Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.id_idioma AS id_idioma_2,
  t0.nom AS nom_3,
  t0.principal AS principal_4,
  t0.visible AS visible_5,
  t0.code_iso AS code_iso_6
FROM
  idioma_gestor t0
WHERE
  t0.visible = ?
ORDER BY
  t0.nom ASC

SELECT t0.id AS id_1, t0.id_idioma AS id_idioma_2, t0.nom AS nom_3, t0.principal AS principal_4, t0.visible AS visible_5, t0.code_iso AS code_iso_6 FROM idioma_gestor t0 WHERE t0.visible = 1 ORDER BY t0.nom ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.codi_pais = ?
  AND t0.sendable = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.codi_pais = 'ES' AND t0.sendable = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.codi_pais = ?
  AND t0.sendable = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.codi_pais = 'ES' AND t0.sendable = 1 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_intern AS nom_intern_3,
  t0.nif AS nif_4,
  t0.adreca AS adreca_5,
  t0.adreca2 AS adreca2_6,
  t0.codi_postal AS codi_postal_7,
  t0.poblacio AS poblacio_8,
  t0.provincia AS provincia_9,
  t0.pais AS pais_10,
  t0.telf_empresa AS telf_empresa_11,
  t0.mail AS mail_12,
  t0.iva AS iva_13,
  t0.nom_impost AS nom_impost_14,
  t0.lletra_factura AS lletra_factura_15,
  t0.lletra_factura_simplificada AS lletra_factura_simplificada_16,
  t0.mail_contacto AS mail_contacto_17,
  t0.dades_factura AS dades_factura_18,
  t0.traspasinici AS traspasinici_19,
  t0.traspasfinal AS traspasfinal_20,
  t0.sii_enviar_factures AS sii_enviar_factures_21,
  t0.sii_codi_pais AS sii_codi_pais_22,
  t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23,
  t0.proveidor AS proveidor_24,
  t0.quin_preu_base_online AS quin_preu_base_online_25,
  t0.mostrar_impost AS mostrar_impost_26,
  t0.traspas AS traspas_27,
  t0.stockhouse_id AS stockhouse_id_28,
  t0.tpv_type_id AS tpv_type_id_29
FROM
  empresa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_intern AS nom_intern_3, t0.nif AS nif_4, t0.adreca AS adreca_5, t0.adreca2 AS adreca2_6, t0.codi_postal AS codi_postal_7, t0.poblacio AS poblacio_8, t0.provincia AS provincia_9, t0.pais AS pais_10, t0.telf_empresa AS telf_empresa_11, t0.mail AS mail_12, t0.iva AS iva_13, t0.nom_impost AS nom_impost_14, t0.lletra_factura AS lletra_factura_15, t0.lletra_factura_simplificada AS lletra_factura_simplificada_16, t0.mail_contacto AS mail_contacto_17, t0.dades_factura AS dades_factura_18, t0.traspasinici AS traspasinici_19, t0.traspasfinal AS traspasfinal_20, t0.sii_enviar_factures AS sii_enviar_factures_21, t0.sii_codi_pais AS sii_codi_pais_22, t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23, t0.proveidor AS proveidor_24, t0.quin_preu_base_online AS quin_preu_base_online_25, t0.mostrar_impost AS mostrar_impost_26, t0.traspas AS traspas_27, t0.stockhouse_id AS stockhouse_id_28, t0.tpv_type_id AS tpv_type_id_29 FROM empresa t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.id = ?
ORDER BY
  t0.id ASC
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.id = 219 ORDER BY t0.id ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.id = '2';

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.text AS text_3,
  t0.des AS des_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.apartat_id AS apartat_id_8,
  t0.language_id AS language_id_9
FROM
  apartats_translation t0
WHERE
  t0.apartat_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.text AS text_3, t0.des AS des_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.apartat_id AS apartat_id_8, t0.language_id AS language_id_9 FROM apartats_translation t0 WHERE t0.apartat_id = 2;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.text AS text_3,
  t0.des AS des_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.apartat_id AS apartat_id_8,
  t0.language_id AS language_id_9
