2022-05-20 01:30
| SQL |
Count
|
AvgTime(S)
|
AvgLockTime(S) |
ReturnRows |
ScanTotalRows |
Index Used Ratio |
DB |
| SET timestamp=N; update alliance_member set yesterdayLogin = N |
1 |
0.00 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->398 |
|
1 |
0.00 |
0.00 |
0.00 |
0.00 |
100.00% |
10.153.120.42->399 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `alliance_help` |
1 |
0.10 |
0.00 |
2635.00 |
2635.00 |
100.00% |
10.121.51.32->394 |
| SET timestamp=N; update alliance a inner join (select count(N) sum,allianceId from allian ... |
1 |
0.10 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->395 |
| SET timestamp=N; select u.uid,u.`name`,w.id,w.x,w.y,ub.itemId,ub.`level`,ur.food,ur.wood, ... |
1 |
0.10 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->396 |
| use cokdb100; SET timestamp=N; select u.uid,u.`name`,w.id,w.x,w.y,ub.itemId,ub.`level`,u ... |
1 |
0.10 |
0.00 |
0.00 |
0.00 |
100.00% |
10.121.51.32->397 |
| SET timestamp=N; SELECT /*!N SQL_NO_CACHE */ * FROM `userprofile_bak` |
1 |
0.11 |
0.00 |
4403.00 |
4403.00 |
100.00% |
10.121.51.32->391 |
| 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 |
| use cokdb80; SET timestamp=N; select `uid`, `level`, `exp`, `name`, `banTime` from userp ... |
2 |
0.11 |
0.00 |
450.00 |
450.00 |
100.00% |
10.121.51.32->393 |
| 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 |
详细SQL
SET timestamp=N; update alliance_member set yesterdayLogin = N