And you expect us to GUESS what your MySQL tables look like? What indexes your are using? What your SQL query looks like?
I'm afraid my crystal ball is not working that well.
An optimist sees the glass as half full.
A pessimist sees the glass as half empty.
A realist drinks it no matter how much there is.