1
2
3
4
5
6
7
8
9
10
11
12
|
# Time: 101214 16:12:28
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 0.214821 Lock_time: 0.000162 Rows_sent: 10 Rows_examined: 2009
use issue_123;
SET timestamp=1292361148;
select t.a_123, count(*) from t join t t2 using(a) group by 1 order by 2 desc limit 10;
# Time: 101214 16:12:29
# User@Host: root[root] @ localhost [127.0.0.1]
# Query_time: 0.214822 Lock_time: 0.000164 Rows_sent: 1 Rows_examined: 200
use issue_124;
SET timestamp=1292361148;
select t.a_124, count(*) from t join t t2 using(a) group by 1 order by 2 desc limit 10;
|
