http://test.praxisonline.co/student/make/evaluation/1439/2

Query Metrics

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

Grouped Statements

Show all queries

Time Count Info
73.31 ms
(44.63%)
1
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"
]
61.15 ms
(37.22%)
1
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
]
8.96 ms
(5.45%)
1
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
]
8.37 ms
(5.09%)
1
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.88 ms
(2.97%)
1
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
]
4.67 ms
(2.84%)
1
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
]
2.94 ms
(1.79%)
1
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.