iotplatform/xps-server-3/logs/info/info.2023-12-04.log

14:40:12.173 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
14:40:12.240 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 4020 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
14:40:12.240 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
14:40:12.303 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
14:40:12.303 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
14:40:14.159 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
14:40:14.163 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
14:40:14.243 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 60 ms. Found 0 Redis repository interfaces.
14:40:14.405 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
14:40:14.427 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
14:40:15.261 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
14:40:15.261 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2957 ms
14:40:17.660 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
14:40:17.670 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
14:40:17.670 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
14:40:17.671 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
14:40:17.672 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

14:40:17.672 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
14:40:17.672 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
14:40:17.672 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@3242e6f8
14:40:19.391 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
14:40:19.397 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
14:40:19.544 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
14:40:19.576 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
14:40:19.576 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
14:40:19.577 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
14:40:19.598 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
14:40:19.608 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
14:40:19.619 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
14:40:19.652 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
14:40:19.709 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
14:40:19.711 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
14:40:19.711 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
14:40:19.736 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.094 seconds (process running for 9.315)
14:40:19.738 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
14:40:19.745 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
14:40:20.115 [restartedMain] INFO  p6spy - 2023-12-04 14:40:20 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1
14:40:20.119 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@328b547d
14:40:20.122 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
14:40:20.200 [restartedMain] INFO  p6spy - 2023-12-04 14:40:20 | Time Consuming: 14 ms | Connection: statement-0 | SQL: SELECT
             
        A.job_id,
        A.job_title,
        A.job_desc,
        A.status,
        A.job_type,
        A.job_code,
        A.job_cron,
        A.job_class_id,
        B.job_class,
        A.cycle_title,
        A.cycle_period,
        A.cycle_unit
     
        FROM      job       AS A
        LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
        WHERE A.deleted_flag = 0
         
         
           AND A.status = 1
         
         
        ORDER BY A.job_id ASC
