0.48 ms (100.00%)
|
1 |
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.email = ? LIMIT 1
Parameters: [
"issoufyankine@gmail.com"
]
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.email = 'issoufyankine@gmail.com' LIMIT 1;
|