Load Time | 2058 ms - You'd better run your shop on a toaster |
Querying Time | 151 ms |
Queries | 156 |
Memory Peak Usage | 15.5 Mb |
Included Files | 132 files - 3.52 Mb |
PrestaShop Cache | 0.77 Mb |
Global vars | 0.25 Mb |
PrestaShop Version | 1.6.1.5 |
PHP Version | 7.0.31 (OK) |
MySQL Version | 8.0.3-rc-log (OK) |
Memory Limit | 11128M |
Max Execution Time | 180s |
Smarty Cache | enabled |
Smarty Compilation | auto |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 129 ms | 129 ms | 7.58 Mb | 7.86 Mb |
__construct | 0 ms | 129 ms | - Mb | 7.86 Mb |
init | 50 ms | 179 ms | 2.65 Mb | 10.92 Mb |
checkAccess | 0 ms | 179 ms | - Mb | 10.92 Mb |
setMedia | 4 ms | 184 ms | 0.21 Mb | 10.92 Mb |
postProcess | 0 ms | 184 ms | - Mb | 10.92 Mb |
initHeader | 0 ms | 184 ms | - Mb | 10.92 Mb |
initContent | 1836 ms | 2020 ms | 4.94 Mb | 15.43 Mb |
initFooter | 38 ms | 2058 ms | 0.02 Mb | 15.46 Mb |
Hook | Time | Memory Usage |
---|---|---|
hookdisplayTop | 152 ms | - Mb |
hookheader | 70 ms | - Mb |
__construct | 38 ms | 4.00 Mb |
hooktop | 7 ms | - Mb |
hookleftcolumn | 3 ms | - Mb |
hookfooter | 1 ms | - Mb |
hookrightcolumn | 1 ms | - Mb |
hookproductlistassign | 0 ms | - Mb |
hookdisplayHeader | 0 ms | - Mb |
9 hooks | 272 ms | 4.00 Mb |
Module | Time | Memory Usage |
---|---|---|
blocktopmenu | 157 ms | 2.00 Mb |
blocklayered | 72 ms | - Mb |
blockcart | 13 ms | - Mb |
googleshopping | 13 ms | 2.00 Mb |
blockcms | 6 ms | - Mb |
blockcategories | 4 ms | - Mb |
blocksearch | 2 ms | - Mb |
productvideotab | 2 ms | - Mb |
productscategory | 1 ms | - Mb |
quickorder | 1 ms | - Mb |
owr | 1 ms | - Mb |
tmhomefeatured | 1 ms | - Mb |
12 modules | 272 ms | 4.00 Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
DROP TEMPORARY TABLE IF EXISTS p_cat_restriction |
58.5 | 1 | /modules/blocklayered/blocklayered.php:2130 | ||
SELECT SQL_NO_CACHE domain, domain_ssl FROM p_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
12.6 | 1 | /classes/shop/ShopUrl.php:169 | ||
SELECT SQL_NO_CACHE id_shop FROM `p_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
8.6 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `p_configuration` c LEFT JOIN `p_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
5.8 | 616 | /classes/Configuration.php:148 | ||
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS 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`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-02-02 00:00:00", INTERVAL 50 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `p_category_product` cp LEFT JOIN `p_product` p ON p.`id_product` = cp.`id_product` INNER JOIN p_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN p_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `p_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `p_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `p_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `p_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `p_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 72 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY IF(stock.`quantity`>0,1,0) DESC, p.`price` ASC LIMIT 0,50 |
4.2 | 8 | Yes | /classes/Category.php:785 | |
SELECT SQL_NO_CACHE 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 `p_hook_module` hm STRAIGHT_JOIN `p_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `p_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
2.9 | 262 | /classes/Hook.php:235 | ||
SELECT SQL_NO_CACHE s.*, sl.`description` FROM `p_supplier` s LEFT JOIN `p_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN p_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC |
2.3 | 53 | Yes | Yes | /classes/Supplier.php:127 |
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `p_module` m INNER JOIN p_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 `p_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `p_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `p_hook` h ON hm.`id_hook` = h.`id_hook` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.1 | 63 | Yes | Yes | /classes/Hook.php:355 |
CREATE TEMPORARY TABLE p_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM p_category_product cp INNER JOIN p_category c ON (c.id_category = cp.id_category AND c.nleft >= 4511058 AND c.nright <= 4511059 AND c.active = 1) INNER JOIN p_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) INNER JOIN p_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") |
1.6 | 1 | /modules/blocklayered/blocklayered.php:2140 | ||
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `p_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `p_hook_alias` ha INNER JOIN `p_hook` h ON ha.name = h.name |
1.5 | 0 | /classes/Hook.php:131 | ||
SELECT SQL_NO_CACHE s.* FROM `p_scene_category` sc LEFT JOIN `p_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN p_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `p_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 72 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC |
1.1 | 1 | Yes | /classes/Scene.php:226 | |
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `p_meta` m LEFT JOIN `p_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
1 | 38 | Yes | /classes/Dispatcher.php:452 | |
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `p_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `p_module` m |
1 | 94 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM p_shop_url su LEFT JOIN p_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'original-dvr.ru' OR su.domain_ssl = 'original-dvr.ru') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.9 | 1 | Yes | /classes/shop/Shop.php:334 | |
SELECT SQL_NO_CACHE data FROM `p_layered_friendly_url` WHERE `url_key` = '5a01144e26f168023e82df55b3a9a67c' LIMIT 1 |
0.8 | 1 | /modules/blocklayered/blocklayered.php:1726 | ||
SELECT SQL_NO_CACHE * FROM `p_country` a LEFT JOIN `p_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `p_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 177) LIMIT 1 |
0.8 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 63 ORDER BY f.position ASC |
0.8 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE * FROM `p_category` a LEFT JOIN `p_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `p_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 |
0.8 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `p_category` c INNER JOIN p_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `p_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE `id_parent` = 72 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
0.8 | 1 | Yes | Yes | /classes/Category.php:656 |
SELECT SQL_NO_CACHE * FROM `p_currency` c INNER JOIN p_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 |
0.7 | 1 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE * FROM `p_category` a LEFT JOIN `p_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `p_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 72) AND (b.`id_shop` = 1) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `p_currency` c LEFT JOIN p_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1 |
0.7 | 1 | /classes/Currency.php:470 | ||
SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `p_lang` l LEFT JOIN `p_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.7 | 1 | /classes/Language.php:777 | ||
SELECT SQL_NO_CACHE public_name FROM `p_attribute_group_lang` agl LEFT JOIN `p_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.7 | 25 | /modules/blocklayered/blocklayered.php:2719 | ||
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM p_theme t LEFT JOIN p_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN p_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =6 AND m.page = "category" LIMIT 1 |
0.6 | 1 | /classes/Theme.php:275 | ||
SELECT SQL_NO_CACHE name FROM `p_feature_lang` fl LEFT JOIN `p_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.6 | 14 | /modules/blocklayered/blocklayered.php:2729 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 66) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM p_shop_group gs LEFT JOIN p_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN p_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 |
0.5 | 1 | Yes | /classes/shop/Shop.php:663 | |
SELECT SQL_NO_CACHE ctg.`id_group` FROM p_category_group ctg WHERE ctg.`id_category` = 72 AND ctg.`id_group` = 1 LIMIT 1 |
0.5 | 1 | /classes/Category.php:1311 | ||
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM p_layered_category WHERE id_category = 72 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.5 | 1 | Yes | Yes | /modules/blocklayered/blocklayered.php:2124 |
ALTER TABLE p_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE |
0.5 | 1 | /modules/blocklayered/blocklayered.php:2146 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 62 ORDER BY f.position ASC |
0.5 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 64) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 67) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5008) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_group` a LEFT JOIN `p_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 110) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `p_product` p INNER JOIN p_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 72 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1 |
0.5 | 8 | /classes/Category.php:712 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 63) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 65) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 66 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `p_lang` l JOIN p_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 |
0.4 | 1 | /classes/Language.php:892 | ||
SELECT SQL_NO_CACHE * FROM `p_group_lang` WHERE `id_group` = 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `p_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 62) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.4 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_currency` a LEFT JOIN `p_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 5008 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 67 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='87d9d86bdf6e02ad7b878108f13b2ef1' AND cache_id="blocktopmenu|1|177|category|72" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 64 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 110 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='c92825898cc50ca4cc33d5adfba949b3' AND cache_id="blocksearch-top|1|177" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN p_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 65 ORDER BY f.position ASC |
0.4 | 1 | Yes | /classes/Product.php:4612 | |
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 66) |
0.4 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE `id_module` FROM `p_module` WHERE `name` = "yamodule" LIMIT 1 |
0.4 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.4 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='7b33c98f85bfe476e2bb83d1ebaf0fc9' AND cache_id="blockcms|2|1|177" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `p_image_type` |
0.4 | 10 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE * FROM `p_hook_alias` |
0.3 | 86 | /classes/Hook.php:187 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 63) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 64) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `p_smarty_last_flush` WHERE type='compile' LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:95 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 67) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM p_shop s LEFT JOIN p_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN p_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 |
0.3 | 1 | /classes/shop/Shop.php:202 | ||
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite FROM p_category c LEFT JOIN p_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) INNER JOIN p_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE c.nleft <= 4511058 AND c.nright >= 4511059 AND c.nleft >= 2 AND c.nright <= 673 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC |
0.3 | 0 | /classes/Tools.php:1306 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 65) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 110) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 5008) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 62) |
0.3 | 1 | /classes/Product.php:3136 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=66 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE `id_country` FROM `p_country` WHERE `iso_code` = 'US' AND active = 1 LIMIT 1 |
0.3 | 1 | /classes/Country.php:173 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.3 | 1 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=67 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='7b33c98f85bfe476e2bb83d1ebaf0fc9' AND cache_id="blockcms|1|1|177" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=63 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=5008 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=110 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found FROM `p_lang` WHERE LEFT(`language_code`,2) = 'en' ORDER BY found ASC LIMIT 1 |
0.3 | 1 | Yes | /classes/Language.php:717 | |
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=64 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM p_image_type WHERE `name` = 'category_default' LIMIT 1 |
0.3 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=62 |
0.3 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=65 |
0.2 | 1 | /classes/Product.php:2913 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 62) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='8ec3eee5193c9759d52d03dff6991261' AND cache_id="blockcategories|1|177|2|72|3" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `p_lang` a LEFT JOIN `p_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE value FROM `p_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.2 | 1 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 67) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `p_smarty_last_flush` WHERE type='template' LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:142 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM p_layered_category WHERE id_category = 72 AND id_shop = 1 LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:636 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 63) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM p_image_type WHERE `name` = 'home_default' LIMIT 1 |
0.2 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 66) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`='7b33c98f85bfe476e2bb83d1ebaf0fc9' AND cache_id="blockcms|0|1|177" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM p_category WHERE id_category = 72 LIMIT 1 |
0.2 | 1 | /classes/Category.php:1479 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `p_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 72 LIMIT 1 |
0.2 | 1 | /classes/Category.php:1056 | ||
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `p_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 72 AND cl.id_shop = 1 LIMIT 1 |
0.2 | 1 | /classes/Meta.php:291 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM p_image_type WHERE `name` = 'medium_default' LIMIT 1 |
0.2 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 66 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 5008) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 110) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 64) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 65 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `p_stock_available` WHERE (id_product = 65) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM p_image_type WHERE `name` = 'm_scene_default' LIMIT 1 |
0.2 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE * FROM `p_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `p_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 45 LIMIT 1 |
0.2 | 1 | /classes/Category.php:1056 | ||
SELECT SQL_NO_CACHE * FROM `p_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE data FROM `p_layered_friendly_url` WHERE `url_key` = 'a7287f7b18384bab00bb6031afc78c21' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1726 | ||
SELECT SQL_NO_CACHE * FROM `p_theme` a WHERE (a.`id_theme` = 6) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 63 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 67 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 110 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM p_category WHERE id_category = 2 LIMIT 1 |
0.2 | 1 | /classes/Category.php:1479 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 64 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 5008 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE id_shop FROM `p_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.2 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = 62 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5193 | ||
SELECT SQL_NO_CACHE id_shop FROM `p_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.2 | 1 | /classes/ObjectModel.php:1450 |
48 | SELECT * FROM `p_prices` WHERE `id_product`=XX |
8 | SELECT SUM(quantity) FROM `p_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX |
8 | SELECT name, value, pf.id_feature FROM p_feature_product pf LEFT JOIN p_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN p_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN p_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN p_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 ASC |
8 | SELECT `id_tax_rules_group` FROM `p_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
8 | SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `p_product` p INNER JOIN `p_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `p_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
8 | SELECT * FROM `p_product` a LEFT JOIN `p_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `p_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 XX |
3 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX" AND compile_id="" LIMIT XX |
2 | SELECT cl.`link_rewrite` FROM `p_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
2 | SELECT * FROM `p_category` a LEFT JOIN `p_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `p_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX |
2 | SELECT data FROM `p_layered_friendly_url` WHERE `url_key` = XX LIMIT XX |
2 | SELECT nleft, nright, level_depth FROM p_category WHERE id_category = XX LIMIT XX |
48 prices |
27 product_shop |
19 product |
9 feature_lang |
9 product_attribute_shop |
9 stock_available |
9 product_lang |
8 category_lang |
8 feature_product |
8 feature_value_lang |
8 feature_shop |
8 feature |
7 category |
6 smarty_lazy_cache |
5 image_type |
4 currency_shop |
4 shop |
4 shop_url |
4 category_shop |
4 lang |
4 hook |
4 module |
4 lang_shop |
3 currency |
3 module_shop |
3 theme |
3 category_product |
2 shop_group |
2 configuration |
2 layered_category |
2 layered_friendly_url |
2 smarty_last_flush |
2 meta |
2 hook_alias |
2 country |
2 group_shop |
2 hook_module |
1 image_lang |
1 manufacturer |
1 supplier |
1 supplier_lang |
1 image_shop |
1 scene |
1 layered_indexable_feature |
1 layered_indexable_attribute_group |
1 attribute_group_lang |
1 hook_module_exceptions |
1 scene_lang |
1 scene_shop |
1 scene_category |
1 category_group |
1 group_lang |
1 group |
1 theme_meta |
1 meta_lang |
1 country_shop |
1 country_lang |
1 configuration_lang |
1 supplier_shop |
Name | Instances | Source |
---|---|---|
Product | 8 | /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] |
Category | 4 | /controllers/front/CategoryController.php [105] /classes/Link.php [177] /modules/blocklayered/blocklayered.php [2118] /modules/blockcategories/blockcategories.php [200] |
Country | 2 | /config/config.inc.php [142] /classes/controller/FrontController.php [279] |
Language | 2 | /config/config.inc.php [195] /classes/Tools.php [498] |
Address | 2 | /classes/Product.php [3075] /classes/Product.php [4564] |
Shop | 1 | /config/config.inc.php [114] |
Theme | 1 | /config/config.inc.php [115] |
ShopGroup | 1 | /classes/shop/Shop.php [518] |
Customer | 1 | /config/config.inc.php [217] |
Currency | 1 | /classes/Tools.php [615] |
Cart | 1 | /classes/controller/FrontController.php [348] |
Group | 1 | /classes/Cart.php [184] |
# | Filename |
---|---|
1 | /index.php |
2 | /config/config.inc.php |
3 | /config/defines.inc.php |
4 | /config/settings.inc.php |
5 | /config/autoload.php |
6 | /config/alias.php |
7 | /classes/PrestaShopAutoload.php |
8 | /cache/class_index.php |
9 | /config/bootstrap.php |
10 | /Core/Business/Core_Business_ContainerBuilder.php |
11 | /Core/Foundation/IoC/Core_Foundation_IoC_Container.php |
12 | /Adapter/Adapter_ServiceLocator.php |
13 | /classes/controller/Controller.php |
14 | /classes/ObjectModel.php |
15 | /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php |
16 | /classes/db/Db.php |
17 | /classes/Tools.php |
18 | /classes/Context.php |
19 | /classes/shop/Shop.php |
20 | /classes/db/DbPDO.php |
21 | /classes/Configuration.php |
22 | /classes/Validate.php |
23 | /classes/cache/Cache.php |
24 | /Adapter/Adapter_EntityMapper.php |
25 | /classes/db/DbQuery.php |
26 | /classes/Theme.php |
27 | /config/defines_uri.inc.php |
28 | /tools/htmlpurifier/HTMLPurifier.standalone.php |
29 | /classes/Language.php |
30 | /classes/Country.php |
31 | /classes/PrestaShopCollection.php |
32 | /classes/shop/ShopGroup.php |
33 | /classes/Cookie.php |
34 | /classes/Rijndael.php |
35 | /classes/Customer.php |
36 | /classes/Group.php |
37 | /classes/Link.php |
38 | /override/classes/Link.php |
39 | /classes/shop/ShopUrl.php |
40 | /config/smarty.config.inc.php |
41 | /tools/smarty/Smarty.class.php |
42 | /tools/smarty/sysplugins/smarty_internal_data.php |
43 | /tools/smarty/sysplugins/smarty_internal_templatebase.php |
44 | /tools/smarty/sysplugins/smarty_internal_template.php |
45 | /tools/smarty/sysplugins/smarty_resource.php |
46 | /tools/smarty/sysplugins/smarty_internal_resource_file.php |
47 | /tools/smarty/sysplugins/smarty_cacheresource.php |
48 | /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php |
49 | /classes/SmartyCustom.php |
50 | /config/smartyfront.config.inc.php |
51 | /classes/Dispatcher.php |
52 | /override/classes/Dispatcher.php |
53 | /classes/module/Module.php |
54 | /classes/Hook.php |
55 | /tools/mobile_Detect/Mobile_Detect.php |
56 | /config/db_slave_server.inc.php |
57 | /controllers/front/CategoryController.php |
58 | /classes/controller/FrontController.php |
59 | /classes/Category.php |
60 | /themes/theme531/lang/ru.php |
61 | /classes/Currency.php |
62 | /classes/Cart.php |
63 | /classes/CartRule.php |
64 | /classes/Meta.php |
65 | /classes/Product.php |
66 | /classes/webservice/WebserviceRequest.php |
67 | /classes/Media.php |
68 | /classes/Scene.php |
69 | /modules/blockcart/blockcart.php |
70 | /classes/Translate.php |
71 | /modules/blockcart/translations/ru.php |
72 | /cache/smarty/compile/a5/99/4e/a5994e8dca7b2aaa19f931e69af1447c6f3d9ac3.file.top.tpl.php |
73 | /tools/smarty/sysplugins/smarty_internal_filter_handler.php |
74 | /tools/minify_html/minify_html.class.php |
75 | /tools/js_minify/jsmin.php |
76 | /modules/blockcategories/blockcategories.php |
77 | /modules/blockcategories/translations/ru.php |
78 | /modules/blockcms/blockcms.php |
79 | /modules/blockcms/BlockCMSModel.php |
80 | /modules/blockcms/translations/ru.php |
81 | /modules/tmhomefeatured/tmhomefeatured.php |
82 | /modules/tmhomefeatured/translations/ru.php |
83 | /modules/productvideotab/productvideotab.php |
84 | /modules/productvideotab/ProductVideoTab_Video.php |
85 | /modules/productvideotab/ProductVideoTab_Product_Video.php |
86 | /modules/productvideotab/ru.php |
87 | /modules/quickorder/quickorder.php |
88 | /modules/quickorder/ru.php |
89 | /modules/owr/owr.php |
90 | /modules/owr/ru.php |
91 | /modules/blocktopmenu/blocktopmenu.php |
92 | /modules/blocktopmenu/menutoplinks.class.php |
93 | /modules/blocktopmenu/translations/ru.php |
94 | /modules/blocklayered/blocklayered.php |
95 | /modules/blocklayered/translations/ru.php |
96 | /modules/productscategory/productscategory.php |
97 | /modules/productscategory/translations/ru.php |
98 | /modules/googleshopping/googleshopping.php |
99 | /modules/googleshopping/lib/phpseclib/Crypt/RSA.php |
100 | /modules/googleshopping/lib/phpseclib/Crypt/Random.php |
101 | /modules/googleshopping/lib/phpseclib/Crypt/Hash.php |
102 | /modules/googleshopping/lib/phpseclib/Math/BigInteger.php |
103 | /modules/googleshopping/translations/ru.php |
104 | /modules/blocksearch/blocksearch.php |
105 | /modules/blocksearch/translations/ru.php |
106 | /cache/smarty/cache/blocktopmenu/1/177/category/72/6f/e7/c9/6fe7c97cfc16551b8f09511277782cec0cca0fee.blocktopmenu.tpl.php |
107 | /cache/smarty/compile/30/16/98/301698833c848867709197ba22b829ec686c3353.file.blockcart.tpl.php |
108 | /cache/smarty/cache/blocksearch_top/1/177/60/9a/61/609a615962a705f1ded80544f6b759602cbadb19.blocksearch-top.tpl.php |
109 | /cache/smarty/cache/blockcategories/1/177/2/72/3/f7/93/17/f7931782ed3be4bf286d4340d78b79ca85493511.blockcategories.tpl.php |
110 | /cache/smarty/cache/blockcms/0/1/177/c4/a4/ee/c4a4ee83470f52c66a88437b9bec363864e22c24.blockcms.tpl.php |
111 | /cache/smarty/cache/blockcms/1/1/177/c4/a4/ee/c4a4ee83470f52c66a88437b9bec363864e22c24.blockcms.tpl.php |
112 | /classes/ImageType.php |
113 | /classes/Combination.php |
114 | /classes/stock/StockAvailable.php |
115 | /classes/tax/Tax.php |
116 | /classes/Address.php |
117 | /classes/SpecificPrice.php |
118 | /classes/tax/TaxManagerFactory.php |
119 | /classes/tax/TaxRulesTaxManager.php |
120 | /classes/tax/TaxManagerInterface.php |
121 | /Adapter/Adapter_Configuration.php |
122 | /Core/Business/Core_Business_ConfigurationInterface.php |
123 | /classes/tax/TaxCalculator.php |
124 | /classes/GroupReduction.php |
125 | /classes/Feature.php |
126 | /classes/Image.php |
127 | /classes/Supplier.php |
128 | /cache/smarty/cache/blockcms/2/1/177/c4/a4/ee/c4a4ee83470f52c66a88437b9bec363864e22c24.blockcms.tpl.php |