Symfony Profiler

SELECT
  a0_.id AS id_0,
  a0_.priority AS priority_1,
  a0_.start_at AS start_at_2,
  a0_.end_at AS end_at_3,
  a0_.is_active AS is_active_4,
  a0_.created_at AS created_at_5,
  a0_.advert_id AS advert_id_6,
  a0_.ad_slot_id AS ad_slot_id_7
FROM
  ad_schedule a0_
  INNER JOIN advert a1_ ON a0_.advert_id = a1_.id
  INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id
WHERE
  a2_.page_type = ?
  AND a2_.slot_name = ?
  AND a2_.is_active = 1
  AND a0_.is_active = 1
  AND a1_.is_active = 1
  AND (
    (
      a0_.start_at IS NULL
      OR a0_.start_at <= ?
    )
  )
  AND (
    (
      a0_.end_at IS NULL
      OR a0_.end_at >= ?
    )
  )
ORDER BY
  a0_.priority DESC,
  a0_.created_at ASC

SELECT a0_.id AS id_0, a0_.priority AS priority_1, a0_.start_at AS start_at_2, a0_.end_at AS end_at_3, a0_.is_active AS is_active_4, a0_.created_at AS created_at_5, a0_.advert_id AS advert_id_6, a0_.ad_slot_id AS ad_slot_id_7 FROM ad_schedule a0_ INNER JOIN advert a1_ ON a0_.advert_id = a1_.id INNER JOIN ad_slot a2_ ON a0_.ad_slot_id = a2_.id WHERE a2_.page_type = 'venue_list' AND a2_.slot_name = 'venue_list-top-landscape' AND a2_.is_active = 1 AND a0_.is_active = 1 AND a1_.is_active = 1 AND ((a0_.start_at IS NULL OR a0_.start_at <= '2026-06-03 10:09:15')) AND ((a0_.end_at IS NULL OR a0_.end_at >= '2026-06-03 10:09:15')) ORDER BY a0_.priority DESC, a0_.created_at ASC;

SELECT
  v0_.id AS id_0,
  v0_.name AS name_1,
  v0_.slug AS slug_2,
  v0_.description AS description_3,
  v0_.address AS address_4,
  v0_.city AS city_5,
  v0_.state AS state_6,
  v0_.postal_code AS postal_code_7,
  v0_.country AS country_8,
  v0_.latitude AS latitude_9,
  v0_.longitude AS longitude_10,
  v0_.phone AS phone_11,
  v0_.email AS email_12,
  v0_.website AS website_13,
  v0_.business_hours AS business_hours_14,
  v0_.amenities AS amenities_15,
  v0_.status AS status_16,
  v0_.is_verified AS is_verified_17,
  v0_.contact_name AS contact_name_18,
  v0_.contact_phone AS contact_phone_19,
  v0_.contact_email AS contact_email_20,
  v0_.created_at AS created_at_21,
  v0_.updated_at AS updated_at_22,
  p1_.created_at AS created_at_23,
  p2_.id AS id_24,
  p2_.name AS name_25,
  p2_.slug AS slug_26,
  p2_.description AS description_27,
  p2_.profile_image AS profile_image_28,
  p2_.bio AS bio_29,
  p2_.portfolio_link AS portfolio_link_30,
  p2_.instagram_handle AS instagram_handle_31,
  p2_.availability_notes AS availability_notes_32,
  p2_.publish_start_at AS publish_start_at_33,
  p2_.publish_end_at AS publish_end_at_34,
  p2_.status AS status_35,
  p2_.created_at AS created_at_36,
  p2_.updated_at AS updated_at_37,
  p2_.is_verified AS is_verified_38,
  p2_.verified_at AS verified_at_39,
  p2_.view_count AS view_count_40,
  p2_.favorite_count AS favorite_count_41,
  p2_.contact_count AS contact_count_42,
  p2_.average_rating AS average_rating_43,
  p2_.review_count AS review_count_44,
  p2_.phone1 AS phone1_45,
  p2_.whatsapp AS whatsapp_46,
  p2_.contact_email AS contact_email_47,
  p2_.instagram AS instagram_48,
  p2_.facebook AS facebook_49,
  p2_.x AS x_50,
  p2_.webpage AS webpage_51,
  p2_.phone2 AS phone2_52,
  p3_.id AS id_53,
  p3_.name AS name_54,
  p3_.slug AS slug_55,
  p3_.description AS description_56,
  p3_.profile_image AS profile_image_57,
  p3_.bio AS bio_58,
  p3_.portfolio_link AS portfolio_link_59,
  p3_.instagram_handle AS instagram_handle_60,
  p3_.availability_notes AS availability_notes_61,
  p3_.publish_start_at AS publish_start_at_62,
  p3_.publish_end_at AS publish_end_at_63,
  p3_.status AS status_64,
  p3_.created_at AS created_at_65,
  p3_.updated_at AS updated_at_66,
  p3_.is_verified AS is_verified_67,
  p3_.verified_at AS verified_at_68,
  p3_.view_count AS view_count_69,
  p3_.favorite_count AS favorite_count_70,
  p3_.contact_count AS contact_count_71,
  p3_.average_rating AS average_rating_72,
  p3_.review_count AS review_count_73,
  p3_.phone1 AS phone1_74,
  p3_.whatsapp AS whatsapp_75,
  p3_.contact_email AS contact_email_76,
  p3_.instagram AS instagram_77,
  p3_.facebook AS facebook_78,
  p3_.x AS x_79,
  p3_.webpage AS webpage_80,
  p3_.phone2 AS phone2_81,
  v0_.owner_id AS owner_id_82,
  p1_.profile_id AS profile_id_83,
  p1_.venue_id AS venue_id_84,
  p2_.user_id AS user_id_85,
  p2_.venue_id AS venue_id_86,
  p3_.user_id AS user_id_87,
  p3_.venue_id AS venue_id_88
