SHOW FULL COLUMNS FROM `xy_company` [ RunTime:0.002353s ]
SELECT `c`.`title`,`c`.`id` FROM `xy_company` `c` INNER JOIN `xy_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xy_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xy_user_vip` `uv` ON `c`.`uid`=`uv`.`uid` WHERE `c`.`delete_time` IS NULL ORDER BY `uv`.`company_vip_level` DESC,`c`.`refresh_time` DESC,`c`.`attestation` DESC LIMIT 10 [ RunTime:0.008219s ]
SELECT `c`.`title`,`c`.`id` FROM `xy_company` `c` INNER JOIN `xy_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xy_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xy_user_vip` `uv` ON `c`.`uid`=`uv`.`uid` WHERE `c`.`delete_time` IS NULL ORDER BY `c`.`refresh_time` DESC,`uv`.`company_vip_level` DESC,`c`.`attestation` DESC LIMIT 10 [ RunTime:0.014987s ]
SHOW FULL COLUMNS FROM `xy_jobs` [ RunTime:0.012051s ]
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.006516s ]
SHOW FULL COLUMNS FROM `xy_jobs_cate` [ RunTime:0.006499s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 221 LIMIT 1 [ RunTime:0.002832s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 82 LIMIT 1 [ RunTime:0.003303s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 60 LIMIT 1 [ RunTime:0.000265s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 163 LIMIT 1 [ RunTime:0.000333s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 397 LIMIT 1 [ RunTime:0.000270s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 114 LIMIT 1 [ RunTime:0.000250s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 162 LIMIT 1 [ RunTime:0.000247s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 97 LIMIT 1 [ RunTime:0.000252s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 935 LIMIT 1 [ RunTime:0.000248s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000263s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 1041 LIMIT 1 [ RunTime:0.000335s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 158 LIMIT 1 [ RunTime:0.000249s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000272s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 106 LIMIT 1 [ RunTime:0.000485s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 200 LIMIT 1 [ RunTime:0.000266s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 156 LIMIT 1 [ RunTime:0.000827s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 35 LIMIT 1 [ RunTime:0.000263s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 861 LIMIT 1 [ RunTime:0.000360s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 201 LIMIT 1 [ RunTime:0.000462s ]
SELECT `id`,`title` FROM `xy_jobs_cate` WHERE `id` = 157 LIMIT 1 [ RunTime:0.000257s ]