iotplatform/xps-server-3/logs/info/info.2023-08-21.log

11:35:07.709 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
11:35:07.761 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 12372 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
11:35:07.762 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
11:35:07.817 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
11:35:07.818 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
11:35:09.558 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
11:35:09.561 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
11:35:09.649 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 72 ms. Found 0 Redis repository interfaces.
11:35:09.809 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
11:35:09.827 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
11:35:10.582 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
11:35:10.583 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2765 ms
11:35:12.923 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
11:35:12.935 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
11:35:12.935 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
11:35:12.935 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
11:35:12.936 [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.

11:35:12.936 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
11:35:12.936 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
11:35:12.936 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@149511a
11:35:14.510 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
11:35:14.515 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
11:35:14.654 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
11:35:14.685 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
11:35:14.685 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
11:35:14.686 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
11:35:14.709 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
11:35:14.719 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
11:35:14.729 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
11:35:14.759 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
11:35:14.811 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
11:35:14.813 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
11:35:14.813 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:35:14.837 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 7.592 seconds (process running for 9.481)
11:35:14.840 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
11:35:14.847 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
11:35:15.214 [restartedMain] INFO  p6spy - 2023-08-21 11:35:15 | Time Consuming: 12 ms | Connection: statement-0 | SQL: SELECT 1
11:35:15.218 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@396d4ebe
11:35:15.228 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
11:35:15.289 [restartedMain] INFO  p6spy - 2023-08-21 11:35:15 | Time Consuming: 4 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
11:35:15.311 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:35:15.313 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:35:15.836 [RMI TCP Connection(3)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
11:35:15.836 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
11:35:15.840 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms
11:35:15.841 [RMI TCP Connection(4)-192.168.3.5] INFO  p6spy - 2023-08-21 11:35:15 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
11:35:15.851 [RMI TCP Connection(4)-192.168.3.5] INFO  p6spy - 2023-08-21 11:35:15 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
11:36:59.695 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
11:36:59.696 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
11:36:59.703 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
11:36:59.706 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
11:36:59.707 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
11:36:59.707 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
11:36:59.713 [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)
11:36:59.714 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
11:36:59.714 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
11:36:59.714 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
11:36:59.714 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
11:36:59.727 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
11:36:59.731 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
11:52:26.598 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
11:52:26.664 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 17788 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
11:52:26.665 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
11:52:26.742 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
11:52:26.742 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
11:52:28.790 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
11:52:28.794 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
11:52:28.892 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 78 ms. Found 0 Redis repository interfaces.
11:52:29.075 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
11:52:29.094 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
11:52:29.929 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
11:52:29.929 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3186 ms
11:52:32.127 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
11:52:32.136 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
11:52:32.136 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
11:52:32.137 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
11:52:32.137 [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.

11:52:32.137 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
11:52:32.137 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
11:52:32.138 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@1afb9b1b
11:52:33.981 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
11:52:33.991 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
11:52:34.145 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
11:52:34.171 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
11:52:34.171 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
11:52:34.171 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
11:52:34.194 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
11:52:34.205 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
11:52:34.214 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
11:52:34.245 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
11:52:34.302 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
11:52:34.303 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
11:52:34.304 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:52:34.331 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.476 seconds (process running for 9.734)
11:52:34.333 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
11:52:34.341 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
11:52:34.721 [restartedMain] INFO  p6spy - 2023-08-21 11:52:34 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1
11:52:34.726 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@37e21c23
11:52:34.739 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
11:52:34.804 [restartedMain] INFO  p6spy - 2023-08-21 11:52:34 | Time Consuming: 7 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
11:52:34.823 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:52:34.826 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
11:52:35.190 [RMI TCP Connection(3)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
11:52:35.191 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
11:52:35.195 [RMI TCP Connection(3)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms
11:52:35.202 [RMI TCP Connection(2)-192.168.3.5] INFO  p6spy - 2023-08-21 11:52:35 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
16:23:43.912 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:23:43 | Time Consuming: 5006 ms | Connection: statement-35 | SQL: SELECT 1
16:23:48.913 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:23:48 | Time Consuming: 5000 ms | Connection: statement-36 | SQL: SELECT 1
16:23:53.915 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:23:53 | Time Consuming: 5000 ms | Connection: statement-37 | SQL: SELECT 1
16:23:58.917 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:23:58 | Time Consuming: 5000 ms | Connection: statement-38 | SQL: SELECT 1
16:24:03.918 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:03 | Time Consuming: 5000 ms | Connection: statement-39 | SQL: SELECT 1
16:24:03.923 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:03 | Time Consuming: 3 ms | Connection: statement-40 | SQL: SELECT 1
16:24:03.939 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:03 | Time Consuming: 9 ms | Connection: statement-40 | 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'
16:24:03.959 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:03 | Time Consuming: 5 ms | Connection: statement-40 | 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
16:24:04.427 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 3 ms | Connection: statement-41 | SQL: SELECT 1
16:24:04.428 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 4 ms | Connection: statement-42 | SQL: SELECT 1
16:24:04.440 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 3 ms | Connection: statement-42 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:24:04.440 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 9 ms | Connection: statement-41 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

                IFNULL(SUM( CASE WHEN goaf_sensor_status = 1  THEN 1 ELSE 0 END ), 0) AS 'sensorOnlineNum'

        FROM        goaf_sensor

        WHERE       A.oc_id = 406283
16:24:04.459 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 31 ms | Connection: statement-40 | 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
                )
            )
16:24:04.486 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 3 ms | Connection: rollback-41 | SQL: 
16:24:04.966 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:24:04 | Time Consuming: 3 ms | Connection: statement-41 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:25:50.370 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 4 ms | Connection: statement-41 | SQL: SELECT 1
16:25:50.379 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 3 ms | Connection: statement-41 | 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'
16:25:50.398 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 5 ms | Connection: statement-41 | 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
16:25:50.726 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 4 ms | Connection: statement-41 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:25:50.727 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 3 ms | Connection: statement-40 | SQL: SELECT 1
16:25:50.765 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:25:50 | Time Consuming: 33 ms | Connection: statement-40 | 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
                )
            )
16:25:58.961 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:25:58 | Time Consuming: 4 ms | Connection: statement-40 | SQL: SELECT 1
16:25:58.961 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:58 | Time Consuming: 4 ms | Connection: statement-41 | SQL: SELECT 1
16:25:58.968 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:25:58 | Time Consuming: 3 ms | Connection: statement-41 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:25:58.968 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:25:58 | Time Consuming: 3 ms | Connection: statement-40 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

                IFNULL(SUM( CASE WHEN goaf_sensor_status = 1  THEN 1 ELSE 0 END ), 0) AS 'sensorOnlineNum'

        FROM        goaf_sensor

        WHERE       A.oc_id = 406283
16:25:58.972 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:25:58 | Time Consuming: 3 ms | Connection: rollback-40 | SQL: 
16:27:52.859 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
16:27:52.861 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
16:27:52.863 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
16:27:52.866 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
16:27:52.866 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
16:27:52.866 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
16:27:52.873 [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)
16:27:52.874 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
16:27:52.874 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
16:27:52.874 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
16:27:52.874 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
16:27:52.886 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
16:27:52.889 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
16:28:01.983 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
16:28:02.041 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 18280 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
16:28:02.042 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
16:28:02.105 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
16:28:02.105 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
16:28:03.980 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
16:28:03.983 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
16:28:04.078 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 82 ms. Found 0 Redis repository interfaces.
16:28:04.251 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
16:28:04.269 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
16:28:05.063 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
16:28:05.064 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2958 ms
16:28:07.479 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
16:28:07.490 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
16:28:07.490 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
16:28:07.491 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
16:28:07.491 [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.

16:28:07.491 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
16:28:07.491 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
16:28:07.491 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@47be3a2c
16:28:09.270 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
16:28:09.276 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
16:28:09.424 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
16:28:09.457 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
16:28:09.458 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
16:28:09.458 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
16:28:09.481 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
16:28:09.492 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
16:28:09.502 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
16:28:09.534 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
16:28:09.596 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
16:28:09.598 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
16:28:09.598 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
16:28:09.631 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.135 seconds (process running for 14.68)
16:28:09.634 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
16:28:09.643 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
16:28:10.036 [restartedMain] INFO  p6spy - 2023-08-21 16:28:10 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1
16:28:10.041 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@5447718d
16:28:10.055 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
16:28:10.123 [restartedMain] INFO  p6spy - 2023-08-21 16:28:10 | Time Consuming: 5 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
16:28:10.144 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
16:28:10.145 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
16:28:21.636 [XNIO-1 task-2] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
16:28:21.636 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
16:28:21.638 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 2 ms
16:28:22.243 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
16:28:22.253 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 4 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'
16:28:22.270 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 5 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
16:28:22.650 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1
16:28:22.650 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

                IFNULL(SUM( CASE WHEN goaf_sensor_status = 1  THEN 1 ELSE 0 END ), 0) AS 'sensorOnlineNum'

        FROM        goaf_sensor

        WHERE       oc_id = 406283
16:28:22.651 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1
16:28:22.662 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:28:22.687 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:28:22 | Time Consuming: 30 ms | Connection: statement-2 | 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
                )
            )
