SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000433s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_label` [ RunTime:0.000246s ]
SELECT * FROM `idea_weapp_goods_label` WHERE `cat_id` = 83 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000157s ]
SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.000371s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000158s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 83 [ RunTime:0.000098s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 84 [ RunTime:0.000073s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 85 [ RunTime:0.000063s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 86 [ RunTime:0.000058s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 87 [ RunTime:0.000069s ]
SELECT COUNT(*) AS think_count FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`is_delete` = '0' AND `cat_id` IN (84,85,86,87,83) [ RunTime:0.000233s ]
SELECT id,title,price,market_price,pic,litpic,sales,initial_sales,hits,
CASE
WHEN (sales + initial_sales) / 10000 >= 1
THEN CONCAT(ROUND((sales + initial_sales) / 10000, 1), "万")
WHEN (sales + initial_sales) / 1000 >= 1
THEN CONCAT(ROUND((sales + initial_sales) / 1000, 1), "千")
ELSE CAST((sales + initial_sales) AS CHAR)
END as xiaoliang,
CASE
WHEN hits / 10000 >= 1
THEN CONCAT(ROUND(hits/ 10000, 1), "万")
WHEN hits / 1000 >= 1
THEN CONCAT(ROUND(hits/ 1000, 1), "千")
ELSE CAST(hits AS CHAR)
END as renqi FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`is_delete` = '0' AND `cat_id` IN (84,85,86,87,83) ORDER BY `initial_sales` DESC LIMIT 0,40 [ RunTime:0.000346s ]
select * from idea_goods_category where is_show = 1 and parent_id = 0 order by is_top desc,sequence desc,id desc limit 0,6 [ RunTime:0.000247s ]
select * from idea_goods_category where is_show = 1 and is_top = 1 and parent_id != 0 order by sequence desc limit 0,2 [ RunTime:0.000138s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 83 LIMIT 1 [ RunTime:0.000118s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_category` WHERE `parent_id` = 83 AND `is_show` = 1 [ RunTime:0.000101s ]
select * from idea_goods_category where is_show = 1 and parent_id = 83 order by is_top desc,sequence desc,id desc limit 0,10 [ RunTime:0.000107s ]
SHOW FULL COLUMNS FROM `idea_addons_statistics_code` [ RunTime:0.000282s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000139s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000082s ]