850.464 ms
SELECT dz.*, stock.`quantity` FROM `ps_dzordergifts` dz
LEFT JOIN `ps_product` p
ON dz.`id_product_gift` = p.`id_product`
LEFT JOIN `ps_stock_available` stock
ON stock.`id_product` = dz.`id_product_gift` AND stock.`id_product_attribute` = 0
WHERE p.`active` = 1
AND stock.`quantity` > 0
AND p.`available_for_order` = 1
ORDER BY dz.`position` ASC,
dz.`product_gift_price_rrc` DESC
in /override/classes/db/Db.php:519
from /modules/dzordergifts/dzordergifts.php:1270
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:191
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:191
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
152341 rows browsed
5.926 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 `ps_hook` h
INNER JOIN `ps_hook_module` hm ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
INNER JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
in /override/classes/db/Db.php:519
from /classes/Hook.php:228
from /classes/Hook.php:266
from /classes/tax/TaxManagerFactory.php:67
from /classes/tax/TaxManagerFactory.php:47
from /classes/Product.php:4703
from /classes/Product.php:493
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
97 rows browsed
4.319 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 `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
in /override/classes/db/Db.php:519
from /classes/Configuration.php:118
from /config/config.inc.php:115
from /index.php:67
704 rows browsed
3.695 ms
SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_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 `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_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 /override/classes/db/Db.php:519
from /classes/Hook.php:346
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:429
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
USING FILESORT -
67 rows browsedUseless GROUP BY need to be removed
2.254 ms
SELECT *, ( IF ('2025-09-15 18:38:21' >= `from` AND '2025-09-15 18:38:21' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 216, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE `id_product` IN (0, 86140)
AND `id_product_attribute` IN (0, 0)
AND `id_shop` IN (0, 1)
AND `id_currency` IN (0, 1)
AND `id_country` IN (0, 216)
AND `id_group` IN (0, 1)
AND `id_customer` IN (0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2025-09-15 18:38:21' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:38:21' <= `to`)
)
AND id_cart IN (0, 0)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT 1
in /override/classes/db/Db.php:565
from /classes/SpecificPrice.php:239
from /classes/Product.php:2830
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
32 rows browsed
2.235 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
2.231 ms
SELECT name, GROUP_CONCAT(value SEPARATOR ", ") as value, pf.id_feature, f.`property_name`
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
WHERE pf.id_product = 86140
GROUP BY pf.id_feature
ORDER BY f.position ASC
in /override/classes/db/Db.php:519
from /controllers/front/ProductController.php:282
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
25 rows browsed
1.963 ms
SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default,
DATEDIFF(
p.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 100 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1
)
LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT
JOIN ps_stock_available stock
ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 )
WHERE `id_product_1` = 86140 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
in /override/classes/db/Db.php:519
from /classes/Product.php:3406
from /controllers/front/ProductController.php:299
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
1.946 ms
SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2 AND cl.id_shop = 1 )
WHERE `id_parent` = 29
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` desc, category_shop.`position` desc
in /override/classes/db/Db.php:519
from /override/classes/Category.php:586
from /controllers/front/ProductController.php:632
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
5 rows browsedUseless GROUP BY need to be removed
1.939 ms
SELECT * FROM `ps_state` ORDER BY `name` ASC
in /override/classes/db/Db.php:519
from /classes/Country.php:136
from /modules/dz_cart/dz_cart.php:2683
from :undefined
from /modules/dz_cart/dz_cart.php:989
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
337 rows browsed
1.844 ms
SELECT `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
in /override/classes/db/Db.php:519
from /classes/Hook.php:131
from /classes/Hook.php:417
from /tools/profiling/Hook.php:60
from /classes/Dispatcher.php:429
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
0 rows browsed
1.473 ms
SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 2)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 86140
in /override/classes/db/Db.php:519
from /classes/Product.php:5257
from /controllers/front/ProductController.php:598
from /controllers/front/ProductController.php:253
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
1.334 ms
SELECT m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
in /override/classes/db/Db.php:519
from /classes/module/Module.php:205
from /modules/smartblog/smartblog.php:25
from /classes/module/Module.php:1016
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/Dispatcher.php:429
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
97 rows browsed
1.305 ms
SELECT domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /classes/shop/ShopUrl.php:154
from /classes/shop/ShopUrl.php:168
from /classes/Tools.php:209
from /classes/Link.php:52
from /config/config.inc.php:210
from /index.php:67
1 row browsed
1.301 ms
SELECT m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
in /override/classes/db/Db.php:519
from /classes/Dispatcher.php:477
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
USING FILESORT -
43 rows browsed
1.263 ms
SELECT d.*, dl.*,
ds.`show_label`,
ds.`show_description`,
ds.`show_placeholder`,
ds.`show_image`,
ds.`width`,
ds.`visibility`,
ds.`required`
FROM `ps_dz_cart_customer_field` d
LEFT JOIN `ps_dz_cart_customer_field_lang` dl
ON d.`id_dz_cart_customer_field` = dl.`id_dz_cart_customer_field`
AND dl.`id_lang` = 2
LEFT JOIN `ps_dz_cart_customer_field_show` ds
ON d.`id_dz_cart_customer_field` = ds.`id_dz_cart_customer_field`
WHERE d.`active`
AND ds.`active`
AND ds.`type` = "register"
ORDER BY ds.`position` ASC
in /override/classes/db/Db.php:519
from /modules/dz_cart/classes/DzCartCustomerFieldShow.php:379
from /modules/dz_cart/dz_cart.php:962
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php:32
from /cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php:32
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/dz_cart/dz_cart.php:1053
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:138
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:138
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
23 rows browsed
1.259 ms
SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_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 /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Language.php:833
from /classes/Language.php:932
from /classes/Dispatcher.php:397
from /classes/Dispatcher.php:221
from /classes/Dispatcher.php:193
from /index.php:68
1 row browsed
1.227 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON a.`id_dz_cart_customer_field` = c.`id_dz_cart_customer_field`
AND c.`type` = "customer"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Customer.php:62
from /config/config.inc.php:198
from /index.php:67
28 rows browsed
1.22 ms
SELECT *,
( IF ('2025-09-15 18:38:22' >= `from` AND '2025-09-15 18:38:22' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 216, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_product` IN(0, 86140) AND
`id_shop` IN(0, 1) AND
`id_currency` IN(0, 1) AND
`id_country` IN(0, 216) AND
`id_group` IN(0, 1) AND
`id_customer` IN(0, 0)
AND
(
(`from` = '0000-00-00 00:00:00' OR '2025-09-15 18:38:22' >= `from`)
AND
(`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:38:22' <= `to`)
)
ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC
in /override/classes/db/Db.php:519
from /classes/SpecificPrice.php:302
from /controllers/front/ProductController.php:369
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
32 rows browsed
1.209 ms
SELECT * FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_lang` al
ON a.`id_dz_cart_customer_field` = al.`id_dz_cart_customer_field`
AND al.`id_lang` = "2"
in /override/classes/db/Db.php:519
from /modules/dz_cart/dz_cart.php:977
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
1.209 ms
SELECT cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
in /override/classes/db/Db.php:519
from /classes/Country.php:130
from /modules/dz_cart/dz_cart.php:2683
from :undefined
from /modules/dz_cart/dz_cart.php:989
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
244 rows browsed
1.103 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /modules/dz_cart/dz_cart.php:1014
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
1.074 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'attr_large' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:156
from /controllers/front/ProductController.php:436
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
1.025 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Product.php:493
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
1.004 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Address.php:364
from /classes/Product.php:4701
from /classes/Product.php:493
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.989 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /controllers/front/ProductController.php:352
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.968 ms
SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 86140 AND i.`active` = 1
ORDER BY `position`
in /override/classes/db/Db.php:519
from /override/classes/Product.php:326
from /controllers/front/ProductController.php:404
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
3 rows browsed
0.906 ms
SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 86140
in /override/classes/db/Db.php:519
from /classes/Product.php:5319
from /controllers/front/ProductController.php:598
from /controllers/front/ProductController.php:253
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.901 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Address.php:364
from /classes/tax/Tax.php:200
from /controllers/front/ProductController.php:360
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.895 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /controllers/front/ProductController.php:385
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.883 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Address.php:364
from /classes/Product.php:4701
from /controllers/front/ProductController.php:352
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.875 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Product.php:2800
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.846 ms
SELECT d.*, dl.*,
ds.`show_label`,
ds.`show_description`,
ds.`show_placeholder`,
ds.`show_image`,
ds.`width`,
ds.`visibility`,
ds.`required`
FROM `ps_dz_cart_customer_field` d
LEFT JOIN `ps_dz_cart_customer_field_lang` dl
ON d.`id_dz_cart_customer_field` = dl.`id_dz_cart_customer_field`
AND dl.`id_lang` = 2
LEFT JOIN `ps_dz_cart_customer_field_show` ds
ON d.`id_dz_cart_customer_field` = ds.`id_dz_cart_customer_field`
WHERE d.`active`
AND ds.`active`
AND ds.`type` = "register"
ORDER BY ds.`position` ASC
in /override/classes/db/Db.php:519
from /modules/dz_cart/classes/DzCartCustomerFieldShow.php:379
from /modules/dz_cart/dz_cart.php:962
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php:32
from /cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php:32
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/dz_cart/dz_cart.php:1053
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
23 rows browsed
0.846 ms
SELECT c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
WHERE c.nleft <= 64
AND c.nright >= 85
AND c.nleft >= 2
AND c.nright <= 6141
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
in /override/classes/db/Db.php:519
from /classes/Tools.php:1061
from /controllers/front/ProductController.php:619
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
33 rows browsed
0.844 ms
SELECT pc.`id_product_comment`,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful,
(SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice,
IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title
FROM `ps_product_comment` pc
LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer`
WHERE pc.`id_product` = 86140 AND pc.`validate` = 1
ORDER BY pc.`date_add` DESC
in /override/classes/db/Db.php:519
from /modules/productcomments/ProductComment.php:114
from /modules/productcomments/productcomments.php:741
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:312
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
1 row browsed
0.837 ms
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 2
LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1
WHERE (a.id_product = 86140) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:479
from /override/classes/Product.php:30
from /classes/Link.php:102
from /classes/Link.php:541
from /classes/controller/FrontController.php:344
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.836 ms
SELECT * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
in /override/classes/db/Db.php:519
from /classes/module/Module.php:1718
from /classes/Hook.php:469
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:760
from /controllers/front/ProductController.php:36
from /tools/profiling/Controller.php:207
from /classes/Dispatcher.php:373
from /index.php:68
132 rows browsed
0.815 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
0.808 ms
SELECT DISTINCT
p.id_product
FROM ps_product p
LEFT JOIN ps_category_product cp ON cp.id_product = p.id_product
LEFT JOIN ps_category_lang cl ON cl.id_category = cp.id_category AND cl.id_lang = 1
left JOIN ps_category c on c.id_category = cl.id_category
where c.id_parent = 58755 and p.id_product = 86140
in /override/classes/db/Db.php:519
from /controllers/front/ProductController.php:271
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
12 rows browsed
0.8 ms
SELECT DISTINCT c.id_category from ps_category c left join ps_category_product cp on cp.id_category = c.id_category left join ps_product p on p.id_product = cp.id_product where p.id_product = 86140 and c.id_parent = 58755 order by c.id_category desc
in /override/classes/db/Db.php:519
from /controllers/front/ProductController.php:284
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
4 rows browsed
0.791 ms
SELECT pcc.`id_product_comment_criterion`, pccl.`name`
FROM `ps_product_comment_criterion` pcc
LEFT JOIN `ps_product_comment_criterion_lang` pccl
ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion)
LEFT JOIN `ps_product_comment_criterion_product` pccp
ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 86140)
LEFT JOIN `ps_product_comment_criterion_category` pccc
ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`)
LEFT JOIN `ps_product_shop` ps
ON (ps.id_category_default = pccc.id_category AND ps.id_product = 86140)
WHERE pccl.`id_lang` = 2
AND (
pccp.id_product IS NOT NULL
OR ps.id_product IS NOT NULL
OR pcc.id_product_comment_criterion_type = 1
)
AND pcc.active = 1
GROUP BY pcc.id_product_comment_criterion
in /override/classes/db/Db.php:519
from /modules/productcomments/ProductCommentCriterion.php:184
from /modules/productcomments/productcomments.php:785
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:309
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsedUseless GROUP BY need to be removed
0.791 ms
SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
in /override/classes/db/Db.php:519
from /override/classes/Category.php:895
from /override/classes/Category.php:848
from /controllers/front/ProductController.php:642
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
5 rows browsedUseless GROUP BY need to be removed
0.778 ms
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1
WHERE (a.id_product = 86140)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:479
from /override/classes/Product.php:30
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.773 ms
SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'attribute.ua' OR su.domain_ssl = 'attribute.ua')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /override/classes/db/Db.php:519
from /classes/shop/Shop.php:329
from /config/config.inc.php:96
from /index.php:67
USING FILESORT -
1 row browsed
0.75 ms
SELECT dz.*,
dzl.*
FROM `ps_dzfilterseo` dz
LEFT JOIN `ps_dzfilterseo_lang` dzl
ON dz.`id_dzfilterseo` = dzl.`id_dzfilterseo`
AND dzl.`id_lang` = 2
WHERE dz.`type` = "action"
AND dz.`action_product_clock` = 1
AND dz.`date_to` > NOW()
AND dz.`products` != ""
in /override/classes/db/Db.php:519
from /modules/dzfilter/classes/DzFilterDb.php:264
from /modules/dzfilter/dzfilter.php:7430
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:309
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.739 ms
SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 86140 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Pack.php:50
from /controllers/front/ProductController.php:197
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.724 ms
SELECT * FROM `ps_dz_word_wrap` w
LEFT JOIN `ps_dz_word_wrap_lang` wl
ON w.`id_word_wrap` = wl.`id_word_wrap` AND wl.`id_lang` = 2
WHERE w.`word_wrap_object` IN ("all", "productall")
OR (w.`word_wrap_object` = "product" AND CONCAT(",",w.`word_wrap_object_id`, ",") LIKE "%,86140,%")
in /override/classes/db/Db.php:519
from /modules/dz_word_wrap/dz_word_wrap.php:207
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
2 rows browsed
0.723 ms
SELECT `id_product` FROM `ps_category_product`
WHERE `id_product` = 86140
AND `id_category` IN(59623,59638,59640,59630,59631,59632,59633,59634,59636,59637,59641,59642)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /modules/dz_word_wrap/dz_word_wrap.php:221
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
12 rows browsed
0.698 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 3) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php:31
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/blocktopmenu/blocktopmenu.php:1000
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.689 ms
SELECT * FROM `ps_state`
WHERE `id_country` = 216
AND `active` = 1
ORDER BY `name` ASC
in /override/classes/db/Db.php:519
from /modules/dz_cart/dz_cart.php:2675
from :undefined
from /modules/dz_cart/dz_cart.php:989
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
25 rows browsed
0.687 ms
SELECT t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=86140
in /override/classes/db/Db.php:519
from /classes/Tag.php:166
from /classes/Product.php:503
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
12 rows browsed
0.674 ms
SELECT *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "module-shopspage-shopsfrontall"
OR m.page = "moduleshopspageshopsfrontall"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Meta.php:142
from /modules/shopspage/shopspage.php:164
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/Dispatcher.php:429
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
2 rows browsed
0.671 ms
SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 2
AND pl.id_product = 86140
AND product_shop.active = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Meta.php:250
from /classes/Meta.php:199
from /classes/controller/FrontController.php:271
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.668 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 156) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /classes/Tools.php:1068
from /controllers/front/ProductController.php:619
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.666 ms
SELECT SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 86140) AND (id_product_attribute = 0) AND (id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/stock/StockAvailable.php:360
from /classes/Product.php:5506
from /classes/Product.php:505
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.66 ms
SELECT *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1)
WHERE `deleted` = 0
AND c.`active` = 1
ORDER BY `name` ASC
in /override/classes/db/Db.php:519
from /classes/Currency.php:219
from /classes/controller/FrontController.php:328
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
9 rows browsed
0.634 ms
SELECT *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1
WHERE (a.id_manufacturer = 77)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Manufacturer.php:105
from /override/classes/Manufacturer.php:35
from /controllers/front/ProductController.php:302
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.626 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 59012) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php:34
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/blocktopmenu/blocktopmenu.php:1000
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.616 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 29) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /controllers/front/ProductController.php:180
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.61 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 12) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php:37
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/blocktopmenu/blocktopmenu.php:1000
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.61 ms
SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 86140
AND pccl.`id_lang` = 2 AND pc.`validate` = 1
in /override/classes/db/Db.php:519
from /modules/productcomments/ProductComment.php:168
from /modules/productcomments/ProductComment.php:186
from /modules/productcomments/productcomments.php:804
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.601 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 140) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php:46
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/blocktopmenu/blocktopmenu.php:1000
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.595 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 16)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php:180
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:152
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.581 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /modules/dz_cart/dz_cart.php:1014
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.579 ms
SELECT *
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 86140
AND pc.`id_customer` = 0
ORDER BY pc.`date_add` DESC LIMIT 1
in /override/classes/db/Db.php:519
from /modules/productcomments/ProductComment.php:137
from /modules/productcomments/productcomments.php:769
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:309
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
1 row browsed
0.577 ms
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 86140
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 100 DAY
)
) > 0
in /override/classes/db/Db.php:519
from /classes/Product.php:1168
from /classes/Product.php:495
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
0 rows browsed
0.574 ms
SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_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 /override/classes/db/Db.php:565
from /classes/shop/Shop.php:199
from /classes/shop/Shop.php:133
from /classes/shop/Shop.php:388
from /config/config.inc.php:96
from /index.php:67
1 row browsed
0.572 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
0.57 ms
SELECT *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 2
LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1
WHERE (a.id_category = 35) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /override/classes/Category.php:152
from /override/classes/Link.php:106
from /cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php:43
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/module/Module.php:1861
from /modules/blocktopmenu/blocktopmenu.php:1000
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.565 ms
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 86140) AND (id_product_attribute = 0) AND (id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/stock/StockAvailable.php:692
from /classes/Product.php:5507
from /classes/Product.php:505
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.565 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Product.php:493
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.558 ms
SELECT a.*, al.`code` FROM `ps_dz_seo_lang_hook` a
LEFT JOIN `ps_dz_seo_lang_hook_lang` al
ON a.`id_dz_seo_lang_hook` = al.`id_dz_seo_lang_hook`
AND al.`id_lang` = "2"
WHERE a.`active` = 1
in /override/classes/db/Db.php:519
from /modules/dz_seo_lang/classes/SeoCode.php:52
from /modules/dz_seo_lang/dz_seo_lang.php:1249
from /modules/dz_seo_lang/dz_seo_lang.php:993
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
4 rows browsed
0.557 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Address.php:364
from /classes/tax/Tax.php:200
from /controllers/front/ProductController.php:360
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.549 ms
SELECT * FROM `ps_product_lang`
WHERE `id_product` = 86140 AND `id_shop` = 1
in /override/classes/db/Db.php:519
from /classes/ObjectModel.php:220
from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:479
from /override/classes/Product.php:30
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
2 rows browsed
0.544 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /controllers/front/ProductController.php:352
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.536 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1056
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1056
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
0.535 ms
SELECT *
FROM `ps_shop_group` a
WHERE (a.id_shop_group = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:490
from /config/config.inc.php:144
from /index.php:67
1 row browsed
0.533 ms
SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Theme.php:177
from /classes/controller/FrontController.php:78
from /classes/controller/Controller.php:135
from /classes/Dispatcher.php:366
from /index.php:68
1 row browsed
0.528 ms
SELECT a.*, c.`value`, s.`required`
FROM `ps_dz_cart_customer_field` a
LEFT JOIN `ps_dz_cart_customer_field_value` c
ON c.`id_dz_cart_customer_field` = a.`id_dz_cart_customer_field`
AND c.`type` = "address"
AND c.`id_object` = "0"
LEFT JOIN `ps_dz_cart_customer_field_show` s
ON s.`name` = a.`name`
AND s.`active` = 1
AND s.`type` = "customer"
WHERE a.`active` = 1
AND a.`field_type` = "address"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:63
from /classes/Address.php:364
from /classes/Product.php:4701
from /classes/Product.php:493
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.524 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
0.522 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 9)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php:189
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:152
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.521 ms
SELECT COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 86140 AND `validate` = 1
AND `grade` > 0 LIMIT 1
in /override/classes/db/Db.php:565
from /modules/productcomments/ProductComment.php:244
from /modules/productcomments/ProductComment.php:187
from /modules/productcomments/productcomments.php:804
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.518 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'large_attr' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:154
from /controllers/front/ProductController.php:436
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.516 ms
SELECT *
FROM `ps_themeconfigurator`
WHERE id_shop = 1 AND id_lang = 2
AND hook = 'footer' AND active = 1
ORDER BY item_order ASC
in /override/classes/db/Db.php:519
from /modules/themeconfigurator/themeconfigurator.php:331
from /modules/themeconfigurator/themeconfigurator.php:314
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
14 rows browsed
0.516 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /controllers/front/ProductController.php:385
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.515 ms
SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position`
FROM `ps_dzseovideopage` dzv
LEFT JOIN `ps_dzseovideopage_lang` dzvl
ON dzv.`id_video` = dzvl.`id_video`
WHERE dzvl.`id_lang` = 2 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:215
from /modules/dzseovideopage/dzseovideopage.php:199
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
USING FILESORT -
131 rows browsed
0.509 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 21)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php:183
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:152
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.507 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Product.php:2800
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.503 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Product.php:493
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.496 ms
SELECT *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.id_country = b.id_country AND b.id_lang = 1
LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1
WHERE (a.id_country = 216)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:121
from /index.php:67
1 row browsed
0.493 ms
SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 86140
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /modules/productcomments/ProductComment.php:180
from /modules/productcomments/productcomments.php:771
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:309
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.488 ms
SELECT id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ObjectModel.php:1262
from /classes/Tools.php:355
from /classes/controller/FrontController.php:157
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.488 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Address.php:364
from /classes/Product.php:4701
from /controllers/front/ProductController.php:352
from /controllers/front/ProductController.php:245
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.487 ms
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1
LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1
WHERE (a.id_product = 86140) AND (b.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Product.php:479
from /override/classes/Product.php:30
from /classes/Link.php:102
from /modules/dz_seo_lang/dz_seo_lang.php:777
from /modules/dz_seo_lang/dz_seo_lang.php:1016
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.485 ms
SELECT GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 86140 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Pack.php:166
from /controllers/front/ProductController.php:258
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
24 rows browsed
0.485 ms
SELECT * FROM `ps_hook_alias`
in /override/classes/db/Db.php:519
from /classes/Hook.php:183
from /classes/Hook.php:202
from /classes/Hook.php:373
from /tools/profiling/Hook.php:50
from /classes/Dispatcher.php:429
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
88 rows browsed
0.485 ms
SELECT depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 86140) AND (id_product_attribute = 0) AND (id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/stock/StockAvailable.php:669
from /classes/Product.php:5508
from /classes/Product.php:505
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.469 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Address.php:364
from /classes/Product.php:4701
from /classes/Product.php:493
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.459 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.459 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 23)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php:186
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:152
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.456 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 10)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php:192
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php:152
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /tools/smarty/sysplugins/smarty_internal_template.php:286
from /cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php:42
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/Controller.php:444
from /classes/controller/FrontController.php:549
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.454 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'attr_cart' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:156
from /controllers/front/ProductController.php:444
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.454 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Customer.php:41
from /config/config.inc.php:198
from /index.php:67
28 rows browsed
0.448 ms
SELECT l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
ORDER BY l.`id_lang` DESC
in /override/classes/db/Db.php:519
from /override/classes/Language.php:42
from /config/config.inc.php:118
from /index.php:67
1 row browsed
0.444 ms
SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade
FROM `ps_product_comment` pc
WHERE pc.`id_product` = 86140
AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /modules/productcomments/ProductComment.php:180
from /modules/productcomments/productcomments.php:737
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:312
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.444 ms
SELECT `id_module` FROM `ps_module` WHERE `name` = "powatag" LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:2058
from /classes/module/Module.php:1758
from /modules/powatag/powatag.php:61
from /classes/module/Module.php:1016
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.444 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'attr_home' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:156
from /controllers/front/ProductController.php:443
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.443 ms
SELECT `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:2058
from /classes/module/Module.php:1758
from /controllers/front/ProductController.php:181
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.44 ms
SELECT *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.id_group = c.id_group AND c.id_shop = 1
WHERE (a.id_group = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:174
from /classes/controller/FrontController.php:229
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.432 ms
SELECT cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1
AND cl.`id_category` = 29 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Category.php:1024
from /classes/Product.php:509
from /override/classes/Product.php:30
from /classes/Link.php:102
from /classes/Link.php:541
from /classes/controller/FrontController.php:344
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.431 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /classes/Link.php:102
from /classes/Link.php:541
from /classes/controller/FrontController.php:344
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.427 ms
SELECT product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
WHERE (p.`id_product` = 86140)
in /override/classes/db/Db.php:519
from /classes/Product.php:2852
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.422 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'medium_attr' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:154
from /controllers/front/ProductController.php:441
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.422 ms
SELECT image_shop.`id_image`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 86140
AND image_shop.`cover` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Product.php:2629
from /modules/socialsharing/socialsharing.php:172
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
3 rows browsed
0.42 ms
SELECT `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 86140
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ProductDownload.php:178
from /controllers/front/ProductController.php:203
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.419 ms
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default'
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Image.php:382
from /controllers/front/ProductController.php:444
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.419 ms
SELECT *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.id_currency = c.id_currency AND c.id_shop = 1
WHERE (a.id_currency = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Currency.php:103
from /classes/Currency.php:429
from /classes/Tools.php:442
from /classes/controller/FrontController.php:179
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.419 ms
SELECT id_shop
FROM `ps_product_shop`
WHERE `id_product` = 86140
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ObjectModel.php:1262
from /controllers/front/ProductController.php:111
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.415 ms
SELECT COUNT(`id_product_comment`) AS "nbr"
FROM `ps_product_comment` pc
WHERE `id_product` = 86140 AND `validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /modules/productcomments/ProductComment.php:223
from /modules/productcomments/productcomments.php:789
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:309
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.411 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'home_attr' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:154
from /controllers/front/ProductController.php:443
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.409 ms
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default'
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Image.php:382
from /controllers/front/ProductController.php:436
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.406 ms
SELECT *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1
WHERE (a.id_lang = 2)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /classes/Tools.php:413
from /classes/Dispatcher.php:225
from /classes/Dispatcher.php:193
from /index.php:68
1 row browsed
0.403 ms
SELECT *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = 1
WHERE (a.id_lang = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Language.php:90
from /config/config.inc.php:173
from /index.php:67
1 row browsed
0.402 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'attr_medium' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:156
from /controllers/front/ProductController.php:441
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.4 ms
SELECT `id_module` FROM `ps_module` WHERE `name` = "dzfilter" LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:2058
from /classes/module/Module.php:1758
from /override/classes/controller/FrontController.php:270
from /modules/productcomments/productcomments.php:837
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.397 ms
SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:2058
from /classes/module/Module.php:1758
from /classes/Product.php:5244
from /controllers/front/ProductController.php:598
from /controllers/front/ProductController.php:253
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.395 ms
SELECT `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 86140
ORDER BY `id_specific_price_priority` DESC
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/SpecificPrice.php:192
from /classes/SpecificPrice.php:172
from /classes/SpecificPrice.php:218
from /classes/Product.php:2830
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.389 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dz_seo_lang/dz_seo_lang.php:1198
from /modules/dz_seo_lang/dz_seo_lang.php:993
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:784
from /tools/profiling/Controller.php:233
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.386 ms
SELECT `active` FROM `ps_dz_pen_constructor`
WHERE `id_product` = "86140"
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /controllers/front/ProductController.php:292
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.385 ms
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default'
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Image.php:382
from /controllers/front/ProductController.php:441
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.383 ms
SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes`
FROM `ps_image_type`
WHERE
`name` LIKE 'cart_attr' LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ImageType.php:141
from /classes/ImageType.php:154
from /controllers/front/ProductController.php:444
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.38 ms
SELECT id_shop
FROM `ps_category_shop`
WHERE `id_category` = 29
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ObjectModel.php:1262
from /controllers/front/ProductController.php:618
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.378 ms
SELECT cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1
AND cl.`id_category` = 29 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Category.php:1024
from /classes/Product.php:509
from /override/classes/Product.php:30
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
0 rows browsed
0.377 ms
SELECT fvl.id_feature_value FROM ps_feature_value_lang fvl
LEFT JOIN ps_feature_product fp
ON fp.id_feature_value = fvl.id_feature_value
LEFT JOIN ps_feature_lang fl
ON fl.id_feature = fp.id_feature
WHERE fl.name = "Серия"
AND fp.id_product = 86140
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /modules/productscategory/productscategory.php:257
from /modules/productscategory/productscategory.php:195
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:587
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:587
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
25 rows browsed
0.377 ms
SELECT nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/Category.php:1394
from /override/classes/Category.php:1412
from /controllers/front/ProductController.php:618
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.376 ms
SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Language.php:637
from /classes/Dispatcher.php:470
from /classes/Dispatcher.php:230
from /classes/Dispatcher.php:193
from /index.php:68
1 row browsed
0.374 ms
SELECT `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default'
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/Image.php:382
from /controllers/front/ProductController.php:443
from /controllers/front/ProductController.php:248
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.373 ms
SELECT `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 86140 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Product.php:4690
from /classes/Product.php:2894
from /classes/Product.php:2769
from /classes/Product.php:500
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.373 ms
SELECT out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 86140) AND (id_product_attribute = 0) AND (id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/stock/StockAvailable.php:692
from /classes/Product.php:5507
from /classes/Product.php:505
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.369 ms
SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion`
FROM `ps_product_comment` pc
LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`)
LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`)
WHERE pc.`id_product` = 86140
AND pccl.`id_lang` = 2 AND pc.`validate` = 1
in /override/classes/db/Db.php:519
from /modules/productcomments/ProductComment.php:168
from /modules/productcomments/ProductComment.php:186
from /modules/productcomments/productcomments.php:804
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1085
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1085
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.367 ms
SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Supplier.php:176
from /classes/Product.php:488
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
0 rows browsed
0.359 ms
SELECT * FROM `ps_group_lang`
WHERE `id_group` = 1
in /override/classes/db/Db.php:519
from /classes/ObjectModel.php:220
from /tools/profiling/ObjectModel.php:37
from /classes/Group.php:75
from /classes/Group.php:312
from /classes/Cart.php:174
from /classes/controller/FrontController.php:229
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
2 rows browsed
0.354 ms
SELECT `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
AND `active` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Manufacturer.php:232
from /classes/Product.php:487
from /override/classes/Product.php:30
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.354 ms
SELECT id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ObjectModel.php:1262
from /classes/Group.php:314
from /classes/Cart.php:174
from /classes/controller/FrontController.php:229
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.354 ms
SELECT * FROM `ps_gender_lang`
WHERE `id_lang` = 2
in /override/classes/db/Db.php:519
from /modules/dz_cart/dz_cart.php:2665
from :undefined
from /modules/dz_cart/dz_cart.php:989
from /modules/dz_cart/dz_cart.php:1071
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
4 rows browsed
0.345 ms
SELECT p.id_product
FROM `ps_product` p
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 86140
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
NOW(),
INTERVAL 100 DAY
)
) > 0
in /override/classes/db/Db.php:519
from /classes/Product.php:1168
from /classes/Product.php:495
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
0 rows browsed
0.343 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /controllers/front/ProductController.php:313
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.343 ms
SELECT COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Currency.php:443
from /classes/Currency.php:449
from /classes/module/Module.php:1837
from /modules/socialsharing/socialsharing.php:166
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
3 rows browsed
0.339 ms
SELECT *
FROM `ps_theme` a
WHERE (a.id_theme = 2)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /config/config.inc.php:97
from /index.php:67
1 row browsed
0.336 ms
SELECT *
FROM `ps_shop` a
WHERE (a.id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/shop/Shop.php:131
from /classes/shop/Shop.php:388
from /config/config.inc.php:96
from /index.php:67
1 row browsed
0.328 ms
SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/Language.php:637
from /classes/Tools.php:402
from /classes/Dispatcher.php:225
from /classes/Dispatcher.php:193
from /index.php:68
1 row browsed
0.326 ms
SELECT id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/ObjectModel.php:1262
from /classes/Tools.php:445
from /classes/controller/FrontController.php:179
from /override/classes/controller/FrontController.php:31
from /controllers/front/ProductController.php:84
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.322 ms
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:1781
from /controllers/front/ProductController.php:181
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.318 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Product.php:493
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.317 ms
SELECT nleft, nright, level_depth
FROM ps_category
WHERE id_category = 29 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/Category.php:1394
from /classes/Tools.php:1045
from /controllers/front/ProductController.php:619
from /controllers/front/ProductController.php:243
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.312 ms
SELECT t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=86140
in /override/classes/db/Db.php:519
from /classes/Tag.php:166
from /classes/Product.php:503
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
12 rows browsed
0.306 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 6)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:900
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.301 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /controllers/front/ProductController.php:87
from /tools/profiling/Controller.php:195
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.293 ms
SELECT fp.id_feature_value FROM ps_feature_lang fl
LEFT JOIN ps_feature_product fp
ON fp.id_feature = fl.id_feature
WHERE fl.name = "Вид изделия"
AND fp.id_product = 86140
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /modules/productscategory/productscategory.php:266
from /modules/productscategory/productscategory.php:195
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:587
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:587
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
25 rows browsed
0.282 ms
SELECT a.*, al.`code` FROM `ps_dz_seo_lang_hook` a
LEFT JOIN `ps_dz_seo_lang_hook_lang` al
ON a.`id_dz_seo_lang_hook` = al.`id_dz_seo_lang_hook`
AND al.`id_lang` = "2"
WHERE a.`active` = 1
in /override/classes/db/Db.php:519
from /modules/dz_seo_lang/classes/SeoCode.php:52
from /modules/dz_seo_lang/dz_seo_lang.php:1249
from /modules/dz_seo_lang/dz_seo_lang.php:1026
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
4 rows browsed
0.276 ms
SELECT * FROM `ps_dz_cart_customer_field` a
WHERE a.`active` = 1
AND a.`field_type` = "customer"
in /override/classes/db/Db.php:519
from /override/classes/Address.php:41
from /classes/Address.php:364
from /classes/Product.php:4701
from /classes/Product.php:493
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
28 rows browsed
0.266 ms
SELECT depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 86140) AND (id_product_attribute = 0) AND (id_shop = 1)
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/stock/StockAvailable.php:669
from /classes/Product.php:5508
from /classes/Product.php:505
from /override/classes/Product.php:30
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.264 ms
SELECT *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 2
LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1
WHERE (a.id_cms = 24)
LIMIT 1
in /override/classes/db/Db.php:565
from /classes/ObjectModel.php:213
from /tools/profiling/ObjectModel.php:37
from /classes/Link.php:242
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1237
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.251 ms
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /classes/module/Module.php:1781
from /modules/powatag/powatag.php:61
from /classes/module/Module.php:1016
from /classes/Hook.php:463
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.223 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.223 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.218 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /classes/Link.php:102
from /modules/dz_seo_lang/dz_seo_lang.php:777
from /modules/dz_seo_lang/dz_seo_lang.php:1016
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.212 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/powatag/powatag.php:311
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.207 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.204 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.204 ms
SELECT `id_video`
FROM `ps_dzseovideopage_products`
WHERE `id_product` = 86140
in /override/classes/db/Db.php:519
from /modules/dzseovideopage/classes/DzSeoVideoPageModel.php:158
from /modules/dzseovideopage/dzseovideopage.php:181
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1056
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1056
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
189 rows browsed
0.2 ms
SELECT COUNT(pc.`id_product`) AS nbr
FROM `ps_product_comment` pc
WHERE `id_product` = 86140 AND `validate` = 1
AND `grade` > 0 LIMIT 1
in /override/classes/db/Db.php:565
from /modules/productcomments/ProductComment.php:244
from /modules/productcomments/ProductComment.php:187
from /modules/productcomments/productcomments.php:804
from /classes/Hook.php:516
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1085
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1085
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.197 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1068
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.193 ms
SELECT cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1
AND cl.`id_category` = 29 LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Category.php:1024
from /classes/Product.php:509
from /override/classes/Product.php:30
from /classes/Link.php:102
from /modules/dz_seo_lang/dz_seo_lang.php:777
from /modules/dz_seo_lang/dz_seo_lang.php:1016
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.174 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /classes/Link.php:102
from /modules/dz_seo_lang/dz_seo_lang.php:777
from /modules/dz_seo_lang/dz_seo_lang.php:1016
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.169 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1074
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.169 ms
SELECT `link_rewrite` FROM `ps_dzfilterseo_lang`
WHERE `id_dzfilterseo` = 225
AND `id_lang` = 2
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /modules/dzfilter/classes/DzFilterDb.php:211
from /override/classes/Link.php:193
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1279
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.168 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dz_seo_lang/dz_seo_lang.php:1198
from /modules/dz_seo_lang/dz_seo_lang.php:1026
from /modules/dz_seo_lang/dz_seo_lang.php:1179
from /classes/Hook.php:514
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /classes/controller/FrontController.php:432
from /controllers/front/ProductController.php:193
from /tools/profiling/Controller.php:227
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.16 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:1051
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.159 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/db/Db.php:590
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed
0.159 ms
SELECT `id_category` FROM `ps_manufacturer`
WHERE `id_manufacturer` = 77
LIMIT 1
in /override/classes/db/Db.php:565
from /override/classes/Manufacturer.php:43
from /override/classes/Product.php:32
from /modules/dzseovideopage/dzseovideopage.php:191
from /classes/Hook.php:514
from /tools/profiling/Hook.php:60
from /config/smarty.config.inc.php:188
from :undefined
from /config/smarty.config.inc.php:241
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php:931
from /tools/smarty/sysplugins/smarty_internal_templatebase.php:180
from /classes/controller/FrontController.php:540
from /tools/profiling/Controller.php:299
from /tools/profiling/Controller.php:249
from /classes/Dispatcher.php:373
from /index.php:68
1 row browsed