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

18:14:31.119 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
18:14:31.179 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 16452 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
18:14:31.179 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
18:14:31.239 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
18:14:31.240 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
18:14:33.314 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
18:14:33.318 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:14:33.407 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 73 ms. Found 0 Redis repository interfaces.
18:14:33.587 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
18:14:33.607 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
18:14:34.480 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:14:34.480 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3240 ms
18:14:37.124 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
18:14:37.136 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
18:14:37.136 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
18:14:37.137 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
18:14:37.138 [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:14:37.138 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
18:14:37.138 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
18:14:37.138 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@4f0cad8a
18:14:39.281 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
18:14:39.313 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:14:39.314 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
18:14:39.314 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
18:14:39.339 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:14:39.349 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
18:14:39.361 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
18:14:39.393 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
18:14:39.448 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
18:14:39.598 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:14:39.598 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 144 ms
18:14:39.607 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
18:14:39.642 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:14:39.680 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:14:39.685 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:14:39.685 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
18:14:39.686 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
18:14:39.691 [restartedMain] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
18:14:39.692 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
18:14:39.692 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
18:14:39.692 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
18:14:39.692 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
18:14:39.716 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:14:39.726 [restartedMain] INFO  o.s.b.a.l.ConditionEvaluationReportLogger - 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
18:15:11.038 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
18:15:11.099 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 17228 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
18:15:11.100 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
18:15:11.163 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
18:15:11.164 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
18:15:13.149 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
18:15:13.153 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:15:13.247 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 78 ms. Found 0 Redis repository interfaces.
18:15:13.422 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
18:15:13.441 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
18:15:14.309 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:15:14.310 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3146 ms
18:15:16.834 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
18:15:16.847 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
18:15:16.847 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
18:15:16.848 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
18:15:16.848 [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:15:16.849 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
18:15:16.849 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
18:15:16.849 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@39c549ec
18:15:18.972 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
18:15:19.004 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:15:19.004 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
18:15:19.004 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
18:15:19.027 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:15:19.037 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
18:15:19.050 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
18:15:19.086 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
18:15:19.141 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
18:15:19.296 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:15:19.296 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 149 ms
18:15:19.305 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
18:15:19.341 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:15:19.367 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:15:19.373 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:15:19.373 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
18:15:19.373 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
18:15:19.379 [restartedMain] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
18:15:19.380 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
18:15:19.380 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
18:15:19.380 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
18:15:19.380 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
18:15:19.405 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:15:19.416 [restartedMain] INFO  o.s.b.a.l.ConditionEvaluationReportLogger - 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
18:22:29.687 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
18:22:29.746 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 16500 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
18:22:29.746 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
18:22:29.808 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
18:22:29.808 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
18:22:31.760 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
18:22:31.764 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:22:31.863 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 82 ms. Found 0 Redis repository interfaces.
18:22:32.042 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
18:22:32.061 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
18:22:32.913 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:22:32.914 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3105 ms
18:22:35.402 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
18:22:35.414 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
18:22:35.414 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
18:22:35.414 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
18:22:35.415 [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:22:35.415 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
18:22:35.415 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
18:22:35.415 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@39c549ec
18:22:37.466 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
18:22:37.497 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:22:37.497 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
18:22:37.498 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
18:22:37.520 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:22:37.531 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
18:22:37.543 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
18:22:37.579 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
18:22:37.636 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
18:22:37.791 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:22:37.791 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 149 ms
18:22:37.800 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
18:22:37.833 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:22:37.858 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:22:37.863 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:22:37.863 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
18:22:37.863 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
18:22:37.868 [restartedMain] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
18:22:37.869 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
18:22:37.869 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
18:22:37.869 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
18:22:37.869 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
18:22:37.893 [restartedMain] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
18:22:37.903 [restartedMain] INFO  o.s.b.a.l.ConditionEvaluationReportLogger - 

Error starting ApplicationContext. To display the condition evaluation report re-run your application with 'debug' enabled.
18:23:43.063 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
18:23:43.121 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 12764 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
18:23:43.121 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
18:23:43.185 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
18:23:43.185 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
18:23:45.149 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
18:23:45.153 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
18:23:45.249 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 80 ms. Found 0 Redis repository interfaces.
18:23:45.427 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
18:23:45.446 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
18:23:46.307 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:23:46.307 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3121 ms
18:23:48.851 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
18:23:48.862 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
18:23:48.863 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
18:23:48.863 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
18:23:48.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:23:48.864 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
18:23:48.864 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
18:23:48.864 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@39c549ec
18:23:50.971 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
18:23:51.003 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
18:23:51.004 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
18:23:51.004 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
18:23:51.026 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:23:51.037 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
18:23:51.050 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
18:23:51.085 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
18:23:51.141 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
18:23:51.301 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
18:23:51.302 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 155 ms
18:23:51.311 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
18:23:51.348 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
18:23:51.365 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http)
18:23:51.369 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
18:23:51.369 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.393 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.861 seconds (process running for 9.698)
18:23:51.395 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
18:23:51.404 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
18:23:51.773 [restartedMain] INFO  p6spy - 2023-06-21 18:23:51 | Time Consuming: 14 ms | Connection: statement-0 | SQL: SELECT 1
18:23:51.777 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@4710bfc3
18:23:51.781 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
18:23:51.852 [restartedMain] INFO  p6spy - 2023-06-21 18:23:51 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT
             
        A.job_id,
        A.job_title,
        A.job_desc,
        A.status,
        A.job_type,
        A.job_code,
        A.job_cron,
        A.job_class_id,
        B.job_class,
        A.cycle_title,
        A.cycle_period,
        A.cycle_unit
     
        FROM      job       AS A
        LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
        WHERE A.deleted_flag = 0
         
         
           AND A.status = 1
         
         
        ORDER BY A.job_id ASC
18:23:51.879 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.881 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.882 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.882 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.882 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.883 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.883 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:51.883 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
18:23:52.134 [RMI TCP Connection(6)-192.168.3.5] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
18:23:52.134 [RMI TCP Connection(6)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
18:23:52.136 [RMI TCP Connection(6)-192.168.3.5] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 2 ms
18:23:52.143 [RMI TCP Connection(7)-192.168.3.5] INFO  p6spy - 2023-06-21 18:23:52 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1
18:24:03.209 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
18:24:03.219 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | 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'
18:24:03.236 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        B.oc_type_id,
        B.oc_name,
        A.account_id,
        A.account_name,
        A.account_real_name,
        A.password,
        A.account_type,
        A.account_staff_no,
        A.account_phone,
        A.account_last_ip,
        A.account_loc,
        A.status,
        A.account_avatar,
        A.account_photo,
        A.account_real_name,
        A.account_intro,
        A.wx_id,
        A.is_fixed
     
        FROM        account AS A
        LEFT JOIN   oc      AS B ON (A.oc_id = B.oc_id )
        WHERE A.deleted_flag = 0
        AND (A.account_name = 'sxky'
        OR   A.account_phone = 'sxky'
        OR   A.account_mail  = 'sxky'
        OR   A.account_staff_no = 'sxky')
18:24:03.244 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 5 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
18:24:03.249 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.rm_id,
        A.role_id,
        B.role_type_id,
        B.role_code,
        B.role_name,
        A.account_id
     
        FROM      s_role_member AS A
        LEFT JOIN s_role        AS B ON (A.role_id = B.role_id)
        WHERE account_id = 406283
        LIMIT 1
18:24:03.255 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.gm_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        B.node_left ,
        B.node_right,
        A.account_id
     
        FROM      s_group_member    AS A
        LEFT JOIN s_group           AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
18:24:03.262 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 4 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
18:24:03.269 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.gmpg_id,
        A.oc_id,
        A.group_id,
        A.account_id,
        A.position_id,
        A.grant_group_id,
        B.group_name AS grant_group_name
     
        FROM      s_group_member_position_grant A
        LEFT JOIN s_group                       B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
         
            AND A.position_id = 406283
         
        LIMIT 1
18:24:03.739 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 18:24:03 | 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'
18:24:03.758 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
18:24:03.990 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1
18:24:03.992 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT 1
18:24:03.993 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 18:24:03 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT 1
18:24:04.001 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 18:24:04 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
18:24:04.005 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 18:24:04 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT      checklist_id,
                    oc_id,
                    checklist_title,
                    checklist_desc
        FROM        goaf_checklist
        WHERE       oc_id = 406283
18:24:04.032 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 18:24:04 | Time Consuming: 34 ms | Connection: statement-2 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
18:24:04.053 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:04 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283
18:24:04.059 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 18:24:04 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
 LIMIT 10 
19:37:32.003 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 17 ms | Connection: statement-45 | 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-21 00:00:00'
                AND  A.expected_end_date <= '2023-06-22 00:00:00'
19:37:32.057 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 6 ms | Connection: statement-45 | 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
19:37:32.107 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 6 ms | Connection: statement-45 | SQL: SELECT
                COUNT(*)
        FROM        goaf_camera_alarm

         where oc_id = 406283
            
            
                AND goaf_alarm_status = '0'
19:37:32.143 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 7 ms | Connection: statement-45 | SQL: SELECT  A.*,
                B.goaf_dev_ip,
                B.goaf_dev_port,
                B.goaf_dev_account,
                B.goaf_dev_pwd,
                B.goaf_dev_socket_addr,
                B.goaf_orebelt,
                B.goaf_orebody,
                B.goaf_oreheight,
                B.goaf_name
        FROM         goaf_camera_alarm  AS A
        LEFT JOIN    goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id
         where A.oc_id = 406283
            
            
                AND A.goaf_alarm_status = '0' 
        ORDER BY A.goaf_alarm_begintime DESC
19:37:32.185 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 5 ms | Connection: statement-45 | 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
19:37:32.218 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:32 | Time Consuming: 6 ms | Connection: statement-45 | 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
19:37:36.919 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5021 ms | Connection: statement-40 | SQL: SELECT 1
19:37:36.918 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5021 ms | Connection: statement-43 | SQL: SELECT 1
19:37:36.919 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5021 ms | Connection: statement-42 | SQL: SELECT 1
19:37:36.919 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5021 ms | Connection: statement-44 | SQL: SELECT 1
19:37:36.919 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5021 ms | Connection: statement-41 | SQL: SELECT 1
19:37:36.925 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5 ms | Connection: statement-46 | SQL: SELECT 1
19:37:36.925 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5 ms | Connection: statement-45 | SQL: SELECT 1
19:37:36.925 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 4 ms | Connection: statement-49 | SQL: SELECT 1
19:37:36.926 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5 ms | Connection: statement-47 | SQL: SELECT 1
19:37:36.926 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 5 ms | Connection: statement-48 | SQL: SELECT 1
19:37:36.937 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 6 ms | Connection: statement-46 | 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
19:37:36.960 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 11 ms | Connection: statement-47 | 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
19:37:36.964 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 14 ms | Connection: statement-45 | 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
19:37:36.965 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 15 ms | Connection: statement-48 | 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
19:37:36.965 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:36 | Time Consuming: 15 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.oc_id = 406283

        
        
        
         
         
         

         
            AND  A.hdanger_type = '0'
         


         
         

         
         

         
         

         


         

         
         
         
        ORDER BY  A.submit_time DESC
19:37:37.054 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:37 | Time Consuming: 6 ms | Connection: statement-49 | 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'
19:37:38.698 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 4 ms | Connection: statement-49 | SQL: SELECT 1
19:37:38.698 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 4 ms | Connection: statement-48 | SQL: SELECT 1
19:37:38.698 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 4 ms | Connection: statement-45 | SQL: SELECT 1
19:37:38.698 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-47 | SQL: SELECT 1
19:37:38.698 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-46 | SQL: SELECT 1
19:37:38.698 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-50 | SQL: SELECT 1
19:37:38.712 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-47 | 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
19:37:38.712 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-49 | 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
19:37:38.714 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 6 ms | Connection: statement-48 | 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
19:37:38.715 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 7 ms | Connection: statement-46 | 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
19:37:38.717 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 8 ms | Connection: statement-45 | 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
19:37:38.719 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 10 ms | Connection: statement-50 | 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-21 00:00:00'
                AND  A.expected_end_date <= '2023-06-22 00:00:00'
19:37:38.744 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 8 ms | Connection: statement-49 | SQL: SELECT
                COUNT(*)
        FROM        goaf_camera_alarm

         where oc_id = 406283
            
            
                AND goaf_alarm_status = '0'
19:37:38.744 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 8 ms | Connection: statement-47 | 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
19:37:38.789 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-47 | SQL: SELECT  A.*,
                B.goaf_dev_ip,
                B.goaf_dev_port,
                B.goaf_dev_account,
                B.goaf_dev_pwd,
                B.goaf_dev_socket_addr,
                B.goaf_orebelt,
                B.goaf_orebody,
                B.goaf_oreheight,
                B.goaf_name
        FROM         goaf_camera_alarm  AS A
        LEFT JOIN    goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id
         where A.oc_id = 406283
            
            
                AND A.goaf_alarm_status = '0' 
        ORDER BY A.goaf_alarm_begintime DESC
19:37:38.789 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-49 | 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'
19:37:38.790 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-50 | 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
19:37:38.818 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:38 | Time Consuming: 5 ms | Connection: statement-45 | 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
19:37:46.605 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 4 ms | Connection: statement-48 | SQL: SELECT 1
19:37:46.605 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 3 ms | Connection: statement-49 | SQL: SELECT 1
19:37:46.605 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 4 ms | Connection: statement-46 | SQL: SELECT 1
19:37:46.605 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 4 ms | Connection: statement-50 | SQL: SELECT 1
19:37:46.605 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 4 ms | Connection: statement-45 | SQL: SELECT 1
19:37:46.605 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 4 ms | Connection: statement-47 | SQL: SELECT 1
19:37:46.618 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 7 ms | Connection: statement-48 | 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
19:37:46.620 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 6 ms | Connection: statement-50 | 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
19:37:46.620 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 8 ms | Connection: statement-49 | 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-21 00:00:00'
                AND  A.expected_end_date <= '2023-06-22 00:00:00'
19:37:46.621 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 8 ms | Connection: statement-45 | 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
19:37:46.623 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 9 ms | Connection: statement-46 | 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
19:37:46.624 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 12 ms | Connection: statement-47 | 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
19:37:46.650 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 5 ms | Connection: statement-45 | SQL: SELECT
                COUNT(*)
        FROM        goaf_camera_alarm

         where oc_id = 406283
            
            
                AND goaf_alarm_status = '0'
19:37:46.652 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 8 ms | Connection: statement-48 | SQL: SELECT  A.*,
                B.goaf_dev_ip,
                B.goaf_dev_port,
                B.goaf_dev_account,
                B.goaf_dev_pwd,
                B.goaf_dev_socket_addr,
                B.goaf_orebelt,
                B.goaf_orebody,
                B.goaf_oreheight,
                B.goaf_name
        FROM         goaf_camera_alarm  AS A
        LEFT JOIN    goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id
         where A.oc_id = 406283
            
            
                AND A.goaf_alarm_status = '0' 
        ORDER BY A.goaf_alarm_begintime DESC
19:37:46.652 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 7 ms | Connection: statement-50 | 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
19:37:46.672 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 5 ms | Connection: statement-49 | 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'
19:37:46.725 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 6 ms | Connection: statement-48 | 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
19:37:46.726 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:46 | Time Consuming: 6 ms | Connection: statement-49 | 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
19:37:56.574 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-50 | SQL: SELECT 1
19:37:56.574 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-47 | SQL: SELECT 1
19:37:56.575 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 4 ms | Connection: statement-49 | SQL: SELECT 1
19:37:56.575 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 4 ms | Connection: statement-45 | SQL: SELECT 1
19:37:56.575 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 3 ms | Connection: statement-46 | SQL: SELECT 1
19:37:56.576 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-48 | SQL: SELECT 1
19:37:56.584 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-47 | 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
19:37:56.586 [XNIO-1 task-5] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-46 | 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-21 00:00:00'
                AND  A.expected_end_date <= '2023-06-22 00:00:00'
19:37:56.588 [XNIO-1 task-3] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 6 ms | Connection: statement-45 | 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
19:37:56.588 [XNIO-1 task-6] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 7 ms | Connection: statement-50 | 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
19:37:56.588 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 6 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.oc_id = 406283

        
        
        
         
         
         

         
            AND  A.hdanger_type = '0'
         


         
         

         
         

         
         

         


         

         
         
         
        ORDER BY  A.submit_time DESC
19:37:56.589 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-48 | 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
19:37:56.614 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-47 | 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
19:37:56.615 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 4 ms | Connection: statement-48 | SQL: SELECT
                COUNT(*)
        FROM        goaf_camera_alarm

         where oc_id = 406283
            
            
                AND goaf_alarm_status = '0'
19:37:56.622 [XNIO-1 task-7] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-49 | SQL: SELECT  A.*,
                B.goaf_dev_ip,
                B.goaf_dev_port,
                B.goaf_dev_account,
                B.goaf_dev_pwd,
                B.goaf_dev_socket_addr,
                B.goaf_orebelt,
                B.goaf_orebody,
                B.goaf_oreheight,
                B.goaf_name
        FROM         goaf_camera_alarm  AS A
        LEFT JOIN    goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id
         where A.oc_id = 406283
            
            
                AND A.goaf_alarm_status = '0' 
        ORDER BY A.goaf_alarm_begintime DESC
19:37:56.643 [XNIO-1 task-2] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-47 | 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'
19:37:56.650 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 5 ms | Connection: statement-48 | 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
19:37:56.698 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:37:56 | Time Consuming: 6 ms | Connection: statement-48 | 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
19:38:30.235 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:38:30 | Time Consuming: 11 ms | Connection: statement-48 | SQL: SELECT 1
19:38:30.247 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:38:30 | Time Consuming: 4 ms | Connection: statement-48 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
19:38:30.285 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:38:30 | Time Consuming: 12 ms | Connection: statement-48 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
19:38:30.483 [XNIO-1 task-4] INFO  p6spy - 2023-06-21 19:38:30 | Time Consuming: 34 ms | Connection: statement-48 | 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
                )
            )
20:07:30.739 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
20:07:30.765 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:07:30.765 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
20:07:30.771 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
20:07:30.773 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
20:07:30.773 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
20:07:30.774 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
20:07:30.784 [SpringApplicationShutdownHook] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
20:07:30.786 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
20:07:30.786 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
20:07:30.786 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
20:07:30.786 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
20:07:30.832 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
20:07:30.836 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.