GET https://shopdocks.copiaincolla.com/_fragment?_path=_format%3Dhtml%26_locale%3Dit%26_controller%3DApp%255CController%255CCartController%253A%253AcountItems

Response
200 OK
IP
10.90.254.254
Profiled on
Token
6449d1

Query Metrics

31 Database Queries
12 Different statements
3.63 ms Query time
3 Invalid entities

Grouped Statements

Show all queries

Time▼ Count Info
0.85 ms
(23.51%) 		9 
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: 
[
  134
]
View formatted query    View runnable query    Explain query    View query backtrace
0.80 ms
(22.16%) 		11 
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: 
[
  32
]
View formatted query    View runnable query    Explain query    View query backtrace
0.39 ms
(10.73%) 		2 
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/2425/6/7018"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.31 ms
(8.49%) 		1 
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: 
[
  "policomp-3-mm-cristallo-32"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.26 ms
(7.23%) 		1 
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: 
[
  "G/2425/6/7018"
  "G/2425%"
  1
  0
]
View formatted query    View runnable query    Explain query    View query backtrace
0.23 ms
(6.46%) 		1 
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_Tipologia = ?) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL))
Parameters: 
[
  91
]
View formatted query    View runnable query    Explain query    View query backtrace
0.17 ms
(4.77%) 		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: 
[
  57
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(4.55%) 		1 
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: 
[
  "G/2425/6/7018"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.16 ms
(4.38%) 		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.tra_Descrizione = ? LIMIT 1
Parameters: 
[
  "LASTRE COMPATTE"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.12 ms
(3.20%) 		1 
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: 
[
  32
]
View formatted query    View runnable query    Explain query    View query backtrace
0.09 ms
(2.56%) 		1 
SELECT t0_.id AS id_0, t0_.uuid AS uuid_1, t0_.Codice AS Codice_2, t0_.TSCreazione AS TSCreazione_3, t0_.TSModifica AS TSModifica_4, t0_.tra_Descrizione AS tra_Descrizione_5 FROM TipologiaProdotti t0_ WHERE t0_.Codice IN (?)
Parameters: 
[
  "ALA1"
]
View formatted query    View runnable query    Explain query    View query backtrace
0.07 ms
(1.96%) 		1 
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: 
[]
View formatted query    View runnable query    Explain query    View query backtrace

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
  • 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\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
  • If association App\Entity\EcommerceCart#user is many-to-one, then the inversed side App\Entity\User#ecommerceCart has to be one-to-many.
  • The association App\Entity\EcommerceCart#order refers to the inverse side field App\Entity\Order#ecommerceCart which does not exist.
App\Entity\User No errors.
App\Entity\Order
  • The mappings App\Entity\Order#orderRows and App\Entity\OrderRow#order are inconsistent with each other.