Yes we do have a slow query log, but all it contains are the main thread list queries by the looks of it.
Like:
sql code:
SELECT THREAD.TID, THREAD.FID, THREAD.TITLE, THREAD.LENGTH, THREAD.POLL_FLAG, THREAD.STICKY, THREAD.VIEWCOUNT, USER_THREAD.LAST_READ, USER_THREAD.INTEREST, USER_FOLDER.INTEREST AS FOLDER_INTEREST, UNIX_TIMESTAMP(THREAD.MODIFIED) AS MODIFIED, USER.LOGON, USER.NICKNAME, USER_PEER.PEER_NICKNAME, USER_PEER.RELATIONSHIP FROM DEFAULT_THREAD THREAD LEFT JOIN DEFAULT_USER_THREAD USER_THREAD ON (USER_THREAD.TID = THREAD.TID AND USER_THREAD.UID = 21) LEFT JOIN DEFAULT_USER_FOLDER USER_FOLDER ON (USER_FOLDER.FID = THREAD.FID AND USER_FOLDER.UID = 21) LEFT JOIN USER USER ON (USER.UID = THREAD.BY_UID) LEFT JOIN DEFAULT_USER_PEER USER_PEER ON (USER_PEER.UID = 21 AND USER_PEER.PEER_UID = THREAD.BY_UID) WHERE THREAD.FID IN (1,2,3,4,5,6,7,8,9,11,12,13,14,16,20,22,23,24) AND ((USER_PEER.RELATIONSHIP & 8) = 0 OR USER_PEER.RELATIONSHIP IS NULL) AND ((USER_PEER.RELATIONSHIP & 2) = 0 OR USER_PEER.RELATIONSHIP IS NULL OR THREAD.LENGTH > 1) AND (USER_THREAD.INTEREST IS NULL OR USER_THREAD.INTEREST > -1) AND (USER_FOLDER.INTEREST IS NULL OR USER_FOLDER.INTEREST > -1) AND THREAD.LENGTH > 0 ORDER BY THREAD.STICKY DESC, THREAD.MODIFIED DESC LIMIT 0, 50;
Um. CVS problems. That looks right. It's the same as mine, except the username. What error message are you getting, assuming you're getting one?