Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.phone AS phone_4,
  t0.bio AS bio_5,
  t0.photo_filename AS photo_filename_6,
  t0.consultation_price AS consultation_price_7,
  t0.is_verified AS is_verified_8,
  t0.created_at AS created_at_9,
  t0.user_id AS user_id_10,
  t0.specialty_id AS specialty_id_11,
  t0.medical_center_id AS medical_center_id_12
FROM
  doctor t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.phone AS phone_4, t0.bio AS bio_5, t0.photo_filename AS photo_filename_6, t0.consultation_price AS consultation_price_7, t0.is_verified AS is_verified_8, t0.created_at AS created_at_9, t0.user_id AS user_id_10, t0.specialty_id AS specialty_id_11, t0.medical_center_id AS medical_center_id_12 FROM doctor t0 WHERE t0.id = '7';

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 4 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  t0.id AS id_1,
  t0.appointment_date AS appointment_date_2,
  t0.appointment_time AS appointment_time_3,
  t0.status AS status_4,
  t0.reason AS reason_5,
  t0.created_at AS created_at_6,
  t0.patient_id AS patient_id_7,
  t0.doctor_id AS doctor_id_8
FROM
  appointment t0
WHERE
  t0.doctor_id = ?
  AND t0.appointment_date = ?

SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.appointment_time AS appointment_time_3, t0.status AS status_4, t0.reason AS reason_5, t0.created_at AS created_at_6, t0.patient_id AS patient_id_7, t0.doctor_id AS doctor_id_8 FROM appointment t0 WHERE t0.doctor_id = 7 AND t0.appointment_date = '2026-10-08';

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 1 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 2 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 3 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 4 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 5 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 6 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 7 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 1 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 2 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 3 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 4 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 5 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 6 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  a0_.id AS id_0,
  a0_.day_of_week AS day_of_week_1,
  a0_.start_time AS start_time_2,
  a0_.end_time AS end_time_3,
  a0_.is_active AS is_active_4,
  a0_.doctor_id AS doctor_id_5
FROM
  availability a0_
WHERE
  a0_.doctor_id = ?
  AND a0_.day_of_week = ?
  AND a0_.is_active = ?
ORDER BY
  a0_.start_time ASC

SELECT a0_.id AS id_0, a0_.day_of_week AS day_of_week_1, a0_.start_time AS start_time_2, a0_.end_time AS end_time_3, a0_.is_active AS is_active_4, a0_.doctor_id AS doctor_id_5 FROM availability a0_ WHERE a0_.doctor_id = 7 AND a0_.day_of_week = 7 AND a0_.is_active = 1 ORDER BY a0_.start_time ASC;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.description AS description_4
FROM
  specialty t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM specialty t0 WHERE t0.id = 13;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.slug AS slug_3,
  t0.address AS address_4,
  t0.city AS city_5,
  t0.phone AS phone_6,
  t0.email AS email_7,
  t0.description AS description_8
FROM
  medical_center t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.email AS email_7, t0.description AS description_8 FROM medical_center t0 WHERE t0.id = 4;

SELECT
  t0.id AS id_1,
  t0.email AS email_2,
  t0.first_name AS first_name_3,
  t0.last_name AS last_name_4,
  t0.phone AS phone_5,
  t0.roles AS roles_6,
  t0.password AS password_7,
  t0.is_active AS is_active_8,
  t0.created_at AS created_at_9,
  t0.updated_at AS updated_at_10,
  t11.id AS id_12,
  t11.birth_date AS birth_date_13,
  t11.gender AS gender_14,
  t11.address AS address_15,
  t11.city AS city_16,
  t11.phone AS phone_17,
  t11.created_at AS created_at_18,
  t11.user_id AS user_id_19,
  t20.id AS id_21,
  t20.first_name AS first_name_22,
  t20.last_name AS last_name_23,
  t20.phone AS phone_24,
  t20.bio AS bio_25,
  t20.photo_filename AS photo_filename_26,
  t20.consultation_price AS consultation_price_27,
  t20.is_verified AS is_verified_28,
  t20.created_at AS created_at_29,
  t20.user_id AS user_id_30,
  t20.specialty_id AS specialty_id_31,
  t20.medical_center_id AS medical_center_id_32
FROM
  `user` t0
  LEFT JOIN patient t11 ON t11.user_id = t0.id
  LEFT JOIN doctor t20 ON t20.user_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.email AS email_2, t0.first_name AS first_name_3, t0.last_name AS last_name_4, t0.phone AS phone_5, t0.roles AS roles_6, t0.password AS password_7, t0.is_active AS is_active_8, t0.created_at AS created_at_9, t0.updated_at AS updated_at_10, t11.id AS id_12, t11.birth_date AS birth_date_13, t11.gender AS gender_14, t11.address AS address_15, t11.city AS city_16, t11.phone AS phone_17, t11.created_at AS created_at_18, t11.user_id AS user_id_19, t20.id AS id_21, t20.first_name AS first_name_22, t20.last_name AS last_name_23, t20.phone AS phone_24, t20.bio AS bio_25, t20.photo_filename AS photo_filename_26, t20.consultation_price AS consultation_price_27, t20.is_verified AS is_verified_28, t20.created_at AS created_at_29, t20.user_id AS user_id_30, t20.specialty_id AS specialty_id_31, t20.medical_center_id AS medical_center_id_32 FROM `user` t0 LEFT JOIN patient t11 ON t11.user_id = t0.id LEFT JOIN doctor t20 ON t20.user_id = t0.id WHERE t0.id = 9;