Symfony Profiler

SELECT
  p0_.id AS id_0,
  p0_.title AS title_1,
  p0_.slug AS slug_2,
  p0_.private AS private_3,
  p0_.level AS level_4,
  p0_._left AS _left_5,
  p0_._right AS _right_6,
  p0_.root AS root_7,
  p0_.compound_related AS compound_related_8,
  p0_.reference_id AS reference_id_9,
  p0_.exchangeable AS exchangeable_10,
  p0_.is_evaluable AS is_evaluable_11,
  p0_.synced AS synced_12,
  p0_.searchable AS searchable_13,
  p0_.deleted_at AS deleted_at_14,
  p0_.custom_order AS custom_order_15,
  p0_.parent_id AS parent_id_16
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_.slug AS slug_2, p0_.private AS private_3, p0_.level AS level_4, p0_._left AS _left_5, p0_._right AS _right_6, p0_.root AS root_7, p0_.compound_related AS compound_related_8, p0_.reference_id AS reference_id_9, p0_.exchangeable AS exchangeable_10, p0_.is_evaluable AS is_evaluable_11, p0_.synced AS synced_12, p0_.searchable AS searchable_13, p0_.deleted_at AS deleted_at_14, p0_.custom_order AS custom_order_15, p0_.parent_id AS parent_id_16 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.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 = 1;

SELECT
  l0_.id AS id_0,
  COALESCE(t1_.content, l0_.title) AS title_1,
  COALESCE(t2_.content, l0_.alias) AS alias_2,
  COALESCE(t3_.content, 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_.eligible_for_mortgage AS eligible_for_mortgage_26,
  l0_.is_compound_location AS is_compound_location_27,
  l0_.parent_id AS parent_id_28,
  l0_.location_compound_id AS location_compound_id_29,
  l0_.rating_id AS rating_id_30,
  l0_.listing_id AS listing_id_31
FROM
  locations l0_
  LEFT JOIN locations_translations t1_ ON t1_.locale = 'en'
  AND t1_.field = 'title'
  AND t1_.location_id = l0_.id
  LEFT JOIN locations_translations t2_ ON t2_.locale = 'en'
  AND t2_.field = 'alias'
  AND t2_.location_id = l0_.id
  LEFT JOIN locations_translations t3_ ON t3_.locale = 'en'
  AND t3_.field = 'description'
  AND t3_.location_id = l0_.id
WHERE
  l0_.parent_id IS NULL
  AND l0_.disabled = ?
  AND l0_.searchable = ?
LIMIT
  1

SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, 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_.eligible_for_mortgage AS eligible_for_mortgage_26, l0_.is_compound_location AS is_compound_location_27, l0_.parent_id AS parent_id_28, l0_.location_compound_id AS location_compound_id_29, l0_.rating_id AS rating_id_30, l0_.listing_id AS listing_id_31 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = 0 AND l0_.searchable = 1 LIMIT 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 = 31;

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

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

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

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

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

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

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

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

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

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
  t0.id AS id_1,
  t0.title AS title_2,
  t0.slug AS slug_3,
  t0.private AS private_4,
  t0.level AS level_5,
  t0._left AS _left_6,
  t0._right AS _right_7,
  t0.root AS root_8,
  t0.compound_related AS compound_related_9,
  t0.reference_id AS reference_id_10,
  t0.exchangeable AS exchangeable_11,
  t0.is_evaluable AS is_evaluable_12,
  t0.synced AS synced_13,
  t0.searchable AS searchable_14,
  t0.deleted_at AS deleted_at_15,
  t0.custom_order AS custom_order_16,
  t0.parent_id AS parent_id_17
FROM
  property_types t0
WHERE
  t0.id = ?
  AND (
    (t0.deleted_at IS NULL)
  )
LIMIT
  1

SELECT t0.id AS id_1, t0.title AS title_2, t0.slug AS slug_3, t0.private AS private_4, t0.level AS level_5, t0._left AS _left_6, t0._right AS _right_7, t0.root AS root_8, t0.compound_related AS compound_related_9, t0.reference_id AS reference_id_10, t0.exchangeable AS exchangeable_11, t0.is_evaluable AS is_evaluable_12, t0.synced AS synced_13, t0.searchable AS searchable_14, t0.deleted_at AS deleted_at_15, t0.custom_order AS custom_order_16, t0.parent_id AS parent_id_17 FROM property_types t0 WHERE t0.id = 2 AND ((t0.deleted_at IS NULL)) LIMIT 1;

SELECT
  p0_.id AS id_0
FROM
  property_types p0_
WHERE
  (
    p0_._right < 9
    AND p0_._left > 2
    AND p0_.root = ?
  )
  AND (p0_.deleted_at IS NULL)

SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 9 AND p0_._left > 2 AND p0_.root = 1) AND (p0_.deleted_at IS NULL);

