On my install, I find basic article pages take about 5500 queries to produce, and take around 200 seconds to load.
Specifically, this query is repeated about 2000 times:
SELECT "medialibrary_mediafiletranslation"."id", "medialibrary_mediafiletranslation"."parent_id", "medialibrary_mediafiletranslation"."language_code", "medialibrary_mediafiletranslation"."caption", "medialibrary_mediafiletranslation"."description" FROM "medialibrary_mediafiletranslation" WHERE ("medialibrary_mediafiletranslation"."parent_id" = 802 AND (UPPER("medialibrary_mediafiletranslation"."language_code"::text) LIKE UPPER('en-us%') OR UPPER("medialibrary_mediafiletranslation"."language_code"::text) LIKE UPPER('en%'))) ORDER BY "medialibrary_mediafiletranslation"."language_code" DESC LIMIT 1
This one around 2000 times as well:
SELECT "medialibrary_mediafiletranslation"."id", "medialibrary_mediafiletranslation"."parent_id", "medialibrary_mediafiletranslation"."language_code", "medialibrary_mediafiletranslation"."caption", "medialibrary_mediafiletranslation"."description" FROM "medialibrary_mediafiletranslation" WHERE ("medialibrary_mediafiletranslation"."parent_id" = 965 AND (UPPER("medialibrary_mediafiletranslation"."language_code"::text) LIKE UPPER('en-us%') OR UPPER("medialibrary_mediafiletranslation"."language_code"::text) LIKE UPPER('en%'))) ORDER BY "medialibrary_mediafiletranslation"."language_code" DESC LIMIT 1
And this one around 1500 times:
SELECT "medialibrary_mediafiletranslation"."id", "medialibrary_mediafiletranslation"."parent_id", "medialibrary_mediafiletranslation"."language_code", "medialibrary_mediafiletranslation"."caption", "medialibrary_mediafiletranslation"."description" FROM "medialibrary_mediafiletranslation" WHERE "medialibrary_mediafiletranslation"."parent_id" = 346 LIMIT 1
On my install, I find basic article pages take about 5500 queries to produce, and take around 200 seconds to load.
Specifically, this query is repeated about 2000 times:
This one around 2000 times as well:
And this one around 1500 times: