SHOW FULL COLUMNS FROM `goods_type` [ RunTime:0.001164s ]
SELECT * FROM `goods_type` WHERE `userid` = 15820 ORDER BY `ord` ASC,`id` ASC [ RunTime:0.000607s ]
SHOW FULL COLUMNS FROM `goods_info` [ RunTime:0.001009s ]
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` = '10345' [ RunTime:0.006193s ]
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` = '10345' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 0,24 [ RunTime:0.002819s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.001356s ]
SELECT * FROM `goods` WHERE `id` IN (1830,1710,1466,507,1320,648,1779,1778,1465,1383,1364,1284,1233,1234,652,650,646,645,644,647,649,478,643,72) [ RunTime:0.000757s ]
SELECT * FROM `goods` WHERE `id` = 72 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000604s ]
SELECT * FROM `goods` WHERE `id` = 478 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000441s ]
SELECT * FROM `goods` WHERE `id` = 507 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000513s ]
SELECT * FROM `goods` WHERE `id` = 643 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000409s ]
SHOW FULL COLUMNS FROM `goods_sku_private` [ RunTime:0.001070s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 643 LIMIT 1 [ RunTime:0.000434s ]
SELECT * FROM `goods` WHERE `id` = 644 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000467s ]
SELECT * FROM `goods` WHERE `id` = 645 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `goods` WHERE `id` = 646 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `goods` WHERE `id` = 647 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000476s ]
SELECT * FROM `goods` WHERE `id` = 648 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `goods` WHERE `id` = 649 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000372s ]
SELECT * FROM `goods` WHERE `id` = 650 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000464s ]
SELECT * FROM `goods` WHERE `id` = 652 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000479s ]
SELECT * FROM `goods` WHERE `id` = 1233 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000461s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1233 LIMIT 1 [ RunTime:0.000445s ]
SELECT * FROM `goods` WHERE `id` = 1234 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000421s ]
SELECT * FROM `goods` WHERE `id` = 1284 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `goods` WHERE `id` = 1320 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `goods` WHERE `id` = 1364 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000382s ]
SELECT * FROM `goods` WHERE `id` = 1383 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000404s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1383 LIMIT 1 [ RunTime:0.000398s ]
SELECT * FROM `goods` WHERE `id` = 1465 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000470s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1465 LIMIT 1 [ RunTime:0.000334s ]
SELECT * FROM `goods` WHERE `id` = 1466 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000405s ]
SELECT * FROM `goods` WHERE `id` = 1710 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1710 LIMIT 1 [ RunTime:0.000371s ]
SELECT * FROM `goods` WHERE `id` = 1778 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000399s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1778 LIMIT 1 [ RunTime:0.000352s ]
SELECT * FROM `goods` WHERE `id` = 1779 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000437s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1779 LIMIT 1 [ RunTime:0.000344s ]
SELECT * FROM `goods` WHERE `id` = 1830 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000405s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001928s ]
SELECT ID AS id,medianame AS NAME,weburl AS URL FROM `user` WHERE `ID` = 15820 LIMIT 1 [ RunTime:0.000437s ]
SHOW FULL COLUMNS FROM `theme` [ RunTime:0.001013s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'seo' [ RunTime:0.030748s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'shop' [ RunTime:0.028550s ]
SHOW FULL COLUMNS FROM `news_info` [ RunTime:0.001295s ]
SELECT ID AS id,`title`,`content`,`data`,`propic` FROM `news_info` WHERE `userid` = 15820 AND `class_id` = 29 ORDER BY `ID` DESC [ RunTime:0.001255s ]
