Query : select * from custom_item_good_text t , custom_item_good g where t.goodgrpno = g.goodgrpno and g.name_id = 'TOTEBAGS' and t.lang='en';
[ALL/Using where]: in PRIMARY (48)
: 0.6 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 1184] : /home1/www/dev/lib/system.php
[line : 64] : /home1/www/dev/pages/shop.custom.list.php
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' and g.goodgrpno in (44) order by regdate desc) limit 0,32;
[const/Using index; Using temporary; Using filesort]:PRIMARY in PRIMARY (1)
: 16 ms : [line : 278] : /home1/www/dev/lib/connection.php
[line : 146] : /home1/www/dev/lib/page.php
[line : 75] : /home1/www/dev/pages/shop.custom.list.php