From ae78d1f003af3e35d6c675da312f75be67fbff2e Mon Sep 17 00:00:00 2001
From: KKSU <15274802129@163.com>
Date: Mon, 30 Dec 2024 16:30:09 +0800
Subject: [PATCH] feat(mall): 优化商品查询 SQL 语句
---
src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java | 6 ++++++
1 files changed, 6 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
index 41152a7..7dc7f9f 100644
--- a/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
+++ b/src/main/java/cc/mrbird/febs/mall/mapper/MallGoodsSkuMapper.java
@@ -23,4 +23,10 @@
Integer upDateStockAndVolumeBySkuId(@Param("id")Long id, @Param("cnt")Integer cnt);
Integer updateStockAndVolumeBySkuId(@Param("id")Long id, @Param("cnt")Integer cnt);
+
+ List<Long> selectGoodsIdBySkuIds(@Param("list")List<Long> skuIds);
+
+ List<MallGoodsSku> selectSkuIdsByGoodsId(@Param("list")List<Long> goodsIdsAll);
+
+ List<MallGoodsSku> selectByIds(@Param("list")List<Long> skuIds);
}
--
Gitblit v1.9.1