SHOPPING
SELL
COMMUNITY
Query : select * from group_info where no=16;
[const/]:PRIMARY in PRIMARY (1)
: 0.5 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 45] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_member where grpno=16 and memberno = 0 limit 1;
[/Impossible WHERE noticed after reading const tables]: in ()
: 0.2 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 47] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_modules where grpno=16 ;
[ref/]:idx_all in idx_all (1)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 63] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_member where grpno=16 and type in ('founder','cofounder','admin') order by type desc;
[range/Using where]:idx_type in PRIMARY,idx_type (25)
: 0.8 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 69] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.premade.community.php
Query : select count(memberno) as cnt from group_member where grpno=16 limit 1;
[ref/Using index]:PRIMARY in PRIMARY (40)
: 0.4 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 97] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_blog_folder where grpno = 16 and threadno = 0 order by threadno desc,orderno asc;
[ref/Using where]:idx_all in idx_all (1)
: 0.5 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 28] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_blog_folder where threadno=81 order by orderno asc;
[ALL/Using where; Using filesort]: in (45)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 42] : /home1/www/dev/pages/shop.premade.community.php
Query : select * from group_blog_folder where threadno=81 order by orderno asc;
[ALL/Using where; Using filesort]: in (45)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 69] : /home1/www/dev/pages/shop.premade.community.php
Query : (select * from group_blog where bloggrpno = 81 order by no desc) limit 0,20;
[ref/Using where; Using filesort]:idx_bloggrpno in idx_bloggrpno (1)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 146] : /home1/www/dev/lib/page.php
[line : 91] : /home1/www/dev/pages/shop.premade.community.php
Query : (select count(no) as con from group_blog where bloggrpno = 81)
[ref/]:idx_bloggrpno in idx_bloggrpno (1)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 161] : /home1/www/dev/lib/page.php
[line : 92] : /home1/www/dev/pages/shop.premade.community.php
|
Community
|
|
|||
Writing A New Post