Exhibit your works

Query : select * from page_languages where lang='en' and page='group';
[ref/Using where]:PRIMARY in PRIMARY (75)
: 12.7 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' and purpose = 'artcollect' order by no desc) limit 0,12;
[ALL/Using where; Using filesort]: in (16)
: 0.8 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' and purpose = 'artcollect')
[ALL/Using where]: in (16)
: 0.4 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