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
The Reina Colona column radiators are perfect if you are looking to add a traditional theme throughout your home. These stunning traditional radiators come in a crisp white finish with an excellent heat output not only will they look fantastic within the home they are sure to keep your home warm throughout.
Sizing will not be an issue with the Colona's as there is a variety of vertical and horizontal 2,3 and 4 column sizes available. The Colona radiators can be used as central heating, electric and dual fuel radiators however please check on your size which usage option is available as certain sizes can only be central heating only.
Load Time | 737 ms - Unicorn powered webserver! |
Querying Time | 267 ms |
Queries | 362 |
Memory Peak Usage | 21.3 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 | 52 ms | 52 ms | 5.87 Mb | 5.96 Mb |
__construct | 0 ms | 52 ms | - Mb | 5.96 Mb |
init | 15 ms | 67 ms | 1.72 Mb | 7.67 Mb |
checkAccess | 0 ms | 67 ms | - Mb | 7.67 Mb |
setMedia | 4 ms | 71 ms | 0.14 Mb | 7.81 Mb |
postProcess | 0 ms | 71 ms | - Mb | 7.81 Mb |
initHeader | 0 ms | 71 ms | - Mb | 7.81 Mb |
initContent | 461 ms | 532 ms | 10.01 Mb | 17.90 Mb |
initFooter | 25 ms | 557 ms | 0.69 Mb | 18.60 Mb |
display | 180 ms | 737 ms | 1.46 Mb | 21.32 Mb |
Hook | Time | Memory Usage |
---|---|---|
__construct | 23 ms | 3.50 Mb |
hookHeader | 17 ms | 0.25 Mb |
hookfooter | 13 ms | - Mb |
hookdisplayHeader | 13 ms | 0.25 Mb |
hookleftcolumn | 11 ms | - Mb |
hooktop | 11 ms | 0.25 Mb |
hookdisplayTop | 9 ms | 0.50 Mb |
hookdisplayNav | 1 ms | - Mb |
hookdisplayFooter | 1 ms | 0.25 Mb |
hookdisplayLeftColumn | 1 ms | - Mb |
hookproductlistassign | 1 ms | - Mb |
hookdisplayTopColumn | 0 ms | - Mb |
hookmoduleRoutes | - ms | - Mb |
13 hooks | 101 ms | 5.00 Mb |
Module | Time | Memory Usage |
---|---|---|
blocklayered | 13 ms | 0.25 Mb |
lgcookieslaw | 11 ms | 0.25 Mb |
blocktopmenu | 10 ms | 0.50 Mb |
smartblog | 7 ms | 0.75 Mb |
blockcart | 7 ms | - Mb |
blockcms | 6 ms | - Mb |
statsdata | 6 ms | 0.25 Mb |
blocksearch | 5 ms | 0.50 Mb |
themeconfigurator | 5 ms | 0.25 Mb |
blockcategories | 4 ms | 0.25 Mb |
blocktags | 4 ms | - Mb |
blockmyaccountfooter | 3 ms | 0.25 Mb |
blockcontactinfos | 3 ms | - 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 |
blockmyaccount | 1 ms | - Mb |
blocksocial | 1 ms | - Mb |
sekeywords | 1 ms | 0.25 Mb |
homeslider | 1 ms | 0.25 Mb |
pagesnotfound | 1 ms | - Mb |
mailalerts | 1 ms | 0.25 Mb |
blockbanner | 1 ms | - Mb |
recaptcha | 1 ms | - Mb |
sagepay | 0 ms | 0.25 Mb |
29 modules | 101 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|10060|1|1%" |
10.5 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|10062|1|1%" |
10.5 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='57f0f0439f37dbba347f5892109c3aab' AND cache_id LIKE "productlist_colors|10061|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|10066|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|10070|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|10063|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|10068|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|10064|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|10069|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|10065|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` = 292 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 |
5 | 92 | Yes | /classes/Category.php:791 | |
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.5 | 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 |
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 >= 514 AND c.nright <= 515 AND c.active = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") |
1.8 | 1 | /modules/blocklayered/blocklayered.php:2135 | ||
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 <= 514 AND c.nright >= 515 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.1 | 267 | 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.1 | 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` = 292 AND `c`.`active` = 1 AND cg.`id_group` =1 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC |
1 | 1 | Yes | Yes | /classes/Category.php:666 |
SELECT SQL_NO_CACHE 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 |
1 | 81 | /classes/module/Module.php:277 | ||
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 (10060,10061,10062,10063,10064,10065,10066,10067,10068,10069,10070,10071,10072,10073,10074,10075,10076,10077,10078,10079,10080,10081,10082,10083) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.9 | 24 | Yes | Yes | /classes/Product.php:3466 |
SELECT SQL_NO_CACHE 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 = 10060 ORDER BY f.position ASC |
0.8 | 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 = 10068 ORDER BY f.position ASC |
0.8 | 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 = 10062 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10069) 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 = 10065 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 = 10067 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 = 10061 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10060) 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` = 10061) 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` = 10068) 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 = 10063 ORDER BY f.position ASC |
0.7 | 22 | 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 | |
ALTER TABLE ps_cat_restriction ADD PRIMARY KEY (id_product), ADD KEY `id_manufacturer` (`id_manufacturer`,`id_product`) USING BTREE, ADD KEY `condition` (`condition`,`id_product`) USING BTREE, ADD KEY `weight` (`weight`,`id_product`) USING BTREE |
0.7 | 1 | /modules/blocklayered/blocklayered.php:2141 | ||
SELECT SQL_NO_CACHE 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` = 10078) 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 *, ( 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 = 10069 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10071) 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` = 10063) 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` = 10062) 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` = 10066) 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 = 10078 ORDER BY f.position ASC |
0.7 | 22 | Yes | /classes/Product.php:4455 | |
SELECT SQL_NO_CACHE name FROM `ps_feature_lang` fl LEFT JOIN `ps_layered_indexable_feature` lif ON lif.id_feature = fl.id_feature WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.7 | 134 | /modules/blocklayered/blocklayered.php:2724 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 17, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 17) AND `id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2023-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 = 10071 ORDER BY f.position ASC |
0.7 | 22 | 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 = 10066 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 = 10064 ORDER BY f.position ASC |
0.7 | 22 | Yes | /classes/Product.php:4455 | |
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 1 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1 |
0.7 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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 = 10077 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10067) 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 = 10070 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10064) 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 = 10079 ORDER BY f.position ASC |
0.7 | 22 | 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 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 = 10083 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10070) 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 = 10082 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 = 10072 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10080) 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 *, ( 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 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 = 10081 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 = 10080 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10082) 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 = 10073 ORDER BY f.position ASC |
0.7 | 22 | 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` = 10081) 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` = 10079) 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` = 10083) 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` = 10073) 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` = 10076) 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 = 10076 ORDER BY f.position ASC |
0.6 | 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 = 10075 ORDER BY f.position ASC |
0.6 | 22 | 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` = 10072) AND (b.`id_shop` = 1) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'd71.6bdv.ws' OR su.domain_ssl = 'd71.6bdv.ws') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.6 | 1 | Yes | /classes/shop/Shop.php:334 | |
SELECT SQL_NO_CACHE * 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` = 10074) 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` = 10065) 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` = 10075) 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 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 = 10074 ORDER BY f.position ASC |
0.6 | 22 | 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` = 10077) AND (b.`id_shop` = 1) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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` = 292 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1 |
0.6 | 45 | /classes/Category.php:720 | ||
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 *, ( 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_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0') |
0.6 | 1 | /classes/ObjectModel.php:487 | ||
SELECT SQL_NO_CACHE *, ( 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 IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10067|1|1","", FROM_UNIXTIME(1701306134)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('12734071', '327', '55575699', '', '1', '1', '2023-11-30 01:02:14') |
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|10074|1|1","", FROM_UNIXTIME(1701306134)) |
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 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.6 | 1 | Yes | /classes/tax/TaxRulesTaxManager.php:109 | |
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` = 292) 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|10073|1|1","", FROM_UNIXTIME(1701306134)) |
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|10081|1|1","", FROM_UNIXTIME(1701306134)) |
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|10080|1|1","", FROM_UNIXTIME(1701306134)) |
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|10078|1|1","", FROM_UNIXTIME(1701306134)) |
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|10079|1|1","", FROM_UNIXTIME(1701306134)) |
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|10082|1|1","", FROM_UNIXTIME(1701306134)) |
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|10072|1|1","", FROM_UNIXTIME(1701306134)) |
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|10071|1|1","", FROM_UNIXTIME(1701306134)) |
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` = 106) 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` = 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` = 16) 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 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10083|1|1","", FROM_UNIXTIME(1701306134)) |
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 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 = 292 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 su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.5 | 1 | /classes/shop/Shop.php:203 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10063) |
0.5 | 1 | /classes/Product.php:2998 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10075|1|1","", FROM_UNIXTIME(1701306134)) |
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|10077|1|1","", FROM_UNIXTIME(1701306134)) |
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` = 10061) |
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` = 10069) |
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` = 10065) |
0.5 | 1 | /classes/Product.php:2998 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10076|1|1","", FROM_UNIXTIME(1701306134)) |
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` = 10062) |
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_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 17) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10067) |
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` = 10079) |
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` = 10076) |
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` = 10078) |
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` = 10064) |
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` = 10077) |
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` = 10080) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
0.4 | 8 | /classes/SpecificPrice.php:230 | ||
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 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 value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.4 | 1 | /classes/shop/Shop.php:1067 | ||
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` = 10060) |
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` = 10070) |
0.4 | 1 | /classes/Product.php:2998 | ||
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction |
0.4 | 1 | /modules/blocklayered/blocklayered.php:2125 | ||
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` = 10066) |
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` = 10072) |
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` = 10068) |
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 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` = 10082) |
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` = 10073) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = 12734071 AND `date_add` > '2023-11-30 00:32:00' AND id_shop IN (1) ORDER BY `date_add` DESC LIMIT 1 |
0.4 | 1 | Yes | /classes/Connection.php:138 | |
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10071) |
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` = 10081) |
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` = 10075) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 |
0.4 | 6 | /classes/SpecificPrice.php:238 | ||
SELECT SQL_NO_CACHE 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` = 10074) |
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` = 10083) |
0.4 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 17 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.4 | 0 | /classes/tax/TaxRulesTaxManager.php:109 | ||
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 type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 292 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 domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.4 | 1 | /classes/shop/ShopUrl.php:169 | ||
SELECT SQL_NO_CACHE * 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 * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9809e53dfa527993d6871c23a4fc7d29' AND cache_id="blocktopmenu|1|1|1|17|category|292" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found FROM `ps_lang` WHERE LEFT(`language_code`,2) = 'en' ORDER BY found ASC LIMIT 1 |
0.4 | 1 | Yes | /classes/Language.php:719 | |
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 292 AND cl.id_shop = 1 LIMIT 1 |
0.4 | 1 | /classes/Meta.php:291 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='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 COUNT(DISTINCT c.id_currency) FROM `ps_currency` c LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1 |
0.4 | 1 | /classes/Currency.php:472 | ||
SELECT SQL_NO_CACHE `id_country` FROM `ps_country` WHERE `iso_code` = 'US' AND active = 1 LIMIT 1 |
0.4 | 1 | /classes/Country.php:174 | ||
SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 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 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|10070|1|1" AND compile_id="" LIMIT 1 |
0.4 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.4 | 5 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10068 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.4 | 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|10066|1|1" AND compile_id="" LIMIT 1 |
0.4 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|0|1|1|1|17" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1 |
0.4 | 1 | /classes/Image.php:470 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.4 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10061) 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|10081|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|10073|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1 |
0.3 | 1 | /classes/Page.php:97 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='979764b58eb6a1c504b39475e4620126' AND cache_id="blockmyaccountfooter|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10082|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '55390e8160f80e0450cfa2babf4512aa' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
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 nleft, nright, level_depth FROM ps_category WHERE id_category = 292 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1485 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10072|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|10061|1|1" AND compile_id="" LIMIT 1 |
0.3 | 0 | /classes/SmartyCustom.php:215 | ||
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 ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 292 AND ctg.`id_group` = 1 LIMIT 1 |
0.3 | 1 | /classes/Category.php:1317 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10070 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10060 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` = 10079 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` = 10061 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
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|10060|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` = 10076 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|10068|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` = 10078 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` = 10077 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10069 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|10071|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10060 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` = 10075 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `id_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 292 LIMIT 1 |
0.3 | 2 | /classes/Page.php:77 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10082 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`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|2|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|10067|1|1","", FROM_UNIXTIME(1701306134)) |
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|10075|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|10074|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_image_type` |
0.3 | 9 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10062|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 = 10060) 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|10064|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|10078|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:95 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10071) 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 = 10062) 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_required_field, object_name, field_name FROM ps_required_field |
0.3 | 1 | /classes/ObjectModel.php:1376 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10081|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10063 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` = 10062 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|10076|1|1","", FROM_UNIXTIME(1701306134)) |
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|10077|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` = 10065 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|10080|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|10083|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|10078|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10077) 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|10063|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`='fb458c083c5e11bd8cdd5fdecc29e5f1' AND cache_id="blockcategories|1|1|1|17|292|292|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` = 10064 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` = 10072 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 = 10063) 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` = 10070 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|10071|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10067 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 = 10073) 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 = 10069) 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|10069|1|1" AND compile_id="" LIMIT 1 |
0.3 | 0 | /classes/SmartyCustom.php:215 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10072|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM ps_layered_category WHERE id_category = 292 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:636 | ||
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10079|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10071 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|10073|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10066 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 = 10076) 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|10065|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 = 10083) 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 = 10082) 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 = 10075) 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|10075|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10083 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` = 10076 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` = 10080 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` = '55390e8160f80e0450cfa2babf4512aa' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10070) 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` = 10064 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` = 10068 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` = 10073 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 = 10081) 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 = 10078) 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 = 10064) 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` = 10074 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` = 10063 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` = 10062 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` = 10081 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|10067|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10080) 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 = 10079) 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 = 10068) 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 = 10074) 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` = 10069 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|10076|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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10061 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` = 10083 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` = 10071 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10082 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`='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 data FROM `ps_layered_friendly_url` WHERE `url_key` = '4f640872eab32813a054a345f6d87e2b' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10075 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10063 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` = 10070 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10082|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10062 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 = 10072) 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 = 10066) 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` = 10072 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` = 10060 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` = 10077 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 = 10065) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10077|1|1","", FROM_UNIXTIME(1701306134)) |
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 data FROM `ps_layered_friendly_url` WHERE `url_key` = '128f0937c7b3fa10328100f0ad93f06d' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10067) 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_product_group_reduction_cache` WHERE `id_product` = 10066 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` = 10065 AND id_shop=1 LIMIT 1 |
0.3 | 1 | /classes/Product.php:5034 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10077 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` = 10073 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` = 10078 AND id_shop=1 LIMIT 1 |
0.3 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '128f0937c7b3fa10328100f0ad93f06d' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10080|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_category_shop` WHERE `id_category` = 292 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` = 'home_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` = 10079 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` = 10083 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|10079|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10082 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` = 10066 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|10074|1|1","", FROM_UNIXTIME(1701306134)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10075 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` = 10078 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` = 10081 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10074 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` = 10080 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` = 10081 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` = 10067 AND id_shop=1 LIMIT 1 |
0.2 | 1 | /classes/Product.php:5034 | ||
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.2 | 6 | /classes/SpecificPrice.php:305 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '5b9adfc8aaf6b3effbbdfc71a2aa6d65' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
0.2 | 1 | /classes/Group.php:133 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10083|1|1","", FROM_UNIXTIME(1701306134)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10068 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` = '4f640872eab32813a054a345f6d87e2b' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10069 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` = 10080 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` = 10065 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` = 10071 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.2 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.2 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '4a0f46202e34a09f5e4106126855fa02' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.2 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10076 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` = 10079 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` = 10061 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` = 10067 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` = 10073 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` = 10064 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
0.2 | 1 | /override/classes/Hook.php:61 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10074 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` = '5b9adfc8aaf6b3effbbdfc71a2aa6d65' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '4a0f46202e34a09f5e4106126855fa02' LIMIT 1 |
0.2 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10072 AND `id_group` = 1 LIMIT 1 |
0.2 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.2 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 |
28 | 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 | DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%" |
10 | SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX |
4 | 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 tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
2 | SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m |
2 | SELECT content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = 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 |
75 product_shop |
51 product |
42 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 |
10 layered_friendly_url |
9 category_lang |
9 category |
7 category_shop |
6 lgcookieslaw_lang |
5 module_shop |
5 module |
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 | 8 | /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] |
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/292/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/292/292/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 |