SHOW FULL COLUMNS FROM `wst_sys_configs` [ RunTime:0.000511s ]
SELECT `fieldCode`,`fieldValue` FROM `wst_sys_configs` [ RunTime:0.000313s ]
SHOW FULL COLUMNS FROM `wst_styles` [ RunTime:0.000409s ]
SELECT `styleSys`,`stylePath`,`id` FROM `wst_styles` WHERE `isUse` = 1 [ RunTime:0.000212s ]
SHOW FULL COLUMNS FROM `wst_datas` [ RunTime:0.000291s ]
SELECT `dataVal` FROM `wst_datas` WHERE `catId` = 3 [ RunTime:0.000204s ]
SHOW FULL COLUMNS FROM `wst_combinations` [ RunTime:0.000409s ]
SELECT `c`.`combineId`,`c`.`combineName`,`c`.`combineDesc`,`c`.`combineImg`,`c`.`combineType`,`c`.`isAdvance`,`c`.`advanceDay`,`c`.`startTime`,`c`.`endTime`,`c`.`isFreeShipping`,`g`.`goodsImg`,`g`.`goodsName`,`g`.`isSpec`,`cg`.`goodsId`,`cg`.`reduceMoney`,`cg`.`id`,g.shopPrice-cg.reduceMoney shopPrice,`g`.`goodsStock` FROM `wst_combinations` `c` INNER JOIN `wst_combination_goods` `cg` ON `c`.`combineId`=`cg`.`combineId` INNER JOIN `wst_goods` `g` ON `g`.`goodsId`=`cg`.`goodsId` WHERE `c`.`dataFlag` = 1 AND `c`.`combineId` = 3 AND `g`.`isSale` = 1 AND `g`.`dataFlag` = 1 ORDER BY `cg`.`goodsType` DESC,`c`.`combineOrder` ASC,`c`.`startTime` ASC,`c`.`combineId` ASC LIMIT 1 [ RunTime:0.000439s ]
SHOW FULL COLUMNS FROM `wst_combination_goods` [ RunTime:0.000321s ]
SELECT `cg`.`id`,`cg`.`goodsId`,`g`.`goodsImg`,`g`.`goodsName`,`cg`.`reduceMoney`,`g`.`dataFlag`,`g`.`isSale`,g.shopPrice-cg.reduceMoney shopPrice,`cg`.`goodsType`,`g`.`isSpec`,`g`.`goodsUnit`,`g`.`marketPrice`,`g`.`goodsStock` FROM `wst_combination_goods` `cg` INNER JOIN `wst_goods` `g` ON `g`.`goodsId`=`cg`.`goodsId` WHERE `combineId` = 3 [ RunTime:0.000251s ]
SHOW FULL COLUMNS FROM `wst_spec_cats` [ RunTime:0.000338s ]
SELECT `gc`.`isAllowImg`,`gc`.`catName`,`sit`.`catId`,`sit`.`itemId`,`sit`.`itemName`,`sit`.`itemImg`,`sit`.`goodsId` FROM `wst_spec_cats` `gc` INNER JOIN `wst_spec_items` `sit` ON `gc`.`catId`=`sit`.`catId` WHERE `sit`.`goodsId` IN (10,19,22,23,26) AND `gc`.`isShow` = 1 AND `sit`.`dataFlag` = 1 ORDER BY `gc`.`isAllowImg` DESC,`gc`.`catSort` ASC,`gc`.`catId` ASC [ RunTime:0.000382s ]
SHOW FULL COLUMNS FROM `wst_goods_specs` [ RunTime:0.000341s ]
SELECT `id`,`isDefault`,`productNo`,`specIds`,`marketPrice`,`specPrice`,`specStock`,`goodsId`,`specWeight`,`specVolume` FROM `wst_goods_specs` WHERE `goodsId` IN (10,19,22,23,26) [ RunTime:0.000254s ]