http://isbbethesda.com/index.php/prof/rooms/18/recapitulatifseq Return to referer URL

Query Metrics

30 Database Queries
12 Different statements
14.58 ms Query time
0 Invalid entities

Queries

Group similar statements

# Time Info
1 0.53 ms
SELECT t0.id AS id_1, t0.email AS email_2, t0.password AS password_3, t0.is_verified AS is_verified_4, t0.avatarPath AS avatarPath_5, t0.phoneNumber AS phoneNumber_6, t0.gender AS gender_7, t0.birthday AS birthday_8, t0.birthplace AS birthplace_9, t0.nationality AS nationality_10, t0.location AS location_11, t0.region AS region_12, t0.department AS department_13, t0.academicLevel AS academicLevel_14, t0.numCni AS numCni_15, t0.status AS status_16, t0.full_name AS full_name_17, t0.security_question AS security_question_18, t0.security_answer AS security_answer_19, t0.created_at AS created_at_20, t0.updated_at AS updated_at_21, t0.image_name AS image_name_22, t0.domain_id AS domain_id_23 FROM user t0 WHERE t0.id = ?
Parameters:
[
  120
]
2 0.54 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 = ?
Parameters:
[
  "18"
]
3 0.58 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.35 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
]
5 1.57 ms
SELECT s0_.id AS id_0, s0_.matricule AS matricule_1, s0_.firstname AS firstname_2, s0_.lastname AS lastname_3, s0_.particular_disease AS particular_disease_4, s0_.father_name AS father_name_5, s0_.mother_name AS mother_name_6, s0_.primary_contact AS primary_contact_7, s0_.residence AS residence_8, s0_.secondary_contact AS secondary_contact_9, s0_.other_informations AS other_informations_10, s0_.birthday AS birthday_11, s0_.gender AS gender_12, s0_.birthplace AS birthplace_13, s0_.enrolled AS enrolled_14, s0_.created_at AS created_at_15, s0_.updated_at AS updated_at_16, s0_.image_name AS image_name_17, s0_.entry_class_id AS entry_class_id_18 FROM student s0_ LEFT JOIN subscription s1_ ON s0_.id = s1_.student_id LEFT JOIN class_room c2_ ON s1_.class_room_id = c2_.id WHERE s1_.school_year_id = ? AND c2_.id = ? ORDER BY s0_.lastname ASC
Parameters:
[
  7
  18
]
6 3.30 ms
SELECT m0_.id AS id_0, m0_.value AS value_1, m0_.weight AS weight_2, m0_.rank2 AS rank2_3, m0_.appreciation AS appreciation_4, m0_.student_id AS student_id_5, m0_.evaluation_id AS evaluation_id_6 FROM mark m0_ LEFT JOIN evaluation e1_ ON m0_.evaluation_id = e1_.id LEFT JOIN student s2_ ON m0_.student_id = s2_.id WHERE e1_.sequence_id = ? AND e1_.class_room_id = ? ORDER BY s2_.lastname ASC
Parameters:
[
  43
  18
]
7 0.52 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
]
8 0.41 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
]
9 0.40 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
]
10 0.50 ms
SELECT t0.id AS id_1, t0.name AS name_2, t0.code AS code_3, t0.room_id AS room_id_4 FROM module t0 WHERE t0.room_id = ?
Parameters:
[
  18
]
11 0.49 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.module_id = ?
Parameters:
[
  60
]
12 0.38 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.module_id = ?
Parameters:
[
  62
]
13 0.27 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.module_id = ?
Parameters:
[
  66
]
14 0.32 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13077
]
15 0.53 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13078
]
16 0.41 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13083
]
17 0.23 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13111
]
18 0.20 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13154
]
19 0.27 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13170
]
20 0.29 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13173
]
21 0.28 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13174
]
22 0.27 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13175
]
23 0.33 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13187
]
24 0.24 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13207
]
25 0.20 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13263
]
26 0.22 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13353
]
27 0.19 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13358
]
28 0.18 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13360
]
29 0.33 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13373
]
30 0.26 ms
SELECT t0.id AS id_1, t0.moyenne AS moyenne_2, t0.competence AS competence_3, t0.abscent AS abscent_4, t0.success_h AS success_h_5, t0.success_f AS success_f_6, t0.faillures_h AS faillures_h_7, t0.faillures_f AS faillures_f_8, t0.mini AS mini_9, t0.maxi AS maxi_10, t0.created_at AS created_at_11, t0.updated_at AS updated_at_12, t0.sequence_id AS sequence_id_13, t0.course_id AS course_id_14, t0.class_room_id AS class_room_id_15, t0.author_id AS author_id_16 FROM evaluation t0 WHERE t0.id = ?
Parameters:
[
  13461
]

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\ClassRoom No errors.
App\Entity\Level No errors.
App\Entity\Module 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\Sequence No errors.
App\Entity\Evaluation No errors.
App\Entity\Student No errors.
App\Entity\Payment No errors.
App\Entity\Mark No errors.
App\Entity\Cycle No errors.
App\Entity\Section No errors.
App\Entity\Program No errors.
App\Entity\Course No errors.