Task: Add index for parent relation in link table

[christophlehmann]

TASK

Related links (IRRE in News records) should have an index on the parent relation field. Currently this query does not use any index

SELECT COUNT(*) FROM `tx_news_domain_model_link` `tx_news_domain_model_link` WHERE (`tx_news_domain_model_link`.`parent` = ?) AND (`tx_news_domain_model_link`.`t3ver_oid` = 0) AND (((`tx_news_domain_model_link`.`deleted` = 0) AND (`tx_news_domain_model_link`.`t3ver_state` <= 0) AND (`tx_news_domain_model_link`.`t3ver_wsid` = 0) AND (((`tx_news_domain_model_link`.`t3ver_oid` = 0) OR (`tx_news_domain_model_link`.`t3ver_state` = 4))) AND (`tx_news_domain_model_link`.`hidden` = 0))) AND (((`tx_news_domain_model_link`.`t3ver_wsid` = 0) AND (((`tx_news_domain_model_link`.`t3ver_oid` = 0) OR (`tx_news_domain_model_link`.`t3ver_state` = 4)))))

Expected behavior/output

The uses an index.

Environment

• TYPO3 version(s): 12
• news version: 11

Possible Solution

Add an index :-)

Additional context

Will provide a PR