Symfony Profiler

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.level AS level_17,
  t0._left AS _left_18,
  t0._right AS _right_19,
  t0.root AS root_20,
  t0.show_primary_only AS show_primary_only_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.synonyms AS synonyms_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.slug = ?
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.level AS level_17, t0._left AS _left_18, t0._right AS _right_19, t0.root AS root_20, t0.show_primary_only AS show_primary_only_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.synonyms AS synonyms_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.slug = 'alexandria' LIMIT 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.name AS name_2,
  t0.original_file_name AS original_file_name_3,
  t0.path AS path_4,
  t0.hash AS hash_5,
  t0.dimensions AS dimensions_6,
  t0.size AS size_7,
  t0.uploaded_at AS uploaded_at_8
FROM
  photos t0
WHERE
  t0.id = ?

SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = 1556;

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 >= '2026-06-10 06:53:31';

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_.level AS level_16,
  l0_._left AS _left_17,
  l0_._right AS _right_18,
  l0_.root AS root_19,
  l0_.show_primary_only AS show_primary_only_20,
  l0_.leads_counter AS leads_counter_21,
  l0_.listings_counter AS listings_counter_22,
  l0_.synonyms AS synonyms_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_._left <= 1
  AND l0_._right >= 6162
  AND l0_.root = ?
ORDER BY
  l0_._left ASC

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_.level AS level_16, l0_._left AS _left_17, l0_._right AS _right_18, l0_.root AS root_19, l0_.show_primary_only AS show_primary_only_20, l0_.leads_counter AS leads_counter_21, l0_.listings_counter AS listings_counter_22, l0_.synonyms AS synonyms_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_._left <= 1 AND l0_._right >= 6162 AND l0_.root = 2 ORDER BY l0_._left ASC;

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.level AS level_17,
  t0._left AS _left_18,
  t0._right AS _right_19,
  t0.root AS root_20,
  t0.show_primary_only AS show_primary_only_21,
  t0.leads_counter AS leads_counter_22,
  t0.listings_counter AS listings_counter_23,
  t0.synonyms AS synonyms_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.disabled = ?
      AND t0.neighborhood_filter = ?
    )
    AND t0.parent_id = ?
  )
ORDER BY
  t0.id ASC

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.level AS level_17, t0._left AS _left_18, t0._right AS _right_19, t0.root AS root_20, t0.show_primary_only AS show_primary_only_21, t0.leads_counter AS leads_counter_22, t0.listings_counter AS listings_counter_23, t0.synonyms AS synonyms_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.disabled = 0 AND t0.neighborhood_filter = 1) AND t0.parent_id = 2) ORDER BY t0.id ASC;

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 = 35;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 35) ORDER BY t0.avg_price ASC;

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 = 38;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 38) ORDER BY t0.avg_price ASC;

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 = 39;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 39) ORDER BY t0.avg_price ASC;

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 = 40;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 40) ORDER BY t0.avg_price ASC;

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 = 45;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 45) ORDER BY t0.avg_price ASC;

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 = 46;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 46) ORDER BY t0.avg_price ASC;

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 = 47;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 47) ORDER BY t0.avg_price ASC;

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 = 48;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 48) ORDER BY t0.avg_price ASC;

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 = 49;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 49) ORDER BY t0.avg_price ASC;

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 = 52;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 52) ORDER BY t0.avg_price ASC;

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 = 61;

SELECT
  t0.id AS id_1,
  t0.growth AS growth_2,
  t0.avg_price AS avg_price_3,
  t0.demand_heat AS demand_heat_4,
  t0.ppm_min AS ppm_min_5,
  t0.ppm_max AS ppm_max_6,
  t0.updated_at AS updated_at_7,
  t0.section_id AS section_id_8,
  t0.property_type_id AS property_type_id_9,
  t0.location_id AS location_id_10
FROM
  locations_statistics t0
WHERE
  (
    (
      t0.avg_price IS NOT NULL
      AND t0.avg_price > ?
    )
    AND t0.location_id = ?
  )
ORDER BY
  t0.avg_price ASC

SELECT t0.id AS id_1, t0.growth AS growth_2, t0.avg_price AS avg_price_3, t0.demand_heat AS demand_heat_4, t0.ppm_min AS ppm_min_5, t0.ppm_max AS ppm_max_6, t0.updated_at AS updated_at_7, t0.section_id AS section_id_8, t0.property_type_id AS property_type_id_9, t0.location_id AS location_id_10 FROM locations_statistics t0 WHERE ((t0.avg_price IS NOT NULL AND t0.avg_price > 0) AND t0.location_id = 61) ORDER BY t0.avg_price ASC;

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 = 63;