| 1234567891011121314151617181920212223242526272829303132333435363738394041424344454647484950515253545556575859606162636465666768 |
- 2022-07-13 14:03:03.856 [main] INFO com.yyjc.fbs.sys.CemsSysServiceApplication - The following profiles are active: dev
- 2022-07-13 14:03:05.866 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8193"]
- 2022-07-13 14:03:05.867 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-13 14:03:05.867 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-13 14:03:05.996 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/sys] - Initializing Spring embedded WebApplicationContext
- 2022-07-13 14:03:08.345 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-13 14:03:08.451 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-13 14:03:08.549 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-13 14:03:10.845 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8193"]
- 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)
- 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'
- 2022-07-13 14:03:21.477 [http-nio-8193-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
- 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"}
- 2022-07-13 14:03:21.696 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 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)
- 2022-07-13 14:03:21.697 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-13 14:03:21.767 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?)
- 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)
- 2022-07-13 14:03:21.767 [http-nio-8193-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
- 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)
- 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)
- 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]]
- 2022-07-13 14:03:43.625 [http-nio-8193-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
- 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"}
- 2022-07-13 14:03:43.641 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 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)
- 2022-07-13 14:03:43.641 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-13 14:03:43.647 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?)
- 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)
- 2022-07-13 14:03:43.647 [http-nio-8193-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
- 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)
- 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)
- 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]]
- 2022-07-13 14:09:31.004 [http-nio-8193-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/sys/dataBoard/selectOverCompany
- 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"}
- 2022-07-13 14:09:32.144 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 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)
- 2022-07-13 14:09:32.144 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-13 14:09:32.185 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?)
- 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)
- 2022-07-13 14:09:32.185 [http-nio-8193-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ? AND is_del = ?) ::: [[0, 0]]
- 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)
- 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)
- 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]]
|