select * from cdb_members inner join cdb_memberfields on cdb_members.uid=cdb_memberfields .uidinner join supe_userfields on cdb_members.uid=supe_userfields.uidinner join cdb_usergroups on cdb_members.groupid=cdb_usergroups.groupidinner join supe_userspaces on cdb_members.uid=supe_userspaces.uidinner join supe_userspacefields on cdb_members.uid=supe_userspacefields.uidorder by cdb_members.uid desc limit 0,500
请问各位高手这个SQL语句还能不能进行更好的优化?
在执行的时候会很慢~~~