SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000369s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000199s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_label` [ RunTime:0.000256s ]
SELECT * FROM `idea_weapp_goods_label` WHERE `cat_id` = 67 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000147s ]
SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.000351s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000157s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 67 [ RunTime:0.000104s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 82 [ RunTime:0.000081s ]
SELECT COUNT(*) AS think_count FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`is_delete` = '0' AND `cat_id` IN (82,67) [ RunTime:0.000214s ]
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 (82,67) ORDER BY `initial_sales` DESC LIMIT 0,40 [ RunTime:0.000365s ]
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.000297s ]
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.000151s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 67 LIMIT 1 [ RunTime:0.000109s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_category` WHERE `parent_id` = 67 AND `is_show` = 1 [ RunTime:0.000100s ]
select * from idea_goods_category where is_show = 1 and parent_id = 67 order by is_top desc,sequence desc,id desc limit 0,10 [ RunTime:0.000123s ]
SHOW FULL COLUMNS FROM `idea_addons_statistics_code` [ RunTime:0.000266s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000126s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000100s ]