fix(sql): 移除多余的产品ID分组条件

Administrator

2025-10-21 bb15f16cbf950c4a8cfd9fb8a39474236f19d9f0

fix(sql): 移除多余的产品ID分组条件

- 删除了导致查询结果不准确的group by子句
- 确保按创建时间正确排序所有记录
- 优化查询逻辑以提高性能和准确性

 src/main/resources/mapper/modules/AiMemberAnswerMapper.xml

@@ -39,7 +39,6 @@
        where a.member_id = #{record.memberUuid}
          and a.state = 1
          and a.company_id = #{record.companyId}
        group by a.product_id
        order by a.CREATED_TIME desc
    </select>
</mapper>