Product Detail Page in a Category is Slow.

[Emrah Gunes]

Hello, I choose more than one category as in the picture, I choose the carpet category as the default category, all my carpet products are categorized this way. I choose 4-5 categories. In a carpet, after saving the product, the product detail opens very slowly, only the "carpet" category has this problem. There is no problem in other categories. Can anyone help why is it so slow.

[Emrah Gunes]

No one to help?

[follettostore]

Please set to true the _PS_DEBUG_PROFILING_ inside the file: \config\defines.inc.php

So refresh the "carpet" category at the end of file Prestashop will debug the loading time of your site. I need a copy of it by screen or via a test site.

After, just set the DEBUG PROFILING to false. We will check which query\plugin slowing your category.

[Emrah Gunes]

Hi, when I did true, the system gave a 500 error and never booted. I checked the error.log file and it gives this error: PHP Fatal error: Allowed memory size of 536870912 bytes exhausted (tried to allocate 20480 bytes) in /home/u0271460/public_html/tools/profiling/Db.php on line 113

[follettostore]

You should edit the memory_limit of your hosting trying to increase to > 512MB 

[Emrah Gunes]

[follettostore]

1 minute ago, Emrah Gunes said:

Please check the following instructions:

https://chemicloud.com/kb/article/how-to-increase-the-php-memory-limit-in-cpanel/

[Emrah Gunes]

[follettostore]

Please set to 1GB as I told you should be > 512M then try again.

[Emrah Gunes]

I don't have 1GB permission

[follettostore]

You must contact your hosting reseller and ask him to increase the memory limit. Only via debugging profile we can see what slows your site.

[Emrah Gunes]

https://www.evmia.com/163-hali

all products in this category have 21303 queriesI installed it on my local computer

[follettostore]

1 minute ago, Emrah Gunes said:

https://www.evmia.com/163-hali

all products in this category have 21303 queriesI installed it on my local computer

We need to see the first 10 queries. Please paste it screen

Thank you.

[Emrah Gunes]

is that enough?

[follettostore]

1 minute ago, Emrah Gunes said:

is that enough?

I dont see nothing

[Emrah Gunes]

how is it like that

[Emrah Gunes]

The first query responds very slowly when viewed from phpmyadmin.

[Emrah Gunes]

"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
"

 

how can i change this query?

[follettostore]

Hello 41ms it's not so high, I need to see in live the debug, can you active on your prod site or give me dev site url?

[Emrah Gunes]

But when I run this query from phpmyadmin it is very slow.

[Emrah Gunes]

LIMIT 0,1000000  I wonder why it accelerated after removing the term, is it a problem?

[follettostore]

1 minute ago, Emrah Gunes said:

LIMIT 0,1000000  I wonder why it accelerated after removing the term, is it a problem?

If you dont share with us your link with debug enabled we cant help you.

This query doesnt have any problem.