Quite a number of slow database queries caused by Defender

I have been given this warning….

Checking the case I can see that your account churchonline.solutions has reached monthly allowed usage of 600000 CPU seconds, due to which it was limited.

Checking your account statistics I can see quite a number of slow database queries:

And with a developer friend have nailed down the issue with Defender Pro and here’s one of the slow queries reports…:

1. Executed 10h 13m 44s ago for 14.234664 sec on Database –> Unknown (NOT FOUND / DELETED)

# Schema: church04_wp952 Last_errno: 0 Killed: 0 SELECT dlx_posts.ID FROM dlx_posts INNER JOIN dlx_postmeta ON ( dlx_posts.ID = dlx_postmeta.post_id ) WHERE 1=1 AND ( ( dlx_postmeta.meta_key = ‘ip’ AND dlx_postmeta.meta_value = ‘173.31.99.166’ ) ) AND dlx_posts.post_type = ‘wd_ip_lockout’ AND ((dlx_posts.post_status = ‘publish’:wink:) GROUP BY dlx_posts.ID ORDER BY dlx_posts.post_date DESC LIMIT 0, 1;

So this issue with Defender is spending my CPU seconds for the month. I have hundreds of these. Can you please let me know what your plug in is doing and how to fix it?

Thank You,

Adrian