BelongsToMany has many duplicate queries on detail page

[niekdemelker]

• Laravel Version: 11.17.0
• Nova Version: 4.34.3
• PHP Version: 8.3.9
• Reproduction Repository: https://github.com/niekdemelker/issue-6479

Description:

When using an BelongsToMany field, this will show all related models on the Details page. This request to fetch all relation records however calls the DB many times to fetch the ViaResource model. Sometimes over 20 times in one request (Strange enough Model::preventLazyLoading(! app()->isProduction()) doesn't block this behaviour.).

The logging states this call is done repeatedly from 'Http/Requests/InteractsWithRelatedResources.php:72' and one time from 'Http/Requests/QueriesResources.php:38'.

Detailed steps to reproduce the issue on a fresh Nova installation:

• run migrations & seeder
• create nova user
• Open Nova and navigate to 'service levels' and open the details page of the generated record
• Open Telescope and search on the tag 'bug' to see the recorded queries of this request

[crynobone]

Please provide full reproducing repository based on fresh installation as suggested in the bug report template (or you can refer to https://github.com/nova-issues for example)

[niekdemelker]

Please provide full reproducing repository based on fresh installation as suggested in the bug report template (or you can refer to https://github.com/nova-issues for example)

@crynobone I already did that. the steps to reproduce take into account you use the provided repo. Se https://github.com/niekdemelker/issue-6479

[niekdemelker]

Do you still require more info? If you need more information on some parts please tell so I can Elaborate

[github-actions]

This thread has been automatically locked since there has not been any recent activity after it was closed. Please open a new issue for related bugs.