Symfony Profiler

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 = 36 ORDER BY t0.sort_order ASC;

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

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 <> 36 AND b0_.city = 'Montréal' ORDER BY b0_.subscription_plan DESC LIMIT 4;

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 = ?

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 = 72;

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

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 = 'spa-scandinave-montreal' AND t0.is_active = 1 LIMIT 1;

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 = 36 AND r0_.is_hidden = 0;

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 = ?

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 = 36;

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 = 36 AND r0_.is_hidden = 0;

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 = 36 AND r0_.is_hidden = 0 GROUP BY r0_.rating;

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;

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 = 36 ORDER BY t0.day_of_week ASC, t0.start_time ASC;

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

SELECT COUNT(s0_.id) AS sclr_0 FROM special_closure s0_ WHERE s0_.barber_profile_id = 36 AND s0_.start_date <= '2026-10-02' AND s0_.end_date >= '2026-10-02' AND s0_.staff_member_id IS NULL;

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 = 36 ORDER BY t0.id ASC;

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

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;

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 = ?

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 = 1;