Query Metrics
23
Database Queries
8
Different statements
2.33 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info | ||||||||||||||||||||||
|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
|
0.79 ms (33.76%) |
13 |
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_Tag = ?
Parameters:
[
43
]
|
||||||||||||||||||||||
|
0.60 ms (25.86%) |
4 |
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:
[
"G/2383/6/7018"
]
|
||||||||||||||||||||||
|
0.29 ms (12.28%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.link AS link_4, t0.isExternal AS isExternal_5, t0.cta AS cta_6, t0.enabled AS enabled_7, t0.imageName AS imageName_8, t0.mobileImageName AS mobileImageName_9, t0.textColor AS textColor_10, t0.sortablePosition AS sortablePosition_11 FROM HomeSlide t0 WHERE t0.enabled = ? ORDER BY t0.sortablePosition DESC
Parameters:
[
1
]
|
||||||||||||||||||||||
|
0.20 ms (8.80%) |
1 |
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.Codice IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND t0.enabled = ? ORDER BY t0.sortablePosition DESC
Parameters:
[ "01MI" "01MU" "02MS" "03AF" "04LU" "05PE" "06LA" "07LC" "08LM" "09LP" "10BD" "11LV" 1 ]
|
||||||||||||||||||||||
|
0.14 ms (5.81%) |
1 |
SELECT t0.id AS id_1, t0.title AS title_2, t0.imageName AS imageName_3, t0.iconImage AS iconImage_4, t0.enabled AS enabled_5, t0.alternativeTitle AS alternativeTitle_6, t0.sortablePosition AS sortablePosition_7, t0.multilanguage AS multilanguage_8, t0.locale AS locale_9, t0.metaTitle AS metaTitle_10, t0.metaDescription AS metaDescription_11, t0.ogType AS ogType_12, t0.ogTitle AS ogTitle_13, t0.ogDescription AS ogDescription_14, t0.twitterTitle AS twitterTitle_15, t0.twitterDescription AS twitterDescription_16, t0.keywords AS keywords_17, t0.ogImageName AS ogImageName_18, t0.slug AS slug_19, t0.tagId_id AS tagId_id_20 FROM Realization t0 WHERE t0.enabled = ? ORDER BY t0.sortablePosition DESC
Parameters:
[
1
]
|
||||||||||||||||||||||
|
0.13 ms (5.63%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.route AS route_3, t0.createdAt AS createdAt_4, t0.updatedAt AS updatedAt_5, t0.metaTitle AS metaTitle_6, t0.metaDescription AS metaDescription_7, t0.ogType AS ogType_8, t0.ogTitle AS ogTitle_9, t0.ogDescription AS ogDescription_10, t0.twitterTitle AS twitterTitle_11, t0.twitterDescription AS twitterDescription_12, t0.keywords AS keywords_13, t0.ogImageName AS ogImageName_14, t0.multilanguage AS multilanguage_15, t0.locale AS locale_16 FROM StaticPage t0 WHERE t0.route = ? AND t0.locale = ? LIMIT 1
Parameters:
[ "app_homepage" "it" ] |
||||||||||||||||||||||
|
0.11 ms (4.94%) |
1 |
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:
[
13
]
|
||||||||||||||||||||||
|
0.07 ms (2.92%) |
1 |
SELECT t0.id AS id_1, t0.code AS code_2, t0.sortablePosition AS sortablePosition_3 FROM ProductHighlight t0 ORDER BY t0.sortablePosition DESC
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\HomeSlide | No errors. |
| App\Entity\Categorie | No errors. |
| App\Entity\Articoli |
|
| App\Entity\Realization | No errors. |
| App\Entity\Tags | No errors. |
| App\Entity\TagsArticoli | No errors. |
| App\Entity\ProductHighlight | No errors. |
| App\Entity\TipologiaProdotti | No errors. |
| App\Entity\AllegatiArticoli | No errors. |
| App\Entity\StaticPage | No errors. |