[BE] Reduce the data being loaded per Design on first load

What does this MR do?

This MR allows us to select certain designs from design list instead of always fetching all designs. This will help frontend to reduce the initial amount of data fetched to display the design list because we will be able to fetch full set of data only for the fullscreen design view with passing the design ID.

Does this MR meet the acceptance criteria?

Conformity

• Changelog entry
• Documentation created/updated or follow-up review issue created
• Code review guidelines
• Merge request performance guidelines
• Style guides
• Database guides

Availability and Testing

• Review and add/update tests for this feature/bug. Consider all test levels. See the Test Planning Process.

Related issues

#34408 (closed)