mysql的 sql优化大家怎看优化

Question

sql优化

select aa.id,aa.gateStationName,bb.id as gateStationId from
        (select rsp.id,rsp.function_name as gateStationName
                from rmc_sys_user as rsu
                left join rmc_sys_user_role rsur on rsu.id = rsur.user_id
        left join rmc_sys_role_permission rsrp on rsur.role_id = rsrp.role_id
        left join rmc_sys_permission rsp on rsrp.permission_id = rsp.id
        ${ew.customSqlSegment}
        and rsp.parent_id = 0 and rsp.menu_type = 2) as aa
                inner join (select * from rmc_sys_permission rsp
                where rsp.parent_id = 4 AND  rsp.function_name LIKE '%闸%') as bb on aa.gateStationName = bb.function_name ORDER BY bb.idx

Answer 1

我看了下 可以优化一下

select  
    aa.id,
    aa.gateStationName, 
    bb.id as gateStationId
from   
     (select p.id,p.function_name as gateStationName  
     from rmc_sys_user u
     left join rmc_sys_user_role ur on u.id  = ur.user_id
     left join rmc_sys_role_permission rp on ur.role_id = rp.role_id
     left join rmc_sys_permission p on rp.permission_id = p.id   
     where p.parent_id = 0 and p.menu_type = 2) as aa  
     join
     (select * from rmc_sys_permission 
     where parent_id = 4 AND function_name LIKE '%闸%') as bb
     on aa.gateStationName = bb.function_name   
order by 
    bb.idx