The Awarded slider media widget queries xf_mg_media_item where xfa_motm_winnner = 1.
As there is no usable index this query scans the whole table which is very slow when there are many records.
Suggested Fix
Create an appropriate index
or
Store media item IDs for winners somewhere else
The Current contest slider media Widget seems to have similar issues (I didn't specifically test this, just looked at the code).
As there is no usable index this query scans the whole table which is very slow when there are many records.
Suggested Fix
Create an appropriate index
or
Store media item IDs for winners somewhere else
The Current contest slider media Widget seems to have similar issues (I didn't specifically test this, just looked at the code).