Media service performance improvements

[ZombieAlienRobot]

Description of changes

Improved the performance of the media service. Reduced number of database calls.

How has this been tested?

Please describe the test strategy you followed. If not tested, please explain why.

• [X] automated unit test
• [ ] automated integration test
• [X] manual, exploratory test

In case of manual test, please document the test well including a set of user instructions and prerequisites. Each including an action, it's result, and where appropriate a screenshot.

Checklist before requesting a review

• [X] My code is easy to understand
• [X] My code follows the coding guidelines of this project
• [X] My code fulfills all acceptance criteria
• [X] The test coverage (line and branch) is reasonably high, especially on Service classes and other classes with complex logic
• [X] I have made corresponding changes to the documentation or the wiki/adr
• [X] I made no breaking changes in the database schema or if so, I will perform a database migration

Checklist for reviewer

• The code is easy to understand
• The code follows the coding guidelines of this project
• The code is tested or if not, the reason is documented or discussed
• The added and existing tests reasonably cover the code change
• The code has no breaking changes in the database schema or if so, the assignee is aware of it and will perform a database migration