Steps to reproduce the issue

After test upgrading a clone of the downloads site to 3.7 RC 4, I clicked into the new com_associations to quickly glance at how it works. After setting up my filters for en-GB articles, the resulting page resulted in 244 queries being executed. The debug bar reports that 214 of the queries for the request are duplicated. The ones that look to be coming from the component are running the same query 3 times for each item.

FWIW my clone of the site has 3 articles and 18 of our site languages set up right now (it's an older database clone that's now massively out of sync with the live site which has 27 languages running now).

Expected result

A sane number of database queries with minimal duplicates.

Actual result

In this scenario, the component issues 244 queries with 214 duplicated request wide (please remember not all of the duplicates will be related to com_associations).