Our webstore uses cookies to offer a better user experience and we recommend you to accept their use to fully enjoy your navigation. Please view our privacy and cookies policy for further information.
I accept
Need help? Call 01206 582462 or email sales@designerbathroomstore.co.uk
Cart 0 Product Products (empty)
No products
To be determined Shipping
£ 0.00 Total
Product successfully added to your shopping cart
Quantity
Total
There are 0 items in your cart. There is 1 item in your cart.
Total products
Total shipping To be determined
Total
Categories
Catalog
Showers
Subcategories
Complete Showers
At Designer Bathroom Store, we know that having a stunning bathroom suite and furniture is only half the battle in achieving the bathroom of your dreams. The second half of this battle is to fit your bathroom with excellent quality appliances and products, however choosing these products can be difficult. To complement our range of Bathroom Suites and Shower Enclosures - we source and supply a fantastic range of complete shower kit. Almost all types of showers are covered, from just a few trusted brands.
If you have any questions about our range of complete showers, please do just get in touch and we will be happy to answer any questions you may have.
Shower Valves
Although not the most exciting product we supply, Shower Valves serve a vital purpose in any bathroom - and our range of shower valves look excellent whilst doing it too. Shower Valves control the flower of water coming from your shower, not entirely different how your basin taps work. There are two main types of Shower Valves - Thermostatic and Manual valves are available within the range, although we do recommend Thermostatic Valves are used in homes with children and elderly people, to provide extra safety and peace of mind.
If you have any questions about our contemporary range of shower valves, please do just get in touch and we will be happy to answer any questions you may have.
Shower Heads and Arms
At Designer Bathroom Store, we stock and supply an impressive range of Shower Heads and Shower Arms. These products have been designed to provide an excellent showering experience, with contemporary style, and are perfectly matched to our bathroom suites and bathroom furniture.
As always, we have worked hard to source a range which represents the very best in design, quality and cost. Providing you with a stylish bathroom solution which provides faithful service for years.
Slider Rail Kits
If your bathroom is used by people of differing heights (most are!!) then a shower rail kit is the product you need. Adding an extra level of functionality to your bathroom, these kits allow you to move your shower head to the perfect height - ensuring you can enjoy the perfect shower, every single time you take one.
As always, we have worked hard to secure a reliable, tough and stylish range which complements all styles of bathrooms. You can browse the range above and find the perfect slider kit for you.
Shower Accessories
Electric Showers
At Designer Bathroom Store, as well as supplying excellent quality bathroom furniture and suites - we also supply a wide range of Showers - which have been handpicked thanks to their levels of quality. They provide the performance that our bathroom products deserve. One of the most popular types of Showers we supply is Electric Showers. These Electric Showers are a self contained unit, which heats and pumps water out of the shower head when it is needed. Only a cold water supply is needed, meaning no wasted hot water.
These showers work much in the same way that a kettle does, quickly heating cold water which is then fed through a thermostatic valve - meaning the water is delivered at the desired temperature. One of the biggest advantages of electric showers, is that there is no hot or cold movement when someone else in the house flushes the toilet or uses the hot tap.
We only work with the very best suppliers in Electric Showers - so you can recieve a shower which is fit for purpose and provides an incredibly reliable performance.
Black Showers
Notice: Undefined index: product in /var/www/virtual/6bdv.ws/d71/htdocs/cache/smarty/compile/1f/54/af/1f54afb3e86dac52e1c47a36321b9382ac9c598b.file.footer.tpl.php on line 153Notice: Trying to get property of non-object in /var/www/virtual/6bdv.ws/d71/htdocs/cache/smarty/compile/1f/54/af/1f54afb3e86dac52e1c47a36321b9382ac9c598b.file.footer.tpl.php on line 153Notice: Trying to get property of non-object in /var/www/virtual/6bdv.ws/d71/htdocs/cache/smarty/compile/1f/54/af/1f54afb3e86dac52e1c47a36321b9382ac9c598b.file.footer.tpl.php on line 153
Kartell Nero Black Square Thermostatic Bar Shower Valve with Overhead Drencher and...
£ 213.44 Details
At Designer Bathroom Store, we know that beautiful designer bathrooms require equally beautiful, reliable and high performance bathroom equipment. The most important being showers, no matter how new and shiny your bathroom is - if your shower does not reflect the quality of your bathroom suite, the whole bathroom is let down.
That’s why we have handpicked a range of showers which have been extensively tested to provide excellent showering, combined with contemporary designs which complement all types of bathrooms. We supply these showers as both complete shower kits, and also electric showers - so there’s the perfect shower for every household.
If you have any questions about our range of Showers, please just get in touch and we will be more than happy to help.
Load Time 809 ms - OK... for a shared hosting Querying Time 328 ms Queries 369 Memory Peak Usage 19.8 Mb Included Files 215 files - 4.83 Mb PrestaShop Cache - Mb Global vars 0.72 Mb PrestaShop Version 1.6.1.6 PHP Version 5.6.40-29+ubuntu16.04.1+deb.sury.org+1 (OK) MySQL Version 10.0.21-MariaDB-log (OK) Memory Limit 150M Max Execution Time 30s Smarty Cache enabled Smarty Compilation never recompile Time Cumulated Time Memory Usage Memory Peak Usage config 51 ms 51 ms 5.87 Mb 5.96 Mb __construct 0 ms 51 ms - Mb 5.96 Mb init 12 ms 63 ms 1.26 Mb 7.23 Mb checkAccess 0 ms 63 ms - Mb 7.23 Mb setMedia 4 ms 67 ms 0.14 Mb 7.37 Mb postProcess 0 ms 67 ms - Mb 7.37 Mb initHeader 0 ms 67 ms - Mb 7.37 Mb initContent 521 ms 588 ms 9.39 Mb 16.80 Mb initFooter 25 ms 613 ms 0.69 Mb 17.52 Mb display 197 ms 809 ms 0.92 Mb 19.82 Mb Hook Time Memory Usage hookproductlistassign 176 ms 4.75 Mb hookHeader 27 ms 0.25 Mb __construct 22 ms 3.50 Mb hookdisplayTop 15 ms 0.50 Mb hookfooter 13 ms 0.25 Mb hookdisplayHeader 13 ms 0.25 Mb hookleftcolumn 13 ms - Mb hooktop 11 ms 0.25 Mb hookdisplayNav 1 ms - Mb hookdisplayFooter 1 ms - Mb hookdisplayLeftColumn 1 ms - Mb hookmoduleRoutes 0 ms - Mb hookdisplayTopColumn - ms - Mb 13 hooks 293 ms 9.75 Mb Module Time Memory Usage blocklayered 200 ms 5.00 Mb blocktopmenu 16 ms 0.75 Mb lgcookieslaw 12 ms 0.25 Mb smartblog 7 ms 0.75 Mb blockcart 7 ms 0.25 Mb statsdata 6 ms 0.25 Mb blockcms 6 ms 0.25 Mb blockcategories 5 ms 0.25 Mb blocksearch 5 ms - Mb themeconfigurator 4 ms 0.25 Mb blockmyaccountfooter 3 ms 0.25 Mb blockcontactinfos 3 ms - Mb blocktags 3 ms - Mb blockuserinfo 3 ms - Mb mancarousel 2 ms - Mb socialsharing 2 ms 0.25 Mb ganalytics 1 ms 0.50 Mb reviewscouk 1 ms 0.25 Mb googleshopping 1 ms 0.25 Mb sekeywords 1 ms - Mb blockbanner 1 ms - Mb blocksocial 1 ms - Mb blockmyaccount 1 ms - Mb mailalerts 1 ms - Mb productcomments 1 ms 0.25 Mb pagesnotfound 1 ms - Mb recaptcha 0 ms - Mb homeslider 0 ms - Mb sagepay 0 ms - Mb 29 modules 293 ms 9.75 Mb Stopwatch SQL - 369 queries
Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE p.*, product_shop.*, product_shop.id_category_default, pl.*, image_shop.`id_image` id_image, il.legend, m.name manufacturer_name, product_attribute_shop.id_product_attribute id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-12-04 00:00:00", INTERVAL 60 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity FROM ps_cat_filter_restriction cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` 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_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`order_priority` DESC,p.`order_weight` DESC,cp.position asc , cp.id_product LIMIT 0,2411.4 496 Yes /modules/blocklayered/blocklayered.php:2047 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|21298|1|1%"
10.8 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14820|1|1%"
10.8 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|21297|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|28235|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17360|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|27369|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|21322|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|28258|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|27529|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|21321|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|28341|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|30735|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|28256|1|1%"
10.7 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17361|1|1%"
10.7 1 /classes/SmartyCustom.php:295 CREATE TEMPORARY TABLE ps_cat_filter_restriction ENGINE=MEMORY SELECT cp.id_product, MIN(cp.position) position FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 1455 AND c.nright <= 1512 AND c.active = 1) JOIN `ps_product` p USING (id_product) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") GROUP BY cp.id_product ORDER BY p.`order_priority` DESC,p.`order_weight` DESC,position, id_product4.5 1 /modules/blocklayered/blocklayered.php:1941 CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 1455 AND c.nright <= 1512 AND c.active = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog")3.8 1 /modules/blocklayered/blocklayered.php:2135 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.4 610 /classes/Configuration.php:148 SELECT SQL_NO_CACHE 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`
2.2 80 Yes Yes /override/classes/Hook.php:129 SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
1.7 271 /classes/Hook.php:236 SELECT SQL_NO_CACHE fl.name feature_name, fp.id_feature, fv.id_feature_value, fvl.value, COUNT(DISTINCT p.id_product) nbr, lifl.url_name name_url_name, lifl.meta_title name_meta_title, lifvl.url_name value_url_name, lifvl.meta_title value_meta_title FROM ps_feature_product fp INNER JOIN ps_cat_restriction p ON p.id_product = fp.id_product LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = 0)) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = 1) LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = 1) WHERE fp.id_feature = 33 GROUP BY fv.id_feature_value
1.5 248 Yes /modules/blocklayered/blocklayered.php:2375 SELECT SQL_NO_CACHE `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
1.4 0 /classes/Hook.php:131 SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 7 AND `c`.`active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.3 8 Yes Yes /classes/Category.php:666 ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE
1.2 1 /modules/blocklayered/blocklayered.php:2141 SELECT SQL_NO_CACHE s.*, sl.`description` FROM `ps_supplier` s LEFT JOIN `ps_supplier_lang` `sl` ON s.`id_supplier` = sl.`id_supplier` AND sl.`id_lang` = 1 INNER JOIN ps_supplier_shop supplier_shop ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1) WHERE (s.`active` = 1) GROUP BY s.id_supplier ORDER BY s.`name` ASC
1.1 28 Yes Yes /classes/Supplier.php:127 SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (14820,17360,21294,21297,21321,21336,27369,28234,28238,28252,28254,28256,28258,28341,30735,17361,21295,21298,21322,21337,27529,28205,28235,28253) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
1 24 Yes Yes /classes/Product.php:3466 SELECT SQL_NO_CACHE p.`id_product`, psi.price_min, psi.price_max FROM ps_cat_restriction p INNER JOIN `ps_layered_price_index` psi ON (psi.id_product = p.id_product AND psi.id_currency = 1 AND psi.id_shop=1) WHERE 1
0.9 248 /modules/blocklayered/blocklayered.php:2375 SELECT SQL_NO_CACHE 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
0.9 81 /classes/module/Module.php:277 SELECT SQL_NO_CACHE 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
0.9 81 /classes/module/Module.php:277 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.8 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE c.nleft <= 1455 AND c.nright >= 1512 AND c.nleft >= 2 AND c.nright <= 1945 AND cl.id_lang = 1 AND c.active = 1 AND c.level_depth > 1 ORDER BY c.level_depth ASC
0.8 113 Yes /classes/Tools.php:1327 SELECT SQL_NO_CACHE name FROM `ps_feature_lang` fl LEFT JOIN `ps_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1
0.8 134 /modules/blocklayered/blocklayered.php:2724 SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 14820) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 17360 ORDER BY f.position ASC
0.7 14 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 28235) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21298) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 27529) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21295) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 27369) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
0.7 1 Yes /classes/shop/Shop.php:663 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21294 ORDER BY f.position ASC
0.7 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 28254) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 28341) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 28258) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 17360) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21297) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21336) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21322) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 21294) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 17361 ORDER BY f.position ASC
0.7 14 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE public_name FROM `ps_attribute_group_lang` agl LEFT JOIN `ps_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1
0.7 83 /modules/blocklayered/blocklayered.php:2714 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 21337) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 28253) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21297 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE * 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` = 28234) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE 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
0.6 41 Yes /classes/Dispatcher.php:452 SELECT SQL_NO_CACHE * 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` = 17361) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 28256) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * 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` = 28252) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 28238) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 21321) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 30735) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:361 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28234|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21294|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE *, ( 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_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) 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, `to` DESC, `from` DESC LIMIT 1
0.6 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21321 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 14820 ORDER BY f.position ASC
0.6 5 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE 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 = 'd71.6bdv.ws' OR su.domain_ssl = 'd71.6bdv.ws') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 1 Yes /classes/shop/Shop.php:334 ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.6 1 /modules/blocklayered/blocklayered.php:1953 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28253|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28253 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 27369 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21298 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE * 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` = 28205) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21295 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28234 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21336|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 27529 ORDER BY f.position ASC
0.6 11 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28205|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21322 ORDER BY f.position ASC
0.6 9 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28254|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28341 ORDER BY f.position ASC
0.6 6 Yes /classes/Product.php:4455 INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('12740708', '208', '585449244', '', '1', '1', '2023-12-04 22:43:35')0.6 1 /classes/ObjectModel.php:487 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21337 ORDER BY f.position ASC
0.6 5 Yes /classes/Product.php:4455 INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')0.6 1 /classes/ObjectModel.php:487 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28252 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21295|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28205 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 21336 ORDER BY f.position ASC
0.6 5 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 30735 ORDER BY f.position ASC
0.6 3 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28238|1|1","", FROM_UNIXTIME(1701729815))0.6 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28256 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28258 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28254 ORDER BY f.position ASC
0.6 4 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28252|1|1","", FROM_UNIXTIME(1701729815))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28238 ORDER BY f.position ASC
0.5 4 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 17 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC0.5 1 Yes /classes/tax/TaxRulesTaxManager.php:109 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 28235 ORDER BY f.position ASC
0.5 4 Yes /classes/Product.php:4455 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21337|1|1","", FROM_UNIXTIME(1701729815))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE * 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` = 76) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.5 86 /classes/Hook.php:187 SELECT SQL_NO_CACHE * 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` = 74) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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` = 75) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * 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
0.5 1 Yes /classes/Currency.php:231 SELECT SQL_NO_CACHE * 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` = 72) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 7 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
0.5 1 Yes /classes/Scene.php:226 SELECT SQL_NO_CACHE * FROM `ps_category_lang` WHERE `id_category` = 7 AND `id_shop` = 1
0.5 1 /Adapter/Adapter_EntityMapper.php:68 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28253)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 17361)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14820)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * 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
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21297)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'footer' AND active = 1 ORDER BY item_order ASC
0.5 3 Yes /modules/themeconfigurator/themeconfigurator.php:376 DROP TEMPORARY TABLE IF EXISTS ps_cat_filter_restriction
0.5 1 /modules/blocklayered/blocklayered.php:1927 SELECT SQL_NO_CACHE * 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` = 73) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21337)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21294)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28341)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28258)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 17360)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28252)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28238)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE 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
0.5 1 /classes/shop/Shop.php:203 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21298)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * 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` = 1327) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28234)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28256)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 27369)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28254)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 27529)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE 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
0.4 1 /classes/Language.php:894 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21295)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 30735)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28205)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC
0.4 3 Yes /modules/themeconfigurator/themeconfigurator.php:376 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21321)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21336)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * 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` = 78) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 21322)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE `id_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 7 LIMIT 1
0.4 1 /classes/Page.php:77 SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 7 AND cl.id_shop = 1 LIMIT 1
0.4 1 /classes/Meta.php:291 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `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_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 28235)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.4 1 /classes/Language.php:777 SELECT SQL_NO_CACHE 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 =1 AND m.page = "category" LIMIT 1
0.4 1 /classes/Theme.php:275 SELECT SQL_NO_CACHE 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
0.4 1 /classes/Currency.php:472 SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = 12740708 AND `date_add` > '2023-12-04 22:13:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1
0.4 1 Yes /classes/Connection.php:138 SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 7 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
0.4 2 Yes Yes /modules/blocklayered/blocklayered.php:2121 SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.4 8 /classes/SpecificPrice.php:230 SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 17 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC0.4 0 /classes/tax/TaxRulesTaxManager.php:109 SELECT SQL_NO_CACHE * 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
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found FROM `ps_lang` WHERE LEFT(`language_code`,2) = 'en' ORDER BY found ASC LIMIT 1
0.4 1 Yes /classes/Language.php:719 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.4 1 /classes/shop/Shop.php:1067 SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 7) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='e87f73d0b061b626a2658ae68d69b740' AND cache_id="blockcontactinfos|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|27529|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28256|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21322|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21298|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9809e53dfa527993d6871c23a4fc7d29' AND cache_id="blocktopmenu|1|1|1|17|category|7" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|27369|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28235|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21294) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='fb458c083c5e11bd8cdd5fdecc29e5f1' AND cache_id="blockcategories|1|1|1|17|7|7|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28253|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|0|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28234|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28252|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28205|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.4 1 /modules/blocklayered/blocklayered.php:2125 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21336|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE COUNT(*) FROM ps_layered_category WHERE id_category = 7 AND id_shop = 1 LIMIT 1
0.3 2 /modules/blocklayered/blocklayered.php:636 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21336 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='42dab2f39a24d3b63c3f2f0acaa84291' AND cache_id="blocksearch-top|1|1|1|17" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.3 9 /classes/ImageType.php:143 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28258|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21295|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28238|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1f5b43b6f0927d8e4f0470a3ffdd60fc' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1
0.3 1 /classes/module/Module.php:2568 SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='979764b58eb6a1c504b39475e4620126' AND cache_id="blockmyaccountfooter|1|1|1|17" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28254|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1f5b43b6f0927d8e4f0470a3ffdd60fc' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
0.3 5 /classes/module/Module.php:2141 SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.3 6 /classes/SpecificPrice.php:238 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21294|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `id_country` FROM `ps_country` WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.3 1 /classes/Country.php:174 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28234 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21321|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 3 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='ab40ee109db6cb4a4df4abe15a379e09' AND cache_id="blocktags|1|1|1|17" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|2|1|1|1|17" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
0.3 1 /classes/shop/ShopUrl.php:169 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17361|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 7 LIMIT 1
0.3 1 /classes/Category.php:1485 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|28341|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14820|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|30735|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1459 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17361) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28238 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21297 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28234) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17360|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21337|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.3 1 /classes/SmartyCustom.php:142 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21298) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21322) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 954 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17361 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21294|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14820) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28341) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21297|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.3 1 /classes/SmartyCustom.php:95 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14820 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21295 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1459 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21295|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE id_required_field, object_name, field_name FROM ps_required_field
0.3 1 /classes/ObjectModel.php:1376 SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 27529 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21298 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28252 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28252) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21321 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 7 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1317 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28252|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17360) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21337 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28238|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21321) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21298 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17361 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27529) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21337) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21294 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28205 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 2 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28238) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28238 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21337 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17360 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21297 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28234 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28341 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28253|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28205) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28256) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17360 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21322 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28252 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14820 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28254 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28258 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28256 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28254 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1
0.3 1 /classes/Page.php:97 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 30735 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 27369 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28253) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 73 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21336 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21295 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21294 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14820 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2023-12-04 00:00:00' AND '2023-12-04 23:59:59' LIMIT 1
0.3 6 /classes/SpecificPrice.php:301 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28253 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21337 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28258 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28258) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1459 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28254) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 30735 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21295) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28205 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1
0.3 1 /classes/Category.php:1485 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 30735) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 28235) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1f5b43b6f0927d8e4f0470a3ffdd60fc' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27369) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21321 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27529 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27369 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28256 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21298 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21297 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21297) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21336) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
0.3 1 /classes/Image.php:470 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28205|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28341 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21322 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 28235 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28341 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1f5b43b6f0927d8e4f0470a3ffdd60fc' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1
0.3 1 /classes/Image.php:470 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21337|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21336 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 75 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 83 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2218 SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-12-04 00:00:00' AND '2023-12-04 23:59:59' LIMIT 1
0.3 6 /classes/SpecificPrice.php:305 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28253 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28256 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28253 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28254 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21336|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28235 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 28235 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28254|1|1","", FROM_UNIXTIME(1701729815))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
0.3 22 /modules/blocklayered/blocklayered.php:738 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21321 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28238 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 27369 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28258 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21295 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|28234|1|1","", FROM_UNIXTIME(1701729815))0.2 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28205 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21322 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE COUNT(*) FROM ps_cat_filter_restriction LIMIT 1
0.2 0 /modules/blocklayered/blocklayered.php:2002 SELECT SQL_NO_CACHE id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
0.2 40 /modules/blocklayered/blocklayered.php:740 SELECT SQL_NO_CACHE id_shop FROM `ps_category_shop` WHERE `id_category` = 7 AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1459 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 27529 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 30735 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21294 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17361 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28252 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw;
0.2 1 /override/classes/Hook.php:61 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 28234 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17360 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/Group.php:133 Doubles
24 SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
24 SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
24 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
24 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
24 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
24 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
24 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
24 SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX
24 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
20 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES (XX,"productlist_colors|XX|XX|XX","", FROM_UNIXTIME(XX))
14 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%"
8 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
5 SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
4 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX
4 SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX
2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
2 SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 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` = XX LIMIT XX ) as mshop FROM `ps_module` m
2 SELECT content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX
2 SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX
Tables stress
75 product_shop 51 product 46 smarty_lazy_cache 28 specific_price 26 product_attribute_shop 26 feature_lang 25 feature_product 25 stock_available 25 product_lang 25 feature_value_lang 24 product_group_reduction_cache 24 feature 24 feature_shop 24 specific_price_priority 17 category_lang 15 category 12 category_shop 6 lgcookieslaw_lang 5 image_type 5 module 5 module_shop 4 lang 4 shop 4 lang_shop 4 shop_url 4 layered_friendly_url 4 hook 4 currency_shop 3 theme 3 currency 2 layered_category 2 category_product 2 layered_indexable_feature 2 cat_restriction 2 smarty_last_flush 2 group_shop 2 hook_alias 2 meta 2 shop_group 2 hook_module 2 country 2 cat_filter_restriction 2 group 2 configuration 2 tax_rule 2 category_group 2 themeconfigurator 2 layered_indexable_attribute_group 2 tax_rules_group 1 product_attribute 1 supplier_shop 1 supplier_lang 1 required_field 1 connections 1 page 1 page_type 1 supplier 1 attribute_group 1 manufacturer 1 tax_lang 1 product_attribute_combination 1 attribute 1 attribute_lang 1 tax 1 layered_indexable_feature_lang_value 1 group_lang 1 scene_category 1 scene 1 scene_shop 1 theme_meta 1 meta_lang 1 country_lang 1 country_shop 1 lgcookieslaw 1 module_group 1 scene_lang 1 hook_module_exceptions 1 cms 1 cms_lang 1 cms_shop 1 image_shop 1 attribute_group_lang 1 layered_indexable_feature_value_lang_value 1 configuration_lang 1 layered_price_index 1 feature_value 1 image_lang ObjectModel instances
Name Instances Source Product 24 /classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
/classes/Link.php [104]
Category 21 /controllers/front/CategoryController.php [105]
/classes/Link.php [177]
/modules/blocklayered/blocklayered.php [2113]
/modules/blocklayered/blocklayered.php [695]
/modules/blockcategories/blockcategories.php [193]
/modules/blocklayered/blocklayered.php [1799]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
Language 3 /config/config.inc.php [195]
/classes/Tools.php [524]
/classes/Tools.php [541]
CMS 2 /classes/Link.php [265]
/classes/Link.php [265]
Address 2 /classes/Product.php [2937]
/classes/Product.php [4405]
Currency 2 /classes/Tools.php [639]
/modules/ganalytics/ganalytics.php [471]
Country 2 /config/config.inc.php [142]
/classes/controller/FrontController.php [279]
Theme 1 /config/config.inc.php [115]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]
Guest 1 /modules/statsdata/statsdata.php [104]
Connection 1 /modules/statsdata/statsdata.php [142]
ShopGroup 1 /classes/shop/Shop.php [518]
Shop 1 /config/config.inc.php [114]
Cart 1 /classes/controller/FrontController.php [348]
Group 1 /classes/Cart.php [184]
Customer 1 /config/config.inc.php [217]
Included Files
# Filename 1 /index.php 2 /config/config.inc.php 3 /config/defines.inc.php 4 /config/settings.inc.php 5 /config/autoload.php 6 /config/alias.php 7 /classes/PrestaShopAutoload.php 8 /cache/class_index.php 9 /config/bootstrap.php 10 /Core/Business/Core_Business_ContainerBuilder.php 11 /Core/Foundation/IoC/Core_Foundation_IoC_Container.php 12 /Adapter/Adapter_ServiceLocator.php 13 /classes/controller/Controller.php 14 /classes/ObjectModel.php 15 /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php 16 /classes/db/Db.php 17 /classes/Tools.php 18 /classes/Context.php 19 /classes/shop/Shop.php 20 /classes/db/DbPDO.php 21 /classes/Configuration.php 22 /override/classes/Configuration.php 23 /classes/Validate.php 24 /classes/cache/Cache.php 25 /Adapter/Adapter_EntityMapper.php 26 /classes/db/DbQuery.php 27 /classes/Theme.php 28 /config/defines_uri.inc.php 29 /tools/htmlpurifier/HTMLPurifier.standalone.php 30 /classes/Language.php 31 /classes/Country.php 32 /classes/PrestaShopCollection.php 33 /classes/shop/ShopGroup.php 34 /classes/Cookie.php 35 /classes/Rijndael.php 36 /classes/Customer.php 37 /classes/Group.php 38 /classes/Link.php 39 /classes/shop/ShopUrl.php 40 /config/smarty.config.inc.php 41 /tools/smarty/Smarty.class.php 42 /tools/smarty/sysplugins/smarty_internal_data.php 43 /tools/smarty/sysplugins/smarty_internal_templatebase.php 44 /tools/smarty/sysplugins/smarty_internal_template.php 45 /tools/smarty/sysplugins/smarty_resource.php 46 /tools/smarty/sysplugins/smarty_internal_resource_file.php 47 /tools/smarty/sysplugins/smarty_cacheresource.php 48 /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php 49 /classes/SmartyCustom.php 50 /config/smartyfront.config.inc.php 51 /classes/Dispatcher.php 52 /classes/Hook.php 53 /override/classes/Hook.php 54 /classes/module/Module.php 55 /tools/mobile_Detect/Mobile_Detect.php 56 /config/db_slave_server.inc.php 57 /modules/smartblog/smartblog.php 58 /modules/smartblog/classes/SmartBlogLink.php 59 /modules/smartblog/classes/BlogCategory.php 60 /modules/smartblog/classes/Blogcomment.php 61 /modules/smartblog/classes/BlogPostCategory.php 62 /modules/smartblog/classes/BlogTag.php 63 /modules/smartblog/classes/SmartBlogPost.php 64 /modules/smartblog/classes/SmartBlogPostMeta.php 65 /modules/smartblog/classes/BlogImageType.php 66 /modules/smartblog/classes/SmartBlogGallaryImage.php 67 /modules/smartblog/controllers/admin/AdminAboutUsController.php 68 /classes/controller/ModuleAdminController.php 69 /classes/controller/AdminController.php 70 /classes/Translate.php 71 /controllers/front/CategoryController.php 72 /classes/controller/FrontController.php 73 /classes/Category.php 74 /themes/default-bootstrap/lang/en.php 75 /classes/Currency.php 76 /classes/Cart.php 77 /classes/CartRule.php 78 /classes/Meta.php 79 /classes/Product.php 80 /override/classes/Product.php 81 /classes/webservice/WebserviceRequest.php 82 /classes/Media.php 83 /classes/Scene.php 84 /modules/socialsharing/socialsharing.php 85 /modules/socialsharing/translations/en.php 86 /modules/blockbanner/blockbanner.php 87 /modules/blockbanner/translations/en.php 88 /modules/blockcart/blockcart.php 89 /modules/blockcart/translations/en.php 90 /modules/blocksocial/blocksocial.php 91 /modules/blocksocial/translations/en.php 92 /modules/blockcategories/blockcategories.php 93 /modules/blockcategories/translations/en.php 94 /modules/blocklayered/blocklayered.php 95 /modules/blocklayered/translations/en.php 96 /modules/blockcms/blockcms.php 97 /modules/blockcms/BlockCMSModel.php 98 /themes/default-bootstrap/modules/blockcms/translations/en.php 99 /modules/blockcms/translations/en.php 100 /modules/blockmyaccount/blockmyaccount.php 101 /modules/blockmyaccount/translations/en.php 102 /modules/blocksearch/blocksearch.php 103 /modules/blocksearch/translations/en.php 104 /modules/blocktopmenu/blocktopmenu.php 105 /modules/blocktopmenu/menutoplinks.class.php 106 /override/modules/blocktopmenu/blocktopmenu.php 107 /modules/blocktopmenu/translations/en.php 108 /modules/blockuserinfo/blockuserinfo.php 109 /modules/blockuserinfo/translations/en.php 110 /modules/themeconfigurator/themeconfigurator.php 111 /modules/themeconfigurator/translations/en.php 112 /cache/smarty/compile/69/ad/24/69ad2414b15c9f0b27f477187a27f4854457badf.file.hook.tpl.php 113 /tools/smarty/sysplugins/smarty_internal_filter_handler.php 114 /modules/homeslider/homeslider.php 115 /modules/homeslider/HomeSlide.php 116 /modules/homeslider/translations/en.php 117 /modules/productcomments/productcomments.php 118 /modules/productcomments/translations/en.php 119 /cache/smarty/compile/b1/d3/72/b1d3720bf762113053677ac286ad47e1379bf2cc.file.blogfeedheader.tpl.php 120 /tools/minify_html/minify_html.class.php 121 /modules/mancarousel/mancarousel.php 122 /modules/googleshopping/googleshopping.php 123 /modules/googleshopping/lib/phpseclib/Crypt/RSA.php 124 /modules/googleshopping/lib/phpseclib/Crypt/Random.php 125 /modules/googleshopping/lib/phpseclib/Crypt/Hash.php 126 /modules/googleshopping/lib/phpseclib/Math/BigInteger.php 127 /modules/googleshopping/translations/en.php 128 /modules/mailalerts/mailalerts.php 129 /modules/mailalerts/MailAlert.php 130 /modules/mailalerts/translations/en.php 131 /modules/ganalytics/ganalytics.php 132 /modules/ganalytics/translations/en.php 133 /modules/lgcookieslaw/lgcookieslaw.php 134 /modules/lgcookieslaw/translations/en.php 135 /classes/CMS.php 136 /cache/smarty/compile/33/2d/49/332d49acbb946753e4631d68dd72331c8d69adaa.file.cookieslaw_header_1_6.tpl.php 137 /cache/smarty/compile/a4/3a/55/a43a553d834d3b40eab6aebf7b951d139602ac9c.file.cookieslaw_header_code.tpl.php 138 /tools/js_minify/jsmin.php 139 /modules/recaptcha/recaptcha.php 140 /modules/sagepay/sagepay.php 141 /classes/PaymentModule.php 142 /Adapter/Adapter_AddressFactory.php 143 /Adapter/Adapter_ProductPriceCalculator.php 144 /Adapter/Adapter_Configuration.php 145 /Core/Business/Core_Business_ConfigurationInterface.php 146 /classes/Customization.php 147 /cache/smarty/compile/74/aa/96/74aa96b01d9e83448f95291df4d6df2e0f1f6dba.file.blockcart.tpl.php 148 /tools/smarty/plugins/modifier.replace.php 149 /tools/smarty/plugins/function.counter.php 150 /cache/smarty/cache/blocksearch_top/1/1/1/17/1e/5f/75/1e5f75c4aa0fa6705f6b6e0097d34f6ab6639eba.blocksearch-top.tpl.php 151 /cache/smarty/compile/7b/ae/05/7bae05b4a5e4c8af494114949671ebd77bc94676.file.blockuserinfo.tpl.php 152 /cache/smarty/cache/blocktopmenu/1/1/1/17/category/7/79/65/67/796567d1b5622d4feeb0ac2a2769b96a1106ffa1.blocktopmenu.tpl.php 153 /modules/pagesnotfound/pagesnotfound.php 154 /modules/pagesnotfound/translations/en.php 155 /modules/sekeywords/sekeywords.php 156 /classes/module/ModuleGraph.php 157 /modules/sekeywords/translations/en.php 158 /cache/smarty/compile/c5/3f/0c/c53f0c03d14f30892dd2502fe32d7965fbd84591.file.cookieslaw.tpl.php 159 /cache/smarty/cache/blockcategories/1/1/1/17/7/7/1/6e/c5/4a/6ec54a1aafdc723fe7c3a8a463665f36b096546f.blockcategories.tpl.php 160 /cache/smarty/compile/d9/4a/96/d94a969cdb9f391b0f77a1da55ad7469c9189163.file.blocklayered.tpl.php 161 /cache/smarty/cache/blockcms/0/1/1/1/17/c6/6c/99/c66c998d736e201796f14bbef99ada4df0200511.blockcms.tpl.php 162 /modules/blocktags/blocktags.php 163 /modules/blocktags/translations/en.php 164 /cache/smarty/cache/blocktags/1/1/1/17/0c/e1/c1/0ce1c1faf3d35f70b8c8c7cbf3c39a02cf1fa583.blocktags.tpl.php 165 /classes/ImageType.php 166 /classes/Combination.php 167 /classes/stock/StockAvailable.php 168 /classes/tax/Tax.php 169 /classes/Address.php 170 /classes/SpecificPrice.php 171 /classes/tax/TaxManagerFactory.php 172 /classes/tax/TaxRulesTaxManager.php 173 /classes/tax/TaxManagerInterface.php 174 /classes/tax/TaxCalculator.php 175 /classes/GroupReduction.php 176 /classes/Feature.php 177 /classes/Image.php 178 /classes/Supplier.php 179 /cache/smarty/cache/blockcms/2/1/1/1/17/c6/6c/99/c66c998d736e201796f14bbef99ada4df0200511.blockcms.tpl.php 180 /modules/blockmyaccountfooter/blockmyaccountfooter.php 181 /modules/blockmyaccountfooter/translations/en.php 182 /cache/smarty/cache/blockmyaccountfooter/1/1/1/17/29/ed/72/29ed723face6c737b0cfa2af388ced1349d928a2.blockmyaccountfooter.tpl.php 183 /modules/blockcontactinfos/blockcontactinfos.php 184 /modules/blockcontactinfos/translations/en.php 185 /cache/smarty/cache/blockcontactinfos/1/1/1/17/c1/27/fa/c127fa81e39fb5e2151d02420747ab0033425aa7.blockcontactinfos.tpl.php 186 /modules/statsdata/statsdata.php 187 /modules/statsdata/translations/en.php 188 /classes/Guest.php 189 /classes/Connection.php 190 /classes/Page.php 191 /classes/ConnectionsSource.php 192 /modules/reviewscouk/reviewscouk.php 193 /cache/smarty/compile/2f/fc/81/2ffc8183fe7b669a9ea9f7af395bb273ae624d33.file.category.tpl.php 194 /cache/smarty/compile/14/61/b5/1461b5063f03678d21b98c78c2078d39adeaecdb.file.errors.tpl.php 195 /cache/smarty/compile/23/68/5f/23685f22e7f1d2924ecd21423f2d03e2e51a8ba1.file.category-count.tpl.php 196 /cache/smarty/compile/0d/44/ec/0d44ecf4aeb788b97ced443d929cdc03ec75feff.file.product-sort.tpl.php 197 /cache/smarty/compile/a0/66/96/a066963f9dfd316c7bb8aea07bd6a224be964cd8.file.nbr-product-page.tpl.php 198 /cache/smarty/compile/55/da/6a/55da6adc645709ca02b6e53a849ddfd3a24a9b88.file.product-compare.tpl.php 199 /cache/smarty/compile/d3/ac/99/d3ac99ed9d700d54cb8c2c628566f63abffc7998.file.pagination.tpl.php 200 /cache/smarty/compile/52/21/4b/52214b4777edda08c81563ffba0138c736a5e06d.file.product-list.tpl.php 201 /tools/smarty/plugins/function.math.php 202 /cache/smarty/compile/e7/d5/20/e7d52066f73e7caa908990fd5e40b7f338f78509.file.layout.tpl.php 203 /cache/smarty/compile/5d/2a/d1/5d2ad148d64a076c1b36e269ad6503c0914553a2.file.header.tpl.php 204 /tools/smarty/plugins/function.implode.php 205 /cache/smarty/compile/c4/80/04/c48004a8ba41925135ae49d545752e7b1af286bf.file.nav.tpl.php 206 /cache/smarty/compile/08/69/28/086928842b0ed75c9b6bd53c6687fddc21bd901b.file.breadcrumb.tpl.php 207 /tools/smarty/plugins/modifier.regex_replace.php 208 /cache/smarty/compile/1f/54/af/1f54afb3e86dac52e1c47a36321b9382ac9c598b.file.footer.tpl.php 209 /cache/smarty/compile/4a/87/8d/4a878d3fe8b784005d62baa84f0151ba0313c8a9.file.global.tpl.php 210 /cache/smarty/compile/7b/05/01/7b0501b5bd8805d050202ee5e0775e0eb31f07be.file.javascript.tpl.php 211 /tools/smarty/plugins/shared.mb_str_replace.php