Symfony Profiler

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 = ?

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 = 99;

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

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 = 1 LIMIT 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 = ?
LIMIT
  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 = '4' LIMIT 1;

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

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 = '262' LIMIT 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 IS NULL
LIMIT
  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 IS NULL LIMIT 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.activated = ?
LIMIT
  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.activated = 1 LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202210070001' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202410170006' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202111040010' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202111040024' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202410050013' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202111040011' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202410050012' LIMIT 1;

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.matricule = ?
LIMIT
  1

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.matricule = '202111090001' LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO evaluation (
  moyenne, competence, abscent, success_h,
  success_f, faillures_h, faillures_f,
  mini, maxi, created_at, updated_at,
  sequence_id, course_id, class_room_id,
  author_id
)
VALUES
  (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)

INSERT INTO evaluation (moyenne, competence, abscent, success_h, success_f, faillures_h, faillures_f, mini, maxi, created_at, updated_at, sequence_id, course_id, class_room_id, author_id) VALUES (8.5, 'Writing on Drama and Prose ', 0, 0, 4, 0, 4, 3, 15, '2025-02-06 08:46:55', '2025-02-06 08:46:55', 42, 262, 4, 99);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (15, 1, 1, 'A', 1374, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (3, 1, 8, 'NA', 1860, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (7, 1, 6, 'NA', 1161, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (10, 1, 4, 'EA/IA', 1175, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (10, 1, 3, 'EA/IA', 1617, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (10, 1, 2, 'EA/IA', 1162, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (8, 1, 5, 'NA', 1616, 12841);

INSERT INTO mark (
  value, weight, rank2, appreciation,
  student_id, evaluation_id
)
VALUES
  (?, ?, ?, ?, ?, ?)

INSERT INTO mark (value, weight, rank2, appreciation, student_id, evaluation_id) VALUES (5, 1, 7, 'NA', 1182, 12841);

"COMMIT"

"COMMIT";