Mapper:
List<FolderInfoVo> getFoldersByIds(@Param("ids") List<Long> ids);
XML:
<select id="getFoldersByIds" resultMap="queryFolderInfoVo">
SELECT * FROM folder WHERE folder_id in
<foreach item="item" collection="ids" index="index" open="(" separator="," close=")">
#{item}
</foreach>
ORDER BY field(folder_id ,
<foreach item="item" collection="ids" index="index" separator=",">
#{item}
</foreach>);
</select>