Pomala presta 1.6.1.1

[KU1]

Dobrý den Všem 

Potřeboval bych nakopnout kam šáhnout aby prestashop nebyl tak pomalej

 

Load Time 3722 ms - You'd better run your shop on a toaster Querying Time 101 ms Queries 24 Memory Peak Usage 24.9 Mb Included Files 172 files - 3.39 Mb PrestaShop Cache 0.45 Mb Global vars 0.52 Mb

PrestaShop Version 1.6.1.1 PHP Version 5.4.16 (OK) MySQL Version 5.5.47-MariaDB (Consider upgrading) Memory Limit 256M Max Execution Time 600s Smarty Cache enabled Smarty Compilation never recompile

  Time Cumulated Time Memory Usage Memory Peak Usage config 344ms 344 ms 11.83 Mb 11.91 Mb __construct 0 ms 344 ms - Mb 11.91 Mb init 28 ms 372 ms 3.85 Mb 15.74 Mb checkAccess 0 ms 372 ms - Mb 15.74 Mb setMedia 3 ms 375 ms 0.23 Mb 15.96 Mb postProcess 0 ms 375 ms - Mb 15.96 Mb initHeader 0 ms 375 ms 0.01 Mb 15.97 Mb initContent 2746ms 3121 ms 7.03 Mb 23.74 Mb initFooter 315ms 3436 ms 0.57 Mb 24.30 Mb display 286ms 3722 ms 0.75 Mb 24.94 Mb

Hook Time Memory Usage hookdisplayHomeTab 69 ms 0.25 Mb __construct 65 ms 5.25 Mb hookleftcolumn 24 ms 0.50 Mb hookfooter 19 ms - Mb hooktop 19 ms 0.25 Mb hookdisplayHomeTabContent 10 ms - Mb hookdisplayNav 10 ms - Mb hookheader 9 ms - Mb hookdisplayHeader 5 ms 0.25 Mb hookdisplayTop 4 ms - Mb hookhome 4 ms - Mb hookdisplayFooter 4 ms 0.25 Mb hookdisplayLeftColumn 2 ms - Mb hookdisplayTopColumn 1 ms - Mb hookdisplayHome 1 ms - Mb 15 hooks 246 ms 6.75 Mb

Module Time Memory Usage homefeatured 33 ms - Mb blockbestsellers 28 ms 0.25 Mb blocknewproducts 26 ms 0.50 Mb blockcart 17 ms 0.25 Mb blockcategories 17 ms 0.25 Mb blocknewsletter 14 ms 1.50 Mb blockviewed 13 ms 0.25 Mb blockcms 13 ms 0.25 Mb blocktopmenu 11 ms 0.50 Mb themeconfigurator 10 ms 0.50 Mb blocksearch 8 ms - Mb blockcmsinfo 7 ms - Mb blockcontact 5 ms - Mb blocksocial 5 ms 0.50 Mb blockmyaccountfooter 5 ms - Mb blockcontactinfos 5 ms 0.25 Mb mailalerts 5 ms 0.50 Mb blockcurrencies 5 ms - Mb blockuserinfo 5 ms 0.25 Mb statsdata 4 ms 0.25 Mb blocklanguages 4 ms 0.25 Mb producttooltip 3 ms 0.25 Mb socialsharing 2 ms 0.25 Mb blockmyaccount 1 ms - Mb sendtoafriend 1 ms - Mb 25 modules 246 ms 6.75 Mb

1. 
    

Stopwatch SQL - 24 queries Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) 90.4 55760     /classes/Configuration.php:148 SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name 1.6 0     /classes/Hook.php:131 SELECT SQL_NO_CACHE value FROM ps_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1 0.5 1     /classes/cache/CacheFs.php:36 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='71f5bc3f12fad16e37ec01aa2c4f50db' AND cache_id="blockcategories|1|16|2|3" AND compile_id="" LIMIT 1 0.5 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 0.5 1     /classes/shop/Shop.php:1067 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='fa775351b67a7de87433f3215374e3e5' AND cache_id="blockcategories|1|16|3" AND compile_id="" LIMIT 1 0.5 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d39cce67c4e625c50691e79158062d36' AND cache_id="blockcmsinfo|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d923048222abd57d01c7fe9fe34772c5' AND cache_id="blockbestsellers-tab|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='26dbb603bbedf1bb8feadeb2705c8501' AND cache_id="blockcms|2|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='106a8f01c73d438493351e660d0b610e' AND cache_id="homefeatured-tab|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d2d2e1f213a449c0f6c87fdb4aa4a32d' AND cache_id="blockmyaccountfooter|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a00091e06a64af943f5874e34f1faa8d' AND cache_id="blockcontactinfos|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d3b8d38c87b4b1bebdbbbb6c38f48a66' AND cache_id="blocknewproducts-tab|20160710|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='26dbb603bbedf1bb8feadeb2705c8501' AND cache_id="blockcms|0|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 0.4 1     /classes/SmartyCustom.php:95 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='46e4eda5566fe4380b1ae70fd9e63b69' AND cache_id="blockcontact|1|16" AND compile_id="" LIMIT 1 0.4 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='455fc153e25d91deebb2ea81118bc2a5' AND cache_id="blocksocial|1|16" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='343e11da50e79b141869be2c5910c6ac' AND cache_id="blocktopmenu|1|16|index" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a1b03d0233ae48cce96a259f9db3766a' AND cache_id="homefeatured|1|16" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='0fa52274fcd44a9653c046537fffdea6' AND cache_id="blocksearch-top|1|16" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='7baae86ed1d8e4a8309591a52818503b' AND cache_id="blocknewproducts-home|20160710|1|16" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d15c21be52d104666630aef62dfb8a68' AND cache_id="blockbestsellers-home|1|16" AND compile_id="" LIMIT 1 0.3 1     /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1) 0.3 20     /classes/module/Module.php:2142 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 0.3 1     /classes/SmartyCustom.php:142

Doubles 2 SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
                            WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX" AND compile_id="" LIMIT XX

Tables stress 17 smarty_lazy_cache 3 configuration 2 hook 2 smarty_last_flush 1 hook_alias 1 configuration_lang 1 hook_module_exceptions

 

 

[WEBDVL]

Skusal si aktualizovat? Tie aktualizacie sa nerobia len na to aby si mal vyssie cislo verzie ale odstranuju chyby....

[ČeskáPresta.cz]

Custom moduly/upravy? Jaky pouzivate hosting? URL?

[Hans_k]

Osobně bych viděl problém v nastavení hostingu.