SHOW FULL COLUMNS FROM `categories` [ RunTime:0.001565s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000272s ]
SHOW FULL COLUMNS FROM `articles` [ RunTime:0.000954s ]
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.000363s ]
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.000308s ]
UPDATE `articles` SET `view_count` = `view_count` + 1 WHERE `id` = 16 [ RunTime:0.003484s ]
SELECT `articles`.`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`.`id` = '16' LIMIT 1 [ RunTime:0.000402s ]
SELECT `articles`.`id`,`articles`.`created_at`,`articles`.`title`,`files`.`thumb_path` FROM `articles` `articles` LEFT JOIN `files` ON `articles`.`thumb_file_id`=`files`.`id` WHERE `articles`.`status` = '1' AND `articles`.`id` < '16' ORDER BY `articles`.`id` DESC LIMIT 1 [ RunTime:0.000397s ]
SELECT `articles`.`id`,`articles`.`created_at`,`articles`.`title`,`files`.`thumb_path` FROM `articles` `articles` LEFT JOIN `files` ON `articles`.`thumb_file_id`=`files`.`id` WHERE `articles`.`status` = '1' AND `articles`.`id` > '16' LIMIT 1 [ RunTime:0.000247s ]
SHOW FULL COLUMNS FROM `comments` [ RunTime:0.001504s ]
SELECT `users`.`avatar`,`users`.`username`,`comments`.`created_at`,`comments`.`content` FROM `comments` LEFT JOIN `users` ON `users`.`id`=`comments`.`user_id` WHERE `article_id` = 16 AND `comments`.`is_deleted` = '0' ORDER BY `comments`.`created_at` DESC LIMIT 5 [ RunTime:0.000476s ]
SHOW FULL COLUMNS FROM `tags` [ RunTime:0.001098s ]
SELECT `t`.`id`,`t`.`name` FROM `tags` `t` LEFT JOIN `article_tag` ON `article_tag`.`tag_id`=`t`.`id` WHERE `article_tag`.`article_id` = '16' [ RunTime:0.000496s ]
32025-02-11 19:12:08
