如何在高负载下优化mysql查询的性能？

I'm a bit confused about how to optimize my SQL queries. I have a mid-complex query with some joins to run a hundred to thousand times per second (two tables on SSD, one table in RAM, 4 JOINs)I'm a bit confused about how to optimize my SQL