Store Notice
New Products
HANDMADE
DESIGNSHOW
Query : select * from artist_url where url='칼있쓰마';
[/Impossible WHERE noticed after reading const tables]: in ()
: 0.6 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 658] : /home1/www/dev/lib/user.php
[line : 1377] : /home1/www/dev/lib/user.php
[line : 63] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select nickname,type,no from member where nickname = '칼있쓰마';
[const/]:nickname in nickname (1)
: 0.5 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 683] : /home1/www/dev/lib/user.php
[line : 1377] : /home1/www/dev/lib/user.php
[line : 63] : /home1/www/dev/lib/store.php
[line : 2] : /home1/www/dev/pages/artist.shop.php
Query : select * from user_css where memberno = 16535
[ref/]:memberno in memberno,memberno_2,idx_mname (10)
: 53.3 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=16535
[const/]:PRIMARY in PRIMARY (1)
: 0.6 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=16535
[const/]:PRIMARY in PRIMARY,idx_memberno (1)
: 0.5 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=16535;
[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=16535
[/Impossible WHERE noticed after reading const tables]: in ()
: 0.3 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=16535 and threadno=0 order by orderno asc;
[ALL/Using where; Using filesort]: in (152)
: 0.3 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 minishop_category,count(distinct itemcode) as cnt from custom_product_set where type = 'sell' and seller = 16535 group by minishop_category;
[ALL/Using where; Using filesort]: in (4854)
: 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 = 16535 group by minishop_category;
[ref/Using where; Using temporary; Using filesort]:idx_seller in idx_seller (1)
: 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 : 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='16535' and referrer='/store/16535' and viewdate='2012-05-24'; : 0.2 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 ('16535','store','16535','/store/16535','2012-05-24','1'); : 0.1 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=16535 and type in ('sell' ) ) union all (select count(itemcode) as cnt from premade_product_set where seller=16535 and type in ('sell' ))
[ALL/Using where]: in (4854)
: 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=16535 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=16535 and type in ('sell' )) order by regdate desc limit 0,12;
[index/Using where]:PRIMARY in (4854)
: 7.1 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 70] : /home1/www/dev/pages/artist.shop.php
|
Community
|
|
|||