SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.009486s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 97122 LIMIT 1 [ RunTime:0.512307s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 97137 LIMIT 1 [ RunTime:0.003002s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.004751s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.003154s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.010561s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 97122 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.003062s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 97122 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.002980s ]
SELECT * FROM `fn_book` WHERE `id` = 97122 LIMIT 1 [ RunTime:0.010495s ]
SELECT `name` FROM `fn_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.002739s ]
SELECT * FROM `fn_book` WHERE `id` = 97122 LIMIT 1 [ RunTime:0.002617s ]
SELECT * FROM `fn_book` WHERE `id` = 97122 LIMIT 1 [ RunTime:0.002712s ]
SELECT `name` FROM `fn_category` WHERE `id` = 2 LIMIT 1 [ RunTime:0.002485s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.007128s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.005666s ]
SELECT * FROM `fn_author` WHERE `id` = 80267 AND `status` = 1 LIMIT 1 [ RunTime:0.002822s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 97122 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.004291s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 80267 [ RunTime:0.004527s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.008941s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 97122 LIMIT 1 [ RunTime:0.005886s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.009167s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 80267 LIMIT 1 [ RunTime:0.002431s ]
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:3.473834s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.011807s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 300604 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003245s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 7 LIMIT 1 [ RunTime:0.002893s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 300603 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.005964s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.004118s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 300602 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003911s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 102 LIMIT 1 [ RunTime:0.003515s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 300601 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.004487s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.003968s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 300600 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.005445s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `genre` = 2 ORDER BY `hits` DESC LIMIT 10 [ RunTime:1.501779s ]
0
我要评论