Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Crypt_RSA has a deprecated constructor in /var/www/admmatrix1013/data/www/original-dvr.ru/modules/googleshopping/lib/phpseclib/Crypt/RSA.php on line 280

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Crypt_Hash has a deprecated constructor in /var/www/admmatrix1013/data/www/original-dvr.ru/modules/googleshopping/lib/phpseclib/Crypt/Hash.php on line 82

Deprecated: Methods with the same name as their class will not be constructors in a future version of PHP; Math_BigInteger has a deprecated constructor in /var/www/admmatrix1013/data/www/original-dvr.ru/modules/googleshopping/lib/phpseclib/Math/BigInteger.php on line 176

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Notice: Array to string conversion in /var/www/admmatrix1013/data/www/original-dvr.ru/classes/Validate.php on line 675

Caught redirection to 404

Load Time1357 ms - OK... for a shared hosting
Querying Time84 ms
Queries99
Memory Peak Usage15.0 Mb
Included Files132 files - 3.52 Mb
PrestaShop Cache0.72 Mb
Global vars0.25 Mb
PrestaShop Version1.6.1.5
PHP Version7.0.31 (OK)
MySQL Version8.0.3-rc-log (OK)
Memory Limit11128M
Max Execution Time180s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 117 ms 117 ms 7.58 Mb 7.86 Mb
__construct 0 ms 117 ms - Mb 7.86 Mb
init 40 ms 157 ms 2.65 Mb 10.92 Mb
checkAccess 0 ms 157 ms - Mb 10.92 Mb
setMedia 4 ms 162 ms 0.21 Mb 10.92 Mb
postProcess 0 ms 162 ms - Mb 10.92 Mb
initHeader 0 ms 162 ms - Mb 10.92 Mb
initContent 1162 ms 1323 ms 4.51 Mb 15.00 Mb
initFooter 33 ms 1357 ms 0.02 Mb 15.03 Mb
Hook Time Memory Usage
hookheader 42 ms - Mb
__construct 36 ms 4.00 Mb
hookdisplayTop 8 ms - Mb
hooktop 7 ms - Mb
hookleftcolumn 3 ms - Mb
hookfooter 1 ms - Mb
hookrightcolumn 1 ms - Mb
hookproductlistassign 0 ms - Mb
hookdisplayHeader - ms - Mb
9 hooks 97 ms 4.00 Mb
Module Time Memory Usage
blocklayered 44 ms - Mb
googleshopping 13 ms 2.00 Mb
blockcart 13 ms - Mb
blocktopmenu 12 ms 2.00 Mb
blockcms 6 ms - Mb
blockcategories 4 ms - Mb
blocksearch 1 ms - Mb
productvideotab 1 ms - Mb
productscategory 1 ms - Mb
quickorder 1 ms - Mb
owr 1 ms - Mb
tmhomefeatured 0 ms - Mb
12 modules 97 ms 4.00 Mb

Stopwatch SQL - 99 queries

