Фигурка De Rosa Rinconada Large Wildlife Кошка Пятнистая Dr411-51

Мы работаем 15-09-2025

Эксклюзивные аксессуары

(044) 227 76 22
(066) 800 8 500

(067) 533 11 42

Обратный звонок

(044) 227 76 22 | (066) 800 8 500 | (067) 533 11 42

Мы перезвоним Вам в течении рабочего часа.

Подпишитесь на рассылку, чтоб получать скидки!

Отсылая свои данные вы соглашаетесь с политикой конфиденциальности.

Серия	Large Wildlife
Вид изделия	Фигурка/статуэтка
Материал	Керамика
Форма	Вертикальная
Фигурка кого?	Кошка
Гарантия	1 год
Страна регистрации бренда	Уругвай
Группа	Кошка
Тип выпуска товара	Серийный
Страна-производитель товара	Уругвай

Серия	Large Wildlife
Вид изделия	Фигурка/статуэтка
Материал	Керамика
Форма	Вертикальная
Фигурка кого?	Кошка
Гарантия	1 год
Страна регистрации бренда	Уругвай
Группа	Кошка
Тип выпуска товара	Серийный
Страна-производитель товара	Уругвай

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

config: 79ms
constructor: 0ms
init: 62ms
checkAccess: 0ms
setMedia: 23ms
postProcess: 0ms
initHeader: 0ms
initContent: 670ms
initFooter: 691ms
display: 3.128s

Hook processing: 3.085s / 17.92 Mb
255 methods called in 42 modules

dzOrderGiftAvailable: 2.222s / 51.5 Mb
displayHeader: 544ms / 3.2 Mb
productCombExtra: 114ms / -41.96 Mb
dzGiftBlock: 65ms / 1.51 Mb
dzCartLogin: 36ms / 0.27 Mb
displayTop: 23ms / 0.24 Mb
moduleRoutes: 21ms / 2.54 Mb
displayFooterProduct: 19ms / 0.06 Mb
displayClickZone: 11ms / 0.08 Mb
displayRightColumnProduct: 7ms / 0.14 Mb
displayProductTabContent: 5ms / 0.03 Mb
dzCartAuth: 4ms / 0.03 Mb
displayProductTab: 3ms / 0.03 Mb
actionProductOutOfStock: 3ms / 0.04 Mb
displayFooter: 2ms / 0.03 Mb
actionFrontControllerSetMedia: 2ms / 0.07 Mb
dzCartFavorite: 1ms / 0.02 Mb
dzSeoLang: 1ms / 0.03 Mb
dzAjaxLoad: 1ms / 0 Mb
productFooterGroup: 0ms / 0.02 Mb
displayFooterTop: 0ms / 0.02 Mb
dzDebug: 0ms / 0 Mb
displayTopColumn: 0ms / 0 Mb
displayLeftColumnProduct: 0ms / 0 Mb
displayProductButtons: 0ms / 0 Mb
dzbuytogether: 0ms / 0 Mb
displayProductNewHook: 0ms / 0 Mb
actionDispatcher: 0ms / 0 Mb
showPopupChooseLanguage: 0ms / 0 Mb
displayProductContent: 0ms / 0 Mb
DisplayOverrideTemplate: 0ms / 0 Mb

Memory peak usage: 261.5 Mb

config: 6.11 Mb (6.2 Mb)
constructor: 0 Mb (6.2 Mb)
init: 2.81 Mb (9.2 Mb)
checkAccess: 0 Mb (9.2 Mb)
setMedia: 0.14 Mb (9.3 Mb)
postProcess: 0 Mb (9.3 Mb)
initHeader: 0 Mb (9.3 Mb)
initContent: 5 Mb (14.2 Mb)
initFooter: 0.92 Mb (15.5 Mb)
display: 13.49 Mb (261.5 Mb)

Total cache size (in Cache class): 1.89 Mb

DB type: DbPDO
SQL Queries: 270 queries
Time spent querying: 802ms

Included files: 333
Size of included files: 5.78 Mb

Globals (> 1 Ko only): 1672 Ko

