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

Query Metrics

23 Database Queries
7 Different statements
7.63 ms Query time
5 Invalid entities

Queries

Group similar statements

# Time Info
1 0.59 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.20 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 1.74 ms
SELECT p0_.id AS id_0, p0_.name AS name_1, p0_.slug AS slug_2, p0_.code AS code_3 FROM pays p0_
Parameters:
[]
4 1.24 ms
SELECT e0_.id AS id_0, e0_.name AS name_1, e0_.ville AS ville_2, e0_.pays_id AS pays_id_3 FROM etablissement e0_
Parameters:
[]
5 0.24 ms
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.slug AS slug_2, c0_.image_file AS image_file_3, c0_.is_sub_category AS is_sub_category_4, c0_.category_id AS category_id_5 FROM categorie c0_
Parameters:
[]
6 0.29 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:
[]
7 0.19 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:
[]
8 0.34 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
]
9 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:
[
  19
]
10 0.17 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
]
11 0.17 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
]
12 0.21 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
]
13 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:
[
  29
]
14 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
]
15 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:
[
  12
]
16 0.17 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
]
17 0.20 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
]
18 0.20 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
]
19 0.17 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
]
20 0.17 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
]
21 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:
[
  26
]
22 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:
[
  8
]
23 0.17 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\Pays No errors.
App\Entity\Etablissement No errors.
App\Entity\Categorie No errors.
App\Entity\Personne
  • The field App\Entity\Personne#utilisateur is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User#personne does not contain the required 'inversedBy="utilisateur"' attribute.
App\Entity\Eleve
  • The mappings App\Entity\Eleve#formations and App\Entity\Formation#eleves are inconsistent with each other.
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\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\Exam No errors.
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.