FROM
  venue v0_
  LEFT JOIN profile_venue p1_ ON v0_.id = p1_.venue_id
  LEFT JOIN profile p2_ ON p1_.profile_id = p2_.id
  LEFT JOIN profile p3_ ON v0_.id = p3_.venue_id
WHERE
  v0_.status = ?
ORDER BY
  v0_.name ASC
LIMIT
  20

SELECT v0_.id AS id_0, v0_.name AS name_1, v0_.slug AS slug_2, v0_.description AS description_3, v0_.address AS address_4, v0_.city AS city_5, v0_.state AS state_6, v0_.postal_code AS postal_code_7, v0_.country AS country_8, v0_.latitude AS latitude_9, v0_.longitude AS longitude_10, v0_.phone AS phone_11, v0_.email AS email_12, v0_.website AS website_13, v0_.business_hours AS business_hours_14, v0_.amenities AS amenities_15, v0_.status AS status_16, v0_.is_verified AS is_verified_17, v0_.contact_name AS contact_name_18, v0_.contact_phone AS contact_phone_19, v0_.contact_email AS contact_email_20, v0_.created_at AS created_at_21, v0_.updated_at AS updated_at_22, p1_.created_at AS created_at_23, p2_.id AS id_24, p2_.name AS name_25, p2_.slug AS slug_26, p2_.description AS description_27, p2_.profile_image AS profile_image_28, p2_.bio AS bio_29, p2_.portfolio_link AS portfolio_link_30, p2_.instagram_handle AS instagram_handle_31, p2_.availability_notes AS availability_notes_32, p2_.publish_start_at AS publish_start_at_33, p2_.publish_end_at AS publish_end_at_34, p2_.status AS status_35, p2_.created_at AS created_at_36, p2_.updated_at AS updated_at_37, p2_.is_verified AS is_verified_38, p2_.verified_at AS verified_at_39, p2_.view_count AS view_count_40, p2_.favorite_count AS favorite_count_41, p2_.contact_count AS contact_count_42, p2_.average_rating AS average_rating_43, p2_.review_count AS review_count_44, p2_.phone1 AS phone1_45, p2_.whatsapp AS whatsapp_46, p2_.contact_email AS contact_email_47, p2_.instagram AS instagram_48, p2_.facebook AS facebook_49, p2_.x AS x_50, p2_.webpage AS webpage_51, p2_.phone2 AS phone2_52, p3_.id AS id_53, p3_.name AS name_54, p3_.slug AS slug_55, p3_.description AS description_56, p3_.profile_image AS profile_image_57, p3_.bio AS bio_58, p3_.portfolio_link AS portfolio_link_59, p3_.instagram_handle AS instagram_handle_60, p3_.availability_notes AS availability_notes_61, p3_.publish_start_at AS publish_start_at_62, p3_.publish_end_at AS publish_end_at_63, p3_.status AS status_64, p3_.created_at AS created_at_65, p3_.updated_at AS updated_at_66, p3_.is_verified AS is_verified_67, p3_.verified_at AS verified_at_68, p3_.view_count AS view_count_69, p3_.favorite_count AS favorite_count_70, p3_.contact_count AS contact_count_71, p3_.average_rating AS average_rating_72, p3_.review_count AS review_count_73, p3_.phone1 AS phone1_74, p3_.whatsapp AS whatsapp_75, p3_.contact_email AS contact_email_76, p3_.instagram AS instagram_77, p3_.facebook AS facebook_78, p3_.x AS x_79, p3_.webpage AS webpage_80, p3_.phone2 AS phone2_81, v0_.owner_id AS owner_id_82, p1_.profile_id AS profile_id_83, p1_.venue_id AS venue_id_84, p2_.user_id AS user_id_85, p2_.venue_id AS venue_id_86, p3_.user_id AS user_id_87, p3_.venue_id AS venue_id_88 FROM venue v0_ LEFT JOIN profile_venue p1_ ON v0_.id = p1_.venue_id LEFT JOIN profile p2_ ON p1_.profile_id = p2_.id LEFT JOIN profile p3_ ON v0_.id = p3_.venue_id WHERE v0_.status = 'active' ORDER BY v0_.name ASC LIMIT 20;

