Symfony Profiler

Query Metrics

6 Database Queries

4 Different statements

161.82 ms Query time

0 Invalid entities

Queries


SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? ORDER BY f0_.datedebut ASC) dctrn_result) dctrn_table
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12
SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC
SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ?
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12
SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC

#▲	Time	Info
1	49.96 ms	SELECT COUNT() AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? ORDER BY f0_.datedebut ASC) dctrn_result) dctrn_table Parameters: [`"2024-12-24" 1`] View formatted query View runnable query Explain query SELECT COUNT() AS dctrn_count FROM ( SELECT DISTINCT id_0 FROM ( SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? ORDER BY f0_.datedebut ASC ) dctrn_result ) dctrn_table SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-24' AND f0_.actif_id = 1 ORDER BY f0_.datedebut ASC) dctrn_result) dctrn_table;
2	39.94 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12 Parameters: [`"2024-12-24" 1`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, datedebut_8 FROM ( SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? ) dctrn_result_inner ORDER BY datedebut_8 ASC ) dctrn_result LIMIT 12 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-24' AND f0_.actif_id = 1) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12;
3	19.39 ms	SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC Parameters: [`"2024-12-24" 1 2327 2244 2357 2261 2478 2302 2303 2410 2411 2477 2278 2476`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-24' AND f0_.actif_id = 1 AND f0_.id IN (2327, 2244, 2357, 2261, 2478, 2302, 2303, 2410, 2411, 2477, 2278, 2476) ORDER BY f0_.datedebut ASC;
4	0.47 ms	SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.nom AS nom_2 FROM hebergement t0 WHERE t0.id = 2;
5	32.99 ms	SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ?) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12 Parameters: [`"2024-12-24" 1`] View formatted query View runnable query Explain query SELECT DISTINCT id_0 FROM ( SELECT DISTINCT id_0, datedebut_8 FROM ( SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? ) dctrn_result_inner ORDER BY datedebut_8 ASC ) dctrn_result LIMIT 12 SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, datedebut_8 FROM (SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-24' AND f0_.actif_id = 1) dctrn_result_inner ORDER BY datedebut_8 ASC) dctrn_result LIMIT 12;
6	19.07 ms	SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC Parameters: [`"2024-12-24" 1 2327 2244 2357 2261 2478 2302 2303 2410 2411 2477 2278 2476`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > ? AND f0_.actif_id = ? AND f0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY f0_.datedebut ASC SELECT f0_.id AS id_0, f0_.code AS code_1, f0_.lieu AS lieu_2, f0_.nombre AS nombre_3, f0_.tarif AS tarif_4, f0_.tarifpromotion AS tarifpromotion_5, f0_.promotion AS promotion_6, f0_.priorite AS priorite_7, f0_.datedebut AS datedebut_8, f0_.datefin AS datefin_9, f0_.datecrea AS datecrea_10, f0_.descriptif AS descriptif_11, f0_.doc_name AS doc_name_12, f0_.doc_name1 AS doc_name1_13, f0_.doc_name2 AS doc_name2_14, f0_.doc_name3 AS doc_name3_15, f0_.updated_at AS updated_at_16, f0_.habilitation AS habilitation_17, f0_.coordonnees AS coordonnees_18, f0_.horaires AS horaires_19, t1_.id AS id_20, t1_.nom AS nom_21, r2_.id AS id_22, r2_.nom AS nom_23, t3_.id AS id_24, t3_.nom AS nom_25, s4_.id AS id_26, s4_.nom AS nom_27, e5_.id AS id_28, e5_.nom AS nom_29, t6_.id AS id_30, t6_.nom AS nom_31, t6_.descriptif AS descriptif_32, f0_.zone_id AS zone_id_33, f0_.type_id AS type_id_34, f0_.theme_id AS theme_id_35, f0_.themebafa_id AS themebafa_id_36, f0_.saison_id AS saison_id_37, f0_.region_id AS region_id_38, f0_.hebergement_id AS hebergement_id_39, f0_.externat_id AS externat_id_40, f0_.actif_id AS actif_id_41, f0_.disponibilite_id AS disponibilite_id_42, t3_.type_id AS type_id_43, t6_.zone_id AS zone_id_44 FROM formation f0_ INNER JOIN type t1_ ON f0_.type_id = t1_.id INNER JOIN region r2_ ON f0_.region_id = r2_.id INNER JOIN theme t3_ ON f0_.theme_id = t3_.id INNER JOIN saison s4_ ON f0_.saison_id = s4_.id LEFT JOIN externat e5_ ON f0_.externat_id = e5_.id LEFT JOIN theme_bafa t6_ ON f0_.themebafa_id = t6_.id WHERE f0_.datedebut > '2024-12-24' AND f0_.actif_id = 1 AND f0_.id IN (2327, 2244, 2357, 2261, 2478, 2302, 2303, 2410, 2411, 2477, 2278, 2476) ORDER BY f0_.datedebut ASC;

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Entities Mapping

Class	Mapping errors
App\Entity\Formation	No errors.
App\Entity\Type	No errors.
App\Entity\Region	No errors.
App\Entity\Theme	No errors.
App\Entity\Saison	No errors.
App\Entity\Externat	No errors.
App\Entity\ThemeBafa	No errors.
App\Entity\Webzone	No errors.
App\Entity\Hebergement	No errors.
App\Entity\Actif	No errors.
App\Entity\Disponibilite	No errors.
App\Entity\Pooldocformation	No errors.
App\Entity\EspaceDocument	No errors.
App\Entity\ThemeBafaPrincipal	No errors.

Symfony Profiler

POST https://devz8.com/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping