banner

Category

Other Brand Shoes

Red Monkey jeans

Evisu short jeans

True&religion jeans

Rock&Repub jeans

Home > Jeans > Dsquared jeans

Sort by-

dsqjean-21

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-20

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-19

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-18

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-17

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-16

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-15

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-14

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-13

List Price：$53.00
Price：$35.00
dsqjean

dsqjean-12

List Price：$53.00
Price：$35.00
dsqjean

Email/MSN:trade-btob@hotmail.com

CopyRight 2003-2007 Trade-btob online,All Rights Reserved

page Execution duration:0.52320289611816secs
Queries:24
time(config)0.02538800239563
PHP Script:header0.035014867782593
PHP Script:TPL_CLASS.php0.046762943267822
PHP Script:TPL_CLASS.php0.047199964523315
PHP Script:TPL_LOGIN.php0.047616958618164
PHP Script:TPL_CATEGORYLIST.php0.048800945281982
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catid=198 AND offerid=1
SQL Time: 0.0018768310546875
SQL QUERY: SELECT catid, cat FROM sdb_mall_offer_pcat WHERE offerid = '1' AND catid in (163,198)
SQL Time: 0.00065708160400391
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=0 AND offerid=1 ORDER BY catpath
SQL Time: 0.0020668506622314
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=163 AND offerid=1 ORDER BY catpath
SQL Time: 0.0013270378112793
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catiffb=1 AND pid=198 AND offerid=1 ORDER BY catpath
SQL Time: 0.0015180110931396
PHP Script:TPL_SEARCH.php0.12458395957947
PHP Script:TPL_GOODSLIST.php0.12512588500977
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND number = ''
SQL Time: 0.00055789947509766
SQL QUERY: SELECT * from sdb_mall_currency where offerid = '1' AND basicmark = '1'
SQL Time: 0.0013949871063232
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catid=198 AND offerid=1
SQL Time: 0.0012290477752686
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catid=198 AND offerid=1
SQL Time: 0.0012140274047852
SQL QUERY: SELECT * FROM sdb_mall_offer_pcat WHERE catid=163 AND offerid=1
SQL Time: 0.0012750625610352
SQL QUERY: SELECT catid from sdb_mall_offer_pcat where catpath like '%,000198%' AND catiffb=1
SQL Time: 0.024460077285767
SQL QUERY: select gid,linkclass from sdb_mall_goods where linkclass is not null and linkclass<>''
SQL Time: 0.0039689540863037
SQL QUERY: select count(*) as count from sdb_mall_goods as a LEFT JOIN sdb_mall_offer_pcat as pc on a.catid = pc.catid WHERE a.shop_iffb=1 AND a.offerid=1 AND (a.catid in (198)) AND a.ifobject != 3 AND pc.catiffb = 1 ORDER BY offer_ord DESC
SQL Time: 0.010025978088379
SQL QUERY: SELECT catid from sdb_mall_offer_pcat where catpath like '%,000198%' AND catiffb=1
SQL Time: 0.00041007995605469
SQL QUERY: select gid,linkclass from sdb_mall_goods where linkclass is not null and linkclass<>''
SQL Time: 0.003511905670166
SQL QUERY: SELECT a.* FROM sdb_mall_goods as a LEFT JOIN sdb_mall_offer_pcat as pc on a.catid = pc.catid WHERE a.shop_iffb=1 AND a.offerid=1 AND (a.catid in (198)) AND a.ifobject != 3 AND pc.catiffb = 1 ORDER BY offer_ord DESC LIMIT 0,10
SQL Time: 0.00885009765625
SQL QUERY: SELECT catid from sdb_mall_offer_pcat where catpath like '%,000198%' AND catiffb=1
SQL Time: 0.00053882598876953
SQL QUERY: select gid,linkclass from sdb_mall_goods where linkclass is not null
SQL Time: 0.020532846450806
SQL QUERY: SELECT a.brand_id as brand_id,c.brand_name as brand_name FROM sdb_mall_goods as a INNER JOIN sdb_mall_brand as c ON a.brand_id=c.brand_id WHERE a.shop_iffb=1 AND a.offerid=1 AND catid in (198) and a.brand_id>0 group by brand_id
SQL Time: 0.001572847366333
SQL QUERY: SELECT * FROM sdb_mall_offer_p WHERE ptype IN ('ALIPAY','ALIPAY_MASS','ALIPAY_DIRECT','99BILL','PAYPAL','PAYPAL_CN') AND offerid=1 ORDER BY ordernum DESC
SQL Time: 0.00072407722473145
PHP Script:TPL_PAGER.php0.51352286338806
PHP Script:TPL_BOTTOM.php0.51442098617554
SQL QUERY: SELECT * FROM sdb_mall_offer_definetag where offerid = '1'
SQL Time: 0.00040316581726074
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='shopexkft_kft_id' and offerid=1
SQL Time: 0.00033879280090332
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='shopexkft_style' and offerid=1
SQL Time: 0.00032496452331543
SQL QUERY: SELECT value from sdb_mall_offer_setup where keyword='shopexkft_enable_code' and offerid=1
SQL Time: 0.00041103363037109
PHP Script:--END0.52317500114441
total sql time:0.088615655899048
Loaded Classes:
ShopCurrency
flyTemp
shopCategory
Pager
Product
shopPayment
DefineTag
shopSetup
ClassesLoaded Time:0.038225650787354