http://isbbethesda.com/index.php/prof/courses/338/show

Query Metrics

10 Database Queries
6 Different statements
4.17 ms Query time
0 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
1.08 ms
(25.98%)
3
SELECT t0.id AS id_1, t0.registration_deadline AS registration_deadline_2, t0.rate AS rate_3, t0.code AS code_4, t0.wording AS wording_5, t0.start_date AS start_date_6, t0.end_date AS end_date_7, t0.activated AS activated_8, t9.id AS id_10, t9.weight AS weight_11, t9.school_year_id AS school_year_id_12 FROM school_year t0 LEFT JOIN payment_plan t9 ON t9.school_year_id = t0.id WHERE t0.id = ?
Parameters:
0 of 0
[ 7 ]
0.97 ms
(23.32%)
3
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.avatarPath AS avatarPath_5, t0.phoneNumber AS phoneNumber_6, t0.gender AS gender_7, t0.birthday AS birthday_8, t0.birthplace AS birthplace_9, t0.nationality AS nationality_10, t0.location AS location_11, t0.region AS region_12, t0.department AS department_13, t0.academicLevel AS academicLevel_14, t0.numCni AS numCni_15, t0.status AS status_16, t0.full_name AS full_name_17, t0.security_question AS security_question_18, t0.security_answer AS security_answer_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_name AS image_name_22, t0.domain_id AS domain_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 51 ]
0.69 ms
(16.49%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 73 ]
0.54 ms
(12.92%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
0 of 0
[ 13 ]
0.46 ms
(11.02%)
1
SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.id = ?
Parameters:
0 of 0
[ "338" ]
0.43 ms
(10.26%)
1
SELECT t0.id AS id_1, t0.head_teacher AS head_teacher_2, t0.course_id AS course_id_3, t0.teacher_id AS teacher_id_4, t0.year_id AS year_id_5 FROM attribution t0 WHERE t0.course_id = ?
Parameters:
0 of 0
[ 338 ]