SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.004076s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 85226 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.003129s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 85226 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.003180s ]
SELECT * FROM `fn_book` WHERE `id` = 85226 LIMIT 1 [ RunTime:0.003173s ]
SELECT `name` FROM `fn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002590s ]
SELECT * FROM `fn_book` WHERE `id` = 85226 LIMIT 1 [ RunTime:0.003507s ]
SELECT * FROM `fn_book` WHERE `id` = 85226 LIMIT 1 [ RunTime:0.002699s ]
SELECT `name` FROM `fn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.006082s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 6 LIMIT 1 [ RunTime:0.003655s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.004608s ]
SELECT * FROM `fn_author` WHERE `id` = 71306 AND `status` = 1 LIMIT 1 [ RunTime:0.002654s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 85226 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.004161s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 71306 [ RunTime:0.003072s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.004832s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 85226 LIMIT 1 [ RunTime:0.002813s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.006063s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 71306 LIMIT 1 [ RunTime:0.002272s ]
SELECT `id`,`genre`,`subgenre`,title as booktitle,`filename`,`authorid`,`update_time`,`remark`,`create_time`,`words`,`author`,`cover` FROM `fn_book` WHERE `status` = 1 ORDER BY CASE WHEN update_time > 0 THEN update_time ELSE create_time END DESC LIMIT 5 [ RunTime:0.337466s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002497s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 93493 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002217s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002009s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 93492 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002161s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 104 LIMIT 1 [ RunTime:0.002080s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 93491 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002153s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 6 LIMIT 1 [ RunTime:0.002197s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 93490 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002461s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002511s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 93489 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.006984s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `genre` = 6 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.244710s ]
我要评论