SHOW FULL COLUMNS FROM `goods_type` [ RunTime:0.000975s ]
SELECT * FROM `goods_type` WHERE `userid` = 15820 ORDER BY `ord` ASC,`id` ASC [ RunTime:0.000532s ]
SHOW FULL COLUMNS FROM `goods_info` [ RunTime:0.000891s ]
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` = '10133' [ RunTime:0.001869s ]
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` = '10133' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 0,24 [ RunTime:0.003783s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.001318s ]
SELECT * FROM `goods` WHERE `id` IN (96,667,836,47,94,1168,48,95,17,22) [ RunTime:0.000553s ]
SELECT * FROM `goods` WHERE `id` = 17 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000390s ]
SHOW FULL COLUMNS FROM `goods_sku_private` [ RunTime:0.000981s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 17 LIMIT 1 [ RunTime:0.000358s ]
SELECT * FROM `goods` WHERE `id` = 22 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000331s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 22 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `goods` WHERE `id` = 47 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 47 LIMIT 1 [ RunTime:0.000302s ]
SELECT * FROM `goods` WHERE `id` = 48 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000329s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 48 LIMIT 1 [ RunTime:0.000299s ]
SELECT * FROM `goods` WHERE `id` = 94 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000357s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 94 LIMIT 1 [ RunTime:0.000296s ]
SELECT * FROM `goods` WHERE `id` = 95 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000324s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 95 LIMIT 1 [ RunTime:0.000311s ]
SELECT * FROM `goods` WHERE `id` = 96 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000347s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 96 LIMIT 1 [ RunTime:0.000313s ]
SELECT * FROM `goods` WHERE `id` = 667 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000310s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 667 LIMIT 1 [ RunTime:0.000336s ]
SELECT * FROM `goods` WHERE `id` = 836 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000320s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 836 LIMIT 1 [ RunTime:0.000319s ]
SELECT * FROM `goods` WHERE `id` = 1168 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000332s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1168 LIMIT 1 [ RunTime:0.000422s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001604s ]
SELECT ID AS id,medianame AS NAME,weburl AS URL FROM `user` WHERE `ID` = 15820 LIMIT 1 [ RunTime:0.000370s ]
SHOW FULL COLUMNS FROM `theme` [ RunTime:0.000964s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'seo' [ RunTime:0.028841s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'shop' [ RunTime:0.028177s ]
SHOW FULL COLUMNS FROM `news_info` [ RunTime:0.001389s ]
SELECT ID AS id,`title`,`content`,`data`,`propic` FROM `news_info` WHERE `userid` = 15820 AND `class_id` = 29 ORDER BY `ID` DESC [ RunTime:0.001371s ]
