Query Metrics

8 Database Queries
6 Different statements
3.95 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.54 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:
[
  1
]
2 0.24 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.id = ? LIMIT 1
Parameters:
[
  5
]
3 0.24 ms
SELECT t0.id AS id_1, t0.created_at AS created_at_2, t0.updated_at AS updated_at_3, t0.teacher_id AS teacher_id_4, t0.class_room_id AS class_room_id_5, t0.school_year_id AS school_year_id_6 FROM main_teacher t0 WHERE t0.school_year_id = ?
Parameters:
[
  5
]
4 0.19 ms
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
Parameters:
[]
5 1.93 ms
SELECT s0_.id AS id_0, s0_.officialExamResult AS officialExamResult_1, s0_.finance_holder AS finance_holder_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.student_id AS student_id_5, s0_.class_room_id AS class_room_id_6, s0_.school_year_id AS school_year_id_7 FROM subscription s0_ LEFT JOIN school_year s1_ ON s0_.school_year_id = s1_.id INNER JOIN student s2_ ON s0_.student_id = s2_.id WHERE s1_.id = ? AND s2_.id IS NOT NULL ORDER BY s0_.class_room_id ASC
Parameters:
[
  5
]
6 0.38 ms
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.room_id = ?
Parameters:
[
  1
]
7 0.20 ms
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.room_id = ?
Parameters:
[
  2
]
8 0.23 ms
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.room_id = ?
Parameters:
[
  3
]

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\SchoolYear No errors.
App\Entity\PaymentPlan No errors.
App\Entity\Quater No errors.
App\Entity\Subscription No errors.
App\Entity\MainTeacher No errors.
App\Entity\User No errors.
App\Entity\ClassRoom No errors.
App\Entity\Level No errors.
App\Entity\Module No errors.
App\Entity\AbscenceSheet No errors.
App\Entity\Student No errors.
App\Entity\Course No errors.