16:28:23.235 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:28:23 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1
16:28:23.245 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:28:23 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:29:35.112 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT 1
16:29:35.128 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:29:35.128 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT 1
16:29:35.128 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT 1
16:29:35.128 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT 1
16:29:35.136 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:29:35.138 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:29:35.224 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:29:35.232 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:29:35 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:30:20.580 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:30:20 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1
16:30:20.592 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:30:20 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:30:21.926 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1
16:30:21.926 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
16:30:21.926 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1
16:30:21.928 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT 1
16:30:21.935 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 3 ms | Connection: statement-4 | SQL: SELECT 1
16:30:21.939 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:30:21.939 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:30:21.940 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:30:21.946 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 4 ms | Connection: statement-4 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:30:21.976 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:30:21.986 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:30:21 | Time Consuming: 8 ms | Connection: statement-2 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:31:05.268 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT 1
16:31:05.286 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 13 ms | Connection: statement-2 | 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'
16:31:05.308 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 7 ms | Connection: statement-2 | 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
16:31:05.486 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 4 ms | Connection: statement-4 | SQL: SELECT 1
16:31:05.489 [XNIO-1 task-4] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:31:05.501 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
16:31:05.506 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 8 ms | Connection: statement-3 | SQL: SELECT 1
16:31:05.506 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT 1
16:31:05.513 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:31:05.522 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 10 ms | Connection: statement-3 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:31:05.524 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 12 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:31:05.526 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 35 ms | Connection: statement-4 | 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
                )
            )
