| 1 |
1.58 ms |
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
Parameters: [
"habilitation-electrique"
]
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 = 'habilitation-electrique' ORDER BY f0_.sort_order ASC;
|
| 4 |
1.40 ms |
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 = 3 ORDER BY t0.start_date ASC;
|
| 5 |
0.85 ms |
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 = 2 ORDER BY t0.start_date ASC;
|