Symfony Profiler

Query Metrics

44 Database Queries

15 Different statements

29.22 ms Query time

4 Invalid entities

Queries


SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 8
SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.localization AS localization_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.cover_image AS cover_image_5, c0_.description AS description_6, c0_.pdf_file AS pdf_file_7 FROM cmsevent c0_ WHERE c0_.date_end > ? ORDER BY c0_.date_start ASC LIMIT 4
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND (c1_.id = ? OR c1_.id = 4) ORDER BY c1_.id ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ?
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND (c1_.id = ? OR c1_.id = 4) ORDER BY c1_.id ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?)
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?)
SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.position AS position_4, t0.is_btn1 AS is_btn1_5, t0.btn1_text AS btn1_text_6, t0.btn1_link AS btn1_link_7, t0.btn1_text_color AS btn1_text_color_8, t0.btn1_bg_color AS btn1_bg_color_9, t0.is_btn2 AS is_btn2_10, t0.btn2_text AS btn2_text_11, t0.btn2_link AS btn2_link_12, t0.btn2_text_color AS btn2_text_color_13, t0.btn2_bg_color AS btn2_bg_color_14, t0.background_image AS background_image_15, t0.deleted AS deleted_16 FROM ese_cmsslider t0 WHERE t0.deleted = ? ORDER BY t0.position DESC
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ?
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.logo AS logo_4, t0.deleted AS deleted_5 FROM cmssponsors t0 WHERE t0.deleted = ?
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?)
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?)
SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1
SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 4

