11:31:19.275 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 11:31:19.332 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 8884 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 11:31:19.333 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 11:31:19.388 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 11:31:19.388 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 11:31:21.084 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 11:31:21.088 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 11:31:21.152 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 49 ms. Found 0 Redis repository interfaces. 11:31:21.298 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 11:31:21.320 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 11:31:22.106 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:31:22.106 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2717 ms 11:31:24.459 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 11:31:24.470 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 11:31:24.470 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 11:31:24.471 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 11:31:24.472 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 11:31:24.472 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 11:31:24.472 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 11:31:24.472 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@158c59f1 11:31:26.645 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 11:31:26.836 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 11:31:26.880 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:31:26.881 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 11:31:26.882 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 11:31:26.918 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:31:26.931 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 11:31:26.941 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 11:31:26.978 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 11:31:27.039 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 11:31:27.222 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:31:27.222 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 176 ms 11:31:27.233 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 11:31:27.275 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:31:27.296 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http) 11:31:27.299 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 11:31:27.299 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.329 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.534 seconds (process running for 9.945) 11:31:27.332 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 11:31:27.342 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 11:31:27.805 [restartedMain] INFO p6spy - 2023-06-29 11:31:27 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1 11:31:27.809 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@6b252b72 11:31:27.814 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 11:31:27.892 [restartedMain] INFO p6spy - 2023-06-29 11:31:27 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 11:31:27.922 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.924 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.925 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.925 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.926 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.926 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.926 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:27.927 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:31:28.224 [RMI TCP Connection(9)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 11:31:28.224 [RMI TCP Connection(9)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 11:31:28.229 [RMI TCP Connection(9)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 5 ms 11:31:28.236 [RMI TCP Connection(8)-192.168.3.5] INFO p6spy - 2023-06-29 11:31:28 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 11:31:56.255 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 10 ms | Connection: statement-0 | SQL: SELECT 1 11:31:56.283 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 12 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' 11:31:56.324 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | 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') 11:31:56.341 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 10 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 11:31:56.354 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 10 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 11:31:56.367 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 10 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 11:31:56.380 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | 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 11:31:56.392 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | 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 11:31:56.951 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 10 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' 11:31:56.995 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:56 | Time Consuming: 11 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 11:31:57.196 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 9 ms | Connection: statement-1 | SQL: SELECT 1 11:31:57.196 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 9 ms | Connection: statement-2 | SQL: SELECT 1 11:31:57.196 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 9 ms | Connection: statement-3 | SQL: SELECT 1 11:31:57.207 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 11:31:57.215 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 11 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:31:57.243 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 35 ms | Connection: statement-2 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 11:31:57.295 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 11 ms | Connection: statement-3 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 11:31:57.309 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:31:57 | Time Consuming: 10 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 11:31:58.836 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:31:58 | Time Consuming: 9 ms | Connection: statement-3 | SQL: SELECT 1 11:31:58.856 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:31:58 | Time Consuming: 9 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 11:32:14.048 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:14 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1 11:32:14.070 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:14 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 11:32:14.110 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:14 | Time Consuming: 4 ms | Connection: statement-3 | 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 11:32:14.161 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:14 | Time Consuming: 5 ms | Connection: statement-3 | 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 11:32:14.168 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:14 | Time Consuming: 4 ms | Connection: statement-3 | 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 11:32:16.847 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:16 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT 1 11:32:16.855 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:16 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 11:32:52.177 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:52 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT 1 11:32:52.190 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:52 | Time Consuming: 7 ms | Connection: statement-3 | SQL: UPDATE goaf_bigscreencfg SET bigscreen_addr = ' http://192.168.3.16:8080/#/' WHERE oc_id = 406283 11:32:52.220 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:52 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 11:32:54.821 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:54 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1 11:32:54.830 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:54 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_bigscreencfg WHERE oc_id = 406283 11:32:56.088 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-2 | SQL: SELECT 1 11:32:56.088 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-3 | SQL: SELECT 1 11:32:56.088 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT 1 11:32:56.088 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-4 | SQL: SELECT 1 11:32:56.088 [XNIO-1 task-6] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-1 | SQL: SELECT 1 11:32:56.109 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 11:32:56.112 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 7 ms | Connection: statement-2 | SQL: SELECT IFNULL(SUM( CASE WHEN hdanger_level = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelLowerNum', IFNULL(SUM( CASE WHEN hdanger_level = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelGeneralNum', IFNULL(SUM( CASE WHEN hdanger_level = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelMajorNum', IFNULL(SUM( CASE WHEN hdanger_level = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerLevelSeriousNum', IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTosubmitNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToforreviewlNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusTorectifyNum', IFNULL(SUM( CASE WHEN status = 3 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusToacceptNum', IFNULL(SUM( CASE WHEN status = 4 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCompleteNum', IFNULL(SUM( CASE WHEN status = -1 THEN 1 ELSE 0 END ), 0) AS 'goafHdangerStatusCancelNum' FROM goaf_hdanger AS A WHERE A.oc_id = 406283 AND A.status != -1 AND A.hdanger_type = '1' ORDER BY A.submit_time DESC 11:32:56.112 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 7 ms | Connection: statement-3 | 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 11:32:56.115 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-4 | 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 11:32:56.121 [XNIO-1 task-6] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 16 ms | Connection: statement-1 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 11:32:56.151 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 7 ms | Connection: statement-4 | SQL: SELECT oc_id, map_id, map_title, map_desc, map_cat_id, map_raster_layer, map_type_id FROM ent_map WHERE 1 = 1 AND deleted_flag = 0 AND oc_id = 406283 11:32:56.151 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 11:32:56.157 [XNIO-1 task-5] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 5 ms | Connection: statement-3 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 11:32:56.160 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 8 ms | Connection: statement-1 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 11:32:56.163 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-2 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 11:32:56.183 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 9 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 11:32:56.286 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:56 | Time Consuming: 6 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' 11:32:59.209 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT 1 11:32:59.209 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 11:32:59.209 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 11:32:59.221 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:32:59.221 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 11:32:59.235 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 11:32:59.242 [XNIO-1 task-7] INFO p6spy - 2023-06-29 11:32:59 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 LIMIT 8 11:37:31.339 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:37:31.346 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:37:31.346 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:37:31.348 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 11:37:31.348 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:37:31.348 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 11:37:31.348 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 11:37:31.358 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process) 11:37:31.359 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 11:37:31.359 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 11:37:31.359 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:37:31.359 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 11:37:31.378 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 11:37:31.382 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 11:37:34.361 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 11:37:34.411 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 17420 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 11:37:34.411 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 11:37:34.461 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 11:37:34.461 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 11:37:35.946 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 11:37:35.950 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 11:37:36.017 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 53 ms. Found 0 Redis repository interfaces. 11:37:36.149 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 11:37:36.164 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 11:37:36.886 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:37:36.886 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2424 ms 11:37:39.105 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 11:37:39.115 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 11:37:39.115 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 11:37:39.116 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 11:37:39.116 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 11:37:39.116 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 11:37:39.116 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 11:37:39.117 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@36b03d4b 11:37:40.739 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 11:37:40.867 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 11:37:40.895 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:37:40.896 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 11:37:40.896 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 11:37:40.915 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:37:40.923 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 11:37:40.932 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 11:37:40.958 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 11:37:41.005 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 11:37:41.120 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:37:41.120 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 109 ms 11:37:41.129 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 11:37:41.162 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:37:41.177 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http) 11:37:41.180 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 11:37:41.180 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.204 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 7.307 seconds (process running for 8.16) 11:37:41.206 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 11:37:41.213 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 11:37:41.520 [restartedMain] INFO p6spy - 2023-06-29 11:37:41 | Time Consuming: 12 ms | Connection: statement-0 | SQL: SELECT 1 11:37:41.524 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@67eda52e 11:37:41.534 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 11:37:41.597 [restartedMain] INFO p6spy - 2023-06-29 11:37:41 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 11:37:41.621 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.623 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.623 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.624 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.624 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.624 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.624 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.624 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:37:41.913 [RMI TCP Connection(2)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 11:37:41.913 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 11:37:41.918 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms 11:37:41.927 [RMI TCP Connection(1)-192.168.3.5] INFO p6spy - 2023-06-29 11:37:41 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 11:37:54.318 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 11:37:54.318 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1 11:37:54.318 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT 1 11:37:54.328 [XNIO-1 task-4] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 11:37:54.329 [XNIO-1 task-3] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 11:37:54.412 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 11:37:54.420 [XNIO-1 task-2] INFO p6spy - 2023-06-29 11:37:54 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 11:38:07.415 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:38:07.421 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:38:07.421 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 11:38:07.423 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 11:38:07.425 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:38:07.425 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 11:38:07.427 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 11:38:07.435 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process) 11:38:07.437 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 11:38:07.437 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 11:38:07.437 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 11:38:07.437 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 11:38:07.450 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 11:38:07.454 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed. 11:49:18.755 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 11:49:18.800 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 17760 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 11:49:18.800 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 11:49:18.853 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 11:49:18.853 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 11:49:20.369 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 11:49:20.372 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 11:49:20.433 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 48 ms. Found 0 Redis repository interfaces. 11:49:20.570 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 11:49:20.586 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 11:49:21.291 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 11:49:21.291 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2437 ms 11:49:23.508 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 11:49:23.518 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 11:49:23.518 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 11:49:23.519 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 11:49:23.520 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED' Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally. NOT STARTED. Currently in standby mode. Number of jobs executed: 0 Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered. 11:49:23.520 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 11:49:23.520 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 11:49:23.520 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@2fd5dce5 11:49:25.127 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 11:49:25.132 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 11:49:25.270 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 11:49:25.299 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 11:49:25.299 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 11:49:25.300 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 11:49:25.319 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 11:49:25.328 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 11:49:25.337 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 11:49:25.364 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 11:49:25.414 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 11:49:25.415 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 11:49:25.415 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.439 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 7.137 seconds (process running for 7.878) 11:49:25.442 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 11:49:25.449 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 11:49:25.747 [restartedMain] INFO p6spy - 2023-06-29 11:49:25 | Time Consuming: 13 ms | Connection: statement-0 | SQL: SELECT 1 11:49:25.752 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@2f304c87 11:49:25.762 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 11:49:25.832 [restartedMain] INFO p6spy - 2023-06-29 11:49:25 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.job_id, A.job_title, A.job_desc, A.status, A.job_type, A.job_code, A.job_cron, A.job_class_id, B.job_class, A.cycle_title, A.cycle_period, A.cycle_unit FROM job AS A LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id) WHERE A.deleted_flag = 0 AND A.status = 1 ORDER BY A.job_id ASC 11:49:25.856 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.858 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.858 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.859 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.859 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.859 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.859 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:25.860 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 11:49:26.350 [RMI TCP Connection(2)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 11:49:26.351 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 11:49:26.353 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 2 ms 11:49:26.358 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-29 11:49:26 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 15:50:22.518 [XNIO-1 task-13] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-145 | SQL: SELECT 1 15:50:22.518 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-148 | SQL: SELECT 1 15:50:22.518 [XNIO-1 task-9] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-146 | SQL: SELECT 1 15:50:22.518 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-147 | SQL: SELECT 1 15:50:22.518 [XNIO-1 task-3] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-149 | SQL: SELECT 1 15:50:22.535 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 6 ms | Connection: statement-147 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 15:50:22.535 [XNIO-1 task-13] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-145 | 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:50:22.535 [XNIO-1 task-9] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 6 ms | Connection: statement-146 | 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:50:22.538 [XNIO-1 task-3] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 8 ms | Connection: statement-149 | 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:50:22.541 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 12 ms | Connection: statement-148 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 15:50:22.557 [XNIO-1 task-12] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 4 ms | Connection: statement-147 | 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:50:22.587 [XNIO-1 task-13] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-147 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 15:50:22.587 [XNIO-1 task-9] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 5 ms | Connection: statement-146 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 15:50:22.587 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 7 ms | Connection: statement-145 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:50:22.596 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 8 ms | Connection: statement-148 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 15:50:22.612 [XNIO-1 task-3] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 6 ms | Connection: statement-149 | SQL: SELECT A.goaflayer_id, A.oc_id, A.goaf_id, A.goaf_name, A.map_id, A.layer_id, B.layer_cat_id, B.layer_title, B.layer_marker, B.layer_vector, B.layer_vector_type FROM goaf_map_layer AS A left join ent_map_layer AS B ON B.layer_id = A.layer_id WHERE A.oc_id = 406283 AND A.map_id = '406283' 15:50:22.617 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:22 | Time Consuming: 6 ms | Connection: statement-145 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 15:50:26.325 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 5 ms | Connection: statement-145 | SQL: SELECT 1 15:50:26.325 [XNIO-1 task-3] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 5 ms | Connection: statement-149 | SQL: SELECT 1 15:50:26.325 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 5 ms | Connection: statement-148 | SQL: SELECT 1 15:50:26.336 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 5 ms | Connection: statement-148 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:50:26.336 [XNIO-1 task-3] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 5 ms | Connection: statement-149 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 15:50:26.410 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 6 ms | Connection: statement-145 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 15:50:26.419 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:26 | Time Consuming: 6 ms | Connection: statement-145 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 15:50:30.677 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:30 | Time Consuming: 5 ms | Connection: statement-145 | SQL: SELECT 1 15:50:30.677 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:30 | Time Consuming: 3 ms | Connection: statement-148 | SQL: SELECT 1 15:50:30.689 [XNIO-1 task-8] INFO p6spy - 2023-06-29 15:50:30 | Time Consuming: 6 ms | Connection: statement-145 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 15:50:30.689 [XNIO-1 task-4] INFO p6spy - 2023-06-29 15:50:30 | Time Consuming: 6 ms | Connection: statement-148 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:00:35.185 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 6 ms | Connection: statement-156 | SQL: SELECT 1 16:00:35.201 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 7 ms | Connection: statement-156 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:00:35.228 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 7 ms | Connection: statement-156 | 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 16:00:35.251 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 4 ms | Connection: statement-156 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:00:35.258 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 7 ms | Connection: statement-157 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:00:35.281 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 5 ms | Connection: statement-156 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:00:35.285 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:00:35 | Time Consuming: 6 ms | Connection: statement-157 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:00:40.203 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5024 ms | Connection: statement-155 | SQL: SELECT 1 16:00:40.203 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5024 ms | Connection: statement-153 | SQL: SELECT 1 16:00:40.203 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5024 ms | Connection: statement-152 | SQL: SELECT 1 16:00:40.203 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5024 ms | Connection: statement-154 | SQL: SELECT 1 16:00:40.209 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-157 | SQL: SELECT 1 16:00:40.209 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-156 | SQL: SELECT 1 16:00:40.209 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-158 | SQL: SELECT 1 16:00:40.209 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-159 | SQL: SELECT 1 16:00:40.220 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-156 | 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 16:00:40.220 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5 ms | Connection: statement-157 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:00:40.220 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5 ms | Connection: statement-159 | 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 16:00:40.220 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 4 ms | Connection: statement-158 | 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 16:00:40.250 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5 ms | Connection: statement-158 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:00:40.297 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:00:40 | Time Consuming: 5 ms | Connection: statement-158 | 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:06:10.091 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:10 | Time Consuming: 5001 ms | Connection: statement-157 | SQL: SELECT 1 16:06:15.094 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:15 | Time Consuming: 5002 ms | Connection: statement-158 | SQL: SELECT 1 16:06:20.095 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:20 | Time Consuming: 5001 ms | Connection: statement-159 | SQL: SELECT 1 16:06:25.099 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 5002 ms | Connection: statement-160 | SQL: SELECT 1 16:06:25.107 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 6 ms | Connection: statement-162 | SQL: SELECT 1 16:06:25.121 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 5 ms | Connection: statement-162 | 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' 16:06:25.143 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 5 ms | Connection: statement-162 | 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') 16:06:25.150 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 5 ms | Connection: statement-162 | 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 16:06:25.158 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 6 ms | Connection: statement-162 | 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 16:06:25.162 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 4 ms | Connection: statement-162 | 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 16:06:25.169 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 5 ms | Connection: statement-162 | 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 16:06:25.174 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:25 | Time Consuming: 4 ms | Connection: statement-162 | 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 16:06:54.781 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 4 ms | Connection: statement-162 | SQL: SELECT 1 16:06:54.790 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-165 | SQL: SELECT 1 16:06:54.790 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-164 | SQL: SELECT 1 16:06:54.790 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-167 | SQL: SELECT 1 16:06:54.790 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-163 | SQL: SELECT 1 16:06:54.790 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-166 | SQL: SELECT 1 16:06:54.794 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-162 | 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 16:06:54.801 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-165 | 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 16:06:54.801 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 4 ms | Connection: statement-167 | 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 16:06:54.803 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 6 ms | Connection: statement-163 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:06:54.805 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 8 ms | Connection: statement-166 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:06:54.807 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 9 ms | Connection: statement-164 | 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 16:06:54.879 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-163 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:06:54.879 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-166 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:06:54.879 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 5 ms | Connection: statement-164 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:06:54.916 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 6 ms | Connection: statement-167 | 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:06:54.926 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 4 ms | Connection: statement-166 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:06:54.927 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:06:54 | Time Consuming: 6 ms | Connection: statement-163 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:12:37.053 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:12:37 | Time Consuming: 6 ms | Connection: statement-168 | 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 16:12:37.082 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:12:37 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:12:37.111 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:12:37 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:12:37.140 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:12:37 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:12:37.171 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:12:37 | Time Consuming: 7 ms | Connection: statement-168 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:12:41.973 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5002 ms | Connection: statement-166 | SQL: SELECT 1 16:12:41.979 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:12:41.988 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5005 ms | Connection: statement-163 | SQL: SELECT 1 16:12:41.988 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5005 ms | Connection: statement-162 | SQL: SELECT 1 16:12:41.988 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5005 ms | Connection: statement-165 | SQL: SELECT 1 16:12:41.988 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5005 ms | Connection: statement-164 | SQL: SELECT 1 16:12:41.992 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 6 ms | Connection: statement-168 | 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 16:12:41.994 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:12:41.994 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5 ms | Connection: statement-171 | SQL: SELECT 1 16:12:41.994 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT 1 16:12:41.994 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:12:41 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT 1 16:12:42.005 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 4 ms | Connection: statement-171 | 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 16:12:42.005 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 4 ms | Connection: statement-170 | 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 16:12:42.007 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 6 ms | Connection: statement-172 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:12:42.009 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 8 ms | Connection: statement-169 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:12:42.352 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 5 ms | Connection: statement-169 | 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:12:42.355 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:12:42 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:15:56.729 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:15:56.729 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-171 | SQL: SELECT 1 16:15:56.729 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT 1 16:15:56.729 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT 1 16:15:56.729 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:15:56.741 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-168 | 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 16:15:56.741 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:15:56.741 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-172 | 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 16:15:56.743 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 8 ms | Connection: statement-169 | 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 16:15:56.746 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 11 ms | Connection: statement-171 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:15:56.763 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 6 ms | Connection: statement-168 | 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 16:15:56.771 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:15:56.771 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:15:56.771 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:15:56.795 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 6 ms | Connection: statement-168 | 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:15:56.799 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:15:56.801 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:15:56 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:16:20.817 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT 1 16:16:20.817 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT 1 16:16:20.824 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-169 | SQL: SELECT 1 16:16:20.824 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT 1 16:16:20.824 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 7 ms | Connection: statement-171 | SQL: SELECT 1 16:16:20.824 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT 1 16:16:20.831 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-172 | 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 16:16:20.831 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-170 | 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 16:16:20.835 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-174 | 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 16:16:20.835 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-171 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:16:20.836 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-169 | 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 16:16:20.837 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 7 ms | Connection: statement-168 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:16:20.860 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 7 ms | Connection: statement-172 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:16:20.861 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:16:20.865 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:16:20.880 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:16:20.885 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:16:20.902 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:20 | Time Consuming: 6 ms | Connection: statement-172 | 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:16:33.973 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-170 | SQL: SELECT 1 16:16:33.973 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-171 | SQL: SELECT 1 16:16:33.973 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-172 | SQL: SELECT 1 16:16:33.973 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:16:33.973 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:16:33.973 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:16:33.986 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 6 ms | Connection: statement-168 | 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 16:16:33.986 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 6 ms | Connection: statement-172 | 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 16:16:33.986 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 7 ms | Connection: statement-169 | 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 16:16:33.986 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 7 ms | Connection: statement-170 | 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 16:16:33.987 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 8 ms | Connection: statement-171 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:16:33.988 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:33 | Time Consuming: 8 ms | Connection: statement-174 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:16:34.015 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 4 ms | Connection: statement-170 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:16:34.015 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:16:34.015 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:16:34.034 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 5 ms | Connection: statement-168 | 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:16:34.042 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:16:34.049 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:34 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:16:48.169 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:16:48.169 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:16:48.169 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:16:48.179 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:48.179 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:48.187 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:48.192 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:48 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:52.263 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT 1 16:16:52.271 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT 1 16:16:52.273 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT 1 16:16:52.273 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 3 ms | Connection: statement-168 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:52.279 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 3 ms | Connection: statement-174 | SQL: SELECT IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafTaskWaitingNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafTaskCompletedNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafTaskExceedNum', IFNULL(SUM( CASE WHEN check_result = 0 THEN 1 ELSE 0 END ), 0) AS 'goafTaskPassNum', IFNULL(SUM( CASE WHEN check_result = 1 THEN 1 ELSE 0 END ), 0) AS 'goafTaskNopassdNum', IFNULL(SUM( CASE WHEN check_result = 2 THEN 1 ELSE 0 END ), 0) AS 'goafTaskUncheckNum' FROM goaf_check_record AS A WHERE A.oc_id = 406283 16:16:52.288 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT count(0) FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.status = '0' AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:16:52.297 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:52 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT IFNULL(SUM( CASE WHEN status = 0 THEN 1 ELSE 0 END ), 0) AS 'goafTaskWaitingNum', IFNULL(SUM( CASE WHEN status = 1 THEN 1 ELSE 0 END ), 0) AS 'goafTaskCompletedNum', IFNULL(SUM( CASE WHEN status = 2 THEN 1 ELSE 0 END ), 0) AS 'goafTaskExceedNum', IFNULL(SUM( CASE WHEN check_result = 0 THEN 1 ELSE 0 END ), 0) AS 'goafTaskPassNum', IFNULL(SUM( CASE WHEN check_result = 1 THEN 1 ELSE 0 END ), 0) AS 'goafTaskNopassdNum', IFNULL(SUM( CASE WHEN check_result = 2 THEN 1 ELSE 0 END ), 0) AS 'goafTaskUncheckNum' FROM goaf_task AS A WHERE A.oc_id = 406283 16:16:53.292 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:53 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:16:53.302 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:53 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:16:53.304 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:53 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:53.315 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:53 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:16:53.320 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:53 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:16:54.906 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT 1 16:16:54.906 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:16:54.906 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT 1 16:16:54.918 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:54.918 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 6 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:54.927 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:54.934 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:54 | Time Consuming: 7 ms | Connection: statement-168 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:56.845 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:16:56.845 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT 1 16:16:56.845 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 3 ms | Connection: statement-169 | SQL: SELECT 1 16:16:56.856 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:56.856 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:56.863 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:56.869 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:56 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:57.510 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT 1 16:16:57.510 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT 1 16:16:57.510 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:16:57.521 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:57.521 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:57.528 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:57.533 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:57 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:58.231 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT 1 16:16:58.231 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:16:58.231 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:16:58.242 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:58.243 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 6 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:58.247 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:58.255 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:58.941 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:16:58.941 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 4 ms | Connection: statement-169 | SQL: SELECT 1 16:16:58.941 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT 1 16:16:58.952 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:58.952 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-169 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:16:58.958 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:16:58.965 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:58 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:16:59.565 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:59 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:16:59.570 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:59 | Time Consuming: 3 ms | Connection: statement-174 | SQL: SELECT 1 16:16:59.575 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:16:59 | Time Consuming: 4 ms | Connection: statement-168 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:16:59.579 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:16:59 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:19:52.044 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:19:52 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:19:52.044 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:19:52 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:19:52.056 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:19:52 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:19:52.056 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:19:52 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:20:18.080 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:20:18 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:20:18.080 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:20:18 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT 1 16:20:18.092 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:20:18 | Time Consuming: 6 ms | Connection: statement-168 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:20:18.093 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:20:18 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:20:51.912 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:20:51 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT 1 16:20:51.912 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:20:51 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:20:51.923 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:20:51 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:20:51.923 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:20:51 | Time Consuming: 5 ms | Connection: statement-168 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:21:10.683 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:21:10 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:21:10.683 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:21:10 | Time Consuming: 4 ms | Connection: statement-176 | SQL: SELECT 1 16:21:10.692 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:21:10 | Time Consuming: 3 ms | Connection: statement-174 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:21:10.692 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:21:10 | Time Consuming: 4 ms | Connection: statement-176 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:21:50.654 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:21:50 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:21:50.654 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:21:50 | Time Consuming: 4 ms | Connection: statement-176 | SQL: SELECT 1 16:21:50.666 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:21:50 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:21:50.666 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:21:50 | Time Consuming: 6 ms | Connection: statement-176 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:22:05.327 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-176 | SQL: SELECT 1 16:22:05.339 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-176 | 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 16:22:05.341 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:22:05.353 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-177 | SQL: SELECT 1 16:22:05.353 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT 1 16:22:05.356 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 7 ms | Connection: statement-179 | SQL: SELECT 1 16:22:05.356 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 7 ms | Connection: statement-174 | 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 16:22:05.365 [XNIO-1 task-8] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 6 ms | Connection: statement-177 | 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 16:22:05.366 [XNIO-1 task-12] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 8 ms | Connection: statement-176 | 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 16:22:05.367 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 8 ms | Connection: statement-178 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.hdanger_type = '0' ORDER BY A.submit_time DESC 16:22:05.370 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 7 ms | Connection: statement-179 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_task AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 AND A.expected_end_date >= '2023-06-29 00:00:00' AND A.expected_end_date <= '2023-06-30 00:00:00' 16:22:05.380 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:22:05.388 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-177 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:22:05.394 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 6 ms | Connection: statement-179 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:22:05.407 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 4 ms | Connection: statement-178 | 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:22:05.407 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT COUNT(*) AS 'goafDevTotalNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementSensorOnlineNum', IFNULL(SUM( CASE WHEN goaf_dev_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasSensorOnlineNum' FROM goaf_devinfo AS A WHERE A.oc_id = 406283 16:22:05.425 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:05 | Time Consuming: 5 ms | Connection: statement-179 | SQL: SELECT A.*, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_check_record AS A LEFT JOIN goaf_baseinfo AS B ON A.goaf_id = B.goaf_id WHERE A.oc_id = 406283 16:22:41.308 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:22:41 | Time Consuming: 31 ms | Connection: statement-178 | SQL: SELECT 1 16:22:41.308 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:41 | Time Consuming: 31 ms | Connection: statement-179 | SQL: SELECT 1 16:22:41.324 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:22:41 | Time Consuming: 9 ms | Connection: statement-179 | SQL: SELECT COUNT(*) FROM goaf_camera_alarm where oc_id = 406283 AND goaf_alarm_status = '0' 16:22:41.324 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:22:41 | Time Consuming: 9 ms | Connection: statement-178 | SQL: SELECT A.*, B.goaf_dev_ip, B.goaf_dev_port, B.goaf_dev_account, B.goaf_dev_pwd, B.goaf_dev_socket_addr, B.goaf_orebelt, B.goaf_orebody, B.goaf_oreheight, B.goaf_name FROM goaf_camera_alarm AS A LEFT JOIN goaf_devinfo AS B ON A.goaf_dev_id = B.goaf_dev_id where A.oc_id = 406283 AND A.goaf_alarm_status = '0' ORDER BY A.goaf_alarm_begintime DESC 16:23:27.093 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT 1 16:23:27.093 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 5 ms | Connection: statement-179 | SQL: SELECT 1 16:23:27.098 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:23:27.103 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 4 ms | Connection: statement-179 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:23:27.109 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT COUNT(*) AS 'sensorDataTotalNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '压力传感器' THEN 1 ELSE 0 END ), 0) AS 'pressureAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '位移传感器' THEN 1 ELSE 0 END ), 0) AS 'displacementAlarmNum', IFNULL(SUM( CASE WHEN goaf_sensor_data_status = 1 AND goaf_dev_typename = '有害气体传感器' THEN 1 ELSE 0 END ), 0) AS 'harmfulGasAlarmNum' FROM goaf_sensordata AS A WHERE A.oc_id = 406283 16:23:27.111 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 6 ms | Connection: statement-178 | SQL: SELECT count(0) FROM goaf_devinfo AS A LEFT JOIN (SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN (SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' 16:23:27.117 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:27 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT A.*, F.goaf_sensor_value, F.goaf_datareport_time, C.hdanger_level FROM goaf_devinfo AS A LEFT JOIN ( SELECT D.goaf_data_id, D.goaf_dev_name AS dev_name, D.goaf_sensor_value, D.goaf_datareport_time, D.goaf_dev_id FROM goaf_sensordata AS D RIGHT JOIN ( SELECT goaf_dev_name, MAX(goaf_datareport_time) AS goaf_datareport_time FROM goaf_sensordata GROUP BY goaf_dev_name) AS E ON E.goaf_datareport_time = D.goaf_datareport_time ) AS F ON A.goaf_dev_name = F.dev_name LEFT JOIN goaf_hdanger AS C ON F.goaf_data_id = C.goaf_data_id WHERE A.oc_id = 406283 AND A.goaf_dev_typename != '摄像头' LIMIT 8 16:23:29.558 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:29 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT 1 16:23:29.563 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:29 | Time Consuming: 3 ms | Connection: statement-178 | SQL: SELECT 1 16:23:29.568 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:29 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:23:29.574 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:29 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:23:59.827 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 4 ms | Connection: statement-174 | SQL: SELECT 1 16:23:59.827 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT 1 16:23:59.839 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:23:59.842 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 6 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:23:59.926 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 5 ms | Connection: statement-174 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:23:59.926 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:23:59 | Time Consuming: 6 ms | Connection: statement-178 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:27:00.006 [quartzScheduler_Worker-1] INFO c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----Start 16:27:05.009 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-29 16:27:05 | Time Consuming: 5002 ms | Connection: statement-176 | SQL: SELECT 1 16:27:10.011 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-29 16:27:10 | Time Consuming: 5001 ms | Connection: statement-177 | SQL: SELECT 1 16:27:10.018 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-29 16:27:10 | Time Consuming: 5 ms | Connection: statement-178 | SQL: SELECT 1 16:27:10.038 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-29 16:27:10 | Time Consuming: 12 ms | Connection: statement-178 | SQL: UPDATE goaf_task SET status = 2 WHERE job_id = 439094 16:27:10.046 [quartzScheduler_Worker-1] INFO p6spy - 2023-06-29 16:27:10 | Time Consuming: 7 ms | Connection: statement-178 | SQL: SELECT * FROM goaf_check_def WHERE 1=1 AND job_id = 439094 AND status = 1 16:27:10.061 [quartzScheduler_Worker-1] INFO c.zhyc.xps.goaf.job.GoafCheckTaskJob - 采空区检查任务执行派发--->CheckTask Generate----End 16:28:07.194 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:28:07 | Time Consuming: 7 ms | Connection: statement-178 | SQL: SELECT 1 16:28:07.217 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:28:07 | Time Consuming: 14 ms | Connection: statement-178 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:29:44.161 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 4 ms | Connection: statement-184 | SQL: SELECT 1 16:29:44.161 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:29:44.168 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:29:44.168 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:29:44.172 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:29:44.172 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:29:44.178 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:29:44.178 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:29:44 | Time Consuming: 4 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:29:48.086 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:29:48 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:29:48.086 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:29:48 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:29:48.098 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:29:48 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:29:48.098 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:29:48 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:30:22.398 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:30:22 | Time Consuming: 4 ms | Connection: statement-186 | SQL: SELECT 1 16:30:22.398 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:30:22 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:30:22.409 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:30:22 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:30:22.409 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:30:22 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:30:42.913 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:30:42 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:30:42.913 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:30:42 | Time Consuming: 3 ms | Connection: statement-186 | SQL: SELECT 1 16:30:42.924 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:30:42 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:30:42.924 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:30:42 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:31:38.176 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT 1 16:31:38.176 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT 1 16:31:38.178 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:31:38.178 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:31:38.188 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:38.188 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:31:38.190 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:31:38.190 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:31:38 | Time Consuming: 6 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:51.405 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 3 ms | Connection: statement-186 | SQL: SELECT 1 16:31:51.405 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:31:51.405 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:31:51.407 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:31:51.416 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:31:51.416 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 6 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:51.419 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:51.419 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:31:51 | Time Consuming: 9 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:32:57.589 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:32:57.592 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 6 ms | Connection: statement-183 | SQL: SELECT 1 16:32:57.592 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT 1 16:32:57.592 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT 1 16:32:57.602 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:32:57.603 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 4 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:32:57.603 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 4 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:32:57.603 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:32:57 | Time Consuming: 4 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:42.084 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:33:42.084 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:33:42.094 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:33:42.094 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:42.097 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:33:42.097 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:33:42.109 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:33:42.109 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:42 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:46.984 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:46 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:33:46.985 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:46 | Time Consuming: 4 ms | Connection: statement-185 | SQL: SELECT 1 16:33:46.997 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:46 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:33:46.997 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:46 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:56.797 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 4 ms | Connection: statement-184 | SQL: SELECT 1 16:33:56.797 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 4 ms | Connection: statement-185 | SQL: SELECT 1 16:33:56.800 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:33:56.800 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:33:56.807 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:56.809 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 8 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:33:56.813 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 6 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:33:56.814 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:33:56 | Time Consuming: 7 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:34:06.813 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 4 ms | Connection: statement-185 | SQL: SELECT 1 16:34:06.813 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:34:06.813 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:34:06.813 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:34:06.860 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 6 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:34:06.860 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:34:06.861 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 6 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:34:06.861 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:34:06 | Time Consuming: 7 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:34:15.257 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 4 ms | Connection: statement-185 | SQL: SELECT 1 16:34:15.257 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 4 ms | Connection: statement-186 | SQL: SELECT 1 16:34:15.268 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:34:15.268 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:34:15.268 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:34:15.271 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 7 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:34:15.278 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 4 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:34:15.280 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:34:15 | Time Consuming: 6 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:35:00.536 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-183 | SQL: SELECT 1 16:35:00.536 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:35:00.536 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-185 | SQL: SELECT 1 16:35:00.536 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT 1 16:35:00.546 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 4 ms | Connection: statement-185 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:35:00.546 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 4 ms | Connection: statement-183 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:35:00.546 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:35:00.546 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:35:00 | Time Consuming: 5 ms | Connection: statement-184 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:36:19.426 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT 1 16:36:19.437 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 6 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:36:19.438 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 5 ms | Connection: statement-188 | SQL: SELECT 1 16:36:19.439 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT 1 16:36:19.449 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 4 ms | Connection: statement-188 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:36:19.450 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:36:19 | Time Consuming: 6 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:36:24.434 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:36:24 | Time Consuming: 5014 ms | Connection: statement-187 | SQL: SELECT 1 16:36:24.441 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:36:24 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT 1 16:36:24.452 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:36:24 | Time Consuming: 5 ms | Connection: statement-186 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:37:31.247 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:37:31 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT 1 16:37:31.247 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:37:31 | Time Consuming: 5 ms | Connection: statement-188 | SQL: SELECT 1 16:37:31.258 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:37:31 | Time Consuming: 5 ms | Connection: statement-188 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:37:31.258 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:37:31 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:40:32.351 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:40:32 | Time Consuming: 9 ms | Connection: statement-188 | SQL: SELECT 1 16:40:32.351 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:40:32 | Time Consuming: 9 ms | Connection: statement-189 | SQL: SELECT 1 16:40:32.362 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:40:32 | Time Consuming: 4 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:40:32.363 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:40:32 | Time Consuming: 6 ms | Connection: statement-188 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:40:37.345 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 5000 ms | Connection: statement-191 | SQL: SELECT 1 16:40:37.345 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 5001 ms | Connection: statement-190 | SQL: SELECT 1 16:40:37.351 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT 1 16:40:37.351 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 5 ms | Connection: statement-188 | SQL: SELECT 1 16:40:37.361 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 4 ms | Connection: statement-188 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:40:37.361 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:40:37 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:41:27.102 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 6 ms | Connection: statement-192 | SQL: SELECT 1 16:41:27.102 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 6 ms | Connection: statement-189 | SQL: SELECT 1 16:41:27.102 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 6 ms | Connection: statement-188 | SQL: SELECT 1 16:41:27.102 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 6 ms | Connection: statement-193 | SQL: SELECT 1 16:41:27.115 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 7 ms | Connection: statement-193 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:41:27.116 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 7 ms | Connection: statement-188 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:41:27.116 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 7 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:41:27.119 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:41:27 | Time Consuming: 10 ms | Connection: statement-192 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:41:35.037 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:41:35 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT 1 16:41:35.047 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:41:35 | Time Consuming: 4 ms | Connection: statement-189 | SQL: SELECT 1 16:41:35.048 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:41:35 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:41:35.058 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:41:35 | Time Consuming: 5 ms | Connection: statement-189 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:45:17.321 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT 1 16:45:17.321 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 5 ms | Connection: statement-193 | SQL: SELECT 1 16:45:17.333 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 5 ms | Connection: statement-193 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:45:17.334 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 7 ms | Connection: statement-192 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:45:17.345 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 3 ms | Connection: statement-195 | SQL: SELECT 1 16:45:17.356 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:45:17 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:45:22.343 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:45:22 | Time Consuming: 5001 ms | Connection: statement-194 | SQL: SELECT 1 16:45:22.350 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:45:22 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT 1 16:45:22.361 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:45:22 | Time Consuming: 6 ms | Connection: statement-192 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:45:23.987 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:45:23 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT 1 16:45:23.987 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:45:23 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT 1 16:45:23.997 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:45:23 | Time Consuming: 4 ms | Connection: statement-195 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:45:23.998 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:45:23 | Time Consuming: 5 ms | Connection: statement-192 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:46:41.859 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:46:41 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT 1 16:46:41.859 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:46:41 | Time Consuming: 5 ms | Connection: statement-193 | SQL: SELECT 1 16:46:41.870 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:46:41 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:46:41.870 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:46:41 | Time Consuming: 6 ms | Connection: statement-193 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:48:14.812 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:48:14 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT 1 16:48:14.812 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:48:14 | Time Consuming: 5 ms | Connection: statement-193 | SQL: SELECT 1 16:48:14.823 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:48:14 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:48:14.824 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:48:14 | Time Consuming: 6 ms | Connection: statement-193 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:48:23.986 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:48:23 | Time Consuming: 5 ms | Connection: statement-193 | SQL: SELECT 1 16:48:23.986 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:48:23 | Time Consuming: 5 ms | Connection: statement-195 | SQL: SELECT 1 16:48:23.997 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:48:23 | Time Consuming: 4 ms | Connection: statement-195 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:48:23.999 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:48:23 | Time Consuming: 6 ms | Connection: statement-193 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:03.401 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 5001 ms | Connection: statement-197 | SQL: SELECT 1 16:52:03.403 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 5000 ms | Connection: statement-198 | SQL: SELECT 1 16:52:03.407 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 5 ms | Connection: statement-199 | SQL: SELECT 1 16:52:03.410 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT 1 16:52:03.419 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 4 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:03.423 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:03 | Time Consuming: 6 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:52:57.248 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 6 ms | Connection: statement-199 | SQL: SELECT 1 16:52:57.248 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 6 ms | Connection: statement-200 | SQL: SELECT 1 16:52:57.258 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 4 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:52:57.258 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:57.281 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 4 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:52:57.281 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:52:57 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:53:17.690 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 6 ms | Connection: statement-199 | SQL: SELECT 1 16:53:17.690 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 6 ms | Connection: statement-200 | SQL: SELECT 1 16:53:17.705 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 6 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:53:17.706 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 7 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:53:17.709 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT 1 16:53:17.709 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT 1 16:53:17.722 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:53:17.726 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:17 | Time Consuming: 8 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:53:24.528 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:24 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT 1 16:53:24.530 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:24 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT 1 16:53:24.541 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:24 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:53:24.545 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:24 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:53:44.219 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT 1 16:53:44.219 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT 1 16:53:44.229 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:53:44.230 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 6 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:53:44.234 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 4 ms | Connection: statement-199 | SQL: SELECT 1 16:53:44.234 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 4 ms | Connection: statement-200 | SQL: SELECT 1 16:53:44.245 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 5 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:53:44.247 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:53:44 | Time Consuming: 7 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:31.809 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 5 ms | Connection: statement-199 | SQL: SELECT 1 16:54:31.809 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT 1 16:54:31.814 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 4 ms | Connection: statement-201 | SQL: SELECT 1 16:54:31.814 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT 1 16:54:31.818 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 4 ms | Connection: statement-199 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:31.821 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 7 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:54:31.823 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:54:31.825 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:54:31 | Time Consuming: 7 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:57:18.569 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:57:18 | Time Consuming: 6 ms | Connection: statement-201 | SQL: SELECT 1 16:57:18.581 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:57:18 | Time Consuming: 6 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:57:18.587 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:57:18 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT 1 16:57:18.598 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:57:18 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:57:57.035 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT 1 16:57:57.035 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT 1 16:57:57.045 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 5 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:57:57.046 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:57:57.055 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 6 ms | Connection: statement-200 | SQL: SELECT 1 16:57:57.066 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:57:57 | Time Consuming: 4 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:58:02.049 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:58:02 | Time Consuming: 5001 ms | Connection: statement-203 | SQL: SELECT 1 16:58:02.056 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:58:02 | Time Consuming: 6 ms | Connection: statement-200 | SQL: SELECT 1 16:58:02.068 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:58:02 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:58:18.290 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-200 | SQL: SELECT 1 16:58:18.290 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-201 | SQL: SELECT 1 16:58:18.298 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT 1 16:58:18.298 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-204 | SQL: SELECT 1 16:58:18.299 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:58:18.300 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:58:18.307 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:58:18.308 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:58:18 | Time Consuming: 4 ms | Connection: statement-204 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:59:42.439 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 4 ms | Connection: statement-204 | SQL: SELECT 1 16:59:42.439 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 4 ms | Connection: statement-202 | SQL: SELECT 1 16:59:42.442 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 4 ms | Connection: statement-200 | SQL: SELECT 1 16:59:42.442 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 4 ms | Connection: statement-201 | SQL: SELECT 1 16:59:42.448 [XNIO-1 task-13] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 4 ms | Connection: statement-204 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:59:42.449 [XNIO-1 task-9] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 6 ms | Connection: statement-202 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 16:59:42.452 [XNIO-1 task-4] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 5 ms | Connection: statement-200 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:59:42.452 [XNIO-1 task-3] INFO p6spy - 2023-06-29 16:59:42 | Time Consuming: 5 ms | Connection: statement-201 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:27:25.742 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:27:25 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT 1 17:27:25.751 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:27:25 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:27:25.770 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:27:25 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:28:51.821 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:28:51 | Time Consuming: 5 ms | Connection: statement-219 | SQL: SELECT 1 17:28:51.830 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:28:51 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:28:54.487 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:28:54 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT 1 17:28:54.495 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:28:54 | Time Consuming: 4 ms | Connection: statement-219 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:28:59.488 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:28:59 | Time Consuming: 5001 ms | Connection: statement-220 | SQL: SELECT 1 17:28:59.492 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:28:59 | Time Consuming: 3 ms | Connection: statement-219 | SQL: SELECT 1 17:28:59.501 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:28:59 | Time Consuming: 5 ms | Connection: statement-219 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:06.590 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 5001 ms | Connection: statement-221 | SQL: SELECT 1 17:30:06.590 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 5001 ms | Connection: statement-222 | SQL: SELECT 1 17:30:06.596 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 5 ms | Connection: statement-225 | SQL: SELECT 1 17:30:06.596 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT 1 17:30:06.606 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 4 ms | Connection: statement-225 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:06.608 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:06 | Time Consuming: 6 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:30:07.240 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:07 | Time Consuming: 4 ms | Connection: statement-225 | SQL: SELECT 1 17:30:07.240 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:07 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT 1 17:30:07.251 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:07 | Time Consuming: 5 ms | Connection: statement-225 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:07.251 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:07 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:30:10.040 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:10 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT 1 17:30:10.040 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:10 | Time Consuming: 4 ms | Connection: statement-225 | SQL: SELECT 1 17:30:10.052 [XNIO-1 task-4] INFO p6spy - 2023-06-29 17:30:10 | Time Consuming: 5 ms | Connection: statement-225 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:30:10.053 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:10 | Time Consuming: 6 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:27.005 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:27 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT 1 17:30:27.014 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:27 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:35.815 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:35 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT 1 17:30:35.825 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:35 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 AND goaf_orebelt = '3' AND goaf_orebody = '3' AND goaf_oreheight = '770' AND goaf_name = '32052' AND goaf_id = '440955' 17:30:42.246 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:42 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT 1 17:30:42.255 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:42 | Time Consuming: 4 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 17:30:52.780 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:52 | Time Consuming: 9 ms | Connection: statement-224 | SQL: SELECT 1 17:30:52.796 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:52 | Time Consuming: 7 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 AND goaf_orebelt = '3' AND goaf_orebody = '3' AND goaf_oreheight = '770' AND goaf_name = '32002' AND goaf_id = '440952' 17:30:58.450 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:58 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT 1 17:30:58.461 [XNIO-1 task-3] INFO p6spy - 2023-06-29 17:30:58 | Time Consuming: 5 ms | Connection: statement-224 | SQL: SELECT * FROM goaf_devinfo where oc_id = 406283 23:36:15.612 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 23:36:15.613 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final 23:36:15.619 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet' 23:36:15.622 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 23:36:15.622 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s). 23:36:15.622 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger' 23:36:15.667 [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) 23:36:15.668 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler 23:36:15.668 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down. 23:36:15.668 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused. 23:36:15.668 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete. 23:36:15.680 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated... 23:36:15.682 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.