| 1 |
0.63 ms |
SELECT d0_.id AS id_0, d0_.first_name AS first_name_1, d0_.last_name AS last_name_2, d0_.phone AS phone_3, d0_.bio AS bio_4, d0_.photo_filename AS photo_filename_5, d0_.consultation_price AS consultation_price_6, d0_.is_verified AS is_verified_7, d0_.created_at AS created_at_8, u1_.id AS id_9, u1_.email AS email_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.phone AS phone_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.is_active AS is_active_16, u1_.created_at AS created_at_17, u1_.updated_at AS updated_at_18, s2_.id AS id_19, s2_.name AS name_20, s2_.slug AS slug_21, s2_.description AS description_22, m3_.id AS id_23, m3_.name AS name_24, m3_.slug AS slug_25, m3_.address AS address_26, m3_.city AS city_27, m3_.phone AS phone_28, m3_.email AS email_29, m3_.description AS description_30, d0_.user_id AS user_id_31, d0_.specialty_id AS specialty_id_32, d0_.medical_center_id AS medical_center_id_33 FROM doctor d0_ INNER JOIN `user` u1_ ON d0_.user_id = u1_.id INNER JOIN specialty s2_ ON d0_.specialty_id = s2_.id INNER JOIN medical_center m3_ ON d0_.medical_center_id = m3_.id WHERE d0_.is_verified = ? ORDER BY d0_.last_name ASC, d0_.first_name ASC
SELECT d0_.id AS id_0, d0_.first_name AS first_name_1, d0_.last_name AS last_name_2, d0_.phone AS phone_3, d0_.bio AS bio_4, d0_.photo_filename AS photo_filename_5, d0_.consultation_price AS consultation_price_6, d0_.is_verified AS is_verified_7, d0_.created_at AS created_at_8, u1_.id AS id_9, u1_.email AS email_10, u1_.first_name AS first_name_11, u1_.last_name AS last_name_12, u1_.phone AS phone_13, u1_.roles AS roles_14, u1_.password AS password_15, u1_.is_active AS is_active_16, u1_.created_at AS created_at_17, u1_.updated_at AS updated_at_18, s2_.id AS id_19, s2_.name AS name_20, s2_.slug AS slug_21, s2_.description AS description_22, m3_.id AS id_23, m3_.name AS name_24, m3_.slug AS slug_25, m3_.address AS address_26, m3_.city AS city_27, m3_.phone AS phone_28, m3_.email AS email_29, m3_.description AS description_30, d0_.user_id AS user_id_31, d0_.specialty_id AS specialty_id_32, d0_.medical_center_id AS medical_center_id_33 FROM doctor d0_ INNER JOIN `user` u1_ ON d0_.user_id = u1_.id INNER JOIN specialty s2_ ON d0_.specialty_id = s2_.id INNER JOIN medical_center m3_ ON d0_.medical_center_id = m3_.id WHERE d0_.is_verified = 1 ORDER BY d0_.last_name ASC, d0_.first_name ASC;
|
| 2 |
0.27 ms |
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = 8;
|
| 3 |
0.23 ms |
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = 6;
|
| 4 |
0.20 ms |
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = 7;
|
| 5 |
0.24 ms |
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = ?
SELECT t0.id AS id_1, t0.birth_date AS birth_date_2, t0.gender AS gender_3, t0.address AS address_4, t0.city AS city_5, t0.phone AS phone_6, t0.created_at AS created_at_7, t0.user_id AS user_id_8 FROM patient t0 WHERE t0.user_id = 10;
|
| 6 |
0.25 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.slug AS slug_3, t0.description AS description_4 FROM specialty t0 ORDER BY t0.name 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 ORDER BY t0.name ASC;
|
| 7 |
0.21 ms |
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 ORDER BY t0.name ASC
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 ORDER BY t0.name ASC;
|
| 8 |
0.37 ms |
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;
|