Symfony Profiler

SELECT
  u0_.id AS id_0,
  c1_.idCustomer AS idCustomer_1,
  c1_.company AS company_2,
  u0_.email AS email_3,
  s2_.title AS title_4,
  s2_.location AS location_5,
  s2_.start_time AS start_time_6,
  s2_.stage_date AS stage_date_7,
  u0_.first_name AS first_name_8,
  u0_.last_name AS last_name_9,
  u0_.id AS id_10,
  u3_.id_session_stage AS id_session_stage_11
FROM
  session_stage s2_,
  course_session c4_,
  user_session u5_,
  `user` u0_,
  user_attendance u3_,
  customer c1_
WHERE
  s2_.id_course_session = c4_.idCourseSession
  AND u5_.id_course_session = c4_.idCourseSession
  AND u0_.id = u5_.id_user
  AND u3_.id_session_stage = s2_.idSessionStage
  AND c1_.idCustomer = u0_.id_customer
  AND DATE_FORMAT(
    CONCAT(
      SUBSTRING(
        s2_.stage_date
        FROM
          1 FOR 10
      ),
      ' ',
      SUBSTRING(
        s2_.start_time
        FROM
          12 FOR 20
      )
    ),
    '%Y-%m-%d %H:%i:%S'
  ) <= '2026-05-07 10:30:01'
  AND u0_.id_user_profil = (
    SELECT
      u6_.idUserProfil
    FROM
      user_profil u6_
    WHERE
      u6_.profil = 'student'
  )
  AND s2_.is_active = 1
  AND u3_.id_user = u0_.id
  AND u0_.is_active = 1
  AND (
    u3_.attendance IS NULL
    OR u3_.attendance = 'N'
  )
  AND (
    u3_.email_sent IS NULL
    OR u3_.email_sent = 0
  )

SELECT u0_.id AS id_0, c1_.idCustomer AS idCustomer_1, c1_.company AS company_2, u0_.email AS email_3, s2_.title AS title_4, s2_.location AS location_5, s2_.start_time AS start_time_6, s2_.stage_date AS stage_date_7, u0_.first_name AS first_name_8, u0_.last_name AS last_name_9, u0_.id AS id_10, u3_.id_session_stage AS id_session_stage_11 FROM session_stage s2_, course_session c4_, user_session u5_, `user` u0_, user_attendance u3_, customer c1_ WHERE s2_.id_course_session = c4_.idCourseSession AND u5_.id_course_session = c4_.idCourseSession AND u0_.id = u5_.id_user AND u3_.id_session_stage = s2_.idSessionStage AND c1_.idCustomer = u0_.id_customer AND DATE_FORMAT(CONCAT(SUBSTRING(s2_.stage_date FROM 1 FOR 10), ' ', SUBSTRING(s2_.start_time FROM 12 FOR 20)), '%Y-%m-%d %H:%i:%S') <= '2026-05-07 10:30:01' AND u0_.id_user_profil = (SELECT u6_.idUserProfil FROM user_profil u6_ WHERE u6_.profil = 'student') AND s2_.is_active = 1 AND u3_.id_user = u0_.id AND u0_.is_active = 1 AND (u3_.attendance IS NULL OR u3_.attendance = 'N') AND (u3_.email_sent IS NULL OR u3_.email_sent = 0);