2022-05-20 01:30
| SQL |
Count
|
AvgTime(S)
|
AvgLockTime(S) |
ReturnRows |
ScanTotalRows |
Index Used Ratio |
DB |
| SET timestamp=N; select * from mail where toUser='S' AND saveFlag != N |
9 |
0.12 |
0.00 |
482.00 |
483.00 |
99.79% |
10.121.51.32->389 |
| use cokdb80; SET timestamp=N; select * from mail where toUser='S' AND saveFlag != N |
8 |
0.11 |
0.00 |
429.00 |
429.00 |
100.00% |
10.121.51.32->392 |
| SET timestamp=N; SELECT t.*, up.`name`,up.pic, up.picVer, up.allianceId, up.banTime, a.al ... |
4 |
1.36 |
0.00 |
300.00 |
300.00 |
100.00% |
10.121.51.32->271 |
| SET timestamp=N; select t1.*, t2.leader from(select t1_1.uid, t1_1.alliancename, t1_1.cur ... |
4 |
0.91 |
0.00 |
199.00 |
199.00 |
100.00% |
10.121.51.32->300 |
| SET timestamp=N; select t1.uid, t1.alliancename, t1.armyKill, t2.leader, t1.nums from (se ... |
4 |
0.62 |
0.00 |
200.00 |
200.00 |
100.00% |
10.121.51.32->330 |
| use cokdb80; SET timestamp=N; TRUNCATE table world_flush_monster_tmp |
4 |
0.28 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->368 |
| use cokdb100; SET timestamp=N; TRUNCATE table world_flush_monster_tmp |
4 |
0.27 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->369 |
| use cokdb100; SET timestamp=N; select orderId, pf, uid, productId, orderInfo, orderPara ... |
4 |
0.18 |
0.00 |
2944.00 |
2944.00 |
100.00% |
10.121.51.32->383 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `contact_3` |
2 |
1.62 |
0.00 |
57857.00 |
57858.00 |
100.00% |
10.121.51.32->256 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `user_god` |
2 |
1.56 |
0.00 |
84054.00 |
84054.00 |
100.00% |
10.121.51.32->259 |
详细SQL
SET timestamp=N; select * from mail where toUser='S' AND saveFlag != N