SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000728s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000287s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000694s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000317s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000691s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000464s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000668s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000328s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000912s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1789927218 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 >= 1789927218 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1789927218 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001422s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000316s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000416s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000416s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000478s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000363s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000430s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000433s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000460s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000337s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 17 ) [ RunTime:0.000349s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 7 WHERE `id` = 211 [ RunTime:0.006435s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 200 [ RunTime:0.004826s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000617s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 136 LIMIT 1 [ RunTime:0.000316s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 136 [ RunTime:0.005503s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 10 WHERE `id` = 263 [ RunTime:0.005815s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 291 LIMIT 1 [ RunTime:0.000463s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 291 [ RunTime:0.004961s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 270 LIMIT 1 [ RunTime:0.000414s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 270 [ RunTime:0.004926s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 272 LIMIT 1 [ RunTime:0.000396s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 272 [ RunTime:0.004653s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 273 LIMIT 1 [ RunTime:0.000388s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 273 [ RunTime:0.004758s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 274 LIMIT 1 [ RunTime:0.000373s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 274 [ RunTime:0.005079s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 19 WHERE `id` = 284 [ RunTime:0.005041s ]