[ DB ] CONNECT:[ UseTime:0.001374s ] mysql:host=127.0.0.1;port=3306;dbname=wstmart;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wst_sys_configs` [ RunTime:0.000800s ]
[ SQL ] SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000348s ]
[ SQL ] SHOW COLUMNS FROM `wst_styles` [ RunTime:0.000814s ]
[ SQL ] SELECT `styleSys`,`stylePath`,`id` FROM `wst_styles` WHERE `isUse` = 1 [ RunTime:0.000263s ]
[ SQL ] SHOW COLUMNS FROM `wst_datas` [ RunTime:0.000725s ]
[ SQL ] SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000315s ]
[ SQL ] show tables like 'wst_app_session'; [ RunTime:0.000511s ]
[ SQL ] SHOW COLUMNS FROM `wst_home_menus` [ RunTime:0.001836s ]
[ SQL ] SELECT * FROM `wst_home_menus` WHERE `dataFlag` = 1 ORDER BY `menuType` ASC [ RunTime:0.000715s ]
[ SQL ] SHOW COLUMNS FROM `wst_switchs` [ RunTime:0.001094s ]
[ SQL ] SELECT * FROM `wst_switchs` [ RunTime:0.000196s ]
[ SQL ] SHOW COLUMNS FROM `wst_data_cats` [ RunTime:0.001923s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000225s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000516s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000424s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000673s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods_cats` [ RunTime:0.001071s ]
[ SQL ] SELECT `catName`,`catId`,`subTitle` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 AND `isFloor` = 1 ORDER BY `catSort` LIMIT 10 [ RunTime:0.000393s ]
[ SQL ] SELECT `parentId`,`catName`,`catId`,`subTitle` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (52,53,47,49,50,51,48,334) AND `isFloor` = 1 ORDER BY `catSort` ASC [ RunTime:0.000579s ]
[ SQL ] SHOW COLUMNS FROM `wst_users` [ RunTime:0.002128s ]
[ SQL ] SELECT `userScore` FROM `wst_users` WHERE `userId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.000383s ]
[ SQL ] SHOW COLUMNS FROM `wst_ads` [ RunTime:0.001160s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000798s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000420s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000721s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000495s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000632s ]
[ SQL ] SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000524s ]
[ SQL ] SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (52,53,47,49,50,51,54,48,334,55,335,56) ORDER BY `catSort` ASC [ RunTime:0.000656s ]
[ SQL ] SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (190,61,164,219,80,137,118,74,189,339,348,84,85,340,138,167,165,349,119,103,62,220,78,221,258,139,108,86,191,63,79,350,166,120,64,361,121,259,87,140,222,81,192,223,82,65,193,141,260,66,71,261,109) ORDER BY `catSort` ASC [ RunTime:0.001004s ]
[ SQL ] SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000610s ]
[ SQL ] SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (52,53,47,49,50,51,54,48,334,55,335,56) ORDER BY `catSort` ASC [ RunTime:0.000626s ]
[ SQL ] SELECT `catName`,`catId`,`parentId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (190,61,164,219,80,137,118,74,189,339,348,84,85,340,138,167,165,349,119,103,62,220,78,221,258,139,108,86,191,63,79,350,166,120,64,361,121,259,87,140,222,81,192,223,82,65,193,141,260,66,71,261,109) ORDER BY `catSort` ASC [ RunTime:0.000995s ]
[ SQL ] SHOW COLUMNS FROM `wst_brands` [ RunTime:0.001249s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '52' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000547s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '52' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000506s ]
[ SQL ] SHOW COLUMNS FROM `wst_shops` [ RunTime:0.001256s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '52' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000607s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=52 ) LIMIT 4 [ RunTime:0.000513s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '53' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000548s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '53' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000569s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '53' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000599s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=53 ) LIMIT 4 [ RunTime:0.000545s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '47' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000510s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '47' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000676s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '47' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000611s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=47 ) LIMIT 4 [ RunTime:0.000549s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '49' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000489s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '49' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000512s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '49' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000494s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=49 ) LIMIT 4 [ RunTime:0.000563s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '50' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000442s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '50' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000390s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '50' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000385s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=50 ) LIMIT 4 [ RunTime:0.000359s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '51' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000341s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '51' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000441s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '51' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000397s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=51 ) LIMIT 4 [ RunTime:0.000501s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '54' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000532s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '54' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000505s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '54' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000357s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=54 ) LIMIT 4 [ RunTime:0.000346s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '48' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000442s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '48' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000448s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '48' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000310s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=48 ) LIMIT 4 [ RunTime:0.000412s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '334' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000536s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '334' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000553s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '334' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000430s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=334 ) LIMIT 4 [ RunTime:0.000416s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '55' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000489s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '55' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000432s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '55' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000362s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=55 ) LIMIT 4 [ RunTime:0.000440s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '335' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000393s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '335' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000508s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '335' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000696s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=335 ) LIMIT 4 [ RunTime:0.000609s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '56' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.001096s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_brands` `b` ON `gcb`.`brandId`=b.brandId and b.dataFlag=1 WHERE ( gc.dataFlag=1 and gc.isShow=1 ) AND `b`.`dataFlag` = '1' AND `gc`.`catId` = '56' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000858s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '56' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.001158s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,`gcb`.`catId`,`sc`.`shopStreetImg` FROM `wst_goods_cats` `gc` INNER JOIN `wst_cat_shops` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `wst_shops` `b` ON `gcb`.`shopId`=b.shopId and b.shopStatus=1 and b.dataFlag=1 INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE ( gc.dataFlag=1 and gc.isShow=1 and gc.catId=56 ) LIMIT 4 [ RunTime:0.000784s ]
[ SQL ] SHOW COLUMNS FROM `wst_navs` [ RunTime:0.001342s ]
[ SQL ] SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000735s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.002168s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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-art' and adStartDate<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000918s ]
[ SQL ] SHOW COLUMNS FROM `wst_articles` [ RunTime:0.001708s ]
[ SQL ] SELECT `a`.`articleId`,`a`.`articleTitle`,`a`.`coverImg`,`a`.`createTime` FROM `wst_articles` `a` INNER JOIN `wst_article_cats` `ac` ON `a`.`catId`=`ac`.`catId` WHERE ( ac.catType=0 and ac.parentId<>7 and a.dataFlag=1 and ac.isShow=1 and a.isShow=1 and ac.dataFlag=1 ) ORDER BY `a`.`catSort` ASC,`a`.`createTime` DESC LIMIT 5 [ RunTime:0.001157s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.001125s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.001722s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.001692s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000806s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000765s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000988s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `wst_brands` `b` INNER JOIN `wst_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` LIMIT 10 [ RunTime:0.000749s ]
[ SQL ] SELECT `brandId`,`brandImg`,`brandName`,0 catId FROM `wst_brands` WHERE `dataFlag` = 1 ORDER BY `sortNo` ASC LIMIT 10 [ RunTime:0.000680s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000673s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods` [ RunTime:0.001762s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '3' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 2 [ RunTime:0.003029s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 2 [ RunTime:0.001372s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 5 [ RunTime:0.000949s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 5 [ RunTime:0.000810s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `wst_shops` `b` INNER JOIN `wst_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `wst_shop_configs` `sc` ON `b`.`shopId`=`sc`.`shopId` WHERE `r`.`dataSrc` = '1' AND `b`.`dataFlag` = '1' AND `b`.`applyStatus` = '2' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 4 [ RunTime:0.000886s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000696s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.001012s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '52' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000833s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000733s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '52_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000995s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '190' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001278s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 190 LIMIT 1 [ RunTime:0.000585s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000632s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '52_190_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001038s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '189' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000574s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 189 LIMIT 1 [ RunTime:0.000320s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000368s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '52_189_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000829s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '191' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000844s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 191 LIMIT 1 [ RunTime:0.000355s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000511s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '52_191_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001241s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '192' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001396s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 192 LIMIT 1 [ RunTime:0.000516s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000379s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '52_192_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000802s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '193' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001095s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 193 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000624s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '52_193_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000838s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000682s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000452s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '53' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000940s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000422s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '53_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.001670s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '137' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000734s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 137 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000362s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '53_137_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000846s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '138' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000713s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 138 LIMIT 1 [ RunTime:0.000672s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000443s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '53_138_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000864s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '139' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001097s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 139 LIMIT 1 [ RunTime:0.000509s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000352s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '53_139_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000540s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '140' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000675s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 140 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000236s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '53_140_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000587s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '141' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000470s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 141 LIMIT 1 [ RunTime:0.000404s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '53_141_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000616s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000565s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000585s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '47' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000746s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000476s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '47_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.002505s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '61' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000784s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 61 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000279s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_61_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001375s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '62' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001251s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 62 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000178s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_62_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001419s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '63' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001439s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 63 LIMIT 1 [ RunTime:0.000536s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000366s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_63_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.002192s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '64' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000622s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 64 LIMIT 1 [ RunTime:0.000677s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000394s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_64_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001216s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '65' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000420s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 65 LIMIT 1 [ RunTime:0.000339s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_65_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001221s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '66' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000564s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 66 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000179s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_66_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000973s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '71' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000439s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 71 LIMIT 1 [ RunTime:0.000331s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '47_71_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.001038s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000494s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000337s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '49' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000779s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '49_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000477s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '80' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000516s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 80 LIMIT 1 [ RunTime:0.000294s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000226s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_80_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000526s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '78' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000437s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 78 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000249s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_78_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000480s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '79' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000550s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 79 LIMIT 1 [ RunTime:0.000207s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000171s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_79_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000479s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '81' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000401s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 81 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_81_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000491s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '82' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000530s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 82 LIMIT 1 [ RunTime:0.000223s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000253s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_82_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000404s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000373s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000341s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '50' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000372s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000275s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '50_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000425s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '219' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000407s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 219 LIMIT 1 [ RunTime:0.000196s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '50_219_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000547s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '220' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000386s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 220 LIMIT 1 [ RunTime:0.000278s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000173s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '50_220_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000446s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '221' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000401s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 221 LIMIT 1 [ RunTime:0.000219s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '50_221_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000378s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '222' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000414s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 222 LIMIT 1 [ RunTime:0.000187s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000164s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '50_222_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000437s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '223' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000390s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 223 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000200s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '50_223_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000414s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000522s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000504s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '51' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000398s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000190s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '51_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000490s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '164' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000454s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 164 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000167s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '51_164_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000412s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '165' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000355s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 165 LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '51_165_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000457s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '167' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000378s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 167 LIMIT 1 [ RunTime:0.000197s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000165s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '51_167_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000394s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '166' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000404s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 166 LIMIT 1 [ RunTime:0.000181s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '51_166_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000384s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000343s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000394s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '48' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000427s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000199s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '48_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000434s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '74' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000438s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 74 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '48_74_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000495s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '258' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000386s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 258 LIMIT 1 [ RunTime:0.000193s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '48_258_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000428s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '259' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000564s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 259 LIMIT 1 [ RunTime:0.000254s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000437s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '48_259_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000486s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '260' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000632s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 260 LIMIT 1 [ RunTime:0.000218s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000202s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '48_260_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000384s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '261' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000468s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 261 LIMIT 1 [ RunTime:0.000324s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '48_261_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000391s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000330s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000342s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '334' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000385s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000228s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '334_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000583s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods_specs` [ RunTime:0.000999s ]
[ SQL ] SELECT * FROM wst_goods_specs gs WHERE `goodsId` IN (75,76,77,78,79,80,81,82) AND `dataFlag` = 1 ORDER BY `id` ASC [ RunTime:0.000791s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '348' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000979s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 348 LIMIT 1 [ RunTime:0.000409s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000630s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '334_348_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000698s ]
[ SQL ] SELECT * FROM wst_goods_specs gs WHERE `goodsId` IN (75,76,77,78,79,80,81,82,93) AND `dataFlag` = 1 ORDER BY `id` ASC [ RunTime:0.001119s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '349' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.001411s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 349 LIMIT 1 [ RunTime:0.000818s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000638s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '334_349_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000999s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '350' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000746s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 350 LIMIT 1 [ RunTime:0.000526s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000427s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '334_350_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000820s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '361' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000735s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 361 LIMIT 1 [ RunTime:0.000334s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000620s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '334_361_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000839s ]
[ SQL ] SELECT `goodsCatId` FROM `wst_goods` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `dataFlag` = 1 AND `goodsId` IN (0) GROUP BY `goodsCatId` [ RunTime:0.000341s ]
[ SQL ] SELECT `goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `dataFlag` = 1 AND `goodsCatId` IN ('') LIMIT 30 [ RunTime:0.001001s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `wst_goods` `g` INNER JOIN `wst_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `wst_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `r`.`dataSrc` = '0' AND `g`.`isSale` = '1' AND `g`.`goodsStatus` = '1' AND `g`.`dataFlag` = '1' AND `r`.`dataType` = '1' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000543s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`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<= '2025-10-18' and adEndDate>='2025-10-18' ) ORDER BY `createTime` DESC LIMIT 1 [ RunTime:0.000592s ]
[ SQL ] SHOW COLUMNS FROM `wst_article_cats` [ RunTime:0.001078s ]
[ SQL ] SELECT `catName`,`catId` FROM `wst_article_cats` WHERE `catType` = 1 AND `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 7 ORDER BY `catSort` ASC LIMIT 5 [ RunTime:0.000590s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `wst_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 5 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000581s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `wst_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 9 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000834s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `wst_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 1 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.001018s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `wst_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 10 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000617s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `wst_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 6 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000792s ]
[ SQL ] SHOW COLUMNS FROM `wst_friendlinks` [ RunTime:0.001500s ]
[ SQL ] SELECT * FROM `wst_friendlinks` WHERE `dataFlag` = 1 ORDER BY `friendlinkSort` ASC [ RunTime:0.000492s ]
[ SQL ] SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000465s ]
