SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.009705s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 179439 LIMIT 1 [ RunTime:0.680214s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 410628 LIMIT 1 [ RunTime:0.017313s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.007069s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.004092s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_chapter` [ RunTime:0.010966s ]
SELECT * FROM `fn_addons_collect_chapter` WHERE `book_id` = 179439 ORDER BY `serial` DESC LIMIT 10 [ RunTime:0.007465s ]
SELECT COUNT(*) AS think_count FROM `fn_addons_collect_chapter` WHERE `book_id` = 179439 LIMIT 1 [ RunTime:0.003828s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.004700s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 179439 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.011912s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 179439 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.008324s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.009022s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.004137s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.006691s ]
SELECT * FROM `fn_addons_site_nav` WHERE `status` = 1 AND `site_id` = 1 AND `nav_id` IN (1,2,3,4,5) ORDER BY `sort` DESC,`create_time` DESC [ RunTime:0.005135s ]
SELECT * FROM `fn_book` WHERE `id` = 179439 LIMIT 1 [ RunTime:0.005460s ]
SELECT `name` FROM `fn_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002996s ]
SELECT * FROM `fn_book` WHERE `id` = 179439 LIMIT 1 [ RunTime:0.004217s ]
SELECT * FROM `fn_book` WHERE `id` = 179439 LIMIT 1 [ RunTime:0.002689s ]
SELECT `name` FROM `fn_category` WHERE `id` = 3 LIMIT 1 [ RunTime:0.002420s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:1.504383s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.004026s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.005889s ]
SELECT * FROM `fn_author` WHERE `id` = 97986 AND `status` = 1 LIMIT 1 [ RunTime:0.003427s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 179439 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.007088s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 97986 [ RunTime:0.003067s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.004439s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 179439 LIMIT 1 [ RunTime:0.002649s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.003901s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 97986 LIMIT 1 [ RunTime:0.002634s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_0` [ RunTime:0.007125s ]
SELECT `info` FROM `fn_chapter_content_0` WHERE `sid` = 4415109 LIMIT 1 [ RunTime:0.003112s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 4415109 LIMIT 1 [ RunTime:0.002584s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.008595s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 4415109 LIMIT 1 [ RunTime:0.004780s ]
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:1.415080s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 4 LIMIT 1 [ RunTime:0.002327s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 309224 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002783s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.006477s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 309223 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003654s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 1 LIMIT 1 [ RunTime:0.003369s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 309222 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003791s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 1 LIMIT 1 [ RunTime:0.003238s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 309221 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003676s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.002627s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 309220 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002757s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `genre` = 3 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.932902s ]
2
我要评论