Exhibit your works

Query : (select * from group_info where auth != 'private' and purpose = 'social' order by no desc) limit 0,12;
[ALL/Using where; Using filesort]: in (16)
: 0.7 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 = 'social')
[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