Untitled

Reading mysql slow query log from /var/log/mysql/mysql-slow.log

Count: 3  Time=29.41s (88s)  Lock=0.00s (0s)  Rows=795.3 (2386), rick[rick]@[192.168.180.68]

  SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)

 

Count: 10  Time=15.13s (151s)  Lock=0.00s (0s)  Rows=896.8 (8968), rick[rick]@[192.168.180.68]

  SELECT author_id, topic_id FROM posts WHERE  queued=N  AND author_id=N AND post_date > N AND topic_id IN(N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N,N)