Query : select artistno as artist , nickname, count(memberno) as sm from beholdartist where regdate >= '2012-01-20' and artistno not in (15,16497,16300,16484,16496) group by artistno order by sm desc limit 1;
[range/Using where; Using temporary; Using filesort]:idx_reg in idx_reg (1)
: 1.2 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-01-20' and t.regdate >= '2012-01-20' and t.memberno not in (15,16497,16300,16484,16496) 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