我有5个表
chanet_cmiims_person_info表
chanet_cmiism_person_commitstate表
chanet_cmiims_commitstate_type表
chanet_cmiims_person_state表
chanet_cmiims_person_state_type表
这是我现在的查询语句,但是效率太低了,2600多条数据都要查询4秒多。请教如何提高此语句的查询效率
SELECT info.* from (
SELECT sinfo.personName as relName,state.id AS personStateId,stateName,cmit.id AS personCommitStateId,commitStateName,info.* FROM chanet_cmiims_person_info AS info
INNER JOIN chanet_cmiism_person_commitstate AS cmit ON cmit.personInfoId=info.id
INNER JOIN chanet_cmiims_commitstate_type AS committype ON committype.id=cmit.commitStateId
INNER JOIN chanet_cmiims_person_state AS state ON info.id=state.personInfoId
INNER JOIN chanet_cmiims_person_state_type AS statetype ON statetype.id =state.stateTypeId
LEFT JOIN chanet_cmiims_person_info AS sinfo ON sinfo.id=info.relevancePerson) AS info