Качка (Гусак) De Rosa Rinconada (Де Роса Рінконада), купити в Україні

Load time: 2.764s
You'd better run your shop on a toaster

config: 88ms
constructor: 0ms
init: 30ms
checkAccess: 0ms
setMedia: 16ms
postProcess: 0ms
initHeader: 0ms
initContent: 666ms
initFooter: 83ms
display: 1.88s

Hook processing: 692ms / 9.73 Mb
237 methods called in 42 modules

displayHeader: 610ms / 6.23 Mb
moduleRoutes: 27ms / 2.54 Mb
displayTop: 22ms / 0.24 Mb
dzCartLogin: 11ms / 0.25 Mb
displayLeftColumn: 10ms / 0.03 Mb
displayClickZone: 3ms / 0.08 Mb
processToolsRequest: 2ms / 0.15 Mb
actionFrontControllerSetMedia: 2ms / 0.07 Mb
dzCartAuth: 1ms / 0.03 Mb
dzCartFavorite: 1ms / 0.03 Mb
displayFooter: 0ms / 0.03 Mb
dzSeoLang: 0ms / 0.03 Mb
displayFooterTop: 0ms / 0.02 Mb
dzAjaxLoad: 0ms / 0 Mb
actionProductListOverride: 0ms / 0 Mb
dzDebug: 0ms / 0 Mb
displayTopColumn: 0ms / 0 Mb
dzOrderGiftAvailable: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb
actionProductListModifier: 0ms / 0 Mb
showPopupChooseLanguage: 0ms / 0 Mb

Memory peak usage: 261.9 Mb

config: 6.12 Mb (6.2 Mb)
constructor: 0 Mb (6.2 Mb)
init: 1.18 Mb (7.4 Mb)
checkAccess: 0 Mb (7.4 Mb)
setMedia: 0.16 Mb (7.6 Mb)
postProcess: 0 Mb (7.6 Mb)
initHeader: 0 Mb (7.6 Mb)
initContent: 6.86 Mb (14.9 Mb)
initFooter: 1.01 Mb (15.8 Mb)
display: 10.97 Mb (261.9 Mb)

Total cache size (in Cache class): 0 Mb

DB type: DbPDO
SQL Queries: 175 queries
Time spent querying: 785ms

Included files: 328
Size of included files: 5.75 Mb

Globals (> 1 Ko only): 1683 Ko

_MODULES ≈ 1300 Ko
_LANG ≈ 210.8 Ko
context ≈ 155 Ko
_SERVER ≈ 8.5 Ko
_MODULE ≈ 4 Ko
_GET ≈ 1.1 Ko

Go to Stopwatch
Go to Doubles
Go to Tables
Go to ObjectModels
Display queries table
Go to files

