Query Metrics
133
Database Queries
11
Different statements
245.22 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
210.93 ms (86.02%) |
62 |
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"
]
|
26.32 ms (10.73%) |
62 |
INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (?, ?, ?, ?, ?, ?)
Parameters:
[ 11.0 1 36 "EA/IA" 1876 12840 ] |
2.91 ms (1.19%) |
1 |
"COMMIT"
Parameters:
[] |
0.88 ms (0.36%) |
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:
[
8
]
|
0.83 ms (0.34%) |
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:
[ 11.387096774194 "Human biology " 0 0 43 0 19 3.0 19.0 "2025-02-05 12:41:42" "2025-02-05 12:41:42" 42 292 23 8 ] |
0.79 ms (0.32%) |
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
]
|
0.66 ms (0.27%) |
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:
[
"292"
]
|
0.63 ms (0.26%) |
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:
[
"23"
]
|
0.47 ms (0.19%) |
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:
[] |
0.41 ms (0.17%) |
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.38 ms (0.15%) |
1 |
"START TRANSACTION"
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 | No errors. |
App\Entity\Payment | No errors. |
App\Entity\Mark | No errors. |