FROM
  apartats_translation t0
WHERE
  t0.apartat_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.text AS text_3, t0.des AS des_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.apartat_id AS apartat_id_8, t0.language_id AS language_id_9 FROM apartats_translation t0 WHERE t0.apartat_id = 1;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.id = 89;

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.text AS text_3,
  t0.des AS des_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.apartat_id AS apartat_id_8,
  t0.language_id AS language_id_9
FROM
  apartats_translation t0
WHERE
  t0.apartat_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.text AS text_3, t0.des AS des_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.apartat_id AS apartat_id_8, t0.language_id AS language_id_9 FROM apartats_translation t0 WHERE t0.apartat_id = 89;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.visiblecolproducte AS visiblecolproducte_5,
  t0.menusdesplegat AS menusdesplegat_6,
  t0.menucapdesplegat AS menucapdesplegat_7,
  t0.numvisites AS numvisites_8,
  t0.indexar AS indexar_9,
  t0.ordre AS ordre_10,
  t0.categorychildren AS categorychildren_11,
  t0.parent_id AS parent_id_12
FROM
  apartats t0
WHERE
  t0.visible = ?
  AND t0.parent_id = ?
ORDER BY
  t0.ordre ASC

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.visiblecolproducte AS visiblecolproducte_5, t0.menusdesplegat AS menusdesplegat_6, t0.menucapdesplegat AS menucapdesplegat_7, t0.numvisites AS numvisites_8, t0.indexar AS indexar_9, t0.ordre AS ordre_10, t0.categorychildren AS categorychildren_11, t0.parent_id AS parent_id_12 FROM apartats t0 WHERE t0.visible = 1 AND t0.parent_id = 2 ORDER BY t0.ordre ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.sendable AS sendable_3,
  t0.preuEnvioGratis AS preuEnvioGratis_4,
  t0.preu_apilable AS preu_apilable_5,
  t0.preu_no_encintable AS preu_no_encintable_6,
  t0.preu_fuera_norma_a AS preu_fuera_norma_a_7,
  t0.textshipment AS textshipment_8,
  t0.textinfoshipment AS textinfoshipment_9,
  t0.displaycetelem AS displaycetelem_10,
  t0.codi_pais AS codi_pais_11,
  t0.grams_max_product AS grams_max_product_12,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_13,
  t0.principal AS principal_14,
  t0.empresa_id AS empresa_id_15,
  t0.idioma_id AS idioma_id_16
FROM
  paisos t0
WHERE
  t0.sendable = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.sendable AS sendable_3, t0.preuEnvioGratis AS preuEnvioGratis_4, t0.preu_apilable AS preu_apilable_5, t0.preu_no_encintable AS preu_no_encintable_6, t0.preu_fuera_norma_a AS preu_fuera_norma_a_7, t0.textshipment AS textshipment_8, t0.textinfoshipment AS textinfoshipment_9, t0.displaycetelem AS displaycetelem_10, t0.codi_pais AS codi_pais_11, t0.grams_max_product AS grams_max_product_12, t0.pot_sortir_dandorra AS pot_sortir_dandorra_13, t0.principal AS principal_14, t0.empresa_id AS empresa_id_15, t0.idioma_id AS idioma_id_16 FROM paisos t0 WHERE t0.sendable = 1;

SELECT
  t0.id AS id_1,
  t0.nom AS nom_2,
  t0.nom_intern AS nom_intern_3,
  t0.nif AS nif_4,
  t0.adreca AS adreca_5,
  t0.adreca2 AS adreca2_6,
  t0.codi_postal AS codi_postal_7,
  t0.poblacio AS poblacio_8,
  t0.provincia AS provincia_9,
  t0.pais AS pais_10,
  t0.telf_empresa AS telf_empresa_11,
  t0.mail AS mail_12,
  t0.iva AS iva_13,
  t0.nom_impost AS nom_impost_14,
  t0.lletra_factura AS lletra_factura_15,
  t0.lletra_factura_simplificada AS lletra_factura_simplificada_16,
  t0.mail_contacto AS mail_contacto_17,
  t0.dades_factura AS dades_factura_18,
  t0.traspasinici AS traspasinici_19,
  t0.traspasfinal AS traspasfinal_20,
  t0.sii_enviar_factures AS sii_enviar_factures_21,
  t0.sii_codi_pais AS sii_codi_pais_22,
  t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23,
  t0.proveidor AS proveidor_24,
  t0.quin_preu_base_online AS quin_preu_base_online_25,
  t0.mostrar_impost AS mostrar_impost_26,
  t0.traspas AS traspas_27,
  t0.stockhouse_id AS stockhouse_id_28,
  t0.tpv_type_id AS tpv_type_id_29
