insert into `qk_chi` . `perio_artical` ( `random_id` , `article_id` , `perio_id` , `issue_id` , `perio_title` , `trans_title` , `doi` , `article_seq` , `article_title` , `en_title` , `authors_name` , `trans_authors` , `authors_unit` , `column_name` , `trans_column` , `publish_year` , `volume` , `issue_num` , `abstract` , `orig_abstract` , `trans_abstract` , `text_segment` , `language` , `trans_language` , `keywords` , `orig_keys` , `trans_keys` , `auto_keys` , `head_words` , `head_table` , `class_code` , `orig_classcode` , `orig_class` , `auto_classcode` , `page_range` , `page_cnt` , `doc_num` , `literature_code` , `received_date` , `revised_date` , `orig_pub_date` , `pro_pub_date` , `abst_webdate` , `full_pubdate` , `abstract_url` , `full_url` , `is_fulltext` , `is_oa` , `service_model` , `cn` , `issn` , `hxkbj_istic` , `hxkbj_pku` , `hxkbj_nd` , `hxkbj_ei` , `hxkbj_sci` , `refdoc_cnt` , `linkdoc_cnt` , `cited_cnt` , `fund_info` , `core_perio` , `is_nstl` , `first_publish` , `source_db` , `first_authors` , `batch_id` , `classname_1` , `classname_2` , `classname_3` , `down_count` , `view_count` , `org_name` , `new_org` , `auth_area` , `auth_city` , `auth_county` , `education_code` , `projectid` , `fundgroupnamezh` , `projectgrantno` , `isthirdservice` ) values ( ... ) on duplicate key update `random_id` = values ( `random_id` ) , `perio_id` = values ( `perio_id` ) , `issue_id` = values ( `issue_id` ) , `perio_title` = values ( `perio_title` ) , `trans_title` = values ( `trans_title` ) , `doi` = values ( `doi` ) , `article_seq` = values ( `article_seq` ) , `article_title` = values ( `article_title` ) , `en_title` = values ( `en_title` ) , `authors_name` = values ( `authors_name` ) , `trans_authors` = values ( `trans_authors` ) , `authors_unit` = values ( `authors_unit` ) , `column_name` = values ( `column_name` ) , `trans_column` = values ( `trans_column` ) , `publish_year` = values ( `publish_year` ) , `volume` = values ( `volume` ) , `issue_num` = values ( `issue_num` ) , `abstract` = values ( `abstract` ) , `orig_abstract` = values ( `orig_abstract` ) , `trans_abstract` = values ( `trans_abstract` ) , `text_segment` = values ( `text_segment` ) , `language` = values ( `language` ) , `trans_language` = values ( `trans_language` ) , `keywords` = values ( `keywords` ) , `orig_keys` = values ( `orig_keys` ) , `trans_keys` = values ( `trans_keys` ) , `auto_keys` = values ( `auto_keys` ) , `head_words` = values ( `head_words` ) , `head_table` = values ( `head_table` ) , `class_code` = values ( `class_code` ) , `orig_classcode` = values ( `orig_classcode` ) , `orig_class` = values ( `orig_class` ) , `auto_classcode` = values ( `auto_classcode` ) , `page_range` = values ( `page_range` ) , `page_cnt` = values ( `page_cnt` ) , `doc_num` = values ( `doc_num` ) , `literature_code` = values ( `literature_code` ) , `received_date` = values ( `received_date` ) , `revised_date` = values ( `revised_date` ) , `orig_pub_date` = values ( `orig_pub_date` ) , `pro_pub_date` = values ( `pro_pub_date` ) , `abst_webdate` = values ( `abst_webdate` ) , `full_pubdate` = values ( `full_pubdate` ) , `abstract_url` = values ( `abstract_url` ) , `full_url` = values ( `full_url` ) , `is_fulltext` = values ( `is_fulltext` ) , `is_oa` = values ( `is_oa` ) , `service_model` = values ( `service_model` ) , `cn` = values ( `cn` ) , `issn` = values ( `issn` ) , `hxkbj_istic` = values ( `hxkbj_istic` ) , `hxkbj_pku` = values ( `hxkbj_pku` ) , `hxkbj_nd` = values ( `hxkbj_nd` ) , `hxkbj_ei` = values ( `hxkbj_ei` ) , `hxkbj_sci` = values ( `hxkbj_sci` ) , `refdoc_cnt` = values ( `refdoc_cnt` ) , `linkdoc_cnt` = values ( `linkdoc_cnt` ) , `cited_cnt` = values ( `cited_cnt` ) , `fund_info` = values ( `fund_info` ) , `core_perio` = values ( `core_perio` ) , `is_nstl` = values ( `is_nstl` ) , `first_publish` = values ( `first_publish` ) , `source_db` = values ( `source_db` ) , `first_authors` = values ( `first_authors` ) , `batch_id` = values ( `batch_id` ) , `classname_1` = values ( `classname_1` ) , `classname_2` = values ( `classname_2` ) , `classname_3` = values(len:4660)
我们也有这样的语句，但是并不慢