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

Query Metrics

21 Database Queries
7 Different statements
4.20 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.43 ms
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.activated = ? LIMIT 1
Parameters:
[
  1
]
2 0.52 ms
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_.activated = ? ORDER BY s0_.id ASC
Parameters:
[
  1
]
3 0.22 ms
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:
[]
4 0.22 ms
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
]
5 0.20 ms
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
]
6 0.19 ms
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
]
7 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM programme t0 WHERE t0.id = ?
Parameters:
[
  1
]
8 0.17 ms
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:
[
  2
]
9 0.15 ms
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:
[
  3
]
10 0.16 ms
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:
[
  13
]
11 0.18 ms
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:
[
  4
]
12 0.16 ms
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:
[
  2
]
13 0.17 ms
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:
[
  5
]
14 0.16 ms
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:
[
  8
]
15 0.16 ms
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:
[
  3
]
16 0.16 ms
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:
[
  7
]
17 0.16 ms
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:
[
  9
]
18 0.16 ms
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:
[
  10
]
19 0.15 ms
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:
[
  2
]
20 0.15 ms
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:
[
  12
]
21 0.14 ms
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:
[
  11
]

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\Quater No errors.
App\Entity\Evaluation No errors.
App\Entity\AbscenceSheet No errors.
App\Entity\SchoolYear No 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\Cycle No errors.
App\Entity\Section No errors.
App\Entity\Program No errors.