PrestaShop - Dlhé načítavanie produktov v administrácií

Dobrý deň chcem vás poprosiť o radu na eshope mám v administrácií velmi dlhe načítavanie katalog---> produkty robí to cez 46 milionov poziadaviek mam tam asi 7000 produktov nerozumiem v com je problem viete mi prosim poradit ako to vyriesit ? dakujem

Dobrý den,

nevím, jakou verzi aplikace používáte, ale u novější verze 1.6.1.1 byly hlášeny problémy s rychlostí administrace. Můžete případně vyzkoušet provést úpravy z tématu 1.6.1.1 backoffice terribly slow on clean installation na oficiálním diskuzním fóru, ve kterém se řešil stejný problém s pomalým načítáním administrace.

6500 dotazů do databáze na 1 produkt - to je opravdu hodně.

Máte hodně kombinací, vlastností? Čeho je ve vašem shopu hodně?

nieje problem v nacitavani celej administracie iba produktoch
SELECT
a.`id_product`, b.`name` AS `name`, `reference`, a.`price` AS `price`, sa.`active` AS `active`
, shop.name as shopname, supp.`name` AS `supp`, shop.`name` AS `shopname`, a.`id_shop_default`, image_shop.`id_image` AS `id_image`, cl.`name` AS `name_category`, sa.`price`, 0 AS `price_final`,
a.`is_virtual`, pd.`nb_downloadable`, sav.`quantity` AS `sav_quantity`, sa.`active`, IF(sav.`quantity`<=0, 1, 0) AS `badge_danger`
FROM `ps_product` a
LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 2 AND b.`id_shop` = 1)

LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`)
LEFT JOIN `ps_supplier` supp ON (supp.id_supplier = a.`id_supplier`)
LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`)
WHERE 1

ORDER BY a.`id_product` ASC LIMIT 0, 50

SELECT COUNT(*) AS `ps_product`
FROM `ps_product` a
LEFT JOIN `ps_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 2 AND b.`id_shop` = 1)

LEFT JOIN `ps_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0
AND sav.id_shop = 1 AND sav.id_shop_group = 0 ) JOIN `ps_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default)
LEFT JOIN `ps_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default)
LEFT JOIN `ps_shop` shop ON (shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = a.`id_product` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default)
LEFT JOIN `ps_image` i ON (i.`id_image` = image_shop.`id_image`)
LEFT JOIN `ps_supplier` supp ON (supp.id_supplier = a.`id_supplier`)
LEFT JOIN `ps_product_download` pd ON (pd.`id_product` = a.`id_product`)
WHERE 1 LIMIT 1
toto je problem ktory trva cez 2 minuty viete mi niekto poradit ako to mam opravit ? dakujem

Ale proč se načítají všechny produkty, když je seznam stránkovaný a není možná volba bez limitu?