CREATE INDEX orderActive ON t_trade_order_matchdetail(order_id_active(32));
create INDEX orderIds on t_trade_order_matchdetail(match_id,order_id_active,order_id_passive);
SHOW INDEX from t_trade_order_matchdetail;
explain select * from t_trade_order_matchdetail where match_id=‘190322170851986465’ and order_id_active=‘190322170851960560’ and order_id_passive=‘190322170821666420’