Time (ms)	Rows	Query	Location	Filesort	Group By
686.307	152341	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	/override/classes/db/Db.php:519	Yes
5.721	1536	SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite, c.kind FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 1995 AND nright <= 1996 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (3) ) ORDER BY cl.`name` ASC	/override/classes/db/Db.php:519	Yes
4.616	67	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`	/override/classes/db/Db.php:519	Yes	Yes
4.068	704	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`)	/override/classes/db/Db.php:519
3.169	3071	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 <= 1995 AND c.nright >= 1996 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	/override/classes/db/Db.php:519	Yes
2.756	97	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	/override/classes/db/Db.php:519	Yes
2.1	337	SELECT * FROM `ps_state` ORDER BY `name` ASC	/override/classes/db/Db.php:519	Yes
1.991	0	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	/override/classes/db/Db.php:519
1.803	7	SELECT catr.*, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name` FROM `ps_cat_filter_restriction_2` catr LEFT JOIN `ps_image` i ON i.`id_product` = catr.`id_product` AND i.`cover` = 1 LEFT JOIN `ps_product_lang` pl ON (catr.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) WHERE catr.`active` = 1 AND catr.`id_category_default` != 1 AND catr.`id_product` IN (SELECT `id_product` FROM `ps_category_product` WHERE `id_category` IN (226)) AND catr.`visibility` IN("both", "catalog") GROUP BY catr.`id_product` ORDER BY catr.`stock` desc,catr.`sortcode` asc LIMIT 0,30	/override/classes/db/Db.php:519	Yes	Yes
1.619	97	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	/override/classes/db/Db.php:519
1.588	2	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	/override/classes/db/Db.php:565
1.321	1	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` = 226 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` desc, category_shop.`position` desc	/override/classes/db/Db.php:519	Yes	Yes
1.142	28	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"	/override/classes/db/Db.php:519
1.127	43	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	/override/classes/db/Db.php:519	Yes
1.114	25	SELECT * FROM `ps_state` WHERE `id_country` = 216 AND `active` = 1 ORDER BY `name` ASC	/override/classes/db/Db.php:519	Yes
1.104	244	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	/override/classes/db/Db.php:519	Yes
1.011	1	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	/override/classes/db/Db.php:519	Yes
0.975	9	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	/override/classes/db/Db.php:519	Yes
0.946	28	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"	/override/classes/db/Db.php:519
0.939	132	SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)	/override/classes/db/Db.php:519
0.89	2071	SELECT GROUP_CONCAT(`id_category`) FROM `ps_category` WHERE `nleft` > 1995 AND `nright` < 1996 LIMIT 1	/override/classes/db/Db.php:565
0.864	28	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"	/override/classes/db/Db.php:519
0.835	1	SELECT s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 226 AND sl.id_lang = 2 AND s.active = 1 ORDER BY sl.name ASC	/override/classes/db/Db.php:519	Yes
0.812	2166	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 c.end_action > now()	/override/classes/db/Db.php:519
0.793	3	SELECT pa.id_product, a.color, pac.id_product_attribute, 0 qty FROM ps_product_attribute pa 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) JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = product_attribute_shop.id_product_attribute) JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) JOIN ps_attribute_group ag ON (ag.id_attribute_group = ag.id_attribute_group) WHERE pa.id_product IN (90291,90290,87744,87745,87765,90160,2464) AND ag.is_color_group = 1 GROUP BY pa.id_product, color	/override/classes/db/Db.php:519	Yes	Yes
0.76	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90290) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.723	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90291) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.714	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 2464) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.702	1	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	/override/classes/db/Db.php:519
0.701	3	SELECT s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) ORDER BY s.`name` ASC	/override/classes/db/Db.php:519	Yes
0.697	1	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	/override/classes/db/Db.php:565
0.689	1	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	/override/classes/db/Db.php:565
0.688	1	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 = 226) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.686	1	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 = "category" LIMIT 1	/override/classes/db/Db.php:565
0.682	3	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	/override/classes/db/Db.php:565
0.672	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87744) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.659	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87765) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.653	1	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	/override/classes/db/Db.php:565
0.651	1	SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a INNER JOIN `ps_dzfilter_actionbox_category` b ON a.`id_dzfilter_actionbox` = b.`id_dzfilter_actionbox` AND b.`id_category` = 226 LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() ORDER BY a.`position` ASC	/override/classes/db/Db.php:519	Yes
0.642	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90160) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.639	1	SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1	/override/classes/db/Db.php:565
0.637	25	SELECT *, "1" AS controller FROM `ps_dzfilter_category` dzcat LEFT JOIN `ps_dzfilter` dz ON dz.`id_item` = dzcat.`id_item` WHERE dzcat.`id_category` = 226 AND dz.`active` = 1 LIMIT 1	/override/classes/db/Db.php:519
0.636	32	SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87745) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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	/override/classes/db/Db.php:565	Yes
0.627	1	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	/override/classes/db/Db.php:565
0.603	2	SELECT IFNULL(cl.name, '') as name FROM ps_category c INNER JOIN ps_category_lang cl ON cl.id_category = c.id_parent AND cl.id_lang = 1 WHERE c.id_category = 226 AND c.level_depth > 2 LIMIT 1	/override/classes/db/Db.php:565
0.601	1	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	/override/classes/db/Db.php:565
0.589	1	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	/override/classes/db/Db.php:565
0.576	28	SELECT * FROM `ps_dz_cart_customer_field` a WHERE a.`active` = 1 AND a.`field_type` = "customer"	/override/classes/db/Db.php:519
0.566	88	SELECT * FROM `ps_hook_alias`	/override/classes/db/Db.php:519
0.564	9	SELECT name, value, pf.id_feature 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 = 90291 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.56	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "powatag" LIMIT 1	/override/classes/db/Db.php:565
0.552	23	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	/override/classes/db/Db.php:519	Yes
0.539	1	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	/override/classes/db/Db.php:565
0.529	1	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	/override/classes/db/Db.php:565
0.529	7	SELECT count(catr.`id_product`) FROM `ps_cat_filter_restriction_2` catr WHERE catr.`active` = 1 AND catr.`id_category_default` != 1 AND catr.`id_product` IN (SELECT `id_product` FROM `ps_category_product` WHERE `id_category` IN (226)) AND catr.`visibility` IN("both", "catalog") ORDER BY NULL LIMIT 1	/override/classes/db/Db.php:565
0.528	1	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 226) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.52	2	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", "categoryall") OR (w.`word_wrap_object` = "category" AND CONCAT(",",w.`word_wrap_object_id`, ",") LIKE "%,226,%") AND w.`word_wrap_type` = "description"	/override/classes/db/Db.php:519
0.516	14	SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 2 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC	/override/classes/db/Db.php:519	Yes
0.515	28	SELECT * FROM `ps_dz_cart_customer_field` a WHERE a.`active` = 1 AND a.`field_type` = "customer"	/override/classes/db/Db.php:519
0.508	1	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	/override/classes/db/Db.php:565
0.505	1	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	/override/classes/db/Db.php:565
0.498	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_category' LIMIT 1	/override/classes/db/Db.php:565
0.495	1	SELECT domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.493	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "dzfilter" LIMIT 1	/override/classes/db/Db.php:565
0.489	28	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"	/override/classes/db/Db.php:519
0.488	23	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	/override/classes/db/Db.php:519	Yes
0.487	28	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"	/override/classes/db/Db.php:519
0.47	1	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	/override/classes/db/Db.php:565
0.468	13	SELECT name, value, pf.id_feature 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 = 87745 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.466	1	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	/override/classes/db/Db.php:565
0.455	9	SELECT name, value, pf.id_feature 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 = 90290 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.454	11	SELECT name, value, pf.id_feature 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 = 2464 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.444	13	SELECT name, value, pf.id_feature 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 = 87744 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.442	100	SELECT * FROM `ps_dzfilter_feature` WHERE `id_item` = 29 AND `active` = 1 ORDER BY `position`	/override/classes/db/Db.php:519	Yes
0.441	1	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 = 90291) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.437	1	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 = 87745) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.43	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_medium' LIMIT 1	/override/classes/db/Db.php:565
0.421	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90291) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.421	1	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 = 87744) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.419	13	SELECT name, value, pf.id_feature 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 = 87765 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.415	12	SELECT name, value, pf.id_feature 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 = 90160 ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
0.413	1	SELECT * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.412	1	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 = 90160) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.411	1	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 = 87765) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.408	1	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 = 90290) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.407	1	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	/override/classes/db/Db.php:565
0.403	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1	/override/classes/db/Db.php:565
0.402	1	SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1	/override/classes/db/Db.php:565
0.401	1	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 = 2464) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.399	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_m_scene' LIMIT 1	/override/classes/db/Db.php:565
0.396	2	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'category_attr' LIMIT 1	/override/classes/db/Db.php:565
0.388	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1	/override/classes/db/Db.php:565
0.383	2	SELECT * FROM `ps_group_lang` WHERE `id_group` = 1	/override/classes/db/Db.php:519
0.379	4	SELECT * FROM `ps_gender_lang` WHERE `id_lang` = 2	/override/classes/db/Db.php:519
0.374	1	SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 2 AND cl.`id_category` = 226 AND cl.id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.371	1	SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1	/override/classes/db/Db.php:565
0.36	1	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 2 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.359	1	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	/override/classes/db/Db.php:565
0.359	2	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'm_scene_attr' LIMIT 1	/override/classes/db/Db.php:565
0.359	1	SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1	/override/classes/db/Db.php:565
0.356	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'medium_attr' LIMIT 1	/override/classes/db/Db.php:565
0.353	1	SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 226 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.349	4	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	/override/classes/db/Db.php:519
0.349	1	SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a INNER JOIN `ps_dzfilter_actionbox_category` b ON a.`id_dzfilter_actionbox` = b.`id_dzfilter_actionbox` AND b.`id_category` = 226 LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() ORDER BY a.`position` ASC	/override/classes/db/Db.php:519	Yes
0.349	1	SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 226 LIMIT 1	/override/classes/db/Db.php:565
0.347	1	SELECT * FROM `ps_theme` a WHERE (a.id_theme = 2) LIMIT 1	/override/classes/db/Db.php:565
0.344	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1	/override/classes/db/Db.php:565
0.335	2	SELECT cl.`name`, cl.`link_rewrite`, cl.`description`, cl.`meta_title`, cl.`meta_keywords`, IF(cl.`meta_description` = "", cl.`description`, IFNULL(cl.`meta_description`, cl.`description`)) as `meta_description`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = c.`id_category` AND cl.`id_lang` = 2 WHERE c.`id_category` = 226 LIMIT 1	/override/classes/db/Db.php:565
0.335	1	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	/override/classes/db/Db.php:565
0.314	1	SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() AND a.`global` = 1 ORDER BY a.`position` ASC	/override/classes/db/Db.php:519	Yes
0.309	1	SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.306	2	SELECT cl.`name`, cl.`link_rewrite`, cl.`description`, cl.`meta_title`, cl.`meta_keywords`, IF(cl.`meta_description` = "", cl.`description`, IFNULL(cl.`meta_description`, cl.`description`)) as `meta_description`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = c.`id_category` AND cl.`id_lang` = 2 WHERE c.`id_category` = 158 LIMIT 1	/override/classes/db/Db.php:565
0.304	1	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 80 AND `id_shop` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.296	1	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 = 1) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.296	1	SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.295	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'home_attr' LIMIT 1	/override/classes/db/Db.php:565
0.292	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87744) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.288	4	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	/override/classes/db/Db.php:519
0.288	1	SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 226 AND ctg.`id_group` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.285	4	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	/override/classes/db/Db.php:519
0.281	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90160) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.274	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87745) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.266	2	SELECT * FROM `ps_category_lang` WHERE `id_category` = 226 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.265	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 2464) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.265	1	SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() AND a.`global` = 1 ORDER BY a.`position` ASC	/override/classes/db/Db.php:519	Yes
0.259	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90290) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.247	28	SELECT * FROM `ps_dz_cart_customer_field` a WHERE a.`active` = 1 AND a.`field_type` = "customer"	/override/classes/db/Db.php:519
0.247	28	SELECT * FROM `ps_dz_cart_customer_field` a WHERE a.`active` = 1 AND a.`field_type` = "customer"	/override/classes/db/Db.php:519
0.247	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87765) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.239	1	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 226) LIMIT 1	/override/classes/db/Db.php:565
0.229	1	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` = 87744)	/override/classes/db/Db.php:519
0.218	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 509 LIMIT 1	/override/classes/db/Db.php:565
0.216	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1	/override/classes/db/Db.php:565
0.212	1	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` = 87745)	/override/classes/db/Db.php:519
0.21	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87744 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.208	1	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	/override/classes/db/Db.php:565
0.205	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90290 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.203	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1	/override/classes/db/Db.php:565
0.202	1	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` = 90290)	/override/classes/db/Db.php:519
0.2	1	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` = 87765)	/override/classes/db/Db.php:519
0.198	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2464 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.197	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87744 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.197	1	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` = 90291)	/override/classes/db/Db.php:519
0.197	1	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	/override/classes/db/Db.php:565
0.196	1	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	/override/classes/db/Db.php:565
0.196	1	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	/override/classes/db/Db.php:565
0.196	1	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` = 90160)	/override/classes/db/Db.php:519
0.193	1	SELECT * FROM `ps_category` WHERE `id_category` = 226 LIMIT 1	/override/classes/db/Db.php:565
0.193	1	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` = 2464)	/override/classes/db/Db.php:519
0.191	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_home' LIMIT 1	/override/classes/db/Db.php:565
0.188	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87765 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.187	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90291 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.185	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87745 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.184	0	SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0	/override/classes/db/Db.php:519
0.169	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 42 LIMIT 1	/override/classes/db/Db.php:565
0.168	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90291 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.167	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 226 LIMIT 1	/override/classes/db/Db.php:565
0.165	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90290 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.164	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90160 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.164	1	SELECT `id_category` FROM `ps_category` WHERE `id_parent` = 0 LIMIT 1	/override/classes/db/Db.php:565
0.164	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90160 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.163	1	SELECT `controller` FROM `ps_dzfilter_controller` WHERE `id_item` = 29 AND `controller` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.162	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 35 LIMIT 1	/override/classes/db/Db.php:565
0.161	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.161	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.16	8	SELECT SUM(`size`) FROM `ps_dzfilter_stats` LIMIT 1	/override/classes/db/Db.php:565
0.159	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.153	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.153	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.15	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87745 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.149	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 2464 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.149	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.149	1	SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.149	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87765 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.147	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565

