Summary:

• Reduce tag list page query time by ~11x (tested on my production database) by eliminating expensive recursive count queries that weren't displayed on the list page
• Created optimized TagListData GraphQL fragment that excludes *_count_all fields
• Tag list page now loads in ~18ms instead of ~205ms (for 20 tags)

Problem:
The tag list page was slow to load because for every tag displayed, the TagData fragment requested 14 count fields:

• 7 direct counts (scene_count, image_count, etc.)
• 7 recursive counts (scene_count_all, image_count_all, etc. with depth: -1)

The recursive *_count_all fields use expensive recursive common table expressions to traverse the tag hierarchy and count all descendants. With 9M+ rows in my scenes_tags, this was extremely slow.
The *_count_all fields were fetched but never displayed on the list page - they're only used on the tag detail page.

Solution:
Created a new TagListData fragment and FindTagsForList query that only fetches the direct counts needed for the list page display.