Query : select artist,nickname,sum(redsticker + blacksticker) as sm from art where display = 'Y' and regdate >= '2012-05-12' and artist not in (15) group by artist order by sm desc limit 1;
[range/Using where; Using temporary; Using filesort]:idx_reg in idx_artist,idx_reg (1)
: 0.7 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 50] : /home1/www/dev/index.php
Query : select artist,nickname,count(no) as sm from art where display = 'Y' and regdate >= '2012-05-12' and artist not in (15) group by artist order by sm desc limit 1;
[range/Using where; Using temporary; Using filesort]:idx_reg in idx_artist,idx_reg (1)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 58] : /home1/www/dev/index.php
Query : select f.member as artist, m.nickname , count(f.no) as sm from poll_history f join member m on f.member = m.no where f.type='art' and m.type != 99 and f.regdate >= '2012-05-12' and f.member not in (15,16701) group by f.member order by sm desc limit 1;
[ALL/Using where; Using temporary; Using filesort]: in (2606)
: 1.8 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 82] : /home1/www/dev/index.php
Query : select artistno as artist , nickname, count(memberno) as sm from beholdartist where regdate >= '2012-05-12' and artistno not in (15,16701) group by artistno order by sm desc limit 1;
[range/Using where; Using temporary; Using filesort]:idx_reg in idx_reg (1)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 90] : /home1/www/dev/index.php
Query : select t.memberno as artist, t.nickname as nickname , count(t.no) + count(b.no) as sm from group_talk t , group_blog b where b.regdate >= '2012-05-12' and t.regdate >= '2012-05-12' and t.memberno not in (15,16701) group by t.memberno order by sm desc limit 1;
[range/Using where; Using temporary; Using filesort]:idx_regdate in idx_regdate,idx_member (1)
: 0.5 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 98] : /home1/www/dev/index.php