14:40:20.221 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
14:40:20.223 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
14:40:20.791 [RMI TCP Connection(3)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
14:40:20.791 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
14:40:20.792 [RMI TCP Connection(1)-192.168.3.5] INFO  p6spy - 2023-12-04 14:40:20 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
14:40:20.794 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms
14:40:20.801 [RMI TCP Connection(1)-192.168.3.5] INFO  p6spy - 2023-12-04 14:40:20 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
14:50:00.016 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start
14:50:00.022 [quartzScheduler_Worker-1] INFO  p6spy - 2023-12-04 14:50:00 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1
14:50:00.035 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End
14:53:18.305 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:18 | Time Consuming: 7 ms | Connection: statement-5 | SQL: SELECT 1
14:53:18.346 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:18 | Time Consuming: 31 ms | Connection: statement-5 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
14:53:18.403 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:18 | Time Consuming: 30 ms | Connection: statement-5 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
14:53:18.970 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:18 | Time Consuming: 173 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
14:53:19.543 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:19 | Time Consuming: 570 ms | Connection: statement-5 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
14:53:23.744 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:23 | Time Consuming: 5022 ms | Connection: statement-6 | SQL: SELECT 1
14:53:23.749 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:23 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
14:53:23.808 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:23 | Time Consuming: 54 ms | Connection: statement-5 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
14:53:29.495 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:29 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
14:53:29.502 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:29 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
14:53:29.520 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:29 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
14:53:29.850 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:29 | Time Consuming: 59 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
14:53:30.402 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:53:30 | Time Consuming: 550 ms | Connection: statement-5 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
14:53:34.788 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:34 | Time Consuming: 5002 ms | Connection: statement-7 | SQL: SELECT 1
14:53:34.795 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:34 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1
14:53:34.838 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:53:34 | Time Consuming: 38 ms | Connection: statement-5 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
14:57:40.938 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 5002 ms | Connection: statement-10 | SQL: SELECT 1
14:57:40.938 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 5002 ms | Connection: statement-11 | SQL: SELECT 1
14:57:40.939 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 5003 ms | Connection: statement-12 | SQL: SELECT 1
14:57:40.944 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 4 ms | Connection: statement-14 | SQL: SELECT 1
14:57:40.946 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT 1
14:57:40.990 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 39 ms | Connection: statement-13 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
14:57:40.993 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 14:57:40 | Time Consuming: 41 ms | Connection: statement-14 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
14:57:41.007 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:41 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283
14:57:41.011 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:41 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
 LIMIT 10 
14:57:49.349 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:49 | Time Consuming: 5 ms | Connection: statement-15 | SQL: SELECT 1
14:57:51.010 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:51 | Time Consuming: 1654 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
14:57:51.650 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:57:51 | Time Consuming: 638 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
14:58:16.353 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 5 ms | Connection: statement-15 | SQL: SELECT 1
14:58:16.362 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
14:58:16.380 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
14:58:16.655 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 4 ms | Connection: statement-14 | SQL: SELECT 1
14:58:16.684 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 26 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
14:58:16.711 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 14:58:16 | Time Consuming: 50 ms | Connection: statement-14 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
14:58:17.217 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 14:58:17 | Time Consuming: 531 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:00:00.002 [quartzScheduler_Worker-2] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start
15:00:00.008 [quartzScheduler_Worker-2] INFO  p6spy - 2023-12-04 15:00:00 | Time Consuming: 4 ms | Connection: statement-13 | SQL: SELECT 1
15:00:00.019 [quartzScheduler_Worker-2] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End
15:01:23.574 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:23 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1
15:01:23.851 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:23 | Time Consuming: 262 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:01:24.527 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:24 | Time Consuming: 674 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:01:45.308 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:45 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1
15:01:45.345 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:45 | Time Consuming: 31 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-12-01 04:00:00'
15:01:45.890 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:01:45 | Time Consuming: 544 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-12-01 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:02:29.995 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:29 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1
15:02:30.193 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:30 | Time Consuming: 187 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:02:30.946 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:30 | Time Consuming: 751 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:02:45.598 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:45 | Time Consuming: 8 ms | Connection: statement-15 | SQL: SELECT 1
15:02:45.635 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:45 | Time Consuming: 24 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:02:46.434 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:02:46 | Time Consuming: 797 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 30, 10 
15:03:23.524 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:23 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:23.561 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:23 | Time Consuming: 26 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:30.148 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:30 | Time Consuming: 22 ms | Connection: statement-15 | SQL: SELECT 1
15:03:30.208 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:30 | Time Consuming: 51 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = ' 新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:35.028 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:35 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:35.064 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:35 | Time Consuming: 26 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:36.211 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:36 | Time Consuming: 1146 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:03:43.196 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:43 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:43.231 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:43 | Time Consuming: 29 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:44.321 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:44 | Time Consuming: 1088 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:03:46.679 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:46 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:46.711 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:46 | Time Consuming: 21 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = ' 新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:53.463 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:53 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:53.497 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:53 | Time Consuming: 23 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = ' 新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:54.202 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:54 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:03:54.253 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:54 | Time Consuming: 40 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = ' 新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:58.421 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:58 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1
15:03:58.454 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:58 | Time Consuming: 24 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:03:59.531 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:03:59 | Time Consuming: 1075 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:04:47.197 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:47 | Time Consuming: 5 ms | Connection: statement-15 | SQL: SELECT 1
15:04:47.234 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:47 | Time Consuming: 26 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:04:48.055 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:48 | Time Consuming: 820 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10, 10 
15:04:55.483 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:55 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:04:55.512 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:55 | Time Consuming: 23 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:04:56.748 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:04:56 | Time Consuming: 1235 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:05:04.769 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:04 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:05:04.802 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:04 | Time Consuming: 23 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:05:05.449 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:05 | Time Consuming: 646 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10, 10 
15:05:09.050 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:09 | Time Consuming: 3 ms | Connection: statement-15 | SQL: SELECT 1
15:05:09.080 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:09 | Time Consuming: 24 ms | Connection: statement-15 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
15:05:10.348 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:05:10 | Time Consuming: 1266 ms | Connection: statement-15 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 01:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:05:37.808 [File Watcher] INFO  o.s.b.d.a.LocalDevToolsAutoConfiguration$RestartingClassPathChangeChangedEventListener - Restarting due to 1225 class path changes (0 additions, 1225 deletions, 0 modifications)
15:05:37.815 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:05:37.817 [Thread-11] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
15:05:37.821 [Thread-11] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
15:05:37.827 [Thread-11] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:05:37.827 [Thread-11] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
15:05:37.827 [Thread-11] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
15:05:37.834 [Thread-11] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
15:05:37.836 [Thread-11] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
15:05:37.836 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
15:05:37.836 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:05:37.836 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
15:05:37.851 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
15:05:37.854 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
15:06:46.565 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 4020 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
15:06:46.565 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
15:06:47.538 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
15:06:47.538 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
15:06:47.601 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 62 ms. Found 0 Redis repository interfaces.
15:06:47.693 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
15:06:47.693 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
15:06:47.883 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
15:06:47.883 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 1313 ms
15:06:49.412 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
15:06:49.413 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
15:06:49.413 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
15:06:49.413 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
15:06:49.413 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

15:06:49.413 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
15:06:49.413 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
15:06:49.413 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@4cc0f405
15:06:50.614 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
15:06:50.617 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
15:06:50.680 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
15:06:50.685 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:06:50.685 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
15:06:50.685 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
15:06:50.689 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
15:06:50.707 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
15:06:50.707 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
15:06:50.707 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:06:50.718 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 4.195 seconds (process running for 1600.297)
15:06:50.719 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
15:06:50.720 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
15:06:51.758 [restartedMain] INFO  o.s.b.a.l.ConditionEvaluationReportLogger - 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
15:06:51.768 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:06:51.768 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
15:06:51.770 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:06:51.770 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
15:06:51.770 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
15:06:51.772 [restartedMain] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
15:06:51.772 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
15:06:51.772 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
15:06:51.772 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:06:51.772 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
15:38:35.960 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
15:38:36.009 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 9888 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
15:38:36.010 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
15:38:36.063 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
15:38:36.063 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
15:38:37.669 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
15:38:37.672 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
15:38:37.743 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 57 ms. Found 0 Redis repository interfaces.
15:38:37.895 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
15:38:37.911 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
15:38:38.711 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
15:38:38.711 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2647 ms
15:38:41.031 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
15:38:41.041 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
15:38:41.041 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
15:38:41.041 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
15:38:41.042 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

15:38:41.042 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
15:38:41.042 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
15:38:41.042 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@7934fa3d
15:38:42.755 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
15:38:42.761 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
15:38:42.909 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
15:38:42.943 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:38:42.944 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
15:38:42.944 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
15:38:42.967 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
15:38:42.976 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
15:38:42.986 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
15:38:43.015 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
15:38:43.064 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
15:38:43.065 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
15:38:43.065 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:38:43.089 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 7.575 seconds (process running for 8.488)
15:38:43.092 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
15:38:43.100 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
15:38:43.430 [restartedMain] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1
15:38:43.435 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@7a40b316
15:38:43.445 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
15:38:43.502 [XNIO-1 task-2] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
15:38:43.502 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
15:38:43.505 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms
15:38:43.584 [restartedMain] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 63 ms | Connection: statement-0 | SQL: SELECT
             
        A.job_id,
        A.job_title,
        A.job_desc,
        A.status,
        A.job_type,
        A.job_code,
        A.job_cron,
        A.job_class_id,
        B.job_class,
        A.cycle_title,
        A.cycle_period,
        A.cycle_unit
     
        FROM      job       AS A
        LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
        WHERE A.deleted_flag = 0
         
         
           AND A.status = 1
         
         
        ORDER BY A.job_id ASC
15:38:43.605 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:38:43.607 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:38:43.612 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:38:43.633 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT
             
        A.oc_id,
        B.oc_type_id,
        B.oc_name,
        A.account_id,
        A.account_name,
        A.account_real_name,
        A.password,
        A.account_type,
        A.account_staff_no,
        A.account_phone,
        A.account_last_ip,
        A.account_loc,
        A.status,
        A.account_avatar,
        A.account_photo,
        A.account_real_name,
        A.account_intro,
        A.wx_id,
        A.is_fixed
     
        FROM        account AS A
        LEFT JOIN   oc      AS B ON (A.oc_id = B.oc_id )
        WHERE A.deleted_flag = 0
        AND (A.account_name = 'sxky'
        OR   A.account_phone = 'sxky'
        OR   A.account_mail  = 'sxky'
        OR   A.account_staff_no = 'sxky')
15:38:43.643 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        A.oc_id,
        A.oc_name,
        A.oc_type_id,
        A.root_id,
        A.parent_id,
        A.admin_id,
        B.account_name AS admin_name,
        A.group_id,
        A.node_left,
        A.node_right,
        A.node_level,
        A.is_leaf,
        A.status,
        A.if_lic
     
        FROM oc           AS A
        LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id)
        WHERE A.oc_id = 406283
