需求 #17957
今日特卖-结果查询优化
0%
描述
接口：
/activity/get_today_sales_tab
分析：
SELECT COUNT(*) AS tp_count FROM ( SELECT DISTINCT `g`.`goods_no` FROM `fmys_goods` `g` INNER JOIN `fmys_goods_lib` `gl` ON `gl`.`goods_no`=`g`.`goods_no` INNER JOIN `fmys_goods_id` `gi` ON `gi`.`goods_id`=`g`.`goods_id` LEFT JOIN `fmys_goods_in_stock` `gis` ON `gis`.`goods_id`=`g`.`goods_id` LEFT JOIN `fmys_brand_discount_goods` `bdg` ON `bdg`.`goods_no`=`gl`.`goods_no` LEFT JOIN `fmys_dtl_user_prefer_brand` `dupb` ON `dupb`.`cat_id`=bdg.cat_id AND dupb.brand_id = bdg.brand_id AND dupb.user_id = 332815 WHERE ( `g`.`goods_name` like '%原价%' OR gis.goods_id is not null ) AND `g`.`is_on_sale` = '1' AND `g`.`special_status` = '2' AND `gl`.`cat_id` IN ('324') AND `g`.`shop_price` <= '999.00' GROUP BY `g`.`goods_no` ) `tmp` [ RunTime:0.215977s ]
使用SQL关联查询缓慢，可以考虑将数据缓存成数据表，只需要近15期内的商品作为常用搜索关联表
由 
