CREATE
SHOPPING
SCORE
COMMUNITY
Query : select * from page_languages where lang='en' and page='process';
[ref/Using where]:PRIMARY in PRIMARY (11)
: 1.1 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 : 34] : /home1/www/dev/inc/group_header.php
[line : 9] : /home1/www/dev/pages/shop.custom.community.php
Query : select * from group_info where no=17;
[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.custom.community.php
Query : select * from group_member where grpno=17 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.custom.community.php
Query : select * from group_modules where grpno=17 ;
[ref/]:idx_all in idx_all (1)
: 0.4 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.custom.community.php
Query : select * from group_member where grpno=17 and type in ('founder','cofounder','admin') order by type desc;
[range/Using where]:idx_type in PRIMARY,idx_type (25)
: 35.1 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.custom.community.php
Query : select count(memberno) as cnt from group_member where grpno=17 limit 1;
[ref/Using index]:PRIMARY in PRIMARY (33)
: 0.3 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.custom.community.php
Query : select * from group_blog_folder where grpno = 17 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.custom.community.php
Query : select * from group_blog_folder where threadno=80 order by orderno asc;
[ALL/Using where; Using filesort]: in (45)
: 0.3 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 42] : /home1/www/dev/pages/shop.custom.community.php
Query : select * from group_blog_folder where threadno=80 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.custom.community.php
Query : (select * from group_blog where bloggrpno = 80 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.custom.community.php
Query : (select count(no) as con from group_blog where bloggrpno = 80)
[ref/]:idx_bloggrpno in idx_bloggrpno (1)
: 0.4 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.custom.community.php
|
Community
|
|
|||
Writing A New Post