Europe’s #1 exclusive supplier of Standing Desks, Height Adjustable Ergonomic Furniture & Accessories.

It is our mission to convert sedentary offices to active, healthy and productive workplaces. We offer the best range of standing desks, height adjustable desks, active seating and cost-effective solutions to help office workers stand and move more comfortably. To ensure maximum wellness why not arrange for an Active Working Seminar or one of our experts to visit your office and advise you on any specific needs. We also provide training, seminars and free guidelines. More Choices. Best Prices. Work Smart. Work Healthier.
Price Promise

Price Promise

We guarantee the LOWEST PRICES for all standing desks. Otherwise we refund the difference. Simple.

free delivery

Free Delivery / Installation

FREE delivery with many solutions. FREE installation with most standing desks.

free trial

Free Trial

Take advantage of our FREE trial standing desk offers

 
 
Load time: 777ms
I hope it is a shared hosting
Hook processing: 480ms / 23.12 Mb
44 methods called in 30 modules
Memory peak usage: 39.4 Mb

Total cache size (in Cache class): 0 Mb
DB type: DbPDO
SQL Queries: 613 queries
Time spent querying: 102ms
Included files: 191
Size of included files: 3.08 Mb
Globals (> 1 Ko only): 557 Ko

Stopwatch (with SQL_NO_CACHE) (total = 613)


4.032 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 75)
in /classes/Product.php:2701
2879 rows browsed

1.315 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 152)
in /classes/Product.php:2701
863 rows browsed

1.018 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 93)
in /classes/Product.php:2701
600 rows browsed

1.003 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 /classes/Configuration.php:118
669 rows browsed

0.874 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 /classes/Hook.php:228
USING FILESORT - 49 rows browsed

0.681 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 /classes/Hook.php:131
0 rows browsed

0.617 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` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
in /classes/Hook.php:346
USING FILESORT - 44 rows browsed
Useless GROUP BY need to be removed

0.608 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 95)
in /classes/Product.php:2701
300 rows browsed

0.585 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 134)
in /classes/Product.php:2701
288 rows browsed

0.481 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 35)
in /classes/Product.php:2701
216 rows browsed

0.478 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 112)
in /classes/Product.php:2701
192 rows browsed

0.442 ms SELECT DISTINCT a.*, cl.`name` AS country, s.name AS state, s.iso_code AS state_iso FROM `ps_address` a LEFT JOIN `ps_country` c ON (a.`id_country` = c.`id_country`) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country`) LEFT JOIN `ps_state` s ON (s.`id_state` = a.`id_state`) INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1) WHERE `id_lang` = 1 AND `id_customer` = 0 AND a.`deleted` = 0
in /classes/Customer.php:457
2 rows browsed

0.439 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 24)
in /classes/Product.php:2701
191 rows browsed

0.368 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
in /classes/module/Module.php:1717
355 rows browsed

0.29 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 24 LIMIT 1
in /classes/Product.php:660
191 rows browsed

0.286 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 = 'test.sit-stand.com' OR su.domain_ssl = 'test.sit-stand.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
in /classes/shop/Shop.php:329
USING FILESORT - 1 row browsed

0.283 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 /classes/Dispatcher.php:461
USING FILESORT - 56 rows browsed

0.273 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 125)
in /classes/Product.php:2701
64 rows browsed

