Главная Обзор Помощь
Регистрация Вход
YouYan
/
IOT
2
0
Ответвить 0
Файлы Задачи 0 Запросы на слияние 0 Вики
Ветка: master
Ветки Метки
IOT
/
SourceCode
/
logs
/
cems-sys-service.2022-06-30.0.log

cems-sys-service.2022-06-30.0.log 38 KB
Постоянная ссылка История Исходник

123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231 
  1. 2022-06-30 11:26:56.776 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    2. 

  2. 2022-06-30 11:26:59.328 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    3. 

  3. 2022-06-30 11:26:59.328 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    4. 

  4. 2022-06-30 11:26:59.329 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    5. 

  5. 2022-06-30 11:26:59.462 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    6. 

  6. 2022-06-30 11:27:04.113 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    7. 

  7. 2022-06-30 11:27:04.286 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    8. 

  8. 2022-06-30 11:27:04.452 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    9. 

  9. 2022-06-30 11:27:08.093 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    10. 

  10. 2022-06-30 11:27:10.935 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 42.932 seconds (JVM running for 47.886)
    11. 

  11. 2022-06-30 11:33:15.198 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    12. 

  12. 2022-06-30 11:33:18.913 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    13. 

  13. 2022-06-30 11:33:18.913 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    14. 

  14. 2022-06-30 11:33:18.914 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    15. 

  15. 2022-06-30 11:33:19.098 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    16. 

  16. 2022-06-30 11:33:23.193 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    17. 

  17. 2022-06-30 11:33:23.352 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    18. 

  18. 2022-06-30 11:33:23.518 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    19. 

  19. 2022-06-30 11:33:26.742 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    20. 

  20. 2022-06-30 11:33:29.462 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 22.108 seconds (JVM running for 25.222)
    21. 

  21. 2022-06-30 11:39:22.373 [http-nio-8193-exec-3] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
    22. 

  22. 2022-06-30 11:39:22.418 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    23. 

  23. 2022-06-30 11:39:23.669 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    24. 

  24. 2022-06-30 11:40:34.529 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    25. 

  25. 2022-06-30 11:40:34.543 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    26. 

  26. 2022-06-30 11:41:05.018 [http-nio-8193-exec-7] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    27. 

  27. 2022-06-30 11:41:05.031 [http-nio-8193-exec-7] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    28. 

  28. 2022-06-30 11:42:32.430 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    29. 

  29. 2022-06-30 11:42:32.446 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    30. 

  30. 2022-06-30 11:43:16.589 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    31. 

  31. 2022-06-30 11:43:16.606 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    32. 

  32. 2022-06-30 11:44:15.051 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    33. 

  33. 2022-06-30 11:44:15.069 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    34. 

  34. 2022-06-30 11:47:01.706 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/monitor/getDeviceList
    35. 

  35. 2022-06-30 11:47:01.719 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录，请登录!
    36. 

  36. 2022-06-30 11:48:44.953 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    37. 

  37. 2022-06-30 11:48:44.993 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    38. 

  38. 2022-06-30 11:49:02.420 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    39. 

  39. FROM org
    40. 

  40. WHERE (is_del = ?)
    41. 

  41. 2022-06-30 11:49:02.429 [http-nio-8193-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)
    42. 

  42. 2022-06-30 11:49:02.429 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    43. 

  43. FROM org
    44. 

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

  45. 2022-06-30 11:49:02.800 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    46. 

  46. FROM company
    47. 

  47. WHERE (monitoring_type = ? AND is_del = ?)
    48. 

  48. 2022-06-30 11:49:02.801 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    49. 

  49. 2022-06-30 11:49:02.802 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    50. 

  50. FROM company
    51. 

  51. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    52. 

  52. 2022-06-30 11:49:03.065 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_total > 0)
    53. 

  53. 2022-06-30 11:49:03.066 [http-nio-8193-exec-10] 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)
    54. 

  54. 2022-06-30 11:49:03.067 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_total > 0) ::: [[20220630]]
    55. 

  55. 2022-06-30 11:50:10.992 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    56. 

  56. 2022-06-30 11:50:11.006 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    57. 

  57. 2022-06-30 11:50:37.402 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    58. 

  58. FROM org
    59. 

  59. WHERE (is_del = ?)
    60. 

  60. 2022-06-30 11:50:37.406 [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)
    61. 

  61. 2022-06-30 11:50:37.409 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    62. 

  62. FROM org
    63. 

  63. WHERE (is_del = ?) ::: [[0]]
    64. 

  64. 2022-06-30 11:50:46.210 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    65. 

  65. FROM company
    66. 

  66. WHERE (monitoring_type = ? AND is_del = ?)
    67. 

  67. 2022-06-30 11:50:46.212 [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)
    68. 

  68. 2022-06-30 11:50:46.216 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    69. 

  69. FROM company
    70. 

  70. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    71. 

  71. 2022-06-30 11:51:03.182 [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, 5) AND exceed_smoke_num > 0)
    72. 

  72. 2022-06-30 11:51:03.183 [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)
    73. 

  73. 2022-06-30 11:51:03.185 [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, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    74. 

  74. 2022-06-30 11:52:28.669 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    75. 

  75. 2022-06-30 11:52:30.876 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    76. 

  76. 2022-06-30 11:52:30.877 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    77. 

  77. 2022-06-30 11:52:30.877 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    78. 

  78. 2022-06-30 11:52:30.990 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    79. 

  79. 2022-06-30 11:52:33.551 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    80. 

  80. 2022-06-30 11:52:33.677 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    81. 

  81. 2022-06-30 11:52:33.801 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    82. 

  82. 2022-06-30 11:52:35.401 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    83. 

  83. 2022-06-30 11:52:36.801 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 13.464 seconds (JVM running for 14.903)
    84. 

  84. 2022-06-30 11:52:54.908 [http-nio-8193-exec-5] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
    85. 

  85. 2022-06-30 11:52:54.967 [http-nio-8193-exec-5] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    86. 

  86. 2022-06-30 11:52:54.985 [http-nio-8193-exec-5] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    87. 

  87. 2022-06-30 11:52:55.128 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    88. 

  88. FROM org
    89. 

  89. WHERE (is_del = ?)
    90. 

  90. 2022-06-30 11:52:55.128 [http-nio-8193-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)
    91. 

  91. 2022-06-30 11:52:55.128 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    92. 

  92. FROM org
    93. 

  93. WHERE (is_del = ?) ::: [[0]]
    94. 

  94. 2022-06-30 11:52:55.193 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    95. 

  95. FROM company
    96. 

  96. WHERE (monitoring_type = ? AND is_del = ?)
    97. 

  97. 2022-06-30 11:52:55.194 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    98. 

  98. 2022-06-30 11:52:55.194 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    99. 

  99. FROM company
    100. 

  100. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    101. 

  101. 2022-06-30 11:52:55.245 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0)
    102. 

  102. 2022-06-30 11:52:55.246 [http-nio-8193-exec-5] 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)
    103. 

  103. 2022-06-30 11:52:55.246 [http-nio-8193-exec-5] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    104. 

  104. 2022-06-30 11:53:12.057 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    105. 

  105. 2022-06-30 11:53:12.066 [http-nio-8193-exec-3] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    106. 

  106. 2022-06-30 11:53:12.066 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    107. 

  107. FROM org
    108. 

  108. WHERE (is_del = ?)
    109. 

  109. 2022-06-30 11:53:12.066 [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)
    110. 

  110. 2022-06-30 11:53:12.066 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    111. 

  111. FROM org
    112. 

  112. WHERE (is_del = ?) ::: [[0]]
    113. 

  113. 2022-06-30 11:53:12.073 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    114. 

  114. FROM company
    115. 

  115. WHERE (monitoring_type = ? AND is_del = ?)
    116. 

  116. 2022-06-30 11:53:12.073 [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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    117. 

  117. 2022-06-30 11:53:12.073 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    118. 

  118. FROM company
    119. 

  119. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    120. 

  120. 2022-06-30 11:53:12.077 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0)
    121. 

  121. 2022-06-30 11:53:12.077 [http-nio-8193-exec-3] 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)
    122. 

  122. 2022-06-30 11:53:12.077 [http-nio-8193-exec-3] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    123. 

  123. 2022-06-30 11:53:17.562 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    124. 

  124. 2022-06-30 11:53:17.580 [http-nio-8193-exec-4] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    125. 

  125. 2022-06-30 11:53:17.581 [http-nio-8193-exec-4] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    126. 

  126. FROM org
    127. 

  127. WHERE (is_del = ?)
    128. 

  128. 2022-06-30 11:53:17.581 [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)
    129. 

  129. 2022-06-30 11:53:17.581 [http-nio-8193-exec-4] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    130. 

  130. FROM org
    131. 

  131. WHERE (is_del = ?) ::: [[0]]
    132. 

  132. 2022-06-30 11:53:17.585 [http-nio-8193-exec-4] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    133. 

  133. FROM company
    134. 

  134. WHERE (monitoring_type = ? AND is_del = ?)
    135. 

  135. 2022-06-30 11:53:17.585 [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)
    136. 

  136. 2022-06-30 11:53:17.585 [http-nio-8193-exec-4] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    137. 

  137. FROM company
    138. 

  138. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    139. 

  139. 2022-06-30 11:53:17.591 [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, 5) AND exceed_smoke_num > 0)
    140. 

  140. 2022-06-30 11:53:17.591 [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)
    141. 

  141. 2022-06-30 11:53:17.591 [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, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    142. 

  142. 2022-06-30 11:53:25.507 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    143. 

  143. 2022-06-30 11:53:25.515 [http-nio-8193-exec-10] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    144. 

  144. 2022-06-30 11:53:25.517 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    145. 

  145. FROM org
    146. 

  146. WHERE (is_del = ?)
    147. 

  147. 2022-06-30 11:53:25.517 [http-nio-8193-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)
    148. 

  148. 2022-06-30 11:53:25.518 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    149. 

  149. FROM org
    150. 

  150. WHERE (is_del = ?) ::: [[0]]
    151. 

  151. 2022-06-30 11:53:25.520 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    152. 

  152. FROM company
    153. 

  153. WHERE (monitoring_type = ? AND is_del = ?)
    154. 

  154. 2022-06-30 11:53:25.521 [http-nio-8193-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=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
    155. 

  155. 2022-06-30 11:53:25.521 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    156. 

  156. FROM company
    157. 

  157. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    158. 

  158. 2022-06-30 11:53:25.524 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0)
    159. 

  159. 2022-06-30 11:53:25.524 [http-nio-8193-exec-10] 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)
    160. 

  160. 2022-06-30 11:53:25.524 [http-nio-8193-exec-10] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT count(0) FROM company_warn_statistics WHERE (upload_date = ? AND company_id IN (1, 2, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    161. 

  161. 2022-06-30 11:54:13.806 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    162. 

  162. 2022-06-30 11:54:16.571 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    163. 

  163. 2022-06-30 11:54:16.572 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    164. 

  164. 2022-06-30 11:54:16.573 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    165. 

  165. 2022-06-30 11:54:16.743 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    166. 

  166. 2022-06-30 11:54:20.221 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    167. 

  167. 2022-06-30 11:54:20.364 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    168. 

  168. 2022-06-30 11:54:20.516 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    169. 

  169. 2022-06-30 11:54:22.523 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    170. 

  170. 2022-06-30 11:54:24.263 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 19.481 seconds (JVM running for 21.504)
    171. 

  171. 2022-06-30 11:54:33.481 [http-nio-8193-exec-1] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
    172. 

  172. 2022-06-30 11:54:33.549 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    173. 

  173. 2022-06-30 11:54:33.567 [http-nio-8193-exec-1] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"8","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    174. 

  174. 2022-06-30 11:54:43.855 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    175. 

  175. FROM org
    176. 

  176. WHERE (is_del = ?)
    177. 

  177. 2022-06-30 11:54:43.862 [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)
    178. 

  178. 2022-06-30 11:54:43.864 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    179. 

  179. FROM org
    180. 

  180. WHERE (is_del = ?) ::: [[0]]
    181. 

  181. 2022-06-30 11:54:46.504 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    182. 

  182. FROM company
    183. 

  183. WHERE (monitoring_type = ? AND is_del = ?)
    184. 

  184. 2022-06-30 11:54:46.504 [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)
    185. 

  185. 2022-06-30 11:54:46.505 [http-nio-8193-exec-1] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    186. 

  186. FROM company
    187. 

  187. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    188. 

  188. 2022-06-30 11:55:14.785 [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, 5) AND exceed_smoke_num > 0)
    189. 

  189. 2022-06-30 11:55:14.785 [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)
    190. 

  190. 2022-06-30 11:55:14.786 [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, 5) AND exceed_smoke_num > 0) ::: [[20220630]]
    191. 

  191. 2022-06-30 13:09:05.305 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
    192. 

  192. 2022-06-30 13:09:07.891 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
    193. 

  193. 2022-06-30 13:09:07.892 [main] INFO  org.apache.catalina.core.StandardService - Starting service [Tomcat]
    194. 

  194. 2022-06-30 13:09:07.893 [main] INFO  org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
    195. 

  195. 2022-06-30 13:09:08.036 [main] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
    196. 

  196. 2022-06-30 13:09:10.877 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
    197. 

  197. 2022-06-30 13:09:10.990 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
    198. 

  198. 2022-06-30 13:09:11.094 [main] INFO  com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
    199. 

  199. 2022-06-30 13:09:12.764 [main] INFO  org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
    200. 

  200. 2022-06-30 13:09:14.221 [main] INFO  com.yyjc.fbs.sys.CemsSysServiceApplication - Started CemsSysServiceApplication in 13.852 seconds (JVM running for 15.321)
    201. 

  201. 2022-06-30 13:10:52.314 [http-nio-8193-exec-2] INFO  org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring DispatcherServlet 'dispatcherServlet'
    202. 

  202. 2022-06-30 13:10:52.379 [http-nio-8193-exec-2] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
    203. 

  203. 2022-06-30 13:10:53.384 [http-nio-8193-exec-2] INFO  com.yyjc.fbs.config.ProxyVerfiyAspect - {"address":"大数据","email":"42","enabled":true,"enterprise_id":"116","id":1,"name":"管理员","phone":"15850773141","sex":"0","telephone":"89511","user_type":0,"username":"admin"}
    204. 

  204. 2022-06-30 13:11:05.954 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    205. 

  205. FROM org
    206. 

  206. WHERE (is_del = ?)
    207. 

  207. 2022-06-30 13:11:05.961 [http-nio-8193-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)
    208. 

  208. 2022-06-30 13:11:05.962 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    209. 

  209. FROM org
    210. 

  210. WHERE (is_del = ?) ::: [[0]]
    211. 

  211. 2022-06-30 13:11:11.536 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    212. 

  212. FROM company
    213. 

  213. WHERE (monitoring_type = ? AND is_del = ?)
    214. 

  214. 2022-06-30 13:11:11.536 [http-nio-8193-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)
    215. 

  215. 2022-06-30 13:11:11.537 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
    216. 

  216. FROM company
    217. 

  217. WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
    218. 

  218. 2022-06-30 13:11:50.459 [http-nio-8193-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)
    219. 

  219. 2022-06-30 13:11:50.460 [http-nio-8193-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)
    220. 

  220. 2022-06-30 13:11:50.461 [http-nio-8193-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) ::: [[20220630]]
    221. 

  221. 2022-06-30 13:11:50.532 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Logic SQL: SELECT *
    222. 

  222. FROM company_warn_statistics
    223. 

  223. 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)
    224. 

  224. ORDER BY exceed_smoke_num desc
    225. 

  225.  LIMIT ? 
    226. 

  226. 2022-06-30 13:11:50.532 [http-nio-8193-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=14, skippedSchemaNameLength=0, originalLiterals=company_warn_statistics)], parametersIndex=2)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[OrderItem(owner=Optional.absent(), name=Optional.of(exceed_smoke_num), orderDirection=DESC, nullOrderDirection=ASC, index=-1, alias=Optional.absent())], limit=null, subQueryStatement=null)
    227. 

  227. 2022-06-30 13:11:50.533 [http-nio-8193-exec-2] INFO  Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT *
    228. 

  228. FROM company_warn_statistics
    229. 

  229. 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)
    230. 

  230. ORDER BY exceed_smoke_num desc
    231. 

  231.  LIMIT ?  ::: [[20220630, 6]]
    232.