16:31:05.543 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:31:05.551 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:31:05 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:31:06.057 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:31:06 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:31:08.177 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1
16:31:08.177 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-4 | SQL: SELECT 1
16:31:08.177 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1
16:31:08.178 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT 1
16:31:08.178 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
16:31:08.188 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:31:08.189 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:31:08.189 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:31:08.189 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 6 ms | Connection: statement-4 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:31:08.221 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:31:08.230 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:31:08 | Time Consuming: 7 ms | Connection: statement-3 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:37:59.116 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:37:59 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1
16:37:59.116 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:37:59 | Time Consuming: 4 ms | Connection: statement-6 | SQL: SELECT 1
16:37:59.125 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:37:59 | Time Consuming: 4 ms | Connection: statement-6 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

                IFNULL(SUM( CASE WHEN goaf_sensor_status = 1  THEN 1 ELSE 0 END ), 0) AS 'sensorOnlineNum'

        FROM        goaf_sensor

        WHERE       oc_id = 406283
16:37:59.125 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:37:59 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:38:47.225 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 7 ms | Connection: statement-9 | SQL: SELECT 1
16:38:47.225 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 11 ms | Connection: statement-7 | SQL: SELECT 1
16:38:47.225 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 11 ms | Connection: statement-6 | SQL: SELECT 1
16:38:47.225 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 7 ms | Connection: statement-8 | SQL: SELECT 1
16:38:47.237 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:38:47.237 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 6 ms | Connection: statement-6 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:38:47.240 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 9 ms | Connection: statement-9 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:38:47.275 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 6 ms | Connection: statement-8 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:38:47.282 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:47 | Time Consuming: 5 ms | Connection: statement-8 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:38:49.234 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:49 | Time Consuming: 13 ms | Connection: statement-9 | SQL: SELECT 1
16:38:49.234 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:49 | Time Consuming: 13 ms | Connection: statement-8 | SQL: SELECT 1
16:38:49.245 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:49 | Time Consuming: 5 ms | Connection: statement-9 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:38:49.246 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:49 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

                IFNULL(SUM( CASE WHEN goaf_sensor_status = 1  THEN 1 ELSE 0 END ), 0) AS 'sensorOnlineNum'

        FROM        goaf_sensor

        WHERE       oc_id = 406283