SELECT
  t0.id AS id_1,
  t0.name AS name_2,
  t0.value AS value_3,
  t0.synced AS synced_4
FROM
  listing_score_settings t0

SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0;

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.eligible_for_mortgage AS eligible_for_mortgage_27,
  t0.is_compound_location AS is_compound_location_28,
  t0.parent_id AS parent_id_29,
  t0.location_compound_id AS location_compound_id_30,
  t0.rating_id AS rating_id_31,
  t0.listing_id AS listing_id_32
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.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.eligible_for_mortgage AS eligible_for_mortgage_27, t0.is_compound_location AS is_compound_location_28, t0.parent_id AS parent_id_29, t0.location_compound_id AS location_compound_id_30, t0.rating_id AS rating_id_31, t0.listing_id AS listing_id_32 FROM locations t0 WHERE t0.id = '505';

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

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_.eligible_for_mortgage AS eligible_for_mortgage_26,
  l0_.is_compound_location AS is_compound_location_27,
  l0_.parent_id AS parent_id_28,
  l0_.location_compound_id AS location_compound_id_29,
  l0_.rating_id AS rating_id_30,
  l0_.listing_id AS listing_id_31
FROM
  locations l0_
WHERE
  l0_._right < 3
  AND l0_._left > 2
  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_.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_.eligible_for_mortgage AS eligible_for_mortgage_26, l0_.is_compound_location AS is_compound_location_27, l0_.parent_id AS parent_id_28, l0_.location_compound_id AS location_compound_id_29, l0_.rating_id AS rating_id_30, l0_.listing_id AS listing_id_31 FROM locations l0_ WHERE l0_._right < 3 AND l0_._left > 2 AND l0_.root = 504 ORDER BY l0_._left ASC;

SELECT
  d0_.id AS id_0,
  d0_.content AS content_1,
  d0_.status AS status_2,
  d0_.created_at AS created_at_3,
  d0_.updated_at AS updated_at_4,
  d0_.comments_counter AS comments_counter_5,
  d0_.deleted_at AS deleted_at_6,
  d0_.severity AS severity_7,
  d0_.subscribers_notified AS subscribers_notified_8,
  d0_.reach_count AS reach_count_9,
  d0_.user_id AS user_id_10,
  d0_.location_id AS location_id_11,
  d0_.category_id AS category_id_12
FROM
  discussions d0_
WHERE
  (
    d0_.status = ?
    AND d0_.location_id IN (?)
    AND d0_.comments_counter = 0
  )
  AND (d0_.deleted_at IS NULL)
ORDER BY
  d0_.comments_counter DESC,
  d0_.created_at DESC

SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ WHERE (d0_.status = 2 AND d0_.location_id IN (505) AND d0_.comments_counter = 0) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.created_at DESC;

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_.eligible_for_mortgage AS eligible_for_mortgage_26,
  l0_.is_compound_location AS is_compound_location_27,
  l0_.parent_id AS parent_id_28,
  l0_.location_compound_id AS location_compound_id_29,
  l0_.rating_id AS rating_id_30,
  l0_.listing_id AS listing_id_31
FROM
  locations l0_
