Jump to content

Front office very slow 1.6.0.6

sodypop

By sodypop
in OUT - 1.6.0.11 [7 Jan 2015]

 Share

Recommended Posts

sodypop Newbie

sodypop

Posted
Posted (edited)

Below is a bug report from one of the front office pages.  Any suggestions to fix would be appreciated.

 

http://sweetsodypop.com/13-medium

 

Load time: 14.775s
You'd better run your shop on a toaster
  • config: 238ms
  • constructor: 0ms
  • init: 273ms
  • checkAccess: 0ms
  • setMedia: 73ms
  • postProcess: 0ms
  • initHeader: 0ms
  • initContent: 5.906s
  • initFooter: 278ms
  • display: 8.006s
Hook processing: 6.293s / 24.79 Mb
92 methods called in 42 modules
  • displayTop: 4.456s / 7.19 Mb
  • displayLeftColumn: 885ms / 2.36 Mb
  • displayHeader: 309ms / 12.7 Mb
  • displayFooter: 278ms / 0.75 Mb
  • displayNav: 270ms / 0.22 Mb
  • actionCartSave: 50ms / 1.42 Mb
  • displayProductListReviews: 35ms / 0.06 Mb
  • displayBanner: 4ms / 0.06 Mb
  • displayProductListFunctionalButtons: 2ms / 0.02 Mb
  • actionProductListOverride: 2ms / 0 Mb
  • displayTopColumn: 1ms / 0 Mb
  • moduleRoutes: 0ms / 0 Mb
  • DisplayOverrideTemplate: 0ms / 0 Mb
  • actionDispatcher: 0ms / 0 Mb
  • actionProductListModifier: 0ms / 0 Mb
  • actionObjectUpdateAfter: 0ms / 0 Mb
  • actionObjectUpdateBefore: 0ms / 0 Mb
  • actionFrontControllerSetMedia: 0ms / 0 Mb
  • actionObjectCartUpdateAfter: 0ms / 0 Mb
  • actionObjectCartUpdateBefore: 0ms / 0 Mb

Memory peak usage: 46.4 Mb

  • config: 10.56 Mb (10.6 Mb)
  • constructor: 0 Mb (10.6 Mb)
  • init: 7.4 Mb (18.1 Mb)
  • checkAccess: 0 Mb (18.1 Mb)
  • setMedia: 0.49 Mb (18.6 Mb)
  • postProcess: 0 Mb (18.6 Mb)
  • initHeader: 0.01 Mb (18.6 Mb)
  • initContent: 23.66 Mb (42.3 Mb)
  • initFooter: 0.76 Mb (43.1 Mb)
  • display: 3.26 Mb (46.4 Mb)


Total cache size (in Cache class): 0 Mb
DB type: DbPDO 
SQL Queries: 236 queries 
Time spent querying: 1.364s
Included files: 264
Size of included files: 3.35 Mb
Globals (> 1 Ko only): 547 Ko
  • _MODULES ≈ 334.1 Ko
  • _LANG ≈ 188 Ko
  • _SERVER ≈ 9 Ko
  • _MODULE ≈ 3.8 Ko
  • _REQUEST ≈ 1.4 Ko
  • _COOKIE ≈ 1.4 Ko

 

