Staging feedback:Optimize favorites query listing

Summary

Showing the favorites ordering for categories is very slow

Steps to reproduce

Visit https://marketplace-staging-d9.eclipse.org/taxonomy/term/31%2C28/favorites

What is the current bug behavior?

Slow query

What is the expected correct behavior?

Not a slow query

Relevant logs and/or screenshots

(Paste any relevant URL, error message, etc.)

added Drupal 9 team:webdev labels

assigned to @theodoreb

marked this issue as blocking #195 (closed)

marked this issue as blocked by #197 (closed)

removed the relation with #197 (closed)

added statetodo label

mentioned in issue #205 (closed)