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 = '019be4b2-b1db-75cf-a401-6a1f9e743732';

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 = 0x019BE4B2B1DB75CFA4016A1F9E743732 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 = '019be4b2-a822-7665-b72d-80d41bfbfd36';

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 = 0x019BE4B2A8227665B72D80D41BFBFD36 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 = '019be4b2-bc4b-7db1-acee-0e94ee6205a7';

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 = 0x019BE4B2BC4B7DB1ACEE0E94EE6205A7 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 = '019be4b2-ad3e-780c-bf9f-f54e0dd44df7';

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 = 0x019BE4B2AD3E780CBF9FF54E0DD44DF7 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 = '019be4b2-b704-7457-b66d-6f993f9e6870';

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 = 0x019BE4B2B7047457B66D6F993F9E6870 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 = '019be4b2-c7fc-7d30-bc20-ec50110918e9';

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 = 0x019BE4B2C7FC7D30BC20EC50110918E9 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 = '019be4b2-bcdc-73df-a98c-07121be3bc4a' OR p0_.subcategory_id = '019be4b2-bcdc-73df-a98c-07121be3bc4a';

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 = '019be4b2-deb0-7d55-80d6-ea1094ea9c6e' OR p0_.subcategory_id = '019be4b2-deb0-7d55-80d6-ea1094ea9c6e';

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 = '019be4b2-bcde-7949-82ca-126dacbbff1d' OR p0_.subcategory_id = '019be4b2-bcde-7949-82ca-126dacbbff1d';

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 = '019be4b2-deb9-7886-b946-6959e9c57002' OR p0_.subcategory_id = '019be4b2-deb9-7886-b946-6959e9c57002';

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 = '019be4b2-bcde-7d91-82ca-126dae339bc6' OR p0_.subcategory_id = '019be4b2-bcde-7d91-82ca-126dae339bc6';

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 = '019be4b2-dec4-7780-ba3e-57a73e1e5505' OR p0_.subcategory_id = '019be4b2-dec4-7780-ba3e-57a73e1e5505';

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 = '019be4b2-bcdf-7392-85b0-7f61f056e57b' OR p0_.subcategory_id = '019be4b2-bcdf-7392-85b0-7f61f056e57b';

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 = '019be4b2-ded0-790a-b0a0-eebae4309bde' OR p0_.subcategory_id = '019be4b2-ded0-790a-b0a0-eebae4309bde';

SELECT
  o0_.id AS id_0,
  o0_.title AS title_1,
  o0_.short_description AS short_description_2,
  o0_.discount_type AS discount_type_3,
  o0_.discount_value AS discount_value_4,
  o0_.badge_label AS badge_label_5,
  o0_.min_booking_amount AS min_booking_amount_6,
  o0_.max_usage_per_customer AS max_usage_per_customer_7,
  o0_.valid_from AS valid_from_8,
  o0_.valid_until AS valid_until_9,
  o0_.is_active AS is_active_10,
  o0_.created_at AS created_at_11,
  o0_.updated_at AS updated_at_12,
  o0_.professional_id AS professional_id_13,
  o0_.service_id AS service_id_14
FROM
  offers o0_
  INNER JOIN professional_profiles p1_ ON o0_.professional_id = p1_.id
WHERE
  o0_.is_active = ?
  AND o0_.valid_from <= ?
  AND o0_.valid_until > ?
  AND p1_.verification_status = ?
ORDER BY
  o0_.valid_until ASC
LIMIT
  6

SELECT o0_.id AS id_0, o0_.title AS title_1, o0_.short_description AS short_description_2, o0_.discount_type AS discount_type_3, o0_.discount_value AS discount_value_4, o0_.badge_label AS badge_label_5, o0_.min_booking_amount AS min_booking_amount_6, o0_.max_usage_per_customer AS max_usage_per_customer_7, o0_.valid_from AS valid_from_8, o0_.valid_until AS valid_until_9, o0_.is_active AS is_active_10, o0_.created_at AS created_at_11, o0_.updated_at AS updated_at_12, o0_.professional_id AS professional_id_13, o0_.service_id AS service_id_14 FROM offers o0_ INNER JOIN professional_profiles p1_ ON o0_.professional_id = p1_.id WHERE o0_.is_active = 1 AND o0_.valid_from <= '2026-02-21 13:22:19' AND o0_.valid_until > '2026-02-21 13:22:19' AND p1_.verification_status = 'VERIFIED' ORDER BY o0_.valid_until ASC LIMIT 6;