parent: af98371f | patch | commit | show whitespace
KKSU
2024-12-30 ae78d1f003af3e35d6c675da312f75be67fbff2e 
feat(mall): 优化商品查询 SQL 语句

- 在 ApiMallGoodsServiceImpl 类中，为获取热销商品的查询语句添加了 select 子句
-通过指定查询字段（仅查询 ID），提高了查询效率
1 files modified
1 ■■■■■ changed files
src/main/java/cc/mrbird/febs/mall/service/impl/ApiMallGoodsServiceImpl.java 1 ●●●●● patch | view | raw | blame | history 
 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");


        // 执行查询，获取商品列表