http://dev.isbbethesda.com/teachers

Query Metrics

17 Database Queries
3 Different statements
8.43 ms Query time
0 Invalid entities
  • Queries
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Group similar statements

# Time Info
1 0.52 ms
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.activated = ? LIMIT 1
Parameters:
0 of 0
[ 1 ]
2 4.26 ms
SELECT u0_.id AS id_0, u0_.email AS email_1, u0_.password AS password_2, u0_.is_verified AS is_verified_3, u0_.avatarPath AS avatarPath_4, u0_.phoneNumber AS phoneNumber_5, u0_.gender AS gender_6, u0_.birthday AS birthday_7, u0_.birthplace AS birthplace_8, u0_.nationality AS nationality_9, u0_.location AS location_10, u0_.region AS region_11, u0_.department AS department_12, u0_.academicLevel AS academicLevel_13, u0_.numCni AS numCni_14, u0_.status AS status_15, u0_.full_name AS full_name_16, u0_.security_question AS security_question_17, u0_.security_answer AS security_answer_18, u0_.created_at AS created_at_19, u0_.updated_at AS updated_at_20, u0_.image_name AS image_name_21, u0_.domain_id AS domain_id_22 FROM user u0_ LEFT JOIN attribution a1_ ON u0_.id = a1_.teacher_id LEFT JOIN school_year s2_ ON a1_.year_id = s2_.id WHERE s2_.id = ? ORDER BY u0_.full_name ASC
Parameters:
0 of 0
[ 7 ]
3 0.53 ms
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
[ 2 ]
4 0.31 ms
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
[ 14 ]
5 0.23 ms
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
[ 8 ]
6 0.20 ms
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
[ 1 ]
7 0.28 ms
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
[ 6 ]
8 0.22 ms
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 ]
9 0.20 ms
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
[ 4 ]
10 0.19 ms
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
[ 9 ]
11 0.23 ms
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
[ 5 ]
12 0.20 ms
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
[ 10 ]
13 0.21 ms
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
[ 16 ]
14 0.22 ms
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
[ 12 ]
15 0.20 ms
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
[ 3 ]
16 0.20 ms
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
[ 7 ]
17 0.21 ms
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
[ 11 ]