Loading the data for the statistics pages involves the subquery SELECT MAX(date_collected) FROM statistics.statistic) to find out the latest day for which statistics are available, requiring a full scan of the rather large table for each page access. The day should instead be cached somewhere, or an index on date_collected be added. (The latter option seems like overkill unless the new index could be used by other queries, too.)