SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000695s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000250s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000498s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000182s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000192s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000670s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000309s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000469s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000198s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000847s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1792094447 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 >= 1792094447 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1792094447 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001038s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000246s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000325s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000364s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000475s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000441s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000490s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000430s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000467s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000441s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000402s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.001014s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 309 LIMIT 1 [ RunTime:0.000309s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 309 [ RunTime:0.005692s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 10 WHERE `id` = 308 [ RunTime:0.020138s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 161 LIMIT 1 [ RunTime:0.000390s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 161 [ RunTime:0.005240s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 302 [ RunTime:0.005180s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 5 WHERE `id` = 300 [ RunTime:0.004828s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 8 WHERE `id` = 211 [ RunTime:0.005162s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 14 WHERE `id` = 200 [ RunTime:0.006594s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 291 LIMIT 1 [ RunTime:0.000540s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 291 [ RunTime:0.004682s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 14 WHERE `id` = 307 [ RunTime:0.005645s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 306 LIMIT 1 [ RunTime:0.000431s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 306 [ RunTime:0.064349s ]