某商品表products存在联合索引idx_category_price_sales(category, price, sales)，表结构为(id INT PRIMARY KEY, category INT, price DECIMAL, sales INT, name VARCHAR(100))。执行查询SELECT name FROM products WHERE category = 5 AND price > 1000 ORDER BY sales;时，MySQL 优化器选择的执行计划最可能为（）
1000 ORDER BY sales;时，MySQL 优化器选择的执行计划最可能为"},"attribs":{"0":"*0+4*0*1*2+8*0+6*0*1*2+1c*0+5*0*1*2+27*0+5*0*1*2+25*0+m"}},"apool":{"numToAttrib":{"0":["author","7418401374654660611"],"1":["inlineCode","true"],"2":["textHighlightBackground","rgb(242,243,245)"]},"nextNum":3}},"type":"text","referenceRecordMap":{},"extra":{"channel":"saas","isEqualBlockSelection":false,"pasteRandomId":"53f6eff2-1a55-48a9-8c6b-44ef4bba02b1","mention_page_title":{},"external_mention_url":{}},"isKeepQuoteContainer":false,"isFromCode":false,"selection":[{"id":87,"type":"text","selection":{"start":0,"end":254},"recordId":"MEZidQuZNoAqZrxvww3cbqEnnOf"}],"payloadMap":{},"isCut":false}" data-lark-record-format="docx/text" class="lark-record-clipboard">
A利用联合索引idx_category_price_sales完成category=5和price>1000的过滤，且ORDER BY sales可依赖索引有序性（无Using filesort）
B利用联合索引idx_category_price_sales完成category=5的过滤，price>1000和ORDER BY sales需在内存中处理（含Using filesort）
C仅利用联合索引idx_category_price_sales中的category字段过滤，price>1000和ORDER BY sales均需全表扫描后处理
D放弃使用联合索引，直接全表扫描并筛选符合条件的记录