Stopwatch (with SQL_NO_CACHE) (total = 175)

686.307 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
USING FILESORT - 152341 rows browsed

5.721 ms SELECT c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite, c.kind FROM `ps_category` c INNER JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2 AND cl.id_shop = 1 ) INNER JOIN `ps_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1) WHERE (c.`active` = 1 OR c.`id_category` = 2) AND c.`id_category` != 1 AND `level_depth` <= 5 AND nleft >= 1995 AND nright <= 1996 AND c.id_category IN ( SELECT id_category FROM `ps_category_group` WHERE `id_group` IN (3) ) ORDER BY cl.`name` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1536 rows browsed

4.616 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
USING FILESORT - 67 rows browsed
Useless GROUP BY need to be removed

4.068 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
704 rows browsed

3.169 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 <= 1995 AND c.nright >= 1996 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
USING FILESORT - 3071 rows browsed

2.756 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
USING FILESORT - 97 rows browsed

2.1 ms SELECT * FROM `ps_state` ORDER BY `name` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 337 rows browsed

1.991 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
0 rows browsed

1.803 ms SELECT catr.*, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name` FROM `ps_cat_filter_restriction_2` catr LEFT JOIN `ps_image` i ON i.`id_product` = catr.`id_product` AND i.`cover` = 1 LEFT JOIN `ps_product_lang` pl ON (catr.`id_product` = pl.`id_product` AND pl.`id_lang` = 2) WHERE catr.`active` = 1 AND catr.`id_category_default` != 1 AND catr.`id_product` IN (SELECT `id_product` FROM `ps_category_product` WHERE `id_category` IN (226)) AND catr.`visibility` IN("both", "catalog") GROUP BY catr.`id_product` ORDER BY catr.`stock` desc,catr.`sortcode` asc LIMIT 0,30
in /override/classes/db/Db.php:519
USING FILESORT - 7 rows browsed
Useless GROUP BY need to be removed

1.619 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
97 rows browsed

1.588 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
2 rows browsed

1.321 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` = 226 AND `active` = 1 GROUP BY c.`id_category` ORDER BY `level_depth` desc, category_shop.`position` desc
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed
Useless GROUP BY need to be removed

1.142 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
28 rows browsed

1.127 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
USING FILESORT - 43 rows browsed

1.114 ms SELECT * FROM `ps_state` WHERE `id_country` = 216 AND `active` = 1 ORDER BY `name` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 25 rows browsed

1.104 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
USING FILESORT - 244 rows browsed

1.011 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
USING FILESORT - 1 row browsed

0.975 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
USING FILESORT - 9 rows browsed

0.946 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
28 rows browsed

0.939 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /override/classes/db/Db.php:519
132 rows browsed

0.89 ms SELECT GROUP_CONCAT(`id_category`) FROM `ps_category` WHERE `nleft` > 1995 AND `nright` < 1996 LIMIT 1
in /override/classes/db/Db.php:565
2071 rows browsed

0.864 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
28 rows browsed

0.835 ms SELECT s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 226 AND sl.id_lang = 2 AND s.active = 1 ORDER BY sl.name ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.812 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 c.end_action > now()
in /override/classes/db/Db.php:519
2166 rows browsed

0.793 ms SELECT pa.id_product, a.color, pac.id_product_attribute, 0 qty FROM ps_product_attribute pa 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) JOIN ps_product_attribute_combination pac ON (pac.id_product_attribute = product_attribute_shop.id_product_attribute) JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) JOIN ps_attribute_group ag ON (ag.id_attribute_group = ag.id_attribute_group) WHERE pa.id_product IN (90291,90290,87744,87745,87765,90160,2464) AND ag.is_color_group = 1 GROUP BY pa.id_product, color
in /override/classes/db/Db.php:519
USING FILESORT - 3 rows browsed
Useless GROUP BY need to be removed

0.76 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90290) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.723 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90291) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.714 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 2464) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.702 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
1 row browsed

0.701 ms SELECT s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) ORDER BY s.`name` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 3 rows browsed

0.697 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
1 row browsed

0.689 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
1 row browsed

0.688 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 = 226) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.686 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 = "category" LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.682 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
3 rows browsed

0.672 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87744) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.659 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87765) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.653 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
1 row browsed

0.651 ms SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a INNER JOIN `ps_dzfilter_actionbox_category` b ON a.`id_dzfilter_actionbox` = b.`id_dzfilter_actionbox` AND b.`id_category` = 226 LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() ORDER BY a.`position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.642 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 90160) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.639 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.637 ms SELECT *, "1" AS controller FROM `ps_dzfilter_category` dzcat LEFT JOIN `ps_dzfilter` dz ON dz.`id_item` = dzcat.`id_item` WHERE dzcat.`id_category` = 226 AND dz.`active` = 1 LIMIT 1
in /override/classes/db/Db.php:519
25 rows browsed

