SELECT id,source_id,asin,msku
FROM t_amazon_listing_20
WHERE is_deleted=0 AND (source_id = 5267 AND customer_id = 1 AND publish_time >= '2024-04-09 04:00:01' AND status = 1 AND is_deleted = 0) ORDER BY publish_time DESC LIMIT 1000;

优化建议：

增加索引，add index idx_sourceid_status_isdeleted_customerid_publishtime(source_id,status,is_deleted,customer_id,publish_time)