Query Metrics
44
Database Queries
15
Different statements
26.16 ms
Query time
4
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
3.84 ms (14.69%) |
11 |
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
]
|
|
3.16 ms (12.07%) |
1 |
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
]
|
|
3.02 ms (11.56%) |
8 |
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
]
|
|
2.77 ms (10.58%) |
5 |
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" ] |
|
2.05 ms (7.82%) |
3 |
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
]
|
|
2.03 ms (7.76%) |
2 |
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 ] |
|
1.80 ms (6.88%) |
2 |
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:
[] |
|
1.63 ms (6.22%) |
3 |
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"
]
|
|
1.38 ms (5.29%) |
1 |
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-12-18 14:08:14"
]
|
|
1.14 ms (4.34%) |
1 |
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
]
|
|
1.00 ms (3.84%) |
1 |
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
]
|
|
0.83 ms (3.17%) |
2 |
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 ] |
|
0.76 ms (2.89%) |
2 |
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
]
|
|
0.41 ms (1.56%) |
1 |
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
]
|
|
0.35 ms (1.34%) |
1 |
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" ] |
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 |
|
| App\Entity\CMSCategory |
|
| App\Entity\Category |
|
| App\Entity\CMSPage |
|
| App\Entity\MenuItemTranslation | No errors. |
| App\Entity\Pension | No errors. |
| App\Entity\CMSSlider | No errors. |
| App\Entity\CMSSponsors | No errors. |