16:38:56.939 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT 1
16:38:56.939 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 4 ms | Connection: statement-6 | SQL: SELECT 1
16:38:56.939 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT 1
16:38:56.939 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1
16:38:56.950 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 5 ms | Connection: statement-8 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:38:56.950 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:38:56.950 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 6 ms | Connection: statement-9 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:38:56.983 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 8 ms | Connection: statement-6 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:38:56.993 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:38:56 | Time Consuming: 8 ms | Connection: statement-6 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:39:01.174 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:39:01 | Time Consuming: 3 ms | Connection: statement-6 | SQL: SELECT 1
16:39:01.183 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:39:01 | Time Consuming: 3 ms | Connection: statement-6 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:39:50.286 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 5 ms | Connection: statement-6 | SQL: SELECT 1
16:39:50.286 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 5 ms | Connection: statement-8 | SQL: SELECT 1
16:39:50.287 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 6 ms | Connection: statement-9 | SQL: SELECT 1
16:39:50.287 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 6 ms | Connection: statement-7 | SQL: SELECT 1
16:39:50.290 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT 1
16:39:50.297 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:39:50.297 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 5 ms | Connection: statement-8 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:39:50.298 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 6 ms | Connection: statement-6 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:39:50.299 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:39:50.329 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 5 ms | Connection: statement-10 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:39:50.336 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:39:50 | Time Consuming: 6 ms | Connection: statement-10 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
16:45:02.920 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:45:02 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
16:45:02.927 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:45:02 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:45:04.314 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
16:45:04.320 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 4 ms | Connection: statement-12 | SQL: SELECT 1
16:45:04.320 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 4 ms | Connection: statement-14 | SQL: SELECT 1
16:45:04.321 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT 1
16:45:04.321 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 5 ms | Connection: statement-15 | SQL: SELECT 1
16:45:04.322 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:45:04.330 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:45:04.333 [XNIO-1 task-5] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
16:45:04.333 [XNIO-1 task-6] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 5 ms | Connection: statement-14 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:45:04.362 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 6 ms | Connection: statement-15 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count
16:45:04.372 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 16:45:04 | Time Consuming: 8 ms | Connection: statement-15 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 999999 
18:34:00.019 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start
18:34:00.025 [quartzScheduler_Worker-1] INFO  p6spy - 2023-08-21 18:34:00 | Time Consuming: 5 ms | Connection: statement-76 | SQL: SELECT 1
18:34:00.038 [quartzScheduler_Worker-1] INFO  p6spy - 2023-08-21 18:34:00 | Time Consuming: 5 ms | Connection: rollback-76 | SQL: 
18:34:00.044 [quartzScheduler_Worker-1] INFO  org.quartz.core.JobRunShell - Job DEFAULT_JOB_GROUP.Cron任务 threw a JobExecutionException: 
org.quartz.JobExecutionException: null
	at com.zhyc.xps.goaf.job.GoafCheckTaskJob.execute(GoafCheckTaskJob.java:29)
	at org.quartz.core.JobRunShell.run(JobRunShell.java:202)
	at org.quartz.simpl.SimpleThreadPool$WorkerThread.run(SimpleThreadPool.java:573)
