The query is in the PhotoPlog memberlist.php file. It is hard to think that the query is examining over 2.57+ million rows. Run this query and it'll tell you how many rows are being examined:
Code:
Content visible to registered users only.
Please report back the full results of the above query.