如何提高多个内连接的查询性能？

I have a query which is taking 1 minute to execute. After spending some time on the query I found there is some part that is actually causing the query to take the time. Please see my comments below for the query mentioned.I have a query which is taking 1 minute to exec