SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.008950s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 172238 LIMIT 1 [ RunTime:0.235849s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 172325 LIMIT 1 [ RunTime:0.005098s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.018412s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.003725s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.003889s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.006774s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 172238 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.012674s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 172238 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.003689s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.007549s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.003006s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.009093s ]
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.008147s ]
SELECT * FROM `fn_book` WHERE `id` = 172238 LIMIT 1 [ RunTime:0.007927s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.004597s ]
SELECT * FROM `fn_book` WHERE `id` = 172238 LIMIT 1 [ RunTime:0.003805s ]
SELECT * FROM `fn_book` WHERE `id` = 172238 LIMIT 1 [ RunTime:0.009336s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.009993s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.790161s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 13 LIMIT 1 [ RunTime:0.004318s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.003205s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.007134s ]
SELECT * FROM `fn_author` WHERE `id` = 138707 AND `status` = 1 LIMIT 1 [ RunTime:0.005939s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172238 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.004892s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 138707 [ RunTime:0.003835s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.005959s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 172238 LIMIT 1 [ RunTime:0.003604s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.006506s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 138707 LIMIT 1 [ RunTime:0.003621s ]
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.739345s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002874s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 173938 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003802s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.003208s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 173937 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003318s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 105 LIMIT 1 [ RunTime:0.002811s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 173936 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002689s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 7 LIMIT 1 [ RunTime:0.002257s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 173935 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002580s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 103 LIMIT 1 [ RunTime:0.002676s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 173934 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002896s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `subgenre` = 101 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.615977s ]
0
我要评论