Symfony Profiler

[
  "route" => "front_legal_page"
  "route_parameters" => [
    "_route" => "front_legal_page"
    "_controller" => "App\Front\Controller\LegalController::show"
    "slug" => "politique-confidentialite"
  ]
  "request_uri" => "https://carrier.alpium.com/informations/politique-confidentialite"
  "method" => "GET"
]

[
  "firewall_name" => "main"
  "authenticators" => 3
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "firewall_name" => "main"
  "authenticator" => "Symfony\Component\Security\Http\Authenticator\Debug\TraceableAuthenticator"
]

[
  "params" => [
    "driver" => "pdo_mysql"
    "idle_connection_ttl" => 600
    "host" => "pb16jo.myd.infomaniak.com"
    "port" => 3306
    "user" => "pb16jo_carrier"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "pb16jo_carrier"
    "serverVersion" => "10.11.15-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.published AS published_5, t0.in_footer AS in_footer_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM legal_pages t0 WHERE t0.slug = ? AND t0.published = ? LIMIT 1"
  "params" => [
    1 => "politique-confidentialite"
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#990
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#977
      +name: "BOOLEAN"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.legal_name AS legal_name_4, t0.commercial_name AS commercial_name_5, t0.siret AS siret_6, t0.vat_number AS vat_number_7, t0.hektor_id AS hektor_id_8, t0.address AS address_9, t0.postal_code AS postal_code_10, t0.city AS city_11, t0.country AS country_12, t0.phone AS phone_13, t0.email AS email_14, t0.website_url AS website_url_15, t0.logo_url AS logo_url_16, t0.primary_color AS primary_color_17, t0.secondary_color AS secondary_color_18, t0.google_business_url AS google_business_url_19, t0.google_review_url AS google_review_url_20, t0.linkedin_url AS linkedin_url_21, t0.facebook_url AS facebook_url_22, t0.instagram_url AS instagram_url_23, t0.youtube_url AS youtube_url_24, t0.latitude AS latitude_25, t0.longitude AS longitude_26, t0.status AS status_27, t0.seo_title AS seo_title_28, t0.seo_meta_description AS seo_meta_description_29, t0.seo_h1 AS seo_h1_30, t0.seo_content AS seo_content_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.deleted_at AS deleted_at_34 FROM agencies t0 WHERE t0.status = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC"
  "params" => [
    1 => "active"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#990
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.content AS content_4, t0.published AS published_5, t0.in_footer AS in_footer_6, t0.position AS position_7, t0.created_at AS created_at_8, t0.updated_at AS updated_at_9 FROM legal_pages t0 WHERE t0.published = ? AND t0.in_footer = ? ORDER BY t0.position ASC, t0.title ASC"
  "params" => [
    1 => 1
    2 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#977
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#977}
  ]
]

[
  "sql" => "SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.category AS category_2, t0_.placement AS placement_3, t0_.code AS code_4, t0_.enabled AS enabled_5, t0_.position AS position_6, t0_.created_at AS created_at_7, t0_.updated_at AS updated_at_8 FROM tracking_scripts t0_ WHERE t0_.enabled = 1 ORDER BY t0_.position ASC, t0_.created_at ASC"
]