WHERE
  l0_._right < 3
  AND l0_._left > 2
  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_.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_.eligible_for_mortgage AS eligible_for_mortgage_26, l0_.is_compound_location AS is_compound_location_27, l0_.parent_id AS parent_id_28, l0_.location_compound_id AS location_compound_id_29, l0_.rating_id AS rating_id_30, l0_.listing_id AS listing_id_31 FROM locations l0_ WHERE l0_._right < 3 AND l0_._left > 2 AND l0_.root = 504 ORDER BY l0_._left ASC;

SELECT
  l0_.id AS id_0,
  l0_.title AS title_1,
  l0_.description AS description_2,
  l0_.category AS category_3,
  l0_.pending_photos_status AS pending_photos_status_4,
  l0_.pending_payment_status AS pending_payment_status_5,
  l0_.relist_status AS relist_status_6,
  l0_.seller_role AS seller_role_7,
  l0_.area AS area_8,
  l0_.price AS price_9,
  l0_.address AS address_10,
  l0_.center_lat AS center_lat_11,
  l0_.center_lng AS center_lng_12,
  l0_.status AS status_13,
  l0_.property_view AS property_view_14,
  l0_.payment_method AS payment_method_15,
  l0_.featured AS featured_16,
  l0_.views AS views_17,
  l0_.phone_counter AS phone_counter_18,
  l0_.messages_counter AS messages_counter_19,
  l0_.leads_counter AS leads_counter_20,
  l0_.sent_notifiers AS sent_notifiers_21,
  l0_.relist_counter AS relist_counter_22,
  l0_.ip AS ip_23,
  l0_.video_url AS video_url_24,
  l0_.slug AS slug_25,
  l0_.custom_slug AS custom_slug_26,
  l0_.score AS score_27,
  l0_.created_at AS created_at_28,
  l0_.updated_at AS updated_at_29,
  l0_.pending_status_created_at AS pending_status_created_at_30,
  l0_.published_at AS published_at_31,
  l0_.expires_at AS expires_at_32,
  l0_.deleted_at AS deleted_at_33,
  l0_.rejected_at AS rejected_at_34,
  l0_.campaign AS campaign_35,
  l0_.final_price AS final_price_36,
  l0_.source_of_sale AS source_of_sale_37,
  l0_.delete_reason AS delete_reason_38,
  l0_.delete_reason_details AS delete_reason_details_39,
  l0_.source AS source_40,
  l0_.impressions AS impressions_41,
  l0_.impressions_monthly_count AS impressions_monthly_count_42,
  l0_.impressions_weekly_count AS impressions_weekly_count_43,
  l0_.impression_updated_at AS impression_updated_at_44,
  l0_.price_level AS price_level_45,
  l0_.compound_status AS compound_status_46,
  l0_.price_per_meter AS price_per_meter_47,
  l0_.is_bumped AS is_bumped_48,
  l0_.is_send_email AS is_send_email_49,
  l0_.market_property_type AS market_property_type_50,
  l0_.creation_source AS creation_source_51,
  l0_.click_through_rate AS click_through_rate_52,
  l0_.label AS label_53,
  l0_.is_top_picks AS is_top_picks_54,
  l0_.contact_rate AS contact_rate_55,
  l0_.synced AS synced_56,
  l0_.reference_id AS reference_id_57,
  l0_.is_pending_featuring AS is_pending_featuring_58,
  l0_.pending_featuring_type AS pending_featuring_type_59,
  l0_.rate_status AS rate_status_60,
  l0_.is_rate_reviewed AS is_rate_reviewed_61,
  l0_.is_call_request AS is_call_request_62,
  l0_.is_shown_in_homepage AS is_shown_in_homepage_63,
  l0_.is_commercial AS is_commercial_64,
  l0_.is_resale AS is_resale_65,
  l0_.is_rent AS is_rent_66,
  l0_.is_primary AS is_primary_67,
  l0_.is_mortgage_approved AS is_mortgage_approved_68,
  l0_.meta_title AS meta_title_69,
  l0_.meta_description AS meta_description_70,
  l0_.is_mortgage AS is_mortgage_71,
  l0_.eligible_for_mortgage AS eligible_for_mortgage_72,
  l0_.property_registration_status AS property_registration_status_73,
  l0_.advertiser_number AS advertiser_number_74,
  l0_.authorization_number AS authorization_number_75,
  l0_.freezed_at AS freezed_at_76,
  l0_.eligible_for_bumpup AS eligible_for_bumpup_77,
  l0_.waiting_time AS waiting_time_78,
  l0_.reference_number AS reference_number_79,
  l0_.parent_id AS parent_id_80,
  l0_.relist_id AS relist_id_81,
  l0_.section_id AS section_id_82,
  l0_.property_type_id AS property_type_id_83,
  l0_.location_id AS location_id_84,
  l0_.compound_location_id AS compound_location_id_85,
  l0_.user_id AS user_id_86,
  l0_.compound_field_id AS compound_field_id_87
