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

15:19:31.816 [background-preinit] INFO  o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
15:19:31.872 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 13400 (E:\zhycnewprj\iotplatform\xps-server-3\xps-application\target\classes started by qzz19 in E:\zhycnewprj\iotplatform\xps-server-3)
15:19:31.872 [restartedMain] INFO  com.zhyc.xps.XPSApplication - The following 1 profile is active: "local"
15:19:31.929 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
15:19:31.930 [restartedMain] INFO  o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
15:19:33.971 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
15:19:33.975 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
15:19:34.064 [restartedMain] INFO  o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 75 ms. Found 0 Redis repository interfaces.
15:19:34.242 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
15:19:34.261 [restartedMain] INFO  o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
15:19:35.074 [restartedMain] INFO  io.undertow.servlet - Initializing Spring embedded WebApplicationContext
15:19:35.074 [restartedMain] INFO  o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3144 ms
15:19:37.584 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
15:19:37.597 [restartedMain] INFO  o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
15:19:37.597 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
15:19:37.597 [restartedMain] INFO  org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
15:19:37.598 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  NOT STARTED.
  Currently in standby mode.
  Number of jobs executed: 0
  Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.

15:19:37.598 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
15:19:37.598 [restartedMain] INFO  org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
15:19:37.598 [restartedMain] INFO  org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@5d75b344
15:19:39.331 [restartedMain] INFO  o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
15:19:39.338 [restartedMain] INFO  o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
15:19:39.486 [restartedMain] INFO  io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
15:19:39.518 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
15:19:39.518 [restartedMain] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
15:19:39.519 [restartedMain] INFO  o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
15:19:39.546 [restartedMain] INFO  io.undertow - starting server: Undertow - 2.3.4.Final
15:19:39.558 [restartedMain] INFO  org.xnio - XNIO version 3.8.8.Final
15:19:39.569 [restartedMain] INFO  org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
15:19:39.603 [restartedMain] INFO  org.jboss.threads - JBoss Threads version 3.5.0.Final
15:19:39.657 [restartedMain] INFO  o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1788 (http)
15:19:39.659 [restartedMain] INFO  o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
15:19:39.659 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:19:39.685 [restartedMain] INFO  com.zhyc.xps.XPSApplication - Started XPSApplication in 8.375 seconds (process running for 15.464)
15:19:39.688 [restartedMain] INFO  com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
15:19:39.695 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
15:19:40.096 [restartedMain] INFO  p6spy - 2023-08-26 15:19:40 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1
15:19:40.100 [restartedMain] INFO  com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@2fbd250d
15:19:40.103 [restartedMain] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
15:19:40.169 [restartedMain] INFO  p6spy - 2023-08-26 15:19:40 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
             
        A.job_id,
        A.job_title,
        A.job_desc,
        A.status,
        A.job_type,
        A.job_code,
        A.job_cron,
        A.job_class_id,
        B.job_class,
        A.cycle_title,
        A.cycle_period,
        A.cycle_unit
     
        FROM      job       AS A
        LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
        WHERE A.deleted_flag = 0
         
         
           AND A.status = 1
         
         
        ORDER BY A.job_id ASC
15:19:40.190 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:19:40.192 [restartedMain] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
15:21:17.967 [XNIO-1 task-2] INFO  io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
15:21:17.968 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
15:21:17.972 [XNIO-1 task-2] INFO  o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms
15:21:18.101 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 12 ms | Connection: statement-0 | SQL: SELECT 1
15:21:18.130 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:21:18.179 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 12 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        B.oc_type_id,
        B.oc_name,
        A.account_id,
        A.account_name,
        A.account_real_name,
        A.password,
        A.account_type,
        A.account_staff_no,
        A.account_phone,
        A.account_last_ip,
        A.account_loc,
        A.status,
        A.account_avatar,
        A.account_photo,
        A.account_real_name,
        A.account_intro,
        A.wx_id,
        A.is_fixed
     
        FROM        account AS A
        LEFT JOIN   oc      AS B ON (A.oc_id = B.oc_id )
        WHERE A.deleted_flag = 0
        AND (A.account_name = 'sxky'
        OR   A.account_phone = 'sxky'
        OR   A.account_mail  = 'sxky'
        OR   A.account_staff_no = 'sxky')