0.254 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 75) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.246 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 35) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.244 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 24) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.244 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 134) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.243 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 152) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 93) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 156) AND `id_product_attribute` IN (0, 105643) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 112) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 125) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 162) AND `id_product_attribute` IN (0, 132600) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 44) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.242 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 123) AND `id_product_attribute` IN (0, 105387) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.241 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 = 155) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.241 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 123) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.241 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 145) AND `id_product_attribute` IN (0, 90717) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.241 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 95) AND `id_product_attribute` IN (0, 101959) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.241 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 157) AND `id_product_attribute` IN (0, 107712) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.24 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 134) AND `id_product_attribute` IN (0, 132624) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.24 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 160) AND `id_product_attribute` IN (0, 133272) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.24 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 160) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.24 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 95) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 164) AND `id_product_attribute` IN (0, 133284) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 112) AND `id_product_attribute` IN (0, 107980) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 125) AND `id_product_attribute` IN (0, 90653) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 31) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 157) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 156) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 35) AND `id_product_attribute` IN (0, 133056) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 24) AND `id_product_attribute` IN (0, 64653) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 145) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.239 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 25) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 152) AND `id_product_attribute` IN (0, 102739) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 164) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 75) AND `id_product_attribute` IN (0, 133298) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 162) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 120) AND `id_product_attribute` IN (0, 105385) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.238 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 31) AND `id_product_attribute` IN (0, 91336) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.237 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 = 45) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.237 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 25) AND `id_product_attribute` IN (0, 133276) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.235 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 93) AND `id_product_attribute` IN (0, 107094) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.235 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 = 123) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.233 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 = 48) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.232 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 = 24) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.232 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 = 93) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.231 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 = 85) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.231 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 = 110) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.231 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 = 125) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.23 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 = 134) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.23 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 = 44) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.23 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 = 156) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.229 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 = 164) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.228 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 = 145) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.228 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 = 31) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.228 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 = 160) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.228 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 = 152) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.227 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 = 95) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.226 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 = 157) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.226 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 = 35) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.225 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 = 112) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.225 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 = 162) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.225 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 = 25) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.22 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 157)
in /classes/Product.php:2701
24 rows browsed

0.218 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 = 75) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.206 ms SELECT *, ( IF ('2019-08-19 06:58:40' >= `from` AND '2019-08-19 06:58:40' <= `to`, 1, 0) + IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 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, 120) AND `id_product_attribute` IN (0, 0) AND `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_customer` IN (0, 0) AND ( (`from` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-08-19 06:58:40' <= `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 /classes/SpecificPrice.php:237
USING FILESORT - 37 rows browsed

0.204 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 /classes/module/Module.php:205
49 rows browsed

0.204 ms SELECT m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1) INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1) WHERE m.`active` = 1 ORDER BY m.`name` ASC
in /classes/Manufacturer.php:177
USING FILESORT - 25 rows browsed

0.202 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 = 120) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.201 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 = 128) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.2 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 = 106) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.199 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 = 157) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.199 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 = 145) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.199 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 162)
in /classes/Product.php:2701
12 rows browsed

0.199 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 = 112) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.198 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 = 160) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.196 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 = 93) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.196 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 = 119) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.196 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 = 25) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.195 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 = 35) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.195 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 = 123) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.194 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 = 44) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.192 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 = 152) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.191 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 25)
in /classes/Product.php:2701
8 rows browsed

0.189 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 = 75) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.188 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 160)
in /classes/Product.php:2701
2 rows browsed

0.187 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 145)
in /classes/Product.php:2701
5 rows browsed

0.185 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 164)
in /classes/Product.php:2701
2 rows browsed

0.185 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 123)
in /classes/Product.php:2701
2 rows browsed

0.185 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 = 31) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.184 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 156)
in /classes/Product.php:2701
2 rows browsed

0.182 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 120)
in /classes/Product.php:2701
2 rows browsed

0.182 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 = 112) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.182 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 31)
in /classes/Product.php:2701
2 rows browsed

0.181 ms SELECT a.id_wpimageslider, b.id_wpimageslider FROM ps_wpimageslider as a, ps_wpimageslider_shop as b WHERE a.id_wpimageslider = b.id_wpimageslider AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpimageslider/model/wpImageSliderModel.php:130
USING FILESORT - 18 rows browsed

0.181 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 75 LIMIT 1
in /classes/Product.php:660
2879 rows browsed

0.179 ms SELECT a.id_wpfrontpageblocks, b.id_wpfrontpageblocks FROM ps_wpfrontpageblocks as a, ps_wpfrontpageblocks_shop as b WHERE a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpfrontpageblocks/model/wpFrontpageBlocksModel.php:131
USING FILESORT - 10 rows browsed