FROM
  empresa t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.nom AS nom_2, t0.nom_intern AS nom_intern_3, t0.nif AS nif_4, t0.adreca AS adreca_5, t0.adreca2 AS adreca2_6, t0.codi_postal AS codi_postal_7, t0.poblacio AS poblacio_8, t0.provincia AS provincia_9, t0.pais AS pais_10, t0.telf_empresa AS telf_empresa_11, t0.mail AS mail_12, t0.iva AS iva_13, t0.nom_impost AS nom_impost_14, t0.lletra_factura AS lletra_factura_15, t0.lletra_factura_simplificada AS lletra_factura_simplificada_16, t0.mail_contacto AS mail_contacto_17, t0.dades_factura AS dades_factura_18, t0.traspasinici AS traspasinici_19, t0.traspasfinal AS traspasfinal_20, t0.sii_enviar_factures AS sii_enviar_factures_21, t0.sii_codi_pais AS sii_codi_pais_22, t0.sii_entregues_exportacions_intracomunitaries AS sii_entregues_exportacions_intracomunitaries_23, t0.proveidor AS proveidor_24, t0.quin_preu_base_online AS quin_preu_base_online_25, t0.mostrar_impost AS mostrar_impost_26, t0.traspas AS traspas_27, t0.stockhouse_id AS stockhouse_id_28, t0.tpv_type_id AS tpv_type_id_29 FROM empresa t0 WHERE t0.id = 2;

SELECT
  p0_.id AS id_0,
  p0_.datacreacio AS datacreacio_1,
  p0_.datamodificacio AS datamodificacio_2,
  p0_.visible AS visible_3,
  p0_.destacat AS destacat_4,
  p0_.premium AS premium_5,
  p0_.indexar AS indexar_6,
  p0_.ordre AS ordre_7,
  p0_.tipus_enllacat AS tipus_enllacat_8,
  p0_.type_stock AS type_stock_9,
  p0_.price_min AS price_min_10,
  p0_.price_max AS price_max_11,
  p1_.id AS id_12,
  p1_.ref AS ref_13,
  p1_.preubase AS preubase_14,
  p1_.preubotiga AS preubotiga_15,
  p1_.preuonline AS preuonline_16,
  p1_.preuonline2 AS preuonline2_17,
  p1_.preuonline3 AS preuonline3_18,
  p1_.oferta AS oferta_19,
  p1_.venda_online AS venda_online_20,
  p1_.preucost AS preucost_21,
  p1_.stock_infinit AS stock_infinit_22,
  p1_.stock_calculat_total AS stock_calculat_total_23,
  p1_.stock_calculat_online AS stock_calculat_online_24,
  p1_.stock_calculat_botiga AS stock_calculat_botiga_25,
  p1_.stock_minim AS stock_minim_26,
  p1_.weight AS weight_27,
  p1_.shipment_weight AS shipment_weight_28,
  p1_.length AS length_29,
  p1_.width AS width_30,
  p1_.height AS height_31,
  p1_.product_noapilable AS product_noapilable_32,
  p1_.product_normaa AS product_normaa_33,
  p1_.product_noencintable AS product_noencintable_34,
  p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35,
  p1_.plasticweight AS plasticweight_36,
  p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37,
  p2_.id AS id_38,
  p2_.titol AS titol_39,
  p2_.visible AS visible_40,
  p2_.datacreacio AS datacreacio_41,
  p2_.datamodificacio AS datamodificacio_42,
  p2_.slug AS slug_43,
  p3_.id AS id_44,
  p0_.marca AS marca_45,
  p0_.familia_id AS familia_id_46,
  p1_.product_id AS product_id_47,
  p3_.product_id AS product_id_48,
  p3_.category_id AS category_id_49
