SHOW FULL COLUMNS FROM `forums` [ RunTime:0.001133s ]
SELECT * FROM `forums` WHERE `status` = 1 ORDER BY `sort` DESC,`id` ASC [ RunTime:0.000817s ]
SHOW FULL COLUMNS FROM `posts` [ RunTime:0.000802s ]
SELECT p.forum_id, COUNT(*) as post_count FROM `posts` `p` LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id` WHERE `p`.`forum_id` IN ('1','2','3','4') AND `p`.`status` = '1' AND `u`.`status` = '1' GROUP BY `p`.`forum_id` [ RunTime:0.001204s ]
SHOW FULL COLUMNS FROM `users` [ RunTime:0.000691s ]
SELECT COUNT(*) AS think_count FROM `users` [ RunTime:0.000407s ]
SELECT COUNT(*) AS think_count FROM `posts` `p` LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id` WHERE `p`.`status` = '1' AND `u`.`status` = '1' [ RunTime:0.000466s ]
SELECT COUNT(*) AS think_count FROM `posts` `p` LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id` WHERE `p`.`status` = '1' AND `u`.`status` = '1' AND `p`.`created_at` BETWEEN '2026-06-10 00:00:00' AND '2026-06-10 23:59:59' [ RunTime:0.000586s ]
SELECT `p`.`id`,`p`.`title`,`p`.`summary`,`p`.`view_count`,`p`.`reply_count`,`p`.`like_count`,`p`.`favorite_count`,`p`.`created_at`,`p`.`last_reply_at`,`u`.`username`,up.avatar as avatar_url,f.name as forum_name FROM `posts` `p` LEFT JOIN `users` `u` ON `u`.`id`=`p`.`user_id` LEFT JOIN `user_profiles` `up` ON `up`.`user_id`=`p`.`user_id` LEFT JOIN `forums` `f` ON `f`.`id`=`p`.`forum_id` WHERE `p`.`status` = '1' AND `u`.`status` = '1' ORDER BY `p`.`is_top` DESC,`p`.`reply_count` DESC,`p`.`view_count` DESC,`p`.`id` DESC LIMIT 8 [ RunTime:0.000809s ]
SHOW FULL COLUMNS FROM `announcements` [ RunTime:0.000754s ]
SELECT * FROM `announcements` WHERE `status` = 1 ORDER BY `updated_at` DESC,`id` DESC LIMIT 3 [ RunTime:0.000583s ]
SHOW COLUMNS FROM posts LIKE 'tag' [ RunTime:0.000590s ]