TYPO3 Core

Updating the extension list in a TYPO3 7.6.15 takes 5 minutes, which is way too much.

A major problem seems to be a select statement that takes > 300 seconds:

mysql> show processlist;
+-----+---------+-------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| Id  | User    | Host              | db    | Command | Time | State        | Info                                                                                                 |
+-----+---------+-------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
| 172 | mariadb | 172.17.0.16:57378 | TYPO3 | Query   |  313 | Sending data | SELECT a.uid AS uid FROM tx_extensionmanager_domain_model_extension a LEFT JOIN tx_extensionmanager_ |
| 173 | mariadb | localhost         | NULL  | Query   |    0 | starting     | show processlist                                                                                     |
+-----+---------+-------------------+-------+---------+------+--------------+------------------------------------------------------------------------------------------------------+
2 rows in set (0.00 sec)