Query : select * from custom_item_good_text t , custom_item_good g where t.goodgrpno = g.goodgrpno and g.name_id = 'TSHIRT' 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 (56,10,52,11,53,12,13) order by regdate desc) limit 0,32;
[ALL/Using where; Using temporary; Using filesort]: in PRIMARY (57)
: 38.5 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

CREATE
SHOPPING
SCORE
COMMUNITY
no forum issues.
Home
>
Shopping
>
Designshow
>
Apparel
>
Tshirts


Loading..
click to close