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

liurunyu

2025-07-29 2132a4073fdd350ddce3fc5f999b305fffae1b01

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/daoAllRound/Ar4BaseMapper.java

New file
@@ -0,0 +1,31 @@
package com.dy.pipIrrGlobal.daoAllRound;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.dy.pipIrrGlobal.voAllRound.VoArIntakeBase;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Param;

import java.util.List;

/**
 * @Author: liurunyu
 * @Date: 2025/1/14 16:45
 * @Description
 */
@Mapper
public interface Ar4BaseMapper extends BaseMapper<Object> {

    /**
     * 查询取水口基本信息
     * @param intakeId
     * @return
     */
    List<VoArIntakeBase> intakeInfo(@Param("intakeId") Long intakeId) ;

    /**
     * 查询取水口关联的RTU地址
     * @param intakeId
     * @return
     */
    List<String> intakeRtuAddr(@Param("intakeId") Long intakeId) ;
}