Symfony Profiler

SELECT
  COUNT(*)
FROM
  professional_profiles t0
WHERE
  t0.verification_status = ?

SELECT COUNT(*) FROM professional_profiles t0 WHERE t0.verification_status = 'VERIFIED';

SELECT
  COUNT(*)
FROM
  projects t0

SELECT COUNT(*) FROM projects t0;

SELECT
  COUNT(*)
FROM
  bookings t0

SELECT COUNT(*) FROM bookings t0;

SELECT
  AVG(r0_.overall_rating) AS sclr_0
FROM
  reviews r0_

SELECT AVG(r0_.overall_rating) AS sclr_0 FROM reviews r0_;

SELECT
  p0_.id AS id_0,
  p0_.display_name AS display_name_1,
  p0_.bio AS bio_2,
  p0_.avatar_url AS avatar_url_3,
  p0_.rating_average AS rating_average_4,
  p0_.rating_count AS rating_count_5,
  p0_.badge_level AS badge_level_6,
  p0_.hourly_rate AS hourly_rate_7,
  p0_.daily_rate AS daily_rate_8,
  p0_.package_rates AS package_rates_9,
  p0_.travel_fee AS travel_fee_10,
  p0_.weekend_fee AS weekend_fee_11,
  p0_.night_fee AS night_fee_12,
  p0_.urgent_fee AS urgent_fee_13,
  p0_.service_radius_km AS service_radius_km_14,
  p0_.base_latitude AS base_latitude_15,
  p0_.base_longitude AS base_longitude_16,
  p0_.base_place_id AS base_place_id_17,
  p0_.base_city AS base_city_18,
  p0_.base_country AS base_country_19,
  p0_.base_country_code AS base_country_code_20,
  p0_.base_formatted_address AS base_formatted_address_21,
  p0_.verification_status AS verification_status_22,
  p0_.created_at AS created_at_23,
  p0_.updated_at AS updated_at_24,
  p0_.ics_token AS ics_token_25,
  p0_.settings AS settings_26,
  p0_.tagline AS tagline_27,
  p0_.cover_image_url AS cover_image_url_28,
  p0_.business_phone AS business_phone_29,
  p0_.website AS website_30,
  p0_.social_links AS social_links_31,
  p0_.professional_type AS professional_type_32,
  p0_.legal_entity_type AS legal_entity_type_33,
  p0_.legal_company_name AS legal_company_name_34,
  p0_.vat_number AS vat_number_35,
  p0_.invoice_footer AS invoice_footer_36,
  p0_.billing_address AS billing_address_37,
  p0_.preferred_currency AS preferred_currency_38,
  p0_.preferred_language AS preferred_language_39,
  p0_.time_format AS time_format_40,
  p0_.user_id AS user_id_41
FROM
  professional_profiles p0_
WHERE
  p0_.verification_status = ?
ORDER BY
  p0_.rating_average DESC,
  p0_.rating_count DESC
LIMIT
  6

SELECT p0_.id AS id_0, p0_.display_name AS display_name_1, p0_.bio AS bio_2, p0_.avatar_url AS avatar_url_3, p0_.rating_average AS rating_average_4, p0_.rating_count AS rating_count_5, p0_.badge_level AS badge_level_6, p0_.hourly_rate AS hourly_rate_7, p0_.daily_rate AS daily_rate_8, p0_.package_rates AS package_rates_9, p0_.travel_fee AS travel_fee_10, p0_.weekend_fee AS weekend_fee_11, p0_.night_fee AS night_fee_12, p0_.urgent_fee AS urgent_fee_13, p0_.service_radius_km AS service_radius_km_14, p0_.base_latitude AS base_latitude_15, p0_.base_longitude AS base_longitude_16, p0_.base_place_id AS base_place_id_17, p0_.base_city AS base_city_18, p0_.base_country AS base_country_19, p0_.base_country_code AS base_country_code_20, p0_.base_formatted_address AS base_formatted_address_21, p0_.verification_status AS verification_status_22, p0_.created_at AS created_at_23, p0_.updated_at AS updated_at_24, p0_.ics_token AS ics_token_25, p0_.settings AS settings_26, p0_.tagline AS tagline_27, p0_.cover_image_url AS cover_image_url_28, p0_.business_phone AS business_phone_29, p0_.website AS website_30, p0_.social_links AS social_links_31, p0_.professional_type AS professional_type_32, p0_.legal_entity_type AS legal_entity_type_33, p0_.legal_company_name AS legal_company_name_34, p0_.vat_number AS vat_number_35, p0_.invoice_footer AS invoice_footer_36, p0_.billing_address AS billing_address_37, p0_.preferred_currency AS preferred_currency_38, p0_.preferred_language AS preferred_language_39, p0_.time_format AS time_format_40, p0_.user_id AS user_id_41 FROM professional_profiles p0_ WHERE p0_.verification_status = 'VERIFIED' ORDER BY p0_.rating_average DESC, p0_.rating_count DESC LIMIT 6;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-e0a7-725d-b547-afc4e34272e3';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588E0A7725DB547AFC4E34272E3 ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-db4e-7cc6-8109-5481b70f821a';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588DB4E7CC681095481B70F821A ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-e5ec-7073-85a6-7adf2e264ca3';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588E5EC707385A67ADF2E264CA3 ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_translations AS name_translations_2,
  c0_.description_translations AS description_translations_3,
  c0_.slug AS slug_4,
  c0_.icon_name AS icon_name_5,
  c0_.icon_key AS icon_key_6,
  c0_.image_url AS image_url_7,
  c0_.color AS color_8,
  c0_.type AS type_9,
  c0_.display_type AS display_type_10,
  c0_.sort_order AS sort_order_11,
  c0_.is_active AS is_active_12,
  c0_.is_featured AS is_featured_13,
  c0_.metadata AS metadata_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.parent_id AS parent_id_17
