Symfony Profiler

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
  t0.id AS id_1,
  t0.service_title AS service_title_2,
  t0.date_start AS date_start_3,
  t0.date_end AS date_end_4,
  t0.price AS price_5,
  t0.status AS status_6,
  t0.payment_status AS payment_status_7,
  t0.notes AS notes_8,
  t0.google_event_id AS google_event_id_9,
  t0.base_service_price AS base_service_price_10,
  t0.discount_amount AS discount_amount_11,
  t0.discount_description AS discount_description_12,
  t0.created_at AS created_at_13,
  t0.updated_at AS updated_at_14,
  t0.customer_id AS customer_id_15,
  t0.professional_id AS professional_id_16,
  t0.project_id AS project_id_17,
  t0.project_service_option_id AS project_service_option_id_18,
  t0.professional_service_id AS professional_service_id_19,
  t0.offer_id AS offer_id_20,
  t21.id AS id_22,
  t21.invoice_number AS invoice_number_23,
  t21.issue_date AS issue_date_24,
  t21.due_date AS due_date_25,
  t21.currency AS currency_26,
  t21.subtotal AS subtotal_27,
  t21.discount_amount AS discount_amount_28,
  t21.tax_rate AS tax_rate_29,
  t21.tax_amount AS tax_amount_30,
  t21.total_amount AS total_amount_31,
  t21.is_tax_included_flag AS is_tax_included_flag_32,
  t21.notes AS notes_33,
  t21.status AS status_34,
  t21.pdf_path AS pdf_path_35,
  t21.professional_legal_name AS professional_legal_name_36,
  t21.professional_tax_id AS professional_tax_id_37,
  t21.professional_address AS professional_address_38,
  t21.customer_name AS customer_name_39,
  t21.customer_address AS customer_address_40,
  t21.footer_text AS footer_text_41,
  t21.language AS language_42,
  t21.created_at AS created_at_43,
  t21.updated_at AS updated_at_44,
  t21.professional_id AS professional_id_45,
  t21.customer_id AS customer_id_46,
  t21.booking_id AS booking_id_47
FROM
  bookings t0
  LEFT JOIN invoices t21 ON t21.booking_id = t0.id
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.service_title AS service_title_2, t0.date_start AS date_start_3, t0.date_end AS date_end_4, t0.price AS price_5, t0.status AS status_6, t0.payment_status AS payment_status_7, t0.notes AS notes_8, t0.google_event_id AS google_event_id_9, t0.base_service_price AS base_service_price_10, t0.discount_amount AS discount_amount_11, t0.discount_description AS discount_description_12, t0.created_at AS created_at_13, t0.updated_at AS updated_at_14, t0.customer_id AS customer_id_15, t0.professional_id AS professional_id_16, t0.project_id AS project_id_17, t0.project_service_option_id AS project_service_option_id_18, t0.professional_service_id AS professional_service_id_19, t0.offer_id AS offer_id_20, t21.id AS id_22, t21.invoice_number AS invoice_number_23, t21.issue_date AS issue_date_24, t21.due_date AS due_date_25, t21.currency AS currency_26, t21.subtotal AS subtotal_27, t21.discount_amount AS discount_amount_28, t21.tax_rate AS tax_rate_29, t21.tax_amount AS tax_amount_30, t21.total_amount AS total_amount_31, t21.is_tax_included_flag AS is_tax_included_flag_32, t21.notes AS notes_33, t21.status AS status_34, t21.pdf_path AS pdf_path_35, t21.professional_legal_name AS professional_legal_name_36, t21.professional_tax_id AS professional_tax_id_37, t21.professional_address AS professional_address_38, t21.customer_name AS customer_name_39, t21.customer_address AS customer_address_40, t21.footer_text AS footer_text_41, t21.language AS language_42, t21.created_at AS created_at_43, t21.updated_at AS updated_at_44, t21.professional_id AS professional_id_45, t21.customer_id AS customer_id_46, t21.booking_id AS booking_id_47 FROM bookings t0 LEFT JOIN invoices t21 ON t21.booking_id = t0.id WHERE t0.id = 0x93B1DDC90C5011F18E47D61AFEAC62E6;

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
  t0.id AS id_1,
  t0.first_name AS first_name_2,
  t0.last_name AS last_name_3,
  t0.full_name AS full_name_4,
  t0.avatar_path AS avatar_path_5,
  t0.avatar_url AS avatar_url_6,
  t0.preferred_language AS preferred_language_7,
  t0.street_address AS street_address_8,
  t0.city AS city_9,
  t0.state AS state_10,
  t0.postal_code AS postal_code_11,
  t0.country_code AS country_code_12,
  t0.country AS country_13,
  t0.latitude AS latitude_14,
  t0.longitude AS longitude_15,
  t0.favorite_tags AS favorite_tags_16,
  t0.settings AS settings_17,
  t0.created_at AS created_at_18,
  t0.updated_at AS updated_at_19,
  t0.user_id AS user_id_20
FROM
  customer_profiles t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.first_name AS first_name_2, t0.last_name AS last_name_3, t0.full_name AS full_name_4, t0.avatar_path AS avatar_path_5, t0.avatar_url AS avatar_url_6, t0.preferred_language AS preferred_language_7, t0.street_address AS street_address_8, t0.city AS city_9, t0.state AS state_10, t0.postal_code AS postal_code_11, t0.country_code AS country_code_12, t0.country AS country_13, t0.latitude AS latitude_14, t0.longitude AS longitude_15, t0.favorite_tags AS favorite_tags_16, t0.settings AS settings_17, t0.created_at AS created_at_18, t0.updated_at AS updated_at_19, t0.user_id AS user_id_20 FROM customer_profiles t0 WHERE t0.id = 0x019C6588D5F77B618393B633C72C903B;

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
  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
  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-03-28 15:02:05' AND o0_.valid_until > '2026-03-28 15:02:05' AND p1_.verification_status = 'VERIFIED' ORDER BY o0_.valid_until ASC LIMIT 6;

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(*)
FROM
  professional_profiles t0
WHERE
  t0.verification_status = ?

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

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_.overall_rating >= ?
  AND r0_.comment IS NOT NULL
  AND r0_.comment <> ?
ORDER BY
  r0_.overall_rating DESC,
  r0_.created_at DESC
LIMIT
  8

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_.overall_rating >= 4 AND r0_.comment IS NOT NULL AND r0_.comment <> '' ORDER BY r0_.overall_rating DESC, r0_.created_at DESC LIMIT 8;

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
  INNER JOIN offer_services ON t0.id = offer_services.professional_service_id
WHERE
  offer_services.offer_id = ?

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 INNER JOIN offer_services ON t0.id = offer_services.professional_service_id WHERE offer_services.offer_id = 0x019D1B0B124874AFB33FC27AA367A9EB;

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
  AVG(r0_.overall_rating) AS sclr_0
FROM
  reviews r0_

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

SELECT
  COUNT(*)
FROM
  projects t0

SELECT COUNT(*) FROM projects t0;

SELECT
  COUNT(*)
FROM
  bookings t0

SELECT COUNT(*) FROM bookings t0;