http://isbbethesda.com/index.php/

Query Metrics

15 Database Queries
4 Different statements
36.88 ms Query time
0 Invalid entities
  • Grouped Statements
  • Database Connections
  • Entity Managers
  • Second Level Cache
  • Entities Mapping

Show all queries

Time Count Info
34.07 ms
(92.38%)
12
SELECT COUNT(s0_.id) AS sclr_0, s0_.officialExamResult AS officialExamResult_1 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id LEFT JOIN class_room c2_ ON s0_.class_room_id = c2_.id WHERE s1_.id = ? AND c2_.id = ? GROUP BY s0_.officialExamResult
Parameters:
0 of 0
[ 7 5 ]
1.12 ms
(3.05%)
1
SELECT t0.id AS id_1, t0.name AS name_2, t0.apc AS apc_3, t0.level_id AS level_id_4 FROM class_room t0 WHERE t0.apc = ? ORDER BY t0.level_id ASC
Parameters:
0 of 0
[ 1 ]
0.86 ms
(2.34%)
1
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 ]
0.82 ms
(2.23%)
1
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 = ? LIMIT 1
Parameters:
0 of 0
[ 7 ]