1:索引满足最左前缀

    2:小表驱动大表

    3:order by 避免filesort, order by 满足最左前缀

    4:group by 先排序 后分组 少用having