Our webstore uses cookies to offer a better user experience and we recommend you to accept their use to fully enjoy your navigation. Please view our privacy and cookies policy for further information.
I accept
Need help? Call 01206 582462 or email sales@designerbathroomstore.co.uk
Cart 0 Product Products (empty)
No products
To be determined Shipping
£ 0.00 Total
Product successfully added to your shopping cart
Quantity
Total
There are 0 items in your cart. There is 1 item in your cart.
Total products
Total shipping To be determined
Total
Categories
Catalog
Shower Enclosures
Subcategories
Quadrant Shower Enclosures
Quadrant Shower Enclosures are an excellent addition into any bathroom space. Perfectly suited to smaller bathroom and en-suites - they operate with a sliding glass door, making them a fantastic space saving option. As well as being suited to smaller bathrooms, these enclosures also work very well in contemporary bathrooms. Although not taking up a massive amount of floorspace, these enclosures still deliver in terms of showering space, thanks to their clever design. As an added bonus, the clever design of these shower enclosures also means that they are very easy to both clean and maintain.
All of our Quadrant Shower Enclosures have been handpicked from the world’s leading designers of bathroom and shower products - and are available in a wide range of designs and finishes. Brands featured within the collection include Kartell, Lakes and Scudo. Some of the most popular finishes include Chrome and Silver, with popular designs including Double Door Quadrants, Single Door Quadrants and Slider Shower Doors.
If you have any questions about these products, please do just get in touch and we will be more than happy to help.
Offset Quadrant Shower Enclosures
Offset Quadrant Shower Enclosures are the perfect product for bathrooms of all shapes and sizes, but especially small or awkward shower rooms, bathrooms and en-suites. These corner shower enclosures fit into the most awkward of spaces, providing an excellent addition into a bathroom with a small footprint, but a spacious showering area. These enclosures are most popular in modern and contemporary bathrooms, their sliding doors contrast brilliantly with the usual straight lines of a bathroom. These enclosures are available in single and double door options and popular finishes include both Chrome and Silver.
All of our enclosures have been handpicked from just a few chosen suppliers, who we absoloutely trust to deliver excellent quality and value products. These manufacturers include Kartell, Lakes and Scudo.
If you have any questions about this range, please do just get in touch and we will be more than happy to answer any questions you may have.
Sliding Door Shower Enclosures
Sliding Shower Doors are one of the simplest types of shower door/enclosure on the market. They work best in medium to large bathrooms, which holds a large showering area. Adding a luxurious feel to a bathroom, they help create a roomy, contemporary element into your bathroom design. Most of our Sliding Shower Doors are reversible, so can be either opened on either the left or right hand side.
All of these designs are available in both framed and frameless designs, and are available in a wide range of sizes - suitable for almost any showering space. Finishes available include Chrome & Silver, and all of our Sliding Shower Doors have been handpicked from just a few chosen suppliers. These suppliers have been chosen thanks to their excellent quality, design and also price point.
If you have any questions about purchasing a Sliding Shower Door for your bathroom - please do just get in touch and we will be more than happy to answer any questions you may have.
Walk In / Wet Rooms
Wet Rooms are the ultimate in contemporary bathrooms, and represent the ideal upgrade for bathrooms, shower rooms and en suites of all shapes and sizes. Wet Rooms are both highly functional and stylish, and our range of Wet Room/Walk In Shower Enclosures and Screens make the perfect addition in creating your wet room showering space. These enclosures and screens are perfect for almost all sizes of wetrooms, and work perfectly in either small en suite wetrooms or larger wet rooms as a bath replacement.
As well as looking fantastic, these screens and enclosures also play a key role in containing shower spray - preventing the rest of the wet room, from.. getting wet. This stops your towels getting soggy, or water resting on your bathroom furniture.
All of these screens have been handpicked from just a couple of our most trusted brands, who we know deliver excellent quality products which also look fantastic. These brands include Lakes and Scudo, who provide enclosures in both Silver and Chrome finishes.
If you have any questions about these enclosures, or help in choosing a shower solution for your wet room - please just get in touch and we will be happy to help.
Bi-Fold Shower Doors
Bi-Fold Shower Doors and Enclosures are the perfect addition to a smaller bathroom, shower room or en-suite. They have been designed with incredible attention to detail with regards to space saving, whilst providing a large showering area. The design of the doors eliminates the requirement for space for a shower door to swing open, meaning these shower enclosures can be installed near or next to other pieces of bathroom furniture.
At Designer Bathroom Store, we have an excellent range of Bi-Fold Shower Enclosures, handpicked from just a small range of suppliers. These suppliers have been chosen because they provide excellent quality products, with a beautiful design and at an excellent price point. Finishes available within this collection include both chrome and silver, and bi-fold shower doors are available in frameless and framed options. As to be expected a range of sizes are also available.
If you have any questions about this range, please do just get in touch and we will be more than happy to answer any questions you may have.
Pivot Shower Doors
Pivot Shower Doors, also commonly known as Hinged Shower Doors come in a variety of shapes, styles and sizes - making them suitable for almost any shower space. Handpicked from just a few trusted suppliers, we source and supply an excellent quality range of Pivot Shower Doors. Available in both framed, and frameless options - popular finishes include both Chrome and Silver. There’s over twenty of these products in stock, so just browse the range and let us know if you have any questions which need answering.
Corner Entry Shower Enclosures
At Designer Bathroom Store, we source and supply an excellent range of corner entry shower enclosures. These enclosures are perfect for those who want a shower enclosure, but whose bathrooms mean that entry to the enclosure would be difficult. Instead of using the usual pivot doors for entry, both sides of corner entry enclosures contain both the static side of the enclosure and part of the doors. Although this sounds a little complicated, using these enclosures could not be easier - simply slide both of the closest panels away from you to open the enclosure.
This range of enclosures is available in almost any size, ensuring you can find the right enclosure for your bathroom - large or small. All of our Corner Entry Enclosures have been handpicked from just a few suppliers, including Lakes. A range of finishes are also available.
Many of our customers choose to replace their enclosure as part of a new bathroom suite, or in some cases simply a refresh and a change of design. If you have any questions about this range, please do just get in touch and we will be more than happy to help.
Shower Trays
Shower Trays provide an essential function in any bathroom. Providing a comfortable, easy to clean and stylish part of any bathroom which includes a shower. Not surprisingly, there’s a massive range of Shower Trays to choose from, and we are proud to stock a great collection to choose from. Regardless of whether you are removing your bath, replacing your bathroom suite, or simply replacing a broken Shower Tray, there’s the perfect product for you.
There’s a range of materials available, including very popular stone resin - which provides an incredibly luxury appearance, whilst providing a very stable footing. These shower trays are also available in Quadrant, Offset, Square and Rectangular Shapes.
As always, we have handpicked just a few suppliers - who we trust to deliver exceptional shower trays which stand up to years and years of use. If you have any questions about this collection, just get in touch and we will be happy to answer any questions you may have.
Side Panels
Shower Side Panels play a key part in both the performance and style of your Shower Enclosure. Used to fully enclose your shower unit, they keep the water in the right side of the shower, whilst looking brilliant. Naturally, a wide range of sizes are available for any enclosure, and we have handpicked just a few shower side panels and screens - which provide reliable, safe and stylish performance. As well as the standard range of glass panels and screens, there’s also a few extra special models within the range - some of which have mirrored finishes allowing you to add a useful mirror into your bathroom.
If you have any questions about this range of side panels, please do just get in touch and we will be more than happy to help with any questions you may have.
Iona A6 Easy Clean Sliding Shower Door 1200mm
From £ 223.14 Details
Iona A6 Easy Clean Sliding Shower Door 1000mm
From £ 215.20 Details
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
Choose from a wide range of shower doors and shower enclosures available from carefully selected, quality manufacturers. With so many styles and sizes available, you can be sure to find the ideal shower enclosure or shower door to suit your needs. From sliding shower doors to, walk in shower enclosures to mirror finish glass panels, we have something for everyone. We also have a wide range of shower trays including square shower trays, quadrant shower trays, rectangular shower trays and accessories.
Load Time 828 ms - OK... for a shared hosting Querying Time 304 ms Queries 413 Memory Peak Usage 21.1 Mb Included Files 215 files - 4.84 Mb PrestaShop Cache - Mb Global vars 0.72 Mb PrestaShop Version 1.6.1.6 PHP Version 5.6.40-29+ubuntu16.04.1+deb.sury.org+1 (OK) MySQL Version 10.0.21-MariaDB-log (OK) Memory Limit 150M Max Execution Time 30s Smarty Cache enabled Smarty Compilation never recompile Time Cumulated Time Memory Usage Memory Peak Usage config 50 ms 50 ms 5.87 Mb 5.96 Mb __construct 0 ms 50 ms - Mb 5.96 Mb init 13 ms 64 ms 1.26 Mb 7.23 Mb checkAccess 0 ms 64 ms - Mb 7.23 Mb setMedia 4 ms 68 ms 0.14 Mb 7.37 Mb postProcess 0 ms 68 ms - Mb 7.37 Mb initHeader 0 ms 68 ms - Mb 7.37 Mb initContent 510 ms 578 ms 10.48 Mb 17.89 Mb initFooter 27 ms 605 ms 0.69 Mb 18.61 Mb display 223 ms 828 ms 1.00 Mb 21.12 Mb Hook Time Memory Usage hookproductlistassign 217 ms 5.50 Mb hookHeader 43 ms 0.50 Mb __construct 23 ms 3.25 Mb hookleftcolumn 18 ms - Mb hookfooter 14 ms 0.25 Mb hookdisplayHeader 13 ms 0.25 Mb hooktop 11 ms - Mb hookdisplayTop 9 ms 0.50 Mb hookdisplayNav 1 ms - Mb hookdisplayFooter 1 ms - Mb hookdisplayLeftColumn 1 ms - Mb hookmoduleRoutes 0 ms - Mb hookdisplayTopColumn - ms - Mb 13 hooks 352 ms 10.25 Mb Module Time Memory Usage blocklayered 263 ms 6.00 Mb lgcookieslaw 12 ms 0.25 Mb blocktopmenu 10 ms 0.50 Mb smartblog 7 ms 0.75 Mb blockcart 7 ms - Mb statsdata 7 ms 0.25 Mb blockcms 6 ms - Mb blocksearch 5 ms 0.25 Mb blockcategories 5 ms 0.25 Mb themeconfigurator 4 ms - Mb blockmyaccountfooter 3 ms 0.25 Mb blockcontactinfos 3 ms 0.25 Mb blockuserinfo 3 ms 0.25 Mb blocktags 3 ms - Mb mancarousel 2 ms - Mb socialsharing 2 ms 0.25 Mb ganalytics 2 ms 0.25 Mb reviewscouk 1 ms - Mb productcomments 1 ms - Mb googleshopping 1 ms 0.25 Mb sekeywords 1 ms - Mb blocksocial 1 ms - Mb mailalerts 1 ms - Mb pagesnotfound 1 ms - Mb blockmyaccount 1 ms - Mb blockbanner 1 ms - Mb homeslider 1 ms 0.25 Mb recaptcha 1 ms - Mb sagepay 0 ms 0.25 Mb 29 modules 352 ms 10.25 Mb Stopwatch SQL - 413 queries
Query Time (ms) Rows Filesort Group By Location SELECT SQL_NO_CACHE p.*, product_shop.*, product_shop.id_category_default, pl.*, image_shop.`id_image` id_image, il.legend, m.name manufacturer_name, product_attribute_shop.id_product_attribute id_product_attribute, DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-12-04 00:00:00", INTERVAL 60 DAY)) > 0 AS new, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity FROM ps_cat_filter_restriction cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_product_lang pl ON (pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN ps_manufacturer m ON (m.id_manufacturer = p.id_manufacturer) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`order_priority` DESC,p.`order_weight` DESC,cp.position asc , cp.id_product LIMIT 0,2421.4 946 Yes /modules/blocklayered/blocklayered.php:2047 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|20939|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|20904|1|1%"
10.6 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17810|1|1%"
10.6 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17752|1|1%"
10.6 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17751|1|1%"
10.6 1 /classes/SmartyCustom.php:295 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|17809|1|1%"
10.6 1 /classes/SmartyCustom.php:295 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 (27672,27670,17434,17733,17738,17742,17745,17751,17754,17809,20903,20936,20939,17435,17734,17739,17743,17746,17752,17755,17810,20904,20909,20937) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC;
7.2 384 Yes Yes /classes/Product.php:3466 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 >= 1415 AND c.nright <= 1454 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")7 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 >= 1415 AND c.nright <= 1454 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_product6.8 1 /modules/blocklayered/blocklayered.php:1941 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
2.6 473 Yes /modules/blocklayered/blocklayered.php:2375 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
2.5 473 Yes /modules/blocklayered/blocklayered.php:2375 SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2.4 610 /classes/Configuration.php:148 SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
2.3 80 Yes Yes /override/classes/Hook.php:129 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 = 46 GROUP BY fv.id_feature_value
1.9 304 Yes /modules/blocklayered/blocklayered.php:2375 SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
1.7 271 /classes/Hook.php:236 ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE
1.7 1 /modules/blocklayered/blocklayered.php:2141 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 = 27 GROUP BY fv.id_feature_value
1.7 473 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` = 6 AND `c`.`active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.5 12 Yes Yes /classes/Category.php:666 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
1.5 473 /modules/blocklayered/blocklayered.php:2375 SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name
1.3 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 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` = 17435)
1 156 /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` = 17434)
1 155 /classes/Product.php:2998 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m
0.9 81 /classes/module/Module.php:277 SELECT SQL_NO_CACHE 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.9 134 /modules/blocklayered/blocklayered.php:2724 SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m
0.9 81 /classes/module/Module.php:277 SELECT SQL_NO_CACHE 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 <= 1415 AND c.nright >= 1454 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 137 Yes /classes/Tools.php:1327 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` = 17434) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 590700 LIMIT 1
0.8 1 /classes/Combination.php:344 ALTER TABLE ps_cat_filter_restriction ADD PRIMARY KEY (id_product), ADD KEY (position, id_product) USING BTREE
0.8 1 /modules/blocklayered/blocklayered.php:1953 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 = 27672 ORDER BY f.position ASC
0.7 17 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` = 17734) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17739) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 20903) 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 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 = 17809 ORDER BY f.position ASC
0.7 15 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` = 17746) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17745) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 20903 ORDER BY f.position ASC
0.7 15 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 = 20936 ORDER BY f.position ASC
0.7 15 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` = 20939) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 17734 ORDER BY f.position ASC
0.7 15 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17434) AND (id_product_attribute = 590700) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 /classes/stock/StockAvailable.php:378 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` = 17752) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17435) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 17434 ORDER BY f.position ASC
0.7 15 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 17 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC0.7 1 Yes /classes/tax/TaxRulesTaxManager.php:109 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` = 17755) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 27672) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 20936) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17743) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17733) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17809) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17738) 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 = 17751 ORDER BY f.position ASC
0.7 16 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` = 17742) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 17751) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 27670) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 17745 ORDER BY f.position ASC
0.7 15 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` = 17754) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name
0.7 1 Yes /classes/shop/Shop.php:663 SELECT SQL_NO_CACHE *, ( 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` = 17810) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-04 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.7 1 Yes /classes/SpecificPrice.php:361 SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 20904) 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 = 27670 ORDER BY f.position ASC
0.7 17 Yes /classes/Product.php:4455 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.7 41 Yes /classes/Dispatcher.php:452 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 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 = 17810 ORDER BY f.position ASC
0.6 15 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 = 17435 ORDER BY f.position ASC
0.6 15 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` = 20909) 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 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 = 17752 ORDER BY f.position ASC
0.6 16 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` = 62) 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 = 17739 ORDER BY f.position ASC
0.6 15 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 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 = 20939 ORDER BY f.position ASC
0.6 15 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` = 20937) 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 = 17746 ORDER BY f.position ASC
0.6 15 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 *, ( 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 = 17738 ORDER BY f.position ASC
0.6 15 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 = 17754 ORDER BY f.position ASC
0.6 16 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 = 17743 ORDER BY f.position ASC
0.6 15 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 = 17742 ORDER BY f.position ASC
0.6 15 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 = 20904 ORDER BY f.position ASC
0.6 15 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 = 20909 ORDER BY f.position ASC
0.6 15 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 = 17755 ORDER BY f.position ASC
0.6 16 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 *, ( 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 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 = 17733 ORDER BY f.position ASC
0.6 15 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 *, ( 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 = 20937 ORDER BY f.position ASC
0.6 15 Yes /classes/Product.php:4455 SELECT SQL_NO_CACHE public_name FROM `ps_attribute_group_lang` agl LEFT JOIN `ps_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1
0.6 83 /modules/blocklayered/blocklayered.php:2714 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` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')0.6 1 /classes/ObjectModel.php:487 SELECT SQL_NO_CACHE * 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` = 63) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 65) 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 INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('12740762', '197', '585449244', '', '1', '1', '2023-12-04 23:17:45')0.6 1 /classes/ObjectModel.php:487 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` = 69) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20909|1|1","", FROM_UNIXTIME(1701731865))0.6 1 /classes/SmartyCustom.php:263 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.6 1 /classes/Theme.php:275 SELECT SQL_NO_CACHE * FROM `ps_category_lang` WHERE `id_category` = 6 AND `id_shop` = 1
0.6 1 /Adapter/Adapter_EntityMapper.php:68 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20937|1|1","", FROM_UNIXTIME(1701731865))0.6 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17755|1|1","", FROM_UNIXTIME(1701731865))0.6 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` = 67) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 68) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /Adapter/Adapter_EntityMapper.php:61 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17435|1|1","", FROM_UNIXTIME(1701731865))0.6 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|27672|1|1","", FROM_UNIXTIME(1701731865))0.6 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17739|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|27670|1|1","", FROM_UNIXTIME(1701731865))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` = 66) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17734|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 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` = 17734)
0.5 6 /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` = 17739)
0.5 6 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169243 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169213 LIMIT 1
0.5 1 /classes/Combination.php:344 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` = 20903)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 614476 LIMIT 1
0.5 1 /classes/Combination.php:344 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` = 20939)
0.5 1 /classes/Product.php:2998 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17743|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE COUNT(*) FROM ps_layered_category WHERE id_category = 6 AND id_shop = 1 LIMIT 1
0.5 5 /modules/blocklayered/blocklayered.php:636 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` = 20936)
0.5 1 /classes/Product.php:2998 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` = 6 LIMIT 1
0.5 1 /classes/Category.php:1062 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` = 17738)
0.5 6 /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` = 17751)
0.5 3 /classes/Product.php:2998 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17745|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 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` = 17742)
0.5 6 /classes/Product.php:2998 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20903|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 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` = 27672)
0.5 6 /classes/Product.php:2998 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20936 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17754|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 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` = 17733)
0.5 6 /classes/Product.php:2998 SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 61) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1
0.5 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 6 AND sl.id_lang = 1 AND s.active = 1 ORDER BY sl.name ASC
0.5 1 Yes /classes/Scene.php:226 SELECT SQL_NO_CACHE 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` = 17743)
0.5 6 /classes/Product.php:2998 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20903 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 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` = 17754)
0.5 3 /classes/Product.php:2998 SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1
0.5 1 /classes/Category.php:1485 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17434|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169267 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1
0.5 1 /classes/ObjectModel.php:1459 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` = 17755)
0.5 5 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 590856 LIMIT 1
0.5 1 /classes/Combination.php:344 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` = 20909)
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` = 17745)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 614464 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169285 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.5 86 /classes/Hook.php:187 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169279 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169261 LIMIT 1
0.5 1 /classes/Combination.php:344 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169237 LIMIT 1
0.5 1 /classes/Combination.php:344 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` = 17810)
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` = 17746)
0.5 1 /classes/Product.php:2998 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20936|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169301 LIMIT 1
0.5 1 /classes/Combination.php:344 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` = 20937)
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` = 20904)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 6 AND ctg.`id_group` = 1 LIMIT 1
0.5 1 /classes/Category.php:1317 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17733|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17742|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20939 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17746|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1
0.5 1 /classes/ObjectModel.php:1459 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17738|1|1","", FROM_UNIXTIME(1701731865))0.5 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.5 1 /classes/shop/Shop.php:203 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20904 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 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` = 17809)
0.5 1 /classes/Product.php:2998 SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
0.5 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` = 17752)
0.5 3 /classes/Product.php:2998 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17746 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17435 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20937 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17434 AND id_shop=1 LIMIT 1
0.5 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.5 9 /classes/ImageType.php:143 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 20909 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.5 1 Yes /classes/Currency.php:231 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17745 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169295 LIMIT 1
0.4 1 /classes/Combination.php:344 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` = 6) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1
0.4 1 /classes/Language.php:894 SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 27670)
0.4 6 /classes/Product.php:2998 SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 17) LIMIT 1
0.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 = 6 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC
0.4 5 Yes Yes /modules/blocklayered/blocklayered.php:2121 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17809 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17810 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 0 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 6 LIMIT 1
0.4 1 /classes/Page.php:77 SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction
0.4 1 /modules/blocklayered/blocklayered.php:2125 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'd181d76011130ec0f8480cd5ab94c275' LIMIT 1
0.4 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.4 1 /classes/shop/Shop.php:1067 DROP TEMPORARY TABLE IF EXISTS ps_cat_filter_restriction
0.4 1 /modules/blocklayered/blocklayered.php:1927 SELECT SQL_NO_CACHE * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC
0.4 3 Yes /modules/themeconfigurator/themeconfigurator.php:376 SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|2|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 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 `id_guest` FROM `ps_connections` WHERE `id_guest` = 12740762 AND `date_add` > '2023-12-04 22:47: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 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 `id_country` FROM `ps_country` WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.4 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.4 1 /classes/Language.php:777 SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1
0.4 1 /classes/Currency.php:472 SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found FROM `ps_lang` WHERE LEFT(`language_code`,2) = 'en' ORDER BY found ASC LIMIT 1
0.4 1 Yes /classes/Language.php:719 SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 169207 LIMIT 1
0.4 1 /classes/Combination.php:344 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17435|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 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` = 6 AND cl.id_shop = 1 LIMIT 1
0.4 1 /classes/Meta.php:291 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.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|0|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|20903|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1
0.4 1 /classes/module/Module.php:2568 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='e87f73d0b061b626a2658ae68d69b740' AND cache_id="blockcontactinfos|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17734) AND (id_product_attribute = 169213) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1
0.4 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`='979764b58eb6a1c504b39475e4620126' AND cache_id="blockmyaccountfooter|1|1|1|17" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17809) 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17734) 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 20903) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 /classes/stock/StockAvailable.php:378 SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1
0.4 1 /Adapter/Adapter_EntityMapper.php:61 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 20936) 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 id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1
0.4 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|20904|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17755|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='fb458c083c5e11bd8cdd5fdecc29e5f1' AND cache_id="blockcategories|1|1|1|17|6|6|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
0.4 6 /classes/SpecificPrice.php:238 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|20937|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1)
0.4 5 /classes/module/Module.php:2141 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|17810|1|1" AND compile_id="" LIMIT 1
0.4 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17734 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1
0.4 1 /Adapter/Adapter_EntityMapper.php:68 SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 6 LIMIT 1
0.4 1 /classes/Category.php:1485 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1
0.4 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 27670 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17739 AND id_shop=1 LIMIT 1
0.4 1 /classes/Product.php:5034 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|6" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17734|1|1" AND compile_id="" LIMIT 1
0.4 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'c85129fb8d7e7763e5dc3908fc0c1c9b' LIMIT 1
0.4 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27672) 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17435 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` = 'd181d76011130ec0f8480cd5ab94c275' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17434) 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` = 17734 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|27672|1|1" 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` = 17754 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 27672 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17743|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 3 LIMIT 1
0.3 1 /classes/Category.php:1062 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17739|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE id_shop FROM `ps_category_shop` WHERE `id_category` = 6 AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1459 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 20936 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` = 20903 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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|20939|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|20936|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17738|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 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|17751|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|20909|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17752 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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|17752|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` = 17434 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` = 27672 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20903 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'd181d76011130ec0f8480cd5ab94c275' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'd181d76011130ec0f8480cd5ab94c275' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17734|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.3 2 /classes/SpecificPrice.php:230 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|17738|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 27670 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` = 17754 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 = 17751) AND (id_product_attribute = 169279) 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 = 17752) 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 = 17739) 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|17434|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17435|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 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|27670|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 20937) 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 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|27672|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20937|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17742) 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` = 17733 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|17743|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20909|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17739|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17810) 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` = 17743 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20936 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` = 17738 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17734 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17751) 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 = 17755) 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 = 27672) AND (id_product_attribute = 614476) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17746|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17746|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 1) LIMIT 1
0.3 1 /Adapter/Adapter_EntityMapper.php:61 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17754|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17755|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17435) 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` = 17809 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` = 17742 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 = 20904) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20936|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17746) 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 = 17743) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:378 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|20903|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 27670) 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 = 17435) AND (id_product_attribute = 590856) 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` = 17739 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 = 17733) 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 = 20939) 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|17742|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17751 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 = 17743) AND (id_product_attribute = 169267) 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 = 20909) 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|17733|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17755 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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|17745|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17745) 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 = 17738) 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` = 27672 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 = 27670) AND (id_product_attribute = 614464) 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 = 17755) AND (id_product_attribute = 169301) 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 = 17739) AND (id_product_attribute = 169243) 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 = 17752) AND (id_product_attribute = 169285) 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` = 17733 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 20939 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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|17754|1|1" AND compile_id="" LIMIT 1
0.3 1 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|17809|1|1" AND compile_id="" LIMIT 1
0.3 0 /classes/SmartyCustom.php:215 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 17810 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17743 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` = 17434 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 20904 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` = 17751 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 = 17754) AND (id_product_attribute = 169295) 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` = 17742 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 = 17738) AND (id_product_attribute = 169237) 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` = 20909 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` = 17746 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 = 17742) AND (id_product_attribute = 169261) 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` = 17745 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5034 SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
0.3 2 /classes/SpecificPrice.php:238 SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 17755 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 = 17733) AND (id_product_attribute = 169207) 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` = 17752 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` = 17738 ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 /classes/SpecificPrice.php:198 SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 20937 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|17742|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 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 `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17435 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20909 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17751 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 17754) 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 content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.3 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17809 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17745 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'c85129fb8d7e7763e5dc3908fc0c1c9b' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17739 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|27670|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17738 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17752 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20939 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17743 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'c85129fb8d7e7763e5dc3908fc0c1c9b' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20904 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1
0.3 1 /classes/Image.php:470 SELECT SQL_NO_CACHE id_attribute_group FROM ps_layered_indexable_attribute_group WHERE indexable = 0
0.3 22 /modules/blocklayered/blocklayered.php:738 SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-12-04 00:00:00' AND '2023-12-04 23:59:59' LIMIT 1
0.3 6 /classes/SpecificPrice.php:305 SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'c85129fb8d7e7763e5dc3908fc0c1c9b' LIMIT 1
0.3 1 /modules/blocklayered/blocklayered.php:1721 SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1
0.3 1 /classes/Group.php:133 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 27670 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17746 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17742 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 20937 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE id_feature FROM ps_layered_indexable_feature WHERE indexable = 0
0.3 40 /modules/blocklayered/blocklayered.php:740 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17434|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17755 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17733 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17733|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17810 AND `id_group` = 1 LIMIT 1
0.3 0 /classes/GroupReduction.php:149 INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|17745|1|1","", FROM_UNIXTIME(1701731865))0.3 1 /classes/SmartyCustom.php:263 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 button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 17754 AND `id_group` = 1 LIMIT 1
0.2 0 /classes/GroupReduction.php:149 SELECT SQL_NO_CACHE COUNT(*) FROM ps_cat_filter_restriction LIMIT 1
0.2 0 /modules/blocklayered/blocklayered.php:2002 SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:225 SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw;
0.2 1 /override/classes/Hook.php:61 SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1
0.2 1 /modules/lgcookieslaw/lgcookieslaw.php:225 Doubles
38 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
36 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))
24 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
24 SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX
24 SELECT * 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
14 SELECT product_attribute_shop.`price` 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 = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
10 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
8 SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX
6 DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%"
4 SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX
4 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 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 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
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 nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX
2 SELECT content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX
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
Tables stress
75 product_shop 51 product 40 product_attribute_shop 39 stock_available 38 smarty_lazy_cache 30 specific_price 29 feature_lang 28 feature_product 28 feature_value_lang 25 product_lang 24 feature 24 specific_price_priority 24 product_group_reduction_cache 24 feature_shop 17 category 16 category_lang 15 product_attribute 14 category_shop 8 layered_friendly_url 6 lgcookieslaw_lang 5 cat_restriction 5 module 5 module_shop 5 image_type 4 layered_indexable_feature_value_lang_value 4 lang 4 shop_url 4 lang_shop 4 feature_value 4 shop 4 layered_indexable_feature_lang_value 4 hook 4 currency_shop 3 currency 3 theme 2 themeconfigurator 2 meta 2 smarty_last_flush 2 layered_indexable_feature 2 cat_filter_restriction 2 configuration 2 tax_rules_group 2 country 2 tax_rule 2 hook_module 2 shop_group 2 layered_indexable_attribute_group 2 hook_alias 2 category_group 2 layered_category 2 category_product 2 group_shop 2 group 1 attribute 1 product_attribute_combination 1 scene_shop 1 country_shop 1 tax 1 tax_lang 1 country_lang 1 attribute_group 1 connections 1 page_type 1 page 1 required_field 1 supplier_shop 1 scene_lang 1 supplier 1 supplier_lang 1 attribute_lang 1 scene_category 1 cms_shop 1 configuration_lang 1 layered_price_index 1 cms_lang 1 cms 1 meta_lang 1 theme_meta 1 scene 1 group_lang 1 attribute_group_lang 1 lgcookieslaw 1 manufacturer 1 image_lang 1 module_group 1 image_shop 1 hook_module_exceptions ObjectModel instances
Name Instances Source Category 25 /controllers/front/CategoryController.php [105]
/classes/Link.php [177]
/modules/blocklayered/blocklayered.php [2113]
/modules/blocklayered/blocklayered.php [695]
/modules/blockcategories/blockcategories.php [193]
/modules/blocklayered/blocklayered.php [1799]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
/classes/Link.php [177]
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]
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/6/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/6/6/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