_MODULES ≈ 1335.9 Ko
_LANG ≈ 160.5 Ko
context ≈ 153.6 Ko
_MODULE ≈ 9.4 Ko
_SERVER ≈ 8.7 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
662.125	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.941	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
4.271	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.218	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
2.286	337	SELECT * FROM `ps_state` ORDER BY `name` ASC	/override/classes/db/Db.php:519	Yes
2.024	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` = 1 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
1.732	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.643	1	SELECT p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, DATEDIFF( p.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE `id_product_1` = 731 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product	/override/classes/db/Db.php:519
1.593	10	SELECT name, GROUP_CONCAT(value SEPARATOR ", ") as value, pf.id_feature, f.`property_name` FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) WHERE pf.id_product = 731 GROUP BY pf.id_feature ORDER BY f.position ASC	/override/classes/db/Db.php:519	Yes
1.436	77	SELECT cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity FROM `ps_customization` cu LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`) WHERE cu.id_cart = 0 AND cu.id_product = 731 AND type = 0 AND in_cart = 0	/override/classes/db/Db.php:519
1.372	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` = "1"	/override/classes/db/Db.php:519
1.348	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` = 1 AND cl.id_shop = 1 ) WHERE `id_parent` = 42 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.334	32	SELECT *, ( IF ('2025-09-15 18:23:57' >= `from` AND '2025-09-15 18:23:57' <= `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, 731) 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:23:57' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:23:57' <= `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
1.28	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
1.279	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.24	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` = 1) 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.213	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
1.175	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
1.126	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
1.044	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.021	1	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 731 AND i.`active` = 1 ORDER BY `position`	/override/classes/db/Db.php:519	Yes
1.013	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
1.01	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.998	32	SELECT *, ( IF ('2025-09-15 18:23:58' >= `from` AND '2025-09-15 18:23:58' <= `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, 731) 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:23:58' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:23:58' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC	/override/classes/db/Db.php:519	Yes
0.97	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.962	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.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.942	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 74235) LIMIT 1	/override/classes/db/Db.php:565
0.934	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.925	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.892	10	SELECT fvl.id_feature_value FROM ps_feature_value_lang fvl LEFT JOIN ps_feature_product fp ON fp.id_feature_value = fvl.id_feature_value LEFT JOIN ps_feature_lang fl ON fl.id_feature = fp.id_feature WHERE fl.name = "Серия" AND fp.id_product = 731 LIMIT 1	/override/classes/db/Db.php:565
0.876	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.866	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.849	7	SELECT cf.`id_customization_field`, cf.`type`, cf.`required`, cfl.`name`, cfl.`id_lang` FROM `ps_customization_field` cf NATURAL JOIN `ps_customization_field_lang` cfl WHERE cf.`id_product` = 731 AND cfl.`id_lang` = 1 ORDER BY cf.`id_customization_field`	/override/classes/db/Db.php:519
0.826	32	SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 74235) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.818	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 731) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.806	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.798	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
0.796	32	SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 85387) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.78	32	SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 80928) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.777	1	SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 731	/override/classes/db/Db.php:519
0.773	25	SELECT * FROM `ps_state` WHERE `id_country` = 216 AND `active` = 1 ORDER BY `name` ASC	/override/classes/db/Db.php:519	Yes
0.76	32	SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 85659) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.755	9	SELECT DISTINCT p.id_product FROM ps_product p LEFT JOIN ps_category_product cp ON cp.id_product = p.id_product LEFT JOIN ps_category_lang cl ON cl.id_category = cp.id_category AND cl.id_lang = 1 left JOIN ps_category c on c.id_category = cl.id_category where c.id_parent = 58755 and p.id_product = 731	/override/classes/db/Db.php:519
0.745	107	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 <= 210 AND c.nright >= 211 AND c.nleft >= 2 AND c.nright <= 6141 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC	/override/classes/db/Db.php:519	Yes
0.741	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 = 1 AND ml.id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.736	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 85659 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.735	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.717	1	SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 731	/override/classes/db/Db.php:519
0.704	5	SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC	/override/classes/db/Db.php:519	Yes	Yes
0.69	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=731	/override/classes/db/Db.php:519
0.68	132	SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)	/override/classes/db/Db.php:519
0.679	1	SELECT pc.`id_product_comment`, (SELECT count() FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful, (SELECT count() FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `ps_product_comment` pc LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = 731 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC	/override/classes/db/Db.php:519	Yes
0.661	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 731 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.66	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 731 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.648	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 731) LIMIT 1	/override/classes/db/Db.php:565
0.64	1	SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 731) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = 731) WHERE pccl.`id_lang` = 1 AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1 ) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion	/override/classes/db/Db.php:519		Yes
0.636	1	SELECT dz., dzl. FROM `ps_dzfilterseo` dz LEFT JOIN `ps_dzfilterseo_lang` dzl ON dz.`id_dzfilterseo` = dzl.`id_dzfilterseo` AND dzl.`id_lang` = 1 WHERE dz.`type` = "action" AND dz.`action_product_clock` = 1 AND dz.`date_to` > NOW() AND dz.`products` != ""	/override/classes/db/Db.php:519
0.633	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 = 42) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.631	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85387) LIMIT 1	/override/classes/db/Db.php:565
0.625	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
0.622	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
0.618	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.613	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.605	3	SELECT DISTINCT c.id_category from ps_category c left join ps_category_product cp on cp.id_category = c.id_category left join ps_product p on p.id_product = cp.id_product where p.id_product = 731 and c.id_parent = 58755 order by c.id_category desc	/override/classes/db/Db.php:519
0.591	131	SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC	/override/classes/db/Db.php:519	Yes
0.59	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.583	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 = 156) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.583	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.577	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.576	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.564	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.556	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.555	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.555	1	SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 1 AND pl.id_product = 731 AND product_shop.active = 1 LIMIT 1	/override/classes/db/Db.php:565
0.551	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.53	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.527	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.522	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.514	1	SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 731 AND pccl.`id_lang` = 1 AND pc.`validate` = 1	/override/classes/db/Db.php:519
0.506	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.504	77	SELECT cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity FROM `ps_customization` cu LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`) WHERE cu.id_cart = 0 AND cu.id_product = 731 AND type = 1 AND in_cart = 0	/override/classes/db/Db.php:519
0.504	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 74235) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.502	2	SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 74235 AND image_shop.`cover`= 1 LIMIT 1	/override/classes/db/Db.php:565
0.501	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.499	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.498	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.498	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 = "product" LIMIT 1	/override/classes/db/Db.php:565
0.497	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85659) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.493	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.493	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.491	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85387) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.491	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.49	1	SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 1 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 2) LIMIT 1	/override/classes/db/Db.php:565
0.481	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80928) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.48	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.478	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.478	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.476	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.473	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.47	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.462	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.458	3	SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 85387 AND image_shop.`cover`= 1 LIMIT 1	/override/classes/db/Db.php:565
0.454	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.454	1	SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'ru' LIMIT 1	/override/classes/db/Db.php:565
0.447	88	SELECT * FROM `ps_hook_alias`	/override/classes/db/Db.php:519
0.446	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.44	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.438	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'large_attr' LIMIT 1	/override/classes/db/Db.php:565
0.437	1	SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1	/override/classes/db/Db.php:519	Yes
0.431	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.43	1	SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 731 LIMIT 1	/override/classes/db/Db.php:565
0.428	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85659) LIMIT 1	/override/classes/db/Db.php:565
0.427	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_large' LIMIT 1	/override/classes/db/Db.php:565
0.426	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.425	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.421	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` = 1 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.417	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.41	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
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 = 731) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.407	2	SELECT * FROM `ps_product_lang` WHERE `id_product` = 731 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.404	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT 1	/override/classes/db/Db.php:565
0.398	4	SELECT * FROM `ps_gender_lang` WHERE `id_lang` = 1	/override/classes/db/Db.php:519
0.398	1	SELECT * FROM `ps_shop` a WHERE (a.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.393	7	SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 80928 AND image_shop.`cover`= 1 LIMIT 1	/override/classes/db/Db.php:565
0.392	1	SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 731 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1	/override/classes/db/Db.php:565
0.391	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 85387 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.388	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` = 1 WHERE w.`word_wrap_object` IN ("all", "productall") OR (w.`word_wrap_object` = "product" AND CONCAT(",",w.`word_wrap_object_id`, ",") LIKE "%,731,%")	/override/classes/db/Db.php:519
0.386	1	SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 AND `grade` > 0 LIMIT 1	/override/classes/db/Db.php:565
0.385	1	SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.385	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large_default' LIMIT 1	/override/classes/db/Db.php:565
0.38	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` = 731)	/override/classes/db/Db.php:519
0.379	6	SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 85659 AND image_shop.`cover`= 1 LIMIT 1	/override/classes/db/Db.php:565
0.378	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'cart_attr' LIMIT 1	/override/classes/db/Db.php:565
0.376	24	SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 731 LIMIT 1	/override/classes/db/Db.php:565
0.373	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 731 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.37	1	SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = 731 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.369	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "dzfilter" LIMIT 1	/override/classes/db/Db.php:565
0.367	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 731 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.365	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 85387) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.363	1	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80928) LIMIT 1	/override/classes/db/Db.php:565
0.36	1	SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.35	1	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.35	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'cart_default' LIMIT 1	/override/classes/db/Db.php:565
0.349	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.349	12	SELECT `id_product` FROM `ps_category_product` WHERE `id_product` = 731 AND `id_category` IN(59623,59638,59640,59630,59631,59632,59633,59634,59636,59637,59641,59642) LIMIT 1	/override/classes/db/Db.php:565
0.344	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=74235	/override/classes/db/Db.php:519
0.339	1	SELECT * FROM `ps_theme` a WHERE (a.id_theme = 2) LIMIT 1	/override/classes/db/Db.php:565
0.338	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 24) LIMIT 1	/override/classes/db/Db.php:565
0.337	1	SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.335	1	SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'ru' LIMIT 1	/override/classes/db/Db.php:565
0.335	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=85387	/override/classes/db/Db.php:519
0.334	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.333	1	SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1	/override/classes/db/Db.php:565
0.333	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.332	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1	/override/classes/db/Db.php:565
0.331	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.33	1	SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 42 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.33	1	SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'attr_cart' LIMIT 1	/override/classes/db/Db.php:565
0.33	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=80928	/override/classes/db/Db.php:519
0.328	0	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 42 LIMIT 1	/override/classes/db/Db.php:565
0.326	2	SELECT * FROM `ps_product_lang` WHERE `id_product` = 74235 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.326	1	SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1	/override/classes/db/Db.php:565
0.326	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.325	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.325	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 42 LIMIT 1	/override/classes/db/Db.php:565
0.322	2	SELECT * FROM `ps_group_lang` WHERE `id_group` = 1	/override/classes/db/Db.php:519
0.322	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.321	2	SELECT * FROM `ps_product_lang` WHERE `id_product` = 85387 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.318	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1	/override/classes/db/Db.php:565
0.317	1	SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1	/override/classes/db/Db.php:565
0.317	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.317	1	SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 731 AND pccl.`id_lang` = 1 AND pc.`validate` = 1	/override/classes/db/Db.php:519
0.314	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.312	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.31	10	SELECT fp.id_feature_value FROM ps_feature_lang fl LEFT JOIN ps_feature_product fp ON fp.id_feature = fl.id_feature WHERE fl.name = "Вид изделия" AND fp.id_product = 731 LIMIT 1	/override/classes/db/Db.php:565
0.31	0	SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1	/override/classes/db/Db.php:565
0.308	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 85659) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.304	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 74235) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.304	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.303	1	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 80928) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.302	0	SELECT `active` FROM `ps_dz_pen_constructor` WHERE `id_product` = "731" LIMIT 1	/override/classes/db/Db.php:565
0.302	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 85659 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.3	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=85659	/override/classes/db/Db.php:519
0.299	1	SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 42 LIMIT 1	/override/classes/db/Db.php:565
0.297	1	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 6) LIMIT 1	/override/classes/db/Db.php:565
0.297	1	SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 731 AND image_shop.`cover` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.295	1	SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1	/override/classes/db/Db.php:565
0.292	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` = "1" WHERE a.`active` = 1	/override/classes/db/Db.php:519
0.292	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.291	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 = 3) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.29	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 = 35) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.287	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.286	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.282	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 74235) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.281	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.281	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 = 140) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.279	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.278	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 = 12) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.278	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.278	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 74235 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.275	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 = 29) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.272	8	SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=731	/override/classes/db/Db.php:519
0.272	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 85659) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.271	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.271	2	SELECT * FROM `ps_product_lang` WHERE `id_product` = 85659 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.268	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 = 59012) AND (b.id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.265	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 85387) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.263	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 74235) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.262	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` = 85387)	/override/classes/db/Db.php:519
0.262	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 85387) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.261	0	SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 80928 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0	/override/classes/db/Db.php:519
0.261	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.256	2	SELECT * FROM `ps_product_lang` WHERE `id_product` = 80928 AND `id_shop` = 1	/override/classes/db/Db.php:519
0.253	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` = 85659)	/override/classes/db/Db.php:519
0.253	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.252	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 80928) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.251	14	SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC	/override/classes/db/Db.php:519	Yes
0.251	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 85387 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.246	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` = "1" WHERE a.`active` = 1	/override/classes/db/Db.php:519
0.245	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 74235 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.244	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.243	1	SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 85659) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.239	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.239	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` = 80928)	/override/classes/db/Db.php:519
0.235	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 80928) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.234	1	SELECT `id_module` FROM `ps_module` WHERE `name` = "powatag" LIMIT 1	/override/classes/db/Db.php:565
0.23	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` = 74235)	/override/classes/db/Db.php:519
0.23	0	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 442 LIMIT 1	/override/classes/db/Db.php:565
0.228	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
0.228	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 442 LIMIT 1	/override/classes/db/Db.php:565
0.227	1	SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 AND `grade` > 0 LIMIT 1	/override/classes/db/Db.php:565
0.226	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
0.22	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
0.216	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
0.214	0	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 155 LIMIT 1	/override/classes/db/Db.php:565
0.214	1	SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1	/override/classes/db/Db.php:565
0.209	189	SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731	/override/classes/db/Db.php:519
0.209	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 155 LIMIT 1	/override/classes/db/Db.php:565
0.206	1	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 AND `active` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.203	1	SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 AND `active` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.201	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 85659 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.2	1	SELECT `link_rewrite` FROM `ps_dzfilterseo_lang` WHERE `id_dzfilterseo` = 225 AND `id_lang` = 1 LIMIT 1	/override/classes/db/Db.php:565
0.2	1	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 80928 ORDER BY `id_specific_price_priority` DESC LIMIT 1	/override/classes/db/Db.php:565
0.199	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 74235 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.192	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.192	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 85387 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.191	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 LIMIT 1	/override/classes/db/Db.php:565
0.188	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.186	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 LIMIT 1	/override/classes/db/Db.php:565
0.183	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 6 LIMIT 1	/override/classes/db/Db.php:565
0.179	1	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1	/override/classes/db/Db.php:565
0.175	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 LIMIT 1	/override/classes/db/Db.php:565
0.175	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 LIMIT 1	/override/classes/db/Db.php:565
0.175	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 LIMIT 1	/override/classes/db/Db.php:565
0.174	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 LIMIT 1	/override/classes/db/Db.php:565
0.174	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.171	0	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1	/override/classes/db/Db.php:565
0.17	0	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 6 LIMIT 1	/override/classes/db/Db.php:565
0.17	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.168	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 LIMIT 1	/override/classes/db/Db.php:565
0.167	1	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 80928 AND id_shop=1 LIMIT 1	/override/classes/db/Db.php:565
0.167	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.166	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	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.158	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1	/override/classes/db/Db.php:565
0.158	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 LIMIT 1	/override/classes/db/Db.php:565
0.157	1	SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 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

