Symfony Profiler

Query Metrics

47 Database Queries

21 Different statements

331.70 ms Query time

8 Invalid entities

1233 Managed entities

Queries


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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1
SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ?
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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) 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 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL)
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 = ?
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_._right < 9067 AND l0_._left > 7132 AND l0_.root = ? 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_ INNER JOIN comments c1_ ON d0_.id = c1_.discussion_id AND (c1_.deleted_at IS NULL) 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_.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_.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_._right < 9067 AND l0_._left > 7132 AND l0_.root = ? 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 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 d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
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 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_._left <= 7132 AND l0_._right >= 9067 AND l0_.root = ? ORDER BY l0_._left ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
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 = ?
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_._left <= 7132 AND l0_._right >= 9067 AND l0_.root = ? ORDER BY l0_._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_.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_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count 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_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC
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 = ?

#▲	Time	Info
1	3.64 ms	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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 Parameters: [`false true`] View formatted query View runnable query Explain query 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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 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_.parent_id IS NULL AND l0_.disabled = 0 AND l0_.searchable = 1 LIMIT 1;
2	58.66 ms	SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ? SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = 1;
3	2.48 ms	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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query 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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 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.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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
4	2.16 ms	SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) AND (p0_.deleted_at IS NULL) Parameters: [`83`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM property_types p0_ WHERE ( p0_._right < 41 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 < 41 AND p0_._left > 2 AND p0_.root = 83) AND (p0_.deleted_at IS NULL);
5	2.20 ms	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 Parameters: [] View formatted query View runnable query Explain query 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;
6	4.06 ms	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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) Parameters: [`"347" "79" "318" "183" "126"`] View formatted query View runnable query Explain query 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE ( l0_.id IN (?, ?, ?, ?, ?) ) AND (l0_.deleted_at IS NULL) 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN ('347', '79', '318', '183', '126')) AND (l0_.deleted_at IS NULL);
7	6.41 ms	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 = ? Parameters: [`"31"`] View formatted query View runnable query Explain query 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 = ? 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 = '31';
8	58.59 ms	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_._right < 9067 AND l0_._left > 7132 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query 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_._right < 9067 AND l0_._left > 7132 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_.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_._right < 9067 AND l0_._left > 7132 AND l0_.root = 1 ORDER BY l0_._left ASC;
9	7.85 ms	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_ INNER JOIN comments c1_ ON d0_.id = c1_.discussion_id AND (c1_.deleted_at IS NULL) 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_.comments_counter DESC, d0_.created_at DESC Parameters: [2 31 7474 27024 24939 24322 7184 7185 7116 7190 24932 23798 26237 318 805 806 807 808 809 810 811 812 813 814 23120 23126 23179 23387 815 816 817 23127 23185 23231 23235 23243 23253 23257 23263 23283 818 23128 23187 23195 23202 23266 23269 23278 23287 23390 23392 319 819 23192 23194 23273 23297 23304 23329 23335 23338 23339 23399 27919 27920 28096 820 23199 23200 23208 23212 23274 23275 23281 23288 23290 23292 23299 23303 23307 23309 23310 23311 23313 23316 23317 23320 23321 23324 23343 23349 23350 23355 23356 23400 23401 23402 23403 23404 23405 23406 23407 23408 27941 821 23214 23215 23216 23226 23232 23240 23315 23323 23327 23331 23332 23333 23336 23337 23341 23342 23344 23347 23357 23358 23359 23361 23362 23365 23366 23371 23373 23376 23381 23383 23409 23410 23411 23412 23413 23414 23415 28376 822 23249 23256 23298 23300 23302 23345 23346 23348 23351 23353 23354 23363 23368 23378 23380 23382 23384 23386 23388 23389 23391 23393 23416 23417 23418 27731 27764 28992 29027 823 23419 23420 23421 23422 23423 23424 23425 23426 23427 23428 23429 23430 23431 23432 23433 23434 23435 23436 23437 23438 23439 23440 23441 23442 23443 23444 23445 23446 23447 23449 23450 23451 23452 23453 23454 23455 23456 23457 23458 23459 23463 23465 23471 23474 824 23448 23460 23461 23462 23464 23466 23467 23468 23469 23475 23476 23477 23478 23479 23480 23481 23484 23489 23490 23492 23498 28228 28396 28397 28398 28399 28400 28401 28402 28403 825 23470 23472 23473 23482 23483 23485 23486 23487 23488 23491 23493 23500 23502 23503 23505 23507 23508 23509 826 23494 23495 23496 23497 23499 23501 23510 23511 23512 23513 23514 23515 23516 23517 23518 23520 23522 23524 23525 23526 23792 23793 28942 827 828 829 830 23504 23506 23519 23521 23523 23527 23528 23529 23530 23531 25964 25965 25966 25967 25174 320 25512 831 832 23264 23396 833 834 835 836 837 838 839 840 23984 24429 26915 321 7448 25405 25724 24002 25723 25404 25403 25402 26835 27733 29113 24626 24051 24872 7192 7236 841 842 843 844 845 846 847 23188 23191 23322 848 23270 23326 850 23318 23319 23397 23398 851 24036 24587 24639 28905 27135 26988 26240 25216 24549 24508 24407 24349 24314 24277 24233 24053 24025 23976 23616 15477 7256 6967 4216 1254 1245 1219 1175 1172 1166 1151 1150 1149 1148 1144 1143 1142 1141 1140 1138 1137 1136 1134 1116 1070 1067 1064 918 917 916 915 914 913 912 911 909 908 905 907 904 903 902 900 899 898 897 444 7257 1192 25285 7685 24242 906 24135 1145 24296 1270 21285 1252 849 910 7501 7243 23704 23914 23800 28315 25306 25309 25315 25385 25531 25593 26313 26690 26804 26888 26904 27079 27090 27091 27154 27223 27233 27234 27450 27452 27465 27525 27526 27527 27624 27672 27728 27729 27782 27783 27825 27826 27842 27898 27952 27968 27993 28050 28051 28056 28066 28333 28346 28383 28405 28406 28433 28461 28472 28542 28543 28567 28584 28585 28612 28621 28716 28983 29043 29133 29243 29246 24647 25074 25283 25284 26320 26321 26322 26323 27424 28054 28277 28827 28993 29204 322 28643 7522 852 28507 853 854 2656 24633 24634 26300 323 855 23140 23280 856 28454 28475 28476 28477 28478 28479 28480 28481 28482 28483 28484 857 23209 23293 28427 28428 28429 28430 28450 28451 28452 28453 858 23146 23147 23150 23164 23175 23181 23210 23221 23239 23245 23252 23259 23282 23285 23286 23289 23291 23294 23305 23308 23314 23394 23395 324 859 860 861 862 863 864 1348 325 28791 28423 28239 26808 26798 24446 25273 26942 25661 25498 23891 23772 7465 7431 7140 1131 1129 921 886 883 882 877 876 874 873 872 26809 7132 441 24512 23895 7635 7130 6963 27198 25534 23713 23709 4980 25112 24610 24058 25276 7131 24578 21286 448 447 463 23771 23617 870 880 1122 881 871 934 935 1282 1293 7182 6929 7193 1066 1071 6961 6465 1356 7004 865 885 884 1180 25202 25287 25288 25463 27337 1121 866 867 1123 868 1124 7012 869 1127 1128 1130 1132 1133 25214 878 25532 25533 879 25732 24635 24636 24616 24615 25218 25258 25259 25260 25261 25733 25734 25735 25736 25738 25739 29196 1135 887 888 7032 889 890 891 892 893 894 895 896 1152 1153 1154 1155 1156 901 1157 1158 1159 1160 7054 1167 1168 1169 1170 1171 7059 919 920 922 923 1179 924 925 1181 926 1182 927 1183 928 929 930 1186 3234 931 1187 932 933 936 937 938 1194 939 1195 940 941 942 943 7139 25278 25394 7141 7142 7143 7145 1258 1260 7324 7336 7452 7464 7490 7630 7835 23539 23541 23609 23610 23611 23612 23613 23615 23618 23619 23631 23680 23689 23724 23734 23781 23799 23857 23887 23902 23908 23916 23935 23946 23982 23990 24052 24057 24265 24281 24287 24291 24305 24306 24315 24320 24386 24412 24417 24421 24463 24464 24465 24640 24642 25062 25113 25117 25198 25299 25300 25452 25455 25521 25543 25624 25632 25636 25642 25740 26615 26617 26631 26710 27050 26713 26749 26833 26848 26869 26872 26881 26987 27003 27011 1126 27082 27085 27099 27105 27121 27123 27124 27144 27235 27249 27250 27251 27328 27363 27379 27390 27531 27532 27579 27583 27610 27620 27647 27650 27736 27741 27784 27823 27881 27896 28010 28014 28048 28049 28061 28076 28087 28131 28172 28178 28323 28347 28446 28556 28562 28568 28574 28575 28577 28622 28626 28627 28681 28692 28697 28737 28768 28773 28835 28839 28866 28947 28956 29019 29020 29044 29123 29152 29153 29154 29160 29161 29182 29223 29228 29241 29242 29245 29251 29253 6989 6990 24871 6995 7003 4714 1222 7455 7502 7521 19049 23708 23711 24319 24321 24943 24945 25124 25891 26306 28100 28211 28232 28380 28678 28818 28859] View formatted query View runnable query Explain query 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_ INNER JOIN comments c1_ ON d0_.id = c1_.discussion_id AND (c1_.deleted_at IS NULL) 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_.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_ INNER JOIN comments c1_ ON d0_.id = c1_.discussion_id AND (c1_.deleted_at IS NULL) WHERE (d0_.status = 2 AND d0_.location_id IN (31, 7474, 27024, 24939, 24322, 7184, 7185, 7116, 7190, 24932, 23798, 26237, 318, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 23120, 23126, 23179, 23387, 815, 816, 817, 23127, 23185, 23231, 23235, 23243, 23253, 23257, 23263, 23283, 818, 23128, 23187, 23195, 23202, 23266, 23269, 23278, 23287, 23390, 23392, 319, 819, 23192, 23194, 23273, 23297, 23304, 23329, 23335, 23338, 23339, 23399, 27919, 27920, 28096, 820, 23199, 23200, 23208, 23212, 23274, 23275, 23281, 23288, 23290, 23292, 23299, 23303, 23307, 23309, 23310, 23311, 23313, 23316, 23317, 23320, 23321, 23324, 23343, 23349, 23350, 23355, 23356, 23400, 23401, 23402, 23403, 23404, 23405, 23406, 23407, 23408, 27941, 821, 23214, 23215, 23216, 23226, 23232, 23240, 23315, 23323, 23327, 23331, 23332, 23333, 23336, 23337, 23341, 23342, 23344, 23347, 23357, 23358, 23359, 23361, 23362, 23365, 23366, 23371, 23373, 23376, 23381, 23383, 23409, 23410, 23411, 23412, 23413, 23414, 23415, 28376, 822, 23249, 23256, 23298, 23300, 23302, 23345, 23346, 23348, 23351, 23353, 23354, 23363, 23368, 23378, 23380, 23382, 23384, 23386, 23388, 23389, 23391, 23393, 23416, 23417, 23418, 27731, 27764, 28992, 29027, 823, 23419, 23420, 23421, 23422, 23423, 23424, 23425, 23426, 23427, 23428, 23429, 23430, 23431, 23432, 23433, 23434, 23435, 23436, 23437, 23438, 23439, 23440, 23441, 23442, 23443, 23444, 23445, 23446, 23447, 23449, 23450, 23451, 23452, 23453, 23454, 23455, 23456, 23457, 23458, 23459, 23463, 23465, 23471, 23474, 824, 23448, 23460, 23461, 23462, 23464, 23466, 23467, 23468, 23469, 23475, 23476, 23477, 23478, 23479, 23480, 23481, 23484, 23489, 23490, 23492, 23498, 28228, 28396, 28397, 28398, 28399, 28400, 28401, 28402, 28403, 825, 23470, 23472, 23473, 23482, 23483, 23485, 23486, 23487, 23488, 23491, 23493, 23500, 23502, 23503, 23505, 23507, 23508, 23509, 826, 23494, 23495, 23496, 23497, 23499, 23501, 23510, 23511, 23512, 23513, 23514, 23515, 23516, 23517, 23518, 23520, 23522, 23524, 23525, 23526, 23792, 23793, 28942, 827, 828, 829, 830, 23504, 23506, 23519, 23521, 23523, 23527, 23528, 23529, 23530, 23531, 25964, 25965, 25966, 25967, 25174, 320, 25512, 831, 832, 23264, 23396, 833, 834, 835, 836, 837, 838, 839, 840, 23984, 24429, 26915, 321, 7448, 25405, 25724, 24002, 25723, 25404, 25403, 25402, 26835, 27733, 29113, 24626, 24051, 24872, 7192, 7236, 841, 842, 843, 844, 845, 846, 847, 23188, 23191, 23322, 848, 23270, 23326, 850, 23318, 23319, 23397, 23398, 851, 24036, 24587, 24639, 28905, 27135, 26988, 26240, 25216, 24549, 24508, 24407, 24349, 24314, 24277, 24233, 24053, 24025, 23976, 23616, 15477, 7256, 6967, 4216, 1254, 1245, 1219, 1175, 1172, 1166, 1151, 1150, 1149, 1148, 1144, 1143, 1142, 1141, 1140, 1138, 1137, 1136, 1134, 1116, 1070, 1067, 1064, 918, 917, 916, 915, 914, 913, 912, 911, 909, 908, 905, 907, 904, 903, 902, 900, 899, 898, 897, 444, 7257, 1192, 25285, 7685, 24242, 906, 24135, 1145, 24296, 1270, 21285, 1252, 849, 910, 7501, 7243, 23704, 23914, 23800, 28315, 25306, 25309, 25315, 25385, 25531, 25593, 26313, 26690, 26804, 26888, 26904, 27079, 27090, 27091, 27154, 27223, 27233, 27234, 27450, 27452, 27465, 27525, 27526, 27527, 27624, 27672, 27728, 27729, 27782, 27783, 27825, 27826, 27842, 27898, 27952, 27968, 27993, 28050, 28051, 28056, 28066, 28333, 28346, 28383, 28405, 28406, 28433, 28461, 28472, 28542, 28543, 28567, 28584, 28585, 28612, 28621, 28716, 28983, 29043, 29133, 29243, 29246, 24647, 25074, 25283, 25284, 26320, 26321, 26322, 26323, 27424, 28054, 28277, 28827, 28993, 29204, 322, 28643, 7522, 852, 28507, 853, 854, 2656, 24633, 24634, 26300, 323, 855, 23140, 23280, 856, 28454, 28475, 28476, 28477, 28478, 28479, 28480, 28481, 28482, 28483, 28484, 857, 23209, 23293, 28427, 28428, 28429, 28430, 28450, 28451, 28452, 28453, 858, 23146, 23147, 23150, 23164, 23175, 23181, 23210, 23221, 23239, 23245, 23252, 23259, 23282, 23285, 23286, 23289, 23291, 23294, 23305, 23308, 23314, 23394, 23395, 324, 859, 860, 861, 862, 863, 864, 1348, 325, 28791, 28423, 28239, 26808, 26798, 24446, 25273, 26942, 25661, 25498, 23891, 23772, 7465, 7431, 7140, 1131, 1129, 921, 886, 883, 882, 877, 876, 874, 873, 872, 26809, 7132, 441, 24512, 23895, 7635, 7130, 6963, 27198, 25534, 23713, 23709, 4980, 25112, 24610, 24058, 25276, 7131, 24578, 21286, 448, 447, 463, 23771, 23617, 870, 880, 1122, 881, 871, 934, 935, 1282, 1293, 7182, 6929, 7193, 1066, 1071, 6961, 6465, 1356, 7004, 865, 885, 884, 1180, 25202, 25287, 25288, 25463, 27337, 1121, 866, 867, 1123, 868, 1124, 7012, 869, 1127, 1128, 1130, 1132, 1133, 25214, 878, 25532, 25533, 879, 25732, 24635, 24636, 24616, 24615, 25218, 25258, 25259, 25260, 25261, 25733, 25734, 25735, 25736, 25738, 25739, 29196, 1135, 887, 888, 7032, 889, 890, 891, 892, 893, 894, 895, 896, 1152, 1153, 1154, 1155, 1156, 901, 1157, 1158, 1159, 1160, 7054, 1167, 1168, 1169, 1170, 1171, 7059, 919, 920, 922, 923, 1179, 924, 925, 1181, 926, 1182, 927, 1183, 928, 929, 930, 1186, 3234, 931, 1187, 932, 933, 936, 937, 938, 1194, 939, 1195, 940, 941, 942, 943, 7139, 25278, 25394, 7141, 7142, 7143, 7145, 1258, 1260, 7324, 7336, 7452, 7464, 7490, 7630, 7835, 23539, 23541, 23609, 23610, 23611, 23612, 23613, 23615, 23618, 23619, 23631, 23680, 23689, 23724, 23734, 23781, 23799, 23857, 23887, 23902, 23908, 23916, 23935, 23946, 23982, 23990, 24052, 24057, 24265, 24281, 24287, 24291, 24305, 24306, 24315, 24320, 24386, 24412, 24417, 24421, 24463, 24464, 24465, 24640, 24642, 25062, 25113, 25117, 25198, 25299, 25300, 25452, 25455, 25521, 25543, 25624, 25632, 25636, 25642, 25740, 26615, 26617, 26631, 26710, 27050, 26713, 26749, 26833, 26848, 26869, 26872, 26881, 26987, 27003, 27011, 1126, 27082, 27085, 27099, 27105, 27121, 27123, 27124, 27144, 27235, 27249, 27250, 27251, 27328, 27363, 27379, 27390, 27531, 27532, 27579, 27583, 27610, 27620, 27647, 27650, 27736, 27741, 27784, 27823, 27881, 27896, 28010, 28014, 28048, 28049, 28061, 28076, 28087, 28131, 28172, 28178, 28323, 28347, 28446, 28556, 28562, 28568, 28574, 28575, 28577, 28622, 28626, 28627, 28681, 28692, 28697, 28737, 28768, 28773, 28835, 28839, 28866, 28947, 28956, 29019, 29020, 29044, 29123, 29152, 29153, 29154, 29160, 29161, 29182, 29223, 29228, 29241, 29242, 29245, 29251, 29253, 6989, 6990, 24871, 6995, 7003, 4714, 1222, 7455, 7502, 7521, 19049, 23708, 23711, 24319, 24321, 24943, 24945, 25124, 25891, 26306, 28100, 28211, 28232, 28380, 28678, 28818, 28859) AND d0_.comments_counter > 0) AND (d0_.deleted_at IS NULL) ORDER BY d0_.comments_counter DESC, d0_.comments_counter DESC, d0_.created_at DESC;
10	49.91 ms	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_._right < 9067 AND l0_._left > 7132 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query 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_._right < 9067 AND l0_._left > 7132 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_.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_._right < 9067 AND l0_._left > 7132 AND l0_.root = 1 ORDER BY l0_._left ASC;
11	35.85 ms	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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 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 Parameters: [2 31 7474 27024 24939 24322 7184 7185 7116 7190 24932 23798 26237 318 805 806 807 808 809 810 811 812 813 814 23120 23126 23179 23387 815 816 817 23127 23185 23231 23235 23243 23253 23257 23263 23283 818 23128 23187 23195 23202 23266 23269 23278 23287 23390 23392 319 819 23192 23194 23273 23297 23304 23329 23335 23338 23339 23399 27919 27920 28096 820 23199 23200 23208 23212 23274 23275 23281 23288 23290 23292 23299 23303 23307 23309 23310 23311 23313 23316 23317 23320 23321 23324 23343 23349 23350 23355 23356 23400 23401 23402 23403 23404 23405 23406 23407 23408 27941 821 23214 23215 23216 23226 23232 23240 23315 23323 23327 23331 23332 23333 23336 23337 23341 23342 23344 23347 23357 23358 23359 23361 23362 23365 23366 23371 23373 23376 23381 23383 23409 23410 23411 23412 23413 23414 23415 28376 822 23249 23256 23298 23300 23302 23345 23346 23348 23351 23353 23354 23363 23368 23378 23380 23382 23384 23386 23388 23389 23391 23393 23416 23417 23418 27731 27764 28992 29027 823 23419 23420 23421 23422 23423 23424 23425 23426 23427 23428 23429 23430 23431 23432 23433 23434 23435 23436 23437 23438 23439 23440 23441 23442 23443 23444 23445 23446 23447 23449 23450 23451 23452 23453 23454 23455 23456 23457 23458 23459 23463 23465 23471 23474 824 23448 23460 23461 23462 23464 23466 23467 23468 23469 23475 23476 23477 23478 23479 23480 23481 23484 23489 23490 23492 23498 28228 28396 28397 28398 28399 28400 28401 28402 28403 825 23470 23472 23473 23482 23483 23485 23486 23487 23488 23491 23493 23500 23502 23503 23505 23507 23508 23509 826 23494 23495 23496 23497 23499 23501 23510 23511 23512 23513 23514 23515 23516 23517 23518 23520 23522 23524 23525 23526 23792 23793 28942 827 828 829 830 23504 23506 23519 23521 23523 23527 23528 23529 23530 23531 25964 25965 25966 25967 25174 320 25512 831 832 23264 23396 833 834 835 836 837 838 839 840 23984 24429 26915 321 7448 25405 25724 24002 25723 25404 25403 25402 26835 27733 29113 24626 24051 24872 7192 7236 841 842 843 844 845 846 847 23188 23191 23322 848 23270 23326 850 23318 23319 23397 23398 851 24036 24587 24639 28905 27135 26988 26240 25216 24549 24508 24407 24349 24314 24277 24233 24053 24025 23976 23616 15477 7256 6967 4216 1254 1245 1219 1175 1172 1166 1151 1150 1149 1148 1144 1143 1142 1141 1140 1138 1137 1136 1134 1116 1070 1067 1064 918 917 916 915 914 913 912 911 909 908 905 907 904 903 902 900 899 898 897 444 7257 1192 25285 7685 24242 906 24135 1145 24296 1270 21285 1252 849 910 7501 7243 23704 23914 23800 28315 25306 25309 25315 25385 25531 25593 26313 26690 26804 26888 26904 27079 27090 27091 27154 27223 27233 27234 27450 27452 27465 27525 27526 27527 27624 27672 27728 27729 27782 27783 27825 27826 27842 27898 27952 27968 27993 28050 28051 28056 28066 28333 28346 28383 28405 28406 28433 28461 28472 28542 28543 28567 28584 28585 28612 28621 28716 28983 29043 29133 29243 29246 24647 25074 25283 25284 26320 26321 26322 26323 27424 28054 28277 28827 28993 29204 322 28643 7522 852 28507 853 854 2656 24633 24634 26300 323 855 23140 23280 856 28454 28475 28476 28477 28478 28479 28480 28481 28482 28483 28484 857 23209 23293 28427 28428 28429 28430 28450 28451 28452 28453 858 23146 23147 23150 23164 23175 23181 23210 23221 23239 23245 23252 23259 23282 23285 23286 23289 23291 23294 23305 23308 23314 23394 23395 324 859 860 861 862 863 864 1348 325 28791 28423 28239 26808 26798 24446 25273 26942 25661 25498 23891 23772 7465 7431 7140 1131 1129 921 886 883 882 877 876 874 873 872 26809 7132 441 24512 23895 7635 7130 6963 27198 25534 23713 23709 4980 25112 24610 24058 25276 7131 24578 21286 448 447 463 23771 23617 870 880 1122 881 871 934 935 1282 1293 7182 6929 7193 1066 1071 6961 6465 1356 7004 865 885 884 1180 25202 25287 25288 25463 27337 1121 866 867 1123 868 1124 7012 869 1127 1128 1130 1132 1133 25214 878 25532 25533 879 25732 24635 24636 24616 24615 25218 25258 25259 25260 25261 25733 25734 25735 25736 25738 25739 29196 1135 887 888 7032 889 890 891 892 893 894 895 896 1152 1153 1154 1155 1156 901 1157 1158 1159 1160 7054 1167 1168 1169 1170 1171 7059 919 920 922 923 1179 924 925 1181 926 1182 927 1183 928 929 930 1186 3234 931 1187 932 933 936 937 938 1194 939 1195 940 941 942 943 7139 25278 25394 7141 7142 7143 7145 1258 1260 7324 7336 7452 7464 7490 7630 7835 23539 23541 23609 23610 23611 23612 23613 23615 23618 23619 23631 23680 23689 23724 23734 23781 23799 23857 23887 23902 23908 23916 23935 23946 23982 23990 24052 24057 24265 24281 24287 24291 24305 24306 24315 24320 24386 24412 24417 24421 24463 24464 24465 24640 24642 25062 25113 25117 25198 25299 25300 25452 25455 25521 25543 25624 25632 25636 25642 25740 26615 26617 26631 26710 27050 26713 26749 26833 26848 26869 26872 26881 26987 27003 27011 1126 27082 27085 27099 27105 27121 27123 27124 27144 27235 27249 27250 27251 27328 27363 27379 27390 27531 27532 27579 27583 27610 27620 27647 27650 27736 27741 27784 27823 27881 27896 28010 28014 28048 28049 28061 28076 28087 28131 28172 28178 28323 28347 28446 28556 28562 28568 28574 28575 28577 28622 28626 28627 28681 28692 28697 28737 28768 28773 28835 28839 28866 28947 28956 29019 29020 29044 29123 29152 29153 29154 29160 29161 29182 29223 29228 29241 29242 29245 29251 29253 6989 6990 24871 6995 7003 4714 1222 7455 7502 7521 19049 23708 23711 24319 24321 24943 24945 25124 25891 26306 28100 28211 28232 28380 28678 28818 28859] View formatted query View runnable query Explain query 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 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_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.status = 2 AND l0_.location_id IN (31, 7474, 27024, 24939, 24322, 7184, 7185, 7116, 7190, 24932, 23798, 26237, 318, 805, 806, 807, 808, 809, 810, 811, 812, 813, 814, 23120, 23126, 23179, 23387, 815, 816, 817, 23127, 23185, 23231, 23235, 23243, 23253, 23257, 23263, 23283, 818, 23128, 23187, 23195, 23202, 23266, 23269, 23278, 23287, 23390, 23392, 319, 819, 23192, 23194, 23273, 23297, 23304, 23329, 23335, 23338, 23339, 23399, 27919, 27920, 28096, 820, 23199, 23200, 23208, 23212, 23274, 23275, 23281, 23288, 23290, 23292, 23299, 23303, 23307, 23309, 23310, 23311, 23313, 23316, 23317, 23320, 23321, 23324, 23343, 23349, 23350, 23355, 23356, 23400, 23401, 23402, 23403, 23404, 23405, 23406, 23407, 23408, 27941, 821, 23214, 23215, 23216, 23226, 23232, 23240, 23315, 23323, 23327, 23331, 23332, 23333, 23336, 23337, 23341, 23342, 23344, 23347, 23357, 23358, 23359, 23361, 23362, 23365, 23366, 23371, 23373, 23376, 23381, 23383, 23409, 23410, 23411, 23412, 23413, 23414, 23415, 28376, 822, 23249, 23256, 23298, 23300, 23302, 23345, 23346, 23348, 23351, 23353, 23354, 23363, 23368, 23378, 23380, 23382, 23384, 23386, 23388, 23389, 23391, 23393, 23416, 23417, 23418, 27731, 27764, 28992, 29027, 823, 23419, 23420, 23421, 23422, 23423, 23424, 23425, 23426, 23427, 23428, 23429, 23430, 23431, 23432, 23433, 23434, 23435, 23436, 23437, 23438, 23439, 23440, 23441, 23442, 23443, 23444, 23445, 23446, 23447, 23449, 23450, 23451, 23452, 23453, 23454, 23455, 23456, 23457, 23458, 23459, 23463, 23465, 23471, 23474, 824, 23448, 23460, 23461, 23462, 23464, 23466, 23467, 23468, 23469, 23475, 23476, 23477, 23478, 23479, 23480, 23481, 23484, 23489, 23490, 23492, 23498, 28228, 28396, 28397, 28398, 28399, 28400, 28401, 28402, 28403, 825, 23470, 23472, 23473, 23482, 23483, 23485, 23486, 23487, 23488, 23491, 23493, 23500, 23502, 23503, 23505, 23507, 23508, 23509, 826, 23494, 23495, 23496, 23497, 23499, 23501, 23510, 23511, 23512, 23513, 23514, 23515, 23516, 23517, 23518, 23520, 23522, 23524, 23525, 23526, 23792, 23793, 28942, 827, 828, 829, 830, 23504, 23506, 23519, 23521, 23523, 23527, 23528, 23529, 23530, 23531, 25964, 25965, 25966, 25967, 25174, 320, 25512, 831, 832, 23264, 23396, 833, 834, 835, 836, 837, 838, 839, 840, 23984, 24429, 26915, 321, 7448, 25405, 25724, 24002, 25723, 25404, 25403, 25402, 26835, 27733, 29113, 24626, 24051, 24872, 7192, 7236, 841, 842, 843, 844, 845, 846, 847, 23188, 23191, 23322, 848, 23270, 23326, 850, 23318, 23319, 23397, 23398, 851, 24036, 24587, 24639, 28905, 27135, 26988, 26240, 25216, 24549, 24508, 24407, 24349, 24314, 24277, 24233, 24053, 24025, 23976, 23616, 15477, 7256, 6967, 4216, 1254, 1245, 1219, 1175, 1172, 1166, 1151, 1150, 1149, 1148, 1144, 1143, 1142, 1141, 1140, 1138, 1137, 1136, 1134, 1116, 1070, 1067, 1064, 918, 917, 916, 915, 914, 913, 912, 911, 909, 908, 905, 907, 904, 903, 902, 900, 899, 898, 897, 444, 7257, 1192, 25285, 7685, 24242, 906, 24135, 1145, 24296, 1270, 21285, 1252, 849, 910, 7501, 7243, 23704, 23914, 23800, 28315, 25306, 25309, 25315, 25385, 25531, 25593, 26313, 26690, 26804, 26888, 26904, 27079, 27090, 27091, 27154, 27223, 27233, 27234, 27450, 27452, 27465, 27525, 27526, 27527, 27624, 27672, 27728, 27729, 27782, 27783, 27825, 27826, 27842, 27898, 27952, 27968, 27993, 28050, 28051, 28056, 28066, 28333, 28346, 28383, 28405, 28406, 28433, 28461, 28472, 28542, 28543, 28567, 28584, 28585, 28612, 28621, 28716, 28983, 29043, 29133, 29243, 29246, 24647, 25074, 25283, 25284, 26320, 26321, 26322, 26323, 27424, 28054, 28277, 28827, 28993, 29204, 322, 28643, 7522, 852, 28507, 853, 854, 2656, 24633, 24634, 26300, 323, 855, 23140, 23280, 856, 28454, 28475, 28476, 28477, 28478, 28479, 28480, 28481, 28482, 28483, 28484, 857, 23209, 23293, 28427, 28428, 28429, 28430, 28450, 28451, 28452, 28453, 858, 23146, 23147, 23150, 23164, 23175, 23181, 23210, 23221, 23239, 23245, 23252, 23259, 23282, 23285, 23286, 23289, 23291, 23294, 23305, 23308, 23314, 23394, 23395, 324, 859, 860, 861, 862, 863, 864, 1348, 325, 28791, 28423, 28239, 26808, 26798, 24446, 25273, 26942, 25661, 25498, 23891, 23772, 7465, 7431, 7140, 1131, 1129, 921, 886, 883, 882, 877, 876, 874, 873, 872, 26809, 7132, 441, 24512, 23895, 7635, 7130, 6963, 27198, 25534, 23713, 23709, 4980, 25112, 24610, 24058, 25276, 7131, 24578, 21286, 448, 447, 463, 23771, 23617, 870, 880, 1122, 881, 871, 934, 935, 1282, 1293, 7182, 6929, 7193, 1066, 1071, 6961, 6465, 1356, 7004, 865, 885, 884, 1180, 25202, 25287, 25288, 25463, 27337, 1121, 866, 867, 1123, 868, 1124, 7012, 869, 1127, 1128, 1130, 1132, 1133, 25214, 878, 25532, 25533, 879, 25732, 24635, 24636, 24616, 24615, 25218, 25258, 25259, 25260, 25261, 25733, 25734, 25735, 25736, 25738, 25739, 29196, 1135, 887, 888, 7032, 889, 890, 891, 892, 893, 894, 895, 896, 1152, 1153, 1154, 1155, 1156, 901, 1157, 1158, 1159, 1160, 7054, 1167, 1168, 1169, 1170, 1171, 7059, 919, 920, 922, 923, 1179, 924, 925, 1181, 926, 1182, 927, 1183, 928, 929, 930, 1186, 3234, 931, 1187, 932, 933, 936, 937, 938, 1194, 939, 1195, 940, 941, 942, 943, 7139, 25278, 25394, 7141, 7142, 7143, 7145, 1258, 1260, 7324, 7336, 7452, 7464, 7490, 7630, 7835, 23539, 23541, 23609, 23610, 23611, 23612, 23613, 23615, 23618, 23619, 23631, 23680, 23689, 23724, 23734, 23781, 23799, 23857, 23887, 23902, 23908, 23916, 23935, 23946, 23982, 23990, 24052, 24057, 24265, 24281, 24287, 24291, 24305, 24306, 24315, 24320, 24386, 24412, 24417, 24421, 24463, 24464, 24465, 24640, 24642, 25062, 25113, 25117, 25198, 25299, 25300, 25452, 25455, 25521, 25543, 25624, 25632, 25636, 25642, 25740, 26615, 26617, 26631, 26710, 27050, 26713, 26749, 26833, 26848, 26869, 26872, 26881, 26987, 27003, 27011, 1126, 27082, 27085, 27099, 27105, 27121, 27123, 27124, 27144, 27235, 27249, 27250, 27251, 27328, 27363, 27379, 27390, 27531, 27532, 27579, 27583, 27610, 27620, 27647, 27650, 27736, 27741, 27784, 27823, 27881, 27896, 28010, 28014, 28048, 28049, 28061, 28076, 28087, 28131, 28172, 28178, 28323, 28347, 28446, 28556, 28562, 28568, 28574, 28575, 28577, 28622, 28626, 28627, 28681, 28692, 28697, 28737, 28768, 28773, 28835, 28839, 28866, 28947, 28956, 29019, 29020, 29044, 29123, 29152, 29153, 29154, 29160, 29161, 29182, 29223, 29228, 29241, 29242, 29245, 29251, 29253, 6989, 6990, 24871, 6995, 7003, 4714, 1222, 7455, 7502, 7521, 19049, 23708, 23711, 24319, 24321, 24943, 24945, 25124, 25891, 26306, 28100, 28211, 28232, 28380, 28678, 28818, 28859)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;
12	2.39 ms	SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_;
13	2.27 ms	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 >= ? Parameters: [`1 "2025-12-16 01:43:15"`] View formatted query View runnable query Explain query 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-16 01:43:15';
14	8.32 ms	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_._left <= 7132 AND l0_._right >= 9067 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query 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_._left <= 7132 AND l0_._right >= 9067 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_.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 <= 7132 AND l0_._right >= 9067 AND l0_.root = 1 ORDER BY l0_._left ASC;
15	2.26 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`347`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 347 ORDER BY t0.position ASC;
16	2.17 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`347`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 347 ORDER BY t0.position ASC;
17	3.25 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 16;
18	2.82 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`16`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 16 AND ((t0.deleted_at IS NULL));
19	2.56 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 16;
20	2.08 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`79`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 79 ORDER BY t0.position ASC;
21	2.17 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`79`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 79 ORDER BY t0.position ASC;
22	2.97 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 2;
23	2.78 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`2`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 2 AND ((t0.deleted_at IS NULL));
24	2.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`2`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 2;
25	2.13 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`318`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 318 ORDER BY t0.position ASC;
26	2.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`318`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 318 ORDER BY t0.position ASC;
27	3.01 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 11;
28	2.40 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`11`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 11 AND ((t0.deleted_at IS NULL));
29	2.24 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 11;
30	2.12 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`183`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 183 ORDER BY t0.position ASC;
31	2.00 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`183`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 183 ORDER BY t0.position ASC;
32	2.85 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 7;
33	2.44 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`7`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 7 AND ((t0.deleted_at IS NULL));
34	2.13 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 7;
35	2.09 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`126`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 126 ORDER BY t0.position ASC;
36	2.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`126`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 126 ORDER BY t0.position ASC;
37	2.86 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 5;
38	2.47 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`5`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 5 AND ((t0.deleted_at IS NULL));
39	2.23 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`5`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 5;
40	2.57 ms	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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`3`] View formatted query View runnable query Explain query 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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) 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.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = 3 AND ((t0.deleted_at IS NULL));
41	3.77 ms	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 = ? Parameters: [`41`] View formatted query View runnable query Explain query 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 = ? 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 = 41;
42	7.40 ms	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_._left <= 7132 AND l0_._right >= 9067 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1`] View formatted query View runnable query Explain query 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_._left <= 7132 AND l0_._right >= 9067 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_.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 <= 7132 AND l0_._right >= 9067 AND l0_.root = 1 ORDER BY l0_._left ASC;
43	2.79 ms	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_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC Parameters: [`false`] View formatted query View runnable query Explain query 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_.level = 1 AND p0_.private = ? ) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, 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_.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_.level = 1 AND p0_.private = 0) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC;
44	2.64 ms	SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC Parameters: [`1 8 7 16 11 5 14 13 47 38 10 31 1 5`] View formatted query View runnable query Explain query SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE ( s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ? ) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (1, 8, 7, 16, 11, 5, 14, 13, 47, 38, 10) AND s1_.location_id IN (31) AND s1_.section_id = 1 AND s1_.search_result_count >= 5) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC;
45	2.73 ms	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_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC Parameters: [`false`] View formatted query View runnable query Explain query 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_.level = 1 AND p0_.private = ? ) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, 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_.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_.level = 1 AND p0_.private = 0) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC;
46	2.24 ms	SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC Parameters: [`1 8 7 16 11 5 14 13 47 38 10 31 2 5`] View formatted query View runnable query Explain query SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE ( s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ? ) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (1, 8, 7, 16, 11, 5, 14, 13, 47, 38, 10) AND s1_.location_id IN (31) AND s1_.section_id = 2 AND s1_.search_result_count >= 5) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC;
47	2.11 ms	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 = ? Parameters: [`"web.enable.facebooklogin"`] View formatted query View runnable query Explain query 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.enable.facebooklogin';

Database Connections

Name	Service
default	doctrine.dbal.default_connection

Entity Managers

Name	Service
default	doctrine.orm.default_entity_manager

Second Level Cache

Second Level Cache is not enabled.

Managed Entities

default entity manager

Class	Amount of managed objects
Aqarmap\Bundle\ListingBundle\Entity\Location	974
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	81
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	75
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	61
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	14
Aqarmap\Bundle\ListingBundle\Entity\Listing	9
Aqarmap\Bundle\UserBundle\Entity\User	6
Aqarmap\Bundle\CRMBundle\Entity\Company	4
Aqarmap\Bundle\ListingBundle\Entity\Section	3
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	3
Aqarmap\Bundle\DiscussionBundle\Entity\Category	1
Aqarmap\Bundle\ListingBundle\Entity\Photo	1
Aqarmap\Bundle\ListingBundle\Entity\Phone	1

Entities Mapping

Class	Mapping errors
Aqarmap\Bundle\ListingBundle\Entity\Location	The mappings Aqarmap\Bundle\ListingBundle\Entity\Location#childrenSortedById and Aqarmap\Bundle\ListingBundle\Entity\Location#parent are inconsistent with each other.
Aqarmap\Bundle\FeatureToggleBundle\Entity\FeatureToggle	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rule	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Listing	The field Aqarmap\Bundle\ListingBundle\Entity\Listing#compoundAveragePrices is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice#parentCompound does not contain the required 'inversedBy="compoundAveragePrices"' attribute.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationStatistics	No errors.
Aqarmap\Bundle\ListingBundle\Entity\TopCustomer	No errors.
Aqarmap\Bundle\MainBundle\Entity\Setting	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	No errors.
Aqarmap\Bundle\AnnouncementBundle\Entity\Announcement	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Section	No errors.
Aqarmap\Bundle\SearchBundle\Entity\SearchResultCombinations	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationTranslation	No errors.
Aqarmap\Bundle\CRMBundle\Entity\Company	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationSupplyDemand	No errors.
Aqarmap\Bundle\NotifierBundle\Entity\Notifier	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserInterest	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationPhoto	No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion	No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequest	No errors.
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	No errors.
Aqarmap\Bundle\ListingBundle\Entity\SearchTerm	No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ListingInsight	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PropertyTypeTranslation	No errors.
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompoundSize	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CustomField	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundAveragePrice	No errors.
Aqarmap\Bundle\ListingBundle\Entity\SectionTranslation	No errors.
Aqarmap\Bundle\ListingBundle\Entity\PriceFilter	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	No errors.
Aqarmap\Bundle\UserBundle\Entity\User	The field Aqarmap\Bundle\UserBundle\Entity\User#referrals is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\CRMBundle\Entity\Company#referedBy does not contain the required 'inversedBy="referrals"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#recurringTransactions is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#user does not contain the required 'inversedBy="recurringTransactions"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#geoLocations is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\User\UserGeoLocation#user does not contain the required 'inversedBy="geoLocations"' attribute. The field Aqarmap\Bundle\UserBundle\Entity\User#packages is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\UserBundle\Entity\UserPackages#user does not contain the required 'inversedBy="packages"' attribute.
Aqarmap\Bundle\ListingBundle\Entity\ListingAttribute	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhone	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingTranslation	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingLead	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingFeature	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNotification	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Rejection	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Interaction	No errors.
App\Entity\ListingLabel	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite	No errors.
Aqarmap\Bundle\ValueEngineBundle\Entity\ValueEngineListingsLocations	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingNote	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingsRatesNote	No errors.
Aqarmap\Bundle\ListingBundle\Entity\CompoundField	No errors.
Aqarmap\Bundle\ListingBundle\Entity\File	No errors.
App\Entity\Listing\ListingValuation	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Category	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CategoryTranslation	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Photo	No errors.
App\Entity\Subscriptions\UserSubscription	The field App\Entity\Subscriptions\UserSubscription#subscriptionCancellationSurveys is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity App\Entity\Subscriptions\SubscriptionCancellationSurvey#userSubscription does not contain the required 'inversedBy="subscriptionCancellationSurveys"' attribute.
Aqarmap\Bundle\CRMBundle\Entity\Staff	No errors.
Aqarmap\Bundle\UserBundle\Entity\Team	No errors.
Aqarmap\Bundle\UserBundle\Entity\DeveloperField	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Phone	No errors.
Aqarmap\Bundle\PaymentBundle\Entity\Payment	The association Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction refers to the inverse side field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#paymentTransactions which does not exist.
App\Entity\User\UserCard	No errors.
Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction	The field Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#recurringTransactionStates is on the inverse side of a bi-directional relationship, but the specified mappedBy association on the target-entity Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransactionState#recurringTransaction does not contain the required 'inversedBy="recurringTransactionStates"' attribute. The mappings Aqarmap\Bundle\RecurringTransactionBundle\Entity\RecurringTransaction#payment and Aqarmap\Bundle\PaymentBundle\Entity\Payment#recurringTransaction are inconsistent with each other.
App\Entity\User\UserGeoLocation	No errors.
Aqarmap\Bundle\UserBundle\Entity\Group	No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Seller	No errors.
Aqarmap\Bundle\BrokerSalesBundle\Entity\Broker	No errors.
Aqarmap\Bundle\CreditBundle\Entity\Credit	The association Aqarmap\Bundle\CreditBundle\Entity\Credit#userPackages refers to the inverse side field Aqarmap\Bundle\UserBundle\Entity\UserPackages#credits which does not exist.
Aqarmap\Bundle\CreditBundle\Entity\CreditAnalysis	No errors.
Aqarmap\Bundle\PaymentBundle\Entity\SalesAnalysis	No errors.
Aqarmap\Bundle\UserBundle\Entity\TeamHistory	No errors.
App\Entity\Lead\Lead	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDevice	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserServices	No errors.
App\Entity\UserLabel	No errors.
Aqarmap\Bundle\ExchangeBundle\Entity\ExchangeRequestUnlock	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserCheckin	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserDomain	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\Comment	No errors.
Aqarmap\Bundle\UserBundle\Entity\PersonalInfo	No errors.
Aqarmap\Bundle\CustomerProfilingBundle\Entity\CustomerProfilingQuestionQueue	No errors.
Aqarmap\Bundle\MessageBundle\Entity\ConversationRecipient	No errors.
Aqarmap\Bundle\UserBundle\Entity\UserPackages	The field 'Aqarmap\Bundle\UserBundle\Entity\UserPackages#creditPrice' has the property type 'float' that differs from the metadata field type 'string' returned by the 'decimal' DBAL type.
Aqarmap\Bundle\ListingBundle\Entity\UserPhone	No errors.
Aqarmap\Bundle\DiscussionBundle\Entity\CommentLike	No errors.
Aqarmap\Bundle\PaymentBundle\Entity\PaymentTransactionService	No errors.
Aqarmap\Bundle\CRMBundle\Entity\StaffHistory	No errors.
App\Entity\LeadsBank\UserSegment	No errors.

Symfony Profiler

GET https://testing-eg.am-root.com/ar/ask-neighbors/?location=31

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping