反馈人:缪金荣

select distinct q.id, q.publish_strategy_id, q.policy_id, q.strategy_name, q.template_name, q.sku_source, q.status, q.end_time, q.create_name, q.create_by, q.create_time from t_shopee_publish_queue q
left join t_shopee_publish_queue_detail d on d.queue_id = q.id and d.is_deleted = 0
WHERE q.is_deleted = 0
order by q.create_time desc LIMIT 20
优化建议:条件中增加source_id、create_time(时间段控制为1天),跑批任务可以轮询每个source_id处理