I noticed a couple of queries in my slow query log. They have one thing in common:

SQL Query
AND p.POST_POSTED_TIME > '880798070' AND p.POST_POSTED_TIME < '1353751670'

This could be measurably improved by using BETWEEN:
SQL Query
AND p.POST_POSTED_TIME BETWEEN '880798070'AND '1353751670'


The Stovebolt Geek
https://www.stovebolt.com/ubbthreads/ubbthreads.php

Server Information
UBB.threads Version 8.0.0
Release 20240826
Server OS Linux
Server Load 0.11
Web Server Apache/2.4.37
PHP Version 8.3.11
MYSQL Version 8.0.39
Database Size 1.82 GB