SHOW FULL COLUMNS FROM `menus` [ RunTime:0.002652s ]
SELECT * FROM `menus` WHERE `status` = 1 AND `show_in_nav` = 1 ORDER BY `sort` ASC [ RunTime:0.000678s ]
SHOW FULL COLUMNS FROM `books` [ RunTime:0.002868s ]
SELECT * FROM `books` WHERE `id` = 2 AND `status` = 1 LIMIT 1 [ RunTime:0.000748s ]
SHOW FULL COLUMNS FROM `categories` [ RunTime:0.002363s ]
SELECT * FROM `categories` WHERE ( `id` = 6 ) ORDER BY `id` DESC LIMIT 1 [ RunTime:0.000696s ]
SHOW FULL COLUMNS FROM `tags` [ RunTime:0.002373s ]
SHOW FULL COLUMNS FROM `book_tags` [ RunTime:0.002300s ]
SELECT `tags`.*,`pivot`.`id` AS `pivot__id`,`pivot`.`book_id` AS `pivot__book_id`,`pivot`.`tag_id` AS `pivot__tag_id`,`pivot`.`create_time` AS `pivot__create_time` FROM `tags` INNER JOIN `book_tags` `pivot` ON `pivot`.`tag_id`=`tags`.`id` WHERE ( `pivot`.`book_id` = '2' ) ORDER BY `id` DESC LIMIT 1000 [ RunTime:0.000699s ]
UPDATE `books` SET `view_count` = `view_count` + 1 , `update_time` = '2026-05-01 00:25:21.013261' WHERE `id` = 2 [ RunTime:0.006359s ]
SELECT * FROM `books` WHERE `category_id` = 6 AND `id` <> 2 AND `status` = 1 ORDER BY `score` DESC LIMIT 6 [ RunTime:0.000838s ]