0.178 ms SELECT product_shop.`price`, product_shop.`ecotax`, product_attribute_shop.id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on 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) LEFT JOIN `ps_product_attribute` `pa` ON pa.`id_product` = p.`id_product` LEFT 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) WHERE (p.`id_product` = 44)
in /classes/Product.php:2701
1 row browsed

0.176 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` = 24 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
25 rows browsed

0.174 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 /classes/Currency.php:219
USING FILESORT - 16 rows browsed

0.172 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 164 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.171 ms SELECT * FROM `ps_tax_rule` WHERE `id_country` = 17 AND `id_tax_rules_group` = 0 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed

0.17 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`=75
in /classes/Tag.php:166
14 rows browsed

0.169 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 75) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.168 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 134) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.167 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` = 75 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
7 rows browsed

0.167 ms SELECT a.id_wpmegamenu FROM ps_wpmegamenu as a, ps_wpmegamenu_shop as b WHERE a.id_wpmegamenu = b.id_wpmegamenu AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpmegamenu/model/wpMegamenuModel.php:81
USING FILESORT - 8 rows browsed

0.167 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` = 145 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
15 rows browsed

0.167 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 = 120) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.167 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 = 97) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.166 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` = 93 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
13 rows browsed

0.165 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 = 55) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.165 ms SELECT a.id_wpisotopetabs, b.id_wpisotopetabs FROM ps_wpisotopetabs as a, ps_wpisotopetabs_shop as b WHERE a.id_wpisotopetabs = b.id_wpisotopetabs AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpisotopetabs/model/wpIsotopeTabsModel.php:88
USING FILESORT - 7 rows browsed

0.165 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` = 155 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
9 rows browsed

0.165 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 0 AND 1 AND items.id_wpmegamenu =12 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.165 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 344) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.165 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 35 AND items.id_wpmegamenu =10 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.164 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 = 162) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.164 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 = 164) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.164 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 33 AND items.id_wpmegamenu =17 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.164 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` = 112 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
13 rows browsed

0.164 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` = 25 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
18 rows browsed

0.164 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` = 134 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
8 rows browsed

0.163 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 75 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.163 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` = 160 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
12 rows browsed

0.163 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 = 156) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.163 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 = 110) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.162 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 = 125) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.162 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 23 AND items.id_wpmegamenu =13 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.162 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 = 134) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.161 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 17 AND items.id_wpmegamenu =18 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.161 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 367) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.161 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 = 24) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.16 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` = 95 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
14 rows browsed

0.16 ms SELECT * FROM `ps_tax_rule` WHERE `id_country` = 17 AND `id_tax_rules_group` = 1 AND `id_state` IN (0, 0) AND ('0' BETWEEN `zipcode_from` AND `zipcode_to` OR (`zipcode_to` = 0 AND `zipcode_from` IN(0, '0'))) ORDER BY `zipcode_from` DESC, `zipcode_to` DESC, `id_state` DESC, `id_country` DESC
in /classes/tax/TaxRulesTaxManager.php:90
USING FILESORT - 1 row browsed

0.159 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 0 AND 1 AND items.id_wpmegamenu =19 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.159 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` = 156 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
11 rows browsed

0.159 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` = 125 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
6 rows browsed

0.158 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 0 AND 1 AND items.id_wpmegamenu =12 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.158 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` = 31 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
9 rows browsed

0.158 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 95 LIMIT 1
in /classes/Product.php:660
300 rows browsed

0.158 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` = 157 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
16 rows browsed

0.158 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` = 44 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
10 rows browsed

0.158 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 120 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.158 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` = 152 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
16 rows browsed

0.158 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 44 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.158 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` = 164 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
3 rows browsed

0.157 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 47 AND items.id_wpmegamenu =11 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.157 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`=44
in /classes/Tag.php:166
9 rows browsed

0.157 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 /classes/Currency.php:443
4 rows browsed

0.157 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` = 48 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
8 rows browsed

