NeedExpertHelp - 3:41 pm on Mar 20, 2011 (gmt 0)

It is tough for me to try the query after an insert because the site is quite active, with inserts and queries on those tables happening continuously. But what would that possibly reveal?

What I still don't get is that even within the MySQL Slow Log, the query time is well below 1 second and yet all the columns are indexed, so I don't understand why MySQL considers it "slow".