[ DB ] CONNECT:[ UseTime:3.943068s ] mysql:host=127.0.0.1;port=3306;dbname=zhaopin;charset=utf8mb4
[ SQL ] SHOW COLUMNS FROM `cmf_position` [ RunTime:0.004404s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM `cmf_position` `a` LEFT JOIN `cmf_recruiting` `b` ON `a`.`recruiting_id`=`b`.`id` WHERE `a`.`status` = 1 AND `b`.`status` = 1 AND `a`.`type` = 2 [ RunTime:0.001545s ]
[ SQL ] SELECT `a`.*,b.title profession_title FROM `cmf_position` `a` LEFT JOIN `cmf_recruiting` `b` ON `a`.`recruiting_id`=`b`.`id` WHERE `a`.`status` = 1 AND `b`.`status` = 1 AND `a`.`type` = 2 ORDER BY `a`.`is_hot` DESC LIMIT 0,12 [ RunTime:0.000920s ]
