Query Metrics
35
Database Queries
9
Different statements
426.24 ms
Query time
0
Invalid entities
Grouped Statements
| Time▼ | Count | Info |
|---|---|---|
|
104.50 ms (24.52%) |
1 |
SELECT t0.id AS id_1, t0.fullname AS fullname_2, t0.username AS username_3, t0.roles AS roles_4, t0.password AS password_5, t0.is_active AS is_active_6 FROM user t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
89.03 ms (20.89%) |
1 |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM students s0_ WHERE s0_.has_in_process_test = 1
Parameters:
[] |
|
73.85 ms (17.33%) |
12 |
SELECT s0_.id AS id_0, s0_.available AS available_1, s0_.finished_at AS finished_at_2, s0_.enable_since AS enable_since_3, s0_.enable_until AS enable_until_4, s0_.score AS score_5, s0_.approved AS approved_6, s0_.student_id AS student_id_7, s0_.module_id AS module_id_8 FROM student_module s0_ WHERE s0_.enable_until > ? AND (s0_.approved IS NULL OR s0_.approved <> 1) AND s0_.student_id = ? ORDER BY s0_.enable_until ASC LIMIT 1
Parameters:
[ "2026-03-05 15:18:38" 696 ] |
|
67.88 ms (15.93%) |
12 |
SELECT s0_.id AS id_0, s0_.created_at AS created_at_1, s0_.student_id AS student_id_2, s0_.level_id AS level_id_3 FROM students s1_ INNER JOIN student_levels s0_ ON (s0_.student_id = s1_.id) WHERE s1_.id = ? LIMIT 1
Parameters:
[
696
]
|
|
23.61 ms (5.54%) |
4 |
SELECT t0.id AS id_1, t0.sequence AS sequence_2, t0.name AS name_3, t0.course_id AS course_id_4 FROM levels t0 WHERE t0.id = ?
Parameters:
[
7
]
|
|
20.12 ms (4.72%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.description AS description_3, t0.abreviature AS abreviature_4 FROM courses t0 WHERE t0.id = ?
Parameters:
[
1
]
|
|
18.36 ms (4.31%) |
1 |
SELECT DISTINCT s0_.id AS id_0, s0_.names AS names_1, s0_.lastname AS lastname_2 FROM students s0_ WHERE s0_.has_in_process_test = 1 ORDER BY s0_.names ASC, s0_.lastname ASC LIMIT 50
Parameters:
[] |
|
17.57 ms (4.12%) |
1 |
SELECT s0_.id AS id_0, s0_.names AS names_1, s0_.lastname AS lastname_2, s0_.city AS city_3, s0_.address AS address_4, s0_.phone AS phone_5, s0_.campus AS campus_6, s0_.modality AS modality_7, s0_.parent AS parent_8, s0_.parent_phone AS parent_phone_9, s0_.document_number AS document_number_10, s0_.eps AS eps_11, s0_.email AS email_12, s0_.has_in_process_test AS has_in_process_test_13, s0_.user_id AS user_id_14, s0_.document_type_id AS document_type_id_15 FROM students s0_ WHERE s0_.has_in_process_test = 1 AND s0_.id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) ORDER BY s0_.names ASC, s0_.lastname ASC
Parameters:
[ 696 52 1372 1325 1045 318 987 891 1339 280 708 382 ] |
|
11.32 ms (2.65%) |
2 |
SELECT t0.id AS id_1, t0.short_name AS short_name_2, t0.name AS name_3 FROM documents_types t0 WHERE t0.id = ?
Parameters:
[
2
]
|
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\Students | No errors. |
| App\Entity\DocumentsTypes | No errors. |
| App\Entity\StudentCourse | No errors. |
| App\Entity\StudentLevels | No errors. |
| App\Entity\Levels | No errors. |
| App\Entity\StudentModule | No errors. |
| App\Entity\Modules | No errors. |
| App\Entity\Courses | No errors. |