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.