Deduplicate SQL queries in RetrieveCorpus

This brings the optimizations already done in ListCorpus to RetrieveCorpus, which avoids duplicate queries on types and memberships.

changed the description

added 1 commit

• 2f604d1b - Add assertNumQueries

Compare with previous version

added 26 commits

• 2f604d1b...089a34bf - 24 commits from branch master
• 81516e69 - Deduplicate SQL queries in RetrieveCorpus
• 6f12c692 - Add assertNumQueries

Compare with previous version

marked this merge request as ready

requested review from @babadie

added 4 commits

• 6f12c692...e47c4abf - 2 commits from branch master
• 825a34fe - Deduplicate SQL queries in RetrieveCorpus
• c21a4c55 - Add assertNumQueries

Compare with previous version

enabled an automatic merge when the pipeline for c21a4c55 succeeds

aborted the automatic merge because target branch was updated

added 8 commits

• c21a4c55...85f21724 - 6 commits from branch master
• be77e540 - Deduplicate SQL queries in RetrieveCorpus
• 1def1a12 - Add assertNumQueries

Compare with previous version

added 6 commits

• 1def1a12...9392dd5b - 4 commits from branch master
• 47909266 - Deduplicate SQL queries in RetrieveCorpus
• 517a0017 - Add assertNumQueries

Compare with previous version

added 3 commits

• 8290d900 - 1 commit from branch master
• 80b89f99 - Deduplicate SQL queries in RetrieveCorpus
• 06d7f165 - Add assertNumQueries

Compare with previous version

merged

mentioned in commit 08fbf155