Mysql优化 sql语句优化
这是我遇到的一句sql语句 执行时间为2s多
select t . USER_ID AS USER_ID ,
(select u . USER_NAME from auth_user u
where ( u . ID = t . USER_ID )) AS USER_NAME , r . ID AS ID , r . RES_NAME AS RES_NAME , r . RES_EN_NAME AS RES_EN_NAME ,
r . RES_TYPE AS RES_TYPE , r . RES_IS_SYS AS RES_IS_SYS , r . RES_LINK AS RES_LINK , r . SORT AS SORT , r . CREATE_TIME AS CREATE_TIME ,
r . CREATE_USER_ID AS CREATE_USER_ID , r . UPDATE_TIME AS UPDATE_TIME , r . UPDATE_USER_ID AS UPDATE_USER_ID , r . MOD_ID AS MOD_ID ,
(select m . MOD_NAME from auth_module m where ( m . ID = r . MOD_ID )) AS MOD_NAME , r . DOM_ID AS DOM_ID ,
(select d . DOM_NAME from auth_domain d where ( d . ID = r . DOM_ID )) AS DOM_NAME ,
(select d . DOM_APP_CODE from auth_domain d where ( d . ID = r . DOM_ID )) AS DOM_APP_CODE , r . OPER_ID AS OPER_ID ,
(select o . OPER_DEF_CODE from auth_operation_define o where ( o . ID = r . OPER_ID )) AS OPER_DEF_CODE ,
(select o . OPER_DEF_VALUE from auth_operation_define o where ( o . ID = r . OPER_ID )) AS OPER_DEF_VALUE ,
(select o . OPER_DEF_CATEGORY from auth_operation_define o where ( o . ID = r . OPER_ID )) AS OPER_DEF_CATEGORY , r . MNU_ID AS MNU_ID ,
(select m . MNU_NAME from auth_menu m where ( m . RES_ID = r . ID )) AS MNU_NAME ,(select m . MNU_PARENT_ID from auth_menu m
where ( m . RES_ID = r . ID )) AS MNU_PARENT_ID , t . ROLE_RES_SCOPE AS ROLE_RES_SCOPE
from v_auth_user_resource_t t JOIN auth_resource r where ( t . RES_ID = r . ID )
v_auth_user_resource_t mysql视图
select ur . USER_ID AS USER_ID , rr . RES_ID AS RES_ID , rr . ROLE_RES_SCOPE AS ROLE_RES_SCOPE
from ( auth_role_resource rr JOIN auth_user_role ur )
where ( ur . ROLE_ID = rr . ROLE_ID )
where 条件后的第一个字段我都加了索引 但是查询效率还是2s多
有哪位大佬给点sql优化建议?