SHOW FULL COLUMNS FROM `fn_addons_site_route` [ RunTime:0.003430s ]
SELECT `id`,`rule`,`group`,`name` FROM `fn_addons_site_route` WHERE `status` = 1 AND `site_id` = 1 [ RunTime:0.002879s ]
SHOW FULL COLUMNS FROM `fn_category` [ RunTime:0.005812s ]
SHOW FULL COLUMNS FROM `fn_book` [ RunTime:0.007051s ]
SELECT * FROM `fn_book` WHERE `filename` = 'chuandaobalingwozidaijinlixitong' LIMIT 1 [ RunTime:0.004016s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.005634s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 110059 LIMIT 1 [ RunTime:0.116307s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 110074 LIMIT 1 [ RunTime:0.004253s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.008099s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.004701s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_chapter` [ RunTime:0.006397s ]
SELECT * FROM `fn_addons_collect_chapter` WHERE `book_id` = 110059 ORDER BY `serial` DESC LIMIT 10 [ RunTime:0.003746s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 110074 LIMIT 1 [ RunTime:0.003330s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.003471s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002720s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.004451s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 110059 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.005738s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 110059 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.004175s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.006715s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.003131s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.006552s ]
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.004900s ]
SELECT * FROM `fn_book` WHERE `id` = 110059 LIMIT 1 [ RunTime:0.005571s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.003064s ]
SELECT * FROM `fn_book` WHERE `id` = 110059 LIMIT 1 [ RunTime:0.003075s ]
SELECT * FROM `fn_book` WHERE `id` = 110059 LIMIT 1 [ RunTime:0.003089s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002804s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.671719s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 13 LIMIT 1 [ RunTime:0.004339s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 102 LIMIT 1 [ RunTime:0.002713s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.004653s ]
SELECT * FROM `fn_author` WHERE `id` = 89397 AND `status` = 1 LIMIT 1 [ RunTime:0.002455s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 110059 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.004061s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 89397 [ RunTime:0.002889s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.004913s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 110059 LIMIT 1 [ RunTime:0.003476s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.004701s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 89397 LIMIT 1 [ RunTime:0.002691s ]
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.694419s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.004147s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172478 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003907s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 103 LIMIT 1 [ RunTime:0.004367s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172477 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.004203s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 1 LIMIT 1 [ RunTime:0.005244s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172476 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.005982s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.004486s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172475 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003694s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.002798s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 172474 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.004647s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `subgenre` = 102 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.515585s ]
0
我要评论