SHOW FULL COLUMNS FROM `wst_sys_configs` [ RunTime:0.000735s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000492s ]
SHOW FULL COLUMNS FROM `wst_datas` [ RunTime:0.000465s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `wst_languages` [ RunTime:0.000438s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000435s ]
SHOW FULL COLUMNS FROM `wst_addons` [ RunTime:0.000423s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `wst_sellers` [ RunTime:0.000751s ]
SELECT * FROM `wst_sellers` WHERE `sellerId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.000500s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000384s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000283s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000371s ]
SELECT `addonId`,`name` FROM `wst_addons` WHERE ( status =1 and dataFlag = 1 ) [ RunTime:0.000204s ]
SHOW FULL COLUMNS FROM `wst_goods_cats` [ RunTime:0.000711s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000295s ]
SELECT `catName`,`a`.`catId` FROM `wst_goods_cats` `a` INNER JOIN `wst_goods_cats_langs` `gl` ON `gl`.`catId`=a.catId and gl.langId=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 AND `isFloor` = 1 ORDER BY `catSort` LIMIT 10 [ RunTime:0.000707s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000271s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (92,115,106,168) AND `isFloor` = 1 ORDER BY `catSort` ASC [ RunTime:0.000827s ]
SHOW FULL COLUMNS FROM `wst_seller_goods` [ RunTime:0.000572s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000303s ]
SHOW FULL COLUMNS FROM `wst_goods` [ RunTime:0.000694s ]
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=5 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.000494s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000335s ]
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=5 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.000607s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000190s ]
SHOW FULL COLUMNS FROM `wst_data_cats` [ RunTime:0.000415s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000179s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=5 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000617s ]
SHOW FULL COLUMNS FROM `wst_coupon_goods` [ RunTime:0.000374s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1178 AND `dataFlag` = 1 [ RunTime:0.000307s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1179 AND `dataFlag` = 1 [ RunTime:0.000227s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1178 LIMIT 1 [ RunTime:0.000168s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1179 LIMIT 1 [ RunTime:0.000184s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000160s ]
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=5 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.000474s ]
SHOW FULL COLUMNS FROM `wst_seller_notices` [ RunTime:0.000491s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000188s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 ORDER BY `isUp` DESC,`upTime` DESC,`a`.`noticeId` DESC LIMIT 10 [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `wst_ads` [ RunTime:0.000456s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000490s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000231s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000198s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000183s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000275s ]
SHOW FULL COLUMNS FROM `wst_navs` [ RunTime:0.000420s ]
SELECT * FROM `wst_navs` `a` INNER JOIN `wst_navs_langs` `nl` ON `a`.`id`=nl.id and nl.langId=5 WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000291s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000191s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000854s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000205s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (92,106,168,115,120,121,122,123,124,125,126,127,128) ORDER BY `catSort` ASC [ RunTime:0.000698s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000197s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (118,140,147,103,149,129,172,116,156,138,169,93,144,107,150,131,171,117,159,141,166,99,148,173,108,151,135,170) ORDER BY `catSort` ASC [ RunTime:0.000858s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000305s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000961s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000211s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (92,106,168,115,120,121,122,123,124,125,126,127,128) ORDER BY `catSort` ASC [ RunTime:0.000775s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000191s ]
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=5 WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (118,140,147,103,149,129,172,116,156,138,169,93,144,107,150,131,171,117,159,141,166,99,148,173,108,151,135,170) ORDER BY `catSort` ASC [ RunTime:0.000724s ]
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-index' and adStartDate<= '2026-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 99 [ RunTime:0.000472s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000651s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000657s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000570s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000521s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000459s ]
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='rbnh-left-ads' and adStartDate<= '2026-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000519s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000478s ]
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-1' and adStartDate<= '2026-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000384s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000187s ]
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=5 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.000603s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000207s ]
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=5 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.000459s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 103 LIMIT 1 [ RunTime:0.000177s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.000175s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000210s ]
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=5 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.000420s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000250s ]
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=5 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.000360s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 99 LIMIT 1 [ RunTime:0.000238s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.000173s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000152s ]
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=5 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.000586s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000248s ]
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=5 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.000795s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 93 LIMIT 1 [ RunTime:0.000237s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 92 LIMIT 1 [ RunTime:0.000169s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000184s ]
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=5 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.000544s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000200s ]
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=5 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.000403s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000494s ]
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-2' and adStartDate<= '2026-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000580s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.000190s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000171s ]
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=5 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.000423s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000198s ]
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=5 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.000425s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 118 LIMIT 1 [ RunTime:0.000171s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.000185s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000206s ]
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=5 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.000369s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000180s ]
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=5 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.000432s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 117 LIMIT 1 [ RunTime:0.000179s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.000129s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000170s ]
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=5 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.000450s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000261s ]
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=5 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.000571s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 116 LIMIT 1 [ RunTime:0.000214s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 115 LIMIT 1 [ RunTime:0.000224s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000314s ]
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=5 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.000485s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000377s ]
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=5 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.000787s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000490s ]
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-3' and adStartDate<= '2026-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000429s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000210s ]
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=5 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.000682s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000197s ]
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=5 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 '106_%' AND `g`.`goodsCatIdPath` LIKE '106_%' LIMIT 8 [ RunTime:0.000798s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000309s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000218s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=5 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000946s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1178 AND `dataFlag` = 1 [ RunTime:0.000651s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1179 AND `dataFlag` = 1 [ RunTime:0.000344s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1180 AND `dataFlag` = 1 [ RunTime:0.000347s ]
SHOW FULL COLUMNS FROM `wst_coupons` [ RunTime:0.000536s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000253s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1181 AND `dataFlag` = 1 [ RunTime:0.000437s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000226s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1178 LIMIT 1 [ RunTime:0.000227s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1179 LIMIT 1 [ RunTime:0.000202s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1180 LIMIT 1 [ RunTime:0.000241s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1181 LIMIT 1 [ RunTime:0.000221s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 108 LIMIT 1 [ RunTime:0.000167s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.000158s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000183s ]
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=5 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.000496s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000223s ]
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=5 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.000534s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000206s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000190s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=5 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000607s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1178 AND `dataFlag` = 1 [ RunTime:0.000319s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1179 AND `dataFlag` = 1 [ RunTime:0.000251s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1180 AND `dataFlag` = 1 [ RunTime:0.000238s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000234s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1181 AND `dataFlag` = 1 [ RunTime:0.000203s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000308s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1182 AND `dataFlag` = 1 [ RunTime:0.000330s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000374s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1178 LIMIT 1 [ RunTime:0.000265s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1179 LIMIT 1 [ RunTime:0.000297s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1180 LIMIT 1 [ RunTime:0.000200s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1181 LIMIT 1 [ RunTime:0.000171s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1182 LIMIT 1 [ RunTime:0.000208s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 107 LIMIT 1 [ RunTime:0.000208s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 106 LIMIT 1 [ RunTime:0.000173s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000204s ]
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=5 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.000481s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000209s ]
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=5 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.000366s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000523s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000460s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000196s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000200s ]
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=5 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` = 168 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 1 ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000400s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000201s ]
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=5 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 '168_%' AND `g`.`goodsCatIdPath` LIKE '168_%' LIMIT 8 [ RunTime:0.000513s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000294s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000170s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=5 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000663s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1188 AND `dataFlag` = 1 [ RunTime:0.000286s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000242s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1188 LIMIT 1 [ RunTime:0.000181s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 169 LIMIT 1 [ RunTime:0.000181s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000200s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000189s ]
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=5 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` = 169 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 0 ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000436s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000206s ]
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=5 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 '168_169_%' AND `g`.`goodsCatIdPath` LIKE '168_169_%' LIMIT 10 [ RunTime:0.000439s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 171 LIMIT 1 [ RunTime:0.000258s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000207s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000219s ]
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=5 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.000484s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000210s ]
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=5 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 '168_171_%' AND `g`.`goodsCatIdPath` LIKE '168_171_%' LIMIT 10 [ RunTime:0.000517s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000243s ]
SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'GOODS_UNIT' LIMIT 1 [ RunTime:0.000172s ]
SELECT `a`.*,`dl`.`dataName` FROM `wst_datas` `a` INNER JOIN `wst_datas_langs` `dl` ON `a`.`id`=dl.dataId and dl.langId=5 WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000755s ]
SELECT COUNT(*) AS think_count FROM `wst_coupon_goods` `cg` INNER JOIN `wst_coupons` `c` ON `cg`.`couponId`=`c`.`couponId` WHERE `endDate` >= '2026-06-21' AND `goodsId` = 1188 AND `dataFlag` = 1 [ RunTime:0.000349s ]
SELECT COUNT(*) AS think_count FROM `wst_coupons` WHERE ( couponType=2 and dataFlag=1 and useObjects=0 and startDate<="2026-06-21" and endDate>="2026-06-21" ) [ RunTime:0.000290s ]
SELECT `goodsId`,`isPifa`,`goodsPrice` FROM `wst_goods` WHERE `goodsId` = 1188 LIMIT 1 [ RunTime:0.000242s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 172 LIMIT 1 [ RunTime:0.000218s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000232s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000210s ]
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=5 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` = 172 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 0 ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000531s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000268s ]
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=5 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 '168_172_%' AND `g`.`goodsCatIdPath` LIKE '168_172_%' LIMIT 10 [ RunTime:0.000452s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 173 LIMIT 1 [ RunTime:0.000202s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000182s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000177s ]
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=5 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` = 173 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 0 ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000423s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000217s ]
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=5 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 '168_173_%' AND `g`.`goodsCatIdPath` LIKE '168_173_%' LIMIT 10 [ RunTime:0.000402s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 170 LIMIT 1 [ RunTime:0.000174s ]
SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 168 LIMIT 1 [ RunTime:0.000161s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000188s ]
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=5 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` = 170 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 AND `r`.`dataType` = 0 ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000391s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000223s ]
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=5 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 '168_170_%' AND `g`.`goodsCatIdPath` LIKE '168_170_%' LIMIT 10 [ RunTime:0.000359s ]
SHOW FULL COLUMNS FROM `wst_custom_pages` [ RunTime:0.000491s ]
SELECT `id` FROM `wst_custom_pages` WHERE `dataFlag` = 1 AND `isIndex` = 1 AND `pageType` = 4 LIMIT 1 [ RunTime:0.000204s ]
SELECT `attr` FROM `wst_custom_pages` WHERE `dataFlag` = 1 AND `id` IS NULL LIMIT 1 [ RunTime:0.000182s ]
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-06-21' and adEndDate>='2026-06-21' and a.sellerId=0 and a.adSrc=1 ) ORDER BY `adSort` ASC LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `wst_languages` WHERE `status` = 1 [ RunTime:0.000222s ]
SELECT * FROM `wst_navs` `a` INNER JOIN `wst_navs_langs` `nl` ON `a`.`id`=nl.id and nl.langId=5 WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000324s ]
