You are viewing a plain text version of this content. The canonical link for it is here.
Posted to notifications@shardingsphere.apache.org by GitBox <gi...@apache.org> on 2022/10/10 06:30:35 UTC

[GitHub] [shardingsphere] novice-gamer opened a new issue, #19884: It is slow to use JDBC connection shardingsphere proxy to write

novice-gamer opened a new issue, #19884:
URL: https://github.com/apache/shardingsphere/issues/19884

   Shardingsphere proxy version 5.1.3
   It is slow to use JDBC connection shardingsphere proxy to write.
   
   Links used by stand-alone databases:
   ```
   jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true
   ```
   
   Links used by shardingsphere proxy:
   ```
   jdbc:mysql://127.0.0.1:3306/database?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true
   ```
   
   Is it necessary to modify parameters after changing to proxy to realize batch fast writing?
   


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] novice-gamer closed issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
novice-gamer closed issue #19884: It is slow to use JDBC connection shardingsphere proxy to write
URL: https://github.com/apache/shardingsphere/issues/19884


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] agoodcoolman commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
agoodcoolman commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1241377645

   I hava the same question .
   
   use Proxy 5.1.2 .
   this is command
   `java -server -Xmx8g -Xms8g -Xmn4g -Xss1024k -XX:+DisableExplicitGC -XX:+UseConcMarkSweepGC -XX:+CMSParallelRemarkEnabled -XX:LargePageSizeInBytes=4g -XX:+UseFastAccessorMethods -XX:+UseCMSInitiatingOccupancyOnly -XX:CMSInitiatingOccupancyFraction=70 -Dfile.encoding=UTF-8 -classpath %CLASS_PATH% %MAIN_CLASS%`
   
   
   server.yaml
   `rules:
     - !AUTHORITY
       users:
         - root@:XXXX
         - sharding@:XXXX
       provider:
         type: ALL_PRIVILEGES_PERMITTED
   
   props:
     max-connections-size-per-query: 1
     kernel-executor-size: 16  # Infinite by default.
     proxy-frontend-flush-threshold: 128  # The default value is 128.
     proxy-opentracing-enabled: false
     proxy-hint-enabled: false
     sql-show: true
     check-table-metadata-enabled: false`
   
   config-sharding.yaml
   `schemaName: sharding_db
   dataSources:
     ds0:
       url: jdbc:postgresql://XXX.XXX.XXX.XXXX:port/data
       username: [username]
       password: [password]
       connectionTimeoutMilliseconds: 30000
       idleTimeoutMilliseconds: 60000
       maxLifetimeMilliseconds: 1800000
       maxPoolSize: 50
       minPoolSize: 1
   
   rules:
     - !SHARDING
       tables:
         memberinfo:
           actualDataNodes: ds0.memberinfo_$->{[0,1,2,3,4,5,6,7,8,9]}
           tableStrategy:
             standard:
               shardingColumn: idcard
               shardingAlgorithmName: hash_mode10
         mzmember:
           actualDataNodes: ds0.mzmember_$->{[0,1,2,3]}
           tableStrategy:
             standard:
               shardingColumn: id_card
               shardingAlgorithmName: hash_mode4
         csvgonanhj:
           actualDataNodes: ds0.csvgonanhj_$->{[0,1,2,3,4,5,6,7,8,9]}
           tableStrategy:
             standard:
               shardingColumn: pid
               shardingAlgorithmName: hash_mode10
         memberresult:
           actualDataNodes: ds0.memberresult_$->{[0,1,2,3,4,5,6,7,8,9]}
           tableStrategy:
             standard:
               shardingColumn: idcard
               shardingAlgorithmName: hash_mode10
         applyinfo:
           actualDataNodes: ds0.applyinfo_$->{[0,1,2,3,4]}
           tableStrategy:
             standard:
               shardingColumn: idcard
               shardingAlgorithmName: hash_mode5
       defaultTableStrategy:
         none:
       shardingAlgorithms:
         hash_mode:
           type: HASH_MOD
           props:
             sharding-count: 1
         hash_mode10:
           type: HASH_MOD
           props:
             sharding-count: 10
         hash_mode4:
           type: HASH_MOD
           props:
             sharding-count: 4
         hash_mode5:
           type: HASH_MOD
           props:
             sharding-count: 5
       keyGenerators:
         snowflake:
           type: SNOWFLAKE
           props:
             worker-id: 123
       bindingTables:
         - memberinfo,csvgonanhj,memberresult`
   
   sql
   `select member_id, idcard, cast(substring(idcard, 7, 4) as int) as age1, cast(substring(idcard, 11, 2) as int) as age2 from memberresult limit 10 offset ?;`


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] github-actions[bot] closed issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
github-actions[bot] closed issue #19884: It is slow to use JDBC connection shardingsphere proxy to write
URL: https://github.com/apache/shardingsphere/issues/19884


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] TeslaCN commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1219275517

   Try setting `allowMultiQueries=false`. Then the MySQL Connector will send `COM_SET_OPTIONS` implicitly.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] novice-gamer commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1219106331

   
   When adding the rewritebatchedstatements = true parameter, an error will be reported, resulting in failure to insert.
   
   Code demo：
   ```
   val ip = Until.getProperty("bidAnalyse.ip")
   val port = Until.getProperty("bidAnalyse.port")
   val db = Until.getProperty("bidAnalyse.db")
   val user = Until.getProperty("bidAnalyse.user")
   val pwd = Until.getProperty("bidAnalyse.pw")
   Class.forName("com.mysql.jdbc.Driver")
   val jdbcUrl = "jdbc:mysql://" + ip + ":" + port + "/" + db + "?useUnicode=true&characterEncoding=UTF-8&autoReconnect=true&failOverReadOnly=false&useSSL=false&allowMultiQueries=true&rewriteBatchedStatements=true" //&rewriteBatchedStatements=true  batchHasPlainStatements=false
   DriverManager.getConnection(jdbcUrl, user, pwd)
   ```
   
   This is the proxy log：
   ```
   [INFO ] 2022-08-18 14:38:12.277 [ShardingSphere-Command-737] ShardingSphere-SQL - Logic SQL: insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','1' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','
 未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='1',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution =
  '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','2' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','202
 2-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='2',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',
 site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','3' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','
 ','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='3',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未�
 �',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','4' ,'','','','0','�
 �限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='4',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '华能(苏州工业园区)发电有限责��公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',rela
 tion = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_typ
 e1,phased_construction,expected_date,update_date,source_sort_id) values('','5' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='5',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '20
 22-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,indus
 try,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','6' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='6',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',ag
 ency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,
 open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','7' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='7',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact
  = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date
 ,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','8' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='8',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='�
 ��州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,pu
 rchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','9' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='9',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_o
 peration_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation
 _cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','10' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','中国政��采购招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='10',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_
 cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purch
 aser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','11' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江���省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='11',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',
 purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_
 prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','12' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='12',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '�
 �限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,pro
 ject_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','13' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='13',project_name = '',project_c
 ode = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(
 project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','14' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_d
 is_id = '',project_content_id ='14',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',s
 ource_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','15' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','',''
 ,'','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='15',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_
 construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','16' ,'','','','0','华能(苏州工业园区)发电有限责任��司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null'
 ,'','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='16',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry
  = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','17' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','',''
 ,'','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='17',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州���',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公
 告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','18' ,'','','','0','有限责任公司','','1
 0','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='18',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date 
 = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_s
 ort_id) values('','19' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='19',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告
 ',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,proje
 ct_type1,phased_construction,expected_date,update_date,source_sort_id) values('','20' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='20',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_da
 te = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055'
   [INFO ] 2022-08-18 14:38:12.278 [ShardingSphere-Command-737] ShardingSphere-SQL - Actual SQL: ds_0 ::: insert into bid_purchaser_info_dis_pro_2022(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id, id) values('', '1', '', '', '', '0', '有限责任公司', '', '10', '江苏省', '3205', '苏州市', '', '', '江苏省', '苏州市', '', '', '', '', '', '', '2022-08-17', '2022-08-17', '', '招�
 �公告', 'null', '', '', '2022年08月17日', '未知', '询价公告', 'http://www.xxx.com', '招标网', '', '', '', '', '', '', '', '', '20220817', '10055', 767033731038068736)ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='1',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = '
 http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','2' ,'','','','0','有限责任公司','','10','江苏省','32
 05','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='2',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17�
 �',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','
 3' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='3',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',q
 ualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_const
 ruction,expected_date,update_date,source_sort_id) values('','4' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='4',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budge
 t_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,sol
 ution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','5' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='5',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = ''
 ,collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '��国政府采购招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualific
 ation,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','6' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='6',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_c
 ontact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collec
 t_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','7' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='7',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityn
 ame='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_cont
 act,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','8' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='8',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purch
 aser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_ope
 ration_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','9' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='9',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏�
 �市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,pu
 rchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','10' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公��','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='10',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname =
  '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_pr
 ovname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','11' ,'','','','0','华能(苏州工业��区)发电有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='11',project_name = '',project_code = '',project_type = '',project_status = '0',
 purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,p
 roject_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','12' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='12',project_name
  = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchase
 r_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','13' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UP
 DATE  project_dis_id = '',project_content_id ='13',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date
  = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','14' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网'
 ,'','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='14',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_typ
 e1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','15' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月
 17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='15',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '��价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '
 ',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','16' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','202
 2-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='16',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http:/
 /www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','17' ,'','','','0','有限责任公司','','10','江苏省','3205','
 苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='17',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',i
 s_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','18' 
 ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='18',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '华能(苏州工业���区)发电有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type 
 = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,from_url,site_name,industry,product,solution,sub_industry,purcha
 sing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','19' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='19',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = '',agency_contact = '',agency_phone = '',collect_date = '2022-0
 8-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055';insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project_name,project_code,project_type,project_status,purchaser,purchaser_address,purchaser_prov_id,purchaser_provname,purchaser_city_id,purchaser_cityname,purchaser_county_id,purchaser_countyname,purchaser_operation_provname,purchaser_operation_cityname,purchaser_operation_countyname,purchaser_contact,purchaser_phone,agency,agency_contact,agency_phone,collect_date,public_date,budget_fund,affiche_type,relation,qualification,open_date,end_date,is_combo,bid_type,f
 rom_url,site_name,industry,product,solution,sub_industry,purchasing_list,project_type1,phased_construction,expected_date,update_date,source_sort_id) values('','20' ,'','','','0','有限责任公司','','10','江苏省','3205','苏州市','','','江苏省','苏州市','','','','','','','2022-08-17','2022-08-17','','招标公告','null','','','2022年08月17日','未知','询价公告','http://www.xxx.com','招标网','','','','','','','','','20220817','10055')ON DUPLICATE KEY UPDATE  project_dis_id = '',project_content_id ='20',project_name = '',project_code = '',project_type = '',project_status = '0',purchaser = '有限责任公司' ,purchaser_address = '',purchaser_prov_id='',purchaser_provname = '江苏省',purchaser_city_id= '3205',purchaser_cityname = '苏州市',purchaser_county_id= '',purchaser_countyname = '',purchaser_operation_provname='江苏省',purchaser_operation_cityname='苏州市',purchaser_operation_countyname='',purchaser_contact = '',purchaser_phone = '',agency = 
 '',agency_contact = '',agency_phone = '',collect_date = '2022-08-17',public_date = '2022-08-17',budget_fund = '',affiche_type = '招标公告',relation = 'null',qualification = '',open_date = '',end_date = '2022年08月17日',is_combo = '未知',bid_type = '询价公告',from_url = 'http://www.xxx.com',site_name = '招标网',industry = '',product = '',solution = '',sub_industry = '',purchasing_list = '',project_type1 = '',phased_construction = '',expected_date = '',update_date = '20220817',source_sort_id = '10055'
   [ERROR] 2022-08-18 14:38:12.282 [ShardingSphere-Command-737] o.a.s.p.f.c.CommandExecutorTask - Exception occur: 
   com.mysql.jdbc.exceptions.jdbc4.MySQLSyntaxErrorException: You have an error in your SQL syntax; check the manual that corresponds to your MySQL server version for the right syntax to use near 'insert into bid_purchaser_info_dis_pro(project_dis_id,project_content_id,project' at line 1
   ```


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] TeslaCN commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1206071255

   Try adding `rewriteBatchedStatements=true` to client's JDBC URL.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] github-actions[bot] commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
github-actions[bot] commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1272349081

   Hello , this issue has not received a reply for several days.
   This issue is supposed to be closed.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] TeslaCN commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
TeslaCN commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1217497652

   Could you provide a demo about this issue? There are too many reasons could impact performance.


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org

[GitHub] [shardingsphere] novice-gamer commented on issue #19884: It is slow to use JDBC connection shardingsphere proxy to write

Posted by GitBox <gi...@apache.org>.
novice-gamer commented on issue #19884:
URL: https://github.com/apache/shardingsphere/issues/19884#issuecomment-1217401064

   This parameter is added when the spark program calls JDBC to use the database, but it is still slow. Is there any other recommended optimization method?


-- 
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.

To unsubscribe, e-mail: notifications-unsubscribe@shardingsphere.apache.org

For queries about this service, please contact Infrastructure at:
users@infra.apache.org