0.636 ms SELECT *, ( IF ('2025-09-15 18:21:05' >= `from` AND '2025-09-15 18:21:05' <= `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, 87745) 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:21:05' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:21:05' <= `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
USING FILESORT - 32 rows browsed

0.627 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
1 row browsed

0.603 ms SELECT IFNULL(cl.name, '') as name FROM ps_category c INNER JOIN ps_category_lang cl ON cl.id_category = c.id_parent AND cl.id_lang = 1 WHERE c.id_category = 226 AND c.level_depth > 2 LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.601 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
1 row browsed

0.589 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
1 row browsed

0.576 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
28 rows browsed

0.566 ms SELECT * FROM `ps_hook_alias`
in /override/classes/db/Db.php:519
88 rows browsed

0.564 ms SELECT name, value, pf.id_feature 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 = 90291 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 9 rows browsed

0.56 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "powatag" LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.552 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
USING FILESORT - 23 rows browsed

0.539 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
1 row browsed

0.529 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
1 row browsed

0.529 ms SELECT count(catr.`id_product`) FROM `ps_cat_filter_restriction_2` catr WHERE catr.`active` = 1 AND catr.`id_category_default` != 1 AND catr.`id_product` IN (SELECT `id_product` FROM `ps_category_product` WHERE `id_category` IN (226)) AND catr.`visibility` IN("both", "catalog") ORDER BY NULL LIMIT 1
in /override/classes/db/Db.php:565
7 rows browsed

0.528 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = 1 LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 226) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.52 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", "categoryall") OR (w.`word_wrap_object` = "category" AND CONCAT(",",w.`word_wrap_object_id`, ",") LIKE "%,226,%") AND w.`word_wrap_type` = "description"
in /override/classes/db/Db.php:519
2 rows 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
USING FILESORT - 14 rows browsed

0.515 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
28 rows browsed

0.508 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
1 row browsed

0.505 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
1 row browsed

0.498 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_category' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.495 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
1 row browsed

0.493 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "dzfilter" LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.489 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
28 rows browsed

0.488 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
USING FILESORT - 23 rows browsed

0.487 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
28 rows browsed

0.47 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
1 row browsed

0.468 ms SELECT name, value, pf.id_feature 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 = 87745 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 13 rows browsed

0.466 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
1 row browsed

0.455 ms SELECT name, value, pf.id_feature 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 = 90290 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 9 rows browsed

0.454 ms SELECT name, value, pf.id_feature 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 = 2464 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 11 rows browsed

0.444 ms SELECT name, value, pf.id_feature 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 = 87744 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 13 rows browsed

0.442 ms SELECT * FROM `ps_dzfilter_feature` WHERE `id_item` = 29 AND `active` = 1 ORDER BY `position`
in /override/classes/db/Db.php:519
USING FILESORT - 100 rows browsed

0.441 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 = 90291) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.437 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 = 87745) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.43 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
1 row browsed

0.421 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90291) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.421 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 = 87744) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.419 ms SELECT name, value, pf.id_feature 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 = 87765 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 13 rows browsed

0.415 ms SELECT name, value, pf.id_feature 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 = 90160 ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 12 rows browsed

0.413 ms SELECT * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.412 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 = 90160) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.411 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 = 87765) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.408 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 = 90290) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.407 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
1 row browsed

0.403 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.402 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.401 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 = 2464) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.399 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_m_scene' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.396 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'category_attr' LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.388 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.383 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = 1
in /override/classes/db/Db.php:519
2 rows browsed

0.379 ms SELECT * FROM `ps_gender_lang` WHERE `id_lang` = 2
in /override/classes/db/Db.php:519
4 rows browsed

0.374 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 2 AND cl.`id_category` = 226 AND cl.id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.371 ms SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.36 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
1 row browsed

0.359 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
1 row browsed

0.359 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'm_scene_attr' LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.359 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.356 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
1 row browsed

0.353 ms SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 226 AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.349 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
4 rows browsed

0.349 ms SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a INNER JOIN `ps_dzfilter_actionbox_category` b ON a.`id_dzfilter_actionbox` = b.`id_dzfilter_actionbox` AND b.`id_category` = 226 LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() ORDER BY a.`position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.349 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 226 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.347 ms SELECT * FROM `ps_theme` a WHERE (a.id_theme = 2) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.344 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.335 ms SELECT cl.`name`, cl.`link_rewrite`, cl.`description`, cl.`meta_title`, cl.`meta_keywords`, IF(cl.`meta_description` = "", cl.`description`, IFNULL(cl.`meta_description`, cl.`description`)) as `meta_description`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = c.`id_category` AND cl.`id_lang` = 2 WHERE c.`id_category` = 226 LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.335 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
1 row browsed

0.314 ms SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() AND a.`global` = 1 ORDER BY a.`position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.309 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
1 row browsed

0.306 ms SELECT cl.`name`, cl.`link_rewrite`, cl.`description`, cl.`meta_title`, cl.`meta_keywords`, IF(cl.`meta_description` = "", cl.`description`, IFNULL(cl.`meta_description`, cl.`description`)) as `meta_description`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = c.`id_category` AND cl.`id_lang` = 2 WHERE c.`id_category` = 158 LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.304 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
1 row browsed

0.296 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 = 1) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.296 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
1 row browsed

0.295 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
1 row browsed

0.292 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87744) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.288 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
4 rows browsed

0.288 ms SELECT ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 226 AND ctg.`id_group` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.285 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
4 rows browsed

0.281 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90160) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.274 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87745) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.266 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = 226 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

0.265 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 2464) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.265 ms SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = 2 WHERE a.`active` = 1 AND (a.`page_number` = "1" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() AND a.`global` = 1 ORDER BY a.`position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.259 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 90290) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.247 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
28 rows browsed

0.247 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 87765) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.239 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = 1 WHERE (a.id_category = 226) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.229 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` = 87744)
in /override/classes/db/Db.php:519
1 row browsed

