SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000630s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000266s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000442s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000239s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000222s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000455s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000369s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000441s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000654s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1792099001 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 >= 1792099001 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1792099001 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001001s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000301s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000318s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000459s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000337s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (2,3,4,5,6,7) ) [ RunTime:0.000398s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000398s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000347s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000327s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000484s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000395s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 199 [ RunTime:0.005285s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000765s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 262 LIMIT 1 [ RunTime:0.000346s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 262 [ RunTime:0.004598s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 263 LIMIT 1 [ RunTime:0.000473s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 263 [ RunTime:0.004640s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 257 [ RunTime:0.009213s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 261 [ RunTime:0.004547s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 260 [ RunTime:0.003984s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 259 [ RunTime:0.004188s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 254 LIMIT 1 [ RunTime:0.000461s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 254 [ RunTime:0.012446s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 252 LIMIT 1 [ RunTime:0.000415s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 252 [ RunTime:0.004351s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 251 LIMIT 1 [ RunTime:0.000420s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 251 [ RunTime:0.004844s ]