Query too slow (240 ms) x8

[Tárraga]

I activated debug profiling and it says I have the same 8 querys that took 240 ms.

	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE DISTINCT p.id_product, p.date_add, p.date_upd, pl.name, pl.link_rewrite, pl.description, pl.description_short, m.name AS manufacturer FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 ) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_category_product` c ON (c.`id_product` = p.`id_product`) LEFT JOIN `ps_product_tag` pt ON (pt.`id_product` = p.`id_product`) WHERE pl.`id_lang` = 3 AND product_shop.`active` = 1 ORDER BY p.date_add DESC LIMIT 0, 1   It seems its something like feature products, but I have disabled the module and it still continue. How can I stop that query or optimice it?

[Tárraga]

Ok I solve it, it was layerslider module. I just disabled it.