it's a standard forum list query that is inefficient as all heck. showflat has the same problem with very LONG topics.. ( lots of posts )
you have a forum that has a HUGE number of topics in it and someone selected a page that is large. hence the starting LIMIT number.
you have 2 choices, really.
upgrade your hosting...
prune old topics.
