Symfony Profiler

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.section_id AS section_id_5
FROM
  sections_translations t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.section_id AS section_id_5
FROM
  sections_translations t0
WHERE
  t0.section_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.section_id AS section_id_5 FROM sections_translations t0 WHERE t0.section_id = 2;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.alias AS alias_2,
  l0_.description AS description_3,
  l0_.slug AS slug_4,
  l0_.lat AS lat_5,
  l0_.lon AS lon_6,
  l0_.zoom AS zoom_7,
  l0_.coordinates AS coordinates_8,
  l0_.searchable AS searchable_9,
  l0_.home_filter AS home_filter_10,
  l0_.statistics_filter AS statistics_filter_11,
  l0_.neighborhood_filter AS neighborhood_filter_12,
  l0_.compound_filter AS compound_filter_13,
  l0_.estimate AS estimate_14,
  l0_.disabled AS disabled_15,
  l0_.synced AS synced_16,
  l0_.level AS level_17,
  l0_._left AS _left_18,
  l0_._right AS _right_19,
  l0_.root AS root_20,
  l0_.leads_counter AS leads_counter_21,
  l0_.listings_counter AS listings_counter_22,
  l0_.keyword AS keyword_23,
  l0_.full_path AS full_path_24,
  l0_.reference_id AS reference_id_25,
  l0_.type AS type_26,
  l0_.eligible_for_mortgage AS eligible_for_mortgage_27,
  l0_.is_compound_location AS is_compound_location_28,
  l0_.parent_id AS parent_id_29,
  l0_.location_compound_id AS location_compound_id_30,
  l0_.rating_id AS rating_id_31,
  l0_.listing_id AS listing_id_32
FROM
  locations l0_
WHERE
  l0_.neighborhood_filter = ?
  AND l0_.disabled = ?
  AND l0_.level = ?

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.keyword AS keyword_23, l0_.full_path AS full_path_24, l0_.reference_id AS reference_id_25, l0_.type AS type_26, l0_.eligible_for_mortgage AS eligible_for_mortgage_27, l0_.is_compound_location AS is_compound_location_28, l0_.parent_id AS parent_id_29, l0_.location_compound_id AS location_compound_id_30, l0_.rating_id AS rating_id_31, l0_.listing_id AS listing_id_32 FROM locations l0_ WHERE l0_.neighborhood_filter = 1 AND l0_.disabled = 0 AND l0_.level = 0;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 2;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 3;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 5;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 9;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 11;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.location_id AS location_id_5
FROM
  locations_translations t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.location_id AS location_id_5 FROM locations_translations t0 WHERE t0.location_id = 29;

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-12-13 23:46:56';

SELECT
  t0.id AS id_1,
  t0.overall AS overall_2,
  t0.neighborhood AS neighborhood_3,
  t0.education AS education_4,
  t0.location_rate AS location_rate_5,
  t0.transportation AS transportation_6,
  t0.population AS population_7,
  t0.Life_style AS Life_style_8,
  t0.health_care AS health_care_9,
  t0.location_id AS location_id_10
FROM
  locations_rating t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.overall AS overall_2, t0.neighborhood AS neighborhood_3, t0.education AS education_4, t0.location_rate AS location_rate_5, t0.transportation AS transportation_6, t0.population AS population_7, t0.Life_style AS Life_style_8, t0.health_care AS health_care_9, t0.location_id AS location_id_10 FROM locations_rating t0 WHERE t0.id = 15487;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 1;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 2;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 3;

SELECT
  t0.id AS id_1,
  t0.overall AS overall_2,
  t0.neighborhood AS neighborhood_3,
  t0.education AS education_4,
  t0.location_rate AS location_rate_5,
  t0.transportation AS transportation_6,
  t0.population AS population_7,
  t0.Life_style AS Life_style_8,
  t0.health_care AS health_care_9,
  t0.location_id AS location_id_10
FROM
  locations_rating t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.overall AS overall_2, t0.neighborhood AS neighborhood_3, t0.education AS education_4, t0.location_rate AS location_rate_5, t0.transportation AS transportation_6, t0.population AS population_7, t0.Life_style AS Life_style_8, t0.health_care AS health_care_9, t0.location_id AS location_id_10 FROM locations_rating t0 WHERE t0.id = 15516;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 5;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 9;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 11;

SELECT
  t0.id AS id_1,
  t0.caption AS caption_2,
  t0.type AS type_3,
  t0.location_id AS location_id_4,
  t0.photo_id AS photo_id_5
