/classes/Category.php:1056 the file is here. This sql is running very slow how can I fix it? Bu sorguyu kaldırdıktan sonra 21347 adet sorgu, 276 düşüyor
"SELECT
p.*,
product_shop.*,
stock.out_of_stock,
IFNULL(stock.quantity, 0) AS quantity,
IFNULL(
product_attribute_shop.id_product_attribute,
0
) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,
pl.`description`,
pl.`description_short`,
pl.`available_now`,
pl.`available_later`,
pl.`link_rewrite`,
pl.`meta_description`,
pl.`meta_keywords`,
pl.`meta_title`,
pl.`name`,
image_shop.`id_image` id_image,
il.`legend` as legend,
m.`name` AS manufacturer_name,
cl.`name` AS category_default,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-09-29 00:00:00", INTERVAL 365 DAY
)
) > 0 AS new,
product_shop.price AS orderprice
FROM
`pr_category_product` cp
LEFT JOIN `pr_product` p ON p.`id_product` = cp.`id_product`
INNER JOIN pr_product_shop product_shop ON (
product_shop.id_product = p.id_product
AND product_shop.id_shop = 1
)
LEFT JOIN `pr_product_attribute_shop` product_attribute_shop ON (
p.`id_product` = product_attribute_shop.`id_product`
AND product_attribute_shop.`default_on` = 1
AND product_attribute_shop.id_shop = 1
)
LEFT JOIN pr_stock_available stock ON (
stock.id_product = `p`.id_product
AND stock.id_product_attribute = 0
AND stock.id_shop = 1
AND stock.id_shop_group = 0
)
LEFT JOIN `pr_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2
AND cl.id_shop = 1
)
LEFT JOIN `pr_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2
AND pl.id_shop = 1
)
LEFT JOIN `pr_image_shop` image_shop ON (
image_shop.`id_product` = p.`id_product`
AND image_shop.cover = 1
AND image_shop.id_shop = 1
)
LEFT JOIN `pr_image_lang` il ON (
image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 2
)
LEFT JOIN `pr_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE
product_shop.`id_shop` = 1
AND cp.`id_category` = 163
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
ORDER BY
cp.`position` ASC
LIMIT
0, 1000000
"