[ DB ] CONNECT:[ UseTime:0.001915s ] mysql:host=rm-8vb5fu6le8n4r2471so.mysql.zhangbei.rds.aliyuncs.com;port=3306;dbname=fulijin;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_data_cats` [ RunTime:0.001977s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000879s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000784s ]
[ SQL ] SHOW COLUMNS FROM `tb_goods_cats` [ RunTime:0.001902s ]
[ SQL ] SELECT `catName`,`catId`,`subTitle`,`simpleName` FROM `tb_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 AND `isFloor` = 1 ORDER BY `catSort` LIMIT 10 [ RunTime:0.000937s ]
[ SQL ] SELECT `parentId`,`catName`,`catId`,`subTitle`,`simpleName` FROM `tb_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` IN (2) AND `isFloor` = 1 ORDER BY `catSort` ASC [ RunTime:0.000861s ]
[ SQL ] SHOW COLUMNS FROM `tb_users` [ RunTime:0.002010s ]
[ SQL ] SELECT `userScore` FROM `tb_users` WHERE `userId` = 0 AND `dataFlag` = 1 LIMIT 1 [ RunTime:0.000828s ]
[ SQL ] SHOW COLUMNS FROM `tb_ads` [ RunTime:0.001685s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-top-ads' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000956s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000819s ]
[ SQL ] SHOW COLUMNS FROM `tb_brands` [ RunTime:0.001625s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,r.goodsCatId catId FROM `tb_brands` `b` INNER JOIN `tb_recommends` `r` ON `b`.`brandId`=`r`.`dataId` WHERE `r`.`dataSrc` = '2' AND `b`.`dataFlag` = '1' AND `r`.`dataType` = '0' AND `r`.`goodsCatId` = '2' ORDER BY `r`.`dataSort` LIMIT 6 [ RunTime:0.000918s ]
[ SQL ] SELECT `b`.`brandId`,`b`.`brandImg`,`b`.`brandName`,`gcb`.`catId` FROM `tb_goods_cats` `gc` INNER JOIN `tb_cat_brands` `gcb` ON `gc`.`catId`=`gcb`.`catId` INNER JOIN `tb_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` = '2' GROUP BY `b`.`brandId`,`gcb`.`catId` LIMIT 6 [ RunTime:0.000937s ]
[ SQL ] SHOW COLUMNS FROM `tb_navs` [ RunTime:0.001620s ]
[ SQL ] SELECT * FROM `tb_navs` WHERE `isShow` = 1 AND `navType` = 0 ORDER BY `navSort` ASC [ RunTime:0.000942s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-index' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000949s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-art' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000887s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-index' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000949s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-top' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000926s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-left-bottom' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000893s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-center' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000910s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-top' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000893s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='wall-right-bottom' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000939s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='rbnh-left-ads' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000964s ]
[ SQL ] SHOW COLUMNS FROM `tb_goods` [ RunTime:0.002130s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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.001030s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isNew` = 1 ORDER BY `saleTime` DESC,`goodsId` ASC LIMIT 2 [ RunTime:0.000914s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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.000989s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 2 [ RunTime:0.000900s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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.000990s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 5 [ RunTime:0.000881s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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.000967s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isRecom` = 1 ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 5 [ RunTime:0.000864s ]
[ SQL ] SHOW COLUMNS FROM `tb_shops` [ RunTime:0.002242s ]
[ SQL ] SELECT `b`.`shopId`,`b`.`shopImg`,`b`.`shopName`,r.goodsCatId catId,`sc`.`shopStreetImg` FROM `tb_shops` `b` INNER JOIN `tb_recommends` `r` ON `b`.`shopId`=`r`.`dataId` INNER JOIN `tb_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.000885s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='ads-1-1' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 1 [ RunTime:0.000963s ]
[ SQL ] SELECT `adId`,`adName`,`adURL`,`subTitle`,`adFile`,`positionWidth`,`positionHeight` FROM `tb_ads` `a` LEFT JOIN `tb_ad_positions` `ap` ON `a`.`adPositionId`=ap.positionId and ap.dataFlag=1 WHERE ( a.dataFlag=1 and ap.positionCode='index-floor-left-1' and adStartDate<= '2026-03-19' and adEndDate>='2026-03-19' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000948s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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` = '2' ORDER BY `r`.`dataSort` ASC LIMIT 8 [ RunTime:0.000954s ]
[ SQL ] SELECT `parentId` FROM `tb_goods_cats` WHERE `catId` = 2 LIMIT 1 [ RunTime:0.000787s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 AND `g`.`goodsCatIdPath` LIKE '2_%' ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 8 [ RunTime:0.000932s ]
[ SQL ] SELECT `goodsCatId` FROM `tb_goods` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `dataFlag` = 1 AND `goodsId` IN (0) GROUP BY `goodsCatId` [ RunTime:0.000885s ]
[ SQL ] SELECT `goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `dataFlag` = 1 AND `goodsId` IN (0) AND `goodsCatId` IN ('') LIMIT 30 [ RunTime:0.000843s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`g`.`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_recommends` `r` ON `g`.`goodsId`=`r`.`dataId` INNER JOIN `tb_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.000973s ]
[ SQL ] SELECT `g`.`goodsTips`,`s`.`shopName`,`s`.`shopId`,`goodsId`,`goodsName`,`goodsImg`,`goodsSn`,`goodsStock`,`saleNum`,`shopPrice`,`marketPrice`,`isSpec`,`appraiseNum`,`visitNum`,`isNew` FROM `tb_goods` `g` INNER JOIN `tb_shops` `s` ON `g`.`shopId`=`s`.`shopId` WHERE `isSale` = 1 AND `goodsStatus` = 1 AND `g`.`dataFlag` = '1' AND `isHot` = 1 ORDER BY `saleNum` DESC,`goodsId` ASC LIMIT 10 [ RunTime:0.000888s ]
[ SQL ] SHOW COLUMNS FROM `tb_article_cats` [ RunTime:0.001656s ]
[ SQL ] SELECT `catName`,`catId` FROM `tb_article_cats` WHERE `catType` = 1 AND `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 7 ORDER BY `catSort` ASC LIMIT 5 [ RunTime:0.000933s ]
[ SQL ] SHOW COLUMNS FROM `tb_articles` [ RunTime:0.001736s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `tb_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 5 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000924s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `tb_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 9 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000885s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `tb_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 1 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000821s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `tb_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 10 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000839s ]
[ SQL ] SELECT `articleId`,`catId`,`articleTitle` FROM `tb_articles` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `catId` = 6 ORDER BY `catSort` ASC,`createTime` ASC LIMIT 6 [ RunTime:0.000865s ]
[ SQL ] SHOW COLUMNS FROM `tb_friendlinks` [ RunTime:0.001695s ]
[ SQL ] SELECT * FROM `tb_friendlinks` WHERE `dataFlag` = 1 ORDER BY `friendlinkSort` ASC [ RunTime:0.000899s ]
[ SQL ] SELECT * FROM `tb_navs` WHERE `isShow` = 1 AND `navType` = 1 ORDER BY `navSort` ASC [ RunTime:0.000951s ]
登录商家中心
