Question about Database Query

Hello,

Thank you for your query and we are so sorry about the trouble this must have caused.

The database query you shared seems to be fine and shouldn’t cause and slowdown to your website. Can you please confirm if this is happening on every page of your website’s WP dashboard?

Also, lease get in touch with your web host and ask them to set at least the following values:

PHP Memory Limit: 512M
Max input time: 150
PHP time limit: 120
PHP max input variables: 1000

See if this will improve the loading speed.

If not, we might need to take a closer look at the settings. Please edit the first post on this ticket and include your WordPress & FTP logins in the designated Sensitive Data section.

Please do take a complete backup of your website before sharing the information with us.

It is completely secure and only our support staff has access to that section. If you want, you can use the below plugin to generate a temporary login URL to your website and share that with us instead:

https://wordpress.org/plugins/temporary-login-without-password/

You can use the above plugin in conjunction with the WP Security Audit Log to monitor what changes our staff might make on your website (if any):

https://wordpress.org/plugins/wp-security-audit-log/

We really look forward to helping you.

Hello,

Based on the query, it fetches the number of posts that don’t have a focus keyword set.

In Rank Math, we count those in the process of the Rank Math SEO Analyzer tool and display/return them where you can also check all of those posts:
https://rankmath.com/kb/seo-analysis/#focus-keywords-test

The other feature where this may occur is by filtering your post list view to find the posts that don’t have a focus keyword (only available with Rank Math PRO):
https://rankmath.com/kb/bulk-editing-in-rank-math/#focus-keyword-not-set

Hope that helps.

Thank you.