XenForo developer

There are likely older queries there that are the ones that are fundamentally executing, but everything you're showing likely just points to the server being totally overloaded/starved for resources. When you have a busy forum and there's a massive load spike, it's likely to just compound and get worse unless/until you interrupt it (such as disabling access to the server for your users).