http://isbbethesda.com/index.php/abscence_sheet/105/pdf

Query Metrics

48 Database Queries
7 Different statements
13.79 ms Query time
0 Invalid entities

Grouped Statements

Show all queries

Time Count Info
11.81 ms
(85.58%)
42
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:
[
  1708
]
0.46 ms
(3.30%)
1
SELECT t0.id AS id_1, t0.start_date AS start_date_2, t0.end_date AS end_date_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.sequence_id AS sequence_id_6, t0.class_room_id AS class_room_id_7 FROM abscence_sheet t0 WHERE t0.id = ?
Parameters:
[
  "105"
]
0.44 ms
(3.21%)
1
SELECT t0.id AS id_1, t0.validation_date AS validation_date_2, t0.code AS code_3, t0.wording AS wording_4, t0.start_date AS start_date_5, t0.end_date AS end_date_6, t0.activated AS activated_7, t0.quater_id AS quater_id_8 FROM sequence t0 WHERE t0.id = ?
Parameters:
[
  43
]
0.36 ms
(2.62%)
1
SELECT t0.id AS id_1, t0.weight AS weight_2, t0.reason AS reason_3, t0.justified AS justified_4, t0.abscence_sheet_id AS abscence_sheet_id_5, t0.student_id AS student_id_6 FROM abscence t0 WHERE t0.abscence_sheet_id = ?
Parameters:
[
  105
]
0.31 ms
(2.22%)
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 = ?
Parameters:
[
  7
]
0.23 ms
(1.65%)
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.20 ms
(1.41%)
1
SELECT t0.id AS id_1, t0.code AS code_2, t0.wording AS wording_3, t0.start_date AS start_date_4, t0.end_date AS end_date_5, t0.activated AS activated_6, t0.school_year_id AS school_year_id_7 FROM quater t0 WHERE t0.id = ?
Parameters:
[
  21
]

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