15:38:43.651 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT
             
        A.rm_id,
        A.role_id,
        B.role_type_id,
        B.role_code,
        B.role_name,
        A.account_id
     
        FROM      s_role_member AS A
        LEFT JOIN s_role        AS B ON (A.role_id = B.role_id)
        WHERE account_id = 406283
        LIMIT 1
15:38:43.663 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 10 ms | Connection: statement-1 | SQL: SELECT
             
        A.gm_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        B.node_left ,
        B.node_right,
        A.account_id
     
        FROM      s_group_member    AS A
        LEFT JOIN s_group           AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:38:43.674 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT
             
        A.gmp_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        A.account_id,
        D.account_name,
        D.account_real_name,
        A.position_id,
        C.position_name
     
        FROM      s_group_member_position A
        LEFT JOIN s_group                 B ON (A.oc_id = B.oc_id AND A.group_id     = B.group_id)
        LEFT JOIN s_position              C ON (A.oc_id = C.oc_id AND A.position_id  = C.position_id)
        LEFT JOIN   account               D ON (A.oc_id = D.oc_id AND A.account_id   = D.account_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:38:43.682 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT
             
        A.gmpg_id,
        A.oc_id,
        A.group_id,
        A.account_id,
        A.position_id,
        A.grant_group_id,
        B.group_name AS grant_group_name
     
        FROM      s_group_member_position_grant A
        LEFT JOIN s_group                       B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
         
            AND A.position_id = 406283
         
        LIMIT 1
15:38:43.917 [RMI TCP Connection(2)-192.168.3.5] INFO  p6spy - 2023-12-04 15:38:43 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:38:44.372 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:44 | Time Consuming: 8 ms | Connection: statement-0 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:38:44.393 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:44 | Time Consuming: 8 ms | Connection: statement-0 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
15:38:44.884 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:44 | Time Consuming: 55 ms | Connection: statement-0 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
15:38:45.421 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:38:45.434 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
15:38:45.446 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 8 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎大破'
15:38:45.458 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442129
15:38:45.468 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎圆锥'
15:38:45.474 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442135
15:38:45.479 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = ' 旧系列球磨机'
15:38:45.484 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442136
15:38:45.490 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442137
15:38:45.494 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '新系列球磨'
15:38:45.499 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:45 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442139
15:38:52.817 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:52 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:38:54.605 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:54 | Time Consuming: 1701 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
15:38:55.235 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:55 | Time Consuming: 627 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:38:59.680 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:38:59.693 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 8 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
15:38:59.699 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎大破'
15:38:59.704 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442129
15:38:59.709 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎圆锥'
15:38:59.714 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442135
15:38:59.718 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = ' 旧系列球磨机'
15:38:59.723 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442136
15:38:59.728 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442137
15:38:59.734 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '新系列球磨'
15:38:59.740 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:38:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442139
15:39:01.001 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
15:39:01.004 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1
15:39:01.005 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT 1
15:39:01.012 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283
15:39:01.016 [XNIO-1 task-3] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
 LIMIT 10 
15:39:01.016 [XNIO-1 task-4] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
15:39:01.025 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:01 | Time Consuming: 16 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
15:39:06.436 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:06 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
15:39:06.474 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:06 | Time Consuming: 28 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
15:39:07.087 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:07 | Time Consuming: 611 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:39:08.429 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:08 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
15:39:08.462 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:08 | Time Consuming: 23 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '破碎大破'
15:39:09.024 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:09 | Time Consuming: 561 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '破碎大破'
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:39:50.207 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1
15:39:50.219 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:39:50.236 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT
             
        A.oc_id,
        B.oc_type_id,
        B.oc_name,
        A.account_id,
        A.account_name,
        A.account_real_name,
        A.password,
        A.account_type,
        A.account_staff_no,
        A.account_phone,
        A.account_last_ip,
        A.account_loc,
        A.status,
        A.account_avatar,
        A.account_photo,
        A.account_real_name,
        A.account_intro,
        A.wx_id,
        A.is_fixed
     
        FROM        account AS A
        LEFT JOIN   oc      AS B ON (A.oc_id = B.oc_id )
        WHERE A.deleted_flag = 0
        AND (A.account_name = 'sxky'
        OR   A.account_phone = 'sxky'
        OR   A.account_mail  = 'sxky'
        OR   A.account_staff_no = 'sxky')
15:39:50.242 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT
             
        A.oc_id,
        A.oc_name,
        A.oc_type_id,
        A.root_id,
        A.parent_id,
        A.admin_id,
        B.account_name AS admin_name,
        A.group_id,
        A.node_left,
        A.node_right,
        A.node_level,
        A.is_leaf,
        A.status,
        A.if_lic
     
        FROM oc           AS A
        LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id)
        WHERE A.oc_id = 406283