19:30:56.372 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:56 | Time Consuming: 5 ms | Connection: statement-111 | SQL: SELECT 1
19:30:56.387 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:56 | Time Consuming: 9 ms | Connection: statement-111 | 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'
19:30:56.412 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:56 | Time Consuming: 5 ms | Connection: statement-111 | 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
19:30:56.638 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:56 | Time Consuming: 30 ms | Connection: statement-111 | 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
                )
            )
19:30:57.168 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:57 | Time Consuming: 3 ms | Connection: statement-111 | SQL: SELECT 1
19:30:57.177 [XNIO-1 task-7] INFO  p6spy - 2023-08-21 19:30:57 | Time Consuming: 4 ms | Connection: statement-111 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
19:43:32.126 [File Watcher] INFO  o.s.b.d.a.LocalDevToolsAutoConfiguration$RestartingClassPathChangeChangedEventListener - Restarting due to 1 class path change (0 additions, 1 deletion, 0 modifications)
19:43:32.130 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:43:32.131 [Thread-11] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
19:43:32.135 [Thread-11] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
19:43:32.138 [Thread-11] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
19:43:32.138 [Thread-11] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
19:43:32.138 [Thread-11] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
19:43:32.143 [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)
19:43:32.144 [Thread-11] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
19:43:32.144 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
19:43:32.144 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:43:32.144 [Thread-11] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
19:43:32.157 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
19:43:32.159 [Thread-11] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
19:43:32.422 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 18280 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
19:43:32.422 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
19:43:33.568 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
19:43:33.568 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
19:43:33.638 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 69 ms. Found 0 Redis repository interfaces.
19:43:33.726 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
19:43:33.727 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
19:43:33.882 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
19:43:33.882 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 1455 ms
19:43:35.373 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
19:43:35.373 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
19:43:35.373 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
19:43:35.374 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
19:43:35.374 [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.

19:43:35.374 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
19:43:35.374 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
19:43:35.374 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@3ecb158f
19:43:36.176 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
19:43:36.176 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
19:43:36.176 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:43:36.176 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
19:43:36.192 [restartedMain] INFO  o.s.b.a.l.ConditionEvaluationReportLogger - 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
19:43:37.976 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 18280 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
19:43:37.976 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
19:43:39.972 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
19:43:39.972 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
19:43:40.071 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 98 ms. Found 0 Redis repository interfaces.
19:43:40.232 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
19:43:40.232 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
19:43:40.502 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
19:43:40.502 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2522 ms
19:43:42.266 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
19:43:42.266 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
19:43:42.266 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
19:43:42.266 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
19:43:42.266 [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.

19:43:42.266 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
19:43:42.266 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
19:43:42.266 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@4bb04b2d
19:43:43.276 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
19:43:43.280 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
19:43:43.331 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
19:43:43.334 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
19:43:43.334 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
19:43:43.335 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
19:43:43.336 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
19:43:43.352 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
19:43:43.352 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
19:43:43.352 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
19:43:43.370 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 5.433 seconds (process running for 11748.418)
19:43:43.371 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
19:43:43.372 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
19:43:43.427 [restartedMain] INFO  p6spy - 2023-08-21 19:43:43 | Time Consuming: 3 ms | Connection: statement-121 | SQL: SELECT 1
19:43:43.431 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@1f28d048
19:43:43.431 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
19:43:43.441 [restartedMain] INFO  p6spy - 2023-08-21 19:43:43 | Time Consuming: 4 ms | Connection: statement-121 | 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
19:43:43.443 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
19:43:43.443 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
19:43:43.506 [restartedMain] INFO  o.s.b.d.a.ConditionEvaluationDeltaLoggingListener - Condition evaluation unchanged
19:45:50.514 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:45:50.514 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
19:45:50.515 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
19:45:50.515 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
19:45:50.515 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
19:45:50.517 [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)
19:45:50.517 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
19:45:50.517 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
19:45:50.517 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:45:50.517 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
19:45:50.526 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
19:45:50.528 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
20:31:17.631 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
20:31:17.712 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 14520 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
20:31:17.713 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
20:31:17.795 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
20:31:17.795 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
20:31:19.659 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
20:31:19.663 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
20:31:19.756 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 79 ms. Found 0 Redis repository interfaces.
20:31:19.924 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
20:31:19.941 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
20:31:20.678 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
20:31:20.679 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2883 ms
20:31:23.056 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
20:31:23.066 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
20:31:23.066 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
20:31:23.067 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
20:31:23.068 [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.

20:31:23.068 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
20:31:23.068 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
20:31:23.068 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@15e88965
20:31:24.907 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
20:31:24.912 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
20:31:25.058 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
20:31:25.090 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:31:25.090 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
20:31:25.090 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
20:31:25.110 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
20:31:25.120 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
20:31:25.130 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
20:31:25.160 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
20:31:25.213 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
20:31:25.214 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
20:31:25.214 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:31:25.240 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.226 seconds (process running for 9.125)
20:31:25.242 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
20:31:25.250 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
20:31:25.576 [restartedMain] INFO  p6spy - 2023-08-21 20:31:25 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1
20:31:25.580 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@1e9179a7
20:31:25.583 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
20:31:25.651 [restartedMain] INFO  p6spy - 2023-08-21 20:31:25 | Time Consuming: 6 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
20:31:25.672 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:31:25.674 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:31:26.428 [RMI TCP Connection(4)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
20:31:26.428 [RMI TCP Connection(5)-192.168.3.5] INFO  p6spy - 2023-08-21 20:31:26 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
20:31:26.428 [RMI TCP Connection(4)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
20:31:26.432 [RMI TCP Connection(4)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms
20:31:26.439 [RMI TCP Connection(5)-192.168.3.5] INFO  p6spy - 2023-08-21 20:31:26 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
20:33:16.823 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
20:33:16.835 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 5 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'
20:33:16.854 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 5 ms | Connection: statement-0 | 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 = 'system'
        OR   A.account_phone = 'system'
        OR   A.account_mail  = 'system'
        OR   A.account_staff_no = 'system')
20:33:16.865 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 4 ms | Connection: statement-0 | 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 = 1
20:33:16.871 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 4 ms | Connection: statement-0 | 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 = 1
        LIMIT 1
20:33:16.877 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 4 ms | Connection: statement-0 | 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 = 1
         
         
            AND A.account_id = 1
         
        LIMIT 1
20:33:16.885 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 5 ms | Connection: statement-0 | 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 = 1
         
         
            AND A.group_id = 1
         
         
            AND A.account_id = 1
         
        LIMIT 1
20:33:16.892 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:16 | Time Consuming: 5 ms | Connection: statement-0 | 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 = 1
         
         
            AND A.group_id = 1
         
         
            AND A.account_id = 1
         
         
            AND A.position_id = 1
         
        LIMIT 1
20:33:17.415 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:17 | Time Consuming: 4 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'
20:33:17.439 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:17 | Time Consuming: 5 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 = 1
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
20:33:17.739 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:17 | Time Consuming: 8 ms | Connection: statement-0 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 1
            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 = 1 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 = 1 AND CC.status=0
                )
            )
20:33:18.341 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:18 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT 1
20:33:18.352 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:18 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 1
20:33:22.873 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 20:33:22 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
20:33:22.873 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:22 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
20:33:22.882 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 20:33:22 | 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
20:33:22.882 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:22 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        role_id,
        role_name,
        role_code,
        role_desc,
        role_type_id,
        sort_no,
        is_fixed
     
        FROM  s_role
        WHERE deleted_flag = 0
         
        ORDER BY role_id ASC
20:33:22.936 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:22 | Time Consuming: 4 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  = 1
         
         
            AND A.role_id = 1
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
20:33:26.185 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:26 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
20:33:26.268 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:26 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT count(0) FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0
20:33:26.279 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:33:26 | Time Consuming: 7 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
         
         
         
        ORDER BY A.job_id ASC
 LIMIT 10 
20:36:54.587 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:36:54 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
20:36:54.587 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 20:36:54 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1
20:36:54.597 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:36:54 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        job_class_id,
        job_class_title,
        job_class_desc,
        job_class
     
        FROM     job_class
        WHERE    deleted_flag = 0
        ORDER BY job_class_id ASC
20:36:54.598 [XNIO-1 task-2] INFO  p6spy - 2023-08-21 20:36:54 | Time Consuming: 5 ms | Connection: statement-1 | 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.job_id = 439094
20:37:04.673 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:37:04 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
20:37:04.692 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:37:04 | Time Consuming: 11 ms | Connection: statement-0 | SQL: UPDATE job
         SET job_title   = '巡检天任务',
                
                
                    job_desc   = '天任务',
                
                
                    status  = 1,
                
                
                    job_type  = 1,
                
                
                    job_code = 'Cron任务',
                
                
                    job_cron = '0 38 20 * * ?',
                
                
                    job_class_id = 2,
                
                
                    cycle_title = '天',
                
                
                    cycle_period = 0,
                
                
                    cycle_unit = 0,
                
                
                    updated_by     = 1,
                
                
                    updated_at    = '2023-08-21T20:37:04.677258300' 
        WHERE job_id = 439094
20:37:04.739 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:37:04 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0
20:37:04.746 [XNIO-1 task-3] INFO  p6spy - 2023-08-21 20:37:04 | Time Consuming: 5 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
         
         
         
        ORDER BY A.job_id ASC
 LIMIT 10 
20:37:10.503 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:37:10.507 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
20:37:10.510 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
20:37:10.513 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:37:10.513 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
20:37:10.513 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
20:37:10.519 [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)
20:37:10.520 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
20:37:10.520 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
20:37:10.520 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:37:10.520 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
20:37:10.532 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
20:37:10.536 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
20:37:20.049 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
20:37:20.098 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 10936 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
20:37:20.098 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
20:37:20.156 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
20:37:20.156 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
20:37:22.007 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
20:37:22.011 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
20:37:22.100 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 76 ms. Found 0 Redis repository interfaces.
20:37:22.268 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
20:37:22.284 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
20:37:23.019 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
20:37:23.020 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2863 ms
20:37:25.449 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
20:37:25.459 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
20:37:25.459 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
20:37:25.459 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
20:37:25.460 [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.

20:37:25.460 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
20:37:25.460 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
20:37:25.460 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@1747a9cc
20:37:27.140 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
20:37:27.146 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
20:37:27.291 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
20:37:27.321 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:37:27.321 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
20:37:27.322 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
20:37:27.343 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
20:37:27.352 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
20:37:27.362 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
20:37:27.390 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
20:37:27.439 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
20:37:27.441 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
20:37:27.441 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:37:27.465 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 7.893 seconds (process running for 15.0)
20:37:27.467 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
20:37:27.474 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
20:37:27.809 [restartedMain] INFO  p6spy - 2023-08-21 20:37:27 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1
20:37:27.814 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@31767e36
20:37:27.824 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
20:37:27.889 [restartedMain] INFO  p6spy - 2023-08-21 20:37:27 | Time Consuming: 5 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
20:37:27.910 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:37:27.911 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
20:38:00.014 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start
20:38:00.020 [quartzScheduler_Worker-1] INFO  p6spy - 2023-08-21 20:38:00 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
20:38:00.041 [quartzScheduler_Worker-1] INFO  c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End
20:38:33.487 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:38:33.488 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
20:38:33.499 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:38:33.499 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
20:38:33.499 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
20:38:33.507 [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)
20:38:33.509 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
20:38:33.509 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
20:38:33.509 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:38:33.509 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
20:38:33.522 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
20:38:33.526 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.