[步骤]

严重级别：一般
所属项目：亚马逊异步刊登任务详情
问题原因：慢SQL，缺少索引：（SELECT id,customer_id,task_id,source_id,sku,price,country,base_attributes,translate_base_attributes,browse_path_by_id,translate_guid,is_main_country,is_main_sku,err_msg,remark,create_name,create_by,create_time,update_by,update_time,is_deleted,real_product_type,is_parent,publish_queue_id FROM t_amazon_async_publish_task_detail WHERE (customer_id = 1 AND task_id IN (34517) AND is_deleted = 0);）

[结果]

解决方案：创建合适的索引，如：idx_task_id(task_id)

[期望]