Symfony Profiler

Query Metrics

46 Database Queries

22 Different statements

254.16 ms Query time

8 Invalid entities

1077 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 < 1872 AND l0_._left > 1 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 < 1872 AND l0_._left > 1 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 <= 1 AND l0_._right >= 1872 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 <= 1 AND l0_._right >= 1872 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	4.57 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	58.15 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	3.17 ms	SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ((t0.deleted_at IS NULL)) LIMIT 1 Parameters: [`1`] View formatted query View runnable query Explain query SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = ? AND ( (t0.deleted_at IS NULL) ) LIMIT 1 SELECT t0.id AS id_1, t0.title AS title_2, t0.title_singular AS title_singular_3, t0.title_plural AS title_plural_4, t0.slug AS slug_5, t0.private AS private_6, t0.level AS level_7, t0._left AS _left_8, t0._right AS _right_9, t0.root AS root_10, t0.compound_related AS compound_related_11, t0.reference_id AS reference_id_12, t0.exchangeable AS exchangeable_13, t0.is_evaluable AS is_evaluable_14, t0.synced AS synced_15, t0.searchable AS searchable_16, t0.deleted_at AS deleted_at_17, t0.custom_order AS custom_order_18, t0.parent_id AS parent_id_19 FROM property_types t0 WHERE t0.id = 1 AND ((t0.deleted_at IS NULL)) LIMIT 1;
4	2.01 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.35 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	5.21 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.42 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: [`"1296"`] 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 = '1296';
8	26.71 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 < 1872 AND l0_._left > 1 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1296`] 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 < 1872 AND l0_._left > 1 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 < 1872 AND l0_._left > 1 AND l0_.root = 1296 ORDER BY l0_._left ASC;
9	11.34 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 1296 8870 51 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 7612 7613 7614 7615 7616 7617 7618 7619 7620 1617 405 7834 102 414 416 413 7508 1240 3235 7007 3845 7634 3791 3964 6102 7090 3636 6930 1139 1065 4610 1125 6934 1147 4275 1344 4932 7009 7505 103 5538 2660 1146 1624 4930 4616 7055 4625 4624 4623 4622 4621 4620 4619 4618 4617 7493 7487 7340 7343 7339 7471 7454 2937 7445 7443 754 1625 7430 7411 290 7358 7367 7359 7350 7338 7333 7332 7331 7253 5632 5121 5377 5889 5634 5123 5379 5635 6147 2821 5125 5637 6149 5382 6150 5639 6151 6663 4104 5128 5384 4105 5641 6153 4106 5130 5386 6154 4107 5643 4108 5132 5388 6156 4109 5645 2574 4110 5390 6158 6670 2063 2831 4111 5135 5647 5392 6160 5137 5649 1810 4882 5394 6162 6418 5139 5651 5396 6164 5141 5653 1558 5398 6166 1815 5655 4376 5144 6168 5401 5657 5146 6170 5403 5659 6427 6172 3357 5149 5405 5661 6174 6942 5151 5407 5663 6176 6944 5409 5665 5154 6178 5411 5667 5156 5668 6180 5413 5669 5158 5670 6182 4903 5415 5671 2600 4392 5160 6184 1321 5417 5673 1834 2346 5162 6186 43 2347 4907 5419 5675 2092 2348 4140 4908 5164 6188 2349 4909 5421 5677 6957 2350 4910 5166 6190 2351 5423 5679 2352 2864 5168 5424 6192 6960 2353 5681 2354 5170 5426 6194 2355 4915 5683 7219 4404 5172 6196 4917 5429 5685 4918 6198 5431 5687 4920 5176 6200 4921 5177 5433 5689 6201 5690 6202 6970 5179 5435 6971 1596 5692 2621 5181 5438 5694 2111 4927 5183 2112 5696 5952 3393 4161 5185 5441 6977 1602 4597 4604 2626 6145 6932 4885 4887 4889 4890 4892 4894 4896 4900 4902 4913 5174 6454 4923 4925 6208 4929 6210 4931 6212 4933 6214 4936 6216 4938 6218 4940 6220 4942 6222 6224 4946 6226 4948 6228 5205 4950 6230 6232 6234 4955 6236 6238 2655 3584 4898 6206 6727 5453 4957 2941 3580 3581 3582 3583 4959 6239 6241 6243 4964 6245 4966 6247 4968 6249 6251 6253 4975 6255 6257 4979 6259 4981 6261 4983 6263 6265 6267 4988 6269 4991 6271 4993 6273 4995 6275 4997 6277 4999 6279 5001 6281 6283 5004 6285 5006 6286 6288 5009 7075 5286 4276 6586 4598 5367 4605 6888 1788 7254 5698 1347 5187 5443 5700 5189 5445 5190 5702 1607 4935 5191 5447 2120 5192 5704 7240 1353 5194 5450 5706 4427 1612 5196 5708 6476 5197 5710 5199 5455 1616 5712 2641 5201 5457 2642 5714 5203 5459 2900 5716 5461 5718 5207 5463 5720 5209 5465 5722 2907 5211 5467 1372 5724 1629 1885 5213 5469 5726 1119 5215 5471 1376 1632 5728 5217 5473 1378 4194 4962 5730 5219 5475 1636 5732 1637 5221 5477 1638 5734 2407 5223 5479 1384 5736 7016 5225 5481 5738 5227 5483 5740 1389 5229 5485 1390 5742 1391 5231 5487 1392 2935 4720 5744 5233 5489 5746 5235 5491 5492 5748 5237 1910 5238 5494 5750 1911 1912 5240 5496 5752 1913 7033 1914 5242 5498 5754 1915 3195 1916 2172 5244 5500 5756 1917 1918 5246 5502 5758 5248 5504 5760 5761 5506 5762 5251 2948 5508 5764 5253 5254 5510 5766 5767 5256 5512 5769 5258 5514 5771 4236 5260 5516 5773 5262 5518 5007 5775 4496 5264 5520 4497 5777 7057 4498 5266 5522 5011 5779 4500 5268 5524 5013 5781 5270 5526 5015 5783 5272 5528 5017 5785 4506 5274 5530 5019 5787 5276 5532 3997 5021 5789 2206 6453 4766 5278 5534 5023 5535 5791 5280 5536 5025 5537 5793 5282 5539 5795 5028 5284 5285 5541 5797 4518 5030 5543 5799 2216 4776 5032 5288 2217 5033 5545 5801 426 6204 1635 5290 2219 2731 4523 5547 5803 6315 5036 5292 5549 5805 5038 1199 1455 2991 5551 5807 2224 2992 5296 5041 5553 5809 5298 5043 5555 5811 5300 5045 5557 5813 5302 5559 5815 5048 5304 6584 5561 5817 5050 5306 5563 5819 5052 5308 1213 27167 5565 5821 5054 5310 5567 5823 4800 5056 5312 1217 5569 5825 5058 5314 1475 5571 5827 5060 5316 5573 5829 4550 5318 5063 5575 5831 1480 5320 5065 5577 5833 5322 7114 5067 5579 5835 5324 5837 7117 2510 5070 5582 7118 5327 5839 5072 5584 3281 5329 5841 5074 5586 3283 4819 5331 5843 5076 5588 5333 5845 5078 5590 5079 5335 5847 5592 5337 5849 2522 5082 5594 5339 5851 5084 5596 5341 5853 5086 5598 5343 5855 4320 5088 5600 4577 5345 5857 2530 4834 5090 5602 4579 5347 5859 3556 5092 5604 6116 5349 5861 5094 5606 6118 5351 5863 5096 5608 6120 1257 5353 5865 4586 5098 5354 5610 6122 5867 5100 5356 5612 6124 1261 1634 1773 1262 5102 5358 5614 6126 1263 5104 5360 5616 2289 6129 1266 5106 5618 2547 5107 5363 6131 3316 5620 4853 5109 5365 6133 5622 1271 6135 1272 5112 5624 1273 5369 6137 1274 5114 5626 2811 5371 6139 5116 5628 2301 4349 5373 6141 5118 5630 5375 6143 7494 15479 15480 15481 15482 15483 15484 15485 15486 15487 15488 15489 15490 15491 15492 15493 15494 15495 15496 15497 15498 15499 15500 15501 15502 15503 15504 15505 15506 15507 15508 15509 15510 15511 15512 15513 15514 15515 15516 15517 15518 15519 15520 15521 15522 15523 15524 15525 15526 15527 15528 15529 15530 15531 15532 15533 15534 15535 15536 15537 15538 15539 15540 15541 15542 15543 15544 15545] 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 (1296, 8870, 51, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7620, 1617, 405, 7834, 102, 414, 416, 413, 7508, 1240, 3235, 7007, 3845, 7634, 3791, 3964, 6102, 7090, 3636, 6930, 1139, 1065, 4610, 1125, 6934, 1147, 4275, 1344, 4932, 7009, 7505, 103, 5538, 2660, 1146, 1624, 4930, 4616, 7055, 4625, 4624, 4623, 4622, 4621, 4620, 4619, 4618, 4617, 7493, 7487, 7340, 7343, 7339, 7471, 7454, 2937, 7445, 7443, 754, 1625, 7430, 7411, 290, 7358, 7367, 7359, 7350, 7338, 7333, 7332, 7331, 7253, 5632, 5121, 5377, 5889, 5634, 5123, 5379, 5635, 6147, 2821, 5125, 5637, 6149, 5382, 6150, 5639, 6151, 6663, 4104, 5128, 5384, 4105, 5641, 6153, 4106, 5130, 5386, 6154, 4107, 5643, 4108, 5132, 5388, 6156, 4109, 5645, 2574, 4110, 5390, 6158, 6670, 2063, 2831, 4111, 5135, 5647, 5392, 6160, 5137, 5649, 1810, 4882, 5394, 6162, 6418, 5139, 5651, 5396, 6164, 5141, 5653, 1558, 5398, 6166, 1815, 5655, 4376, 5144, 6168, 5401, 5657, 5146, 6170, 5403, 5659, 6427, 6172, 3357, 5149, 5405, 5661, 6174, 6942, 5151, 5407, 5663, 6176, 6944, 5409, 5665, 5154, 6178, 5411, 5667, 5156, 5668, 6180, 5413, 5669, 5158, 5670, 6182, 4903, 5415, 5671, 2600, 4392, 5160, 6184, 1321, 5417, 5673, 1834, 2346, 5162, 6186, 43, 2347, 4907, 5419, 5675, 2092, 2348, 4140, 4908, 5164, 6188, 2349, 4909, 5421, 5677, 6957, 2350, 4910, 5166, 6190, 2351, 5423, 5679, 2352, 2864, 5168, 5424, 6192, 6960, 2353, 5681, 2354, 5170, 5426, 6194, 2355, 4915, 5683, 7219, 4404, 5172, 6196, 4917, 5429, 5685, 4918, 6198, 5431, 5687, 4920, 5176, 6200, 4921, 5177, 5433, 5689, 6201, 5690, 6202, 6970, 5179, 5435, 6971, 1596, 5692, 2621, 5181, 5438, 5694, 2111, 4927, 5183, 2112, 5696, 5952, 3393, 4161, 5185, 5441, 6977, 1602, 4597, 4604, 2626, 6145, 6932, 4885, 4887, 4889, 4890, 4892, 4894, 4896, 4900, 4902, 4913, 5174, 6454, 4923, 4925, 6208, 4929, 6210, 4931, 6212, 4933, 6214, 4936, 6216, 4938, 6218, 4940, 6220, 4942, 6222, 6224, 4946, 6226, 4948, 6228, 5205, 4950, 6230, 6232, 6234, 4955, 6236, 6238, 2655, 3584, 4898, 6206, 6727, 5453, 4957, 2941, 3580, 3581, 3582, 3583, 4959, 6239, 6241, 6243, 4964, 6245, 4966, 6247, 4968, 6249, 6251, 6253, 4975, 6255, 6257, 4979, 6259, 4981, 6261, 4983, 6263, 6265, 6267, 4988, 6269, 4991, 6271, 4993, 6273, 4995, 6275, 4997, 6277, 4999, 6279, 5001, 6281, 6283, 5004, 6285, 5006, 6286, 6288, 5009, 7075, 5286, 4276, 6586, 4598, 5367, 4605, 6888, 1788, 7254, 5698, 1347, 5187, 5443, 5700, 5189, 5445, 5190, 5702, 1607, 4935, 5191, 5447, 2120, 5192, 5704, 7240, 1353, 5194, 5450, 5706, 4427, 1612, 5196, 5708, 6476, 5197, 5710, 5199, 5455, 1616, 5712, 2641, 5201, 5457, 2642, 5714, 5203, 5459, 2900, 5716, 5461, 5718, 5207, 5463, 5720, 5209, 5465, 5722, 2907, 5211, 5467, 1372, 5724, 1629, 1885, 5213, 5469, 5726, 1119, 5215, 5471, 1376, 1632, 5728, 5217, 5473, 1378, 4194, 4962, 5730, 5219, 5475, 1636, 5732, 1637, 5221, 5477, 1638, 5734, 2407, 5223, 5479, 1384, 5736, 7016, 5225, 5481, 5738, 5227, 5483, 5740, 1389, 5229, 5485, 1390, 5742, 1391, 5231, 5487, 1392, 2935, 4720, 5744, 5233, 5489, 5746, 5235, 5491, 5492, 5748, 5237, 1910, 5238, 5494, 5750, 1911, 1912, 5240, 5496, 5752, 1913, 7033, 1914, 5242, 5498, 5754, 1915, 3195, 1916, 2172, 5244, 5500, 5756, 1917, 1918, 5246, 5502, 5758, 5248, 5504, 5760, 5761, 5506, 5762, 5251, 2948, 5508, 5764, 5253, 5254, 5510, 5766, 5767, 5256, 5512, 5769, 5258, 5514, 5771, 4236, 5260, 5516, 5773, 5262, 5518, 5007, 5775, 4496, 5264, 5520, 4497, 5777, 7057, 4498, 5266, 5522, 5011, 5779, 4500, 5268, 5524, 5013, 5781, 5270, 5526, 5015, 5783, 5272, 5528, 5017, 5785, 4506, 5274, 5530, 5019, 5787, 5276, 5532, 3997, 5021, 5789, 2206, 6453, 4766, 5278, 5534, 5023, 5535, 5791, 5280, 5536, 5025, 5537, 5793, 5282, 5539, 5795, 5028, 5284, 5285, 5541, 5797, 4518, 5030, 5543, 5799, 2216, 4776, 5032, 5288, 2217, 5033, 5545, 5801, 426, 6204, 1635, 5290, 2219, 2731, 4523, 5547, 5803, 6315, 5036, 5292, 5549, 5805, 5038, 1199, 1455, 2991, 5551, 5807, 2224, 2992, 5296, 5041, 5553, 5809, 5298, 5043, 5555, 5811, 5300, 5045, 5557, 5813, 5302, 5559, 5815, 5048, 5304, 6584, 5561, 5817, 5050, 5306, 5563, 5819, 5052, 5308, 1213, 27167, 5565, 5821, 5054, 5310, 5567, 5823, 4800, 5056, 5312, 1217, 5569, 5825, 5058, 5314, 1475, 5571, 5827, 5060, 5316, 5573, 5829, 4550, 5318, 5063, 5575, 5831, 1480, 5320, 5065, 5577, 5833, 5322, 7114, 5067, 5579, 5835, 5324, 5837, 7117, 2510, 5070, 5582, 7118, 5327, 5839, 5072, 5584, 3281, 5329, 5841, 5074, 5586, 3283, 4819, 5331, 5843, 5076, 5588, 5333, 5845, 5078, 5590, 5079, 5335, 5847, 5592, 5337, 5849, 2522, 5082, 5594, 5339, 5851, 5084, 5596, 5341, 5853, 5086, 5598, 5343, 5855, 4320, 5088, 5600, 4577, 5345, 5857, 2530, 4834, 5090, 5602, 4579, 5347, 5859, 3556, 5092, 5604, 6116, 5349, 5861, 5094, 5606, 6118, 5351, 5863, 5096, 5608, 6120, 1257, 5353, 5865, 4586, 5098, 5354, 5610, 6122, 5867, 5100, 5356, 5612, 6124, 1261, 1634, 1773, 1262, 5102, 5358, 5614, 6126, 1263, 5104, 5360, 5616, 2289, 6129, 1266, 5106, 5618, 2547, 5107, 5363, 6131, 3316, 5620, 4853, 5109, 5365, 6133, 5622, 1271, 6135, 1272, 5112, 5624, 1273, 5369, 6137, 1274, 5114, 5626, 2811, 5371, 6139, 5116, 5628, 2301, 4349, 5373, 6141, 5118, 5630, 5375, 6143, 7494, 15479, 15480, 15481, 15482, 15483, 15484, 15485, 15486, 15487, 15488, 15489, 15490, 15491, 15492, 15493, 15494, 15495, 15496, 15497, 15498, 15499, 15500, 15501, 15502, 15503, 15504, 15505, 15506, 15507, 15508, 15509, 15510, 15511, 15512, 15513, 15514, 15515, 15516, 15517, 15518, 15519, 15520, 15521, 15522, 15523, 15524, 15525, 15526, 15527, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15538, 15539, 15540, 15541, 15542, 15543, 15544, 15545)) AND (d0_.deleted_at IS NULL) ORDER BY d0_.created_at DESC;
10	21.57 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 < 1872 AND l0_._left > 1 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1296`] 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 < 1872 AND l0_._left > 1 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 < 1872 AND l0_._left > 1 AND l0_.root = 1296 ORDER BY l0_._left ASC;
11	36.78 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 1296 8870 51 382 383 384 385 386 387 388 389 390 391 392 393 394 395 396 397 398 7612 7613 7614 7615 7616 7617 7618 7619 7620 1617 405 7834 102 414 416 413 7508 1240 3235 7007 3845 7634 3791 3964 6102 7090 3636 6930 1139 1065 4610 1125 6934 1147 4275 1344 4932 7009 7505 103 5538 2660 1146 1624 4930 4616 7055 4625 4624 4623 4622 4621 4620 4619 4618 4617 7493 7487 7340 7343 7339 7471 7454 2937 7445 7443 754 1625 7430 7411 290 7358 7367 7359 7350 7338 7333 7332 7331 7253 5632 5121 5377 5889 5634 5123 5379 5635 6147 2821 5125 5637 6149 5382 6150 5639 6151 6663 4104 5128 5384 4105 5641 6153 4106 5130 5386 6154 4107 5643 4108 5132 5388 6156 4109 5645 2574 4110 5390 6158 6670 2063 2831 4111 5135 5647 5392 6160 5137 5649 1810 4882 5394 6162 6418 5139 5651 5396 6164 5141 5653 1558 5398 6166 1815 5655 4376 5144 6168 5401 5657 5146 6170 5403 5659 6427 6172 3357 5149 5405 5661 6174 6942 5151 5407 5663 6176 6944 5409 5665 5154 6178 5411 5667 5156 5668 6180 5413 5669 5158 5670 6182 4903 5415 5671 2600 4392 5160 6184 1321 5417 5673 1834 2346 5162 6186 43 2347 4907 5419 5675 2092 2348 4140 4908 5164 6188 2349 4909 5421 5677 6957 2350 4910 5166 6190 2351 5423 5679 2352 2864 5168 5424 6192 6960 2353 5681 2354 5170 5426 6194 2355 4915 5683 7219 4404 5172 6196 4917 5429 5685 4918 6198 5431 5687 4920 5176 6200 4921 5177 5433 5689 6201 5690 6202 6970 5179 5435 6971 1596 5692 2621 5181 5438 5694 2111 4927 5183 2112 5696 5952 3393 4161 5185 5441 6977 1602 4597 4604 2626 6145 6932 4885 4887 4889 4890 4892 4894 4896 4900 4902 4913 5174 6454 4923 4925 6208 4929 6210 4931 6212 4933 6214 4936 6216 4938 6218 4940 6220 4942 6222 6224 4946 6226 4948 6228 5205 4950 6230 6232 6234 4955 6236 6238 2655 3584 4898 6206 6727 5453 4957 2941 3580 3581 3582 3583 4959 6239 6241 6243 4964 6245 4966 6247 4968 6249 6251 6253 4975 6255 6257 4979 6259 4981 6261 4983 6263 6265 6267 4988 6269 4991 6271 4993 6273 4995 6275 4997 6277 4999 6279 5001 6281 6283 5004 6285 5006 6286 6288 5009 7075 5286 4276 6586 4598 5367 4605 6888 1788 7254 5698 1347 5187 5443 5700 5189 5445 5190 5702 1607 4935 5191 5447 2120 5192 5704 7240 1353 5194 5450 5706 4427 1612 5196 5708 6476 5197 5710 5199 5455 1616 5712 2641 5201 5457 2642 5714 5203 5459 2900 5716 5461 5718 5207 5463 5720 5209 5465 5722 2907 5211 5467 1372 5724 1629 1885 5213 5469 5726 1119 5215 5471 1376 1632 5728 5217 5473 1378 4194 4962 5730 5219 5475 1636 5732 1637 5221 5477 1638 5734 2407 5223 5479 1384 5736 7016 5225 5481 5738 5227 5483 5740 1389 5229 5485 1390 5742 1391 5231 5487 1392 2935 4720 5744 5233 5489 5746 5235 5491 5492 5748 5237 1910 5238 5494 5750 1911 1912 5240 5496 5752 1913 7033 1914 5242 5498 5754 1915 3195 1916 2172 5244 5500 5756 1917 1918 5246 5502 5758 5248 5504 5760 5761 5506 5762 5251 2948 5508 5764 5253 5254 5510 5766 5767 5256 5512 5769 5258 5514 5771 4236 5260 5516 5773 5262 5518 5007 5775 4496 5264 5520 4497 5777 7057 4498 5266 5522 5011 5779 4500 5268 5524 5013 5781 5270 5526 5015 5783 5272 5528 5017 5785 4506 5274 5530 5019 5787 5276 5532 3997 5021 5789 2206 6453 4766 5278 5534 5023 5535 5791 5280 5536 5025 5537 5793 5282 5539 5795 5028 5284 5285 5541 5797 4518 5030 5543 5799 2216 4776 5032 5288 2217 5033 5545 5801 426 6204 1635 5290 2219 2731 4523 5547 5803 6315 5036 5292 5549 5805 5038 1199 1455 2991 5551 5807 2224 2992 5296 5041 5553 5809 5298 5043 5555 5811 5300 5045 5557 5813 5302 5559 5815 5048 5304 6584 5561 5817 5050 5306 5563 5819 5052 5308 1213 27167 5565 5821 5054 5310 5567 5823 4800 5056 5312 1217 5569 5825 5058 5314 1475 5571 5827 5060 5316 5573 5829 4550 5318 5063 5575 5831 1480 5320 5065 5577 5833 5322 7114 5067 5579 5835 5324 5837 7117 2510 5070 5582 7118 5327 5839 5072 5584 3281 5329 5841 5074 5586 3283 4819 5331 5843 5076 5588 5333 5845 5078 5590 5079 5335 5847 5592 5337 5849 2522 5082 5594 5339 5851 5084 5596 5341 5853 5086 5598 5343 5855 4320 5088 5600 4577 5345 5857 2530 4834 5090 5602 4579 5347 5859 3556 5092 5604 6116 5349 5861 5094 5606 6118 5351 5863 5096 5608 6120 1257 5353 5865 4586 5098 5354 5610 6122 5867 5100 5356 5612 6124 1261 1634 1773 1262 5102 5358 5614 6126 1263 5104 5360 5616 2289 6129 1266 5106 5618 2547 5107 5363 6131 3316 5620 4853 5109 5365 6133 5622 1271 6135 1272 5112 5624 1273 5369 6137 1274 5114 5626 2811 5371 6139 5116 5628 2301 4349 5373 6141 5118 5630 5375 6143 7494 15479 15480 15481 15482 15483 15484 15485 15486 15487 15488 15489 15490 15491 15492 15493 15494 15495 15496 15497 15498 15499 15500 15501 15502 15503 15504 15505 15506 15507 15508 15509 15510 15511 15512 15513 15514 15515 15516 15517 15518 15519 15520 15521 15522 15523 15524 15525 15526 15527 15528 15529 15530 15531 15532 15533 15534 15535 15536 15537 15538 15539 15540 15541 15542 15543 15544 15545] 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 (1296, 8870, 51, 382, 383, 384, 385, 386, 387, 388, 389, 390, 391, 392, 393, 394, 395, 396, 397, 398, 7612, 7613, 7614, 7615, 7616, 7617, 7618, 7619, 7620, 1617, 405, 7834, 102, 414, 416, 413, 7508, 1240, 3235, 7007, 3845, 7634, 3791, 3964, 6102, 7090, 3636, 6930, 1139, 1065, 4610, 1125, 6934, 1147, 4275, 1344, 4932, 7009, 7505, 103, 5538, 2660, 1146, 1624, 4930, 4616, 7055, 4625, 4624, 4623, 4622, 4621, 4620, 4619, 4618, 4617, 7493, 7487, 7340, 7343, 7339, 7471, 7454, 2937, 7445, 7443, 754, 1625, 7430, 7411, 290, 7358, 7367, 7359, 7350, 7338, 7333, 7332, 7331, 7253, 5632, 5121, 5377, 5889, 5634, 5123, 5379, 5635, 6147, 2821, 5125, 5637, 6149, 5382, 6150, 5639, 6151, 6663, 4104, 5128, 5384, 4105, 5641, 6153, 4106, 5130, 5386, 6154, 4107, 5643, 4108, 5132, 5388, 6156, 4109, 5645, 2574, 4110, 5390, 6158, 6670, 2063, 2831, 4111, 5135, 5647, 5392, 6160, 5137, 5649, 1810, 4882, 5394, 6162, 6418, 5139, 5651, 5396, 6164, 5141, 5653, 1558, 5398, 6166, 1815, 5655, 4376, 5144, 6168, 5401, 5657, 5146, 6170, 5403, 5659, 6427, 6172, 3357, 5149, 5405, 5661, 6174, 6942, 5151, 5407, 5663, 6176, 6944, 5409, 5665, 5154, 6178, 5411, 5667, 5156, 5668, 6180, 5413, 5669, 5158, 5670, 6182, 4903, 5415, 5671, 2600, 4392, 5160, 6184, 1321, 5417, 5673, 1834, 2346, 5162, 6186, 43, 2347, 4907, 5419, 5675, 2092, 2348, 4140, 4908, 5164, 6188, 2349, 4909, 5421, 5677, 6957, 2350, 4910, 5166, 6190, 2351, 5423, 5679, 2352, 2864, 5168, 5424, 6192, 6960, 2353, 5681, 2354, 5170, 5426, 6194, 2355, 4915, 5683, 7219, 4404, 5172, 6196, 4917, 5429, 5685, 4918, 6198, 5431, 5687, 4920, 5176, 6200, 4921, 5177, 5433, 5689, 6201, 5690, 6202, 6970, 5179, 5435, 6971, 1596, 5692, 2621, 5181, 5438, 5694, 2111, 4927, 5183, 2112, 5696, 5952, 3393, 4161, 5185, 5441, 6977, 1602, 4597, 4604, 2626, 6145, 6932, 4885, 4887, 4889, 4890, 4892, 4894, 4896, 4900, 4902, 4913, 5174, 6454, 4923, 4925, 6208, 4929, 6210, 4931, 6212, 4933, 6214, 4936, 6216, 4938, 6218, 4940, 6220, 4942, 6222, 6224, 4946, 6226, 4948, 6228, 5205, 4950, 6230, 6232, 6234, 4955, 6236, 6238, 2655, 3584, 4898, 6206, 6727, 5453, 4957, 2941, 3580, 3581, 3582, 3583, 4959, 6239, 6241, 6243, 4964, 6245, 4966, 6247, 4968, 6249, 6251, 6253, 4975, 6255, 6257, 4979, 6259, 4981, 6261, 4983, 6263, 6265, 6267, 4988, 6269, 4991, 6271, 4993, 6273, 4995, 6275, 4997, 6277, 4999, 6279, 5001, 6281, 6283, 5004, 6285, 5006, 6286, 6288, 5009, 7075, 5286, 4276, 6586, 4598, 5367, 4605, 6888, 1788, 7254, 5698, 1347, 5187, 5443, 5700, 5189, 5445, 5190, 5702, 1607, 4935, 5191, 5447, 2120, 5192, 5704, 7240, 1353, 5194, 5450, 5706, 4427, 1612, 5196, 5708, 6476, 5197, 5710, 5199, 5455, 1616, 5712, 2641, 5201, 5457, 2642, 5714, 5203, 5459, 2900, 5716, 5461, 5718, 5207, 5463, 5720, 5209, 5465, 5722, 2907, 5211, 5467, 1372, 5724, 1629, 1885, 5213, 5469, 5726, 1119, 5215, 5471, 1376, 1632, 5728, 5217, 5473, 1378, 4194, 4962, 5730, 5219, 5475, 1636, 5732, 1637, 5221, 5477, 1638, 5734, 2407, 5223, 5479, 1384, 5736, 7016, 5225, 5481, 5738, 5227, 5483, 5740, 1389, 5229, 5485, 1390, 5742, 1391, 5231, 5487, 1392, 2935, 4720, 5744, 5233, 5489, 5746, 5235, 5491, 5492, 5748, 5237, 1910, 5238, 5494, 5750, 1911, 1912, 5240, 5496, 5752, 1913, 7033, 1914, 5242, 5498, 5754, 1915, 3195, 1916, 2172, 5244, 5500, 5756, 1917, 1918, 5246, 5502, 5758, 5248, 5504, 5760, 5761, 5506, 5762, 5251, 2948, 5508, 5764, 5253, 5254, 5510, 5766, 5767, 5256, 5512, 5769, 5258, 5514, 5771, 4236, 5260, 5516, 5773, 5262, 5518, 5007, 5775, 4496, 5264, 5520, 4497, 5777, 7057, 4498, 5266, 5522, 5011, 5779, 4500, 5268, 5524, 5013, 5781, 5270, 5526, 5015, 5783, 5272, 5528, 5017, 5785, 4506, 5274, 5530, 5019, 5787, 5276, 5532, 3997, 5021, 5789, 2206, 6453, 4766, 5278, 5534, 5023, 5535, 5791, 5280, 5536, 5025, 5537, 5793, 5282, 5539, 5795, 5028, 5284, 5285, 5541, 5797, 4518, 5030, 5543, 5799, 2216, 4776, 5032, 5288, 2217, 5033, 5545, 5801, 426, 6204, 1635, 5290, 2219, 2731, 4523, 5547, 5803, 6315, 5036, 5292, 5549, 5805, 5038, 1199, 1455, 2991, 5551, 5807, 2224, 2992, 5296, 5041, 5553, 5809, 5298, 5043, 5555, 5811, 5300, 5045, 5557, 5813, 5302, 5559, 5815, 5048, 5304, 6584, 5561, 5817, 5050, 5306, 5563, 5819, 5052, 5308, 1213, 27167, 5565, 5821, 5054, 5310, 5567, 5823, 4800, 5056, 5312, 1217, 5569, 5825, 5058, 5314, 1475, 5571, 5827, 5060, 5316, 5573, 5829, 4550, 5318, 5063, 5575, 5831, 1480, 5320, 5065, 5577, 5833, 5322, 7114, 5067, 5579, 5835, 5324, 5837, 7117, 2510, 5070, 5582, 7118, 5327, 5839, 5072, 5584, 3281, 5329, 5841, 5074, 5586, 3283, 4819, 5331, 5843, 5076, 5588, 5333, 5845, 5078, 5590, 5079, 5335, 5847, 5592, 5337, 5849, 2522, 5082, 5594, 5339, 5851, 5084, 5596, 5341, 5853, 5086, 5598, 5343, 5855, 4320, 5088, 5600, 4577, 5345, 5857, 2530, 4834, 5090, 5602, 4579, 5347, 5859, 3556, 5092, 5604, 6116, 5349, 5861, 5094, 5606, 6118, 5351, 5863, 5096, 5608, 6120, 1257, 5353, 5865, 4586, 5098, 5354, 5610, 6122, 5867, 5100, 5356, 5612, 6124, 1261, 1634, 1773, 1262, 5102, 5358, 5614, 6126, 1263, 5104, 5360, 5616, 2289, 6129, 1266, 5106, 5618, 2547, 5107, 5363, 6131, 3316, 5620, 4853, 5109, 5365, 6133, 5622, 1271, 6135, 1272, 5112, 5624, 1273, 5369, 6137, 1274, 5114, 5626, 2811, 5371, 6139, 5116, 5628, 2301, 4349, 5373, 6141, 5118, 5630, 5375, 6143, 7494, 15479, 15480, 15481, 15482, 15483, 15484, 15485, 15486, 15487, 15488, 15489, 15490, 15491, 15492, 15493, 15494, 15495, 15496, 15497, 15498, 15499, 15500, 15501, 15502, 15503, 15504, 15505, 15506, 15507, 15508, 15509, 15510, 15511, 15512, 15513, 15514, 15515, 15516, 15517, 15518, 15519, 15520, 15521, 15522, 15523, 15524, 15525, 15526, 15527, 15528, 15529, 15530, 15531, 15532, 15533, 15534, 15535, 15536, 15537, 15538, 15539, 15540, 15541, 15542, 15543, 15544, 15545)) AND (l0_.deleted_at IS NULL) ORDER BY l0_.published_at DESC LIMIT 4;
12	2.52 ms	SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ Parameters: [] View formatted query View runnable query Explain query SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_ SELECT d0_.id AS id_0, d0_.title AS title_1, d0_.created_at AS created_at_2 FROM discussions_categories d0_;
13	2.36 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 05:31:17"`] 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 05:31:17';
14	2.59 ms	SELECT l0_.id AS id_0, l0_.title AS title_1, l0_.alias AS alias_2, l0_.description AS description_3, l0_.slug AS slug_4, l0_.lat AS lat_5, l0_.lon AS lon_6, l0_.zoom AS zoom_7, l0_.coordinates AS coordinates_8, l0_.searchable AS searchable_9, l0_.home_filter AS home_filter_10, l0_.statistics_filter AS statistics_filter_11, l0_.neighborhood_filter AS neighborhood_filter_12, l0_.compound_filter AS compound_filter_13, l0_.estimate AS estimate_14, l0_.disabled AS disabled_15, l0_.synced AS synced_16, l0_.level AS level_17, l0_._left AS _left_18, l0_._right AS _right_19, l0_.root AS root_20, l0_.show_primary_only AS show_primary_only_21, l0_.leads_counter AS leads_counter_22, l0_.listings_counter AS listings_counter_23, l0_.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 <= 1 AND l0_._right >= 1872 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1296`] 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 <= 1 AND l0_._right >= 1872 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 <= 1 AND l0_._right >= 1872 AND l0_.root = 1296 ORDER BY l0_._left ASC;
15	2.21 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	1.85 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.31 ms	SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? Parameters: [`16`] View formatted query View runnable query Explain query SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = ? SELECT t0.username AS username_1, t0.username_canonical AS username_canonical_2, t0.email AS email_3, t0.email_canonical AS email_canonical_4, t0.enabled AS enabled_5, t0.salt AS salt_6, t0.password AS password_7, t0.last_login AS last_login_8, t0.confirmation_token AS confirmation_token_9, t0.password_requested_at AS password_requested_at_10, t0.roles AS roles_11, t0.id AS id_12, t0.full_name AS full_name_13, t0.bio AS bio_14, t0.phone_number AS phone_number_15, t0.is_valid_logo AS is_valid_logo_16, t0.is_valid_personal_photo AS is_valid_personal_photo_17, t0.is_migrated_phone AS is_migrated_phone_18, t0.is_valid_email AS is_valid_email_19, t0.user_type AS user_type_20, t0.language AS language_21, t0.legacy AS legacy_22, t0.facebook_id AS facebook_id_23, t0.google_id AS google_id_24, t0.registration_ip AS registration_ip_25, t0.created_at AS created_at_26, t0.last_update AS last_update_27, t0.global_unsubscribe AS global_unsubscribe_28, t0.customer_profiling_queue_date AS customer_profiling_queue_date_29, t0.is_quick_registered AS is_quick_registered_30, t0.score AS score_31, t0.is_imported AS is_imported_32, t0.subscription_expiry_date AS subscription_expiry_date_33, t0.credit_expiry_date AS credit_expiry_date_34, t0.soft_churn_date AS soft_churn_date_35, t0.reach_count AS reach_count_36, t0.synced AS synced_37, t0.reference_id AS reference_id_38, t0.has_email AS has_email_39, t0.client_served_count AS client_served_count_40, t0.enabled_marketing AS enabled_marketing_41, t0.zoho_synced AS zoho_synced_42, t0.recent_search_last_checked AS recent_search_last_checked_43, t0.listing_availability_last_checked AS listing_availability_last_checked_44, t0.recent_search_last_send AS recent_search_last_send_45, t0.boost_level AS boost_level_46, t0.boost AS boost_47, t0.is_phone_verified AS is_phone_verified_48, t0.auth_identifier AS auth_identifier_49, t0.auth_access_token AS auth_access_token_50, t0.auth_refresh_token AS auth_refresh_token_51, t0.auth_updated_at AS auth_updated_at_52, t0.parent_id AS parent_id_53, t0.logo AS logo_54, t0.personal_photo AS personal_photo_55, t0.subscription_id AS subscription_id_56, t0.company_id AS company_id_57, t0.staff_id AS staff_id_58, t0.team_id AS team_id_59, t0.developerField_id AS developerField_id_60, t0.phone_id AS phone_id_61 FROM users t0 WHERE t0.id = 16;
18	2.48 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.37 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	1.93 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	1.84 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	2.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: [`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.18 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	1.81 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	1.85 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	1.98 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	2.43 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.21 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.04 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	1.93 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	1.95 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	2.56 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	1.95 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	1.99 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.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: [`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	1.98 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.24 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	1.98 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.29 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.43 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	2.39 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 <= 1 AND l0_._right >= 1872 AND l0_.root = ? ORDER BY l0_._left ASC Parameters: [`1296`] 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 <= 1 AND l0_._right >= 1872 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 <= 1 AND l0_._right >= 1872 AND l0_.root = 1296 ORDER BY l0_._left ASC;
42	2.75 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.30 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 1296 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 (1296) 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.30 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.02 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 1296 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 (1296) 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.17 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	941
Aqarmap\Bundle\ListingBundle\Entity\ListingSearchScoreSetting	75
Aqarmap\Bundle\ListingBundle\Entity\PropertyType	14
Aqarmap\Bundle\NeighborhoodBundle\Entity\LocationCompound	12
Aqarmap\Bundle\ListingBundle\Entity\Listing	9
Aqarmap\Bundle\UserBundle\Entity\User	7
Aqarmap\Bundle\CRMBundle\Entity\Company	4
Aqarmap\Bundle\ListingBundle\Entity\LocationRating	3
Aqarmap\Bundle\ListingBundle\Entity\CompoundLocation	3
Aqarmap\Bundle\ListingBundle\Entity\Photo	3
Aqarmap\Bundle\ListingBundle\Entity\Section	2
Aqarmap\Bundle\ListingBundle\Entity\ListingPhoto	2
Aqarmap\Bundle\DiscussionBundle\Entity\Discussion	1
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\Comment	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\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=1296&tab=3

Configuration Settings

Theme

Page Width

Query Metrics

Queries

Database Connections

Entity Managers

Second Level Cache

Managed Entities

default entity manager

Entities Mapping