Query Metrics
7
Database Queries
7
Different statements
135.44 ms
Query time
0
Invalid entities
Queries
| #▲ | Time | Info |
|---|---|---|
| 1 | 19.34 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 | 16.05 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.student_id = ? AND t0.module_id = ? AND t0.id = ? ORDER BY t0.id DESC LIMIT 1
Parameters:
[ "1372" "1" "2130" ] |
| 3 | 80.37 ms |
SELECT t0.id AS id_1, t0.answer_type AS answer_type_2, t0.answer_skill_type AS answer_skill_type_3, t0.question AS question_4, t0.right_answer AS right_answer_5, t0.answer_given AS answer_given_6, t0.points AS points_7, t0.score AS score_8, t0.is_checked AS is_checked_9, t0.student_evaluation_id AS student_evaluation_id_10 FROM student_evaluation_answer t0 WHERE t0.student_evaluation_id = ?
Parameters:
[
2130
]
|
| 4 | 9.10 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:
[
1372
]
|
| 5 | 2.89 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:
[
1
]
|
| 6 | 5.42 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
]
|
| 7 | 2.28 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\StudentEvaluation | No errors. |
| App\Entity\Students | No errors. |
| App\Entity\Modules | No errors. |
| App\Entity\StudentEvaluationAnswer | No errors. |
| App\Entity\StudentEvaluationPostRevision | No errors. |
| App\Entity\DocumentsTypes | No errors. |
| App\Entity\StudentCourse | No errors. |
| App\Entity\Levels | No errors. |
| App\Entity\Courses | No errors. |