[ DB ] CONNECT:[ UseTime:0.002825s ] mysql:host=rm-8vb5fu6le8n4r2471so.mysql.zhangbei.rds.aliyuncs.com;port=3306;dbname=fulijin;charset=utf8
[ SQL ] SHOW COLUMNS FROM `tb_data_cats` [ RunTime:0.002041s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000834s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000752s ]
[ SQL ] SHOW COLUMNS FROM `tb_goods_cats` [ RunTime:0.001882s ]
[ SQL ] SELECT * FROM `tb_goods_cats` WHERE `dataFlag` = 1 AND `isShow` = 1 AND `parentId` = 0 ORDER BY `catSort` ASC [ RunTime:0.000932s ]
[ SQL ] SHOW COLUMNS FROM `tb_brands` [ RunTime:0.001626s ]
[ SQL ] SELECT COUNT(*) AS tp_count FROM ( SELECT count(*) AS think_count FROM `tb_brands` `b` LEFT JOIN `tb_cat_brands` `gcb` ON `gcb`.`brandId`=`b`.`brandId` WHERE `b`.`dataFlag` = '1' AND `gcb`.`catId` = '2' GROUP BY `b`.`brandId`,`gcb`.`catId` ) `_group_count_` LIMIT 1 [ RunTime:0.000916s ]
[ SQL ] SELECT `b`.`brandId`,`brandName`,`brandImg`,`gcb`.`catId` FROM `tb_brands` `b` LEFT JOIN `tb_cat_brands` `gcb` ON `gcb`.`brandId`=`b`.`brandId` WHERE `b`.`dataFlag` = '1' AND `gcb`.`catId` = '2' GROUP BY `b`.`brandId`,`gcb`.`catId` ORDER BY `b`.`sortNo` ASC LIMIT 0,66 [ RunTime:0.000899s ]
[ SQL ] SHOW COLUMNS FROM `tb_ads` [ RunTime:0.001738s ]
[ 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-05-19' and adEndDate>='2026-05-19' ) ORDER BY `adSort` LIMIT 99 [ RunTime:0.000933s ]
[ SQL ] SELECT `catId` FROM `tb_data_cats` WHERE `catCode` = 'ADS_TYPE' LIMIT 1 [ RunTime:0.000747s ]
[ 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.000787s ]
[ 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.000921s ]
[ SQL ] SHOW COLUMNS FROM `tb_navs` [ RunTime:0.001621s ]
[ SQL ] SELECT * FROM `tb_navs` WHERE `isShow` = 1 AND `navType` = 0 ORDER BY `navSort` ASC [ RunTime:0.000857s ]
[ SQL ] SHOW COLUMNS FROM `tb_article_cats` [ RunTime:0.001599s ]
[ 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.000868s ]
[ SQL ] SHOW COLUMNS FROM `tb_articles` [ RunTime:0.001704s ]
[ 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.000876s ]
[ 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.000804s ]
[ 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.000824s ]
[ 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.000760s ]
[ 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.000823s ]
[ SQL ] SHOW COLUMNS FROM `tb_friendlinks` [ RunTime:0.002081s ]
[ SQL ] SELECT * FROM `tb_friendlinks` WHERE `dataFlag` = 1 ORDER BY `friendlinkSort` ASC [ RunTime:0.000880s ]
[ SQL ] SELECT * FROM `tb_navs` WHERE `isShow` = 1 AND `navType` = 1 ORDER BY `navSort` ASC [ RunTime:0.000838s ]
首页