There isn’t any way to optimize this query, the only hope you have is to optimize the data…. that is store it in a way that does not require all of the LIKE matches on un-indexed columns of the database. This can be done the same way that I explain for repeaters here https://acfextras.com/dont-query-repeaters/
Beyond this, pre-indexing search results, which is too complex to go into here, this is how most search plugins speed up searching.
