Performance: Excessive SQL usage in Sales and Products Grid

[lbajsarowicz]

Issue Description

Preconditions

1. Magento 2.4.5-p1
2. Mailchimp 103.4.53

Steps to reproduce

As an Administrator, visit Products Grid.

Actual and Expected result

Mailchimp extension performs over 1000 unnecessary MySQL requests to load Product Listing.

Diff when Mailchimp is disabled (for a grid of 100 products):

Additional information

Poor extension architecture and the fact it's an official extension affects thousands of stores around the globe, wasting huge amount of resources. Minor optimizations would not only help merchants better utilize their employees time (lower load times), but also waste lest natural resources.