صفحهٔ اصلی گشت‌و‌گذار راهنما
ثبت نام ورود
YouYan
/
Server
2
0
انشعاب 0
پرونده‌ها مشکلات 0 درخواست واکشی 0 ویکی
درخت: 72dd0511a0
شاخه‌ها تگ‌ها
Server
/
fbs_code
/
logs
/
cems-sys-service.2022-07-22.0.log

cems-sys-service.2022-07-22.0.log 17 KB
تاريخچه خام

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103 
  1. 2022-07-22 12:08:30.621 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    2. 

  2. 2022-07-22 12:08:34.297 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    3. 

  3. 2022-07-22 12:08:34.298 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    4. 

  4. 2022-07-22 12:08:34.298 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    5. 

  5. 2022-07-22 12:08:34.542 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    6. 

  6. 2022-07-22 12:08:41.105 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    7. 

  7. 2022-07-22 12:08:43.801 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    8. 

  8. 2022-07-22 12:08:46.386 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    9. 

  9. 2022-07-22 12:08:59.644 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    10. 

  10. 2022-07-22 12:09:01.127 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 35.202 seconds (JVM running for 36.824)
    11. 

  11. 2022-07-22 12:09:48.309 [http-nio-8193-exec-1] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
    12. 

  12. 2022-07-22 12:09:48.358 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectSmokeTendency
    13. 

  13. 2022-07-22 12:09:48.382 [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. 

  14. 2022-07-22 12:09:48.552 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    15. 

  15. FROM org
    16. 

  16. WHERE (is_del = ?)
    17. 

  17. 2022-07-22 12:09:48.554 [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. 

  18. 2022-07-22 12:09:48.554 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    19. 

  19. FROM org
    20. 

  20. WHERE (is_del = ?) ::: [[0]]
    21. 

  21. 2022-07-22 12:09:48.679 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    22. 

  22. FROM company
    23. 

  23. WHERE (monitoring_type = ?)
    24. 

  24. 2022-07-22 12:09:48.679 [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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    25. 

  25. 2022-07-22 12:09:48.679 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    26. 

  26. FROM company
    27. 

  27. WHERE (monitoring_type = ?) ::: [[0]]
    28. 

  28. 2022-07-22 12:09:48.775 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    29. 

  29. FROM anal_monitor_date
    30. 

  30. 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))
    31. 

  31. 2022-07-22 12:09:48.775 [http-nio-8193-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)
    32. 

  32. 2022-07-22 12:09:48.775 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    33. 

  33. FROM anal_monitor_date
    34. 

  34. 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]]
    35. 

  35. 2022-07-22 12:10:34.390 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectSmokeTendency
    36. 

  36. 2022-07-22 12:10:34.397 [http-nio-8193-exec-3] 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"}
    37. 

  37. 2022-07-22 12:10:34.397 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    38. 

  38. FROM org
    39. 

  39. WHERE (is_del = ?)
    40. 

  40. 2022-07-22 12:10:34.397 [http-nio-8193-exec-3] 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)
    41. 

  41. 2022-07-22 12:10:34.397 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    42. 

  42. FROM org
    43. 

  43. WHERE (is_del = ?) ::: [[0]]
    44. 

  44. 2022-07-22 12:10:34.443 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    45. 

  45. FROM company
    46. 

  46. WHERE (monitoring_type = ?)
    47. 

  47. 2022-07-22 12:10:34.443 [http-nio-8193-exec-3] 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)
    48. 

  48. 2022-07-22 12:10:34.443 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    49. 

  49. FROM company
    50. 

  50. WHERE (monitoring_type = ?) ::: [[0]]
    51. 

  51. 2022-07-22 12:11:17.343 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    52. 

  52. FROM anal_monitor_date
    53. 

  53. 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))
    54. 

  54. 2022-07-22 12:11:17.343 [http-nio-8193-exec-3] 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)
    55. 

  55. 2022-07-22 12:11:17.343 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    56. 

  56. FROM anal_monitor_date
    57. 

  57. 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]]
    58. 

  58. 2022-07-22 12:20:21.005 [http-nio-8193-exec-6] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectSmokeTendency
    59. 

  59. 2022-07-22 12:20:21.013 [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"}
    60. 

  60. 2022-07-22 12:20:21.014 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    61. 

  61. FROM org
    62. 

  62. WHERE (is_del = ?)
    63. 

  63. 2022-07-22 12:20:21.014 [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)
    64. 

  64. 2022-07-22 12:20:21.014 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    65. 

  65. FROM org
    66. 

  66. WHERE (is_del = ?) ::: [[0]]
    67. 

  67. 2022-07-22 12:20:21.527 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    68. 

  68. FROM company
    69. 

  69. WHERE (monitoring_type = ?)
    70. 

  70. 2022-07-22 12:20:21.528 [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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    71. 

  71. 2022-07-22 12:20:21.528 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    72. 

  72. FROM company
    73. 

  73. WHERE (monitoring_type = ?) ::: [[0]]
    74. 

  74. 2022-07-22 12:21:00.462 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    75. 

  75. FROM anal_monitor_date
    76. 

  76. 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))
    77. 

  77. 2022-07-22 12:21:00.463 [http-nio-8193-exec-6] 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)
    78. 

  78. 2022-07-22 12:21:00.463 [http-nio-8193-exec-6] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    79. 

  79. FROM anal_monitor_date
    80. 

  80. 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]]
    81. 

  81. 2022-07-22 12:21:15.778 [http-nio-8193-exec-7] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectSmokeTendency
    82. 

  82. 2022-07-22 12:21:15.789 [http-nio-8193-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"}
    83. 

  83. 2022-07-22 12:21:15.790 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    84. 

  84. FROM org
    85. 

  85. WHERE (is_del = ?)
    86. 

  86. 2022-07-22 12:21:15.791 [http-nio-8193-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)
    87. 

  87. 2022-07-22 12:21:15.791 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    88. 

  88. FROM org
    89. 

  89. WHERE (is_del = ?) ::: [[0]]
    90. 

  90. 2022-07-22 12:21:15.830 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    91. 

  91. FROM company
    92. 

  92. WHERE (monitoring_type = ?)
    93. 

  93. 2022-07-22 12:21:15.830 [http-nio-8193-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)
    94. 

  94. 2022-07-22 12:21:15.830 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    95. 

  95. FROM company
    96. 

  96. WHERE (monitoring_type = ?) ::: [[0]]
    97. 

  97. 2022-07-22 12:21:17.736 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    98. 

  98. FROM anal_monitor_date
    99. 

  99. 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))
    100. 

  100. 2022-07-22 12:21:17.736 [http-nio-8193-exec-7] 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)
    101. 

  101. 2022-07-22 12:21:17.737 [http-nio-8193-exec-7] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
    102. 

  102. FROM anal_monitor_date
    103. 

  103. 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]]
    104.