cems-sys-service.2022-07-13.0.log 12 KB

1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768
  1. 2022-07-13 14:03:03.856 [main] INFO com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
  2. 2022-07-13 14:03:05.866 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
  3. 2022-07-13 14:03:05.867 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
  4. 2022-07-13 14:03:05.867 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
  5. 2022-07-13 14:03:05.996 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
  6. 2022-07-13 14:03:08.345 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
  7. 2022-07-13 14:03:08.451 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
  8. 2022-07-13 14:03:08.549 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
  9. 2022-07-13 14:03:10.845 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
  10. 2022-07-13 14:03:13.150 [main] INFO com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 15.559 seconds (JVM running for 16.607)
  11. 2022-07-13 14:03:21.421 [http-nio-8193-exec-1] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
  12. 2022-07-13 14:03:21.477 [http-nio-8193-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
  13. 2022-07-13 14:03:21.510 [http-nio-8193-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"}
  14. 2022-07-13 14:03:21.696 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  15. FROM org
  16. WHERE (is_del = ?)
  17. 2022-07-13 14:03:21.697 [http-nio-8193-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)
  18. 2022-07-13 14:03:21.697 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  19. FROM org
  20. WHERE (is_del = ?) ::: [[0]]
  21. 2022-07-13 14:03:21.767 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  22. FROM company
  23. WHERE (monitoring_type = ? AND is_del = ?)
  24. 2022-07-13 14:03:21.767 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  25. 2022-07-13 14:03:21.767 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  26. FROM company
  27. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
  28. 2022-07-13 14:03:21.825 [http-nio-8193-exec-1] 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)
  29. 2022-07-13 14:03:21.825 [http-nio-8193-exec-1] 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)
  30. 2022-07-13 14:03:21.826 [http-nio-8193-exec-1] 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]]
  31. 2022-07-13 14:03:43.625 [http-nio-8193-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
  32. 2022-07-13 14:03:43.640 [http-nio-8193-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"}
  33. 2022-07-13 14:03:43.641 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  34. FROM org
  35. WHERE (is_del = ?)
  36. 2022-07-13 14:03:43.641 [http-nio-8193-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)
  37. 2022-07-13 14:03:43.641 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  38. FROM org
  39. WHERE (is_del = ?) ::: [[0]]
  40. 2022-07-13 14:03:43.647 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  41. FROM company
  42. WHERE (monitoring_type = ? AND is_del = ?)
  43. 2022-07-13 14:03:43.647 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  44. 2022-07-13 14:03:43.647 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  45. FROM company
  46. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
  47. 2022-07-13 14:03:43.654 [http-nio-8193-exec-4] 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)
  48. 2022-07-13 14:03:43.654 [http-nio-8193-exec-4] 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)
  49. 2022-07-13 14:03:43.654 [http-nio-8193-exec-4] 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]]
  50. 2022-07-13 14:09:31.004 [http-nio-8193-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
  51. 2022-07-13 14:09:32.143 [http-nio-8193-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"}
  52. 2022-07-13 14:09:32.144 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  53. FROM org
  54. WHERE (is_del = ?)
  55. 2022-07-13 14:09:32.144 [http-nio-8193-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)
  56. 2022-07-13 14:09:32.144 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  57. FROM org
  58. WHERE (is_del = ?) ::: [[0]]
  59. 2022-07-13 14:09:32.185 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
  60. FROM company
  61. WHERE (monitoring_type = ? AND is_del = ?)
  62. 2022-07-13 14:09:32.185 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
  63. 2022-07-13 14:09:32.185 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
  64. FROM company
  65. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
  66. 2022-07-13 14:09:32.190 [http-nio-8193-exec-6] 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)
  67. 2022-07-13 14:09:32.191 [http-nio-8193-exec-6] 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)
  68. 2022-07-13 14:09:32.191 [http-nio-8193-exec-6] 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]]