FROM
  productos p0_
  LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  LEFT JOIN productos_marca p2_ ON p0_.marca = p2_.id
  INNER JOIN productos_apartats_ref p3_ ON p0_.id = p3_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p3_.category_id IN (?, ?, ?, ?, ?, ?)
GROUP BY
  p2_.id
ORDER BY
  p2_.titol ASC,
  p1_.preubotiga ASC

SELECT p0_.id AS id_0, p0_.datacreacio AS datacreacio_1, p0_.datamodificacio AS datamodificacio_2, p0_.visible AS visible_3, p0_.destacat AS destacat_4, p0_.premium AS premium_5, p0_.indexar AS indexar_6, p0_.ordre AS ordre_7, p0_.tipus_enllacat AS tipus_enllacat_8, p0_.type_stock AS type_stock_9, p0_.price_min AS price_min_10, p0_.price_max AS price_max_11, p1_.id AS id_12, p1_.ref AS ref_13, p1_.preubase AS preubase_14, p1_.preubotiga AS preubotiga_15, p1_.preuonline AS preuonline_16, p1_.preuonline2 AS preuonline2_17, p1_.preuonline3 AS preuonline3_18, p1_.oferta AS oferta_19, p1_.venda_online AS venda_online_20, p1_.preucost AS preucost_21, p1_.stock_infinit AS stock_infinit_22, p1_.stock_calculat_total AS stock_calculat_total_23, p1_.stock_calculat_online AS stock_calculat_online_24, p1_.stock_calculat_botiga AS stock_calculat_botiga_25, p1_.stock_minim AS stock_minim_26, p1_.weight AS weight_27, p1_.shipment_weight AS shipment_weight_28, p1_.length AS length_29, p1_.width AS width_30, p1_.height AS height_31, p1_.product_noapilable AS product_noapilable_32, p1_.product_normaa AS product_normaa_33, p1_.product_noencintable AS product_noencintable_34, p1_.exclosenviamentgratuit AS exclosenviamentgratuit_35, p1_.plasticweight AS plasticweight_36, p1_.pot_sortir_dandorra AS pot_sortir_dandorra_37, p2_.id AS id_38, p2_.titol AS titol_39, p2_.visible AS visible_40, p2_.datacreacio AS datacreacio_41, p2_.datamodificacio AS datamodificacio_42, p2_.slug AS slug_43, p3_.id AS id_44, p0_.marca AS marca_45, p0_.familia_id AS familia_id_46, p1_.product_id AS product_id_47, p3_.product_id AS product_id_48, p3_.category_id AS category_id_49 FROM productos p0_ LEFT JOIN productos_preu p1_ ON p0_.id = p1_.product_id LEFT JOIN productos_marca p2_ ON p0_.marca = p2_.id INNER JOIN productos_apartats_ref p3_ ON p0_.id = p3_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p3_.category_id IN ('17', '72', '75', '76', '77', 2) GROUP BY p2_.id ORDER BY p2_.titol ASC, p1_.preubotiga ASC;

SELECT
  COUNT(DISTINCT p0_.id) AS sclr_0
FROM
  productos p0_
  INNER JOIN productos_preu p1_ ON p0_.id = p1_.product_id
  INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id
WHERE
  p0_.visible = 1
  AND p1_.venda_online <> 2
  AND p2_.category_id IN (?, ?, ?, ?, ?, ?)

SELECT COUNT(DISTINCT p0_.id) AS sclr_0 FROM productos p0_ INNER JOIN productos_preu p1_ ON p0_.id = p1_.product_id INNER JOIN productos_apartats_ref p2_ ON p0_.id = p2_.product_id WHERE p0_.visible = 1 AND p1_.venda_online <> 2 AND p2_.category_id IN ('17', '72', '75', '76', '77', 2);