Django ORM generates duplicate queries causing high query counts per page

warning

performanceUpdated Nov 12, 2025(via Exa)

Sources

Intermittent Database Connection Errors and Slow Page Loads on My Django Website - Deployment - Django Forumforum.djangoproject.com

Technologies:

Djangosubject

MySQLSymptoms of this issue are visible in MySQL metrics and logs

How to detect:

Multiple redundant SELECT statements for the same data visible in debug toolbar, especially for views handling menu categories and items. High number of queries per page load persists even after applying select_related() and prefetch_related().

Recommended action:

Review view logic and model query structure to eliminate N+1 query patterns. Verify select_related() is used for foreign keys and prefetch_related() for many-to-many and reverse foreign key relations. Examine actual view code to identify architectural issues in how related models are queried.