SHOW FULL COLUMNS FROM `regions` [ RunTime:0.000612s ]
SELECT * FROM `regions` WHERE `slug` = 'haikou' AND `status` = '1' LIMIT 1 [ RunTime:0.000321s ]
SHOW FULL COLUMNS FROM `article_columns` [ RunTime:0.000529s ]
SELECT COUNT(*) AS think_count FROM `article_columns` WHERE `slug` = 'luohu' AND `status` = '1' [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `property_articles` [ RunTime:0.000591s ]
SELECT `id` FROM `regions` WHERE `parent_id` = '4' [ RunTime:0.000248s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('9','14','15','16') [ RunTime:0.000283s ]
SELECT `id` FROM `regions` WHERE `parent_id` IN ('12','17','61','13') [ RunTime:0.000245s ]
SHOW FULL COLUMNS FROM `article_column_links` [ RunTime:0.000516s ]
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`.`region_id` IN ('4','9','14','15','16','12','17','61','13') AND EXISTS ( SELECT * FROM `article_column_links` `acl` INNER JOIN `article_columns` `ac` ON `ac`.`id`=`acl`.`column_id` WHERE ( acl.article_id=a.id ) AND `ac`.`slug` = 'luohu' ) ORDER BY `a`.`published_at` DESC,`a`.`id` DESC LIMIT 100 [ RunTime:0.188844s ]
SELECT * FROM `regions` WHERE `parent_id` = '4' AND `status` = '1' [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `visitor_blacklist` [ RunTime:0.000674s ]
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 18:02:22' ) [ RunTime:0.000319s ]
SHOW FULL COLUMNS FROM `sites` [ RunTime:0.000598s ]
SELECT * FROM `sites` WHERE `status` = '1' ORDER BY `id` ASC [ RunTime:0.000283s ]
SHOW FULL COLUMNS FROM `site_themes` [ RunTime:0.000558s ]
SELECT * FROM `site_themes` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000260s ]
SELECT * FROM `regions` WHERE `node_level` IN ('city','county') AND `status` = '1' ORDER BY `sort_order` ASC,`id` ASC [ RunTime:0.000504s ]
SHOW FULL COLUMNS FROM `seo_settings` [ RunTime:0.000576s ]
SELECT * FROM `seo_settings` WHERE `site_id` = '1' LIMIT 1 [ RunTime:0.000276s ]
SHOW FULL COLUMNS FROM `third_party_integrations` [ RunTime:0.000554s ]
SELECT * FROM `third_party_integrations` WHERE `site_id` = '1' AND `integration_type` = 'customer_service' AND `provider` = '53kf' AND `enabled` = '1' LIMIT 1 [ RunTime:0.000314s ]