Stopwatch (with SQL_NO_CACHE) (total = 270)

662.125 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.941 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

4.271 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.218 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

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

2.024 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` = 1 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

1.732 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.643 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, MAX(image_shop.`id_image`) id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, DATEDIFF( p.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0 AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_image` i ON (i.`id_product` = p.`id_product`) LEFT JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 ) WHERE `id_product_1` = 731 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product
in /override/classes/db/Db.php:519
1 row browsed

1.593 ms SELECT name, GROUP_CONCAT(value SEPARATOR ", ") as value, pf.id_feature, f.`property_name` FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) WHERE pf.id_product = 731 GROUP BY pf.id_feature ORDER BY f.position ASC
in /override/classes/db/Db.php:519
USING FILESORT - 10 rows browsed

1.436 ms SELECT cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity FROM `ps_customization` cu LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`) WHERE cu.id_cart = 0 AND cu.id_product = 731 AND type = 0 AND in_cart = 0
in /override/classes/db/Db.php:519
77 rows browsed

1.372 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` = "1"
in /override/classes/db/Db.php:519
28 rows browsed

1.348 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` = 1 AND cl.id_shop = 1 ) WHERE `id_parent` = 42 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.334 ms SELECT *, ( IF ('2025-09-15 18:23:57' >= `from` AND '2025-09-15 18:23:57' <= `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, 731) 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:23:57' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:23:57' <= `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

1.28 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

1.279 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.24 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` = 1) 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.213 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

