This is because you are doing so many “LIKE” comparisons, not only on the content but also on the field names.
I would eliminate these “LIKE” comparisons from all of the queries.
This will not be easy because you already have a ton of content on the site. If you want to make the change it will mean updating every post.
This old post covers the basics of how to avoid these types of performance issues with queries https://web.archive.org/web/20190814230622/https://acfextras.com/dont-query-repeaters/
Short of this and updating all of the content you could try using transients or some other type of caching mechanism to store the results of these queries to they do not need to be run every time you need to do them.
Welcome to the Advanced Custom Fields community forum.
Browse through ideas, snippets of code, questions and answers between fellow ACF users
Helping others is a great way to earn karma, gain badges and help ACF development!
© 2022 Advanced Custom Fields.