kuflievskiy

Hello, @filoveg and @joyously!

I have had the same issue as you described. I think this query had to go away when you disable to commenting feature in the settings. But actually, it is not.

I have found the hook that is placed before executing this query here
wordpress/wp-includes/comment.php

So you can override the behavior and trick the WordPress. I have set 1 comment and got rid of this query execution.

This is my workaround:

		add_filter( 'wp_count_comments', function () {
			return 1;
		} );

I hope it will be helpful for someone.