SHOW FULL COLUMNS FROM `tb_goods_category` [ RunTime:0.024373s ]
SELECT * FROM `tb_goods_category` WHERE `level` IN (1,2) [ RunTime:0.001085s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 0 [ RunTime:0.001712s ]
SHOW FULL COLUMNS FROM `tb_goods` [ RunTime:0.000721s ]
SELECT * FROM `tb_goods` WHERE ( `id` IN (1393025,1393107,1409027) ) ORDER BY `id` DESC LIMIT 0,50 [ RunTime:0.000524s ]
SHOW FULL COLUMNS FROM `tb_comments` [ RunTime:0.000362s ]
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` = 1409027 [ RunTime:0.000448s ]
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` = 1393107 [ RunTime:0.000218s ]
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` = 1393025 [ RunTime:0.000269s ]
SHOW FULL COLUMNS FROM `tb_hot_keywords` [ RunTime:0.000339s ]
SELECT * FROM `tb_hot_keywords` ORDER BY `search_count` DESC LIMIT 10 [ RunTime:0.000210s ]
SHOW FULL COLUMNS FROM `tb_article` [ RunTime:0.000332s ]
SELECT * FROM `tb_article` WHERE `category_id` = 12 ORDER BY `id` DESC [ RunTime:0.000984s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10369 LIMIT 1 [ RunTime:0.000208s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10369 LIMIT 1 [ RunTime:0.000183s ]
SELECT * FROM `tb_goods_category` WHERE `id` IN (0,10369) [ RunTime:0.000245s ]
SELECT * FROM `tb_goods_category` WHERE `fid` = 10369 [ RunTime:0.000411s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10369 LIMIT 1 [ RunTime:0.000240s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10369%' ) [ RunTime:0.000290s ]
SELECT * FROM `tb_goods` WHERE ( `cate_id` IN (10370,10371,10372,10373,10374,10375,10376,10377,10378,10379,10380,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10396,10399,10400,10369) ) ORDER BY `sell_count` DESC LIMIT 0,50 [ RunTime:0.019252s ]
SELECT * FROM `tb_goods_category` WHERE `id` = 10369 LIMIT 1 [ RunTime:0.000383s ]
SELECT `id` FROM `tb_goods_category` WHERE ( `cate_map` LIKE '0,10369%' ) [ RunTime:0.000428s ]
SELECT COUNT(*) AS think_count FROM `tb_goods` WHERE ( `cate_id` IN (10370,10371,10372,10373,10374,10375,10376,10377,10378,10379,10380,10381,10382,10383,10384,10385,10386,10387,10388,10389,10390,10391,10392,10393,10394,10395,10396,10399,10400,10369) ) [ RunTime:0.016335s ]