查询内存不够限制

zhongrj

2024-01-08 57e23a6ba83608b5f6f4160be1ca9cc50f22f0d1

查询内存不够限制

 src/main/java/org/springblade/modules/house/mapper/HouseholdMapper.xml

@@ -699,7 +699,7 @@
            <if test="household.regionCode!=null and household.regionCode!=''">
                and jg.community_code like concat('%',#{household.regionCode},'%')
            </if>
            <if test="household.id!=null and household.id!=''">
            <if test="household.id!=null">
                and jh.id = #{household.id}
            </if>
            <if test="household.labelId!=null">
@@ -709,7 +709,10 @@
                and CONCAT(jh.name,jh.phone_number) like CONCAT ('%', #{household.searchKey},'%')
            </if>
            and jh.is_deleted = 0
            order by jh.create_time desc
            order by jh.create_time desc,jh.id desc
            <if test="household.limit!=null">
                limit #{household.limit}
            </if>
        </where>
    </select>


 src/main/java/org/springblade/modules/house/vo/HouseholdVO.java

@@ -158,4 +158,9 @@
     */
    private String searchKey;

    /**
     * 取值数
     */
    private Integer limit;

}