15:21:18.198 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 14 ms | Connection: statement-0 | SQL: SELECT
             
        A.oc_id,
        A.oc_name,
        A.oc_type_id,
        A.root_id,
        A.parent_id,
        A.admin_id,
        B.account_name AS admin_name,
        A.group_id,
        A.node_left,
        A.node_right,
        A.node_level,
        A.is_leaf,
        A.status,
        A.if_lic
     
        FROM oc           AS A
        LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id)
        WHERE A.oc_id = 406283
15:21:18.213 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT
             
        A.rm_id,
        A.role_id,
        B.role_type_id,
        B.role_code,
        B.role_name,
        A.account_id
     
        FROM      s_role_member AS A
        LEFT JOIN s_role        AS B ON (A.role_id = B.role_id)
        WHERE account_id = 406283
        LIMIT 1
15:21:18.222 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT
             
        A.gm_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        B.node_left ,
        B.node_right,
        A.account_id
     
        FROM      s_group_member    AS A
        LEFT JOIN s_group           AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:21:18.235 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT
             
        A.gmp_id,
        A.oc_id,
        A.group_id,
        B.group_name,
        A.account_id,
        D.account_name,
        D.account_real_name,
        A.position_id,
        C.position_name
     
        FROM      s_group_member_position A
        LEFT JOIN s_group                 B ON (A.oc_id = B.oc_id AND A.group_id     = B.group_id)
        LEFT JOIN s_position              C ON (A.oc_id = C.oc_id AND A.position_id  = C.position_id)
        LEFT JOIN   account               D ON (A.oc_id = D.oc_id AND A.account_id   = D.account_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
        LIMIT 1
15:21:18.248 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:18 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT
             
        A.gmpg_id,
        A.oc_id,
        A.group_id,
        A.account_id,
        A.position_id,
        A.grant_group_id,
        B.group_name AS grant_group_name
     
        FROM      s_group_member_position_grant A
        LEFT JOIN s_group                       B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id)
        WHERE A.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
            AND A.group_id = 406283
         
         
            AND A.account_id = 406283
         
         
            AND A.position_id = 406283
         
        LIMIT 1
15:21:19.298 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:19 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT
             
        client_id,
        client_title,
        client_app_id,
        client_app_key,
        client_app_secret,
        client_desc,
        status,
        is_fixed
     
        FROM  client
        WHERE deleted_flag = 0
         
            AND client_app_id = '10001'
         
         
            AND client_app_key = '82a8bf439373e305'
15:21:19.351 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:19 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT
             
        A.client_id,
        A.role_id,
        A.permit_id,
        A.permit_title,
        A.permit_code,
        A.permit_entry,
        A.permit_desc,
        A.permit_type,
        A.parent_id,
        A.root_id,
        A.sort_no,
        A.is_home
     
        FROM s_role_permit    AS A
        WHERE 1 = 1
         
            AND A.client_id  = 2
         
         
            AND A.role_id = 6
         
         
        ORDER BY A.parent_id ASC ,A.sort_no ASC
15:21:19.633 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:19 | Time Consuming: 36 ms | Connection: statement-0 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
15:21:20.297 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:20 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT 1
15:21:20.309 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:20 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
15:21:20.324 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:20 | Time Consuming: 11 ms | Connection: statement-0 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
15:21:31.680 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
15:21:31.681 [XNIO-1 task-4] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1
15:21:31.682 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1
15:21:31.682 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1
15:21:31.691 [XNIO-1 task-4] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT
             
        oc_id,
        map_id,
        map_title,
        map_desc,
        map_cat_id,
        map_raster_layer,
        map_type_id
     
        FROM ent_map
        WHERE 1 = 1 AND deleted_flag = 0
         
            AND oc_id = 406283
