Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.first_name AS first_name_5,
  t0.last_name AS last_name_6,
  t0.phone AS phone_7,
  t0.user_type AS user_type_8,
  t0.is_verified AS is_verified_9,
  t0.matricule AS matricule_10,
  t0.full_name AS full_name_11,
  t0.last_request_ts AS last_request_ts_12,
  t0.theme AS theme_13,
  t0.picture AS picture_14,
  t0.sexe AS sexe_15,
  t0.local_phone_lang AS local_phone_lang_16,
  t0.user_token AS user_token_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.author_id AS author_id_20,
  t0.editor_id AS editor_id_21,
  t0.school_id AS school_id_22
FROM
  `user` t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.user_type AS user_type_8, t0.is_verified AS is_verified_9, t0.matricule AS matricule_10, t0.full_name AS full_name_11, t0.last_request_ts AS last_request_ts_12, t0.theme AS theme_13, t0.picture AS picture_14, t0.sexe AS sexe_15, t0.local_phone_lang AS local_phone_lang_16, t0.user_token AS user_token_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.author_id AS author_id_20, t0.editor_id AS editor_id_21, t0.school_id AS school_id_22 FROM `user` t0 WHERE t0.id = 863;

SELECT
  DISTINCT t0_.id AS id_0
FROM
  subject s1_
  LEFT JOIN `user` u2_ ON s1_.prof_id = u2_.id
  LEFT JOIN the_class t0_ ON s1_.classe_id = t0_.id
WHERE
  u2_.id = ?

SELECT DISTINCT t0_.id AS id_0 FROM subject s1_ LEFT JOIN `user` u2_ ON s1_.prof_id = u2_.id LEFT JOIN the_class t0_ ON s1_.classe_id = t0_.id WHERE u2_.id = 863;

SELECT
  c0_.id AS id_0,
  c0_.created_at AS created_at_1,
  c0_.updated_at AS updated_at_2,
  c0_.initiator_id AS initiator_id_3,
  c0_.recipient_id AS recipient_id_4,
  c0_.year_id AS year_id_5
FROM
  chat c0_
  LEFT JOIN `user` u1_ ON c0_.initiator_id = u1_.id
  LEFT JOIN `user` u2_ ON c0_.recipient_id = u2_.id
  LEFT JOIN school_year s3_ ON c0_.year_id = s3_.id
  LEFT JOIN message m4_ ON c0_.id = m4_.chat_id
WHERE
  (
    u1_.id = ?
    OR u2_.id = ?
  )
  AND s3_.active = ?
ORDER BY
  m4_.created_at DESC

SELECT c0_.id AS id_0, c0_.created_at AS created_at_1, c0_.updated_at AS updated_at_2, c0_.initiator_id AS initiator_id_3, c0_.recipient_id AS recipient_id_4, c0_.year_id AS year_id_5 FROM chat c0_ LEFT JOIN `user` u1_ ON c0_.initiator_id = u1_.id LEFT JOIN `user` u2_ ON c0_.recipient_id = u2_.id LEFT JOIN school_year s3_ ON c0_.year_id = s3_.id LEFT JOIN message m4_ ON c0_.id = m4_.chat_id WHERE (u1_.id = 863 OR u2_.id = 863) AND s3_.active = 1 ORDER BY m4_.created_at DESC;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.active AS active_2,
  t0_.slug AS slug_3,
  t0_.created_at AS created_at_4,
  t0_.updated_at AS updated_at_5,
  s1_.id AS id_6,
  s1_.name AS name_7,
  s1_.created_at AS created_at_8,
  s1_.updated_at AS updated_at_9,
  t0_.section_id AS section_id_10,
  t0_.author_id AS author_id_11,
  t0_.editor_id AS editor_id_12,
  t0_.school_id AS school_id_13,
  t0_.prof_id AS prof_id_14,
  t0_.principal_prof_id AS principal_prof_id_15,
  s1_.author_id AS author_id_16,
  s1_.editor_id AS editor_id_17,
  s1_.school_id AS school_id_18
FROM
  the_class t0_
  LEFT JOIN school_section s1_ ON t0_.section_id = s1_.id
