SHOW FULL COLUMNS FROM `xycms_company` [ RunTime:0.000893s ]
SELECT `c`.`title`,`c`.`id` FROM `xycms_company` `c` INNER JOIN `xycms_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xycms_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xycms_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.002474s ]
SELECT `c`.`title`,`c`.`id` FROM `xycms_company` `c` INNER JOIN `xycms_company_content` `content` ON `content`.`cid`=`c`.`id` INNER JOIN `xycms_user` `user` ON `user`.`id`=c.uid AND user.status=1 INNER JOIN `xycms_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.001704s ]
SHOW FULL COLUMNS FROM `xycms_jobs` [ RunTime:0.001107s ]
SELECT count(jobs_cate3) as countCate,jobs_cate3 as title FROM `xycms_jobs` WHERE ( `status` = 1 AND `examine` = 1 ) AND `xycms_jobs`.`delete_time` IS NULL GROUP BY `jobs_cate3` HAVING count(jobs_cate3)>1 ORDER BY `countCate` DESC LIMIT 20 [ RunTime:0.000825s ]
SHOW FULL COLUMNS FROM `xycms_jobs_cate` [ RunTime:0.000872s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 62 LIMIT 1 [ RunTime:0.000308s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 221 LIMIT 1 [ RunTime:0.000310s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 922 LIMIT 1 [ RunTime:0.000309s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 650 LIMIT 1 [ RunTime:0.000294s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 1230 LIMIT 1 [ RunTime:0.000301s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 618 LIMIT 1 [ RunTime:0.000270s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 513 LIMIT 1 [ RunTime:0.000290s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 226 LIMIT 1 [ RunTime:0.000301s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 862 LIMIT 1 [ RunTime:0.000317s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 397 LIMIT 1 [ RunTime:0.000305s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 647 LIMIT 1 [ RunTime:0.000266s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 469 LIMIT 1 [ RunTime:0.000295s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 872 LIMIT 1 [ RunTime:0.000307s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 40 LIMIT 1 [ RunTime:0.000292s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 724 LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 113 LIMIT 1 [ RunTime:0.000275s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 61 LIMIT 1 [ RunTime:0.000410s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 114 LIMIT 1 [ RunTime:0.000307s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 735 LIMIT 1 [ RunTime:0.000250s ]
SELECT `id`,`title` FROM `xycms_jobs_cate` WHERE `id` = 1227 LIMIT 1 [ RunTime:0.000246s ]