FROM
  categories c0_
WHERE
  c0_.id = ?

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_translations AS name_translations_2, c0_.description_translations AS description_translations_3, c0_.slug AS slug_4, c0_.icon_name AS icon_name_5, c0_.icon_key AS icon_key_6, c0_.image_url AS image_url_7, c0_.color AS color_8, c0_.type AS type_9, c0_.display_type AS display_type_10, c0_.sort_order AS sort_order_11, c0_.is_active AS is_active_12, c0_.is_featured AS is_featured_13, c0_.metadata AS metadata_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.parent_id AS parent_id_17 FROM categories c0_ WHERE c0_.id = 0x019C6588F69678BE8864EE9198386F66;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-ddfb-7553-a3ba-df5c7334ddc8';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588DDFB7553A3BADF5C7334DDC8 ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-e34d-7ba6-9ad4-316c9c604b60';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588E34D7BA69AD4316C9C604B60 ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  MIN(p0_.min_price) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.professional_id = ?

SELECT MIN(p0_.min_price) AS sclr_0 FROM professional_services p0_ WHERE p0_.professional_id = '019c6588-eba3-7920-bcc9-0a7444143cc2';

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 = ?
ORDER BY
  t0.created_at ASC
LIMIT
  1

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 = 0x019C6588EBA37920BCC90A7444143CC2 ORDER BY t0.created_at ASC LIMIT 1;

SELECT
  c0_.id AS id_0,
  c0_.name AS name_1,
  c0_.name_translations AS name_translations_2,
  c0_.description_translations AS description_translations_3,
  c0_.slug AS slug_4,
  c0_.icon_name AS icon_name_5,
  c0_.icon_key AS icon_key_6,
  c0_.image_url AS image_url_7,
  c0_.color AS color_8,
  c0_.type AS type_9,
  c0_.display_type AS display_type_10,
  c0_.sort_order AS sort_order_11,
  c0_.is_active AS is_active_12,
  c0_.is_featured AS is_featured_13,
  c0_.metadata AS metadata_14,
  c0_.created_at AS created_at_15,
  c0_.updated_at AS updated_at_16,
  c0_.parent_id AS parent_id_17
FROM
  categories c0_
WHERE
  c0_.is_active = ?
  AND c0_.parent_id IS NULL
  AND c0_.display_type = ?
ORDER BY
  c0_.is_featured DESC,
  c0_.sort_order ASC
LIMIT
  8

SELECT c0_.id AS id_0, c0_.name AS name_1, c0_.name_translations AS name_translations_2, c0_.description_translations AS description_translations_3, c0_.slug AS slug_4, c0_.icon_name AS icon_name_5, c0_.icon_key AS icon_key_6, c0_.image_url AS image_url_7, c0_.color AS color_8, c0_.type AS type_9, c0_.display_type AS display_type_10, c0_.sort_order AS sort_order_11, c0_.is_active AS is_active_12, c0_.is_featured AS is_featured_13, c0_.metadata AS metadata_14, c0_.created_at AS created_at_15, c0_.updated_at AS updated_at_16, c0_.parent_id AS parent_id_17 FROM categories c0_ WHERE c0_.is_active = 1 AND c0_.parent_id IS NULL AND c0_.display_type = 'main' ORDER BY c0_.is_featured DESC, c0_.sort_order ASC LIMIT 8;

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-e622-74ed-b4eb-d713cba8f67c' OR p0_.subcategory_id = '019c6588-e622-74ed-b4eb-d713cba8f67c';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-f696-78be-8864-ee9198386f66' OR p0_.subcategory_id = '019c6588-f696-78be-8864-ee9198386f66';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-e623-7420-95a4-c9b5c556b1eb' OR p0_.subcategory_id = '019c6588-e623-7420-95a4-c9b5c556b1eb';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-f698-789e-a27f-959c9e65c142' OR p0_.subcategory_id = '019c6588-f698-789e-a27f-959c9e65c142';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-e623-7688-95a4-c9b5c74b4632' OR p0_.subcategory_id = '019c6588-e623-7688-95a4-c9b5c74b4632';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-f69a-740a-873d-b2ed0118023d' OR p0_.subcategory_id = '019c6588-f69a-740a-873d-b2ed0118023d';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-e623-78f0-95a4-c9b5ca643e6f' OR p0_.subcategory_id = '019c6588-e623-78f0-95a4-c9b5ca643e6f';

SELECT
  COUNT(DISTINCT p0_.professional_id) AS sclr_0
FROM
  professional_services p0_
WHERE
  p0_.category_id = ?
  OR p0_.subcategory_id = ?

SELECT COUNT(DISTINCT p0_.professional_id) AS sclr_0 FROM professional_services p0_ WHERE p0_.category_id = '019c6588-f69b-7a69-a1d3-2ec816f31057' OR p0_.subcategory_id = '019c6588-f69b-7a69-a1d3-2ec816f31057';