ORDER BY
  t0_.name DESC

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.active AS active_2, t0_.slug AS slug_3, t0_.created_at AS created_at_4, t0_.updated_at AS updated_at_5, s1_.id AS id_6, s1_.name AS name_7, s1_.created_at AS created_at_8, s1_.updated_at AS updated_at_9, t0_.section_id AS section_id_10, t0_.author_id AS author_id_11, t0_.editor_id AS editor_id_12, t0_.school_id AS school_id_13, t0_.prof_id AS prof_id_14, t0_.principal_prof_id AS principal_prof_id_15, s1_.author_id AS author_id_16, s1_.editor_id AS editor_id_17, s1_.school_id AS school_id_18 FROM the_class t0_ LEFT JOIN school_section s1_ ON t0_.section_id = s1_.id ORDER BY t0_.name DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.slug AS slug_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.section_id AS section_id_7,
  t0.author_id AS author_id_8,
  t0.editor_id AS editor_id_9,
  t0.school_id AS school_id_10,
  t0.prof_id AS prof_id_11,
  t0.principal_prof_id AS principal_prof_id_12
FROM
  the_class t0
WHERE
  t0.school_id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.slug AS slug_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.section_id AS section_id_7, t0.author_id AS author_id_8, t0.editor_id AS editor_id_9, t0.school_id AS school_id_10, t0.prof_id AS prof_id_11, t0.principal_prof_id AS principal_prof_id_12 FROM the_class t0 WHERE t0.school_id = 1;

SELECT
  d0_.id AS id_0,
  d0_.created_at AS created_at_1,
  d0_.updated_at AS updated_at_2,
  d0_.user_a_id AS user_a_id_3,
  d0_.user_b_id AS user_b_id_4,
  d0_.school_id AS school_id_5,
  d0_.year_id AS year_id_6
FROM
  discussion d0_
  LEFT JOIN school_year s1_ ON d0_.year_id = s1_.id
WHERE
  (
    d0_.user_a_id = ?
    OR d0_.user_b_id = ?
  )
  AND d0_.school_id = ?
  AND s1_.active = ?
ORDER BY
  d0_.updated_at DESC

SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.updated_at AS updated_at_2, d0_.user_a_id AS user_a_id_3, d0_.user_b_id AS user_b_id_4, d0_.school_id AS school_id_5, d0_.year_id AS year_id_6 FROM discussion d0_ LEFT JOIN school_year s1_ ON d0_.year_id = s1_.id WHERE (d0_.user_a_id = 863 OR d0_.user_b_id = 863) AND d0_.school_id = 1 AND s1_.active = 1 ORDER BY d0_.updated_at DESC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.active AS active_3,
  t0.name_en AS name_en_4,
  t0.created_at AS created_at_5,
  t0.updated_at AS updated_at_6,
  t0.author_id AS author_id_7,
  t0.editor_id AS editor_id_8
FROM
  school_year t0
WHERE
  t0.active = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.active AS active_3, t0.name_en AS name_en_4, t0.created_at AS created_at_5, t0.updated_at AS updated_at_6, t0.author_id AS author_id_7, t0.editor_id AS editor_id_8 FROM school_year t0 WHERE t0.active = 1 LIMIT 1;

SELECT
  s0_.id AS id_0,
  s0_.image_name AS image_name_1,
  s0_.slug AS slug_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4,
  s0_.year_id AS year_id_5,
  s0_.student_id AS student_id_6,
  s0_.classe_id AS classe_id_7,
  s0_.school_id AS school_id_8,
  s0_.scolarity_id AS scolarity_id_9
FROM
  student_year s0_
  LEFT JOIN student s1_ ON s0_.student_id = s1_.id
  LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id
  LEFT JOIN school s3_ ON s0_.school_id = s3_.id
WHERE
  s1_.parent_id = ?
  AND s2_.active = ?
  AND s3_.id = ?

SELECT s0_.id AS id_0, s0_.image_name AS image_name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4, s0_.year_id AS year_id_5, s0_.student_id AS student_id_6, s0_.classe_id AS classe_id_7, s0_.school_id AS school_id_8, s0_.scolarity_id AS scolarity_id_9 FROM student_year s0_ LEFT JOIN student s1_ ON s0_.student_id = s1_.id LEFT JOIN school_year s2_ ON s0_.year_id = s2_.id LEFT JOIN school s3_ ON s0_.school_id = s3_.id WHERE s1_.parent_id = 863 AND s2_.active = 1 AND s3_.id = 1;

SELECT
  d0_.id AS id_0,
  d0_.created_at AS created_at_1,
  d0_.updated_at AS updated_at_2,
  d0_.classe_id AS classe_id_3,
  d0_.year_id AS year_id_4,
  d0_.school_id AS school_id_5
FROM
  discussion_class d0_
  LEFT JOIN school_year s1_ ON d0_.year_id = s1_.id
WHERE
  d0_.classe_id IN (?)
  AND s1_.active = ?

SELECT d0_.id AS id_0, d0_.created_at AS created_at_1, d0_.updated_at AS updated_at_2, d0_.classe_id AS classe_id_3, d0_.year_id AS year_id_4, d0_.school_id AS school_id_5 FROM discussion_class d0_ LEFT JOIN school_year s1_ ON d0_.year_id = s1_.id WHERE d0_.classe_id IN (17) AND s1_.active = 1;

