SHOW FULL COLUMNS FROM `goods_type` [ RunTime:0.047823s ]
SELECT * FROM `goods_type` WHERE `userid` = 15820 ORDER BY `ord` ASC,`id` ASC [ RunTime:0.047656s ]
SHOW FULL COLUMNS FROM `goods_info` [ RunTime:0.047491s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '8' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.119968s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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 5 [ RunTime:0.072606s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '53' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.072405s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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 5 [ RunTime:0.072575s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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 5 [ RunTime:0.096464s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '10342' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.096212s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '32' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.143468s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '10625' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.072772s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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` = '54' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.096645s ]
SELECT `i`.`id`,`i`.`goodsid`,`i`.`type`,`i`.`name`,`i`.`title`,`i`.`showprice`,`i`.`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`.`ishot` = '2' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 10 [ RunTime:0.072306s ]
SHOW FULL COLUMNS FROM `news_info` [ RunTime:0.047635s ]
SELECT ID AS id,`title`,`propic`,`content`,`data` FROM `news_info` WHERE `userid` = 15820 AND `tj` = 1 ORDER BY `data` DESC,`ID` DESC LIMIT 3 [ RunTime:0.047665s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.048246s ]
SELECT ID AS id,medianame AS NAME,weburl AS URL FROM `user` WHERE `ID` = 15820 LIMIT 1 [ RunTime:0.047439s ]
SHOW FULL COLUMNS FROM `theme` [ RunTime:0.047564s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'seo' [ RunTime:0.119145s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'shop' [ RunTime:0.117215s ]
SELECT ID AS id,`title`,`content`,`data`,`propic` FROM `news_info` WHERE `userid` = 15820 AND `class_id` = 29 ORDER BY `ID` DESC [ RunTime:0.118699s ]