SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000547s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000267s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000377s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000169s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000420s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000354s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000710s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000294s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000566s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1788825971 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 >= 1788825971 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1788825971 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001844s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 6 ) [ RunTime:0.000222s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 7 ) [ RunTime:0.000278s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 7 ) [ RunTime:0.000290s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 7 ) [ RunTime:0.000324s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 6 ) [ RunTime:0.000251s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 6 ) [ RunTime:0.000265s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 6 ) [ RunTime:0.000244s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 7 ) [ RunTime:0.000231s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 6 ) [ RunTime:0.000245s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 8 ) [ RunTime:0.000253s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 1575 [ RunTime:0.005217s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000574s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 27 LIMIT 1 [ RunTime:0.000244s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 27 [ RunTime:0.004363s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 993 LIMIT 1 [ RunTime:0.000345s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 993 [ RunTime:0.004232s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_odd` [ RunTime:0.000521s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 194 LIMIT 1 [ RunTime:0.000250s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 194 [ RunTime:0.004116s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 1923 [ RunTime:0.004532s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 100 [ RunTime:0.004076s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 141 [ RunTime:0.004211s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 10 LIMIT 1 [ RunTime:0.000310s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 10 [ RunTime:0.004303s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 2293 [ RunTime:0.005197s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 716 [ RunTime:0.005398s ]