SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000414s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000211s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_label` [ RunTime:0.000248s ]
SELECT * FROM `idea_weapp_goods_label` WHERE `cat_id` = 69 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000148s ]
SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.000374s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000170s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 69 [ RunTime:0.000097s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 66 [ RunTime:0.000070s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 71 [ RunTime:0.000059s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 74 [ RunTime:0.000056s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 80 [ RunTime:0.000056s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 81 [ 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 (66,71,74,80,81,69) [ RunTime:0.000252s ]
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 (66,71,74,80,81,69) ORDER BY `initial_sales` DESC LIMIT 0,40 [ RunTime:0.000391s ]
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.000284s ]
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.000128s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 69 LIMIT 1 [ RunTime:0.000115s ]
SELECT COUNT(*) AS think_count FROM `idea_goods_category` WHERE `parent_id` = 69 AND `is_show` = 1 [ RunTime:0.000101s ]
select * from idea_goods_category where is_show = 1 and parent_id = 69 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.000254s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000120s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000081s ]