SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000582s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000196s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000381s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000152s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000169s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000387s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000297s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000372s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000859s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1775518171 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 >= 1775518171 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1775518171 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001537s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000196s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000192s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000206s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000230s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000208s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000205s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000183s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000191s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000181s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 10 ) [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000603s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 297 LIMIT 1 [ RunTime:0.000204s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 297 [ RunTime:0.004191s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 318 LIMIT 1 [ RunTime:0.000214s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 318 [ RunTime:0.010849s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_odd` [ RunTime:0.000675s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 317 LIMIT 1 [ RunTime:0.000205s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 317 [ RunTime:0.018011s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 3 WHERE `id` = 313 [ RunTime:0.003961s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_resume` [ RunTime:0.000607s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 384 LIMIT 1 [ RunTime:0.000211s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 384 [ RunTime:0.003719s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 355 LIMIT 1 [ RunTime:0.000201s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 355 [ RunTime:0.005029s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 344 LIMIT 1 [ RunTime:0.000210s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 344 [ RunTime:0.003854s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 346 LIMIT 1 [ RunTime:0.000207s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 346 [ RunTime:0.003661s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 347 LIMIT 1 [ RunTime:0.000188s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 347 [ RunTime:0.003646s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 339 LIMIT 1 [ RunTime:0.000196s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 339 [ RunTime:0.003898s ]