SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.006566s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 177747 LIMIT 1 [ RunTime:1.014990s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 408922 LIMIT 1 [ RunTime:0.004138s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.004900s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 5 AND `status` = 1 LIMIT 1 [ RunTime:0.003628s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_chapter` [ RunTime:0.006396s ]
SELECT * FROM `fn_addons_collect_chapter` WHERE `book_id` = 177747 ORDER BY `serial` DESC LIMIT 10 [ RunTime:0.005104s ]
SELECT COUNT(*) AS think_count FROM `fn_addons_collect_chapter` WHERE `book_id` = 177747 LIMIT 1 [ RunTime:0.003794s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.017886s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 177747 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.012959s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 177747 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.003393s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.003701s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.002658s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.004371s ]
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.003091s ]
SELECT * FROM `fn_book` WHERE `id` = 177747 LIMIT 1 [ RunTime:0.002989s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002448s ]
SELECT * FROM `fn_book` WHERE `id` = 177747 LIMIT 1 [ RunTime:0.002484s ]
SELECT * FROM `fn_book` WHERE `id` = 177747 LIMIT 1 [ RunTime:0.002248s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002165s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:1.474680s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 13 LIMIT 1 [ RunTime:0.004376s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 105 LIMIT 1 [ RunTime:0.002579s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.005373s ]
SELECT * FROM `fn_author` WHERE `id` = 139367 AND `status` = 1 LIMIT 1 [ RunTime:0.002998s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 177747 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.005883s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 139367 [ RunTime:0.004202s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.004287s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` IN (122362,177747,276559) LIMIT 1 [ RunTime:0.002627s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.004002s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 139367 LIMIT 1 [ RunTime:0.002768s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_0` [ RunTime:0.004157s ]
SELECT `info` FROM `fn_chapter_content_0` WHERE `sid` = 4320864 LIMIT 1 [ RunTime:0.002712s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 4320864 LIMIT 1 [ RunTime:0.002508s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.006031s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 4320864 LIMIT 1 [ RunTime:0.002609s ]
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:2.507954s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.008775s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 312411 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.007295s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.003953s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 312410 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003222s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.008114s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 312409 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.004559s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002773s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 312408 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003869s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 1 LIMIT 1 [ RunTime:0.002682s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 312407 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002877s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `subgenre` = 105 ORDER BY `hits` DESC LIMIT 10 [ RunTime:1.938230s ]
2
我要评论