SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000566s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000337s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000229s ]
SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000590s ]
SELECT p.*,r.name region_name,CASE WHEN COALESCE(p.video_url,'')<>'' OR EXISTS (SELECT 1 FROM property_videos pv_badge WHERE pv_badge.property_id=p.id AND pv_badge.status=1 AND COALESCE(pv_badge.video_url,'')<>'') THEN 1 ELSE 0 END has_video,CASE WHEN COALESCE(p.panorama_url,'')<>'' OR EXISTS (SELECT 1 FROM property_panoramas pp_badge WHERE pp_badge.property_id=p.id AND pp_badge.status=1 AND COALESCE(pp_badge.panorama_url,'')<>'') THEN 1 ELSE 0 END has_panorama FROM `properties` `p` LEFT JOIN `regions` `r` ON `r`.`id`=`p`.`region_id` WHERE `p`.`status` = '1' AND ( `p`.`legacy_id` = '2160' OR `p`.`id` = '2160' ) LIMIT 1 [ RunTime:0.000656s ]
SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000405s ]
SELECT * FROM `property_photos` WHERE `property_id` = '2160' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000284s ]
SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000459s ]
SELECT * FROM `property_floor_plans` WHERE `property_id` = '2160' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000390s ]
SELECT * FROM `property_panoramas` WHERE `property_id` = '2160' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000271s ]
SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000370s ]
SELECT * FROM `property_reviews` WHERE `property_id` = '2160' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000401s ]
SELECT * FROM `property_questions` WHERE `property_id` = '2160' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000305s ]
SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000400s ]
SELECT * FROM `property_promotions` WHERE `property_id` = '2160' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000295s ]
SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000388s ]
SELECT * FROM `property_milestones` WHERE `property_id` = '2160' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000264s ]
SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000385s ]
SELECT * FROM `property_price_histories` WHERE `property_id` = '2160' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000248s ]
SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000415s ]
SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '2160' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000385s ]
SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '2160' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000242s ]
SELECT * FROM `property_videos` WHERE `property_id` = '2160' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000255s ]
SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000432s ]
SELECT `a`.`id`,`a`.`legacy_id`,`a`.`property_id`,`a`.`legacy_property_id`,`a`.`region_id`,`a`.`title`,`a`.`summary`,`a`.`cover_image`,`a`.`author`,`a`.`source_name`,`a`.`keywords`,`a`.`view_count`,`a`.`is_recommended`,`a`.`is_pinned`,`a`.`status`,`a`.`published_at`,`a`.`created_at`,`a`.`updated_at`,r.name region_name,p.name property_name,p.cover_image property_cover FROM `property_articles` `a` LEFT JOIN `regions` `r` ON `r`.`id`=`a`.`region_id` LEFT JOIN `properties` `p` ON `p`.`id`=`a`.`property_id` WHERE `a`.`status` = 'published' AND `a`.`property_id` = '2160' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000403s ]
SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000408s ]
SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000307s ]
SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000383s ]
SELECT COUNT(*) AS think_count FROM `visitor_blacklist` WHERE ( `ip_address` = '216.73.216.164' ) AND ( `expires_at` IS NULL OR `expires_at` > '2026-08-20 19:08:18' ) [ RunTime:0.000235s ]
SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000360s ]
SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000360s ]
SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000345s ]
SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000366s ]
SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000233s ]
SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000392s ]
SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000246s ]