GET https://lookwello.com/barbers/capitale-barber-18

Query Metrics

41 Database Queries
21 Different statements
7.41 ms Query time
0 Invalid entities
151 Managed entities

Queries

Group similar statements

#▲ Time Info
1 0.08 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"
]
2 0.41 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.slug = ? AND t0.is_active = ? LIMIT 1
Parameters:
[
  "capitale-barber-18"
  1
]
3 0.34 ms
SELECT AVG(r0_.rating) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
Parameters:
[
  19
]
4 0.15 ms
SELECT COUNT(r0_.id) AS sclr_0 FROM review r0_ WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0
Parameters:
[
  19
]
5 0.24 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
Parameters:
[
  19
]
6 0.29 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.duration_minutes AS duration_minutes_5, t0.duration_max_minutes AS duration_max_minutes_6, t0.price AS price_7, t0.description AS description_8, t0.happy_hours_discount AS happy_hours_discount_9, t0.happy_hours_slot AS happy_hours_slot_10, t0.is_active AS is_active_11, t0.barber_profile_id AS barber_profile_id_12 FROM service t0 WHERE t0.barber_profile_id = ?
Parameters:
[
  19
]
7 0.29 ms
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.address AS address_4, b0_.city AS city_5, b0_.latitude AS latitude_6, b0_.longitude AS longitude_7, b0_.languages AS languages_8, b0_.transport_info AS transport_info_9, b0_.payment_methods AS payment_methods_10, b0_.subscription_plan AS subscription_plan_11, b0_.salon_type AS salon_type_12, b0_.salon_categories AS salon_categories_13, b0_.is_verified AS is_verified_14, b0_.is_active AS is_active_15, b0_.offer_home_visit AS offer_home_visit_16, b0_.home_visit_radius AS home_visit_radius_17, b0_.staff_appointment_management AS staff_appointment_management_18, b0_.phone AS phone_19, b0_.website AS website_20, b0_.instagram AS instagram_21, b0_.facebook AS facebook_22, b0_.tiktok AS tiktok_23, b0_.created_at AS created_at_24, b0_.user_id AS user_id_25 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.id <> ? AND b0_.city = ? ORDER BY b0_.subscription_plan DESC LIMIT 4
Parameters:
[
  19
  "Ottawa"
]
8 0.25 ms
SELECT b0_.id AS id_0, b0_.salon_name AS salon_name_1, b0_.slug AS slug_2, b0_.description AS description_3, b0_.address AS address_4, b0_.city AS city_5, b0_.latitude AS latitude_6, b0_.longitude AS longitude_7, b0_.languages AS languages_8, b0_.transport_info AS transport_info_9, b0_.payment_methods AS payment_methods_10, b0_.subscription_plan AS subscription_plan_11, b0_.salon_type AS salon_type_12, b0_.salon_categories AS salon_categories_13, b0_.is_verified AS is_verified_14, b0_.is_active AS is_active_15, b0_.offer_home_visit AS offer_home_visit_16, b0_.home_visit_radius AS home_visit_radius_17, b0_.staff_appointment_management AS staff_appointment_management_18, b0_.phone AS phone_19, b0_.website AS website_20, b0_.instagram AS instagram_21, b0_.facebook AS facebook_22, b0_.tiktok AS tiktok_23, b0_.created_at AS created_at_24, b0_.user_id AS user_id_25 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:
[
  19
  "mixed"
]
9 0.17 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
Parameters:
[
  19
]
10 0.16 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:
[
  19
  "2026-10-02"
  "2026-10-02"
]
11 0.43 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
Parameters:
[
  19
]
12 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 AS description_20, t16.address AS address_21, t16.city AS city_22, t16.latitude AS latitude_23, t16.longitude AS longitude_24, t16.languages AS languages_25, t16.transport_info AS transport_info_26, t16.payment_methods AS payment_methods_27, t16.subscription_plan AS subscription_plan_28, t16.salon_type AS salon_type_29, t16.salon_categories AS salon_categories_30, t16.is_verified AS is_verified_31, t16.is_active AS is_active_32, t16.offer_home_visit AS offer_home_visit_33, t16.home_visit_radius AS home_visit_radius_34, t16.staff_appointment_management AS staff_appointment_management_35, t16.phone AS phone_36, t16.website AS website_37, t16.instagram AS instagram_38, t16.facebook AS facebook_39, t16.tiktok AS tiktok_40, t16.created_at AS created_at_41, t16.user_id AS user_id_42, t43.id AS id_44, t43.is_active AS is_active_45, t43.created_at AS created_at_46, t43.barber_profile_id AS barber_profile_id_47, t43.user_id AS user_id_48 FROM `user` t0 LEFT JOIN barber_profile t16 ON t16.user_id = t0.id LEFT JOIN staff_member t43 ON t43.user_id = t0.id WHERE t0.id = ?
Parameters:
[
  36
]
13 0.15 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
Parameters:
[
  19
]
14 0.49 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_10 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0) dctrn_result_inner ORDER BY created_at_10 DESC) dctrn_result LIMIT 10
Parameters:
[
  19
]
15 0.39 ms
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24, r0_.client_id AS client_id_25, r0_.barber_profile_id AS barber_profile_id_26, r0_.appointment_id AS appointment_id_27, u1_.referred_by_id AS referred_by_id_28 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.created_at DESC
Parameters:
[
  19
  59
  60
  62
  61
]
16 0.06 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.user_id = ?
Parameters:
[
  5
]
17 0.03 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.user_id = ?
Parameters:
[
  5
]
18 0.04 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.user_id = ?
Parameters:
[
  11
]
19 0.03 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.user_id = ?
Parameters:
[
  11
]
20 0.04 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.user_id = ?
Parameters:
[
  7
]
21 0.03 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.user_id = ?
Parameters:
[
  7
]
22 0.16 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.user_id = ?
Parameters:
[
  17
]
23 0.09 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.user_id = ?
Parameters:
[
  17
]
24 0.05 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_10 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0) dctrn_result_inner ORDER BY created_at_10 DESC) dctrn_result LIMIT 10
Parameters:
[
  19
]
25 0.06 ms
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24, r0_.client_id AS client_id_25, r0_.barber_profile_id AS barber_profile_id_26, r0_.appointment_id AS appointment_id_27, u1_.referred_by_id AS referred_by_id_28 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.created_at DESC
Parameters:
[
  19
  59
  60
  62
  61
]
26 0.20 ms
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.refusal_reason AS refusal_reason_6, t0.client_notes AS client_notes_7, t0.qr_code_token AS qr_code_token_8, t0.created_at AS created_at_9, t0.client_id AS client_id_10, t0.barber_profile_id AS barber_profile_id_11, t0.staff_member_id AS staff_member_id_12, t0.service_id AS service_id_13, t14.id AS id_15, t14.rating AS rating_16, t14.rating_ambiance AS rating_ambiance_17, t14.rating_rapport_qp AS rating_rapport_qp_18, t14.rating_resultats AS rating_resultats_19, t14.comment AS comment_20, t14.is_hidden AS is_hidden_21, t14.is_reported AS is_reported_22, t14.professional_reply AS professional_reply_23, t14.replied_at AS replied_at_24, t14.created_at AS created_at_25, t14.client_id AS client_id_26, t14.barber_profile_id AS barber_profile_id_27, t14.appointment_id AS appointment_id_28 FROM appointment t0 LEFT JOIN review t14 ON t14.appointment_id = t0.id WHERE t0.id = ?
Parameters:
[
  171
]
27 0.17 ms
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.refusal_reason AS refusal_reason_6, t0.client_notes AS client_notes_7, t0.qr_code_token AS qr_code_token_8, t0.created_at AS created_at_9, t0.client_id AS client_id_10, t0.barber_profile_id AS barber_profile_id_11, t0.staff_member_id AS staff_member_id_12, t0.service_id AS service_id_13, t14.id AS id_15, t14.rating AS rating_16, t14.rating_ambiance AS rating_ambiance_17, t14.rating_rapport_qp AS rating_rapport_qp_18, t14.rating_resultats AS rating_resultats_19, t14.comment AS comment_20, t14.is_hidden AS is_hidden_21, t14.is_reported AS is_reported_22, t14.professional_reply AS professional_reply_23, t14.replied_at AS replied_at_24, t14.created_at AS created_at_25, t14.client_id AS client_id_26, t14.barber_profile_id AS barber_profile_id_27, t14.appointment_id AS appointment_id_28 FROM appointment t0 LEFT JOIN review t14 ON t14.appointment_id = t0.id WHERE t0.id = ?
Parameters:
[
  172
]
28 0.16 ms
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.refusal_reason AS refusal_reason_6, t0.client_notes AS client_notes_7, t0.qr_code_token AS qr_code_token_8, t0.created_at AS created_at_9, t0.client_id AS client_id_10, t0.barber_profile_id AS barber_profile_id_11, t0.staff_member_id AS staff_member_id_12, t0.service_id AS service_id_13, t14.id AS id_15, t14.rating AS rating_16, t14.rating_ambiance AS rating_ambiance_17, t14.rating_rapport_qp AS rating_rapport_qp_18, t14.rating_resultats AS rating_resultats_19, t14.comment AS comment_20, t14.is_hidden AS is_hidden_21, t14.is_reported AS is_reported_22, t14.professional_reply AS professional_reply_23, t14.replied_at AS replied_at_24, t14.created_at AS created_at_25, t14.client_id AS client_id_26, t14.barber_profile_id AS barber_profile_id_27, t14.appointment_id AS appointment_id_28 FROM appointment t0 LEFT JOIN review t14 ON t14.appointment_id = t0.id WHERE t0.id = ?
Parameters:
[
  178
]
29 0.16 ms
SELECT t0.id AS id_1, t0.appointment_date AS appointment_date_2, t0.start_time AS start_time_3, t0.end_time AS end_time_4, t0.status AS status_5, t0.refusal_reason AS refusal_reason_6, t0.client_notes AS client_notes_7, t0.qr_code_token AS qr_code_token_8, t0.created_at AS created_at_9, t0.client_id AS client_id_10, t0.barber_profile_id AS barber_profile_id_11, t0.staff_member_id AS staff_member_id_12, t0.service_id AS service_id_13, t14.id AS id_15, t14.rating AS rating_16, t14.rating_ambiance AS rating_ambiance_17, t14.rating_rapport_qp AS rating_rapport_qp_18, t14.rating_resultats AS rating_resultats_19, t14.comment AS comment_20, t14.is_hidden AS is_hidden_21, t14.is_reported AS is_reported_22, t14.professional_reply AS professional_reply_23, t14.replied_at AS replied_at_24, t14.created_at AS created_at_25, t14.client_id AS client_id_26, t14.barber_profile_id AS barber_profile_id_27, t14.appointment_id AS appointment_id_28 FROM appointment t0 LEFT JOIN review t14 ON t14.appointment_id = t0.id WHERE t0.id = ?
Parameters:
[
  173
]
30 0.29 ms
SELECT COUNT(*) AS dctrn_count FROM (SELECT DISTINCT id_0 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 ORDER BY r0_.created_at DESC) dctrn_result) dctrn_table
Parameters:
[
  19
]
31 0.05 ms
SELECT DISTINCT id_0 FROM (SELECT DISTINCT id_0, created_at_10 FROM (SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0) dctrn_result_inner ORDER BY created_at_10 DESC) dctrn_result LIMIT 10
Parameters:
[
  19
]
32 0.06 ms
SELECT r0_.id AS id_0, r0_.rating AS rating_1, r0_.rating_ambiance AS rating_ambiance_2, r0_.rating_rapport_qp AS rating_rapport_qp_3, r0_.rating_resultats AS rating_resultats_4, r0_.comment AS comment_5, r0_.is_hidden AS is_hidden_6, r0_.is_reported AS is_reported_7, r0_.professional_reply AS professional_reply_8, r0_.replied_at AS replied_at_9, r0_.created_at AS created_at_10, u1_.id AS id_11, u1_.email AS email_12, u1_.roles AS roles_13, u1_.password AS password_14, u1_.first_name AS first_name_15, u1_.last_name AS last_name_16, u1_.phone AS phone_17, u1_.avatar AS avatar_18, u1_.preferred_language AS preferred_language_19, u1_.created_at AS created_at_20, u1_.is_active AS is_active_21, u1_.is_verified AS is_verified_22, u1_.referral_code AS referral_code_23, u1_.wallet_balance AS wallet_balance_24, r0_.client_id AS client_id_25, r0_.barber_profile_id AS barber_profile_id_26, r0_.appointment_id AS appointment_id_27, u1_.referred_by_id AS referred_by_id_28 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id WHERE r0_.barber_profile_id = ? AND r0_.is_hidden = 0 AND r0_.id IN (?, ?, ?, ?) ORDER BY r0_.created_at DESC
Parameters:
[
  19
  59
  60
  62
  61
]
33 0.27 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
Parameters:
[
  45
]
34 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 = ?
Parameters:
[
  45
]
35 0.13 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
Parameters:
[
  20
]
36 0.63 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 = ?
Parameters:
[
  20
]
37 0.05 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
Parameters:
[
  4
]
38 0.04 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 = ?
Parameters:
[
  4
]
39 0.04 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
Parameters:
[
  16
]
40 0.05 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 = ?
Parameters:
[
  16
]
41 0.07 ms
SELECT t0.id AS id_1, t0.salon_name AS salon_name_2, t0.slug AS slug_3, t0.description AS description_4, t0.address AS address_5, t0.city AS city_6, t0.latitude AS latitude_7, t0.longitude AS longitude_8, t0.languages AS languages_9, t0.transport_info AS transport_info_10, t0.payment_methods AS payment_methods_11, t0.subscription_plan AS subscription_plan_12, t0.salon_type AS salon_type_13, t0.salon_categories AS salon_categories_14, t0.is_verified AS is_verified_15, t0.is_active AS is_active_16, t0.offer_home_visit AS offer_home_visit_17, t0.home_visit_radius AS home_visit_radius_18, t0.staff_appointment_management AS staff_appointment_management_19, t0.phone AS phone_20, t0.website AS website_21, t0.instagram AS instagram_22, t0.facebook AS facebook_23, t0.tiktok AS tiktok_24, t0.created_at AS created_at_25, t0.user_id AS user_id_26 FROM barber_profile t0 WHERE t0.is_active = ?
Parameters:
[
  1
]

Database Connections

Name Service
default doctrine.dbal.default_connection

Entity Managers

Name Service
default doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class Amount of managed objects
App\Entity\User 54
App\Entity\BarberProfile 43
App\Entity\Review 18
App\Entity\Appointment 18
App\Entity\ProfilePhoto 8
App\Entity\Availability 5
App\Entity\Service 4
App\Entity\Setting 1

Entities Mapping

Class Mapping errors
App\Entity\Setting No errors.
App\Entity\BarberProfile No errors.
App\Entity\User No errors.
App\Entity\Service No errors.
App\Entity\Availability No errors.
App\Entity\SpecialClosure No errors.
App\Entity\StaffMember No errors.
App\Entity\Appointment No errors.
App\Entity\Review No errors.
App\Entity\ProfilePhoto No errors.
App\Entity\Notification No errors.