spotweb: Spotweb overview page is slow to load after reinstall

I can’t figure out why my spotweb index overview is so slow to load while this used to be really fast. Somehow after a new install of Spotweb with a fresh DB it is slow.

Specs:
Windows 2012R2
IIS 8.5
PHP 5.6.16
MySQL 5.6.28

Spotweb Master: ef965705cb21e520c67cc04270b698ced0ab350a

Total Spotweb Database size is 3 GB

Running on:

OS Name Microsoft Windows Server 2012 R2 Standard
Version 6.3.9600 Build 9600
System Model    Virtual Machine
System Type x64-based PC
Processor   Intel(R) Xeon(R) CPU E5-2660 v3 @ 2.60GHz, 2600 Mhz, 4 Core(s), 4 Logical Processor(s)
Installed Physical Memory (RAM) 16,0 GB
Total Physical Memory   16,0 GB

Because it is virtual, additional memory or CPU’s are no problem if more are needed.

It appears the big hangup is the slow select statement which takes around 30 seconds.

# Time: 151229 13:38:58
# User@Host: root[root] @ localhost [::1]  Id:    38
# Query_time: 32.684651  Lock_time: 0.000000 Rows_sent: 26  Rows_examined: 6463381
SET timestamp=1451392738;
SELECT s.id AS id,
                                                s.messageid AS messageid,
                                                s.category AS category,
                                                s.poster AS poster,
                                                l.download as downloadstamp, 
                                                l.watch as watchstamp,
                                                l.seen AS seenstamp,
                                                s.subcata AS subcata,
                                                s.subcatb AS subcatb,
                                                s.subcatc AS subcatc,
                                                s.subcatd AS subcatd,
                                                s.subcatz AS subcatz,
                                                s.title AS title,
                                                s.tag AS tag,
                                                s.stamp AS stamp,
                                                s.moderated AS moderated,
                                                s.filesize AS filesize,
                                                s.spotrating AS rating,
                                                s.commentcount AS commentcount,
                                                s.reportcount AS reportcount,
                                                s.spotterid AS spotterid,
                                                s.editstamp AS editstamp,
                                                s.editor AS editor,
                                                f.verified AS verified,
                                                COALESCE(bl.idtype, wl.idtype, gwl.idtype) AS idtype

                                     FROM spots AS s  LEFT JOIN spotstatelist AS l on ((s.messageid = l.messageid) AND (l.ouruserid = 3)) 
                                     LEFT JOIN spotsfull AS f ON (s.messageid = f.messageid) 
                                     LEFT JOIN spotteridblacklist as bl ON ((bl.spotterid = s.spotterid) AND ((bl.ouruserid = 3) OR (bl.ouruserid = -1)) AND (bl.idtype = 1))
                                     LEFT JOIN spotteridblacklist as wl on ((wl.spotterid = s.spotterid) AND ((wl.ouruserid = 3) AND (wl.idtype = 2)))
                                     LEFT JOIN spotteridblacklist as gwl on ((gwl.spotterid = s.spotterid) AND ((gwl.ouruserid = -1) AND (gwl.idtype = 2)))  WHERE (bl.spotterid IS NULL)  AND (NOT ((s.Category = 0) AND (s.subcatz = 'z3|')))
                                     ORDER BY s.reversestamp ASC LIMIT 26 OFFSET 25;

Stack Trace.xlsx