16:19:01.729 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final 16:19:01.817 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 13140 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3) 16:19:01.818 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev" 16:19:01.908 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable 16:19:01.908 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG' 16:19:03.961 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode 16:19:03.965 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode. 16:19:04.058 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 74 ms. Found 0 Redis repository interfaces. 16:19:04.234 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created. 16:19:04.254 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created. 16:19:05.151 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 16:19:05.151 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 3242 ms 16:19:07.364 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor 16:19:07.374 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl 16:19:07.375 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created. 16:19:07.375 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized. 16:19:07.376 [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. 16:19:07.376 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance. 16:19:07.376 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2 16:19:07.376 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@20fe19df 16:19:09.373 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729 16:19:09.525 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link 16:19:09.571 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel 16:19:09.571 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s). 16:19:09.571 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger' 16:19:09.597 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 16:19:09.609 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final 16:19:09.623 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final 16:19:09.658 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final 16:19:09.722 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http) 16:19:09.879 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext 16:19:09.880 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 151 ms 16:19:09.889 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z' 16:19:09.927 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final 16:19:09.945 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8081 (http) 16:19:09.948 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now 16:19:09.948 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:09.985 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.893 seconds (process running for 10.302) 16:19:09.987 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务 16:19:09.996 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting... 16:19:10.400 [restartedMain] INFO p6spy - 2023-06-01 16:19:10 | Time Consuming: 16 ms | Connection: statement-0 | SQL: SELECT 1 16:19:10.412 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@58692e66 16:19:10.424 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed. 16:19:10.497 [restartedMain] INFO p6spy - 2023-06-01 16:19:10 | 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 16:19:10.521 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.523 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.523 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.523 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.523 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.524 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.524 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:10.524 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started. 16:19:11.014 [RMI TCP Connection(2)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet' 16:19:11.014 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet' 16:19:11.033 [RMI TCP Connection(2)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 19 ms 16:19:11.043 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-01 16:19:11 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 16:19:56.001 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 16:19:56.012 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 16:19:56.029 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 16:19:56.038 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.oc_id, A.oc_name, A.oc_type_id, A.root_id, A.parent_id, A.admin_id, B.account_name AS admin_name, A.group_id, A.node_left, A.node_right, A.node_level, A.is_leaf, A.status, A.if_lic FROM oc AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.admin_id = B.account_id) WHERE A.oc_id = 406283 16:19:56.043 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.rm_id, A.role_id, B.role_type_id, B.role_code, B.role_name, A.account_id FROM s_role_member AS A LEFT JOIN s_role AS B ON (A.role_id = B.role_id) WHERE account_id = 406283 LIMIT 1 16:19:56.048 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.gm_id, A.oc_id, A.group_id, B.group_name, B.node_left , B.node_right, A.account_id FROM s_group_member AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 LIMIT 1 16:19:56.054 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.gmp_id, A.oc_id, A.group_id, B.group_name, A.account_id, D.account_name, D.account_real_name, A.position_id, C.position_name FROM s_group_member_position A LEFT JOIN s_group B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) LEFT JOIN s_position C ON (A.oc_id = C.oc_id AND A.position_id = C.position_id) LEFT JOIN account D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 LIMIT 1 16:19:56.059 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 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 16:19:56.523 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 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' 16:19:56.539 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 16:19:56.701 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT 1 16:19:56.703 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT 1 16:19:56.703 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT 1 16:19:56.709 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:19:56.711 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:19:56.733 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 25 ms | Connection: statement-3 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 16:19:56.765 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:19:56.771 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:19:56 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:20:28.881 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 16:20:28.896 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 8 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' 16:20:28.920 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 6 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 16:20:28.927 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 6 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 16:20:28.934 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.rm_id, A.role_id, B.role_type_id, B.role_code, B.role_name, A.account_id FROM s_role_member AS A LEFT JOIN s_role AS B ON (A.role_id = B.role_id) WHERE account_id = 406283 LIMIT 1 16:20:28.940 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.gm_id, A.oc_id, A.group_id, B.group_name, B.node_left , B.node_right, A.account_id FROM s_group_member AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.group_id = B.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.account_id = 406283 LIMIT 1 16:20:28.948 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 6 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 16:20:28.956 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:28 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.gmpg_id, A.oc_id, A.group_id, A.account_id, A.position_id, A.grant_group_id, B.group_name AS grant_group_name FROM s_group_member_position_grant A LEFT JOIN s_group B ON(A.oc_id = B.oc_id AND A.grant_group_id = B.group_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.group_id = 406283 AND A.account_id = 406283 AND A.position_id = 406283 LIMIT 1 16:20:29.004 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 16:20:29.026 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 16:20:29.200 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT 1 16:20:29.200 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT 1 16:20:29.201 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT 1 16:20:29.207 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:20:29.213 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:20:29.213 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:20:29.221 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 6 ms | Connection: statement-3 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:20:29.234 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:20:29 | Time Consuming: 26 ms | Connection: statement-1 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 16:20:40.829 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1 16:20:40.830 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1 16:20:40.830 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 16:20:40.830 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 16:20:40.846 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 13 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:20:40.849 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 6 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:20:40.893 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:20:40.898 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:40 | 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) table_count 16:20:40.901 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:20:40.907 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:40 | Time Consuming: 6 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 ORDER BY A.account_id, A.group_id LIMIT 999999 16:20:43.679 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-3 | SQL: SELECT 1 16:20:43.679 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 16:20:43.690 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 5 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 16:20:43.695 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 16:20:43.704 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.hdanger_id = 440772 16:20:43.722 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:20:43.729 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 5 ms | Connection: statement-2 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:20:43.758 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, B.oc_name, A.wf_def_id, A.wf_ins_id, A.wf_ins_title, A.status, A.begin_time, A.finish_time, A.cur_activity_ins_id, A.cur_activity_code, A.cur_activity_title, A.cur_activity_begin_time, A.cur_form_code, A.cur_group_id, A.cur_position_id, A.cur_account_id, A.cur_group_name, A.cur_position_name, A.cur_account_name FROM wf_ins AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 16:20:43.765 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.wf_def_id, A.activity_def_id, A.wf_ins_id, A.activity_ins_id, A.activity_ins_title, A.activity_code, A.form_code, A.start_time, A.end_time, A.status, A.group_id, A.group_name, A.position_id, A.position_name, A.account_id, A.account_name, A.activity_ins_from, A.activity_ins_to FROM wf_activity_ins AS A WHERE A.oc_id = 406283 AND A.deleted_flag = 0 AND A.status = 0 AND A.wf_ins_id = 440772 16:20:43.772 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT A.wf_def_id, A.activity_def_id, A.action_id, A.action_title, A.action_desc, A.action_code, A.form_code, A.target_activity_def_id, B.activity_def_title AS target_activity_def_title FROM wf_activity_action_def AS A LEFT JOIN wf_activity_def AS B ON (A.wf_def_id = B.wf_def_id AND A.target_activity_def_id = B.activity_def_id) WHERE A.deleted_flag = 0 AND A.wf_def_id = 1 AND A.activity_def_id = 2 ORDER BY A.action_id 16:20:43.778 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.wf_def_id, A.wf_ins_id, A.activity_def_id, A.activity_ins_id, B.activity_ins_title, B.activity_ins_from, B.activity_ins_to, B.activity_code, A.action_ins_id, A.action_id, A.action_title, A.action_remark, A.action_code, A.form_code, A.action_result, A.target_activity_ins_id, A.action_time, A.group_id, A.group_name, A.position_id, A.position_name, A.account_id, A.account_name FROM wf_activity_action_ins AS A LEFT JOIN wf_activity_ins AS B ON (A.oc_id = B.oc_id AND A.wf_ins_id = B.wf_ins_id AND A.activity_ins_id= B.activity_ins_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_position AS D ON (A.oc_id = D.oc_id AND A.position_id = D.position_id) LEFT JOIN account AS E ON (A.oc_id = E.oc_id AND A.account_id = E.account_id ) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 ORDER BY A.action_time DESC 16:20:43.784 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.wf_ins_id, A.activity_ins_id, A.activity_code, A.file_id, B.file_title, B.dir_id, B.file_icon, B.file_url, B.file_ext, B.file_size, B.file_author, B.file_desc, B.uploaded_by AS uploader_id, C.account_name AS uploader_name, B.uploaded_at FROM wf_ins_attach AS A LEFT JOIN doc_file AS B ON(A.oc_id = B.oc_id AND A.file_id = B.file_id) LEFT JOIN account AS C ON(B.oc_id = C.oc_id AND B.uploaded_by = C.account_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 ORDER BY file_id ASC 16:20:43.817 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, B.oc_name, A.wf_def_id, A.wf_ins_id, A.wf_ins_title, A.status, A.begin_time, A.finish_time, A.cur_activity_ins_id, A.cur_activity_code, A.cur_activity_title, A.cur_activity_begin_time, A.cur_form_code, A.cur_group_id, A.cur_position_id, A.cur_account_id, A.cur_group_name, A.cur_position_name, A.cur_account_name FROM wf_ins AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 16:20:43.822 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 3 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.wf_def_id, A.activity_def_id, A.wf_ins_id, A.activity_ins_id, A.activity_ins_title, A.activity_code, A.form_code, A.start_time, A.end_time, A.status, A.group_id, A.group_name, A.position_id, A.position_name, A.account_id, A.account_name, A.activity_ins_from, A.activity_ins_to FROM wf_activity_ins AS A WHERE A.oc_id = 406283 AND A.deleted_flag = 0 AND A.status = 0 AND A.wf_ins_id = 440772 16:20:43.827 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.wf_def_id, A.activity_def_id, A.action_id, A.action_title, A.action_desc, A.action_code, A.form_code, A.target_activity_def_id, B.activity_def_title AS target_activity_def_title FROM wf_activity_action_def AS A LEFT JOIN wf_activity_def AS B ON (A.wf_def_id = B.wf_def_id AND A.target_activity_def_id = B.activity_def_id) WHERE A.deleted_flag = 0 AND A.wf_def_id = 1 AND A.activity_def_id = 2 ORDER BY A.action_id 16:20:43.833 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.wf_def_id, A.wf_ins_id, A.activity_def_id, A.activity_ins_id, B.activity_ins_title, B.activity_ins_from, B.activity_ins_to, B.activity_code, A.action_ins_id, A.action_id, A.action_title, A.action_remark, A.action_code, A.form_code, A.action_result, A.target_activity_ins_id, A.action_time, A.group_id, A.group_name, A.position_id, A.position_name, A.account_id, A.account_name FROM wf_activity_action_ins AS A LEFT JOIN wf_activity_ins AS B ON (A.oc_id = B.oc_id AND A.wf_ins_id = B.wf_ins_id AND A.activity_ins_id= B.activity_ins_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_position AS D ON (A.oc_id = D.oc_id AND A.position_id = D.position_id) LEFT JOIN account AS E ON (A.oc_id = E.oc_id AND A.account_id = E.account_id ) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 ORDER BY A.action_time DESC 16:20:43.839 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:43 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT A.oc_id, A.wf_ins_id, A.activity_ins_id, A.activity_code, A.file_id, B.file_title, B.dir_id, B.file_icon, B.file_url, B.file_ext, B.file_size, B.file_author, B.file_desc, B.uploaded_by AS uploader_id, C.account_name AS uploader_name, B.uploaded_at FROM wf_ins_attach AS A LEFT JOIN doc_file AS B ON(A.oc_id = B.oc_id AND A.file_id = B.file_id) LEFT JOIN account AS C ON(B.oc_id = C.oc_id AND B.uploaded_by = C.account_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 ORDER BY file_id ASC 16:20:48.506 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:20:48 | Time Consuming: 4 ms | Connection: statement-2 | SQL: SELECT 1 16:23:13.362 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1 16:23:13.362 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 5 ms | Connection: statement-1 | SQL: SELECT 1 16:23:13.363 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 3 ms | Connection: statement-3 | SQL: SELECT 1 16:23:13.370 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:23:13.371 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:23:13.387 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 ms | Connection: statement-1 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:23:13.391 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT count(0) FROM goaf_check_def WHERE 1 = 1 AND oc_id = 406283 16:23:13.396 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT * FROM goaf_check_def WHERE 1=1 AND oc_id = 406283 LIMIT 10 16:23:13.403 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:23:13 | 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) table_count 16:23:13.411 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 6 ms | Connection: statement-1 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:23:13.411 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 6 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 ORDER BY A.account_id, A.group_id LIMIT 999999 16:23:13.416 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:23:13.428 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 3 ms | Connection: statement-1 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:23:13.454 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 4 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) table_count 16:23:13.462 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:23:13 | Time Consuming: 6 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 ORDER BY A.account_id, A.group_id LIMIT 999999 16:23:21.934 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:23:21 | Time Consuming: 8574 ms | Connection: statement-4 | SQL: SELECT 1 16:23:21.938 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:23:21 | Time Consuming: 3 ms | Connection: statement-0 | SQL: SELECT 1 16:23:21.946 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:23:21 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:25:29.936 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:25:29 | Time Consuming: 18938 ms | Connection: statement-2 | SQL: replace into uid_sequence(stub) values('a') 16:25:29.976 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:25:29 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1 16:30:13.297 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:30:13 | Time Consuming: 5010 ms | Connection: statement-6 | SQL: SELECT 1 16:30:18.298 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:30:18 | Time Consuming: 5001 ms | Connection: statement-7 | SQL: SELECT 1 16:30:18.303 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:30:18 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT 1 16:31:07.050 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT 1 16:31:07.050 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 5 ms | Connection: statement-10 | SQL: SELECT 1 16:31:07.050 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 5 ms | Connection: statement-12 | SQL: SELECT 1 16:31:07.059 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:07.060 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:31:07.085 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 6 ms | Connection: statement-12 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:31:07.092 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:07 | Time Consuming: 5 ms | Connection: statement-12 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:31:12.046 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:12 | Time Consuming: 5000 ms | Connection: statement-11 | SQL: SELECT 1 16:31:12.051 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:12 | Time Consuming: 3 ms | Connection: statement-10 | SQL: SELECT 1 16:31:12.085 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:12 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:31:12.094 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:12 | Time Consuming: 7 ms | Connection: statement-10 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:31:13.906 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-12 | SQL: SELECT 1 16:31:13.906 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT 1 16:31:13.907 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT 1 16:31:13.907 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 3 ms | Connection: statement-14 | SQL: SELECT 1 16:31:13.908 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1 16:31:13.908 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 3 ms | Connection: statement-16 | SQL: SELECT 1 16:31:13.914 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-12 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:13.915 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 3 ms | Connection: statement-13 | SQL: SELECT count(0) FROM goaf_check_def WHERE 1 = 1 AND oc_id = 406283 16:31:13.915 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:31:13.916 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-14 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:31:13.918 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 5 ms | Connection: statement-15 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:13.947 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 5 ms | Connection: statement-16 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:31:13.965 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 4 ms | Connection: statement-10 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:31:13.978 [XNIO-1 task-8] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 29 ms | Connection: statement-16 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:31:13.994 [XNIO-1 task-6] INFO p6spy - 2023-06-01 16:31:13 | Time Consuming: 27 ms | Connection: statement-10 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:31:14.147 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 211 ms | Connection: statement-15 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:31:14.153 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 217 ms | Connection: statement-14 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:31:14.176 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 240 ms | Connection: statement-12 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:14.289 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 373 ms | Connection: statement-13 | SQL: SELECT * FROM goaf_check_def WHERE 1=1 AND oc_id = 406283 LIMIT 10 16:31:14.309 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 8 ms | Connection: statement-9 | SQL: replace into uid_sequence(stub) values('a') 16:31:14.313 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 3 ms | Connection: statement-9 | SQL: SELECT LAST_INSERT_ID() AS uid 16:31:14.328 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:31:14 | Time Consuming: 10 ms | Connection: statement-9 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440780, '20205300442259453.jpg', 10000, 'jpg', 140755, '20205300442259453.jpg', 406283, '2023-06-01T16:31:14.314003800', 406283, '2023-06-01T16:31:14.314003800' ) 16:31:15.527 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:15 | Time Consuming: 4 ms | Connection: statement-13 | SQL: SELECT 1 16:31:15.562 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:15 | Time Consuming: 5 ms | Connection: statement-13 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 16:31:15.579 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:15 | Time Consuming: 15 ms | Connection: statement-13 | 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 ORDER BY A.submit_time DESC LIMIT 10 16:31:19.339 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT 1 16:31:19.339 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-14 | SQL: SELECT 1 16:31:19.339 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT 1 16:31:19.339 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-13 | SQL: SELECT 1 16:31:19.339 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT 1 16:31:19.347 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-9 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:31:19.347 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-13 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:31:19.347 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-15 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:31:19.351 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 7 ms | Connection: statement-12 | SQL: replace into uid_sequence(stub) values('a') 16:31:19.355 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-12 | SQL: SELECT LAST_INSERT_ID() AS uid 16:31:19.359 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT wf_def_id, wf_def_title, wf_def_desc FROM wf_def WHERE 1 = 1 AND wf_def_id = 1 16:31:19.368 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 7 ms | Connection: statement-12 | SQL: INSERT INTO wf_ins ( oc_id, wf_def_id, wf_ins_id, wf_ins_title, status , begin_time , created_by, created_at ) values ( 406283, 1, 440781, '隐患整改流程', 0, '2023-06-01T16:31:19.360157700', 406283, '2023-06-01T16:31:19.360157700' ) 16:31:19.372 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT wf_def_id , activity_def_id, activity_def_title, activity_def_desc, activity_code, form_code FROM wf_activity_def WHERE deleted_flag = 0 AND wf_def_id = 1 AND activity_def_id = 1 16:31:19.373 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 5 ms | Connection: statement-14 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:31:19.379 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 5 ms | Connection: statement-14 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:31:19.383 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 7 ms | Connection: statement-12 | SQL: INSERT INTO wf_activity_ins ( oc_id, wf_def_id, activity_def_id, wf_ins_id, activity_ins_id, activity_ins_title, activity_code, form_code, status, group_id, position_id, account_id, group_name, position_name, account_name, start_time, created_by, created_at ) values ( 406283, 1, 1, 440781, 440781, '提交隐患', 'submit', 'submit', 0, 406283, 406283, 406283, '泾阳水泥有限公司', '管理员', 'admin003', '2023-06-01T16:31:19.373183100', 406283, '2023-06-01T16:31:19.373183100' ) 16:31:19.388 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:19 | Time Consuming: 4 ms | Connection: statement-12 | SQL: SELECT A.wf_def_id, A.activity_def_id, A.action_id, A.action_title, A.action_desc, A.action_code, A.form_code, A.target_activity_def_id, B.activity_def_title AS target_activity_def_title FROM wf_activity_action_def AS A LEFT JOIN wf_activity_def AS B ON (A.wf_def_id = B.wf_def_id AND A.target_activity_def_id = B.activity_def_id) WHERE A.deleted_flag = 0 AND A.wf_def_id = 1 AND A.activity_def_id = 1 ORDER BY A.action_id 16:31:24.262 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:31:24 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT 1 16:32:06.454 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:32:06 | Time Consuming: 7 ms | Connection: statement-12 | SQL: replace into uid_sequence(stub) values('a') 16:32:06.458 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:32:06 | Time Consuming: 3 ms | Connection: statement-12 | SQL: SELECT LAST_INSERT_ID() AS uid 16:32:06.467 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:32:06 | Time Consuming: 7 ms | Connection: statement-12 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440782, 'avatar.png', 10000, 'png', 129167, 'avatar.png', 406283, '2023-06-01T16:32:06.458450800', 406283, '2023-06-01T16:32:06.458450800' ) 16:38:38.783 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:38:38 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT 1 16:39:21.064 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:39:21 | Time Consuming: 9 ms | Connection: statement-17 | SQL: replace into uid_sequence(stub) values('a') 16:39:21.068 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:39:21 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT LAST_INSERT_ID() AS uid 16:39:21.079 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:39:21 | Time Consuming: 9 ms | Connection: statement-17 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440783, '20205300442259453.jpg', 10000, 'jpg', 140755, '20205300442259453.jpg', 406283, '2023-06-01T16:39:21.069343500', 406283, '2023-06-01T16:39:21.069343500' ) 16:41:02.272 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:41:02 | Time Consuming: 5 ms | Connection: statement-17 | SQL: SELECT 1 16:41:02.719 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:41:02 | Time Consuming: 9 ms | Connection: statement-17 | SQL: replace into uid_sequence(stub) values('a') 16:41:02.724 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:41:02 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT LAST_INSERT_ID() AS uid 16:41:02.738 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:41:02 | Time Consuming: 9 ms | Connection: statement-17 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440785, '20205300442259453.jpg', 10000, 'http://113.141.93.143:9000/file/202361164124003344.jpg', 'http://113.141.93.143:9000/icon/202361164126832833.jpg', 'jpg', 140755, '20205300442259453.jpg', 406283, '2023-06-01T16:41:02.724930500', 406283, '2023-06-01T16:41:02.724930500' ) 16:41:16.413 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:41:16 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT 1 16:41:16.546 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:41:16 | Time Consuming: 7 ms | Connection: statement-17 | SQL: replace into uid_sequence(stub) values('a') 16:41:16.550 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:41:16 | Time Consuming: 3 ms | Connection: statement-17 | SQL: SELECT LAST_INSERT_ID() AS uid 16:41:16.561 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:41:16 | Time Consuming: 9 ms | Connection: statement-17 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440786, 'avatar.png', 10000, 'http://113.141.93.143:9000/file/202361164116457646.jpg', 'http://113.141.93.143:9000/icon/2023611641165102179.jpg', 'png', 129167, 'avatar.png', 406283, '2023-06-01T16:41:16.550834200', 406283, '2023-06-01T16:41:16.550834200' ) 16:42:07.663 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:07 | Time Consuming: 5 ms | Connection: statement-17 | SQL: SELECT 1 16:42:08.823 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT 1 16:42:08.835 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:08.854 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 5 ms | Connection: statement-17 | 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 16:42:08.860 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:08.865 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:08.870 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:08.876 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:08.882 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:08.927 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:08.947 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:08 | Time Consuming: 4 ms | Connection: statement-17 | 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 16:42:09.062 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 3 ms | Connection: statement-19 | SQL: SELECT 1 16:42:09.064 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 3 ms | Connection: statement-20 | SQL: SELECT 1 16:42:09.064 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:42:09.070 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 5 ms | Connection: statement-17 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:42:09.070 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 4 ms | Connection: statement-19 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:42:09.094 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:42:09 | Time Consuming: 26 ms | Connection: statement-20 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 16:42:13.112 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:42:13 | Time Consuming: 4 ms | Connection: statement-20 | SQL: SELECT 1 16:42:14.054 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:14 | Time Consuming: 5001 ms | Connection: statement-18 | SQL: SELECT 1 16:42:14.058 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:14 | Time Consuming: 3 ms | Connection: statement-17 | SQL: SELECT 1 16:42:14.068 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:14 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:42:15.278 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-17 | SQL: SELECT 1 16:42:15.287 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 3 ms | Connection: statement-17 | 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:42:15.305 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 16:42:15.311 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:15.316 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:15.322 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:15.329 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 6 ms | Connection: statement-17 | 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:42:15.335 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | 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:42:15.378 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-17 | 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:42:15.396 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | 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 16:42:15.490 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-20 | SQL: SELECT 1 16:42:15.491 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-19 | SQL: SELECT 1 16:42:15.492 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 4 ms | Connection: statement-22 | SQL: SELECT 1 16:42:15.495 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 3 ms | Connection: statement-17 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:42:15.499 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 3 ms | Connection: statement-22 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:42:15.500 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-20 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:42:15.501 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 5 ms | Connection: statement-17 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:42:15.522 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:42:15 | Time Consuming: 26 ms | Connection: statement-19 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 16:47:12.720 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:47:12 | Time Consuming: 5002 ms | Connection: statement-23 | SQL: SELECT 1 16:47:12.725 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:47:12 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT 1 16:47:12.908 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:47:12 | Time Consuming: 7 ms | Connection: statement-24 | SQL: replace into uid_sequence(stub) values('a') 16:47:12.912 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:47:12 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT LAST_INSERT_ID() AS uid 16:47:12.924 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:47:12 | Time Consuming: 8 ms | Connection: statement-24 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440787, '2020528223602757.jpg', 10000, 'http://113.141.93.143:9000/file/2023611647128042474.jpg', 'http://113.141.93.143:9000/icon/2023611647128795822.jpg', 'jpg', 220341, '2020528223602757.jpg', 406283, '2023-06-01T16:47:12.912254300', 406283, '2023-06-01T16:47:12.912254300' ) 16:47:47.433 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:47:47 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT 1 16:47:47.813 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:47:47 | Time Consuming: 8 ms | Connection: statement-24 | SQL: replace into uid_sequence(stub) values('a') 16:47:47.817 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:47:47 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT LAST_INSERT_ID() AS uid 16:47:47.828 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:47:47 | Time Consuming: 9 ms | Connection: statement-24 | SQL: INSERT INTO doc_file ( oc_id, file_id, file_title, dir_id, file_url, file_icon, file_ext, file_size, file_desc, uploaded_by, uploaded_at, created_by, created_at ) values ( 406283, 440788, '202052760591712127.jpg', 10000, 'http://113.141.93.143:9000/file/2023611647476033948.jpg', 'http://113.141.93.143:9000/icon/2023611647477784913.jpg', 'jpg', 114226, '202052760591712127.jpg', 406283, '2023-06-01T16:47:47.817991900', 406283, '2023-06-01T16:47:47.817991900' ) 16:48:12.438 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:12 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT 1 16:48:12.447 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:12 | Time Consuming: 4 ms | Connection: statement-24 | 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 16:48:12.485 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:12 | Time Consuming: 6 ms | Connection: statement-24 | 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 <= 14) table_count 16:48:12.491 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:12 | Time Consuming: 5 ms | Connection: statement-24 | 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 <= 14 ORDER BY A.account_id, A.group_id LIMIT 999999 16:48:16.880 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT 1 16:48:16.891 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 7 ms | Connection: statement-24 | SQL: replace into uid_sequence(stub) values('a') 16:48:16.895 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT LAST_INSERT_ID() AS uid 16:48:16.900 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT A.wf_def_id, A.activity_def_id, A.action_id, A.action_title, A.action_desc, A.action_code, A.form_code, A.target_activity_def_id, B.activity_def_title AS target_activity_def_title FROM wf_activity_action_def AS A LEFT JOIN wf_activity_def AS B ON (A.wf_def_id = B.wf_def_id AND A.target_activity_def_id = B.activity_def_id) WHERE A.deleted_flag = 0 AND A.wf_def_id = 1 AND A.activity_def_id = 2 AND A.action_id = 1 16:48:16.912 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 9 ms | Connection: statement-24 | SQL: INSERT INTO wf_activity_action_ins ( oc_id, wf_def_id, activity_def_id, wf_ins_id, activity_ins_id, action_ins_id, action_id, action_title, action_remark, action_code, form_code, action_time, group_id, position_id, account_id, group_name, position_name, account_name, created_by, created_at ) values ( 406283, 1, 2, 440772, 440774, 440789, 1, '提交', '123', 'submit', '-', '2023-06-01T16:48:16.901618800', 406283, 406283, 406283, '泾阳水泥有限公司', '管理员', 'admin003', 406283, '2023-06-01T16:48:16.901618800' ) 16:48:16.921 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 7 ms | Connection: statement-24 | SQL: replace into uid_sequence(stub) values('a') 16:48:16.925 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT LAST_INSERT_ID() AS uid 16:48:16.933 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 6 ms | Connection: statement-24 | SQL: UPDATE wf_activity_ins SET status = 1, end_time = '2023-06-01T16:48:16.925873', activity_ins_to = 440790, updated_by = 406283, updated_at = '2023-06-01T16:48:16.925873' WHERE oc_id = 406283 AND wf_ins_id = 440772 AND activity_ins_id = 440774 16:48:16.943 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 7 ms | Connection: statement-24 | SQL: DELETE FROM wf_ins_attach WHERE 1 = 1 AND oc_id = 406283 AND wf_ins_id = 440772 AND activity_ins_id = 440774 16:48:16.952 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 7 ms | Connection: statement-24 | SQL: INSERT INTO wf_ins_attach ( oc_id, wf_ins_id, activity_ins_id, file_id, created_by, created_at ) values ( 406283, 440772, 440774, 440785, 406283, '2023-06-01T16:48:16.943870100' ) 16:48:16.961 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 7 ms | Connection: statement-24 | SQL: INSERT INTO wf_ins_attach ( oc_id, wf_ins_id, activity_ins_id, file_id, created_by, created_at ) values ( 406283, 440772, 440774, 440788, 406283, '2023-06-01T16:48:16.952671700' ) 16:48:16.967 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT wf_def_id , activity_def_id, activity_def_title, activity_def_desc, activity_code, form_code FROM wf_activity_def WHERE deleted_flag = 0 AND wf_def_id = 1 AND activity_def_id = 3 16:48:16.979 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 8 ms | Connection: statement-24 | SQL: INSERT INTO wf_activity_ins ( oc_id, wf_def_id, activity_def_id, wf_ins_id, activity_ins_id, activity_ins_title, activity_code, form_code, status, group_id, position_id, account_id, group_name, position_name, account_name, start_time, activity_ins_from, created_by, created_at ) values ( 406283, 1, 3, 440772, 440790, '整改', 'rectify', 'recity', 0, 406283, 406283, 406283, '泾阳水泥有限公司', '管理员', 'admin003', '2023-06-01T16:48:16.968825100', 440774, 406283, '2023-06-01T16:48:16.968825100' ) 16:48:16.993 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 9 ms | Connection: statement-24 | SQL: UPDATE wf_ins SET status = 1, cur_group_id = 406283 , cur_position_id = 406283 , cur_account_id = 406283 , cur_group_name = '泾阳水泥有限公司' , cur_position_name = '管理员' , cur_account_name = 'admin003' , cur_activity_ins_id = 440790 , cur_activity_code = 'rectify' , cur_activity_title = '整改' , cur_form_code = 'recity' , cur_activity_begin_time = '2023-06-01T16:48:16.979788800', updated_by = 406283, updated_at = '2023-06-01T16:48:16.979788800' WHERE 1 = 1 AND oc_id = 406283 AND wf_ins_id = 440772 16:48:16.999 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:16 | Time Consuming: 5 ms | Connection: statement-24 | SQL: SELECT A.oc_id, B.oc_name, A.wf_def_id, A.wf_ins_id, A.wf_ins_title, A.status, A.begin_time, A.finish_time, A.cur_activity_ins_id, A.cur_activity_code, A.cur_activity_title, A.cur_activity_begin_time, A.cur_form_code, A.cur_group_id, A.cur_position_id, A.cur_account_id, A.cur_group_name, A.cur_position_name, A.cur_account_name FROM wf_ins AS A LEFT JOIN oc AS B ON (A.oc_id = B.oc_id) WHERE A.deleted_flag = 0 AND A.oc_id = 406283 AND A.wf_ins_id = 440772 16:48:17.049 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:17 | Time Consuming: 7 ms | Connection: statement-24 | SQL: UPDATE goaf_hdanger SET hdanger_level = 1, hdanger_desc = '采空区3-12-121-3-1上的传感器harmfulGas_001异常预警; 上报数值为：990.66; 告警阈值为：10.00; 传感器类型：有害气体传感器; 传感器安装位置：东北角', danger_deadline = '2023-06-02T00:00', review_remark = '123', rectify_group_id = 406283, rectify_group_name = '泾阳水泥有限公司', rectify_position_id = 406283, rectify_position_name = '管理员', rectify_account_id = 406283, rectify_account_name = 'admin003', status = 2 WHERE hdanger_id = 440772 16:48:17.145 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:17 | Time Consuming: 4 ms | Connection: statement-24 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:48:17.154 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:48:17 | Time Consuming: 7 ms | Connection: statement-24 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:51:46.336 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:51:46 | Time Consuming: 39 ms | Connection: statement-24 | SQL: SELECT 1 16:51:46.345 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:51:46 | Time Consuming: 4 ms | Connection: statement-24 | 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:51:46.363 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:51:46 | Time Consuming: 5 ms | Connection: statement-24 | 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 16:51:46.533 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:51:46 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 16:51:46.539 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:51:46 | Time Consuming: 5 ms | Connection: statement-24 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 16:51:51.528 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 5002 ms | Connection: statement-28 | SQL: SELECT 1 16:51:51.528 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 5002 ms | Connection: statement-27 | SQL: SELECT 1 16:51:51.528 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 5002 ms | Connection: statement-25 | SQL: SELECT 1 16:51:51.532 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT 1 16:51:51.563 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 26 ms | Connection: statement-24 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 16:51:51.577 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:51:51 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:51:56.530 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:51:56 | Time Consuming: 5001 ms | Connection: statement-29 | SQL: SELECT 1 16:51:56.534 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:51:56 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT 1 16:51:56.541 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:51:56 | Time Consuming: 3 ms | Connection: statement-24 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:52:24.652 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:24 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT 1 16:52:24.663 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:24 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT count(0) FROM goaf_checklist WHERE oc_id = 406283 16:52:24.667 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:24 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 LIMIT 10 16:52:26.784 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-31 | SQL: SELECT 1 16:52:26.784 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-30 | SQL: SELECT 1 16:52:26.784 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT 1 16:52:26.791 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT 1 16:52:26.791 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:52:26.794 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-31 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:52:26.794 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-30 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:26.799 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT * FROM goaf_syscfg WHERE oc_id = 406283 16:52:26.804 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-34 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:52:26.808 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:52:26.826 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 6 ms | Connection: statement-32 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:52:26.832 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:26 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:52:33.109 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT 1 16:52:33.109 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 3 ms | Connection: statement-32 | SQL: SELECT 1 16:52:33.109 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT 1 16:52:33.109 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:52:33.110 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT 1 16:52:33.118 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT * FROM goaf_syscfg WHERE oc_id = 406283 16:52:33.118 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:33.119 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:52:33.120 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:52:33.124 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 3 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:52:33.149 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 5 ms | Connection: statement-31 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:52:33.155 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:33 | Time Consuming: 5 ms | Connection: statement-31 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:52:36.133 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:36 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT 1 16:52:36.142 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:36 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT count(0) FROM goaf_sensordata WHERE oc_id = 406283 16:52:36.147 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:36 | Time Consuming: 4 ms | Connection: statement-31 | SQL: SELECT * FROM goaf_sensordata WHERE oc_id = 406283 ORDER BY goaf_datareport_time DESC LIMIT 10 16:52:37.623 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:37 | Time Consuming: 4 ms | Connection: statement-31 | SQL: SELECT 1 16:52:37.633 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:37 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:52:37.640 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:37 | Time Consuming: 6 ms | Connection: statement-31 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:52:39.297 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT 1 16:52:39.297 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:52:39.298 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-31 | SQL: SELECT 1 16:52:39.298 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT 1 16:52:39.298 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT 1 16:52:39.305 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT * FROM goaf_syscfg WHERE oc_id = 406283 16:52:39.305 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:39.306 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 3 ms | Connection: statement-32 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:52:39.306 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:52:39.312 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:52:39.342 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 5 ms | Connection: statement-33 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:52:39.349 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:39 | Time Consuming: 6 ms | Connection: statement-33 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:52:42.546 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 3 ms | Connection: statement-32 | SQL: SELECT 1 16:52:42.546 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:52:42.546 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT 1 16:52:42.546 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT 1 16:52:42.554 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:42.554 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:52:42.596 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:52:42.596 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:52:42.603 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 5 ms | Connection: statement-34 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:52:42.604 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:42 | Time Consuming: 7 ms | Connection: statement-30 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:52:48.274 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT 1 16:52:48.274 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT 1 16:52:48.274 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT 1 16:52:48.279 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT 1 16:52:48.284 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 4 ms | Connection: statement-30 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:52:48.284 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 5 ms | Connection: statement-34 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:52:48.333 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:52:48.334 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '2' 16:52:48.340 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:52:48.342 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:52:48 | Time Consuming: 6 ms | Connection: statement-33 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '2' ORDER BY A.submit_time DESC LIMIT 10 16:53:09.607 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:53:09 | Time Consuming: 6 ms | Connection: statement-33 | SQL: SELECT 1 16:53:09.621 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:53:09 | Time Consuming: 7 ms | Connection: statement-33 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:53:09.674 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:53:09 | Time Consuming: 5 ms | Connection: statement-33 | 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 16:53:09.704 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:53:09 | Time Consuming: 5 ms | Connection: statement-33 | 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 <= 14) table_count 16:53:09.710 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:53:09 | Time Consuming: 5 ms | Connection: statement-33 | 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 <= 14 ORDER BY A.account_id, A.group_id LIMIT 10 16:54:48.026 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:54:48.026 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT 1 16:54:48.027 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT 1 16:54:48.027 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT 1 16:54:48.072 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 5 ms | Connection: statement-30 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:48.073 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:54:48.111 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 38 ms | Connection: statement-30 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:48.255 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 225 ms | Connection: statement-34 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:48.286 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 255 ms | Connection: statement-33 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:48.791 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:48 | Time Consuming: 717 ms | Connection: statement-32 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 16:54:50.019 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT 1 16:54:50.020 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 5 ms | Connection: statement-34 | SQL: SELECT 1 16:54:50.020 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 5 ms | Connection: statement-30 | SQL: SELECT 1 16:54:50.020 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT 1 16:54:50.023 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT 1 16:54:50.027 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT * FROM goaf_syscfg WHERE oc_id = 406283 16:54:50.028 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:54:50.062 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 6 ms | Connection: statement-31 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:50.107 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 44 ms | Connection: statement-31 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:50.251 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:50 | Time Consuming: 227 ms | Connection: statement-33 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:51.577 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:51 | Time Consuming: 1549 ms | Connection: statement-30 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:54:51.597 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:51 | Time Consuming: 1573 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:52.063 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT 1 16:54:52.063 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT 1 16:54:52.063 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 4 ms | Connection: statement-31 | SQL: SELECT 1 16:54:52.068 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 5 ms | Connection: statement-32 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:52.069 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 6 ms | Connection: statement-30 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:52.071 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:54:52.072 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 3 ms | Connection: statement-33 | SQL: SELECT count(0) FROM goaf_check_def WHERE 1 = 1 AND oc_id = 406283 16:54:52.077 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT * FROM goaf_check_def WHERE 1=1 AND oc_id = 406283 LIMIT 10 16:54:52.104 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 6 ms | Connection: statement-31 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:52.120 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 27 ms | Connection: statement-30 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:52.148 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 41 ms | Connection: statement-31 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:52.208 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 6 ms | Connection: statement-31 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:52.215 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 5 ms | Connection: statement-31 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:52.308 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 214 ms | Connection: statement-34 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 16:54:52.779 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 685 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:52.803 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:52 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:57.128 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT 1 16:54:57.129 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT 1 16:54:57.129 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 3 ms | Connection: statement-34 | SQL: SELECT 1 16:54:57.129 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 3 ms | Connection: statement-32 | SQL: SELECT 1 16:54:57.129 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 2 ms | Connection: statement-33 | SQL: SELECT 1 16:54:57.138 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 4 ms | Connection: statement-31 | SQL: SELECT count(0) FROM goaf_devinfo WHERE oc_id = 406283 16:54:57.138 [XNIO-1 task-2] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 4 ms | Connection: statement-34 | SQL: SELECT * FROM goaf_syscfg WHERE oc_id = 406283 16:54:57.138 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:57.166 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 5 ms | Connection: statement-33 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:57.170 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 31 ms | Connection: statement-31 | SQL: SELECT * FROM goaf_devinfo WHERE oc_id = 406283 LIMIT 10 16:54:57.174 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 6 ms | Connection: statement-33 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:57.357 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:57 | Time Consuming: 222 ms | Connection: statement-30 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:59.363 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 3 ms | Connection: statement-31 | SQL: SELECT 1 16:54:59.364 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 4 ms | Connection: statement-32 | SQL: SELECT 1 16:54:59.364 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT 1 16:54:59.364 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 3 ms | Connection: statement-30 | SQL: SELECT 1 16:54:59.374 [XNIO-1 task-7] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 6 ms | Connection: statement-32 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 16:54:59.375 [XNIO-1 task-4] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 7 ms | Connection: statement-31 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 16:54:59.429 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 5 ms | Connection: statement-30 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 16:54:59.430 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 4 ms | Connection: statement-33 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 16:54:59.694 [XNIO-1 task-3] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 264 ms | Connection: statement-30 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 16:54:59.739 [XNIO-1 task-5] INFO p6spy - 2023-06-01 16:54:59 | Time Consuming: 307 ms | Connection: statement-33 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 17:27:23.991 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:23 | Time Consuming: 5003 ms | Connection: statement-50 | SQL: SELECT 1 17:27:23.996 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:23 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT 1 17:27:24.006 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 5 ms | Connection: statement-51 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:27:24.254 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 235 ms | Connection: statement-51 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:27:24.448 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 4 ms | Connection: statement-53 | SQL: SELECT 1 17:27:24.448 [XNIO-1 task-3] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 4 ms | Connection: statement-54 | SQL: SELECT 1 17:27:24.448 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 4 ms | Connection: statement-52 | SQL: SELECT 1 17:27:24.482 [XNIO-1 task-3] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 29 ms | Connection: statement-54 | SQL: SELECT A.oc_id, A.group_id, A.group_name, A.group_code, A.group_cat_id, C.group_cat_title, A.node_left, A.node_right, A.parent_id, A.root_id, B.group_name as parent_name, A.node_level, A.is_leaf, A.is_fixed, A.group_desc FROM s_group AS A LEFT JOIN s_group AS B ON (A.oc_id = B.oc_id AND A.parent_id = B.group_id) LEFT JOIN s_group_cat AS C ON (A.oc_id = C.oc_id AND A.group_cat_id = C.group_cat_id) WHERE A.oc_id = 406283 AND A.deleted_flag = 0 17:27:24.485 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT count(0) FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' 17:27:24.490 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 26 ms | Connection: statement-55 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:27:24.499 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 5 ms | Connection: statement-52 | SQL: SELECT count(0) FROM (SELECT DISTINCT (A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name AS grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id) LEFT JOIN (SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name AS grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON (M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id) LEFT JOIN s_position AS P ON (M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON (M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id)) AS D ON (A.oc_id = D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283) table_count 17:27:24.540 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 39 ms | Connection: statement-52 | SQL: SELECT DISTINCT(A.account_id), A.gm_id, A.oc_id, A.group_id, B.account_name, B.account_real_name, B.account_phone, B.account_staff_no, B.account_avatar, B.status, B.is_fixed, C.group_name, C.node_left, C.node_right, D.gmp_id, D.position_id, D.position_name, E.gmpg_id, E.grant_group_id, F.group_name as grant_group_name FROM s_group_member AS A LEFT JOIN account AS B ON (A.oc_id = B.oc_id AND A.account_id = B.account_id) LEFT JOIN s_group AS C ON (A.oc_id = C.oc_id AND A.group_id = C.group_id ) LEFT JOIN s_group_member_position_grant AS E ON (B.oc_id = E.oc_id AND B.account_id = E.account_id) LEFT JOIN s_group AS F ON (E.oc_id = F.oc_id AND E.grant_group_id = F.group_id ) LEFT JOIN ( SELECT M.oc_id, M.account_id, M.gmp_id, M.group_id, M.position_id, P.position_name, N.gmpg_id, N.grant_group_id, GP.group_name as grant_group_name FROM s_group_member_position AS M LEFT JOIN s_group_member_position_grant AS N ON ( M.oc_id = N.oc_id AND M.account_id = N.account_id AND M.group_id = N.group_id AND M.position_id = N.position_id ) LEFT JOIN s_position AS P ON(M.oc_id = P.oc_id AND M.position_id = P.position_id) LEFT JOIN s_group AS GP ON(M.oc_id = GP.oc_id AND N.grant_group_id = GP.group_id ) ) AS D ON (A.oc_id= D.oc_id AND A.account_id = D.account_id AND A.group_id = D.group_id) WHERE B.deleted_flag = 0 AND A.oc_id = 406283 ORDER BY A.account_id, A.group_id LIMIT 999999 17:27:24.675 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:27:24 | Time Consuming: 222 ms | Connection: statement-53 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:27:26.289 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:27:26 | Time Consuming: 1802 ms | Connection: statement-51 | SQL: SELECT A.hdanger_id, A.oc_id, A.goaf_id, A.hdanger_title, A.hdanger_level, A.hdanger_type, A.checklist_id, A.hdanger_desc, A.submit_group_id, A.submit_group_name, A.submit_position_id, A.submit_position_name, A.submit_account_id, A.submit_account_name, A.submit_time, A.review_group_id, A.review_group_name, A.review_position_id, A.review_position_name, A.review_account_id, A.review_account_name, A.danger_deadline, A.review_time, A.review_remark, A.rectify_group_id, A.rectify_group_name, A.rectify_position_id, A.rectify_position_name, A.rectify_account_id, A.rectify_account_name, A.rectify_time, A.danger_reason, A.rectify_measure, A.rectify_remark, A.accept_group_id, A.accept_group_name, A.accept_position_id, A.accept_position_name, A.accept_account_id, A.accept_account_name, A.accept_time, A.accept_remark, A.finish_time, A.status, B.wf_def_id, B.wf_ins_id, B.wf_ins_title, B.cur_group_id, B.cur_group_name, B.cur_position_id, B.cur_position_name, B.cur_account_id, B.cur_account_name, B.cur_activity_ins_id, B.cur_activity_code, B.cur_activity_title, B.cur_form_code, B.cur_activity_begin_time FROM goaf_hdanger AS A LEFT JOIN wf_ins AS B ON A.hdanger_id = B.wf_ins_id WHERE A.oc_id = 406283 AND A.status = '1' ORDER BY A.submit_time DESC LIMIT 10 17:31:10.280 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 5 ms | Connection: statement-51 | SQL: SELECT 1 17:31:10.288 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:31:10.305 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 6 ms | Connection: statement-51 | 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 17:31:10.311 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:31:10.315 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 3 ms | Connection: statement-51 | 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 17:31:10.320 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:31:10.326 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:31:10.330 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 3 ms | Connection: statement-51 | 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 17:31:10.366 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 7 ms | Connection: statement-53 | SQL: SELECT 1 17:31:10.374 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-53 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:31:10.391 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-53 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:31:10.510 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-53 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:31:10.519 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT 1 17:31:10.519 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-52 | SQL: SELECT 1 17:31:10.528 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 3 ms | Connection: statement-52 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:31:10.530 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 6 ms | Connection: statement-55 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:31:10.533 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 4 ms | Connection: statement-52 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:31:10.536 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:31:10 | Time Consuming: 24 ms | Connection: statement-51 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:32:13.087 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT 1 17:32:13.095 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:32:13.110 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 17:32:13.117 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:32:13.121 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:32:13.126 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 3 ms | Connection: statement-51 | 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 17:32:13.133 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:32:13.139 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | 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 17:32:13.177 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:32:13.196 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 7 ms | Connection: statement-51 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:32:13.315 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT 1 17:32:13.315 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 3 ms | Connection: statement-53 | SQL: SELECT 1 17:32:13.315 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-52 | SQL: SELECT 1 17:32:13.317 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 3 ms | Connection: statement-51 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:32:13.322 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:32:13.324 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:32:13.325 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 4 ms | Connection: statement-52 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:32:13.347 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:13 | Time Consuming: 27 ms | Connection: statement-53 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:32:15.247 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 3 ms | Connection: statement-53 | SQL: SELECT 1 17:32:15.261 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 4 ms | Connection: statement-53 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:32:15.281 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 5 ms | Connection: statement-53 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:32:15.398 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 5 ms | Connection: statement-51 | SQL: SELECT 1 17:32:15.398 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 5 ms | Connection: statement-55 | SQL: SELECT 1 17:32:15.399 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 6 ms | Connection: statement-52 | SQL: SELECT 1 17:32:15.402 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 3 ms | Connection: statement-53 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:32:15.407 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 4 ms | Connection: statement-51 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:32:15.413 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 5 ms | Connection: statement-52 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:32:15.420 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 6 ms | Connection: statement-52 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:32:15.429 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:32:15 | Time Consuming: 26 ms | Connection: statement-55 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:33:37.967 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:37 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT 1 17:33:37.977 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:37 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:33:37.994 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:37 | Time Consuming: 4 ms | Connection: statement-55 | 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 = 'admin003' OR A.account_phone = 'admin003' OR A.account_mail = 'admin003' OR A.account_staff_no = 'admin003') 17:33:37.999 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:37 | Time Consuming: 4 ms | Connection: statement-55 | 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 17:33:38.004 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 3 ms | Connection: statement-55 | 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 17:33:38.008 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 3 ms | Connection: statement-55 | 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 17:33:38.013 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 5 ms | Connection: statement-55 | 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 17:33:38.017 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 3 ms | Connection: statement-55 | 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 17:33:38.056 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 3 ms | Connection: statement-55 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:33:38.073 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 7 ms | Connection: statement-55 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:33:38.221 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 4 ms | Connection: statement-58 | SQL: SELECT 1 17:33:38.223 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 5 ms | Connection: statement-55 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:33:38.223 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 5 ms | Connection: statement-57 | SQL: SELECT 1 17:33:38.223 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 6 ms | Connection: statement-59 | SQL: SELECT 1 17:33:38.228 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 4 ms | Connection: statement-55 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:33:38.233 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 4 ms | Connection: statement-57 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:33:38.234 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 3 ms | Connection: statement-59 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:33:38.254 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:33:38 | Time Consuming: 26 ms | Connection: statement-58 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:35:05.757 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-58 | SQL: SELECT 1 17:35:05.766 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 4 ms | Connection: statement-58 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:35:05.783 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-58 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:35:05.906 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 4 ms | Connection: statement-59 | SQL: SELECT 1 17:35:05.907 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-57 | SQL: SELECT 1 17:35:05.907 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-55 | SQL: SELECT 1 17:35:05.913 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 4 ms | Connection: statement-58 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:35:05.917 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-59 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:35:05.917 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-57 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:35:05.919 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 5 ms | Connection: statement-58 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:35:05.937 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:05 | Time Consuming: 25 ms | Connection: statement-55 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:35:38.825 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 4 ms | Connection: statement-57 | SQL: SELECT 1 17:35:38.834 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 4 ms | Connection: statement-57 | SQL: SELECT client_id, client_title, client_app_id, client_app_key, client_app_secret, client_desc, status, is_fixed FROM client WHERE deleted_flag = 0 AND client_app_id = '10001' AND client_app_key = '82a8bf439373e305' 17:35:38.852 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 5 ms | Connection: statement-57 | SQL: SELECT A.client_id, A.role_id, A.permit_id, A.permit_title, A.permit_code, A.permit_entry, A.permit_desc, A.permit_type, A.parent_id, A.root_id, A.sort_no, A.is_home FROM s_role_permit AS A WHERE 1 = 1 AND A.client_id = 2 AND A.role_id = 6 ORDER BY A.parent_id ASC ,A.sort_no ASC 17:35:38.981 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 4 ms | Connection: statement-59 | SQL: SELECT 1 17:35:38.983 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 5 ms | Connection: statement-58 | SQL: SELECT 1 17:35:38.983 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 5 ms | Connection: statement-60 | SQL: SELECT 1 17:35:38.986 [XNIO-1 task-4] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 5 ms | Connection: statement-57 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 17:35:38.991 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 3 ms | Connection: statement-59 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283 17:35:38.992 [XNIO-1 task-2] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 4 ms | Connection: statement-60 | SQL: SELECT checklist_id, oc_id, checklist_title, checklist_desc FROM goaf_checklist WHERE oc_id = 406283 17:35:38.996 [XNIO-1 task-5] INFO p6spy - 2023-06-01 17:35:38 | Time Consuming: 5 ms | Connection: statement-59 | SQL: SELECT * FROM goaf_baseinfo WHERE oc_id = 406283 LIMIT 10 17:35:39.016 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:35:39 | Time Consuming: 28 ms | Connection: statement-58 | SQL: SELECT count(*) FROM msg AS M WHERE M.oc_id = 406283 AND ( EXISTS ( SELECT 1 FROM msg_to TT WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0 ) OR EXISTS ( SELECT 1 FROM msg_cc CC WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0 ) ) 17:36:24.778 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:36:24 | Time Consuming: 4 ms | Connection: statement-58 | SQL: SELECT 1 17:36:24.821 [XNIO-1 task-7] INFO p6spy - 2023-06-01 17:36:24 | Time Consuming: 38 ms | Connection: statement-58 | 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 ) )