0.156 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 123) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.156 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 157 LIMIT 1
in /classes/Product.php:660
24 rows browsed

0.156 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 162) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.156 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` = 162 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
23 rows browsed

0.156 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 59) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.156 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 162 LIMIT 1
in /classes/Product.php:660
12 rows browsed

0.156 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 = 98) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.156 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 248) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.155 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`=25
in /classes/Tag.php:166
10 rows browsed

0.155 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 47) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.155 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` = 123 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
20 rows browsed

0.155 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 35 LIMIT 1
in /classes/Product.php:660
216 rows browsed

0.155 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.155 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 160 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.155 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` = 85 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
4 rows browsed

0.155 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`=24
in /classes/Tag.php:166
11 rows browsed

0.155 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 24) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.154 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` = 35 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
15 rows browsed

0.154 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 123 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.154 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`=35
in /classes/Tag.php:166
11 rows browsed

0.154 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 164) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.154 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 112 LIMIT 1
in /classes/Product.php:660
192 rows browsed

0.154 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 152) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.154 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 120 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.154 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` = 45 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
12 rows browsed

0.154 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 112) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.154 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 152 LIMIT 1
in /classes/Product.php:660
863 rows browsed

0.154 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 145 LIMIT 1
in /classes/Product.php:660
5 rows browsed

0.154 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 152) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.154 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`=160
in /classes/Tag.php:166
10 rows browsed

0.154 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 32) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.154 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 25 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.154 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 156 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.153 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 95) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.153 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 31 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.153 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 150) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.153 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 134 LIMIT 1
in /classes/Product.php:660
288 rows browsed

0.153 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 157) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.153 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` = 110 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
1 row browsed

0.153 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 156) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.153 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 19 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.153 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`=95
in /classes/Tag.php:166
4 rows browsed

0.153 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 25 LIMIT 1
in /classes/Product.php:660
8 rows browsed

0.153 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 125 LIMIT 1
in /classes/Product.php:660
64 rows browsed

0.153 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 = 107) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.152 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 160) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.152 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 29) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.152 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 112) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.152 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 19) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.152 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 25) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.152 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 25 AND items.id_wpmegamenu =15 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.152 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 177) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.152 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 160) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.152 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 35) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.152 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`=31
in /classes/Tag.php:166
9 rows browsed

0.152 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 145 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.152 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 125) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.152 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 309) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 31) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.151 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 44) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 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 = 24 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.151 ms SELECT a.id_wpsociallinks, b.id_wpsociallinks FROM ps_wpsociallinks as a, ps_wpsociallinks_shop as b WHERE a.id_wpsociallinks = b.id_wpsociallinks AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpsociallinks/model/wpSocialLinksModel.php:180
USING FILESORT - 3 rows browsed

0.151 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 46) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 377) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 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 = 95) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 157 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.151 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 123 LIMIT 1
in /classes/Product.php:660
2 rows browsed

0.151 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 346) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.151 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 35 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.15 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 134 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.15 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 13) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 125) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.15 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 25) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.15 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 = 123 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.15 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 = 108) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 50) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 68) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 375) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 38) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 33) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.15 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 45) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 69) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 219) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 214) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 10 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.149 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`=145
in /classes/Tag.php:166
5 rows browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 370) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 200) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 215) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT * FROM `ps_wpimageslider` a LEFT JOIN `ps_wpimageslider_lang` `b` ON a.id_wpimageslider = b.id_wpimageslider AND b.id_lang = 1 LEFT JOIN `ps_wpimageslider_shop` `c` ON a.id_wpimageslider = c.id_wpimageslider AND c.id_shop = 1 WHERE (a.id_wpimageslider = 23) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 134) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 232) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 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`=123
in /classes/Tag.php:166
5 rows browsed

0.149 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 95 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.149 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 164) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.149 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 95) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.149 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 112 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.149 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 213) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.149 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 44 LIMIT 1
in /classes/Product.php:660
1 row browsed

