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

JSMin: Unterminated String at byte 49: 'JSMin: Unterminated String at byte 1662: '
No products
Subcategories
The Eucotherm Mars range of flat panel radiators is the most prominent design from Eucotherm. The stylish flat panel design which is available in both horizontal and vertical models is s perfect addition to the modern home. With wide panels, the radiator is not only providing an eye-catching design for your home, but also excellent heat output. The Mars range is made from high quality steel and is available in both single panel and double panel options. With a wall to the front of the radiator measurement of just 86mm, the Mars duo double panel radiators provide an enormous heat output without sitting far off of the wall.
Vertical Mars radiators come in heights of 600mm, 900mm, 1200mm, 1500mm and 1800mm, with widths of 295mm, 445mm, 595mm and 670mm available, so there is a size to suit any project, whether it’s making the most of large wall space, or gaining heat output when space is at a premium.
The horizontal Mars radiator range has heights of 295mm, 445mm, 595mm, 600mm and 670mm and widths of 445mm, 595mm, 600mm, 820mm, 900mm, 1195mm, 1200mm, 1420mm, 1500mm and 1800mm, giving you plenty of choice and the option to have matching radiators throughout the whole house.
With such a wide variety of sizes and designs, the Eucotherm Mars radiator range is perfect for any room in the house. The tall vertical radiators are ideal as kitchen radiators when you don’t want to compromise on wall space for cupboards but still want to achieve a warm room. Horizontal Eucotherm Mars radiators are perfect for bedroom radiators and hallway radiators.
Eucotherm Mars are European made radiators which have been crafted to the highest quality. The radiators are backed with a ten year guarantee for peace of mind.
The Mars range features three stunning stocked finishes – white, anthracite and silver. Custom finishes can be ordered with a 6-8 week lead time. Call 01206 582462 today to discuss special finish options for Eucotherm Mars radiators.
Load Time | 728 ms - Unicorn powered webserver! |
Querying Time | 245 ms |
Queries | 368 |
Memory Peak Usage | 21.5 Mb |
Included Files | 214 files - 4.79 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.71 Mb |
PrestaShop Version | 1.6.1.6 |
PHP Version | 5.6.40-29+ubuntu16.04.1+deb.sury.org+1 (OK) |
MySQL Version | 10.0.21-MariaDB-log (OK) |
Memory Limit | 150M |
Max Execution Time | 30s |
Smarty Cache | enabled |
Smarty Compilation | never recompile |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 51 ms | 51 ms | 5.87 Mb | 5.96 Mb |
__construct | 0 ms | 51 ms | - Mb | 5.96 Mb |
init | 15 ms | 65 ms | 1.72 Mb | 7.67 Mb |
checkAccess | 0 ms | 65 ms | - Mb | 7.67 Mb |
setMedia | 4 ms | 70 ms | 0.14 Mb | 7.81 Mb |
postProcess | 0 ms | 70 ms | - Mb | 7.81 Mb |
initHeader | 0 ms | 70 ms | - Mb | 7.81 Mb |
initContent | 442 ms | 512 ms | 10.05 Mb | 17.94 Mb |
initFooter | 25 ms | 537 ms | 0.69 Mb | 18.64 Mb |
display | 191 ms | 728 ms | 1.51 Mb | 21.46 Mb |
Hook | Time | Memory Usage |
---|---|---|
__construct | 23 ms | 3.25 Mb |
hookHeader | 18 ms | 0.25 Mb |
hookdisplayHeader | 13 ms | 0.25 Mb |
hookfooter | 13 ms | 0.50 Mb |
hookleftcolumn | 12 ms | - Mb |
hooktop | 11 ms | 0.25 Mb |
hookdisplayTop | 8 ms | 0.50 Mb |
hookdisplayNav | 1 ms | - Mb |
hookdisplayLeftColumn | 1 ms | - Mb |
hookdisplayFooter | 1 ms | - Mb |
hookproductlistassign | 0 ms | - Mb |
hookdisplayTopColumn | 0 ms | - Mb |
hookmoduleRoutes | 0 ms | - Mb |
13 hooks | 103 ms | 5.00 Mb |
Module | Time | Memory Usage |
---|---|---|
blocklayered | 13 ms | 0.25 Mb |
lgcookieslaw | 12 ms | 0.25 Mb |
blocktopmenu | 9 ms | 0.50 Mb |
smartblog | 8 ms | 0.75 Mb |
blockcart | 7 ms | - Mb |
blockcms | 7 ms | 0.25 Mb |
statsdata | 6 ms | 0.25 Mb |
blockcategories | 5 ms | 0.25 Mb |
blocksearch | 5 ms | 0.50 Mb |
themeconfigurator | 5 ms | - Mb |
blocktags | 4 ms | - Mb |
blockmyaccountfooter | 3 ms | - Mb |
blockcontactinfos | 3 ms | 0.25 Mb |
blockuserinfo | 3 ms | 0.25 Mb |
mancarousel | 2 ms | - Mb |
socialsharing | 2 ms | 0.25 Mb |
ganalytics | 1 ms | - Mb |
reviewscouk | 1 ms | - Mb |
productcomments | 1 ms | - Mb |
googleshopping | 1 ms | 0.25 Mb |
mailalerts | 1 ms | 0.25 Mb |
sekeywords | 1 ms | 0.25 Mb |
blockmyaccount | 1 ms | - Mb |
blocksocial | 1 ms | - Mb |
blockbanner | 1 ms | - Mb |
homeslider | 1 ms | 0.25 Mb |
pagesnotfound | 1 ms | - Mb |
recaptcha | 1 ms | - Mb |
sagepay | 0 ms | 0.25 Mb |
29 modules | 103 ms | 5.00 Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14929|1|1%" |
10.4 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14935|1|1%" |
10.4 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14932|1|1%" |
10.4 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14938|1|1%" |
10.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14947|1|1%" |
10.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14944|1|1%" |
10.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|14941|1|1%" |
10.3 | 1 | /classes/SmartyCustom.php:295 | ||
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, DATE_SUB("2023-11-30 00:00:00", INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` 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_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 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 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` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 935 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY p.`order_priority` DESC,p.`order_weight` DESC,cp.`position` ASC LIMIT 0,24 |
7.8 | 266 | Yes | /classes/Category.php:791 | |
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 >= 962 AND c.nright <= 967 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") |
2.7 | 1 | /modules/blocklayered/blocklayered.php:2135 | ||
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
2.4 | 610 | /classes/Configuration.php:148 | ||
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.2 | 80 | Yes | Yes | /override/classes/Hook.php:129 |
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.7 | 271 | /classes/Hook.php:236 | ||
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name |
1.4 | 0 | /classes/Hook.php:131 | ||
SELECT SQL_NO_CACHE c.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 <= 962 AND c.nright >= 967 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 |
1.3 | 331 | Yes | /classes/Tools.php:1327 | |
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.2 | 28 | Yes | Yes | /classes/Supplier.php:127 |
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` = 935 AND `c`.`active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
1.1 | 2 | Yes | Yes | /classes/Category.php:666 |
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total 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_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 935 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1 |
1.1 | 133 | /classes/Category.php:720 | ||
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 (14949,14950,14952,14953,25141,25142,25143,25144,25145,14928,14929,14931,14932,14934,14935,14937,14938,14940,14941,14943,14944,14946,14947,14955) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1 | 24 | Yes | Yes | /classes/Product.php:3466 |
SELECT SQL_NO_CACHE 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 | ||
ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE |
0.8 | 1 | /modules/blocklayered/blocklayered.php:2141 | ||
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m |
0.8 | 81 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE 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 = 25141 ORDER BY f.position ASC |
0.8 | 23 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.8 | 1 | Yes | /classes/SpecificPrice.php:361 | |
SELECT SQL_NO_CACHE 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 = 14949 ORDER BY f.position ASC |
0.8 | 21 | 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 = 25145 ORDER BY f.position ASC |
0.8 | 23 | Yes | /classes/Product.php:4455 | |
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1 |
0.8 | 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` = 14950) 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 = 14950 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.7 | 1 | Yes | /classes/SpecificPrice.php:361 | |
SELECT SQL_NO_CACHE name FROM `ps_feature_lang` fl LEFT JOIN `ps_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.7 | 134 | /modules/blocklayered/blocklayered.php:2724 | ||
SELECT SQL_NO_CACHE 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 = 25143 ORDER BY f.position ASC |
0.7 | 23 | 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 = 25142 ORDER BY f.position ASC |
0.7 | 23 | 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 = 14953 ORDER BY f.position ASC |
0.7 | 20 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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 = 14952 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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 = 14938 ORDER BY f.position ASC |
0.7 | 21 | 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 = 14928 ORDER BY f.position ASC |
0.7 | 22 | 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 = 14944 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14946) 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` = 14929) 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 = 14940 ORDER BY f.position ASC |
0.7 | 21 | 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 = 14937 ORDER BY f.position ASC |
0.7 | 21 | 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 = 14929 ORDER BY f.position ASC |
0.7 | 21 | 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 = 25144 ORDER BY f.position ASC |
0.7 | 23 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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 = 14932 ORDER BY f.position ASC |
0.7 | 21 | 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 = 14931 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14928) 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 = 14934 ORDER BY f.position ASC |
0.7 | 21 | 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` = 14947) 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 = 14941 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14935) 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` = 14941) AND (b.`id_shop` = 1) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 1176) 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` = 14949) 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` = 14934) 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14952) AND (b.`id_shop` = 1) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name |
0.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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14931) 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 = 14947 ORDER BY f.position ASC |
0.7 | 21 | 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` = 25142) 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` = 14953) AND (b.`id_shop` = 1) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.7 | 41 | Yes | /classes/Dispatcher.php:452 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 14940) 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14937) 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` = 25145) 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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 = 14946 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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` = 14943) 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 = 14943 ORDER BY f.position ASC |
0.7 | 21 | 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` = 14944) 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 = 14955 ORDER BY f.position ASC |
0.7 | 21 | Yes | /classes/Product.php:4455 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25145|1|1","", FROM_UNIXTIME(1701309886)) |
0.7 | 1 | /classes/SmartyCustom.php:263 | ||
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` = 25143) 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 = 14935 ORDER BY f.position ASC |
0.7 | 21 | 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.6 | 1 | Yes | /classes/SpecificPrice.php:361 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 25141) AND (b.`id_shop` = 1) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 14955) 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 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-11-30 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-11-30 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.6 | 1 | Yes | /classes/SpecificPrice.php:361 | |
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('12734166', '8731', '55575699', '', '1', '1', '2023-11-30 02:04:46') |
0.6 | 1 | /classes/ObjectModel.php:487 | ||
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` = 14932) AND (b.`id_shop` = 1) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 14938) 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|14949|1|1","", FROM_UNIXTIME(1701309886)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE public_name FROM `ps_attribute_group_lang` agl LEFT JOIN `ps_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.6 | 83 | /modules/blocklayered/blocklayered.php:2714 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 25144) 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|14937|1|1","", FROM_UNIXTIME(1701309886)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
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 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14952|1|1","", FROM_UNIXTIME(1701309886)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
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 IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14943|1|1","", FROM_UNIXTIME(1701309886)) |
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|14940|1|1","", FROM_UNIXTIME(1701309886)) |
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|14955|1|1","", FROM_UNIXTIME(1701309886)) |
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|14953|1|1","", FROM_UNIXTIME(1701309886)) |
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|14931|1|1","", FROM_UNIXTIME(1701309886)) |
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|14934|1|1","", FROM_UNIXTIME(1701309886)) |
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|25143|1|1","", FROM_UNIXTIME(1701309886)) |
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|14928|1|1","", FROM_UNIXTIME(1701309886)) |
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|14946|1|1","", FROM_UNIXTIME(1701309886)) |
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` = 935) 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|14950|1|1","", FROM_UNIXTIME(1701309886)) |
0.5 | 1 | /classes/SmartyCustom.php:263 | ||
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` DESC |
0.5 | 1 | Yes | /classes/tax/TaxRulesTaxManager.php:109 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25141|1|1","", FROM_UNIXTIME(1701309886)) |
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` = 932) 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|25144|1|1","", FROM_UNIXTIME(1701309886)) |
0.5 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.5 | 86 | /classes/Hook.php:187 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 3) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 977) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC |
0.5 | 1 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE 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` = 25145) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC |
0.5 | 3 | Yes | /modules/themeconfigurator/themeconfigurator.php:376 | |
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` = 1175) AND (b.`id_shop` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 935 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` = 25141) |
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` = 14929) |
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` = 14937) |
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` = 14952) |
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` = 14946) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.5 | 1 | /classes/shop/Shop.php:203 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25142|1|1","", FROM_UNIXTIME(1701309886)) |
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` = 14953) |
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` = 25143) |
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` = 14934) |
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` = 14949) |
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` = 25144) |
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` = 14928) |
0.5 | 1 | /classes/Product.php:2998 | ||
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` = 935 AND cl.id_shop = 1 LIMIT 1 |
0.5 | 1 | /classes/Meta.php:291 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14940) |
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` = 14944) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
0.4 | 8 | /classes/SpecificPrice.php:230 | ||
SELECT SQL_NO_CACHE * 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 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` = 14943) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14931) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 25142) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14950) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14947) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14955) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "category" LIMIT 1 |
0.4 | 1 | /classes/Theme.php:275 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT 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 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` DESC |
0.4 | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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 type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 935 AND id_shop = 1 GROUP BY `type`, id_value ORDER BY position ASC |
0.4 | 1 | Yes | Yes | /modules/blocklayered/blocklayered.php:2121 |
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14935) |
0.4 | 1 | /classes/Product.php:2998 | ||
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 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 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` = 14938) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14941) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 14932) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = 12734166 AND `date_add` > '2023-11-30 01:34: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 * 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 * 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 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`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14935|1|1" AND compile_id="" LIMIT 1 |
0.4 | 0 | /classes/SmartyCustom.php:215 | ||
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 * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 2 LIMIT 1 |
0.4 | 1 | /classes/Category.php:1062 | ||
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 COUNT(*) FROM ps_layered_category WHERE id_category = 935 AND id_shop = 1 LIMIT 1 |
0.4 | 1 | /modules/blocklayered/blocklayered.php:636 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14953|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_image_type` |
0.4 | 9 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '8744eb6d9e5ba08b95504a7bec60b643' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14949) 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`='9809e53dfa527993d6871c23a4fc7d29' AND cache_id="blocktopmenu|1|1|1|17|category|935" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/shop/ShopUrl.php:169 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14937|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.3 | 1 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 935 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1485 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14940 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.3 | 5 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:142 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14938) 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 = 14944) 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 ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 935 AND ctg.`id_group` = 1 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1317 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 25142) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction |
0.3 | 1 | /modules/blocklayered/blocklayered.php:2125 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 25144 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14947) 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_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found FROM `ps_lang` WHERE LEFT(`language_code`,2) = 'en' ORDER BY found ASC LIMIT 1 |
0.3 | 1 | Yes | /classes/Language.php:719 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14938|1|1" AND compile_id="" LIMIT 1 |
0.3 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 25143) 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 DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 |
0.3 | 6 | /classes/SpecificPrice.php:238 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1485 | ||
SELECT SQL_NO_CACHE 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|25144|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` = 14950 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|25143|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`='fb458c083c5e11bd8cdd5fdecc29e5f1' AND cache_id="blockcategories|1|1|1|17|935|935|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|25145|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`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|2|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.3 | 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`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14931|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`='979764b58eb6a1c504b39475e4620126' AND cache_id="blockmyaccountfooter|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14928) 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|14929|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|14940|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 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 25143 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` = '8744eb6d9e5ba08b95504a7bec60b643' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='42dab2f39a24d3b63c3f2f0acaa84291' AND cache_id="blocksearch-top|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|14941|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|14950|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1 |
0.3 | 1 | /classes/Image.php:470 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|25141|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|14932|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|14944|1|1" AND compile_id="" LIMIT 1 |
0.3 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14937 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14929 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14949 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|0|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25142|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
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_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1 |
0.3 | 1 | /classes/Page.php:97 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14946 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /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|14943|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14955|1|1","", FROM_UNIXTIME(1701309886)) |
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|14928|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|25143|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 935 LIMIT 1 |
0.3 | 1 | /classes/Page.php:77 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14940) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 935 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1062 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14943 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|14940|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_category_shop` WHERE `id_category` = 935 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14952 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14949|1|1","", FROM_UNIXTIME(1701309886)) |
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|14952|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 25145) 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 `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
0.3 | 1 | /classes/Group.php:133 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14932) 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|25141|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14955) 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|14953|1|1","", FROM_UNIXTIME(1701309886)) |
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|14934|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14946 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|14950|1|1","", FROM_UNIXTIME(1701309886)) |
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|14943|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14950) 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 = 14953) 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` = 14931 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14946|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14943) 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` = 14953 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|14947|1|1" AND compile_id="" LIMIT 1 |
0.3 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14928 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` = 25142 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 = 14952) 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|25142|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|14937|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14931) 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 = 25144) 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` = 14949 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` = 14937 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` = 25142 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 = 14934) 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` = 25141 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` = 14952 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 = 25141) 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 button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14935) 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|14946|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` = 14955 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 14929) 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` = 14934 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 = 14937) 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` = 14953 AND id_shop=1 LIMIT 1 |
0.3 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1 |
0.3 | 1 | /classes/Image.php:470 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 25144 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` = 25141 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 = 14941) 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` = 14947 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|14955|1|1" 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` = 14952 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14947 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /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|14934|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` = 14934 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 25143 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` = 14931 AND id_shop=1 LIMIT 1 |
0.3 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14938 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14935 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14934 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` = 14935 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|14949|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2023-11-30 00:00:00' AND '2023-11-30 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` = 14932 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14941 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14943 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14928 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` = 14944 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` = 14944 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 0 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14953 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 = 14946) 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` = 25145 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` = 14940 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|14952|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25144|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
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 `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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 25142 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` = 14950 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` = 14931 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` = 'c598c7302c6137e28d976b210d150836' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14937 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` = 14935 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 14949 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` = 25145 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14929 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` = 25144 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` = 'c598c7302c6137e28d976b210d150836' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|14928|1|1","", FROM_UNIXTIME(1701309886)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-11-30 00:00:00' AND '2023-11-30 23:59:59' LIMIT 1 |
0.3 | 6 | /classes/SpecificPrice.php:305 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14938 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` = 14955 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` = 14941 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 14932 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5034 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|25145|1|1","", FROM_UNIXTIME(1701309886)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '3f170c6e82d3e9c1f139924ca59a03e9' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '3f170c6e82d3e9c1f139924ca59a03e9' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14946 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '154a8c824a95b3a4f12e1645d9e8274c' LIMIT 1 |
0.2 | 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|14931|1|1","", FROM_UNIXTIME(1701309886)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 25145 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14928 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 25141 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14943 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14940 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14947 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '154a8c824a95b3a4f12e1645d9e8274c' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14941 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14950 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14944 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14932 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14955 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14938 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1d982d4f4f566b9197f232b0d6396cd0' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 14929 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '1d982d4f4f566b9197f232b0d6396cd0' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
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` = 25143 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
0.2 | 1 | /override/classes/Hook.php:61 |
34 | 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 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 |
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 `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 * 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX |
24 | SELECT *, ( 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
10 | SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX |
7 | DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%" |
6 | 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 |
4 | SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX |
2 | SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m |
2 | SELECT 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 content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
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 |
75 product_shop |
51 product |
39 smarty_lazy_cache |
28 specific_price |
26 product_attribute_shop |
25 feature_lang |
25 stock_available |
25 product_lang |
24 feature_value_lang |
24 feature_product |
24 feature |
24 feature_shop |
24 specific_price_priority |
24 product_group_reduction_cache |
12 category_lang |
11 category |
10 layered_friendly_url |
9 category_shop |
6 lgcookieslaw_lang |
5 module |
5 module_shop |
5 image_type |
4 lang |
4 currency_shop |
4 lang_shop |
4 hook |
4 shop |
4 shop_url |
3 category_product |
3 currency |
3 theme |
2 layered_category |
2 smarty_last_flush |
2 tax_rule |
2 tax_rules_group |
2 themeconfigurator |
2 category_group |
2 hook_module |
2 meta |
2 country |
2 configuration |
2 shop_group |
2 group |
2 hook_alias |
2 group_shop |
1 attribute_lang |
1 page_type |
1 tax |
1 attribute |
1 product_attribute_combination |
1 connections |
1 page |
1 required_field |
1 product_attribute |
1 supplier_lang |
1 tax_lang |
1 supplier_shop |
1 attribute_group |
1 supplier |
1 attribute_group_lang |
1 meta_lang |
1 theme_meta |
1 group_lang |
1 scene_category |
1 module_group |
1 lgcookieslaw |
1 configuration_lang |
1 country_lang |
1 country_shop |
1 scene |
1 scene_shop |
1 cms_lang |
1 cms_shop |
1 image_shop |
1 image_lang |
1 cms |
1 layered_indexable_feature |
1 scene_lang |
1 hook_module_exceptions |
1 layered_indexable_attribute_group |
1 manufacturer |
Name | Instances | Source |
---|---|---|
Product | 24 | /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] |
Category | 12 | /controllers/front/CategoryController.php [105] /classes/Link.php [177] /modules/blocklayered/blocklayered.php [2113] /modules/blockcategories/blockcategories.php [193] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] /classes/Link.php [177] |
Language | 3 | /config/config.inc.php [195] /classes/Tools.php [524] /classes/Tools.php [541] |
CMS | 2 | /classes/Link.php [265] /classes/Link.php [265] |
Address | 2 | /classes/Product.php [2937] /classes/Product.php [4405] |
Currency | 2 | /classes/Tools.php [639] /modules/ganalytics/ganalytics.php [471] |
Country | 2 | /config/config.inc.php [142] /classes/controller/FrontController.php [279] |
Theme | 1 | /config/config.inc.php [115] |
Tax | 1 | /classes/tax/TaxRulesTaxManager.php [115] |
Guest | 1 | /modules/statsdata/statsdata.php [104] |
Connection | 1 | /modules/statsdata/statsdata.php [142] |
ShopGroup | 1 | /classes/shop/Shop.php [518] |
Shop | 1 | /config/config.inc.php [114] |
Cart | 1 | /classes/controller/FrontController.php [348] |
Group | 1 | /classes/Cart.php [184] |
Customer | 1 | /config/config.inc.php [217] |
# | 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/935/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/935/935/1/6e/c5/4a/6ec54a1aafdc723fe7c3a8a463665f36b096546f.blockcategories.tpl.php |
160 | /cache/smarty/cache/blockcms/0/1/1/1/17/c6/6c/99/c66c998d736e201796f14bbef99ada4df0200511.blockcms.tpl.php |
161 | /modules/blocktags/blocktags.php |
162 | /modules/blocktags/translations/en.php |
163 | /cache/smarty/cache/blocktags/1/1/1/17/0c/e1/c1/0ce1c1faf3d35f70b8c8c7cbf3c39a02cf1fa583.blocktags.tpl.php |
164 | /classes/ImageType.php |
165 | /classes/Combination.php |
166 | /classes/stock/StockAvailable.php |
167 | /classes/tax/Tax.php |
168 | /classes/Address.php |
169 | /classes/SpecificPrice.php |
170 | /classes/tax/TaxManagerFactory.php |
171 | /classes/tax/TaxRulesTaxManager.php |
172 | /classes/tax/TaxManagerInterface.php |
173 | /classes/tax/TaxCalculator.php |
174 | /classes/GroupReduction.php |
175 | /classes/Feature.php |
176 | /classes/Image.php |
177 | /classes/Supplier.php |
178 | /cache/smarty/cache/blockcms/2/1/1/1/17/c6/6c/99/c66c998d736e201796f14bbef99ada4df0200511.blockcms.tpl.php |
179 | /modules/blockmyaccountfooter/blockmyaccountfooter.php |
180 | /modules/blockmyaccountfooter/translations/en.php |
181 | /cache/smarty/cache/blockmyaccountfooter/1/1/1/17/29/ed/72/29ed723face6c737b0cfa2af388ced1349d928a2.blockmyaccountfooter.tpl.php |
182 | /modules/blockcontactinfos/blockcontactinfos.php |
183 | /modules/blockcontactinfos/translations/en.php |
184 | /cache/smarty/cache/blockcontactinfos/1/1/1/17/c1/27/fa/c127fa81e39fb5e2151d02420747ab0033425aa7.blockcontactinfos.tpl.php |
185 | /modules/statsdata/statsdata.php |
186 | /modules/statsdata/translations/en.php |
187 | /classes/Guest.php |
188 | /classes/Connection.php |
189 | /classes/Page.php |
190 | /classes/ConnectionsSource.php |
191 | /modules/reviewscouk/reviewscouk.php |
192 | /cache/smarty/compile/2f/fc/81/2ffc8183fe7b669a9ea9f7af395bb273ae624d33.file.category.tpl.php |
193 | /cache/smarty/compile/14/61/b5/1461b5063f03678d21b98c78c2078d39adeaecdb.file.errors.tpl.php |
194 | /cache/smarty/compile/23/68/5f/23685f22e7f1d2924ecd21423f2d03e2e51a8ba1.file.category-count.tpl.php |
195 | /cache/smarty/compile/0d/44/ec/0d44ecf4aeb788b97ced443d929cdc03ec75feff.file.product-sort.tpl.php |
196 | /cache/smarty/compile/a0/66/96/a066963f9dfd316c7bb8aea07bd6a224be964cd8.file.nbr-product-page.tpl.php |
197 | /cache/smarty/compile/55/da/6a/55da6adc645709ca02b6e53a849ddfd3a24a9b88.file.product-compare.tpl.php |
198 | /cache/smarty/compile/d3/ac/99/d3ac99ed9d700d54cb8c2c628566f63abffc7998.file.pagination.tpl.php |
199 | /cache/smarty/compile/52/21/4b/52214b4777edda08c81563ffba0138c736a5e06d.file.product-list.tpl.php |
200 | /tools/smarty/plugins/function.math.php |
201 | /cache/smarty/compile/e7/d5/20/e7d52066f73e7caa908990fd5e40b7f338f78509.file.layout.tpl.php |
202 | /cache/smarty/compile/5d/2a/d1/5d2ad148d64a076c1b36e269ad6503c0914553a2.file.header.tpl.php |
203 | /tools/smarty/plugins/function.implode.php |
204 | /cache/smarty/compile/c4/80/04/c48004a8ba41925135ae49d545752e7b1af286bf.file.nav.tpl.php |
205 | /cache/smarty/compile/08/69/28/086928842b0ed75c9b6bd53c6687fddc21bd901b.file.breadcrumb.tpl.php |
206 | /tools/smarty/plugins/modifier.regex_replace.php |
207 | /cache/smarty/compile/1f/54/af/1f54afb3e86dac52e1c47a36321b9382ac9c598b.file.footer.tpl.php |
208 | /cache/smarty/compile/4a/87/8d/4a878d3fe8b784005d62baa84f0151ba0313c8a9.file.global.tpl.php |
209 | /cache/smarty/compile/7b/05/01/7b0501b5bd8805d050202ee5e0775e0eb31f07be.file.javascript.tpl.php |
210 | /tools/smarty/plugins/shared.mb_str_replace.php |