Symfony Profiler

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

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 = 'lastre-compatte-14' LIMIT 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_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
    )
  )

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 = 14 AND a0_.CodiceAlternativo IS NULL AND a0_.Codice NOT LIKE 'D%' AND a0_.tra_Descrizione IS NOT NULL AND a0_.val_GestioneWeb = 1 AND a0_.val_Obsoleto = 0) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL));

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
      )
    )
  )

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 = 14 AND t0.val_GestioneWeb = 1 AND t0.val_Obsoleto = 0 AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL)));

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

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 = 14 AND a0_.CodiceAlternativo IS NULL AND a0_.Codice NOT LIKE 'D%' AND a0_.tra_Descrizione IS NOT NULL AND a0_.val_GestioneWeb = 1 AND a0_.val_Obsoleto = 0) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL)) LIMIT 40;

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
    )
  )

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 = 'G/2420/6/7018' AND a0_.Codice NOT LIKE 'D%' AND a0_.Codice LIKE '%' AND a0_.val_GestioneWeb = 1 AND a0_.val_Obsoleto = 0) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL));

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

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 = 'G/2420/6/7018' AND (((t0.val_Obsoleto = 0 OR t0.val_Obsoleto IS NULL))) LIMIT 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
    )
  )

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 = 'G/2510/6/7018N' AND a0_.Codice NOT LIKE 'D%' AND a0_.Codice LIKE '%' AND a0_.val_GestioneWeb = 1 AND a0_.val_Obsoleto = 0) AND ((a0_.val_Obsoleto = 0 OR a0_.val_Obsoleto IS NULL));