Jump to content

Back and front office very slow loading

5haun

By 5haun
in OUT - 1.6.0.7 [17 Jun 2014]

 Share

Recommended Posts

5haun Newbie

5haun

Posted
Posted

Hey guys

Why is everything so slow?

Load time: 4.708s
You'd better run your shop on a toaster
  • config: 425ms
  • constructor: 0ms
  • init: 69ms
  • checkAccess: 0ms
  • setMedia: 11ms
  • postProcess: 0ms
  • initHeader: 0ms
  • initContent: 2.861s
  • initFooter: 371ms
  • display: 970ms
Hook processing: 3.315s / 17.1 Mb
52 methods called in 32 modules
  • displayTop: 2.064s / 6.27 Mb
  • displayHomeTab: 512ms / 0.19 Mb
  • displayFooter: 371ms / 0.98 Mb
  • displayHeader: 227ms / 8.7 Mb
  • displayNav: 82ms / 0.16 Mb
  • displayHomeTabContent: 23ms / 0.41 Mb
  • displayLeftColumn: 17ms / 0.13 Mb
  • displayHome: 17ms / 0.2 Mb
  • displayTopColumn: 3ms / 0.05 Mb
  • moduleRoutes: 0ms / 0 Mb
  • actionFrontControllerSetMedia: 0ms / 0 Mb
  • actionDispatcher: 0ms / 0 Mb
  • displayBanner: 0ms / 0 Mb
  • DisplayOverrideTemplate: 0ms / 0 Mb
Memory peak usage: 33.4 Mb
  • config: 10.38 Mb (10.5 Mb)
  • constructor: 0 Mb (10.5 Mb)
  • init: 4.68 Mb (15.2 Mb)
  • checkAccess: 0 Mb (15.2 Mb)
  • setMedia: 0.32 Mb (15.5 Mb)
  • postProcess: 0 Mb (15.5 Mb)
  • initHeader: 0.01 Mb (15.5 Mb)
  • initContent: 15.93 Mb (31.5 Mb)
  • initFooter: 0.99 Mb (32.5 Mb)
  • display: 0.72 Mb (33.4 Mb)


Total cache size (in Cache class): 0 Mb
DB type: DbPDO
SQL Queries: 20 queries
Time spent querying: 917ms
Included files: 207
Size of included files: 2.62 Mb
Globals (> 1 Ko only): 401 Ko
  • _LANG ≈ 192.9 Ko
  • _MODULES ≈ 165.1 Ko
  • HTTP_SERVER_VARS ≈ 8.1 Ko
  • _SERVER ≈ 8.1 Ko
  • HTTP_ENV_VARS ≈ 7.1 Ko
  • _ENV ≈ 7.1 Ko
  • _MODULE ≈ 4.8 Ko
  • _REQUEST ≈ 1.1 Ko
  • HTTP_COOKIE_VARS ≈ 1.1 Ko
  • _COOKIE ≈ 1.1 Ko
