We should add ec:isProxy = 0 to avoid the UNION query.
We could add a simple cache at service level, so that resolution name => uuid do not require a DB query each time.
For that cache we could leverage Guava MapMaker for that ...
The cache should be invalidated when workflows are reloaded.