Symfony Profiler

[
  "route" => "robots_txt"
  "route_parameters" => [
    "_route" => "robots_txt"
    "_controller" => "App\Controller\Publica\RobotsTxtController::robotsTxt"
  ]
  "request_uri" => "http://www.districlaror.com/robots.txt"
  "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.sendable = ? ORDER BY t0.principal DESC LIMIT 1"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => 5
  ]
]

[
  "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.meta_robots IN (?, ?, ?, ?, ?, ?, ?, ?, ?)"
  "params" => [
    1 => 1
    2 => "noindex, nofollow"
    3 => "noindex"
    4 => "nofollow"
    5 => "none"
    6 => "noindex, none"
    7 => "nofollow, none"
    8 => "none, noindex "
    9 => "none, nofollow"
    10 => "noindex, nofollow, none"
  ]
  "types" => [
    1 => 5
    2 => 2
    3 => 2
    4 => 2
    5 => 2
    6 => 2
    7 => 2
    8 => 2
    9 => 2
    10 => 2
  ]
]

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

[
  "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
  ]
]