Symfony Profiler

Query Metrics

28 Database Queries

20 Different statements

178.92 ms Query time

8 Invalid entities

1053 Managed entities

Queries


SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1
SELECT 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.amenities AS amenities_19, t0.parent_id AS parent_id_20 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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, t62.id AS id_63, t62.balance AS balance_64, t62.status AS status_65, t62.created_at AS created_at_66, t62.updated_at AS updated_at_67, t62.user_id AS user_id_68 FROM users t0 LEFT JOIN wallets t62 ON t62.user_id = t0.id 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.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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	6.31 ms	SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 Parameters: [`false true`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 SELECT l0_.id AS id_0, COALESCE(t1_.content, l0_.title) AS title_1, COALESCE(t2_.content, l0_.alias) AS alias_2, COALESCE(t3_.content, l0_.description) AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ LEFT JOIN locations_translations t1_ ON t1_.locale = 'en' AND t1_.field = 'title' AND t1_.location_id = l0_.id LEFT JOIN locations_translations t2_ ON t2_.locale = 'en' AND t2_.field = 'alias' AND t2_.location_id = l0_.id LEFT JOIN locations_translations t3_ ON t3_.locale = 'en' AND t3_.field = 'description' AND t3_.location_id = l0_.id WHERE l0_.parent_id IS NULL AND l0_.disabled = 0 AND l0_.searchable = 1 LIMIT 1;
2	3.72 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.amenities AS amenities_19, t0.parent_id AS parent_id_20 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.amenities AS amenities_19, t0.parent_id AS parent_id_20 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.amenities AS amenities_19, t0.parent_id AS parent_id_20 FROM property_types t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
3	2.94 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);
4	3.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;
5	4.72 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) Parameters: [`"1477" "1475" "34" "348" "309"`] 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.id IN ('1477', '1475', '34', '348', '309')) AND (l0_.deleted_at IS NULL);
6	3.24 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = ? Parameters: [`"33"`] 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = '33';
7	35.75 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 AND l0_.root = 1 ORDER BY l0_._left ASC;
8	6.44 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 33 1306 1279 25313 24934 23955 7194 1307 1308 1309 1310 1311 1312 1313 1314 1315 1331 7249 7000 7021 7112 7115 7631 7632 15336 23998 24241 24536 25172 25221 25233 25308 25720 25917 26307 26906 26951 27146 27498 28339 28522 29132 107 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 10094 108 7419 7680 7681 10095 10096 10097 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 10141 10142 10143 10144 10145 10146 10147 10148 10149 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 10202 10203 10204 27673 109 7483 7481 7478 7482 7479 7480 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 23894 26299 111 1204 1205 1206 1207 1208 7426 24200 28662 112 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 113 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 28922 28963 28964 28965 28966 28967 28968 28969 28970 28971 28972 114 25464 115 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 10511 10512 10513 10514 10515 10516 10517 10518 10519 10520 10521 10522 10523 10524 10525 10526 10527 10528 10529 10530 10531 10532 10533 10534 10535 10536 10537 10538 10539 10540 10541 10542 10543 10544 10545 10546 10547 10548 10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 25638 116 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 117 10579 10580 10581 10582 10583 10584 10585 10586 10587 10588 10589 10590 10591 10592 10593 10594 10595 10596 10597 10598 10599 10600 10601 10602 10603 10604 10605 10606 10607 10608 10609 10610 10611 10612 10613 10614 10615 10616 118 119 120 10617 10618 10619 10620 10621 10622 10623 10624 10625 10626 10627 10628 10629 10630 10631 10632 10633 28414 121 122 123 124 10634 25158 10635 10636 10637 10638 10639 10640 10641 10642 10643 10644 10645 10646 10647 10648 10649 10650 10651 10652 10653 10654 10655 10656 10657 10658 10659 10660 10661 10662 10663 125 10664 10665 10666 10667 10668 10669 10670 10671 10672 10673 10674 10675 10676 10677 10678 10679 10680 10681 10682 10683 10684 10685 10686 10687 25474 126 127 1225 7414 10749 10750 10751 10752 10753 10754 10755 10756 10757 10758 10759 10760 10761 10762 10763 10764 10765 10766 10767 10768 10769 10770 10771 10772 10773 10774 10775 10776 10777 10778 10779 10780 10781 10782 10783 10784 10785 10786 10787 10788 10789 10790 10791 10792 10793 10794 10795 10796 10797 10798 10799 10800 10801 10802 10803 10804 10805 10806 10807 10808 10809 28729 7477 11364 25059 25060 25061 28177 28900] 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 (33, 1306, 1279, 25313, 24934, 23955, 7194, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1331, 7249, 7000, 7021, 7112, 7115, 7631, 7632, 15336, 23998, 24241, 24536, 25172, 25221, 25233, 25308, 25720, 25917, 26307, 26906, 26951, 27146, 27498, 28339, 28522, 29132, 107, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 10008, 10009, 10010, 10011, 10012, 10013, 10014, 10015, 10016, 10017, 10018, 10019, 10020, 10021, 10022, 10023, 10024, 10025, 10026, 10027, 10028, 10029, 10030, 10031, 10032, 10033, 10034, 10035, 10036, 10037, 10038, 10039, 10040, 10041, 10042, 10043, 10044, 10045, 10046, 10047, 10048, 10049, 10050, 10051, 10052, 10053, 10054, 10055, 10056, 10057, 10058, 10059, 10060, 10061, 10062, 10063, 10064, 10065, 10066, 10067, 10068, 10069, 10070, 10071, 10072, 10073, 10074, 10075, 10076, 10077, 10078, 10079, 10080, 10081, 10082, 10083, 10084, 10085, 10086, 10087, 10088, 10089, 10090, 10091, 10092, 10093, 10094, 108, 7419, 7680, 7681, 10095, 10096, 10097, 10098, 10099, 10100, 10101, 10102, 10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111, 10112, 10113, 10114, 10115, 10116, 10117, 10118, 10119, 10120, 10121, 10122, 10123, 10124, 10125, 10126, 10127, 10128, 10129, 10130, 10131, 10132, 10133, 10134, 10135, 10136, 10137, 10138, 10139, 10140, 10141, 10142, 10143, 10144, 10145, 10146, 10147, 10148, 10149, 10150, 10151, 10152, 10153, 10154, 10155, 10156, 10157, 10158, 10159, 10160, 10161, 10162, 10163, 10164, 10165, 10166, 10167, 10168, 10169, 10170, 10171, 10172, 10173, 10174, 10175, 10176, 10177, 10178, 10179, 10180, 10181, 10182, 10183, 10184, 10185, 10186, 10187, 10188, 10189, 10190, 10191, 10192, 10193, 10194, 10195, 10196, 10197, 10198, 10199, 10200, 10201, 10202, 10203, 10204, 27673, 109, 7483, 7481, 7478, 7482, 7479, 7480, 10205, 10206, 10207, 10208, 10209, 10210, 10211, 10212, 10213, 10214, 10215, 10216, 10217, 10218, 10219, 10220, 10221, 10222, 10223, 10224, 10225, 10226, 10227, 10228, 10229, 10230, 10231, 10232, 10233, 10234, 10235, 10236, 10237, 10238, 10239, 10240, 10241, 10242, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10259, 10260, 10261, 10262, 10263, 10264, 10265, 10266, 10267, 23894, 26299, 111, 1204, 1205, 1206, 1207, 1208, 7426, 24200, 28662, 112, 10367, 10368, 10369, 10370, 10371, 10372, 10373, 10374, 10375, 10376, 10377, 10378, 10379, 10380, 10381, 10382, 10383, 10384, 10385, 10386, 10387, 10388, 10389, 10390, 10391, 10392, 10393, 10394, 10395, 10396, 113, 10397, 10398, 10399, 10400, 10401, 10402, 10403, 10404, 10405, 10406, 10407, 10408, 10409, 10410, 10411, 10412, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10428, 10429, 10430, 10431, 10432, 10433, 10434, 10435, 10436, 10437, 10438, 10439, 10440, 10441, 10442, 10443, 10444, 10445, 10446, 10447, 10448, 10449, 10450, 10451, 10452, 10453, 10454, 10455, 10456, 10457, 10458, 10459, 10460, 10461, 10462, 10463, 10464, 10465, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10476, 10477, 10478, 10479, 10480, 10481, 10482, 10483, 10484, 10485, 28922, 28963, 28964, 28965, 28966, 28967, 28968, 28969, 28970, 28971, 28972, 114, 25464, 115, 10486, 10487, 10488, 10489, 10490, 10491, 10492, 10493, 10494, 10495, 10496, 10497, 10498, 10499, 10500, 10501, 10502, 10503, 10504, 10505, 10506, 10507, 10508, 10509, 10510, 10511, 10512, 10513, 10514, 10515, 10516, 10517, 10518, 10519, 10520, 10521, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 10531, 10532, 10533, 10534, 10535, 10536, 10537, 10538, 10539, 10540, 10541, 10542, 10543, 10544, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10554, 10555, 10556, 10557, 10558, 10559, 10560, 25638, 116, 10561, 10562, 10563, 10564, 10565, 10566, 10567, 10568, 10569, 10570, 10571, 10572, 10573, 10574, 10575, 10576, 10577, 10578, 117, 10579, 10580, 10581, 10582, 10583, 10584, 10585, 10586, 10587, 10588, 10589, 10590, 10591, 10592, 10593, 10594, 10595, 10596, 10597, 10598, 10599, 10600, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10608, 10609, 10610, 10611, 10612, 10613, 10614, 10615, 10616, 118, 119, 120, 10617, 10618, 10619, 10620, 10621, 10622, 10623, 10624, 10625, 10626, 10627, 10628, 10629, 10630, 10631, 10632, 10633, 28414, 121, 122, 123, 124, 10634, 25158, 10635, 10636, 10637, 10638, 10639, 10640, 10641, 10642, 10643, 10644, 10645, 10646, 10647, 10648, 10649, 10650, 10651, 10652, 10653, 10654, 10655, 10656, 10657, 10658, 10659, 10660, 10661, 10662, 10663, 125, 10664, 10665, 10666, 10667, 10668, 10669, 10670, 10671, 10672, 10673, 10674, 10675, 10676, 10677, 10678, 10679, 10680, 10681, 10682, 10683, 10684, 10685, 10686, 10687, 25474, 126, 127, 1225, 7414, 10749, 10750, 10751, 10752, 10753, 10754, 10755, 10756, 10757, 10758, 10759, 10760, 10761, 10762, 10763, 10764, 10765, 10766, 10767, 10768, 10769, 10770, 10771, 10772, 10773, 10774, 10775, 10776, 10777, 10778, 10779, 10780, 10781, 10782, 10783, 10784, 10785, 10786, 10787, 10788, 10789, 10790, 10791, 10792, 10793, 10794, 10795, 10796, 10797, 10798, 10799, 10800, 10801, 10802, 10803, 10804, 10805, 10806, 10807, 10808, 10809, 28729, 7477, 11364, 25059, 25060, 25061, 28177, 28900) 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;
9	28.65 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._right < 11873 AND l0_._left > 10318 AND l0_.root = 1 ORDER BY l0_._left ASC;
10	24.16 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 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 33 1306 1279 25313 24934 23955 7194 1307 1308 1309 1310 1311 1312 1313 1314 1315 1331 7249 7000 7021 7112 7115 7631 7632 15336 23998 24241 24536 25172 25221 25233 25308 25720 25917 26307 26906 26951 27146 27498 28339 28522 29132 107 1026 1027 1028 1029 1030 1031 1032 1033 1034 1035 1036 1037 1038 1039 996 997 998 999 1000 1001 1002 1003 1004 1005 1006 1007 1008 1009 10008 10009 10010 10011 10012 10013 10014 10015 10016 10017 10018 10019 10020 10021 10022 10023 10024 10025 10026 10027 10028 10029 10030 10031 10032 10033 10034 10035 10036 10037 10038 10039 10040 10041 10042 10043 10044 10045 10046 10047 10048 10049 10050 10051 10052 10053 10054 10055 10056 10057 10058 10059 10060 10061 10062 10063 10064 10065 10066 10067 10068 10069 10070 10071 10072 10073 10074 10075 10076 10077 10078 10079 10080 10081 10082 10083 10084 10085 10086 10087 10088 10089 10090 10091 10092 10093 10094 108 7419 7680 7681 10095 10096 10097 10098 10099 10100 10101 10102 10103 10104 10105 10106 10107 10108 10109 10110 10111 10112 10113 10114 10115 10116 10117 10118 10119 10120 10121 10122 10123 10124 10125 10126 10127 10128 10129 10130 10131 10132 10133 10134 10135 10136 10137 10138 10139 10140 10141 10142 10143 10144 10145 10146 10147 10148 10149 10150 10151 10152 10153 10154 10155 10156 10157 10158 10159 10160 10161 10162 10163 10164 10165 10166 10167 10168 10169 10170 10171 10172 10173 10174 10175 10176 10177 10178 10179 10180 10181 10182 10183 10184 10185 10186 10187 10188 10189 10190 10191 10192 10193 10194 10195 10196 10197 10198 10199 10200 10201 10202 10203 10204 27673 109 7483 7481 7478 7482 7479 7480 10205 10206 10207 10208 10209 10210 10211 10212 10213 10214 10215 10216 10217 10218 10219 10220 10221 10222 10223 10224 10225 10226 10227 10228 10229 10230 10231 10232 10233 10234 10235 10236 10237 10238 10239 10240 10241 10242 10243 10244 10245 10246 10247 10248 10249 10250 10251 10252 10253 10254 10255 10256 10257 10258 10259 10260 10261 10262 10263 10264 10265 10266 10267 23894 26299 111 1204 1205 1206 1207 1208 7426 24200 28662 112 10367 10368 10369 10370 10371 10372 10373 10374 10375 10376 10377 10378 10379 10380 10381 10382 10383 10384 10385 10386 10387 10388 10389 10390 10391 10392 10393 10394 10395 10396 113 10397 10398 10399 10400 10401 10402 10403 10404 10405 10406 10407 10408 10409 10410 10411 10412 10413 10414 10415 10416 10417 10418 10419 10420 10421 10422 10423 10424 10425 10426 10427 10428 10429 10430 10431 10432 10433 10434 10435 10436 10437 10438 10439 10440 10441 10442 10443 10444 10445 10446 10447 10448 10449 10450 10451 10452 10453 10454 10455 10456 10457 10458 10459 10460 10461 10462 10463 10464 10465 10466 10467 10468 10469 10470 10471 10472 10473 10474 10475 10476 10477 10478 10479 10480 10481 10482 10483 10484 10485 28922 28963 28964 28965 28966 28967 28968 28969 28970 28971 28972 114 25464 115 10486 10487 10488 10489 10490 10491 10492 10493 10494 10495 10496 10497 10498 10499 10500 10501 10502 10503 10504 10505 10506 10507 10508 10509 10510 10511 10512 10513 10514 10515 10516 10517 10518 10519 10520 10521 10522 10523 10524 10525 10526 10527 10528 10529 10530 10531 10532 10533 10534 10535 10536 10537 10538 10539 10540 10541 10542 10543 10544 10545 10546 10547 10548 10549 10550 10551 10552 10553 10554 10555 10556 10557 10558 10559 10560 25638 116 10561 10562 10563 10564 10565 10566 10567 10568 10569 10570 10571 10572 10573 10574 10575 10576 10577 10578 117 10579 10580 10581 10582 10583 10584 10585 10586 10587 10588 10589 10590 10591 10592 10593 10594 10595 10596 10597 10598 10599 10600 10601 10602 10603 10604 10605 10606 10607 10608 10609 10610 10611 10612 10613 10614 10615 10616 118 119 120 10617 10618 10619 10620 10621 10622 10623 10624 10625 10626 10627 10628 10629 10630 10631 10632 10633 28414 121 122 123 124 10634 25158 10635 10636 10637 10638 10639 10640 10641 10642 10643 10644 10645 10646 10647 10648 10649 10650 10651 10652 10653 10654 10655 10656 10657 10658 10659 10660 10661 10662 10663 125 10664 10665 10666 10667 10668 10669 10670 10671 10672 10673 10674 10675 10676 10677 10678 10679 10680 10681 10682 10683 10684 10685 10686 10687 25474 126 127 1225 7414 10749 10750 10751 10752 10753 10754 10755 10756 10757 10758 10759 10760 10761 10762 10763 10764 10765 10766 10767 10768 10769 10770 10771 10772 10773 10774 10775 10776 10777 10778 10779 10780 10781 10782 10783 10784 10785 10786 10787 10788 10789 10790 10791 10792 10793 10794 10795 10796 10797 10798 10799 10800 10801 10802 10803 10804 10805 10806 10807 10808 10809 28729 7477 11364 25059 25060 25061 28177 28900] 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 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_.amenities AS amenities_41, l0_.source AS source_42, l0_.impressions AS impressions_43, l0_.impressions_monthly_count AS impressions_monthly_count_44, l0_.impressions_weekly_count AS impressions_weekly_count_45, l0_.impression_updated_at AS impression_updated_at_46, l0_.price_level AS price_level_47, l0_.compound_status AS compound_status_48, l0_.price_per_meter AS price_per_meter_49, l0_.is_bumped AS is_bumped_50, l0_.is_send_email AS is_send_email_51, l0_.is_availability_email_sent AS is_availability_email_sent_52, l0_.market_property_type AS market_property_type_53, l0_.creation_source AS creation_source_54, l0_.click_through_rate AS click_through_rate_55, l0_.label AS label_56, l0_.is_top_picks AS is_top_picks_57, l0_.contact_rate AS contact_rate_58, l0_.synced AS synced_59, l0_.reference_id AS reference_id_60, l0_.is_pending_featuring AS is_pending_featuring_61, l0_.pending_featuring_type AS pending_featuring_type_62, l0_.rate_status AS rate_status_63, l0_.is_rate_reviewed AS is_rate_reviewed_64, l0_.is_call_request AS is_call_request_65, l0_.is_shown_in_homepage AS is_shown_in_homepage_66, l0_.is_commercial AS is_commercial_67, l0_.is_resale AS is_resale_68, l0_.is_rent AS is_rent_69, l0_.is_primary AS is_primary_70, l0_.is_mortgage_approved AS is_mortgage_approved_71, l0_.meta_title AS meta_title_72, l0_.meta_description AS meta_description_73, l0_.is_mortgage AS is_mortgage_74, l0_.eligible_for_mortgage AS eligible_for_mortgage_75, l0_.property_registration_status AS property_registration_status_76, l0_.advertiser_number AS advertiser_number_77, l0_.authorization_number AS authorization_number_78, l0_.freezed_at AS freezed_at_79, l0_.eligible_for_bumpup AS eligible_for_bumpup_80, l0_.waiting_time AS waiting_time_81, l0_.reference_number AS reference_number_82, l0_.is_hold AS is_hold_83, l0_.is_ai_content AS is_ai_content_84, l0_.ai_review AS ai_review_85, l0_.rating_review_status AS rating_review_status_86, l0_.parent_id AS parent_id_87, l0_.relist_id AS relist_id_88, l0_.section_id AS section_id_89, l0_.property_type_id AS property_type_id_90, l0_.location_id AS location_id_91, l0_.compound_location_id AS compound_location_id_92, l0_.user_id AS user_id_93, l0_.compound_field_id AS compound_field_id_94, l0_.brochure_id AS brochure_id_95, l0_.valuation_id AS valuation_id_96, l0_.new_valuation_id AS new_valuation_id_97 FROM listings l0_ WHERE (l0_.status = 2 AND l0_.location_id IN (33, 1306, 1279, 25313, 24934, 23955, 7194, 1307, 1308, 1309, 1310, 1311, 1312, 1313, 1314, 1315, 1331, 7249, 7000, 7021, 7112, 7115, 7631, 7632, 15336, 23998, 24241, 24536, 25172, 25221, 25233, 25308, 25720, 25917, 26307, 26906, 26951, 27146, 27498, 28339, 28522, 29132, 107, 1026, 1027, 1028, 1029, 1030, 1031, 1032, 1033, 1034, 1035, 1036, 1037, 1038, 1039, 996, 997, 998, 999, 1000, 1001, 1002, 1003, 1004, 1005, 1006, 1007, 1008, 1009, 10008, 10009, 10010, 10011, 10012, 10013, 10014, 10015, 10016, 10017, 10018, 10019, 10020, 10021, 10022, 10023, 10024, 10025, 10026, 10027, 10028, 10029, 10030, 10031, 10032, 10033, 10034, 10035, 10036, 10037, 10038, 10039, 10040, 10041, 10042, 10043, 10044, 10045, 10046, 10047, 10048, 10049, 10050, 10051, 10052, 10053, 10054, 10055, 10056, 10057, 10058, 10059, 10060, 10061, 10062, 10063, 10064, 10065, 10066, 10067, 10068, 10069, 10070, 10071, 10072, 10073, 10074, 10075, 10076, 10077, 10078, 10079, 10080, 10081, 10082, 10083, 10084, 10085, 10086, 10087, 10088, 10089, 10090, 10091, 10092, 10093, 10094, 108, 7419, 7680, 7681, 10095, 10096, 10097, 10098, 10099, 10100, 10101, 10102, 10103, 10104, 10105, 10106, 10107, 10108, 10109, 10110, 10111, 10112, 10113, 10114, 10115, 10116, 10117, 10118, 10119, 10120, 10121, 10122, 10123, 10124, 10125, 10126, 10127, 10128, 10129, 10130, 10131, 10132, 10133, 10134, 10135, 10136, 10137, 10138, 10139, 10140, 10141, 10142, 10143, 10144, 10145, 10146, 10147, 10148, 10149, 10150, 10151, 10152, 10153, 10154, 10155, 10156, 10157, 10158, 10159, 10160, 10161, 10162, 10163, 10164, 10165, 10166, 10167, 10168, 10169, 10170, 10171, 10172, 10173, 10174, 10175, 10176, 10177, 10178, 10179, 10180, 10181, 10182, 10183, 10184, 10185, 10186, 10187, 10188, 10189, 10190, 10191, 10192, 10193, 10194, 10195, 10196, 10197, 10198, 10199, 10200, 10201, 10202, 10203, 10204, 27673, 109, 7483, 7481, 7478, 7482, 7479, 7480, 10205, 10206, 10207, 10208, 10209, 10210, 10211, 10212, 10213, 10214, 10215, 10216, 10217, 10218, 10219, 10220, 10221, 10222, 10223, 10224, 10225, 10226, 10227, 10228, 10229, 10230, 10231, 10232, 10233, 10234, 10235, 10236, 10237, 10238, 10239, 10240, 10241, 10242, 10243, 10244, 10245, 10246, 10247, 10248, 10249, 10250, 10251, 10252, 10253, 10254, 10255, 10256, 10257, 10258, 10259, 10260, 10261, 10262, 10263, 10264, 10265, 10266, 10267, 23894, 26299, 111, 1204, 1205, 1206, 1207, 1208, 7426, 24200, 28662, 112, 10367, 10368, 10369, 10370, 10371, 10372, 10373, 10374, 10375, 10376, 10377, 10378, 10379, 10380, 10381, 10382, 10383, 10384, 10385, 10386, 10387, 10388, 10389, 10390, 10391, 10392, 10393, 10394, 10395, 10396, 113, 10397, 10398, 10399, 10400, 10401, 10402, 10403, 10404, 10405, 10406, 10407, 10408, 10409, 10410, 10411, 10412, 10413, 10414, 10415, 10416, 10417, 10418, 10419, 10420, 10421, 10422, 10423, 10424, 10425, 10426, 10427, 10428, 10429, 10430, 10431, 10432, 10433, 10434, 10435, 10436, 10437, 10438, 10439, 10440, 10441, 10442, 10443, 10444, 10445, 10446, 10447, 10448, 10449, 10450, 10451, 10452, 10453, 10454, 10455, 10456, 10457, 10458, 10459, 10460, 10461, 10462, 10463, 10464, 10465, 10466, 10467, 10468, 10469, 10470, 10471, 10472, 10473, 10474, 10475, 10476, 10477, 10478, 10479, 10480, 10481, 10482, 10483, 10484, 10485, 28922, 28963, 28964, 28965, 28966, 28967, 28968, 28969, 28970, 28971, 28972, 114, 25464, 115, 10486, 10487, 10488, 10489, 10490, 10491, 10492, 10493, 10494, 10495, 10496, 10497, 10498, 10499, 10500, 10501, 10502, 10503, 10504, 10505, 10506, 10507, 10508, 10509, 10510, 10511, 10512, 10513, 10514, 10515, 10516, 10517, 10518, 10519, 10520, 10521, 10522, 10523, 10524, 10525, 10526, 10527, 10528, 10529, 10530, 10531, 10532, 10533, 10534, 10535, 10536, 10537, 10538, 10539, 10540, 10541, 10542, 10543, 10544, 10545, 10546, 10547, 10548, 10549, 10550, 10551, 10552, 10553, 10554, 10555, 10556, 10557, 10558, 10559, 10560, 25638, 116, 10561, 10562, 10563, 10564, 10565, 10566, 10567, 10568, 10569, 10570, 10571, 10572, 10573, 10574, 10575, 10576, 10577, 10578, 117, 10579, 10580, 10581, 10582, 10583, 10584, 10585, 10586, 10587, 10588, 10589, 10590, 10591, 10592, 10593, 10594, 10595, 10596, 10597, 10598, 10599, 10600, 10601, 10602, 10603, 10604, 10605, 10606, 10607, 10608, 10609, 10610, 10611, 10612, 10613, 10614, 10615, 10616, 118, 119, 120, 10617, 10618, 10619, 10620, 10621, 10622, 10623, 10624, 10625, 10626, 10627, 10628, 10629, 10630, 10631, 10632, 10633, 28414, 121, 122, 123, 124, 10634, 25158, 10635, 10636, 10637, 10638, 10639, 10640, 10641, 10642, 10643, 10644, 10645, 10646, 10647, 10648, 10649, 10650, 10651, 10652, 10653, 10654, 10655, 10656, 10657, 10658, 10659, 10660, 10661, 10662, 10663, 125, 10664, 10665, 10666, 10667, 10668, 10669, 10670, 10671, 10672, 10673, 10674, 10675, 10676, 10677, 10678, 10679, 10680, 10681, 10682, 10683, 10684, 10685, 10686, 10687, 25474, 126, 127, 1225, 7414, 10749, 10750, 10751, 10752, 10753, 10754, 10755, 10756, 10757, 10758, 10759, 10760, 10761, 10762, 10763, 10764, 10765, 10766, 10767, 10768, 10769, 10770, 10771, 10772, 10773, 10774, 10775, 10776, 10777, 10778, 10779, 10780, 10781, 10782, 10783, 10784, 10785, 10786, 10787, 10788, 10789, 10790, 10791, 10792, 10793, 10794, 10795, 10796, 10797, 10798, 10799, 10800, 10801, 10802, 10803, 10804, 10805, 10806, 10807, 10808, 10809, 28729, 7477, 11364, 25059, 25060, 25061, 28177, 28900)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;
11	2.79 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_;
12	3.12 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 "2026-03-05 16:28:10"`] 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 >= '2026-03-05 16:28:10';
13	6.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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 AND l0_.root = 1 ORDER BY l0_._left ASC;
14	2.43 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: [`34`] 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 = 34 ORDER BY t0.position ASC;
15	2.46 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: [`34`] 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 = 34 ORDER BY t0.position ASC;
16	3.75 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, t62.id AS id_63, t62.balance AS balance_64, t62.status AS status_65, t62.created_at AS created_at_66, t62.updated_at AS updated_at_67, t62.user_id AS user_id_68 FROM users t0 LEFT JOIN wallets t62 ON t62.user_id = t0.id WHERE t0.id = ? Parameters: [`1`] 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, t62.id AS id_63, t62.balance AS balance_64, t62.status AS status_65, t62.created_at AS created_at_66, t62.updated_at AS updated_at_67, t62.user_id AS user_id_68 FROM users t0 LEFT JOIN wallets t62 ON t62.user_id = t0.id 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, t62.id AS id_63, t62.balance AS balance_64, t62.status AS status_65, t62.created_at AS created_at_66, t62.updated_at AS updated_at_67, t62.user_id AS user_id_68 FROM users t0 LEFT JOIN wallets t62 ON t62.user_id = t0.id WHERE t0.id = 1;
17	3.10 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`1`] 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 = 1 AND ((t0.deleted_at IS NULL));
18	2.45 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: [`1`] 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 = 1;
19	3.71 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: [`348`] 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 = 348 ORDER BY t0.position ASC;
20	2.46 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: [`348`] 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 = 348 ORDER BY t0.position ASC;
21	2.59 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = ? Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.title AS title_2, t0.description AS description_3, t0.meta_title AS meta_title_4, t0.meta_description AS meta_description_5, t0.main AS main_6, t0.searchable AS searchable_7, t0.slug AS slug_8, t0.synced AS synced_9, t0.reference_id AS reference_id_10, t0.meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0.id = 3;
22	2.95 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = ? Parameters: [`38`] 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 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.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.synonyms AS synonyms_25, t0.full_path AS full_path_26, t0.reference_id AS reference_id_27, t0.type AS type_28, t0.eligible_for_mortgage AS eligible_for_mortgage_29, t0.is_compound_location AS is_compound_location_30, t0.parent_id AS parent_id_31, t0.location_compound_id AS location_compound_id_32, t0.rating_id AS rating_id_33, t0.listing_id AS listing_id_34 FROM locations t0 WHERE t0.id = 38;
23	6.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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 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_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.synonyms AS synonyms_24, l0_.full_path AS full_path_25, l0_.reference_id AS reference_id_26, l0_.type AS type_27, l0_.eligible_for_mortgage AS eligible_for_mortgage_28, l0_.is_compound_location AS is_compound_location_29, l0_.parent_id AS parent_id_30, l0_.location_compound_id AS location_compound_id_31, l0_.rating_id AS rating_id_32, l0_.listing_id AS listing_id_33 FROM locations l0_ WHERE l0_._left <= 10318 AND l0_._right >= 11873 AND l0_.root = 1 ORDER BY l0_._left ASC;
24	3.37 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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;
25	3.22 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 33 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 (33) 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;
26	3.21 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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_.amenities AS amenities_18, p0_.parent_id AS parent_id_19 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;
27	2.51 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 33 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 (33) 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;
28	2.69 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	781
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	157
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	75
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	13
Aqarmap\Bundle\ListingBundle\Entity\Listing	6
Aqarmap\Bundle\UserBundle\Entity\Group	6
Aqarmap\Bundle\ListingBundle\Entity\Section	3
Aqarmap\Bundle\UserBundle\Entity\User	3
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	2
Aqarmap\Bundle\ListingBundle\Entity\Photo	2
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	1
Aqarmap\Bundle\DiscussionBundle\Entity\Category	1
App\Entity\Subscriptions\UserSubscription	1
Aqarmap\Bundle\CRMBundle\Entity\Company	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.
App\Entity\Location\LocationTier	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\Listing\ListingPaymentPlan	No errors.
App\Entity\ListingLabel	No errors.
Aqarmap\Bundle\ListingBundle\Entity\ListingRate	No errors.
Aqarmap\Bundle\ListingBundle\Entity\Favourite	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.
App\Entity\Wallet\Wallet	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=33

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping