Act as a senior database administrator. I have a SQL query joining five tables that is running slowly. Outline a step-by-step diagnostic strategy to identify the bottleneck. List specific commands or methods (like EXPLAIN) to use and common optimizations to check for, such as indexing or join order.