Add a post_status check for performance

[srtfisher]

• Adds a post_status check to an expensive query.
• Aligns post_status use in the plugin to use the actual public post statuses from get_post_stati().

[mchanDev]

Thanks for this @srtfisher I believe this is a useful improvement.

We're sorry for the length of time that this PR has been sitting stale.

If you are happy to update this with the latest codebase and address the comment regarding variable name, we'll get this shipped!

Thanks!

[srtfisher]

@mchanDev great! I just updated this with the latest from main and a fix for that variable.