11:00:49.542 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 11:00:49.612 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 7520 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 11:00:49.613 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 11:00:49.680 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 11:00:49.681 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 11:00:51.790 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 11:00:51.795 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 11:00:51.884 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 71 ms. Found 0 Redis repository interfaces. 11:00:52.060 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 11:00:52.086 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 11:00:52.974 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:00:52.974 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3293 ms 11:00:55.530 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 11:00:55.542 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 11:00:55.543 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 11:00:55.543 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 11:00:55.544 [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:00:55.544 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 11:00:55.544 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 11:00:55.544 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@6f9f550a 11:00:57.474 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 11:00:57.637 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 11:00:57.671 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:00:57.672 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 11:00:57.672 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 11:00:57.701 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:00:57.715 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 11:00:57.728 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 11:00:57.766 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 11:00:57.824 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 11:00:57.981 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:00:57.981 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 152 ms 11:00:57.990 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 11:00:58.026 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:00:58.043 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 11:00:58.047 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 11:00:58.047 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.072 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 9.194 seconds (process running for 10.675) 11:00:58.074 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 11:00:58.083 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 11:00:58.527 [restartedMain] INFO p6spy - 2023-06-13 11:00:58 | Time Consuming: 17 ms | Connection: statement-0 | SQL: SELECT 1 11:00:58.533 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@733694e7 11:00:58.536 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 11:00:58.614 [restartedMain] INFO p6spy - 2023-06-13 11:00:58 | 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:00:58.642 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.645 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.645 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.645 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.645 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.646 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.646 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.646 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:00:58.979 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 11:00:58.979 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 11:00:58.982 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms 11:00:58.994 [RMI TCP Connection(5)-192.168.3.5] INFO p6spy - 2023-06-13 11:00:58 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 11:02:42.321 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:02:42.357 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:02:42.358 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:02:42.359 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 11:02:42.360 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:02:42.360 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 11:02:42.360 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 11:02:42.370 [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:02:42.371 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 11:02:42.371 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 11:02:42.372 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:02:42.372 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 11:02:42.384 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 11:02:42.388 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 11:02:48.287 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 11:02:48.344 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 4904 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 11:02:48.345 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 11:02:48.404 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 11:02:48.405 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 11:02:50.299 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 11:02:50.303 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 11:02:50.393 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces. 11:02:50.566 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 11:02:50.585 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 11:02:51.418 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:02:51.418 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3013 ms 11:02:53.850 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 11:02:53.862 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 11:02:53.862 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 11:02:53.862 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 11:02:53.863 [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:02:53.863 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 11:02:53.863 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 11:02:53.863 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@638e413 11:02:55.723 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 11:02:55.860 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 11:02:55.891 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:02:55.891 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 11:02:55.892 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 11:02:55.913 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:02:55.923 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 11:02:55.935 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 11:02:55.970 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 11:02:56.029 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 11:02:56.176 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:02:56.176 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 141 ms 11:02:56.185 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 11:02:56.222 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:02:56.239 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 11:02:56.243 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 11:02:56.243 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.265 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.508 seconds (process running for 9.443) 11:02:56.267 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 11:02:56.275 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 11:02:56.627 [restartedMain] INFO p6spy - 2023-06-13 11:02:56 | Time Consuming: 14 ms | Connection: statement-0 | SQL: SELECT 1 11:02:56.631 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@765aa534 11:02:56.642 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 11:02:56.712 [restartedMain] INFO p6spy - 2023-06-13 11:02:56 | 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 11:02:56.738 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.740 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.740 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.740 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.741 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.741 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.741 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:56.741 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:02:57.234 [RMI TCP Connection(3)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 11:02:57.234 [RMI TCP Connection(3)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 11:02:57.237 [RMI TCP Connection(3)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms 11:02:57.244 [RMI TCP Connection(2)-192.168.3.5] INFO p6spy - 2023-06-13 11:02:57 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 11:10:00.351 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:00 | Time Consuming: 5023 ms | Connection: statement-0 | SQL: SELECT 1 11:10:05.358 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:05 | Time Consuming: 5005 ms | Connection: statement-1 | SQL: SELECT 1 11:10:10.364 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:10 | Time Consuming: 5004 ms | Connection: statement-2 | SQL: SELECT 1 11:10:15.377 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:15 | Time Consuming: 5012 ms | Connection: statement-3 | SQL: SELECT 1 11:10:20.391 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 5013 ms | Connection: statement-4 | SQL: SELECT 1 11:10:20.395 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 11:10:20.407 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 11:10:20.422 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 11:10:20.790 [XNIO-1 task-2] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-6 | SQL: SELECT 1 11:10:20.790 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT 1 11:10:20.791 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1 11:10:20.801 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 5 ms | Connection: statement-8 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:10:20.801 [XNIO-1 task-2] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 5 ms | Connection: statement-6 | 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 11:10:20.809 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 2 ms | Connection: statement-9 | SQL: SELECT 1 11:10:20.842 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 27 ms | Connection: statement-9 | 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 ) ) 11:10:20.911 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 11:10:20.911 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-5 | 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 11:10:20.918 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 4 ms | Connection: statement-5 | 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 11:10:20.920 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:20 | Time Consuming: 6 ms | Connection: statement-7 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 11:10:34.758 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:34 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1 11:10:36.356 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1 11:10:36.367 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 5 ms | Connection: statement-7 | 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' 11:10:36.385 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT A.oc_id, B.oc_type_id, B.oc_name, A.account_id, A.account_name, A.account_real_name, A.password, A.account_type, A.account_staff_no, A.account_phone, A.account_last_ip, A.account_loc, A.status, A.account_avatar, A.account_photo, A.account_real_name, A.account_intro, A.wx_id, A.is_fixed FROM account AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id ) WHERE A.deleted_flag = 0 AND (A.account_name = 'sxky' OR A.account_phone = 'sxky' OR A.account_mail = 'sxky' OR A.account_staff_no = 'sxky') 11:10:36.394 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT A.oc_id, A.oc_name, A.oc_type_id, A.root_id, A.parent_id, A.admin_id, B.account_name AS admin_name, A.group_id, A.node_left, A.node_right, A.node_level, A.is_leaf, A.status, A.if_lic FROM oc AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id) WHERE A.oc_id = 406283 11:10:36.399 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT A.rm_id, A.role_id, B.role_type_id, B.role_code, B.role_name, A.account_id FROM s_role_member AS A LEFT JOIN s_role AS B ON (A.role_id = B.role_id) WHERE account_id = 406283 LIMIT 1 11:10:36.405 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT A.gm_id, A.oc_id, A.group_id, B.group_name, B.node_left , B.node_right, A.account_id FROM s_group_member AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 LIMIT 1 11:10:36.411 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT A.gmp_id, A.oc_id, A.group_id, B.group_name, A.account_id, D.account_name, D.account_real_name, A.position_id, C.position_name FROM s_group_member_position A LEFT JOIN s_group B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) LEFT JOIN s_position C ON (A.oc_id = C.oc_id AND A.position_id = C.position_id) LEFT JOIN account D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 LIMIT 1 11:10:36.417 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT A.gmpg_id, A.oc_id, A.group_id, A.account_id, A.position_id, A.grant_group_id, B.group_name AS grant_group_name FROM s_group_member_position_grant A LEFT JOIN s_group B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 AND A.position_id = 406283 LIMIT 1 11:10:36.480 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-7 | 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' 11:10:36.501 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 5 ms | Connection: statement-7 | 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 11:10:36.734 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 11:10:36.734 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-8 | SQL: SELECT 1 11:10:36.736 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 11:10:36.736 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:10:36.743 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 2 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 11:10:36.743 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 11:10:36.748 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 11:10:36.768 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:36 | Time Consuming: 29 ms | Connection: statement-8 | 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 ) ) 11:10:39.817 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 11:10:39.817 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 3 ms | Connection: statement-8 | SQL: SELECT 1 11:10:39.817 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT 1 11:10:39.818 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 11:10:39.826 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:10:39.826 [XNIO-1 task-3] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 4 ms | Connection: statement-5 | 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 11:10:39.869 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 11:10:39.869 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 4 ms | Connection: statement-7 | 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 11:10:39.876 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 11:10:39.876 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:39 | Time Consuming: 5 ms | Connection: statement-7 | 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 11:10:43.380 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 11:10:43.380 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT 1 11:10:43.390 [XNIO-1 task-5] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 4 ms | Connection: statement-8 | 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 11:10:43.408 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT 1 11:10:43.419 [XNIO-1 task-4] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.hdanger_id = 441050 11:10:43.421 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 3 ms | Connection: statement-9 | 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 11:10:43.426 [XNIO-1 task-6] INFO p6spy - 2023-06-13 11:10:43 | Time Consuming: 4 ms | Connection: statement-9 | 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 13:07:21.942 [XNIO-1 task-6] INFO p6spy - 2023-06-13 13:07:21 | Time Consuming: 6 ms | Connection: statement-11 | SQL: replace into uid_sequence(stub) values('a') 13:07:21.947 [XNIO-1 task-6] INFO p6spy - 2023-06-13 13:07:21 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT LAST_INSERT_ID() AS uid 13:07:21.961 [XNIO-1 task-6] INFO p6spy - 2023-06-13 13:07:21 | Time Consuming: 9 ms | Connection: statement-11 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441442, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/202361313721156431.jpg', 'http://113.141.93.143:9000/icon/2023613137219079350.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T13:07:21.947914300', 406283, '2023-06-13T13:07:21.947914300' ) 13:07:39.785 [XNIO-1 task-8] INFO p6spy - 2023-06-13 13:07:39 | Time Consuming: 6 ms | Connection: statement-11 | SQL: SELECT 1 13:07:39.840 [XNIO-1 task-8] INFO p6spy - 2023-06-13 13:07:39 | Time Consuming: 4 ms | Connection: statement-11 | 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' 13:07:39.972 [XNIO-1 task-8] INFO p6spy - 2023-06-13 13:07:39 | Time Consuming: 57 ms | Connection: statement-11 | 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 13:07:40.311 [XNIO-1 task-7] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 164 ms | Connection: statement-12 | SQL: SELECT 1 13:07:40.311 [XNIO-1 task-5] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 164 ms | Connection: statement-14 | SQL: SELECT 1 13:07:40.311 [XNIO-1 task-8] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 164 ms | Connection: statement-13 | SQL: SELECT 1 13:07:40.311 [XNIO-1 task-6] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 164 ms | Connection: statement-15 | SQL: SELECT 1 13:07:40.355 [XNIO-1 task-5] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 36 ms | Connection: statement-14 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 13:07:40.355 [XNIO-1 task-6] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 36 ms | Connection: statement-15 | 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 ) ) 13:07:40.355 [XNIO-1 task-8] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 36 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 13:07:40.376 [XNIO-1 task-2] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 8 ms | Connection: statement-11 | 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 13:07:40.406 [XNIO-1 task-7] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 32 ms | Connection: statement-12 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 13:07:40.414 [XNIO-1 task-2] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 35 ms | Connection: statement-11 | 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 13:07:40.419 [XNIO-1 task-7] INFO p6spy - 2023-06-13 13:07:40 | Time Consuming: 11 ms | Connection: statement-12 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 15:08:05.066 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:05 | Time Consuming: 5002 ms | Connection: statement-82 | SQL: SELECT 1 15:08:10.069 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:10 | Time Consuming: 5001 ms | Connection: statement-83 | SQL: SELECT 1 15:08:11.658 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 15:08:11.667 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 15:08:11.668 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 15:08:11.671 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 15:08:11.672 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 15:08:11.673 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 15:08:11.673 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 15:08:11.684 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process) 15:08:11.686 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 15:08:11.686 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 15:08:11.686 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 15:08:11.686 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 15:08:11.698 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 15:08:11.702 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 15:08:11.703 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:11 | Time Consuming: 1633 ms | Connection: statement-84 | SQL: SELECT 1 15:08:15.329 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 15:08:15.387 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 17596 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 15:08:15.388 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 15:08:15.450 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 15:08:15.450 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 15:08:17.393 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 15:08:17.397 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 15:08:17.490 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 77 ms. Found 0 Redis repository interfaces. 15:08:17.659 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 15:08:17.678 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 15:08:18.529 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 15:08:18.529 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3078 ms 15:08:21.056 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 15:08:21.069 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 15:08:21.069 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 15:08:21.070 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 15:08:21.070 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 15:08:21.070 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 15:08:21.070 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 15:08:21.070 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@6305a252 15:08:22.993 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 15:08:23.134 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 15:08:23.167 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 15:08:23.167 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 15:08:23.167 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 15:08:23.190 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 15:08:23.202 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 15:08:23.214 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 15:08:23.251 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 15:08:23.306 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 15:08:23.455 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 15:08:23.455 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 142 ms 15:08:23.464 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 15:08:23.498 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 15:08:23.515 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 15:08:23.518 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 15:08:23.518 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:23.540 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.756 seconds (process running for 9.776) 15:08:23.543 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 15:08:23.551 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 15:08:23.906 [restartedMain] INFO p6spy - 2023-06-13 15:08:23 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1 15:08:23.910 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@979da19 15:08:23.913 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 15:08:23.987 [restartedMain] INFO p6spy - 2023-06-13 15:08:23 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 15:08:24.013 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.015 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.015 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.016 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.016 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.016 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.016 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.017 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 15:08:24.276 [RMI TCP Connection(6)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 15:08:24.276 [RMI TCP Connection(6)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 15:08:24.280 [RMI TCP Connection(6)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms 15:08:24.299 [RMI TCP Connection(5)-192.168.3.5] INFO p6spy - 2023-06-13 15:08:24 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 15:08:35.294 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 15:08:35.307 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | 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' 15:08:35.329 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 7 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 = 'sxky' OR A.account_phone = 'sxky' OR A.account_mail = 'sxky' OR A.account_staff_no = 'sxky') 15:08:35.342 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | 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 = 406283 15:08:35.349 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 5 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 = 406283 LIMIT 1 15:08:35.357 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 5 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 = 406283 AND A.account_id = 406283 LIMIT 1 15:08:35.366 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | 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 = 406283 AND A.group_id = 406283 AND A.account_id = 406283 LIMIT 1 15:08:35.373 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 4 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 = 406283 AND A.group_id = 406283 AND A.account_id = 406283 AND A.position_id = 406283 LIMIT 1 15:08:35.916 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | 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' 15:08:35.937 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:35 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 15:08:36.232 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1 15:08:36.232 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT 1 15:08:36.233 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT 1 15:08:36.245 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 15:08:36.246 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 7 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:08:36.258 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 28 ms | Connection: statement-0 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 15:08:36.327 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 15:08:36.337 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:36 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 15:08:44.718 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:44 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 15:08:45.912 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT 1 15:08:45.925 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 7 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' 15:08:45.943 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, B.oc_type_id, B.oc_name, A.account_id, A.account_name, A.account_real_name, A.password, A.account_type, A.account_staff_no, A.account_phone, A.account_last_ip, A.account_loc, A.status, A.account_avatar, A.account_photo, A.account_real_name, A.account_intro, A.wx_id, A.is_fixed FROM account AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id ) WHERE A.deleted_flag = 0 AND (A.account_name = 'sxky' OR A.account_phone = 'sxky' OR A.account_mail = 'sxky' OR A.account_staff_no = 'sxky') 15:08:45.948 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.oc_name, A.oc_type_id, A.root_id, A.parent_id, A.admin_id, B.account_name AS admin_name, A.group_id, A.node_left, A.node_right, A.node_level, A.is_leaf, A.status, A.if_lic FROM oc AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id) WHERE A.oc_id = 406283 15:08:45.953 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT A.rm_id, A.role_id, B.role_type_id, B.role_code, B.role_name, A.account_id FROM s_role_member AS A LEFT JOIN s_role AS B ON (A.role_id = B.role_id) WHERE account_id = 406283 LIMIT 1 15:08:45.958 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.gm_id, A.oc_id, A.group_id, B.group_name, B.node_left , B.node_right, A.account_id FROM s_group_member AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 LIMIT 1 15:08:45.965 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT A.gmp_id, A.oc_id, A.group_id, B.group_name, A.account_id, D.account_name, D.account_real_name, A.position_id, C.position_name FROM s_group_member_position A LEFT JOIN s_group B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) LEFT JOIN s_position C ON (A.oc_id = C.oc_id AND A.position_id = C.position_id) LEFT JOIN account D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 LIMIT 1 15:08:45.971 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:45 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.gmpg_id, A.oc_id, A.group_id, A.account_id, A.position_id, A.grant_group_id, B.group_name AS grant_group_name FROM s_group_member_position_grant A LEFT JOIN s_group B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 AND A.position_id = 406283 LIMIT 1 15:08:46.006 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 3 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' 15:08:46.023 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 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 15:08:46.138 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1 15:08:46.141 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1 15:08:46.141 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 15:08:46.142 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:08:46.150 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 15:08:46.151 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 15:08:46.158 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 15:08:46.176 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:08:46 | Time Consuming: 29 ms | Connection: statement-1 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 15:09:25.884 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:09:25 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1 15:09:25.918 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:09:25 | Time Consuming: 29 ms | Connection: statement-1 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 15:10:05.363 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1 15:10:05.376 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 15:10:05.402 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT A.oc_id, B.oc_type_id, B.oc_name, A.account_id, A.account_name, A.account_real_name, A.password, A.account_type, A.account_staff_no, A.account_phone, A.account_last_ip, A.account_loc, A.status, A.account_avatar, A.account_photo, A.account_real_name, A.account_intro, A.wx_id, A.is_fixed FROM account AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id ) WHERE A.deleted_flag = 0 AND (A.account_name = 'sxky' OR A.account_phone = 'sxky' OR A.account_mail = 'sxky' OR A.account_staff_no = 'sxky') 15:10:05.407 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT A.oc_id, A.oc_name, A.oc_type_id, A.root_id, A.parent_id, A.admin_id, B.account_name AS admin_name, A.group_id, A.node_left, A.node_right, A.node_level, A.is_leaf, A.status, A.if_lic FROM oc AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id) WHERE A.oc_id = 406283 15:10:05.411 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT A.rm_id, A.role_id, B.role_type_id, B.role_code, B.role_name, A.account_id FROM s_role_member AS A LEFT JOIN s_role AS B ON (A.role_id = B.role_id) WHERE account_id = 406283 LIMIT 1 15:10:05.416 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT A.gm_id, A.oc_id, A.group_id, B.group_name, B.node_left , B.node_right, A.account_id FROM s_group_member AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 LIMIT 1 15:10:05.420 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT A.gmp_id, A.oc_id, A.group_id, B.group_name, A.account_id, D.account_name, D.account_real_name, A.position_id, C.position_name FROM s_group_member_position A LEFT JOIN s_group B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) LEFT JOIN s_position C ON (A.oc_id = C.oc_id AND A.position_id = C.position_id) LEFT JOIN account D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 LIMIT 1 15:10:05.425 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT A.gmpg_id, A.oc_id, A.group_id, A.account_id, A.position_id, A.grant_group_id, B.group_name AS grant_group_name FROM s_group_member_position_grant A LEFT JOIN s_group B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 AND A.position_id = 406283 LIMIT 1 15:10:05.466 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 15:10:05.484 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 15:10:05.641 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 15:10:05.648 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 15:10:05.649 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT 1 15:10:05.649 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 15:10:05.651 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 15:10:05.657 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:10:05.657 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 15:10:05.683 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:10:05 | Time Consuming: 28 ms | Connection: statement-3 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 15:10:08.403 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT 1 15:10:08.403 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 15:10:08.404 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1 15:10:08.409 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT 1 15:10:08.411 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-4 | SQL: SELECT 1 15:10:08.417 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 6 ms | Connection: statement-2 | 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.oc_id = 406283 AND A.account_id = 406283 15:10:08.422 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum', IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum', IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum', IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum', IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum', IFNULL(SUM( CASE WHEN status = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum', IFNULL(SUM( CASE WHEN status = 4 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum', IFNULL(SUM( CASE WHEN status = -1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum' FROM goaf_hdanger AS A WHERE A.oc_id = 406283 AND A.status != -1 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 15:10:08.424 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 6 ms | Connection: statement-4 | SQL: SELECT IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum', IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum', IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum', IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum', IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum', IFNULL(SUM( CASE WHEN status = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum', IFNULL(SUM( CASE WHEN status = 4 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum', IFNULL(SUM( CASE WHEN status = -1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum' FROM goaf_hdanger AS A WHERE A.oc_id = 406283 AND A.status != -1 AND A.hdanger_type = '1' ORDER BY A.submit_time DESC 15:10:08.425 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 15:10:08.429 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 10 ms | Connection: statement-3 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-13 00:00:00' AND A.expected_end_date <= '2023-06-14 00:00:00' 15:10:08.437 [XNIO-1 task-7] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT oc_id, map_id, map_title, map_desc, map_cat_id, map_raster_layer, map_type_id FROM ent_map WHERE 1 = 1 AND deleted_flag = 0 AND oc_id = 406283 15:10:08.453 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-4 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:10:08.454 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '1' ORDER BY A.submit_time DESC 15:10:08.478 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 4 ms | Connection: statement-4 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:10:08.490 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.goaflayer_id, A.oc_id, A.goaf_id, A.goaf_name, A.map_id, A.layer_id, B.layer_cat_id, B.layer_title, B.layer_marker, B.layer_vector, B.layer_vector_type FROM goaf_map_layer AS A left join ent_map_layer AS B ON B.layer_id = A.layer_id WHERE A.oc_id = 406283 AND A.map_id = '406283' 15:10:08.494 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 15:10:08.503 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:10:08 | Time Consuming: 5 ms | Connection: statement-4 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:11:29.607 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-3 | SQL: SELECT 1 15:11:29.607 [XNIO-1 task-7] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-4 | SQL: SELECT 1 15:11:29.607 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT 1 15:11:29.607 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT 1 15:11:29.607 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT 1 15:11:29.619 [XNIO-1 task-7] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 6 ms | Connection: statement-4 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-13 00:00:00' AND A.expected_end_date <= '2023-06-14 00:00:00' 15:11:29.619 [XNIO-1 task-6] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum', IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum', IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum', IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum', IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum', IFNULL(SUM( CASE WHEN status = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum', IFNULL(SUM( CASE WHEN status = 4 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum', IFNULL(SUM( CASE WHEN status = -1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum' FROM goaf_hdanger AS A WHERE A.oc_id = 406283 AND A.status != -1 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 15:11:29.619 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum', IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum', IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum', IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum', IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum', IFNULL(SUM( CASE WHEN status = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum', IFNULL(SUM( CASE WHEN status = 4 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum', IFNULL(SUM( CASE WHEN status = -1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum' FROM goaf_hdanger AS A WHERE A.oc_id = 406283 AND A.status != -1 AND A.hdanger_type = '1' ORDER BY A.submit_time DESC 15:11:29.619 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT A.oc_id, B.oc_type_id, B.oc_name, A.account_id, A.account_name, A.account_real_name, A.password, A.account_type, A.account_staff_no, A.account_phone, A.account_last_ip, A.account_loc, A.status, A.account_avatar, A.account_photo, A.account_real_name, A.account_intro, A.wx_id, A.is_fixed FROM account AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id ) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 15:11:29.621 [XNIO-1 task-4] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 8 ms | Connection: statement-3 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 15:11:29.649 [XNIO-1 task-7] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-4 | SQL: SELECT oc_id, map_id, map_title, map_desc, map_cat_id, map_raster_layer, map_type_id FROM ent_map WHERE 1 = 1 AND deleted_flag = 0 AND oc_id = 406283 15:11:29.649 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:11:29.649 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '1' ORDER BY A.submit_time DESC 15:11:29.667 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 15:11:29.687 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:11:29.706 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT A.goaflayer_id, A.oc_id, A.goaf_id, A.goaf_name, A.map_id, A.layer_id, B.layer_cat_id, B.layer_title, B.layer_marker, B.layer_vector, B.layer_vector_type FROM goaf_map_layer AS A left join ent_map_layer AS B ON B.layer_id = A.layer_id WHERE A.oc_id = 406283 AND A.map_id = '406283' 15:11:29.723 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:11:29 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:11:31.513 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 9 ms | Connection: statement-1 | SQL: SELECT 1 15:11:31.514 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT 1 15:11:31.514 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 9 ms | Connection: statement-2 | SQL: SELECT 1 15:11:31.535 [XNIO-1 task-5] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 10 ms | Connection: statement-2 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:11:31.535 [XNIO-1 task-3] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 15:11:31.546 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 15:11:31.556 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:31 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 LIMIT 8 15:11:33.729 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:33 | Time Consuming: 9 ms | Connection: statement-1 | SQL: SELECT 1 15:11:33.743 [XNIO-1 task-2] INFO p6spy - 2023-06-13 15:11:33 | Time Consuming: 7 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:19:00.293 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5014 ms | Connection: statement-45 | SQL: SELECT 1 16:19:00.293 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5014 ms | Connection: statement-43 | SQL: SELECT 1 16:19:00.293 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5014 ms | Connection: statement-46 | SQL: SELECT 1 16:19:00.293 [XNIO-1 task-2] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5014 ms | Connection: statement-44 | SQL: SELECT 1 16:19:00.299 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 4 ms | Connection: statement-48 | SQL: SELECT 1 16:19:00.299 [XNIO-1 task-2] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 4 ms | Connection: statement-50 | SQL: SELECT 1 16:19:00.299 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 4 ms | Connection: statement-49 | SQL: SELECT 1 16:19:00.300 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5 ms | Connection: statement-47 | SQL: SELECT 1 16:19:00.309 [XNIO-1 task-2] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5 ms | Connection: statement-50 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:19:00.310 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 4 ms | Connection: statement-47 | 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:19:00.346 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 5 ms | Connection: statement-48 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:19:00.351 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 9 ms | Connection: statement-49 | 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:19:00.354 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 7 ms | Connection: statement-48 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:19:00.358 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:00 | Time Consuming: 6 ms | Connection: statement-49 | 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:19:05.566 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 3 ms | Connection: statement-48 | SQL: SELECT 1 16:19:05.566 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 3 ms | Connection: statement-47 | SQL: SELECT 1 16:19:05.576 [XNIO-1 task-5] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 5 ms | Connection: statement-48 | 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:19:05.580 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 4 ms | Connection: statement-49 | SQL: SELECT 1 16:19:05.591 [XNIO-1 task-3] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 5 ms | Connection: statement-49 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.hdanger_id = 441050 16:19:05.603 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 5 ms | Connection: statement-47 | 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:19:05.610 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:05 | Time Consuming: 5 ms | Connection: statement-47 | 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:19:15.430 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:15 | Time Consuming: 4 ms | Connection: statement-47 | SQL: SELECT 1 16:19:17.406 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:17 | Time Consuming: 7 ms | Connection: statement-47 | SQL: replace into uid_sequence(stub) values('a') 16:19:17.410 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:17 | Time Consuming: 3 ms | Connection: statement-47 | SQL: SELECT LAST_INSERT_ID() AS uid 16:19:17.430 [XNIO-1 task-7] INFO p6spy - 2023-06-13 16:19:17 | Time Consuming: 15 ms | Connection: statement-47 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441444, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/2023613161916142122.jpg', 'http://113.141.93.143:9000/icon/20236131619173676955.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T16:19:17.410469200', 406283, '2023-06-13T16:19:17.410469200' ) 16:27:00.020 [quartzScheduler_Worker-1] INFO c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start 16:27:05.023 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:05 | Time Consuming: 5001 ms | Connection: statement-48 | SQL: SELECT 1 16:27:10.025 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:10 | Time Consuming: 5001 ms | Connection: statement-49 | SQL: SELECT 1 16:27:15.027 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 5002 ms | Connection: statement-54 | SQL: SELECT 1 16:27:15.033 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 5 ms | Connection: statement-55 | SQL: SELECT 1 16:27:15.055 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 11 ms | Connection: statement-55 | SQL: UPDATE goaf_task SET status = 2 WHERE job_id = 439094 16:27:15.062 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: SELECT * FROM goaf_check_def WHERE 1=1 AND job_id = 439094 AND status = 1 16:27:15.071 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.074 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.111 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.127 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 13 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441465, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.156 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 27 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.160 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.160 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.175 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 11 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441466, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.186 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 9 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.193 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.194 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.206 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 9 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441467, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.228 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 21 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.234 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 5 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.235 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.252 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 13 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441468, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.265 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 12 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.270 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.271 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.280 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441469, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.288 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.292 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.293 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.305 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 8 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441470, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.318 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 11 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.328 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 9 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.329 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.352 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 20 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441471, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.361 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 8 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.367 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.367 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.379 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 10 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441472, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.393 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 12 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.399 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.400 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.410 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 8 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441473, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.424 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 12 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.429 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.430 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.447 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 17 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441474, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.458 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 9 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.466 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.466 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.477 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 9 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441475, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.484 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.487 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 2 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.488 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.496 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441476, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.504 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.508 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.509 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.519 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 8 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441477, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.526 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.530 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 2 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.530 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.539 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441478, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.548 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.552 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.552 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.562 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441479, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.569 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.573 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 2 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.574 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.584 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441480, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.592 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.596 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.597 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.605 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441481, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.613 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.616 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 2 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.617 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.625 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441482, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.632 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.635 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.636 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.644 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 6 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441483, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.652 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 7 ms | Connection: statement-55 | SQL: replace into uid_sequence(stub) values('a') 16:27:15.655 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT LAST_INSERT_ID() AS uid 16:27:15.656 [quartzScheduler_Worker-1] INFO c.z.x.g.job.GoafCheckTaskJobService - GoafCheckDef(checkDefId=441001, ocId=406283, goafId=440952, checkTitle=测试, checkTypeId=0, groupId=406283, positionId=406283, accountId=406283, accountName=sxky, positionName=管理员, groupName=森鑫矿业, checklistId=439392, checklistTitle=null, defStartDate=2023-06-05, defEndDate=2023-06-22, checkCount=20, checkCycleUnit=1, jobId=439094, checkDesc=121, status=1) 16:27:15.665 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-13 16:27:15 | Time Consuming: 8 ms | Connection: statement-55 | SQL: insert into goaf_task ( task_id, oc_id, goaf_id, job_id, check_def_id, checklist_id, task_title, task_desc, expected_start_date, expected_end_date, handle_account_id, handle_account_name, handle_position_id, handle_position_name, handle_group_id, handle_group_name ) values ( 441484, 406283, 440952, 439094, 441001, 439392, '测试', '121', '2023-06-13', '2023-06-14', 406283, 'sxky', 406283, '管理员', 406283, '森鑫矿业' ) 16:27:15.678 [quartzScheduler_Worker-1] INFO c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End 17:15:28.555 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 17:15:28.568 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 17:15:28.568 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 17:15:28.571 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 17:15:28.572 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 17:15:28.572 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 17:15:28.572 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 17:15:28.635 [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) 17:15:28.638 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 17:15:28.638 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 17:15:28.638 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 17:15:28.638 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 17:15:28.652 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 17:15:28.655 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 17:15:35.830 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 17:15:35.899 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 16028 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 17:15:35.900 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 17:15:35.979 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 17:15:35.979 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 17:15:38.117 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 17:15:38.121 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 17:15:38.217 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 76 ms. Found 0 Redis repository interfaces. 17:15:38.402 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 17:15:38.422 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 17:15:39.348 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 17:15:39.348 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3368 ms 17:15:42.108 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 17:15:42.121 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 17:15:42.121 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 17:15:42.122 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 17:15:42.122 [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. 17:15:42.123 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 17:15:42.123 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 17:15:42.123 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@4905c7c8 17:15:44.606 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 17:15:44.765 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 17:15:44.805 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 17:15:44.805 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 17:15:44.805 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 17:15:44.831 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 17:15:44.843 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 17:15:44.855 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 17:15:44.893 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 17:15:44.952 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 17:15:45.117 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 17:15:45.117 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 159 ms 17:15:45.127 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 17:15:45.169 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 17:15:45.188 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 17:15:45.191 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 17:15:45.191 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.217 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 10.019 seconds (process running for 11.124) 17:15:45.220 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 17:15:45.230 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 17:15:45.608 [restartedMain] INFO p6spy - 2023-06-13 17:15:45 | Time Consuming: 17 ms | Connection: statement-0 | SQL: SELECT 1 17:15:45.613 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@2c4d6cca 17:15:45.618 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 17:15:45.697 [restartedMain] INFO p6spy - 2023-06-13 17:15:45 | 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 17:15:45.727 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.729 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.730 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.730 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.730 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.731 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.731 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:45.731 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:15:46.185 [RMI TCP Connection(10)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 17:15:46.186 [RMI TCP Connection(10)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 17:15:46.190 [RMI TCP Connection(10)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms 17:15:46.200 [RMI TCP Connection(11)-192.168.3.5] INFO p6spy - 2023-06-13 17:15:46 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 17:20:59.037 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:20:59 | Time Consuming: 5010 ms | Connection: statement-0 | SQL: SELECT 1 17:21:04.040 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:04 | Time Consuming: 5001 ms | Connection: statement-1 | SQL: SELECT 1 17:21:09.041 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:09 | Time Consuming: 5001 ms | Connection: statement-2 | SQL: SELECT 1 17:21:14.043 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:14 | Time Consuming: 5001 ms | Connection: statement-3 | SQL: SELECT 1 17:21:18.398 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 17 ms | Connection: statement-5 | SQL: SELECT 1 17:21:18.412 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:21:18.436 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:21:18.808 [XNIO-1 task-4] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 3 ms | Connection: statement-8 | SQL: SELECT 1 17:21:18.808 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 4 ms | Connection: statement-6 | SQL: SELECT 1 17:21:18.808 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 4 ms | Connection: statement-7 | SQL: SELECT 1 17:21:18.812 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 17:21:18.815 [XNIO-1 task-6] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 5 ms | Connection: statement-5 | 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 17:21:18.819 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 5 ms | Connection: statement-7 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:21:18.851 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 34 ms | Connection: statement-9 | 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 ) ) 17:21:18.934 [XNIO-1 task-4] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 17:21:18.939 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 6 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 17:21:18.945 [XNIO-1 task-4] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 6 ms | Connection: statement-8 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 17:21:18.945 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:18 | Time Consuming: 5 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 17:21:19.046 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:19 | Time Consuming: 5001 ms | Connection: statement-4 | SQL: SELECT 1 17:21:19.057 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:19 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:21:19.077 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:19 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:21:30.906 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:30 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 17:21:30.915 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:30 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:21:30.934 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:30 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:21:31.106 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 3 ms | Connection: statement-6 | SQL: SELECT 1 17:21:31.106 [XNIO-1 task-4] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 3 ms | Connection: statement-8 | SQL: SELECT 1 17:21:31.106 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 17:21:31.108 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT 1 17:21:31.115 [XNIO-1 task-4] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 4 ms | Connection: statement-8 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:21:31.117 [XNIO-1 task-3] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 4 ms | Connection: statement-6 | 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 17:21:31.141 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 29 ms | Connection: statement-7 | 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 ) ) 17:21:31.159 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 17:21:31.159 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 5 ms | Connection: statement-9 | 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 17:21:31.166 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 5 ms | Connection: statement-9 | 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 17:21:31.167 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:31 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 17:21:37.861 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1 17:21:37.861 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 3 ms | Connection: statement-7 | SQL: SELECT 1 17:21:37.872 [XNIO-1 task-5] INFO p6spy - 2023-06-13 17:21:37 | 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 17:21:37.878 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT 1 17:21:37.888 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 5 ms | Connection: statement-9 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.hdanger_id = 441050 17:21:37.901 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 5 ms | Connection: statement-5 | 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 17:21:37.909 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:37 | Time Consuming: 6 ms | Connection: statement-5 | 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 17:21:53.425 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:53 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 17:21:54.813 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:54 | Time Consuming: 8 ms | Connection: statement-5 | SQL: replace into uid_sequence(stub) values('a') 17:21:54.820 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:54 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT LAST_INSERT_ID() AS uid 17:21:54.842 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:21:54 | Time Consuming: 16 ms | Connection: statement-5 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441485, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/20236131721539764265.jpg', 'http://113.141.93.143:9000/icon/20236131721547665035.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T17:21:54.821795800', 406283, '2023-06-13T17:21:54.821795800' ) 17:23:52.705 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:23:52 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 17:23:53.906 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:23:53 | Time Consuming: 8 ms | Connection: statement-9 | SQL: replace into uid_sequence(stub) values('a') 17:23:53.911 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:23:53 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT LAST_INSERT_ID() AS uid 17:23:53.922 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:23:53 | Time Consuming: 9 ms | Connection: statement-9 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441486, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/20236131723531378764.jpg', 'http://113.141.93.143:9000/icon/20236131723538695245.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T17:23:53.911112500', 406283, '2023-06-13T17:23:53.911112500' ) 17:24:52.003 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:24:52 | Time Consuming: 7 ms | Connection: statement-5 | SQL: SELECT 1 17:24:53.091 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:24:53 | Time Consuming: 10 ms | Connection: statement-5 | SQL: replace into uid_sequence(stub) values('a') 17:24:53.096 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:24:53 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT LAST_INSERT_ID() AS uid 17:24:53.105 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:24:53 | Time Consuming: 8 ms | Connection: statement-5 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441487, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/20236131724523893079.jpg', 'http://113.141.93.143:9000/icon/2023613172453491984.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T17:24:53.096739500', 406283, '2023-06-13T17:24:53.096739500' ) 17:31:11.643 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:31:11 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1 17:31:12.442 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:31:12 | Time Consuming: 6 ms | Connection: statement-11 | SQL: replace into uid_sequence(stub) values('a') 17:31:12.445 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:31:12 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT LAST_INSERT_ID() AS uid 17:31:12.461 [XNIO-1 task-7] INFO p6spy - 2023-06-13 17:31:12 | Time Consuming: 12 ms | Connection: statement-11 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441488, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/2023613173112343929.jpg', 'http://113.141.93.143:9000/icon/20236131731124064865.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T17:31:12.445679700', 406283, '2023-06-13T17:31:12.445679700' ) 17:39:41.289 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:39:41 | Time Consuming: 5 ms | Connection: statement-16 | SQL: SELECT 1 17:39:42.112 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:39:42 | Time Consuming: 7 ms | Connection: statement-16 | SQL: replace into uid_sequence(stub) values('a') 17:39:42.117 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:39:42 | Time Consuming: 4 ms | Connection: statement-16 | SQL: SELECT LAST_INSERT_ID() AS uid 17:39:42.126 [XNIO-1 task-2] INFO p6spy - 2023-06-13 17:39:42 | Time Consuming: 7 ms | Connection: statement-16 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 441489, '智慧创新营业执照.jpg', 10000, 'http://113.141.93.143:9000/file/20236131739416749959.jpg', 'http://113.141.93.143:9000/icon/2023613173942724998.jpg', 'jpg', 1119549, '智慧创新营业执照.jpg', 406283, '2023-06-13T17:39:42.117547500', 406283, '2023-06-13T17:39:42.117547500' ) 17:56:11.966 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 17:56:11.989 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 17:56:11.989 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 17:56:11.993 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 17:56:11.994 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 17:56:11.994 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 17:56:11.994 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 17:56:12.001 [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) 17:56:12.002 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 17:56:12.002 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 17:56:12.002 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 17:56:12.003 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 17:56:12.015 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 17:56:12.017 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 17:56:18.668 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 17:56:18.731 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 4232 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 17:56:18.732 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 17:56:18.802 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 17:56:18.802 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 17:56:20.918 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 17:56:20.922 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 17:56:21.021 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 82 ms. Found 0 Redis repository interfaces. 17:56:21.209 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 17:56:21.230 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 17:56:22.156 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 17:56:22.157 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3353 ms 17:56:24.949 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 17:56:24.961 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 17:56:24.962 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 17:56:24.963 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 17:56:24.963 [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. 17:56:24.963 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 17:56:24.964 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 17:56:24.964 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@76cb10c2 17:56:27.187 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 17:56:27.350 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 17:56:27.387 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 17:56:27.388 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 17:56:27.388 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 17:56:27.413 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 17:56:27.425 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 17:56:27.438 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 17:56:27.474 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 17:56:27.535 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 17:56:27.702 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 17:56:27.702 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 160 ms 17:56:27.713 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 17:56:27.754 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 17:56:27.773 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 17:56:27.777 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 17:56:27.777 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:27.804 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 9.716 seconds (process running for 10.704) 17:56:27.807 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 17:56:27.817 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 17:56:28.202 [restartedMain] INFO p6spy - 2023-06-13 17:56:28 | Time Consuming: 16 ms | Connection: statement-0 | SQL: SELECT 1 17:56:28.208 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@3d685b61 17:56:28.227 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 17:56:28.307 [restartedMain] INFO p6spy - 2023-06-13 17:56:28 | 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 17:56:28.338 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.340 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.341 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.341 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.341 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.342 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.342 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.342 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 17:56:28.960 [RMI TCP Connection(3)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 17:56:28.960 [RMI TCP Connection(3)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 17:56:28.964 [RMI TCP Connection(3)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms 17:56:28.967 [RMI TCP Connection(4)-192.168.3.5] INFO p6spy - 2023-06-13 17:56:28 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 17:56:28.980 [RMI TCP Connection(4)-192.168.3.5] INFO p6spy - 2023-06-13 17:56:28 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 18:19:29.700 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 18:19:29.711 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 18:19:29.711 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 18:19:29.715 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 18:19:29.719 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 18:19:29.719 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 18:19:29.719 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 18:19:29.727 [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) 18:19:29.728 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 18:19:29.728 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 18:19:29.728 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 18:19:29.728 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 18:19:29.740 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 18:19:29.743 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 18:19:40.068 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 18:19:40.155 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 7624 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 18:19:40.155 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 18:19:40.249 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 18:19:40.249 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 18:19:42.441 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 18:19:42.445 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 18:19:42.546 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 80 ms. Found 0 Redis repository interfaces. 18:19:42.742 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 18:19:42.763 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 18:19:43.762 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:19:43.762 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3512 ms 18:19:46.850 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 18:19:46.863 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 18:19:46.863 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 18:19:46.864 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 18:19:46.864 [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. 18:19:46.864 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 18:19:46.864 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 18:19:46.864 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@770d5aac 18:19:49.321 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 18:19:49.490 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 18:19:49.529 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 18:19:49.529 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 18:19:49.530 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 18:19:49.558 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:19:49.571 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 18:19:49.584 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 18:19:49.623 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 18:19:49.684 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 18:19:49.864 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 18:19:49.864 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 174 ms 18:19:49.875 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 18:19:49.915 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 18:19:49.934 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 18:19:49.938 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 18:19:49.938 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:49.965 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 10.544 seconds (process running for 11.724) 18:19:49.969 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 18:19:49.979 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 18:19:50.407 [restartedMain] INFO p6spy - 2023-06-13 18:19:50 | Time Consuming: 16 ms | Connection: statement-0 | SQL: SELECT 1 18:19:50.413 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@6f341b2b 18:19:50.418 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 18:19:50.496 [restartedMain] INFO p6spy - 2023-06-13 18:19:50 | 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 18:19:50.526 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.528 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.529 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.530 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.530 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.531 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.531 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:50.531 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 18:19:51.175 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 18:19:51.175 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 18:19:51.179 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-13 18:19:51 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 18:19:51.180 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 5 ms 18:19:51.205 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-13 18:19:51 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT 1 18:20:02.997 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:20:02 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 18:20:03.965 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:20:03 | Time Consuming: 7 ms | Connection: statement-0 | SQL: replace into uid_sequence(stub) values('a') 18:20:03.970 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:20:03 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT LAST_INSERT_ID() AS uid 18:25:31.929 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:31 | Time Consuming: 5011 ms | Connection: statement-0 | SQL: SELECT 1 18:25:36.933 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:36 | Time Consuming: 5001 ms | Connection: statement-1 | SQL: SELECT 1 18:25:41.935 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:41 | Time Consuming: 5001 ms | Connection: statement-2 | SQL: SELECT 1 18:25:46.936 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:46 | Time Consuming: 5001 ms | Connection: statement-3 | SQL: SELECT 1 18:25:51.939 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:51 | Time Consuming: 5002 ms | Connection: statement-4 | SQL: SELECT 1 18:25:51.946 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:25:51 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1 18:26:01.245 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:26:01 | Time Consuming: 8 ms | Connection: statement-5 | SQL: replace into uid_sequence(stub) values('a') 18:26:01.249 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:26:01 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT LAST_INSERT_ID() AS uid 18:27:59.856 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:27:59 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1 18:30:02.075 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:30:02 | Time Consuming: 10 ms | Connection: statement-5 | SQL: replace into uid_sequence(stub) values('a') 18:30:02.083 [XNIO-1 task-2] INFO p6spy - 2023-06-13 18:30:02 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT LAST_INSERT_ID() AS uid 18:48:38.582 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:38 | Time Consuming: 5002 ms | Connection: statement-17 | SQL: SELECT 1 18:48:43.585 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:43 | Time Consuming: 5001 ms | Connection: statement-18 | SQL: SELECT 1 18:48:48.588 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:48 | Time Consuming: 5002 ms | Connection: statement-19 | SQL: SELECT 1 18:48:53.591 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:53 | Time Consuming: 5001 ms | Connection: statement-20 | SQL: SELECT 1 18:48:58.593 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:58 | Time Consuming: 5001 ms | Connection: statement-21 | SQL: SELECT 1 18:48:58.603 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:48:58 | Time Consuming: 9 ms | Connection: statement-22 | SQL: SELECT 1 18:49:05.738 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:49:05 | Time Consuming: 8 ms | Connection: statement-22 | SQL: replace into uid_sequence(stub) values('a') 18:49:05.742 [XNIO-1 task-3] INFO p6spy - 2023-06-13 18:49:05 | Time Consuming: 3 ms | Connection: statement-22 | SQL: SELECT LAST_INSERT_ID() AS uid 20:24:10.754 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:10 | Time Consuming: 5001 ms | Connection: statement-78 | SQL: SELECT 1 20:24:15.756 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:15 | Time Consuming: 5002 ms | Connection: statement-79 | SQL: SELECT 1 20:24:20.761 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:20 | Time Consuming: 5002 ms | Connection: statement-80 | SQL: SELECT 1 20:24:25.764 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:25 | Time Consuming: 5001 ms | Connection: statement-81 | SQL: SELECT 1 20:24:30.766 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:30 | Time Consuming: 5001 ms | Connection: statement-82 | SQL: SELECT 1 20:24:30.771 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:24:30 | Time Consuming: 4 ms | Connection: statement-83 | SQL: SELECT 1 20:26:49.688 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:26:49 | Time Consuming: 7 ms | Connection: statement-83 | SQL: replace into uid_sequence(stub) values('a') 20:26:49.693 [XNIO-1 task-2] INFO p6spy - 2023-06-13 20:26:49 | Time Consuming: 3 ms | Connection: statement-83 | SQL: SELECT LAST_INSERT_ID() AS uid 20:31:58.542 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:31:58 | Time Consuming: 5002 ms | Connection: statement-83 | SQL: SELECT 1 20:32:03.544 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:03 | Time Consuming: 5000 ms | Connection: statement-84 | SQL: SELECT 1 20:32:08.546 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:08 | Time Consuming: 5001 ms | Connection: statement-85 | SQL: SELECT 1 20:32:13.547 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:13 | Time Consuming: 5000 ms | Connection: statement-86 | SQL: SELECT 1 20:32:18.548 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:18 | Time Consuming: 5001 ms | Connection: statement-89 | SQL: SELECT 1 20:32:18.554 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:18 | Time Consuming: 4 ms | Connection: statement-90 | SQL: SELECT 1 20:32:25.160 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:25 | Time Consuming: 6 ms | Connection: statement-90 | SQL: replace into uid_sequence(stub) values('a') 20:32:25.164 [XNIO-1 task-3] INFO p6spy - 2023-06-13 20:32:25 | Time Consuming: 3 ms | Connection: statement-90 | SQL: SELECT LAST_INSERT_ID() AS uid