SHOW FULL COLUMNS FROM `categories` [ RunTime:0.003938s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000466s ]
SHOW FULL COLUMNS FROM `articles` [ RunTime:0.001108s ]
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.000615s ]
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.000672s ]
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` = '12' [ RunTime:0.000584s ]
SELECT `articles`.`id`,`articles`.`category_id`,`articles`.`title`,`articles`.`content`,`articles`.`created_at`,`articles`.`thumb_file_id`,`articles`.`view_count`,`files`.`path`,`categories`.`name`,`users`.`username` 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` = '12' LIMIT 0,9 [ RunTime:0.000397s ]
12025-02-16 16:47:28
22025-02-13 12:58:14
32025-02-11 19:12:08