15:21:31.692 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT
                    IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum',

                    IFNULL(SUM( CASE WHEN status =  0  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum',
                    IFNULL(SUM( CASE WHEN status =  1  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum',
                    IFNULL(SUM( CASE WHEN status =  2  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum',
                    IFNULL(SUM( CASE WHEN status =  3  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum',
                    IFNULL(SUM( CASE WHEN status =  4  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum',
                    IFNULL(SUM( CASE WHEN status = -1  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum'
        FROM        goaf_hdanger AS A

        WHERE       A.oc_id = 406283 AND  A.status != -1




         
         

         
            AND  A.hdanger_type = '1'
         

         


         
         

         
         

         
         


         

         
         
         
        ORDER BY  A.submit_time DESC
15:21:31.692 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT
                    IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum',
                    IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum',

                    IFNULL(SUM( CASE WHEN status =  0  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum',
                    IFNULL(SUM( CASE WHEN status =  1  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum',
                    IFNULL(SUM( CASE WHEN status =  2  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum',
                    IFNULL(SUM( CASE WHEN status =  3  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum',
                    IFNULL(SUM( CASE WHEN status =  4  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum',
                    IFNULL(SUM( CASE WHEN status = -1  THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum'
        FROM        goaf_hdanger AS A

        WHERE       A.oc_id = 406283 AND  A.status != -1




         
         

         
            AND  A.hdanger_type = '0'
         

         


         
         

         
         

         
         


         

         
         
         
        ORDER BY  A.submit_time DESC
15:21:31.695 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 7 ms | Connection: statement-3 | SQL: SELECT
         
        A.hdanger_id,
        A.oc_id,
        A.goaf_id,
        A.hdanger_title,
        A.hdanger_level,
        A.hdanger_type,
        A.checklist_id,
        A.hdanger_desc,
        A.submit_group_id,
        A.submit_group_name,
        A.submit_position_id,
        A.submit_position_name,
        A.submit_account_id,
        A.submit_account_name,
        A.submit_time,
        A.review_group_id,
        A.review_group_name,
        A.review_position_id,
        A.review_position_name,
        A.review_account_id,
        A.review_account_name,
        A.danger_deadline,
        A.review_time,
        A.review_remark,
        A.rectify_group_id,
        A.rectify_group_name,
        A.rectify_position_id,
        A.rectify_position_name,
        A.rectify_account_id,
        A.rectify_account_name,
        A.rectify_time,
        A.danger_reason,
        A.rectify_measure,
        A.rectify_remark,
        A.accept_group_id,
        A.accept_group_name,
        A.accept_position_id,
        A.accept_position_name,
        A.accept_account_id,
        A.accept_account_name,
        A.accept_time,
        A.accept_remark,
        A.finish_time,
        A.status,

        B.wf_def_id,
        B.wf_ins_id,
        B.wf_ins_title,
        B.cur_group_id,
        B.cur_group_name,
        B.cur_position_id,
        B.cur_position_name,
        B.cur_account_id,
        B.cur_account_name,
        B.cur_activity_ins_id,
        B.cur_activity_code,
        B.cur_activity_title,
        B.cur_form_code,
        B.cur_activity_begin_time
     
        FROM      goaf_hdanger AS A
        LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id
        WHERE    A.oc_id = 406283

        
        
        
         
         
         

         
            AND  A.hdanger_type = '1'
         


         
         

         
         

         
         

         


         

         
         
         
        ORDER BY  A.submit_time DESC
15:21:31.732 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 15:21:31 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT      A.goaflayer_id,
                    A.oc_id,
                    A.goaf_id,
                    A.goaf_name,
                    A.map_id,
                    A.layer_id,
                    B.layer_cat_id,
                    B.layer_title,
                    B.layer_marker,
                    B.layer_vector,
                    B.layer_vector_type
        FROM        goaf_map_layer AS A
        left join   ent_map_layer  AS B ON B.layer_id = A.layer_id
        WHERE     A.oc_id = 406283
         
            AND A.map_id = '406283'
16:19:44.677 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:44 | Time Consuming: 5 ms | Connection: statement-35 | SQL: SELECT 1
16:19:44.720 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:44 | Time Consuming: 38 ms | Connection: statement-35 | SQL: SELECT count(*)
        FROM msg AS M
        WHERE M.oc_id = 406283
            AND (
                EXISTS (
                    SELECT 1 FROM msg_to TT
                    WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
                ) OR
                EXISTS (
                    SELECT 1 FROM msg_cc CC
                    WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
                )
            )
16:19:45.265 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:45 | Time Consuming: 4 ms | Connection: statement-35 | SQL: SELECT 1
16:19:45.271 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:45 | Time Consuming: 4 ms | Connection: statement-35 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
16:19:45.276 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:45 | Time Consuming: 5 ms | Connection: statement-35 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
16:19:48.497 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 4 ms | Connection: statement-36 | SQL: SELECT 1
16:19:48.497 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 4 ms | Connection: statement-35 | SQL: SELECT 1
16:19:48.506 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 4 ms | Connection: statement-36 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
16:19:48.507 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 3 ms | Connection: statement-35 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283
16:19:48.507 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 3 ms | Connection: statement-37 | SQL: SELECT 1
16:19:48.513 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 5 ms | Connection: statement-35 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
 LIMIT 10 
16:19:48.517 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:48 | Time Consuming: 4 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
16:19:52.022 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 3 ms | Connection: statement-37 | SQL: SELECT 1
16:19:52.033 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
16:19:52.051 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'other'
16:19:52.061 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442129
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
16:19:52.068 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 4 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'waterpump'
16:19:52.076 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 4 ms | Connection: statement-37 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442136
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
16:19:52.082 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 4 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'machinery'
16:19:52.090 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442137
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
16:19:52.098 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'compress'
16:19:52.108 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 5 ms | Connection: statement-37 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442135
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
16:19:52.115 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:52 | Time Consuming: 4 ms | Connection: statement-37 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442139
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
16:19:54.277 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:54 | Time Consuming: 3 ms | Connection: statement-37 | SQL: SELECT 1
16:19:54.294 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:54 | Time Consuming: 12 ms | Connection: statement-37 | SQL: SELECT  td_wave_value_x, td_wave_value_y, td_wave_value_z
        FROM      goaf_sensordata

        WHERE   goaf_data_id = 442169
16:19:58.678 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:58 | Time Consuming: 3 ms | Connection: statement-37 | SQL: SELECT 1
16:19:58.690 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 16:19:58 | Time Consuming: 8 ms | Connection: statement-37 | SQL: SELECT  td_wave_value_x, td_wave_value_y, td_wave_value_z
        FROM      goaf_sensordata

        WHERE   goaf_data_id = 442170
17:58:32.424 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:32 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT 1
17:58:32.436 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:32 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283
17:58:32.715 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:32 | Time Consuming: 277 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
         
        ORDER BY goaf_datareport_time DESC
 LIMIT 10 
17:58:45.883 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT 1
17:58:45.893 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 3 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
17:58:45.908 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'other'
17:58:45.920 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 5 ms | Connection: statement-95 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442129
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
17:58:45.934 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 10 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'waterpump'
17:58:45.942 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442136
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
17:58:45.951 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 7 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'machinery'
17:58:45.961 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 6 ms | Connection: statement-95 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442137
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
17:58:45.968 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 5 ms | Connection: statement-95 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'compress'
17:58:45.975 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 4 ms | Connection: statement-95 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442135
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
17:58:45.983 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 17:58:45 | Time Consuming: 6 ms | Connection: statement-95 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442139
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
18:04:40.469 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:40 | Time Consuming: 4 ms | Connection: statement-100 | SQL: SELECT 1
18:04:40.481 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:40 | Time Consuming: 5 ms | Connection: statement-100 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id    = B.group_id)
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0
18:04:40.537 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:40 | Time Consuming: 6 ms | Connection: statement-100 | SQL: SELECT
             
        A.oc_id,
        A.group_id,
        A.group_name,
        A.group_code,
        A.group_cat_id,
        C.group_cat_title,
        A.node_left,
        A.node_right,
        A.parent_id,
        A.root_id,
        B.group_name as parent_name,
        A.node_level,
        A.is_leaf,
        A.is_fixed,
        A.group_desc
     
        FROM      s_group       AS A
        LEFT JOIN s_group       AS B ON (A.oc_id = B.oc_id AND A.parent_id     = B.group_id    )
        LEFT JOIN s_group_cat   AS C ON (A.oc_id = C.oc_id AND A.group_cat_id  = C.group_cat_id)
        WHERE A.oc_id = 406283 AND A.deleted_flag = 0 AND A.group_id = 406283
18:04:40.608 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:40 | Time Consuming: 6 ms | Connection: statement-100 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND C.node_left >= 1 AND C.node_right <= 4) table_count
18:04:40.617 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:40 | Time Consuming: 6 ms | Connection: statement-100 | SQL: SELECT
            DISTINCT(A.account_id),
            A.gm_id,
            A.oc_id,
            A.group_id,
            B.account_name,
            B.account_real_name,
            B.account_phone,
            B.account_staff_no,
            B.account_avatar,
            B.status,
            B.is_fixed,
            C.group_name,
            C.node_left,
            C.node_right,
            D.gmp_id,
            D.position_id,
            D.position_name,
            E.gmpg_id,
            E.grant_group_id,
            F.group_name as grant_group_name
        FROM
            s_group_member                      AS A
        LEFT JOIN account                       AS B ON (A.oc_id = B.oc_id AND A.account_id     = B.account_id)
        LEFT JOIN s_group                       AS C ON (A.oc_id = C.oc_id AND A.group_id       = C.group_id  )
        LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id     = E.account_id)
        LEFT JOIN s_group                       AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id  )
        LEFT JOIN (
            SELECT
                M.oc_id,
                M.account_id,
                M.gmp_id,
                M.group_id,
                M.position_id,
                P.position_name,
                N.gmpg_id,
                N.grant_group_id,
                GP.group_name as grant_group_name
            FROM
                s_group_member_position AS M
            LEFT JOIN s_group_member_position_grant AS N ON (
                    M.oc_id       = N.oc_id
                AND M.account_id  = N.account_id
                AND M.group_id    = N.group_id
                AND M.position_id = N.position_id )
            LEFT JOIN s_position AS P  ON(M.oc_id = P.oc_id  AND M.position_id    = P.position_id)
            LEFT JOIN s_group    AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id  )
        )      AS  D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id)
        WHERE B.deleted_flag = 0
         
            AND A.oc_id = 406283
         
         
             
                AND C.node_left  >= 1
                AND C.node_right <= 4
                 
         
         
        ORDER BY A.account_id, A.group_id
 LIMIT 10 
18:04:44.732 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:44 | Time Consuming: 4 ms | Connection: statement-100 | SQL: SELECT 1
18:04:44.734 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:04:44 | Time Consuming: 4 ms | Connection: statement-101 | SQL: SELECT 1
18:04:44.737 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:44 | Time Consuming: 5 ms | Connection: statement-100 | SQL: SELECT
                COUNT(*)                                                                       AS 'goafSensorTotalNum',

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

        FROM        goaf_sensor

        WHERE       oc_id = 406283
18:04:44.740 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:04:44 | Time Consuming: 5 ms | Connection: statement-101 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
18:04:44.745 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:04:44 | Time Consuming: 4 ms | Connection: statement-101 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
18:04:45.896 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 3 ms | Connection: statement-100 | SQL: SELECT 1
18:04:45.897 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 3 ms | Connection: statement-101 | SQL: SELECT 1
18:04:45.901 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 3 ms | Connection: statement-100 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
18:04:45.908 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 7 ms | Connection: statement-101 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
18:04:45.910 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 8 ms | Connection: statement-100 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
18:04:45.914 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 7 ms | Connection: statement-102 | SQL: SELECT 1
18:04:45.922 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:04:45 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
18:05:00.333 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:00 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT 1
18:05:00.337 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:00 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT count(0) FROM goaf_sensor WHERE oc_id = 406283
18:05:00.342 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:00 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
 LIMIT 10 
18:05:03.040 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 3 ms | Connection: statement-101 | SQL: SELECT 1
18:05:03.041 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 3 ms | Connection: statement-100 | SQL: SELECT 1
18:05:03.043 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT 1
18:05:03.051 [XNIO-1 task-3] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 5 ms | Connection: statement-100 | SQL: SELECT *
        FROM      goaf_syscfg
        WHERE     oc_id = 406283
18:05:03.051 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 4 ms | Connection: statement-101 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283
18:05:03.057 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 8 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_baseinfo
        WHERE     oc_id = 406283
18:05:03.058 [XNIO-1 task-5] INFO  p6spy - 2023-08-26 18:05:03 | Time Consuming: 6 ms | Connection: statement-101 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
 LIMIT 10 
18:05:09.452 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT 1
18:05:09.460 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_devinfo
         where oc_id = 406283
18:05:09.472 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'other'
18:05:09.478 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442129
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
18:05:09.484 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 5 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'waterpump'
18:05:09.489 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442136
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
18:05:09.494 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'machinery'
18:05:09.500 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442137
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
18:05:09.506 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT *
        FROM      goaf_sensor
         where oc_id = 406283
        
        

        
            AND goaf_dev_name = 'compress'
18:05:09.512 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 4 ms | Connection: statement-102 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442135
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
18:05:09.516 [XNIO-1 task-2] INFO  p6spy - 2023-08-26 18:05:09 | Time Consuming: 3 ms | Connection: statement-102 | SQL: SELECT goaf_data_id, oc_id, goaf_sensor_id, goaf_sensor_name, frequency_x, frequency_y, frequency_z,
               acc_x, acc_y, acc_z, vel_x, vel_y, vel_z, dis_x, dis_y, dis_z, sensor_temperature,
               ang_x, ang_y, ang_z, f_alarm_acc_x, f_alarm_acc_y, f_alarm_acc_z,
               f_alarm_vel_x, f_alarm_vel_y, f_alarm_vel_z, f_alarm_dis_x, f_alarm_dis_y, f_alarm_dis_z,
               f_alarm_temperature, goaf_datareport_time
        FROM      goaf_sensordata
        WHERE     oc_id = 406283
         
            AND goaf_sensor_id = 442139
         

        ORDER BY goaf_datareport_time DESC
        LIMIT 1
19:35:46.359 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:35:46.361 [SpringApplicationShutdownHook] INFO  io.undertow - stopping server: Undertow - 2.3.4.Final
19:35:46.363 [SpringApplicationShutdownHook] INFO  io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
19:35:46.370 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
19:35:46.372 [SpringApplicationShutdownHook] INFO  o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
19:35:46.373 [SpringApplicationShutdownHook] INFO  o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
19:35:46.382 [SpringApplicationShutdownHook] INFO  o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
19:35:46.384 [SpringApplicationShutdownHook] INFO  o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
19:35:46.384 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
19:35:46.384 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
19:35:46.384 [SpringApplicationShutdownHook] INFO  org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
19:35:46.403 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
19:35:46.406 [SpringApplicationShutdownHook] INFO  com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.