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

Query Metrics

30 Database Queries
14 Different statements
6.17 ms Query time
7 Invalid entities

Queries

Group similar statements

# Time Info
1 0.47 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.21 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.25 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 = ? LIMIT 1
Parameters:
[
  "ECONNOMIE-SOCIALE-ET-FAMILIALE-ESF"
]
4 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.slug IS NULL LIMIT 1
Parameters:
[]
5 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type_enseignement_id AS type_enseignement_id_4 FROM filiere t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
6 0.11 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.filiere_id AS filiere_id_4 FROM specialite t0 WHERE t0.slug IS NULL LIMIT 1
Parameters:
[]
7 0.15 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:
[]
8 0.39 ms
SELECT c0_.id AS id_0, c0_.intitule AS intitule_1, c0_.slug AS slug_2, c0_.content AS content_3, c0_.description AS description_4, c0_.is_published AS is_published_5, c0_.is_free AS is_free_6, c0_.niveau_difficulte AS niveau_difficulte_7, c0_.duree_apprentissage AS duree_apprentissage_8, c0_.created_at AS created_at_9, c0_.vues AS vues_10, c0_.is_validated AS is_validated_11, c0_.montant_abonnement AS montant_abonnement_12, c0_.language AS language_13, c0_.number_of_lessons AS number_of_lessons_14, c0_.tags AS tags_15, c0_.is_rejected AS is_rejected_16, c0_.review AS review_17, c0_.updated_at AS updated_at_18, c0_.published_at AS published_at_19, c0_.enseignant_id AS enseignant_id_20, c0_.categorie_id AS categorie_id_21, c0_.skill_level_id AS skill_level_id_22 FROM cours c0_ INNER JOIN categorie c1_ ON c0_.categorie_id = c1_.id WHERE c0_.categorie_id = ? AND c0_.is_validated = ?
Parameters:
[
  31
  1
]
9 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 ORDER BY t0.name ASC
Parameters:
[]
10 0.20 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.type_enseignement_id AS type_enseignement_id_4 FROM filiere t0
Parameters:
[]
11 0.22 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.filiere_id AS filiere_id_4 FROM specialite t0 ORDER BY t0.filiere_id ASC
Parameters:
[]
12 0.19 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 ORDER BY t0.specialite_id ASC, t0.name ASC
Parameters:
[]
13 0.21 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:
[]
14 0.13 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:
[]
15 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.is_sub_category = ? ORDER BY t0.name ASC LIMIT 11
Parameters:
[
  0
]
16 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:
[
  19
]
17 0.15 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
]
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:
[
  30
]
19 0.15 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
]
20 0.27 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
]
21 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:
[
  31
]
22 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:
[
  12
]
23 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:
[
  20
]
24 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:
[
  7
]
25 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
]
26 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:
[
  24
]
27 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:
[
  25
]
28 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:
[
  26
]
29 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:
[
  8
]
30 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:
[
  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\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\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.
App\Entity\Filiere
  • The mappings App\Entity\Filiere#sousSystemes and App\Entity\SousSysteme#filieres are inconsistent with each other.
  • The association App\Entity\Filiere#users refers to the owning side field App\Entity\User#filiere which does not exist.
App\Entity\TypeEnseignement No errors.
App\Entity\Specialite No errors.
App\Entity\Classe 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\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\Eleve
  • The mappings App\Entity\Eleve#formations and App\Entity\Formation#eleves are inconsistent with each other.