Hi,
Thank you for the feedback, but I’m afraid this query is not coming from our plugin. I have gone through all of the search process, and there is no query ever executed on the term meta table. This one even sets a timestamp, which is very unusual. The only instance is when the taxonomy search is enabled, but that uses a LEFT JOIN statement, not this query, it is completely different.
This might be something triggered by Ajax Search Pro after the actual search. I suspect maybe when the search is finished and the plugin requests the title, content or some other fields from WordPress, then there might be a hook from a different plugin to do something else, which then does this query. This is only a guess, the actual slow query could be coming from somewhere else too.
I will try to explain the query above, that may help you find the root cause: The query tries to get term metadata for specific taxonomy terms, the numbers there are listed the taxonomy term IDs. These taxonomy terms can be categories, post tags, product categories, product tags etc.. It looks like as if it tries to fetch metadata for a specific taxonomy term list for some reason – maybe to list categories or something similar.