| 1 |
0.24 ms |
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.setting_key = ? LIMIT 1
Parameters: [
"maintenance_mode"
]
SELECT t0.id AS id_1, t0.setting_key AS setting_key_2, t0.setting_value AS setting_value_3, t0.setting_type AS setting_type_4, t0.setting_group AS setting_group_5, t0.label AS label_6, t0.description AS description_7, t0.updated_at AS updated_at_8 FROM setting t0 WHERE t0.setting_key = 'maintenance_mode' LIMIT 1;
|
| 2 |
0.45 ms |
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.address AS address_6, t0.city AS city_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.languages AS languages_10, t0.transport_info AS transport_info_11, t0.transport_info_en AS transport_info_en_12, t0.payment_methods AS payment_methods_13, t0.subscription_plan AS subscription_plan_14, t0.salon_type AS salon_type_15, t0.salon_categories AS salon_categories_16, t0.is_verified AS is_verified_17, t0.is_active AS is_active_18, t0.offer_home_visit AS offer_home_visit_19, t0.home_visit_radius AS home_visit_radius_20, t0.staff_appointment_management AS staff_appointment_management_21, t0.phone AS phone_22, t0.website AS website_23, t0.instagram AS instagram_24, t0.facebook AS facebook_25, t0.tiktok AS tiktok_26, t0.created_at AS created_at_27, t0.user_id AS user_id_28 FROM barber_profile t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters: [
"daliahajama"
1
]
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.address AS address_6, t0.city AS city_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.languages AS languages_10, t0.transport_info AS transport_info_11, t0.transport_info_en AS transport_info_en_12, t0.payment_methods AS payment_methods_13, t0.subscription_plan AS subscription_plan_14, t0.salon_type AS salon_type_15, t0.salon_categories AS salon_categories_16, t0.is_verified AS is_verified_17, t0.is_active AS is_active_18, t0.offer_home_visit AS offer_home_visit_19, t0.home_visit_radius AS home_visit_radius_20, t0.staff_appointment_management AS staff_appointment_management_21, t0.phone AS phone_22, t0.website AS website_23, t0.instagram AS instagram_24, t0.facebook AS facebook_25, t0.tiktok AS tiktok_26, t0.created_at AS created_at_27, t0.user_id AS user_id_28 FROM barber_profile t0 WHERE t0.slug = 'daliahajama' AND t0.is_active = 1 LIMIT 1;
|
| 3 |
0.31 ms |
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = 62 AND r0_.is_hidden = 0;
|
| 4 |
0.15 ms |
SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = 62 AND r0_.is_hidden = 0;
|
| 5 |
0.18 ms |
SELECT r0_.rating AS rating_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 GROUP BY r0_.rating
SELECT r0_.rating AS rating_0, COUNT(r0_.id) AS sclr_1 FROM review r0_ WHERE r0_.barber_profile_id = 62 AND r0_.is_hidden = 0 GROUP BY r0_.rating;
|
| 6 |
0.31 ms |
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.sub_category AS sub_category_4, t0.audience AS audience_5, t0.duration_minutes AS duration_minutes_6, t0.duration_max_minutes AS duration_max_minutes_7, t0.price AS price_8, t0.description_fr AS description_fr_9, t0.description_en AS description_en_10, t0.happy_hours_discount AS happy_hours_discount_11, t0.happy_hours_slot AS happy_hours_slot_12, t0.is_active AS is_active_13, t0.barber_profile_id AS barber_profile_id_14 FROM service t0 WHERE t0.barber_profile_id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.category AS category_3, t0.sub_category AS sub_category_4, t0.audience AS audience_5, t0.duration_minutes AS duration_minutes_6, t0.duration_max_minutes AS duration_max_minutes_7, t0.price AS price_8, t0.description_fr AS description_fr_9, t0.description_en AS description_en_10, t0.happy_hours_discount AS happy_hours_discount_11, t0.happy_hours_slot AS happy_hours_slot_12, t0.is_active AS is_active_13, t0.barber_profile_id AS barber_profile_id_14 FROM service t0 WHERE t0.barber_profile_id = 62;
|
| 7 |
0.30 ms |
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description_fr AS description_fr_3, b0_.description_en AS description_en_4, b0_.address AS address_5, b0_.city AS city_6, b0_.latitude AS latitude_7, b0_.longitude AS longitude_8, b0_.languages AS languages_9, b0_.transport_info AS transport_info_10, b0_.transport_info_en AS transport_info_en_11, b0_.payment_methods AS payment_methods_12, b0_.subscription_plan AS subscription_plan_13, b0_.salon_type AS salon_type_14, b0_.salon_categories AS salon_categories_15, b0_.is_verified AS is_verified_16, b0_.is_active AS is_active_17, b0_.offer_home_visit AS offer_home_visit_18, b0_.home_visit_radius AS home_visit_radius_19, b0_.staff_appointment_management AS staff_appointment_management_20, b0_.phone AS phone_21, b0_.website AS website_22, b0_.instagram AS instagram_23, b0_.facebook AS facebook_24, b0_.tiktok AS tiktok_25, b0_.created_at AS created_at_26, b0_.user_id AS user_id_27 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> ? AND b0_.city = ? ORDER BY b0_.subscription_plan DESC LIMIT 4
Parameters: [
62
"city"
]
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description_fr AS description_fr_3, b0_.description_en AS description_en_4, b0_.address AS address_5, b0_.city AS city_6, b0_.latitude AS latitude_7, b0_.longitude AS longitude_8, b0_.languages AS languages_9, b0_.transport_info AS transport_info_10, b0_.transport_info_en AS transport_info_en_11, b0_.payment_methods AS payment_methods_12, b0_.subscription_plan AS subscription_plan_13, b0_.salon_type AS salon_type_14, b0_.salon_categories AS salon_categories_15, b0_.is_verified AS is_verified_16, b0_.is_active AS is_active_17, b0_.offer_home_visit AS offer_home_visit_18, b0_.home_visit_radius AS home_visit_radius_19, b0_.staff_appointment_management AS staff_appointment_management_20, b0_.phone AS phone_21, b0_.website AS website_22, b0_.instagram AS instagram_23, b0_.facebook AS facebook_24, b0_.tiktok AS tiktok_25, b0_.created_at AS created_at_26, b0_.user_id AS user_id_27 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> 62 AND b0_.city = 'city' ORDER BY b0_.subscription_plan DESC LIMIT 4;
|
| 8 |
0.28 ms |
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description_fr AS description_fr_3, b0_.description_en AS description_en_4, b0_.address AS address_5, b0_.city AS city_6, b0_.latitude AS latitude_7, b0_.longitude AS longitude_8, b0_.languages AS languages_9, b0_.transport_info AS transport_info_10, b0_.transport_info_en AS transport_info_en_11, b0_.payment_methods AS payment_methods_12, b0_.subscription_plan AS subscription_plan_13, b0_.salon_type AS salon_type_14, b0_.salon_categories AS salon_categories_15, b0_.is_verified AS is_verified_16, b0_.is_active AS is_active_17, b0_.offer_home_visit AS offer_home_visit_18, b0_.home_visit_radius AS home_visit_radius_19, b0_.staff_appointment_management AS staff_appointment_management_20, b0_.phone AS phone_21, b0_.website AS website_22, b0_.instagram AS instagram_23, b0_.facebook AS facebook_24, b0_.tiktok AS tiktok_25, b0_.created_at AS created_at_26, b0_.user_id AS user_id_27 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> ? AND b0_.salon_type = ? ORDER BY b0_.subscription_plan DESC LIMIT 4
Parameters: [
62
"mixed"
]
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description_fr AS description_fr_3, b0_.description_en AS description_en_4, b0_.address AS address_5, b0_.city AS city_6, b0_.latitude AS latitude_7, b0_.longitude AS longitude_8, b0_.languages AS languages_9, b0_.transport_info AS transport_info_10, b0_.transport_info_en AS transport_info_en_11, b0_.payment_methods AS payment_methods_12, b0_.subscription_plan AS subscription_plan_13, b0_.salon_type AS salon_type_14, b0_.salon_categories AS salon_categories_15, b0_.is_verified AS is_verified_16, b0_.is_active AS is_active_17, b0_.offer_home_visit AS offer_home_visit_18, b0_.home_visit_radius AS home_visit_radius_19, b0_.staff_appointment_management AS staff_appointment_management_20, b0_.phone AS phone_21, b0_.website AS website_22, b0_.instagram AS instagram_23, b0_.facebook AS facebook_24, b0_.tiktok AS tiktok_25, b0_.created_at AS created_at_26, b0_.user_id AS user_id_27 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> 62 AND b0_.salon_type = 'mixed' ORDER BY b0_.subscription_plan DESC LIMIT 4;
|
| 9 |
0.21 ms |
SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.is_active AS is_active_5, t0.barber_profile_id AS barber_profile_id_6, t0.staff_member_id AS staff_member_id_7 FROM availability t0 WHERE t0.barber_profile_id = ? ORDER BY t0.day_of_week ASC, t0.start_time ASC
SELECT t0.id AS id_1, t0.day_of_week AS day_of_week_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.is_active AS is_active_5, t0.barber_profile_id AS barber_profile_id_6, t0.staff_member_id AS staff_member_id_7 FROM availability t0 WHERE t0.barber_profile_id = 62 ORDER BY t0.day_of_week ASC, t0.start_time ASC;
|
| 10 |
0.12 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.id = 334;
|
| 11 |
0.10 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.id = 333;
|
| 12 |
0.18 ms |
SELECT COUNT(s0_.id) AS sclr_0 FROM special_closure s0_ WHERE s0_.barber_profile_id = ? AND s0_.start_date <= ? AND s0_.end_date >= ? AND s0_.staff_member_id IS NULL
Parameters: [
62
"2026-10-03"
"2026-10-03"
]
SELECT COUNT(s0_.id) AS sclr_0 FROM special_closure s0_ WHERE s0_.barber_profile_id = 62 AND s0_.start_date <= '2026-10-03' AND s0_.end_date >= '2026-10-03' AND s0_.staff_member_id IS NULL;
|
| 13 |
1.07 ms |
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.label_fr AS label_fr_2, s0_.label_en AS label_en_3, s0_.aliases AS aliases_4, s0_.position AS position_5, s0_.is_active AS is_active_6, s1_.id AS id_7, s1_.slug AS slug_8, s1_.label_fr AS label_fr_9, s1_.label_en AS label_en_10, s1_.prestations AS prestations_11, s1_.position AS position_12, s1_.category_id AS category_id_13 FROM service_category s0_ LEFT JOIN service_sub_category s1_ ON s0_.id = s1_.category_id WHERE s0_.is_active = 1 ORDER BY s0_.position ASC, s1_.position ASC
SELECT s0_.id AS id_0, s0_.slug AS slug_1, s0_.label_fr AS label_fr_2, s0_.label_en AS label_en_3, s0_.aliases AS aliases_4, s0_.position AS position_5, s0_.is_active AS is_active_6, s1_.id AS id_7, s1_.slug AS slug_8, s1_.label_fr AS label_fr_9, s1_.label_en AS label_en_10, s1_.prestations AS prestations_11, s1_.position AS position_12, s1_.category_id AS category_id_13 FROM service_category s0_ LEFT JOIN service_sub_category s1_ ON s0_.id = s1_.category_id WHERE s0_.is_active = 1 ORDER BY s0_.position ASC, s1_.position ASC;
|
| 14 |
0.19 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = 62 ORDER BY t0.sort_order ASC;
|
| 15 |
0.46 ms |
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.address AS address_6, t0.city AS city_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.languages AS languages_10, t0.transport_info AS transport_info_11, t0.transport_info_en AS transport_info_en_12, t0.payment_methods AS payment_methods_13, t0.subscription_plan AS subscription_plan_14, t0.salon_type AS salon_type_15, t0.salon_categories AS salon_categories_16, t0.is_verified AS is_verified_17, t0.is_active AS is_active_18, t0.offer_home_visit AS offer_home_visit_19, t0.home_visit_radius AS home_visit_radius_20, t0.staff_appointment_management AS staff_appointment_management_21, t0.phone AS phone_22, t0.website AS website_23, t0.instagram AS instagram_24, t0.facebook AS facebook_25, t0.tiktok AS tiktok_26, t0.created_at AS created_at_27, t0.user_id AS user_id_28 FROM barber_profile t0 WHERE t0.is_active = ?
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description_fr AS description_fr_4, t0.description_en AS description_en_5, t0.address AS address_6, t0.city AS city_7, t0.latitude AS latitude_8, t0.longitude AS longitude_9, t0.languages AS languages_10, t0.transport_info AS transport_info_11, t0.transport_info_en AS transport_info_en_12, t0.payment_methods AS payment_methods_13, t0.subscription_plan AS subscription_plan_14, t0.salon_type AS salon_type_15, t0.salon_categories AS salon_categories_16, t0.is_verified AS is_verified_17, t0.is_active AS is_active_18, t0.offer_home_visit AS offer_home_visit_19, t0.home_visit_radius AS home_visit_radius_20, t0.staff_appointment_management AS staff_appointment_management_21, t0.phone AS phone_22, t0.website AS website_23, t0.instagram AS instagram_24, t0.facebook AS facebook_25, t0.tiktok AS tiktok_26, t0.created_at AS created_at_27, t0.user_id AS user_id_28 FROM barber_profile t0 WHERE t0.is_active = 1;
|
| 16 |
0.45 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id 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.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.phone AS phone_7,
t0.avatar AS avatar_8,
t0.preferred_language AS preferred_language_9,
t0.created_at AS created_at_10,
t0.is_active AS is_active_11,
t0.is_verified AS is_verified_12,
t0.referral_code AS referral_code_13,
t0.wallet_balance AS wallet_balance_14,
t0.referred_by_id AS referred_by_id_15,
t16.id AS id_17,
t16.salon_name AS salon_name_18,
t16.slug AS slug_19,
t16.description_fr AS description_fr_20,
t16.description_en AS description_en_21,
t16.address AS address_22,
t16.city AS city_23,
t16.latitude AS latitude_24,
t16.longitude AS longitude_25,
t16.languages AS languages_26,
t16.transport_info AS transport_info_27,
t16.transport_info_en AS transport_info_en_28,
t16.payment_methods AS payment_methods_29,
t16.subscription_plan AS subscription_plan_30,
t16.salon_type AS salon_type_31,
t16.salon_categories AS salon_categories_32,
t16.is_verified AS is_verified_33,
t16.is_active AS is_active_34,
t16.offer_home_visit AS offer_home_visit_35,
t16.home_visit_radius AS home_visit_radius_36,
t16.staff_appointment_management AS staff_appointment_management_37,
t16.phone AS phone_38,
t16.website AS website_39,
t16.instagram AS instagram_40,
t16.facebook AS facebook_41,
t16.tiktok AS tiktok_42,
t16.created_at AS created_at_43,
t16.user_id AS user_id_44,
t45.id AS id_46,
t45.is_active AS is_active_47,
t45.created_at AS created_at_48,
t45.barber_profile_id AS barber_profile_id_49,
t45.user_id AS user_id_50
FROM
`user` t0
LEFT JOIN barber_profile t16 ON t16.user_id = t0.id
LEFT JOIN staff_member t45 ON t45.user_id = t0.id
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id WHERE t0.id = 944;
|
| 17 |
0.17 ms |
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.barber_profile_id = ? ORDER BY t0.id ASC
SELECT t0.id AS id_1, t0.is_active AS is_active_2, t0.created_at AS created_at_3, t0.barber_profile_id AS barber_profile_id_4, t0.user_id AS user_id_5 FROM staff_member t0 WHERE t0.barber_profile_id = 62 ORDER BY t0.id ASC;
|
| 18 |
0.30 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id 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.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.phone AS phone_7,
t0.avatar AS avatar_8,
t0.preferred_language AS preferred_language_9,
t0.created_at AS created_at_10,
t0.is_active AS is_active_11,
t0.is_verified AS is_verified_12,
t0.referral_code AS referral_code_13,
t0.wallet_balance AS wallet_balance_14,
t0.referred_by_id AS referred_by_id_15,
t16.id AS id_17,
t16.salon_name AS salon_name_18,
t16.slug AS slug_19,
t16.description_fr AS description_fr_20,
t16.description_en AS description_en_21,
t16.address AS address_22,
t16.city AS city_23,
t16.latitude AS latitude_24,
t16.longitude AS longitude_25,
t16.languages AS languages_26,
t16.transport_info AS transport_info_27,
t16.transport_info_en AS transport_info_en_28,
t16.payment_methods AS payment_methods_29,
t16.subscription_plan AS subscription_plan_30,
t16.salon_type AS salon_type_31,
t16.salon_categories AS salon_categories_32,
t16.is_verified AS is_verified_33,
t16.is_active AS is_active_34,
t16.offer_home_visit AS offer_home_visit_35,
t16.home_visit_radius AS home_visit_radius_36,
t16.staff_appointment_management AS staff_appointment_management_37,
t16.phone AS phone_38,
t16.website AS website_39,
t16.instagram AS instagram_40,
t16.facebook AS facebook_41,
t16.tiktok AS tiktok_42,
t16.created_at AS created_at_43,
t16.user_id AS user_id_44,
t45.id AS id_46,
t45.is_active AS is_active_47,
t45.created_at AS created_at_48,
t45.barber_profile_id AS barber_profile_id_49,
t45.user_id AS user_id_50
FROM
`user` t0
LEFT JOIN barber_profile t16 ON t16.user_id = t0.id
LEFT JOIN staff_member t45 ON t45.user_id = t0.id
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id WHERE t0.id = 975;
|
| 19 |
0.27 ms |
SELECT t0.id AS id_1, t0.email AS email_2, t0.roles AS roles_3, t0.password AS password_4, t0.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id 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.first_name AS first_name_5,
t0.last_name AS last_name_6,
t0.phone AS phone_7,
t0.avatar AS avatar_8,
t0.preferred_language AS preferred_language_9,
t0.created_at AS created_at_10,
t0.is_active AS is_active_11,
t0.is_verified AS is_verified_12,
t0.referral_code AS referral_code_13,
t0.wallet_balance AS wallet_balance_14,
t0.referred_by_id AS referred_by_id_15,
t16.id AS id_17,
t16.salon_name AS salon_name_18,
t16.slug AS slug_19,
t16.description_fr AS description_fr_20,
t16.description_en AS description_en_21,
t16.address AS address_22,
t16.city AS city_23,
t16.latitude AS latitude_24,
t16.longitude AS longitude_25,
t16.languages AS languages_26,
t16.transport_info AS transport_info_27,
t16.transport_info_en AS transport_info_en_28,
t16.payment_methods AS payment_methods_29,
t16.subscription_plan AS subscription_plan_30,
t16.salon_type AS salon_type_31,
t16.salon_categories AS salon_categories_32,
t16.is_verified AS is_verified_33,
t16.is_active AS is_active_34,
t16.offer_home_visit AS offer_home_visit_35,
t16.home_visit_radius AS home_visit_radius_36,
t16.staff_appointment_management AS staff_appointment_management_37,
t16.phone AS phone_38,
t16.website AS website_39,
t16.instagram AS instagram_40,
t16.facebook AS facebook_41,
t16.tiktok AS tiktok_42,
t16.created_at AS created_at_43,
t16.user_id AS user_id_44,
t45.id AS id_46,
t45.is_active AS is_active_47,
t45.created_at AS created_at_48,
t45.barber_profile_id AS barber_profile_id_49,
t45.user_id AS user_id_50
FROM
`user` t0
LEFT JOIN barber_profile t16 ON t16.user_id = t0.id
LEFT JOIN staff_member t45 ON t45.user_id = t0.id
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.first_name AS first_name_5, t0.last_name AS last_name_6, t0.phone AS phone_7, t0.avatar AS avatar_8, t0.preferred_language AS preferred_language_9, t0.created_at AS created_at_10, t0.is_active AS is_active_11, t0.is_verified AS is_verified_12, t0.referral_code AS referral_code_13, t0.wallet_balance AS wallet_balance_14, t0.referred_by_id AS referred_by_id_15, t16.id AS id_17, t16.salon_name AS salon_name_18, t16.slug AS slug_19, t16.description_fr AS description_fr_20, t16.description_en AS description_en_21, t16.address AS address_22, t16.city AS city_23, t16.latitude AS latitude_24, t16.longitude AS longitude_25, t16.languages AS languages_26, t16.transport_info AS transport_info_27, t16.transport_info_en AS transport_info_en_28, t16.payment_methods AS payment_methods_29, t16.subscription_plan AS subscription_plan_30, t16.salon_type AS salon_type_31, t16.salon_categories AS salon_categories_32, t16.is_verified AS is_verified_33, t16.is_active AS is_active_34, t16.offer_home_visit AS offer_home_visit_35, t16.home_visit_radius AS home_visit_radius_36, t16.staff_appointment_management AS staff_appointment_management_37, t16.phone AS phone_38, t16.website AS website_39, t16.instagram AS instagram_40, t16.facebook AS facebook_41, t16.tiktok AS tiktok_42, t16.created_at AS created_at_43, t16.user_id AS user_id_44, t45.id AS id_46, t45.is_active AS is_active_47, t45.created_at AS created_at_48, t45.barber_profile_id AS barber_profile_id_49, t45.user_id AS user_id_50 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t45 ON t45.user_id = t0.id WHERE t0.id = 976;
|
| 20 |
0.23 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = 4 ORDER BY t0.sort_order ASC;
|
| 21 |
0.20 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = 4;
|
| 22 |
0.16 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = 16 ORDER BY t0.sort_order ASC;
|
| 23 |
0.16 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = 16;
|
| 24 |
0.19 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = 41 ORDER BY t0.sort_order ASC;
|
| 25 |
0.15 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = 41;
|
| 26 |
0.34 ms |
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = ? ORDER BY t0.sort_order ASC
SELECT t0.id AS id_1, t0.filename AS filename_2, t0.is_cover AS is_cover_3, t0.sort_order AS sort_order_4, t0.barber_profile_id AS barber_profile_id_5 FROM profile_photo t0 WHERE t0.barber_profile_id = 43 ORDER BY t0.sort_order ASC;
|
| 27 |
0.14 ms |
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = ?
SELECT t0.id AS id_1, t0.rating AS rating_2, t0.rating_ambiance AS rating_ambiance_3, t0.rating_rapport_qp AS rating_rapport_qp_4, t0.rating_resultats AS rating_resultats_5, t0.comment AS comment_6, t0.is_hidden AS is_hidden_7, t0.is_reported AS is_reported_8, t0.professional_reply AS professional_reply_9, t0.replied_at AS replied_at_10, t0.created_at AS created_at_11, t0.client_id AS client_id_12, t0.barber_profile_id AS barber_profile_id_13, t0.appointment_id AS appointment_id_14 FROM review t0 WHERE t0.barber_profile_id = 43;
|