Query Metrics

6 Database Queries
6 Different statements
1.57 ms Query time
1 Invalid entities

Queries

Group similar statements

# Time Info
1 0.27 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.Codice AS Codice_3, t0.TSCreazione AS TSCreazione_4, t0.TSModifica AS TSModifica_5, t0.tra_Descrizione AS tra_Descrizione_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.alternativeTitle AS alternativeTitle_9, t0.description AS description_10, t0.productListDescription AS productListDescription_11, t0.productDescription AS productDescription_12, t0.sortablePosition AS sortablePosition_13, t0.multilanguage AS multilanguage_14, t0.locale AS locale_15, t0.metaTitle AS metaTitle_16, t0.metaDescription AS metaDescription_17, t0.ogType AS ogType_18, t0.ogTitle AS ogTitle_19, t0.ogDescription AS ogDescription_20, t0.twitterTitle AS twitterTitle_21, t0.twitterDescription AS twitterDescription_22, t0.keywords AS keywords_23, t0.ogImageName AS ogImageName_24, t0.slug AS slug_25, t0.ref_GruppoCategorie AS ref_GruppoCategorie_26 FROM Categorie t0 WHERE t0.slug = ? LIMIT 1
Parameters:
[
  "pannelli-in-alluminio-39"
]
2 0.71 ms
SELECT a0_.id AS id_0, a0_.PrezzoCatalogo AS PrezzoCatalogo_1, a0_.PrezzoVendita AS PrezzoVendita_2, a0_.PrezzoIVAInclusa AS PrezzoIVAInclusa_3, a0_.QtaMinimaAcquisto AS QtaMinimaAcquisto_4, a0_.QtaMinimaVendita AS QtaMinimaVendita_5, a0_.Altezza AS Altezza_6, a0_.Larghezza AS Larghezza_7, a0_.Profondita AS Profondita_8, a0_.QtaInConfezione AS QtaInConfezione_9, a0_.Peso AS Peso_10, a0_.uuid AS uuid_11, a0_.ref_Azienda AS ref_Azienda_12, a0_.tra_DescrizioneEstesa AS tra_DescrizioneEstesa_13, a0_.TSCreazione AS TSCreazione_14, a0_.TSModifica AS TSModifica_15, a0_.Codice AS Codice_16, a0_.tra_Descrizione AS tra_Descrizione_17, a0_.BarCode AS BarCode_18, a0_.Note AS Note_19, a0_.URI_Immagine AS URI_Immagine_20, a0_.NomeAllegato AS NomeAllegato_21, a0_.CodiceAlternativo AS CodiceAlternativo_22, a0_.RifAggiuntivo1 AS RifAggiuntivo1_23, a0_.RifAggiuntivo2 AS RifAggiuntivo2_24, a0_.RifAggiuntivo3 AS RifAggiuntivo3_25, a0_.RifAggiuntivo4 AS RifAggiuntivo4_26, a0_.RifAggiuntivo5 AS RifAggiuntivo5_27, a0_.RifAggiuntivo6 AS RifAggiuntivo6_28, a0_.RifAggiuntivo7 AS RifAggiuntivo7_29, a0_.RifAggiuntivo8 AS RifAggiuntivo8_30, a0_.RifAggiuntivo9 AS RifAggiuntivo9_31, a0_.val_GestioneWeb AS val_GestioneWeb_32, a0_.ref_UnitaMisura AS ref_UnitaMisura_33, a0_.val_Obsoleto AS val_Obsoleto_34, a0_.imageUpdatedAt AS imageUpdatedAt_35, a0_.ref_AliquotaIVA AS ref_AliquotaIVA_36, a0_.ref_ContropartitaVendita AS ref_ContropartitaVendita_37, a0_.metaTitle AS metaTitle_38, a0_.metaDescription AS metaDescription_39, a0_.ogType AS ogType_40, a0_.ogTitle AS ogTitle_41, a0_.ogDescription AS ogDescription_42, a0_.twitterTitle AS twitterTitle_43, a0_.twitterDescription AS twitterDescription_44, a0_.keywords AS keywords_45, a0_.ogImageName AS ogImageName_46, a0_.multilanguage AS multilanguage_47, a0_.locale AS locale_48, a0_.slug AS slug_49, a0_.ref_CategoriaMerceologica AS ref_CategoriaMerceologica_50, a0_.ref_Tipologia AS ref_Tipologia_51 FROM Articoli a0_ WHERE (a0_.ref_CategoriaMerceologica = ? AND a0_.CodiceAlternativo IS NULL AND a0_.Codice NOT LIKE 'D%' AND a0_.tra_Descrizione IS NOT NULL AND a0_.val_GestioneWeb = ? AND a0_.val_Obsoleto = ?) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL))
Parameters:
[
  39
  1
  0
]
3 0.19 ms
SELECT t0.id AS id_1, t0.PrezzoCatalogo AS PrezzoCatalogo_2, t0.PrezzoVendita AS PrezzoVendita_3, t0.PrezzoIVAInclusa AS PrezzoIVAInclusa_4, t0.QtaMinimaAcquisto AS QtaMinimaAcquisto_5, t0.QtaMinimaVendita AS QtaMinimaVendita_6, t0.Altezza AS Altezza_7, t0.Larghezza AS Larghezza_8, t0.Profondita AS Profondita_9, t0.QtaInConfezione AS QtaInConfezione_10, t0.Peso AS Peso_11, t0.uuid AS uuid_12, t0.ref_Azienda AS ref_Azienda_13, t0.tra_DescrizioneEstesa AS tra_DescrizioneEstesa_14, t0.TSCreazione AS TSCreazione_15, t0.TSModifica AS TSModifica_16, t0.Codice AS Codice_17, t0.tra_Descrizione AS tra_Descrizione_18, t0.BarCode AS BarCode_19, t0.Note AS Note_20, t0.URI_Immagine AS URI_Immagine_21, t0.NomeAllegato AS NomeAllegato_22, t0.CodiceAlternativo AS CodiceAlternativo_23, t0.RifAggiuntivo1 AS RifAggiuntivo1_24, t0.RifAggiuntivo2 AS RifAggiuntivo2_25, t0.RifAggiuntivo3 AS RifAggiuntivo3_26, t0.RifAggiuntivo4 AS RifAggiuntivo4_27, t0.RifAggiuntivo5 AS RifAggiuntivo5_28, t0.RifAggiuntivo6 AS RifAggiuntivo6_29, t0.RifAggiuntivo7 AS RifAggiuntivo7_30, t0.RifAggiuntivo8 AS RifAggiuntivo8_31, t0.RifAggiuntivo9 AS RifAggiuntivo9_32, t0.val_GestioneWeb AS val_GestioneWeb_33, t0.ref_UnitaMisura AS ref_UnitaMisura_34, t0.val_Obsoleto AS val_Obsoleto_35, t0.imageUpdatedAt AS imageUpdatedAt_36, t0.ref_AliquotaIVA AS ref_AliquotaIVA_37, t0.ref_ContropartitaVendita AS ref_ContropartitaVendita_38, t0.metaTitle AS metaTitle_39, t0.metaDescription AS metaDescription_40, t0.ogType AS ogType_41, t0.ogTitle AS ogTitle_42, t0.ogDescription AS ogDescription_43, t0.twitterTitle AS twitterTitle_44, t0.twitterDescription AS twitterDescription_45, t0.keywords AS keywords_46, t0.ogImageName AS ogImageName_47, t0.multilanguage AS multilanguage_48, t0.locale AS locale_49, t0.slug AS slug_50, t0.ref_CategoriaMerceologica AS ref_CategoriaMerceologica_51, t0.ref_Tipologia AS ref_Tipologia_52 FROM Articoli t0 WHERE t0.ref_CategoriaMerceologica = ? AND t0.val_GestioneWeb = ? AND t0.val_Obsoleto = ? AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL)))
Parameters:
[
  39
  1
  0
]
4 0.18 ms
SELECT a0_.id AS id_0, a0_.PrezzoCatalogo AS PrezzoCatalogo_1, a0_.PrezzoVendita AS PrezzoVendita_2, a0_.PrezzoIVAInclusa AS PrezzoIVAInclusa_3, a0_.QtaMinimaAcquisto AS QtaMinimaAcquisto_4, a0_.QtaMinimaVendita AS QtaMinimaVendita_5, a0_.Altezza AS Altezza_6, a0_.Larghezza AS Larghezza_7, a0_.Profondita AS Profondita_8, a0_.QtaInConfezione AS QtaInConfezione_9, a0_.Peso AS Peso_10, a0_.uuid AS uuid_11, a0_.ref_Azienda AS ref_Azienda_12, a0_.tra_DescrizioneEstesa AS tra_DescrizioneEstesa_13, a0_.TSCreazione AS TSCreazione_14, a0_.TSModifica AS TSModifica_15, a0_.Codice AS Codice_16, a0_.tra_Descrizione AS tra_Descrizione_17, a0_.BarCode AS BarCode_18, a0_.Note AS Note_19, a0_.URI_Immagine AS URI_Immagine_20, a0_.NomeAllegato AS NomeAllegato_21, a0_.CodiceAlternativo AS CodiceAlternativo_22, a0_.RifAggiuntivo1 AS RifAggiuntivo1_23, a0_.RifAggiuntivo2 AS RifAggiuntivo2_24, a0_.RifAggiuntivo3 AS RifAggiuntivo3_25, a0_.RifAggiuntivo4 AS RifAggiuntivo4_26, a0_.RifAggiuntivo5 AS RifAggiuntivo5_27, a0_.RifAggiuntivo6 AS RifAggiuntivo6_28, a0_.RifAggiuntivo7 AS RifAggiuntivo7_29, a0_.RifAggiuntivo8 AS RifAggiuntivo8_30, a0_.RifAggiuntivo9 AS RifAggiuntivo9_31, a0_.val_GestioneWeb AS val_GestioneWeb_32, a0_.ref_UnitaMisura AS ref_UnitaMisura_33, a0_.val_Obsoleto AS val_Obsoleto_34, a0_.imageUpdatedAt AS imageUpdatedAt_35, a0_.ref_AliquotaIVA AS ref_AliquotaIVA_36, a0_.ref_ContropartitaVendita AS ref_ContropartitaVendita_37, a0_.metaTitle AS metaTitle_38, a0_.metaDescription AS metaDescription_39, a0_.ogType AS ogType_40, a0_.ogTitle AS ogTitle_41, a0_.ogDescription AS ogDescription_42, a0_.twitterTitle AS twitterTitle_43, a0_.twitterDescription AS twitterDescription_44, a0_.keywords AS keywords_45, a0_.ogImageName AS ogImageName_46, a0_.multilanguage AS multilanguage_47, a0_.locale AS locale_48, a0_.slug AS slug_49, a0_.ref_CategoriaMerceologica AS ref_CategoriaMerceologica_50, a0_.ref_Tipologia AS ref_Tipologia_51 FROM Articoli a0_ WHERE (a0_.ref_CategoriaMerceologica = ? AND a0_.CodiceAlternativo IS NULL AND a0_.Codice NOT LIKE 'D%' AND a0_.tra_Descrizione IS NOT NULL AND a0_.val_GestioneWeb = ? AND a0_.val_Obsoleto = ?) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL)) LIMIT 40
Parameters:
[
  39
  1
  0
]
5 0.12 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.Codice AS Codice_3, t0.TSCreazione AS TSCreazione_4, t0.TSModifica AS TSModifica_5, t0.tra_Descrizione AS tra_Descrizione_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.alternativeTitle AS alternativeTitle_9, t0.description AS description_10, t0.productListDescription AS productListDescription_11, t0.productDescription AS productDescription_12, t0.sortablePosition AS sortablePosition_13, t0.multilanguage AS multilanguage_14, t0.locale AS locale_15, t0.metaTitle AS metaTitle_16, t0.metaDescription AS metaDescription_17, t0.ogType AS ogType_18, t0.ogTitle AS ogTitle_19, t0.ogDescription AS ogDescription_20, t0.twitterTitle AS twitterTitle_21, t0.twitterDescription AS twitterDescription_22, t0.keywords AS keywords_23, t0.ogImageName AS ogImageName_24, t0.slug AS slug_25, t0.ref_GruppoCategorie AS ref_GruppoCategorie_26 FROM Categorie t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  39
]
6 0.10 ms
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.Codice AS Codice_3, t0.TSCreazione AS TSCreazione_4, t0.TSModifica AS TSModifica_5, t0.tra_Descrizione AS tra_Descrizione_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.alternativeTitle AS alternativeTitle_9, t0.description AS description_10, t0.productListDescription AS productListDescription_11, t0.productDescription AS productDescription_12, t0.sortablePosition AS sortablePosition_13, t0.multilanguage AS multilanguage_14, t0.locale AS locale_15, t0.metaTitle AS metaTitle_16, t0.metaDescription AS metaDescription_17, t0.ogType AS ogType_18, t0.ogTitle AS ogTitle_19, t0.ogDescription AS ogDescription_20, t0.twitterTitle AS twitterTitle_21, t0.twitterDescription AS twitterDescription_22, t0.keywords AS keywords_23, t0.ogImageName AS ogImageName_24, t0.slug AS slug_25, t0.ref_GruppoCategorie AS ref_GruppoCategorie_26 FROM Categorie t0 WHERE t0.id = ?
Parameters:
[
  64
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class Mapping errors
App\Entity\Categorie No errors.
App\Entity\Articoli
  • The field 'App\Entity\Articoli#PrezzoCatalogo' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Articoli#PrezzoVendita' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Articoli#PrezzoIVAInclusa' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
  • The field 'App\Entity\Articoli#Profondita' has the property type 'string' that differs from the metadata field type 'float' returned by the 'float' DBAL type.
App\Entity\TipologiaProdotti No errors.