Skip to content
GitLab
Menu
Projects
Groups
Snippets
/
Help
Help
Support
Community forum
Keyboard shortcuts
?
Submit feedback
Contribute to GitLab
Sign in
Toggle navigation
Menu
Open sidebar
lannlife
ReportETL
Merge requests
!105
[LE-5606] fix: 优化 listCustCardByUserCoupon 索引利用
Code
Review changes
Check out branch
Download
Email patches
Plain diff
Merged
lannlife
requested to merge
LE-5606
into
milestone20260519
May 15, 2026
Overview
0
Commits
2
Changes
3
将 STATUS != 8 移至 WHERE 子句最后,让优化器优先利用 CARD_TYPE 和时间字段索引
时间条件由开区间 < 改为闭区间 <=
调用方 batchInsertCouponGotInfo 对 endDate 做减 1 秒处理,保持业务语义等价