Symfony Profiler

Query Metrics

46 Database Queries

22 Different statements

273.26 ms Query time

8 Invalid entities

519 Managed entities

Queries


SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1
SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1
SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) AND (p0_.deleted_at IS NULL)
SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL)
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 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_ WHERE (d0_.status = ? AND d0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deleted_at IS NULL) ORDER BY 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 AND l0_.root = ? ORDER BY l0_._left ASC
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.status = ? AND l0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4
SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_
SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ?
SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 AND l0_.root = ? ORDER BY l0_._left ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ?
SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ?
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ?
SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL))
SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 AND l0_.root = ? ORDER BY l0_._left ASC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC
SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC
SELECT p0_.slug AS slug_0, p0_.id AS id_1, p0_.title AS title_2, p0_.level AS level_3, s1_.search_result_count AS search_result_count_4 FROM property_types p0_ INNER JOIN search_results_combinations_counts s1_ ON (s1_.property_type_id = p0_.id) WHERE (s1_.property_type_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?) AND s1_.location_id IN (?) AND s1_.section_id = ? AND s1_.search_result_count >= ?) AND (p0_.deleted_at IS NULL) GROUP BY p0_.id ORDER BY s1_.search_result_count DESC
SELECT f0_.id AS id_0, f0_.name AS name_1, f0_.identifier AS identifier_2, f0_.description AS description_3, f0_.toggle_owner AS toggle_owner_4, f0_.status AS status_5, f0_.category AS category_6, f0_.added_at_date AS added_at_date_7, f0_.updated_at_date AS updated_at_date_8 FROM features_toggles f0_ WHERE f0_.identifier = ?

