[步骤]
严重级别：一般所属项目：同步有品亚马逊销量到智能备货
问题原因：慢SQL问题，存在一次性查询数据过多，索引命中不合理（SELECT
s.purchase_date_beijing,
s.source_id,
s.msku,
s.quantity_ordered,
s.amazon_order_id,
d.asin,
d.parent_asin,
d.country_code,
d.sku,
d.customer_id
FROM
t_amazon_sales_6 s
JOIN t_amazon_sales_dim d ON s.source_id = d.source_id
AND s.msku = d.msku
WHERE
s.source_id = 16549
AND s.purchase_date_beijing >= '2025-05-28 13:02:34.125714'
AND s.purchase_date_beijing<='2025-06-27 13:02:34.125714';）
解决方案：SQL指定索引，增加分页查询，提供借鉴的优化SQL为：（
SELECT
s.purchase_date_beijing,
s.source_id,
s.msku,
s.quantity_ordered,
s.amazon_order_id,
d.asin,
d.parent_asin,
d.country_code,
d.sku,
d.customer_id
FROM
t_amazon_sales_6 s force index(idx_source_id_purchase_date_beijing_msku)
JOIN t_amazon_sales_dim d ON s.source_id = d.source_id
AND s.msku = d.msku
WHERE
s.source_id = 16549
AND s.purchase_date_beijing BETWEEN '2025-05-28 13:02:34.125714'
AND '2025-06-27 13:02:34.125714' order by s.id asc limit 500）
[结果]
[期望]