iotplatform/xps-server-3/logs/info/info.2023-06-13.log

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