0.148 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 75) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.148 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 157) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.148 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 13 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.148 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 160) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.148 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 157) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.148 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 31) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.148 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 44 LIMIT 1
in /classes/Product.php:670
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 373) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 162) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.148 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 152 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 17) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 10) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 12) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 164) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.148 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 156) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 364) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 11) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.`default_on` = 1 AND pa.id_product = 44 LIMIT 1
in /classes/Product.php:680
1 row browsed

0.148 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 13 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.148 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 15) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.148 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 134) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.148 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 123) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 156) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 231) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 112) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 180) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 12 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.147 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 10 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.147 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 340) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 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 = 134 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.147 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 366) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 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 = 160 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 152) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.147 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 192) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 125) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT * FROM `ps_wpmegamenu` a LEFT JOIN `ps_wpmegamenu_lang` `b` ON a.id_wpmegamenu = b.id_wpmegamenu AND b.id_lang = 1 LEFT JOIN `ps_wpmegamenu_shop` `c` ON a.id_wpmegamenu = c.id_wpmegamenu AND c.id_shop = 1 WHERE (a.id_wpmegamenu = 18) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 24) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 35) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 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 = 156 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.147 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 19 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 24) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 25) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 35) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 95) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 31) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 75) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.147 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.146 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.id_product = 44 LIMIT 1
in /classes/Product.php:689
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 374) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 332) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 123) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 218) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 162) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 313) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 216) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = 44) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:692
1 row browsed

0.146 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 = 152 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.146 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`=112
in /classes/Tag.php:166
5 rows browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 348) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 365) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 339) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 323) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 249) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.146 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 362) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 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 = 44 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 371) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = 93) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:669
1 row browsed

0.145 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 11 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.145 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 18 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 299) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 324) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 325) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 158) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.145 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 234) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.144 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 = 112 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 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 = 162 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 337) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.144 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 19 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.144 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 18 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.144 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 = 25 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 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 = 125 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 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 = 31 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 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 = 35 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.144 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 = 145 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.143 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 = 157 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.143 ms SELECT a.id_wpmegamenu FROM ps_wpmegamenu as a, ps_wpmegamenu_shop as b WHERE a.id_wpmegamenu = b.id_wpmegamenu AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpmegamenu/model/wpMegamenuModel.php:81
USING FILESORT - 8 rows browsed

0.143 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 12 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.143 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 = 95 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.143 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 17 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.142 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`=162
in /classes/Tag.php:166
1 row browsed

0.14 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 333) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.14 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 /classes/Language.php:818
1 row browsed

0.14 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 18 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.14 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`=152
in /classes/Tag.php:166
1 row browsed

0.139 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`=125
in /classes/Tag.php:166
1 row browsed

0.138 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`=164
in /classes/Tag.php:166
1 row browsed

0.138 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`=156
in /classes/Tag.php:166
1 row browsed

0.138 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 202) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 317) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 195) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 322) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 311) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 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`=157
in /classes/Tag.php:166
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 355) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.137 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 209) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.135 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 /classes/shop/Shop.php:199
1 row browsed

0.135 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` = 119 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
18 rows browsed

0.135 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 93 LIMIT 1
in /classes/Category.php:904
0 rows browsed

