需求 #17958
档口收藏-技术逻辑优化-慢请求
开始日期:
2020-06-10
计划完成日期:
% 完成:
0%
预期时间:
PRD时间:
移交时间:
提测时间:
承诺上线时间:
实际上线时间:
截稿时间:
开发时间:
联调时间:
需求方:
技术
风险评估:
未知
优先级:
10
开发优先级:
后端开发:
跨组后端开发:
CodeReview:
前端开发:
IOS开发:
安卓开发:
测试:
UI:
数据组:
批次(PMO):
数据组完成时间:
描述
接口：
api/users/get_supplier_follow_list
SELECT sf.supply_id, max(gle.first_sale_period) as first_sale_period FROM `fmys_supply_follow` `sf` INNER JOIN `fmys_goods_lib` `gl` ON `sf`.`supply_id`=`gl`.`supply_id` INNER JOIN `fmys_goods_lib_ext` `gle` ON `gle`.`goods_no`=`gl`.`goods_no` WHERE `user_id` = 332815 GROUP BY `sf`.`supply_id` [ RunTime:0.051470s ]
SELECT `gl`.`supply_id`,count(*) as today_update_count FROM `fmys_goods_lib` `gl` INNER JOIN `fmys_goods_lib_ext` `gle` ON `gl`.`goods_no`=`gle`.`goods_no` WHERE `gl`.`supply_id` IN ('7962','14344','2431','14029','7368','13565','16353','11393','10254','5651') AND `gle`.`first_sale_period` = '1475' GROUP BY `gl`.`supply_id` [ RunTime:0.034294s ]
由 
