Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.category_id AS category_id_2,
  t0.subcategory_id AS subcategory_id_3,
  t0.title AS title_4,
  t0.description AS description_5,
  t0.default_duration_minutes AS default_duration_minutes_6,
  t0.min_price AS min_price_7,
  t0.max_price AS max_price_8,
  t0.is_active AS is_active_9,
  t0.created_at AS created_at_10,
  t0.updated_at AS updated_at_11,
  t0.professional_id AS professional_id_12
FROM
  professional_services t0
WHERE
  t0.professional_id = ?
  AND t0.is_active = ?

SELECT t0.id AS id_1, t0.category_id AS category_id_2, t0.subcategory_id AS subcategory_id_3, t0.title AS title_4, t0.description AS description_5, t0.default_duration_minutes AS default_duration_minutes_6, t0.min_price AS min_price_7, t0.max_price AS max_price_8, t0.is_active AS is_active_9, t0.created_at AS created_at_10, t0.updated_at AS updated_at_11, t0.professional_id AS professional_id_12 FROM professional_services t0 WHERE t0.professional_id = 0x019BE4B2BC4B7DB1ACEE0E94EE6205A7 AND t0.is_active = 1;

SELECT
  t0.id AS id_1,
  t0.display_name AS display_name_2,
  t0.bio AS bio_3,
  t0.avatar_url AS avatar_url_4,
  t0.rating_average AS rating_average_5,
  t0.rating_count AS rating_count_6,
  t0.badge_level AS badge_level_7,
  t0.hourly_rate AS hourly_rate_8,
  t0.daily_rate AS daily_rate_9,
  t0.package_rates AS package_rates_10,
  t0.travel_fee AS travel_fee_11,
  t0.weekend_fee AS weekend_fee_12,
  t0.night_fee AS night_fee_13,
  t0.urgent_fee AS urgent_fee_14,
  t0.service_radius_km AS service_radius_km_15,
  t0.base_latitude AS base_latitude_16,
  t0.base_longitude AS base_longitude_17,
  t0.base_place_id AS base_place_id_18,
  t0.base_city AS base_city_19,
  t0.base_country AS base_country_20,
  t0.base_country_code AS base_country_code_21,
  t0.base_formatted_address AS base_formatted_address_22,
  t0.verification_status AS verification_status_23,
  t0.created_at AS created_at_24,
  t0.updated_at AS updated_at_25,
  t0.ics_token AS ics_token_26,
  t0.settings AS settings_27,
  t0.tagline AS tagline_28,
  t0.cover_image_url AS cover_image_url_29,
  t0.business_phone AS business_phone_30,
  t0.website AS website_31,
  t0.social_links AS social_links_32,
  t0.professional_type AS professional_type_33,
  t0.legal_entity_type AS legal_entity_type_34,
  t0.legal_company_name AS legal_company_name_35,
  t0.vat_number AS vat_number_36,
  t0.invoice_footer AS invoice_footer_37,
  t0.billing_address AS billing_address_38,
  t0.preferred_currency AS preferred_currency_39,
  t0.preferred_language AS preferred_language_40,
  t0.time_format AS time_format_41,
  t0.user_id AS user_id_42
FROM
  professional_profiles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.display_name AS display_name_2, t0.bio AS bio_3, t0.avatar_url AS avatar_url_4, t0.rating_average AS rating_average_5, t0.rating_count AS rating_count_6, t0.badge_level AS badge_level_7, t0.hourly_rate AS hourly_rate_8, t0.daily_rate AS daily_rate_9, t0.package_rates AS package_rates_10, t0.travel_fee AS travel_fee_11, t0.weekend_fee AS weekend_fee_12, t0.night_fee AS night_fee_13, t0.urgent_fee AS urgent_fee_14, t0.service_radius_km AS service_radius_km_15, t0.base_latitude AS base_latitude_16, t0.base_longitude AS base_longitude_17, t0.base_place_id AS base_place_id_18, t0.base_city AS base_city_19, t0.base_country AS base_country_20, t0.base_country_code AS base_country_code_21, t0.base_formatted_address AS base_formatted_address_22, t0.verification_status AS verification_status_23, t0.created_at AS created_at_24, t0.updated_at AS updated_at_25, t0.ics_token AS ics_token_26, t0.settings AS settings_27, t0.tagline AS tagline_28, t0.cover_image_url AS cover_image_url_29, t0.business_phone AS business_phone_30, t0.website AS website_31, t0.social_links AS social_links_32, t0.professional_type AS professional_type_33, t0.legal_entity_type AS legal_entity_type_34, t0.legal_company_name AS legal_company_name_35, t0.vat_number AS vat_number_36, t0.invoice_footer AS invoice_footer_37, t0.billing_address AS billing_address_38, t0.preferred_currency AS preferred_currency_39, t0.preferred_language AS preferred_language_40, t0.time_format AS time_format_41, t0.user_id AS user_id_42 FROM professional_profiles t0 WHERE t0.id = 0x019BE4B2BC4B7DB1ACEE0E94EE6205A7;

