Symfony Profiler

[
  "route" => "app_q_and_a"
  "route_parameters" => [
    "_route" => "app_q_and_a"
    "_controller" => "App\Controller\HomeController::faq"
    "_locale" => "fr"
  ]
  "request_uri" => "https://app.trainizer.fr/fr/q-and-a"
  "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 f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE (f0_.sector_id = ? OR f0_.sector_id IS NULL) GROUP BY f0_.theme"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1085
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.theme AS theme_1, f0_.title AS title_2, f0_.content AS content_3, f0_.visibility AS visibility_4, f0_.priority AS priority_5, f0_.sector_id AS sector_id_6 FROM faq f0_ WHERE ((f0_.sector_id = ? OR f0_.sector_id IS NULL)) AND f0_.visibility = 1 ORDER BY f0_.sector_id ASC, f0_.title ASC"
  "params" => [
    1 => null
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1085
      +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.role AS role_19, t1.entrance_code AS entrance_code_20, t1.entrance_code_date AS entrance_code_date_21, t1.sector_id AS sector_id_22, t2.password_save AS password_save_23, t2.documents AS documents_24, t2.diploma AS diploma_25, t2.tutorial_completed AS tutorial_completed_26, t2.cohort_id AS cohort_id_27, t3.role AS role_28, t3.entrance_code AS entrance_code_29, t3.entrance_code_date AS entrance_code_date_30, t3.responsible_id AS responsible_id_31, t4.role AS role_32, t4.entrance_code AS entrance_code_33, t4.entrance_code_date AS entrance_code_date_34, t4.coordinator_id AS coordinator_id_35 FROM user t0 LEFT JOIN responsible t1 ON t0.id = t1.id LEFT JOIN trainee t2 ON t0.id = t2.id LEFT JOIN coordinator 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 {#1186
      +name: "INTEGER"
    }
  ]
]

[
  "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 => 1
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1186
      +name: "INTEGER"
    }
  ]
]