FROM
  listings l0_
WHERE
  (
    l0_.status = ?
    AND l0_.location_id IN (?)
  )
  AND (l0_.deleted_at IS NULL)
ORDER BY
  l0_.published_at DESC
LIMIT
  4

SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.expires_at AS expires_at_32, l0_.deleted_at AS deleted_at_33, l0_.rejected_at AS rejected_at_34, l0_.campaign AS campaign_35, l0_.final_price AS final_price_36, l0_.source_of_sale AS source_of_sale_37, l0_.delete_reason AS delete_reason_38, l0_.delete_reason_details AS delete_reason_details_39, l0_.source AS source_40, l0_.impressions AS impressions_41, l0_.impressions_monthly_count AS impressions_monthly_count_42, l0_.impressions_weekly_count AS impressions_weekly_count_43, l0_.impression_updated_at AS impression_updated_at_44, l0_.price_level AS price_level_45, l0_.compound_status AS compound_status_46, l0_.price_per_meter AS price_per_meter_47, l0_.is_bumped AS is_bumped_48, l0_.is_send_email AS is_send_email_49, l0_.market_property_type AS market_property_type_50, l0_.creation_source AS creation_source_51, l0_.click_through_rate AS click_through_rate_52, l0_.label AS label_53, l0_.is_top_picks AS is_top_picks_54, l0_.contact_rate AS contact_rate_55, l0_.synced AS synced_56, l0_.reference_id AS reference_id_57, l0_.is_pending_featuring AS is_pending_featuring_58, l0_.pending_featuring_type AS pending_featuring_type_59, l0_.rate_status AS rate_status_60, l0_.is_rate_reviewed AS is_rate_reviewed_61, l0_.is_call_request AS is_call_request_62, l0_.is_shown_in_homepage AS is_shown_in_homepage_63, l0_.is_commercial AS is_commercial_64, l0_.is_resale AS is_resale_65, l0_.is_rent AS is_rent_66, l0_.is_primary AS is_primary_67, l0_.is_mortgage_approved AS is_mortgage_approved_68, l0_.meta_title AS meta_title_69, l0_.meta_description AS meta_description_70, l0_.is_mortgage AS is_mortgage_71, l0_.eligible_for_mortgage AS eligible_for_mortgage_72, l0_.property_registration_status AS property_registration_status_73, l0_.advertiser_number AS advertiser_number_74, l0_.authorization_number AS authorization_number_75, l0_.freezed_at AS freezed_at_76, l0_.eligible_for_bumpup AS eligible_for_bumpup_77, l0_.waiting_time AS waiting_time_78, l0_.reference_number AS reference_number_79, l0_.parent_id AS parent_id_80, l0_.relist_id AS relist_id_81, l0_.section_id AS section_id_82, l0_.property_type_id AS property_type_id_83, l0_.location_id AS location_id_84, l0_.compound_location_id AS compound_location_id_85, l0_.user_id AS user_id_86, l0_.compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE (l0_.status = 2 AND l0_.location_id IN (505)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;