SELECT
  t0.id AS id_1,
  t0.absence_last_connection_count AS absence_last_connection_count_2,
  t0.late_last_connection_count AS late_last_connection_count_3,
  t0.homework_last_connection_count AS homework_last_connection_count_4,
  t0.note_last_connection_count AS note_last_connection_count_5,
  t0.blog_last_connection_count AS blog_last_connection_count_6,
  t0.event_last_connection_count AS event_last_connection_count_7,
  t0.discussion_message_last_connection_count AS discussion_message_last_connection_count_8,
  t0.punish_last_connection_count AS punish_last_connection_count_9,
  t0.doc_info_last_connection_count AS doc_info_last_connection_count_10,
  t0.message_group_last_connexion_count AS message_group_last_connexion_count_11,
  t0.created_at AS created_at_12,
  t0.updated_at AS updated_at_13,
  t0.user_id AS user_id_14,
  t0.year_id AS year_id_15
FROM
  notifications t0
WHERE
  t0.user_id = ?
  AND t0.year_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.absence_last_connection_count AS absence_last_connection_count_2, t0.late_last_connection_count AS late_last_connection_count_3, t0.homework_last_connection_count AS homework_last_connection_count_4, t0.note_last_connection_count AS note_last_connection_count_5, t0.blog_last_connection_count AS blog_last_connection_count_6, t0.event_last_connection_count AS event_last_connection_count_7, t0.discussion_message_last_connection_count AS discussion_message_last_connection_count_8, t0.punish_last_connection_count AS punish_last_connection_count_9, t0.doc_info_last_connection_count AS doc_info_last_connection_count_10, t0.message_group_last_connexion_count AS message_group_last_connexion_count_11, t0.created_at AS created_at_12, t0.updated_at AS updated_at_13, t0.user_id AS user_id_14, t0.year_id AS year_id_15 FROM notifications t0 WHERE t0.user_id = 863 AND t0.year_id = 3 LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.file_name AS file_name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.discussion_id AS discussion_id_6,
  t0.author_id AS author_id_7,
  t0.reply_to_message_id AS reply_to_message_id_8
FROM
  discussion_class_message t0
WHERE
  t0.discussion_id = ?

SELECT t0.id AS id_1, t0.message AS message_2, t0.file_name AS file_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.discussion_id AS discussion_id_6, t0.author_id AS author_id_7, t0.reply_to_message_id AS reply_to_message_id_8 FROM discussion_class_message t0 WHERE t0.discussion_id = 54;

SELECT
  t0.id AS id_1,
  t0.message_count AS message_count_2,
  t0.created_at AS created_at_3,
  t0.updated_at AS updated_at_4,
  t0.user_id AS user_id_5,
  t0.discussion_id AS discussion_id_6
FROM
  discussion_messages_count t0
WHERE
  t0.user_id = ?
  AND t0.discussion_id = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.message_count AS message_count_2, t0.created_at AS created_at_3, t0.updated_at AS updated_at_4, t0.user_id AS user_id_5, t0.discussion_id AS discussion_id_6 FROM discussion_messages_count t0 WHERE t0.user_id = 863 AND t0.discussion_id = 54 LIMIT 1;

"START TRANSACTION"

"START TRANSACTION";

INSERT INTO discussion_messages_count (
  message_count, created_at, updated_at,
  user_id, discussion_id
)
VALUES
  (?, ?, ?, ?, ?)

INSERT INTO discussion_messages_count (message_count, created_at, updated_at, user_id, discussion_id) VALUES (0, '2025-12-06 07:22:02', '2025-12-06 07:22:02', 863, 54);

"COMMIT"

"COMMIT";

SELECT
  t0.id AS id_1,
  t0.message AS message_2,
  t0.file_name AS file_name_3,
  t0.created_at AS created_at_4,
  t0.updated_at AS updated_at_5,
  t0.discussion_id AS discussion_id_6,
  t0.author_id AS author_id_7,
  t0.reply_to_message_id AS reply_to_message_id_8
FROM
  discussion_class_message t0
WHERE
  t0.discussion_id = ?

SELECT t0.id AS id_1, t0.message AS message_2, t0.file_name AS file_name_3, t0.created_at AS created_at_4, t0.updated_at AS updated_at_5, t0.discussion_id AS discussion_id_6, t0.author_id AS author_id_7, t0.reply_to_message_id AS reply_to_message_id_8 FROM discussion_class_message t0 WHERE t0.discussion_id = 54;