# 系统慢日志查询 (B)

+ 根据 SQL 指纹搜索同类慢查询:
  +  先根据最近慢语句 List 查找特定慢语句:
```
select query_time, query, digest
from information_schema.slow_query
where is_internal = false
  and time between '2021-09-01' and '2021-09-02'
order by query_time desc
limit 1;
```
-------------------------------------------------------------
根据 SQL 指纹搜索同类慢查询

- 先根据最近慢语句 List 查找特定慢语句
```
select query_time, query, digest
from information_schema.slow_query
where is_internal = false
  and time between '2021-09-01' and '2021-09-02'
order by query_time desc
limit 1;
+-------------+-----------------------------+------------------------------------------------------------------+
| query_time  | query                       | digest                                                           |
+-------------+-----------------------------+------------------------------------------------------------------+
| 0.302558006 | select * from t1 where a=1; | 4751cb6008fda383e22dacb601fde85425dc8f8cf669338d55d944bafb46a6fa |
+-------------+-----------------------------+------------------------------------------------------------------+
```