| 123456789101112131415161718192021222324252627282930313233343536373839404142434445464748495051525354555657585960616263646566676869707172737475767778798081828384858687888990919293949596979899100101102103104105106107108109110111112113114115116117118119120121122123124125126127128129130131132133134135136137138139140141142143144145146147148149150151152153154155156157158159160161162163164165166167168169170171172173174175176177178179180181182183184185186187188189190191192193194195196197198199200201202203204205206207208209210211212213214215216217218219220221222223224225226227228229230231232233234235236237238239240241242243244245246247248249250251252253254255256257258259260261262263264265266267268269270271272273274275276277278279280281282283284285286287288289290291292293294295296297298299300301302303304305306307308309310311312313314315316317318319320321322323324325326327 |
- 2022-07-22 11:40:05.838 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
- 2022-07-22 11:40:08.528 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
- 2022-07-22 11:40:08.529 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 11:40:08.529 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 11:40:08.679 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 11:40:11.342 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 11:40:11.505 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 11:40:11.661 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 11:40:13.928 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
- 2022-07-22 11:40:14.785 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 14.506 seconds (JVM running for 16.728)
- 2022-07-22 11:43:05.763 [http-nio-8198-exec-2] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
- 2022-07-22 11:43:05.811 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:43:06.818 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:43:35.810 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:43:35.827 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:46:10.361 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closing ...
- 2022-07-22 11:46:10.370 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
- 2022-07-22 11:46:10.370 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closing ...
- 2022-07-22 11:46:10.376 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closed
- 2022-07-22 11:46:10.376 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closing ...
- 2022-07-22 11:46:10.381 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closed
- 2022-07-22 11:47:43.725 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:47:43.736 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:47:50.854 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:47:50.868 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:48:27.310 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
- 2022-07-22 11:48:29.232 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
- 2022-07-22 11:48:29.233 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 11:48:29.233 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 11:48:29.374 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 11:48:34.327 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 11:48:36.810 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 11:48:39.204 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 11:48:50.100 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
- 2022-07-22 11:48:50.775 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 29.944 seconds (JVM running for 31.107)
- 2022-07-22 11:49:36.151 [http-nio-8198-exec-4] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
- 2022-07-22 11:49:36.191 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:49:37.104 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:52:24.739 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dict/getOrgList
- 2022-07-22 11:52:24.774 [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"}
- 2022-07-22 11:52:24.900 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 11:52:24.901 [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)
- 2022-07-22 11:52:24.901 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 11:53:21.201 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:53:21.212 [http-nio-8198-exec-3] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:53:40.006 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:53:40.018 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:55:00.179 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:55:01.157 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:55:24.500 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dict/getOrgList
- 2022-07-22 11:55:24.532 [http-nio-8198-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-22 11:55:24.533 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 11:55:24.534 [http-nio-8198-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-22 11:55:24.534 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 11:55:58.703 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:55:58.715 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:56:55.838 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:58:06.898 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - 尚未登录,请登录!
- 2022-07-22 11:58:57.981 [http-nio-8198-exec-2] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 11:59:19.073 [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"}
- 2022-07-22 11:59:19.077 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 11:59:19.077 [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)
- 2022-07-22 11:59:19.077 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 11:59:19.666 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 11:59:19.666 [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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 11:59:19.667 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 11:59:19.721 [http-nio-8198-exec-2] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:00:50.751 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
- 2022-07-22 12:00:53.188 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
- 2022-07-22 12:00:53.189 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 12:00:53.190 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 12:00:53.353 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 12:00:58.831 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 12:01:01.365 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 12:01:03.954 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 12:01:14.472 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
- 2022-07-22 12:01:15.182 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 30.03 seconds (JVM running for 32.488)
- 2022-07-22 12:01:27.024 [http-nio-8198-exec-1] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
- 2022-07-22 12:01:27.071 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:01:38.229 [http-nio-8198-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-22 12:01:42.609 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:01:42.613 [http-nio-8198-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-22 12:01:42.613 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:01:42.867 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:01:42.869 [http-nio-8198-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)
- 2022-07-22 12:01:42.870 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:01:42.971 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:01:42.971 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:01:42.972 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:02:06.961 [http-nio-8198-exec-4] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:02:06.975 [http-nio-8198-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-22 12:02:11.617 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:02:11.617 [http-nio-8198-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-22 12:02:11.617 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:02:11.662 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:02:11.662 [http-nio-8198-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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 12:02:11.662 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:02:11.705 [http-nio-8198-exec-4] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:02:28.914 [http-nio-8198-exec-6] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:02:28.922 [http-nio-8198-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-22 12:02:37.470 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:02:37.471 [http-nio-8198-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-22 12:02:37.471 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:02:37.515 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:02:37.515 [http-nio-8198-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)
- 2022-07-22 12:02:37.515 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:03:28.206 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:03:28.207 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:03:28.207 [http-nio-8198-exec-6] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:04:31.094 [http-nio-8198-exec-8] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:04:31.106 [http-nio-8198-exec-8] 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-22 12:04:37.083 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:04:37.083 [http-nio-8198-exec-8] 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-22 12:04:37.083 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] 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)
- 2022-07-22 12:04:37.700 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:04:55.776 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:04:55.777 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:04:55.779 [http-nio-8198-exec-8] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:05:45.549 [http-nio-8198-exec-10] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:05:45.556 [http-nio-8198-exec-10] 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-22 12:05:45.557 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:05:45.557 [http-nio-8198-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)
- 2022-07-22 12:05:45.557 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:05:45.606 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:05:45.607 [http-nio-8198-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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 12:05:45.607 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:07:14.710 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:07:14.710 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:07:14.711 [http-nio-8198-exec-10] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:11:47.849 [http-nio-8198-exec-5] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:11:47.860 [http-nio-8198-exec-5] 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-22 12:11:47.863 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:11:47.863 [http-nio-8198-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)
- 2022-07-22 12:11:47.863 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:11:48.429 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:11:48.429 [http-nio-8198-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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 12:11:48.429 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:11:52.960 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:11:52.997 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:11:52.998 [http-nio-8198-exec-5] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:14:25.767 [http-nio-8198-exec-7] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:14:25.775 [http-nio-8198-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"}
- 2022-07-22 12:14:25.776 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:14:25.776 [http-nio-8198-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)
- 2022-07-22 12:14:25.776 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:14:26.320 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:14:26.320 [http-nio-8198-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)
- 2022-07-22 12:14:26.320 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - SQLStatement: SelectStatement(super=DQLStatement(super=AbstractSQLStatement(type=DQL, tables=Tables(tables=[]), conditions=Conditions(orCondition=OrCondition(andConditions=[])), sqlTokens=[], 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)
- 2022-07-22 12:14:29.321 [http-nio-8198-exec-7] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:24:09.095 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closing ...
- 2022-07-22 12:24:09.097 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} closed
- 2022-07-22 12:24:09.098 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closing ...
- 2022-07-22 12:24:09.101 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} closed
- 2022-07-22 12:24:09.101 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closing ...
- 2022-07-22 12:24:09.105 [Apollo-Config-2] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} closed
- 2022-07-22 12:24:19.227 [http-nio-8198-exec-9] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:24:19.235 [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"}
- 2022-07-22 12:24:22.389 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-4} inited
- 2022-07-22 12:24:24.933 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-5} inited
- 2022-07-22 12:24:27.423 [http-nio-8198-exec-9] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-6} inited
- 2022-07-22 12:24:40.855 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:24:40.855 [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)
- 2022-07-22 12:24:40.856 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:24:40.903 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:24:40.904 [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=1)), containStar=true, selectListLastPosition=9, groupByLastPosition=0, items=[StarSelectItem(owner=Optional.absent())], groupByItems=[], orderByItems=[], limit=null, subQueryStatement=null)
- 2022-07-22 12:24:40.904 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:24:40.950 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:24:40.950 [http-nio-8198-exec-9] 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)
- 2022-07-22 12:24:40.951 [http-nio-8198-exec-9] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
- 2022-07-22 12:24:55.115 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - The following profiles are active: dev
- 2022-07-22 12:24:56.976 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Initializing ProtocolHandler ["http-nio-8198"]
- 2022-07-22 12:24:56.977 [main] INFO org.apache.catalina.core.StandardService - Starting service [Tomcat]
- 2022-07-22 12:24:56.977 [main] INFO org.apache.catalina.core.StandardEngine - Starting Servlet engine: [Apache Tomcat/9.0.48]
- 2022-07-22 12:24:57.106 [main] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring embedded WebApplicationContext
- 2022-07-22 12:25:01.561 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-1} inited
- 2022-07-22 12:25:04.099 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-2} inited
- 2022-07-22 12:25:06.693 [main] INFO com.alibaba.druid.pool.DruidDataSource - {dataSource-3} inited
- 2022-07-22 12:25:19.905 [main] INFO org.apache.coyote.http11.Http11NioProtocol - Starting ProtocolHandler ["http-nio-8198"]
- 2022-07-22 12:25:20.519 [main] INFO com.yyjc.fbs.mobile.FbsMobileServiceApplication - Started FbsMobileServiceApplication in 30.402 seconds (JVM running for 32.489)
- 2022-07-22 12:25:31.117 [http-nio-8198-exec-1] INFO org.apache.catalina.core.ContainerBase.[Tomcat].[localhost].[/mobile] - Initializing Spring DispatcherServlet 'dispatcherServlet'
- 2022-07-22 12:25:31.164 [http-nio-8198-exec-1] INFO com.yyjc.fbs.config.ProxyVerfiyAspect - [verify uri is]===/mobile/dataBoard/selectSmokeTendency
- 2022-07-22 12:25:31.187 [http-nio-8198-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-22 12:25:31.350 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM org
- WHERE (is_del = ?)
- 2022-07-22 12:25:31.351 [http-nio-8198-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-22 12:25:31.352 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM org
- WHERE (is_del = ?) ::: [[0]]
- 2022-07-22 12:25:31.496 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT *
- FROM company
- WHERE (monitoring_type = ?)
- 2022-07-22 12:25:31.497 [http-nio-8198-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)
- 2022-07-22 12:25:31.497 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-sysbase ::: SELECT *
- FROM company
- WHERE (monitoring_type = ?) ::: [[0]]
- 2022-07-22 12:25:31.560 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Logic SQL: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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))
- 2022-07-22 12:25:31.561 [http-nio-8198-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)
- 2022-07-22 12:25:31.561 [http-nio-8198-exec-1] INFO Sharding-Sphere-SQL - Actual SQL: cems-2022 ::: SELECT mn,company_id,upload_date,smoke_total,voc_total,pm25_total
- FROM anal_monitor_date
- 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]]
|