Reduce N+1 queries when publishing draft notes
requested to merge 444592-investigate-and-reduce-n-1-sql-queries-when-publishing-multiple-draft-notes into master
What does this MR do and why?
This MR reduces the number of executed queries when publishing multiple draft notes.
More work would follow this, but this change reduces from 197 to 186 in the case of publishing 5 draft notes.
MR acceptance checklist
Please evaluate this MR against the MR acceptance checklist. It helps you analyze changes to reduce risks in quality, performance, reliability, security, and maintainability.
Related to #444592 (closed)