SHOW FULL COLUMNS FROM `wst_sys_configs` [ RunTime:0.002904s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.028192s ]
SHOW FULL COLUMNS FROM `wst_datas` [ RunTime:0.011718s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.007192s ]
SHOW FULL COLUMNS FROM `wst_languages` [ RunTime:0.004484s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.005165s ]
SHOW FULL COLUMNS FROM `wst_addons` [ RunTime:0.006176s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.005634s ]
SHOW FULL COLUMNS FROM `wst_sellers` [ RunTime:0.014933s ]
SELECT * FROM `wst_sellers` WHERE `sellerId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.006116s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.005656s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.006400s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.005694s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.014459s ]
SHOW FULL COLUMNS FROM `wst_goods_cats` [ RunTime:0.045318s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.016240s ]
SELECT `catName`,`a`.`catId` FROM `wst_goods_cats` `a` INNER JOIN `wst_goods_cats_langs` `gl` ON `gl`.`catId`=a.catId and gl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 AND `isFloor` = 1 ORDER BY `catSort` LIMIT 10 [ RunTime:0.013732s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.014589s ]
SELECT `parentId`,`catName`,`a`.`catId` FROM `wst_goods_cats` `a` INNER JOIN `wst_goods_cats_langs` `gl` ON `gl`.`catId`=a.catId and gl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (106,162,92,115,120,121,122,123,124,125) AND `isFloor` = 1 ORDER BY `catSort` ASC [ RunTime:0.011484s ]
SHOW FULL COLUMNS FROM `wst_seller_goods` [ RunTime:0.022336s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.016678s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.013373s ]
SHOW FULL COLUMNS FROM `wst_goods` [ RunTime:0.017605s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '0' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 5 [ RunTime:0.016869s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.023639s ]
SHOW FULL COLUMNS FROM `wst_data_cats` [ RunTime:0.011461s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.019906s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.012693s ]
SHOW FULL COLUMNS FROM `wst_coupon_goods` [ RunTime:0.015320s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1141 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.021298s ]
SHOW FULL COLUMNS FROM `wst_coupons` [ RunTime:0.008421s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.005330s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1142 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.007028s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006910s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1145 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.009991s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.010172s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1146 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.004482s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006137s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1147 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.007878s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.003702s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1141 LIMIT 1 [ RunTime:0.004454s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1142 LIMIT 1 [ RunTime:0.001722s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1145 LIMIT 1 [ RunTime:0.001526s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1146 LIMIT 1 [ RunTime:0.002135s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1147 LIMIT 1 [ RunTime:0.001604s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001849s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001257s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '0' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 2 [ RunTime:0.001549s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.002463s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002059s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '0' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '3' ORDER BY `r`.`dataSort` ASC LIMIT 2 [ RunTime:0.003017s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001642s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.001174s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.002504s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1133 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.005362s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006447s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1133 LIMIT 1 [ RunTime:0.001626s ]
SHOW FULL COLUMNS FROM `wst_seller_notices` [ RunTime:0.001991s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001887s ]
SELECT `a`.`noticeId`,`al`.`noticeTitle`,`a`.`createTime`,`upTime`,`isUp` FROM `wst_seller_notices` `a` INNER JOIN `wst_seller_notices_langs` `al` ON `al`.`noticeId`=a.noticeId and al.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 ORDER BY `isUp` DESC,`upTime` DESC,`a`.`noticeId` DESC LIMIT 10 [ RunTime:0.002155s ]
SHOW FULL COLUMNS FROM `wst_ads` [ RunTime:0.002555s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-top-ads' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001646s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001444s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001458s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001247s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001415s ]
SHOW FULL COLUMNS FROM `wst_navs` [ RunTime:0.001657s ]
SELECT * FROM `wst_navs` `a` INNER JOIN `wst_navs_langs` `nl` ON `a`.`id`=nl.id and nl.langId=4 WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.001521s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001227s ]
SELECT `catName`,`gc`.`catId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.002386s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001419s ]
SELECT `catName`,`gc`.`catId`,`parentId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (106,162,92,115,120,121,122,123,124,125,126,128,170) ORDER BY `catSort` ASC [ RunTime:0.002780s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001431s ]
SELECT `catName`,`gc`.`catId`,`parentId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (93,138,171,107,149,117,159,131,99,141,161,108,150,118,140,135,103,147,116,151,129) ORDER BY `catSort` ASC [ RunTime:0.002807s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001379s ]
SELECT `catName`,`gc`.`catId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.002226s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001270s ]
SELECT `catName`,`gc`.`catId`,`parentId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (106,162,92,115,120,121,122,123,124,125,126,128,170) ORDER BY `catSort` ASC [ RunTime:0.002333s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001234s ]
SELECT `catName`,`gc`.`catId`,`parentId`,`catImg`,`shortName` FROM `wst_goods_cats` `gc` INNER JOIN `wst_goods_cats_langs` `gcl` ON `gc`.`catId`=gcl.catId and gcl.langId=4 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (93,138,171,107,149,117,159,131,99,141,161,108,150,118,140,135,103,147,116,151,129) ORDER BY `catSort` ASC [ RunTime:0.002317s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-top' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001526s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-bottom' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001332s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-center' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001547s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-top' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001326s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-bottom' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001357s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-1-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001368s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001154s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.001204s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001204s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '106' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001562s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001461s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.001118s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.002248s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1140 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001518s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001444s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1141 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001660s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001080s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1142 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001186s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.002541s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1144 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001376s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001331s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1145 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001357s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.002798s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1146 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001710s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001304s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1147 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001646s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001911s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1140 LIMIT 1 [ RunTime:0.001327s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1141 LIMIT 1 [ RunTime:0.001359s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1142 LIMIT 1 [ RunTime:0.001802s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1144 LIMIT 1 [ RunTime:0.001240s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1145 LIMIT 1 [ RunTime:0.001381s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1146 LIMIT 1 [ RunTime:0.001390s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1147 LIMIT 1 [ RunTime:0.001694s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001238s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 108 LIMIT 1 [ RunTime:0.001233s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.002204s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001266s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '108' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001669s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001450s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '106_108_%' AND `g`.`goodsCatIdPath` LIKE '106_108_%' LIMIT 10 [ RunTime:0.008465s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002142s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.005052s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.002427s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1140 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.002212s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.002253s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1141 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001548s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.002379s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1142 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.006623s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001437s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1144 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.005573s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001198s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1233 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.006579s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.004934s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1234 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.001611s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.004901s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1140 LIMIT 1 [ RunTime:0.011586s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1141 LIMIT 1 [ RunTime:0.010999s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1142 LIMIT 1 [ RunTime:0.006691s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1144 LIMIT 1 [ RunTime:0.014734s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1233 LIMIT 1 [ RunTime:0.004490s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1234 LIMIT 1 [ RunTime:0.007755s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.006175s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 107 LIMIT 1 [ RunTime:0.007112s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.004781s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.004792s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '107' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.005923s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006396s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '106_107_%' AND `g`.`goodsCatIdPath` LIKE '106_107_%' LIMIT 10 [ RunTime:0.005997s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005561s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.005654s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.006450s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1145 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.005690s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.007874s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1146 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.007150s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006699s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1147 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.005235s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.005930s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1145 LIMIT 1 [ RunTime:0.005755s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1146 LIMIT 1 [ RunTime:0.006579s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1147 LIMIT 1 [ RunTime:0.005611s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.006106s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 161 LIMIT 1 [ RunTime:0.007190s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.005211s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005822s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '161' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.007661s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.007217s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '106_161_%' AND `g`.`goodsCatIdPath` LIKE '106_161_%' LIMIT 10 [ RunTime:0.005163s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005821s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.006368s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.007611s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1232 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.011000s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.010546s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1235 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.012224s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.005527s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1237 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.006631s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006944s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1232 LIMIT 1 [ RunTime:0.008597s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1235 LIMIT 1 [ RunTime:0.009084s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1237 LIMIT 1 [ RunTime:0.008722s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-2-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.012641s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.007935s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 162 LIMIT 1 [ RunTime:0.008648s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005267s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '162' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.008567s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006513s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '162_%' AND `g`.`goodsCatIdPath` LIKE '162_%' LIMIT 8 [ RunTime:0.007696s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.007663s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.006928s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.006246s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1245 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.009498s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.014003s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1245 LIMIT 1 [ RunTime:0.006566s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.009321s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 171 LIMIT 1 [ RunTime:0.011751s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 162 LIMIT 1 [ RunTime:0.013766s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.011528s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '171' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.012797s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.012440s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '162_171_%' AND `g`.`goodsCatIdPath` LIKE '162_171_%' LIMIT 10 [ RunTime:0.012633s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.004747s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.001756s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.004163s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1245 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.008972s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.001742s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1245 LIMIT 1 [ RunTime:0.001795s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-3-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.004359s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001364s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.001681s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002433s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '92' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.006490s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001479s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '92_%' AND `g`.`goodsCatIdPath` LIKE '92_%' LIMIT 8 [ RunTime:0.005904s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001586s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.004528s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.007744s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1133 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.002093s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.006197s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1133 LIMIT 1 [ RunTime:0.001381s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.013307s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 103 LIMIT 1 [ RunTime:0.010794s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.012241s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.017116s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '103' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.015755s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.012728s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '92_103_%' AND `g`.`goodsCatIdPath` LIKE '92_103_%' LIMIT 10 [ RunTime:0.007320s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.006010s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 99 LIMIT 1 [ RunTime:0.007589s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.007045s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006328s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '99' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.007847s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.008448s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '92_99_%' AND `g`.`goodsCatIdPath` LIKE '92_99_%' LIMIT 10 [ RunTime:0.007771s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.007148s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 93 LIMIT 1 [ RunTime:0.006760s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.010646s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006641s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '93' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.005758s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.004725s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '92_93_%' AND `g`.`goodsCatIdPath` LIKE '92_93_%' LIMIT 10 [ RunTime:0.005765s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003145s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000258s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=4 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.001033s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-10-12' AND `goodsId` = 1133 AND `dataFlag` = '1' LIMIT 1 [ RunTime:0.000431s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-10-12" and endDate>="2026-10-12" ) LIMIT 1 [ RunTime:0.000362s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1133 LIMIT 1 [ RunTime:0.000316s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-4-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.002461s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-4' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001199s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001101s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.001035s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001579s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '115' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001184s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002041s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '115_%' AND `g`.`goodsCatIdPath` LIKE '115_%' LIMIT 8 [ RunTime:0.005019s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.005077s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 116 LIMIT 1 [ RunTime:0.002737s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.001071s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001234s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '116' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001409s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000804s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '115_116_%' AND `g`.`goodsCatIdPath` LIKE '115_116_%' LIMIT 10 [ RunTime:0.001399s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.006447s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 118 LIMIT 1 [ RunTime:0.005788s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.004769s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003091s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '118' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001294s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001992s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '115_118_%' AND `g`.`goodsCatIdPath` LIKE '115_118_%' LIMIT 10 [ RunTime:0.001265s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.002048s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 117 LIMIT 1 [ RunTime:0.004792s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.000724s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000755s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '117' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001868s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001528s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '115_117_%' AND `g`.`goodsCatIdPath` LIKE '115_117_%' LIMIT 10 [ RunTime:0.001428s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-5-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001322s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-5' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000923s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001487s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 120 LIMIT 1 [ RunTime:0.004624s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.004233s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '120' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001350s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001011s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '120_%' AND `g`.`goodsCatIdPath` LIKE '120_%' LIMIT 8 [ RunTime:0.001470s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000919s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 129 LIMIT 1 [ RunTime:0.000784s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 120 LIMIT 1 [ RunTime:0.000824s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000797s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '129' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001102s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000745s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '120_129_%' AND `g`.`goodsCatIdPath` LIKE '120_129_%' LIMIT 10 [ RunTime:0.001053s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-6-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001031s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-6' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.002689s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000865s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 121 LIMIT 1 [ RunTime:0.000732s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000755s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '121' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001019s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000789s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '121_%' AND `g`.`goodsCatIdPath` LIKE '121_%' LIMIT 8 [ RunTime:0.001037s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001055s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 135 LIMIT 1 [ RunTime:0.001193s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 121 LIMIT 1 [ RunTime:0.000659s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001134s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '135' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001330s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000858s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '121_135_%' AND `g`.`goodsCatIdPath` LIKE '121_135_%' LIMIT 10 [ RunTime:0.001134s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001834s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 131 LIMIT 1 [ RunTime:0.000777s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 121 LIMIT 1 [ RunTime:0.000915s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001296s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '131' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001525s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001029s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '121_131_%' AND `g`.`goodsCatIdPath` LIKE '121_131_%' LIMIT 10 [ RunTime:0.005194s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-7-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.002319s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-7' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001327s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.003119s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 122 LIMIT 1 [ RunTime:0.000749s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001058s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '122' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001360s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001273s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '122_%' AND `g`.`goodsCatIdPath` LIKE '122_%' LIMIT 8 [ RunTime:0.001267s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.000882s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 141 LIMIT 1 [ RunTime:0.001599s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 122 LIMIT 1 [ RunTime:0.000699s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003706s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '141' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.002943s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002123s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '122_141_%' AND `g`.`goodsCatIdPath` LIKE '122_141_%' LIMIT 10 [ RunTime:0.002043s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.001747s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 138 LIMIT 1 [ RunTime:0.000886s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 122 LIMIT 1 [ RunTime:0.001912s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.000917s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '138' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.002198s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003905s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '122_138_%' AND `g`.`goodsCatIdPath` LIKE '122_138_%' LIMIT 10 [ RunTime:0.002063s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-8-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001936s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-8' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001938s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.002035s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 123 LIMIT 1 [ RunTime:0.002415s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001937s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '123' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.001140s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.005846s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '123_%' AND `g`.`goodsCatIdPath` LIKE '123_%' LIMIT 8 [ RunTime:0.006932s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.012784s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 140 LIMIT 1 [ RunTime:0.011799s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 123 LIMIT 1 [ RunTime:0.006334s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.007530s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '140' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.007016s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006679s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '123_140_%' AND `g`.`goodsCatIdPath` LIKE '123_140_%' LIMIT 10 [ RunTime:0.006698s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.006318s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 147 LIMIT 1 [ RunTime:0.006790s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 123 LIMIT 1 [ RunTime:0.006743s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006824s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '147' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.006782s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.006564s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '123_147_%' AND `g`.`goodsCatIdPath` LIKE '123_147_%' LIMIT 10 [ RunTime:0.006773s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-9-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.007207s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-9' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.007007s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.008044s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 124 LIMIT 1 [ RunTime:0.001867s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.012443s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '124' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.014545s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.011911s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '124_%' AND `g`.`goodsCatIdPath` LIKE '124_%' LIMIT 8 [ RunTime:0.012939s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-10-1' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.020806s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-10' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.010548s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.007128s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 125 LIMIT 1 [ RunTime:0.006939s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.011609s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '125' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.010661s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.008835s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isHot` = '1' AND `g`.`goodsCatIdPath` LIKE '125_%' AND `g`.`goodsCatIdPath` LIKE '125_%' LIMIT 8 [ RunTime:0.013803s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.007977s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 150 LIMIT 1 [ RunTime:0.012046s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 125 LIMIT 1 [ RunTime:0.013583s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.007870s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '150' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.002103s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.003456s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '125_150_%' AND `g`.`goodsCatIdPath` LIKE '125_150_%' LIMIT 10 [ RunTime:0.001931s ]
SELECT `areaIdPath` FROM `wst_sellers` WHERE `sellerId` = 0 LIMIT 1 [ RunTime:0.010940s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 149 LIMIT 1 [ RunTime:0.000998s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 125 LIMIT 1 [ RunTime:0.002298s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002007s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `r`.`goodsCatId` = '149' AND `g`.`isSale` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.012765s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.002065s ]
SELECT gs.id goodsSpecId,`g`.`goodsId`,`g`.`goodsCatId`,`g`.`goodsImg`,`g`.`goodsUnitId`,`gl`.`goodsTips`,`gl`.`goodsName`,`g`.`goodsPrice`,g.goodsPrice defaultGoodsPrice,`g`.`goodsStock`,`g`.`saleNum`,`g`.`isSpec`,`g`.`goodsSn`,`gs`.`specStock`,`gs`.`specIds`,g.goodsPrice as platformPrice,`g`.`marketPrice`,`g`.`minOrder` FROM `wst_goods` `g` INNER JOIN `wst_goods_langs` `gl` ON `g`.`goodsId`=gl.goodsId and gl.langId=4 LEFT JOIN `wst_goods_specs` `gs` ON `g`.`goodsId`=gs.goodsId and gs.isDefault=1 WHERE `g`.`dataFlag` = '1' AND `g`.`isSale` = '1' AND `g`.`isReCom` = '1' AND `g`.`goodsCatIdPath` LIKE '125_149_%' AND `g`.`goodsCatIdPath` LIKE '125_149_%' LIMIT 10 [ RunTime:0.002654s ]
SELECT `adId`,`adName`,`adURL`,`adFile`,`positionWidth`,`positionHeight` FROM `wst_ads` `a` LEFT JOIN `wst_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='home-pop-ads' and adStartDate<= '2026-10-12' and adEndDate>='2026-10-12' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.001870s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 ORDER BY `sort` ASC [ RunTime:0.001597s ]
SELECT * FROM `wst_navs` `a` INNER JOIN `wst_navs_langs` `nl` ON `a`.`id`=nl.id and nl.langId=4 WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.003636s ]