0.218 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 509 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.216 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.212 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` = 87745)
in /override/classes/db/Db.php:519
1 row browsed

0.21 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87744 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.208 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
1 row browsed

0.205 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90290 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.203 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.202 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` = 90290)
in /override/classes/db/Db.php:519
1 row browsed

0.2 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` = 87765)
in /override/classes/db/Db.php:519
1 row browsed

0.198 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 2464 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.197 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87744 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.197 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` = 90291)
in /override/classes/db/Db.php:519
1 row browsed

0.197 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
1 row browsed

0.196 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
1 row browsed

0.196 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
1 row browsed

0.196 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` = 90160)
in /override/classes/db/Db.php:519
1 row browsed

0.193 ms SELECT * FROM `ps_category` WHERE `id_category` = 226 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.193 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` = 2464)
in /override/classes/db/Db.php:519
1 row browsed

0.191 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
1 row browsed

0.188 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87765 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.187 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90291 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.185 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 87745 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.184 ms SELECT DISTINCT `id_product` FROM `ps_compare` c LEFT JOIN `ps_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = 0
in /override/classes/db/Db.php:519
0 rows browsed

0.169 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 42 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.168 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90291 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.167 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 226 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.165 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90290 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.164 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 90160 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.164 ms SELECT `id_category` FROM `ps_category` WHERE `id_parent` = 0 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.164 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 90160 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.163 ms SELECT `controller` FROM `ps_dzfilter_controller` WHERE `id_item` = 29 AND `controller` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.162 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 2 AND cl.id_shop = 1 AND cl.`id_category` = 35 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.161 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.16 ms SELECT SUM(`size`) FROM `ps_dzfilter_stats` LIMIT 1
in /override/classes/db/Db.php:565
8 rows browsed

0.159 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.153 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.15 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87745 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.149 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 2464 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.149 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.149 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.149 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 87765 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

Doubles (IDs replaced by "XX") (total = 21)

10 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.id_category = b.id_category AND b.id_lang = XX LEFT JOIN `ps_category_shop` `c` ON a.id_category = c.id_category AND c.id_shop = XX WHERE (a.id_category = XX) AND (b.id_shop = XX) LIMIT XX

7 SELECT product_shop.`price`, product_shop.`ecotax`, XX 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 = XX) WHERE (p.`id_product` = XX)

7 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = XX LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = XX WHERE (a.id_product = XX) AND (b.id_shop = XX) LIMIT XX

7 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX

7 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) WHERE pf.id_product = XX ORDER BY f.position ASC

7 SELECT *, ( IF ('XX-XX-XX XX:XX:XX' >= `from` AND 'XX-XX-XX XX:XX:XX' <= `to`, XX, XX) + IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_product` IN (XX, XX) AND `id_product_attribute` IN (XX, XX) AND `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_customer` IN (XX, XX) AND ( (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) ) AND id_cart IN (XX, XX) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC LIMIT XX

7 SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX LIMIT XX

7 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX

7 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX

5 SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = XX LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = XX WHERE (a.id_cms = XX) LIMIT XX

5 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX

4 SELECT * FROM `ps_dz_cart_customer_field` a WHERE a.`active` = XX AND a.`field_type` = "customer"

3 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` = "XX" LEFT JOIN `ps_dz_cart_customer_field_show` s ON s.`name` = a.`name` AND s.`active` = XX AND s.`type` = "customer" WHERE a.`active` = XX AND a.`field_type` = "address"

3 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` = "XX" WHERE a.`active` = XX

