I found solution. When You use multistore website with large pruducts base then the part of LEFT JOIN ps_product_shop is the reason for the reduced performance of the sql query. I added index:
ALTER TABLE `ps_product_shop` DROP INDEX `sitte1`, ADD INDEX `sitte1` (`id_product`, `active`, `visibility`, `indexed`) USING BTREE;
and all runs smoothly.