[ DB ] CONNECT:[ UseTime:0.000319s ] mysql:host=127.0.0.1;port=3306;dbname=asy_home;charset=utf8
[ SQL ] SHOW COLUMNS FROM `biz_site_info` [ RunTime:0.000548s ]
[ SQL ] SELECT * FROM `biz_site_info` WHERE ( 1=1 ) LIMIT 1 [ RunTime:0.000252s ]
[ SQL ] SHOW COLUMNS FROM `biz_ent` [ RunTime:0.000433s ]
[ SQL ] SELECT * FROM `biz_ent` WHERE ( 1=1 ) LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SHOW COLUMNS FROM `biz_notice` [ RunTime:0.000398s ]
[ SQL ] SELECT * FROM `biz_notice` WHERE `notice_status` = 2 ORDER BY `notice_on_top` DESC,`notice_weight` DESC,`create_time` DESC LIMIT 5 [ RunTime:0.000336s ]
[ SQL ] SHOW COLUMNS FROM `biz_site_image` [ RunTime:0.000435s ]
[ SQL ] SELECT * FROM `biz_site_image` WHERE ( 1=1 ) [ RunTime:0.000169s ]
[ SQL ] SHOW COLUMNS FROM `biz_site_seo` [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `biz_site_seo` WHERE `code` = 'join_me' LIMIT 1 [ RunTime:0.000193s ]
[ SQL ]
select
cat.id
,cat.job_cat_name
from biz_job_cat cat
join biz_job job on job.job_cat_id=cat.id
where cat.job_cat_status = 2 and job.job_status=2
group by cat.id
order by cat.job_cat_weight desc [ RunTime:0.000303s ]
[ SQL ] SHOW COLUMNS FROM `biz_job` [ RunTime:0.000397s ]
[ SQL ] SELECT `job_workplace` FROM `biz_job` WHERE `job_status` = 2 GROUP BY `job_workplace` ORDER BY `job_workplace` ASC [ RunTime:0.000208s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `biz_job` `job` INNER JOIN `asy_home`.`biz_job_cat` `cat` ON `cat`.`id`=`job_cat_id` WHERE `job_status` = 2 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT `job`.`id`,`job`.`job_name`,`job`.`job_cat_id`,`job`.`job_on_top_status`,`job`.`job_workplace`,`job`.`need_count`,`job`.`create_time`,`job_cat_name` FROM `biz_job` `job` INNER JOIN `asy_home`.`biz_job_cat` `cat` ON `cat`.`id`=`job_cat_id` WHERE `job_status` = 2 ORDER BY `job_on_top_status` DESC,`job_weight` DESC,`create_time` DESC LIMIT 0,10 [ RunTime:0.000260s ]
扫码联系客服
