cems-mobile-service.2022-07-13.0.log 11 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768697071
  1. 2022-07-13 13:48:44.158 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
  2. 2022-07-13 13:48:46.002 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
  3. 2022-07-13 13:48:46.002 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  4. 2022-07-13 13:48:46.002 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  5. 2022-07-13 13:48:46.107 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
  6. 2022-07-13 13:48:47.934 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  7. 2022-07-13 13:48:48.041 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  8. 2022-07-13 13:48:48.142 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  9. 2022-07-13 13:48:50.494 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
  10. 2022-07-13 13:48:52.018 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 14.182 seconds (JVM running for 15.56)
  11. 2022-07-13 13:51:40.275 [http-nio-8198-exec-3] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  12. 2022-07-13 13:51:57.303 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  13. 2022-07-13 13:51:58.170 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  14. 2022-07-13 13:52:33.838 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  15. 2022-07-13 13:52:33.850 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  16. 2022-07-13 13:53:42.449 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  17. 2022-07-13 13:53:42.464 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  18. 2022-07-13 13:54:30.501 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  19. 2022-07-13 13:54:30.512 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  20. 2022-07-13 13:54:31.588 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  21. 2022-07-13 13:54:31.598 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  22. 2022-07-13 13:55:15.057 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  23. 2022-07-13 13:55:15.069 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  24. 2022-07-13 13:55:31.399 [http-nio-8198-exec-5] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  25. 2022-07-13 13:55:31.410 [http-nio-8198-exec-5] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  26. 2022-07-13 13:58:28.818 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  27. 2022-07-13 13:58:28.828 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  28. 2022-07-13 14:00:30.059 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  29. 2022-07-13 14:00:30.770 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  30. 2022-07-13 14:06:14.041 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  31. 2022-07-13 14:06:14.050 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  32. 2022-07-13 14:09:43.572 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  33. 2022-07-13 14:09:43.600 [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"}
  34. 2022-07-13 14:09:43.690 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  35. FROM org
  36. WHERE (is_del = ?)
  37. 2022-07-13 14:09:43.691 [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)
  38. 2022-07-13 14:09:43.691 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  39. FROM org
  40. WHERE (is_del = ?) ::: [[0]]
  41. 2022-07-13 14:09:43.801 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  42. FROM company
  43. WHERE (monitoring_type = ? AND is_del = ?)
  44. 2022-07-13 14:09:43.802 [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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  45. 2022-07-13 14:09:43.802 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  46. FROM company
  47. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
  48. 2022-07-13 14:09:43.861 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? 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) AND exceed_smoke_num > 0)
  49. 2022-07-13 14:09:43.861 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company_warn_statistics, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=company_warn_statistics), operator=EQUAL, positionValueMap={}, positionIndexMap={0=0})])])), sqlTokens=[TableToken(beginPosition=21, skippedSchemaNameLength=0, originalLiterals=company_warn_statistics)], parametersIndex=1)), containStar=false, selectListLastPosition=16, groupByLastPosition=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(0), alias=Optional.absent(), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  50. 2022-07-13 14:09:43.862 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? 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) AND exceed_smoke_num > 0) ::: [[20220713]]
  51. 2022-07-13 15:05:55.349 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompanyTitle
  52. 2022-07-13 15:05:55.374 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
  53. 2022-07-13 15:06:24.851 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectOverCompany
  54. 2022-07-13 15:06:24.860 [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"}
  55. 2022-07-13 15:06:24.861 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  56. FROM org
  57. WHERE (is_del = ?)
  58. 2022-07-13 15:06:24.861 [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)
  59. 2022-07-13 15:06:24.861 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  60. FROM org
  61. WHERE (is_del = ?) ::: [[0]]
  62. 2022-07-13 15:06:24.916 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  63. FROM company
  64. WHERE (monitoring_type = ? AND is_del = ?)
  65. 2022-07-13 15:06:24.916 [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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  66. 2022-07-13 15:06:24.916 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  67. FROM company
  68. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
  69. 2022-07-13 15:06:24.922 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? 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) AND exceed_smoke_num > 0)
  70. 2022-07-13 15:06:24.922 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[Table(name=company_warn_statistics, alias=Optional.absent())]), conditions=Conditions(orCondition=OrCondition(andConditions=[AndCondition(conditions=[Condition(column=Column(name=upload_date, tableName=company_warn_statistics), operator=EQUAL, positionValueMap={}, positionIndexMap={0=0})])])), sqlTokens=[TableToken(beginPosition=21, skippedSchemaNameLength=0, originalLiterals=company_warn_statistics)], parametersIndex=1)), containStar=false, selectListLastPosition=16, groupByLastPosition=0, items=[AggregationSelectItem(type=COUNT, innerExpression=(0), alias=Optional.absent(), derivedAggregationSelectItems=[], index=-1)], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  71. 2022-07-13 15:06:24.922 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? 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) AND exceed_smoke_num > 0) ::: [[20220713]]