SELECT
  a0_.id AS id_0,
  a0_.page_type AS page_type_1,
  a0_.slot_name AS slot_name_2,
  a0_.display_name AS display_name_3,
  a0_.rotation_mode AS rotation_mode_4,
  a0_.allowed_formats AS allowed_formats_5,
  a0_.dimensions AS dimensions_6,
  a0_.is_active AS is_active_7,
  a0_.created_at AS created_at_8
FROM
  ad_slot a0_
WHERE
  a0_.page_type = ?
  AND a0_.slot_name = ?
  AND a0_.is_active = 1

SELECT a0_.id AS id_0, a0_.page_type AS page_type_1, a0_.slot_name AS slot_name_2, a0_.display_name AS display_name_3, a0_.rotation_mode AS rotation_mode_4, a0_.allowed_formats AS allowed_formats_5, a0_.dimensions AS dimensions_6, a0_.is_active AS is_active_7, a0_.created_at AS created_at_8 FROM ad_slot a0_ WHERE a0_.page_type = 'venue_list' AND a0_.slot_name = 'venue_list-top-landscape' AND a0_.is_active = 1;

SELECT
  b0_.id AS id_0,
  b0_.name AS name_1,
  b0_.position AS position_2,
  b0_.image_path AS image_path_3,
  b0_.link_url AS link_url_4,
  b0_.start_date AS start_date_5,
  b0_.end_date AS end_date_6,
  b0_.is_active AS is_active_7,
  b0_.click_count AS click_count_8,
  b0_.view_count AS view_count_9,
  b0_.sort_order AS sort_order_10,
  b0_.created_at AS created_at_11
FROM
  banner b0_
WHERE
  b0_.is_active = 1
  AND (
    (
      b0_.start_date IS NULL
      OR b0_.start_date <= ?
    )
  )
  AND (
    (
      b0_.end_date IS NULL
      OR b0_.end_date >= ?
    )
  )
  AND b0_.position = ?
ORDER BY
  b0_.sort_order ASC

SELECT b0_.id AS id_0, b0_.name AS name_1, b0_.position AS position_2, b0_.image_path AS image_path_3, b0_.link_url AS link_url_4, b0_.start_date AS start_date_5, b0_.end_date AS end_date_6, b0_.is_active AS is_active_7, b0_.click_count AS click_count_8, b0_.view_count AS view_count_9, b0_.sort_order AS sort_order_10, b0_.created_at AS created_at_11 FROM banner b0_ WHERE b0_.is_active = 1 AND ((b0_.start_date IS NULL OR b0_.start_date <= 1780474155)) AND ((b0_.end_date IS NULL OR b0_.end_date >= 1780474155)) AND b0_.position = 'header' ORDER BY b0_.sort_order ASC;

SELECT
  t0.id AS id_1,
  t0.image_path AS image_path_2,
  t0.thumbnail_path AS thumbnail_path_3,
  t0.caption AS caption_4,
  t0.sort_order AS sort_order_5,
  t0.is_primary AS is_primary_6,
  t0.created_at AS created_at_7,
  t0.venue_id AS venue_id_8
FROM
  venue_image t0
WHERE
  t0.venue_id = ?
ORDER BY
  t0.sort_order ASC

SELECT t0.id AS id_1, t0.image_path AS image_path_2, t0.thumbnail_path AS thumbnail_path_3, t0.caption AS caption_4, t0.sort_order AS sort_order_5, t0.is_primary AS is_primary_6, t0.created_at AS created_at_7, t0.venue_id AS venue_id_8 FROM venue_image t0 WHERE t0.venue_id = 2 ORDER BY t0.sort_order ASC;

SELECT
  DISTINCT v0_.city AS city_0
FROM
  venue v0_
WHERE
  v0_.city IS NOT NULL
  AND v0_.status = ?
ORDER BY
  v0_.city ASC

SELECT DISTINCT v0_.city AS city_0 FROM venue v0_ WHERE v0_.city IS NOT NULL AND v0_.status = 'active' ORDER BY v0_.city ASC;

SELECT
  COUNT(v0_.id) AS sclr_0
FROM
  venue v0_
WHERE
  v0_.status = ?

SELECT COUNT(v0_.id) AS sclr_0 FROM venue v0_ WHERE v0_.status = 'active';

SELECT
  a0_.id AS id_0,
  a0_.name AS name_1,
  a0_.slug AS slug_2,
  a0_.created_at AS created_at_3,
  a0_.updated_at AS updated_at_4
FROM
  area a0_
ORDER BY
  a0_.name ASC

SELECT a0_.id AS id_0, a0_.name AS name_1, a0_.slug AS slug_2, a0_.created_at AS created_at_3, a0_.updated_at AS updated_at_4 FROM area a0_ ORDER BY a0_.name ASC;

SELECT
  s0_.id AS id_0,
  s0_.name AS name_1,
  s0_.slug AS slug_2,
  s0_.created_at AS created_at_3,
  s0_.updated_at AS updated_at_4
FROM
  service s0_
ORDER BY
  s0_.name ASC

SELECT s0_.id AS id_0, s0_.name AS name_1, s0_.slug AS slug_2, s0_.created_at AS created_at_3, s0_.updated_at AS updated_at_4 FROM service s0_ ORDER BY s0_.name ASC;