Query Time (ms) Rows Filesort Group By Location
DROP TEMPORARY TABLE IF EXISTS p_cat_restriction
31.3 1 /modules/blocklayered/blocklayered.php:2130
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.7 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("2022-09-30 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` = 7 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
3.2 3 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.6 262 /classes/Hook.php:235
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 63 Yes Yes /classes/Hook.php:355
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 53 Yes Yes /classes/Supplier.php:127
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 >= 4510493
AND c.nright <= 4510494
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.5 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 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 = 4358
ORDER BY f.position ASC
1.3 5 Yes /classes/Product.php:4612
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 = 7
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 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
1 1 Yes /classes/shop/Shop.php:334
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)
1 1 /classes/Language.php:777
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
0.9 94 /classes/module/Module.php:277
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 = 4055
ORDER BY f.position ASC
0.9 5 Yes /classes/Product.php:4612
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` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 7
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.7 1 Yes Yes /classes/Category.php:656
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
0.7 38 Yes /classes/Dispatcher.php:452
SELECT SQL_NO_CACHE data FROM `p_layered_friendly_url` WHERE `url_key` = '73504aa2f388e3f62bd6766a960e7590' LIMIT 1
0.7 1 /modules/blocklayered/blocklayered.php:1726
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.7 1 /Adapter/Adapter_EntityMapper.php:61
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.6 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 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.6 1 Yes /classes/shop/Shop.php:663
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.6 1 /classes/Currency.php:470
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.5 1 /Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ctg.`id_group`
FROM p_category_group ctg
WHERE ctg.`id_category` = 7 AND ctg.`id_group` = 1 LIMIT 1
0.5 1 /classes/Category.php:1311
SELECT SQL_NO_CACHE `id_module` FROM `p_module` WHERE `name` = "yamodule" LIMIT 1
0.5 1 /classes/module/Module.php:2568
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM p_layered_category
WHERE id_category = 7
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 *
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` = 4358) 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` = 4006) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61
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` 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.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` = 4055) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61
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.4 1 /classes/shop/Shop.php:202
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` = 7 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.4 3 /classes/Category.php:712
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `p_smarty_lazy_cache`
WHERE `template_hash`='87d9d86bdf6e02ad7b878108f13b2ef1' AND cache_id="blocktopmenu|1|177|category|7" 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 = 4006
ORDER BY f.position ASC
0.4 1 Yes /classes/Product.php:4612
SELECT SQL_NO_CACHE * FROM `p_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.4 1 /classes/module/Module.php:2141
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` = 4358)
0.3 1 /classes/Product.php:3136
SELECT SQL_NO_CACHE * FROM `p_image_type`
0.3 10 /classes/ImageType.php:143
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` = 4006)
0.3 1 /classes/Product.php:3136
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.3 1 /classes/SmartyCustom.php:215
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 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` = 4055)
0.3 1 /classes/Product.php:3136
SELECT SQL_NO_CACHE *
FROM `p_group_lang`
WHERE `id_group` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68
SELECT SQL_NO_CACHE domain, domain_ssl
FROM p_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
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 <= 4510493
AND c.nright >= 4510494
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 * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4055
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4358
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
0.3 1 /classes/Product.php:2913
SELECT SQL_NO_CACHE * FROM `p_prices` WHERE `id_product`=4006
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.2 1 /classes/Country.php:173
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.2 1 Yes /classes/Language.php:717
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.2 1 /classes/SmartyCustom.php:215
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|7|3" AND compile_id="" LIMIT 1
0.2 1 /classes/SmartyCustom.php:215
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 `width`, `height`
FROM p_image_type
WHERE `name` = 'category_default' LIMIT 1
0.2 1 /classes/Image.php:471
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 *
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 SUM(quantity)
FROM `p_stock_available`
WHERE (id_product = 4358) 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 COUNT(*)
FROM p_layered_category
WHERE id_category = 7
AND id_shop = 1 LIMIT 1
0.2 1 /modules/blocklayered/blocklayered.php:636
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` = 7 AND cl.id_shop = 1 LIMIT 1
0.2 1 /classes/Meta.php:291
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.2 1 /classes/SmartyCustom.php:215
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` = 7 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 `width`, `height`
FROM p_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.2 1 /classes/Image.php:471
SELECT SQL_NO_CACHE SUM(quantity)
FROM `p_stock_available`
WHERE (id_product = 4006) 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 = 4055) 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_shop
FROM `p_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1450
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 `width`, `height`
FROM p_image_type
WHERE `name` = 'm_scene_default' LIMIT 1
0.2 1 /classes/Image.php:471
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 nleft, nright, level_depth
FROM p_category
WHERE id_category = 7 LIMIT 1
0.2 1 /classes/Category.php:1479
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_shop
FROM `p_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1450
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` = 4006 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` = 4358 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` = 4055 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

Doubles

18
SELECT * FROM `p_prices` WHERE `id_product`=XX
3
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 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
3
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
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
3
							SELECT `id_tax_rules_group`
							FROM `p_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
3
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)
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 nleft, nright, level_depth
			FROM p_category
			WHERE id_category = XX LIMIT XX

Tables stress

18 prices
12 product_shop
9 product
7 category_lang
7 category
6 smarty_lazy_cache
5 image_type
4 lang
4 feature_lang
4 product_attribute_shop
4 stock_available
4 product_lang
4 shop
4 lang_shop
4 category_shop
4 currency_shop
4 shop_url
4 hook
4 module
3 feature_shop
3 feature_value_lang
3 theme
3 currency
3 feature_product
3 category_product
3 feature
3 module_shop
2 country
2 shop_group
2 configuration
2 layered_category
2 smarty_last_flush
2 meta
2 group_shop
2 hook_module
2 hook_alias
1 image_shop
1 supplier
1 manufacturer
1 supplier_lang
1 image_lang
1 scene
1 layered_indexable_feature
1 group_lang
1 configuration_lang
1 country_lang
1 country_shop
1 meta_lang
1 theme_meta
1 group
1 category_group
1 layered_indexable_attribute_group
1 scene_category
1 scene_shop
1 scene_lang
1 hook_module_exceptions
1 layered_friendly_url
1 attribute_group_lang
1 supplier_shop

ObjectModel instances

NameInstancesSource
Category 4 /controllers/front/CategoryController.php [105]
/classes/Link.php [177]
/modules/blocklayered/blocklayered.php [2118]
/modules/blockcategories/blockcategories.php [200]
Product 3 /classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
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]

Included Files

#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/7/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/7/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