SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000588s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000291s ]
SELECT `id` FROM `regions` WHERE `parent_id` = '4' [ RunTime:0.000240s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('9','14','15','16') [ RunTime:0.000251s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('12','17','61','13') [ RunTime:0.000195s ]
SHOW FULL COLUMNS FROM `properties` [ RunTime:0.000572s ]
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`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `p`.`is_pinned` DESC,`p`.`sort_order` DESC,`p`.`id` DESC LIMIT 6 [ RunTime:0.000894s ]
SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000430s ]
SELECT `a`.*,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`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 5 [ RunTime:0.017374s ]
SHOW FULL COLUMNS FROM `article_columns` [ RunTime:0.000403s ]
SELECT * FROM `article_columns` WHERE `status` = '1' ORDER BY `sort_order` DESC,`id` ASC [ RunTime:0.000263s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '8' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.000798s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '5' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.196435s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '2' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.009898s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '7' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.007514s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '6' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.083735s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '3' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.012004s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '1' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.026617s ]
SELECT `a`.*,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` INNER JOIN `article_column_links` `acl` ON `acl`.`article_id`=`a`.`id` WHERE `a`.`status` = 'published' AND `acl`.`column_id` = '4' AND `a`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `a`.`is_pinned` DESC,`a`.`published_at` DESC,`a`.`id` DESC LIMIT 3 [ RunTime:0.005668s ]
SHOW FULL COLUMNS FROM `property_promotions` [ RunTime:0.001134s ]
SELECT `g`.*,p.name property_name,p.legacy_id property_legacy_id,`p`.`average_price`,p.cover_image property_cover,r.name region_name FROM `property_promotions` `g` INNER JOIN `properties` `p` ON `p`.`id`=`g`.`property_id` LEFT JOIN `regions` `r` ON `r`.`id`=`p`.`region_id` WHERE `g`.`status` = 'published' AND `p`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `g`.`sort_order` DESC,`g`.`id` DESC LIMIT 6 [ RunTime:0.000608s ]
SHOW FULL COLUMNS FROM `property_questions` [ RunTime:0.000440s ]
SELECT `q`.*,p.name property_name,p.legacy_id property_legacy_id FROM `property_questions` `q` INNER JOIN `properties` `p` ON `p`.`id`=`q`.`property_id` WHERE `q`.`status` = 'published' AND `p`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `q`.`asked_at` DESC,`q`.`id` DESC LIMIT 6 [ RunTime:0.002032s ]
SELECT `id`,`name` FROM `properties` WHERE `status` = '1' AND `region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `is_pinned` DESC,`sort_order` DESC,`id` DESC LIMIT 100 [ RunTime:0.001254s ]
SELECT * FROM `regions` WHERE `parent_id` = '4' AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `advisors` [ RunTime:0.000429s ]
SELECT * FROM `advisors` WHERE `status` = '1' AND `city_name` IN ('海口','海南') ORDER BY `sort_order` DESC,`id` ASC LIMIT 4 [ RunTime:0.000347s ]
SELECT `id` FROM `regions` WHERE `parent_id` = '4' [ RunTime:0.000260s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('9','14','15','16') [ RunTime:0.000213s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('12','17','61','13') [ RunTime:0.000197s ]
SHOW FULL COLUMNS FROM `property_videos` [ RunTime:0.000409s ]
SELECT `v`.`id`,`v`.`title`,`v`.`video_url`,`v`.`cover_image`,`v`.`sort_order`,p.id property_id,p.legacy_id property_legacy_id,p.name property_name,p.cover_image property_cover,r.name region_name FROM `property_videos` `v` INNER JOIN `properties` `p` ON `p`.`id`=`v`.`property_id` LEFT JOIN `regions` `r` ON `r`.`id`=`p`.`region_id` WHERE `v`.`status` = '1' AND `p`.`status` = '1' AND `v`.`video_url` <> '' AND `p`.`region_id` IN ('4','9','14','15','16','12','17','61','13') ORDER BY `v`.`sort_order` DESC,`v`.`id` DESC LIMIT 3 [ RunTime:0.000867s ]
SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000373s ]
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-14 14:39:46' ) [ RunTime:0.000234s ]
SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000394s ]
SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000217s ]
SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000383s ]
SELECT * FROM `site_themes` WHERE `site_id` = '2' LIMIT 1 [ RunTime:0.000203s ]
SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000334s ]
SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000380s ]
SELECT * FROM `seo_settings` WHERE `site_id` = '2' LIMIT 1 [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000391s ]
SELECT * FROM `third_party_integrations` WHERE `site_id` = '2' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000231s ]
