Read about https://www.linkedin.com/pulse/why-backward-index-scans-slower-innodb-jinyou-ma-5mooc/?trackingId=11eOap0agc5vIfyHqro%2F8w%3D%3D