Symfony Profiler

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 = '77';

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.destacat AS destacat_5,
  t0.premium AS premium_6,
  t0.indexar AS indexar_7,
  t0.ordre AS ordre_8,
  t0.tipus_enllacat AS tipus_enllacat_9,
  t0.type_stock AS type_stock_10,
  t0.price_min AS price_min_11,
  t0.price_max AS price_max_12,
  t0.marca AS marca_13,
  t0.familia_id AS familia_id_14
FROM
  productos 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.destacat AS destacat_5, t0.premium AS premium_6, t0.indexar AS indexar_7, t0.ordre AS ordre_8, t0.tipus_enllacat AS tipus_enllacat_9, t0.type_stock AS type_stock_10, t0.price_min AS price_min_11, t0.price_max AS price_max_12, t0.marca AS marca_13, t0.familia_id AS familia_id_14 FROM productos t0 WHERE t0.id = '536';

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.category_id AS category_id_3
FROM
  productos_apartats_ref t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3 FROM productos_apartats_ref t0 WHERE t0.product_id = 536;

SELECT
  t0.id AS id_1,
  t0.titol AS titol_2,
  t0.des AS des_3,
  t0.text AS text_4,
  t0.info AS info_5,
  t0.titol_am AS titol_am_6,
  t0.keywords AS keywords_7,
  t0.product_id AS product_id_8,
  t0.language_id AS language_id_9
FROM
  productos_translation t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.titol AS titol_2, t0.des AS des_3, t0.text AS text_4, t0.info AS info_5, t0.titol_am AS titol_am_6, t0.keywords AS keywords_7, t0.product_id AS product_id_8, t0.language_id AS language_id_9 FROM productos_translation t0 WHERE t0.product_id = 536;

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.id = ?

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.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 = 77;

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.ref AS ref_2,
  t0.preubase AS preubase_3,
  t0.preubotiga AS preubotiga_4,
  t0.preuonline AS preuonline_5,
  t0.preuonline2 AS preuonline2_6,
  t0.preuonline3 AS preuonline3_7,
  t0.oferta AS oferta_8,
  t0.venda_online AS venda_online_9,
  t0.preucost AS preucost_10,
  t0.stock_infinit AS stock_infinit_11,
  t0.stock_calculat_total AS stock_calculat_total_12,
  t0.stock_calculat_online AS stock_calculat_online_13,
  t0.stock_calculat_botiga AS stock_calculat_botiga_14,
  t0.stock_minim AS stock_minim_15,
  t0.weight AS weight_16,
  t0.shipment_weight AS shipment_weight_17,
  t0.length AS length_18,
  t0.width AS width_19,
  t0.height AS height_20,
  t0.product_noapilable AS product_noapilable_21,
  t0.product_normaa AS product_normaa_22,
  t0.product_noencintable AS product_noencintable_23,
  t0.exclosenviamentgratuit AS exclosenviamentgratuit_24,
  t0.plasticweight AS plasticweight_25,
  t0.pot_sortir_dandorra AS pot_sortir_dandorra_26,
  t0.product_id AS product_id_27
FROM
  productos_preu t0
WHERE
  t0.product_id = ?
ORDER BY
  t0.preubotiga ASC

SELECT t0.id AS id_1, t0.ref AS ref_2, t0.preubase AS preubase_3, t0.preubotiga AS preubotiga_4, t0.preuonline AS preuonline_5, t0.preuonline2 AS preuonline2_6, t0.preuonline3 AS preuonline3_7, t0.oferta AS oferta_8, t0.venda_online AS venda_online_9, t0.preucost AS preucost_10, t0.stock_infinit AS stock_infinit_11, t0.stock_calculat_total AS stock_calculat_total_12, t0.stock_calculat_online AS stock_calculat_online_13, t0.stock_calculat_botiga AS stock_calculat_botiga_14, t0.stock_minim AS stock_minim_15, t0.weight AS weight_16, t0.shipment_weight AS shipment_weight_17, t0.length AS length_18, t0.width AS width_19, t0.height AS height_20, t0.product_noapilable AS product_noapilable_21, t0.product_normaa AS product_normaa_22, t0.product_noencintable AS product_noencintable_23, t0.exclosenviamentgratuit AS exclosenviamentgratuit_24, t0.plasticweight AS plasticweight_25, t0.pot_sortir_dandorra AS pot_sortir_dandorra_26, t0.product_id AS product_id_27 FROM productos_preu t0 WHERE t0.product_id = 536 ORDER BY t0.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,
  p0_.marca AS marca_12,
  p0_.familia_id AS familia_id_13
FROM
  productos p0_
  INNER JOIN productos_apartats_ref p1_ ON p0_.id = p1_.product_id
WHERE
  p0_.visible = 1
  AND p1_.category_id = ?
  AND p1_.product_id <> ?
ORDER BY
  p0_.destacat ASC,
  p0_.premium ASC
LIMIT
  3

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, p0_.marca AS marca_12, p0_.familia_id AS familia_id_13 FROM productos p0_ INNER JOIN productos_apartats_ref p1_ ON p0_.id = p1_.product_id WHERE p0_.visible = 1 AND p1_.category_id = 77 AND p1_.product_id <> 536 ORDER BY p0_.destacat ASC, p0_.premium ASC LIMIT 3;

SELECT
  t0.id AS id_1,
  t0.product_id AS product_id_2,
  t0.category_id AS category_id_3
FROM
  productos_apartats_ref t0
WHERE
  t0.product_id = ?

SELECT t0.id AS id_1, t0.product_id AS product_id_2, t0.category_id AS category_id_3 FROM productos_apartats_ref t0 WHERE t0.product_id = 304;