SHOW FULL COLUMNS FROM `xy_company` [ RunTime:0.003336s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.002311s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as title FROM `xy_jobs` WHERE ( `status` = 1 AND `examine` = 1 ) AND `xy_jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 20 [ RunTime:0.003739s ]
SHOW FULL COLUMNS FROM `xy_jobs_cate` [ RunTime:0.004818s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 82 LIMIT 1 [ RunTime:0.001039s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 163 LIMIT 1 [ RunTime:0.001674s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 1041 LIMIT 1 [ RunTime:0.000768s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 935 LIMIT 1 [ RunTime:0.000729s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 200 LIMIT 1 [ RunTime:0.000415s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000434s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 114 LIMIT 1 [ RunTime:0.000660s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000663s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000656s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 106 LIMIT 1 [ RunTime:0.000643s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 158 LIMIT 1 [ RunTime:0.000881s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000377s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 861 LIMIT 1 [ RunTime:0.000505s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 157 LIMIT 1 [ RunTime:0.000624s ]