Error slowing site too much

Slowing site too much (78 secs). Maybe table too big?

I had to disable plugin. This is where de lag happens:

SELECT p.ID AS ‘id’, p.post_title AS ‘title’, p.post_date AS ‘date’, p.post_author AS ‘uid’, SUM(v.pageviews) AS ‘pageviews’
FROM TABLE_popularpostssummary v
LEFT JOIN TABLE_posts p
ON v.postid = p.ID
WHERE 1 = 1
AND p.post_type = ‘post’
AND v.view_datetime > DATE_SUB(‘2020-03-04 09:32:41’, INTERVAL 1 MONTH)
AND p.post_password = ”
AND p.post_status = ‘publish’
GROUP BY v.postid
ORDER BY pageviews DESC
LIMIT 30;

• This topic was modified 4 years, 9 months ago by bbcbbc.