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.