Query Metrics
25
Database Queries
9
Different statements
9.12 ms
Query time
0
Invalid entities
Grouped Statements
Time▼ | Count | Info |
---|---|---|
2.70 ms (29.58%) |
11 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.amount AS amount_3, t0.cycle_id AS cycle_id_4 FROM level t0 WHERE t0.id = ?
Parameters:
[
1
]
|
1.74 ms (19.12%) |
3 |
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.07 ms (11.72%) |
4 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.section_id AS section_id_3 FROM cycle t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.89 ms (9.72%) |
1 |
SELECT a0_.id AS id_0, a0_.start_date AS start_date_1, a0_.end_date AS end_date_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4, a0_.sequence_id AS sequence_id_5, a0_.class_room_id AS class_room_id_6 FROM abscence_sheet a0_ LEFT JOIN sequence s1_ ON a0_.sequence_id = s1_.id LEFT JOIN quater q2_ ON s1_.quater_id = q2_.id LEFT JOIN school_year s3_ ON q2_.school_year_id = s3_.id WHERE s3_.id = ? ORDER BY a0_.id DESC
Parameters:
[
7
]
|
0.72 ms (7.89%) |
1 |
SELECT s0_.id AS id_0, s0_.validation_date AS validation_date_1, s0_.code AS code_2, s0_.wording AS wording_3, s0_.start_date AS start_date_4, s0_.end_date AS end_date_5, s0_.activated AS activated_6, s0_.quater_id AS quater_id_7 FROM sequence s0_ LEFT JOIN quater q1_ ON s0_.quater_id = q1_.id LEFT JOIN school_year s2_ ON q1_.school_year_id = s2_.id WHERE s2_.id = ?
Parameters:
[
7
]
|
0.65 ms (7.08%) |
1 |
SELECT q0_.id AS id_0, q0_.code AS code_1, q0_.wording AS wording_2, q0_.start_date AS start_date_3, q0_.end_date AS end_date_4, q0_.activated AS activated_5, q0_.school_year_id AS school_year_id_6 FROM quater q0_ LEFT JOIN school_year s1_ ON q0_.school_year_id = s1_.id WHERE s1_.id = ? ORDER BY q0_.id ASC
Parameters:
[
7
]
|
0.64 ms (6.97%) |
2 |
SELECT t0.id AS id_1, t0.name AS name_2, t0.programme_id AS programme_id_3 FROM section t0 WHERE t0.id = ?
Parameters:
[
1
]
|
0.40 ms (4.43%) |
1 |
SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.apc AS apc_2, c0_.level_id AS level_id_3 FROM class_room c0_
Parameters:
[] |
0.32 ms (3.49%) |
1 |
SELECT t0.id AS id_1, t0.name AS name_2 FROM programme t0 WHERE t0.id = ?
Parameters:
[
1
]
|
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\Sequence | No errors. |
App\Entity\SchoolYear | No errors. |
App\Entity\PaymentPlan | No errors. |
App\Entity\Quater | No errors. |
App\Entity\Subscription | No errors. |
App\Entity\ClassRoom | No errors. |
App\Entity\AbscenceSheet | No errors. |
App\Entity\Abscence | No errors. |
App\Entity\Evaluation | No errors. |
App\Entity\Level | No errors. |
App\Entity\Module | No errors. |
App\Entity\MainTeacher | No errors. |
App\Entity\Cycle | No errors. |
App\Entity\Section | No errors. |
App\Entity\Program | No errors. |