http://isbbethesda.com/prof/rooms/classroom/1/insolvent

Query Metrics

4 Database Queries
4 Different statements
7.23 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
3.36 ms
(46.48%)
1
SELECT t0.id AS id_1, t0.officialExamResult AS officialExamResult_2, t0.finance_holder AS finance_holder_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.student_id AS student_id_6, t0.class_room_id AS class_room_id_7, t0.school_year_id AS school_year_id_8 FROM subscription t0 WHERE t0.school_year_id = ? AND t0.class_room_id = ?
Parameters:
[
  7
  1
]
1.69 ms
(23.39%)
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:
[
  1
]
1.54 ms
(21.32%)
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.id = ?
Parameters:
[
  "1"
]
0.64 ms
(8.81%)
1
SELECT t0.id AS id_1, t0.matricule AS matricule_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.particular_disease AS particular_disease_5, t0.father_name AS father_name_6, t0.mother_name AS mother_name_7, t0.primary_contact AS primary_contact_8, t0.residence AS residence_9, t0.secondary_contact AS secondary_contact_10, t0.other_informations AS other_informations_11, t0.birthday AS birthday_12, t0.gender AS gender_13, t0.birthplace AS birthplace_14, t0.enrolled AS enrolled_15, t0.created_at AS created_at_16, t0.updated_at AS updated_at_17, t0.image_name AS image_name_18, t0.entry_class_id AS entry_class_id_19 FROM student t0 WHERE t0.id = ?
Parameters:
[
  1629
]

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