SHOW FULL COLUMNS FROM `categories` [ RunTime:0.001893s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000249s ]
SHOW FULL COLUMNS FROM `articles` [ RunTime:0.001167s ]
SELECT `articles`.`id`,`title`,`content`,`articles`.`updated_at`,`files`.`path`,`files`.`thumb_path`,`articles`.`created_at` FROM `articles` LEFT JOIN `files` ON `files`.`id`=`articles`.`thumb_file_id` ORDER BY `articles`.`created_at` DESC LIMIT 5 [ RunTime:0.000561s ]
SELECT c.id,c.name,count(a.id) as a_count FROM `categories` `c` LEFT JOIN `articles` `a` ON `a`.`category_id`=`c`.`id` WHERE `a`.`is_deleted` = '0' GROUP BY `c`.`id`,`c`.`name` [ RunTime:0.000446s ]
SELECT COUNT(*) AS think_count FROM `articles` `articles` LEFT JOIN `categories` ON `articles`.`category_id`=`categories`.`id` LEFT JOIN `files` ON `articles`.`thumb_file_id`=`files`.`id` LEFT JOIN `users` ON `articles`.`user_id`=`users`.`id` WHERE `articles`.`category_id` = '14' [ RunTime:0.000480s ]
12025-02-16 16:47:28
22025-02-13 12:58:14
32025-02-11 19:12:08
