info.2023-06-28.log 41 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327328329330331332333334335336337338339340341342343344345346347348349350351352353354355356357358359360361362363364365366367368369370371372373374375376377378379380381382383384385386387388389390391392393394395396397398399400401402403404405406407408409410411412413414415416417418419420421422423424425426427428429430431432433434435436437438439440441442443444445446447448449450451452453454455456457458459460461462463464465466467468469470471472473474475476477478479480481482483484485486487488489490491492493494495496497498499500501502503504505506507508509510511512513514515516517518519520521522523524525526527528529530531532533534535536537538539540541542543544545546547548549550551552553554555556557558559560561562563564565566567568569570571572573574575576577578579580581582583584585586587588589590591592593594595596597598599600601602603604605606607608609610611612613614615616617618619620621622623624625626627628629630631632633634635636637638639640641642643644645646647648649650651652653654655656657658659660661662663664665666667668669670671672673674675676677678679680681682683
  1. 18:24:54.899 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
  2. 18:24:54.950 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 19180 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
  3. 18:24:54.950 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
  4. 18:24:55.011 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
  5. 18:24:55.011 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
  6. 18:24:56.955 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
  7. 18:24:56.959 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  8. 18:24:57.029 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 56 ms. Found 0 Redis repository interfaces.
  9. 18:24:57.176 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  10. 18:24:57.195 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  11. 18:24:58.011 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext
  12. 18:24:58.012 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2999 ms
  13. 18:25:00.579 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  14. 18:25:00.590 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  15. 18:25:00.590 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  16. 18:25:00.591 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
  17. 18:25:00.592 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  18. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  19. NOT STARTED.
  20. Currently in standby mode.
  21. Number of jobs executed: 0
  22. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  23. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.
  24. 18:25:00.592 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
  25. 18:25:00.592 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  26. 18:25:00.592 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@10820e6c
  27. 18:25:02.671 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
  28. 18:25:02.837 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
  29. 18:25:02.874 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  30. 18:25:02.875 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
  31. 18:25:02.875 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
  32. 18:25:02.903 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final
  33. 18:25:02.913 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final
  34. 18:25:02.924 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
  35. 18:25:02.963 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final
  36. 18:25:03.022 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
  37. 18:25:03.177 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext
  38. 18:25:03.178 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 150 ms
  39. 18:25:03.191 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
  40. 18:25:03.231 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final
  41. 18:25:03.252 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http)
  42. 18:25:03.255 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
  43. 18:25:03.255 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  44. 18:25:03.279 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.919 seconds (process running for 9.743)
  45. 18:25:03.282 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
  46. 18:25:03.290 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
  47. 18:25:03.710 [restartedMain] INFO p6spy - 2023-06-28 18:25:03 | Time Consuming: 18 ms | Connection: statement-0 | SQL: SELECT 1
  48. 18:25:03.716 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@47d09491
  49. 18:25:03.721 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
  50. 18:25:03.800 [restartedMain] INFO p6spy - 2023-06-28 18:25:03 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT
  51. A.job_id,
  52. A.job_title,
  53. A.job_desc,
  54. A.status,
  55. A.job_type,
  56. A.job_code,
  57. A.job_cron,
  58. A.job_class_id,
  59. B.job_class,
  60. A.cycle_title,
  61. A.cycle_period,
  62. A.cycle_unit
  63. FROM job AS A
  64. LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
  65. WHERE A.deleted_flag = 0
  66. AND A.status = 1
  67. ORDER BY A.job_id ASC
  68. 18:25:03.835 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  69. 18:25:03.850 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  70. 18:25:03.850 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  71. 18:25:03.851 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  72. 18:25:03.851 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  73. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  74. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  75. 18:25:03.852 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  76. 18:25:04.097 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
  77. 18:25:04.098 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
  78. 18:25:04.101 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 3 ms
  79. 18:25:04.107 [RMI TCP Connection(5)-192.168.3.5] INFO p6spy - 2023-06-28 18:25:04 | Time Consuming: 4 ms | Connection: statement-0 | SQL: SELECT 1
  80. 18:26:08.472 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 42 ms | Connection: statement-0 | SQL: SELECT 1
  81. 18:26:08.488 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT
  82. client_id,
  83. client_title,
  84. client_app_id,
  85. client_app_key,
  86. client_app_secret,
  87. client_desc,
  88. status,
  89. is_fixed
  90. FROM client
  91. WHERE deleted_flag = 0
  92. AND client_app_id = '10001'
  93. AND client_app_key = '82a8bf439373e305'
  94. 18:26:08.511 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 6 ms | Connection: statement-0 | SQL: SELECT
  95. A.client_id,
  96. A.role_id,
  97. A.permit_id,
  98. A.permit_title,
  99. A.permit_code,
  100. A.permit_entry,
  101. A.permit_desc,
  102. A.permit_type,
  103. A.parent_id,
  104. A.root_id,
  105. A.sort_no,
  106. A.is_home
  107. FROM s_role_permit AS A
  108. WHERE 1 = 1
  109. AND A.client_id = 2
  110. AND A.role_id = 6
  111. ORDER BY A.parent_id ASC ,A.sort_no ASC
  112. 18:26:08.790 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:26:08 | Time Consuming: 31 ms | Connection: statement-0 | SQL: SELECT count(*)
  113. FROM msg AS M
  114. WHERE M.oc_id = 406283
  115. AND (
  116. EXISTS (
  117. SELECT 1 FROM msg_to TT
  118. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  119. ) OR
  120. EXISTS (
  121. SELECT 1 FROM msg_cc CC
  122. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  123. )
  124. )
  125. 18:26:26.148 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final
  126. 18:26:26.154 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
  127. 18:26:26.154 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final
  128. 18:26:26.156 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
  129. 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  130. 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
  131. 18:26:26.157 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
  132. 18:26:26.170 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
  133. 18:26:26.172 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  134. 18:26:26.172 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
  135. 18:26:26.172 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
  136. 18:26:26.173 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
  137. 18:26:26.185 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
  138. 18:26:26.189 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.
  139. 18:26:33.322 [background-preinit] INFO o.h.validator.internal.util.Version - HV000001: Hibernate Validator 8.0.0.Final
  140. 18:26:33.381 [restartedMain] INFO com.zhyc.xps.XPSApplication - Starting XPSApplication using Java 17.0.6 with PID 8884 (E:\syf3prj\xps-server-3\xps-application\target\classes started by qzz19 in E:\syf3prj\xps-server-3)
  141. 18:26:33.382 [restartedMain] INFO com.zhyc.xps.XPSApplication - The following 1 profile is active: "dev"
  142. 18:26:33.444 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - Devtools property defaults active! Set 'spring.devtools.add-properties' to 'false' to disable
  143. 18:26:33.445 [restartedMain] INFO o.s.b.d.e.DevToolsPropertyDefaultsPostProcessor - For additional web related logging consider setting the 'logging.level.web' property to 'DEBUG'
  144. 18:26:35.143 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Multiple Spring Data modules found, entering strict repository configuration mode
  145. 18:26:35.146 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Bootstrapping Spring Data Redis repositories in DEFAULT mode.
  146. 18:26:35.215 [restartedMain] INFO o.s.d.r.c.RepositoryConfigurationDelegate - Finished Spring Data repository scanning in 54 ms. Found 0 Redis repository interfaces.
  147. 18:26:35.362 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'errorChannel' has been explicitly defined. Therefore, a default PublishSubscribeChannel will be created.
  148. 18:26:35.380 [restartedMain] INFO o.s.i.c.DefaultConfiguringBeanFactoryPostProcessor - No bean named 'integrationHeaderChannelRegistry' has been explicitly defined. Therefore, a default DefaultHeaderChannelRegistry will be created.
  149. 18:26:36.190 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext
  150. 18:26:36.191 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 2745 ms
  151. 18:26:38.854 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Using default implementation for ThreadExecutor
  152. 18:26:38.865 [restartedMain] INFO o.quartz.core.SchedulerSignalerImpl - Initialized Scheduler Signaller of type: class org.quartz.core.SchedulerSignalerImpl
  153. 18:26:38.865 [restartedMain] INFO org.quartz.core.QuartzScheduler - Quartz Scheduler v.2.3.2 created.
  154. 18:26:38.866 [restartedMain] INFO org.quartz.simpl.RAMJobStore - RAMJobStore initialized.
  155. 18:26:38.867 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler meta-data: Quartz Scheduler (v2.3.2) 'quartzScheduler' with instanceId 'NON_CLUSTERED'
  156. Scheduler class: 'org.quartz.core.QuartzScheduler' - running locally.
  157. NOT STARTED.
  158. Currently in standby mode.
  159. Number of jobs executed: 0
  160. Using thread pool 'org.quartz.simpl.SimpleThreadPool' - with 10 threads.
  161. Using job-store 'org.quartz.simpl.RAMJobStore' - which does not support persistence. and is not clustered.
  162. 18:26:38.867 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler 'quartzScheduler' initialized from an externally provided properties instance.
  163. 18:26:38.867 [restartedMain] INFO org.quartz.impl.StdSchedulerFactory - Quartz scheduler version: 2.3.2
  164. 18:26:38.867 [restartedMain] INFO org.quartz.core.QuartzScheduler - JobFactory set to: org.springframework.scheduling.quartz.SpringBeanJobFactory@21dda797
  165. 18:26:40.796 [restartedMain] INFO o.s.b.d.a.OptionalLiveReloadServer - LiveReload server is running on port 35729
  166. 18:26:40.941 [restartedMain] INFO io.undertow.websockets.jsr - UT026003: Adding annotated server endpoint class com.zhyc.xps.common.ws.WebSocketServer for path /websocket/link
  167. 18:26:40.973 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - Adding {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  168. 18:26:40.974 [restartedMain] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 1 subscriber(s).
  169. 18:26:40.974 [restartedMain] INFO o.s.i.endpoint.EventDrivenConsumer - started bean '_org.springframework.integration.errorLogger'
  170. 18:26:40.994 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final
  171. 18:26:41.003 [restartedMain] INFO org.xnio - XNIO version 3.8.8.Final
  172. 18:26:41.014 [restartedMain] INFO org.xnio.nio - XNIO NIO Implementation Version 3.8.8.Final
  173. 18:26:41.046 [restartedMain] INFO org.jboss.threads - JBoss Threads version 3.5.0.Final
  174. 18:26:41.099 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 1688 (http)
  175. 18:26:41.229 [restartedMain] INFO io.undertow.servlet - Initializing Spring embedded WebApplicationContext
  176. 18:26:41.229 [restartedMain] INFO o.s.b.w.s.c.ServletWebServerApplicationContext - Root WebApplicationContext: initialization completed in 124 ms
  177. 18:26:41.239 [restartedMain] INFO o.s.b.a.e.web.EndpointLinksResolver - Exposing 15 endpoint(s) beneath base path '/actuator/z'
  178. 18:26:41.274 [restartedMain] INFO io.undertow - starting server: Undertow - 2.3.4.Final
  179. 18:26:41.290 [restartedMain] INFO o.s.b.w.e.undertow.UndertowWebServer - Undertow started on port(s) 8089 (http)
  180. 18:26:41.294 [restartedMain] INFO o.s.s.quartz.SchedulerFactoryBean - Starting Quartz Scheduler now
  181. 18:26:41.294 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  182. 18:26:41.318 [restartedMain] INFO com.zhyc.xps.XPSApplication - Started XPSApplication in 8.521 seconds (process running for 9.368)
  183. 18:26:41.320 [restartedMain] INFO com.zhyc.xps.sys.job.InitSystemJob - 初始化系统定时任务
  184. 18:26:41.327 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Starting...
  185. 18:26:41.692 [restartedMain] INFO p6spy - 2023-06-28 18:26:41 | Time Consuming: 15 ms | Connection: statement-0 | SQL: SELECT 1
  186. 18:26:41.698 [restartedMain] INFO com.zaxxer.hikari.pool.HikariPool - DatebookHikariCP - Added connection com.p6spy.engine.wrapper.ConnectionWrapper@6bdeaa69
  187. 18:26:41.702 [restartedMain] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Start completed.
  188. 18:26:41.784 [restartedMain] INFO p6spy - 2023-06-28 18:26:41 | Time Consuming: 7 ms | Connection: statement-0 | SQL: SELECT
  189. A.job_id,
  190. A.job_title,
  191. A.job_desc,
  192. A.status,
  193. A.job_type,
  194. A.job_code,
  195. A.job_cron,
  196. A.job_class_id,
  197. B.job_class,
  198. A.cycle_title,
  199. A.cycle_period,
  200. A.cycle_unit
  201. FROM job AS A
  202. LEFT JOIN job_class AS B ON (A.job_class_id = B.job_class_id)
  203. WHERE A.deleted_flag = 0
  204. AND A.status = 1
  205. ORDER BY A.job_id ASC
  206. 18:26:41.819 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  207. 18:26:41.821 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  208. 18:26:41.821 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  209. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  210. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  211. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  212. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  213. 18:26:41.822 [restartedMain] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED started.
  214. 18:26:42.443 [RMI TCP Connection(4)-192.168.3.5] INFO io.undertow.servlet - Initializing Spring DispatcherServlet 'dispatcherServlet'
  215. 18:26:42.443 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Initializing Servlet 'dispatcherServlet'
  216. 18:26:42.445 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-28 18:26:42 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
  217. 18:26:42.448 [RMI TCP Connection(4)-192.168.3.5] INFO o.s.web.servlet.DispatcherServlet - Completed initialization in 4 ms
  218. 18:26:42.460 [RMI TCP Connection(3)-192.168.3.5] INFO p6spy - 2023-06-28 18:26:42 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
  219. 18:30:06.701 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:30:06 | Time Consuming: 5 ms | Connection: statement-0 | SQL: SELECT 1
  220. 18:30:06.738 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:30:06 | Time Consuming: 29 ms | Connection: statement-0 | SQL: SELECT count(*)
  221. FROM msg AS M
  222. WHERE M.oc_id = 406283
  223. AND (
  224. EXISTS (
  225. SELECT 1 FROM msg_to TT
  226. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  227. ) OR
  228. EXISTS (
  229. SELECT 1 FROM msg_cc CC
  230. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  231. )
  232. )
  233. 18:34:16.468 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:16 | Time Consuming: 5029 ms | Connection: statement-0 | SQL: SELECT 1
  234. 18:34:21.471 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:21 | Time Consuming: 5001 ms | Connection: statement-1 | SQL: SELECT 1
  235. 18:34:26.473 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:26 | Time Consuming: 5001 ms | Connection: statement-2 | SQL: SELECT 1
  236. 18:34:31.476 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:31 | Time Consuming: 5001 ms | Connection: statement-3 | SQL: SELECT 1
  237. 18:34:36.479 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5002 ms | Connection: statement-4 | SQL: SELECT 1
  238. 18:34:36.485 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1
  239. 18:34:36.501 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 9 ms | Connection: statement-5 | SQL: UPDATE account
  240. SET updated_by = 406283
  241. WHERE oc_id = 406283 AND account_id = 406283
  242. 18:34:36.569 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT
  243. client_id,
  244. client_title,
  245. client_app_id,
  246. client_app_key,
  247. client_app_secret,
  248. client_desc,
  249. status,
  250. is_fixed
  251. FROM client
  252. WHERE deleted_flag = 0
  253. AND client_app_id = '10001'
  254. AND client_app_key = '82a8bf439373e305'
  255. 18:34:36.591 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:36 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT
  256. A.client_id,
  257. A.role_id,
  258. A.permit_id,
  259. A.permit_title,
  260. A.permit_code,
  261. A.permit_entry,
  262. A.permit_desc,
  263. A.permit_type,
  264. A.parent_id,
  265. A.root_id,
  266. A.sort_no,
  267. A.is_home
  268. FROM s_role_permit AS A
  269. WHERE 1 = 1
  270. AND A.client_id = 2
  271. AND A.role_id = 6
  272. ORDER BY A.parent_id ASC ,A.sort_no ASC
  273. 18:34:57.455 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:57 | Time Consuming: 8 ms | Connection: statement-5 | SQL: SELECT 1
  274. 18:34:57.489 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:34:57 | Time Consuming: 28 ms | Connection: statement-5 | SQL: SELECT count(*)
  275. FROM msg AS M
  276. WHERE M.oc_id = 406283
  277. AND (
  278. EXISTS (
  279. SELECT 1 FROM msg_to TT
  280. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  281. ) OR
  282. EXISTS (
  283. SELECT 1 FROM msg_cc CC
  284. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  285. )
  286. )
  287. 18:35:03.133 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 7 ms | Connection: statement-5 | SQL: SELECT 1
  288. 18:35:03.144 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT
  289. client_id,
  290. client_title,
  291. client_app_id,
  292. client_app_key,
  293. client_app_secret,
  294. client_desc,
  295. status,
  296. is_fixed
  297. FROM client
  298. WHERE deleted_flag = 0
  299. AND client_app_id = '10001'
  300. AND client_app_key = '82a8bf439373e305'
  301. 18:35:03.164 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT
  302. A.client_id,
  303. A.role_id,
  304. A.permit_id,
  305. A.permit_title,
  306. A.permit_code,
  307. A.permit_entry,
  308. A.permit_desc,
  309. A.permit_type,
  310. A.parent_id,
  311. A.root_id,
  312. A.sort_no,
  313. A.is_home
  314. FROM s_role_permit AS A
  315. WHERE 1 = 1
  316. AND A.client_id = 2
  317. AND A.role_id = 6
  318. ORDER BY A.parent_id ASC ,A.sort_no ASC
  319. 18:35:03.324 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:03 | Time Consuming: 32 ms | Connection: statement-5 | SQL: SELECT count(*)
  320. FROM msg AS M
  321. WHERE M.oc_id = 406283
  322. AND (
  323. EXISTS (
  324. SELECT 1 FROM msg_to TT
  325. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  326. ) OR
  327. EXISTS (
  328. SELECT 1 FROM msg_cc CC
  329. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  330. )
  331. )
  332. 18:35:31.778 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:31 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT 1
  333. 18:35:31.792 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:35:31 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT *
  334. FROM goaf_bigscreencfg
  335. WHERE oc_id = 406283
  336. 18:39:12.283 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1
  337. 18:39:12.294 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT
  338. client_id,
  339. client_title,
  340. client_app_id,
  341. client_app_key,
  342. client_app_secret,
  343. client_desc,
  344. status,
  345. is_fixed
  346. FROM client
  347. WHERE deleted_flag = 0
  348. AND client_app_id = '10001'
  349. AND client_app_key = '82a8bf439373e305'
  350. 18:39:12.311 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 6 ms | Connection: statement-5 | SQL: SELECT
  351. A.client_id,
  352. A.role_id,
  353. A.permit_id,
  354. A.permit_title,
  355. A.permit_code,
  356. A.permit_entry,
  357. A.permit_desc,
  358. A.permit_type,
  359. A.parent_id,
  360. A.root_id,
  361. A.sort_no,
  362. A.is_home
  363. FROM s_role_permit AS A
  364. WHERE 1 = 1
  365. AND A.client_id = 2
  366. AND A.role_id = 6
  367. ORDER BY A.parent_id ASC ,A.sort_no ASC
  368. 18:39:12.495 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:12 | Time Consuming: 28 ms | Connection: statement-5 | SQL: SELECT count(*)
  369. FROM msg AS M
  370. WHERE M.oc_id = 406283
  371. AND (
  372. EXISTS (
  373. SELECT 1 FROM msg_to TT
  374. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  375. ) OR
  376. EXISTS (
  377. SELECT 1 FROM msg_cc CC
  378. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  379. )
  380. )
  381. 18:39:16.181 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
  382. 18:39:16.189 [XNIO-1 task-2] INFO p6spy - 2023-06-28 18:39:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT *
  383. FROM goaf_bigscreencfg
  384. WHERE oc_id = 406283
  385. 18:39:17.479 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5011 ms | Connection: statement-7 | SQL: SELECT 1
  386. 18:39:17.479 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5013 ms | Connection: statement-6 | SQL: SELECT 1
  387. 18:39:17.479 [XNIO-1 task-5] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 5007 ms | Connection: statement-8 | SQL: SELECT 1
  388. 18:39:17.484 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1
  389. 18:39:17.538 [XNIO-1 task-5] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT checklist_id,
  390. oc_id,
  391. checklist_title,
  392. checklist_desc
  393. FROM goaf_checklist
  394. WHERE oc_id = 406283
  395. 18:39:17.545 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT count(0) FROM goaf_baseinfo WHERE oc_id = 406283
  396. 18:39:17.549 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:17 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT *
  397. FROM goaf_baseinfo
  398. WHERE oc_id = 406283
  399. LIMIT 10
  400. 18:39:22.492 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 5013 ms | Connection: statement-9 | SQL: SELECT 1
  401. 18:39:22.515 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 21 ms | Connection: statement-5 | SQL: SELECT 1
  402. 18:39:22.525 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:22 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT *
  403. FROM goaf_baseinfo
  404. WHERE oc_id = 406283
  405. 18:39:25.333 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
  406. 18:39:25.340 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT
  407. client_id,
  408. client_title,
  409. client_app_id,
  410. client_app_key,
  411. client_app_secret,
  412. client_desc,
  413. status,
  414. is_fixed
  415. FROM client
  416. WHERE deleted_flag = 0
  417. AND client_app_id = '10001'
  418. AND client_app_key = '82a8bf439373e305'
  419. 18:39:25.359 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT
  420. A.client_id,
  421. A.role_id,
  422. A.permit_id,
  423. A.permit_title,
  424. A.permit_code,
  425. A.permit_entry,
  426. A.permit_desc,
  427. A.permit_type,
  428. A.parent_id,
  429. A.root_id,
  430. A.sort_no,
  431. A.is_home
  432. FROM s_role_permit AS A
  433. WHERE 1 = 1
  434. AND A.client_id = 2
  435. AND A.role_id = 6
  436. ORDER BY A.parent_id ASC ,A.sort_no ASC
  437. 18:39:25.463 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
  438. 18:39:25.481 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 13 ms | Connection: statement-11 | SQL: SELECT *
  439. FROM goaf_bigscreencfg
  440. WHERE oc_id = 406283
  441. 18:39:25.493 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:25 | Time Consuming: 29 ms | Connection: statement-5 | SQL: SELECT count(*)
  442. FROM msg AS M
  443. WHERE M.oc_id = 406283
  444. AND (
  445. EXISTS (
  446. SELECT 1 FROM msg_to TT
  447. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  448. ) OR
  449. EXISTS (
  450. SELECT 1 FROM msg_cc CC
  451. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  452. )
  453. )
  454. 18:39:43.654 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:43 | Time Consuming: 4 ms | Connection: statement-5 | SQL: SELECT 1
  455. 18:39:43.662 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:39:43 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT *
  456. FROM goaf_bigscreencfg
  457. WHERE oc_id = 406283
  458. 18:40:16.230 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
  459. 18:40:16.237 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:16 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT *
  460. FROM goaf_bigscreencfg
  461. WHERE oc_id = 406283
  462. 18:40:32.512 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:32 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
  463. 18:40:32.519 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:32 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT *
  464. FROM goaf_bigscreencfg
  465. WHERE oc_id = 406283
  466. 18:40:38.464 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT 1
  467. 18:40:38.473 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 3 ms | Connection: statement-5 | SQL: SELECT
  468. client_id,
  469. client_title,
  470. client_app_id,
  471. client_app_key,
  472. client_app_secret,
  473. client_desc,
  474. status,
  475. is_fixed
  476. FROM client
  477. WHERE deleted_flag = 0
  478. AND client_app_id = '10001'
  479. AND client_app_key = '82a8bf439373e305'
  480. 18:40:38.489 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 5 ms | Connection: statement-5 | SQL: SELECT
  481. A.client_id,
  482. A.role_id,
  483. A.permit_id,
  484. A.permit_title,
  485. A.permit_code,
  486. A.permit_entry,
  487. A.permit_desc,
  488. A.permit_type,
  489. A.parent_id,
  490. A.root_id,
  491. A.sort_no,
  492. A.is_home
  493. FROM s_role_permit AS A
  494. WHERE 1 = 1
  495. AND A.client_id = 2
  496. AND A.role_id = 6
  497. ORDER BY A.parent_id ASC ,A.sort_no ASC
  498. 18:40:38.586 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  499. 18:40:38.586 [XNIO-1 task-4] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 2 ms | Connection: statement-5 | SQL: SELECT *
  500. FROM goaf_bigscreencfg
  501. WHERE oc_id = 406283
  502. 18:40:38.622 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:40:38 | Time Consuming: 30 ms | Connection: statement-11 | SQL: SELECT count(*)
  503. FROM msg AS M
  504. WHERE M.oc_id = 406283
  505. AND (
  506. EXISTS (
  507. SELECT 1 FROM msg_to TT
  508. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  509. ) OR
  510. EXISTS (
  511. SELECT 1 FROM msg_cc CC
  512. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  513. )
  514. )
  515. 18:41:23.423 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:23 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  516. 18:41:23.433 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:23 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  517. FROM goaf_bigscreencfg
  518. WHERE oc_id = 406283
  519. 18:41:39.449 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:39 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  520. 18:41:39.458 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:41:39 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT *
  521. FROM goaf_bigscreencfg
  522. WHERE oc_id = 406283
  523. 18:42:03.504 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:42:03 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  524. 18:42:03.513 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:42:03 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  525. FROM goaf_bigscreencfg
  526. WHERE oc_id = 406283
  527. 18:43:09.578 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:43:09 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  528. 18:43:09.586 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:43:09 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  529. FROM goaf_bigscreencfg
  530. WHERE oc_id = 406283
  531. 18:44:01.629 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:01 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  532. 18:44:01.662 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:01 | Time Consuming: 29 ms | Connection: statement-11 | SQL: SELECT count(*)
  533. FROM msg AS M
  534. WHERE M.oc_id = 406283
  535. AND (
  536. EXISTS (
  537. SELECT 1 FROM msg_to TT
  538. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  539. ) OR
  540. EXISTS (
  541. SELECT 1 FROM msg_cc CC
  542. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  543. )
  544. )
  545. 18:44:04.042 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
  546. 18:44:04.050 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  547. FROM goaf_bigscreencfg
  548. WHERE oc_id = 406283
  549. 18:44:57.420 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  550. 18:44:57.454 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 28 ms | Connection: statement-11 | SQL: SELECT count(*)
  551. FROM msg AS M
  552. WHERE M.oc_id = 406283
  553. AND (
  554. EXISTS (
  555. SELECT 1 FROM msg_to TT
  556. WHERE M.oc_id = TT.oc_id AND M.msg_id = TT.msg_id AND TT.msg_to_id = 406283 AND TT.status=0
  557. ) OR
  558. EXISTS (
  559. SELECT 1 FROM msg_cc CC
  560. WHERE M.oc_id = CC.oc_id AND M.msg_id = CC.msg_id AND CC.msg_cc_id = 406283 AND CC.status=0
  561. )
  562. )
  563. 18:44:57.934 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:57 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  564. FROM goaf_bigscreencfg
  565. WHERE oc_id = 406283
  566. 18:44:59.014 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT 1
  567. 18:44:59.025 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 6 ms | Connection: statement-11 | SQL: UPDATE goaf_bigscreencfg
  568. SET bigscreen_addr = 'http://192.168.3.16:998/cn/index-iframe.html'
  569. WHERE oc_id = 406283
  570. 18:44:59.059 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:44:59 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  571. FROM goaf_bigscreencfg
  572. WHERE oc_id = 406283
  573. 18:45:02.031 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
  574. 18:45:02.042 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 6 ms | Connection: statement-11 | SQL: UPDATE goaf_bigscreencfg
  575. SET bigscreen_addr = 'http://192.168.3.16:8080/#/'
  576. WHERE oc_id = 406283
  577. 18:45:02.073 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:02 | Time Consuming: 4 ms | Connection: statement-11 | SQL: SELECT *
  578. FROM goaf_bigscreencfg
  579. WHERE oc_id = 406283
  580. 18:45:04.210 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT 1
  581. 18:45:04.218 [XNIO-1 task-3] INFO p6spy - 2023-06-28 18:45:04 | Time Consuming: 3 ms | Connection: statement-11 | SQL: SELECT *
  582. FROM goaf_bigscreencfg
  583. WHERE oc_id = 406283
  584. 19:01:01.517 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final
  585. 19:01:01.523 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
  586. 19:01:01.523 [SpringApplicationShutdownHook] INFO io.undertow - stopping server: Undertow - 2.3.4.Final
  587. 19:01:01.525 [SpringApplicationShutdownHook] INFO io.undertow.servlet - Destroying Spring FrameworkServlet 'dispatcherServlet'
  588. 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - Removing {logging-channel-adapter:_org.springframework.integration.errorLogger} as a subscriber to the 'errorChannel' channel
  589. 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.c.PublishSubscribeChannel - Channel 'xps-server.errorChannel' has 0 subscriber(s).
  590. 19:01:01.526 [SpringApplicationShutdownHook] INFO o.s.i.endpoint.EventDrivenConsumer - stopped bean '_org.springframework.integration.errorLogger'
  591. 19:01:01.537 [SpringApplicationShutdownHook] INFO o.s.j.e.a.AnnotationMBeanExporter - Could not unregister MBean [com.github.tobato.fastdfs.domain.conn:name=fdfsConnectionPool,type=FdfsConnectionPool] as said MBean is not registered (perhaps already unregistered by an external process)
  592. 19:01:01.538 [SpringApplicationShutdownHook] INFO o.s.s.quartz.SchedulerFactoryBean - Shutting down Quartz Scheduler
  593. 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutting down.
  594. 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED paused.
  595. 19:01:01.539 [SpringApplicationShutdownHook] INFO org.quartz.core.QuartzScheduler - Scheduler quartzScheduler_$_NON_CLUSTERED shutdown complete.
  596. 19:01:01.551 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown initiated...
  597. 19:01:01.553 [SpringApplicationShutdownHook] INFO com.zaxxer.hikari.HikariDataSource - DatebookHikariCP - Shutdown completed.