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

Query Metrics

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

Queries

Group similar statements

# Time Info
1 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:
[]
2 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:
[]
3 0.25 ms
SELECT t0.id AS id_1, t0.reference AS reference_2, t0.join_at AS join_at_3, t0.is_premium AS is_premium_4, t0.classe_id AS classe_id_5, t0.utilisateur_id AS utilisateur_id_6, t0.etablissement_id AS etablissement_id_7 FROM eleve t0 WHERE t0.utilisateur_id IS NULL LIMIT 1
Parameters:
[]
4 1.28 ms
SELECT t0.id AS id_1, t0.label AS label_2, t0.slug AS slug_3, t0.montant AS montant_4, t0.duree AS duree_5, t0.is_recommended AS is_recommended_6, t0.nbre_point AS nbre_point_7 FROM abonnement t0 ORDER BY t0.montant ASC
Parameters:
[]
5 1.27 ms
SELECT t0.id AS id_1, t0.label AS label_2 FROM abonnement_item t0
Parameters:
[]
6 0.40 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.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.is_sub_category = ? ORDER BY t0.name ASC LIMIT 11
Parameters:
[
  0
]
9 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:
[
  19
]
10 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
]
11 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:
[
  30
]
12 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:
[
  5
]
13 0.14 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.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:
[
  31
]
15 0.13 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.14 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.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:
[
  7
]
18 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:
[
  22
]
19 0.13 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.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:
[
  25
]
21 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
]
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:
[
  8
]
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:
[
  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\Eleve
  • The mappings App\Entity\Eleve#formations and App\Entity\Formation#eleves are inconsistent with each other.
App\Entity\Classe 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\Etablissement No errors.
App\Entity\Abonnement No errors.
App\Entity\Payment No errors.
App\Entity\AbonnementItem No errors.
App\Entity\PaymentMethod 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.