15:39:50.247 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT
             
        A.rm_id,
        A.role_id,
        B.role_type_id,
        B.role_code,
        B.role_name,
        A.account_id
     
        FROM      s_role_member AS A
        LEFT JOIN s_role        AS B ON (A.role_id = B.role_id)
        WHERE account_id = 406283
        LIMIT 1
15:39:50.254 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        A.gm_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        B.node_left ,
        B.node_right,
        A.account_id
     
        FROM      s_group_member    AS A
        LEFT JOIN s_group           AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:39:50.261 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        A.gmp_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        A.account_id,
        D.account_name,
        D.account_real_name,
        A.position_id,
        C.position_name
     
        FROM      s_group_member_position A
        LEFT JOIN s_group                 B ON (A.oc_id = B.oc_id AND A.group_id     = B.group_id)
        LEFT JOIN s_position              C ON (A.oc_id = C.oc_id AND A.position_id  = C.position_id)
        LEFT JOIN   account               D ON (A.oc_id = D.oc_id AND A.account_id   = D.account_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:39:50.268 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        A.gmpg_id,
        A.oc_id,
        A.group_id,
        A.account_id,
        A.position_id,
        A.grant_group_id,
        B.group_name AS grant_group_name
     
        FROM      s_group_member_position_grant A
        LEFT JOIN s_group                       B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
         
            AND A.position_id = 406283
         
        LIMIT 1
15:39:50.304 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:39:50.319 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
15:39:50.637 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:50 | Time Consuming: 33 ms | Connection: statement-1 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
15:39:51.214 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT 1
15:39:51.222 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
15:39:51.228 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎大破'
15:39:51.232 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442129
15:39:51.236 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '破碎圆锥'
15:39:51.240 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442135
15:39:51.245 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = ' 旧系列球磨机'
15:39:51.250 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442136
15:39:51.254 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442137
15:39:51.260 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = '新系列球磨'
15:39:51.266 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:51 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT C.goaf_sensor_name, C.goaf_sensor_location, C.goaf_sensor_status, C.goaf_install_time,
               B.goaf_sensor_alarm_id, B.goaf_sensor_alarm_level, B.goaf_sensor_alarm_type, A.goaf_datareport_time
        FROM goaf_sensor AS C
                 LEFT JOIN
             (SELECT goaf_sensor_id, goaf_data_id, goaf_datareport_time
              FROM goaf_sensordata_new
              ) AS A ON A.goaf_sensor_id = C.goaf_sensor_id
                 LEFT JOIN goaf_sensoralarm AS B ON A.goaf_data_id = B.goaf_data_id

        WHERE C.goaf_sensor_id = 442139
15:39:52.634 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:52 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1
15:39:52.686 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:52 | Time Consuming: 43 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '破碎大破' AND goaf_datareport_time BETWEEN '2023-11-29 00:00:00' AND '2023-12-31 00:00:00'
15:39:53.259 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:53 | Time Consuming: 572 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '破碎大破'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-29 00:00:00' AND '2023-12-31 00:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:39:55.505 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:55 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
15:39:55.538 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:55 | Time Consuming: 27 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
15:39:56.124 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:39:56 | Time Consuming: 583 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:40:00.006 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start
15:40:00.010 [quartzScheduler_Worker-1] INFO  p6spy - 2023-12-04 15:40:00 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:40:00.025 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End
15:40:02.130 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:02 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1
15:40:02.165 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:02 | Time Consuming: 27 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '破碎大破' AND goaf_datareport_time BETWEEN '2023-11-29 00:00:00' AND '2023-12-31 00:00:00'
15:40:02.923 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:02 | Time Consuming: 758 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '破碎大破'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-29 00:00:00' AND '2023-12-31 00:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:40:46.749 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:46 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
15:40:46.783 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:46 | Time Consuming: 27 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 AND goaf_dev_name = '新系列球磨' AND goaf_datareport_time BETWEEN '2023-11-30 00:00:00' AND '2023-11-30 04:00:00'
15:40:48.134 [XNIO-1 task-2] INFO  p6spy - 2023-12-04 15:40:48 | Time Consuming: 1350 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
            AND goaf_dev_name = '新系列球磨'
         
         
            AND goaf_datareport_time BETWEEN '2023-11-30 00:00:00' AND '2023-11-30 04:00:00'
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
15:41:17.025 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:41:17.026 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
15:41:17.029 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
15:41:17.031 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:41:17.031 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
15:41:17.031 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
15:41:17.038 [SpringApplicationShutdownHook] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
15:41:17.041 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
15:41:17.041 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
15:41:17.041 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
15:41:17.042 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
15:41:17.061 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
15:41:17.064 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.