Query : select * from artist_url where url='HigH ClouD';
[/Impossible WHERE noticed after reading const tables]: in ()
: 0.5 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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select nickname,type,no from member where nickname = 'HigH ClouD';
[const/]:nickname in nickname (1)
: 0.4 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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select * from user_css where memberno = 255
[ref/]:memberno in memberno,memberno_2,idx_mname (6)
: 1.1 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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select * from member where no=255
[const/]:PRIMARY in PRIMARY (1)
: 0.5 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 89] : /home1/www/dev/lib/store.php
[line : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select * from store where no=255
[const/]:PRIMARY in PRIMARY,idx_memberno (1)
: 0.4 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 93] : /home1/www/dev/lib/store.php
[line : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select count(memberno) as cnt from beholdartist b where b.artistno=255;
[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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select * from beholdartist where memberno=-1168712 and artistno=255
[/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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select * from minishop_category where memberno=255 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 minishop_category,count(distinct itemcode) as cnt from custom_product_set where type = 'sell' and seller = 255 group by minishop_category;
[ALL/Using where; Using filesort]: in (4073)
: 7.2 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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php

Query : select minishop_category,count(itemcode) as cnt from premade_product_set where type = 'sell' and seller = 255 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 : 13] : /home1/www/dev/pages/shop.premade.item.view.php