| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195 |
- 2022-07-22 14:39:34.367 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 35100 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:39:34.378 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: ${activeProfile}
- 2022-07-22 14:39:36.614 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8080"]
- 2022-07-22 14:39:36.615 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:39:36.616 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:39:36.744 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:39:36.803 [main] INFO org.apache.catalina.core.StandardService - Stopping service [Tomcat]
- 2022-07-22 14:41:41.431 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 43304 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:41:41.434 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: ${activeProfile}
- 2022-07-22 14:41:43.076 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8080"]
- 2022-07-22 14:41:43.076 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:41:43.077 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:41:43.180 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:41:43.220 [main] INFO org.apache.catalina.core.StandardService - Stopping service [Tomcat]
- 2022-07-22 14:43:18.341 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 26748 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:43:18.344 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: ${activeProfile}
- 2022-07-22 14:43:20.057 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8080"]
- 2022-07-22 14:43:20.057 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:43:20.058 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:43:20.156 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:43:20.206 [main] INFO org.apache.catalina.core.StandardService - Stopping service [Tomcat]
- 2022-07-22 14:46:58.182 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 33576 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:46:58.186 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: ${activeProfile}
- 2022-07-22 14:46:59.772 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8080"]
- 2022-07-22 14:46:59.772 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:46:59.773 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:46:59.928 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:46:59.972 [main] INFO org.apache.catalina.core.StandardService - Stopping service [Tomcat]
- 2022-07-22 14:56:32.847 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 42860 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:56:32.850 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
- 2022-07-22 14:56:35.432 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
- 2022-07-22 14:56:35.433 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:56:35.433 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:56:35.595 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:56:37.258 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 14:56:37.426 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 14:56:37.592 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 14:56:37.774 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
- 2022-07-22 14:56:40.998 [main] INFO com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
- 2022-07-22 14:56:43.058 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@767cc126[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 14:56:43.073 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@70ad0854[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 14:56:43.074 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@76208b80[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
- 2022-07-22 14:56:43.253 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
- 2022-07-22 14:56:43.330 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 12.651 seconds (JVM running for 14.366)
- 2022-07-22 14:56:44.935 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server start success, nettype = class com.xxl.job.core.server.EmbedServer, port = 8198
- 2022-07-22 14:56:47.286 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry fail, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=500, msg=xxl-rpc remoting error(Connection refused: connect), for url : http://127.0.0.1:30000/xxl-job-admin/api/registry, content=null]
- 2022-07-22 14:57:52.443 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop.
- 2022-07-22 14:57:52.449 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry-remove success, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=200, msg=null, content=null]
- 2022-07-22 14:57:52.449 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory.
- 2022-07-22 14:57:52.449 [SpringApplicationShutdownHook] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success.
- 2022-07-22 14:57:52.450 [xxl-job, executor TriggerCallbackThread] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory.
- 2022-07-22 14:57:52.450 [Thread-4] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.
- 2022-07-22 14:57:57.386 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 43716 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 14:57:57.388 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
- 2022-07-22 14:57:58.720 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
- 2022-07-22 14:57:58.721 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 14:57:58.721 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 14:57:58.837 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 14:57:59.979 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 14:58:00.129 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 14:58:00.267 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 14:58:00.402 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
- 2022-07-22 14:58:01.839 [main] INFO com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
- 2022-07-22 14:58:02.307 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@52a67293[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 14:58:02.308 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@67c21bf[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 14:58:02.308 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@67afe909[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
- 2022-07-22 14:58:02.356 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
- 2022-07-22 14:58:02.378 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 6.119 seconds (JVM running for 7.166)
- 2022-07-22 14:58:02.903 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server start success, nettype = class com.xxl.job.core.server.EmbedServer, port = 8198
- 2022-07-22 15:00:00.284 [xxl-rpc, EmbedServer bizThreadPool-1442567787] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@52a67293[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 15:00:00.346 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from parse_type
- 2022-07-22 15:00:00.347 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=parse_type, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=parse_type)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 15:00:00.347 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type
- 2022-07-22 15:00:00.439 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
- 2022-07-22 15:00:00.439 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 15:00:00.439 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
- 2022-07-22 15:01:34.027 [Thread-7] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main]
- 2022-07-22 15:02:00.022 [xxl-rpc, EmbedServer bizThreadPool-167956770] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@52a67293[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 15:03:33.261 [Thread-9] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-9,10,main]
- 2022-07-22 15:04:00.029 [xxl-rpc, EmbedServer bizThreadPool-1589069362] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@52a67293[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 15:04:00.139 [Thread-12] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? )
- 2022-07-22 15:04:00.139 [Thread-12] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@2bbdaa8d], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125)
- 2022-07-22 15:04:00.139 [Thread-12] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_07 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220722150300, 20220722150308, 2.320000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220722150300, 20220722150308, 3.540000000000]]
- 2022-07-22 15:04:00.222 [Thread-12] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
- 2022-07-22 15:04:00.223 [Thread-12] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@309f1b3d], parametersIndex=13)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=268)
- 2022-07-22 15:04:00.223 [Thread-12] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_07 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S3, 20220722150300, 20220722150308, null, null, 4.250000000000, 0.030000000000, 2.800000000000, null, null, null, null, null]]
- 2022-07-22 15:05:00.045 [xxl-rpc, EmbedServer bizThreadPool-1589069362] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@67c21bf[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 15:05:00.047 [Thread-14] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
- 2022-07-22 15:05:00.047 [Thread-14] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 15:05:00.048 [Thread-14] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
- 2022-07-22 15:06:33.414 [Thread-13] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-13,10,main]
- 2022-07-22 15:06:52.237 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop.
- 2022-07-22 15:06:52.241 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry-remove success, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=200, msg=null, content=null]
- 2022-07-22 15:06:52.242 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory.
- 2022-07-22 15:06:52.242 [SpringApplicationShutdownHook] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success.
- 2022-07-22 15:06:52.245 [Thread-11] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-11,10,main]
- 2022-07-22 15:06:52.245 [xxl-job, executor TriggerCallbackThread] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory.
- 2022-07-22 15:06:52.246 [Thread-4] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.
- 2022-07-22 15:07:02.132 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 12472 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 15:07:02.136 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
- 2022-07-22 15:07:04.651 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
- 2022-07-22 15:07:04.652 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 15:07:04.652 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 15:07:04.852 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 15:07:06.941 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 15:07:07.137 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 15:07:07.344 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 15:07:07.579 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
- 2022-07-22 15:07:10.966 [main] INFO com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
- 2022-07-22 15:07:12.662 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@3e8fe7db[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
- 2022-07-22 15:07:12.666 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@5af641d3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 15:07:12.666 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@14e83c9d[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 15:07:12.763 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
- 2022-07-22 15:07:12.809 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 13.341 seconds (JVM running for 15.664)
- 2022-07-22 15:07:13.461 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server start success, nettype = class com.xxl.job.core.server.EmbedServer, port = 8198
- 2022-07-22 15:07:56.417 [xxl-rpc, EmbedServer bizThreadPool-212715741] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@14e83c9d[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 15:07:56.494 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from parse_type
- 2022-07-22 15:07:56.494 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=parse_type, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=parse_type)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 15:07:56.494 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type
- 2022-07-22 15:07:56.552 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
- 2022-07-22 15:07:56.553 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 15:07:56.553 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
- 2022-07-22 15:14:24.793 [Thread-10] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? )
- 2022-07-22 15:14:24.793 [Thread-10] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@71b9e4b7], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125)
- 2022-07-22 15:14:24.794 [Thread-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_07 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220722150800, 20220722150849, 2.530000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220722150800, 20220722150849, 5.910000000000]]
- 2022-07-22 15:14:25.093 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server stop.
- 2022-07-22 15:14:25.098 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job registry-remove success, registryParam:RegistryParam{registryGroup='EXECUTOR', registryKey='cems-hj212-db', registryValue='http://127.0.0.1:8198/'}, registryResult:ReturnT [code=200, msg=null, content=null]
- 2022-07-22 15:14:25.099 [xxl-job, executor ExecutorRegistryThread] INFO com.xxl.job.core.thread.ExecutorRegistryThread - >>>>>>>>>>> xxl-job, executor registry thread destory.
- 2022-07-22 15:14:25.099 [SpringApplicationShutdownHook] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server destroy success.
- 2022-07-22 15:14:25.102 [Thread-7] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main]
- 2022-07-22 15:14:25.102 [xxl-job, executor TriggerCallbackThread] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor callback thread destory.
- 2022-07-22 15:14:25.103 [Thread-4] INFO com.xxl.job.core.thread.TriggerCallbackThread - >>>>>>>>>>> xxl-job, executor retry callback thread destory.
- 2022-07-22 16:57:32.524 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Starting DBServiceApplication using Java 1.8.0_321 on LAPTOP-RTMRD03L with PID 33008 (D:\iwb-workstation-2021\InternetOfThing\fbs_code\fbs-server-parent\fbs-server-dbservice\target\classes started by Lenovo in D:\iwb-workstation-2021\InternetOfThing\fbs_code)
- 2022-07-22 16:57:32.528 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - The following profiles are active: dev
- 2022-07-22 16:57:35.058 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8196"]
- 2022-07-22 16:57:35.059 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 16:57:35.060 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 16:57:35.213 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 16:57:36.924 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 16:57:37.068 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 16:57:37.211 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 16:57:37.356 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
- 2022-07-22 16:57:39.065 [main] INFO com.yyjc.fbs.server.dbserveice.config.XxlJobConfig - >>>>>>>>>>> xxl-job config init.
- 2022-07-22 16:57:39.676 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 16:57:39.677 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysOnlineDataErrorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@107ebdad[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#executeError]
- 2022-07-22 16:57:39.677 [main] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job register jobhandler success, name:sysMonitorJobHandler, jobHandler:com.xxl.job.core.handler.impl.MethodJobHandler@e3275d3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 16:57:39.731 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8196"]
- 2022-07-22 16:57:39.756 [main] INFO com.yyjc.fbs.server.dbserveice.DBServiceApplication - Started DBServiceApplication in 9.569 seconds (JVM running for 11.457)
- 2022-07-22 16:57:40.310 [Thread-5] INFO com.xxl.job.core.server.EmbedServer - >>>>>>>>>>> xxl-job remoting server start success, nettype = class com.xxl.job.core.server.EmbedServer, port = 8189
- 2022-07-22 16:58:00.332 [xxl-rpc, EmbedServer bizThreadPool-950819035] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 16:58:00.406 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from parse_type
- 2022-07-22 16:58:00.407 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=parse_type, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=parse_type)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 16:58:00.407 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-server-config ::: select * from t_parse_type
- 2022-07-22 16:58:00.465 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
- 2022-07-22 16:58:00.466 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 16:58:00.466 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
- 2022-07-22 16:58:08.014 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? )
- 2022-07-22 16:58:08.014 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@4c173a18], parametersIndex=8)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=125)
- 2022-07-22 16:58:08.014 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_07 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S2, 20220722151300, 20220722151349, 3.740000000000, C9ADFEEFC4EB4EB08FB296F4S1, 20220722151300, 20220722151349, 5.260000000000]]
- 2022-07-22 16:58:08.031 [Thread-8] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
- 2022-07-22 16:58:08.031 [Thread-8] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@2030fec8], parametersIndex=13)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=268)
- 2022-07-22 16:58:08.031 [Thread-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_07 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[C9ADFEEFC4EB4EB08FB296F4S3, 20220722151300, 20220722151349, null, null, 3.910000000000, 0.130000000000, 1.650000000000, null, null, null, null, null]]
- 2022-07-22 16:59:41.331 [Thread-7] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-7,10,main]
- 2022-07-22 17:00:00.045 [xxl-rpc, EmbedServer bizThreadPool-1502973586] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:00:00.175 [Thread-10] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_electric (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? ),( ?,?,?, ? )
- 2022-07-22 17:00:00.175 [Thread-10] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_electric, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=5})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=9})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=13})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=17})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=21})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=25})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=29})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=33})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=37})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=41})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=45})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=49})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=53})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=57})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=61})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=65})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=69})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=73})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=77})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=81})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=85})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=89})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=93})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=97})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=101})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=105})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=109})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=113})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=117})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=121})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=125})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=129})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=133})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=137})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=141})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=145})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=149})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=153})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=157})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=161})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=165})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=169})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=173})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=177})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=181})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=185})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=189})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=193})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=197})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=201})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=205})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=209})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=213})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=217})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=221})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=225})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=229})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=233})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=237})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=241})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=245})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=249})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=253})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=257})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=261})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=265})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=269})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=273})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=277})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=281})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=285})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=289})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=293})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=297})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=301})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=305})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=309})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=313})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=317})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=321})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=325})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=329})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=333})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=337})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=341})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=345})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=349})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=353})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=357})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=361})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=365})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=369})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=373})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=377})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=381})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=385})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=389})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=393})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=397})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=401})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=405})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=409})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=413})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=417})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=421})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=425})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=429})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=433})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=437})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=441})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=445})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=449})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=453})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=457})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=461})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=465})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=469})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=473})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=477})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=481})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=485})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=489})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=493})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=497})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=501})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=505})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=509})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=513})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=517})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=521})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=525})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=529})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=533})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=537})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=541})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=545})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=549})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=553})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=557})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=561})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=565})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=569})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=573})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=577})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=581})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=585})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=589})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=593})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=597})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=601})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=605})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=609})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=613})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=617})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=621})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=625})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=629})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=633})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=637})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=641})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=645})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=649})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=653})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=657})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=661})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=665})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=669})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=673})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=677})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=681})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=685})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=689})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=693})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=697})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=701})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=705})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=709})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=713})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=717})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=721})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=725})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=729})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=733})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=737})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=741})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=745})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=749})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=753})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=757})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=761})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=765})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=769})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=773})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=777})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=781})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=785})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=789})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=793})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_electric), operator=EQUAL, positionValueMap={}, positionIndexMap={0=797})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_electric), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@89c95ce], parametersIndex=800)), columns=[Column(name=terminal_id, tableName=online_data_electric), Column(name=upload_date, tableName=online_data_electric), Column(name=insert_time, tableName=online_data_electric), Column(name=ia, tableName=online_data_electric)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4), InsertValue(expression=( ?,?,?, ? ), parametersCount=4)]), columnsListLastPosition=83, generateKeyColumnIndex=-1, insertValuesListLastPosition=3293)
- 2022-07-22 17:00:00.177 [Thread-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_electric_07 (terminal_id,upload_date,insert_time, ia ) VALUES ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ), ( ?,?,?, ? ) ::: [[iwb100071S2, 20220722165500, 20220722165841, 4.22000000, iwb100040S2, 20220722165500, 20220722165841, 4.33000000, iwb100043S2, 20220722165500, 20220722165841, 4.91000000, iwb100012S2, 20220722165500, 20220722165841, 2.51000000, iwb100092S1, 20220722165500, 20220722165841, 4.95000000, iwb100077S2, 20220722165500, 20220722165841, 4.32000000, iwb100061S1, 20220722165500, 20220722165841, 5.32000000, iwb100046S2, 20220722165500, 20220722165841, 2.99000000, iwb100095S1, 20220722165500, 20220722165841, 4.61000000, iwb100074S2, 20220722165500, 20220722165841, 3.73000000, iwb100027S1, 20220722165500, 20220722165841, 5.33000000, iwb100033S1, 20220722165500, 20220722165841, 4.33000000, iwb100064S1, 20220722165500, 20220722165841, 2.75000000, iwb100067S1, 20220722165500, 20220722165841, 2.1000000, iwb100030S1, 20220722165500, 20220722165841, 4.68000000, iwb100002S1, 20220722165500, 20220722165841, 4.47000000, iwb100036S1, 20220722165500, 20220722165841, 3.67000000, iwb100005S1, 20220722165500, 20220722165841, 3.69000000, iwb100086S1, 20220722165500, 20220722165841, 2.31000000, iwb100037S2, 20220722165500, 20220722165841, 4.33000000, iwb100098S1, 20220722165500, 20220722165841, 3.95000000, iwb100021S1, 20220722165500, 20220722165841, 5.9000000, iwb100024S1, 20220722165500, 20220722165841, 3.11000000, iwb100049S2, 20220722165500, 20220722165841, 2.5000000, iwb100083S1, 20220722165500, 20220722165841, 2.18000000, iwb100089S1, 20220722165500, 20220722165841, 4.52000000, iwb100080S1, 20220722165500, 20220722165841, 3.31000000, iwb100021S2, 20220722165500, 20220722165841, 4.92000000, iwb100024S2, 20220722165500, 20220722165841, 2.83000000, iwb100011S1, 20220722165500, 20220722165841, 2.25000000, iwb100018S1, 20220722165500, 20220722165841, 4.47000000, iwb100042S1, 20220722165500, 20220722165841, 5.89000000, iwb100045S1, 20220722165500, 20220722165841, 5.89000000, iwb100014S1, 20220722165500, 20220722165841, 3.69000000, iwb100000S2, 20220722165500, 20220722165841, 4.92000000, iwb100003S2, 20220722165500, 20220722165841, 2.83000000, iwb100099S2, 20220722165500, 20220722165841, 2.88000000, iwb100048S1, 20220722165500, 20220722165841, 4.1000000, iwb100008S1, 20220722165500, 20220722165841, 4.12000000, iwb100096S2, 20220722165500, 20220722165841, 2.88000000, iwb100039S1, 20220722165500, 20220722165841, 5.89000000, iwb100090S2, 20220722165500, 20220722165841, 4.97000000, iwb100093S2, 20220722165500, 20220722165841, 3.14000000, iwb100006S2, 20220722165500, 20220722165841, 2.19000000, iwb100087S2, 20220722165500, 20220722165841, 3.31000000, iwb100009S2, 20220722165500, 20220722165840, 3.26000000, iwb100018S2, 20220722165500, 20220722165841, 3.85000000, iwb100015S2, 20220722165500, 20220722165841, 4.92000000, iwb100027S2, 20220722165500, 20220722165841, 4.5000000, iwb100030S2, 20220722165500, 20220722165841, 4.01000000, iwb100002S2, 20220722165500, 20220722165841, 3.85000000, iwb100098S2, 20220722165500, 20220722165841, 3.46000000, iwb100033S2, 20220722165500, 20220722165841, 3.74000000, iwb100036S2, 20220722165500, 20220722165841, 3.25000000, iwb100051S1, 20220722165500, 20220722165841, 4.1000000, iwb100095S2, 20220722165500, 20220722165841, 3.95000000, iwb100020S1, 20220722165500, 20220722165841, 4.9000000, iwb100054S1, 20220722165500, 20220722165841, 4.88000000, iwb100092S2, 20220722165500, 20220722165841, 4.21000000, iwb100006S1, 20220722165500, 20220722165841, 2.25000000, iwb100009S1, 20220722165500, 20220722165840, 3.69000000, iwb100023S1, 20220722165500, 20220722165841, 4.24000000, iwb100026S1, 20220722165500, 20220722165841, 5.33000000, iwb100050S2, 20220722165500, 20220722165841, 2.5000000, iwb100057S1, 20220722165500, 20220722165841, 3.76000000, iwb100053S2, 20220722165500, 20220722165841, 4.16000000, iwb100056S2, 20220722165500, 20220722165841, 2.24000000, iwb100071S1, 20220722165500, 20220722165841, 4.97000000, iwb100041S2, 20220722165500, 20220722165841, 4.91000000, iwb100044S2, 20220722165500, 20220722165841, 4.91000000, iwb100017S1, 20220722165500, 20220722165841, 5.9000000, iwb100047S2, 20220722165500, 20220722165841, 2.99000000, iwb100012S1, 20220722165500, 20220722165841, 2.68000000, iwb100077S1, 20220722165500, 20220722165841, 5.09000000, iwb100074S1, 20220722165500, 20220722165841, 4.31000000, iwb100015S1, 20220722165500, 20220722165841, 5.9000000, iwb100029S1, 20220722165500, 20220722165841, 4.68000000, iwb100003S1, 20220722165500, 20220722165841, 3.11000000, iwb100000S1, 20220722165500, 20220722165841, 5.9000000, iwb100068S1, 20220722165500, 20220722165841, 3.53000000, iwb100065S1, 20220722165500, 20220722165841, 2.75000000, iwb100062S1, 20220722165500, 20220722165841, 4.54000000, iwb100011S2, 20220722165500, 20220722165841, 2.19000000, iwb100014S2, 20220722165500, 20220722165841, 3.26000000, iwb100005S2, 20220722165500, 20220722165841, 3.26000000, iwb100008S2, 20220722165500, 20220722165841, 3.59000000, iwb100017S2, 20220722165500, 20220722165841, 4.92000000, iwb100083S2, 20220722165500, 20220722165841, 2.13000000, iwb100038S2, 20220722165500, 20220722165841, 4.91000000, iwb100080S2, 20220722165500, 20220722165841, 2.98000000, iwb100089S2, 20220722165500, 20220722165841, 3.89000000, iwb100086S2, 20220722165500, 20220722165841, 2.23000000, iwb100062S2, 20220722165500, 20220722165841, 3.9000000, iwb100068S2, 20220722165500, 20220722165841, 3.15000000, iwb100065S2, 20220722165500, 20220722165841, 2.56000000, iwb100059S2, 20220722165500, 20220722165841, 3.41000000, iwb100013S1, 20220722165500, 20220722165841, 3.69000000, iwb100047S1, 20220722165500, 20220722165841, 3.32000000, iwb100029S2, 20220722165500, 20220722165841, 4.01000000, iwb100044S1, 20220722165500, 20220722165841, 5.89000000, iwb100075S1, 20220722165500, 20220722165841, 5.75000000, iwb100078S1, 20220722165500, 20220722165841, 2.53000000, iwb100026S2, 20220722165500, 20220722165841, 4.5000000, iwb100091S2, 20220722165500, 20220722165841, 2.55000000, iwb100094S2, 20220722165500, 20220722165841, 3.95000000, iwb100097S2, 20220722165500, 20220722165841, 4.8000000, iwb100035S2, 20220722165500, 20220722165841, 4.91000000, iwb100032S2, 20220722165500, 20220722165841, 3.74000000, iwb100023S2, 20220722165500, 20220722165841, 3.68000000, iwb100085S2, 20220722165500, 20220722165841, 4.64000000, iwb100020S2, 20220722165500, 20220722165841, 4.17000000, iwb100038S1, 20220722165500, 20220722165841, 5.89000000, iwb100088S2, 20220722165500, 20220722165841, 4.38000000, iwb100056S1, 20220722165500, 20220722165841, 2.32000000, iwb100041S1, 20220722165500, 20220722165841, 5.89000000, iwb100082S2, 20220722165500, 20220722165841, 4.06000000, iwb100059S1, 20220722165500, 20220722165841, 3.88000000, iwb100050S1, 20220722165500, 20220722165841, 2.67000000, iwb100053S1, 20220722165500, 20220722165841, 4.88000000, iwb100063S1, 20220722165500, 20220722165841, 3.88000000, iwb100048S2, 20220722165500, 20220722165841, 3.58000000, iwb100032S1, 20220722165500, 20220722165841, 4.33000000, iwb100035S1, 20220722165500, 20220722165841, 5.89000000, iwb100066S1, 20220722165500, 20220722165841, 2.1000000, iwb100069S1, 20220722165500, 20220722165841, 4.97000000, iwb100060S1, 20220722165500, 20220722165841, 4.54000000, iwb100060S2, 20220722165500, 20220722165841, 3.9000000, iwb100090S1, 20220722165500, 20220722165841, 5.96000000, iwb100075S2, 20220722165500, 20220722165841, 4.81000000, iwb100078S2, 20220722165500, 20220722165841, 2.4000000, iwb100072S2, 20220722165500, 20220722165841, 4.81000000, iwb100063S2, 20220722165500, 20220722165841, 3.41000000, iwb100066S2, 20220722165500, 20220722165841, 2.07000000, iwb100069S2, 20220722165500, 20220722165841, 4.22000000, iwb100084S1, 20220722165500, 20220722165841, 5.53000000, iwb100099S1, 20220722165500, 20220722165841, 3.17000000, iwb100096S1, 20220722165500, 20220722165841, 3.17000000, iwb100051S2, 20220722165500, 20220722165841, 3.58000000, iwb100072S1, 20220722165500, 20220722165841, 5.75000000, iwb100054S2, 20220722165500, 20220722165841, 4.16000000, iwb100057S2, 20220722165500, 20220722165841, 3.32000000, iwb100045S2, 20220722165500, 20220722165841, 4.91000000, iwb100087S1, 20220722165500, 20220722165841, 3.74000000, iwb100039S2, 20220722165500, 20220722165841, 4.91000000, iwb100093S1, 20220722165500, 20220722165841, 3.52000000, iwb100042S2, 20220722165500, 20220722165841, 4.91000000, iwb100081S1, 20220722165500, 20220722165841, 3.31000000, iwb100067S2, 20220722165500, 20220722165841, 2.07000000, iwb100064S2, 20220722165500, 20220722165841, 2.56000000, iwb100082S1, 20220722165500, 20220722165841, 4.75000000, iwb100085S1, 20220722165500, 20220722165841, 5.53000000, iwb100019S2, 20220722165500, 20220722165841, 4.92000000, iwb100081S2, 20220722165500, 20220722165841, 2.98000000, iwb100088S1, 20220722165500, 20220722165841, 5.18000000, iwb100016S2, 20220722165500, 20220722165841, 3.85000000, iwb100084S2, 20220722165500, 20220722165841, 4.64000000, iwb100022S2, 20220722165500, 20220722165841, 2.83000000, iwb100025S2, 20220722165500, 20220722165841, 2.34000000, iwb100061S2, 20220722165500, 20220722165841, 4.49000000, iwb100076S2, 20220722165500, 20220722165841, 4.32000000, iwb100070S2, 20220722165500, 20220722165841, 3.73000000, iwb100073S2, 20220722165500, 20220722165841, 3.73000000, iwb100079S2, 20220722165500, 20220722165841, 3.47000000, iwb100052S2, 20220722165500, 20220722165841, 4.65000000, iwb100028S1, 20220722165500, 20220722165841, 5.33000000, iwb100001S1, 20220722165500, 20220722165841, 3.69000000, iwb100004S1, 20220722165500, 20220722165841, 3.11000000, iwb100055S2, 20220722165500, 20220722165841, 2.24000000, iwb100091S1, 20220722165500, 20220722165841, 2.74000000, iwb100058S2, 20220722165500, 20220722165841, 3.32000000, iwb100097S1, 20220722165500, 20220722165841, 5.74000000, iwb100094S1, 20220722165500, 20220722165841, 4.61000000, iwb100031S2, 20220722165500, 20220722165841, 3.74000000, iwb100049S1, 20220722165500, 20220722165841, 2.67000000, iwb100004S2, 20220722165500, 20220722165841, 2.83000000, iwb100076S1, 20220722165500, 20220722165841, 5.09000000, iwb100007S2, 20220722165500, 20220722165841, 4.17000000, iwb100034S2, 20220722165500, 20220722165841, 3.25000000, iwb100070S1, 20220722165500, 20220722165841, 4.31000000, iwb100079S1, 20220722165500, 20220722165841, 3.96000000, iwb100073S1, 20220722165500, 20220722165841, 4.31000000, iwb100028S2, 20220722165500, 20220722165841, 4.5000000, iwb100040S1, 20220722165500, 20220722165841, 5.11000000, iwb100055S1, 20220722165500, 20220722165841, 2.32000000, iwb100013S2, 20220722165500, 20220722165841, 3.26000000, iwb100052S1, 20220722165500, 20220722165841, 5.54000000, iwb100010S2, 20220722165500, 20220722165841, 3.26000000, iwb100058S1, 20220722165500, 20220722165841, 3.76000000, iwb100001S2, 20220722165500, 20220722165841, 3.26000000, iwb100043S1, 20220722165500, 20220722165841, 5.89000000, iwb100046S1, 20220722165500, 20220722165841, 3.32000000, iwb100034S1, 20220722165500, 20220722165841, 3.67000000, iwb100037S1, 20220722165500, 20220722165841, 5.11000000, iwb100007S1, 20220722165500, 20220722165841, 4.9000000, iwb100031S1, 20220722165500, 20220722165841, 4.33000000, iwb100019S1, 20220722165500, 20220722165841, 5.9000000, iwb100025S1, 20220722165500, 20220722165841, 2.46000000, iwb100010S1, 20220722165500, 20220722165841, 3.69000000, iwb100016S1, 20220722165500, 20220722165841, 4.47000000, iwb100022S1, 20220722165500, 20220722165841, 3.11000000]]
- 2022-07-22 17:00:00.253 [Thread-10] INFO Sharding-Sphere-SQL - Logic SQL: insert ignore into online_data_lampblack (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ),( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? )
- 2022-07-22 17:00:00.253 [Thread-10] INFO Sharding-Sphere-SQL - SQLStatement: InsertStatement(super=DMLStatement(super=AbstractSQLStatement(type=DML, tables=Tables(tables=[Table(name=online_data_lampblack, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=14})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=27})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=40})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=53})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=66})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=79})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=92})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=105})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=118})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=131})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=144})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=157})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=170})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=183})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=196})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=209})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=222})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=235})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=248})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=261})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=274})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=287})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=300})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=313})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=326})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=339})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=352})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=365})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=378})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=391})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=404})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=417})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=430})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=443})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=456})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=469})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=482})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=495})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=508})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=521})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=534})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=547})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=560})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=573})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=586})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=599})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=612})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=625})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=638})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=651})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=664})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=677})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=690})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=703})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=716})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=729})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=742})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=755})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=768})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=781})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=794})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=807})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=820})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=833})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=846})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=859})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=872})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=885})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=898})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=911})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=924})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=937})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=950})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=963})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=976})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=989})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1002})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1015})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1028})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1041})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1054})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1067})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1080})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1093})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1106})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1119})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1132})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1145})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1158})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1171})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1184})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1197})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1210})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1223})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1236})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1249})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1262})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1275})]), AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=online_data_lampblack), operator=EQUAL, positionValueMap={}, positionIndexMap={0=1288})])])), sqlTokens=[TableToken(beginPosition=19, skippedSchemaNameLength=0, originalLiterals=online_data_lampblack), io.shardingsphere.core.parsing.parser.token.InsertValuesToken@53ae85d7], parametersIndex=1300)), columns=[Column(name=terminal_id, tableName=online_data_lampblack), Column(name=upload_date, tableName=online_data_lampblack), Column(name=insert_time, tableName=online_data_lampblack), Column(name=flue_temp, tableName=online_data_lampblack), Column(name=flue_humidity, tableName=online_data_lampblack), Column(name=smoke_density, tableName=online_data_lampblack), Column(name=voc_density, tableName=online_data_lampblack), Column(name=pm25, tableName=online_data_lampblack), Column(name=longitude, tableName=online_data_lampblack), Column(name=latitude, tableName=online_data_lampblack), Column(name=smoke_total, tableName=online_data_lampblack), Column(name=voc_total, tableName=online_data_lampblack), Column(name=pm25_total, tableName=online_data_lampblack)], generatedKeyConditions=[], insertValues=InsertValues(insertValues=[InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13), InsertValue(expression=( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), parametersCount=13)]), columnsListLastPosition=206, generateKeyColumnIndex=-1, insertValuesListLastPosition=5416)
- 2022-07-22 17:00:00.254 [Thread-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: insert ignore into online_data_lampblack_07 (terminal_id,upload_date,insert_time, flue_temp , flue_humidity , smoke_density , voc_density , pm25 , longitude , latitude , smoke_total , voc_total , pm25_total ) VALUES ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ), ( ?,?,?, ? , ? , ? , ? , ? , ? , ? , ? , ? , ? ) ::: [[iwb100022S3, 20220722165500, 20220722165841, null, null, 2.11000000, 0.04000000, 1.55000000, null, null, null, null, null, iwb100084S3, 20220722165500, 20220722165841, null, null, 4.53000000, 0.08000000, 2.76000000, null, null, null, null, null, iwb100056S3, 20220722165500, 20220722165841, null, null, 1.32000000, 0.03000000, 1.16000000, null, null, null, null, null, iwb100053S3, 20220722165500, 20220722165841, null, null, 3.88000000, 0.07000000, 2.44000000, null, null, null, null, null, iwb100087S3, 20220722165500, 20220722165841, null, null, 2.74000000, 0.05000000, 1.87000000, null, null, null, null, null, iwb100081S3, 20220722165500, 20220722165841, null, null, 2.31000000, 0.04000000, 1.65000000, null, null, null, null, null, iwb100008S3, 20220722165500, 20220722165841, null, null, 3.12000000, 0.06000000, 2.06000000, null, null, null, null, null, iwb100005S3, 20220722165500, 20220722165841, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100070S3, 20220722165500, 20220722165841, null, null, 3.31000000, 0.06000000, 2.15000000, null, null, null, null, null, iwb100039S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100036S3, 20220722165500, 20220722165841, null, null, 2.67000000, 0.05000000, 1.83000000, null, null, null, null, null, iwb100073S3, 20220722165500, 20220722165841, null, null, 3.31000000, 0.06000000, 2.15000000, null, null, null, null, null, iwb100042S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100011S3, 20220722165500, 20220722165841, null, null, 1.25000000, 0.03000000, 1.12000000, null, null, null, null, null, iwb100064S3, 20220722165500, 20220722165841, null, null, 1.75000000, 0.04000000, 1.37000000, null, null, null, null, null, iwb100076S3, 20220722165500, 20220722165841, null, null, 4.09000000, 0.07000000, 2.54000000, null, null, null, null, null, iwb100061S3, 20220722165500, 20220722165841, null, null, 4.32000000, 0.07000000, 2.66000000, null, null, null, null, null, iwb100079S3, 20220722165500, 20220722165841, null, null, 2.96000000, 0.05000000, 1.98000000, null, null, null, null, null, iwb100002S3, 20220722165500, 20220722165841, null, null, 3.47000000, 0.06000000, 2.23000000, null, null, null, null, null, iwb100067S3, 20220722165500, 20220722165841, null, null, 1.1000000, 0.03000000, 1.05000000, null, null, null, null, null, iwb100016S3, 20220722165500, 20220722165841, null, null, 3.47000000, 0.06000000, 2.23000000, null, null, null, null, null, iwb100093S3, 20220722165500, 20220722165841, null, null, 2.52000000, 0.05000000, 1.76000000, null, null, null, null, null, iwb100090S3, 20220722165500, 20220722165841, null, null, 4.96000000, 0.08000000, 2.98000000, null, null, null, null, null, iwb100019S3, 20220722165500, 20220722165841, null, null, 4.9000000, 0.08000000, 2.95000000, null, null, null, null, null, iwb100096S3, 20220722165500, 20220722165841, null, null, 2.17000000, 0.04000000, 1.58000000, null, null, null, null, null, iwb100028S3, 20220722165500, 20220722165841, null, null, 4.33000000, 0.08000000, 2.66000000, null, null, null, null, null, iwb100025S3, 20220722165500, 20220722165841, null, null, 1.46000000, 0.03000000, 1.23000000, null, null, null, null, null, iwb100031S3, 20220722165500, 20220722165841, null, null, 3.33000000, 0.06000000, 2.16000000, null, null, null, null, null, iwb100034S3, 20220722165500, 20220722165841, null, null, 2.67000000, 0.05000000, 1.83000000, null, null, null, null, null, iwb100099S3, 20220722165500, 20220722165841, null, null, 2.17000000, 0.04000000, 1.58000000, null, null, null, null, null, iwb100037S3, 20220722165500, 20220722165841, null, null, 4.11000000, 0.07000000, 2.55000000, null, null, null, null, null, iwb100006S3, 20220722165500, 20220722165841, null, null, 1.25000000, 0.03000000, 1.12000000, null, null, null, null, null, iwb100003S3, 20220722165500, 20220722165841, null, null, 2.11000000, 0.04000000, 1.55000000, null, null, null, null, null, iwb100078S3, 20220722165500, 20220722165841, null, null, 1.53000000, 0.03000000, 1.26000000, null, null, null, null, null, iwb100027S3, 20220722165500, 20220722165841, null, null, 4.33000000, 0.08000000, 2.66000000, null, null, null, null, null, iwb100058S3, 20220722165500, 20220722165841, null, null, 2.76000000, 0.05000000, 1.88000000, null, null, null, null, null, iwb100075S3, 20220722165500, 20220722165841, null, null, 4.75000000, 0.08000000, 2.87000000, null, null, null, null, null, iwb100072S3, 20220722165500, 20220722165841, null, null, 4.75000000, 0.08000000, 2.87000000, null, null, null, null, null, iwb100051S3, 20220722165500, 20220722165841, null, null, 3.1000000, 0.06000000, 2.05000000, null, null, null, null, null, iwb100088S3, 20220722165500, 20220722165841, null, null, 4.18000000, 0.07000000, 2.59000000, null, null, null, null, null, iwb100057S3, 20220722165500, 20220722165841, null, null, 2.76000000, 0.05000000, 1.88000000, null, null, null, null, null, iwb100054S3, 20220722165500, 20220722165841, null, null, 3.88000000, 0.07000000, 2.44000000, null, null, null, null, null, iwb100048S3, 20220722165500, 20220722165841, null, null, 3.1000000, 0.06000000, 2.05000000, null, null, null, null, null, iwb100085S3, 20220722165500, 20220722165841, null, null, 4.53000000, 0.08000000, 2.76000000, null, null, null, null, null, iwb100082S3, 20220722165500, 20220722165841, null, null, 3.75000000, 0.07000000, 2.37000000, null, null, null, null, null, iwb100045S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100033S3, 20220722165500, 20220722165841, null, null, 3.33000000, 0.06000000, 2.16000000, null, null, null, null, null, iwb100030S3, 20220722165500, 20220722165841, null, null, 3.68000000, 0.07000000, 2.34000000, null, null, null, null, null, iwb100021S3, 20220722165500, 20220722165841, null, null, 4.9000000, 0.08000000, 2.95000000, null, null, null, null, null, iwb100024S3, 20220722165500, 20220722165841, null, null, 2.11000000, 0.04000000, 1.55000000, null, null, null, null, null, iwb100012S3, 20220722165500, 20220722165841, null, null, 1.68000000, 0.04000000, 1.34000000, null, null, null, null, null, iwb100009S3, 20220722165500, 20220722165840, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100000S3, 20220722165500, 20220722165841, null, null, 4.9000000, 0.08000000, 2.95000000, null, null, null, null, null, iwb100018S3, 20220722165500, 20220722165841, null, null, 3.47000000, 0.06000000, 2.23000000, null, null, null, null, null, iwb100049S3, 20220722165500, 20220722165841, null, null, 1.67000000, 0.04000000, 1.33000000, null, null, null, null, null, iwb100091S3, 20220722165500, 20220722165841, null, null, 1.74000000, 0.04000000, 1.37000000, null, null, null, null, null, iwb100060S3, 20220722165500, 20220722165841, null, null, 3.54000000, 0.06000000, 2.27000000, null, null, null, null, null, iwb100015S3, 20220722165500, 20220722165841, null, null, 4.9000000, 0.08000000, 2.95000000, null, null, null, null, null, iwb100001S3, 20220722165500, 20220722165841, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100066S3, 20220722165500, 20220722165841, null, null, 1.1000000, 0.03000000, 1.05000000, null, null, null, null, null, iwb100035S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100032S3, 20220722165500, 20220722165841, null, null, 3.33000000, 0.06000000, 2.16000000, null, null, null, null, null, iwb100063S3, 20220722165500, 20220722165841, null, null, 2.88000000, 0.05000000, 1.94000000, null, null, null, null, null, iwb100097S3, 20220722165500, 20220722165841, null, null, 4.74000000, 0.08000000, 2.87000000, null, null, null, null, null, iwb100094S3, 20220722165500, 20220722165841, null, null, 3.61000000, 0.06000000, 2.3000000, null, null, null, null, null, iwb100052S3, 20220722165500, 20220722165841, null, null, 4.54000000, 0.08000000, 2.77000000, null, null, null, null, null, iwb100069S3, 20220722165500, 20220722165841, null, null, 3.97000000, 0.07000000, 2.48000000, null, null, null, null, null, iwb100055S3, 20220722165500, 20220722165841, null, null, 1.32000000, 0.03000000, 1.16000000, null, null, null, null, null, iwb100007S3, 20220722165500, 20220722165841, null, null, 3.9000000, 0.07000000, 2.45000000, null, null, null, null, null, iwb100004S3, 20220722165500, 20220722165841, null, null, 2.11000000, 0.04000000, 1.55000000, null, null, null, null, null, iwb100046S3, 20220722165500, 20220722165841, null, null, 2.32000000, 0.04000000, 1.66000000, null, null, null, null, null, iwb100040S3, 20220722165500, 20220722165841, null, null, 4.11000000, 0.07000000, 2.55000000, null, null, null, null, null, iwb100043S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100010S3, 20220722165500, 20220722165841, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100044S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100013S3, 20220722165500, 20220722165841, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100041S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100020S3, 20220722165500, 20220722165841, null, null, 3.9000000, 0.07000000, 2.45000000, null, null, null, null, null, iwb100023S3, 20220722165500, 20220722165841, null, null, 3.24000000, 0.06000000, 2.12000000, null, null, null, null, null, iwb100017S3, 20220722165500, 20220722165841, null, null, 4.9000000, 0.08000000, 2.95000000, null, null, null, null, null, iwb100014S3, 20220722165500, 20220722165841, null, null, 2.69000000, 0.05000000, 1.84000000, null, null, null, null, null, iwb100080S3, 20220722165500, 20220722165841, null, null, 2.31000000, 0.04000000, 1.65000000, null, null, null, null, null, iwb100095S3, 20220722165500, 20220722165841, null, null, 3.61000000, 0.06000000, 2.3000000, null, null, null, null, null, iwb100026S3, 20220722165500, 20220722165841, null, null, 4.33000000, 0.08000000, 2.66000000, null, null, null, null, null, iwb100029S3, 20220722165500, 20220722165841, null, null, 3.68000000, 0.07000000, 2.34000000, null, null, null, null, null, iwb100038S3, 20220722165500, 20220722165841, null, null, 4.89000000, 0.08000000, 2.94000000, null, null, null, null, null, iwb100098S3, 20220722165500, 20220722165841, null, null, 2.95000000, 0.05000000, 1.97000000, null, null, null, null, null, iwb100083S3, 20220722165500, 20220722165841, null, null, 1.18000000, 0.03000000, 1.09000000, null, null, null, null, null, iwb100086S3, 20220722165500, 20220722165841, null, null, 1.31000000, 0.03000000, 1.15000000, null, null, null, null, null, iwb100092S3, 20220722165500, 20220722165841, null, null, 3.95000000, 0.07000000, 2.47000000, null, null, null, null, null, iwb100089S3, 20220722165500, 20220722165841, null, null, 3.52000000, 0.06000000, 2.26000000, null, null, null, null, null, iwb100074S3, 20220722165500, 20220722165841, null, null, 3.31000000, 0.06000000, 2.15000000, null, null, null, null, null, iwb100047S3, 20220722165500, 20220722165841, null, null, 2.32000000, 0.04000000, 1.66000000, null, null, null, null, null, iwb100077S3, 20220722165500, 20220722165841, null, null, 4.09000000, 0.07000000, 2.54000000, null, null, null, null, null, iwb100050S3, 20220722165500, 20220722165841, null, null, 1.67000000, 0.04000000, 1.33000000, null, null, null, null, null, iwb100059S3, 20220722165500, 20220722165841, null, null, 2.88000000, 0.05000000, 1.94000000, null, null, null, null, null, iwb100071S3, 20220722165500, 20220722165841, null, null, 3.97000000, 0.07000000, 2.48000000, null, null, null, null, null, iwb100062S3, 20220722165500, 20220722165841, null, null, 3.54000000, 0.06000000, 2.27000000, null, null, null, null, null, iwb100065S3, 20220722165500, 20220722165841, null, null, 1.75000000, 0.04000000, 1.37000000, null, null, null, null, null, iwb100068S3, 20220722165500, 20220722165841, null, null, 2.53000000, 0.05000000, 1.76000000, null, null, null, null, null]]
- 2022-07-22 17:01:33.507 [Thread-9] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-9,10,main]
- 2022-07-22 17:02:00.046 [xxl-rpc, EmbedServer bizThreadPool-1742015586] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:03:33.335 [Thread-11] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-11,10,main]
- 2022-07-22 17:04:00.046 [xxl-rpc, EmbedServer bizThreadPool-1472269232] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:05:00.049 [xxl-rpc, EmbedServer bizThreadPool-1472269232] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:3, handler:com.xxl.job.core.handler.impl.MethodJobHandler@e3275d3[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#monitor]
- 2022-07-22 17:05:00.053 [Thread-16] INFO Sharding-Sphere-SQL - Logic SQL: select * from monitor where type=0
- 2022-07-22 17:05:00.054 [Thread-16] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=monitor, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=monitor)], parametersIndex=0)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 17:05:00.054 [Thread-16] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: select * from monitor where type=0
- 2022-07-22 17:05:33.290 [Thread-13] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-13,10,main]
- 2022-07-22 17:06:00.046 [xxl-rpc, EmbedServer bizThreadPool-1472269232] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:06:33.382 [Thread-15] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-15,10,main]
- 2022-07-22 17:07:33.278 [Thread-17] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-17,10,main]
- 2022-07-22 17:08:00.017 [xxl-rpc, EmbedServer bizThreadPool-332165945] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:09:33.262 [Thread-19] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-19,10,main]
- 2022-07-22 17:10:00.043 [xxl-rpc, EmbedServer bizThreadPool-927254523] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:11:33.317 [Thread-21] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-21,10,main]
- 2022-07-22 17:12:00.047 [xxl-rpc, EmbedServer bizThreadPool-1997349360] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 17:13:33.305 [Thread-23] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-23,10,main]
- 2022-07-22 17:14:00.049 [xxl-rpc, EmbedServer bizThreadPool-1816607721] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 22:25:33.128 [Thread-25] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-25,10,main]
- 2022-07-22 22:26:00.020 [xxl-rpc, EmbedServer bizThreadPool-1053177591] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 22:27:33.298 [Thread-27] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-27,10,main]
- 2022-07-22 22:28:00.025 [xxl-rpc, EmbedServer bizThreadPool-1326799952] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
- 2022-07-22 22:29:33.291 [Thread-29] INFO com.xxl.job.core.thread.JobThread - >>>>>>>>>>> xxl-job JobThread stoped, hashCode:Thread[Thread-29,10,main]
- 2022-07-22 22:30:00.056 [xxl-rpc, EmbedServer bizThreadPool-2016662448] INFO com.xxl.job.core.executor.XxlJobExecutor - >>>>>>>>>>> xxl-job regist JobThread success, jobId:2, handler:com.xxl.job.core.handler.impl.MethodJobHandler@642614b7[class com.yyjc.fbs.server.dbserveice.jobhandler.SysOnlineDataJobHandler#execute]
|