Symfony Profiler

[
  "route" => "app_home"
  "route_parameters" => [
    "_route" => "app_home"
    "_controller" => "App\Controller\HomeController::index"
  ]
  "request_uri" => "https://cis.fabien-gahery.fr/"
  "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"
]

[
  "key" => "_security_main"
  "token_class" => "Symfony\Component\Security\Core\Authentication\Token\UsernamePasswordToken"
]

[
  "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 u0_.id AS id_0, u0_.username AS username_1, u0_.roles AS roles_2, u0_.password AS password_3, u0_.totp_secret AS totp_secret_4, u0_.totp_recovery_codes AS totp_recovery_codes_5, u0_.firstname AS firstname_6, u0_.lastname AS lastname_7, u0_.birthdate AS birthdate_8, u0_.engagement_start_date AS engagement_start_date_9, u0_.email AS email_10, u0_.sdis_email AS sdis_email_11, u0_.hierarchical_rank AS hierarchical_rank_12, u0_.birth_place AS birth_place_13, u0_.address AS address_14, u0_.city AS city_15, u0_.zip_code AS zip_code_16, u0_.civil_status AS civil_status_17, u0_.land_line_phone_number AS land_line_phone_number_18, u0_.mobile_phone_number AS mobile_phone_number_19, u0_.partner_firstname AS partner_firstname_20, u0_.partner_lastname AS partner_lastname_21, u0_.number_of_children AS number_of_children_22, u0_.maiden_name AS maiden_name_23, u0_.gender AS gender_24, u0_.personnel_number AS personnel_number_25, u0_.profile_sheet AS profile_sheet_26, u0_.portrait AS portrait_27, u0_.is_active AS is_active_28, u0_.is_retired AS is_retired_29, u0_.latitude AS latitude_30, u0_.longitude AS longitude_31, u0_.address_geocoded_at AS address_geocoded_at_32, u0_.password_changed_at AS password_changed_at_33, u0_.temporary_password_expires_at AS temporary_password_expires_at_34, u0_.login_count AS login_count_35, u0_.last_login_at AS last_login_at_36, u0_.last_seen_at AS last_seen_at_37, a1_.id AS id_38, a1_.label AS label_39, a1_.code AS code_40, a1_.locked AS locked_41, a1_.sort_order AS sort_order_42, a1_.pages AS pages_43, c2_.id AS id_44, c2_.group_key AS group_key_45, c2_.label AS label_46, c2_.max_holders AS max_holders_47, c2_.sort_order AS sort_order_48, c2_.managed_by AS managed_by_49, u3_.id AS id_50, u3_.page_code AS page_code_51, u3_.granted AS granted_52, o4_.id AS id_53, o4_.number AS number_54, o4_.logo AS logo_55, o4_.color AS color_56, u0_.operational_team_id AS operational_team_id_57, a1_.center_function_id AS center_function_id_58, c2_.parent_id AS parent_id_59, u3_.user_id AS user_id_60 FROM `user` u0_ LEFT JOIN access_role_user a5_ ON u0_.id = a5_.user_id LEFT JOIN access_role a1_ ON a1_.id = a5_.access_role_id LEFT JOIN center_function_user c6_ ON u0_.id = c6_.user_id LEFT JOIN center_function c2_ ON c2_.id = c6_.center_function_id LEFT JOIN user_page_override u3_ ON u0_.id = u3_.user_id LEFT JOIN operational_team o4_ ON u0_.operational_team_id = o4_.id WHERE u0_.id = ?"
  "params" => [
    1 => 21
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#865
      +name: "INTEGER"
    }
  ]
]

[
  "username" => "vguillard"
  "provider" => "App\Security\UserProvider"
]

[
  "name" => "REMEMBERME"
]

[
  "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 {#741
      +name: "STRING"
    }
  ]
]