I have a page with many posts and every single page load is noticably slow. Hence, I have checked with Query Monitor the culprit(s) for the slow loading time and found that one query in particular is taking 90% of the time.
This one query is:
SELECT ID FROM posts WHERE (post_content LIKE '%template=publish%')
This query takes 3-4 seconds everytime a page (frontend/backend) is loaded. This is not userfriendly as well as it puts a straing on the DB, too.
Does anyone have any suggestions as to reduce/improve/cache the query? Unfortunately Object-Caching is not feasable on this site.
However, it suggests that a plugin is actually calling it, since it is originated from plugin.php, correct? Any way to trace the culprit plugin?
Edit2: I have done the good ol' deactivate-all-plugins-and-activate-one-by-one-debug-procedure. It turns out, the plugin userpro generates that query. I will contact the author. Let's see what he has to say about that.