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/service/impl/ApiMallGoodsServiceImpl.java | 1 +
1 files changed, 1 insertions(+), 0 deletions(-)
diff --git a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java
index 054a2af..42bc29c 100644
--- a/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java
+++ b/src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java
@@ -70,6 +70,7 @@
LambdaQueryWrapper<MallGoods> goodsQuery = new LambdaQueryWrapper<>();
goodsQuery.eq(MallGoods::getIsSale, 1)
.eq(MallGoods::getIsNormal, 1)
+ .select(MallGoods::getId)
.orderByDesc(MallGoods::getVolume)
.last("limit 5");
// 执行查询，获取商品列表
--
Gitblit v1.9.1