INSERT INTO record_access(time,employeeId)
SELECT ra.time,ra.employeeId from `r_record_access` as ra
LEFT JOIN `kq_work_shift` as ws on ra.employeeId = ws.employeeId where DATE_FORMAT(time,'%Y-%m-%d') >= @sstartTime and DATE_FORMAT(time,'%Y-%m-%d') <= @eendTime AND FIND_IN_SET(ra.readerId,ws.readerIds)
SELECT ra.time,ra.employeeId from `r_record_access` as ra
LEFT JOIN `kq_work_shift` as ws on ra.employeeId = ws.employeeId where DATE_FORMAT(time,'%Y-%m-%d') >= @sstartTime and DATE_FORMAT(time,'%Y-%m-%d') <= @eendTime AND FIND_IN_SET(ra.readerId,ws.readerIds)