Query Metrics
17
Database Queries
10
Different statements
12.39 ms
Query time
3
Invalid entities
Queries
| #▲ | Time | Info | ||||||||||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| 1 | 4.15 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.slug = ? AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL))) LIMIT 1
Parameters:
[
"acrilcl-25-mm-acrilico-colato-cristallo-1692"
]
|
||||||||||||||||||||||||||||||
| 2 | 0.20 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.tra_Descrizione = ? LIMIT 1
Parameters:
[
"LAVORATI SPECIALI PRODOTTI IN METACRILATO"
]
|
||||||||||||||||||||||||||||||
| 3 | 0.15 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:
[
63
]
|
||||||||||||||||||||||||||||||
| 4 | 0.25 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_.CodiceAlternativo = ? AND a0_.Codice NOT LIKE 'D%' AND a0_.Codice LIKE ? AND a0_.val_GestioneWeb = ? AND a0_.val_Obsoleto = ?) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL))
Parameters:
[ "PMMA/25CL3" "PMMA/25CL3%" 1 0 ]
|
||||||||||||||||||||||||||||||
| 5 | 0.21 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.Codice = ? AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL))) LIMIT 1
Parameters:
[
"PMMA/25CL3"
]
|
||||||||||||||||||||||||||||||
| 6 | 0.20 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.Codice = ? AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL))) LIMIT 1
Parameters:
[
"PMMA/25CL3"
]
|
||||||||||||||||||||||||||||||
| 7 | 1.63 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.CodiceAlternativo IS NULL AND t0.Codice = ? AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL))) LIMIT 1
Parameters:
[
"PMMA/25CL3"
]
|
||||||||||||||||||||||||||||||
| 8 | 0.14 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.ref_Articolo AS ref_Articolo_5, t0.ref_Tag AS ref_Tag_6 FROM TagsArticoli t0 WHERE t0.ref_Articolo = ?
Parameters:
[
1692
]
|
||||||||||||||||||||||||||||||
| 9 | 2.26 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
135
]
|
||||||||||||||||||||||||||||||
| 10 | 0.78 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
130
]
|
||||||||||||||||||||||||||||||
| 11 | 0.09 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
136
]
|
||||||||||||||||||||||||||||||
| 12 | 0.09 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
116
]
|
||||||||||||||||||||||||||||||
| 13 | 0.08 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
105
]
|
||||||||||||||||||||||||||||||
| 14 | 0.08 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
111
]
|
||||||||||||||||||||||||||||||
| 15 | 0.08 ms |
SELECT t0.id AS id_1, t0.uuid AS uuid_2, t0.TSCreazione AS TSCreazione_3, t0.TSModifica AS TSModifica_4, t0.Descrizione AS Descrizione_5, t0.ref_TagPadre AS ref_TagPadre_6 FROM Tags t0 WHERE t0.id = ?
Parameters:
[
124
]
|
||||||||||||||||||||||||||||||
| 16 | 0.52 ms |
SELECT t0.id AS id_1, t0.Codice AS Codice_2, t0.tra_Descrizione AS tra_Descrizione_3 FROM UnitaDiMisura t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
2
]
|
||||||||||||||||||||||||||||||
| 17 | 1.46 ms |
SELECT t0.id AS id_1, t0.createdAt AS createdAt_2, t0.updatedAt AS updatedAt_3, t0.closedAt AS closedAt_4, t0.browserDetails AS browserDetails_5, t0.user_id AS user_id_6, t0.order_id AS order_id_7 FROM EcommerceCart t0 WHERE t0.user_id IS NULL AND t0.closedAt IS NULL LIMIT 1
Parameters:
[]
|
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\Articoli |
|
| App\Entity\Categorie | No errors. |
| App\Entity\TipologiaProdotti | No errors. |
| App\Entity\AllegatiArticoli | No errors. |
| App\Entity\TagsArticoli | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\UnitaDiMisura | No errors. |
| App\Entity\EcommerceCart |
|
| App\Entity\User | No errors. |
| App\Entity\Order |
|