EXPLAIN execution Plan:

the following is my table structure. It takes 7 seconds to query more than 10, 000 pieces of data.
CREATE TABLE order_copy (
id bigint (20) NOT NULL AUTO_INCREMENT,
seq_id bigint) (20) NOT NULL DEFAULT"0" COMMENT "sort id",
ref_order_id bigint (20) DEFAULT" 0" COMMENT "cancel the order association id",
ref_seq_id bigint (20) DEFAULT" 0"COMMENT "cancel the order associated with id",

code
trade_name varchar (36) DEFAULT NULL COMMENT "trade pair",
symbol varchar (20) NOT NULL COMMENT "trade pair",
type varchar) (50) NOT NULL COMMENT "order type: rnBUY_LIMIT- limit buy rnSELL_LIMIT- limit sell rnBUY_LIMIT_CANCEL- cancel purchase order rnSELL_LIMIT_CANCEL- cancel sale order,
price decimal (20Tal8) NOT NULL COMMENT" Price",
amount decimal (20J8) NOT NULL COMMENT "quantity",
complete_amount decimal (20pai8) DEFAULT "0.00000000" COMMENT" fulfillment",
average_price decimal (20pai8) DEFAULT "0.00000000" COMMENT" average price,
consume_worth decimal (20jie8) DEFAULT "0.00000000" COMMENT" consumption value,
status varchar (20) NOT NULL COMMENT "order status: rnSUBMITTED- submits rnSEQUENCED- order rnFULLY_FILLED- completion part
created_time bigint (20) NOT NULL COMMENT "creation time",
updated_time bigint (20) NOT NULL DEFAULT"0" COMMENT "modification time",
version int (11) DEFAULT"0,
PRIMARY KEY ( id )
) ENGINE=InnoDB AUTO_INCREMENT=14891 DEFAULT CHARSET=utf8 COMMENT=" order form V2shipping;