Jump to content

Back 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
Here is the error report for the products page in the back office.  Can anyone tell me what changes I need to make?  Where?
 
Load time: 133.42s
You'd better run your shop on a toaster
  • config: 11.918s
  • constructor: 0ms
  • init: 6.167s
  • checkAccess: 0ms
  • setMedia: 19ms
  • postProcess: 645ms
  • initHeader: 545ms
  • initContent: 105.995s
  • initFooter: 324ms
  • display: 7.806s
Hook processing: 1.717s / 5.74 Mb
10 methods called in 10 modules
  • displayBackOfficeHeader: 1.695s / 4.51 Mb
  • actionAdminControllerSetMedia: 14ms / 0.96 Mb
  • displayBackOfficeFooter: 7ms / 0.26 Mb
  • displayAdminListBefore: 0ms / 0 Mb
  • displayAdminListAfter: 0ms / 0 Mb
  • actionAdminProductsListingFieldsModifier: 0ms / 0 Mb
  • moduleRoutes: 0ms / 0 Mb
  • actionDispatcher: 0ms / 0 Mb
  • actionAdminProductsOptionsModifier: 0ms / 0 Mb
  • actionAdminProductsListingResultsModifier: 0ms / 0 Mb
  • displayAdminProductsListAfter: 0ms / 0 Mb
  • displayAdminProductsListBefore: 0ms / 0 Mb
  • displayBackOfficeTop: 0ms / 0 Mb
Memory peak usage: 39 Mb
  • config: 15.34 Mb (18.1 Mb)
  • constructor: 0 Mb (18.1 Mb)
  • init: 6.38 Mb (22 Mb)
  • checkAccess: 0 Mb (22 Mb)
  • setMedia: 0.97 Mb (22.9 Mb)
  • postProcess: 0 Mb (22.9 Mb)
  • initHeader: 0.58 Mb (23.4 Mb)
  • initContent: 14.15 Mb (37.6 Mb)
  • initFooter: 0.06 Mb (37.6 Mb)
  • display: 1.05 Mb (39 Mb)


Total cache size (in Cache class): 0 Mb
DB type: DbPDO 
SQL Queries: 101 queries 
Time spent querying: 21.177s
Included files: 169
Size of included files: 3.15 Mb
Globals (> 1 Ko only): 1240 Ko
  • _LANGADM ≈ 1138.4 Ko
  • _MODULES ≈ 81.9 Ko
  • _SERVER ≈ 8.8 Ko
  • _REQUEST ≈ 2 Ko
  • _COOKIE ≈ 1.7 Ko
