Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.less_than_grams AS less_than_grams_1,
  p0_.price AS price_2,
  p0_.price_per_kg AS price_per_kg_3,
  p0_.paisos_id AS paisos_id_4
FROM
  paisos_shipment p0_
WHERE
  p0_.paisos_id = ?
  AND p0_.less_than_grams >= ?
ORDER BY
  p0_.less_than_grams ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.less_than_grams AS less_than_grams_1, p0_.price AS price_2, p0_.price_per_kg AS price_per_kg_3, p0_.paisos_id AS paisos_id_4 FROM paisos_shipment p0_ WHERE p0_.paisos_id = 219 AND p0_.less_than_grams >= 0 ORDER BY p0_.less_than_grams ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.debug AS debug_3,
  t0.merchantcode AS merchantcode_4,
  t0.terminal AS terminal_5,
  t0.secretkey AS secretkey_6,
  t0.type AS type_7
FROM
  payment_methods t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.title AS title_2, t0.debug AS debug_3, t0.merchantcode AS merchantcode_4, t0.terminal AS terminal_5, t0.secretkey AS secretkey_6, t0.type AS type_7 FROM payment_methods t0 WHERE t0.id = 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.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 = ?
ORDER BY
  t0.principal DESC
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.sendable = 1 ORDER BY t0.principal DESC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.datapublicacio AS datapublicacio_4,
  t0.datadespublicacio AS datadespublicacio_5,
  t0.visible AS visible_6
FROM
  destacat t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.datapublicacio AS datapublicacio_4, t0.datadespublicacio AS datadespublicacio_5, t0.visible AS visible_6 FROM destacat t0 WHERE t0.id = 1;

SELECT
  t0.id AS id_1,
  t0.datacreacio AS datacreacio_2,
  t0.datamodificacio AS datamodificacio_3,
  t0.visible AS visible_4,
  t0.ordre AS ordre_5,
  t0.destacat AS destacat_6,
  t0.tipus_pagina AS tipus_pagina_7,
  t0.parent_id AS parent_id_8,
  t0.replaced_with_id AS replaced_with_id_9
FROM
  pagines t0
WHERE
  t0.visible = ?
  AND t0.tipus_pagina = ?

SELECT t0.id AS id_1, t0.datacreacio AS datacreacio_2, t0.datamodificacio AS datamodificacio_3, t0.visible AS visible_4, t0.ordre AS ordre_5, t0.destacat AS destacat_6, t0.tipus_pagina AS tipus_pagina_7, t0.parent_id AS parent_id_8, t0.replaced_with_id AS replaced_with_id_9 FROM pagines t0 WHERE t0.visible = 1 AND t0.tipus_pagina = 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.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.created AS created_2,
  t0.updated AS updated_3,
  t0.active AS active_4,
  t0.internal AS internal_5,
  t0.meta_robots AS meta_robots_6,
  t0.show_breadcrumbs AS show_breadcrumbs_7,
  t0.show_h1_title AS show_h1_title_8,
  t0.homepage AS homepage_9,
  t0.special_type AS special_type_10
FROM
  page t0
WHERE
  t0.active = ?
  AND t0.special_type = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.active AS active_4, t0.internal AS internal_5, t0.meta_robots AS meta_robots_6, t0.show_breadcrumbs AS show_breadcrumbs_7, t0.show_h1_title AS show_h1_title_8, t0.homepage AS homepage_9, t0.special_type AS special_type_10 FROM page t0 WHERE t0.active = 1 AND t0.special_type = 'cookies' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.created AS created_2,
  t0.updated AS updated_3,
  t0.title AS title_4,
  t0.slug AS slug_5,
  t0.meta_keywords AS meta_keywords_6,
  t0.meta_description AS meta_description_7,
  t0.page_id AS page_id_8,
  t0.language_id AS language_id_9
FROM
  page_translation t0
WHERE
  t0.page_id = ?
ORDER BY
  t0.language_id ASC

SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.title AS title_4, t0.slug AS slug_5, t0.meta_keywords AS meta_keywords_6, t0.meta_description AS meta_description_7, t0.page_id AS page_id_8, t0.language_id AS language_id_9 FROM page_translation t0 WHERE t0.page_id = 5 ORDER BY t0.language_id ASC;

SELECT
  p0_.id AS id_0,
  p0_.less_than_grams AS less_than_grams_1,
  p0_.price AS price_2,
  p0_.price_per_kg AS price_per_kg_3,
  p0_.paisos_id AS paisos_id_4
FROM
  paisos_shipment p0_
WHERE
  p0_.paisos_id = ?
  AND p0_.price_per_kg = 0
ORDER BY
  p0_.less_than_grams DESC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.less_than_grams AS less_than_grams_1, p0_.price AS price_2, p0_.price_per_kg AS price_per_kg_3, p0_.paisos_id AS paisos_id_4 FROM paisos_shipment p0_ WHERE p0_.paisos_id = 219 AND p0_.price_per_kg = 0 ORDER BY p0_.less_than_grams DESC LIMIT 1;

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.principal DESC,
  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.principal DESC, t0.nom ASC;