UPDATE `fn_book` SET `chapters` = 203 WHERE `id` = 96627 [ RunTime:0.003602s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 96627 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.002867s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 96627 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.003059s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.003651s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.002735s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.008494s ]
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.002352s ]
SELECT * FROM `fn_book` WHERE `id` = 96627 LIMIT 1 [ RunTime:0.003085s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002603s ]
SELECT * FROM `fn_book` WHERE `id` = 96627 LIMIT 1 [ RunTime:0.002126s ]
SELECT * FROM `fn_book` WHERE `id` = 96627 LIMIT 1 [ RunTime:0.002080s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002014s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.317876s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 13 LIMIT 1 [ RunTime:0.002163s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.002046s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.003852s ]
SELECT * FROM `fn_author` WHERE `id` = 79897 AND `status` = 1 LIMIT 1 [ RunTime:0.002239s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 96627 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.003713s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 79897 [ RunTime:0.002224s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.003462s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 96627 LIMIT 1 [ RunTime:0.002110s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.004193s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 79897 LIMIT 1 [ RunTime:0.002676s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_1` [ RunTime:0.003820s ]
SELECT `info` FROM `fn_chapter_content_1` WHERE `sid` = 545468 LIMIT 1 [ RunTime:0.002072s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 545468 LIMIT 1 [ RunTime:0.002657s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.003465s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 545468 LIMIT 1 [ RunTime:0.002304s ]
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.333671s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.002808s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 103948 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.003029s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 2 LIMIT 1 [ RunTime:0.002994s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 103947 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002886s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 102 LIMIT 1 [ RunTime:0.002718s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 103946 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002549s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.002107s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 103945 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002158s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 102 LIMIT 1 [ RunTime:0.002021s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 103944 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002174s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `genre` = 13 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.319832s ]
0
我要评论