Symfony Profiler

[
  "route" => "app_formations"
  "route_parameters" => [
    "_route" => "app_formations"
    "_controller" => "App\Controller\FormationController::index"
  ]
  "request_uri" => "http://www.guardianfrance.fr/formations?categorie=incendie"
  "method" => "GET"
]

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

[
  "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" => "127.0.0.1"
    "port" => 3306
    "user" => "academy_user"
    "password" => "<redacted>"
    "driverOptions" => []
    "defaultTableOptions" => []
    "dbname" => "academy"
    "serverVersion" => "10.11.2-MariaDB"
    "charset" => "utf8mb4"
  ]
]

[
  "sql" => "SELECT f0_.id AS id_0, f0_.title AS title_1, f0_.subtitle AS subtitle_2, f0_.slug AS slug_3, f0_.description AS description_4, f0_.full_description AS full_description_5, f0_.image AS image_6, f0_.icon AS icon_7, f0_.duration AS duration_8, f0_.duration_unit AS duration_unit_9, f0_.price AS price_10, f0_.is_active AS is_active_11, f0_.is_featured AS is_featured_12, f0_.sort_order AS sort_order_13, f0_.objectives AS objectives_14, f0_.prerequisites AS prerequisites_15, f0_.program AS program_16, f0_.certification AS certification_17, f0_.program_filename AS program_filename_18, f0_.created_at AS created_at_19, f0_.updated_at AS updated_at_20, c1_.id AS id_21, c1_.name AS name_22, c1_.slug AS slug_23, c1_.color AS color_24, c1_.icon AS icon_25, f0_.category_id AS category_id_26 FROM formation f0_ LEFT JOIN category c1_ ON f0_.category_id = c1_.id WHERE f0_.is_active = 1 AND c1_.slug = ? ORDER BY f0_.sort_order ASC"
  "params" => [
    1 => "incendie"
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#896
      +name: "STRING"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.icon AS icon_5 FROM category t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.color AS color_4, t0.icon AS icon_5 FROM category t0"
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.location AS location_4, t0.max_participants AS max_participants_5, t0.current_participants AS current_participants_6, t0.price AS price_7, t0.status AS status_8, t0.notes AS notes_9, t0.formation_id AS formation_id_10 FROM formation_session t0 WHERE t0.formation_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 6
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1000
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.location AS location_4, t0.max_participants AS max_participants_5, t0.current_participants AS current_participants_6, t0.price AS price_7, t0.status AS status_8, t0.notes AS notes_9, t0.formation_id AS formation_id_10 FROM formation_session t0 WHERE t0.formation_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 7
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1000
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.location AS location_4, t0.max_participants AS max_participants_5, t0.current_participants AS current_participants_6, t0.price AS price_7, t0.status AS status_8, t0.notes AS notes_9, t0.formation_id AS formation_id_10 FROM formation_session t0 WHERE t0.formation_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 8
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1000
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.location AS location_4, t0.max_participants AS max_participants_5, t0.current_participants AS current_participants_6, t0.price AS price_7, t0.status AS status_8, t0.notes AS notes_9, t0.formation_id AS formation_id_10 FROM formation_session t0 WHERE t0.formation_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 9
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1000
      +name: "INTEGER"
    }
  ]
]

[
  "sql" => "SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.location AS location_4, t0.max_participants AS max_participants_5, t0.current_participants AS current_participants_6, t0.price AS price_7, t0.status AS status_8, t0.notes AS notes_9, t0.formation_id AS formation_id_10 FROM formation_session t0 WHERE t0.formation_id = ? ORDER BY t0.start_date ASC"
  "params" => [
    1 => 10
  ]
  "types" => [
    1 => Doctrine\DBAL\ParameterType {#1000
      +name: "INTEGER"
    }
  ]
]