SELECT
  r0_.id AS id_0,
  r0_.type AS type_1,
  r0_.punctuality_rating AS punctuality_rating_2,
  r0_.professionalism_rating AS professionalism_rating_3,
  r0_.quality_rating AS quality_rating_4,
  r0_.responsiveness_rating AS responsiveness_rating_5,
  r0_.value_rating AS value_rating_6,
  r0_.overall_rating AS overall_rating_7,
  r0_.comment AS comment_8,
  r0_.title AS title_9,
  r0_.status AS status_10,
  r0_.helpful_count AS helpful_count_11,
  r0_.response AS response_12,
  r0_.responded_at AS responded_at_13,
  r0_.created_at AS created_at_14,
  r0_.updated_at AS updated_at_15,
  r0_.professional_id AS professional_id_16,
  r0_.customer_id AS customer_id_17,
  r0_.booking_id AS booking_id_18,
  r0_.project_id AS project_id_19
FROM
  reviews r0_
WHERE
  r0_.professional_id = ?
  AND r0_.status = ?
ORDER BY
  r0_.created_at DESC
LIMIT
  10

SELECT r0_.id AS id_0, r0_.type AS type_1, r0_.punctuality_rating AS punctuality_rating_2, r0_.professionalism_rating AS professionalism_rating_3, r0_.quality_rating AS quality_rating_4, r0_.responsiveness_rating AS responsiveness_rating_5, r0_.value_rating AS value_rating_6, r0_.overall_rating AS overall_rating_7, r0_.comment AS comment_8, r0_.title AS title_9, r0_.status AS status_10, r0_.helpful_count AS helpful_count_11, r0_.response AS response_12, r0_.responded_at AS responded_at_13, r0_.created_at AS created_at_14, r0_.updated_at AS updated_at_15, r0_.professional_id AS professional_id_16, r0_.customer_id AS customer_id_17, r0_.booking_id AS booking_id_18, r0_.project_id AS project_id_19 FROM reviews r0_ WHERE r0_.professional_id = '019be4b2-bc4b-7db1-acee-0e94ee6205a7' AND r0_.status = 'APPROVED' ORDER BY r0_.created_at DESC LIMIT 10;

SELECT
  FLOOR(overall_rating) as stars,
  COUNT(id) as count
FROM
  reviews
WHERE
  professional_id = ?
  AND status = ?
GROUP BY
  stars
ORDER BY
  stars DESC

SELECT FLOOR(overall_rating) as stars, COUNT(id) as count
            FROM reviews
            WHERE professional_id = 0x019BE4B2BC4B7DB1ACEE0E94EE6205A7
            AND status = 'APPROVED'
            GROUP BY stars
            ORDER BY stars DESC
        ;

SELECT
  AVG(r0_.overall_rating) AS sclr_0,
  AVG(r0_.punctuality_rating) AS sclr_1,
  AVG(r0_.professionalism_rating) AS sclr_2,
  AVG(r0_.quality_rating) AS sclr_3,
  AVG(r0_.responsiveness_rating) AS sclr_4,
  AVG(r0_.value_rating) AS sclr_5,
  COUNT(r0_.id) AS sclr_6
FROM
  reviews r0_
WHERE
  r0_.professional_id = ?
  AND r0_.status = ?

SELECT AVG(r0_.overall_rating) AS sclr_0, AVG(r0_.punctuality_rating) AS sclr_1, AVG(r0_.professionalism_rating) AS sclr_2, AVG(r0_.quality_rating) AS sclr_3, AVG(r0_.responsiveness_rating) AS sclr_4, AVG(r0_.value_rating) AS sclr_5, COUNT(r0_.id) AS sclr_6 FROM reviews r0_ WHERE r0_.professional_id = '019be4b2-bc4b-7db1-acee-0e94ee6205a7' AND r0_.status = 'APPROVED';