解决mysql desc时导致查询太慢

mysql8.0倒叙索引：ALTER TABLE tableName ADD INDEX IDX_C1_DESC(AA DESC);

实测从20秒降到0.1秒

mysql5.6：mysql> set global optimizer_switch='index_condition_pushdown=off';