SHOW FULL COLUMNS FROM `idea_goods_category` [ RunTime:0.000849s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000407s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_label` [ RunTime:0.000972s ]
SELECT * FROM `idea_weapp_goods_label` WHERE `cat_id` = 68 AND `is_show` = 1 ORDER BY `sort` ASC [ RunTime:0.000563s ]
SHOW FULL COLUMNS FROM `idea_goods` [ RunTime:0.001014s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000401s ]
SELECT `id` FROM `idea_goods_category` WHERE `parent_id` = 68 [ RunTime:0.000289s ]
SELECT COUNT(*) AS think_count FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`stock` > '0' AND `g`.`is_delete` = '0' AND `cat_id` = 68 [ RunTime:0.000561s ]
SELECT `g`.*,CASE
WHEN (g.sales + g.initial_sales) / 10000 >= 1
THEN CONCAT(ROUND((g.sales + g.initial_sales) / 10000, 1), "万")
WHEN (g.sales + g.initial_sales) / 1000 >= 1
THEN CONCAT(ROUND((g.sales + g.initial_sales) / 1000, 1), "千")
ELSE CAST((g.sales + g.initial_sales) AS CHAR)
END as xiaoliang,CASE
WHEN g.hits / 10000 >= 1
THEN CONCAT(ROUND(g.hits/ 10000, 1), "万")
WHEN g.hits / 1000 >= 1
THEN CONCAT(ROUND(g.hits/ 1000, 1), "千")
ELSE CAST(g.hits AS CHAR)
END as renqi FROM `idea_goods` `g` WHERE `g`.`is_sale` = '1' AND `g`.`stock` > '0' AND `g`.`is_delete` = '0' AND `cat_id` = 68 ORDER BY `initial_sales` DESC LIMIT 0,40 [ RunTime:0.000906s ]
SHOW FULL COLUMNS FROM `idea_weapp_diyflag` [ RunTime:0.000589s ]
SELECT * FROM `idea_weapp_diyflag` WHERE `status` = 1 [ RunTime:0.000332s ]
SHOW FULL COLUMNS FROM `idea_weapp_goods_content` [ RunTime:0.000663s ]
SELECT * FROM `idea_weapp_goods_content` WHERE `goods_id` IN (171,170,35,153,172,34,36,37) [ RunTime:0.000444s ]
SHOW FULL COLUMNS FROM `idea_coupon_user` [ RunTime:0.000573s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000645s ]
SHOW FULL COLUMNS FROM `idea_coupon` [ RunTime:0.000619s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(171,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000461s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000701s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(170,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000578s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001001s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(35,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000564s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001032s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(153,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000560s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001025s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(172,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000557s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000916s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(34,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000551s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.000977s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(36,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000728s ]
SELECT * FROM `idea_coupon_user` WHERE `user_id` IS NULL ORDER BY `id` DESC [ RunTime:0.001110s ]
SELECT * FROM `idea_coupon` WHERE `type` = 2 AND ( `send_amount` > `get_amount` ) AND ( use_type = 0 or (use_type = 1 and FIND_IN_SET(37,goods_ids)) ) AND `e_date` >= 1793527506 ORDER BY `cut_price` DESC [ RunTime:0.000766s ]
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.000731s ]
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.000547s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 68 LIMIT 1 [ RunTime:0.000515s ]
SELECT * FROM `idea_goods_category` WHERE `id` = 70 LIMIT 1 [ RunTime:0.000415s ]
select * from idea_goods_category where is_show = 1 and parent_id = 70 order by is_top desc,sequence desc,id desc limit 0,10 [ RunTime:0.000551s ]
SHOW FULL COLUMNS FROM `idea_addons_statistics_code` [ RunTime:0.000971s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'body' [ RunTime:0.000521s ]
SELECT `code` FROM `idea_addons_statistics_code` WHERE `status` = 1 AND `position` = 'head' [ RunTime:0.000383s ]