1.175 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

1.126 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

1.044 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.021 ms SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 731 AND i.`active` = 1 ORDER BY `position`
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

1.013 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

1.01 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.998 ms SELECT *, ( IF ('2025-09-15 18:23:58' >= `from` AND '2025-09-15 18:23:58' <= `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, 731) 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:23:58' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:23:58' <= `to`) ) ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC
in /override/classes/db/Db.php:519
USING FILESORT - 32 rows browsed

0.97 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.962 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.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.942 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 74235) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.934 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.925 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.892 ms SELECT fvl.id_feature_value FROM ps_feature_value_lang fvl LEFT JOIN ps_feature_product fp ON fp.id_feature_value = fvl.id_feature_value LEFT JOIN ps_feature_lang fl ON fl.id_feature = fp.id_feature WHERE fl.name = "Серия" AND fp.id_product = 731 LIMIT 1
in /override/classes/db/Db.php:565
10 rows browsed

0.876 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.866 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.849 ms SELECT cf.`id_customization_field`, cf.`type`, cf.`required`, cfl.`name`, cfl.`id_lang` FROM `ps_customization_field` cf NATURAL JOIN `ps_customization_field_lang` cfl WHERE cf.`id_product` = 731 AND cfl.`id_lang` = 1 ORDER BY cf.`id_customization_field`
in /override/classes/db/Db.php:519
7 rows browsed

0.826 ms SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 74235) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.818 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 731) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.806 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.798 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

0.796 ms SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 85387) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.78 ms SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 80928) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.777 ms SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1) WHERE pa.`id_product` = 731
in /override/classes/db/Db.php:519
1 row browsed

0.773 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

0.76 ms SELECT *, ( IF ('2025-09-15 18:24:01' >= `from` AND '2025-09-15 18:24:01' <= `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, 85659) 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:24:01' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-09-15 18:24:01' <= `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.755 ms SELECT DISTINCT p.id_product FROM ps_product p LEFT JOIN ps_category_product cp ON cp.id_product = p.id_product LEFT JOIN ps_category_lang cl ON cl.id_category = cp.id_category AND cl.id_lang = 1 left JOIN ps_category c on c.id_category = cl.id_category where c.id_parent = 58755 and p.id_product = 731
in /override/classes/db/Db.php:519
9 rows browsed

0.745 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 <= 210 AND c.nright >= 211 AND c.nleft >= 2 AND c.nright <= 6141 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
in /override/classes/db/Db.php:519
USING FILESORT - 107 rows browsed

0.741 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 = 1 AND ml.id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

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

0.735 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.717 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 1) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = 731
in /override/classes/db/Db.php:519
1 row browsed

0.704 ms SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE `id_lang` = 1 AND c.`id_parent` = 2 AND `active` = 1 GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 5 rows browsed
Useless GROUP BY need to be removed

0.69 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=731
in /override/classes/db/Db.php:519
8 rows browsed

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

0.679 ms SELECT pc.`id_product_comment`, (SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = 1) as total_useful, (SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, 1)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `ps_product_comment` pc LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = 731 AND pc.`validate` = 1 ORDER BY pc.`date_add` DESC
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.661 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 731 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

0.66 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 731 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

0.648 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 731) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.64 ms SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = 731) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = 731) WHERE pccl.`id_lang` = 1 AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = 1 ) AND pcc.active = 1 GROUP BY pcc.id_product_comment_criterion
in /override/classes/db/Db.php:519
1 row browsed
Useless GROUP BY need to be removed

0.636 ms SELECT dz.*, dzl.* FROM `ps_dzfilterseo` dz LEFT JOIN `ps_dzfilterseo_lang` dzl ON dz.`id_dzfilterseo` = dzl.`id_dzfilterseo` AND dzl.`id_lang` = 1 WHERE dz.`type` = "action" AND dz.`action_product_clock` = 1 AND dz.`date_to` > NOW() AND dz.`products` != ""
in /override/classes/db/Db.php:519
1 row browsed

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

0.631 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85387) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.625 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

0.622 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

0.618 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.613 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.605 ms SELECT DISTINCT c.id_category from ps_category c left join ps_category_product cp on cp.id_category = c.id_category left join ps_product p on p.id_product = cp.id_product where p.id_product = 731 and c.id_parent = 58755 order by c.id_category desc
in /override/classes/db/Db.php:519
3 rows browsed

0.591 ms SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = 1 ORDER BY `position` ASC
in /override/classes/db/Db.php:519
USING FILESORT - 131 rows browsed

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

0.583 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.577 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.576 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.564 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.556 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.555 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.555 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE pl.id_lang = 1 AND pl.id_product = 731 AND product_shop.active = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.551 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.53 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.527 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.522 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.514 ms SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 731 AND pccl.`id_lang` = 1 AND pc.`validate` = 1
in /override/classes/db/Db.php:519
1 row browsed

0.506 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.504 ms SELECT cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity FROM `ps_customization` cu LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`) WHERE cu.id_cart = 0 AND cu.id_product = 731 AND type = 1 AND in_cart = 0
in /override/classes/db/Db.php:519
77 rows browsed

0.504 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 74235) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.502 ms SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 74235 AND image_shop.`cover`= 1 LIMIT 1
in /override/classes/db/Db.php:565
2 rows browsed

0.501 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.499 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.498 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.498 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =2 AND m.page = "product" LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.497 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85659) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.493 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.491 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85387) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.49 ms SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.id_manufacturer = b.id_manufacturer AND b.id_lang = 1 LEFT JOIN `ps_manufacturer_shop` `c` ON a.id_manufacturer = c.id_manufacturer AND c.id_shop = 1 WHERE (a.id_manufacturer = 2) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.481 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.id_product = b.id_product AND b.id_lang = 1 LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80928) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.48 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.478 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.478 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.476 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 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.473 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 731) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.47 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.462 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.458 ms SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 85387 AND image_shop.`cover`= 1 LIMIT 1
in /override/classes/db/Db.php:565
3 rows browsed

