16:58:07 [10.221.202.67] {root} (dw_trade_order_seller_db) > explain analyze SELECT /*+ USE_INDEX(trade_order_seller idx_seller_id_create_time_us)*/
-> id,
-> order_no,
-> sub_order_no,
-> biz_type,
-> biz_channel,
-> biz_code,
-> biz_id,
-> abs(sub_or…
集群只有版本区别,索引都是一样的。7.5.7版本也有index:idx_selid_status_close_time(seller_id, sub_order_status, close_time),但是SQL选择了走index:idx_seller_id_create_time_us(seller_id, create_time_us)
去掉后的查询条件
`seller_id` = 1764332565
AND `spu_id` = 4399003
AND `sub_order_status` IN (
10,
1000,
1100,
1200,
2000,
2003,
2004,
2005,
2006,
2007,
2010,
2015,
3000,
3010,
3020,
3030,
3035,
3040,
4000,
7000,
7500,
…