EXPLAIN
select id_ from sys_role_menu
where menu_id in (1,2,3,4) and permission_=’add’
order by create_time desc
create index sysRoleMenu_menuId_permissin on sys_role_menu(menu_id, permission_)
%建表的时候使用
alter table sys_role_menu add index index_test on menu_id
drop index sysRoleMenu_menuId_permissin_time on sys_role_menu
create index sysRoleMenu_menuId_permissin_time on sys_role_menu(menu_id, permission_,create_time)