Sargable Queries & MUL Indexes; or Why My Query is Slow

You're on Ops. Debugging Error-s in Invoicing Rails app, as usual. They're stored in MySQL, and accessed through ActiveRecord and some helper methods. They've already been updated with a status_message, so now it's time to dig in and investigate...