Symfony Profiler

[
  "route" => "comanda_home"
  "route_parameters" => [
    "_route" => "comanda_home"
    "_controller" => "App\Controller\Publica\ShoppingCartController::comanda_home"
    "_locale" => "es"
  ]
  "request_uri" => "http://www.districlaror.com/es/pedido.html?change_state=ES"
  "method" => "GET"
]

[
  "firewall_name" => "shop"
  "authenticators" => 1
]

[
  "firewall_name" => "shop"
  "authenticator" => "App\Security\ShopLoginAuthenticator"
]

[
  "firewall_name" => "shop"
  "authenticator" => "App\Security\ShopLoginAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "192.168.1.248"
    "port" => 3306
    "user" => "districlaror_web"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => [
      "collation" => "utf8mb4_unicode_ci"
    ]
    "dbname" => "districlaror"
    "serverVersion" => "11.4.3-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ES"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => "ES"
    2 => 1
  ]
  "types" => [
    1 => 2
    2 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 219
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => 5
    2 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 219
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 219
    2 => 0
  ]
  "types" => [
    1 => 1
    2 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 219
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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 = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "frontend.menu_footer_es"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.titol AS titol_3, m0_.tipus AS tipus_4, m0_.estat AS estat_5, m0_.nivell AS nivell_6 FROM menu_posicio m0_ WHERE m0_.tipus = ? LIMIT 1"
  "params" => [
    1 => "footer"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.origin AS origin_3, m0_.origin_id AS origin_id_4, m0_.estat AS estat_5, m0_.ordre AS ordre_6, m0_.editable AS editable_7, m0_.link AS link_8, m0_.nova_pagina AS nova_pagina_9, m0_.name_route AS name_route_10, m0_.param_route AS param_route_11, m0_.pare_id AS pare_id_12, m0_.posicio_id AS posicio_id_13 FROM menu m0_ WHERE m0_.pare_id IS NULL AND m0_.posicio_id = ? AND m0_.estat = 1 ORDER BY m0_.ordre ASC"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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.id = ? LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 16
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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.id = ? LIMIT 1"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => 1
  ]
]

[
  "key" => "frontend.menu_legal_es"
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.titol AS titol_3, m0_.tipus AS tipus_4, m0_.estat AS estat_5, m0_.nivell AS nivell_6 FROM menu_posicio m0_ WHERE m0_.tipus = ? LIMIT 1"
  "params" => [
    1 => "legal"
  ]
  "types" => [
    1 => 2
  ]
]

[
  "sql" => "SELECT m0_.id AS id_0, m0_.created AS created_1, m0_.updated AS updated_2, m0_.origin AS origin_3, m0_.origin_id AS origin_id_4, m0_.estat AS estat_5, m0_.ordre AS ordre_6, m0_.editable AS editable_7, m0_.link AS link_8, m0_.nova_pagina AS nova_pagina_9, m0_.name_route AS name_route_10, m0_.param_route AS param_route_11, m0_.pare_id AS pare_id_12, m0_.posicio_id AS posicio_id_13 FROM menu m0_ WHERE m0_.pare_id IS NULL AND m0_.posicio_id = ? AND m0_.estat = 1 ORDER BY m0_.ordre ASC"
  "params" => [
    1 => 2
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 14
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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.id = ? LIMIT 1"
  "params" => [
    1 => 5
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.created AS created_2, t0.updated AS updated_3, t0.titol AS titol_4, t0.menu_id AS menu_id_5, t0.language_id AS language_id_6 FROM menu_translation t0 WHERE t0.menu_id = ?"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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.id = ? LIMIT 1"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => 1
  ]
]

[
  "sql" => "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"
  "params" => [
    1 => 1
    2 => "cookies"
  ]
  "types" => [
    1 => 5
    2 => 2
  ]
]