René's URL Explorer Experiment

{"@context":"https://schema.org","@type":"DiscussionForumPosting","headline":"Article edit page makes many queries","articleBody":"On my install, I find basic article pages take about 5500 queries to produce, and take around 200 seconds to load.\r\n\r\nSpecifically, this query is repeated about 2000 times:\r\n\r\n```\r\nSELECT \"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\r\n```\r\n\r\nThis one around 2000 times as well:\r\n\r\n```\r\nSELECT \"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\r\n```\r\n\r\nAnd this one around 1500 times:\r\n\r\n```\r\nSELECT \"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\r\n```\r\n","author":{"url":"https://github.com/danpalmer","@type":"Person","name":"danpalmer"},"datePublished":"2018-08-27T12:43:03.000Z","interactionStatistic":{"@type":"InteractionCounter","interactionType":"https://schema.org/CommentAction","userInteractionCount":9},"url":"https://github.com/675/feincms/issues/675"}