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 Bonera radiator. A designer radiator with a contemporary finish. The Bonera adds a talking point within any room due to its intricate panel design and modern finish.
Made from a high quality steel and finished in a crisp white or popular anthracite colour. The Bonera is available in horizontal and vertical sizing with the horizontal height of 550mm and widths available of 456, 588, 852, 984 and 1248mm available and the vertical range has 2 sizes available 1800 x 324 and 1800 x 456.
The vertical Bonera range is suitable for central heating use only and the horizontal can be used as central heating, electric only or dual fuel use
Load Time | 559 ms - Unicorn powered webserver! |
Querying Time | 133 ms |
Queries | 266 |
Memory Peak Usage | 19.7 Mb |
Included Files | 214 files - 4.79 Mb |
PrestaShop Cache | - Mb |
Global vars | 0.69 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 | 55 ms | 55 ms | 5.87 Mb | 5.96 Mb |
__construct | 0 ms | 55 ms | - Mb | 5.96 Mb |
init | 16 ms | 71 ms | 1.72 Mb | 7.67 Mb |
checkAccess | 0 ms | 71 ms | - Mb | 7.67 Mb |
setMedia | 4 ms | 75 ms | 0.14 Mb | 7.81 Mb |
postProcess | 0 ms | 75 ms | - Mb | 7.81 Mb |
initHeader | 0 ms | 76 ms | - Mb | 7.81 Mb |
initContent | 293 ms | 368 ms | 8.49 Mb | 16.38 Mb |
initFooter | 26 ms | 395 ms | 0.69 Mb | 17.09 Mb |
display | 164 ms | 559 ms | 1.41 Mb | 19.67 Mb |
Hook | Time | Memory Usage |
---|---|---|
__construct | 23 ms | 3.50 Mb |
hookHeader | 18 ms | 0.25 Mb |
hookleftcolumn | 15 ms | - Mb |
hookfooter | 13 ms | - Mb |
hookdisplayHeader | 13 ms | 0.25 Mb |
hooktop | 11 ms | 0.25 Mb |
hookdisplayTop | 8 ms | 0.50 Mb |
hookdisplayNav | 1 ms | - Mb |
hookdisplayFooter | 1 ms | 0.25 Mb |
hookdisplayLeftColumn | 1 ms | - Mb |
hookproductlistassign | 1 ms | - Mb |
hookmoduleRoutes | 0 ms | - Mb |
hookdisplayTopColumn | - ms | - Mb |
13 hooks | 105 ms | 5.00 Mb |
Module | Time | Memory Usage |
---|---|---|
blocklayered | 14 ms | 0.25 Mb |
lgcookieslaw | 11 ms | 0.25 Mb |
blocktopmenu | 9 ms | 0.50 Mb |
smartblog | 8 ms | 0.75 Mb |
blockcategories | 7 ms | 0.25 Mb |
blockcart | 7 ms | 0.25 Mb |
blockcms | 7 ms | - Mb |
statsdata | 6 ms | 0.25 Mb |
blocksearch | 5 ms | - Mb |
themeconfigurator | 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 | 2 ms | - Mb |
reviewscouk | 1 ms | - Mb |
sekeywords | 1 ms | 0.25 Mb |
productcomments | 1 ms | - Mb |
googleshopping | 1 ms | 0.25 Mb |
blocksocial | 1 ms | - Mb |
blockmyaccount | 1 ms | 0.25 Mb |
mailalerts | 1 ms | 0.25 Mb |
homeslider | 1 ms | 0.25 Mb |
blockbanner | 1 ms | - Mb |
recaptcha | 1 ms | - Mb |
pagesnotfound | 1 ms | - Mb |
sagepay | 0 ms | 0.25 Mb |
29 modules | 105 ms | 5.00 Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
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` = 273 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 |
3.1 | 28 | 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.6 | 610 | /classes/Configuration.php:148 | ||
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
2.4 | 80 | Yes | Yes | /override/classes/Hook.php:129 |
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.8 | 271 | /classes/Hook.php:236 | ||
CREATE TEMPORARY TABLE ps_cat_restriction ENGINE=MEMORY SELECT DISTINCT cp.id_product, p.id_manufacturer, product_shop.condition, p.weight FROM ps_category_product cp INNER JOIN ps_category c ON (c.id_category = cp.id_category AND c.nleft >= 532 AND c.nright <= 533 AND c.active = 1) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = cp.id_product AND product_shop.id_shop = 1) INNER JOIN ps_product p ON (p.id_product=cp.id_product) WHERE product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") |
1.6 | 1 | /modules/blocklayered/blocklayered.php:2135 | ||
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 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.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 <= 532 AND c.nright >= 533 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 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` = 273 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 m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m |
0.9 | 81 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE name, 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 = 9945 ORDER BY f.position ASC |
0.9 | 22 | Yes | /classes/Product.php:4455 | |
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 (9945,9946,9947,9948,9949,9950,9951,9952,9953,9954,10042,10044,10045,10047) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.8 | 14 | Yes | Yes | /classes/Product.php:3466 |
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 = 9949 ORDER BY f.position ASC |
0.8 | 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.8 | 134 | /modules/blocklayered/blocklayered.php:2724 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9947 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 = 9951 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` = 9947) 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 = 10044 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 = 9946 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` = 9946) 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 = 10042 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 = 10047 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 = 9950 ORDER BY f.position ASC |
0.7 | 22 | Yes | /classes/Product.php:4455 | |
SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 17 AND tr.`id_tax_rules_group` = 1 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.7 | 1 | Yes | /classes/tax/TaxRulesTaxManager.php:109 | |
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 = 9954 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 = 9953 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` = 9948) 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` = 10042) 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` = 9953) 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 = 9952 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 = 9948 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` = 9952) 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 = 10045 ORDER BY f.position ASC |
0.7 | 22 | Yes | /classes/Product.php:4455 | |
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.7 | 41 | Yes | /classes/Dispatcher.php:452 | |
SELECT SQL_NO_CACHE * 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` = 10045) 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` = 9950) 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 * 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` = 9951) 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 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.7 | 1 | Yes | /classes/shop/Shop.php:334 | |
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 * 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` = 9949) 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` = 9954) 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` = 10044) 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.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 | |
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` = 10047) 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 | |
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.6 | 1 | /modules/blocklayered/blocklayered.php:2141 | ||
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =1 AND m.page = "category" LIMIT 1 |
0.6 | 1 | /classes/Theme.php:275 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9950|1|1","", FROM_UNIXTIME(1701306185)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9945) 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|9948|1|1","", FROM_UNIXTIME(1701306185)) |
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|9947|1|1","", FROM_UNIXTIME(1701306185)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 16) AND (b.`id_shop` = 1) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.6 | 1 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.6 | 86 | /classes/Hook.php:187 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9954|1|1","", FROM_UNIXTIME(1701306185)) |
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|9946|1|1","", FROM_UNIXTIME(1701306185)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
0.6 | 8 | /classes/SpecificPrice.php:230 | ||
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.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|9945|1|1","", FROM_UNIXTIME(1701306185)) |
0.6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE public_name FROM `ps_attribute_group_lang` agl LEFT JOIN `ps_layered_indexable_attribute_group` liag ON liag.id_attribute_group = agl.id_attribute_group WHERE indexable IS NULL OR indexable = 0 AND id_lang = 1 |
0.6 | 83 | /modules/blocklayered/blocklayered.php:2714 | ||
SELECT SQL_NO_CACHE * FROM `ps_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` = 273) 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|9949|1|1","", FROM_UNIXTIME(1701306185)) |
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|10042|1|1","", FROM_UNIXTIME(1701306185)) |
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|10047|1|1","", FROM_UNIXTIME(1701306185)) |
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|9952|1|1","", FROM_UNIXTIME(1701306185)) |
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|10044|1|1","", FROM_UNIXTIME(1701306185)) |
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 ('12734072', '308', '55575699', '', '1', '1', '2023-11-30 01:03:05') |
0.5 | 1 | /classes/ObjectModel.php:487 | ||
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` = 273 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1 |
0.5 | 14 | /classes/Category.php:720 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.5 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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` = 9952) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1) WHERE l.`active` = 1 LIMIT 1 |
0.5 | 1 | /classes/Language.php:894 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9954) |
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` = 9949) |
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` = 10047) |
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|10045|1|1","", FROM_UNIXTIME(1701306185)) |
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|9951|1|1","", FROM_UNIXTIME(1701306185)) |
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` = 9953) |
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|9953|1|1","", FROM_UNIXTIME(1701306185)) |
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` = 9945) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9946 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 1 AND cl.id_shop = 1 AND cl.`id_category` = 3 LIMIT 1 |
0.5 | 1 | /classes/Category.php:1062 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 1 AND id_shop = 1 LIMIT 1 |
0.5 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10045) |
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` = 9946) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE s.* FROM `ps_scene_category` sc LEFT JOIN `ps_scene` s ON (sc.id_scene = s.id_scene) INNER JOIN ps_scene_shop scene_shop ON (scene_shop.id_scene = s.id_scene AND scene_shop.id_shop = 1) LEFT JOIN `ps_scene_lang` sl ON (sl.id_scene = s.id_scene) WHERE sc.id_category = 273 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 * 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 COUNT(*) FROM ps_layered_category WHERE id_category = 273 AND id_shop = 1 LIMIT 1 |
0.5 | 1 | /modules/blocklayered/blocklayered.php:636 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10044 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 2 LIMIT 1 |
0.5 | 1 | /classes/Category.php:1485 | ||
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` = 9950) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9947 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9951) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9951 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9948) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.5 | 1 | /classes/Language.php:777 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10047 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10042 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9952 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9947) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.5 | 1 | /classes/ObjectModel.php:1459 | ||
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` = 10044) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9950 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9948 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9953 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE ctg.`id_group` FROM ps_category_group ctg WHERE ctg.`id_category` = 273 AND ctg.`id_group` = 1 LIMIT 1 |
0.5 | 1 | /classes/Category.php:1317 | ||
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_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC |
0.5 | 1 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT 1 |
0.5 | 1 | /classes/Image.php:470 | ||
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` = 10042) |
0.5 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9954 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9949 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:198 | ||
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 `id_guest` FROM `ps_connections` WHERE `id_guest` = 12734072 AND `date_add` > '2023-11-30 00:33: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 `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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10045 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.4 | 1 | /classes/SpecificPrice.php:198 | ||
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|2|1|1|1|17" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description` FROM `ps_category_lang` cl WHERE cl.`id_lang` = 1 AND cl.`id_category` = 273 AND cl.id_shop = 1 LIMIT 1 |
0.4 | 1 | /classes/Meta.php:291 | ||
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 * FROM `ps_theme` a WHERE (a.`id_theme` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category WHERE id_category = 273 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 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 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_themeconfigurator` WHERE id_shop = 1 AND id_lang = 1 AND hook = 'left' AND active = 1 ORDER BY item_order ASC |
0.4 | 3 | Yes | /modules/themeconfigurator/themeconfigurator.php:376 | |
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.4 | 1 | /classes/module/Module.php:2568 | ||
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_image_type` |
0.4 | 9 | /classes/ImageType.php:143 | ||
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 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|273|273|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='e87f73d0b061b626a2658ae68d69b740' AND cache_id="blockcontactinfos|1|1|1|17" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10047) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.4 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9946|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT 1 |
0.4 | 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|9950|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9950) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.4 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.4 | 5 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'a232b4580eef6339d8444b58852a2cf5' LIMIT 1 |
0.4 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10044|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9952|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_page_type FROM ps_page_type WHERE name = 'category' LIMIT 1 |
0.4 | 1 | /classes/Page.php:97 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9947 AND id_shop=1 LIMIT 1 |
0.4 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9945|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9945) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.4 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE nleft, nright, level_depth FROM ps_category WHERE id_category = 273 LIMIT 1 |
0.4 | 1 | /classes/Category.php:1485 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '37d5c619acacdc522057df73f7efcdbc' LIMIT 1 |
0.4 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'a232b4580eef6339d8444b58852a2cf5' LIMIT 1 |
0.4 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9953) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.4 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9947|1|1" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='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 * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.4 | 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`='9809e53dfa527993d6871c23a4fc7d29' AND cache_id="blocktopmenu|1|1|1|17|category|273" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9948 AND `id_group` = 1 LIMIT 1 |
0.4 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_category_shop` WHERE `id_category` = 273 AND id_shop = 1 LIMIT 1 |
0.3 | 1 | /classes/ObjectModel.php:1459 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9949) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='42dab2f39a24d3b63c3f2f0acaa84291' AND cache_id="blocksearch-top|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9948|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
DROP TEMPORARY TABLE IF EXISTS ps_cat_restriction |
0.3 | 1 | /modules/blocklayered/blocklayered.php:2125 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|9951|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` = 9950 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|9953|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|9949|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|10045|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0 |
0.3 | 6 | /classes/SpecificPrice.php:238 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='57f0f0439f37dbba347f5892109c3aab' AND cache_id="productlist_colors|10042|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /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 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9947|1|1","", FROM_UNIXTIME(1701306185)) |
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`='005dfe2ddd0b23688bd00b3326fcb853' AND cache_id="blockcms|0|1|1|1|17" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10042) 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_page` FROM `ps_page` WHERE `id_page_type` = 3 AND `id_object` = 273 LIMIT 1 |
0.3 | 1 | /classes/Page.php:77 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9953 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` = 10042 AND id_shop=1 LIMIT 1 |
0.3 | 1 | /classes/Product.php:5034 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT 1 |
0.3 | 1 | /classes/Image.php:470 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9952 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` = 9945 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`='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_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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9949 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` = 9946 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|9954|1|1" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9951 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 = 9947) 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|10047|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9948) 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|9953|1|1","", FROM_UNIXTIME(1701306185)) |
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|10047|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` = 10047 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|9948|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9952|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9952) 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|9949|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9950|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9954|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9945 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` = 10044 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|10045|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10042 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9951 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9946) 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` = 9949 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` = 10045 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 = 9951) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10044) 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` = 9948 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` = 9947 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
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_required_field, object_name, field_name FROM ps_required_field |
0.3 | 1 | /classes/ObjectModel.php:1376 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '9c57142836cb293596f156f93184e0b6' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9950 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '37d5c619acacdc522057df73f7efcdbc' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10045 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|9945|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|9946|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9952 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` = 9953 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 = 10045) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.3 | 1 | /classes/stock/StockAvailable.php:378 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1 |
0.3 | 1 | /classes/Image.php:470 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9954) 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|9951|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '85de7532f1b200cb57c74d47aa194258' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9954 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` = 10044 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` = 9946 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
0.3 | 1 | /override/classes/Hook.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('57f0f0439f37dbba347f5892109c3aab',"productlist_colors|10042|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9945 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` = '0c43eedf0d5a10dbc18a264be1402bf9' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '50b8bdde429fe0688306665b5d7a71ad' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2023-11-30 00:00:00' AND '2023-11-30 23:59:59' LIMIT 1 |
0.3 | 6 | /classes/SpecificPrice.php:305 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '9c57142836cb293596f156f93184e0b6' 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|10044|1|1","", FROM_UNIXTIME(1701306185)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '50b8bdde429fe0688306665b5d7a71ad' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bf5baba682637db3bd78df6e51298364' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
0.3 | 1 | /classes/Group.php:133 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '0c43eedf0d5a10dbc18a264be1402bf9' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = '85de7532f1b200cb57c74d47aa194258' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE data FROM `ps_layered_friendly_url` WHERE `url_key` = 'bf5baba682637db3bd78df6e51298364' LIMIT 1 |
0.3 | 1 | /modules/blocklayered/blocklayered.php:1721 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10047 AND `id_group` = 1 LIMIT 1 |
0.3 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 1 LIMIT 1 |
0.3 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:225 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9954 AND `id_group` = 1 LIMIT 1 |
0.3 | 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)) |
14 | SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
14 | 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 |
14 | 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 |
14 | 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 |
14 | 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 |
14 | 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 |
14 | SELECT data FROM `ps_layered_friendly_url` WHERE `url_key` = XX LIMIT XX |
14 | SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX |
14 | SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
14 | 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) |
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 content FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blockcms|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
2 | SELECT 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 nleft, nright, level_depth FROM ps_category WHERE id_category = XX LIMIT XX |
2 | SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
45 product_shop |
31 product |
22 smarty_lazy_cache |
18 specific_price |
16 product_attribute_shop |
15 feature_lang |
15 stock_available |
15 product_lang |
14 feature_product |
14 feature_value_lang |
14 specific_price_priority |
14 layered_friendly_url |
14 feature_shop |
14 feature |
14 product_group_reduction_cache |
9 category_lang |
9 category |
7 category_shop |
6 lgcookieslaw_lang |
5 module_shop |
5 image_type |
5 module |
4 lang_shop |
4 lang |
4 shop |
4 shop_url |
4 currency_shop |
4 hook |
3 category_product |
3 theme |
3 currency |
2 tax_rule |
2 themeconfigurator |
2 tax_rules_group |
2 smarty_last_flush |
2 layered_category |
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 | 14 | /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/273/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/273/273/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 |