Put this in your sitepackage Configuration/TCA/Overrides/

temporary_performance_patch.php

<?php

// this mitigates the core bug #92863 and is taken from https://github.com/TYPO3/TYPO3.CMS/commit/db0d7549647ed5326f4affc84b907dd0e397c844
// this file can be removed entirely after updating to TYPO3 10.4.11

$GLOBALS['TCA']['sys_file_metadata']['columns']['l10n_parent']['config'] = [
    'type' => 'group',
    'internal_type' => 'db',
    'allowed' => 'sys_file_metadata',
    'size' => 1,
    'maxitems' => 1,
    'minitems' => 0,
];

$GLOBALS['TCA']['sys_file_reference']['columns']['l10n_parent']['config'] = [
    'type' => 'group',
    'internal_type' => 'db',
    'allowed' => 'sys_file_reference',
    'size' => 1,
    'maxitems' => 1,
    'minitems' => 0,
];

Works like a charme