Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.identification_number AS identification_number_5,
  t0.diplomas AS diplomas_6,
  t0.refund AS refund_7,
  t0.image_name AS image_name_8,
  t0.updated_at AS updated_at_9,
  t10.id AS id_11,
  t10.mail AS mail_12,
  t10.mobile AS mobile_13,
  t10.create_date AS create_date_14,
  t10.archive_date AS archive_date_15,
  t10.last_login_date AS last_login_date_16,
  t10.status AS status_17,
  t10.slug AS slug_18,
  t10.roles AS roles_19,
  t10.password AS password_20,
  t10.is_verified AS is_verified_21,
  t10.firstname AS firstname_22,
  t10.lastname AS lastname_23,
  t10.patient_id AS patient_id_24,
  t10.medecin_id AS medecin_id_25
FROM
  medecin t0
  LEFT JOIN `user` t10 ON t10.medecin_id = t0.id
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.diplomas AS diplomas_6, t0.refund AS refund_7, t0.image_name AS image_name_8, t0.updated_at AS updated_at_9, t10.id AS id_11, t10.mail AS mail_12, t10.mobile AS mobile_13, t10.create_date AS create_date_14, t10.archive_date AS archive_date_15, t10.last_login_date AS last_login_date_16, t10.status AS status_17, t10.slug AS slug_18, t10.roles AS roles_19, t10.password AS password_20, t10.is_verified AS is_verified_21, t10.firstname AS firstname_22, t10.lastname AS lastname_23, t10.patient_id AS patient_id_24, t10.medecin_id AS medecin_id_25 FROM medecin t0 LEFT JOIN `user` t10 ON t10.medecin_id = t0.id WHERE t0.slug = 'Claude-ARNOLD-51288e71' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.firstname AS firstname_3,
  t0.lastname AS lastname_4,
  t0.identification_number AS identification_number_5,
  t0.medecin_id AS medecin_id_6,
  t0.user_id AS user_id_7
FROM
  medecin_substitute t0
WHERE
  t0.user_id = ?

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.firstname AS firstname_3, t0.lastname AS lastname_4, t0.identification_number AS identification_number_5, t0.medecin_id AS medecin_id_6, t0.user_id AS user_id_7 FROM medecin_substitute t0 WHERE t0.user_id = 17;

SELECT
  t0.id AS id_1,
  t0.slug AS slug_2,
  t0.duration AS duration_3,
  t0.slot_open_time AS slot_open_time_4,
  t0.slot_close_time AS slot_close_time_5,
  t0.notifications AS notifications_6,
  t0.delay_acceptance AS delay_acceptance_7,
  t0.available_online AS available_online_8,
  t0.medecin_id AS medecin_id_9,
  t0.cabinet_id AS cabinet_id_10,
  t0.specialities_id AS specialities_id_11,
  t0.consultation_type_id AS consultation_type_id_12
FROM
  medecin_specialities t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.slug AS slug_2, t0.duration AS duration_3, t0.slot_open_time AS slot_open_time_4, t0.slot_close_time AS slot_close_time_5, t0.notifications AS notifications_6, t0.delay_acceptance AS delay_acceptance_7, t0.available_online AS available_online_8, t0.medecin_id AS medecin_id_9, t0.cabinet_id AS cabinet_id_10, t0.specialities_id AS specialities_id_11, t0.consultation_type_id AS consultation_type_id_12 FROM medecin_specialities t0 WHERE t0.slug = '5468a1cd' LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-01-19 00:00:00') AND ('2026-01-24 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-01-26 00:00:00') AND ('2026-01-31 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-02-02 00:00:00') AND ('2026-02-07 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-02-09 00:00:00') AND ('2026-02-14 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-02-16 00:00:00') AND ('2026-02-21 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-02-23 00:00:00') AND ('2026-02-28 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-03-02 00:00:00') AND ('2026-03-07 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-03-09 00:00:00') AND ('2026-03-14 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;

SELECT
  c0_.id AS id_0,
  c0_.date AS date_1,
  c0_.start_time AS start_time_2,
  c0_.end_time AS end_time_3,
  c0_.time_interval AS time_interval_4,
  c0_.medecin_id AS medecin_id_5,
  c0_.model_id AS model_id_6,
  c0_.model_repeat_id AS model_repeat_id_7
FROM
  calendar_time_slot c0_
  INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id
  INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id
WHERE
  m1_.id = ?
  AND (
    c0_.date BETWEEN (?)
    AND (?)
  )
  AND c0_.medecin_id = ?
ORDER BY
  c0_.date ASC,
  c0_.start_time ASC

SELECT c0_.id AS id_0, c0_.date AS date_1, c0_.start_time AS start_time_2, c0_.end_time AS end_time_3, c0_.time_interval AS time_interval_4, c0_.medecin_id AS medecin_id_5, c0_.model_id AS model_id_6, c0_.model_repeat_id AS model_repeat_id_7 FROM calendar_time_slot c0_ INNER JOIN calendar_time_slot_medecin_specialities c2_ ON c0_.id = c2_.calendar_time_slot_id INNER JOIN medecin_specialities m1_ ON m1_.id = c2_.medecin_specialities_id WHERE m1_.id = 1 AND (c0_.date BETWEEN ('2026-03-16 00:00:00') AND ('2026-03-21 00:00:00')) AND c0_.medecin_id = 6 ORDER BY c0_.date ASC, c0_.start_time ASC;