SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000416s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 72 LIMIT 1 [ RunTime:0.000200s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_label` [ RunTime:0.000251s ]
SELECT * FROM `idea_weapp_goods_label` WHERE `cat_id` = 72 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000147s ]
SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.000372s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 72 LIMIT 1 [ RunTime:0.000176s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 72 [ RunTime:0.000100s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 73 [ RunTime:0.000087s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 76 [ RunTime:0.000064s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 77 [ RunTime:0.000057s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 78 [ RunTime:0.000055s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 79 [ RunTime:0.000054s ]
SELECT COUNT(*) AS think_count FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`is_delete` = '0' AND `cat_id` IN (73,76,77,78,79,72) [ RunTime:0.000239s ]
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 (73,76,77,78,79,72) ORDER BY `initial_sales` DESC LIMIT 0,40 [ RunTime:0.000382s ]
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.000282s ]
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.000135s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 72 LIMIT 1 [ RunTime:0.000105s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_category` WHERE `parent_id` = 72 AND `is_show` = 1 [ RunTime:0.000094s ]
select * from idea_goods_category where is_show = 1 and parent_id = 72 order by is_top desc,sequence desc,id desc limit 0,10 [ RunTime:0.000108s ]
SHOW FULL COLUMNS FROM `idea_addons_statistics_code` [ RunTime:0.000262s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000174s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000099s ]