Exhibit your works

Query : select * from page_languages where lang='en' and page='group';
[ref/Using where]:PRIMARY in PRIMARY (75)
: 3.5 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 177] : /home1/www/dev/lib/language.php
[line : 10] : /home1/www/dev/pages/groups.php

Query : (select * from group_info where auth != 'private' order by no desc) limit 0,12;
[ALL/Using where; Using filesort]: in (16)
: 1.1 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 146] : /home1/www/dev/lib/page.php
[line : 49] : /home1/www/dev/pages/groups.php

Query : (select count(no) as con from group_info where auth != 'private' )
[ALL/Using where]: in (16)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 163] : /home1/www/dev/lib/page.php
[line : 50] : /home1/www/dev/pages/groups.php