#▲	Time	Info
1	1.14 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 8 Parameters: [`0`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 8 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = 0 ORDER BY f0_.weight DESC LIMIT 8;
2	0.80 ms	SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.localization AS localization_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.cover_image AS cover_image_5, c0_.description AS description_6, c0_.pdf_file AS pdf_file_7 FROM cmsevent c0_ WHERE c0_.date_end > ? ORDER BY c0_.date_start ASC LIMIT 4 Parameters: [`"2025-08-10 01:16:10"`] View formatted query View runnable query Explain query SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.localization AS localization_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.cover_image AS cover_image_5, c0_.description AS description_6, c0_.pdf_file AS pdf_file_7 FROM cmsevent c0_ WHERE c0_.date_end > ? ORDER BY c0_.date_start ASC LIMIT 4 SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.localization AS localization_2, c0_.date_start AS date_start_3, c0_.date_end AS date_end_4, c0_.cover_image AS cover_image_5, c0_.description AS description_6, c0_.pdf_file AS pdf_file_7 FROM cmsevent c0_ WHERE c0_.date_end > '2025-08-10 01:16:10' ORDER BY c0_.date_start ASC LIMIT 4;
3	0.57 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) Parameters: [`"CMS_FACEBOOK" "CMS_TWITTER" "CMS_LINKEDIN"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_FACEBOOK', 'CMS_TWITTER', 'CMS_LINKEDIN');
4	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 Parameters: [`"Top"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = 'Top' LIMIT 1;
5	0.90 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE ( t0.parent_item_menu_id IS NULL AND t0.menu_id = ? ) ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = 1) ORDER BY t0.position ASC;
6	0.97 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id;
7	1.63 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND (c1_.id = ? OR c1_.id = 4) ORDER BY c1_.id ASC Parameters: [`0 5`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND ( c1_.id = ? OR c1_.id = 4 ) ORDER BY c1_.id ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = 0 AND (c1_.id = 5 OR c1_.id = 4) ORDER BY c1_.id ASC;
8	0.64 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 1;
9	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 11;
10	0.45 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 9;
11	0.46 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`8`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 8;
12	0.40 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 7;
13	0.44 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`6`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 6;
14	0.41 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 5;
15	0.42 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`4`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 4;
16	0.48 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 3;
17	0.47 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 2;
18	0.58 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? Parameters: [`10`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.text AS text_3, t0.slug AS slug_4, t0.description AS description_5, t0.logo AS logo_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8 FROM filiere_specialite t0 WHERE t0.id = 10;
19	0.69 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC Parameters: [`0 6`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = 0 AND c1_.id = 6 ORDER BY c1_.id ASC;
20	0.69 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = 7 ORDER BY t0.position ASC;
21	0.77 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id;
22	1.26 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND (c1_.id = ? OR c1_.id = 4) ORDER BY c1_.id ASC Parameters: [`0 5`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND ( c1_.id = ? OR c1_.id = 4 ) ORDER BY c1_.id ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = 0 AND (c1_.id = 5 OR c1_.id = 4) ORDER BY c1_.id ASC;
23	0.63 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC Parameters: [`0 6`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = ? AND c1_.id = ? ORDER BY c1_.id ASC SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ LEFT JOIN filiere_cycle_filiere f2_ ON f0_.id = f2_.filiere_id LEFT JOIN cycle_filiere c1_ ON c1_.id = f2_.cycle_filiere_id WHERE f0_.deleted = 0 AND c1_.id = 6 ORDER BY c1_.id ASC;
24	0.62 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC Parameters: [`9`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE t0.parent_item_menu_id = 9 ORDER BY t0.position ASC;
25	0.54 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 Parameters: [`"Category"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = 'Category' LIMIT 1;
26	0.67 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE ( t0.parent_item_menu_id IS NULL AND t0.menu_id = ? ) ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = 2) ORDER BY t0.position ASC;
27	0.62 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) Parameters: [`"CMS_EMAIL" "CMS_PHONE" "CMS_COPY_RIGHT"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_EMAIL', 'CMS_PHONE', 'CMS_COPY_RIGHT');
28	0.47 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) Parameters: [`"CMS_FACEBOOK" "CMS_TWITTER" "CMS_LINKEDIN"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_FACEBOOK', 'CMS_TWITTER', 'CMS_LINKEDIN');
29	0.79 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.position AS position_4, t0.is_btn1 AS is_btn1_5, t0.btn1_text AS btn1_text_6, t0.btn1_link AS btn1_link_7, t0.btn1_text_color AS btn1_text_color_8, t0.btn1_bg_color AS btn1_bg_color_9, t0.is_btn2 AS is_btn2_10, t0.btn2_text AS btn2_text_11, t0.btn2_link AS btn2_link_12, t0.btn2_text_color AS btn2_text_color_13, t0.btn2_bg_color AS btn2_bg_color_14, t0.background_image AS background_image_15, t0.deleted AS deleted_16 FROM ese_cmsslider t0 WHERE t0.deleted = ? ORDER BY t0.position DESC Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.position AS position_4, t0.is_btn1 AS is_btn1_5, t0.btn1_text AS btn1_text_6, t0.btn1_link AS btn1_link_7, t0.btn1_text_color AS btn1_text_color_8, t0.btn1_bg_color AS btn1_bg_color_9, t0.is_btn2 AS is_btn2_10, t0.btn2_text AS btn2_text_11, t0.btn2_link AS btn2_link_12, t0.btn2_text_color AS btn2_text_color_13, t0.btn2_bg_color AS btn2_bg_color_14, t0.background_image AS background_image_15, t0.deleted AS deleted_16 FROM ese_cmsslider t0 WHERE t0.deleted = ? ORDER BY t0.position DESC SELECT t0.id AS id_1, t0.title AS title_2, t0.subtitle AS subtitle_3, t0.position AS position_4, t0.is_btn1 AS is_btn1_5, t0.btn1_text AS btn1_text_6, t0.btn1_link AS btn1_link_7, t0.btn1_text_color AS btn1_text_color_8, t0.btn1_bg_color AS btn1_bg_color_9, t0.is_btn2 AS is_btn2_10, t0.btn2_text AS btn2_text_11, t0.btn2_link AS btn2_link_12, t0.btn2_text_color AS btn2_text_color_13, t0.btn2_bg_color AS btn2_bg_color_14, t0.background_image AS background_image_15, t0.deleted AS deleted_16 FROM ese_cmsslider t0 WHERE t0.deleted = 0 ORDER BY t0.position DESC;
30	1.11 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 1;
31	0.76 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`33`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 33;
32	0.60 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`38`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 38;
33	0.78 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`31`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 31;
34	0.57 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`36`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 36;
35	0.60 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`40`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 40;
36	0.55 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`30`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 30;
37	0.58 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.slug AS slug_4, t0.position AS position_5, t0.short_description AS short_description_6, t0.image_baniere AS image_baniere_7, t0.deleted AS deleted_8, t9.id AS id_10, t9.level AS level_11, t9.tranche_one AS tranche_one_12, t9.tranche_two AS tranche_two_13, t9.tranche_three AS tranche_three_14, t9.cycle_id AS cycle_id_15 FROM cycle_filiere t0 LEFT JOIN pension t9 ON t9.cycle_id = t0.id INNER JOIN filiere_cycle_filiere ON t0.id = filiere_cycle_filiere.cycle_filiere_id WHERE filiere_cycle_filiere.filiere_id = 2;
38	0.57 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?) Parameters: [`"CMS_HOME_TAKE_TOUR" "CMS_HOME_TAKE_TOUR_VIDEO"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_HOME_TAKE_TOUR', 'CMS_HOME_TAKE_TOUR_VIDEO');
39	0.68 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.logo AS logo_4, t0.deleted AS deleted_5 FROM cmssponsors t0 WHERE t0.deleted = ? Parameters: [`0`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.logo AS logo_4, t0.deleted AS deleted_5 FROM cmssponsors t0 WHERE t0.deleted = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.website AS website_3, t0.logo AS logo_4, t0.deleted AS deleted_5 FROM cmssponsors t0 WHERE t0.deleted = 0;
40	0.49 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) Parameters: [`"CMS_EMAIL" "CMS_PHONE" "CMS_COPY_RIGHT"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_EMAIL', 'CMS_PHONE', 'CMS_COPY_RIGHT');
41	0.46 ms	SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) Parameters: [`"CMS_FACEBOOK" "CMS_TWITTER" "CMS_LINKEDIN"`] View formatted query View runnable query Explain query SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN (?, ?, ?) SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.label AS label_2, e0_.value AS value_3, e0_.position AS position_4 FROM ese_configuration e0_ WHERE e0_.name IN ('CMS_FACEBOOK', 'CMS_TWITTER', 'CMS_LINKEDIN');
42	0.53 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 Parameters: [`"Footer"`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = ? LIMIT 1 SELECT t0.id AS id_1, t0.name AS name_2, t0.hook AS hook_3, t0.menu_type AS menu_type_4, t0.active AS active_5, t0.create_at AS create_at_6, t0.update_at AS update_at_7 FROM ese_menu t0 WHERE t0.hook = 'Footer' LIMIT 1;
43	0.70 ms	SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = ?) ORDER BY t0.position ASC Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE ( t0.parent_item_menu_id IS NULL AND t0.menu_id = ? ) ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.type AS type_2, t0.image AS image_3, t0.blank_target AS blank_target_4, t0.active AS active_5, t0.cliquable AS cliquable_6, t0.icon AS icon_7, t0.icon_color AS icon_color_8, t0.create_at AS create_at_9, t0.update_at AS update_at_10, t0.position AS position_11, t0.display_children AS display_children_12, t0.display_title AS display_title_13, t0.name AS name_14, t0.value AS value_15, t0.link_value AS link_value_16, t0.menu_id AS menu_id_17, t0.parent_item_menu_id AS parent_item_menu_id_18, t0.cmscategory_id AS cmscategory_id_19, t0.category_id AS category_id_20, t0.cmspage_id AS cmspage_id_21 FROM ese_menu_item t0 WHERE (t0.parent_item_menu_id IS NULL AND t0.menu_id = 3) ORDER BY t0.position ASC;
44	0.75 ms	SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 4 Parameters: [`0`] View formatted query View runnable query Explain query SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = ? ORDER BY f0_.weight DESC LIMIT 4 SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.description AS description_2, f0_.short_description AS short_description_3, f0_.debouche AS debouche_4, f0_.niveau_entree AS niveau_entree_5, f0_.image_couverture AS image_couverture_6, f0_.fiche_pdf AS fiche_pdf_7, f0_.slug AS slug_8, f0_.weight AS weight_9, f0_.deleted AS deleted_10, f0_.filiere_specialite_id AS filiere_specialite_id_11 FROM filiere f0_ WHERE f0_.deleted = 0 ORDER BY f0_.weight DESC LIMIT 4;

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\Filiere	No errors.
App\Entity\FiliereSpecialite	No errors.
App\Entity\CycleFiliere	No errors.
App\Entity\Inscription	No errors.
App\Entity\CMSEvent	No errors.
App\Entity\Configuration	No errors.
App\Entity\Menu	No errors.
App\Entity\MenuItem	The mappings App\Entity\MenuItem#CMSCategory and App\Entity\CMSCategory#menuItems are inconsistent with each other. The mappings App\Entity\MenuItem#category and App\Entity\Category#menuItems are inconsistent with each other. The mappings App\Entity\MenuItem#CMSPage and App\Entity\CMSPage#menuItems are inconsistent with each other.
App\Entity\CMSCategory	The field App\Entity\CMSCategory#menuItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MenuItem#menuItems does not contain the required 'inversedBy="menuItems"' attribute.
App\Entity\Category	The field App\Entity\Category#menuItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MenuItem#menuItems does not contain the required 'inversedBy="menuItems"' attribute.
App\Entity\CMSPage	The field App\Entity\CMSPage#menuItems is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\MenuItem#menuItems does not contain the required 'inversedBy="menuItems"' attribute.
App\Entity\MenuItemTranslation	No errors.
App\Entity\Pension	No errors.
App\Entity\CMSSlider	No errors.
App\Entity\CMSSponsors	No errors.

Symfony Profiler

GET http://dev.ecolesup-euro.fr/

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Entities Mapping