合肥三丰种子有限公司 - 企业详情 - 东方就业网 - 技术劳务人才就业服务网站

1:[0.29 MS - SELECT m.*, a.uid as is_member_access, a.groupid, a.isforbid as is_member_forbid, a.unactive as is_member_active, a.money, a.integral, a.mailcode, a.msgnews, a.msgwrites, a.addrlists, a.favourites, n.uid as is_member_nameid, n.truename FROM dongfang.nake_member m LEFT JOIN dongfang.nake_member_access a ON a.uid = m.uid LEFT JOIN dongfang.nake_member_names n ON n.uid = m.uid WHERE m.uid = '3571']
2:[25.30 MS - SELECT co.*, cc.*, l.uid as is_logo_id, l.attachroot, l.attachname, l.attachwidth, l.attacheight, p.id as is_location_id, p.cntitle as location, tpl_s.uid as is_template_special_uid, tpl_s.htmlfile as is_template_special_htmlfile, tpl_s.beginedate as is_template_special_beginedate, tpl_s.finishdate as is_template_special_finishdate, cf.*, tpl_u.tid as is_template_common_tid, tpl_u.htmlfile as is_template_common_htmlfile, cd.website, cd.introduce, s.id as is_comsize_id, s.cntitle as sizename FROM dongfang.nake_company_organ co LEFT JOIN dongfang.nake_company_contact cc ON cc.organid = co.organid LEFT JOIN dongfang.nake_company_logo l ON l.uid = co.uid AND l.checked = '1' LEFT JOIN dongfang.nake_classplace p ON p.id = co.placeid LEFT JOIN dongfang.nake_company_template tpl_s ON tpl_s.uid = co.uid AND tpl_s.isused = '1', dongfang.nake_company_faces cf LEFT JOIN dongfang.nake_company_templates tpl_u ON tpl_u.tid = cf.templateid, dongfang.nake_company_fields cd LEFT JOIN dongfang.nake_classcomsize s ON s.id = cd.comsize WHERE co.uid = '3535' AND cf.uid = co.uid AND cd.uid = co.uid ORDER BY co.isprimary DESC LIMIT 1]
3:[0.69 MS - SELECT j.jobid, j.postdate, j.losedate, j.applies, j.views, j.jname, j.people, o.organid as is_organ_id, o.orgname, k.id as is_kind_id, k.cntitle as jkind FROM dongfang.nake_jobs_faces j LEFT JOIN dongfang.nake_company_organ o ON o.organid = j.organid LEFT JOIN dongfang.nake_classjobskinds k ON k.id = j.jobskinds WHERE j.uid = '3535' AND j.checked = '1' AND j.stoped = '0' ORDER BY j.postdate DESC]