SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000544s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000228s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000389s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000161s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000162s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000462s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000327s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000419s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000563s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1780754327 THEN 1 ELSE 0 END AS is_top FROM `fn_fenlei_info` `me` LEFT JOIN `fn_fenlei_info_category` `c` ON `me`.`cid`=`c`.`id` LEFT JOIN `fn_fenlei_user` `u` ON `me`.`uid`=`u`.`uid` WHERE ( me.status = 1 AND me.display = 1 AND me.pause = 0 AND me.end_time >= 1780754327 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1780754327 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001436s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000191s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000186s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000253s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000197s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000227s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000242s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000246s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000253s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000239s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,5,4,10) ) [ RunTime:0.000259s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000629s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 518 LIMIT 1 [ RunTime:0.000189s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 518 [ RunTime:0.004192s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 318 LIMIT 1 [ RunTime:0.000276s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 318 [ RunTime:0.003818s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 514 [ RunTime:0.003772s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_odd` [ RunTime:0.000562s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 517 LIMIT 1 [ RunTime:0.000186s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 517 [ RunTime:0.003908s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 494 LIMIT 1 [ RunTime:0.000202s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 494 [ RunTime:0.004723s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 498 LIMIT 1 [ RunTime:0.000202s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 498 [ RunTime:0.004284s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 497 LIMIT 1 [ RunTime:0.000190s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 497 [ RunTime:0.008746s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 492 LIMIT 1 [ RunTime:0.000212s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 492 [ RunTime:0.003545s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 490 LIMIT 1 [ RunTime:0.000194s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 490 [ RunTime:0.003533s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 496 LIMIT 1 [ RunTime:0.000202s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 496 [ RunTime:0.003543s ]