Relationships in json api result can lead to a lot of extra queries

I'm using this patch to convert all the entity load to 1 query to the base table. The resource identifier only needs a uuid, bundle and entity type.

Next to that, I also implemented the hook_entity_field_access in my custom module, to set view access to false for entity references (like paragraphs) on json api collection requests that are not needed on lists in my project.
As extra tweak I used a custom version of the patch in https://www.drupal.org/project/jsonapi_extras/issues/3039331#comment-143...

Before changes: 8372 queries
After applying this patch + implementing access rules on the fields: 1486 queries
After also applying the patch for link fields: 1116 queries

Overview of profilings:

Summaries:
https://www.drupal.org/files/issues/2022-01-24/overview-profiling.png

Difference between with patch and without patch:
https://www.drupal.org/files/issues/2022-01-24/patch-only.png

No it didn't. I use json api extras to disable some of those fields. But they still were loaded and removed afterwards. Implementing the field_access hook makes sure the related normalizer is not activated:

https://git.drupalcode.org/project/drupal/-/blob/9.4.x/core/modules/json...

@yang_yi_cn my version:

It disables the social image relation and the paragraphs relation on collection requests (except for 1 content type, special case for the app).
For all other pages it also disables some basic fields.

function uitbe_jsonapi_entity_field_access($operation, \Drupal\Core\Field\FieldDefinitionInterface $field_definition, \Drupal\Core\Session\AccountInterface $account, \Drupal\Core\Field\FieldItemListInterface $items = NULL) {
  $routeParts = explode('.', Drupal::routeMatch()->getRouteName());
  if ($routeParts[0] === 'jsonapi' && $routeParts[2] === 'collection') {
    $collectionExcludedFields = [
      'field_social_image',
    ];

    if ($routeParts[1] !== 'node--landing_page') {
      $collectionExcludedFields[] = 'field_content';
    }

    if (in_array($field_definition->getName(), $collectionExcludedFields)) {
      return AccessResult::forbidden()
        ->addCacheContexts(['route.name']);
    }
  }

  if ($operation === 'view' && $account->isAnonymous()) {
    $excludedFields = [
      'uid',
      'vid',
      'langcode',
      'revision_uid',
      'revision_timestamp',
      'revision_log',
      'publish_on',
      'node_type',
      'paragraph_type',
    ];
    return AccessResult::forbiddenIf(in_array($field_definition->getName(), $excludedFields))
      ->cachePerPermissions();
  }

  return AccessResult::neutral();
}