Indexe & EXPLAIN

So findest du langsame Abfragen und verbessern die Performance.

EXPLAIN analysieren

EXPLAIN SELECT *
FROM orders
WHERE user_id = 42
ORDER BY created_at DESC
LIMIT 20;