0.135 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 152 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.134 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 252) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.134 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` = 128 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
8 rows browsed

0.134 ms SELECT a.id_wpisotopetabs, b.id_wpisotopetabs FROM ps_wpisotopetabs as a, ps_wpisotopetabs_shop as b WHERE a.id_wpisotopetabs = b.id_wpisotopetabs AND b.id_shop = 1 AND a.active = 1 ORDER BY a.position ASC
in /modules/wpisotopetabs/model/wpIsotopeTabsModel.php:88
USING FILESORT - 7 rows browsed

0.133 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 93) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.132 ms SELECT `vat_number` FROM `ps_address` WHERE `id_customer` = 0 AND `active` = 1 AND `deleted` = 0 LIMIT 1
in /modules/checkvat/checkvat.php:412
2 rows browsed

0.132 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 = 81) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.132 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 = "index" LIMIT 1
in /classes/Theme.php:177
1 row browsed

0.131 ms SELECT * FROM `ps_wpsociallinks` a LEFT JOIN `ps_wpsociallinks_shop` `c` ON a.id_wpsociallinks = c.id_wpsociallinks AND c.id_shop = 1 WHERE (a.id_wpsociallinks = 2) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.131 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 47 AND items.id_wpmegamenu =11 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.13 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 = 56) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.13 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 58 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.129 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 33 AND items.id_wpmegamenu =17 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.129 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 = 109) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.128 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 93 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.128 ms SELECT COUNT(*) FROM `ps_hook_module` hm LEFT JOIN `ps_hook` h ON (h.`id_hook` = hm.`id_hook`) WHERE h.`name` = 'home' AND hm.`id_module` = 38 LIMIT 1
in /classes/module/Module.php:1796
0 rows browsed

0.128 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 = 113) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.128 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 = 118) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.128 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 35 AND items.id_wpmegamenu =10 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.128 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 25 AND items.id_wpmegamenu =15 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.128 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 = 17) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.127 ms SELECT * FROM `ps_hook_alias`
in /classes/Hook.php:183
86 rows browsed

0.127 ms SELECT pa.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE product_attribute_shop.default_on = 1 AND pa.id_product = 93 LIMIT 1
in /classes/Product.php:660
600 rows browsed

0.127 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 = 115) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.127 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 = 114) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.127 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 = 116) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.127 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 23 AND items.id_wpmegamenu =13 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.127 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 55 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.127 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blockbestsellers" LIMIT 1
in /classes/module/Module.php:2057
1 row browsed

0.126 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_shop` `c` ON a.id_country = c.id_country AND c.id_shop = 1 WHERE (a.id_country = 17) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.126 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 2 AND 17 AND items.id_wpmegamenu =18 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.126 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 = 117) AND (b.id_shop = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.125 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 31 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.125 ms SELECT items.id_wpmegamenuitems FROM ps_wpmegamenuitems as items WHERE items.nleft BETWEEN 0 AND 1 AND items.id_wpmegamenu =19 ORDER BY items.nleft
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:142
USING FILESORT - 156 rows browsed

0.125 ms SELECT * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "index" OR m.page = "index" ) AND ml.id_lang = 1 AND ml.id_shop = 1 LIMIT 1
in /classes/Meta.php:142
1 row browsed

0.125 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 53 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.125 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 35 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.125 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 71 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.124 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 109 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.124 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 94 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.124 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 145 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.124 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 66 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.124 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 110 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.124 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 123 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.124 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 125 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.124 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 134 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.124 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 40 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.123 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 13 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.123 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 90 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.123 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 156 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.123 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 4 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.123 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 134 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.123 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 112 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.123 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 35 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.123 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 120 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.123 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 93 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.123 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 24 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.123 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 95 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 162 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 95 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 157 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 160 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 164 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 125 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 164 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 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` = 120 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
17 rows browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 112 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 44 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 157 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 25 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 145 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 160 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 162 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.122 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 162 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.122 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 24 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.121 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 156 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.121 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 152 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.121 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 31 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.121 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 145) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.121 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 44 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.121 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 75 ORDER BY `id_specific_price_priority` DESC LIMIT 1
in /classes/SpecificPrice.php:190
1 row browsed

0.121 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 25 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.12 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 27 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.12 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 = 93 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.12 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`=93
in /classes/Tag.php:166
4 rows browsed

