要出入的表结构：
CREATE TABLE test.test_dws_performance_order6 (
id bigint(20) unsigned NOT NULL AUTO_INCREMENT,
order_no bigint(20) unsigned DEFAULT NULL ,
fs_order_no varchar(64) DEFAULT NULL ,
item_id bigint(20) unsigned DEFAULT NULL ,
item_ids varchar(2000) DEFAULT NULL ,
item_names varchar(2000) DEFAULT NULL ,
sku_id bigint(20) unsigned DEFAULT NULL ,
sku_ids varchar(2000) DEFAULT NULL ,
sku_names varchar(2000) DEFAULT NULL ,
cate_id bigint(20) DEFAULT NULL ,
cate_name varchar(500) DEFAULT NULL ,
biz_type_id bigint(20) DEFAULT NULL ,
biz_type_name varchar(20) DEFAULT NULL ,
position_type_id tinyint(4) DEFAULT NULL ,
institution_id bigint(20) DEFAULT NULL ,
weimaihao bigint(20) DEFAULT NULL ,
user_name varchar(100) DEFAULT NULL ,
mobile varchar(12) DEFAULT NULL ,
doctor_id bigint(20) DEFAULT NULL ,
doctor_name varchar(50) DEFAULT NULL ,
pay_time datetime DEFAULT NULL ,
order_amount decimal(20,4) DEFAULT NULL ,
pay_amount decimal(20,4) DEFAULT NULL ,
preference_amount decimal(20,4) DEFAULT NULL ,
drug_amount decimal(20,4) DEFAULT NULL,
gradient_preference_amount decimal(20,4) DEFAULT NULL,
confirmed_amount decimal(20,2) DEFAULT NULL ,
base_amount decimal(20,4) DEFAULT NULL,
performance_points bigint(20) DEFAULT NULL ,
performance_coefficient decimal(20,4) DEFAULT NULL ,
bd_id bigint(20) DEFAULT NULL ,
bd_role_id tinyint(4) DEFAULT NULL ,
bd_name varchar(40) DEFAULT NULL ,
exclude_reason_id bigint(20) DEFAULT ‘0’ ,
create_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ,
update_time timestamp NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP ,
PRIMARY KEY (id) /*T![clustered_index] CLUSTERED */,
UNIQUE KEY uk_order_no (order_no),
UNIQUE KEY uk_fs_order_no (fs_order_no),
KEY idx_pay_time (pay_time),
KEY idx_bd_id (bd_id),
KEY idx_weimaihao (weimaihao),
KEY idx_doctor_id (doctor_id),
KEY idx_update_time (update_time)
) ENGINE=InnoDB DEFAULT CHARSET=utf8mb4 COLLATE=utf8mb4_bin