order by

-- 不走索引
idx_ (a, b, c)
order by a, b desc, c;

-- 走索引
idx_ (a, b desc, c)
order by a, b desc, c;

-- 走索引
idx_ (a desc, b, c desc)
order by a, b desc, c;