GET https://www.dev.ecolesup-euro.fr/contact

Query Metrics

33 Database Queries
11 Different statements
42.07 ms Query time
4 Invalid entities

Queries

Group similar statements

# Time Info
1 18.95 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.name AS name_3, t0.description AS description_4 FROM contact t0
Parameters:
[]
2 1.58 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.value AS value_4, t0.position AS position_5 FROM ese_configuration t0 WHERE t0.name = ? LIMIT 1
Parameters:
[
  "GOOGLE_API_KEY"
]
3 0.51 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"
]
4 1.60 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"
]
5 2.14 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
]
6 2.56 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:
[]
7 3.44 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
]
8 0.53 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
]
9 0.29 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
]
10 0.27 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
]
11 0.29 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
]
12 0.28 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
]
13 0.27 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
]
14 0.25 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
]
15 0.28 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
]
16 0.27 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
]
17 0.25 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
]
18 0.25 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
]
19 0.41 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
]
20 0.38 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
]
21 0.35 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:
[]
22 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 = ? OR c1_.id = 4) ORDER BY c1_.id ASC
Parameters:
[
  0
  5
]
23 0.39 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
]
24 0.51 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
]
25 0.37 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"
]
26 1.83 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
]
27 0.30 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"
]
28 0.56 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"
]
29 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"
]
30 0.39 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"
]
31 0.40 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"
]
32 0.49 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
]
33 0.47 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
]

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\Contact 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\CycleFiliere No errors.
App\Entity\Pension No errors.
App\Entity\Filiere No errors.
App\Entity\Inscription No errors.
App\Entity\FiliereSpecialite No errors.