SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000519s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000194s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000385s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000150s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000167s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000365s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000418s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000384s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000492s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1770418811 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 >= 1770418811 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1770418811 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001217s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000198s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000202s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000211s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000274s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000303s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000332s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000295s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000326s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000329s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 4 ) [ RunTime:0.000258s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 295 [ RunTime:0.004442s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000486s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 93 LIMIT 1 [ RunTime:0.000206s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 93 [ RunTime:0.003759s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 92 LIMIT 1 [ RunTime:0.000222s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 92 [ RunTime:0.003879s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 24 LIMIT 1 [ RunTime:0.000222s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 24 [ RunTime:0.003819s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 94 LIMIT 1 [ RunTime:0.000214s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 94 [ RunTime:0.003707s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 25 LIMIT 1 [ RunTime:0.000223s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 25 [ RunTime:0.003697s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 26 LIMIT 1 [ RunTime:0.000205s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 26 [ RunTime:0.003477s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 277 LIMIT 1 [ RunTime:0.000234s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 277 [ RunTime:0.003595s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 217 LIMIT 1 [ RunTime:0.000299s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 217 [ RunTime:0.004046s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 144 LIMIT 1 [ RunTime:0.000290s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 144 [ RunTime:0.003998s ]