GET https://pay-kulmapeck.online/header-categories

Query Metrics

27 Database Queries
11 Different statements
15.68 ms Query time
6 Invalid entities

Queries

Group similar statements

# Time Info
1 0.70 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1
Parameters:
[]
2 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0
Parameters:
[]
3 0.52 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
4 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.specialite_id AS specialite_id_4, t0.skill_level_id AS skill_level_id_5, t0.sous_systeme_id AS sous_systeme_id_6 FROM classe t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
5 0.42 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM skill_level t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
6 4.80 ms
SELECT e0_.id AS id_0, e0_.sujet AS sujet_1, e0_.correction AS correction_2, e0_.title AS title_3, e0_.description AS description_4, e0_.published_at AS published_at_5, e0_.is_published AS is_published_6, e0_.reference AS reference_7, e0_.is_validated AS is_validated_8, e0_.duration AS duration_9, e0_.image_file AS image_file_10, e0_.language AS language_11, e0_.user_id AS user_id_12, e0_.classe_id AS classe_id_13, e0_.category_id AS category_id_14 FROM exam e0_ WHERE e0_.is_validated = ? ORDER BY e0_.published_at DESC
Parameters:
[
  1
]
7 0.72 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0
Parameters:
[]
8 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.specialite_id AS specialite_id_4, t0.skill_level_id AS skill_level_id_5, t0.sous_systeme_id AS sous_systeme_id_6 FROM classe t0
Parameters:
[]
9 2.12 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3 FROM skill_level t0
Parameters:
[]
10 0.49 ms
SELECT t0.id AS id_1, t0.site_name AS site_name_2, t0.site_copyrights AS site_copyrights_3, t0.site_email AS site_email_4, t0.site_description AS site_description_5, t0.contact_phone AS contact_phone_6, t0.support_email AS support_email_7, t0.contact_address AS contact_address_8, t0.main_site_url AS main_site_url_9, t0.is_maintenance_mode AS is_maintenance_mode_10, t0.maintenance_text AS maintenance_text_11 FROM site_setting t0 LIMIT 1
Parameters:
[]
11 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.link AS link_3, t0.icon AS icon_4 FROM social_setting t0
Parameters:
[]
12 0.39 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.is_sub_category = ? ORDER BY t0.name ASC LIMIT 11
Parameters:
[
  0
]
13 0.24 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  19
]
14 0.23 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  9
]
15 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  30
]
16 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  5
]
17 0.57 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  29
]
18 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  31
]
19 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  12
]
20 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  20
]
21 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  7
]
22 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  22
]
23 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  24
]
24 0.38 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  25
]
25 0.70 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  26
]
26 0.28 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  8
]
27 0.26 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.image_file AS image_file_4, t0.is_sub_category AS is_sub_category_5, t0.category_id AS category_id_6 FROM categorie t0 WHERE t0.category_id = ?
Parameters:
[
  11
]

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\SiteSetting No errors.
App\Entity\SocialSetting No errors.
App\Entity\Categorie No errors.
App\Entity\Classe No errors.
App\Entity\Specialite No errors.
App\Entity\SkillLevel No errors.
App\Entity\SousSysteme
  • The association App\Entity\SousSysteme#filieres refers to the owning side field App\Entity\Filiere#sousSysteme which does not exist.
App\Entity\Exam No errors.
App\Entity\User
  • The field App\Entity\User#personne is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Personne#utilisateur does not contain the required 'inversedBy="personne"' attribute.
  • The mappings App\Entity\User#filieres and App\Entity\Filiere#users are inconsistent with each other.
App\Entity\Cours
  • The field App\Entity\Cours#forum is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Forum#cours does not contain the required 'inversedBy="forum"' attribute.
App\Entity\Enseignant
  • The association App\Entity\Enseignant#evaluations refers to the owning side field App\Entity\Evaluation#relation which does not exist.
App\Entity\Evaluation
  • The mappings App\Entity\Evaluation#enseignant and App\Entity\Enseignant#evaluations are inconsistent with each other.
App\Entity\MatiereCycle No errors.
App\Entity\SubjectChat No errors.
App\Entity\Eleve
  • The mappings App\Entity\Eleve#formations and App\Entity\Formation#eleves are inconsistent with each other.