FROM
  locations_photos t0
WHERE
  t0.location_id = ?

SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.location_id AS location_id_4, t0.photo_id AS photo_id_5 FROM locations_photos t0 WHERE t0.location_id = 29;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.title_singular AS title_singular_2,
  p0_.title_plural AS title_plural_3,
  p0_.slug AS slug_4,
  p0_.private AS private_5,
  p0_.level AS level_6,
  p0_._left AS _left_7,
  p0_._right AS _right_8,
  p0_.root AS root_9,
  p0_.compound_related AS compound_related_10,
  p0_.reference_id AS reference_id_11,
  p0_.exchangeable AS exchangeable_12,
  p0_.is_evaluable AS is_evaluable_13,
  p0_.synced AS synced_14,
  p0_.searchable AS searchable_15,
  p0_.deleted_at AS deleted_at_16,
  p0_.custom_order AS custom_order_17,
  p0_.parent_id AS parent_id_18
FROM
  property_types p0_
WHERE
  (p0_.parent_id IS NULL)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_._left ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.locale AS locale_2,
  t0.field AS field_3,
  t0.content AS content_4,
  t0.property_type_id AS property_type_id_5
FROM
  property_types_translations t0
WHERE
  t0.property_type_id = ?

SELECT t0.id AS id_1, t0.locale AS locale_2, t0.field AS field_3, t0.content AS content_4, t0.property_type_id AS property_type_id_5 FROM property_types_translations t0 WHERE t0.property_type_id = 83;

SELECT
  l0_.id AS id_0,
  COALESCE(l1_.content, l0_.title) AS sclr_1,
  l0_.slug AS slug_2
FROM
  locations l0_
  LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id
  AND (
    l1_.locale = ?
    AND l1_.field = ?
    AND l1_.location_id = l0_.id
  )
WHERE
  l0_.disabled = ?
  AND l0_.parent_id IS NULL
ORDER BY
  l0_.listings_counter DESC

SELECT l0_.id AS id_0, COALESCE(l1_.content, l0_.title) AS sclr_1, l0_.slug AS slug_2 FROM locations l0_ LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id AND (l1_.locale = 'en' AND l1_.field = 'title' AND l1_.location_id = l0_.id) WHERE l0_.disabled = 0 AND l0_.parent_id IS NULL ORDER BY l0_.listings_counter DESC;

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.title_singular AS title_singular_2,
  p0_.title_plural AS title_plural_3,
  p0_.slug AS slug_4,
  p0_.private AS private_5,
  p0_.level AS level_6,
  p0_._left AS _left_7,
  p0_._right AS _right_8,
  p0_.root AS root_9,
  p0_.compound_related AS compound_related_10,
  p0_.reference_id AS reference_id_11,
  p0_.exchangeable AS exchangeable_12,
  p0_.is_evaluable AS is_evaluable_13,
  p0_.synced AS synced_14,
  p0_.searchable AS searchable_15,
  p0_.deleted_at AS deleted_at_16,
  p0_.custom_order AS custom_order_17,
  p0_.parent_id AS parent_id_18
FROM
  property_types p0_
WHERE
  (p0_.parent_id IS NULL)
  AND (p0_.deleted_at IS NULL)
ORDER BY
  p0_._left ASC
LIMIT
  1

SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.parent_id IS NULL) AND (p0_.deleted_at IS NULL) ORDER BY p0_._left ASC LIMIT 1;

SELECT
  l0_.id AS id_0,
  COALESCE(l1_.content, l0_.title) AS sclr_1,
  l0_.slug AS slug_2
FROM
  locations l0_
  LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id
  AND (
    l1_.locale = ?
    AND l1_.field = ?
    AND l1_.location_id = l0_.id
  )
WHERE
  l0_.disabled = ?
  AND l0_.parent_id IS NULL
ORDER BY
  l0_.listings_counter DESC

SELECT l0_.id AS id_0, COALESCE(l1_.content, l0_.title) AS sclr_1, l0_.slug AS slug_2 FROM locations l0_ LEFT JOIN locations_translations l1_ ON l0_.id = l1_.location_id AND (l1_.locale = 'en' AND l1_.field = 'title' AND l1_.location_id = l0_.id) WHERE l0_.disabled = 0 AND l0_.parent_id IS NULL ORDER BY l0_.listings_counter DESC;