Optimize retrieving personal and resource access tokens for Credentials inventory index page and API endpoints

&18720 (closed) reports about issues with

• rendering Credentials / Personal access tokens and Credentials / Project and group access tokens tabs
• GET /groups/:id/manage/personal_access_tokens and GET /groups/:id/manage/resource_access_tokens API endpoints requests

for large groups. The root cause of those issues is performance of SQL queries that retrieve personal and resource access tokens for those pages and API endpoints.

• If possible, amend existing PersonalAccessTokensFinder (otherwise create new Authn::CredentialsInventory::PersonalAccessTokensFinder finder) to allow filtering by new personal_access_tokens.group_id and personal_access_tokens.user_type columns.
• Create new queries by using the finder and new columns to replace problematic queries with a FF for
  • the index page
  • GET /groups/:id/manage/personal_access_tokens API endpoint
  • GET /groups/:id/manage/resource_access_tokens API endpoint
• Optimize IN queries, see !201312 (comment 2757654224)
  • !206878 (merged)