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

liurunyu

2025-07-29 83c1bbca96beb5461fff56d861214444348e86d0

 pipIrr-platform/pipIrr-global/src/main/java/com/dy/pipIrrGlobal/voSpecial/VoTopXClient.java

New file
@@ -0,0 +1,55 @@
package com.dy.pipIrrGlobal.voSpecial;

import com.alibaba.fastjson2.annotation.JSONField;
import com.alibaba.fastjson2.writer.ObjectWriterImplToString;
import com.fasterxml.jackson.annotation.JsonPropertyOrder;
import lombok.Data;

/**
 * @Author: liurunyu
 * @Date: 2025/2/10 8:52
 * @Description
 */

@Data
@JsonPropertyOrder({"id",
        "clientId",
        "clientName",
        "clientNum",
        "clientAddress",
        "amount"
})
public class VoTopXClient {
    private static final long serialVersionUID = 202502100853001L;
    /**
     * 数据记录id(开关阀记录)
     */
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    public Long id ;

    /**
     * 农户ID
     */
    @JSONField(serializeUsing= ObjectWriterImplToString.class)
    public Long clientId;
    /**
     * 农户姓名
     */
    public String clientName;

    /**
     * 农户编号
     */
    public String clientNum;

    /**
     * 农户地址
     */
    public String clientAddress;

    /**
     * 用水量
     */
    public Double amount;

}