2 SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = XX WHERE a.`active` = XX AND (a.`page_number` = "XX" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() AND a.`global` = XX ORDER BY a.`position` ASC

2 SELECT cl.`name`, cl.`link_rewrite`, cl.`description`, cl.`meta_title`, cl.`meta_keywords`, IF(cl.`meta_description` = "", cl.`description`, IFNULL(cl.`meta_description`, cl.`description`)) as `meta_description`, c.`id_parent` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON cl.`id_category` = c.`id_category` AND cl.`id_lang` = XX WHERE c.`id_category` = XX LIMIT XX

2 SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.id_lang = c.id_lang AND c.id_shop = XX WHERE (a.id_lang = XX) LIMIT XX

2 SELECT a.`all_width`,al.`bg_image`,a.`id_dzfilter_actionbox`,a.`active`,a.`cron`,a.`bg_color`,a.`priority`,a.`image_stretch`,a.`random`,a.`insert_position`,a.`insert_position_number`,a.`repeat_number`,al.`link`,al.`text`,a.`text_halign`,a.`text_valign` FROM `ps_dzfilter_actionbox` a INNER JOIN `ps_dzfilter_actionbox_category` b ON a.`id_dzfilter_actionbox` = b.`id_dzfilter_actionbox` AND b.`id_category` = XX LEFT JOIN `ps_dzfilter_actionbox_lang` al ON a.`id_dzfilter_actionbox` = al.`id_dzfilter_actionbox` AND al.`id_lang` = XX WHERE a.`active` = XX AND (a.`page_number` = "XX" OR a.`page_number` = "") AND a.`date_from` < NOW() AND a.`date_to` > NOW() ORDER BY a.`position` ASC

2 SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'uk' LIMIT XX

2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX

2 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` = XX 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

Tables stress

24 category_lang

23 category

21 product_shop

16 product

14 category_shop

12 image_type

11 dz_cart_customer_field

8 stock_available

8 product_lang

7 specific_price

7 feature_lang

7 manufacturer

7 feature_value_lang

7 feature_product

7 feature

7 specific_price_priority

6 dz_cart_customer_field_show

6 lang

5 module

5 cms_lang

5 cms_shop

5 cms

5 lang_shop

4 hook

4 dzfilter_actionbox_lang

4 dz_cart_customer_field_value

4 currency_shop

4 module_shop

4 dzfilter_actionbox

3 category_product

3 meta

3 theme

3 shop

3 dz_cart_customer_field_lang

3 dz_seo_lang_hook_lang

3 shop_url

3 dz_seo_lang_hook

3 currency

2 cat_filter_restriction_2

2 category_group

2 hook_alias

2 meta_lang

2 group

2 hook_module

2 country_shop

2 country

2 country_lang

2 state

2 group_shop

2 dzfilter_actionbox_category

1 product_attribute_shop

1 attribute

1 supplier_lang

1 product_attribute

1 supplier

1 product_attribute_combination

1 supplier_shop

1 attribute_group

1 dz_word_wrap_lang

1 dzordergifts

1 dz_word_wrap

1 themeconfigurator

1 dzfilter_stats

1 hook_module_exceptions

1 scene_category

1 scene

1 group_lang

1 theme_meta

1 configuration

1 configuration_lang

1 shop_group

1 scene_shop

1 scene_lang

1 compare

1 compare_product

1 gender_lang

1 image

1 dzfilter_feature

1 dzfilter_category

1 dzfilter

1 dzfilter_controller

1 zone

ObjectModel instances

27 Category

7 Product

5 CMS

3 Address

1 Group

1 Cart

1 Country

1 Shop

1 Theme

Included files

1 ./index.php
2 config/config.inc.php
3 config/defines.inc.php
4 config/settings.inc.php
5 config/autoload.php
6 config/alias.php
7 classes/PrestaShopAutoload.php
8 cache/class_index.php
9 tools/profiling/Controller.php
10 classes/controller/Controller.php
11 tools/profiling/ObjectModel.php
12 classes/ObjectModel.php
13 tools/profiling/Hook.php
14 classes/Hook.php
15 tools/profiling/Db.php
16 override/classes/db/Db.php
17 tools/profiling/Tools.php
18 classes/Tools.php
19 classes/Context.php
20 classes/shop/Shop.php
21 config/db_slave_server.inc.php
22 classes/db/DbPDO.php
23 classes/cache/Cache.php
24 classes/Validate.php
25 classes/db/DbQuery.php
26 classes/Theme.php
27 config/defines_uri.inc.php
28 classes/Configuration.php
29 classes/Language.php
30 override/classes/Language.php
31 classes/Country.php
32 classes/PrestaShopCollection.php
33 classes/shop/ShopGroup.php
34 classes/Cookie.php
35 override/classes/Cookie.php
36 classes/Rijndael.php
37 classes/Customer.php
38 override/classes/Customer.php
39 classes/Group.php
40 classes/Link.php
41 override/classes/Link.php
42 classes/shop/ShopUrl.php
43 config/smarty.config.inc.php
44 tools/smarty/Smarty.class.php
45 tools/smarty/sysplugins/smarty_internal_data.php
46 tools/smarty/sysplugins/smarty_internal_templatebase.php
47 tools/smarty/sysplugins/smarty_internal_template.php
48 tools/smarty/sysplugins/smarty_resource.php
49 tools/smarty/sysplugins/smarty_internal_resource_file.php
50 tools/smarty/sysplugins/smarty_cacheresource.php
51 tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
52 config/smartyfront.config.inc.php
53 classes/Dispatcher.php
54 override/classes/Dispatcher.php
55 tools/mobile_Detect/Mobile_Detect.php
56 classes/module/Module.php
57 modules/smartblog/smartblog.php
58 modules/smartblog/classes/BlogCategory.php
59 modules/smartblog/classes/Blogcomment.php
60 modules/smartblog/classes/BlogPostCategory.php
61 modules/smartblog/classes/BlogTag.php
62 modules/smartblog/classes/SmartBlogPost.php
63 modules/smartblog/classes/BlogImageType.php
64 modules/smartblog/controllers/admin/AdminAboutUsController.php
65 classes/controller/ModuleAdminController.php
66 classes/controller/AdminController.php
67 classes/Translate.php
68 themes/attr/modules/smartblog/translations/uk.php
69 modules/smartblog/translations/uk.php
70 modules/dz_ajaxload/dz_ajaxload.php
71 modules/dz_ajaxload/classes/Dz_ajaxloadDb.php
72 themes/attr/modules/dz_ajaxload/translations/uk.php
73 modules/dz_ajaxload/translations/uk.php
74 modules/dzseovideopage/dzseovideopage.php
75 modules/dzseovideopage/classes/DzSeoVideoPageForms.php
76 modules/dzseovideopage/classes/DzSeoVideoPageModel.php
77 themes/attr/modules/dzseovideopage/translations/uk.php
78 modules/dzseovideopage/translations/uk.php
79 modules/shopspage/shopspage.php
80 modules/shopspage/class/ShopsPageForms.php
81 modules/shopspage/class/ShopsPageClass.php
82 themes/attr/modules/shopspage/translations/uk.php
83 modules/shopspage/translations/uk.php
84 classes/Meta.php
85 modules/dz_cart/dz_cart.php
86 modules/dz_cart/classes/Dz_cartDb.php
87 modules/dz_cart/classes/DzCartSetting.php
88 modules/dz_cart/classes/DzCartCustomerField.php
89 modules/dz_cart/classes/DzCartCustomerFieldShow.php
90 modules/dz_cart/classes/DzCartOrdersAddress.php
91 themes/attr/modules/dz_cart/translations/uk.php
92 modules/dz_cart/translations/uk.php
93 modules/dzfilter/dzfilter.php
94 modules/dzfilter/classes/DzFilterDb.php
95 modules/dzfilter/classes/DzfilterSeoMap.php
96 themes/attr/modules/dzfilter/translations/uk.php
97 modules/dzfilter/translations/uk.php
98 modules/dz_pen_constructor/dz_pen_constructor.php
99 modules/dz_pen_constructor/classes/Dz_pen_constructorDb.php
100 modules/dz_pen_constructor/backward_compatibility/backward.php
101 modules/dz_pen_constructor/backward_compatibility/Display.php
102 classes/controller/FrontController.php
103 override/classes/controller/FrontController.php
104 modules/dz_pen_constructor/classes/DzPenConstructorMaket.php
105 modules/dz_pen_constructor/classes/DzPenConstructorIcon.php
106 themes/attr/modules/dz_pen_constructor/translations/uk.php
107 modules/dz_pen_constructor/uk.php
108 controllers/front/CategoryController.php
109 override/controllers/front/CategoryController.php
110 override/classes/Category.php
111 themes/attr/lang/uk.php
112 classes/Currency.php
113 classes/Cart.php
114 override/classes/Cart.php
115 classes/CartRule.php
116 override/classes/CartRule.php
117 classes/Product.php
118 override/classes/Product.php
119 classes/webservice/WebserviceRequest.php
120 classes/Media.php
121 classes/Scene.php
122 modules/blockbestsellers/blockbestsellers.php
123 themes/attr/modules/blockbestsellers/translations/uk.php
124 modules/blockbestsellers/translations/uk.php
125 modules/blockcart/blockcart.php
126 themes/attr/modules/blockcart/translations/uk.php
127 modules/blockcart/translations/uk.php
128 modules/blockcategories/blockcategories.php
129 themes/attr/modules/blockcategories/translations/uk.php
130 modules/blockcategories/translations/uk.php
131 modules/blockcontact/blockcontact.php
132 modules/blockcontact/controllers/admin/CopyImagesController.php
133 themes/attr/modules/blockcontact/translations/uk.php
134 modules/blockcontact/translations/uk.php
135 modules/blockcontactinfos/blockcontactinfos.php
136 themes/attr/modules/blockcontactinfos/translations/uk.php
137 modules/blockcontactinfos/translations/uk.php
138 modules/blocknewproducts/blocknewproducts.php
139 themes/attr/modules/blocknewproducts/translations/uk.php
140 modules/blocknewproducts/translations/uk.php
141 modules/blocksearch/blocksearch.php
142 themes/attr/modules/blocksearch/translations/uk.php
143 modules/blocksearch/translations/uk.php
144 modules/homeslider/homeslider.php
145 modules/homeslider/HomeSlide.php
146 themes/attr/modules/homeslider/translations/uk.php
147 modules/homeslider/translations/uk.php
148 modules/homefeatured/homefeatured.php
149 themes/attr/modules/homefeatured/translations/uk.php
150 modules/homefeatured/translations/uk.php
151 modules/themeconfigurator/themeconfigurator.php
152 themes/attr/modules/themeconfigurator/translations/uk.php
153 modules/themeconfigurator/translations/uk.php
154 modules/productcomments/productcomments.php
155 themes/attr/modules/productcomments/translations/uk.php
156 modules/productcomments/translations/uk.php
157 modules/editorial/editorial.php
158 themes/attr/modules/editorial/translations/uk.php
159 modules/editorial/translations/uk.php
160 modules/editorial/EditorialClass.php
161 modules/blocksocial/blocksocial.php
162 themes/attr/modules/blocksocial/translations/uk.php
163 modules/blocksocial/translations/uk.php
164 modules/mailalerts/mailalerts.php
165 modules/mailalerts/MailAlert.php
166 themes/attr/modules/mailalerts/translations/uk.php
167 modules/mailalerts/translations/uk.php
168 modules/blockonsale/blockonsale.php
169 themes/attr/modules/blockonsale/translations/uk.php
170 modules/blockonsale/translations/uk.php
171 modules/powatag/powatag.php
172 classes/PaymentModule.php
173 modules/powatag/classes/PowaTagLogs.php
174 modules/powatag/classes/PowaTagProductAttributeHelper.php
175 modules/powatag/classes/PowaTagProductHelper.php
176 modules/powatag/classes/PowaTagProductQuantityHelper.php
177 modules/powatag/classes/PowaTagRequestLogs.php
178 modules/powatag/classes/PowaTagTransaction.php
179 modules/powatag/classes/helper/powatagTotAdminTabHelper.php
180 themes/attr/modules/powatag/translations/uk.php
181 modules/powatag/translations/uk.php
182 modules/blockmanufacturer/blockmanufacturer.php
183 themes/attr/modules/blockmanufacturer/translations/uk.php
184 modules/blockmanufacturer/translations/uk.php
185 modules/socialsharing/socialsharing.php
186 themes/attr/modules/socialsharing/translations/uk.php
187 modules/socialsharing/translations/uk.php
188 modules/eicaptcha/eicaptcha.php
189 themes/attr/modules/eicaptcha/translations/uk.php
190 modules/eicaptcha/translations/uk.php
191 modules/productscategory/productscategory.php
192 themes/attr/modules/productscategory/translations/uk.php
193 modules/productscategory/translations/uk.php
194 modules/dzshortlinks/dzshortlinks.php
195 modules/dzshortlinks/classes/DzShortLinksDb.php
196 themes/attr/modules/dzshortlinks/translations/uk.php
197 modules/dzshortlinks/translations/uk.php
198 modules/dzordergifts/dzordergifts.php
199 modules/dzordergifts/classes/DzOrderGiftsDb.php
200 modules/dzordergifts/classes/DzOrderGiftObject.php
201 themes/attr/modules/dzordergifts/translations/uk.php
202 modules/dzordergifts/translations/uk.php
203 modules/dzbuytogether/dzbuytogether.php
204 modules/dzbuytogether/classes/DzBuyTogetherDb.php
205 themes/attr/modules/dzbuytogether/translations/uk.php
206 modules/dzbuytogether/translations/uk.php
207 modules/dz_carrier_warehouse/dz_carrier_warehouse.php
208 modules/dz_carrier_warehouse/classes/Dz_carrier_warehouseCarrier.php
209 classes/module/CarrierModule.php
210 themes/attr/modules/dz_carrier_warehouse/translations/uk.php
211 modules/dz_carrier_warehouse/translations/uk.php
212 classes/Combination.php
213 classes/tax/Tax.php
214 classes/Manufacturer.php
215 override/classes/Manufacturer.php
216 classes/Address.php
217 override/classes/Address.php
218 classes/SpecificPrice.php
219 classes/tax/TaxManagerFactory.php
220 classes/tax/TaxRulesTaxManager.php
221 classes/tax/TaxManagerInterface.php
222 classes/tax/TaxCalculator.php
223 classes/GroupReduction.php
224 classes/stock/StockAvailable.php
225 classes/Feature.php
226 override/classes/Feature.php
227 modules/dzsync1c/dzsync1c.php
228 modules/dzsync1c/classes/DzSync1cDb.php
229 modules/dzsync1c/classes/DzSync1cObject.php
230 themes/attr/modules/dzsync1c/translations/uk.php
231 modules/dzsync1c/translations/uk.php
232 classes/Image.php
233 override/classes/Image.php
234 classes/ImageType.php
235 classes/CompareProduct.php
236 cache/smarty/compile/e5/7d/7d/e57d7dee38b341b4183ec1df9c24753269122047.file.selected_filters.tpl.php
237 tools/smarty/sysplugins/smarty_internal_filter_handler.php
238 cache/smarty/compile/db/8d/fa/db8dfa4b78e9ad54a0752a4b862b337386530f75.file.dzfilterLeftColumn.tpl.php
239 tools/minify_html/minify_html.class.php
240 modules/dz_seo_lang/dz_seo_lang.php
241 modules/dz_seo_lang/classes/SeoCode.php
242 themes/attr/modules/dz_seo_lang/translations/uk.php
243 modules/dz_seo_lang/translations/uk.php
244 cache/smarty/compile/78/53/60/785360407ed7b4232c4a210e04ab42901aa97392.file.header.tpl.php
245 tools/js_minify/jsmin.php
246 modules/dz_nova_poshta/dz_nova_poshta.php
247 modules/dz_nova_poshta/classes/Dz_nova_poshtaCarrier.php
248 modules/dz_nova_poshta/classes/DzNp.php
249 modules/dz_nova_poshta/classes/DzNpDb.php
250 modules/dz_nova_poshta/classes/DzNpAddress.php
251 modules/dz_nova_poshta/classes/DzNpCommon.php
252 modules/dz_nova_poshta/classes/DzNpInternetDocument.php
253 modules/dz_nova_poshta/classes/DzNpCounterparty.php
254 themes/attr/modules/dz_nova_poshta/translations/uk.php
255 modules/dz_nova_poshta/translations/uk.php
256 modules/dz_nova_poshta/uk.php
257 modules/dz_cashless/dz_cashless.php
258 themes/attr/modules/dz_cashless/translations/uk.php
259 modules/dz_cashless/translations/uk.php
260 modules/blocktopmenu/blocktopmenu.php
261 modules/blocktopmenu/menutoplinks.class.php
262 themes/attr/modules/blocktopmenu/translations/uk.php
263 modules/blocktopmenu/translations/uk.php
264 modules/dz_debug/dz_debug.php
265 themes/attr/modules/dz_debug/translations/uk.php
266 modules/dz_debug/translations/uk.php
267 modules/blockcms/blockcms.php
268 modules/blockcms/BlockCMSModel.php
269 themes/attr/modules/blockcms/translations/uk.php
270 modules/blockcms/translations/uk.php
271 cache/smarty/cache/blockcms/top/1/2/1/216/7f/73/0f/7f730f454e0ca5d20116f0fb41d492192fbd77d3.blockcms_top.tpl.php
272 cache/smarty/cache/blocksocial/1/2/1/216/a5/b3/5f/a5b35fe3b7f6d3eef458f1f9085ae18dd290aa3a.blocksocial.tpl.php
273 cache/smarty/cache/blocksearch_top/1/2/1/216/02/e7/1a/02e71a9249b8674163cf975fb33fa96e9da86f69.blocksearch-top.tpl.php
274 cache/smarty/cache/blockcontact/1/2/1/216/13/90/fa/1390fad7e6c6932d26a56fad3e80a8c888cdcff4.blockcontact_top.tpl.php
275 cache/smarty/cache/blocktopmenu/1/2/1/216/05/ad/d7/05add7601f76982f34b7a402fa1d79c85ff1630e.blocktopmenu.tpl.php
276 cache/smarty/compile/b6/2c/b4/b62cb468796a471bd2568a9f32d28a7126070a58.file.dzAjaxLoad.tpl.php
277 classes/Supplier.php
278 cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php
279 cache/smarty/cache/blockcms/2/1/2/1/216/81/27/2b/81272bc7e8fb262950ed198a412d2ce43a7e363e.blockcms.tpl.php
280 cache/smarty/cache/blockcontactinfos/1/2/1/216/90/88/1a/90881acdbd08508a1ec725779df50fd412c8f80c.blockcontactinfos.tpl.php
281 cache/smarty/compile/a1/b4/28/a1b428aa468ecb6bdd1418d7fc72f783d5cfca43.file.hook.tpl.php
282 modules/blocknewsletter/blocknewsletter.php
283 themes/attr/modules/blocknewsletter/translations/uk.php
284 modules/blocknewsletter/translations/uk.php
285 cache/smarty/compile/bd/60/1f/bd601f54955c31d58c1d4cf83b5f3b2a75fe4fa7.file.blocknewsletter.tpl.php
286 modules/blockmyaccountfooter/blockmyaccountfooter.php
287 themes/attr/modules/blockmyaccountfooter/translations/uk.php
288 modules/blockmyaccountfooter/translations/uk.php
289 cache/smarty/cache/blockmyaccountfooter/1/2/1/216/90/24/fa/9024fa5f611a09b62b11468d2634f37c930bea31.blockmyaccountfooter.tpl.php
290 modules/dz_word_wrap/dz_word_wrap.php
291 modules/dz_word_wrap/classes/Dz_word_wrapDb.php
292 themes/attr/modules/dz_word_wrap/translations/uk.php
293 modules/dz_word_wrap/translations/uk.php
294 cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php
295 cache/smarty/compile/98/eb/ab/98ebabb7150edf1324d06d1e76b91ffd4bf09bc2.file.dzCartLogin.tpl.php
296 cache/smarty/compile/4c/57/f8/4c57f885411b79323a70c1ecf2af53a97771ca35.file.dz-cart-customer-login.tpl.php
297 tools/smarty/plugins/modifier.replace.php
298 cache/smarty/compile/f0/d7/54/f0d75481cc60c43dd7e421c7dab7822eb850d1ca.file.dz-cart-errors.tpl.php
299 cache/smarty/compile/30/a0/58/30a058ff6fc6be549325815c76ada2e095dd718c.file.dz-cart-customer-fields-form-new.tpl.php
300 cache/smarty/compile/84/0b/35/840b353dec7da2377b93631af9a346d0da9654e7.file.dz-cart-customer-phone-confirm.tpl.php
301 tools/smarty/plugins/shared.mb_str_replace.php
302 cache/smarty/compile/93/03/10/930310e96ccdee06114402b3d8c75e3658359339.file.dzCartAuth.tpl.php
303 cache/smarty/compile/41/f5/93/41f593162134ac2a051e80978c4f1999250b7b0f.file.footer.tpl.php
304 cache/smarty/compile/ca/ff/83/caff83751393390220f67e31ddb4bb991b1b31b2.file.footer.tpl.php
305 cache/smarty/compile/9f/6c/36/9f6c36544a41ed6565efb7e3e8862e88ea108619.file.category.tpl.php
306 cache/smarty/compile/c3/c9/2d/c3c92d66095a3270dc447e19ad38663e743a4208.file.errors.tpl.php
307 cache/smarty/compile/83/63/3c/83633cf032bfa43079fbe850a76e352484a57c1d.file.product-sort.tpl.php
308 cache/smarty/compile/d2/55/40/d25540b5f0e3ce7ebdeb3927e4dfba1ee33f9235.file.nbr-product-page.tpl.php
309 cache/smarty/compile/e6/ae/ed/e6aeed26aad8b00c54b3682e0a12d2bcb138a718.file.product-list.tpl.php
310 tools/smarty/plugins/function.math.php
311 tools/smarty/plugins/modifier.date_format.php
312 cache/smarty/compile/f7/b7/01/f7b70141e2a77d04e9f5d1d2ae8c479d4a3044f5.file.favorite.tpl.php
313 tools/smarty/plugins/shared.make_timestamp.php
314 cache/smarty/compile/fd/d4/e4/fdd4e4debc64579fca9adbe84c762bfd24ff3086.file.pagination.tpl.php
315 cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php
316 cache/smarty/compile/a4/1c/ca/a41cca29f154eae2aac6231b96011ad9f2aac6d0.file.header.tpl.php
317 tools/smarty/plugins/modifier.regex_replace.php
318 tools/smarty/plugins/function.implode.php
319 modules/mkclickzone/mkclickzone.php
320 modules/mkclickzone/ClickZone.php
321 themes/attr/modules/mkclickzone/translations/uk.php
322 modules/mkclickzone/translations/uk.php
323 cache/smarty/compile/82/23/2b/82232bd85a07c01c44c8d933df949dfff879fc10.file.dzSeoLang.tpl.php
324 cache/smarty/compile/85/df/46/85df4621f102d61183235d32d8c19dbc6e47efbb.file.breadcrumb.tpl.php
325 cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php
326 cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php
327 classes/CMS.php
328 cache/smarty/compile/20/be/2e/20be2ee020a13947212660466f91a9a7b518740e.file.javascript.tpl.php

De Rosa Rinconada Качка (Гусак)

Фігурка/статуетка De Rosa Families Дика Качка Dr133f-60

Фігурка/статуетка De Rosa Families Дике Каченя Dr333f-60

Фігурка/статуетка De Rosa Rinconada Качка Крижень (10x8x7) Dr200f-60

Фігурка/статуетка De Rosa Rinconada Каченя Крижень (7x6x6) Dr400f-60

Фігурка/статуетка De Rosa Rinconada Качка Мандаринка (9x12x7) Dr230f-60

Фігурка/статуетка De Rosa Families Качка Dr230a-f-60

Фігурка De Rosa Rinconada Emerald Качка Синя Dr1027-60

Stopwatch (with SQL_NO_CACHE) (total = 175)

Doubles (IDs replaced by "XX") (total = 21)

Tables stress

ObjectModel instances

Included files