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
Bath Panels
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
Whilst some of the Baths we supply do not need bath panels, many do. Don’t think that’s a bad thing either – bath panels allow you to customise and style your bath around your exact preferences, and the range we offer, which have all been handpicked from the leading bathroom suppliers allow you to create a bath which complements your bathroom interior.
There’s everything from wood, stone effect and plastic bath panels for both the sides and ends of your bath, so you can spend as little or as much as you like. Many of our customers just seeking simple functionality choose a plastic bath panel, whilst others choose a painted wooden bath panel for an added touch of luxury.
If you have any questions about the right bath panels for your bath, please do just get in touch and we will be more than happy to help you find the perfect panel.
Load Time 847 ms - OK... for a shared hosting Querying Time 392 ms Queries 357 Memory Peak Usage 19.5 Mb Included Files 215 files - 4.82 Mb PrestaShop Cache - Mb Global vars 0.71 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 50 ms 50 ms 5.87 Mb 5.96 Mb __construct 0 ms 50 ms - Mb 5.96 Mb init 11 ms 62 ms 1.26 Mb 7.23 Mb checkAccess 0 ms 62 ms - Mb 7.23 Mb setMedia 4 ms 66 ms 0.14 Mb 7.37 Mb postProcess 0 ms 66 ms - Mb 7.37 Mb initHeader 0 ms 66 ms - Mb 7.37 Mb initContent 580 ms 646 ms 9.32 Mb 16.75 Mb initFooter 25 ms 671 ms 0.69 Mb 17.44 Mb display 175 ms 847 ms 0.77 Mb 19.47 Mb Hook Time Memory Usage hookproductlistassign 160 ms 4.75 Mb hookHeader 26 ms 0.25 Mb __construct 22 ms 2.75 Mb hookleftcolumn 16 ms - Mb hookfooter 13 ms 0.25 Mb hookdisplayHeader 13 ms 0.50 Mb hooktop 11 ms 0.25 Mb hookdisplayTop 10 ms 0.50 Mb hookdisplayNav 1 ms - Mb hookdisplayFooter 1 ms - Mb hookdisplayLeftColumn 1 ms - Mb hookdisplayTopColumn 0 ms - Mb hookmoduleRoutes - ms - Mb 13 hooks 274 ms 9.25 Mb Module Time Memory Usage blocklayered 184 ms 5.00 Mb blocktopmenu 12 ms 0.75 Mb lgcookieslaw 11 ms 0.50 Mb smartblog 7 ms 0.75 Mb blockcart 7 ms 0.25 Mb blockcategories 7 ms 0.25 Mb blockcms 6 ms 0.25 Mb statsdata 6 ms 0.25 Mb blocksearch 5 ms - Mb themeconfigurator 4 ms 0.25 Mb blockmyaccountfooter 3 ms 0.25 Mb blocktags 3 ms - Mb blockcontactinfos 3 ms - Mb blockuserinfo 3 ms - Mb mancarousel 2 ms - Mb socialsharing 2 ms 0.25 Mb ganalytics 1 ms - Mb reviewscouk 1 ms - Mb productcomments 1 ms 0.25 Mb googleshopping 1 ms 0.25 Mb blockmyaccount 1 ms - Mb blockbanner 1 ms - Mb mailalerts 1 ms - Mb sekeywords 1 ms - Mb blocksocial 1 ms - Mb pagesnotfound 1 ms - Mb homeslider 0 ms - Mb recaptcha 0 ms - Mb sagepay 0 ms - Mb 29 modules 274 ms 9.25 Mb Stopwatch SQL - 357 queries
Query Time (ms) Rows Filesort Group By Location DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|21272|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|21280|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|21502|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|22891|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|21273|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|21274|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|21275|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|22892|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|21500|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|21499|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|27793|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|21501|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|21509|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|27792|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|21507|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|21503|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|21279|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|27794|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|22889|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|22888|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|21506|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|22890|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|21508|1|1%"
10.6 1 /classes/SmartyCustom.php:295 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,244.4 114 Yes /modules/blocklayered/blocklayered.php:2047 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.6 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.8 271 /classes/Hook.php:236 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 >= 1534 AND c.nright <= 1535 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")1.6 1 /modules/blocklayered/blocklayered.php:2135 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 >= 1534 AND c.nright <= 1535 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_product1.5 1 /modules/blocklayered/blocklayered.php:1941 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.2 0 /classes/Hook.php:131 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 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 57 Yes /modules/blocklayered/blocklayered.php:2375 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` = 85 AND `c`.`active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
1 1 Yes Yes /classes/Category.php:666 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 (21271,21272,21273,21274,21275,21279,21280,21499,21500,21501,21502,21503,21506,21507,21508,21509,22888,22889,22890,22891,22892,27792,27793,27794) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
0.9 24 Yes Yes /classes/Product.php:3466 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 = 26 GROUP BY fv.id_feature_value
0.9 57 Yes /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.8 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.8 81 /classes/module/Module.php:277 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 <= 1534 AND c.nright >= 1535 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 106 Yes /classes/Tools.php:1327 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 = 57 GROUP BY fv.id_feature_value
0.8 57 Yes /modules/blocklayered/blocklayered.php:2375 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 = 21271 ORDER BY f.position ASC
0.7 12 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 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 = 21509 ORDER BY f.position ASC
0.7 12 Yes /classes/Product.php:4455 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 *, ( 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 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.7 134 /modules/blocklayered/blocklayered.php:2724 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 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
0.7 1 /modules/blocklayered/blocklayered.php:2141 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` = 22888) 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 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 = 21272 ORDER BY f.position ASC
0.7 12 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 * 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` = 21272) 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 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 = 21508 ORDER BY f.position ASC
0.6 12 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` = 21273) 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` = 21508) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 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.6 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 = 21274 ORDER BY f.position ASC
0.6 12 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 = 22888 ORDER BY f.position ASC
0.6 11 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` = 21502) 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 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.6 83 /modules/blocklayered/blocklayered.php:2714 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` = 21271) 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 *, ( 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` = 21275) 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 *, ( 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` = 22890) 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 *, ( 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` = 22889) 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` = 21509) 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` = 22892) 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 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 = 21280 ORDER BY f.position ASC
0.6 12 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` = 21499) 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 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 = 22889 ORDER BY f.position ASC
0.6 12 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 = 21279 ORDER BY f.position ASC
0.6 12 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.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` = 21506) 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` = 21280) 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 = 21501 ORDER BY f.position ASC
0.6 5 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` = 21501) 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` = 27792) 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 = 21275 ORDER BY f.position ASC
0.6 12 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 = 22890 ORDER BY f.position ASC
0.6 12 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 = 21273 ORDER BY f.position ASC
0.6 12 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` = 21500) 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` = 21503) 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` = 21274) 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 = 22892 ORDER BY f.position ASC
0.6 12 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 = 22891 ORDER BY f.position ASC
0.6 12 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` = 27793) 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` = 22891) 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` = 21507) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 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.6 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 = 21507 ORDER BY f.position ASC
0.6 5 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` = 27794) 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 = 27793 ORDER BY f.position ASC
0.6 7 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` = 21279) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 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 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 = 27792 ORDER BY f.position ASC
0.6 7 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 = 21500 ORDER BY f.position ASC
0.5 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 = 21506 ORDER BY f.position ASC
0.5 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 = 27794 ORDER BY f.position ASC
0.5 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 = 21502 ORDER BY f.position ASC
0.5 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 = 21503 ORDER BY f.position ASC
0.5 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.5 1 /classes/ObjectModel.php:487 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|21271|1|1","", FROM_UNIXTIME(1701730012))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` = 85) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 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.5 57 /modules/blocklayered/blocklayered.php:2375 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` = 22888)
0.5 1 /classes/Product.php:2998 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 = 21499 ORDER BY f.position ASC
0.5 5 Yes /classes/Product.php:4455 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` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('12740713', '224', '585449244', '', '1', '1', '2023-12-04 22:46:52')0.5 1 /classes/ObjectModel.php:487 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` = 21271)
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` = 21273)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.5 86 /classes/Hook.php:187 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` = 22889)
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` = 21274)
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` = 21507)
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` = 21280)
0.4 1 /classes/Product.php:2998 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 = 85 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
0.4 1 Yes /classes/Scene.php:226 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` = 22891)
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` = 21502)
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` = 21272)
0.4 1 /classes/Product.php:2998 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.4 1 Yes /classes/Currency.php:231 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` = 21508)
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` = 21500)
0.4 1 /classes/Product.php:2998 DROP TEMPORARY TABLE IF EXISTS ps_cat_filter_restriction
0.4 1 /modules/blocklayered/blocklayered.php:1927 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` = 21509)
0.4 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.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` = 22890)
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` = 21275)
0.4 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.4 1 /classes/shop/Shop.php:203 SELECT SQL_NO_CACHE * FROM `ps_category_lang` WHERE `id_category` = 85 AND `id_shop` = 1
0.4 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` = 21506)
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` = 27792)
0.4 1 /classes/Product.php:2998 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 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` = 21503)
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 ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.4 1 /modules/blocklayered/blocklayered.php:1953 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.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 85 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
0.4 4 Yes Yes /modules/blocklayered/blocklayered.php:2121 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` = 21279)
0.4 1 /classes/Product.php:2998 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 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` = 21501)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21509) 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 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` = 21499)
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` = 27794)
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` = 22892)
0.4 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21271) 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 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21271 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5034 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 `id_guest` FROM `ps_connections` WHERE `id_guest` = 12740713 AND `date_add` > '2023-12-04 22:16: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 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` = 27793)
0.4 1 /classes/Product.php:2998 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 DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.4 1 /modules/blocklayered/blocklayered.php:2125 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 * 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` = 85) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21273 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1
0.4 1 /classes/shop/ShopUrl.php:169 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 l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 1 /classes/Language.php:777 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` = 85 AND cl.id_shop = 1 LIMIT 1
0.3 1 /classes/Meta.php:291 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1067 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.3 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21501) 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` a WHERE (a.`id_tax` = 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`='e87f73d0b061b626a2658ae68d69b740' AND cache_id="blockcontactinfos|1|1|1|17" AND compile_id="" LIMIT 1
0.3 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.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`='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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 22888 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`='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|27794|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|21501|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|21508|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 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`='fb458c083c5e11bd8cdd5fdecc29e5f1' AND cache_id="blockcategories|1|1|1|17|85|85|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|22891|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`='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 `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.3 1 Yes /classes/Language.php:719 SELECT SQL_NO_CACHE COUNT(*) FROM ps_layered_category WHERE id_category = 85 AND id_shop = 1 LIMIT 1
0.3 4 /modules/blocklayered/blocklayered.php:636 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|85" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21274 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.3 9 /classes/ImageType.php:143 SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 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`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|22890|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 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 `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1
0.3 1 /classes/Image.php:470 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.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`='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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21271|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 85 LIMIT 1
0.3 1 /classes/Category.php:1062 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 22890 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 85 LIMIT 1
0.3 1 /classes/Category.php:1485 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21272 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21275|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27793) 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_theme` a WHERE (a.`id_theme` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21507 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '660940ce621852a403267bf7285f49a3' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21279) 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 = 22888) 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|21506|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 22889 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|21280|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21507) 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|21273|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '660940ce621852a403267bf7285f49a3' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 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|21274|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|21509|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|21499|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|21503|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21502 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '660940ce621852a403267bf7285f49a3' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '660940ce621852a403267bf7285f49a3' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68 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|21500|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|27792|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21500) 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` = 22892 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|22889|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|22892|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|21507|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|21279|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|27793|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21273) 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|22888|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 27792 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` = 27794 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 85 AND ctg.`id_group` = 1 LIMIT 1
0.3 1 /classes/Category.php:1317 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21502) 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` = 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`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|21502|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_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 85 LIMIT 1
0.3 2 /classes/Page.php:77 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21275 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 = 21506) 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` = 'bf4804e583f93b924cec5fa71f023027' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 22892) 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_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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21280 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bf4804e583f93b924cec5fa71f023027' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 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|21272|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21271 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` = 22888 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` = 21506 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21272) 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` = 21500 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` = 21279 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` = 21509 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 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 id_required_field, object_name, field_name FROM ps_required_field
0.3 1 /classes/ObjectModel.php:1376 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 content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 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 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 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` = 21499 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1
0.3 1 /Adapter/Adapter_EntityMapper.php:68 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21508 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bf4804e583f93b924cec5fa71f023027' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bf4804e583f93b924cec5fa71f023027' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 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 id_shop FROM `ps_category_shop` WHERE `id_category` = 85 AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1459 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 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21501 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 27793 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
0.3 40 /modules/blocklayered/blocklayered.php:740 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 22891 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 22891) 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` = 21502 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|21271|1|1","", FROM_UNIXTIME(1701730012))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21280) 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 = 21275) 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` = 21272 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 = 22889) 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` = 22891 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 = 21274) 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 button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21508) 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` = 21273 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` = 21508 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 = 22890) 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` = 22889 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` = 21509 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 = 27792) 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` = 21274 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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 button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21503) 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` = 21271 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 = 27794) 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` = 21279 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21503 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21280 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1
0.2 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21501 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1
0.2 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21500 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 21499) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 22888 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21275 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21501 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21503 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21506 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27793 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 21507 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27792 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 22892 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 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` = 22889 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 22890 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1
0.2 1 /classes/Group.php:133 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 21499 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21503 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27794 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21272 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` = 22892 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 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.2 6 /classes/SpecificPrice.php:305 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 21273 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` = 21279 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` = 21509 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` = 21508 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` = 21500 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` = 27794 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` = 21275 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` = 27793 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` = 21506 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` = 21502 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` = 21274 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` = 21507 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` = 21280 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` = 27792 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` = 22890 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` = 22891 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` = 21499 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 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 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 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 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
23 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%"
8 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
3 SELECT 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 = XX) INNER JOIN ps_feature_value fv ON (fv.id_feature_value = fp.id_feature_value AND (fv.custom IS NULL OR fv.custom = XX)) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_layered_indexable_feature_lang_value lifl ON (lifl.id_feature = fp.id_feature AND lifl.id_lang = XX) LEFT JOIN ps_layered_indexable_feature_value_lang_value lifvl ON (lifvl.id_feature_value = fp.id_feature_value AND lifvl.id_lang = XX) WHERE fp.id_feature = XX GROUP BY fv.id_feature_value
2 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
2 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
2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
2 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))
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 55 smarty_lazy_cache 51 product 28 specific_price 28 feature_lang 27 feature_product 27 feature_value_lang 26 product_attribute_shop 25 product_lang 25 stock_available 24 specific_price_priority 24 product_group_reduction_cache 24 feature 24 feature_shop 9 category 8 category_lang 8 layered_friendly_url 6 category_shop 6 lgcookieslaw_lang 5 image_type 5 module 5 module_shop 4 shop_url 4 lang 4 cat_restriction 4 lang_shop 4 currency_shop 4 shop 4 hook 3 feature_value 3 layered_indexable_feature_value_lang_value 3 theme 3 layered_indexable_feature_lang_value 3 currency 2 shop_group 2 smarty_last_flush 2 layered_indexable_attribute_group 2 themeconfigurator 2 layered_indexable_feature 2 meta 2 tax_rules_group 2 country 2 tax_rule 2 hook_module 2 hook_alias 2 group 2 cat_filter_restriction 2 group_shop 2 layered_category 2 configuration 2 category_product 2 category_group 1 product_attribute_combination 1 attribute 1 attribute_lang 1 product_attribute 1 hook_module_exceptions 1 tax_lang 1 country_shop 1 country_lang 1 attribute_group 1 connections 1 page_type 1 page 1 required_field 1 supplier_shop 1 supplier 1 supplier_lang 1 tax 1 attribute_group_lang 1 layered_price_index 1 scene 1 meta_lang 1 cms_shop 1 cms_lang 1 theme_meta 1 cms 1 scene_lang 1 configuration_lang 1 group_lang 1 lgcookieslaw 1 scene_category 1 module_group 1 manufacturer 1 image_shop 1 image_lang 1 scene_shop 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 8 /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]
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/85/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/85/85/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