0.12 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 6 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.12 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` = 106 AND image_shop.`cover` = 1 LIMIT 1
in /classes/Product.php:2480
1 row browsed

0.12 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 24 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.12 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 160 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.12 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 11 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 26 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 19 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 24 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.119 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 326) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.119 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 29 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 145 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.119 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 31 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.119 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 10 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = 28 AND `active` = 1 LIMIT 1
in /classes/Manufacturer.php:230
1 row browsed

0.119 ms SELECT * FROM `ps_shop_group` a WHERE (a.id_shop_group = 1) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.119 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 31) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.119 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 75 AND `id_shop` = 1
in /classes/ObjectModel.php:219
2 rows browsed

0.118 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 = 164 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.118 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 66 LIMIT 1
in /classes/Category.php:904
0 rows browsed

0.118 ms SELECT * FROM `ps_wpisotopetabs` a LEFT JOIN `ps_wpisotopetabs_lang` `b` ON a.id_wpisotopetabs = b.id_wpisotopetabs AND b.id_lang = 1 LEFT JOIN `ps_wpisotopetabs_shop` `c` ON a.id_wpisotopetabs = c.id_wpisotopetabs AND c.id_shop = 1 WHERE (a.id_wpisotopetabs = 6) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.118 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 55 LIMIT 1
in /classes/Category.php:904
0 rows browsed

0.118 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 75 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.118 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 110 LIMIT 1
in /classes/Category.php:904
0 rows browsed

0.118 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 35 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.118 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 331) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.117 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 310) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.117 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 156 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.117 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 164 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.117 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = 2 LIMIT 1
in /classes/Supplier.php:176
1 row browsed

0.117 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 358) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.117 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 120) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
in /classes/stock/StockAvailable.php:360
1 row browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 95 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 ms SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
in /classes/Language.php:711
1 row browsed

0.116 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 307) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 152 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 31 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 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 /classes/ObjectModel.php:212
1 row browsed

0.116 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 198) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 25 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 120 AND id_shop=1 LIMIT 1
in /classes/Product.php:4537
1 row browsed

0.116 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 302) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.116 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 33) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 24 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 160 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.116 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 76 LIMIT 1
in /classes/Category.php:904
1 row browsed

0.115 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 15 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.115 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 11 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.115 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 44 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.115 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 376) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.115 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 156 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.115 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 134 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.115 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 341) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.115 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 112 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.115 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 4) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.115 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 350) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
in /classes/module/Module.php:1780
0 rows browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 356) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 164 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.114 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 17 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 351) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 157 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 334) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 137) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_product_lang` WHERE `id_product` = 162 AND `id_shop` = 1
in /classes/ObjectModel.php:219
1 row browsed

0.114 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 123 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 379) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 368) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 13 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.114 ms SELECT * FROM `ps_wpfrontpageblocks` a LEFT JOIN `ps_wpfrontpageblocks_lang` `b` ON a.id_wpfrontpageblocks = b.id_wpfrontpageblocks AND b.id_lang = 1 LEFT JOIN `ps_wpfrontpageblocks_shop` `c` ON a.id_wpfrontpageblocks = c.id_wpfrontpageblocks AND c.id_shop = 1 WHERE (a.id_wpfrontpageblocks = 35) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 143) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 363) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.114 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 17 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.114 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 125 AND `id_group` = 1 LIMIT 1
in /classes/GroupReduction.php:142
0 rows browsed

0.113 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`=120
in /classes/Tag.php:166
5 rows browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 184) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 193) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 15 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.113 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 = 120 AND DATEDIFF( product_shop.`date_add`, DATE_SUB( NOW(), INTERVAL 0 DAY ) ) > 0
in /classes/Product.php:1149
0 rows browsed

0.113 ms SELECT MAX(nright) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 19 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:105
156 rows browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 369) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 312) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 11 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 204) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 205) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 357) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 308) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT MIN(nleft) FROM ps_wpmegamenuitems WHERE id_wpmegamenu = 12 LIMIT 1
in /modules/wpmegamenu/model/wpMegamenuItemsModel.php:87
156 rows browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 361) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
in /classes/module/Module.php:1780
0 rows browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 303) LIMIT 1
in /classes/ObjectModel.php:212
1 row browsed

0.113 ms SELECT * FROM `ps_wpmegamenuitems` a LEFT JOIN `ps_wpmegamenuitems_lang` `b` ON a.id_wpmegamenuitems = b.id_wpmegamenuitems AND b.id_lang = 1 WHERE (a.id_wpmegamenuitems = 178) LIMIT 1
in /classes/ObjectModel.php:212