Why is this MySQL query performing slowly despite correct indexing?
127553
Why is this MySQL SELECT performing so slowly despite indexing?
128134
MySQL 'Order By' - sorting alphanumeric correctly
149623
How to improve the performance of this select query?
28866
How does MySQL process ORDER BY and LIMIT in a query?
148559
Using the correct, or preferable, not equal operator in MySQL
106227
Using column alias in WHERE clause of MySQL query produces an error
156801
Query is returning a single concatenated string of values THEN the rows it found
15357
How do I speed up counting rows in a PostgreSQL table?
8210
MySQL not using indexes with WHERE IN clause?
99497
IF EXISTS taking longer than embedded select statement
112338
Why is PostgreSQL 9.5 not using my newest index for ORDER BY, even though it uses similar indices just fine?
103235
When a previously-fast SQL query starts running slow, where do I look to find the source of the issue?
138361
What's faster, SELECT DISTINCT or GROUP BY in MySQL?
149918
MySQL trigger/procedure execution delay
57678
ORDER BY not behaving as expected
62300
Mysql count instances of substring, then order by
29844
mysql_query doesn't work but db_query does on a simple SELECT query