Prestashop težava (sporne SQL poizvdebe)

Da ne dolgovezim. :) Neka zadeva na Prestashopu mi periodično (vsakih cca 6 ur) obremenjuje strežniške zmogljivosti. Če se kdo bolj spozna, kaj bi to lahko bilo, bi bil zelo vesel. Hvala. ;-) Spodaj je primer sporne SQL poizvedbe (vsaka traja 160+ sekund):

Command: Query
    Time: 168
   State: statistics
    Info: CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY
														SELECT cp.id_product, MIN(cp.position) position FROM ps_category c
														STRAIGHT_JOIN ps_category_product cp ON (c.id_category = cp.id_category AND
														c.nleft >= 6
														AND c.nright <= 7
														AND c.active = 1)
														STRAIGHT_JOIN `ps_product` p ON (p.id_product=cp.id_product)
														INNER JOIN `ps_layered_price_index` psi
			ON
			(
				psi.price_min <= 7299
				AND psi.price_max >= 605
				AND psi.`id_product` = p.`id_product`
				AND psi.`id_shop` = 1
				AND psi.`id_currency` = 1
			)
														 INNER JOIN ps_product_shop product_shop
		ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
														WHERE 1  AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND p.id_manufacturer IN (2) AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 38)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 1265)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 1277)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 1258)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 58)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 48)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 1269)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 54 OR fp.`id_feature_value` = 68)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 261)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 98)  AND p.id_product IN (SELECT `id_product` FROM `ps_feature_product` fp WHERE fp.`id_feature_value` = 53)
														GROUP BY cp.id_product ORDER BY position, id_product