SHOW FULL COLUMNS FROM `goods_type` [ RunTime:0.001298s ]
SELECT * FROM `goods_type` WHERE `userid` = 15820 ORDER BY `ord` ASC,`id` ASC [ RunTime:0.000649s ]
SHOW FULL COLUMNS FROM `goods_info` [ RunTime:0.001016s ]
SELECT COUNT(*) AS think_count FROM `goods_info` `i` INNER JOIN `goods` `g` ON `g`.`id`=`i`.`goodsid` WHERE `i`.`userid` = '15820' AND `i`.`isdelete` = '1' AND `g`.`isdelete` = '1' AND `i`.`type` = '11' [ RunTime:0.001843s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,g.name AS name,`i`.`title`,`g`.`showprice`,`g`.`price`,`i`.`rebate`,`i`.`hits`,`i`.`ord`,`i`.`ishot`,g.name AS goods_name,g.logo AS goods_logo,g.des AS goods_des FROM `goods_info` `i` INNER JOIN `goods` `g` ON `g`.`id`=`i`.`goodsid` WHERE `i`.`userid` = '15820' AND `i`.`isdelete` = '1' AND `g`.`isdelete` = '1' AND `i`.`type` = '11' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 0,24 [ RunTime:0.002535s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.001453s ]
SELECT * FROM `goods` WHERE `id` IN (18,1319,1347,31,29,30,641,67,33,39,32,34,35) [ RunTime:0.000736s ]
SELECT * FROM `goods` WHERE `id` = 18 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000445s ]
SHOW FULL COLUMNS FROM `goods_sku_private` [ RunTime:0.000938s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 18 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `goods` WHERE `id` = 29 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000403s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 29 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `goods` WHERE `id` = 30 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 30 LIMIT 1 [ RunTime:0.000368s ]
SELECT * FROM `goods` WHERE `id` = 31 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 31 LIMIT 1 [ RunTime:0.000379s ]
SELECT * FROM `goods` WHERE `id` = 32 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 32 LIMIT 1 [ RunTime:0.000500s ]
SELECT * FROM `goods` WHERE `id` = 33 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000414s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 33 LIMIT 1 [ RunTime:0.000345s ]
SELECT * FROM `goods` WHERE `id` = 34 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000441s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 34 LIMIT 1 [ RunTime:0.000367s ]
SELECT * FROM `goods` WHERE `id` = 35 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 35 LIMIT 1 [ RunTime:0.000388s ]
SELECT * FROM `goods` WHERE `id` = 39 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 39 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `goods` WHERE `id` = 67 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000408s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 67 LIMIT 1 [ RunTime:0.000373s ]
SELECT * FROM `goods` WHERE `id` = 641 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000392s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 641 LIMIT 1 [ RunTime:0.000349s ]
SELECT * FROM `goods` WHERE `id` = 1319 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1319 LIMIT 1 [ RunTime:0.000346s ]
SELECT * FROM `goods` WHERE `id` = 1347 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000428s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1347 LIMIT 1 [ RunTime:0.000346s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001640s ]
SELECT ID AS id,medianame AS NAME,weburl AS URL FROM `user` WHERE `ID` = 15820 LIMIT 1 [ RunTime:0.000411s ]
SHOW FULL COLUMNS FROM `theme` [ RunTime:0.001047s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'seo' [ RunTime:0.027946s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'shop' [ RunTime:0.027852s ]
SHOW FULL COLUMNS FROM `news_info` [ RunTime:0.001385s ]
SELECT ID AS id,`title`,`content`,`data`,`propic` FROM `news_info` WHERE `userid` = 15820 AND `class_id` = 29 ORDER BY `ID` DESC [ RunTime:0.001294s ]
