SHOW FULL COLUMNS FROM `categories` [ RunTime:0.006343s ]
SELECT id,name FROM `categories` WHERE `is_deleted` = 0 [ RunTime:0.000479s ]
SHOW FULL COLUMNS FROM `articles` [ RunTime:0.001455s ]
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.000812s ]
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.000561s ]
UPDATE `articles` SET `view_count` = `view_count` + 1 WHERE `id` = 14 [ RunTime:0.007640s ]
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` = '14' LIMIT 1 [ RunTime:0.000597s ]
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` < '14' ORDER BY `articles`.`id` DESC LIMIT 1 [ RunTime:0.000460s ]
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` > '14' LIMIT 1 [ RunTime:0.000290s ]
SHOW FULL COLUMNS FROM `comments` [ RunTime:0.001457s ]
SELECT `users`.`avatar`,`users`.`username`,`comments`.`created_at`,`comments`.`content` FROM `comments` LEFT JOIN `users` ON `users`.`id`=`comments`.`user_id` WHERE `article_id` = 14 AND `comments`.`is_deleted` = '0' ORDER BY `comments`.`created_at` DESC LIMIT 5 [ RunTime:0.000394s ]
SHOW FULL COLUMNS FROM `tags` [ RunTime:0.000872s ]
SELECT `t`.`id`,`t`.`name` FROM `tags` `t` LEFT JOIN `article_tag` ON `article_tag`.`tag_id`=`t`.`id` WHERE `article_tag`.`article_id` = '14' [ RunTime:0.000321s ]
22025-02-13 12:58:14
32025-02-11 19:12:08
