Skip to content

Listing entries loads many more relationships than required #13378

@macaws

Description

@macaws

Bug description

For both Runway and Statamic Entries, the augmentation appears to be loading an insane number of extra models:

Image

We have a bunch of fields with Taxonomy terms - and it appears that those get loaded on the listing pages, even when they're not visible. We were able to "fix" this by setting filterable: false on these fields - and that stopped the extra queries and sped up the CP significantly.

Discord thread

How to reproduce

Add a Term field to your entries or Runway models - and upon loading the list view, you'll notice that it's also loading all those Terms behind the scenes.

Logs

Environment

Environment
Application Name: <snipped>
Laravel Version: 12.41.1
PHP Version: 8.4.12
Composer Version: 2.9.2
Environment: uat
Debug Mode: ENABLED
URL: <snipped>
Maintenance Mode: OFF
Timezone: UTC
Locale: en

Cache
Config: CACHED
Events: CACHED
Routes: CACHED
Views: CACHED

Drivers
Broadcasting: reverb
Cache: redis
Database: pgsql
Logs: stack / stdout, sentry_logs
Mail: smtp
Octane: roadrunner
Queue: redis
Scout: meilisearch
Session: redis

Storage
public/icons: NOT LINKED
public/storage: NOT LINKED

Livewire
Livewire: v3.7.0

Spatie Permissions
Features Enabled: Default
Version: 6.23.0

Statamic
Addons: 12
Sites: 1
Stache Watcher: Disabled
Static Caching: null
Version: 5.70.0 PRO

Statamic Addons
aryehraber/statamic-uuid: 2.3.0
edge/powerbi-embed: dev-master
eminos/statamic-set-header-toggle: 1.1.0
eminos/statamic-tabs: 1.2.0
igd/utils: 2.3.x-dev
jacksleight/statamic-bard-mutator: 3.0.5
mitydigital/iconamic: 2.2.3
pecotamic/sitemap: 1.4.10
rias/statamic-redirect: 3.13.0
statamic-rad-pack/meilisearch: 3.4.0
statamic-rad-pack/runway: 8.8.2
statamic/eloquent-driver: 4.35.1

Statamic Eloquent Driver
Asset Containers: file
Assets: eloquent
Blueprints: eloquent
Collection Trees: eloquent
Collections: eloquent
Entries: eloquent
Fieldsets: file
Form Submissions: eloquent
Forms: eloquent
Global Sets: eloquent
Global Variables: eloquent
Navigation Trees: eloquent
Navigations: eloquent
Revisions: eloquent
Sites: file
Taxonomies: eloquent
Terms: eloquent
Tokens: eloquent

Installation

Fresh statamic/statamic site via CLI

Additional details

No response

Metadata

Metadata

Assignees

No one assigned

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions