SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.002010s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.001793s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as title FROM `xycms_jobs` WHERE ( `status` = 1 AND `examine` = 1 AND `jobs_area1` = 20 AND `jobs_area2` = 262 ) AND `xycms_jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 20 [ RunTime:0.001407s ]
SHOW FULL COLUMNS FROM `xycms_area` [ RunTime:0.001572s ]
SELECT `id`,`title` FROM `xycms_area` WHERE `pid` = 20 AND `id` <> 262 LIMIT 20 [ RunTime:0.000876s ]