优化SQL语句，以提高查询速度

liurunyu

2025-07-29 311a9b371845bb716c182e530e015259834754ad

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoSt/StClientAmountYearMapper.java

@@ -1,10 +1,13 @@
package com.dy.pipIrrGlobal.daoSt;

import com.dy.pipIrrGlobal.pojoSt.StClientAmountYear;
import com.dy.pipIrrGlobal.voSt.VoStClientAmountYearRecord;
import com.dy.pipIrrGlobal.voSt.VoStClientIdAmountYearRecord;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;
import java.util.Map;

/**
 * @Author: liurunyu
@@ -61,6 +64,27 @@
     */
    int updateByPrimaryKey(StClientAmountYear record);



    //////////////////////////////////////
    //查询统计结果
    /**
     * 查询总数量
     * @param params
     * @return
     */
    Long selectCountYearStatistics(Map<?, ?> params) ;

    List<VoStClientIdAmountYearRecord> selectClientIds4YearStatistics(Map<?, ?> params) ;
    /**
     * 查询分页数据
     * @param params
     * @return
     */
    List<VoStClientAmountYearRecord> selectYearStatistics(Map<?, ?> params) ;

    //////////////////////////////////////
    //统计相关
    /**
     * 查询某年 某量值
     *