#▲	Time	Info
1	3.76 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_.keyword AS keyword_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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 Parameters: [`false true`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_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_.parent_id IS NULL AND l0_.disabled = ? AND l0_.searchable = ? LIMIT 1 SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.keyword AS keyword_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_.parent_id IS NULL AND l0_.disabled = 0 AND l0_.searchable = 1 LIMIT 1;
2	61.31 ms	SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ? Parameters: [`1`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = ? SELECT l0_.id AS id_0 FROM locations l0_ WHERE l0_._right < 25078 AND l0_._left > 1 AND l0_.root = 1;
3	2.83 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
4	3.82 ms	SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = ?) AND (p0_.deleted_at IS NULL) Parameters: [`83`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0 FROM property_types p0_ WHERE ( p0_._right < 41 AND p0_._left > 2 AND p0_.root = ? ) AND (p0_.deleted_at IS NULL) SELECT p0_.id AS id_0 FROM property_types p0_ WHERE (p0_._right < 41 AND p0_._left > 2 AND p0_.root = 83) AND (p0_.deleted_at IS NULL);
5	2.36 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0 Parameters: [] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0 SELECT t0.id AS id_1, t0.name AS name_2, t0.value AS value_3, t0.synced AS synced_4 FROM listing_score_settings t0;
6	4.45 ms	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN (?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) Parameters: [`"347" "318" "183" "233" "626"`] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE ( l0_.id IN (?, ?, ?, ?, ?) ) AND (l0_.deleted_at IS NULL) SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.id IN ('347', '318', '183', '233', '626')) AND (l0_.deleted_at IS NULL);
7	3.30 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.keyword AS keyword_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: [`"407"`] 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.keyword AS keyword_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.keyword AS keyword_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 = '407';
8	19.55 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 AND l0_.root = 1 ORDER BY l0_._left ASC;
9	5.75 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_ WHERE (d0_.status = ? AND d0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (d0_.deleted_at IS NULL) ORDER BY d0_.created_at DESC Parameters: [2 407 408 7723 15343 15344 15345 15346 15347 15348 15349 15350 15351 15352 15353 15354 15355 15356 15357 15358 15359 15360 15361 15362 15363 15364 15365 15366 15367 15368 15369 15370 15371 15372 15373 15374 15375 15376 15377 15378 15379 15380 15381 15382 15383 15384 15385 15386 15387 15388 15389 15390 15391 15392 15393 15394 15395 15396 15397 15398 15399 15400 15401 15402 15403 15404 15405 15406 15407 15408 15409 15410 15411 15412 15413 15414 15415 15416 15417 15418 15419 15420 15421 15422 15423 15424 15425 15426 15427 15428 15429 15430 15431 15432 15433 15434 15435 15436 15437 15438 15439 15440 15441 15442 15443 15444 15445 15446 15447 15448 15449 15450 15451 15452 15453 15454 15455 15456 15457 15458 15459 15460 15461 15462 15463 15464 15465 15466 15467 15468 15469 15470 15471 15472 15473 15474 15475 15476 24115 11365 11366 11367 11368 11369 11370 11371 11372 11373 11374 11375 11376 11377 11378 11379 11380 11381 11382 11383 11384 11386 11387 11388 11389 11390 11391 11392 11393 11394 11395 11396 11397 11398 11399 11400 11401 11402 11403 11404 11405 11406 11407 11408 11409 11410 11411 11412 11413 11414 11415 11416 11417 11418 11419 11420 11421 11422 11423 11424 11425 11426 11427 11428 11429 11430 11431 11432 11434 11527 11528 11529 11530 11531 11532 11533 11534 11535 11536 11537 11538 11539 11540 11541 11542 11543 11544 11545 11546 11547 11548 11549 11550 11551 11552 11553 11554 11555 11556 11557 11558 11559 11560 11561 11562 11563 11564 11565 11566 11567 11568 11569 11570 11571 11572 11573 11574 11575 11576 11577 11578 11579 11580 11581 11582 11583 11584 11585 11586 11587 11588 11589 11590 11591 11592 11593 11594 11595 11596 11597 11598 11599 11600 11601 11602 11603 11604 11605 11606 11607 11608 11609 11610 11611 11612 11613 11614 11615 11616 11617 11618 11619 11620 11621 11622 11623 11624 11625 11626 11627 11628 11629 11630 11631 11632 11633 11634 11635 11636 11637 11638 11639 11640 11641 11642 11643 11644 11645 11646 11647 11648 11649 11650 11651 11652 11653 11654 11655 11656 11657 11658 11659 11660 11661 11662 11663 11664 11665 11666 11667 11668 11669 11670 11671 11672 11673 11674 11675 11676 11677 11678 11679 11680 11681 11682 11683 11684 11685 11686 11687 11688 11689 11690 11691 11692 11693 11694 11695 11696 11697 11698 11699 11700 11701 11702 11703 11704 11705 11706 11707 11708 11709 11710 11711 28198] 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_ WHERE ( d0_.status = ? AND d0_.location_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND (d0_.deleted_at IS NULL) ORDER BY d0_.created_at DESC SELECT d0_.id AS id_0, d0_.content AS content_1, d0_.status AS status_2, d0_.created_at AS created_at_3, d0_.updated_at AS updated_at_4, d0_.comments_counter AS comments_counter_5, d0_.deleted_at AS deleted_at_6, d0_.severity AS severity_7, d0_.subscribers_notified AS subscribers_notified_8, d0_.reach_count AS reach_count_9, d0_.user_id AS user_id_10, d0_.location_id AS location_id_11, d0_.category_id AS category_id_12 FROM discussions d0_ WHERE (d0_.status = 2 AND d0_.location_id IN (407, 408, 7723, 15343, 15344, 15345, 15346, 15347, 15348, 15349, 15350, 15351, 15352, 15353, 15354, 15355, 15356, 15357, 15358, 15359, 15360, 15361, 15362, 15363, 15364, 15365, 15366, 15367, 15368, 15369, 15370, 15371, 15372, 15373, 15374, 15375, 15376, 15377, 15378, 15379, 15380, 15381, 15382, 15383, 15384, 15385, 15386, 15387, 15388, 15389, 15390, 15391, 15392, 15393, 15394, 15395, 15396, 15397, 15398, 15399, 15400, 15401, 15402, 15403, 15404, 15405, 15406, 15407, 15408, 15409, 15410, 15411, 15412, 15413, 15414, 15415, 15416, 15417, 15418, 15419, 15420, 15421, 15422, 15423, 15424, 15425, 15426, 15427, 15428, 15429, 15430, 15431, 15432, 15433, 15434, 15435, 15436, 15437, 15438, 15439, 15440, 15441, 15442, 15443, 15444, 15445, 15446, 15447, 15448, 15449, 15450, 15451, 15452, 15453, 15454, 15455, 15456, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15465, 15466, 15467, 15468, 15469, 15470, 15471, 15472, 15473, 15474, 15475, 15476, 24115, 11365, 11366, 11367, 11368, 11369, 11370, 11371, 11372, 11373, 11374, 11375, 11376, 11377, 11378, 11379, 11380, 11381, 11382, 11383, 11384, 11386, 11387, 11388, 11389, 11390, 11391, 11392, 11393, 11394, 11395, 11396, 11397, 11398, 11399, 11400, 11401, 11402, 11403, 11404, 11405, 11406, 11407, 11408, 11409, 11410, 11411, 11412, 11413, 11414, 11415, 11416, 11417, 11418, 11419, 11420, 11421, 11422, 11423, 11424, 11425, 11426, 11427, 11428, 11429, 11430, 11431, 11432, 11434, 11527, 11528, 11529, 11530, 11531, 11532, 11533, 11534, 11535, 11536, 11537, 11538, 11539, 11540, 11541, 11542, 11543, 11544, 11545, 11546, 11547, 11548, 11549, 11550, 11551, 11552, 11553, 11554, 11555, 11556, 11557, 11558, 11559, 11560, 11561, 11562, 11563, 11564, 11565, 11566, 11567, 11568, 11569, 11570, 11571, 11572, 11573, 11574, 11575, 11576, 11577, 11578, 11579, 11580, 11581, 11582, 11583, 11584, 11585, 11586, 11587, 11588, 11589, 11590, 11591, 11592, 11593, 11594, 11595, 11596, 11597, 11598, 11599, 11600, 11601, 11602, 11603, 11604, 11605, 11606, 11607, 11608, 11609, 11610, 11611, 11612, 11613, 11614, 11615, 11616, 11617, 11618, 11619, 11620, 11621, 11622, 11623, 11624, 11625, 11626, 11627, 11628, 11629, 11630, 11631, 11632, 11633, 11634, 11635, 11636, 11637, 11638, 11639, 11640, 11641, 11642, 11643, 11644, 11645, 11646, 11647, 11648, 11649, 11650, 11651, 11652, 11653, 11654, 11655, 11656, 11657, 11658, 11659, 11660, 11661, 11662, 11663, 11664, 11665, 11666, 11667, 11668, 11669, 11670, 11671, 11672, 11673, 11674, 11675, 11676, 11677, 11678, 11679, 11680, 11681, 11682, 11683, 11684, 11685, 11686, 11687, 11688, 11689, 11690, 11691, 11692, 11693, 11694, 11695, 11696, 11697, 11698, 11699, 11700, 11701, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 28198)) AND (d0_.deleted_at IS NULL) ORDER BY d0_.created_at DESC;
10	34.60 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 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_.keyword AS keyword_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 < 2049 AND l0_._left > 1266 AND l0_.root = 1 ORDER BY l0_._left ASC;
11	32.58 ms	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.status = ? AND l0_.location_id IN (?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4 Parameters: [2 407 408 7723 15343 15344 15345 15346 15347 15348 15349 15350 15351 15352 15353 15354 15355 15356 15357 15358 15359 15360 15361 15362 15363 15364 15365 15366 15367 15368 15369 15370 15371 15372 15373 15374 15375 15376 15377 15378 15379 15380 15381 15382 15383 15384 15385 15386 15387 15388 15389 15390 15391 15392 15393 15394 15395 15396 15397 15398 15399 15400 15401 15402 15403 15404 15405 15406 15407 15408 15409 15410 15411 15412 15413 15414 15415 15416 15417 15418 15419 15420 15421 15422 15423 15424 15425 15426 15427 15428 15429 15430 15431 15432 15433 15434 15435 15436 15437 15438 15439 15440 15441 15442 15443 15444 15445 15446 15447 15448 15449 15450 15451 15452 15453 15454 15455 15456 15457 15458 15459 15460 15461 15462 15463 15464 15465 15466 15467 15468 15469 15470 15471 15472 15473 15474 15475 15476 24115 11365 11366 11367 11368 11369 11370 11371 11372 11373 11374 11375 11376 11377 11378 11379 11380 11381 11382 11383 11384 11386 11387 11388 11389 11390 11391 11392 11393 11394 11395 11396 11397 11398 11399 11400 11401 11402 11403 11404 11405 11406 11407 11408 11409 11410 11411 11412 11413 11414 11415 11416 11417 11418 11419 11420 11421 11422 11423 11424 11425 11426 11427 11428 11429 11430 11431 11432 11434 11527 11528 11529 11530 11531 11532 11533 11534 11535 11536 11537 11538 11539 11540 11541 11542 11543 11544 11545 11546 11547 11548 11549 11550 11551 11552 11553 11554 11555 11556 11557 11558 11559 11560 11561 11562 11563 11564 11565 11566 11567 11568 11569 11570 11571 11572 11573 11574 11575 11576 11577 11578 11579 11580 11581 11582 11583 11584 11585 11586 11587 11588 11589 11590 11591 11592 11593 11594 11595 11596 11597 11598 11599 11600 11601 11602 11603 11604 11605 11606 11607 11608 11609 11610 11611 11612 11613 11614 11615 11616 11617 11618 11619 11620 11621 11622 11623 11624 11625 11626 11627 11628 11629 11630 11631 11632 11633 11634 11635 11636 11637 11638 11639 11640 11641 11642 11643 11644 11645 11646 11647 11648 11649 11650 11651 11652 11653 11654 11655 11656 11657 11658 11659 11660 11661 11662 11663 11664 11665 11666 11667 11668 11669 11670 11671 11672 11673 11674 11675 11676 11677 11678 11679 11680 11681 11682 11683 11684 11685 11686 11687 11688 11689 11690 11691 11692 11693 11694 11695 11696 11697 11698 11699 11700 11701 11702 11703 11704 11705 11706 11707 11708 11709 11710 11711 28198] View formatted query View runnable query Explain query SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE ( l0_.status = ? AND l0_.location_id IN ( ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ?, ? ) ) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4 SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.description AS description_2, l0_.category AS category_3, l0_.pending_photos_status AS pending_photos_status_4, l0_.pending_payment_status AS pending_payment_status_5, l0_.relist_status AS relist_status_6, l0_.seller_role AS seller_role_7, l0_.area AS area_8, l0_.price AS price_9, l0_.address AS address_10, l0_.center_lat AS center_lat_11, l0_.center_lng AS center_lng_12, l0_.status AS status_13, l0_.property_view AS property_view_14, l0_.payment_method AS payment_method_15, l0_.featured AS featured_16, l0_.views AS views_17, l0_.phone_counter AS phone_counter_18, l0_.messages_counter AS messages_counter_19, l0_.leads_counter AS leads_counter_20, l0_.sent_notifiers AS sent_notifiers_21, l0_.relist_counter AS relist_counter_22, l0_.ip AS ip_23, l0_.video_url AS video_url_24, l0_.slug AS slug_25, l0_.custom_slug AS custom_slug_26, l0_.score AS score_27, l0_.created_at AS created_at_28, l0_.updated_at AS updated_at_29, l0_.pending_status_created_at AS pending_status_created_at_30, l0_.published_at AS published_at_31, l0_.auto_reviewed_at AS auto_reviewed_at_32, l0_.expires_at AS expires_at_33, l0_.deleted_at AS deleted_at_34, l0_.rejected_at AS rejected_at_35, l0_.campaign AS campaign_36, l0_.final_price AS final_price_37, l0_.source_of_sale AS source_of_sale_38, l0_.delete_reason AS delete_reason_39, l0_.delete_reason_details AS delete_reason_details_40, l0_.source AS source_41, l0_.impressions AS impressions_42, l0_.impressions_monthly_count AS impressions_monthly_count_43, l0_.impressions_weekly_count AS impressions_weekly_count_44, l0_.impression_updated_at AS impression_updated_at_45, l0_.price_level AS price_level_46, l0_.compound_status AS compound_status_47, l0_.price_per_meter AS price_per_meter_48, l0_.is_bumped AS is_bumped_49, l0_.is_send_email AS is_send_email_50, l0_.is_availability_email_sent AS is_availability_email_sent_51, l0_.market_property_type AS market_property_type_52, l0_.creation_source AS creation_source_53, l0_.click_through_rate AS click_through_rate_54, l0_.label AS label_55, l0_.is_top_picks AS is_top_picks_56, l0_.contact_rate AS contact_rate_57, l0_.synced AS synced_58, l0_.reference_id AS reference_id_59, l0_.is_pending_featuring AS is_pending_featuring_60, l0_.pending_featuring_type AS pending_featuring_type_61, l0_.rate_status AS rate_status_62, l0_.is_rate_reviewed AS is_rate_reviewed_63, l0_.is_call_request AS is_call_request_64, l0_.is_shown_in_homepage AS is_shown_in_homepage_65, l0_.is_commercial AS is_commercial_66, l0_.is_resale AS is_resale_67, l0_.is_rent AS is_rent_68, l0_.is_primary AS is_primary_69, l0_.is_mortgage_approved AS is_mortgage_approved_70, l0_.meta_title AS meta_title_71, l0_.meta_description AS meta_description_72, l0_.is_mortgage AS is_mortgage_73, l0_.eligible_for_mortgage AS eligible_for_mortgage_74, l0_.property_registration_status AS property_registration_status_75, l0_.advertiser_number AS advertiser_number_76, l0_.authorization_number AS authorization_number_77, l0_.freezed_at AS freezed_at_78, l0_.eligible_for_bumpup AS eligible_for_bumpup_79, l0_.waiting_time AS waiting_time_80, l0_.reference_number AS reference_number_81, l0_.is_hold AS is_hold_82, l0_.is_ai_content AS is_ai_content_83, l0_.ai_review AS ai_review_84, l0_.rating_review_status AS rating_review_status_85, l0_.parent_id AS parent_id_86, l0_.relist_id AS relist_id_87, l0_.section_id AS section_id_88, l0_.property_type_id AS property_type_id_89, l0_.location_id AS location_id_90, l0_.compound_location_id AS compound_location_id_91, l0_.user_id AS user_id_92, l0_.compound_field_id AS compound_field_id_93, l0_.brochure_id AS brochure_id_94, l0_.valuation_id AS valuation_id_95 FROM listings l0_ WHERE (l0_.status = 2 AND l0_.location_id IN (407, 408, 7723, 15343, 15344, 15345, 15346, 15347, 15348, 15349, 15350, 15351, 15352, 15353, 15354, 15355, 15356, 15357, 15358, 15359, 15360, 15361, 15362, 15363, 15364, 15365, 15366, 15367, 15368, 15369, 15370, 15371, 15372, 15373, 15374, 15375, 15376, 15377, 15378, 15379, 15380, 15381, 15382, 15383, 15384, 15385, 15386, 15387, 15388, 15389, 15390, 15391, 15392, 15393, 15394, 15395, 15396, 15397, 15398, 15399, 15400, 15401, 15402, 15403, 15404, 15405, 15406, 15407, 15408, 15409, 15410, 15411, 15412, 15413, 15414, 15415, 15416, 15417, 15418, 15419, 15420, 15421, 15422, 15423, 15424, 15425, 15426, 15427, 15428, 15429, 15430, 15431, 15432, 15433, 15434, 15435, 15436, 15437, 15438, 15439, 15440, 15441, 15442, 15443, 15444, 15445, 15446, 15447, 15448, 15449, 15450, 15451, 15452, 15453, 15454, 15455, 15456, 15457, 15458, 15459, 15460, 15461, 15462, 15463, 15464, 15465, 15466, 15467, 15468, 15469, 15470, 15471, 15472, 15473, 15474, 15475, 15476, 24115, 11365, 11366, 11367, 11368, 11369, 11370, 11371, 11372, 11373, 11374, 11375, 11376, 11377, 11378, 11379, 11380, 11381, 11382, 11383, 11384, 11386, 11387, 11388, 11389, 11390, 11391, 11392, 11393, 11394, 11395, 11396, 11397, 11398, 11399, 11400, 11401, 11402, 11403, 11404, 11405, 11406, 11407, 11408, 11409, 11410, 11411, 11412, 11413, 11414, 11415, 11416, 11417, 11418, 11419, 11420, 11421, 11422, 11423, 11424, 11425, 11426, 11427, 11428, 11429, 11430, 11431, 11432, 11434, 11527, 11528, 11529, 11530, 11531, 11532, 11533, 11534, 11535, 11536, 11537, 11538, 11539, 11540, 11541, 11542, 11543, 11544, 11545, 11546, 11547, 11548, 11549, 11550, 11551, 11552, 11553, 11554, 11555, 11556, 11557, 11558, 11559, 11560, 11561, 11562, 11563, 11564, 11565, 11566, 11567, 11568, 11569, 11570, 11571, 11572, 11573, 11574, 11575, 11576, 11577, 11578, 11579, 11580, 11581, 11582, 11583, 11584, 11585, 11586, 11587, 11588, 11589, 11590, 11591, 11592, 11593, 11594, 11595, 11596, 11597, 11598, 11599, 11600, 11601, 11602, 11603, 11604, 11605, 11606, 11607, 11608, 11609, 11610, 11611, 11612, 11613, 11614, 11615, 11616, 11617, 11618, 11619, 11620, 11621, 11622, 11623, 11624, 11625, 11626, 11627, 11628, 11629, 11630, 11631, 11632, 11633, 11634, 11635, 11636, 11637, 11638, 11639, 11640, 11641, 11642, 11643, 11644, 11645, 11646, 11647, 11648, 11649, 11650, 11651, 11652, 11653, 11654, 11655, 11656, 11657, 11658, 11659, 11660, 11661, 11662, 11663, 11664, 11665, 11666, 11667, 11668, 11669, 11670, 11671, 11672, 11673, 11674, 11675, 11676, 11677, 11678, 11679, 11680, 11681, 11682, 11683, 11684, 11685, 11686, 11687, 11688, 11689, 11690, 11691, 11692, 11693, 11694, 11695, 11696, 11697, 11698, 11699, 11700, 11701, 11702, 11703, 11704, 11705, 11706, 11707, 11708, 11709, 11710, 11711, 28198)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;
12	3.55 ms	SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_;
13	3.07 ms	SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ? Parameters: [`1 "2025-12-19 16:46:33"`] View formatted query View runnable query Explain query SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (?) AND a0_.end_at >= ? SELECT a0_.id AS id_0, a0_.title AS title_1, a0_.url AS url_2, a0_.description AS description_3, a0_.customer_title AS customer_title_4, a0_.customer_url AS customer_url_5, a0_.customer_description AS customer_description_6, a0_.end_at AS end_at_7, a0_.start_at AS start_at_8, a0_.color AS color_9, a0_.counter AS counter_10, a0_.top_bar AS top_bar_11, a0_.appear_on_mobile AS appear_on_mobile_12 FROM announcements a0_ WHERE a0_.top_bar IN (1) AND a0_.end_at >= '2025-12-19 16:46:33';
14	3.87 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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 AND l0_.root = 1 ORDER BY l0_._left ASC;
15	4.08 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`347`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 347 ORDER BY t0.position ASC;
16	2.08 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`347`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 347 ORDER BY t0.position ASC;
17	3.63 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 16;
18	3.04 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`16`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 16 AND ((t0.deleted_at IS NULL));
19	2.61 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 16;
20	2.38 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`318`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 318 ORDER BY t0.position ASC;
21	2.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`318`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 318 ORDER BY t0.position ASC;
22	3.70 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 11;
23	2.62 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`11`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 11 AND ((t0.deleted_at IS NULL));
24	2.22 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`11`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 11;
25	2.33 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`183`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 183 ORDER BY t0.position ASC;
26	2.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`183`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = 183 ORDER BY t0.position ASC;
27	3.11 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 7;
28	2.50 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`7`] View formatted query View runnable query Explain query SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ( (t0.deleted_at IS NULL) ) SELECT COUNT(*) FROM listings t0 WHERE t0.user_id = 7 AND ((t0.deleted_at IS NULL));
29	2.16 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? Parameters: [`7`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.roles AS roles_3, t0.category AS category_4, t0.zoho_crm AS zoho_crm_5, t0.is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0.id = users_groups.group_id WHERE users_groups.user_id = 7;
30	2.05 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: [`233`] 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 = 233 ORDER BY t0.position ASC;
31	4.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`233`] 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 = 233 ORDER BY t0.position ASC;
32	3.39 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`17`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 17;
33	2.49 ms	SELECT COUNT() FROM listings t0 WHERE t0.user_id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`17`] 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 = 17 AND ((t0.deleted_at IS NULL));
34	2.20 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: [`17`] 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 = 17;
35	2.23 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: [`626`] 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 = 626 ORDER BY t0.position ASC;
36	2.19 ms	SELECT t0.id AS id_1, t0.caption AS caption_2, t0.type AS type_3, t0.position AS position_4, t0.listing_id AS listing_id_5, t0.photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0.listing_id = ? ORDER BY t0.position ASC Parameters: [`626`] 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 = 626 ORDER BY t0.position ASC;
37	2.25 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ? Parameters: [`215`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = 215;
38	2.10 ms	SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ? Parameters: [`217`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = ? SELECT t0.id AS id_1, t0.name AS name_2, t0.original_file_name AS original_file_name_3, t0.path AS path_4, t0.hash AS hash_5, t0.dimensions AS dimensions_6, t0.size AS size_7, t0.uploaded_at AS uploaded_at_8 FROM photos t0 WHERE t0.id = 217;
39	2.67 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) Parameters: [`3`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = 3 AND ((t0.deleted_at IS NULL));
40	3.83 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.keyword AS keyword_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: [`41`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.alias AS alias_3, t0.description AS description_4, t0.slug AS slug_5, t0.lat AS lat_6, t0.lon AS lon_7, t0.zoom AS zoom_8, t0.coordinates AS coordinates_9, t0.searchable AS searchable_10, t0.home_filter AS home_filter_11, t0.statistics_filter AS statistics_filter_12, t0.neighborhood_filter AS neighborhood_filter_13, t0.compound_filter AS compound_filter_14, t0.estimate AS estimate_15, t0.disabled AS disabled_16, t0.synced AS synced_17, t0.level AS level_18, t0._left AS _left_19, t0._right AS _right_20, t0.root AS root_21, t0.show_primary_only AS show_primary_only_22, t0.leads_counter AS leads_counter_23, t0.listings_counter AS listings_counter_24, t0.keyword AS keyword_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.keyword AS keyword_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 = 41;
41	3.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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 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_.keyword AS keyword_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 <= 1266 AND l0_._right >= 2049 AND l0_.root = 1 ORDER BY l0_._left ASC;
42	3.79 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC Parameters: [`false`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE ( p0_.level = 1 AND p0_.private = ? ) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = 0) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC;
43	2.80 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 407 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 (407) 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;
44	2.87 ms	SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = ?) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC Parameters: [`false`] View formatted query View runnable query Explain query SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE ( p0_.level = 1 AND p0_.private = ? ) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC SELECT p0_.id AS id_0, p0_.title AS title_1, p0_.title_singular AS title_singular_2, p0_.title_plural AS title_plural_3, p0_.slug AS slug_4, p0_.private AS private_5, p0_.level AS level_6, p0_._left AS _left_7, p0_._right AS _right_8, p0_.root AS root_9, p0_.compound_related AS compound_related_10, p0_.reference_id AS reference_id_11, p0_.exchangeable AS exchangeable_12, p0_.is_evaluable AS is_evaluable_13, p0_.synced AS synced_14, p0_.searchable AS searchable_15, p0_.deleted_at AS deleted_at_16, p0_.custom_order AS custom_order_17, p0_.parent_id AS parent_id_18 FROM property_types p0_ WHERE (p0_.level = 1 AND p0_.private = 0) AND (p0_.deleted_at IS NULL) ORDER BY p0_.root ASC, p0_._left ASC;
45	2.55 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 407 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 (407) 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;
46	2.40 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	397
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	75
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	14
Aqarmap\Bundle\ListingBundle\Entity\Listing	9
Aqarmap\Bundle\UserBundle\Entity\User	7
Aqarmap\Bundle\CRMBundle\Entity\Company	4
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	3
Aqarmap\Bundle\ListingBundle\Entity\Photo	3
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	2
Aqarmap\Bundle\ListingBundle\Entity\Section	2
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto	2
Aqarmap\Bundle\DiscussionBundle\Entity\Category	1

Entities Mapping

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

Symfony Profiler

GET https://testing-eg.am-root.com/ar/ask-neighbors/?location=407&tab=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping