SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000526s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000207s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000372s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000172s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000168s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000441s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000324s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000406s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000183s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000509s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1774480472 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 >= 1774480472 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1774480472 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.001212s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 15 ) [ RunTime:0.000192s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000342s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000314s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000288s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000308s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000294s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000291s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000308s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000318s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000299s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 292 [ RunTime:0.004573s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 298 [ RunTime:0.004188s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 297 [ RunTime:0.003849s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 296 [ RunTime:0.004611s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 295 [ RunTime:0.003894s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 294 [ RunTime:0.004056s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 293 [ RunTime:0.004021s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 291 [ RunTime:0.004149s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 290 [ RunTime:0.003943s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 1 WHERE `id` = 289 [ RunTime:0.003788s ]