Please verify that this bug has NOT been raised before.

• I checked and didn't find a similar issue

Describe the bug*

GET /api/stock/?part_detail=true&location_detail=true performs a lot of db operations on larger datasets.

Steps to Reproduce

Call /api/stock/?location=8&part_detail=true&location_detail=true

Expected behaviour

Less operations, thus faster execution

Deployment Method

• Docker
• Bare metal

Version Information

0.14.0 dev

Please verify if you can reproduce this bug on the demo site.

• I can reproduce this bug on the demo site.

Relevant log output

No response