Prestashop Search Functionality Optimising

Prestashop Search Functionality Optimising Pretashop 1.6.1.4 [login to view URL] MSG from Hosting site. I have found that during these periods where the website has been slow/unresponsive, there are a number of long running MySQL queries using up the CPU resources on the server. There were 6 copies of the below query running for over 10 minutes, and it appears to be related to product searches. "SELECT si.id_product FROM ps_search_word sw LEFT JOIN ps_search_index si ON sw.id_word = si.id_word WHERE sw.id_lang = 1 AND sw.id_shop = 1 AND [login to view URL] LIKE '%%';" We would recommend a Presta shop developer check your sites product search functionality, for optimising the product searches. If you have any further questions, please let us know.