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 = 'cairo/6th-of-october/el-ahyaa/neighborhood-8th/street-4' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.description AS description_3,
  t0.meta_title AS meta_title_4,
  t0.meta_description AS meta_description_5,
  t0.main AS main_6,
  t0.searchable AS searchable_7,
  t0.slug AS slug_8,
  t0.reference_id AS reference_id_9,
  t0.meta_search_description AS meta_search_description_10
FROM
  sections t0
WHERE
  t0.slug = ?
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.reference_id AS reference_id_9, t0.meta_search_description AS meta_search_description_10 FROM sections t0 WHERE t0.slug = 'for-sale' LIMIT 1;

SELECT
  t0.id AS id_1,
  t0.title AS title_2,
  t0.title_singular AS title_singular_3,
  t0.title_plural AS title_plural_4,
  t0.slug AS slug_5,
  t0.private AS private_6,
  t0.level AS level_7,
  t0._left AS _left_8,
  t0._right AS _right_9,
  t0.root AS root_10,
  t0.compound_related AS compound_related_11,
  t0.reference_id AS reference_id_12,
  t0.exchangeable AS exchangeable_13,
  t0.is_evaluable AS is_evaluable_14,
  t0.searchable AS searchable_15,
  t0.deleted_at AS deleted_at_16,
  t0.custom_order AS custom_order_17,
  t0.amenities AS amenities_18,
  t0.parent_id AS parent_id_19
FROM
  property_types t0
WHERE
  t0.slug = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.searchable AS searchable_15, t0.deleted_at AS deleted_at_16, t0.custom_order AS custom_order_17, t0.amenities AS amenities_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.slug = 'building' AND ((t0.deleted_at IS NULL)) 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.disabled = ?
    AND t0.parent_id = ?
  )
ORDER BY
  t0._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 = 0 AND t0.parent_id = 23496) ORDER BY t0._left ASC;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.slug AS slug_2
FROM
  locations l0_
WHERE
  l0_._left < ?
  AND l0_._right > ?
  AND l0_.root = ?

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.slug AS slug_2 FROM locations l0_ WHERE l0_._left < 7669 AND l0_._right > 7670 AND l0_.root = 1;

SELECT
  s0_.rooms AS rooms_0,
  s0_.id AS id_1,
  s0_.market_property_type AS market_property_type_2,
  s0_.finish_type AS finish_type_3,
  s0_.listing_payment_method AS listing_payment_method_4,
  s0_.eligible_for_mortgage AS eligible_for_mortgage_5
FROM
  search_result_combination_filters s0_
WHERE
  s0_.section_id = ?
  AND s0_.property_type_id = ?
  AND s0_.location_id = ?
  AND s0_.search_result_count > ?

SELECT s0_.rooms AS rooms_0, s0_.id AS id_1, s0_.market_property_type AS market_property_type_2, s0_.finish_type AS finish_type_3, s0_.listing_payment_method AS listing_payment_method_4, s0_.eligible_for_mortgage AS eligible_for_mortgage_5 FROM search_result_combination_filters s0_ WHERE s0_.section_id = 2 AND s0_.property_type_id = 5 AND s0_.location_id = 23496 AND s0_.search_result_count > 0;

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_.slug IN (?)

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_.slug IN ('cairo/6th-of-october/el-ahyaa/neighborhood-8th/street-4');

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.id = ?

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.id = 826;

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.id = ?

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.id = 319;

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.id = ?

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.id = 31;

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.id = ?

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.id = 1;

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_property_types p2_ ON c0_.id = p2_.paragraph_id
  INNER JOIN property_types p1_ ON p1_.id = p2_.property_type_id
  AND (p1_.deleted_at IS NULL)
  INNER JOIN paragraphs_sections p4_ ON c0_.id = p4_.paragraph_id
  INNER JOIN sections s3_ ON s3_.id = p4_.section_id
  INNER JOIN paragraphs_locations p6_ ON c0_.id = p6_.paragraph_id
  INNER JOIN locations l5_ ON l5_.id = p6_.location_id
WHERE
  p1_.id IN (?)
  AND s3_.id = ?
  AND c0_.place = ?
  AND l5_.id IN (?)
  AND (
    SELECT
      COUNT(*)
    FROM
      paragraphs_compound_locations p7_
    WHERE
      p7_.paragraph_id = c0_.id
  ) = 0
  AND c0_.by_owner_only = ?
LIMIT
  1

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_property_types p2_ ON c0_.id = p2_.paragraph_id INNER JOIN property_types p1_ ON p1_.id = p2_.property_type_id AND (p1_.deleted_at IS NULL) INNER JOIN paragraphs_sections p4_ ON c0_.id = p4_.paragraph_id INNER JOIN sections s3_ ON s3_.id = p4_.section_id INNER JOIN paragraphs_locations p6_ ON c0_.id = p6_.paragraph_id INNER JOIN locations l5_ ON l5_.id = p6_.location_id WHERE p1_.id IN (5) AND s3_.id = 2 AND c0_.place = 1 AND l5_.id IN (23496) AND (SELECT COUNT(*) FROM paragraphs_compound_locations p7_ WHERE p7_.paragraph_id = c0_.id) = 0 AND c0_.by_owner_only = 0 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_.searchable AS searchable_14,
  p0_.deleted_at AS deleted_at_15,
  p0_.custom_order AS custom_order_16,
  p0_.amenities AS amenities_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

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_.searchable AS searchable_14, p0_.deleted_at AS deleted_at_15, p0_.custom_order AS custom_order_16, p0_.amenities AS amenities_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;

SELECT
  COUNT(*)
FROM
  listings t0
WHERE
  t0.section_id = ?
  AND t0.property_type_id = ?
  AND t0.location_id = ?
  AND t0.status = ?
  AND t0.featured IN (?, ?, ?, ?, ?, ?)
  AND (
    (t0.deleted_at IS NULL)
  )

SELECT COUNT(*) FROM listings t0 WHERE t0.section_id = 2 AND t0.property_type_id = 5 AND t0.location_id = 23496 AND t0.status = 2 AND t0.featured IN (2, 8, 7, 5, 6, 4) AND ((t0.deleted_at IS NULL));

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_.searchable AS searchable_14,
  p0_.deleted_at AS deleted_at_15,
  p0_.custom_order AS custom_order_16,
  p0_.amenities AS amenities_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

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_.searchable AS searchable_14, p0_.deleted_at AS deleted_at_15, p0_.custom_order AS custom_order_16, p0_.amenities AS amenities_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;

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.section_id = ?
  AND t0.property_type_id = ?
  AND t0.location_id = ?
ORDER BY
  t0.updated_at DESC
LIMIT
  1

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.section_id = 2 AND t0.property_type_id = 5 AND t0.location_id = 23496 ORDER BY t0.updated_at DESC LIMIT 1;

SELECT
  p0_.title AS title_0
FROM
  property_types p0_
WHERE
  (
    p0_.parent_id = 5
    AND p0_.private = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.title AS title_0 FROM property_types p0_ WHERE (p0_.parent_id = 5 AND p0_.private = 0) AND (p0_.deleted_at IS NULL);