SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.001005s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000265s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000540s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000230s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000261s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000814s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000541s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000893s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000401s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.001100s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1784690996 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 >= 1784690996 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1784690996 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001336s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000320s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000546s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000378s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000395s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 12 ) [ RunTime:0.000411s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000591s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000481s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000446s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000617s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000480s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.001275s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 41 LIMIT 1 [ RunTime:0.000486s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 41 [ RunTime:0.008197s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 61 LIMIT 1 [ RunTime:0.000659s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 61 [ RunTime:0.006792s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 63 [ RunTime:0.007627s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 62 LIMIT 1 [ RunTime:0.000442s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 62 [ RunTime:0.006403s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 28 [ RunTime:0.005819s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 52 [ RunTime:0.005817s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 51 [ RunTime:0.006245s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 50 LIMIT 1 [ RunTime:0.000494s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 50 [ RunTime:0.006034s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 49 LIMIT 1 [ RunTime:0.000517s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 49 [ RunTime:0.006006s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 47 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 47 [ RunTime:0.005806s ]