0.454 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.454 ms SELECT `id_lang` FROM `ps_lang` WHERE `iso_code` = 'ru' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.446 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.44 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.438 ms SELECT `id_image_type`, `name`, `width`, `height`, `products`, `categories`, `manufacturers`, `suppliers`, `scenes` FROM `ps_image_type` WHERE `name` LIKE 'large_attr' LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.437 ms SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`id_customer` = 0 ORDER BY pc.`date_add` DESC LIMIT 1
in /override/classes/db/Db.php:519
USING FILESORT - 1 row browsed

0.431 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.43 ms SELECT COUNT(*) FROM ps_pack WHERE id_product_pack = 731 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.428 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 85659) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.426 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.425 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.421 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` = 1 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.417 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.41 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows 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 = 731) AND (b.id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.407 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 731 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

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

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

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

0.393 ms SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 80928 AND image_shop.`cover`= 1 LIMIT 1
in /override/classes/db/Db.php:565
7 rows browsed

0.392 ms SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = 731 AND `active` = 1 ORDER BY `id_product_download` DESC LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.391 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 85387 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

0.388 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` = 1 WHERE w.`word_wrap_object` IN ("all", "productall") OR (w.`word_wrap_object` = "product" AND CONCAT(",",w.`word_wrap_object_id`, ",") LIKE "%,731,%")
in /override/classes/db/Db.php:519
2 rows browsed

0.386 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 AND `grade` > 0 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.385 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = 731 AND pc.`deleted` = 0 AND pc.`validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

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

0.379 ms SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE `id_product` = 85659 AND image_shop.`cover`= 1 LIMIT 1
in /override/classes/db/Db.php:565
6 rows browsed

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

0.376 ms SELECT GROUP_CONCAT(a.`id_product_pack`) FROM `ps_pack` a WHERE a.`id_product_item` = 731 LIMIT 1
in /override/classes/db/Db.php:565
24 rows browsed

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

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

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

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

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

0.363 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.id_product = c.id_product AND c.id_shop = 1 WHERE (a.id_product = 80928) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.36 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 7 AND `id_shop` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.35 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 AND `active` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.349 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.349 ms SELECT `id_product` FROM `ps_category_product` WHERE `id_product` = 731 AND `id_category` IN(59623,59638,59640,59630,59631,59632,59633,59634,59636,59637,59641,59642) LIMIT 1
in /override/classes/db/Db.php:565
12 rows browsed

0.344 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=74235
in /override/classes/db/Db.php:519
8 rows browsed

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

0.338 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 24) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.337 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.335 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=85387
in /override/classes/db/Db.php:519
8 rows browsed

0.334 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.333 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.333 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.332 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.331 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.33 ms SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = 42 AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.33 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=80928
in /override/classes/db/Db.php:519
8 rows browsed

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

0.326 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 74235 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

0.326 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.326 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.325 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.325 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 42 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.322 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.321 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 85387 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

0.318 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.317 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.317 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.317 ms SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = 731 AND pccl.`id_lang` = 1 AND pc.`validate` = 1
in /override/classes/db/Db.php:519
1 row browsed

0.314 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.312 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.31 ms SELECT fp.id_feature_value FROM ps_feature_lang fl LEFT JOIN ps_feature_product fp ON fp.id_feature = fl.id_feature WHERE fl.name = "Вид изделия" AND fp.id_product = 731 LIMIT 1
in /override/classes/db/Db.php:565
10 rows browsed

0.31 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

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

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

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

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

0.302 ms SELECT `active` FROM `ps_dz_pen_constructor` WHERE `id_product` = "731" LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

0.302 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 85659 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

0.3 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=85659
in /override/classes/db/Db.php:519
8 rows browsed

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

0.297 ms SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.id_cms = b.id_cms AND b.id_lang = 1 LEFT JOIN `ps_cms_shop` `c` ON a.id_cms = c.id_cms AND c.id_shop = 1 WHERE (a.id_cms = 6) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.297 ms SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 731 AND image_shop.`cover` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.295 ms SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.292 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` = "1" WHERE a.`active` = 1
in /override/classes/db/Db.php:519
4 rows browsed

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

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

0.287 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.286 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.282 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 74235) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

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

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

0.278 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.278 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 74235 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

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

0.272 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=731
in /override/classes/db/Db.php:519
8 rows browsed

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

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

0.271 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 85659 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

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

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

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

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

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

0.261 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE p.id_product = 80928 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 100 DAY ) ) > 0
in /override/classes/db/Db.php:519
0 rows browsed

0.261 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.256 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 80928 AND `id_shop` = 1
in /override/classes/db/Db.php:519
2 rows browsed

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

0.253 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.252 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 80928) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.251 ms SELECT * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC
in /override/classes/db/Db.php:519
USING FILESORT - 14 rows browsed

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

0.246 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` = "1" WHERE a.`active` = 1
in /override/classes/db/Db.php:519
4 rows browsed

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

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

0.243 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 85659) 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_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.239 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` = 80928)
in /override/classes/db/Db.php:519
1 row browsed

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

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

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

0.23 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 442 LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

0.228 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows browsed

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

0.227 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = 731 AND `validate` = 1 AND `grade` > 0 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.226 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows browsed

0.22 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows browsed

0.216 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows browsed

0.214 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 155 LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

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

0.209 ms SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = 731
in /override/classes/db/Db.php:519
189 rows browsed

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

0.206 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 3 AND `active` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

0.203 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 20 AND `active` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

0.2 ms SELECT `link_rewrite` FROM `ps_dzfilterseo_lang` WHERE `id_dzfilterseo` = 225 AND `id_lang` = 1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

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

0.192 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.192 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 85387 AND id_shop=1 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

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

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

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

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

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

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

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

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

0.171 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

0.17 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 6 LIMIT 1
in /override/classes/db/Db.php:565
0 rows browsed

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

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

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

