Query Metrics
35
Database Queries
9
Different statements
426.24 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 104.50 ms |
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
]
|
| 2 | 89.03 ms |
SELECT count(DISTINCT s0_.id) AS sclr_0 FROM students s0_ WHERE s0_.has_in_process_test = 1
Parameters:
[] |
| 3 | 18.36 ms |
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:
[] |
| 4 | 17.57 ms |
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 ] |
| 5 | 26.78 ms |
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
]
|
| 6 | 24.95 ms |
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 ] |
| 7 | 17.33 ms |
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:
[
52
]
|
| 8 | 8.23 ms |
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" 52 ] |
| 9 | 3.58 ms |
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:
[
1372
]
|
| 10 | 6.31 ms |
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" 1372 ] |
| 11 | 0.99 ms |
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:
[
1325
]
|
| 12 | 6.82 ms |
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" 1325 ] |
| 13 | 4.78 ms |
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:
[
1045
]
|
| 14 | 5.32 ms |
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" 1045 ] |
| 15 | 4.77 ms |
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:
[
318
]
|
| 16 | 5.75 ms |
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" 318 ] |
| 17 | 3.27 ms |
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:
[
987
]
|
| 18 | 2.97 ms |
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" 987 ] |
| 19 | 0.93 ms |
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:
[
891
]
|
| 20 | 2.70 ms |
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" 891 ] |
| 21 | 0.24 ms |
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:
[
1339
]
|
| 22 | 2.09 ms |
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" 1339 ] |
| 23 | 1.70 ms |
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:
[
280
]
|
| 24 | 3.00 ms |
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" 280 ] |
| 25 | 0.85 ms |
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:
[
708
]
|
| 26 | 2.75 ms |
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" 708 ] |
| 27 | 2.65 ms |
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:
[
382
]
|
| 28 | 2.98 ms |
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" 382 ] |
| 29 | 10.48 ms |
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
]
|
| 30 | 20.79 ms |
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
]
|
| 31 | 20.12 ms |
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
]
|
| 32 | 0.92 ms |
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:
[
1
]
|
| 33 | 0.83 ms |
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:
[
1
]
|
| 34 | 0.94 ms |
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:
[
3
]
|
| 35 | 0.95 ms |
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:
[
4
]
|
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. |