http://isbbethesda.com/index.php/evaluations/?course=&room=&sequence=

Query Metrics

43 Database Queries
14 Different statements
11.78 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.52 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.github_id AS github_id_3, t0.github_access_token AS github_access_token_4, t0.facebook_id AS facebook_id_5, t0.facebook_access_token AS facebook_access_token_6, t0.google_id AS google_id_7, t0.google_access_token AS google_access_token_8, t0.linkedin_id AS linkedin_id_9, t0.linkedin_access_token AS linkedin_access_token_10, t0.twitter_id AS twitter_id_11, t0.twitter_access_token AS twitter_access_token_12, t0.yahoo_id AS yahoo_id_13, t0.yahoo_access_token AS yahoo_access_token_14, t0.password AS password_15, t0.is_verified AS is_verified_16, t0.avatarPath AS avatarPath_17, t0.phoneNumber AS phoneNumber_18, t0.gender AS gender_19, t0.birthday AS birthday_20, t0.birthplace AS birthplace_21, t0.nationality AS nationality_22, t0.location AS location_23, t0.region AS region_24, t0.department AS department_25, t0.academicLevel AS academicLevel_26, t0.numCni AS numCni_27, t0.status AS status_28, t0.full_name AS full_name_29, t0.security_question AS security_question_30, t0.security_answer AS security_answer_31, t0.created_at AS created_at_32, t0.updated_at AS updated_at_33, t0.image_name AS image_name_34, t0.domain_id AS domain_id_35 FROM user t0 WHERE t0.id = ?
Parameters:
[
  34
]
2 0.53 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
]
3 0.51 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
]
4 0.56 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 WHERE t0.id = ? LIMIT 1
Parameters:
[
  ""
]
5 0.20 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.id = ? LIMIT 1
Parameters:
[
  ""
]
6 0.25 ms
SELECT t0.id AS id_1, t0.wording AS wording_2, t0.coefficient AS coefficient_3, t0.code AS code_4, t0.domain_id AS domain_id_5, t0.module_id AS module_id_6 FROM course t0 WHERE t0.id = ? LIMIT 1
Parameters:
[
  ""
]
7 0.58 ms
SELECT e0_.id AS id_0, e0_.moyenne AS moyenne_1, e0_.competence AS competence_2, e0_.abscent AS abscent_3, e0_.success_h AS success_h_4, e0_.success_f AS success_f_5, e0_.faillures_h AS faillures_h_6, e0_.faillures_f AS faillures_f_7, e0_.created_at AS created_at_8, e0_.updated_at AS updated_at_9, e0_.sequence_id AS sequence_id_10, e0_.course_id AS course_id_11, e0_.class_room_id AS class_room_id_12 FROM evaluation e0_ LEFT JOIN sequence s1_ ON e0_.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 e0_.id DESC
Parameters:
[
  7
]
8 0.73 ms
SELECT c0_.id AS id_0, c0_.wording AS wording_1, c0_.coefficient AS coefficient_2, c0_.code AS code_3, c0_.domain_id AS domain_id_4, c0_.module_id AS module_id_5 FROM course c0_
Parameters:
[]
9 0.43 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  5
]
10 0.19 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  11
]
11 0.31 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  9
]
12 0.29 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  8
]
13 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  2
]
14 0.16 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  1
]
15 0.18 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  4
]
16 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  3
]
17 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  6
]
18 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  10
]
19 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  7
]
20 0.17 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  12
]
21 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  13
]
22 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  14
]
23 0.15 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.headOfDepartmentId AS headOfDepartmentId_3 FROM domain t0 WHERE t0.id = ?
Parameters:
[
  16
]
24 0.38 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_.id = ? ORDER BY s0_.id ASC
Parameters:
[
  7
]
25 0.24 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:
[]
26 0.27 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
]
27 0.31 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
]
28 0.33 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
]
29 0.27 ms
SELECT t0.id AS id_1, t0.name AS name_2 FROM programme t0 WHERE t0.id = ?
Parameters:
[
  1
]
30 0.30 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
]
31 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:
[
  3
]
32 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:
[
  13
]
33 0.23 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
]
34 0.22 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
]
35 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:
[
  5
]
36 0.24 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
]
37 0.21 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
]
38 0.20 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
]
39 0.21 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
]
40 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:
[
  10
]
41 0.25 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
]
42 0.21 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
]
43 0.20 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\User No errors.
App\Entity\Domain No errors.
App\Entity\Email No errors.
App\Entity\Attribution No errors.
App\Entity\MainTeacher No errors.
App\Entity\Course No 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\Level No errors.
App\Entity\Module No errors.
App\Entity\Evaluation No errors.
App\Entity\Mark No errors.
App\Entity\AbscenceSheet No errors.
App\Entity\Cycle No errors.
App\Entity\Section No errors.
App\Entity\Program No errors.