Basically the problem of what's happening, is we have people making posts, threads, etc - but they are not coming up right away. There are moments when the slave is 20-30 seconds delayed from the master.
They said that query in question takes so long to go through that it's causing that delay...