SHOW FULL COLUMNS FROM `fn_addons_site_route` [ RunTime:0.003000s ]
SELECT `id`,`rule`,`group`,`name` FROM `fn_addons_site_route` WHERE `status` = 1 AND `site_id` = 1 [ RunTime:0.002321s ]
SHOW FULL COLUMNS FROM `fn_category` [ RunTime:0.004730s ]
SHOW FULL COLUMNS FROM `fn_addons_site_config` [ RunTime:0.003143s ]
SELECT `key`,`value` FROM `fn_addons_site_config` WHERE `site_id` = 1 [ RunTime:0.002836s ]
SHOW FULL COLUMNS FROM `fn_book` [ RunTime:0.004969s ]
SELECT * FROM `fn_book` WHERE `filename` = 'lingjingxingzhe' LIMIT 1 [ RunTime:0.002774s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_novel` [ RunTime:0.004842s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `book_id` = 159740 LIMIT 1 [ RunTime:0.150992s ]
SELECT * FROM `fn_addons_collect_novel` WHERE `id` = 188185 LIMIT 1 [ RunTime:0.003471s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_rule` [ RunTime:0.003841s ]
SELECT * FROM `fn_addons_collect_rule` WHERE `id` = 3 AND `status` = 1 LIMIT 1 [ RunTime:0.003099s ]
SHOW FULL COLUMNS FROM `fn_addons_collect_chapter` [ RunTime:0.004733s ]
SELECT * FROM `fn_addons_collect_chapter` WHERE `book_id` = 159740 ORDER BY `serial` DESC LIMIT 10 [ RunTime:0.006135s ]
SELECT COUNT(*) AS think_count FROM `fn_addons_collect_chapter` WHERE `book_id` = 159740 LIMIT 1 [ RunTime:0.003440s ]
SELECT `name` FROM `fn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002366s ]
SHOW FULL COLUMNS FROM `fn_chapter` [ RunTime:0.003774s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 159740 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.006367s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 159740 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.007732s ]
SELECT `key`,`value` FROM `fn_addons_site_config` WHERE `site_id` = 1 [ RunTime:0.003910s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.005341s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.002734s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.004239s ]
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.004102s ]
SELECT * FROM `fn_book` WHERE `id` = 159740 LIMIT 1 [ RunTime:0.002346s ]
SELECT `name` FROM `fn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002406s ]
SELECT * FROM `fn_book` WHERE `id` = 159740 LIMIT 1 [ RunTime:0.002352s ]
SELECT * FROM `fn_book` WHERE `id` = 159740 LIMIT 1 [ RunTime:0.002893s ]
SELECT `name` FROM `fn_category` WHERE `id` = 6 LIMIT 1 [ RunTime:0.002852s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.463386s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 6 LIMIT 1 [ RunTime:0.003036s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.004214s ]
SELECT * FROM `fn_author` WHERE `id` = 146809 AND `status` = 1 LIMIT 1 [ RunTime:0.002387s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159740 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.012630s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 146809 [ RunTime:0.003706s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.003721s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 159740 LIMIT 1 [ RunTime:0.002211s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.003302s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 146809 LIMIT 1 [ RunTime:0.002085s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_0` [ RunTime:0.002995s ]
SELECT `info` FROM `fn_chapter_content_0` WHERE `sid` = 4532847 LIMIT 1 [ RunTime:0.002246s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 4532847 LIMIT 1 [ RunTime:0.002045s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.005794s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 4532847 LIMIT 1 [ RunTime:0.002532s ]
SELECT `id`,`genre`,`subgenre`,title as booktitle,`filename`,`authorid`,`update_time`,`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.452770s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 6 LIMIT 1 [ RunTime:0.002656s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159740 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.005123s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.002547s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159741 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.010556s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 4 LIMIT 1 [ RunTime:0.002849s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159742 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002456s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 4 LIMIT 1 [ RunTime:0.002201s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159705 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002659s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 101 LIMIT 1 [ RunTime:0.002319s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 159711 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.002839s ]
SELECT `hits_time` FROM `fn_book` WHERE `id` = 159740 LIMIT 1 [ RunTime:0.002610s ]
UPDATE `fn_book` SET `hits` = `hits` + 1 , `hits_time` = 1765444557 WHERE `id` = 159740 [ RunTime:0.004111s ]
4
我要评论