Stopwatch (with SQL_NO_CACHE) (total = 20)
449.389 ms SELECT p.id_product, MAX(product_attribute_shop.id_product_attribute) id_product_attribute, pl.`link_rewrite`, pl.`name`, pl.`description_short`, MAX(image_shop.`id_image`) id_image, il.`legend`, ps.`quantity` AS sales, p.`ean13`, p.`upc`, cl.`link_rewrite` AS category, p.show_price, p.available_for_order, IFNULL(stock.quantity, 0) as quantity, p.customizable, IFNULL(pa.minimal_quantity, p.minimal_quantity) as minimal_quantity, stock.out_of_stock, product_shop.`date_add` > "2014-05-29" as new FROM `qug_product_sale` ps LEFT JOIN `qug_product` p ON ps.`id_product` = p.`id_product` INNER JOIN qug_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `qug_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN qug_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1) LEFT JOIN qug_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `qug_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `qug_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN qug_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `qug_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `qug_category_lang` cl ON cl.`id_category` = product_shop.`id_category_default` AND cl.`id_lang` = 1 AND cl.id_shop = 1 WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND p.`id_product` IN (13,14) GROUP BY product_shop.id_product ORDER BY sales DESC LIMIT 0, 8
in /classes/ProductSale.php:207
USING FILESORT - 2 rows browsed
178.627 ms SELECT `id_address` FROM qug_address a WHERE a.`id_address` = 0 LIMIT 1
in /classes/Address.php:321
0 rows browsed
81.755 ms SELECT id_feature, id_product, id_feature_value FROM `qug_feature_product` WHERE `id_product` IN (13,14)
in /classes/Product.php:3354
1 row browsed
80.886 ms SELECT * FROM `qug_cart_cart_rule` cd LEFT JOIN `qug_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `qug_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 34 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
47.161 ms SELECT `id_hook`, `name` FROM `qug_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `qug_hook_alias` ha INNER JOIN `qug_hook` h ON ha.name = h.name
in /classes/Hook.php:131
0 rows browsed
17.324 ms SELECT `reduction` FROM `qug_product_group_reduction_cache` WHERE `id_product` = 14 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
12.755 ms SELECT * FROM `qug_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1705
1 row browsed
10.101 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `qug_image_type` WHERE `name` LIKE 'home_default-bootstrap' LIMIT 1
in /classes/ImageType.php:141
1 row browsed
9.331 ms SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0)) AS unique_id, cp.id_address_delivery, product_shop.`wholesale_price`, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, NULL AS customization_quantity, NULL AS id_customization, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ pa.`weight`) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, pai.`id_image` as pai_id_image, il.`legend` as pai_legend, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity FROM `qug_cart_product` cp LEFT JOIN `qug_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `qug_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `qug_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `qug_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `qug_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN qug_stock_available stock ON (stock.id_product = cp.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 ) LEFT JOIN `qug_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `qug_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `qug_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `qug_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 34) AND (p.`id_product` IS NOT NULL) GROUP BY unique_id ORDER BY p.`id_product`, cp.`id_product_attribute`, cp.`date_add` ASC
in /classes/Cart.php:508
USING FILESORT - 4 rows browsed
Useless GROUP BY need to be removed
7.274 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `qug_image_type` WHERE `name` LIKE 'default-bootstrap_home' LIMIT 1
in /classes/ImageType.php:141
1 row browsed
6.022 ms SELECT `reduction` FROM `qug_product_group_reduction_cache` WHERE `id_product` = 13 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
3.758 ms SELECT 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 `qug_configuration` c LEFT JOIN `qug_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
in /classes/Configuration.php:118
314 rows browsed
3.577 ms SELECT SUM(`quantity`) FROM `qug_cart_product` WHERE `id_product` = 13 AND `id_cart` = 34 LIMIT 1
in /classes/Product.php:2553
1 row browsed
2.135 ms SELECT * FROM `qug_cart_cart_rule` cd LEFT JOIN `qug_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `qug_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 34 AND gift_product != 0 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.841 ms SELECT * FROM `qug_cart_cart_rule` cd LEFT JOIN `qug_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `qug_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 34 AND free_shipping = 1 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.768 ms SELECT * FROM `qug_cart_cart_rule` cd LEFT JOIN `qug_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `qug_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 34 AND (reduction_percent != 0 OR reduction_amount != 0) ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.464 ms SELECT * FROM `qug_cart` a WHERE (a.id_cart = 34) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.878 ms SELECT value FROM qug_configuration WHERE name= 'PS_CACHEFS_DIRECTORY_DEPTH' LIMIT 1
in /classes/cache/CacheFs.php:36
1 row browsed
0.754 ms SELECT SUM(`quantity`) FROM `qug_cart_product` WHERE `id_product` = 14 AND `id_cart` = 34 LIMIT 1
in /classes/Product.php:2553
1 row browsed
0.754 ms SELECT SUM(`quantity`) FROM `qug_cart_product` WHERE `id_product` = 14 AND `id_cart` = 34 LIMIT 1
in /classes/Product.php:2553
1 row browsed

 

Link to comment
Share on other sites
El Patron Mentor

El Patron

Posted
Posted

If you don't or cannot change your host provider you can install a cache module like mine but their are others.

 

these are good cache modules but don't forget about us 3rd party developers, (to shy for addon's).  JavaPro for your front office and BoZoom (only back office performance module in the world).

 

@joe...I've seen your work on customers shops (they tend to be speed freaks), and yes cache modules really help!  When combined with JavaPro for example, many can sit on shared servers (if the have gzip/mod_expires) and save loads of money not having to use vps/dedicated.  (we rock)..

  • Like 1
Link to comment
Share on other sites
JPresta.com Rookie

JPresta.com

Posted
Posted

@joe...I've seen your work on customers shops (they tend to be speed freaks), and yes cache modules really help!  When combined with JavaPro for example, many can sit on shared servers (if the have gzip/mod_expires) and save loads of money not having to use vps/dedicated.  (we rock)..

For sure we rock  :D

Link to comment
Share on other sites
5haun Newbie

5haun

Posted
  • Author
Posted

can you provide front office url (you can later delete it by editing your post) ,it may be something rather simple or as you said hosting.

 

 

If you don't or cannot change your host provider you can install a cache module like mine but their are others.

 

 

As more gets added to prestashop it naturally is going to run slower.    But slow host is  usually the biggest issue.    Some of the cach options i actually run faster with them disabled. 

 

Thanks for all the feedback. I changed my hosting package - everything is a lot faster. I will also tweak the performance settings some more.

 

Cheers

  • Like 1
Link to comment
Share on other sites
 Share
Go to topic listing
×
×
  • Create New...