求大神优化sql语句

select count(r) from recruitment_info r
where r.recordState='normal' and r.category='recruit' and r.status='published'
and r.positionInfo like '%网页添加实习信息%' and r.workAddress like '%上海%'and
(r.orgName like '%樱桃小丸子%' or r.orgCode in  (select e.code from enterprise e where e.code in
   (select re.orgCode from recruitment_info re where      re.orgName is null)
  and
  e.name like '%樱桃小丸子%' )
)