Mybatis注解版传入List参数，按顺序读取

    @Select("<script>"  +
            "select * from catalogue where catalogue_IsDelete=0 and catalogue_Id  in" +
            "<foreach item='item' index='index' collection='list' open='(' close=')' separator=','>" +
            "#{item.catalogue_Id}" +
            "</foreach> order by field(catalogue_Id," +
            "<foreach item='item' index='index' collection='list' separator=','>" +
            "#{item.catalogue_Id}" +
            "</foreach>" +
            ")"+
            "</script>")
    List<Catalogue> getRecentCatalogueByCMCaId(List<RecentCMCaId> list);