cems-mobile-service.2022-07-22.0.log 48 KB

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327
  1. 2022-07-22 11:40:05.838 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
  2. 2022-07-22 11:40:08.528 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
  3. 2022-07-22 11:40:08.529 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  4. 2022-07-22 11:40:08.529 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  5. 2022-07-22 11:40:08.679 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
  6. 2022-07-22 11:40:11.342 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  7. 2022-07-22 11:40:11.505 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  8. 2022-07-22 11:40:11.661 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  9. 2022-07-22 11:40:13.928 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
  10. 2022-07-22 11:40:14.785 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 14.506 seconds (JVM running for 16.728)
  11. 2022-07-22 11:43:05.763 [http-nio-8198-exec-2] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  12. 2022-07-22 11:43:05.811 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  13. 2022-07-22 11:43:06.818 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  14. 2022-07-22 11:43:35.810 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  15. 2022-07-22 11:43:35.827 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  16. 2022-07-22 11:46:10.361 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closing ...
  17. 2022-07-22 11:46:10.370 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
  18. 2022-07-22 11:46:10.370 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closing ...
  19. 2022-07-22 11:46:10.376 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closed
  20. 2022-07-22 11:46:10.376 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closing ...
  21. 2022-07-22 11:46:10.381 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closed
  22. 2022-07-22 11:47:43.725 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  23. 2022-07-22 11:47:43.736 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  24. 2022-07-22 11:47:50.854 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  25. 2022-07-22 11:47:50.868 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  26. 2022-07-22 11:48:27.310 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
  27. 2022-07-22 11:48:29.232 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
  28. 2022-07-22 11:48:29.233 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  29. 2022-07-22 11:48:29.233 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  30. 2022-07-22 11:48:29.374 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
  31. 2022-07-22 11:48:34.327 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  32. 2022-07-22 11:48:36.810 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  33. 2022-07-22 11:48:39.204 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  34. 2022-07-22 11:48:50.100 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
  35. 2022-07-22 11:48:50.775 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 29.944 seconds (JVM running for 31.107)
  36. 2022-07-22 11:49:36.151 [http-nio-8198-exec-4] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  37. 2022-07-22 11:49:36.191 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  38. 2022-07-22 11:49:37.104 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  39. 2022-07-22 11:52:24.739 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dict/getOrgList
  40. 2022-07-22 11:52:24.774 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  41. 2022-07-22 11:52:24.900 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  42. FROM org
  43. WHERE (is_del = ?)
  44. 2022-07-22 11:52:24.901 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  45. 2022-07-22 11:52:24.901 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  46. FROM org
  47. WHERE (is_del = ?) ::: [[0]]
  48. 2022-07-22 11:53:21.201 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  49. 2022-07-22 11:53:21.212 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  50. 2022-07-22 11:53:40.006 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  51. 2022-07-22 11:53:40.018 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  52. 2022-07-22 11:55:00.179 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  53. 2022-07-22 11:55:01.157 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  54. 2022-07-22 11:55:24.500 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dict/getOrgList
  55. 2022-07-22 11:55:24.532 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  56. 2022-07-22 11:55:24.533 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  57. FROM org
  58. WHERE (is_del = ?)
  59. 2022-07-22 11:55:24.534 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  60. 2022-07-22 11:55:24.534 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  61. FROM org
  62. WHERE (is_del = ?) ::: [[0]]
  63. 2022-07-22 11:55:58.703 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  64. 2022-07-22 11:55:58.715 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  65. 2022-07-22 11:56:55.838 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  66. 2022-07-22 11:58:06.898 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  67. 2022-07-22 11:58:57.981 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  68. 2022-07-22 11:59:19.073 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  69. 2022-07-22 11:59:19.077 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  70. FROM org
  71. WHERE (is_del = ?)
  72. 2022-07-22 11:59:19.077 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  73. 2022-07-22 11:59:19.077 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  74. FROM org
  75. WHERE (is_del = ?) ::: [[0]]
  76. 2022-07-22 11:59:19.666 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  77. FROM company
  78. WHERE (monitoring_type = ?)
  79. 2022-07-22 11:59:19.666 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  80. 2022-07-22 11:59:19.667 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  81. FROM company
  82. WHERE (monitoring_type = ?) ::: [[0]]
  83. 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  84. FROM anal_monitor_date
  85. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  86. 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  87. 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  88. FROM anal_monitor_date
  89. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  90. 2022-07-22 12:00:50.751 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
  91. 2022-07-22 12:00:53.188 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
  92. 2022-07-22 12:00:53.189 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  93. 2022-07-22 12:00:53.190 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  94. 2022-07-22 12:00:53.353 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
  95. 2022-07-22 12:00:58.831 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  96. 2022-07-22 12:01:01.365 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  97. 2022-07-22 12:01:03.954 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  98. 2022-07-22 12:01:14.472 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
  99. 2022-07-22 12:01:15.182 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 30.03 seconds (JVM running for 32.488)
  100. 2022-07-22 12:01:27.024 [http-nio-8198-exec-1] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  101. 2022-07-22 12:01:27.071 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  102. 2022-07-22 12:01:38.229 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  103. 2022-07-22 12:01:42.609 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  104. FROM org
  105. WHERE (is_del = ?)
  106. 2022-07-22 12:01:42.613 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  107. 2022-07-22 12:01:42.613 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  108. FROM org
  109. WHERE (is_del = ?) ::: [[0]]
  110. 2022-07-22 12:01:42.867 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  111. FROM company
  112. WHERE (monitoring_type = ?)
  113. 2022-07-22 12:01:42.869 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  114. 2022-07-22 12:01:42.870 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  115. FROM company
  116. WHERE (monitoring_type = ?) ::: [[0]]
  117. 2022-07-22 12:01:42.971 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  118. FROM anal_monitor_date
  119. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  120. 2022-07-22 12:01:42.971 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  121. 2022-07-22 12:01:42.972 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  122. FROM anal_monitor_date
  123. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  124. 2022-07-22 12:02:06.961 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  125. 2022-07-22 12:02:06.975 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  126. 2022-07-22 12:02:11.617 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  127. FROM org
  128. WHERE (is_del = ?)
  129. 2022-07-22 12:02:11.617 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  130. 2022-07-22 12:02:11.617 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  131. FROM org
  132. WHERE (is_del = ?) ::: [[0]]
  133. 2022-07-22 12:02:11.662 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  134. FROM company
  135. WHERE (monitoring_type = ?)
  136. 2022-07-22 12:02:11.662 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  137. 2022-07-22 12:02:11.662 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  138. FROM company
  139. WHERE (monitoring_type = ?) ::: [[0]]
  140. 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  141. FROM anal_monitor_date
  142. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  143. 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  144. 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  145. FROM anal_monitor_date
  146. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  147. 2022-07-22 12:02:28.914 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  148. 2022-07-22 12:02:28.922 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  149. 2022-07-22 12:02:37.470 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  150. FROM org
  151. WHERE (is_del = ?)
  152. 2022-07-22 12:02:37.471 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  153. 2022-07-22 12:02:37.471 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  154. FROM org
  155. WHERE (is_del = ?) ::: [[0]]
  156. 2022-07-22 12:02:37.515 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  157. FROM company
  158. WHERE (monitoring_type = ?)
  159. 2022-07-22 12:02:37.515 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  160. 2022-07-22 12:02:37.515 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  161. FROM company
  162. WHERE (monitoring_type = ?) ::: [[0]]
  163. 2022-07-22 12:03:28.206 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  164. FROM anal_monitor_date
  165. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  166. 2022-07-22 12:03:28.207 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  167. 2022-07-22 12:03:28.207 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  168. FROM anal_monitor_date
  169. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  170. 2022-07-22 12:04:31.094 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  171. 2022-07-22 12:04:31.106 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  172. 2022-07-22 12:04:37.083 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  173. FROM org
  174. WHERE (is_del = ?)
  175. 2022-07-22 12:04:37.083 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  176. 2022-07-22 12:04:37.083 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  177. FROM org
  178. WHERE (is_del = ?) ::: [[0]]
  179. 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  180. FROM company
  181. WHERE (monitoring_type = ?)
  182. 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  183. 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  184. FROM company
  185. WHERE (monitoring_type = ?) ::: [[0]]
  186. 2022-07-22 12:04:55.776 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  187. FROM anal_monitor_date
  188. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  189. 2022-07-22 12:04:55.777 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  190. 2022-07-22 12:04:55.779 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  191. FROM anal_monitor_date
  192. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  193. 2022-07-22 12:05:45.549 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  194. 2022-07-22 12:05:45.556 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  195. 2022-07-22 12:05:45.557 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  196. FROM org
  197. WHERE (is_del = ?)
  198. 2022-07-22 12:05:45.557 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  199. 2022-07-22 12:05:45.557 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  200. FROM org
  201. WHERE (is_del = ?) ::: [[0]]
  202. 2022-07-22 12:05:45.606 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  203. FROM company
  204. WHERE (monitoring_type = ?)
  205. 2022-07-22 12:05:45.607 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  206. 2022-07-22 12:05:45.607 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  207. FROM company
  208. WHERE (monitoring_type = ?) ::: [[0]]
  209. 2022-07-22 12:07:14.710 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  210. FROM anal_monitor_date
  211. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  212. 2022-07-22 12:07:14.710 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  213. 2022-07-22 12:07:14.711 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  214. FROM anal_monitor_date
  215. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  216. 2022-07-22 12:11:47.849 [http-nio-8198-exec-5] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  217. 2022-07-22 12:11:47.860 [http-nio-8198-exec-5] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  218. 2022-07-22 12:11:47.863 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  219. FROM org
  220. WHERE (is_del = ?)
  221. 2022-07-22 12:11:47.863 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  222. 2022-07-22 12:11:47.863 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  223. FROM org
  224. WHERE (is_del = ?) ::: [[0]]
  225. 2022-07-22 12:11:48.429 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  226. FROM company
  227. WHERE (monitoring_type = ?)
  228. 2022-07-22 12:11:48.429 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  229. 2022-07-22 12:11:48.429 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  230. FROM company
  231. WHERE (monitoring_type = ?) ::: [[0]]
  232. 2022-07-22 12:11:52.960 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  233. FROM anal_monitor_date
  234. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  235. 2022-07-22 12:11:52.997 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  236. 2022-07-22 12:11:52.998 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  237. FROM anal_monitor_date
  238. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  239. 2022-07-22 12:14:25.767 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  240. 2022-07-22 12:14:25.775 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  241. 2022-07-22 12:14:25.776 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  242. FROM org
  243. WHERE (is_del = ?)
  244. 2022-07-22 12:14:25.776 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  245. 2022-07-22 12:14:25.776 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  246. FROM org
  247. WHERE (is_del = ?) ::: [[0]]
  248. 2022-07-22 12:14:26.320 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  249. FROM company
  250. WHERE (monitoring_type = ?)
  251. 2022-07-22 12:14:26.320 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  252. 2022-07-22 12:14:26.320 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  253. FROM company
  254. WHERE (monitoring_type = ?) ::: [[0]]
  255. 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  256. FROM anal_monitor_date
  257. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  258. 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  259. 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  260. FROM anal_monitor_date
  261. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  262. 2022-07-22 12:24:09.095 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closing ...
  263. 2022-07-22 12:24:09.097 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
  264. 2022-07-22 12:24:09.098 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closing ...
  265. 2022-07-22 12:24:09.101 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closed
  266. 2022-07-22 12:24:09.101 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closing ...
  267. 2022-07-22 12:24:09.105 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closed
  268. 2022-07-22 12:24:19.227 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  269. 2022-07-22 12:24:19.235 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  270. 2022-07-22 12:24:22.389 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
  271. 2022-07-22 12:24:24.933 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-5} inited
  272. 2022-07-22 12:24:27.423 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-6} inited
  273. 2022-07-22 12:24:40.855 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  274. FROM org
  275. WHERE (is_del = ?)
  276. 2022-07-22 12:24:40.855 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  277. 2022-07-22 12:24:40.856 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  278. FROM org
  279. WHERE (is_del = ?) ::: [[0]]
  280. 2022-07-22 12:24:40.903 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  281. FROM company
  282. WHERE (monitoring_type = ?)
  283. 2022-07-22 12:24:40.904 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  284. 2022-07-22 12:24:40.904 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  285. FROM company
  286. WHERE (monitoring_type = ?) ::: [[0]]
  287. 2022-07-22 12:24:40.950 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  288. FROM anal_monitor_date
  289. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  290. 2022-07-22 12:24:40.950 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=anal_monitor_date, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=anal_monitor_date), operator=BETWEEN, positionValueMap={}, positionIndexMap={0=0, 1=1})])])), sqlTokens=[TableToken(beginPosition=71, skippedSchemaNameLength=0, originalLiterals=anal_monitor_date)], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  291. 2022-07-22 12:24:40.951 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  292. FROM anal_monitor_date
  293. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]
  294. 2022-07-22 12:24:55.115 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
  295. 2022-07-22 12:24:56.976 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
  296. 2022-07-22 12:24:56.977 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  297. 2022-07-22 12:24:56.977 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  298. 2022-07-22 12:24:57.106 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
  299. 2022-07-22 12:25:01.561 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  300. 2022-07-22 12:25:04.099 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  301. 2022-07-22 12:25:06.693 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  302. 2022-07-22 12:25:19.905 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
  303. 2022-07-22 12:25:20.519 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 30.402 seconds (JVM running for 32.489)
  304. 2022-07-22 12:25:31.117 [http-nio-8198-exec-1] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  305. 2022-07-22 12:25:31.164 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
  306. 2022-07-22 12:25:31.187 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - {"enabled":true,"enterprise_id":"117","id":26,"name":"江苏省政府账号","phone":"13858965347","province":"","sex":"1","telephone":"","user_type":1,"username":"jiangsu"}
  307. 2022-07-22 12:25:31.350 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  308. FROM org
  309. WHERE (is_del = ?)
  310. 2022-07-22 12:25:31.351 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=org, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=org)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  311. 2022-07-22 12:25:31.352 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  312. FROM org
  313. WHERE (is_del = ?) ::: [[0]]
  314. 2022-07-22 12:25:31.496 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  315. FROM company
  316. WHERE (monitoring_type = ?)
  317. 2022-07-22 12:25:31.497 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[TableToken(beginPosition=14, skippedSchemaNameLength=0, originalLiterals=company)], parametersIndex=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  318. 2022-07-22 12:25:31.497 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  319. FROM company
  320. WHERE (monitoring_type = ?) ::: [[0]]
  321. 2022-07-22 12:25:31.560 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  322. FROM anal_monitor_date
  323. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26))
  324. 2022-07-22 12:25:31.561 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=anal_monitor_date, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=anal_monitor_date), operator=BETWEEN, positionValueMap={}, positionIndexMap={0=0, 1=1})])])), sqlTokens=[TableToken(beginPosition=71, skippedSchemaNameLength=0, originalLiterals=anal_monitor_date)], parametersIndex=2)), containStar=false, selectListLastPosition=66, groupByLastPosition=0, items=[CommonSelectItem(expression=company_id, alias=Optional.absent()), CommonSelectItem(expression=mn, alias=Optional.absent()), CommonSelectItem(expression=upload_date, alias=Optional.absent()), CommonSelectItem(expression=smoke_total, alias=Optional.absent()), CommonSelectItem(expression=voc_total, alias=Optional.absent()), CommonSelectItem(expression=pm25_total, alias=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  325. 2022-07-22 12:25:31.561 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
  326. FROM anal_monitor_date
  327. WHERE (upload_date between ? and ? AND company_id in (1,2,6,8,9,10,11,12,13,14,15,16,17,18,19,20,21,22,23,24,25,26)) ::: [[20220623, 20220722]]