SHOW FULL COLUMNS FROM `tb_goods_category` [ RunTime:0.013895s ]
SELECT * FROM `tb_goods_category` WHERE `level` IN (1,2) [ RunTime:0.010301s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 0 [ RunTime:0.020395s ]
SHOW FULL COLUMNS FROM `tb_goods` [ RunTime:0.015320s ]
SELECT * FROM `tb_goods` WHERE ( `id` IN (1417993,1435507,1422242,1381977,1391558,1391075,1414155,1386889,1422185) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.003538s ]
SHOW FULL COLUMNS FROM `tb_comments` [ RunTime:0.007475s ]
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` = 1435507 [ RunTime:0.014807s ]
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` = 1422242 [ RunTime:0.012789s ]
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` = 1422185 [ RunTime:0.007278s ]
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` = 1417993 [ RunTime:0.001898s ]
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` = 1414155 [ RunTime:0.000512s ]
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` = 1391558 [ RunTime:0.001075s ]
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` = 1391075 [ RunTime:0.000871s ]
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` = 1386889 [ RunTime:0.001891s ]
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` = 1381977 [ RunTime:0.000856s ]
SHOW FULL COLUMNS FROM `tb_hot_keywords` [ RunTime:0.001056s ]
SELECT * FROM `tb_hot_keywords` ORDER BY `search_count` DESC LIMIT 10 [ RunTime:0.000799s ]
SHOW FULL COLUMNS FROM `tb_article` [ RunTime:0.007273s ]
SELECT * FROM `tb_article` WHERE `category_id` = 12 ORDER BY `id` DESC [ RunTime:0.003711s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10642 LIMIT 1 [ RunTime:0.004287s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10642 LIMIT 1 [ RunTime:0.004067s ]
SELECT * FROM `tb_goods_category` WHERE `id` IN (0,10641,10642) [ RunTime:0.002503s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 10642 [ RunTime:0.001465s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10642 LIMIT 1 [ RunTime:0.004535s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10641,10642%' ) [ RunTime:0.003982s ]
SELECT * FROM `tb_goods` WHERE ( `cate_id` IN (10643,10791,10792,10793,10794,10795,10796,10797,10798,10799,10802,10803,10805,10806,10807,10811,10812,10813,10814,10815,10816,10823,10824,10827,10828,10830,10833,10834,10836,10837,10839,10844,10845,10846,10848,10852,10853,10858,10859,10860,10862,10864,10865,10868,10869,10870,10871,10872,10873,10876,10877,10880,10881,10882,10883,10884,10885,10886,10887,10888,10642) ) ORDER BY `sell_count` DESC LIMIT 0,50 [ RunTime:0.041739s ]
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` = 1416192 [ RunTime:0.001199s ]
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` = 1416448 [ RunTime:0.000237s ]
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` = 1416704 [ RunTime:0.000204s ]
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` = 1417216 [ RunTime:0.000205s ]
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` = 1417472 [ RunTime:0.000243s ]
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` = 1416193 [ RunTime:0.000195s ]
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` = 1416705 [ RunTime:0.003105s ]
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` = 1417217 [ RunTime:0.002933s ]
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` = 1417473 [ 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` = 1416194 [ RunTime:0.003751s ]
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` = 1416450 [ RunTime:0.001992s ]
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` = 1417218 [ RunTime:0.002725s ]
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` = 1417474 [ RunTime:0.000231s ]
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` = 1416195 [ RunTime:0.003959s ]
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` = 1416451 [ RunTime:0.001435s ]
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` = 1417219 [ RunTime:0.001602s ]
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` = 1417475 [ RunTime:0.001351s ]
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` = 1416196 [ RunTime:0.002697s ]
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` = 1416452 [ RunTime:0.004837s ]
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` = 1417220 [ RunTime:0.003738s ]
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` = 1417476 [ RunTime:0.001086s ]
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` = 1416197 [ RunTime:0.000859s ]
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` = 1416453 [ RunTime:0.005722s ]
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` = 1417221 [ RunTime:0.001008s ]
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` = 1417477 [ RunTime:0.001821s ]
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` = 1416198 [ RunTime:0.000562s ]
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` = 1416454 [ RunTime:0.006259s ]
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` = 1417222 [ RunTime:0.003671s ]
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` = 1417478 [ RunTime:0.002007s ]
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` = 1416199 [ RunTime:0.000863s ]
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` = 1416455 [ RunTime:0.003716s ]
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` = 1416711 [ RunTime:0.003003s ]
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` = 1417223 [ RunTime:0.000640s ]
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` = 1417479 [ RunTime:0.002964s ]
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` = 1416200 [ RunTime:0.002950s ]
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` = 1416456 [ RunTime:0.002925s ]
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` = 1417224 [ RunTime:0.001706s ]
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` = 1417480 [ RunTime:0.001299s ]
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` = 1416457 [ RunTime:0.002154s ]
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` = 1417225 [ RunTime:0.002191s ]
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` = 1417481 [ RunTime:0.002006s ]
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` = 1416202 [ RunTime:0.003227s ]
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` = 1416458 [ RunTime:0.000411s ]
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` = 1417226 [ RunTime:0.002572s ]
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` = 1417482 [ RunTime:0.004858s ]
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` = 1416203 [ RunTime:0.001658s ]
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` = 1416459 [ RunTime:0.001605s ]
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` = 1417227 [ RunTime:0.009923s ]
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` = 1417483 [ RunTime:0.014650s ]
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` = 1416204 [ RunTime:0.009205s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10642 LIMIT 1 [ RunTime:0.006502s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10641,10642%' ) [ RunTime:0.005090s ]
SELECT COUNT(*) AS think_count FROM `tb_goods` WHERE ( `cate_id` IN (10643,10791,10792,10793,10794,10795,10796,10797,10798,10799,10802,10803,10805,10806,10807,10811,10812,10813,10814,10815,10816,10823,10824,10827,10828,10830,10833,10834,10836,10837,10839,10844,10845,10846,10848,10852,10853,10858,10859,10860,10862,10864,10865,10868,10869,10870,10871,10872,10873,10876,10877,10880,10881,10882,10883,10884,10885,10886,10887,10888,10642) ) [ RunTime:0.035042s ]
SELECT * FROM `tb_goods` WHERE ( `cate_id` IN (10643,10791,10792,10793,10794,10795,10796,10797,10798,10799,10802,10803,10805,10806,10807,10811,10812,10813,10814,10815,10816,10823,10824,10827,10828,10830,10833,10834,10836,10837,10839,10844,10845,10846,10848,10852,10853,10858,10859,10860,10862,10864,10865,10868,10869,10870,10871,10872,10873,10876,10877,10880,10881,10882,10883,10884,10885,10886,10887,10888,10642) ) ORDER BY `id` DESC LIMIT 1140,60 [ RunTime:0.198636s ]
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` = 1416122 [ RunTime:0.003041s ]
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` = 1416121 [ RunTime:0.000931s ]
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` = 1416119 [ RunTime:0.003198s ]
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` = 1416118 [ RunTime:0.004493s ]
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` = 1416117 [ RunTime:0.000782s ]
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` = 1416116 [ RunTime:0.002398s ]
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` = 1416115 [ RunTime:0.001637s ]
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` = 1416114 [ RunTime:0.001673s ]
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` = 1416113 [ RunTime:0.002549s ]
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` = 1416112 [ RunTime:0.009524s ]
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` = 1416111 [ RunTime:0.007597s ]
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` = 1391355 [ RunTime:0.004090s ]
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` = 1391354 [ RunTime:0.009551s ]