Optimize query in django project

Job ID: 31190873

Budget: $15 – $25 USD

I have a project where a specific call is performing around 2000+ queries which should be allot less. I tried to prefetch_related to optimize it without any success. So hopefully someone can optimize the query for me here.

The query fetches products that belongs to a menu. A product has a tax class, category, accessories and so on. And those results are recurring and should be cached / optimized somehow.