SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000508s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 1 LIMIT 1 [ RunTime:0.000216s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `pid` = 1 [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000432s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000146s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000134s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000448s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000266s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000170s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000260s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000135s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000129s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000117s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000125s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (1,2) ) [ RunTime:0.000131s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000410s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000203s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000568s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1770102967 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 >= 1770102967 AND me.cid in(2,17,4,1) ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1770102967 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.002116s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000184s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000350s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000322s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000360s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000407s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000331s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000356s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000551s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000388s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000746s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1136 LIMIT 1 [ RunTime:0.000232s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 11 WHERE `id` = 1136 [ RunTime:0.005905s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1134 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 19 WHERE `id` = 1134 [ RunTime:0.005638s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1125 LIMIT 1 [ RunTime:0.000320s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 5 WHERE `id` = 1125 [ RunTime:0.005719s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_odd` [ RunTime:0.000812s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 222 LIMIT 1 [ RunTime:0.000253s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 11 WHERE `id` = 222 [ RunTime:0.005822s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_resume` [ RunTime:0.000760s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1117 LIMIT 1 [ RunTime:0.000208s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 16 WHERE `id` = 1117 [ RunTime:0.005345s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1112 LIMIT 1 [ RunTime:0.000337s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 13 WHERE `id` = 1112 [ RunTime:0.006349s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1109 LIMIT 1 [ RunTime:0.000375s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 20 WHERE `id` = 1109 [ RunTime:0.005295s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1105 LIMIT 1 [ RunTime:0.000305s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 7 WHERE `id` = 1105 [ RunTime:0.005358s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1099 LIMIT 1 [ RunTime:0.000357s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 20 WHERE `id` = 1099 [ RunTime:0.005081s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1036 LIMIT 1 [ RunTime:0.000368s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 15 WHERE `id` = 1036 [ RunTime:0.004838s ]