SHOW FULL COLUMNS FROM `fn_fenlei_info_category` [ RunTime:0.000735s ]
SELECT * FROM `fn_fenlei_info_category` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000320s ]
SHOW FULL COLUMNS FROM `fn_fenlei_site` [ RunTime:0.000579s ]
SELECT * FROM `fn_fenlei_site` WHERE `id` = 0 LIMIT 1 [ RunTime:0.000267s ]
SELECT * FROM `fn_fenlei_site` WHERE `pid` = 0 [ RunTime:0.000262s ]
SHOW FULL COLUMNS FROM `fn_fenlei_nav` [ RunTime:0.000500s ]
SELECT * FROM `fn_fenlei_nav` WHERE ( `type` = 2 AND `location` = 'top' AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `fn_fenlei_ad` [ RunTime:0.000895s ]
SELECT * FROM `fn_fenlei_ad` WHERE ( `type` = 2 AND `display` = 1 ) ORDER BY `sort_number` DESC [ RunTime:0.000344s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info` [ RunTime:0.000610s ]
SELECT `me`.*,c.name cname,`u`.`username`,`u`.`avatar`,CASE WHEN me.top_time > 1792020648 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 >= 1792020648 ) ORDER BY `is_top` DESC,`me`.`sort_number` DESC,CASE WHEN me.end_time > 1792020648 THEN 0 ELSE 1 END ASC,`me`.`update_time` DESC LIMIT 0,10 [ RunTime:0.020354s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000413s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000383s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000537s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.001178s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000242s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000298s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.001006s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000336s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000332s ]
SELECT * FROM `fn_fenlei_site` WHERE ( `id` = 1 ) [ RunTime:0.000360s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_odd` [ RunTime:0.000752s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 15308 LIMIT 1 [ RunTime:0.000336s ]
SHOW FULL COLUMNS FROM `fn_fenlei_info_job_full` [ RunTime:0.000554s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 17702 LIMIT 1 [ RunTime:0.000284s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 17702 AND `salary` > 0 LIMIT 1 [ RunTime:0.000283s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 18452 LIMIT 1 [ RunTime:0.000277s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18452 AND `salary` > 0 LIMIT 1 [ RunTime:0.000257s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 18347 LIMIT 1 [ RunTime:0.000257s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18347 AND `salary` > 0 LIMIT 1 [ RunTime:0.000252s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18175 LIMIT 1 [ RunTime:0.000241s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 4398 LIMIT 1 [ RunTime:0.000262s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 4398 AND `salary` > 0 LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 3470 LIMIT 1 [ RunTime:0.000250s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 3470 AND `salary` > 0 LIMIT 1 [ RunTime:0.000236s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 18300 LIMIT 1 [ RunTime:0.000268s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18300 AND `salary` > 0 LIMIT 1 [ RunTime:0.000234s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 18024 LIMIT 1 [ RunTime:0.000253s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18024 AND `salary` > 0 LIMIT 1 [ RunTime:0.000265s ]
SELECT * FROM `fn_fenlei_info_job_full` WHERE `iid` = 18086 LIMIT 1 [ RunTime:0.000275s ]
SELECT * FROM `fn_fenlei_info_job_odd` WHERE `iid` = 18086 AND `salary` > 0 LIMIT 1 [ RunTime:0.000273s ]