Symfony Profiler

[
  "route" => "front_estimation_page"
  "route_parameters" => [
    "_route" => "front_estimation_page"
    "_controller" => "App\Front\Controller\GeoController::estimationPage"
    "slug" => "tassin-la-demi-lune"
  ]
  "request_uri" => "https://carrier.alpium.com/estimation-immobiliere/tassin-la-demi-lune"
  "method" => "GET"
]

[
  "firewall_name" => "customer"
  "authenticators" => 2
]

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

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

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

[
  "firewall_name" => "customer"
  "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.slug AS slug_2, t0.seo_title AS seo_title_3, t0.seo_meta_description AS seo_meta_description_4, t0.seo_h1 AS seo_h1_5, t0.seo_intro AS seo_intro_6, t0.seo_content AS seo_content_7, t0.cta_label AS cta_label_8, t0.faq AS faq_9, t0.hero_image_url AS hero_image_url_10, t0.hero_image_alt AS hero_image_alt_11, t0.status AS status_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.city_id AS city_id_16 FROM estimation_pages t0 WHERE t0.slug = ? AND t0.status = ? AND ((t0.deleted_at IS NULL)) LIMIT 1"
  "params" => [
    1 => "tassin-la-demi-lune"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1154
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1154}
  ]
]

[
  "sql" => "SELECT d0_.id AS id_0, d0_.name AS name_1, d0_.slug AS slug_2, d0_.description AS description_3, d0_.latitude AS latitude_4, d0_.longitude AS longitude_5, d0_.seo_title AS seo_title_6, d0_.seo_meta_description AS seo_meta_description_7, d0_.seo_h1 AS seo_h1_8, d0_.seo_content AS seo_content_9, d0_.status AS status_10, d0_.created_at AS created_at_11, d0_.updated_at AS updated_at_12, d0_.deleted_at AS deleted_at_13, d0_.city_id AS city_id_14 FROM districts d0_ WHERE (d0_.city_id = ? AND d0_.status = ?) AND (d0_.deleted_at IS NULL) ORDER BY d0_.name ASC"
  "params" => [
    1 => b"\x01ŸK€:EvLµ.Ã\x01Ÿz“µ"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1154
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1154}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.postal_code AS postal_code_4, t0.department AS department_5, t0.region AS region_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.population AS population_9, t0.seo_title AS seo_title_10, t0.seo_meta_description AS seo_meta_description_11, t0.seo_h1 AS seo_h1_12, t0.seo_intro AS seo_intro_13, t0.seo_content AS seo_content_14, t0.faq AS faq_15, t0.hero_image_url AS hero_image_url_16, t0.hero_image_alt AS hero_image_alt_17, t0.google_business_url AS google_business_url_18, t0.status AS status_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.territory_id AS territory_id_23 FROM cities t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => b"\x01ŸK€:EvLµ.Ã\x01Ÿz“µ"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1154
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.postal_code AS postal_code_4, t0.department AS department_5, t0.region AS region_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.population AS population_9, t0.seo_title AS seo_title_10, t0.seo_meta_description AS seo_meta_description_11, t0.seo_h1 AS seo_h1_12, t0.seo_intro AS seo_intro_13, t0.seo_content AS seo_content_14, t0.faq AS faq_15, t0.hero_image_url AS hero_image_url_16, t0.hero_image_alt AS hero_image_alt_17, t0.google_business_url AS google_business_url_18, t0.status AS status_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.deleted_at AS deleted_at_22, t0.territory_id AS territory_id_23 FROM cities t0 WHERE t0.territory_id = ? AND t0.status = ? AND ((t0.deleted_at IS NULL)) ORDER BY t0.name ASC"
  "params" => [
    1 => b"\x01ŸK€:7yô§«­}T{yh"
    2 => "published"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1154
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1154}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.baseline AS baseline_4, t0.description AS description_5, t0.hero_image_url AS hero_image_url_6, t0.seo_title AS seo_title_7, t0.seo_meta_description AS seo_meta_description_8, t0.seo_h1 AS seo_h1_9, t0.seo_content AS seo_content_10, t0.status AS status_11, t0.display_order AS display_order_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.deleted_at AS deleted_at_15, t0.agency_id AS agency_id_16 FROM territories t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))"
  "params" => [
    1 => b"\x01ŸK€:7yô§«­}T{yh"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1154
      +name: "STRING"
    }
  ]
]

[
  "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 {#1154
      +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 {#1705
      +name: "BOOLEAN"
    }
    2 => Doctrine\DBAL\ParameterType {#1705}
  ]
]

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