我想知道有没有办法加快查询速度，

SELECT
     SUM(quantity) as quantity
    ,productId
FROM krakoweats.orderproducts
GROUP BY productId
ORDER BY quantity DESC
LIMIT 3;

字符串
table是这样的

Columns:
orderId int(11) PK 
productId int(11) PK 
quantity int(11) 
unityPrice double 
createdAt datetime 
updatedAt datetime

型
我想获取前3名销售的产品。该表有大约11万条记录，运行时间约为9秒，是否有方法加快速度？我正在与mariadb合作。
编辑：
我有这样的索引

+---------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| Table         | Non_unique | Key_name                           | Seq_in_index | Column_name | Collation | Cardinality | Sub_part | Packed | Null | Index_type | Comment | Index_comment | Ignored |
+---------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+------------+---------+---------------+---------+
| orderproducts |          0 | order_products_order_id_product_id |            1 | orderId     | A         |       55747 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| orderproducts |          0 | order_products_order_id_product_id |            2 | productId   | A         |      579777 |     NULL | NULL   |      | BTREE      |         |               | NO      |
| orderproducts |          1 | order_products_product_id          |            1 | productId   | A         |       31254 |     NULL | NULL   |      | BTREE      |         |               | NO      |
+---------------+------------+------------------------------------+--------------+-------------+-----------+-------------+----------+--------+------+-------

型