SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000640s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000323s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000304s ]
SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000830s ]
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` = '2164' OR `p`.`id` = '2164' ) LIMIT 1 [ RunTime:0.000884s ]
SHOW FULL COLUMNS FROM `property_photos` [ RunTime:0.000564s ]
SELECT * FROM `property_photos` WHERE `property_id` = '2164' AND `status` = '1' ORDER BY `is_cover` DESC,`sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000362s ]
SHOW FULL COLUMNS FROM `property_floor_plans` [ RunTime:0.000562s ]
SELECT * FROM `property_floor_plans` WHERE `property_id` = '2164' AND `status` = '1' ORDER BY `sort_order` DESC,`id` DESC LIMIT 300 [ RunTime:0.000383s ]
SHOW FULL COLUMNS FROM `property_panoramas` [ RunTime:0.000563s ]
SELECT * FROM `property_panoramas` WHERE `property_id` = '2164' AND `status` = '1' AND `panorama_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `property_reviews` [ RunTime:0.000584s ]
SELECT * FROM `property_reviews` WHERE `property_id` = '2164' AND `status` = 'published' ORDER BY `sort_order` DESC,`created_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000372s ]
SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000622s ]
SELECT * FROM `property_questions` WHERE `property_id` = '2164' AND `status` = 'published' ORDER BY `sort_order` DESC,`asked_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.000605s ]
SELECT * FROM `property_promotions` WHERE `property_id` = '2164' AND `status` = 'published' ORDER BY `sort_order` DESC,`starts_at` DESC,`id` DESC LIMIT 100 [ RunTime:0.000421s ]
SHOW FULL COLUMNS FROM `property_milestones` [ RunTime:0.000523s ]
SELECT * FROM `property_milestones` WHERE `property_id` = '2164' AND `status` = '1' ORDER BY `event_date` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.000353s ]
SHOW FULL COLUMNS FROM `property_price_histories` [ RunTime:0.000515s ]
SELECT * FROM `property_price_histories` WHERE `property_id` = '2164' ORDER BY `recorded_on` ASC,`sort_order` ASC,`id` ASC LIMIT 300 [ RunTime:0.000312s ]
SHOW FULL COLUMNS FROM `property_sandbox_buildings` [ RunTime:0.000790s ]
SELECT * FROM `property_sandbox_buildings` WHERE `property_id` = '2164' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC LIMIT 500 [ RunTime:0.000268s ]
SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000411s ]
SELECT COUNT(*) AS think_count FROM `property_videos` WHERE `property_id` = '2164' AND `status` = '1' AND `video_url` <> '' [ RunTime:0.000218s ]
SELECT * FROM `property_videos` WHERE `property_id` = '2164' AND `status` = '1' AND `video_url` <> '' ORDER BY `sort_order` DESC,`id` DESC LIMIT 4 [ RunTime:0.000258s ]
SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000410s ]
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` = '2164' ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 6 [ RunTime:0.000399s ]
SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000371s ]
SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 3 [ RunTime:0.000289s ]
SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000415s ]
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:42:01' ) [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000365s ]
SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000207s ]
SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000346s ]
SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000213s ]
SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000330s ]
SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000374s ]
SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000216s ]
SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000352s ]
SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000247s ]