tuichenchuxin commented on issue #13544:
URL:
https://github.com/apache/shardingsphere/issues/13544#issuecomment-981355328
@Comven
```
2021-11-29 15:25:31.203 INFO 53564 --- [p-nio-80-exec-1]
o.d.s.jdbc.controller.TestController : 即将查询[2021-10-01
00:00:00]到[2021-11-30 23:59:59]的订单信息
2021-11-29 15:25:31.253 DEBUG 53564 --- [p-nio-80-exec-1]
o.d.s.j.mapper.OrderInfoDao.queryInfo : ==> Preparing: select id ,
order_no, user_id, add_time from order_info where add_time between ? and ?
order by add_time
2021-11-29 15:25:31.878 DEBUG 53564 --- [p-nio-80-exec-1]
o.d.s.j.mapper.OrderInfoDao.queryInfo : ==> Parameters: 2021-10-01
00:00:00.0(Timestamp), 2021-11-30 23:59:59.0(Timestamp)
2021-11-29 15:25:31.956 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL
: Logic SQL: select
id
, order_no, user_id, add_time
from order_info where add_time between ? and ? order by add_time
2021-11-29 15:25:31.956 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL
: SQLStatement:
MySQLSelectStatement(limit=Optional.empty, lock=Optional.empty,
window=Optional.empty)
2021-11-29 15:25:31.957 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL
: Actual SQL: db1slaver ::: select
id
, order_no, user_id, add_time
from order_info_202110 where add_time between ? and ? order by
add_time ::: [2021-10-01 00:00:00.0, 2021-11-30 23:59:59.0]
2021-11-29 15:25:31.957 INFO 53564 --- [p-nio-80-exec-1] ShardingSphere-SQL
: Actual SQL: db1slaver ::: select
id
, order_no, user_id, add_time
from order_info_202111 where add_time between ? and ? order by
add_time ::: [2021-10-01 00:00:00.0, 2021-11-30 23:59:59.0]
2021-11-29 15:25:32.023 DEBUG 53564 --- [p-nio-80-exec-1]
o.d.s.j.mapper.OrderInfoDao.queryInfo : <== Total: 4
```
--
This is an automated message from the Apache Git Service.
To respond to the message, please log on to GitHub and use the
URL above to go to the specific comment.
To unsubscribe, e-mail: [email protected]
For queries about this service, please contact Infrastructure at:
[email protected]
