Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.slug IS NULL
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.slug IS NULL LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.label AS label_3,
  t0.type AS type_4,
  t0.options AS options_5,
  t0.similar_identifier AS similar_identifier_6,
  t0.required AS required_7
FROM
  custom_fields t0
WHERE
  t0.name = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.name AS name_2, t0.label AS label_3, t0.type AS type_4, t0.options AS options_5, t0.similar_identifier AS similar_identifier_6, t0.required AS required_7 FROM custom_fields t0 WHERE t0.name = 'finish-type' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.alias AS alias_3,
  t0.description AS description_4,
  t0.slug AS slug_5,
  t0.lat AS lat_6,
  t0.lon AS lon_7,
  t0.zoom AS zoom_8,
  t0.coordinates AS coordinates_9,
  t0.searchable AS searchable_10,
  t0.home_filter AS home_filter_11,
  t0.statistics_filter AS statistics_filter_12,
  t0.neighborhood_filter AS neighborhood_filter_13,
  t0.compound_filter AS compound_filter_14,
  t0.estimate AS estimate_15,
  t0.disabled AS disabled_16,
  t0.synced AS synced_17,
  t0.level AS level_18,
  t0._left AS _left_19,
  t0._right AS _right_20,
  t0.root AS root_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.keyword AS keyword_24,
  t0.full_path AS full_path_25,
  t0.reference_id AS reference_id_26,
  t0.type AS type_27,
  t0.eligible_for_mortgage AS eligible_for_mortgage_28,
  t0.is_compound_location AS is_compound_location_29,
  t0.parent_id AS parent_id_30,
  t0.location_compound_id AS location_compound_id_31,
  t0.rating_id AS rating_id_32,
  t0.listing_id AS listing_id_33
FROM
  locations t0
WHERE
  t0.id IN (?, ?, ?, ?, ?)

SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.keyword AS keyword_24, t0.full_path AS full_path_25, t0.reference_id AS reference_id_26, t0.type AS type_27, t0.eligible_for_mortgage AS eligible_for_mortgage_28, t0.is_compound_location AS is_compound_location_29, t0.parent_id AS parent_id_30, t0.location_compound_id AS location_compound_id_31, t0.rating_id AS rating_id_32, t0.listing_id AS listing_id_33 FROM locations t0 WHERE t0.id IN ('1', '2', '3', '4', '5');

SELECT
  c0_.id AS id_0,
  c0_.title AS title_1,
  c0_.paragraph AS paragraph_2,
  c0_.place AS place_3,
  c0_.is_published AS is_published_4,
  c0_.by_owner_only AS by_owner_only_5,
  c0_.photo AS photo_6
FROM
  custom_paragraphs c0_
  INNER JOIN paragraphs_sections p2_ ON c0_.id = p2_.paragraph_id
  INNER JOIN sections s1_ ON s1_.id = p2_.section_id
WHERE
  s1_.id = ?
  AND c0_.place = ?
  AND (
    SELECT
      COUNT(*)
    FROM
      paragraphs_locations p3_
    WHERE
      p3_.paragraph_id = c0_.id
  ) = 0
  AND (
    SELECT
      COUNT(*)
    FROM
      paragraphs_compound_locations p4_
    WHERE
      p4_.paragraph_id = c0_.id
  ) = 0
  AND c0_.is_published = ?

SELECT c0_.id AS id_0, c0_.title AS title_1, c0_.paragraph AS paragraph_2, c0_.place AS place_3, c0_.is_published AS is_published_4, c0_.by_owner_only AS by_owner_only_5, c0_.photo AS photo_6 FROM custom_paragraphs c0_ INNER JOIN paragraphs_sections p2_ ON c0_.id = p2_.paragraph_id INNER JOIN sections s1_ ON s1_.id = p2_.section_id WHERE s1_.id = 3 AND c0_.place = 2 AND (SELECT COUNT(*) FROM paragraphs_locations p3_ WHERE p3_.paragraph_id = c0_.id) = 0 AND (SELECT COUNT(*) FROM paragraphs_compound_locations p4_ WHERE p4_.paragraph_id = c0_.id) = 0 AND c0_.is_published = 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 1 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 2 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 3 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 4 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 5 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 7 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 6 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 8 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 9 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 13 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 14 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 10 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 11 ORDER BY t0._left ASC;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.coordinates AS coordinates_3,
  t0.slug AS slug_4,
  t0._left AS _left_5,
  t0.level AS level_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.activity AS activity_9,
  t0.is_compound_location AS is_compound_location_10,
  t0.type AS type_11,
  t0.parent_id AS parent_id_12,
  t0.listing_id AS listing_id_13,
  t0.location_id AS location_id_14
FROM
  compound_locations t0
WHERE
  t0.parent_id = ?
ORDER BY
  t0._left ASC

SELECT t0.id AS id_1, t0.title AS title_2, t0.coordinates AS coordinates_3, t0.slug AS slug_4, t0._left AS _left_5, t0.level AS level_6, t0._right AS _right_7, t0.root AS root_8, t0.activity AS activity_9, t0.is_compound_location AS is_compound_location_10, t0.type AS type_11, t0.parent_id AS parent_id_12, t0.listing_id AS listing_id_13, t0.location_id AS location_id_14 FROM compound_locations t0 WHERE t0.parent_id = 12 ORDER BY t0._left ASC;

SELECT
  a0_.id AS id_0,
  a0_.title AS title_1,
  a0_.url AS url_2,
  a0_.description AS description_3,
  a0_.customer_title AS customer_title_4,
  a0_.customer_url AS customer_url_5,
  a0_.customer_description AS customer_description_6,
  a0_.end_at AS end_at_7,
  a0_.start_at AS start_at_8,
  a0_.color AS color_9,
  a0_.counter AS counter_10,
  a0_.top_bar AS top_bar_11,
  a0_.appear_on_mobile AS appear_on_mobile_12
FROM
  announcements a0_
WHERE
  a0_.top_bar IN (?)
  AND a0_.end_at >= ?

SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (1) AND a0_.end_at >= '2025-07-06 04:23:04';

SELECT
  f0_.id AS id_0,
  f0_.name AS name_1,
  f0_.identifier AS identifier_2,
  f0_.description AS description_3,
  f0_.toggle_owner AS toggle_owner_4,
  f0_.status AS status_5,
  f0_.category AS category_6,
  f0_.added_at_date AS added_at_date_7,
  f0_.updated_at_date AS updated_at_date_8
FROM
  features_toggles f0_
WHERE
  f0_.identifier = ?

SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = 'web.compound.advisor';