Symfony Profiler

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

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 = 'agent-prevention-et-securite' ORDER BY f0_.sort_order ASC;

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

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;

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

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 = 1 ORDER BY t0.start_date ASC;