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

liurunyu

2025-07-29 2132a4073fdd350ddce3fc5f999b305fffae1b01

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoRm/RmSoilHistoryMapper.java

@@ -1,13 +1,21 @@
package com.dy.pipIrrGlobal.daoRm;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.pojoRm.RmSoilDay;
import com.dy.pipIrrGlobal.pojoRm.RmSoilHistory;
import com.dy.pipIrrGlobal.voRm.VoSoil;
import org.apache.ibatis.annotations.Mapper;

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

/**
 * @Author: liurunyu
 * @Date: 2025/6/25 10:04
 * @Description
 */
public interface RmSoilHistoryMapper {
@Mapper
public interface RmSoilHistoryMapper extends BaseMapper<RmSoilHistory> {
    int deleteByPrimaryKey(Long id);

    int insert(RmSoilHistory record);
@@ -16,6 +24,21 @@

    RmSoilHistory selectByPrimaryKey(Long id);

    /**
     * 根据指定条件查询记录数量
     * @param params
     * @return
     */
    Long selectCount(Map<?, ?> params);

    /**
     * 根据指定条件查询记录
     * @param params
     * @return
     */
    List<VoSoil> selectSome(Map<?, ?> params);


    int updateByPrimaryKeySelective(RmSoilHistory record);

    int updateByPrimaryKey(RmSoilHistory record);