Stopwatch (with SQL_NO_CACHE) (total = 236)
95.481 ms SELECT * FROM `miz_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 3 AND `id_state` IN (0, 3) AND ('85212' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '85212'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed
93.709 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 12 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
88.196 ms SELECT `name` FROM `miz_country_lang` WHERE `id_lang` = 1 AND `id_country` = 21 LIMIT 1
in /classes/Country.php:205
1 row browsed
72.491 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 11) AND (id_product_attribute = 75) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
58.03 ms SELECT s.* FROM `miz_scene_category` sc LEFT JOIN `miz_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN miz_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `miz_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 13 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
in /classes/Scene.php:217
USING FILESORT - 1 row browsed
46.439 ms SELECT * FROM `miz_currency` c INNER JOIN miz_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
in /classes/Currency.php:219
USING FILESORT - 1 row browsed
43.788 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 18 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
41.978 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 13 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
39.53 ms SELECT b.`id_blocklink`, b.`url`, b.`new_window` FROM `miz_blocklink` b
in /modules/blocklink/blocklink.php:179
2 rows browsed
38.126 ms SELECT * FROM `miz_customer` WHERE `email` = ''
in /modules/sendinblue/sendinblue.php:3200
1 row browsed
36.722 ms SELECT c.id_carrier FROM `miz_warehouse_carrier` wc INNER JOIN `miz_carrier` c ON c.id_reference = wc.id_carrier WHERE (id_warehouse = 0) AND (c.deleted = 0)
in /classes/stock/Warehouse.php:147
1 row browsed
36.082 ms SELECT * FROM `miz_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330
USING FILESORT - 7 rows browsed
36.044 ms SELECT * FROM `miz_carrier` a LEFT JOIN `miz_carrier_lang` `b` ON a.id_carrier = b.id_carrier AND b.id_lang = 1 LEFT JOIN `miz_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 27) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
34.477 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
33.149 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 24 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
31.636 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 16 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
30.988 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
30.176 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 25 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
27.94 ms SELECT c.*, cl.delay FROM `miz_carrier` c LEFT JOIN `miz_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `miz_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `miz_zone` z ON (z.`id_zone` = 2) INNER JOIN miz_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 AND cz.`id_zone` = 2 AND z.`active` = 1 AND c.id_carrier IN (SELECT id_carrier FROM miz_carrier_group WHERE id_group IN (1)) AND (c.is_module = 0 OR c.need_range = 1) GROUP BY c.`id_carrier` ORDER BY c.`position` ASC
in /classes/Carrier.php:453
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
27.018 ms SELECT image_shop.`id_image` id_image, il.`legend` FROM `miz_image` i JOIN `miz_image_shop` image_shop ON (i.id_image = image_shop.id_image AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `miz_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 11 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Cart.php:653
2 rows browsed
26.139 ms SELECT `id_hook`, `name` FROM `miz_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `miz_hook_alias` ha INNER JOIN `miz_hook` h ON ha.name = h.name
in /classes/Hook.php:131
0 rows browsed
24.062 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
23.115 ms SELECT `id_module` FROM `miz_module` WHERE `name` = "blocklayered" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed
21.078 ms SELECT 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 miz_shop_group gs LEFT JOIN miz_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN miz_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 /classes/shop/Shop.php:629
USING FILESORT - 1 row browsed
19.601 ms SELECT * FROM `miz_cart_cart_rule` cd LEFT JOIN `miz_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `miz_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 198 AND gift_product != 0 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
16.489 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 25) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
15.578 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 9 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
15.312 ms SELECT pa.id_product, a.color, pac.id_product_attribute, 0 qty FROM miz_product_attribute pa INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN miz_product_attribute_combination pac ON (pac.id_product_attribute = product_attribute_shop.id_product_attribute) JOIN miz_attribute a ON (a.id_attribute = pac.id_attribute) JOIN miz_attribute_group ag ON (ag.id_attribute_group = ag.id_attribute_group) WHERE pa.id_product IN (9,12) AND ag.is_color_group = 1 GROUP BY pa.id_product, color
in /classes/Product.php:3121
USING FILESORT - 20 rows browsed
Useless GROUP BY need to be removed
14.939 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 9 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
13.556 ms SELECT product_attribute_shop.`price` FROM `miz_product_attribute` pa INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 75 LIMIT 1
in /classes/Combination.php:320
1 row browsed
13.028 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 16) AND (id_product_attribute = 91) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
13.023 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 13) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
12.874 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 24) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
11.593 ms SELECT s.*, sl.`description` FROM `miz_supplier` s LEFT JOIN `miz_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN miz_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) ORDER BY s.`name` ASC
in /classes/Supplier.php:123
USING FILESORT - 1 row browsed
11.261 ms SELECT h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `miz_hook` h INNER JOIN `miz_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) INNER JOIN `miz_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
in /classes/Hook.php:228
USING FILESORT - 79 rows browsed
8.484 ms SELECT * FROM `miz_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC
in /modules/themeconfigurator/themeconfigurator.php:330
USING FILESORT - 7 rows browsed
7.153 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 11)
in /classes/Product.php:2701
5 rows browsed
6.817 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) 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`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB(NOW(), INTERVAL 45 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `miz_category_product` cp LEFT JOIN `miz_product` p ON p.`id_product` = cp.`id_product` INNER JOIN miz_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` pa ON (p.`id_product` = pa.`id_product`) LEFT JOIN miz_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 miz_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 `miz_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `miz_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `miz_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN miz_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 `miz_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `miz_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 13 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY product_shop.id_product ORDER BY cp.`position` asc LIMIT 0,30
in /classes/Category.php:706
USING FILESORT - 10 rows browsed
6.512 ms SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `miz_module` m INNER JOIN miz_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `miz_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `miz_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `miz_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `miz_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /classes/Hook.php:346
USING FILESORT - 74 rows browsed
Useless GROUP BY need to be removed
5.118 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 `miz_configuration` c LEFT JOIN `miz_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
in /classes/Configuration.php:118
279 rows browsed
3.863 ms SELECT l.`id_lang`, c.`link_rewrite` FROM `miz_category_lang` AS c LEFT JOIN `miz_lang` AS l ON c.`id_lang` = l.`id_lang` WHERE c.`id_category` = 13 AND l.`active` = 1
in /classes/Category.php:1261
1 row browsed
2.899 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 `miz_cart_product` cp LEFT JOIN `miz_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `miz_product_shop` product_shop ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `miz_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `miz_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 `miz_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 miz_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 `miz_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `miz_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 `miz_product_attribute_image` `pai` ON pai.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `miz_image_lang` `il` ON il.`id_image` = pai.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 198) 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 - 1 row browsed
Useless GROUP BY need to be removed
2.406 ms SELECT MAX(image_shop.id_image) id_image, p.id_product, il.legend, product_shop.active, pl.name, pl.description_short, pl.link_rewrite, cl.link_rewrite AS category_rewrite FROM miz_product p INNER JOIN miz_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN miz_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 ) LEFT JOIN miz_image i ON (i.id_product = p.id_product) LEFT JOIN miz_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 miz_image_lang il ON (il.id_image = image_shop.id_image) LEFT JOIN miz_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 ) WHERE p.id_product IN (12,11) AND pl.id_lang = 1 AND cl.id_lang = 1 GROUP BY product_shop.id_product
in /modules/blockviewed/blockviewed.php:109
USING FILESORT - 2 rows browsed
1.955 ms SELECT * FROM `miz_cart_cart_rule` cd LEFT JOIN `miz_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `miz_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 198 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.832 ms SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `miz_category` c INNER JOIN miz_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `miz_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `miz_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 13 AND `active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
in /classes/Category.php:585
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed
1.656 ms SELECT * FROM `miz_cart_cart_rule` cd LEFT JOIN `miz_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `miz_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 198 AND (reduction_percent != 0 OR reduction_amount != 0) ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.606 ms SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `miz_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `miz_module` m
in /classes/module/Module.php:205
79 rows browsed
1.333 ms SELECT t.name, COUNT(pt.id_tag) AS times FROM `miz_product_tag` pt LEFT JOIN `miz_tag` t ON (t.id_tag = pt.id_tag) LEFT JOIN `miz_product` p ON (p.id_product = pt.id_product) INNER JOIN miz_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE t.`id_lang` = 1 AND product_shop.`active` = 1 AND p.`id_product` IN ( SELECT cp.`id_product` FROM `miz_category_product` cp LEFT JOIN `miz_category_group` cg ON (cp.`id_category` = cg.`id_category`) WHERE cg.`id_group` = 1 ) GROUP BY t.id_tag ORDER BY times DESC LIMIT 10
in /classes/Tag.php:157
USING FILESORT - 10 rows browsed
1.296 ms SELECT * FROM `miz_cart_cart_rule` cd LEFT JOIN `miz_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `miz_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 198 AND free_shipping = 1 ORDER by cr.priority ASC
in /classes/Cart.php:348
USING FILESORT - 1 row browsed
1.233 ms SELECT m.page, ml.url_rewrite, ml.id_lang FROM `miz_meta` m LEFT JOIN `miz_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC
in /classes/Dispatcher.php:461
USING FILESORT - 34 rows browsed
1.19 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 11) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
1.15 ms SELECT * FROM `miz_category` a LEFT JOIN `miz_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `miz_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 2) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
1.146 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `miz_attribute` a LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `miz_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 11 AND pac.`id_product_attribute` = 75
in /classes/Product.php:5012
2 rows browsed
1.121 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 13) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
1.117 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
1.096 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 11) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
1.087 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 16 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
1.066 ms SELECT DISTINCT a.`id_attribute_group`, al.`name`, agl.`name` as `group` FROM `miz_attribute` a LEFT JOIN `miz_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `miz_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 11 AND pac.id_product_attribute = 75 AND a.`id_attribute` NOT IN(25)
in /classes/Product.php:5056
2 rows browsed
1.035 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 13 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
1.015 ms SELECT COUNT(DISTINCT c.id_currency) FROM `miz_currency` c LEFT JOIN miz_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1
in /classes/Currency.php:443
1 row browsed
0.999 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM miz_theme t LEFT JOIN miz_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN miz_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "category" LIMIT 1
in /classes/Theme.php:177
1 row browsed
0.997 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 12 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.994 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 16 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.984 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.972 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.967 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.961 ms SELECT COUNT(cp.`id_product`) AS total FROM `miz_product` p INNER JOIN miz_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 13 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
in /classes/Category.php:662
8 rows browsed
0.956 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 9) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.947 ms SELECT pac.`id_product_attribute`, agl.`public_name` AS public_group_name, al.`name` AS attribute_name FROM `miz_product_attribute_combination` pac LEFT JOIN `miz_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `miz_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `miz_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1 ) LEFT JOIN `miz_attribute_group_lang` agl ON ( ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1 ) WHERE pac.`id_product_attribute` IN (75) ORDER BY agl.`public_name` ASC
in /classes/Cart.php:717
USING FILESORT - 2 rows browsed
0.933 ms SELECT DISTINCT a.`id_attribute_group`, al.`name`, agl.`name` as `group` FROM `miz_attribute` a LEFT JOIN `miz_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `miz_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product` = 11 AND pac.id_product_attribute = 75 AND a.`id_attribute` NOT IN(25)
in /classes/Product.php:5056
2 rows browsed
0.931 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `miz_attribute` a LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `miz_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 11 AND pac.`id_product_attribute` = 75
in /classes/Product.php:5012
2 rows browsed
0.93 ms SELECT * FROM `miz_country` a LEFT JOIN `miz_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1 LEFT JOIN `miz_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 21) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.923 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.913 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Customer.php:11
USING FILESORT - 18 rows browsed
0.91 ms SELECT `id_country`, `id_state`, `vat_number`, `postcode` FROM `miz_address` WHERE `id_address` = 28 LIMIT 1
in /classes/Address.php:303
1 row browsed
0.909 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 25 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.907 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 16) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.898 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.895 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 24 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.894 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.889 ms SELECT COUNT(DISTINCT l.id_lang) FROM `miz_lang` l JOIN miz_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 /classes/Language.php:818
1 row browsed
0.888 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 18) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.878 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 18 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.876 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 9) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
0.876 ms SELECT count(distinct id_address_delivery) FROM `miz_cart_product` cp WHERE (id_cart = 198) LIMIT 1
in /classes/Cart.php:2307
1 row browsed
0.876 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 11 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.872 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 13 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.868 ms SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 12) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.86 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 9 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.844 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.842 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 24 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.84 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.837 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 13) AND (id_product_attribute = 85) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
0.837 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.836 ms SELECT * FROM `miz_group` a LEFT JOIN `miz_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1 WHERE (a.id_group = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.835 ms SELECT * FROM `miz_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed
0.83 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 24)
in /classes/Product.php:2701
5 rows browsed
0.814 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.809 ms SELECT * FROM `miz_category` a LEFT JOIN `miz_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `miz_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 13) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.807 ms SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = 11) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed
0.805 ms SELECT * FROM `miz_cart` a WHERE (a.id_cart = 198) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.802 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 25)
in /classes/Product.php:2701
2 rows browsed
0.792 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = 12 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:184
1 row browsed
0.787 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Customer.php:11
USING FILESORT - 18 rows browsed
0.778 ms SELECT * FROM `miz_carrier` a LEFT JOIN `miz_carrier_shop` `c` ON a.id_carrier = c.id_carrier AND c.id_shop = 1 WHERE (a.id_carrier = 27) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.776 ms SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 18 ORDER BY f.position ASC
in /classes/Product.php:4030
USING FILESORT - 2 rows browsed
0.775 ms SELECT * FROM `miz_cart_rule` cr LEFT JOIN `miz_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE ( cr.`id_customer` = 0 OR cr.group_restriction = 1 OR cr.`id_customer` = 0 ) AND cr.date_from < "2014-08-10 01:35:54" AND cr.date_to > "2014-08-10 01:35:54" AND cr.`active` = 1
in /classes/CartRule.php:266
3 rows browsed
0.759 ms SELECT * FROM `miz_product_lang` WHERE `id_product` = 11 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed
0.758 ms SELECT * FROM `miz_currency` a LEFT JOIN `miz_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1 WHERE (a.id_currency = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.756 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.748 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 13)
in /classes/Product.php:2701
5 rows browsed
0.743 ms SELECT s.`id_zone` AS id_zone_state, c.`id_zone` FROM `miz_address` a LEFT JOIN `miz_country` c ON c.`id_country` = a.`id_country` LEFT JOIN `miz_state` s ON s.`id_state` = a.`id_state` WHERE a.`id_address` = 28 LIMIT 1
in /classes/Address.php:250
1 row browsed
0.731 ms SELECT COUNT(*) FROM miz_store s INNER JOIN miz_store_shop store_shop ON (store_shop.id_store = s.id_store AND store_shop.id_shop = 1) LIMIT 1
in /modules/blockstore/blockstore.php:94
1 row browsed
0.718 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 16)
in /classes/Product.php:2701
4 rows browsed
0.717 ms SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM miz_shop_url su LEFT JOIN miz_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'sweetsodypop.com' OR su.domain_ssl = 'sweetsodypop.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /classes/shop/Shop.php:329
USING FILESORT - 1 row browsed
0.717 ms SELECT * FROM `miz_tax_rule` WHERE `id_country` = 21 AND `id_tax_rules_group` = 3 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed
0.716 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = 11 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /modules/productcomments/ProductComment.php:197
1 row browsed
0.711 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.71 ms SELECT c.id_category, cl.name, cl.link_rewrite FROM miz_category c LEFT JOIN miz_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) WHERE c.nleft <= 7 AND c.nright >= 8 AND c.nleft >= 2 AND c.nright <= 19 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
in /classes/Tools.php:1052
USING FILESORT - 10 rows browsed
0.707 ms SELECT SUM(`quantity`) FROM `miz_cart_product` WHERE `id_cart` = 198 LIMIT 1
in /classes/Cart.php:762
1 row browsed
0.706 ms SELECT * FROM `miz_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.697 ms SELECT l.*, ls.`id_shop` FROM `miz_lang` l LEFT JOIN `miz_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /classes/Language.php:711
1 row browsed
0.695 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Address.php:12
USING FILESORT - 18 rows browsed
0.694 ms SELECT * FROM `miz_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
0.693 ms SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = 1) WHERE a.`required` = 1 ORDER BY a.`position`
in /override/classes/Customer.php:11
USING FILESORT - 18 rows browsed
0.691 ms SELECT * FROM `miz_hook_alias`
in /classes/Hook.php:183
86 rows browsed
0.684 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 12)
in /classes/Product.php:2701
5 rows browsed
0.682 ms SELECT `id_lang`, `text` FROM miz_blocklink_lang WHERE `id_blocklink`=1
in /modules/blocklink/blocklink.php:192
1 row browsed
 
 
 
Doubles (IDs replaced by "XX") (total = 24)17 SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = XX) WHERE a.`required` = XX ORDER BY a.`position`16 SELECT SUM(quantity) FROM `miz_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX8 SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX8 SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `miz_product` p INNER JOIN `miz_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `miz_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT JOIN `miz_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)8 SELECT COUNT(`id_product_comment`) AS "nbr" FROM `miz_product_comment` pc WHERE `id_product` = XX AND `validate` = XX LIMIT XX8 SELECT * FROM `miz_product` a LEFT JOIN `miz_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `miz_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX8 SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX8 SELECT name, value, pf.id_feature FROM miz_feature_product pf LEFT JOIN miz_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN miz_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN miz_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN miz_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC8 SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `miz_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX8 SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `miz_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XXLIMIT XX8 SELECT product_attribute_shop.`price` FROM `miz_product_attribute` pa INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX4 SELECT * FROM `miz_tax_rule` WHERE `id_country` = XX AND `id_tax_rules_group` = XX AND `id_state` IN (XX, XX) AND ('XX' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = XX AND `zipcode_from` IN(XX, 'XX'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC3 SELECT * FROM `miz_advcheckout` a LEFT JOIN `miz_advcheckout_lang` al ON (a.`id_field` = al.`id_field` AND al.`id_lang` = XX) WHERE a.`required` = XX ORDER BY a.`position`2 SELECT `id_address` FROM miz_address a WHERE a.`id_address` = XX LIMIT XX2 SELECT data FROM `miz_layered_friendly_url` WHERE `url_key` = 'XXcXXfbXXbXXeXXadXXeXXcXXeXXaXX' LIMIT XX2 SELECT * FROM `miz_customer` a WHERE (a.id_customer = XX) LIMIT XX2 SELECT nleft, nright, level_depth FROM miz_category WHERE id_category = XX LIMIT XX2 SELECT cl.`link_rewrite` FROM `miz_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX2 SELECT g.`id_attribute_group`, g.`name` as `group` FROM `miz_attribute_group_lang` g LEFT JOIN `miz_attribute` a ON (a.`id_attribute_group` = g.`id_attribute_group`) WHERE a.`id_attribute` = XX AND g.`id_lang` = XX AND g.`name` IS NOT NULL2 SELECT DISTINCT a.`id_attribute_group`, al.`name`, agl.`name` as `group` FROM `miz_attribute` a LEFT JOIN `miz_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `miz_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX AND pac.id_product_attribute = XX AND a.`id_attribute` NOT IN(XX)2 SELECT g.`id_attribute_group`, g.`url_name` as `group` FROM `miz_layered_indexable_attribute_group_lang_value` g LEFT JOIN `miz_attribute` a ON (a.`id_attribute_group` = g.`id_attribute_group`) WHERE a.`id_attribute` =XX AND g.`id_lang` = XX AND g.`url_name` IS NOT NULL AND g.`url_name` != ''2 SELECT DISTINCT la.`id_attribute`, la.`url_name` as `name` FROM `miz_attribute` a LEFT JOIN `miz_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `miz_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN miz_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `miz_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = XX) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = XX AND pac.`id_product_attribute` = XX2 SELECT `id_lang`, `text` FROM miz_blocklink_lang WHERE `id_blocklink`=XX2 SELECT * FROM `miz_category` a LEFT JOIN `miz_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `miz_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XXWHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX
Edited by sodypop (see edit history)
Link to comment
Share on other sites
PrestaHeroes USA Mentor

PrestaHeroes USA

Posted
Posted

HI, just looking again at your shop this morning, what a first noticed was just a 'little' sluggish and actually pretty zippy.  This before doing anything below.

 

 

Then I looked at back office (supplied the other day) and changed ccc for .css and .js as follows

08.10.2014-09.08.png
http://screencast.com/t/9jCfbbIjXg

 

I then opened up module BoZoom and did 'some' java profiling for you.

 

Did you do something (I suspect host, or low use on your server by others) that accounts for faster fo/bo?

 

Note: it's better to open ticket with hosting rather than calling them.  This way if they get multiple issues they can better relate them to single issue.


also, are you using module block layered?  if not disable and/or uninstall it.

Link to comment
Share on other sites
sodypop Newbie

sodypop

Posted
  • Author
Posted

Thank you for your help.  The back office is still sluggish (especially when calling up the products).

 

For the front office I ran a web optimizer scan and found I needed to resize my images.  Doing that really sped things up on the front end.   The only slow part in the front now is the Shopping Cart area.

 

Brenda

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