What is the query trying to do?
The query is fetching all the record frm 3 tables using inner join and I am using pagination displaying it.
I tried adding Indexes in all the column that im searching or connecting with and it improves that over all performance of the system. I am on the observation part now. hope that it fix the problem permanently.
I'll close this thread later on when i validated that the solution is effective.