SHOW FULL COLUMNS FROM `tb_goods_category` [ RunTime:0.014848s ]
SELECT * FROM `tb_goods_category` WHERE `level` IN (1,2) [ RunTime:0.007396s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 0 [ RunTime:0.015594s ]
SHOW FULL COLUMNS FROM `tb_goods` [ RunTime:0.013177s ]
SELECT * FROM `tb_goods` WHERE ( `id` IN (1383957,1381787,1385400,1412706,1386394,1383385,1383481,1383303) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.015706s ]
SHOW FULL COLUMNS FROM `tb_comments` [ RunTime:0.018283s ]
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` = 1412706 [ RunTime:0.016753s ]
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` = 1386394 [ RunTime:0.005464s ]
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` = 1385400 [ RunTime:0.002150s ]
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` = 1383957 [ RunTime:0.006608s ]
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` = 1383481 [ RunTime:0.000961s ]
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` = 1383385 [ RunTime:0.000941s ]
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` = 1383303 [ RunTime:0.000764s ]
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` = 1381787 [ RunTime:0.000828s ]
SHOW FULL COLUMNS FROM `tb_hot_keywords` [ RunTime:0.001279s ]
SELECT * FROM `tb_hot_keywords` ORDER BY `search_count` DESC LIMIT 10 [ RunTime:0.001368s ]
SHOW FULL COLUMNS FROM `tb_article` [ RunTime:0.002838s ]
SELECT * FROM `tb_article` WHERE `category_id` = 12 ORDER BY `id` DESC [ RunTime:0.002784s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.000854s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.000501s ]
SELECT * FROM `tb_goods_category` WHERE `id` IN (0,10338,10341,10354) [ RunTime:0.005393s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 10354 [ RunTime:0.003969s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.007370s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10338,10341,10354%' ) [ RunTime:0.006365s ]
SELECT * FROM `tb_goods` WHERE ( `cate_id` IN (0,10354) ) ORDER BY `sell_count` DESC LIMIT 0,50 [ RunTime:0.185757s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10354 LIMIT 1 [ RunTime:0.007602s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10338,10341,10354%' ) [ RunTime:0.007402s ]
SELECT COUNT(*) AS think_count FROM `tb_goods` WHERE ( `cate_id` IN (0,10354) ) [ RunTime:0.134978s ]