SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000929s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000577s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000248s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000365s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000705s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000490s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000645s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000965s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1789247247 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 >= 1789247247 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1789247247 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.009360s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000411s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (2,1) ) [ RunTime:0.000540s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000362s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (2,5,6,7,8,9) ) [ RunTime:0.000493s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` IN (2,5,6,7,8,9) ) [ RunTime:0.000541s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000377s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000456s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000469s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 5 ) [ RunTime:0.000325s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000379s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 2 WHERE `id` = 4024 [ RunTime:0.004510s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 3 WHERE `id` = 4072 [ RunTime:0.005148s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 4116 [ RunTime:0.004401s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 4115 [ RunTime:0.004736s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 4114 [ RunTime:0.004898s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 8 WHERE `id` = 4113 [ RunTime:0.004797s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 4112 [ RunTime:0.005100s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 4111 [ RunTime:0.013695s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 5 WHERE `id` = 4110 [ RunTime:0.004742s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 5 WHERE `id` = 4109 [ RunTime:0.004709s ]