Symfony Profiler

SELECT
  s0_.name AS name_0,
  s0_.category AS category_1,
  AVG(s0_.price) AS sclr_2,
  MIN(s0_.duration_minutes) AS sclr_3,
  COUNT(DISTINCT s0_.barber_profile_id) AS sclr_4
FROM
  service s0_
  INNER JOIN barber_profile b1_ ON s0_.barber_profile_id = b1_.id
WHERE
  s0_.is_active = 1
  AND b1_.is_active = 1
GROUP BY
  s0_.name,
  s0_.category
ORDER BY
  sclr_4 DESC,
  sclr_2 ASC
LIMIT
  8

SELECT s0_.name AS name_0, s0_.category AS category_1, AVG(s0_.price) AS sclr_2, MIN(s0_.duration_minutes) AS sclr_3, COUNT(DISTINCT s0_.barber_profile_id) AS sclr_4 FROM service s0_ INNER JOIN barber_profile b1_ ON s0_.barber_profile_id = b1_.id WHERE s0_.is_active = 1 AND b1_.is_active = 1 GROUP BY s0_.name, s0_.category ORDER BY sclr_4 DESC, sclr_2 ASC LIMIT 8;

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

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

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

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

SELECT
  b0_.city AS city_0,
  COUNT(b0_.id) AS sclr_1
FROM
  barber_profile b0_
WHERE
  b0_.is_active = 1
  AND b0_.city IN (?, ?, ?, ?, ?, ?)
GROUP BY
  b0_.city

SELECT b0_.city AS city_0, COUNT(b0_.id) AS sclr_1 FROM barber_profile b0_ WHERE b0_.is_active = 1 AND b0_.city IN ('Montreal', 'Toronto', 'Vancouver', 'Calgary', 'Ottawa', 'Quebec City') GROUP BY b0_.city;

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,
  b2_.id AS id_25,
  b2_.salon_name AS salon_name_26,
  b2_.slug AS slug_27,
  b2_.description AS description_28,
  b2_.address AS address_29,
  b2_.city AS city_30,
  b2_.latitude AS latitude_31,
  b2_.longitude AS longitude_32,
  b2_.languages AS languages_33,
  b2_.transport_info AS transport_info_34,
  b2_.payment_methods AS payment_methods_35,
  b2_.subscription_plan AS subscription_plan_36,
  b2_.salon_type AS salon_type_37,
  b2_.salon_categories AS salon_categories_38,
  b2_.is_verified AS is_verified_39,
  b2_.is_active AS is_active_40,
  b2_.offer_home_visit AS offer_home_visit_41,
  b2_.home_visit_radius AS home_visit_radius_42,
  b2_.staff_appointment_management AS staff_appointment_management_43,
  b2_.phone AS phone_44,
  b2_.website AS website_45,
  b2_.instagram AS instagram_46,
  b2_.facebook AS facebook_47,
  b2_.tiktok AS tiktok_48,
  b2_.created_at AS created_at_49,
  r0_.client_id AS client_id_50,
  r0_.barber_profile_id AS barber_profile_id_51,
  r0_.appointment_id AS appointment_id_52,
  u1_.referred_by_id AS referred_by_id_53,
  b2_.user_id AS user_id_54
FROM
  review r0_
  LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id
  LEFT JOIN barber_profile b2_ ON r0_.barber_profile_id = b2_.id
WHERE
  r0_.is_hidden = 0
  AND r0_.rating >= 4
  AND r0_.comment IS NOT NULL
  AND r0_.comment <> ''
ORDER BY
  r0_.rating DESC,
  r0_.created_at DESC
LIMIT
  6

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, b2_.id AS id_25, b2_.salon_name AS salon_name_26, b2_.slug AS slug_27, b2_.description AS description_28, b2_.address AS address_29, b2_.city AS city_30, b2_.latitude AS latitude_31, b2_.longitude AS longitude_32, b2_.languages AS languages_33, b2_.transport_info AS transport_info_34, b2_.payment_methods AS payment_methods_35, b2_.subscription_plan AS subscription_plan_36, b2_.salon_type AS salon_type_37, b2_.salon_categories AS salon_categories_38, b2_.is_verified AS is_verified_39, b2_.is_active AS is_active_40, b2_.offer_home_visit AS offer_home_visit_41, b2_.home_visit_radius AS home_visit_radius_42, b2_.staff_appointment_management AS staff_appointment_management_43, b2_.phone AS phone_44, b2_.website AS website_45, b2_.instagram AS instagram_46, b2_.facebook AS facebook_47, b2_.tiktok AS tiktok_48, b2_.created_at AS created_at_49, r0_.client_id AS client_id_50, r0_.barber_profile_id AS barber_profile_id_51, r0_.appointment_id AS appointment_id_52, u1_.referred_by_id AS referred_by_id_53, b2_.user_id AS user_id_54 FROM review r0_ LEFT JOIN `user` u1_ ON r0_.client_id = u1_.id LEFT JOIN barber_profile b2_ ON r0_.barber_profile_id = b2_.id WHERE r0_.is_hidden = 0 AND r0_.rating >= 4 AND r0_.comment IS NOT NULL AND r0_.comment <> '' ORDER BY r0_.rating DESC, r0_.created_at DESC LIMIT 6;

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_.subscription_plan IN (?, ?)
ORDER BY
  b0_.subscription_plan DESC
LIMIT
  6

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_.subscription_plan IN ('premium', 'premium_plus') ORDER BY b0_.subscription_plan DESC LIMIT 6;

SELECT
  t0_.id AS id_0,
  t0_.name AS name_1,
  t0_.category AS category_2,
  t0_.tag AS tag_3,
  t0_.image_filename AS image_filename_4,
  t0_.image_url AS image_url_5,
  t0_.search_query AS search_query_6,
  t0_.search_category AS search_category_7,
  t0_.is_active AS is_active_8,
  t0_.sort_order AS sort_order_9,
  t0_.created_at AS created_at_10,
  t0_.updated_at AS updated_at_11
FROM
  trend t0_
WHERE
  t0_.is_active = 1
ORDER BY
  t0_.sort_order ASC,
  t0_.created_at DESC
LIMIT
  8

SELECT t0_.id AS id_0, t0_.name AS name_1, t0_.category AS category_2, t0_.tag AS tag_3, t0_.image_filename AS image_filename_4, t0_.image_url AS image_url_5, t0_.search_query AS search_query_6, t0_.search_category AS search_category_7, t0_.is_active AS is_active_8, t0_.sort_order AS sort_order_9, t0_.created_at AS created_at_10, t0_.updated_at AS updated_at_11 FROM trend t0_ WHERE t0_.is_active = 1 ORDER BY t0_.sort_order ASC, t0_.created_at DESC LIMIT 8;

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;

SELECT
  COUNT(b0_.id) AS sclr_0
FROM
  barber_profile b0_
WHERE
  b0_.is_active = 1

SELECT COUNT(b0_.id) AS sclr_0 FROM barber_profile b0_ WHERE b0_.is_active = 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 = ?
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;