Всем привет, прощу помощи.
Не открывает через админку список товаров. ошибка 505
в запросах в базе данных висит не понятный запрос и загружает CPU на 100%
SELECT prod.product_id, pr_cat.category_id, prod.`name_uk-UA` as name, prod.`short_description_uk-UA` as
short_description, prod.product_ean, prod.manufacturer_code, prod.image, prod.product_price, prod.currency_id,
prod.product_tax_id as tax_id, prod.product_old_price, prod.product_weight, prod.average_rating, prod.reviews_count,
prod.hits, prod.weight_volume_units, prod.basic_price_unit_id, prod.label_id, prod.product_manufacturer_id, prod.min_price,
prod.product_quantity, prod.different_prices, prod.`extra_field_2` , prod.unlimited, product_nodiscount FROM `sna3v_jshopping_products` AS
prod INNER JOIN `sna3v_jshopping_products_to_categories` AS pr_cat ON pr_cat.product_id = prod.product_id LEFT JOIN `sna3v_jshopping_categories`
AS cat ON pr_cat.category_id = cat.category_id WHERE prod.product_publish = '1' AND cat.category_publish='1' AND prod.access IN (1,1,5) AND cat.access IN (1,1,5) GROUP BY prod.product_id LIMIT 7