Soromap

Bonjour, J'aurais besoin d'aide pour un souci de lenteur du chargement du Back-Office de presta 1.5.6.2 : - Chargement des pages du BO de 10s à 20s (selon la page) - Le front-office charge très rapidement. - tous les modules de stats sont désactivés. - J'ai déjà testé avec et sans le cache d'activé. - Le site est installé sur un serveur Ubuntu avec LAMP en local (Intel Xeon E5502 1.87GHz, 2 Go RAM) - J'ai aussi testé une nouvelle installation de prestashop 1.4.11.0, 1.5.4.1 et 1.6.0.6 : Sur la version 1.4.11.0, pas de problème, back-office est rapide (moins d'une seconde) mais le thème voulu n'est pas compatible. Sur les versions 1.5.4.1 et 1.6.0.6 le back-office est aussi lent à charger. ------------------------------------------------------------------------------------------------------------------------------ Ma configuration : Informations à propos de votre configuration Informations sur votre serveurInformations sur votre serveur: Linux #119-Ubuntu SMP Wed Feb 19 01:20:04 UTC 2014 i686 Version du logiciel serveur: Apache Version de PHP: 5.3.2-1ubuntu4.24 Limite de mémoire: 128M Temps d'exécution maximal (max_execution_time): 120 Informations sur la base de donnéesVersion de MySQL: 5.1.73-0ubuntu0.10.04.1 Moteur MySQL: InnoDB Préfixe des tables: ps_ Informations sur votre boutiqueVersion de PrestaShop: 1.5.6.2 URL de votre boutique: http://test.protecwood.com/ Nom du thème utilisé: deco_evo Informations sur la configuration mailMéthode d'envoi de mail: Vous utilisez la fonction mail() de PHP Vos informationsInformations vous concernant: Mozilla/5.0 (Windows NT 5.1; rv:28.0) Gecko/20100101 Firefox/28.0 Vérifier votre configuration Paramètres requis: OK Paramètres optionnels: OK Liste des fichiers modifiés Aucun changement n'a été détecté sur vos fichiers ------------------------------------------------------------------------------------------------------------------------------ J'ai mis PS_DEBUG_PROFILING à true, voila le resultat : PrestaShop™ 1.5.6.2 Temps de chargement22.597s Questions / Renseignements / Formations : +33 (0)1.40.18.30.04 | Contact | Bug Tracker | Forum | Addons Load time: 22.597s You'd better run your shop on a toaster config: 44ms constructor: 0ms init: 13ms checkAccess: 0ms setMedia: 2ms postProcess: 0ms initHeader: 7ms initContent: 16.408s initFooter: 0ms display: 6.122s Hook processing: 4ms / 0.07 Mb moduleRoutes: 3ms / 0.06 Mb displayAdminHomeQuickLinks: 0ms / 0 Mb actionDispatcher: 0ms / 0 Mb actionAdminControllerSetMedia: 0ms / 0 Mb displayBackOfficeFooter: 0ms / 0 Mb displayAdminHomeStatistics: 0ms / 0 Mb displayAdminHomeInfos: 0ms / 0 Mb displayBackOfficeHeader: 0ms / 0 Mb displayBackOfficeTop: 0ms / 0 Mb displayBackOfficeHome: 0ms / 0 Mb Memory peak usage: 5.8 Mb config: 2.92 Mb (2.9 Mb) constructor: 0 Mb (2.9 Mb) init: 1.37 Mb (4.3 Mb) checkAccess: 0 Mb (4.3 Mb) setMedia: 0.06 Mb (4.4 Mb) postProcess: 0 Mb (4.4 Mb) initHeader: 0.37 Mb (4.7 Mb) initContent: 0.72 Mb (5.6 Mb) initFooter: 0 Mb (5.6 Mb) display: 0.13 Mb (5.8 Mb) Total cache size (in Cache class): 0.12 Mb DB type: DbPDO SQL Queries: 42 queries Time spent querying: 12ms Included files: 69 Size of included files: 1.54 Mb Globals (> 1 Ko only): 993 Ko _LANGADM ≈ 981.2 Ko _SERVER ≈ 6.5 Ko _COOKIE ≈ 1.4 Ko Go to Stopwatch Go to Doubles Go to Tables Go to ObjectModels Display queries table Stopwatch (with SQL_NO_CACHE) (total = 42)2.353 ms 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) in /srv/www/test.protecwood.com/classes/Configuration.php:116 478 rows browsed0.939 ms SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` WHERE ((SELECT COUNT(*) FROM ps_module_shop ms WHERE ms.id_module = m.id_module AND ms.id_shop IN (1)) = 1) AND (h.name != "displayPayment") AND (hm.id_shop = 1) ORDER BY hm.`position` in /srv/www/test.protecwood.com/classes/Hook.php:339 36 rows browsed0.939 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) ORDER BY t.`position` ASC in /srv/www/test.protecwood.com/classes/Tab.php:246 USING FILESORT - 101 rows browsed0.492 ms SELECT SQL_NO_CACHE *, ( SELECT osl.`name` FROM `ps_order_state_lang` osl WHERE osl.`id_order_state` = o.`current_state` AND osl.`id_lang` = 1 LIMIT 1 ) AS `state_name` FROM `ps_orders` o LEFT JOIN `ps_customer` c ON (c.`id_customer` = o.`id_customer`) WHERE 1 AND o.id_shop IN (1) ORDER BY o.`date_add` DESC LIMIT 0, 10 in /srv/www/test.protecwood.com/classes/order/Order.php:882 USING FILESORT - 1 row browsed0.4 ms SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC in /srv/www/test.protecwood.com/classes/Dispatcher.php:426 USING FILESORT - 26 rows browsed0.337 ms SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name in /srv/www/test.protecwood.com/classes/shop/Shop.php:622 USING FILESORT - 1 row browsed0.332 ms SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'test.protecwood.com' OR su.domain_ssl = 'test.protecwood.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC in /srv/www/test.protecwood.com/classes/shop/Shop.php:320 USING FILESORT - 1 row browsed0.269 ms SELECT SQL_NO_CACHE SUM(total_paid / conversion_rate) as total_converted, left(invoice_date, 10) as invoice_date FROM ps_orders o WHERE valid = 1 AND total_paid > 0 AND invoice_date BETWEEN '2014-04-07 00:00:00' AND '2014-04-14 16:04:09' AND id_shop IN (1) GROUP BY DATE(invoice_date) in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:398 USING FILESORT - 1 row browsed0.269 ms SELECT SQL_NO_CACHE module FROM ps_tab_module_preference WHERE `id_tab` = 1 AND `id_employee` = 1 in /srv/www/test.protecwood.com/classes/Tab.php:534 1 row browsed0.268 ms SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/Language.php:805 1 row browsed0.263 ms SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:1244 1 row browsed0.245 ms SELECT SQL_NO_CACHE SUM(pv.`counter`) AS total_viewed FROM `ps_page_viewed` pv LEFT JOIN `ps_date_range` dr ON pv.`id_date_range` = dr.`id_date_range` LEFT JOIN `ps_page` p ON pv.`id_page` = p.`id_page` LEFT JOIN `ps_page_type` pt ON pt.`id_page_type` = p.`id_page_type` WHERE pt.`name` = 'product' AND dr.`time_start` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND dr.`time_end` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:332 1 row browsed0.235 ms SELECT SQL_NO_CACHE * FROM `ps_hook_alias` in /srv/www/test.protecwood.com/classes/Hook.php:182 86 rows browsed0.234 ms SELECT SQL_NO_CACHE * FROM `ps_quick_access` qa LEFT JOIN `ps_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC in /srv/www/test.protecwood.com/classes/QuickAccess.php:65 USING FILESORT - 5 rows browsed0.234 ms SELECT SQL_NO_CACHE * FROM `ps_employee` a LEFT JOIN `ps_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.233 ms SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/shop/Shop.php:199 1 row browsed0.231 ms SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab` in /srv/www/test.protecwood.com/classes/Tab.php:276 101 rows browsed0.23 ms SELECT SQL_NO_CACHE IFNULL(SUM(`total_paid_real` / conversion_rate), "0") as total_sales, COUNT(*) as total_orders FROM `ps_orders` WHERE valid = 1 AND `invoice_date` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:313 1 row browsed0.217 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.21 ms SELECT SQL_NO_CACHE t.`class_name`, t.`module` FROM `ps_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != "" in /srv/www/test.protecwood.com/classes/Tab.php:222 101 rows browsed0.201 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers in /srv/www/test.protecwood.com/classes/cache/CacheMemcache.php:202 1 row browsed0.186 ms SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 8) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.183 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_REWRITING_SETTINGS" LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:45 1 row browsed0.182 ms SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.169 ms SELECT SQL_NO_CACHE * FROM `ps_tab` t LEFT JOIN `ps_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/Tab.php:203 1 row browsed0.169 ms SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) in /srv/www/test.protecwood.com/classes/Language.php:698 1 row browsed0.167 ms SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.162 ms SELECT SQL_NO_CACHE COUNT(`id_customer`) AS total_registrations FROM `ps_customer` c WHERE c.`date_add` BETWEEN '2014-04-01 00:00:00' AND '2014-04-31 23:59:59' AND id_shop IN (1) LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:320 1 row browsed0.156 ms SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/shop/ShopUrl.php:154 1 row browsed0.156 ms SELECT SQL_NO_CACHE * FROM `ps_country_lang` WHERE `id_country` = 8 in /srv/www/test.protecwood.com/classes/ObjectModel.php:219 1 row browsed0.154 ms SELECT SQL_NO_CACHE `id_employee` FROM `ps_employee` WHERE `id_employee` = 1 AND `passwd` = 'cf97a074d2703875dcfab8f9f68175f7' AND active = 1 LIMIT 1 in /srv/www/test.protecwood.com/classes/Employee.php:223 1 row browsed0.153 ms SELECT SQL_NO_CACHE date_upd FROM ps_configuration WHERE name = "PS_HTACCESS_CACHE_CONTROL" LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:60 1 row browsed0.149 ms SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.147 ms SELECT SQL_NO_CACHE id_shop FROM `ps_employee_shop` WHERE `id_employee` = 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:1291 1 row browsed0.145 ms SELECT SQL_NO_CACHE * FROM `ps_tab_lang` WHERE `id_tab` = 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:219 1 row browsed0.143 ms SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.139 ms SELECT SQL_NO_CACHE * FROM `ps_tab` a WHERE (a.id_tab = 1) LIMIT 1 in /srv/www/test.protecwood.com/classes/ObjectModel.php:212 1 row browsed0.127 ms SELECT SQL_NO_CACHE `id_parent` FROM `ps_tab` WHERE LOWER(class_name) = 'adminhome' LIMIT 1 in /srv/www/test.protecwood.com/classes/Tab.php:178 101 rows browsed0.113 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` LIKE "%pending%" LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:257 1 row browsed0.113 ms SELECT SQL_NO_CACHE COUNT(*) FROM `ps_customer_thread` WHERE `status` = "open" LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:256 1 row browsed0.104 ms SELECT SQL_NO_CACHE COUNT(*) FROM ps_customer_thread LIMIT 1 in /srv/www/test.protecwood.com/controllers/admin/AdminHomeController.php:255 1 row browsed0.097 ms SELECT SQL_NO_CACHE * FROM ps_memcached_servers in /srv/www/test.protecwood.com/classes/cache/CacheMemcache.php:202 1 row browsed Doubles (IDs replaced by "XX") (total = 1)2 SELECT * FROM ps_memcached_servers Tables stress6 tab4 shop4 shop_url3 tab_lang3 orders3 lang_shop3 lang3 configuration3 customer_thread2 customer2 currency_shop2 shop_group2 memcached_servers2 employee_shop2 country_lang2 country2 country_shop2 employee1 tab_module_preference1 order_state_lang1 date_range1 page_viewed1 page1 page_type1 quick_access_lang1 hook_alias1 hook_module1 module1 configuration_lang1 theme1 hook1 module_shop1 currency1 meta_lang1 meta1 quick_access ObjectModel instances2 Currency2 Country1 Tab1 ShopGroup1 Language1 Employee1 Shop Included files1 adminPW/index.php 2 config/config.inc.php 3 config/defines.inc.php 4 config/settings.inc.php 5 config/autoload.php 6 config/alias.php 7 classes/Autoload.php 8 cache/class_index.php 9 tools/profiling/Controller.php 10 classes/controller/Controller.php 11 tools/profiling/ObjectModel.php 12 classes/ObjectModel.php 13 tools/profiling/Hook.php 14 classes/Hook.php 15 tools/profiling/Db.php 16 classes/db/Db.php 17 tools/profiling/Tools.php 18 classes/Tools.php 19 classes/Context.php 20 classes/shop/Shop.php 21 classes/db/DbPDO.php 22 classes/cache/Cache.php 23 classes/cache/CacheMemcache.php 24 classes/Validate.php 25 classes/db/DbQuery.php 26 config/defines_uri.inc.php 27 classes/Configuration.php 28 classes/Language.php 29 classes/Country.php 30 classes/Collection.php 31 classes/Cookie.php 32 classes/Rijndael.php 33 classes/Employee.php 34 classes/Link.php 35 classes/shop/ShopUrl.php 36 config/smarty.config.inc.php 37 tools/smarty/Smarty.class.php 38 tools/smarty/sysplugins/smarty_internal_data.php 39 tools/smarty/sysplugins/smarty_internal_templatebase.php 40 tools/smarty/sysplugins/smarty_internal_template.php 41 tools/smarty/sysplugins/smarty_resource.php 42 tools/smarty/sysplugins/smarty_internal_resource_file.php 43 tools/smarty/sysplugins/smarty_cacheresource.php 44 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 45 config/smartyadmin.config.inc.php 46 adminPW/functions.php 47 ./images.inc.php 48 classes/Dispatcher.php 49 classes/Tab.php 50 controllers/admin/AdminHomeController.php 51 classes/controller/AdminController.php 52 classes/Translate.php 53 translations/fr/admin.php 54 classes/Profile.php 55 classes/Currency.php 56 classes/Media.php 57 classes/QuickAccess.php 58 classes/helper/Helper.php 59 classes/shop/ShopGroup.php 60 classes/module/Module.php 61 classes/Upgrader.php 62 classes/Chart.php 63 classes/order/Order.php 64 cache/smarty/compile/93/17/6f/93176fecf88d4fba3de0b9a656d3385c050fa6d2.file.optimizationTips.tpl.php 65 cache/smarty/compile/65/3d/ee/653deed35ad5f13530df3e5026ffa5a35601aea6.file.content.tpl.php 66 cache/smarty/compile/b5/d6/99/b5d69928a1a6a7f1f7379dac2576419cc7c5df9a.file.layout.tpl.php 67 cache/smarty/compile/67/25/82/6725826279815b2a1741aca643541569c78605ac.file.header.tpl.php 68 tools/smarty/plugins/modifier.escape.php 69 cache/smarty/compile/0a/48/47/0a4847d5c9fd4a46ac29fb09959b1c64dc48b298.file.footer.tpl.php ------------------------------------------------------------------------------------------------------------------------------ Merci d'avoir pris le temps de me lire ;-) Cordialement, Stephen Bousquet

Bonjour, Pouvez-vous me dire si le module peut fonctionner directement avec la saisie de la référence d'une déclinaison d'un produit ? Je n’ai pas eu l'impression que ce soit le cas dans la démo. Cordialement,