From 0f287f6dfd18b17ae22543f35025efc3bbec24a7 Mon Sep 17 00:00:00 2001
From: lidongdong <1459917685@qq.com>
Date: 星期四, 23 十一月 2023 13:51:42 +0800
Subject: [PATCH] 优化花城数据查询太慢
---
springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynDAO.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynDAO.java b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynDAO.java
index 5293066..b667d18 100644
--- a/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynDAO.java
+++ b/springcloud_k8s_panzhihuazhihuishequ/service_community/src/main/java/com/panzhihua/service_community/dao/ComActDynDAO.java
@@ -68,6 +68,12 @@
// + " order by d.is_topping desc, d.create_at desc " + "</script>")
IPage<ComActDynVO> pageDynamicByAdmin(Page page, @Param("comActDynVO") ComActDynVO comActDynVO);
+
+ String getContent(@Param("id") String id);
+
+ int getReadNum(@Param("dynId") String dynId);
+
+
@Select("SELECT " + " count( cad.id ) AS dynTotal, "
+ " (select count(id) from com_act_dyn where community_id = ${communityId} and create_at LIKE CONCAT(#{nowDate},'%')) as currentNum "
+ "FROM " + " com_act_dyn AS cad " + "WHERE " + " community_id = ${communityId}")
--
Gitblit v1.7.1