diff --git a/EastLineServer/src/main/resources/mybatis/BanKuaiMapper.xml b/EastLineServer/src/main/resources/mybatis/BanKuaiMapper.xml
index 8a1811b..551d3cd 100644
--- a/EastLineServer/src/main/resources/mybatis/BanKuaiMapper.xml
+++ b/EastLineServer/src/main/resources/mybatis/BanKuaiMapper.xml
@@ -5,14 +5,30 @@
 <!--    根据分类查询板块列表-->
     <select id="doQueryBanKuaiFromCate" resultType="HashMap">
 
-        SELECT code, name FROM t_bankuai WHERE cate = #{cate};
+        SELECT *
+        FROM
+            (
+                SELECT
+                    `t1`.`code`,
+                    `t1`.`name`,
+                    cast(sum(`zhangfu`) AS DECIMAL(18, 2)) `zfS`
+                FROM
+                    `t_zijinliu_bankuai` `t1`
+                WHERE
+                        `t1`.`code` IN (
+                        SELECT `t2`.`code` FROM `t_bankuai` `t2` WHERE `t2`.`cate` = #{cate} ORDER BY `t2`.`id`
+                    )
+                  AND   `t1`.`shijian` LIKE '%15:00%'
+                GROUP BY `t1`.`code`) `a`
+        ORDER BY
+            `a`.`zfS` DESC;
 
     </select>
 
 <!--    根据板块代码查询同类个股(按个股总值排名) -->
     <select id="doQueryGeGuFromBkCode" resultType="HashMap">
 
-        SELECT c.code, c.name, c.bkName, c.bkCode, CONVERT(c.zongZhi, DECIMAL(18, 2)) zongZhi, CONVERT(c.liuZhi, DECIMAL(18, 2)) liuZhi
+        SELECT c.code, c.name, c.bkName, c.bkCode, CONVERT(c.zongZhi, DECIMAL(18, 2)) zongZhi, CONVERT(c.liuZhi, DECIMAL(18, 2)) liuZhi, CONVERT(c.`shiYingLvT`/100, DECIMAL(18, 2)) shiYingLvT
         FROM t_bankuai_gegu g
         LEFT JOIN t_code c ON g.code = c.code
         WHERE g.bkCode = #{bkCode} AND c.heXinTiCai like CONCAT('%', (
@@ -30,7 +46,8 @@
             bkName,
             bkCode,
             CONVERT(zongZhi, DECIMAL(18, 2)) zongZhi,
-            CONVERT(liuZhi, DECIMAL(18, 2)) liuZhi
+            CONVERT(liuZhi, DECIMAL(18, 2)) liuZhi,
+            CONVERT(`shiYingLvT`/100, DECIMAL(18, 2)) shiYingLvT
         FROM t_code
         ORDER BY CONVERT(zongZhi, DECIMAL(18, 2)) DESC
         limit 50;