视图的性能，查询好慢啊，高手帮忙分析一下

Question

create view employeeInformation as
SELECT
 employee.employeeId,
 employee.employeeName,
 empsalary.salary,
 employee.birthday,
 employee.cardNo,
 employee.insuranceNo,
 employee.sex,
 empdepartment.departmentId,
 empkind.employeeKindId,
 empheadship.headshipKindId,
 empresidence.residenceKindId,
 empstatus.statusKindId
 FROM
 employee
 LEFT OUTER JOIN empsalary empsalary on (employee.employeeId = empsalary.employeeId
  and empsalary.id=(select MAX(id) from empsalary where employee.employeeId = empsalary.employeeId) )
 LEFT OUTER JOIN empdepartment empdepartment on (employee.employeeId = empdepartment.employeeId
  and empdepartment.id=(select MAX(id) from empdepartment where employee.employeeId = empdepartment.employeeId) )
 LEFT OUTER JOIN empkind empkind on (employee.employeeId = empkind.employeeId
  and  empkind.id=(select MAX(id) from empkind where employee.employeeId = empkind.employeeId) )
 LEFT OUTER JOIN empheadship empheadship on (employee.employeeId = empheadship.employeeId
  and  empheadship.id=(select MAX(id) from empheadship where employee.employeeId = empheadship.employeeId))
 LEFT OUTER JOIN empresidence empresidence on (employee.employeeId = empresidence.employeeId 
  and empresidence.id=(select MAX(id) from empresidence where employee.employeeId = empresidence.employeeId))
 LEFT OUTER JOIN empstatus empstatus on (employee.employeeId = empstatus.employeeId 
  AND  empstatus.id=(select MAX(id) from empstatus where employee.employeeId = empstatus.employeeId)) 左联接表中存有employeeId对应的多条记录，匹配最新插入的记录，就是id号最大的记录,2000条数据，查询要8秒多,
 怎么优化啊？
 

Answer 1

Post your explain result.
For example
EXPLAIN SELECT ...;

Answer 2

explain后想不出解决方法，select max(id)好像扫描全表了