http://test.praxisonline.co/student/view/evaluation/1372/1/2130

Query Metrics

7 Database Queries
7 Different statements
135.44 ms Query time
0 Invalid entities

Queries

Group similar statements

# 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