UPDATE `fn_book` SET `chapters` = 117 WHERE `id` = 98 [ RunTime:0.004941s ]
SELECT `name` FROM `fn_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.002442s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 98 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.003395s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 98 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.003566s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.004907s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.002414s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.003608s ]
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.003388s ]
SELECT * FROM `fn_book` WHERE `id` = 98 LIMIT 1 [ RunTime:0.003087s ]
SELECT `name` FROM `fn_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.002284s ]
SELECT * FROM `fn_book` WHERE `id` = 98 LIMIT 1 [ RunTime:0.002512s ]
SELECT * FROM `fn_book` WHERE `id` = 98 LIMIT 1 [ RunTime:0.002182s ]
SELECT `name` FROM `fn_category` WHERE `id` = 8 LIMIT 1 [ RunTime:0.002128s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.413536s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.003359s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.004344s ]
SELECT * FROM `fn_author` WHERE `id` = 147440 AND `status` = 1 LIMIT 1 [ RunTime:0.003968s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 98 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.003540s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 147440 [ RunTime:0.002372s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.003383s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` IN (78,98) LIMIT 1 [ RunTime:0.002200s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.003142s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 147440 LIMIT 1 [ RunTime:0.002204s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_1` [ RunTime:0.006133s ]
SELECT `info` FROM `fn_chapter_content_1` WHERE `sid` = 177718 LIMIT 1 [ RunTime:0.004032s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 177718 LIMIT 1 [ RunTime:0.003047s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.004548s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 177718 LIMIT 1 [ RunTime:0.002423s ]
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.495671s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.003242s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 125033 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002721s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 104 LIMIT 1 [ RunTime:0.002370s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 125032 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002269s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 6 LIMIT 1 [ RunTime:0.002583s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 125031 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002718s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002642s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 125030 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002613s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.002265s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 125029 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002410s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `genre` = 8 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.300307s ]
1
我要评论