HANDMADE
DESIGNSHOW
Query : select * from user_css where memberno = 1768
[ref/]:memberno in memberno,memberno_2,idx_mname (9)
: 1.5 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 52] : /home1/www/dev/lib/skin.php
[line : 86] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select * from member where no=1768
[const/]:PRIMARY in PRIMARY (1)
: 0.7 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 89] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select * from store where no=1768
[const/]:PRIMARY in PRIMARY,idx_memberno (1)
: 0.6 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 93] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select count(memberno) as cnt from beholdartist b where b.artistno=1768;
[index/Using where; Using index]:idx_reg in (7016)
: 2.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 104] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select * from beholdartist where memberno=-1168102 and artistno=1768
[/Impossible WHERE noticed after reading const tables]: in ()
: 0.4 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 106] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select * from minishop_category where memberno=1768 and threadno=0 order by orderno asc;
[ALL/Using where; Using filesort]: in (152)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 19] : /home1/www/dev/lib/store.php
[line : 111] : /home1/www/dev/lib/store.php
Query : select * from minishop_category where memberno=1768 and threadno=20 order by orderno asc;
[ALL/Using where; Using filesort]: in (152)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 34] : /home1/www/dev/lib/store.php
[line : 111] : /home1/www/dev/lib/store.php
Query : select * from minishop_category where memberno=1768 and threadno=72 order by orderno asc;
[ALL/Using where; Using filesort]: in (152)
: 0.4 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 34] : /home1/www/dev/lib/store.php
[line : 111] : /home1/www/dev/lib/store.php
Query : select minishop_category,count(distinct itemcode) as cnt from custom_product_set where type = 'sell' and seller = 1768 group by minishop_category;
[ALL/Using where; Using filesort]: in (4853)
: 7.8 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 116] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select minishop_category,count(itemcode) as cnt from premade_product_set where type = 'sell' and seller = 1768 group by minishop_category;
[ref/Using where; Using temporary; Using filesort]:idx_seller in idx_seller (23)
: 0.9 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 1151] : /home1/www/dev/lib/system.php
[line : 127] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : update page_stats set viewcount = viewcount + 1 where type='store' and pk='1768' and referrer='/store/1768' and viewdate='2012-05-24'; : 25.9 ms : [line : 212] : /home1/www/dev/lib/connection.php
[line : 1022] : /home1/www/dev/lib/system.php
[line : 8] : /home1/www/dev/pages/artist.shop.php
Query : insert ignore into page_stats (owner,type,pk,referrer,viewdate,viewcount) values ('1768','store','1768','/store/1768','2012-05-24','1'); : 0.3 ms : [line : 212] : /home1/www/dev/lib/connection.php
[line : 152] : /home1/www/dev/lib/connection.php
[line : 187] : /home1/www/dev/lib/connection.php
[line : 1025] : /home1/www/dev/lib/system.php
[line : 8] : /home1/www/dev/pages/artist.shop.php
Query : (select count(distinct itemcode) as cnt from custom_product_set where seller=1768 and type in ('sell' ) ) union all (select count(itemcode) as cnt from premade_product_set where seller=1768 and type in ('sell' ))
[ALL/Using where]: in (4853)
: 4.9 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 65] : /home1/www/dev/pages/artist.shop.php
Query : (select view,recommend,'custom' as itemtype , type as opentype , itemcode as itemcode , default_platetype as plate , name as name , commission as price , regdate as regdate from custom_product_set where seller=1768 and type in ('sell' ) group by itemcode ) union all (select view,recommend,'premade' as itemtype , type as opentype , itemcode as itemcode , filename as plate , name as name , price as price , regdate as regdate from premade_product_set where seller=1768 and type in ('sell' )) order by regdate desc limit 0,12;
[index/Using where]:PRIMARY in (4853)
: 7.2 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 70] : /home1/www/dev/pages/artist.shop.php
|
Community
|
|
|||
