SHOW FULL COLUMNS FROM `tb_goods_category` [ RunTime:0.007253s ]
SELECT * FROM `tb_goods_category` WHERE `level` IN (1,2) [ RunTime:0.008742s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 0 [ RunTime:0.022806s ]
SHOW FULL COLUMNS FROM `tb_goods` [ RunTime:0.013170s ]
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,1376632,1408427,1423547,1377862,1433833,1412718,1413982,1384489) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.019603s ]
SHOW FULL COLUMNS FROM `tb_comments` [ RunTime:0.012039s ]
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.006287s ]
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.004745s ]
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.001575s ]
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` = 1433833 [ RunTime:0.003969s ]
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.006206s ]
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.013224s ]
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.010778s ]
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.013005s ]
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.013543s ]
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.003762s ]
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.003787s ]
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.006783s ]
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` = 1423547 [ RunTime:0.012715s ]
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.003752s ]
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.006793s ]
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.009781s ]
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.004431s ]
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.003804s ]
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` = 1413982 [ RunTime:0.005825s ]
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.007803s ]
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.006772s ]
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` = 1412718 [ RunTime:0.007757s ]
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.009758s ]
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.009742s ]
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.009719s ]
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.008717s ]
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` = 1408427 [ RunTime:0.011766s ]
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.009078s ]
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.007536s ]
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.011068s ]
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.012858s ]
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.014496s ]
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` = 1384489 [ RunTime:0.012143s ]
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.010800s ]
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.009664s ]
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.011826s ]
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.013102s ]
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.008241s ]
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.013109s ]
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.006432s ]
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` = 1378699 [ RunTime:0.004050s ]
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` = 1377945 [ RunTime:0.005206s ]
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` = 1377862 [ RunTime:0.016326s ]
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` = 1376632 [ RunTime:0.006706s ]
SHOW FULL COLUMNS FROM `tb_hot_keywords` [ RunTime:0.010359s ]
SELECT * FROM `tb_hot_keywords` ORDER BY `search_count` DESC LIMIT 10 [ RunTime:0.006370s ]
SHOW FULL COLUMNS FROM `tb_article` [ RunTime:0.005803s ]
SELECT * FROM `tb_article` WHERE `category_id` = 12 ORDER BY `id` DESC [ RunTime:0.002228s ]
SELECT * FROM `tb_goods` WHERE `id` = 1418417 LIMIT 1 [ RunTime:0.002150s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10899 LIMIT 1 [ RunTime:0.002444s ]
SELECT * FROM `tb_goods_category` WHERE `id` IN (0,10890,10899) [ RunTime:0.002252s ]
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` = 1418417 [ RunTime:0.002344s ]
SHOW FULL COLUMNS FROM `tb_paymethod` [ RunTime:0.001728s ]
SELECT * FROM `tb_paymethod` [ RunTime:0.005902s ]
SHOW FULL COLUMNS FROM `tb_gallery` [ RunTime:0.002731s ]
SELECT * FROM `tb_gallery` WHERE `goods_id` = 1418417 ORDER BY `id` DESC [ RunTime:0.167154s ]
SELECT * FROM `tb_goods` ORDER BY `collect_count` DESC LIMIT 0,20 [ RunTime:0.149549s ]
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.010588s ]
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.012705s ]
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.010728s ]
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.010554s ]
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.010868s ]
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.010912s ]
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.011582s ]
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.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` = 1378304 [ RunTime:0.013792s ]
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.013424s ]
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.008001s ]
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.006795s ]
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.007719s ]
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.012807s ]
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.008738s ]
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.009772s ]
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.009810s ]
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.008280s ]
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.012199s ]
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.011778s ]
SHOW FULL COLUMNS FROM `tb_user_goods_history` [ RunTime:0.009139s ]
SELECT `user_id` FROM `tb_user_goods_history` WHERE `goods_id` = 1418417 [ RunTime:0.004540s ]
SELECT `goods_id` FROM `tb_user_goods_history` WHERE 0 = 1 ORDER BY `view_count` DESC LIMIT 20 [ RunTime:0.009814s ]
SELECT `id`,`goods_name`,`cover`,`price` FROM `tb_goods` WHERE 0 = 1 [ RunTime:0.004035s ]