UPDATE `fn_book` SET `chapters` = 142 WHERE `id` = 55099 [ RunTime:0.006916s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.003218s ]
SELECT `id`,`bookid`,`title` FROM `fn_chapter` WHERE `bookid` = 55099 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC LIMIT 1 [ RunTime:0.006459s ]
SELECT `id`,`bookid`,`title`,`create_time`,`update_time` FROM `fn_chapter` WHERE `bookid` = 55099 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` DESC LIMIT 1 [ RunTime:0.004259s ]
SHOW FULL COLUMNS FROM `fn_addons_site_group` [ RunTime:0.004665s ]
SELECT `site_id`,`template_pc`,`template_mobile`,`logo`,`avatar`,`cover`,`favicon`,app_qrcode as appqr,site_name as title,site_name as admin_title,`icp`,police_icp as beian,statistics as code,`copyright`,`domain` FROM `fn_addons_site_group` WHERE `status` = 1 ORDER BY LENGTH(domain) DESC [ RunTime:0.003041s ]
SELECT `key`,`value` FROM `fn_addons_site_config` WHERE `site_id` = 1 [ RunTime:0.006774s ]
SHOW FULL COLUMNS FROM `fn_nav` [ RunTime:0.004475s ]
SELECT * FROM `fn_nav` WHERE `status` = 1 [ RunTime:0.002749s ]
SHOW FULL COLUMNS FROM `fn_addons_site_nav` [ RunTime:0.004444s ]
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.003185s ]
SELECT * FROM `fn_book` WHERE `id` = 55099 LIMIT 1 [ RunTime:0.002761s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002582s ]
SELECT * FROM `fn_book` WHERE `id` = 55099 LIMIT 1 [ RunTime:0.002754s ]
SELECT * FROM `fn_book` WHERE `id` = 55099 LIMIT 1 [ RunTime:0.002878s ]
SELECT `name` FROM `fn_category` WHERE `id` = 13 LIMIT 1 [ RunTime:0.002749s ]
SHOW FULL COLUMNS FROM `fn_config` [ RunTime:0.004807s ]
SELECT * FROM `fn_config` WHERE `name` = 'content' LIMIT 1 [ RunTime:0.002828s ]
SELECT `id`,`filename`,`cover`,`title`,`chapters`,`author`,`remark` FROM `fn_book` WHERE `status` = 1 ORDER BY `hits` DESC LIMIT 5 [ RunTime:0.806655s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 13 LIMIT 1 [ RunTime:0.004424s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 103 LIMIT 1 [ RunTime:0.002735s ]
SHOW FULL COLUMNS FROM `fn_author` [ RunTime:0.005747s ]
SELECT * FROM `fn_author` WHERE `id` = 47407 AND `status` = 1 LIMIT 1 [ RunTime:0.003334s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 55099 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `chaps` ASC [ RunTime:0.005211s ]
SELECT `id` FROM `fn_book` WHERE `status` = 1 AND `authorid` = 47407 [ RunTime:0.003646s ]
SHOW FULL COLUMNS FROM `fn_favorites` [ RunTime:0.004303s ]
SELECT COUNT(*) AS think_count FROM `fn_favorites` WHERE `pid` = 55099 LIMIT 1 [ RunTime:0.002486s ]
SHOW FULL COLUMNS FROM `fn_follow` [ RunTime:0.003997s ]
SELECT COUNT(*) AS think_count FROM `fn_follow` WHERE `from_id` = 47407 LIMIT 1 [ RunTime:0.002615s ]
SHOW FULL COLUMNS FROM `fn_chapter_content_6` [ RunTime:0.007459s ]
SELECT `info` FROM `fn_chapter_content_6` WHERE `sid` = 3485248 LIMIT 1 [ RunTime:0.021053s ]
SELECT `id`,`title`,`bookid` FROM `fn_chapter` WHERE `id` = 3485248 LIMIT 1 [ RunTime:0.006010s ]
SHOW FULL COLUMNS FROM `fn_addons_caijipro_chapter` [ RunTime:0.006495s ]
SELECT * FROM `fn_addons_caijipro_chapter` WHERE `chapterid` = 3485248 LIMIT 1 [ RunTime:0.003011s ]
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.765465s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 7 LIMIT 1 [ RunTime:0.003915s ]
SELECT `id`,`bookid`,`title`,`chaps`,`create_time` FROM `fn_chapter` WHERE `bookid` = 161809 AND `status` = 1 AND `verify` IN (0,1) ORDER BY `create_time` DESC LIMIT 1 [ RunTime:0.004552s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 8 LIMIT 1 [ RunTime:0.006524s ]
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.004545s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 103 LIMIT 1 [ RunTime:0.003258s ]
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.004678s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 1 LIMIT 1 [ RunTime:0.003950s ]
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.005169s ]
SELECT `name` FROM `fn_category` WHERE `status` = 1 AND `id` = 3 LIMIT 1 [ RunTime:0.003538s ]
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.003693s ]
SELECT `id`,`cover`,`filename`,`title`,`genre`,`subgenre` FROM `fn_book` WHERE `status` = 1 AND `subgenre` = 103 ORDER BY `hits` DESC LIMIT 10 [ RunTime:0.534518s ]
0
我要评论