“The standard warning against premature optimization applies here.”
Correctness first, then readability, then speed. Shrink the haystack before you look for the needle. Read the EXPLAIN plan instead of guessing. None of it is new, and most dashboards still ignore all three.