1
2.45 ms
SELECT COUNT (l0_ . id ) AS sclr_0 FROM leads l0_ WHERE l0_ . user_ip = ? AND l0_ . created_at > = ?
Parameters :
[
"192.168.5.202 "
"2024-09-29 01:16:10 "
]
SELECT COUNT (l0_ . id ) AS sclr_0 FROM leads l0_ WHERE l0_ . user_ip = '192.168.5.202' AND l0_ . created_at > = '2024-09-29 01:16:10' ;
Copy
2
2.86 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . id = ?
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . id = ?
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . id = '131' ;
Copy
3
2.05 ms
SELECT i0_ . id AS id_0 , i0_ . type AS type_1 , i0_ . user_ip AS user_ip_2 , i0_ . created_at AS created_at_3 , i0_ . source AS source_4 , i0_ . campaign AS campaign_5 , i0_ . user_id AS user_id_6 , i0_ . listing_id AS listing_id_7 FROM interactions i0_ WHERE i0_ . listing_id = ? AND i0_ . type = ? AND i0_ . user_ip = ? AND i0_ . created_at > = ? ORDER BY i0_ . id DESC LIMIT 1
Parameters :
[
131
4
"192.168.5.202 "
"2024-09-27 01:31:10 "
]
SELECT i0_ . id AS id_0 , i0_ . type AS type_1 , i0_ . user_ip AS user_ip_2 , i0_ . created_at AS created_at_3 , i0_ . source AS source_4 , i0_ . campaign AS campaign_5 , i0_ . user_id AS user_id_6 , i0_ . listing_id AS listing_id_7 FROM interactions i0_ WHERE i0_ . listing_id = 131 AND i0_ . type = 4 AND i0_ . user_ip = '192.168.5.202' AND i0_ . created_at > = '2024-09-27 01:31:10' ORDER BY i0_ . id DESC LIMIT 1 ;
Copy
4
1.21 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
5
1.76 ms
INSERT INTO interactions (TYPE , user_ip , created_at , source , campaign , user_id , listing_id ) VALUES (? , ? , ? , ? , ? , ? , ? )
Parameters :
[
1 => 4
2 => "192.168.5.202 "
3 => "2024-09-29 01:31:10 "
4 => "interaction-service "
5 => null
6 => null
7 => 131
]
INSERT INTO interactions (TYPE , user_ip , created_at , source , campaign , user_id , listing_id ) VALUES (4 , '192.168.5.202' , '2024-09-29 01:31:10' , 'interaction-service' , NULL , NULL , 131 );
Copy
6
4.45 ms
"COMMIT"
7
1.12 ms
"START TRANSACTION"
"START TRANSACTION" ;
Copy
8
1.97 ms
UPDATE listings SET views = ? WHERE id = ?
UPDATE listings SET views = 16 WHERE id = 131 ;
Copy
9
4.80 ms
"COMMIT"
10
1.62 ms
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . listing_id AS listing_id_3 , t0 . custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0 . listing_id = ?
SELECT t0 . id AS id_1 , t0 . value AS value_2 , t0 . listing_id AS listing_id_3 , t0 . custome_field_id AS custome_field_id_4 FROM listings_attributes t0 WHERE t0 . listing_id = 131 ;
Copy
11
3.05 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE (((t0 . type = ? AND t0 . expires_at > = ? ) OR t0 . expires_at IS NULL ) AND t0 . listing_id = ? ) ORDER BY t0 . id DESC
Parameters :
[
3
"2024-09-29 01:31:10 "
131
]
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . created_at AS created_at_3 ,
t0 . expires_at AS expires_at_4 ,
t0 . approved_at AS approved_at_5 ,
t0 . bump_up_duration AS bump_up_duration_6 ,
t0 . bump_up_occurrences AS bump_up_occurrences_7 ,
t0 . bumps_count AS bumps_count_8 ,
t0 . last_bumped_at AS last_bumped_at_9 ,
t0 . paused_at AS paused_at_10 ,
t0 . processed AS processed_11 ,
t0 . leads_count_snapshot AS leads_count_snapshot_12 ,
t0 . next_bump_date AS next_bump_date_13 ,
t0 . featuring_status AS featuring_status_14 ,
t0 . listing_id AS listing_id_15 ,
t16 . id AS id_17 ,
t16 . title AS title_18 ,
t16 . description AS description_19 ,
t16 . category AS category_20 ,
t16 . pending_photos_status AS pending_photos_status_21 ,
t16 . pending_payment_status AS pending_payment_status_22 ,
t16 . relist_status AS relist_status_23 ,
t16 . seller_role AS seller_role_24 ,
t16 . area AS area_25 ,
t16 . price AS price_26 ,
t16 . address AS address_27 ,
t16 . center_lat AS center_lat_28 ,
t16 . center_lng AS center_lng_29 ,
t16 . status AS status_30 ,
t16 . property_view AS property_view_31 ,
t16 . payment_method AS payment_method_32 ,
t16 . featured AS featured_33 ,
t16 . views AS views_34 ,
t16 . phone_counter AS phone_counter_35 ,
t16 . messages_counter AS messages_counter_36 ,
t16 . leads_counter AS leads_counter_37 ,
t16 . sent_notifiers AS sent_notifiers_38 ,
t16 . relist_counter AS relist_counter_39 ,
t16 . ip AS ip_40 ,
t16 . video_url AS video_url_41 ,
t16 . slug AS slug_42 ,
t16 . custom_slug AS custom_slug_43 ,
t16 . score AS score_44 ,
t16 . created_at AS created_at_45 ,
t16 . updated_at AS updated_at_46 ,
t16 . pending_status_created_at AS pending_status_created_at_47 ,
t16 . published_at AS published_at_48 ,
t16 . expires_at AS expires_at_49 ,
t16 . deleted_at AS deleted_at_50 ,
t16 . rejected_at AS rejected_at_51 ,
t16 . campaign AS campaign_52 ,
t16 . final_price AS final_price_53 ,
t16 . source_of_sale AS source_of_sale_54 ,
t16 . delete_reason AS delete_reason_55 ,
t16 . delete_reason_details AS delete_reason_details_56 ,
t16 . source AS source_57 ,
t16 . impressions AS impressions_58 ,
t16 . impressions_monthly_count AS impressions_monthly_count_59 ,
t16 . impressions_weekly_count AS impressions_weekly_count_60 ,
t16 . impression_updated_at AS impression_updated_at_61 ,
t16 . price_level AS price_level_62 ,
t16 . compound_status AS compound_status_63 ,
t16 . price_per_meter AS price_per_meter_64 ,
t16 . is_bumped AS is_bumped_65 ,
t16 . is_send_email AS is_send_email_66 ,
t16 . market_property_type AS market_property_type_67 ,
t16 . creation_source AS creation_source_68 ,
t16 . click_through_rate AS click_through_rate_69 ,
t16 . label AS label_70 ,
t16 . is_top_picks AS is_top_picks_71 ,
t16 . contact_rate AS contact_rate_72 ,
t16 . synced AS synced_73 ,
t16 . reference_id AS reference_id_74 ,
t16 . is_pending_featuring AS is_pending_featuring_75 ,
t16 . pending_featuring_type AS pending_featuring_type_76 ,
t16 . rate_status AS rate_status_77 ,
t16 . is_rate_reviewed AS is_rate_reviewed_78 ,
t16 . is_call_request AS is_call_request_79 ,
t16 . is_shown_in_homepage AS is_shown_in_homepage_80 ,
t16 . is_commercial AS is_commercial_81 ,
t16 . is_resale AS is_resale_82 ,
t16 . is_rent AS is_rent_83 ,
t16 . is_primary AS is_primary_84 ,
t16 . is_mortgage_approved AS is_mortgage_approved_85 ,
t16 . meta_title AS meta_title_86 ,
t16 . meta_description AS meta_description_87 ,
t16 . is_mortgage AS is_mortgage_88 ,
t16 . eligible_for_mortgage AS eligible_for_mortgage_89 ,
t16 . property_registration_status AS property_registration_status_90 ,
t16 . advertiser_number AS advertiser_number_91 ,
t16 . authorization_number AS authorization_number_92 ,
t16 . freezed_at AS freezed_at_93 ,
t16 . eligible_for_bumpup AS eligible_for_bumpup_94 ,
t16 . waiting_time AS waiting_time_95 ,
t16 . reference_number AS reference_number_96 ,
t16 . parent_id AS parent_id_97 ,
t16 . relist_id AS relist_id_98 ,
t16 . section_id AS section_id_99 ,
t16 . property_type_id AS property_type_id_100 ,
t16 . location_id AS location_id_101 ,
t16 . compound_location_id AS compound_location_id_102 ,
t16 . user_id AS user_id_103 ,
t16 . compound_field_id AS compound_field_id_104 ,
t0 . credit_id AS credit_id_105 ,
t0 . bump_up_owner_id AS bump_up_owner_id_106
FROM
listings_features t0
INNER JOIN listings t16 ON t0 . listing_id = t16 . id
WHERE
(
(
(
t0 . type = ?
AND t0 . expires_at > = ?
)
OR t0 . expires_at IS NULL
)
AND t0 . listing_id = ?
)
ORDER BY
t0 . id DESC
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE (((t0 . type = 3 AND t0 . expires_at > = '2024-09-29 01:31:10' ) OR t0 . expires_at IS NULL ) AND t0 . listing_id = 131 ) ORDER BY t0 . id DESC ;
Copy
12
2.97 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE ((t0 . type ! = ? AND t0 . type ! = ? ) AND t0 . listing_id = ? ) ORDER BY t0 . id DESC LIMIT 1
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . created_at AS created_at_3 ,
t0 . expires_at AS expires_at_4 ,
t0 . approved_at AS approved_at_5 ,
t0 . bump_up_duration AS bump_up_duration_6 ,
t0 . bump_up_occurrences AS bump_up_occurrences_7 ,
t0 . bumps_count AS bumps_count_8 ,
t0 . last_bumped_at AS last_bumped_at_9 ,
t0 . paused_at AS paused_at_10 ,
t0 . processed AS processed_11 ,
t0 . leads_count_snapshot AS leads_count_snapshot_12 ,
t0 . next_bump_date AS next_bump_date_13 ,
t0 . featuring_status AS featuring_status_14 ,
t0 . listing_id AS listing_id_15 ,
t16 . id AS id_17 ,
t16 . title AS title_18 ,
t16 . description AS description_19 ,
t16 . category AS category_20 ,
t16 . pending_photos_status AS pending_photos_status_21 ,
t16 . pending_payment_status AS pending_payment_status_22 ,
t16 . relist_status AS relist_status_23 ,
t16 . seller_role AS seller_role_24 ,
t16 . area AS area_25 ,
t16 . price AS price_26 ,
t16 . address AS address_27 ,
t16 . center_lat AS center_lat_28 ,
t16 . center_lng AS center_lng_29 ,
t16 . status AS status_30 ,
t16 . property_view AS property_view_31 ,
t16 . payment_method AS payment_method_32 ,
t16 . featured AS featured_33 ,
t16 . views AS views_34 ,
t16 . phone_counter AS phone_counter_35 ,
t16 . messages_counter AS messages_counter_36 ,
t16 . leads_counter AS leads_counter_37 ,
t16 . sent_notifiers AS sent_notifiers_38 ,
t16 . relist_counter AS relist_counter_39 ,
t16 . ip AS ip_40 ,
t16 . video_url AS video_url_41 ,
t16 . slug AS slug_42 ,
t16 . custom_slug AS custom_slug_43 ,
t16 . score AS score_44 ,
t16 . created_at AS created_at_45 ,
t16 . updated_at AS updated_at_46 ,
t16 . pending_status_created_at AS pending_status_created_at_47 ,
t16 . published_at AS published_at_48 ,
t16 . expires_at AS expires_at_49 ,
t16 . deleted_at AS deleted_at_50 ,
t16 . rejected_at AS rejected_at_51 ,
t16 . campaign AS campaign_52 ,
t16 . final_price AS final_price_53 ,
t16 . source_of_sale AS source_of_sale_54 ,
t16 . delete_reason AS delete_reason_55 ,
t16 . delete_reason_details AS delete_reason_details_56 ,
t16 . source AS source_57 ,
t16 . impressions AS impressions_58 ,
t16 . impressions_monthly_count AS impressions_monthly_count_59 ,
t16 . impressions_weekly_count AS impressions_weekly_count_60 ,
t16 . impression_updated_at AS impression_updated_at_61 ,
t16 . price_level AS price_level_62 ,
t16 . compound_status AS compound_status_63 ,
t16 . price_per_meter AS price_per_meter_64 ,
t16 . is_bumped AS is_bumped_65 ,
t16 . is_send_email AS is_send_email_66 ,
t16 . market_property_type AS market_property_type_67 ,
t16 . creation_source AS creation_source_68 ,
t16 . click_through_rate AS click_through_rate_69 ,
t16 . label AS label_70 ,
t16 . is_top_picks AS is_top_picks_71 ,
t16 . contact_rate AS contact_rate_72 ,
t16 . synced AS synced_73 ,
t16 . reference_id AS reference_id_74 ,
t16 . is_pending_featuring AS is_pending_featuring_75 ,
t16 . pending_featuring_type AS pending_featuring_type_76 ,
t16 . rate_status AS rate_status_77 ,
t16 . is_rate_reviewed AS is_rate_reviewed_78 ,
t16 . is_call_request AS is_call_request_79 ,
t16 . is_shown_in_homepage AS is_shown_in_homepage_80 ,
t16 . is_commercial AS is_commercial_81 ,
t16 . is_resale AS is_resale_82 ,
t16 . is_rent AS is_rent_83 ,
t16 . is_primary AS is_primary_84 ,
t16 . is_mortgage_approved AS is_mortgage_approved_85 ,
t16 . meta_title AS meta_title_86 ,
t16 . meta_description AS meta_description_87 ,
t16 . is_mortgage AS is_mortgage_88 ,
t16 . eligible_for_mortgage AS eligible_for_mortgage_89 ,
t16 . property_registration_status AS property_registration_status_90 ,
t16 . advertiser_number AS advertiser_number_91 ,
t16 . authorization_number AS authorization_number_92 ,
t16 . freezed_at AS freezed_at_93 ,
t16 . eligible_for_bumpup AS eligible_for_bumpup_94 ,
t16 . waiting_time AS waiting_time_95 ,
t16 . reference_number AS reference_number_96 ,
t16 . parent_id AS parent_id_97 ,
t16 . relist_id AS relist_id_98 ,
t16 . section_id AS section_id_99 ,
t16 . property_type_id AS property_type_id_100 ,
t16 . location_id AS location_id_101 ,
t16 . compound_location_id AS compound_location_id_102 ,
t16 . user_id AS user_id_103 ,
t16 . compound_field_id AS compound_field_id_104 ,
t0 . credit_id AS credit_id_105 ,
t0 . bump_up_owner_id AS bump_up_owner_id_106
FROM
listings_features t0
INNER JOIN listings t16 ON t0 . listing_id = t16 . id
WHERE
(
(
t0 . type ! = ?
AND t0 . type ! = ?
)
AND t0 . listing_id = ?
)
ORDER BY
t0 . id DESC
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE ((t0 . type ! = 1 AND t0 . type ! = 3 ) AND t0 . listing_id = 131 ) ORDER BY t0 . id DESC LIMIT 1 ;
Copy
13
3.10 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE (((t0 . type = ? AND t0 . expires_at > = ? ) OR t0 . expires_at IS NULL ) AND t0 . listing_id = ? ) ORDER BY t0 . id DESC
Parameters :
[
3
"2024-09-29 01:31:10 "
131
]
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . created_at AS created_at_3 ,
t0 . expires_at AS expires_at_4 ,
t0 . approved_at AS approved_at_5 ,
t0 . bump_up_duration AS bump_up_duration_6 ,
t0 . bump_up_occurrences AS bump_up_occurrences_7 ,
t0 . bumps_count AS bumps_count_8 ,
t0 . last_bumped_at AS last_bumped_at_9 ,
t0 . paused_at AS paused_at_10 ,
t0 . processed AS processed_11 ,
t0 . leads_count_snapshot AS leads_count_snapshot_12 ,
t0 . next_bump_date AS next_bump_date_13 ,
t0 . featuring_status AS featuring_status_14 ,
t0 . listing_id AS listing_id_15 ,
t16 . id AS id_17 ,
t16 . title AS title_18 ,
t16 . description AS description_19 ,
t16 . category AS category_20 ,
t16 . pending_photos_status AS pending_photos_status_21 ,
t16 . pending_payment_status AS pending_payment_status_22 ,
t16 . relist_status AS relist_status_23 ,
t16 . seller_role AS seller_role_24 ,
t16 . area AS area_25 ,
t16 . price AS price_26 ,
t16 . address AS address_27 ,
t16 . center_lat AS center_lat_28 ,
t16 . center_lng AS center_lng_29 ,
t16 . status AS status_30 ,
t16 . property_view AS property_view_31 ,
t16 . payment_method AS payment_method_32 ,
t16 . featured AS featured_33 ,
t16 . views AS views_34 ,
t16 . phone_counter AS phone_counter_35 ,
t16 . messages_counter AS messages_counter_36 ,
t16 . leads_counter AS leads_counter_37 ,
t16 . sent_notifiers AS sent_notifiers_38 ,
t16 . relist_counter AS relist_counter_39 ,
t16 . ip AS ip_40 ,
t16 . video_url AS video_url_41 ,
t16 . slug AS slug_42 ,
t16 . custom_slug AS custom_slug_43 ,
t16 . score AS score_44 ,
t16 . created_at AS created_at_45 ,
t16 . updated_at AS updated_at_46 ,
t16 . pending_status_created_at AS pending_status_created_at_47 ,
t16 . published_at AS published_at_48 ,
t16 . expires_at AS expires_at_49 ,
t16 . deleted_at AS deleted_at_50 ,
t16 . rejected_at AS rejected_at_51 ,
t16 . campaign AS campaign_52 ,
t16 . final_price AS final_price_53 ,
t16 . source_of_sale AS source_of_sale_54 ,
t16 . delete_reason AS delete_reason_55 ,
t16 . delete_reason_details AS delete_reason_details_56 ,
t16 . source AS source_57 ,
t16 . impressions AS impressions_58 ,
t16 . impressions_monthly_count AS impressions_monthly_count_59 ,
t16 . impressions_weekly_count AS impressions_weekly_count_60 ,
t16 . impression_updated_at AS impression_updated_at_61 ,
t16 . price_level AS price_level_62 ,
t16 . compound_status AS compound_status_63 ,
t16 . price_per_meter AS price_per_meter_64 ,
t16 . is_bumped AS is_bumped_65 ,
t16 . is_send_email AS is_send_email_66 ,
t16 . market_property_type AS market_property_type_67 ,
t16 . creation_source AS creation_source_68 ,
t16 . click_through_rate AS click_through_rate_69 ,
t16 . label AS label_70 ,
t16 . is_top_picks AS is_top_picks_71 ,
t16 . contact_rate AS contact_rate_72 ,
t16 . synced AS synced_73 ,
t16 . reference_id AS reference_id_74 ,
t16 . is_pending_featuring AS is_pending_featuring_75 ,
t16 . pending_featuring_type AS pending_featuring_type_76 ,
t16 . rate_status AS rate_status_77 ,
t16 . is_rate_reviewed AS is_rate_reviewed_78 ,
t16 . is_call_request AS is_call_request_79 ,
t16 . is_shown_in_homepage AS is_shown_in_homepage_80 ,
t16 . is_commercial AS is_commercial_81 ,
t16 . is_resale AS is_resale_82 ,
t16 . is_rent AS is_rent_83 ,
t16 . is_primary AS is_primary_84 ,
t16 . is_mortgage_approved AS is_mortgage_approved_85 ,
t16 . meta_title AS meta_title_86 ,
t16 . meta_description AS meta_description_87 ,
t16 . is_mortgage AS is_mortgage_88 ,
t16 . eligible_for_mortgage AS eligible_for_mortgage_89 ,
t16 . property_registration_status AS property_registration_status_90 ,
t16 . advertiser_number AS advertiser_number_91 ,
t16 . authorization_number AS authorization_number_92 ,
t16 . freezed_at AS freezed_at_93 ,
t16 . eligible_for_bumpup AS eligible_for_bumpup_94 ,
t16 . waiting_time AS waiting_time_95 ,
t16 . reference_number AS reference_number_96 ,
t16 . parent_id AS parent_id_97 ,
t16 . relist_id AS relist_id_98 ,
t16 . section_id AS section_id_99 ,
t16 . property_type_id AS property_type_id_100 ,
t16 . location_id AS location_id_101 ,
t16 . compound_location_id AS compound_location_id_102 ,
t16 . user_id AS user_id_103 ,
t16 . compound_field_id AS compound_field_id_104 ,
t0 . credit_id AS credit_id_105 ,
t0 . bump_up_owner_id AS bump_up_owner_id_106
FROM
listings_features t0
INNER JOIN listings t16 ON t0 . listing_id = t16 . id
WHERE
(
(
(
t0 . type = ?
AND t0 . expires_at > = ?
)
OR t0 . expires_at IS NULL
)
AND t0 . listing_id = ?
)
ORDER BY
t0 . id DESC
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE (((t0 . type = 3 AND t0 . expires_at > = '2024-09-29 01:31:10' ) OR t0 . expires_at IS NULL ) AND t0 . listing_id = 131 ) ORDER BY t0 . id DESC ;
Copy
14
3.01 ms
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE ((t0 . type ! = ? AND t0 . type ! = ? ) AND t0 . listing_id = ? ) ORDER BY t0 . id DESC LIMIT 1
SELECT
t0 . id AS id_1 ,
t0 . type AS type_2 ,
t0 . created_at AS created_at_3 ,
t0 . expires_at AS expires_at_4 ,
t0 . approved_at AS approved_at_5 ,
t0 . bump_up_duration AS bump_up_duration_6 ,
t0 . bump_up_occurrences AS bump_up_occurrences_7 ,
t0 . bumps_count AS bumps_count_8 ,
t0 . last_bumped_at AS last_bumped_at_9 ,
t0 . paused_at AS paused_at_10 ,
t0 . processed AS processed_11 ,
t0 . leads_count_snapshot AS leads_count_snapshot_12 ,
t0 . next_bump_date AS next_bump_date_13 ,
t0 . featuring_status AS featuring_status_14 ,
t0 . listing_id AS listing_id_15 ,
t16 . id AS id_17 ,
t16 . title AS title_18 ,
t16 . description AS description_19 ,
t16 . category AS category_20 ,
t16 . pending_photos_status AS pending_photos_status_21 ,
t16 . pending_payment_status AS pending_payment_status_22 ,
t16 . relist_status AS relist_status_23 ,
t16 . seller_role AS seller_role_24 ,
t16 . area AS area_25 ,
t16 . price AS price_26 ,
t16 . address AS address_27 ,
t16 . center_lat AS center_lat_28 ,
t16 . center_lng AS center_lng_29 ,
t16 . status AS status_30 ,
t16 . property_view AS property_view_31 ,
t16 . payment_method AS payment_method_32 ,
t16 . featured AS featured_33 ,
t16 . views AS views_34 ,
t16 . phone_counter AS phone_counter_35 ,
t16 . messages_counter AS messages_counter_36 ,
t16 . leads_counter AS leads_counter_37 ,
t16 . sent_notifiers AS sent_notifiers_38 ,
t16 . relist_counter AS relist_counter_39 ,
t16 . ip AS ip_40 ,
t16 . video_url AS video_url_41 ,
t16 . slug AS slug_42 ,
t16 . custom_slug AS custom_slug_43 ,
t16 . score AS score_44 ,
t16 . created_at AS created_at_45 ,
t16 . updated_at AS updated_at_46 ,
t16 . pending_status_created_at AS pending_status_created_at_47 ,
t16 . published_at AS published_at_48 ,
t16 . expires_at AS expires_at_49 ,
t16 . deleted_at AS deleted_at_50 ,
t16 . rejected_at AS rejected_at_51 ,
t16 . campaign AS campaign_52 ,
t16 . final_price AS final_price_53 ,
t16 . source_of_sale AS source_of_sale_54 ,
t16 . delete_reason AS delete_reason_55 ,
t16 . delete_reason_details AS delete_reason_details_56 ,
t16 . source AS source_57 ,
t16 . impressions AS impressions_58 ,
t16 . impressions_monthly_count AS impressions_monthly_count_59 ,
t16 . impressions_weekly_count AS impressions_weekly_count_60 ,
t16 . impression_updated_at AS impression_updated_at_61 ,
t16 . price_level AS price_level_62 ,
t16 . compound_status AS compound_status_63 ,
t16 . price_per_meter AS price_per_meter_64 ,
t16 . is_bumped AS is_bumped_65 ,
t16 . is_send_email AS is_send_email_66 ,
t16 . market_property_type AS market_property_type_67 ,
t16 . creation_source AS creation_source_68 ,
t16 . click_through_rate AS click_through_rate_69 ,
t16 . label AS label_70 ,
t16 . is_top_picks AS is_top_picks_71 ,
t16 . contact_rate AS contact_rate_72 ,
t16 . synced AS synced_73 ,
t16 . reference_id AS reference_id_74 ,
t16 . is_pending_featuring AS is_pending_featuring_75 ,
t16 . pending_featuring_type AS pending_featuring_type_76 ,
t16 . rate_status AS rate_status_77 ,
t16 . is_rate_reviewed AS is_rate_reviewed_78 ,
t16 . is_call_request AS is_call_request_79 ,
t16 . is_shown_in_homepage AS is_shown_in_homepage_80 ,
t16 . is_commercial AS is_commercial_81 ,
t16 . is_resale AS is_resale_82 ,
t16 . is_rent AS is_rent_83 ,
t16 . is_primary AS is_primary_84 ,
t16 . is_mortgage_approved AS is_mortgage_approved_85 ,
t16 . meta_title AS meta_title_86 ,
t16 . meta_description AS meta_description_87 ,
t16 . is_mortgage AS is_mortgage_88 ,
t16 . eligible_for_mortgage AS eligible_for_mortgage_89 ,
t16 . property_registration_status AS property_registration_status_90 ,
t16 . advertiser_number AS advertiser_number_91 ,
t16 . authorization_number AS authorization_number_92 ,
t16 . freezed_at AS freezed_at_93 ,
t16 . eligible_for_bumpup AS eligible_for_bumpup_94 ,
t16 . waiting_time AS waiting_time_95 ,
t16 . reference_number AS reference_number_96 ,
t16 . parent_id AS parent_id_97 ,
t16 . relist_id AS relist_id_98 ,
t16 . section_id AS section_id_99 ,
t16 . property_type_id AS property_type_id_100 ,
t16 . location_id AS location_id_101 ,
t16 . compound_location_id AS compound_location_id_102 ,
t16 . user_id AS user_id_103 ,
t16 . compound_field_id AS compound_field_id_104 ,
t0 . credit_id AS credit_id_105 ,
t0 . bump_up_owner_id AS bump_up_owner_id_106
FROM
listings_features t0
INNER JOIN listings t16 ON t0 . listing_id = t16 . id
WHERE
(
(
t0 . type ! = ?
AND t0 . type ! = ?
)
AND t0 . listing_id = ?
)
ORDER BY
t0 . id DESC
LIMIT
1
Copy
SELECT t0 . id AS id_1 , t0 . type AS type_2 , t0 . created_at AS created_at_3 , t0 . expires_at AS expires_at_4 , t0 . approved_at AS approved_at_5 , t0 . bump_up_duration AS bump_up_duration_6 , t0 . bump_up_occurrences AS bump_up_occurrences_7 , t0 . bumps_count AS bumps_count_8 , t0 . last_bumped_at AS last_bumped_at_9 , t0 . paused_at AS paused_at_10 , t0 . processed AS processed_11 , t0 . leads_count_snapshot AS leads_count_snapshot_12 , t0 . next_bump_date AS next_bump_date_13 , t0 . featuring_status AS featuring_status_14 , t0 . listing_id AS listing_id_15 , t16 . id AS id_17 , t16 . title AS title_18 , t16 . description AS description_19 , t16 . category AS category_20 , t16 . pending_photos_status AS pending_photos_status_21 , t16 . pending_payment_status AS pending_payment_status_22 , t16 . relist_status AS relist_status_23 , t16 . seller_role AS seller_role_24 , t16 . area AS area_25 , t16 . price AS price_26 , t16 . address AS address_27 , t16 . center_lat AS center_lat_28 , t16 . center_lng AS center_lng_29 , t16 . status AS status_30 , t16 . property_view AS property_view_31 , t16 . payment_method AS payment_method_32 , t16 . featured AS featured_33 , t16 . views AS views_34 , t16 . phone_counter AS phone_counter_35 , t16 . messages_counter AS messages_counter_36 , t16 . leads_counter AS leads_counter_37 , t16 . sent_notifiers AS sent_notifiers_38 , t16 . relist_counter AS relist_counter_39 , t16 . ip AS ip_40 , t16 . video_url AS video_url_41 , t16 . slug AS slug_42 , t16 . custom_slug AS custom_slug_43 , t16 . score AS score_44 , t16 . created_at AS created_at_45 , t16 . updated_at AS updated_at_46 , t16 . pending_status_created_at AS pending_status_created_at_47 , t16 . published_at AS published_at_48 , t16 . expires_at AS expires_at_49 , t16 . deleted_at AS deleted_at_50 , t16 . rejected_at AS rejected_at_51 , t16 . campaign AS campaign_52 , t16 . final_price AS final_price_53 , t16 . source_of_sale AS source_of_sale_54 , t16 . delete_reason AS delete_reason_55 , t16 . delete_reason_details AS delete_reason_details_56 , t16 . source AS source_57 , t16 . impressions AS impressions_58 , t16 . impressions_monthly_count AS impressions_monthly_count_59 , t16 . impressions_weekly_count AS impressions_weekly_count_60 , t16 . impression_updated_at AS impression_updated_at_61 , t16 . price_level AS price_level_62 , t16 . compound_status AS compound_status_63 , t16 . price_per_meter AS price_per_meter_64 , t16 . is_bumped AS is_bumped_65 , t16 . is_send_email AS is_send_email_66 , t16 . market_property_type AS market_property_type_67 , t16 . creation_source AS creation_source_68 , t16 . click_through_rate AS click_through_rate_69 , t16 . label AS label_70 , t16 . is_top_picks AS is_top_picks_71 , t16 . contact_rate AS contact_rate_72 , t16 . synced AS synced_73 , t16 . reference_id AS reference_id_74 , t16 . is_pending_featuring AS is_pending_featuring_75 , t16 . pending_featuring_type AS pending_featuring_type_76 , t16 . rate_status AS rate_status_77 , t16 . is_rate_reviewed AS is_rate_reviewed_78 , t16 . is_call_request AS is_call_request_79 , t16 . is_shown_in_homepage AS is_shown_in_homepage_80 , t16 . is_commercial AS is_commercial_81 , t16 . is_resale AS is_resale_82 , t16 . is_rent AS is_rent_83 , t16 . is_primary AS is_primary_84 , t16 . is_mortgage_approved AS is_mortgage_approved_85 , t16 . meta_title AS meta_title_86 , t16 . meta_description AS meta_description_87 , t16 . is_mortgage AS is_mortgage_88 , t16 . eligible_for_mortgage AS eligible_for_mortgage_89 , t16 . property_registration_status AS property_registration_status_90 , t16 . advertiser_number AS advertiser_number_91 , t16 . authorization_number AS authorization_number_92 , t16 . freezed_at AS freezed_at_93 , t16 . eligible_for_bumpup AS eligible_for_bumpup_94 , t16 . waiting_time AS waiting_time_95 , t16 . reference_number AS reference_number_96 , t16 . parent_id AS parent_id_97 , t16 . relist_id AS relist_id_98 , t16 . section_id AS section_id_99 , t16 . property_type_id AS property_type_id_100 , t16 . location_id AS location_id_101 , t16 . compound_location_id AS compound_location_id_102 , t16 . user_id AS user_id_103 , t16 . compound_field_id AS compound_field_id_104 , t0 . credit_id AS credit_id_105 , t0 . bump_up_owner_id AS bump_up_owner_id_106 FROM listings_features t0 INNER JOIN listings t16 ON t0 . listing_id = t16 . id WHERE ((t0 . type ! = 1 AND t0 . type ! = 3 ) AND t0 . listing_id = 131 ) ORDER BY t0 . id DESC LIMIT 1 ;
Copy
15
1.34 ms
SELECT t0 . id AS id_1 , t0 . locale AS locale_2 , t0 . field AS field_3 , t0 . content AS content_4 , t0 . listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0 . listing_id = ?
SELECT t0 . id AS id_1 , t0 . locale AS locale_2 , t0 . field AS field_3 , t0 . content AS content_4 , t0 . listing_id AS listing_id_5 FROM listings_translations t0 WHERE t0 . listing_id = 131 ;
Copy
16
1.36 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . main AS main_6 , t0 . searchable AS searchable_7 , t0 . slug AS slug_8 , t0 . synced AS synced_9 , t0 . reference_id AS reference_id_10 , t0 . meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . meta_title AS meta_title_4 , t0 . meta_description AS meta_description_5 , t0 . main AS main_6 , t0 . searchable AS searchable_7 , t0 . slug AS slug_8 , t0 . synced AS synced_9 , t0 . reference_id AS reference_id_10 , t0 . meta_search_description AS meta_search_description_11 FROM sections t0 WHERE t0 . id = 3 ;
Copy
17
1.82 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . alias AS alias_3 , t0 . description AS description_4 , t0 . slug AS slug_5 , t0 . lat AS lat_6 , t0 . lon AS lon_7 , t0 . zoom AS zoom_8 , t0 . coordinates AS coordinates_9 , t0 . searchable AS searchable_10 , t0 . home_filter AS home_filter_11 , t0 . statistics_filter AS statistics_filter_12 , t0 . neighborhood_filter AS neighborhood_filter_13 , t0 . compound_filter AS compound_filter_14 , t0 . estimate AS estimate_15 , t0 . disabled AS disabled_16 , t0 . synced AS synced_17 , t0 . level AS level_18 , t0 . _left AS _left_19 , t0 . _right AS _right_20 , t0 . root AS root_21 , t0 . leads_counter AS leads_counter_22 , t0 . listings_counter AS listings_counter_23 , t0 . keyword AS keyword_24 , t0 . full_path AS full_path_25 , t0 . reference_id AS reference_id_26 , t0 . eligible_for_mortgage AS eligible_for_mortgage_27 , t0 . is_compound_location AS is_compound_location_28 , t0 . parent_id AS parent_id_29 , t0 . location_compound_id AS location_compound_id_30 , t0 . rating_id AS rating_id_31 , t0 . listing_id AS listing_id_32 FROM locations t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . alias AS alias_3 , t0 . description AS description_4 , t0 . slug AS slug_5 , t0 . lat AS lat_6 , t0 . lon AS lon_7 , t0 . zoom AS zoom_8 , t0 . coordinates AS coordinates_9 , t0 . searchable AS searchable_10 , t0 . home_filter AS home_filter_11 , t0 . statistics_filter AS statistics_filter_12 , t0 . neighborhood_filter AS neighborhood_filter_13 , t0 . compound_filter AS compound_filter_14 , t0 . estimate AS estimate_15 , t0 . disabled AS disabled_16 , t0 . synced AS synced_17 , t0 . level AS level_18 , t0 . _left AS _left_19 , t0 . _right AS _right_20 , t0 . root AS root_21 , t0 . leads_counter AS leads_counter_22 , t0 . listings_counter AS listings_counter_23 , t0 . keyword AS keyword_24 , t0 . full_path AS full_path_25 , t0 . reference_id AS reference_id_26 , t0 . eligible_for_mortgage AS eligible_for_mortgage_27 , t0 . is_compound_location AS is_compound_location_28 , t0 . parent_id AS parent_id_29 , t0 . location_compound_id AS location_compound_id_30 , t0 . rating_id AS rating_id_31 , t0 . listing_id AS listing_id_32 FROM locations t0 WHERE t0 . id = 45 ;
Copy
18
1.65 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . alias AS alias_3 , t0 . description AS description_4 , t0 . slug AS slug_5 , t0 . lat AS lat_6 , t0 . lon AS lon_7 , t0 . zoom AS zoom_8 , t0 . coordinates AS coordinates_9 , t0 . searchable AS searchable_10 , t0 . home_filter AS home_filter_11 , t0 . statistics_filter AS statistics_filter_12 , t0 . neighborhood_filter AS neighborhood_filter_13 , t0 . compound_filter AS compound_filter_14 , t0 . estimate AS estimate_15 , t0 . disabled AS disabled_16 , t0 . synced AS synced_17 , t0 . level AS level_18 , t0 . _left AS _left_19 , t0 . _right AS _right_20 , t0 . root AS root_21 , t0 . leads_counter AS leads_counter_22 , t0 . listings_counter AS listings_counter_23 , t0 . keyword AS keyword_24 , t0 . full_path AS full_path_25 , t0 . reference_id AS reference_id_26 , t0 . eligible_for_mortgage AS eligible_for_mortgage_27 , t0 . is_compound_location AS is_compound_location_28 , t0 . parent_id AS parent_id_29 , t0 . location_compound_id AS location_compound_id_30 , t0 . rating_id AS rating_id_31 , t0 . listing_id AS listing_id_32 FROM locations t0 INNER JOIN listings_locations ON t0 . id = listings_locations . location_id WHERE listings_locations . listing_id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . alias AS alias_3 , t0 . description AS description_4 , t0 . slug AS slug_5 , t0 . lat AS lat_6 , t0 . lon AS lon_7 , t0 . zoom AS zoom_8 , t0 . coordinates AS coordinates_9 , t0 . searchable AS searchable_10 , t0 . home_filter AS home_filter_11 , t0 . statistics_filter AS statistics_filter_12 , t0 . neighborhood_filter AS neighborhood_filter_13 , t0 . compound_filter AS compound_filter_14 , t0 . estimate AS estimate_15 , t0 . disabled AS disabled_16 , t0 . synced AS synced_17 , t0 . level AS level_18 , t0 . _left AS _left_19 , t0 . _right AS _right_20 , t0 . root AS root_21 , t0 . leads_counter AS leads_counter_22 , t0 . listings_counter AS listings_counter_23 , t0 . keyword AS keyword_24 , t0 . full_path AS full_path_25 , t0 . reference_id AS reference_id_26 , t0 . eligible_for_mortgage AS eligible_for_mortgage_27 , t0 . is_compound_location AS is_compound_location_28 , t0 . parent_id AS parent_id_29 , t0 . location_compound_id AS location_compound_id_30 , t0 . rating_id AS rating_id_31 , t0 . listing_id AS listing_id_32 FROM locations t0 INNER JOIN listings_locations ON t0 . id = listings_locations . location_id WHERE listings_locations . listing_id = 131 ;
Copy
19
1.33 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . private AS private_4 , t0 . level AS level_5 , t0 . _left AS _left_6 , t0 . _right AS _right_7 , t0 . root AS root_8 , t0 . compound_related AS compound_related_9 , t0 . reference_id AS reference_id_10 , t0 . exchangeable AS exchangeable_11 , t0 . is_evaluable AS is_evaluable_12 , t0 . synced AS synced_13 , t0 . searchable AS searchable_14 , t0 . deleted_at AS deleted_at_15 , t0 . custom_order AS custom_order_16 , t0 . parent_id AS parent_id_17 FROM property_types t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . slug AS slug_3 , t0 . private AS private_4 , t0 . level AS level_5 , t0 . _left AS _left_6 , t0 . _right AS _right_7 , t0 . root AS root_8 , t0 . compound_related AS compound_related_9 , t0 . reference_id AS reference_id_10 , t0 . exchangeable AS exchangeable_11 , t0 . is_evaluable AS is_evaluable_12 , t0 . synced AS synced_13 , t0 . searchable AS searchable_14 , t0 . deleted_at AS deleted_at_15 , t0 . custom_order AS custom_order_16 , t0 . parent_id AS parent_id_17 FROM property_types t0 WHERE t0 . id = 3 ;
Copy
20
1.43 ms
SELECT t0 . id AS id_1 , t0 . caption AS caption_2 , t0 . type AS type_3 , t0 . position AS position_4 , t0 . listing_id AS listing_id_5 , t0 . photo_id AS photo_id_6 FROM listings_photos t0 WHERE t0 . listing_id = ? ORDER BY t0 . position ASC
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 = 131 ORDER BY t0 . position ASC ;
Copy
21
1.29 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 = ?
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 = 131 ;
Copy
22
1.97 ms
SELECT t0 . username AS username_1 , t0 . username_canonical AS username_canonical_2 , t0 . email AS email_3 , t0 . email_canonical AS email_canonical_4 , t0 . enabled AS enabled_5 , t0 . salt AS salt_6 , t0 . password AS password_7 , t0 . last_login AS last_login_8 , t0 . confirmation_token AS confirmation_token_9 , t0 . password_requested_at AS password_requested_at_10 , t0 . roles AS roles_11 , t0 . id AS id_12 , t0 . full_name AS full_name_13 , t0 . bio AS bio_14 , t0 . phone_number AS phone_number_15 , t0 . is_valid_logo AS is_valid_logo_16 , t0 . is_valid_personal_photo AS is_valid_personal_photo_17 , t0 . is_migrated_phone AS is_migrated_phone_18 , t0 . is_valid_email AS is_valid_email_19 , t0 . user_type AS user_type_20 , t0 . language AS language_21 , t0 . legacy AS legacy_22 , t0 . facebook_id AS facebook_id_23 , t0 . google_id AS google_id_24 , t0 . registration_ip AS registration_ip_25 , t0 . created_at AS created_at_26 , t0 . last_update AS last_update_27 , t0 . global_unsubscribe AS global_unsubscribe_28 , t0 . customer_profiling_queue_date AS customer_profiling_queue_date_29 , t0 . is_quick_registered AS is_quick_registered_30 , t0 . is_imported AS is_imported_31 , t0 . subscription_expiry_date AS subscription_expiry_date_32 , t0 . credit_expiry_date AS credit_expiry_date_33 , t0 . soft_churn_date AS soft_churn_date_34 , t0 . reach_count AS reach_count_35 , t0 . synced AS synced_36 , t0 . reference_id AS reference_id_37 , t0 . has_email AS has_email_38 , t0 . client_served_count AS client_served_count_39 , t0 . enabled_marketing AS enabled_marketing_40 , t0 . zoho_synced AS zoho_synced_41 , t0 . recent_search_last_checked AS recent_search_last_checked_42 , t0 . recent_search_last_send AS recent_search_last_send_43 , t0 . auth_identifier AS auth_identifier_44 , t0 . auth_access_token AS auth_access_token_45 , t0 . auth_refresh_token AS auth_refresh_token_46 , t0 . auth_updated_at AS auth_updated_at_47 , t0 . parent_id AS parent_id_48 , t0 . logo AS logo_49 , t0 . personal_photo AS personal_photo_50 , t0 . company_id AS company_id_51 , t0 . staff_id AS staff_id_52 , t0 . team_id AS team_id_53 , t0 . developerField_id AS developerField_id_54 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 . is_imported AS is_imported_31 ,
t0 . subscription_expiry_date AS subscription_expiry_date_32 ,
t0 . credit_expiry_date AS credit_expiry_date_33 ,
t0 . soft_churn_date AS soft_churn_date_34 ,
t0 . reach_count AS reach_count_35 ,
t0 . synced AS synced_36 ,
t0 . reference_id AS reference_id_37 ,
t0 . has_email AS has_email_38 ,
t0 . client_served_count AS client_served_count_39 ,
t0 . enabled_marketing AS enabled_marketing_40 ,
t0 . zoho_synced AS zoho_synced_41 ,
t0 . recent_search_last_checked AS recent_search_last_checked_42 ,
t0 . recent_search_last_send AS recent_search_last_send_43 ,
t0 . auth_identifier AS auth_identifier_44 ,
t0 . auth_access_token AS auth_access_token_45 ,
t0 . auth_refresh_token AS auth_refresh_token_46 ,
t0 . auth_updated_at AS auth_updated_at_47 ,
t0 . parent_id AS parent_id_48 ,
t0 . logo AS logo_49 ,
t0 . personal_photo AS personal_photo_50 ,
t0 . company_id AS company_id_51 ,
t0 . staff_id AS staff_id_52 ,
t0 . team_id AS team_id_53 ,
t0 . developerField_id AS developerField_id_54
FROM
users t0
WHERE
t0 . id = ?
Copy
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 . is_imported AS is_imported_31 , t0 . subscription_expiry_date AS subscription_expiry_date_32 , t0 . credit_expiry_date AS credit_expiry_date_33 , t0 . soft_churn_date AS soft_churn_date_34 , t0 . reach_count AS reach_count_35 , t0 . synced AS synced_36 , t0 . reference_id AS reference_id_37 , t0 . has_email AS has_email_38 , t0 . client_served_count AS client_served_count_39 , t0 . enabled_marketing AS enabled_marketing_40 , t0 . zoho_synced AS zoho_synced_41 , t0 . recent_search_last_checked AS recent_search_last_checked_42 , t0 . recent_search_last_send AS recent_search_last_send_43 , t0 . auth_identifier AS auth_identifier_44 , t0 . auth_access_token AS auth_access_token_45 , t0 . auth_refresh_token AS auth_refresh_token_46 , t0 . auth_updated_at AS auth_updated_at_47 , t0 . parent_id AS parent_id_48 , t0 . logo AS logo_49 , t0 . personal_photo AS personal_photo_50 , t0 . company_id AS company_id_51 , t0 . staff_id AS staff_id_52 , t0 . team_id AS team_id_53 , t0 . developerField_id AS developerField_id_54 FROM users t0 WHERE t0 . id = 2 ;
Copy
23
1.45 ms
SELECT COUNT (* ) FROM listings t0 WHERE t0 . user_id = ?
SELECT COUNT (* ) FROM listings t0 WHERE t0 . user_id = 2 ;
Copy
24
1.31 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 = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . roles AS roles_3 , t0 . category AS category_4 , t0 . zoho_crm AS zoho_crm_5 , t0 . is_private AS is_private_6 FROM groups_list t0 INNER JOIN users_groups ON t0 . id = users_groups . group_id WHERE users_groups . user_id = 2 ;
Copy
25
2.12 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = ? AND t0 . parent_id = ? ) ORDER BY t0 . area ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
(
t0 . status = ?
AND t0 . parent_id = ?
)
ORDER BY
t0 . area ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = 2 AND t0 . parent_id = 131 ) ORDER BY t0 . area ASC ;
Copy
26
2.04 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = ? AND t0 . parent_id = ? ) ORDER BY t0 . area ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
(
t0 . status = ?
AND t0 . parent_id = ?
)
ORDER BY
t0 . area ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = 2 AND t0 . parent_id = 131 ) ORDER BY t0 . area ASC ;
Copy
27
1.82 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
28
1.95 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
29
1.75 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
30
2.02 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
31
2.10 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
32
1.93 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
33
1.93 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
34
2.29 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = ? ORDER BY t0 . id ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
t0 . parent_id = ?
ORDER BY
t0 . id ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE t0 . parent_id = 131 ORDER BY t0 . id ASC ;
Copy
35
13.92 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
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 ;
Copy
36
6.94 ms
SELECT l0_ . id AS id_0 FROM locations l0_ WHERE l0_ . _left < = 4 AND l0_ . _right > = 5 AND l0_ . root = ? AND l0_ . id < > ? AND l0_ . parent_id IS NOT NULL ORDER BY l0_ . _left ASC
SELECT l0_ . id AS id_0 FROM locations l0_ WHERE l0_ . _left < = 4 AND l0_ . _right > = 5 AND l0_ . root = 43 AND l0_ . id < > 45 AND l0_ . parent_id IS NOT NULL ORDER BY l0_ . _left ASC ;
Copy
37
4.67 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 . is_imported AS is_imported_31 , t0 . subscription_expiry_date AS subscription_expiry_date_32 , t0 . credit_expiry_date AS credit_expiry_date_33 , t0 . soft_churn_date AS soft_churn_date_34 , t0 . reach_count AS reach_count_35 , t0 . synced AS synced_36 , t0 . reference_id AS reference_id_37 , t0 . has_email AS has_email_38 , t0 . client_served_count AS client_served_count_39 , t0 . enabled_marketing AS enabled_marketing_40 , t0 . zoho_synced AS zoho_synced_41 , t0 . recent_search_last_checked AS recent_search_last_checked_42 , t0 . recent_search_last_send AS recent_search_last_send_43 , t0 . auth_identifier AS auth_identifier_44 , t0 . auth_access_token AS auth_access_token_45 , t0 . auth_refresh_token AS auth_refresh_token_46 , t0 . auth_updated_at AS auth_updated_at_47 , t0 . parent_id AS parent_id_48 , t0 . logo AS logo_49 , t0 . personal_photo AS personal_photo_50 , t0 . company_id AS company_id_51 , t0 . staff_id AS staff_id_52 , t0 . team_id AS team_id_53 , t0 . developerField_id AS developerField_id_54 FROM users t0 WHERE t0 . id IN (? )
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 . is_imported AS is_imported_31 ,
t0 . subscription_expiry_date AS subscription_expiry_date_32 ,
t0 . credit_expiry_date AS credit_expiry_date_33 ,
t0 . soft_churn_date AS soft_churn_date_34 ,
t0 . reach_count AS reach_count_35 ,
t0 . synced AS synced_36 ,
t0 . reference_id AS reference_id_37 ,
t0 . has_email AS has_email_38 ,
t0 . client_served_count AS client_served_count_39 ,
t0 . enabled_marketing AS enabled_marketing_40 ,
t0 . zoho_synced AS zoho_synced_41 ,
t0 . recent_search_last_checked AS recent_search_last_checked_42 ,
t0 . recent_search_last_send AS recent_search_last_send_43 ,
t0 . auth_identifier AS auth_identifier_44 ,
t0 . auth_access_token AS auth_access_token_45 ,
t0 . auth_refresh_token AS auth_refresh_token_46 ,
t0 . auth_updated_at AS auth_updated_at_47 ,
t0 . parent_id AS parent_id_48 ,
t0 . logo AS logo_49 ,
t0 . personal_photo AS personal_photo_50 ,
t0 . company_id AS company_id_51 ,
t0 . staff_id AS staff_id_52 ,
t0 . team_id AS team_id_53 ,
t0 . developerField_id AS developerField_id_54
FROM
users t0
WHERE
t0 . id IN (? )
Copy
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 . is_imported AS is_imported_31 , t0 . subscription_expiry_date AS subscription_expiry_date_32 , t0 . credit_expiry_date AS credit_expiry_date_33 , t0 . soft_churn_date AS soft_churn_date_34 , t0 . reach_count AS reach_count_35 , t0 . synced AS synced_36 , t0 . reference_id AS reference_id_37 , t0 . has_email AS has_email_38 , t0 . client_served_count AS client_served_count_39 , t0 . enabled_marketing AS enabled_marketing_40 , t0 . zoho_synced AS zoho_synced_41 , t0 . recent_search_last_checked AS recent_search_last_checked_42 , t0 . recent_search_last_send AS recent_search_last_send_43 , t0 . auth_identifier AS auth_identifier_44 , t0 . auth_access_token AS auth_access_token_45 , t0 . auth_refresh_token AS auth_refresh_token_46 , t0 . auth_updated_at AS auth_updated_at_47 , t0 . parent_id AS parent_id_48 , t0 . logo AS logo_49 , t0 . personal_photo AS personal_photo_50 , t0 . company_id AS company_id_51 , t0 . staff_id AS staff_id_52 , t0 . team_id AS team_id_53 , t0 . developerField_id AS developerField_id_54 FROM users t0 WHERE t0 . id IN (NULL );
Copy
38
1.60 ms
SELECT f0_ . id AS id_0 , f0_ . bank_name AS bank_name_1 , f0_ . bank_url AS bank_url_2 , f0_ . status AS status_3 , RAND () AS sclr_4 FROM financial_aids f0_ WHERE f0_ . status = ? ORDER BY sclr_4 ASC LIMIT 1
SELECT f0_ . id AS id_0 , f0_ . bank_name AS bank_name_1 , f0_ . bank_url AS bank_url_2 , f0_ . status AS status_3 , RAND () AS sclr_4 FROM financial_aids f0_ WHERE f0_ . status = 1 ORDER BY sclr_4 ASC LIMIT 1 ;
Copy
39
1.75 ms
SELECT COUNT (* ) FROM listings t0 WHERE (t0 . status = ? AND t0 . user_id = ? )
SELECT COUNT (* ) FROM listings t0 WHERE (t0 . status = 2 AND t0 . user_id = 2 );
Copy
40
1.92 ms
SELECT MIN (l0_ . price ) AS sclr_0 , MIN (l0_ . area ) AS sclr_1 FROM listings l0_ WHERE l0_ . status = ? AND l0_ . parent_id = ?
SELECT MIN (l0_ . price ) AS sclr_0 , MIN (l0_ . area ) AS sclr_1 FROM listings l0_ WHERE l0_ . status = 2 AND l0_ . parent_id = 131 ;
Copy
41
3.50 ms
SELECT COUNT (l0_ . id ) AS sclr_0 FROM listings l0_ WHERE l0_ . status = ? AND l0_ . section_id = ? AND l0_ . location_id = ? AND l0_ . category < > ? AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = ? )
Parameters :
[
2
1
45
3
2
]
SELECT COUNT (l0_ . id ) AS sclr_0 FROM listings l0_ WHERE l0_ . status = 2 AND l0_ . section_id = 1 AND l0_ . location_id = 45 AND l0_ . category < > 3 AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = 2 );
Copy
42
3.85 ms
SELECT l0_ . id AS id_0 , l0_ . title AS title_1 , l0_ . description AS description_2 , l0_ . category AS category_3 , l0_ . pending_photos_status AS pending_photos_status_4 , l0_ . pending_payment_status AS pending_payment_status_5 , l0_ . relist_status AS relist_status_6 , l0_ . seller_role AS seller_role_7 , l0_ . area AS area_8 , l0_ . price AS price_9 , l0_ . address AS address_10 , l0_ . center_lat AS center_lat_11 , l0_ . center_lng AS center_lng_12 , l0_ . status AS status_13 , l0_ . property_view AS property_view_14 , l0_ . payment_method AS payment_method_15 , l0_ . featured AS featured_16 , l0_ . views AS views_17 , l0_ . phone_counter AS phone_counter_18 , l0_ . messages_counter AS messages_counter_19 , l0_ . leads_counter AS leads_counter_20 , l0_ . sent_notifiers AS sent_notifiers_21 , l0_ . relist_counter AS relist_counter_22 , l0_ . ip AS ip_23 , l0_ . video_url AS video_url_24 , l0_ . slug AS slug_25 , l0_ . custom_slug AS custom_slug_26 , l0_ . score AS score_27 , l0_ . created_at AS created_at_28 , l0_ . updated_at AS updated_at_29 , l0_ . pending_status_created_at AS pending_status_created_at_30 , l0_ . published_at AS published_at_31 , l0_ . expires_at AS expires_at_32 , l0_ . deleted_at AS deleted_at_33 , l0_ . rejected_at AS rejected_at_34 , l0_ . campaign AS campaign_35 , l0_ . final_price AS final_price_36 , l0_ . source_of_sale AS source_of_sale_37 , l0_ . delete_reason AS delete_reason_38 , l0_ . delete_reason_details AS delete_reason_details_39 , l0_ . source AS source_40 , l0_ . impressions AS impressions_41 , l0_ . impressions_monthly_count AS impressions_monthly_count_42 , l0_ . impressions_weekly_count AS impressions_weekly_count_43 , l0_ . impression_updated_at AS impression_updated_at_44 , l0_ . price_level AS price_level_45 , l0_ . compound_status AS compound_status_46 , l0_ . price_per_meter AS price_per_meter_47 , l0_ . is_bumped AS is_bumped_48 , l0_ . is_send_email AS is_send_email_49 , l0_ . market_property_type AS market_property_type_50 , l0_ . creation_source AS creation_source_51 , l0_ . click_through_rate AS click_through_rate_52 , l0_ . label AS label_53 , l0_ . is_top_picks AS is_top_picks_54 , l0_ . contact_rate AS contact_rate_55 , l0_ . synced AS synced_56 , l0_ . reference_id AS reference_id_57 , l0_ . is_pending_featuring AS is_pending_featuring_58 , l0_ . pending_featuring_type AS pending_featuring_type_59 , l0_ . rate_status AS rate_status_60 , l0_ . is_rate_reviewed AS is_rate_reviewed_61 , l0_ . is_call_request AS is_call_request_62 , l0_ . is_shown_in_homepage AS is_shown_in_homepage_63 , l0_ . is_commercial AS is_commercial_64 , l0_ . is_resale AS is_resale_65 , l0_ . is_rent AS is_rent_66 , l0_ . is_primary AS is_primary_67 , l0_ . is_mortgage_approved AS is_mortgage_approved_68 , l0_ . meta_title AS meta_title_69 , l0_ . meta_description AS meta_description_70 , l0_ . is_mortgage AS is_mortgage_71 , l0_ . eligible_for_mortgage AS eligible_for_mortgage_72 , l0_ . property_registration_status AS property_registration_status_73 , l0_ . advertiser_number AS advertiser_number_74 , l0_ . authorization_number AS authorization_number_75 , l0_ . freezed_at AS freezed_at_76 , l0_ . eligible_for_bumpup AS eligible_for_bumpup_77 , l0_ . waiting_time AS waiting_time_78 , l0_ . reference_number AS reference_number_79 , l0_ . parent_id AS parent_id_80 , l0_ . relist_id AS relist_id_81 , l0_ . section_id AS section_id_82 , l0_ . property_type_id AS property_type_id_83 , l0_ . location_id AS location_id_84 , l0_ . compound_location_id AS compound_location_id_85 , l0_ . user_id AS user_id_86 , l0_ . compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE l0_ . status = ? AND l0_ . section_id = ? AND l0_ . location_id = ? AND l0_ . category < > ? AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = ? ) LIMIT 5
Parameters :
[
2
1
45
3
2
]
SELECT
l0_ . id AS id_0 ,
l0_ . title AS title_1 ,
l0_ . description AS description_2 ,
l0_ . category AS category_3 ,
l0_ . pending_photos_status AS pending_photos_status_4 ,
l0_ . pending_payment_status AS pending_payment_status_5 ,
l0_ . relist_status AS relist_status_6 ,
l0_ . seller_role AS seller_role_7 ,
l0_ . area AS area_8 ,
l0_ . price AS price_9 ,
l0_ . address AS address_10 ,
l0_ . center_lat AS center_lat_11 ,
l0_ . center_lng AS center_lng_12 ,
l0_ . status AS status_13 ,
l0_ . property_view AS property_view_14 ,
l0_ . payment_method AS payment_method_15 ,
l0_ . featured AS featured_16 ,
l0_ . views AS views_17 ,
l0_ . phone_counter AS phone_counter_18 ,
l0_ . messages_counter AS messages_counter_19 ,
l0_ . leads_counter AS leads_counter_20 ,
l0_ . sent_notifiers AS sent_notifiers_21 ,
l0_ . relist_counter AS relist_counter_22 ,
l0_ . ip AS ip_23 ,
l0_ . video_url AS video_url_24 ,
l0_ . slug AS slug_25 ,
l0_ . custom_slug AS custom_slug_26 ,
l0_ . score AS score_27 ,
l0_ . created_at AS created_at_28 ,
l0_ . updated_at AS updated_at_29 ,
l0_ . pending_status_created_at AS pending_status_created_at_30 ,
l0_ . published_at AS published_at_31 ,
l0_ . expires_at AS expires_at_32 ,
l0_ . deleted_at AS deleted_at_33 ,
l0_ . rejected_at AS rejected_at_34 ,
l0_ . campaign AS campaign_35 ,
l0_ . final_price AS final_price_36 ,
l0_ . source_of_sale AS source_of_sale_37 ,
l0_ . delete_reason AS delete_reason_38 ,
l0_ . delete_reason_details AS delete_reason_details_39 ,
l0_ . source AS source_40 ,
l0_ . impressions AS impressions_41 ,
l0_ . impressions_monthly_count AS impressions_monthly_count_42 ,
l0_ . impressions_weekly_count AS impressions_weekly_count_43 ,
l0_ . impression_updated_at AS impression_updated_at_44 ,
l0_ . price_level AS price_level_45 ,
l0_ . compound_status AS compound_status_46 ,
l0_ . price_per_meter AS price_per_meter_47 ,
l0_ . is_bumped AS is_bumped_48 ,
l0_ . is_send_email AS is_send_email_49 ,
l0_ . market_property_type AS market_property_type_50 ,
l0_ . creation_source AS creation_source_51 ,
l0_ . click_through_rate AS click_through_rate_52 ,
l0_ . label AS label_53 ,
l0_ . is_top_picks AS is_top_picks_54 ,
l0_ . contact_rate AS contact_rate_55 ,
l0_ . synced AS synced_56 ,
l0_ . reference_id AS reference_id_57 ,
l0_ . is_pending_featuring AS is_pending_featuring_58 ,
l0_ . pending_featuring_type AS pending_featuring_type_59 ,
l0_ . rate_status AS rate_status_60 ,
l0_ . is_rate_reviewed AS is_rate_reviewed_61 ,
l0_ . is_call_request AS is_call_request_62 ,
l0_ . is_shown_in_homepage AS is_shown_in_homepage_63 ,
l0_ . is_commercial AS is_commercial_64 ,
l0_ . is_resale AS is_resale_65 ,
l0_ . is_rent AS is_rent_66 ,
l0_ . is_primary AS is_primary_67 ,
l0_ . is_mortgage_approved AS is_mortgage_approved_68 ,
l0_ . meta_title AS meta_title_69 ,
l0_ . meta_description AS meta_description_70 ,
l0_ . is_mortgage AS is_mortgage_71 ,
l0_ . eligible_for_mortgage AS eligible_for_mortgage_72 ,
l0_ . property_registration_status AS property_registration_status_73 ,
l0_ . advertiser_number AS advertiser_number_74 ,
l0_ . authorization_number AS authorization_number_75 ,
l0_ . freezed_at AS freezed_at_76 ,
l0_ . eligible_for_bumpup AS eligible_for_bumpup_77 ,
l0_ . waiting_time AS waiting_time_78 ,
l0_ . reference_number AS reference_number_79 ,
l0_ . parent_id AS parent_id_80 ,
l0_ . relist_id AS relist_id_81 ,
l0_ . section_id AS section_id_82 ,
l0_ . property_type_id AS property_type_id_83 ,
l0_ . location_id AS location_id_84 ,
l0_ . compound_location_id AS compound_location_id_85 ,
l0_ . user_id AS user_id_86 ,
l0_ . compound_field_id AS compound_field_id_87
FROM
listings l0_
WHERE
l0_ . status = ?
AND l0_ . section_id = ?
AND l0_ . location_id = ?
AND l0_ . category < > ?
AND l0_ . parent_id IS NULL
AND (
l0_ . market_property_type IS NULL
OR l0_ . market_property_type = ?
)
LIMIT
5
Copy
SELECT l0_ . id AS id_0 , l0_ . title AS title_1 , l0_ . description AS description_2 , l0_ . category AS category_3 , l0_ . pending_photos_status AS pending_photos_status_4 , l0_ . pending_payment_status AS pending_payment_status_5 , l0_ . relist_status AS relist_status_6 , l0_ . seller_role AS seller_role_7 , l0_ . area AS area_8 , l0_ . price AS price_9 , l0_ . address AS address_10 , l0_ . center_lat AS center_lat_11 , l0_ . center_lng AS center_lng_12 , l0_ . status AS status_13 , l0_ . property_view AS property_view_14 , l0_ . payment_method AS payment_method_15 , l0_ . featured AS featured_16 , l0_ . views AS views_17 , l0_ . phone_counter AS phone_counter_18 , l0_ . messages_counter AS messages_counter_19 , l0_ . leads_counter AS leads_counter_20 , l0_ . sent_notifiers AS sent_notifiers_21 , l0_ . relist_counter AS relist_counter_22 , l0_ . ip AS ip_23 , l0_ . video_url AS video_url_24 , l0_ . slug AS slug_25 , l0_ . custom_slug AS custom_slug_26 , l0_ . score AS score_27 , l0_ . created_at AS created_at_28 , l0_ . updated_at AS updated_at_29 , l0_ . pending_status_created_at AS pending_status_created_at_30 , l0_ . published_at AS published_at_31 , l0_ . expires_at AS expires_at_32 , l0_ . deleted_at AS deleted_at_33 , l0_ . rejected_at AS rejected_at_34 , l0_ . campaign AS campaign_35 , l0_ . final_price AS final_price_36 , l0_ . source_of_sale AS source_of_sale_37 , l0_ . delete_reason AS delete_reason_38 , l0_ . delete_reason_details AS delete_reason_details_39 , l0_ . source AS source_40 , l0_ . impressions AS impressions_41 , l0_ . impressions_monthly_count AS impressions_monthly_count_42 , l0_ . impressions_weekly_count AS impressions_weekly_count_43 , l0_ . impression_updated_at AS impression_updated_at_44 , l0_ . price_level AS price_level_45 , l0_ . compound_status AS compound_status_46 , l0_ . price_per_meter AS price_per_meter_47 , l0_ . is_bumped AS is_bumped_48 , l0_ . is_send_email AS is_send_email_49 , l0_ . market_property_type AS market_property_type_50 , l0_ . creation_source AS creation_source_51 , l0_ . click_through_rate AS click_through_rate_52 , l0_ . label AS label_53 , l0_ . is_top_picks AS is_top_picks_54 , l0_ . contact_rate AS contact_rate_55 , l0_ . synced AS synced_56 , l0_ . reference_id AS reference_id_57 , l0_ . is_pending_featuring AS is_pending_featuring_58 , l0_ . pending_featuring_type AS pending_featuring_type_59 , l0_ . rate_status AS rate_status_60 , l0_ . is_rate_reviewed AS is_rate_reviewed_61 , l0_ . is_call_request AS is_call_request_62 , l0_ . is_shown_in_homepage AS is_shown_in_homepage_63 , l0_ . is_commercial AS is_commercial_64 , l0_ . is_resale AS is_resale_65 , l0_ . is_rent AS is_rent_66 , l0_ . is_primary AS is_primary_67 , l0_ . is_mortgage_approved AS is_mortgage_approved_68 , l0_ . meta_title AS meta_title_69 , l0_ . meta_description AS meta_description_70 , l0_ . is_mortgage AS is_mortgage_71 , l0_ . eligible_for_mortgage AS eligible_for_mortgage_72 , l0_ . property_registration_status AS property_registration_status_73 , l0_ . advertiser_number AS advertiser_number_74 , l0_ . authorization_number AS authorization_number_75 , l0_ . freezed_at AS freezed_at_76 , l0_ . eligible_for_bumpup AS eligible_for_bumpup_77 , l0_ . waiting_time AS waiting_time_78 , l0_ . reference_number AS reference_number_79 , l0_ . parent_id AS parent_id_80 , l0_ . relist_id AS relist_id_81 , l0_ . section_id AS section_id_82 , l0_ . property_type_id AS property_type_id_83 , l0_ . location_id AS location_id_84 , l0_ . compound_location_id AS compound_location_id_85 , l0_ . user_id AS user_id_86 , l0_ . compound_field_id AS compound_field_id_87 FROM listings l0_ WHERE l0_ . status = 2 AND l0_ . section_id = 1 AND l0_ . location_id = 45 AND l0_ . category < > 3 AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = 2 ) LIMIT 5 ;
Copy
43
1.58 ms
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . slug AS slug_2 , l0_ . area AS area_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . parent_id = ? AND l0_ . status = ? AND l0_ . deleted_at IS NULL
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . slug AS slug_2 , l0_ . area AS area_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . parent_id = 131 AND l0_ . status = 2 AND l0_ . deleted_at IS NULL ;
Copy
44
4.19 ms
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . area AS area_2 , l0_ . slug AS slug_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . status = ? AND l0_ . section_id = ? AND l0_ . location_id = ? AND l0_ . category < > ? AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = ? ) ORDER BY title_5 ASC
Parameters :
[
2
1
45
3
2
]
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . area AS area_2 , l0_ . slug AS slug_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . status = 2 AND l0_ . section_id = 1 AND l0_ . location_id = 45 AND l0_ . category < > 3 AND l0_ . parent_id IS NULL AND (l0_ . market_property_type IS NULL OR l0_ . market_property_type = 2 ) ORDER BY title_5 ASC ;
Copy
45
3.64 ms
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . area AS area_2 , l0_ . slug AS slug_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . status = ? AND l0_ . section_id = ? AND l0_ . location_id = ? AND l0_ . category < > ? AND l0_ . parent_id IS NULL ORDER BY title_5 ASC
SELECT l0_ . id AS id_0 , l0_ . price AS price_1 , l0_ . area AS area_2 , l0_ . slug AS slug_3 , p1_ . id AS id_4 , p1_ . title AS title_5 FROM listings l0_ INNER JOIN property_types p1_ ON l0_ . property_type_id = p1_ . id WHERE l0_ . status = 2 AND l0_ . section_id = 2 AND l0_ . location_id = 45 AND l0_ . category < > 3 AND l0_ . parent_id IS NULL ORDER BY title_5 ASC ;
Copy
46
2.17 ms
SELECT l0_ . id AS id_0 , l0_ . growth AS growth_1 , l0_ . avg_price AS avg_price_2 , l0_ . demand_heat AS demand_heat_3 , l0_ . ppm_min AS ppm_min_4 , l0_ . ppm_max AS ppm_max_5 , l0_ . updated_at AS updated_at_6 , l0_ . section_id AS section_id_7 , l0_ . property_type_id AS property_type_id_8 , l0_ . location_id AS location_id_9 FROM locations_statistics l0_ INNER JOIN locations l1_ ON l0_ . location_id = l1_ . id WHERE l0_ . location_id = ? AND l0_ . property_type_id = ? AND l1_ . statistics_filter = ?
Parameters :
[
45
3
true
]
SELECT l0_ . id AS id_0 , l0_ . growth AS growth_1 , l0_ . avg_price AS avg_price_2 , l0_ . demand_heat AS demand_heat_3 , l0_ . ppm_min AS ppm_min_4 , l0_ . ppm_max AS ppm_max_5 , l0_ . updated_at AS updated_at_6 , l0_ . section_id AS section_id_7 , l0_ . property_type_id AS property_type_id_8 , l0_ . location_id AS location_id_9 FROM locations_statistics l0_ INNER JOIN locations l1_ ON l0_ . location_id = l1_ . id WHERE l0_ . location_id = 45 AND l0_ . property_type_id = 3 AND l1_ . statistics_filter = 1 ;
Copy
47
1.88 ms
SELECT discussion_id FROM
(SELECT discussion_id , id FROM comments WHERE STATUS = 2 AND deleted_at IS NULL ORDER BY id DESC LIMIT 50 ) AS t
GROUP BY discussion_id
SELECT discussion_id FROM
(SELECT discussion_id , id FROM comments WHERE STATUS = 2 AND deleted_at IS NULL ORDER BY id DESC LIMIT 50 ) AS t
GROUP BY discussion_id ;
Copy
48
1.87 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_ . id IN (? ) AND d0_ . status = ? AND d0_ . location_id = ? ORDER BY d0_ . comments_counter DESC , d0_ . created_at DESC LIMIT 3
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_ . id IN (NULL ) AND d0_ . status = 2 AND d0_ . location_id = 45 ORDER BY d0_ . comments_counter DESC , d0_ . created_at DESC LIMIT 3 ;
Copy
49
1.87 ms
SELECT t0 . id AS id_1 , t0 . is_verified AS is_verified_2 , t0 . main_number AS main_number_3 , t0 . verification_code AS verification_code_4 , t0 . verified_at AS verified_at_5 , t0 . has_whatsApp AS has_whatsApp_6 , t0 . added_at AS added_at_7 , t0 . user_id AS user_id_8 , t0 . phone_id AS phone_id_9 FROM users_phones t0 WHERE t0 . user_id = ? ORDER BY t0 . id DESC
SELECT t0 . id AS id_1 , t0 . is_verified AS is_verified_2 , t0 . main_number AS main_number_3 , t0 . verification_code AS verification_code_4 , t0 . verified_at AS verified_at_5 , t0 . has_whatsApp AS has_whatsApp_6 , t0 . added_at AS added_at_7 , t0 . user_id AS user_id_8 , t0 . phone_id AS phone_id_9 FROM users_phones t0 WHERE t0 . user_id = 2 ORDER BY t0 . id DESC ;
Copy
50
1.75 ms
SELECT t0 . id AS id_1 , t0 . is_verified AS is_verified_2 , t0 . main_number AS main_number_3 , t0 . verification_code AS verification_code_4 , t0 . verified_at AS verified_at_5 , t0 . has_whatsApp AS has_whatsApp_6 , t0 . added_at AS added_at_7 , t0 . user_id AS user_id_8 , t0 . phone_id AS phone_id_9 FROM users_phones t0 WHERE t0 . user_id = ? ORDER BY t0 . id DESC
SELECT t0 . id AS id_1 , t0 . is_verified AS is_verified_2 , t0 . main_number AS main_number_3 , t0 . verification_code AS verification_code_4 , t0 . verified_at AS verified_at_5 , t0 . has_whatsApp AS has_whatsApp_6 , t0 . added_at AS added_at_7 , t0 . user_id AS user_id_8 , t0 . phone_id AS phone_id_9 FROM users_phones t0 WHERE t0 . user_id = 2 ORDER BY t0 . id DESC ;
Copy
51
1.60 ms
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . original_phone_number AS original_phone_number_3 , t0 . country_code AS country_code_4 , t0 . ip AS ip_5 , t0 . country AS country_6 , t0 . created_at AS created_at_7 FROM phones t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . number AS number_2 , t0 . original_phone_number AS original_phone_number_3 , t0 . country_code AS country_code_4 , t0 . ip AS ip_5 , t0 . country AS country_6 , t0 . created_at AS created_at_7 FROM phones t0 WHERE t0 . id = 542 ;
Copy
52
1.77 ms
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . path AS path_3 , t0 . hash AS hash_4 FROM photos t0 WHERE t0 . id = ?
SELECT t0 . id AS id_1 , t0 . name AS name_2 , t0 . path AS path_3 , t0 . hash AS hash_4 FROM photos t0 WHERE t0 . id = 1 ;
Copy
53
2.13 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
"2024-09-29 01:31:11 "
]
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 > = '2024-09-29 01:31:11' ;
Copy
54
3.86 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = ? AND t0 . parent_id = ? ) ORDER BY t0 . area ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
(
t0 . status = ?
AND t0 . parent_id = ?
)
ORDER BY
t0 . area ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = 2 AND t0 . parent_id = 131 ) ORDER BY t0 . area ASC ;
Copy
55
3.76 ms
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = ? AND t0 . parent_id = ? ) ORDER BY t0 . area ASC
SELECT
t0 . id AS id_1 ,
t0 . title AS title_2 ,
t0 . description AS description_3 ,
t0 . category AS category_4 ,
t0 . pending_photos_status AS pending_photos_status_5 ,
t0 . pending_payment_status AS pending_payment_status_6 ,
t0 . relist_status AS relist_status_7 ,
t0 . seller_role AS seller_role_8 ,
t0 . area AS area_9 ,
t0 . price AS price_10 ,
t0 . address AS address_11 ,
t0 . center_lat AS center_lat_12 ,
t0 . center_lng AS center_lng_13 ,
t0 . status AS status_14 ,
t0 . property_view AS property_view_15 ,
t0 . payment_method AS payment_method_16 ,
t0 . featured AS featured_17 ,
t0 . views AS views_18 ,
t0 . phone_counter AS phone_counter_19 ,
t0 . messages_counter AS messages_counter_20 ,
t0 . leads_counter AS leads_counter_21 ,
t0 . sent_notifiers AS sent_notifiers_22 ,
t0 . relist_counter AS relist_counter_23 ,
t0 . ip AS ip_24 ,
t0 . video_url AS video_url_25 ,
t0 . slug AS slug_26 ,
t0 . custom_slug AS custom_slug_27 ,
t0 . score AS score_28 ,
t0 . created_at AS created_at_29 ,
t0 . updated_at AS updated_at_30 ,
t0 . pending_status_created_at AS pending_status_created_at_31 ,
t0 . published_at AS published_at_32 ,
t0 . expires_at AS expires_at_33 ,
t0 . deleted_at AS deleted_at_34 ,
t0 . rejected_at AS rejected_at_35 ,
t0 . campaign AS campaign_36 ,
t0 . final_price AS final_price_37 ,
t0 . source_of_sale AS source_of_sale_38 ,
t0 . delete_reason AS delete_reason_39 ,
t0 . delete_reason_details AS delete_reason_details_40 ,
t0 . source AS source_41 ,
t0 . impressions AS impressions_42 ,
t0 . impressions_monthly_count AS impressions_monthly_count_43 ,
t0 . impressions_weekly_count AS impressions_weekly_count_44 ,
t0 . impression_updated_at AS impression_updated_at_45 ,
t0 . price_level AS price_level_46 ,
t0 . compound_status AS compound_status_47 ,
t0 . price_per_meter AS price_per_meter_48 ,
t0 . is_bumped AS is_bumped_49 ,
t0 . is_send_email AS is_send_email_50 ,
t0 . market_property_type AS market_property_type_51 ,
t0 . creation_source AS creation_source_52 ,
t0 . click_through_rate AS click_through_rate_53 ,
t0 . label AS label_54 ,
t0 . is_top_picks AS is_top_picks_55 ,
t0 . contact_rate AS contact_rate_56 ,
t0 . synced AS synced_57 ,
t0 . reference_id AS reference_id_58 ,
t0 . is_pending_featuring AS is_pending_featuring_59 ,
t0 . pending_featuring_type AS pending_featuring_type_60 ,
t0 . rate_status AS rate_status_61 ,
t0 . is_rate_reviewed AS is_rate_reviewed_62 ,
t0 . is_call_request AS is_call_request_63 ,
t0 . is_shown_in_homepage AS is_shown_in_homepage_64 ,
t0 . is_commercial AS is_commercial_65 ,
t0 . is_resale AS is_resale_66 ,
t0 . is_rent AS is_rent_67 ,
t0 . is_primary AS is_primary_68 ,
t0 . is_mortgage_approved AS is_mortgage_approved_69 ,
t0 . meta_title AS meta_title_70 ,
t0 . meta_description AS meta_description_71 ,
t0 . is_mortgage AS is_mortgage_72 ,
t0 . eligible_for_mortgage AS eligible_for_mortgage_73 ,
t0 . property_registration_status AS property_registration_status_74 ,
t0 . advertiser_number AS advertiser_number_75 ,
t0 . authorization_number AS authorization_number_76 ,
t0 . freezed_at AS freezed_at_77 ,
t0 . eligible_for_bumpup AS eligible_for_bumpup_78 ,
t0 . waiting_time AS waiting_time_79 ,
t0 . reference_number AS reference_number_80 ,
t0 . parent_id AS parent_id_81 ,
t0 . relist_id AS relist_id_82 ,
t0 . section_id AS section_id_83 ,
t0 . property_type_id AS property_type_id_84 ,
t0 . location_id AS location_id_85 ,
t0 . compound_location_id AS compound_location_id_86 ,
t0 . user_id AS user_id_87 ,
t0 . compound_field_id AS compound_field_id_88
FROM
listings t0
WHERE
(
t0 . status = ?
AND t0 . parent_id = ?
)
ORDER BY
t0 . area ASC
Copy
SELECT t0 . id AS id_1 , t0 . title AS title_2 , t0 . description AS description_3 , t0 . category AS category_4 , t0 . pending_photos_status AS pending_photos_status_5 , t0 . pending_payment_status AS pending_payment_status_6 , t0 . relist_status AS relist_status_7 , t0 . seller_role AS seller_role_8 , t0 . area AS area_9 , t0 . price AS price_10 , t0 . address AS address_11 , t0 . center_lat AS center_lat_12 , t0 . center_lng AS center_lng_13 , t0 . status AS status_14 , t0 . property_view AS property_view_15 , t0 . payment_method AS payment_method_16 , t0 . featured AS featured_17 , t0 . views AS views_18 , t0 . phone_counter AS phone_counter_19 , t0 . messages_counter AS messages_counter_20 , t0 . leads_counter AS leads_counter_21 , t0 . sent_notifiers AS sent_notifiers_22 , t0 . relist_counter AS relist_counter_23 , t0 . ip AS ip_24 , t0 . video_url AS video_url_25 , t0 . slug AS slug_26 , t0 . custom_slug AS custom_slug_27 , t0 . score AS score_28 , t0 . created_at AS created_at_29 , t0 . updated_at AS updated_at_30 , t0 . pending_status_created_at AS pending_status_created_at_31 , t0 . published_at AS published_at_32 , t0 . expires_at AS expires_at_33 , t0 . deleted_at AS deleted_at_34 , t0 . rejected_at AS rejected_at_35 , t0 . campaign AS campaign_36 , t0 . final_price AS final_price_37 , t0 . source_of_sale AS source_of_sale_38 , t0 . delete_reason AS delete_reason_39 , t0 . delete_reason_details AS delete_reason_details_40 , t0 . source AS source_41 , t0 . impressions AS impressions_42 , t0 . impressions_monthly_count AS impressions_monthly_count_43 , t0 . impressions_weekly_count AS impressions_weekly_count_44 , t0 . impression_updated_at AS impression_updated_at_45 , t0 . price_level AS price_level_46 , t0 . compound_status AS compound_status_47 , t0 . price_per_meter AS price_per_meter_48 , t0 . is_bumped AS is_bumped_49 , t0 . is_send_email AS is_send_email_50 , t0 . market_property_type AS market_property_type_51 , t0 . creation_source AS creation_source_52 , t0 . click_through_rate AS click_through_rate_53 , t0 . label AS label_54 , t0 . is_top_picks AS is_top_picks_55 , t0 . contact_rate AS contact_rate_56 , t0 . synced AS synced_57 , t0 . reference_id AS reference_id_58 , t0 . is_pending_featuring AS is_pending_featuring_59 , t0 . pending_featuring_type AS pending_featuring_type_60 , t0 . rate_status AS rate_status_61 , t0 . is_rate_reviewed AS is_rate_reviewed_62 , t0 . is_call_request AS is_call_request_63 , t0 . is_shown_in_homepage AS is_shown_in_homepage_64 , t0 . is_commercial AS is_commercial_65 , t0 . is_resale AS is_resale_66 , t0 . is_rent AS is_rent_67 , t0 . is_primary AS is_primary_68 , t0 . is_mortgage_approved AS is_mortgage_approved_69 , t0 . meta_title AS meta_title_70 , t0 . meta_description AS meta_description_71 , t0 . is_mortgage AS is_mortgage_72 , t0 . eligible_for_mortgage AS eligible_for_mortgage_73 , t0 . property_registration_status AS property_registration_status_74 , t0 . advertiser_number AS advertiser_number_75 , t0 . authorization_number AS authorization_number_76 , t0 . freezed_at AS freezed_at_77 , t0 . eligible_for_bumpup AS eligible_for_bumpup_78 , t0 . waiting_time AS waiting_time_79 , t0 . reference_number AS reference_number_80 , t0 . parent_id AS parent_id_81 , t0 . relist_id AS relist_id_82 , t0 . section_id AS section_id_83 , t0 . property_type_id AS property_type_id_84 , t0 . location_id AS location_id_85 , t0 . compound_location_id AS compound_location_id_86 , t0 . user_id AS user_id_87 , t0 . compound_field_id AS compound_field_id_88 FROM listings t0 WHERE (t0 . status = 2 AND t0 . parent_id = 131 ) ORDER BY t0 . area ASC ;
Copy