http://test.praxisonline.co/admin/student?checkProcessTest=1

Query Metrics

35 Database Queries
9 Different statements
426.24 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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.