Query Metrics
7
Database Queries
7
Different statements
164.27 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 61.15 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:
[
1513
]
|
| 2 | 73.31 ms |
SELECT t0.id AS id_1, t0.available AS available_2, t0.finished_at AS finished_at_3, t0.enable_since AS enable_since_4, t0.enable_until AS enable_until_5, t0.score AS score_6, t0.approved AS approved_7, t0.student_id AS student_id_8, t0.module_id AS module_id_9 FROM student_module t0 WHERE t0.module_id = ? AND t0.student_id = ? LIMIT 1
Parameters:
[ "2" "1439" ] |
| 3 | 8.37 ms |
SELECT t0.id AS id_1, t0.all_points AS all_points_2, t0.getted_points AS getted_points_3, t0.score_minimun AS score_minimun_4, t0.score_reading AS score_reading_5, t0.score_writing AS score_writing_6, t0.score_listening AS score_listening_7, t0.score_speaking AS score_speaking_8, t0.score AS score_9, t0.attemps AS attemps_10, t0.approved AS approved_11, t0.status AS status_12, t0.presented_at AS presented_at_13, t0.checked_at AS checked_at_14, t0.student_id AS student_id_15, t0.module_id AS module_id_16 FROM student_evaluation t0 WHERE t0.module_id = ? AND t0.student_id = ? ORDER BY t0.attemps DESC LIMIT 1
Parameters:
[ "2" "1439" ] |
| 4 | 8.96 ms |
SELECT t0.id AS id_1, t0.names AS names_2, t0.lastname AS lastname_3, t0.city AS city_4, t0.address AS address_5, t0.phone AS phone_6, t0.campus AS campus_7, t0.modality AS modality_8, t0.parent AS parent_9, t0.parent_phone AS parent_phone_10, t0.document_number AS document_number_11, t0.eps AS eps_12, t0.email AS email_13, t0.has_in_process_test AS has_in_process_test_14, t0.user_id AS user_id_15, t0.document_type_id AS document_type_id_16 FROM students t0 WHERE t0.id = ?
Parameters:
[
1439
]
|
| 5 | 4.88 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.evaluation_template AS evaluation_template_3, t0.evaluation_template2 AS evaluation_template2_4, t0.enable_show AS enable_show_5, t0.this_validate_level AS this_validate_level_6, t0.score_minimun AS score_minimun_7, t0.level_id AS level_id_8 FROM modules t0 WHERE t0.id = ?
Parameters:
[
2
]
|
| 6 | 4.67 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
]
|
| 7 | 2.94 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
]
|
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\StudentModule | No errors. |
| App\Entity\Students | No errors. |
| App\Entity\Modules | No errors. |
| App\Entity\StudentEvaluation | No errors. |
| App\Entity\DocumentsTypes | No errors. |
| App\Entity\StudentCourse | No errors. |
| App\Entity\Levels | No errors. |
| App\Entity\Courses | No errors. |