Stopwatch (with SQL_NO_CACHE) (total = 101)
2021.092 ms SELECT t.*, tl.name FROM `miz_tab` t LEFT JOIN `miz_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE 1 ORDER BY t.`position` ASC
in /classes/Tab.php:256
USING FILESORT - 106 rows browsed
1867.936 ms SELECT t.`class_name`, t.`module` FROM `miz_tab` t WHERE t.`module` IS NOT NULL AND t.`module` != ""
in /classes/Tab.php:232
106 rows browsed
1618.972 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
1451.545 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
1422.916 ms SELECT * FROM `miz_tab` t LEFT JOIN `miz_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 21 LIMIT 1
in /classes/Tab.php:213
1 row browsed
1171.141 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_kpi` c LEFT JOIN `miz_configuration_kpi_lang` cl ON (c.`id_configuration_kpi` = cl.`id_configuration_kpi`)
in /classes/Configuration.php:118
44 rows browsed
938.639 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
908.984 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
902.983 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` WHERE (h.name != "displayPayment") AND (hm.id_shop = 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
594.949 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
557.572 ms SELECT * FROM `miz_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
496.562 ms SELECT SQL_CALC_FOUND_ROWS a.`id_product`,b.name as name,`reference`,a.price as price,sa.active as active , shop.name as shopname, a.id_shop_default, MAX(image_shop.id_image) id_image, cl.name `name_category`, sa.`price`, 0 AS price_final, sav.`quantity` as sav_quantity, sa.`active`, IF(sav.`quantity`<=0, 1, 0 ) badge_danger FROM `miz_product` a LEFT JOIN `miz_product_lang` b ON (b.`id_product` = a.`id_product` AND b.`id_lang` = 1 AND b.`id_shop` = 1) LEFT JOIN `miz_image` i ON (i.`id_product` = a.`id_product`) LEFT JOIN `miz_stock_available` sav ON (sav.`id_product` = a.`id_product` AND sav.`id_product_attribute` = 0 AND sav.id_shop = 1 ) JOIN `miz_product_shop` sa ON (a.`id_product` = sa.`id_product` AND sa.id_shop = a.id_shop_default) LEFT JOIN `miz_category_lang` cl ON (sa.`id_category_default` = cl.`id_category` AND b.`id_lang` = cl.`id_lang` AND cl.id_shop = a.id_shop_default) LEFT JOIN `miz_shop` shop ON (shop.id_shop = a.id_shop_default) LEFT JOIN `miz_image_shop` image_shop ON (image_shop.`id_image` = i.`id_image` AND image_shop.`cover` = 1 AND image_shop.id_shop = a.id_shop_default) WHERE 1 GROUP BY sa.id_product ORDER BY a.`id_product` ASC LIMIT 0,50
in /classes/controller/AdminController.php:2739
USING FILESORT - 10 rows browsed
432.286 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` = 9)
in /classes/Product.php:2701
5 rows browsed
430.209 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_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `miz_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /classes/Hook.php:346
USING FILESORT - 79 rows browsed
Useless GROUP BY need to be removed
380.121 ms SELECT id_tab, class_name FROM `miz_tab`
in /classes/Tab.php:287
106 rows browsed
322.135 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
291.712 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
278.874 ms SELECT * FROM `miz_hook_alias`
in /classes/Hook.php:183
86 rows browsed
270.33 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
266.721 ms SELECT domain, domain_ssl FROM miz_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
in /classes/shop/ShopUrl.php:154
1 row browsed
262.933 ms SELECT `id_module` FROM `miz_module` WHERE `name` = "javaprobo" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed
235.858 ms SELECT module FROM miz_tab_module_preference WHERE `id_tab` = 21 AND `id_employee` = 1
in /classes/Tab.php:547
1 row browsed
187.42 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
184.79 ms SELECT COUNT(*) n FROM `miz_module_shop` WHERE id_module=64 AND id_shop IN (1) GROUP BY id_module HAVING n=1 LIMIT 1
in /classes/module/Module.php:1771
1 row browsed
182.407 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
170.925 ms SELECT a.`id_ps_advice`, a.`selector`, a.`location`, al.`html`, a.`weight` FROM `miz_advice` a LEFT JOIN `miz_advice_lang` al ON al.`id_advice` = a.`id_advice` LEFT JOIN `miz_tab_advice` at ON at.`id_advice` = a.`id_advice` WHERE ( a.`validated` = 1 AND a.`hide` = 0 AND al.`id_lang` = 1 AND at.`id_tab` = 21 AND ((a.`start_day` = 0 AND a.`stop_day` = 0) OR (10 >= a.`start_day` AND 10 <= a.`stop_day`)))
in /modules/gamification/classes/Advice.php:99
6 rows browsed
165.758 ms SELECT * FROM `miz_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
160.62 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
155.065 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` = 14)
in /classes/Product.php:2701
1 row browsed
139.663 ms SELECT class_name FROM miz_tab WHERE id_tab = 1 LIMIT 1
in /classes/Tab.php:535
1 row browsed
135.243 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
134.388 ms SELECT * FROM `miz_theme` a WHERE (a.id_theme = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
129.476 ms SELECT c.*, cl.* 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 cl.id_shop = 1 WHERE 1 AND `id_lang` = 1 ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
in /classes/Category.php:514
USING FILESORT - 10 rows browsed
120.764 ms SELECT * FROM `miz_employee` a LEFT JOIN `miz_employee_shop` `c` ON a.id_employee = c.id_employee AND c.id_shop = 1 WHERE (a.id_employee = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
108.539 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
95.577 ms SELECT `id_employee` FROM `miz_employee` WHERE `id_employee` = 1 AND `passwd` = 'b9a9be5388b7ba8acc1c14087fdb006b' AND active = 1 LIMIT 1
in /classes/Employee.php:299
1 row browsed
92.361 ms SELECT * FROM `miz_tab` a LEFT JOIN `miz_tab_lang` `b` ON a.id_tab = b.id_tab AND b.id_lang = 1 WHERE (a.id_tab = 21) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
92.051 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 12 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
88.328 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
75.571 ms SELECT COUNT(*) n FROM `miz_module_shop` WHERE id_module=83 AND id_shop IN (1) GROUP BY id_module HAVING n=1 LIMIT 1
in /classes/module/Module.php:1771
1 row browsed
74.281 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_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `miz_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /classes/Hook.php:346
USING FILESORT - 79 rows browsed
Useless GROUP BY need to be removed
69.111 ms SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM miz_shop s LEFT JOIN miz_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN miz_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 /classes/shop/Shop.php:199
1 row browsed
63.638 ms SELECT id_shop FROM `miz_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1
in /classes/ObjectModel.php:1250
1 row browsed
62.947 ms SELECT `version` FROM `miz_module` WHERE `name` = 'gamification' LIMIT 1
in /modules/gamification/gamification.php:143
1 row browsed
60.31 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` = 18)
in /classes/Product.php:2701
3 rows browsed
60.065 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 14 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
58.979 ms SELECT `id_module` FROM `miz_module_shop` WHERE `id_module` = 81 AND `id_shop` = 1 LIMIT 1
in /classes/module/Module.php:1780
1 row browsed
58.397 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
58.261 ms SELECT pa.id_product_attribute 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 = 15 LIMIT 1
in /classes/Product.php:670
1 row browsed
57.98 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 11 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
54.24 ms SELECT `id_module` FROM `miz_module` WHERE `name` = "gamification" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed
53.754 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 9 LIMIT 1
in /classes/Product.php:660
5 rows browsed
52.748 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 25 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
52.49 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 18 LIMIT 1
in /classes/Product.php:660
3 rows browsed
51.511 ms SELECT COUNT(*) n FROM `miz_module_shop` WHERE id_module=83 AND id_shop IN (1) GROUP BY id_module HAVING n=1 LIMIT 1
in /classes/module/Module.php:1771
1 row browsed
50.704 ms SELECT * FROM `miz_tab` t LEFT JOIN `miz_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = 1) WHERE t.`id_tab` = 9 LIMIT 1
in /classes/Tab.php:213
1 row browsed
50.552 ms SELECT `id_parent` FROM `miz_tab` WHERE LOWER(class_name) = 'adminproducts' LIMIT 1
in /classes/Tab.php:188
106 rows browsed
50.376 ms SELECT pa.id_product_attribute 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 = 15 LIMIT 1
in /classes/Product.php:689
1 row browsed
50.239 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 15 LIMIT 1
in /classes/Product.php:660
1 row browsed
48.07 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 18 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
47.803 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 11 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
31.877 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 9 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
31.392 ms SELECT `id_module` FROM `miz_module_shop` WHERE `id_module` = 64 AND `id_shop` = 1 LIMIT 1
in /classes/module/Module.php:1780
1 row browsed
25.763 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 13 LIMIT 1
in /classes/Product.php:660
5 rows browsed
20.556 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 12 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
20.337 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
18.304 ms SELECT * FROM `miz_quick_access` qa LEFT JOIN `miz_quick_access_lang` qal ON (qa.`id_quick_access` = qal.`id_quick_access` AND qal.`id_lang` = 1) ORDER BY `name` ASC
in /classes/QuickAccess.php:65
USING FILESORT - 3 rows browsed
17.101 ms SELECT id_shop FROM `miz_employee_shop` WHERE `id_employee` = 1
in /classes/ObjectModel.php:1297
1 row browsed
16.843 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 15 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
16.606 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 11 LIMIT 1
in /classes/Product.php:660
5 rows browsed
15.4 ms SELECT * FROM `miz_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1717
6 rows browsed
14.687 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
13.576 ms SELECT FOUND_ROWS() AS `miz_product` LIMIT 1
in /classes/controller/AdminController.php:2742
0 rows browsed
12.553 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
12.382 ms SELECT * FROM `miz_country` a 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
12.266 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
12.049 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
11.869 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 24 LIMIT 1
in /classes/Product.php:660
5 rows browsed
11.493 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 24 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
10.546 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
10.519 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` = 15)
in /classes/Product.php:2701
1 row browsed
10.088 ms SELECT * FROM `miz_lang` a LEFT JOIN `miz_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1 WHERE (a.id_lang = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed
9.564 ms SELECT * FROM `miz_country_lang` WHERE `id_country` = 21
in /classes/ObjectModel.php:219
1 row browsed
8.669 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 15 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
8.39 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 14 LIMIT 1
in /classes/Product.php:660
1 row browsed
7.579 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 12 LIMIT 1
in /classes/Product.php:660
5 rows browsed
6.727 ms SELECT * FROM `miz_group_lang` WHERE `id_group` = 1
in /classes/ObjectModel.php:219
1 row browsed
6.693 ms SELECT COUNT(*) n FROM `miz_module_shop` WHERE id_module=83 AND id_shop IN (1) GROUP BY id_module HAVING n=1 LIMIT 1
in /classes/module/Module.php:1771
1 row browsed
6.321 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 16 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
6.129 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 16 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
5.735 ms SELECT pa.id_product_attribute 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 product_attribute_shop.`default_on` = 1 AND pa.id_product = 15 LIMIT 1
in /classes/Product.php:680
1 row browsed
5.555 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 25 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
5.239 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 25 LIMIT 1
in /classes/Product.php:660
2 rows browsed
4.942 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
4.376 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 24 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
4.32 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 13 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
3.775 ms SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = 1 AND pa.id_product = 16 LIMIT 1
in /classes/Product.php:660
4 rows browsed
2.863 ms SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = 13 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed
2.127 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 14 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
1.224 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 18 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
1.224 ms SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = 18 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed
Doubles (IDs replaced by "XX") (total = 9)10 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)10 SELECT pa.id_product_attribute 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 product_attribute_shop.default_on = XX AND pa.id_product = XX LIMIT XX10 SELECT `id_tax_rules_group` FROM `miz_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX10 SELECT `reduction` FROM `miz_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX4 SELECT COUNT(*) n FROM `miz_module_shop` WHERE id_module=XX AND id_shop IN (XX) GROUP BY id_module HAVING n=XX LIMIT XX2 SELECT * FROM `miz_tab` t LEFT JOIN `miz_tab_lang` tl ON (t.`id_tab` = tl.`id_tab` AND tl.`id_lang` = XX) WHERE t.`id_tab` = XX LIMIT XX2 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_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `miz_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.name != "displayPayment") AND (hm.id_shop = XX) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`2 SELECT `id_module` FROM `miz_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX2 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` DESC

 

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