Symfony Profiler

[
  "route" => "app_privacy_public"
  "route_parameters" => [
    "_route" => "app_privacy_public"
    "_controller" => "App\Controller\LegalController::privacyPublic"
  ]
  "request_uri" => "https://cis.fabien-gahery.fr/politique-de-confidentialite"
  "method" => "GET"
]

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

[
  "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" => "database"
    "port" => 3306
    "user" => "app"
    "password" => "<redacted>"
    "driverOptions" => []
    "serverVersion" => "8.0.36"
    "defaultTableOptions" => []
    "dbname" => "sp-lege-2026"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.value AS value_2 FROM site_setting t0 WHERE t0.name = ?"
  "params" => [
    1 => "public_access"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.group_key AS group_key_2, t0.label AS label_3, t0.max_holders AS max_holders_4, t0.sort_order AS sort_order_5, t0.managed_by AS managed_by_6, t0.parent_id AS parent_id_7 FROM center_function t0 WHERE t0.label = ? LIMIT 1"
  "params" => [
    1 => "Président"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.totp_recovery_codes AS totp_recovery_codes_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.birthdate AS birthdate_9, t0.engagement_start_date AS engagement_start_date_10, t0.email AS email_11, t0.sdis_email AS sdis_email_12, t0.hierarchical_rank AS hierarchical_rank_13, t0.birth_place AS birth_place_14, t0.address AS address_15, t0.city AS city_16, t0.zip_code AS zip_code_17, t0.civil_status AS civil_status_18, t0.land_line_phone_number AS land_line_phone_number_19, t0.mobile_phone_number AS mobile_phone_number_20, t0.partner_firstname AS partner_firstname_21, t0.partner_lastname AS partner_lastname_22, t0.number_of_children AS number_of_children_23, t0.maiden_name AS maiden_name_24, t0.gender AS gender_25, t0.personnel_number AS personnel_number_26, t0.profile_sheet AS profile_sheet_27, t0.portrait AS portrait_28, t0.is_active AS is_active_29, t0.is_retired AS is_retired_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.address_geocoded_at AS address_geocoded_at_33, t0.password_changed_at AS password_changed_at_34, t0.temporary_password_expires_at AS temporary_password_expires_at_35, t0.login_count AS login_count_36, t0.last_login_at AS last_login_at_37, t0.last_seen_at AS last_seen_at_38, t0.operational_team_id AS operational_team_id_39 FROM `user` t0 INNER JOIN center_function_user ON t0.id = center_function_user.user_id WHERE center_function_user.center_function_id = ?"
  "params" => [
    1 => 24
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#818
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.group_key AS group_key_2, t0.label AS label_3, t0.max_holders AS max_holders_4, t0.sort_order AS sort_order_5, t0.managed_by AS managed_by_6, t0.parent_id AS parent_id_7 FROM center_function t0 WHERE t0.label = ? LIMIT 1"
  "params" => [
    1 => "Informatique"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.username AS username_2, t0.roles AS roles_3, t0.password AS password_4, t0.totp_secret AS totp_secret_5, t0.totp_recovery_codes AS totp_recovery_codes_6, t0.firstname AS firstname_7, t0.lastname AS lastname_8, t0.birthdate AS birthdate_9, t0.engagement_start_date AS engagement_start_date_10, t0.email AS email_11, t0.sdis_email AS sdis_email_12, t0.hierarchical_rank AS hierarchical_rank_13, t0.birth_place AS birth_place_14, t0.address AS address_15, t0.city AS city_16, t0.zip_code AS zip_code_17, t0.civil_status AS civil_status_18, t0.land_line_phone_number AS land_line_phone_number_19, t0.mobile_phone_number AS mobile_phone_number_20, t0.partner_firstname AS partner_firstname_21, t0.partner_lastname AS partner_lastname_22, t0.number_of_children AS number_of_children_23, t0.maiden_name AS maiden_name_24, t0.gender AS gender_25, t0.personnel_number AS personnel_number_26, t0.profile_sheet AS profile_sheet_27, t0.portrait AS portrait_28, t0.is_active AS is_active_29, t0.is_retired AS is_retired_30, t0.latitude AS latitude_31, t0.longitude AS longitude_32, t0.address_geocoded_at AS address_geocoded_at_33, t0.password_changed_at AS password_changed_at_34, t0.temporary_password_expires_at AS temporary_password_expires_at_35, t0.login_count AS login_count_36, t0.last_login_at AS last_login_at_37, t0.last_seen_at AS last_seen_at_38, t0.operational_team_id AS operational_team_id_39 FROM `user` t0 INNER JOIN center_function_user ON t0.id = center_function_user.user_id WHERE center_function_user.center_function_id = ?"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#818
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.name AS name_1, t0.value AS value_2 FROM site_setting t0 WHERE t0.name = ?"
  "params" => [
    1 => "pending_slot_color"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#841
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT a0_.id AS id_0, a0_.label AS label_1, a0_.code AS code_2, a0_.locked AS locked_3, a0_.sort_order AS sort_order_4, a0_.pages AS pages_5, c1_.id AS id_6, c1_.group_key AS group_key_7, c1_.label AS label_8, c1_.max_holders AS max_holders_9, c1_.sort_order AS sort_order_10, c1_.managed_by AS managed_by_11, a0_.center_function_id AS center_function_id_12, c1_.parent_id AS parent_id_13 FROM access_role a0_ LEFT JOIN center_function c1_ ON a0_.center_function_id = c1_.id ORDER BY a0_.sort_order ASC, a0_.label ASC"
]