智能刊登gaussdb 慢sql top 10
2.解决方案
- 建议在数据表 irobotbox_marketpublish.Cs_ClearStock_Ebay_Situation 的 SellerSku,OrderSourceId,CustomerId,MarketId 列上添加如下索引，以提高查询性能：
ALTER TABLE `irobotbox_marketpublish`.`Cs_ClearStock_Ebay_Situation` ADD INDEX `idx_SellerSku_OrderSourceId_CustomerId_MarketId` (`SellerSku`, `OrderSourceId`, `CustomerId`, `MarketId`)
注意：在业务高峰期，变更表结构存在风险，请谨慎操作！
- 建议使用as关键字显示声明别名，隐式别名'`Cs_ClearStock_Ebay_Situation` m'可替换为更易懂的形式'`Cs_ClearStock_Ebay_Situation` AS m'。
- 发现IN表达式包含元素超过10，请慎用，因为元素过多会导致全表扫描。
3.原sql
SELECT m.*
FROM `Cs_ClearStock_Ebay_Situation` m
WHERE m.CustomerId = 1
AND m.MarketId = 2
AND m.OrderSourceId = 10486
AND m.SellerSku IN ('X06134421GYW1ST', 'J061836QLN2I3AV', '5061852BFHKW4CG', 'S061544ZUNXZFTD', '3061603FG77GZZI', 'P0616130POWTRF7', 'S061933YUZZWRGA', '1061616GGWY819S', '8062105A6QCACAM', 'U062139HLZHUND7', '6062726BXQCZ5SB', 'A061747PD241Q00', '6062730L2DIIUC4', '8062335YJH95VJM', 'T062358EWWATFZD', 'M062608MIPNKBSP', '7121747013P3C3L', '8121544T97564LP', 'Y121557IIE0GABE', '3121647FSH5YCWF', 'E121926TU0Y0A5X', 'P122535IFNSL4XC', 'I121941HDJKTYSQ', 'L122604FYQ2I5YT', 'Z122725B4537S5Z', '0122227N8UBZ2D8', 'V122310VY3ZAYLR', 'L122335I3G309PH', 'B123230VW35S391', 'N123026X08L48YM', 'K1233404B2ME4GB', 'B123351LYNMFQJR', 'O123437JFP27JJG', 'N123928H5OCINGH', 'Z1248022PRJCPSP', '4124232AA8D2Y4K', 'X124248IEDE0V17', 'K124440V9M0LU5N', 'F125529013KG4PR', 'H125531HRLV0DTH', 'D125611OTTOXYTA', '31249551NC9MZ9H', 'T125035CIVHMUQ1', 'H125038OVI4FZ6N', 'J125044D2H49YQA', '9125123SWK3HSKG', '71253476JR3OE6Q', '4125404ZDBM5IY1', 'O124541XH4QLRZR', 'V125556ZEMA82Y0', 'T125621BWX0OWB5', 'U125657QIJ2IHLL', '6125659W4UEJFJG', 'N130107FQSMRCWK', 'J130702LK2UT8EO', 'A130734IIX8S7Q2', 'B130915CHQZJLK2', 'H131221T17J9X3M', 'W130921GVZXIWDQ', 'B131228MY09NGX5', 'U131231R1B368YP', 'O131354KK3BYA5G', 'G130939C6ZB19OY', 'I1309456ULIPOX1', 'U131000W23USDOZ', 'Z131111NCVCYKT8', 'H13115946H9QLLS', 'B1320356EYU1AAE', '0131659IF4L8ZWY', 'E132647AZQW5RO1', '1131732S0398SZ5', 'E131737KKP72EMH', '413174177RNFY91', 'K133032AGUPUKPQ', '21335493KHSGKXR', '0133556Z138L2T0', 'Q134335ZOC5WK3L', 'K1339434Q88B78I', '813434775E4VIFN', 'Z134803BNZ7GLVC', 'D134809ECSMZI3C', 'B1344234SE6XCRR', 'D134211V7K58T3J', 'O134239SHSZ70L3', 'L1342452R865EUR', '4134309VIY7CE3R', '2134312OY72VP4A', '4134650WUPQJXCY', '4134737DTVURDW8', '0134425OZQ54XNU', '3072221GTY95OR3', 'X072227PZK5PAU8', 'N072257QDAVMDH3', '7072300BISSNSD6', 'E072353P5ABW4M2', '2005057551ESMNH')