MyBatis limit分页设置

错误的写法：

<select id="queryMyApplicationRecord" parameterType="MyApplicationRequest" resultMap="myApplicationMap">
    SELECT
    a.*,
    FROM
    tb_user a
    WHERE 1=1
    <if test="ids != null and ids.size()!=0">
        AND a.id IN
        <foreach collection="ids" item="id" index="index"
                 open="(" close=")" separator=",">
            #{
   id}
        </foreach>
    </if>
    <if test="statusList != null and statusList.size()!=0">
        AND a.status IN
        <foreach collection=