SHOW FULL COLUMNS FROM `tb_goods_category` [ RunTime:0.011440s ]
SELECT * FROM `tb_goods_category` WHERE `level` IN (1,2) [ RunTime:0.005899s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 0 [ RunTime:0.003439s ]
SHOW FULL COLUMNS FROM `tb_goods` [ RunTime:0.009650s ]
SELECT * FROM `tb_goods` WHERE ( `id` IN (1418367,1434154,1412734,1423736,1405670,1428247,1380468,1392332,1426295,1434702,1410860,1378699,1390479,1395235,1436125,1411969,1433085,1418569,1420016,1379816,1380741,1423724,1414639,1380481,1380405,1381586,1408444,1425855,1425831,1423797,1377945,1406258,1409067,1420067,1413735,1380525,1388011,1417858,1409070,1433799,1436250,1420025,1382624,1381526,1408441,1380665,1406372,1418543,1408047,1436152,1415414,1416852) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.019615s ]
SHOW FULL COLUMNS FROM `tb_comments` [ RunTime:0.011106s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1436250 [ RunTime:0.012866s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1436152 [ RunTime:0.011801s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1436125 [ RunTime:0.011786s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1434702 [ RunTime:0.011846s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1434154 [ RunTime:0.009856s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1433799 [ RunTime:0.012833s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1433085 [ RunTime:0.009473s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1428247 [ RunTime:0.015786s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1426295 [ RunTime:0.009038s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1425855 [ RunTime:0.009455s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1425831 [ RunTime:0.008668s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1423797 [ RunTime:0.012775s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1423736 [ RunTime:0.008731s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1423724 [ RunTime:0.006089s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1420067 [ RunTime:0.000727s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1420025 [ RunTime:0.000542s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1420016 [ RunTime:0.000866s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1418569 [ RunTime:0.000926s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1418543 [ RunTime:0.000914s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1418367 [ RunTime:0.001281s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1417858 [ RunTime:0.000786s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1416852 [ RunTime:0.001038s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1415414 [ RunTime:0.007635s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1414639 [ RunTime:0.007286s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1413735 [ RunTime:0.005365s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1412734 [ RunTime:0.010614s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1411969 [ RunTime:0.010994s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1410860 [ RunTime:0.010647s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1409070 [ RunTime:0.012065s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1409067 [ RunTime:0.011447s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1408444 [ RunTime:0.011780s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1408441 [ RunTime:0.011956s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1408047 [ RunTime:0.013499s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1406372 [ RunTime:0.009757s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1406258 [ RunTime:0.010726s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1405670 [ RunTime:0.011723s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1395235 [ RunTime:0.011734s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1392332 [ RunTime:0.008079s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1390479 [ RunTime:0.003393s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1388011 [ RunTime:0.014773s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1382624 [ RunTime:0.006657s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1381586 [ RunTime:0.007793s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1381526 [ RunTime:0.009767s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380741 [ RunTime:0.005006s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380665 [ RunTime:0.000718s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380525 [ RunTime:0.000677s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380481 [ RunTime:0.000695s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380468 [ RunTime:0.000611s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380405 [ RunTime:0.000570s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1379816 [ RunTime:0.000281s ]
SHOW FULL COLUMNS FROM `tb_hot_keywords` [ RunTime:0.001016s ]
SELECT * FROM `tb_hot_keywords` ORDER BY `search_count` DESC LIMIT 10 [ RunTime:0.000293s ]
SHOW FULL COLUMNS FROM `tb_article` [ RunTime:0.000419s ]
SELECT * FROM `tb_article` WHERE `category_id` = 12 ORDER BY `id` DESC [ RunTime:0.000906s ]
SELECT * FROM `tb_goods` WHERE `id` = 1411946 LIMIT 1 [ RunTime:0.006954s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10768 LIMIT 1 [ RunTime:0.000655s ]
SELECT * FROM `tb_goods_category` WHERE `id` IN (0,10766,10768) [ RunTime:0.006796s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1411946 [ RunTime:0.000964s ]
SHOW FULL COLUMNS FROM `tb_paymethod` [ RunTime:0.000945s ]
SELECT * FROM `tb_paymethod` [ RunTime:0.000349s ]
SHOW FULL COLUMNS FROM `tb_gallery` [ RunTime:0.000568s ]
SELECT * FROM `tb_gallery` WHERE `goods_id` = 1411946 ORDER BY `id` DESC [ RunTime:0.125978s ]
SELECT * FROM `tb_goods` ORDER BY `collect_count` DESC LIMIT 0,20 [ RunTime:0.043786s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1376256 [ RunTime:0.001582s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1376512 [ RunTime:0.000285s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1376768 [ RunTime:0.000275s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1377024 [ RunTime:0.000248s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1377280 [ RunTime:0.000216s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1377536 [ RunTime:0.000258s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1377792 [ RunTime:0.000232s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1378048 [ RunTime:0.000239s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1378304 [ RunTime:0.000190s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1378560 [ RunTime:0.000254s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1378816 [ RunTime:0.000286s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1379072 [ RunTime:0.000188s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1379328 [ RunTime:0.000234s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1379584 [ RunTime:0.003234s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1379840 [ RunTime:0.000831s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380096 [ RunTime:0.000963s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380352 [ RunTime:0.002637s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380608 [ RunTime:0.004392s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1380864 [ RunTime:0.000485s ]
SELECT `tb_comments`.*,`tb_customer`.`nick_name` FROM `tb_comments` INNER JOIN `tb_customer` ON `tb_customer`.`id`=`tb_comments`.`user_id` WHERE `goods_id` = 1381120 [ RunTime:0.001903s ]
SHOW FULL COLUMNS FROM `tb_user_goods_history` [ RunTime:0.001986s ]
SELECT `user_id` FROM `tb_user_goods_history` WHERE `goods_id` = 1411946 [ RunTime:0.002592s ]
SELECT `goods_id` FROM `tb_user_goods_history` WHERE 0 = 1 ORDER BY `view_count` DESC LIMIT 20 [ RunTime:0.004852s ]
SELECT `id`,`goods_name`,`cover`,`price` FROM `tb_goods` WHERE 0 = 1 [ RunTime:0.002915s ]