Query Metrics
51
Database Queries
11
Different statements
139.19 ms
Query time
1
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
107.99 ms (77.58%) |
21 |
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:
[
"242271640"
]
|
|
17.63 ms (12.67%) |
21 |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 14.0 1 11 "A" 1876 15412 ] |
|
3.89 ms (2.80%) |
1 |
"COMMIT"
Parameters:
[] |
|
2.81 ms (2.02%) |
1 |
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.404761904762 "Iot, Cloud computing and system software " 0 0 14 0 7 5.0 18.0 "2026-01-30 17:00:06" "2026-01-30 17:00:06" 48 255 19 723 ] |
|
1.27 ms (0.91%) |
1 |
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:
[
723
]
|
|
1.24 ms (0.89%) |
1 |
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
]
|
|
1.18 ms (0.85%) |
1 |
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:
[
"255"
]
|
|
0.89 ms (0.64%) |
1 |
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:
[
"19"
]
|
|
0.83 ms (0.60%) |
1 |
"START TRANSACTION"
Parameters:
[] |
|
0.77 ms (0.55%) |
1 |
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
]
|
|
0.69 ms (0.50%) |
1 |
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:
[] |
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. |