TYPO3 Core

TYPO3\CMS\Frontend\Page\PageRepository::getMenu() calls getPageOverlay() for each single page, generating an additional SQL query for each page.

It would be more efficient if only one SQL query would be made, fetching the overlays for all pages at once. The method implementing this could then be used by getMenu().

This would reduce the number of SQL queries dramatically for big menus.