[ DB ] CONNECT:[ UseTime:0.000514s ] mysql:host=127.0.0.1;port=3306;dbname=wstmart;charset=utf8
[ SQL ] SHOW COLUMNS FROM `wst_sys_configs` [ RunTime:0.001014s ]
[ SQL ] SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000550s ]
[ SQL ] SHOW COLUMNS FROM `wst_styles` [ RunTime:0.000905s ]
[ SQL ] SELECT `styleSys`,`stylePath`,`id` FROM `wst_styles` WHERE `isUse` = 1 [ RunTime:0.000366s ]
[ SQL ] SHOW COLUMNS FROM `wst_datas` [ RunTime:0.000775s ]
[ SQL ] SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000369s ]
[ SQL ] show tables like 'wst_app_session'; [ RunTime:0.000458s ]
[ SQL ] SHOW COLUMNS FROM `wst_home_menus` [ RunTime:0.000935s ]
[ SQL ] SELECT * FROM `wst_home_menus` WHERE `dataFlag` = 1 ORDER BY `menuType` ASC [ RunTime:0.000941s ]
[ SQL ] SHOW COLUMNS FROM `wst_switchs` [ RunTime:0.000971s ]
[ SQL ] SELECT * FROM `wst_switchs` [ RunTime:0.000260s ]
[ SQL ] SHOW COLUMNS FROM `wst_data_cats` [ RunTime:0.000617s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000255s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000507s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000395s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000510s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods_cats` [ RunTime:0.001316s ]
[ 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.000438s ]
[ 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.000606s ]
[ SQL ] SHOW COLUMNS FROM `wst_users` [ RunTime:0.001104s ]
[ SQL ] SELECT `userScore` FROM `wst_users` WHERE `userId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.000281s ]
[ SQL ] SHOW COLUMNS FROM `wst_ads` [ RunTime:0.000980s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000578s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000309s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000642s ]
[ SQL ] SELECT `catId` FROM `wst_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000311s ]
[ SQL ] SELECT * FROM `wst_datas` WHERE `dataFlag` = 1 ORDER BY `catId` ASC,`dataSort` ASC,`id` ASC [ RunTime:0.000664s ]
[ SQL ] SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000412s ]
[ 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.000562s ]
[ 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.000957s ]
[ SQL ] SELECT `catName`,`catId`,`catImg` FROM `wst_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000523s ]
[ 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.000595s ]
[ 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.001036s ]
[ SQL ] SHOW COLUMNS FROM `wst_brands` [ RunTime:0.001106s ]
[ 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.000404s ]
[ 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.000416s ]
[ SQL ] SHOW COLUMNS FROM `wst_shops` [ RunTime:0.001028s ]
[ 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.000433s ]
[ 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.000389s ]
[ 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.000384s ]
[ 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.000503s ]
[ 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.000387s ]
[ 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.000374s ]
[ 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.000390s ]
[ 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.000560s ]
[ 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.000481s ]
[ 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.000505s ]
[ 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.000499s ]
[ 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.000461s ]
[ 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.000424s ]
[ 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.000504s ]
[ 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.000397s ]
[ 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.000487s ]
[ 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.000368s ]
[ 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.000508s ]
[ 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.000365s ]
[ 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.000429s ]
[ 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.000312s ]
[ 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.000332s ]
[ 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.000594s ]
[ 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.000427s ]
[ 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.000412s ]
[ 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.000405s ]
[ 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.000357s ]
[ 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.000494s ]
[ 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.000376s ]
[ 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.000418s ]
[ 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.000412s ]
[ 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.000526s ]
[ 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.000422s ]
[ 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.000383s ]
[ 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.000380s ]
[ 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.000460s ]
[ 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.000387s ]
[ 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.000390s ]
[ 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.000404s ]
[ 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.000426s ]
[ 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.000317s ]
[ 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.000458s ]
[ 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.000516s ]
[ 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.000392s ]
[ 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.000387s ]
[ 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.000399s ]
[ SQL ] SHOW COLUMNS FROM `wst_navs` [ RunTime:0.000853s ]
[ SQL ] SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000313s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000398s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000329s ]
[ SQL ] SHOW COLUMNS FROM `wst_articles` [ RunTime:0.001025s ]
[ 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.000370s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000358s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000329s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000323s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000320s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000305s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000312s ]
[ 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.000351s ]
[ SQL ] SELECT `brandId`,`brandImg`,`brandName`,0 catId FROM `wst_brands` WHERE `dataFlag` = 1 ORDER BY `sortNo` ASC LIMIT 10 [ RunTime:0.000246s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000313s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods` [ RunTime:0.000945s ]
[ 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.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` = '1' AND `r`.`goodsCatId` = '0' ORDER BY `r`.`dataSort` ASC LIMIT 2 [ RunTime:0.000439s ]
[ 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.000403s ]
[ 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.000384s ]
[ 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.000434s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000324s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) 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` = '52' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000412s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000193s ]
[ 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.000454s ]
[ 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.000412s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 190 LIMIT 1 [ RunTime:0.000186s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 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 '52_190_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000371s ]
[ 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.000338s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 189 LIMIT 1 [ RunTime:0.000201s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 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 '52_189_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000405s ]
[ 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.000488s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 191 LIMIT 1 [ RunTime:0.000198s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 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 '52_191_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000326s ]
[ 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.000347s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 192 LIMIT 1 [ RunTime:0.000177s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000174s ]
[ 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.000324s ]
[ 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.000349s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 193 LIMIT 1 [ RunTime:0.000183s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 52 LIMIT 1 [ RunTime:0.000214s ]
[ 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.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='ads-2-1' and adStartDate<= '2025-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000363s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000331s ]
[ 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.000390s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 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 '53_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000397s ]
[ 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.000380s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 137 LIMIT 1 [ RunTime:0.000182s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000172s ]
[ 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.000354s ]
[ 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.000332s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 138 LIMIT 1 [ RunTime:0.000194s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000169s ]
[ 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.000417s ]
[ 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.001011s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 139 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000243s ]
[ 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.000407s ]
[ 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.000442s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 140 LIMIT 1 [ RunTime:0.000231s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 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 '53_140_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000418s ]
[ 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.000379s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 141 LIMIT 1 [ RunTime:0.000184s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 53 LIMIT 1 [ RunTime:0.000217s ]
[ 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.000407s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000367s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000405s ]
[ 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.000444s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000251s ]
[ 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.001016s ]
[ 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.000438s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 61 LIMIT 1 [ RunTime:0.000229s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000210s ]
[ 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.001064s ]
[ 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.000445s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 62 LIMIT 1 [ RunTime:0.000258s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000237s ]
[ 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.000960s ]
[ 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.000519s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 63 LIMIT 1 [ RunTime:0.000227s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000233s ]
[ 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.000979s ]
[ 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.000457s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 64 LIMIT 1 [ RunTime:0.000233s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000355s ]
[ 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.001248s ]
[ 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.000508s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 65 LIMIT 1 [ RunTime:0.000288s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 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 '47_65_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000986s ]
[ 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.000548s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 66 LIMIT 1 [ RunTime:0.000507s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000234s ]
[ 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.001218s ]
[ 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.000829s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 71 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 47 LIMIT 1 [ RunTime:0.000209s ]
[ 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.001189s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000551s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000472s ]
[ 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.000513s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000317s ]
[ 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.000616s ]
[ 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.000588s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 80 LIMIT 1 [ RunTime:0.000365s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 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 `isRecom` = 1 AND `g`.`goodsCatIdPath` LIKE '49_80_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000528s ]
[ 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.000546s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 78 LIMIT 1 [ RunTime:0.000360s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000313s ]
[ 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.000501s ]
[ 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.000449s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 79 LIMIT 1 [ RunTime:0.000286s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000317s ]
[ 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.000586s ]
[ 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.000538s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 81 LIMIT 1 [ RunTime:0.000240s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 49 LIMIT 1 [ RunTime:0.000187s ]
[ 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.000493s ]
[ 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.000522s ]
[ 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.000176s ]
[ 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.000451s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000434s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000418s ]
[ 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.000366s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000194s ]
[ 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.000527s ]
[ 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.000429s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 219 LIMIT 1 [ RunTime:0.000172s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000166s ]
[ 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.000374s ]
[ 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.000385s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 220 LIMIT 1 [ RunTime:0.000162s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000281s ]
[ 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.000362s ]
[ 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.000398s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 221 LIMIT 1 [ RunTime:0.000293s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000245s ]
[ 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.000518s ]
[ 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.000518s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 222 LIMIT 1 [ RunTime:0.000262s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000281s ]
[ 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.000558s ]
[ 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.000402s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 223 LIMIT 1 [ RunTime:0.000378s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 50 LIMIT 1 [ RunTime:0.000257s ]
[ 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.000521s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000476s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000456s ]
[ 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.000487s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000206s ]
[ 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.000542s ]
[ 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.000526s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 164 LIMIT 1 [ RunTime:0.000292s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000193s ]
[ 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.000483s ]
[ 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.000398s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 165 LIMIT 1 [ RunTime:0.000296s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000203s ]
[ 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.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` = '167' ORDER BY `r`.`dataSort` ASC LIMIT 10 [ RunTime:0.000485s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 167 LIMIT 1 [ RunTime:0.000239s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 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 '51_167_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000416s ]
[ 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.000414s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 166 LIMIT 1 [ RunTime:0.000277s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 51 LIMIT 1 [ RunTime:0.000207s ]
[ 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.000400s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000403s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000362s ]
[ 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.000357s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000217s ]
[ 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.000574s ]
[ 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.000516s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 74 LIMIT 1 [ RunTime:0.000238s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000255s ]
[ 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.000556s ]
[ 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.000497s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 258 LIMIT 1 [ RunTime:0.000204s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000175s ]
[ 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.000414s ]
[ 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.000462s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 259 LIMIT 1 [ RunTime:0.000308s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000222s ]
[ 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.000548s ]
[ 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.000430s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 260 LIMIT 1 [ RunTime:0.000189s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000320s ]
[ 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.000379s ]
[ 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.000457s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 261 LIMIT 1 [ RunTime:0.000273s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 48 LIMIT 1 [ RunTime:0.000251s ]
[ 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.000422s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000532s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000419s ]
[ 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.000531s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000227s ]
[ 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.000642s ]
[ SQL ] SHOW COLUMNS FROM `wst_goods_specs` [ RunTime:0.000906s ]
[ 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.000627s ]
[ 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.000552s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 348 LIMIT 1 [ RunTime:0.000269s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000257s ]
[ 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.000566s ]
[ 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.000515s ]
[ 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.000709s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 349 LIMIT 1 [ RunTime:0.000234s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000195s ]
[ 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.000475s ]
[ 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.000383s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 350 LIMIT 1 [ RunTime:0.000291s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000310s ]
[ 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.000472s ]
[ 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.000391s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 361 LIMIT 1 [ RunTime:0.000299s ]
[ SQL ] SELECT `parentId` FROM `wst_goods_cats` WHERE `catId` = 334 LIMIT 1 [ RunTime:0.000242s ]
[ 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.001420s ]
[ SQL ] SELECT `goodsCatId` FROM `wst_goods` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `dataFlag` = 1 AND `goodsId` IN (0) GROUP BY `goodsCatId` [ RunTime:0.000450s ]
[ 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.000717s ]
[ 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.000566s ]
[ 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-06-22' and adEndDate>='2025-06-22' ) ORDER BY `createTime` DESC LIMIT 1 [ RunTime:0.000486s ]
[ SQL ] SHOW COLUMNS FROM `wst_article_cats` [ RunTime:0.001264s ]
[ 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.000836s ]
[ 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.000315s ]
[ 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.000468s ]
[ 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.000469s ]
[ 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.000349s ]
[ 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.000560s ]
[ SQL ] SHOW COLUMNS FROM `wst_friendlinks` [ RunTime:0.000941s ]
[ SQL ] SELECT * FROM `wst_friendlinks` WHERE `dataFlag` = 1 ORDER BY `friendlinkSort` ASC [ RunTime:0.000314s ]
[ SQL ] SELECT * FROM `wst_navs` WHERE `isShow` = 1 ORDER BY `navSort` ASC [ RunTime:0.000413s ]
