Query : select distinct s.itemcode as itemcode , s.default_platetype , s.lastcommenttime , s.view , s.recommend, i.name_id as salename , i.brand_id as salebrand,
s.cacheprice as saleprice , i.cash as cash , i.coupon as coupon ,
s.name as name , s.tag as tag, s.seller as seller , s.sellernickname as sellernickname,
s.regdate as regdate , s.lastcommenttime as lastcommenttime , s.view as view, s.voters as voters , s.recommend as recommend
from custom_product_set s, custom_item_info i , custom_item_good g
where i.saleitemno = s.saleitemno and g.goodgrpno = i.goodgrpno and s.type = 'sell' order by regdate desc limit 0,8;
[ALL/Using temporary; Using filesort]: in PRIMARY (57)
: 42.7 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 19] : /home1/www/dev/pages/shop.custom.main.php
CREATE
SHOPPING
SCORE
COMMUNITY
Query : select * from group_blog where grpno=17 order by regdate desc limit 1;
[ref/Using where; Using filesort]:idx_grpno in idx_grpno (1)
: 0.7 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1165] : /home1/www/dev/lib/system.php
[line : 110] : /home1/www/dev/inc/shop_heading.php
[line : 47] : /home1/www/dev/pages/shop.custom.main.php
no forum issues.
SA does not provide [handmade] services for international users at the moment. Please do not buy or sell any items if you are outside of South Korea.
Query : select displaydate from featured_custom where displaydate <='2012-02-22' order by displaydate desc limit 1;
[range/Using where; Using index]:idx_disp in idx_disp (19)
: 15.7 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 52] : /home1/www/dev/pages/shop.custom.main.php
Query : select * from featured_custom f , custom_product_set p where f.displaydate <='2010-07-15' and p.itemcode = f.itemcode order by f.displaydate desc limit 1;
[range/Using where]:idx_disp in PRIMARY,idx_disp (19)
: 0.6 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 66] : /home1/www/dev/pages/shop.custom.main.php
Query : select * from featured_custom where displaydate < '2010-07-15' order by displaydate desc limit 1;
[range/Using where]:idx_disp in idx_disp (18)
: 0.3 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 67] : /home1/www/dev/pages/shop.custom.main.php
Query : select * from featured_custom where displaydate > '2010-07-15' order by displaydate asc limit 1;
[range/Using where]:idx_disp in idx_disp (1)
: 0.3 ms : [line : 246] : /home1/www/dev/lib/connection.php
[line : 68] : /home1/www/dev/pages/shop.custom.main.php
Query : select * from shop_themes where sdate <= now() and type = 'custom' order by no asc limit 5;
[ALL/Using where; Using filesort]: in (7)
: 0.6 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 105] : /home1/www/dev/pages/shop.custom.main.php
Show what you bought in SA!
We give you another free tshirt every month.
photo review
click to close
