N+1 problem in dcim/ipam API calls

[Tishka17]

Deployment Type

Self-hosted

NetBox Version

v4.2.8

Python Version

3.10

Steps to Reproduce

1. Enable SQL logging
2. Do API requests:

• api/ipam/ip-addresses/
• api/ipam/prefixes
• api/dcim/interfaces

Expected Behavior

All required data is loaded by batch SQL requests

Observed Behavior

In the output you will see repeated SQL calls for each object in the response set:

• circuits_virtualcircuittermination for interfaces
• dcim_interface folowing by dcim_device for ip-address
• dcim_site for prefixes

[Tishka17]

I understand that PR was not recommended to create, but I needed these changes to validate my hypotesis.