mysql查询条件失效问题

select recordId, employeeId,startTime,endTime

 from `kq_absent_register` as ar

 where ar.employeeId = 75 

and "2017-07-05" <= DATE_FORMAT(ar.startTime,'%Y-%m-%d') 

and "2017-07-05" >= DATE_FORMAT(ar.endTime,'%Y-%m-%d') 

and ar.type = 11 or ar.type = 12;

会先运行and的内容且把and的内容当成一块，所以要把Type的条件括起来