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

Query Metrics

34 Database Queries
16 Different statements
10.50 ms Query time
8 Invalid entities

Queries

Group similar statements

# Time Info
1 0.64 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.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:
[]
3 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.slug = ? LIMIT 1
Parameters:
[
  "CHIMIE"
]
4 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.slug IS NULL LIMIT 1
Parameters:
[]
5 0.27 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 1.43 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.48 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.56 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:
[
  5
  1
]
9 0.27 ms
SELECT t0.id AS id_1, t0.video_url AS video_url_2, t0.mp4_file AS mp4_file_3, t0.web_mfile AS web_mfile_4, t0.ogg_file AS ogg_file_5, t0.image_file AS image_file_6, t0.cours_id AS cours_id_7 FROM media t0 WHERE t0.cours_id = ?
Parameters:
[
  2
]
10 0.18 ms
SELECT t0.id AS id_1, t0.cours_id AS cours_id_2 FROM forum t0 WHERE t0.cours_id = ?
Parameters:
[
  2
]
11 0.25 ms
SELECT t0.id AS id_1, t0.video_url AS video_url_2, t0.mp4_file AS mp4_file_3, t0.web_mfile AS web_mfile_4, t0.ogg_file AS ogg_file_5, t0.image_file AS image_file_6, t0.cours_id AS cours_id_7 FROM media t0 WHERE t0.cours_id = ?
Parameters:
[
  22
]
12 0.19 ms
SELECT t0.id AS id_1, t0.cours_id AS cours_id_2 FROM forum t0 WHERE t0.cours_id = ?
Parameters:
[
  22
]
13 0.46 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:
[]
14 0.50 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:
[]
15 0.24 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:
[]
16 0.67 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:
[]
17 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:
[]
18 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:
[]
19 0.31 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
]
20 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:
[
  19
]
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:
[
  9
]
22 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:
[
  30
]
23 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:
[
  5
]
24 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:
[
  29
]
25 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
]
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:
[
  12
]
27 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
]
28 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:
[
  7
]
29 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:
[
  22
]
30 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
]
31 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:
[
  25
]
32 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
]
33 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
]
34 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:
[
  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\Chapitre No errors.
App\Entity\Eleve
  • The mappings App\Entity\Eleve#formations and App\Entity\Formation#eleves are inconsistent with each other.
App\Entity\Formation
  • The association App\Entity\Formation#eleves refers to the inverse side field App\Entity\Eleve#CreatedAt which does not exist.
App\Entity\Like No errors.
App\Entity\Media No errors.
App\Entity\Forum No errors.
App\Entity\Membre No errors.
App\Entity\Sujet No errors.
App\Entity\FAQ No errors.
App\Entity\Review No errors.
App\Entity\Payment No errors.
App\Entity\PaymentMethod No errors.
App\Entity\Lecture No errors.
App\Entity\Quiz No errors.
App\Entity\QuizLost 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.