SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000586s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000201s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000448s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000180s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000683s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000361s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000625s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000241s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000865s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1782089709 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 >= 1782089709 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1782089709 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.003061s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000274s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000271s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000220s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000224s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000223s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000206s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000217s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000225s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000207s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 2 ) [ RunTime:0.000283s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 45 WHERE `id` = 1879 [ RunTime:0.004967s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000855s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1878 LIMIT 1 [ RunTime:0.000248s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 37 WHERE `id` = 1878 [ RunTime:0.004111s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_resume` [ RunTime:0.000748s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1877 LIMIT 1 [ RunTime:0.000246s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 29 WHERE `id` = 1877 [ RunTime:0.010054s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1867 LIMIT 1 [ RunTime:0.000343s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 50 WHERE `id` = 1867 [ RunTime:0.004497s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1868 LIMIT 1 [ RunTime:0.000261s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 44 WHERE `id` = 1868 [ RunTime:0.007083s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1869 LIMIT 1 [ RunTime:0.000387s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 26 WHERE `id` = 1869 [ RunTime:0.004348s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1870 LIMIT 1 [ RunTime:0.000322s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 25 WHERE `id` = 1870 [ RunTime:0.004275s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 1871 LIMIT 1 [ RunTime:0.000279s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 21 WHERE `id` = 1871 [ RunTime:0.004119s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1872 LIMIT 1 [ RunTime:0.000328s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 50 WHERE `id` = 1872 [ RunTime:0.004136s ]
SELECT * FROM `fn_fenlei_info_resume` WHERE `iid` = 1873 LIMIT 1 [ RunTime:0.000312s ]
UPDATE `fn_fenlei_info` SET `click_count` = `click_count` + 17 WHERE `id` = 1873 [ RunTime:0.004386s ]