Query Metrics
45
Database Queries
11
Different statements
109.89 ms
Query time
1
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 1.11 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.avatarPath AS avatarPath_5, t0.phoneNumber AS phoneNumber_6, t0.gender AS gender_7, t0.birthday AS birthday_8, t0.birthplace AS birthplace_9, t0.nationality AS nationality_10, t0.location AS location_11, t0.region AS region_12, t0.department AS department_13, t0.academicLevel AS academicLevel_14, t0.numCni AS numCni_15, t0.status AS status_16, t0.full_name AS full_name_17, t0.security_question AS security_question_18, t0.security_answer AS security_answer_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_name AS image_name_22, t0.domain_id AS domain_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
59
]
|
| 2 | 1.17 ms |
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 3 | 0.87 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"4"
]
|
| 4 | 1.03 ms |
SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
"395"
]
|
| 5 | 0.82 ms |
SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.id IS NULL LIMIT 1
Parameters:
[] |
| 6 | 0.67 ms |
SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.activated = ? LIMIT 1
Parameters:
[
1
]
|
| 7 | 2.78 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"242275924"
]
|
| 8 | 4.96 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"242275926"
]
|
| 9 | 4.15 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202522z"
]
|
| 10 | 4.90 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202310070008"
]
|
| 11 | 6.71 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521g"
]
|
| 12 | 6.70 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521q"
]
|
| 13 | 6.98 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202522a"
]
|
| 14 | 6.76 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521d"
]
|
| 15 | 7.33 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521s"
]
|
| 16 | 4.80 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"242275924"
]
|
| 17 | 5.02 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"242275926"
]
|
| 18 | 6.55 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202522z"
]
|
| 19 | 2.83 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202310070008"
]
|
| 20 | 3.40 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521g"
]
|
| 21 | 3.26 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521q"
]
|
| 22 | 4.92 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202522a"
]
|
| 23 | 3.54 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521d"
]
|
| 24 | 3.34 ms |
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.matricule = ? LIMIT 1
Parameters:
[
"202521s"
]
|
| 25 | 0.39 ms |
"START TRANSACTION"
Parameters:
[] |
| 26 | 1.80 ms |
INSERT INTO evaluation (moyenne, competence, abscent, success_h, success_f, faillures_h, faillures_f, mini, maxi, created_at, updated_at, sequence_id, course_id, class_room_id, author_id) VALUES (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)
Parameters:
[ 12.555555555556 "Historical background of food " 0 0 14 0 4 4.0 18.0 "2025-11-05 13:18:46" "2025-11-05 13:18:46" 46 395 4 59 ] |
| 27 | 1.51 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 11.0 1 12 "EA/IA" 1459 14597 ] |
| 28 | 0.47 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 16.0 1 6 "A" 1595 14597 ] |
| 29 | 0.44 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 10.0 1 14 "EA/IA" 2178 14597 ] |
| 30 | 0.48 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 18.0 1 2 "E" 1509 14597 ] |
| 31 | 0.49 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 15.0 1 8 "A" 2174 14597 ] |
| 32 | 0.51 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 4.0 1 18 "NA" 2169 14597 ] |
| 33 | 0.47 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 13.0 1 10 "EA/IA" 2176 14597 ] |
| 34 | 0.46 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 17.0 1 4 "E" 2171 14597 ] |
| 35 | 0.46 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 9.0 1 16 "NA" 2170 14597 ] |
| 36 | 0.56 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 11.0 1 11 "EA/IA" 1459 14597 ] |
| 37 | 0.45 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 16.0 1 5 "A" 1595 14597 ] |
| 38 | 0.39 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 10.0 1 13 "EA/IA" 2178 14597 ] |
| 39 | 0.55 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 18.0 1 1 "E" 1509 14597 ] |
| 40 | 0.52 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 15.0 1 7 "A" 2174 14597 ] |
| 41 | 0.51 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 4.0 1 17 "NA" 2169 14597 ] |
| 42 | 0.46 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 13.0 1 9 "EA/IA" 2176 14597 ] |
| 43 | 0.37 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 17.0 1 3 "E" 2171 14597 ] |
| 44 | 0.34 ms |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 9.0 1 15 "NA" 2170 14597 ] |
| 45 | 3.64 ms |
"COMMIT"
Parameters:
[] |
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\User | No errors. |
| App\Entity\Domain | No errors. |
| App\Entity\Email | No errors. |
| App\Entity\Attribution | No errors. |
| App\Entity\MainTeacher | No errors. |
| App\Entity\SchoolYear | No errors. |
| App\Entity\PaymentPlan | No errors. |
| App\Entity\Quater | No errors. |
| App\Entity\Subscription | No errors. |
| App\Entity\ClassRoom | No errors. |
| App\Entity\Level | No errors. |
| App\Entity\Module | No errors. |
| App\Entity\AbscenceSheet | No errors. |
| App\Entity\Course | No errors. |
| App\Entity\Evaluation | No errors. |
| App\Entity\Sequence | No errors. |
| App\Entity\Student |
|
| App\Entity\Payment | No errors. |
| App\Entity\Mark | No errors. |