[סגור] Posts overview loading takes more than 2 minutes

Background of the issue:
I am trying to access a custom post type listing via the WordPress backend.

Symptoms:
Custom post type overview loading took nearly 3 minutes to load.
Posts overview is also slow.

Questions:
We're using PHP 8.3 and automatic translations.
I have used Query Monitor, which suggests that the issue is caused by a slow WPML query.
I've followed multiple recommendation of yours to increase performance – but none of them have anything to do with the backend queries, so did not help. I've attached screenshots of the Query Monitor.

Why is the post listing taking so long to load?
How can this be fixed?
My customer is understandably upset that he can't easily edit his posts due to long wait times.

On a side note.. there's 306 PHP Errors that could probably be avoided on your end (see screenshot attached).

Here's the query that causes a long wait time on my custom post type listing (see screenshots attached):

SELECT translations.translation_id, translations.element_type, translations.element_id, translations.trid, translations.language_code, translations.source_language_code, (
SELECT element_id
FROM wp_icl_translations as originalTranslation
WHERE originalTranslation.trid = translations.trid and originalTranslation.source_language_code IS NULL ) as original_doc_id, NULLIF(translations.source_language_code, '') IS NULL AS original, translation_status.rid, translation_status.status, translation_status.translator_id, translation_status.needs_update, translation_status.review_status, translation_status.translation_service, translation_status.batch_id, translation_status.timestamp, translation_status.tp_id, translation_status.ate_comm_retry_count, jobs.max_job_id as job_id, jobs.translated, jobs.editor, jobs.editor_job_id, jobs.automatic, jobs.ate_sync_count
FROM wp_icl_translations as translations
LEFT JOIN wp_icl_translation_status translation_status
ON translation_status.translation_id = translations.translation_id
LEFT JOIN (
SELECT MAX(job_id) as max_job_id, translated, editor, editor_job_id, automatic, ate_sync_count, rid
FROM wp_icl_translate_job
GROUP BY job_id ) as jobs
ON jobs.rid = translation_status.rid
WHERE translations.trid IN (
SELECT trid
FROM wp_icl_translations
WHERE (element_id = 838964
AND element_type = 'post_trend')
OR (element_id = 838923
AND element_type = 'post_trend')
OR (element_id = 838199
AND element_type = 'post_trend')
OR (element_id = 838189
AND element_type = 'post_trend')
OR (element_id = 838182
AND element_type = 'post_trend')
OR (element_id = 838112
AND element_type = 'post_trend')
OR (element_id = 838099
AND element_type = 'post_trend')
OR (element_id = 838082
AND element_type = 'post_trend')
OR (element_id = 838060
AND element_type = 'post_trend')
OR (element_id = 655807
AND element_type = 'post_trend')
OR (element_id = 655802
AND element_type = 'post_trend')
OR (element_id = 645688
AND element_type = 'post_trend')
OR (element_id = 642861
AND element_type = 'post_trend')
OR (element_id = 637813
AND element_type = 'post_trend')
OR (element_id = 637810
AND element_type = 'post_trend')
OR (element_id = 635531
AND element_type = 'post_trend')
OR (element_id = 634057
AND element_type = 'post_trend')
OR (element_id = 634053
AND element_type = 'post_trend')
OR (element_id = 634056
AND element_type = 'post_trend')
OR (element_id = 634052
AND element_type = 'post_trend')
OR (element_id = 634051
AND element_type = 'post_trend')
OR (element_id = 634048
AND element_type = 'post_trend')
OR (element_id = 634047
AND element_type = 'post_trend')
OR (element_id = 634046
AND element_type = 'post_trend')
OR (element_id = 634043
AND element_type = 'post_trend')
OR (element_id = 634042
AND element_type = 'post_trend')
OR (element_id = 634041
AND element_type = 'post_trend')
OR (element_id = 634040
AND element_type = 'post_trend')
OR (element_id = 634039
AND element_type = 'post_trend')
OR (element_id = 634038
AND element_type = 'post_trend')
OR (element_id = 634005
AND element_type = 'post_trend')
OR (element_id = 633999
AND element_type = 'post_trend')
OR (element_id = 633998
AND element_type = 'post_trend')
OR (element_id = 633997
AND element_type = 'post_trend')
OR (element_id = 633996
AND element_type = 'post_trend')
OR (element_id = 633995
AND element_type = 'post_trend')
OR (element_id = 633994
AND element_type = 'post_trend')
OR (element_id = 633993
AND element_type = 'post_trend')
OR (element_id = 633992
AND element_type = 'post_trend')
OR (element_id = 633991
AND element_type = 'post_trend')
OR (element_id = 633990
AND element_type = 'post_trend')
OR (element_id = 633989
AND element_type = 'post_trend')
OR (element_id = 633988
AND element_type = 'post_trend')
OR (element_id = 633987
AND element_type = 'post_trend')
OR (element_id = 633986
AND element_type = 'post_trend')
OR (element_id = 633985
AND element_type = 'post_trend')
OR (element_id = 633984
AND element_type = 'post_trend')
OR (element_id = 633983
AND element_type = 'post_trend')
OR (element_id = 633982
AND element_type = 'post_trend')
OR (element_id = 633981
AND element_type = 'post_trend') )
AND 1 = 1