Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.roles AS roles_3,
  t0.password AS password_4,
  t0.last_login_at AS last_login_at_5,
  t0.last_logout_at AS last_logout_at_6,
  t0.description AS description_7,
  t0.lastname AS lastname_8,
  t0.firstname AS firstname_9,
  t0.is_first_connexion AS is_first_connexion_10,
  t0.registration_number AS registration_number_11,
  t0.hierarchical_level AS hierarchical_level_12,
  t0.phone_number AS phone_number_13,
  t0.status AS status_14,
  t0.active AS active_15,
  t0.referent AS referent_16,
  t0.entry_date AS entry_date_17,
  t0.activation_code AS activation_code_18,
  t0.activation_code_expired_at AS activation_code_expired_at_19,
  t0.reset_code AS reset_code_20,
  t0.reset_code_expired_at AS reset_code_expired_at_21,
  t0.device_tokens AS device_tokens_22,
  t0.is_verified AS is_verified_23,
  t0.profile_color AS profile_color_24,
  t0.is_internal_account AS is_internal_account_25,
  t0.elapsed_time AS elapsed_time_26,
  t0.last_login_notified_at AS last_login_notified_at_27,
  t0.country_id AS country_id_28,
  t0.module_id AS module_id_29,
  t0.subsidiary_company_id AS subsidiary_company_id_30,
  t0.job_id AS job_id_31,
  t0.office_id AS office_id_32,
  t0.contract_id AS contract_id_33,
  t0.photo_id AS photo_id_34,
  t0.responsible_id AS responsible_id_35
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.last_login_at AS last_login_at_5, t0.last_logout_at AS last_logout_at_6, t0.description AS description_7, t0.lastname AS lastname_8, t0.firstname AS firstname_9, t0.is_first_connexion AS is_first_connexion_10, t0.registration_number AS registration_number_11, t0.hierarchical_level AS hierarchical_level_12, t0.phone_number AS phone_number_13, t0.status AS status_14, t0.active AS active_15, t0.referent AS referent_16, t0.entry_date AS entry_date_17, t0.activation_code AS activation_code_18, t0.activation_code_expired_at AS activation_code_expired_at_19, t0.reset_code AS reset_code_20, t0.reset_code_expired_at AS reset_code_expired_at_21, t0.device_tokens AS device_tokens_22, t0.is_verified AS is_verified_23, t0.profile_color AS profile_color_24, t0.is_internal_account AS is_internal_account_25, t0.elapsed_time AS elapsed_time_26, t0.last_login_notified_at AS last_login_notified_at_27, t0.country_id AS country_id_28, t0.module_id AS module_id_29, t0.subsidiary_company_id AS subsidiary_company_id_30, t0.job_id AS job_id_31, t0.office_id AS office_id_32, t0.contract_id AS contract_id_33, t0.photo_id AS photo_id_34, t0.responsible_id AS responsible_id_35 FROM `user` t0 WHERE t0.id = 704;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.description AS description_2,
  l0_.type AS type_3,
  l0_.is_all_jobs AS is_all_jobs_4,
  l0_.is_all_offices AS is_all_offices_5,
  l0_.is_all_contracts AS is_all_contracts_6,
  l0_.is_all_subsidiary_companies AS is_all_subsidiary_companies_7,
  l0_.is_published AS is_published_8,
  l0_.knowledges AS knowledges_9,
  l0_.start_at AS start_at_10,
  l0_.end_at AS end_at_11,
  l0_.slug AS slug_12,
  l0_.time AS time_13,
  l0_.is_do_not_miss AS is_do_not_miss_14,
  l0_.reject_reason AS reject_reason_15,
  l0_.current_place AS current_place_16,
  l0_.review_reason AS review_reason_17,
  l0_.starting_notification_sent AS starting_notification_sent_18,
  l0_.created_at AS created_at_19,
  l0_.updated_at AS updated_at_20,
  l0_.cover_id AS cover_id_21,
  l0_.created_by AS created_by_22
FROM
  live l0_
  LEFT JOIN live_module l2_ ON l0_.id = l2_.live_id
  LEFT JOIN module m1_ ON m1_.id = l2_.module_id
  AND (m1_.is_published = 1)
  LEFT JOIN program_module p4_ ON m1_.id = p4_.module_id
  LEFT JOIN program p3_ ON p3_.id = p4_.program_id
  LEFT JOIN program_participation p5_ ON p3_.id = p5_.program_id
  LEFT JOIN `user` u6_ ON l0_.created_by = u6_.id
WHERE
  (
    (
      l0_.type = ?
      AND (
        l0_.is_published = 1
        AND p5_.created_by = ?
      )
      AND (
        p3_.id IS NOT NULL
        AND DATE(p3_.start_at) <= CURRENT_DATE
        AND DATE(p3_.end_at) >= CURRENT_DATE
      )
    )
    OR (
      u6_.id = ?
      OR EXISTS (
        SELECT
          1
        FROM
          module_user m7_
        WHERE
          m7_.module_id = m1_.id
          AND m7_.user_id IN (?)
      )
    )
  )
  AND l0_.start_at <= ?
  AND l0_.end_at >= ?
ORDER BY
  l0_.id DESC

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.type AS type_3, l0_.is_all_jobs AS is_all_jobs_4, l0_.is_all_offices AS is_all_offices_5, l0_.is_all_contracts AS is_all_contracts_6, l0_.is_all_subsidiary_companies AS is_all_subsidiary_companies_7, l0_.is_published AS is_published_8, l0_.knowledges AS knowledges_9, l0_.start_at AS start_at_10, l0_.end_at AS end_at_11, l0_.slug AS slug_12, l0_.time AS time_13, l0_.is_do_not_miss AS is_do_not_miss_14, l0_.reject_reason AS reject_reason_15, l0_.current_place AS current_place_16, l0_.review_reason AS review_reason_17, l0_.starting_notification_sent AS starting_notification_sent_18, l0_.created_at AS created_at_19, l0_.updated_at AS updated_at_20, l0_.cover_id AS cover_id_21, l0_.created_by AS created_by_22 FROM live l0_ LEFT JOIN live_module l2_ ON l0_.id = l2_.live_id LEFT JOIN module m1_ ON m1_.id = l2_.module_id AND (m1_.is_published = 1) LEFT JOIN program_module p4_ ON m1_.id = p4_.module_id LEFT JOIN program p3_ ON p3_.id = p4_.program_id LEFT JOIN program_participation p5_ ON p3_.id = p5_.program_id LEFT JOIN `user` u6_ ON l0_.created_by = u6_.id WHERE ((l0_.type = 'live' AND (l0_.is_published = 1 AND p5_.created_by = 704) AND (p3_.id IS NOT NULL AND DATE(p3_.start_at) <= CURRENT_DATE AND DATE(p3_.end_at) >= CURRENT_DATE)) OR (u6_.id = 704 OR EXISTS (SELECT 1 FROM module_user m7_ WHERE m7_.module_id = m1_.id AND m7_.user_id IN (704)))) AND l0_.start_at <= '2025-01-06 09:58:29' AND l0_.end_at >= '2025-01-06 09:58:29' ORDER BY l0_.id DESC;