Optimize the lookup of contributor result

[techsmyth]

Description

As a user I want a performance application

Acceptance criteria

• [ ] The lookup of a Contributor in the Contributor Service should cache the type
• [ ] The database lookup should then go directly to the relevant table, not try all tables

To avoid doing lookups that are not relevant all the time

Additional Context

Areas that will be affected

To be added during the refinement