Symfony Profiler

[
  "route" => "app_login"
  "route_parameters" => [
    "_route" => "app_login"
    "_controller" => "App\Controller\SecurityController::login"
    "_locale" => "sitemap.xml"
  ]
  "request_uri" => "https://app.trainizer.fr/sitemap.xml/login"
  "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" => "192.168.1.131"
    "port" => 3306
    "user" => "paf_dev"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "autoformation_dev"
    "serverVersion" => "11.8.3-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL ORDER BY t0.date DESC"
  "params" => [
    1 => "homework_to_do"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? ORDER BY t0.date DESC"
  "params" => [
    1 => "new_features"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_5, t0.username AS username_6, t0.last_name AS last_name_7, t0.first_name AS first_name_8, t0.roles AS roles_9, t0.password AS password_10, t0.email AS email_11, t0.activated AS activated_12, t0.tmp_code AS tmp_code_13, t0.tmp_code_date AS tmp_code_date_14, t0.signature AS signature_15, t0.uuid AS uuid_16, t0.phone_number AS phone_number_17, t0.avatar_id AS avatar_id_18, t0.dtype, t1.password_save AS password_save_19, t1.documents AS documents_20, t1.diploma AS diploma_21, t1.tutorial_completed AS tutorial_completed_22, t1.financial_aid AS financial_aid_23, t1.cohort_id AS cohort_id_24, t2.role AS role_25, t2.entrance_code AS entrance_code_26, t2.entrance_code_date AS entrance_code_date_27, t2.responsible_id AS responsible_id_28, t3.role AS role_29, t3.entrance_code AS entrance_code_30, t3.entrance_code_date AS entrance_code_date_31, t3.sector_id AS sector_id_32, t4.role AS role_33, t4.entrance_code AS entrance_code_34, t4.entrance_code_date AS entrance_code_date_35, t4.coordinator_id AS coordinator_id_36 FROM user t0 LEFT JOIN trainee t1 ON t0.id = t1.id LEFT JOIN coordinator t2 ON t0.id = t2.id LEFT JOIN responsible t3 ON t0.id = t3.id LEFT JOIN trainer t4 ON t0.id = t4.id WHERE t0.id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1248
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.category AS category_2, t0.registry_number AS registry_number_3, t0.job AS job_4, t0.qualification AS qualification_5, t0.contract_label AS contract_label_6, t0.nationality AS nationality_7, t0.birth_date AS birth_date_8, t0.sex AS sex_9, t0.hired_at AS hired_at_10, t0.left_at AS left_at_11, t0.notes AS notes_12, t0.created_at AS created_at_13, t0.user_id AS user_id_14 FROM collaborator t0 WHERE t0.user_id = ?"
  "params" => [
    1 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1248
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL ORDER BY t0.date DESC"
  "params" => [
    1 => "new_message"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL ORDER BY t0.date DESC"
  "params" => [
    1 => "new_internship"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category = ? AND t0.user_id IS NULL ORDER BY t0.date DESC"
  "params" => [
    1 => "new_document"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.origin AS origin_2, t0.message AS message_3, t0.link AS link_4, t0.date AS date_5, t0.category AS category_6, t0.user_id AS user_id_7 FROM notification t0 WHERE t0.category IN (?, ?, ?) AND t0.user_id IS NULL ORDER BY t0.date DESC"
  "params" => [
    1 => "planning_added"
    2 => "planning_updated"
    3 => "planning_removed"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1240
      +name: "STRING"
    }
    2 => Doctrine\DBAL\ParameterType {#1240}
    3 => Doctrine\DBAL\ParameterType {#1240}
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.path AS path_3 FROM theme t0 WHERE t0.id = ?"
  "params" => [
    1 => 4
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1248
      +name: "INTEGER"
    }
  ]
]