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

liurunyu

2025-07-29 2132a4073fdd350ddce3fc5f999b305fffae1b01

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voLargeScreen/VoBaseInfo.java

New file
@@ -0,0 +1,65 @@
package com.dy.pipIrrGlobal.voLargeScreen;

import com.fasterxml.jackson.annotation.JsonPropertyOrder;
import lombok.Data;

/**
 * @Author: liurunyu
 * @Date: 2025/2/6 10:40
 * @Description
 */

@Data
@JsonPropertyOrder({"totalCountOfTown",
        "totalCountOfVillage",
        "totalCountOfBlock",
        "totalCountOfDivide",
        "totalCountOfIntake",
        "totalCountOfIntakeWithController",
        "totalCountOfIntakeWithoutController",
        "totalCountOfController",
        "totalCountOfControllerTramp"
        })
public class VoBaseInfo {

    private static final long serialVersionUID = 202502060948001L;

    /**
     * 乡镇总数
     */
    public Integer totalCountOfTown ;

    /**
     * 行政村总数
     */
    public Integer totalCountOfVillage ;
    /**
     * 片区总数
     */
    public Integer totalCountOfBlock ;
    /**
     * 分水房总数
     */
    public Integer totalCountOfDivide ;
    /**
     * 取水口总数
     */
    public Integer totalCountOfIntake ;
    /**
     * 已绑定控制器的取水口总数
     */
    public Integer totalCountOfIntakeWithController ;
    /**
     * 未绑定控制器的取水口总数
     */
    public Integer totalCountOfIntakeWithoutController ;
    /**
     * 阀控器总数
     */
    public Integer totalCountOfController ;
    /**
     * 流浪阀控器总数
     */
    public Integer totalCountOfControllerTramp ;

}