0.167 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.166 ms SELECT `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 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 `id_category` FROM `ps_manufacturer` WHERE `id_manufacturer` = 2 LIMIT 1
in /override/classes/db/Db.php:565
1 row browsed

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

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

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

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

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

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

18 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"

11 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

8 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 * 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

6 SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=XX

6 SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) WHERE p.id_product = XX AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL XX DAY ) ) > XX

6 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

6 SELECT dzv.`id_video`, dzv.`link`, dzvl.`name`, dzv.`active`, dzv.`position` FROM `ps_dzseovideopage` dzv LEFT JOIN `ps_dzseovideopage_lang` dzvl ON dzv.`id_video` = dzvl.`id_video` WHERE dzvl.`id_lang` = XX ORDER BY `position` ASC

6 SELECT `id_video` FROM `ps_dzseovideopage_products` WHERE `id_product` = XX

6 SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX

6 SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) LIMIT XX

5 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

5 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX

5 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)

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

5 SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX

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

4 SELECT * FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE `id_product` = XX AND image_shop.`cover`= XX LIMIT XX

3 SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX

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

2 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 nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX

2 SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = XX AND pc.`deleted` = XX AND pc.`validate` = XX LIMIT XX

2 SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = XX AND pccl.`id_lang` = XX AND pc.`validate` = XX

2 SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = XX AND `validate` = XX AND `grade` > 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

2 SELECT cu.id_customization, cd.index, cd.value, cd.type, cu.in_cart, cu.quantity FROM `ps_customization` cu LEFT JOIN `ps_customized_data` cd ON (cu.`id_customization` = cd.`id_customization`) WHERE cu.id_cart = XX AND cu.id_product = XX AND type = XX AND in_cart = XX

2 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX

Tables stress

41 dz_cart_customer_field

31 product_shop

27 product

26 manufacturer

24 category_lang

21 dz_cart_customer_field_show

19 stock_available

19 dz_cart_customer_field_value

15 category

13 product_lang

12 image_type

11 category_shop

9 product_comment

7 cms

7 cms_shop

7 image_shop

7 image

7 cms_lang

7 module

6 dzseovideopage_lang

6 dzseovideopage_products

6 dzseovideopage

6 tag

6 specific_price

6 product_tag

5 module_shop

5 lang

5 specific_price_priority

4 currency_shop

4 hook

4 lang_shop

3 category_product

3 theme

3 shop_url

3 feature_product

3 meta

3 product_comment_criterion

3 shop

3 currency

3 product_comment_criterion_lang

3 dz_cart_customer_field_lang

3 feature_lang

2 attribute

2 image_lang

2 dzfilterseo_lang

2 customized_data

2 feature_value_lang

2 product_comment_usefulness

2 product_comment_grade

2 product_attribute

2 product_attribute_shop

2 product_attribute_combination

2 state

2 country_shop

2 customization

2 hook_alias

2 meta_lang

2 country_lang

2 hook_module

2 pack

2 group_shop

2 dz_seo_lang_hook_lang

2 dz_seo_lang_hook

2 country

1 dzordergifts

1 dz_word_wrap_lang

1 dz_word_wrap

1 product_comment_criterion_product

1 themeconfigurator

1 customer

1 manufacturer_shop

1 dzfilterseo

1 product_comment_criterion_category

1 gender_lang

1 group_lang

1 supplier

1 hook_module_exceptions

1 zone

1 group

1 theme_meta

1 configuration

1 configuration_lang

1 shop_group

1 product_download

1 layered_indexable_attribute_lang_value

1 customization_field

1 customization_field_lang

1 accessory

1 dz_pen_constructor

1 feature

1 attribute_lang

1 attribute_group_lang

1 attribute_shop

1 manufacturer_lang

ObjectModel instances

21 Product

18 Address

18 Category

7 CMS

2 Language

1 DzCartSetting

1 Manufacturer

1 Group

1 Cart

1 Country

1 Theme

1 ShopGroup

1 Customer

1 Currency

1 Shop

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/ru.php
69 modules/smartblog/translations/ru.php
70 modules/dz_ajaxload/dz_ajaxload.php
71 modules/dz_ajaxload/classes/Dz_ajaxloadDb.php
72 themes/attr/modules/dz_ajaxload/translations/ru.php
73 modules/dz_ajaxload/translations/ru.php
74 modules/dzseovideopage/dzseovideopage.php
75 modules/dzseovideopage/classes/DzSeoVideoPageForms.php
76 modules/dzseovideopage/classes/DzSeoVideoPageModel.php
77 themes/attr/modules/dzseovideopage/translations/ru.php
78 modules/dzseovideopage/translations/ru.php
79 modules/shopspage/shopspage.php
80 modules/shopspage/class/ShopsPageForms.php
81 modules/shopspage/class/ShopsPageClass.php
82 themes/attr/modules/shopspage/translations/ru.php
83 modules/shopspage/translations/ru.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/ru.php
92 modules/dz_cart/translations/ru.php
93 modules/dzfilter/dzfilter.php
94 modules/dzfilter/classes/DzFilterDb.php
95 modules/dzfilter/classes/DzfilterSeoMap.php
96 themes/attr/modules/dzfilter/translations/ru.php
97 modules/dzfilter/translations/ru.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/ru.php
107 modules/dz_pen_constructor/ru.php
108 controllers/front/ProductController.php
109 themes/attr/lang/ru.php
110 classes/Currency.php
111 classes/Cart.php
112 override/classes/Cart.php
113 classes/CartRule.php
114 override/classes/CartRule.php
115 classes/Product.php
116 override/classes/Product.php
117 classes/webservice/WebserviceRequest.php
118 override/classes/Category.php
119 classes/Manufacturer.php
120 override/classes/Manufacturer.php
121 classes/Supplier.php
122 classes/Address.php
123 override/classes/Address.php
124 classes/tax/TaxManagerFactory.php
125 classes/tax/TaxRulesTaxManager.php
126 classes/tax/TaxManagerInterface.php
127 classes/tax/TaxCalculator.php
128 classes/tax/Tax.php
129 classes/Combination.php
130 classes/SpecificPrice.php
131 classes/GroupReduction.php
132 classes/Tag.php
133 classes/stock/StockAvailable.php
134 classes/Media.php
135 modules/blockbestsellers/blockbestsellers.php
136 themes/attr/modules/blockbestsellers/translations/ru.php
137 modules/blockbestsellers/translations/ru.php
138 modules/blockcart/blockcart.php
139 themes/attr/modules/blockcart/translations/ru.php
140 modules/blockcart/translations/ru.php
141 modules/blockcategories/blockcategories.php
142 themes/attr/modules/blockcategories/translations/ru.php
143 modules/blockcategories/translations/ru.php
144 modules/blockcontact/blockcontact.php
145 modules/blockcontact/controllers/admin/CopyImagesController.php
146 themes/attr/modules/blockcontact/translations/ru.php
147 modules/blockcontact/translations/ru.php
148 modules/blockcontactinfos/blockcontactinfos.php
149 themes/attr/modules/blockcontactinfos/translations/ru.php
150 modules/blockcontactinfos/translations/ru.php
151 modules/blocknewproducts/blocknewproducts.php
152 themes/attr/modules/blocknewproducts/translations/ru.php
153 modules/blocknewproducts/translations/ru.php
154 modules/blocksearch/blocksearch.php
155 themes/attr/modules/blocksearch/translations/ru.php
156 modules/blocksearch/translations/ru.php
157 modules/homeslider/homeslider.php
158 modules/homeslider/HomeSlide.php
159 themes/attr/modules/homeslider/translations/ru.php
160 modules/homeslider/translations/ru.php
161 modules/homefeatured/homefeatured.php
162 themes/attr/modules/homefeatured/translations/ru.php
163 modules/homefeatured/translations/ru.php
164 modules/themeconfigurator/themeconfigurator.php
165 themes/attr/modules/themeconfigurator/translations/ru.php
166 modules/themeconfigurator/translations/ru.php
167 modules/productcomments/productcomments.php
168 themes/attr/modules/productcomments/translations/ru.php
169 modules/productcomments/translations/ru.php
170 modules/editorial/editorial.php
171 themes/attr/modules/editorial/translations/ru.php
172 modules/editorial/translations/ru.php
173 modules/editorial/EditorialClass.php
174 modules/blocksocial/blocksocial.php
175 themes/attr/modules/blocksocial/translations/ru.php
176 modules/blocksocial/translations/ru.php
177 modules/mailalerts/mailalerts.php
178 modules/mailalerts/MailAlert.php
179 themes/attr/modules/mailalerts/translations/ru.php
180 modules/mailalerts/translations/ru.php
181 modules/blockonsale/blockonsale.php
182 themes/attr/modules/blockonsale/translations/ru.php
183 modules/blockonsale/translations/ru.php
184 modules/powatag/powatag.php
185 classes/PaymentModule.php
186 modules/powatag/classes/PowaTagLogs.php
187 modules/powatag/classes/PowaTagProductAttributeHelper.php
188 modules/powatag/classes/PowaTagProductHelper.php
189 modules/powatag/classes/PowaTagProductQuantityHelper.php
190 modules/powatag/classes/PowaTagRequestLogs.php
191 modules/powatag/classes/PowaTagTransaction.php
192 modules/powatag/classes/helper/powatagTotAdminTabHelper.php
193 themes/attr/modules/powatag/translations/ru.php
194 modules/powatag/translations/ru.php
195 cache/smarty/compile/b4/89/68/b489683ee9c16700bb363001b5ab0af31099e539.file.powatag_header.tpl.php
196 tools/smarty/sysplugins/smarty_internal_filter_handler.php
197 tools/minify_html/minify_html.class.php
198 modules/blockmanufacturer/blockmanufacturer.php
199 themes/attr/modules/blockmanufacturer/translations/ru.php
200 modules/blockmanufacturer/translations/ru.php
201 modules/socialsharing/socialsharing.php
202 themes/attr/modules/socialsharing/translations/ru.php
203 modules/socialsharing/translations/ru.php
204 cache/smarty/compile/b6/88/41/b68841b81141a41f56c21fee6e749a4aae5f0540.file.socialsharing_header.tpl.cache.php
205 tools/smarty/sysplugins/smarty_internal_write_file.php
206 modules/eicaptcha/eicaptcha.php
207 themes/attr/modules/eicaptcha/translations/ru.php
208 modules/eicaptcha/translations/ru.php
209 modules/productscategory/productscategory.php
210 themes/attr/modules/productscategory/translations/ru.php
211 modules/productscategory/translations/ru.php
212 modules/dzshortlinks/dzshortlinks.php
213 modules/dzshortlinks/classes/DzShortLinksDb.php
214 themes/attr/modules/dzshortlinks/translations/ru.php
215 modules/dzshortlinks/translations/ru.php
216 modules/dzordergifts/dzordergifts.php
217 modules/dzordergifts/classes/DzOrderGiftsDb.php
218 modules/dzordergifts/classes/DzOrderGiftObject.php
219 themes/attr/modules/dzordergifts/translations/ru.php
220 modules/dzordergifts/translations/ru.php
221 modules/dzbuytogether/dzbuytogether.php
222 modules/dzbuytogether/classes/DzBuyTogetherDb.php
223 themes/attr/modules/dzbuytogether/translations/ru.php
224 modules/dzbuytogether/translations/ru.php
225 modules/dz_carrier_warehouse/dz_carrier_warehouse.php
226 modules/dz_carrier_warehouse/classes/Dz_carrier_warehouseCarrier.php
227 classes/module/CarrierModule.php
228 themes/attr/modules/dz_carrier_warehouse/translations/ru.php
229 modules/dz_carrier_warehouse/translations/ru.php
230 modules/dz_seo_lang/dz_seo_lang.php
231 modules/dz_seo_lang/classes/SeoCode.php
232 themes/attr/modules/dz_seo_lang/translations/ru.php
233 modules/dz_seo_lang/translations/ru.php
234 cache/smarty/compile/78/53/60/785360407ed7b4232c4a210e04ab42901aa97392.file.header.tpl.php
235 tools/js_minify/jsmin.php
236 modules/dz_nova_poshta/dz_nova_poshta.php
237 modules/dz_nova_poshta/classes/Dz_nova_poshtaCarrier.php
238 modules/dz_nova_poshta/classes/DzNp.php
239 modules/dz_nova_poshta/classes/DzNpDb.php
240 modules/dz_nova_poshta/classes/DzNpAddress.php
241 modules/dz_nova_poshta/classes/DzNpCommon.php
242 modules/dz_nova_poshta/classes/DzNpInternetDocument.php
243 modules/dz_nova_poshta/classes/DzNpCounterparty.php
244 themes/attr/modules/dz_nova_poshta/translations/ru.php
245 modules/dz_nova_poshta/translations/ru.php
246 modules/dz_nova_poshta/ru.php
247 modules/dz_cashless/dz_cashless.php
248 themes/attr/modules/dz_cashless/translations/ru.php
249 modules/dz_cashless/translations/ru.php
250 modules/blocktopmenu/blocktopmenu.php
251 modules/blocktopmenu/menutoplinks.class.php
252 themes/attr/modules/blocktopmenu/translations/ru.php
253 modules/blocktopmenu/translations/ru.php
254 modules/dz_debug/dz_debug.php
255 themes/attr/modules/dz_debug/translations/ru.php
256 modules/dz_debug/translations/ru.php
257 modules/dzsync1c/dzsync1c.php
258 modules/dzsync1c/classes/DzSync1cDb.php
259 modules/dzsync1c/classes/DzSync1cObject.php
260 themes/attr/modules/dzsync1c/translations/ru.php
261 modules/dzsync1c/translations/ru.php
262 modules/blockcms/blockcms.php
263 modules/blockcms/BlockCMSModel.php
264 themes/attr/modules/blockcms/translations/ru.php
265 modules/blockcms/translations/ru.php
266 cache/smarty/cache/blockcms/top/1/1/1/216/7f/73/0f/7f730f454e0ca5d20116f0fb41d492192fbd77d3.blockcms_top.tpl.php
267 cache/smarty/cache/blocksocial/1/1/1/216/a5/b3/5f/a5b35fe3b7f6d3eef458f1f9085ae18dd290aa3a.blocksocial.tpl.php
268 cache/smarty/cache/blocksearch_top/1/1/1/216/02/e7/1a/02e71a9249b8674163cf975fb33fa96e9da86f69.blocksearch-top.tpl.php
269 cache/smarty/cache/blockcontact/1/1/1/216/13/90/fa/1390fad7e6c6932d26a56fad3e80a8c888cdcff4.blockcontact_top.tpl.php
270 cache/smarty/cache/blocktopmenu/1/1/1/216/05/ad/d7/05add7601f76982f34b7a402fa1d79c85ff1630e.blocktopmenu.tpl.php
271 cache/smarty/compile/b6/2c/b4/b62cb468796a471bd2568a9f32d28a7126070a58.file.dzAjaxLoad.tpl.php
272 classes/Pack.php
273 classes/ProductDownload.php
274 classes/Customization.php
275 classes/Image.php
276 override/classes/Image.php
277 classes/ImageType.php
278 modules/productcomments/ProductComment.php
279 modules/productcomments/ProductCommentCriterion.php
280 cache/smarty/compile/ee/fe/34/eefe34efae8c55199ca1a23010649ebab7212ffb.file.productcomments-extra.tpl.php
281 cache/smarty/compile/7f/50/70/7f5070eca2fbc254a17149e5616e9244005798bb.file.product.tpl.php
282 cache/smarty/compile/64/ff/e4/64ffe45bc86f938e681e7c66e4a538bace9749a1.file.tab.tpl.php
283 cache/smarty/compile/ed/a5/06/eda50686191c7a9da3861bead93463f1dd80987b.file.productcomments.tpl.php
284 cache/smarty/compile/51/7f/71/517f717605dd159e645485387dc8653c2e4673ba.file.displayProductTabContent.tpl.php
285 cache/smarty/compile/04/31/16/043116cf7c3340e15458e6e17bbac464a94a4975.file.blocktopmenu_footer.tpl.php
286 cache/smarty/cache/blockcms/2/1/1/1/216/81/27/2b/81272bc7e8fb262950ed198a412d2ce43a7e363e.blockcms.tpl.php
287 cache/smarty/cache/blockcontactinfos/1/1/1/216/90/88/1a/90881acdbd08508a1ec725779df50fd412c8f80c.blockcontactinfos.tpl.php
288 cache/smarty/compile/a1/b4/28/a1b428aa468ecb6bdd1418d7fc72f783d5cfca43.file.hook.tpl.php
289 modules/blocknewsletter/blocknewsletter.php
290 themes/attr/modules/blocknewsletter/translations/ru.php
291 modules/blocknewsletter/translations/ru.php
292 cache/smarty/compile/bd/60/1f/bd601f54955c31d58c1d4cf83b5f3b2a75fe4fa7.file.blocknewsletter.tpl.php
293 modules/blockmyaccountfooter/blockmyaccountfooter.php
294 themes/attr/modules/blockmyaccountfooter/translations/ru.php
295 modules/blockmyaccountfooter/translations/ru.php
296 cache/smarty/cache/blockmyaccountfooter/1/1/1/216/90/24/fa/9024fa5f611a09b62b11468d2634f37c930bea31.blockmyaccountfooter.tpl.php
297 modules/dz_word_wrap/dz_word_wrap.php
298 modules/dz_word_wrap/classes/Dz_word_wrapDb.php
299 themes/attr/modules/dz_word_wrap/translations/ru.php
300 modules/dz_word_wrap/translations/ru.php
301 cache/smarty/compile/7b/9c/bb/7b9cbb63e2b9a6e62b2a352818e96133b48542ee.file.footer.tpl.php
302 cache/smarty/compile/98/eb/ab/98ebabb7150edf1324d06d1e76b91ffd4bf09bc2.file.dzCartLogin.tpl.php
303 cache/smarty/compile/4c/57/f8/4c57f885411b79323a70c1ecf2af53a97771ca35.file.dz-cart-customer-login.tpl.php
304 tools/smarty/plugins/modifier.replace.php
305 cache/smarty/compile/f0/d7/54/f0d75481cc60c43dd7e421c7dab7822eb850d1ca.file.dz-cart-errors.tpl.php
306 cache/smarty/compile/30/a0/58/30a058ff6fc6be549325815c76ada2e095dd718c.file.dz-cart-customer-fields-form-new.tpl.php
307 cache/smarty/compile/84/0b/35/840b353dec7da2377b93631af9a346d0da9654e7.file.dz-cart-customer-phone-confirm.tpl.php
308 tools/smarty/plugins/shared.mb_str_replace.php
309 cache/smarty/compile/93/03/10/930310e96ccdee06114402b3d8c75e3658359339.file.dzCartAuth.tpl.php
310 cache/smarty/compile/41/f5/93/41f593162134ac2a051e80978c4f1999250b7b0f.file.footer.tpl.php
311 cache/smarty/compile/01/bf/84/01bf846fd6b2178fe6eaa1133b286f413d8e0804.file.footer.tpl.php
312 cache/smarty/compile/09/e7/ad/09e7ad1511e777189ae2623b2c70e08aa5fc8073.file.product.tpl.php
313 tools/smarty/plugins/modifier.date_format.php
314 tools/smarty/plugins/function.math.php
315 tools/smarty/plugins/function.cycle.php
316 cache/smarty/compile/c3/c9/2d/c3c92d66095a3270dc447e19ad38663e743a4208.file.errors.tpl.php
317 cache/smarty/compile/f7/b7/01/f7b70141e2a77d04e9f5d1d2ae8c479d4a3044f5.file.favorite.tpl.php
318 tools/smarty/plugins/shared.make_timestamp.php
319 cache/smarty/compile/d6/53/9f/d6539fdd98ddf1f4d55a33dfde95015711873ed4.file.displayProductButtons.tpl.php
320 classes/CMS.php
321 cache/smarty/compile/49/1f/9e/491f9e034e6cd49ba1903ec0818a02509e453e1d.file.layout.tpl.php
322 cache/smarty/compile/a4/1c/ca/a41cca29f154eae2aac6231b96011ad9f2aac6d0.file.header.tpl.php
323 tools/smarty/plugins/modifier.regex_replace.php
324 tools/smarty/plugins/function.implode.php
325 modules/mkclickzone/mkclickzone.php
326 modules/mkclickzone/ClickZone.php
327 themes/attr/modules/mkclickzone/translations/ru.php
328 modules/mkclickzone/translations/ru.php
329 cache/smarty/compile/82/23/2b/82232bd85a07c01c44c8d933df949dfff879fc10.file.dzSeoLang.tpl.php
330 cache/smarty/compile/85/df/46/85df4621f102d61183235d32d8c19dbc6e47efbb.file.breadcrumb.tpl.php
331 cache/smarty/compile/95/40/7f/95407f1c01c5af5a24613a0cf22805e913fd1915.file.footer.tpl.php
332 cache/smarty/compile/c1/2e/13/c12e138aad715e821f978a0d328ef3e71e90f2fd.file.global.tpl.php
333 cache/smarty/compile/20/be/2e/20be2ee020a13947212660466f91a9a7b518740e.file.javascript.tpl.php