better query for holdings / collections on user profile

following up from here
- https://github.com/kodadot/nft-gallery/issues/3182#issuecomment-1179691901

in profile / holdings tab, current time for expanding collections with large numbers (thousands) results in long loading time / freezing.
given the @vikiival comment, I assume this query could be pimped up to handle this in a better way

Start at the profile/holdings tab and trace the query used when expanding large collections, then review the linked discussion for the existing performance context. Measure behavior with collections containing thousands of items; done means expansion no longer causes long loading times or freezing.

Written by the indexing model from the issue text.