SHOW FULL COLUMNS FROM `goods_type` [ RunTime:0.001254s ]
SELECT * FROM `goods_type` WHERE `userid` = 15820 ORDER BY `ord` ASC,`id` ASC [ RunTime:0.003075s ]
SHOW FULL COLUMNS FROM `goods_info` [ RunTime:0.001319s ]
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` = '8' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.025904s ]
SHOW FULL COLUMNS FROM `goods` [ RunTime:0.002244s ]
SELECT * FROM `goods` WHERE `id` IN (393,1342,1191,42,5) [ RunTime:0.000634s ]
SELECT * FROM `goods` WHERE `id` = 5 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000530s ]
SHOW FULL COLUMNS FROM `goods_sku_private` [ RunTime:0.001159s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 5 LIMIT 1 [ RunTime:0.001236s ]
SELECT * FROM `goods` WHERE `id` = 42 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000514s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 42 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `goods` WHERE `id` = 393 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000480s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 393 LIMIT 1 [ RunTime:0.000440s ]
SELECT * FROM `goods` WHERE `id` = 1191 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1191 LIMIT 1 [ RunTime:0.000442s ]
SELECT * FROM `goods` WHERE `id` = 1342 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000465s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1342 LIMIT 1 [ RunTime:0.000415s ]
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 5 [ RunTime:0.004771s ]
SELECT * FROM `goods` WHERE `id` IN (96,667,836,47,94) [ RunTime:0.000729s ]
SELECT * FROM `goods` WHERE `id` = 47 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000552s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 47 LIMIT 1 [ RunTime:0.000488s ]
SELECT * FROM `goods` WHERE `id` = 94 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000434s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 94 LIMIT 1 [ RunTime:0.000369s ]
SELECT * FROM `goods` WHERE `id` = 96 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000400s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 96 LIMIT 1 [ RunTime:0.000363s ]
SELECT * FROM `goods` WHERE `id` = 667 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000384s ]
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.000349s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 836 LIMIT 1 [ RunTime:0.000314s ]
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` = '53' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.005792s ]
SELECT * FROM `goods` WHERE `id` IN (1831,655,25,990,16) [ RunTime:0.000556s ]
SELECT * FROM `goods` WHERE `id` = 16 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000429s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 16 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `goods` WHERE `id` = 25 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 25 LIMIT 1 [ RunTime:0.000359s ]
SELECT * FROM `goods` WHERE `id` = 655 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000380s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 655 LIMIT 1 [ RunTime:0.000353s ]
SELECT * FROM `goods` WHERE `id` = 990 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000410s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 990 LIMIT 1 [ RunTime:0.000396s ]
SELECT * FROM `goods` WHERE `id` = 1831 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000458s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1831 LIMIT 1 [ RunTime:0.000413s ]
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 5 [ RunTime:0.003160s ]
SELECT * FROM `goods` WHERE `id` IN (18,1319,1347,31,29) [ RunTime:0.000514s ]
SELECT * FROM `goods` WHERE `id` = 18 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000468s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 18 LIMIT 1 [ RunTime:0.000412s ]
SELECT * FROM `goods` WHERE `id` = 29 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 29 LIMIT 1 [ RunTime:0.000387s ]
SELECT * FROM `goods` WHERE `id` = 31 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000457s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 31 LIMIT 1 [ RunTime:0.000436s ]
SELECT * FROM `goods` WHERE `id` = 1319 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000422s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1319 LIMIT 1 [ RunTime:0.000430s ]
SELECT * FROM `goods` WHERE `id` = 1347 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000473s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1347 LIMIT 1 [ RunTime:0.000459s ]
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 5 [ RunTime:0.005107s ]
SELECT * FROM `goods` WHERE `id` IN (1830,1710,1466,507,1320) [ RunTime:0.000627s ]
SELECT * FROM `goods` WHERE `id` = 507 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000530s ]
SELECT * FROM `goods` WHERE `id` = 1320 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000453s ]
SELECT * FROM `goods` WHERE `id` = 1466 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000419s ]
SELECT * FROM `goods` WHERE `id` = 1710 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000418s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1710 LIMIT 1 [ RunTime:0.000386s ]
SELECT * FROM `goods` WHERE `id` = 1830 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000445s ]
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` = '10342' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.004532s ]
SELECT * FROM `goods` WHERE `id` IN (19,1346,10,20,66) [ RunTime:0.000667s ]
SELECT * FROM `goods` WHERE `id` = 10 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000560s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 10 LIMIT 1 [ RunTime:0.000420s ]
SELECT * FROM `goods` WHERE `id` = 19 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 19 LIMIT 1 [ RunTime:0.000351s ]
SELECT * FROM `goods` WHERE `id` = 20 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000377s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 20 LIMIT 1 [ RunTime:0.000368s ]
SELECT * FROM `goods` WHERE `id` = 66 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000361s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 66 LIMIT 1 [ RunTime:0.000327s ]
SELECT * FROM `goods` WHERE `id` = 1346 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000377s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1346 LIMIT 1 [ RunTime:0.000332s ]
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` = '32' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.005810s ]
SELECT * FROM `goods` WHERE `id` IN (12,13,69,8,41) [ RunTime:0.000608s ]
SELECT * FROM `goods` WHERE `id` = 8 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000572s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 8 LIMIT 1 [ RunTime:0.000440s ]
SELECT * FROM `goods` WHERE `id` = 12 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000493s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 12 LIMIT 1 [ RunTime:0.000408s ]
SELECT * FROM `goods` WHERE `id` = 13 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000448s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 13 LIMIT 1 [ RunTime:0.000391s ]
SELECT * FROM `goods` WHERE `id` = 41 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000420s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 41 LIMIT 1 [ RunTime:0.000385s ]
SELECT * FROM `goods` WHERE `id` = 69 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000443s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 69 LIMIT 1 [ RunTime:0.000356s ]
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` = '10625' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.004659s ]
SELECT * FROM `goods` WHERE `id` IN (664,37,657,658,653) [ RunTime:0.000583s ]
SELECT * FROM `goods` WHERE `id` = 37 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000485s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 37 LIMIT 1 [ RunTime:0.000390s ]
SELECT * FROM `goods` WHERE `id` = 653 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000402s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 653 LIMIT 1 [ RunTime:0.000370s ]
SELECT * FROM `goods` WHERE `id` = 657 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000411s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 657 LIMIT 1 [ RunTime:0.000378s ]
SELECT * FROM `goods` WHERE `id` = 658 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000446s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 658 LIMIT 1 [ RunTime:0.000537s ]
SELECT * FROM `goods` WHERE `id` = 664 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000556s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 664 LIMIT 1 [ RunTime:0.000407s ]
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` = '54' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 5 [ RunTime:0.005965s ]
SELECT * FROM `goods` WHERE `id` IN (71,68,38,24,36) [ RunTime:0.000685s ]
SELECT * FROM `goods` WHERE `id` = 24 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000659s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 24 LIMIT 1 [ RunTime:0.000393s ]
SELECT * FROM `goods` WHERE `id` = 36 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 36 LIMIT 1 [ RunTime:0.000578s ]
SELECT * FROM `goods` WHERE `id` = 38 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000406s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 38 LIMIT 1 [ RunTime:0.000491s ]
SELECT * FROM `goods` WHERE `id` = 68 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000391s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 68 LIMIT 1 [ RunTime:0.000306s ]
SELECT * FROM `goods` WHERE `id` = 71 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000344s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 71 LIMIT 1 [ RunTime:0.000315s ]
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`.`ishot` = '2' ORDER BY `i`.`ord` ASC,`i`.`id` DESC LIMIT 10 [ RunTime:0.002860s ]
SELECT * FROM `goods` WHERE `id` IN (1831,19,20,1168,22) [ RunTime:0.000631s ]
SELECT * FROM `goods` WHERE `id` = 19 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000471s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 19 LIMIT 1 [ RunTime:0.000388s ]
SELECT * FROM `goods` WHERE `id` = 20 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000397s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 20 LIMIT 1 [ RunTime:0.000318s ]
SELECT * FROM `goods` WHERE `id` = 22 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000395s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 22 LIMIT 1 [ RunTime:0.000340s ]
SELECT * FROM `goods` WHERE `id` = 1168 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000415s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1168 LIMIT 1 [ RunTime:0.000359s ]
SELECT * FROM `goods` WHERE `id` = 1831 AND `isdelete` = 1 LIMIT 1 [ RunTime:0.000403s ]
SELECT * FROM `goods_sku_private` WHERE `goods_id` = 1831 LIMIT 1 [ RunTime:0.000326s ]
SHOW FULL COLUMNS FROM `news_info` [ RunTime:0.002007s ]
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.006167s ]
SHOW FULL COLUMNS FROM `user` [ RunTime:0.001946s ]
SELECT ID AS id,medianame AS NAME,weburl AS URL FROM `user` WHERE `ID` = 15820 LIMIT 1 [ RunTime:0.000396s ]
SHOW FULL COLUMNS FROM `theme` [ RunTime:0.000907s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'seo' [ RunTime:0.031750s ]
SELECT `value`,`key` FROM `theme` WHERE `userid` = 15820 AND `theme` = 'shop' [ RunTime:0.028713s ]
SELECT ID AS id,`title`,`content`,`data`,`propic` FROM `news_info` WHERE `userid` = 15820 AND `class_id` = 29 ORDER BY `ID` DESC [ RunTime:0.094193s ]
SELECT COUNT(*) AS think_count FROM `user` [ RunTime:0.010394s ]
SHOW FULL COLUMNS FROM `ruanwen_info` [ RunTime:0.001963s ]
SELECT COUNT(*) AS think_count FROM `ruanwen_info` [ RunTime:0.009585s ]
SHOW FULL COLUMNS FROM `media_info` [ RunTime:0.002087s ]
SELECT COUNT(*) AS think_count FROM `media_info` [ RunTime:0.001569s ]
SHOW FULL COLUMNS FROM `sms_send_list` [ RunTime:0.001180s ]
SELECT COUNT(*) AS think_count FROM `sms_send_list` [ RunTime:0.361863s ]
SELECT COUNT(*) AS think_count FROM `user` WHERE `flag` < 4 [ RunTime:0.049538s ]