45100 Sonseca
España" target="_blank" rel="noreferrer" href="https://goo.gl/maps/aKWsvUG5QwT2">Ctra. Madrid - Ciudad Real, km 96,9
45100 Sonseca
España
Load Time | 665 ms - Unicorn powered webserver! |
Querying Time | 363 ms |
Queries | 617 |
Memory Peak Usage | 18.7 Mb |
Included Files | 365 files - 8.33 Mb |
PrestaShop Cache | - Mb |
Global vars | 1.52 Mb |
PrestaShop Version | 1.6.1.15 |
PHP Version | 7.1.33 (OK) |
MySQL Version | 5.5.68-MariaDB (Consider upgrading) |
Memory Limit | 1280000M |
Max Execution Time | 600000000s |
Smarty Cache | enabled |
Smarty Compilation | auto |
Time | Cumulated Time | Memory Usage | Memory Peak Usage | |
---|---|---|---|---|
config | 42 ms | 42 ms | 7.33 Mb | 7.44 Mb |
__construct | 0 ms | 42 ms | - Mb | 7.44 Mb |
init | 3 ms | 46 ms | 0.32 Mb | 7.65 Mb |
checkAccess | 0 ms | 46 ms | - Mb | 7.65 Mb |
setMedia | 1 ms | 47 ms | 0.01 Mb | 7.69 Mb |
postProcess | 0 ms | 47 ms | - Mb | 7.69 Mb |
initHeader | 0 ms | 47 ms | - Mb | 7.69 Mb |
initContent | 436 ms | 484 ms | 6.73 Mb | 14.40 Mb |
initFooter | 14 ms | 498 ms | 0.46 Mb | 14.91 Mb |
display | 167 ms | 665 ms | 3.07 Mb | 18.68 Mb |
Hook | Time | Memory Usage |
---|---|---|
hookheader | 36 ms | - Mb |
__construct | 32 ms | 2.00 Mb |
hookdisplayProductOnList | 31 ms | - Mb |
hookdisplayProductListReviews | 31 ms | - Mb |
hookfooter | 12 ms | - Mb |
hookdisplayHeader | 8 ms | - Mb |
hookdisplayProductListFunctionalButtons | 5 ms | - Mb |
hookcalculateGrid | 4 ms | - Mb |
hooktop | 3 ms | - Mb |
hookmaxHeader | 1 ms | - Mb |
hookdisplayTop | 1 ms | - Mb |
hookdisplayNav | 1 ms | - Mb |
hookiqitMobileSearch | 1 ms | - Mb |
hookdisplayFooter | 0 ms | - Mb |
hookmoduleRoutes | - ms | - Mb |
hookiqitMegaMenu | - ms | - Mb |
16 hooks | 167 ms | 2.00 Mb |
Module | Time | Memory Usage |
---|---|---|
attributes | 32 ms | 2.00 Mb |
productcomments | 31 ms | - Mb |
pm_advancedsearch4 | 24 ms | - Mb |
lgmiravia | 16 ms | - Mb |
rcpgtagmanager | 10 ms | - Mb |
themeeditor | 7 ms | - Mb |
facebookpsconnect | 6 ms | - Mb |
blockwishlist | 6 ms | - Mb |
customergroup | 5 ms | - Mb |
lgcookieslaw | 4 ms | - Mb |
blocksearch_mod | 3 ms | - Mb |
iqitmegamenu | 3 ms | - Mb |
blockcart | 2 ms | - Mb |
blockcurrencies | 2 ms | - Mb |
blockcontactinfos | 2 ms | - Mb |
baabandonedcartreminder | 2 ms | - Mb |
redsys | 1 ms | - Mb |
pdfcatalogo | 1 ms | - Mb |
feeder | 1 ms | - Mb |
nxr_product_bestseller | 1 ms | - Mb |
paypalwithfee | 1 ms | - Mb |
blockuserinfo | 1 ms | - Mb |
blocklanguages | 1 ms | - Mb |
pluginadder | 1 ms | - Mb |
glsshipping | 1 ms | - Mb |
blockbanner | 1 ms | - Mb |
blockmyaccount | 1 ms | - Mb |
footercontent | 0 ms | - Mb |
sekeywords | 0 ms | - Mb |
blockmanufacturer | 0 ms | - Mb |
eicaptcha | 0 ms | - Mb |
masbarato | 0 ms | - Mb |
mailalerts | 0 ms | - Mb |
iqitcontentcreator | 0 ms | - Mb |
productsnavpn | 0 ms | - Mb |
crossselling_mod | 0 ms | - Mb |
productsmanufacturer | 0 ms | - Mb |
customcontactpage | 0 ms | - Mb |
38 modules | 167 ms | 2.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, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2024-12-24 00:00:00", INTERVAL 150 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 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` = 5) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 6 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 1920, 24 |
116 | 1944 | /classes/ProductSale.php:140 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
18.4 | 7945 | /classes/SpecificPrice.php:230 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10409|1|5%" |
11.6 | 1 | /classes/SmartyCustom.php:295 | ||
SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1 |
11.3 | 3601 | /classes/ProductSale.php:53 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10399|1|5%" |
10.8 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10277|1|5%" |
10.8 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10280|1|5%" |
10.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10232|1|5%" |
9.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10448|1|5%" |
9.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10330|1|5%" |
9.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10417|1|5%" |
9.1 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10460|1|5%" |
8.8 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10428|1|5%" |
8.8 | 1 | /classes/SmartyCustom.php:295 | ||
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`) |
5.7 | 4360 | /classes/Configuration.php:148 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1 |
4.9 | 15889 | /classes/SpecificPrice.php:230 | ||
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 |
2.3 | 528 | /classes/Hook.php:235 | ||
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10464 ORDER BY f.position ASC |
2 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE MIN(ps_product_comment.id_product_comment) as id_product_comment,ps_product_comment.id_customer,ps_product_comment.id_product,ps_product_comment.content,ps_product_comment.customer_name,ps_product_comment.title,ps_product_comment.grade,ps_image.id_image FROM `ps_product_comment` JOIN ps_customer ON ps_customer.id_customer = ps_product_comment.id_customer JOIN `ps_image` ON ps_product_comment.id_product = ps_image.id_product WHERE ps_product_comment.grade > 3 and ps_customer.id_lang = "5" and firstname not like "%Dario%" GROUP BY ps_product_comment.id_product ORDER BY ps_product_comment.id_product_comment DESC LIMIT 5; |
1.2 | 245 | Yes | /modules/customergroup/customergroup.php:48 | |
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` = 5) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (10464,10460,10456,10448,10447,10444,10429,10428,10417,10409,10405,10401,10399,10374,10366,10361,10347,10330,10280,10277,10274,10234,10232) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1.2 | 31 | Yes | Yes | /classes/Product.php:3464 |
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` |
1.1 | 228 | Yes | Yes | /override/classes/Hook.php:130 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10448) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722377) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.8 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10428 ORDER BY f.position ASC |
0.8 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE id_product_comment,ps_product_comment.id_product,id_customer,title,content,customer_name,grade,validate,date_add,ps_image.id_image FROM `ps_product_comment` JOIN `ps_image` ON ps_product_comment.id_product = ps_image.id_product WHERE id_customer != 6 and grade > 3 and ps_product_comment.id_product != 2129 ORDER BY `id_product_comment` DESC LIMIT 400; |
0.8 | 245 | /modules/customergroup/customergroup.php:55 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722321 LIMIT 1 |
0.7 | 1 | /classes/Combination.php:343 | ||
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.7 | 151 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10429 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.7 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10417) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722321) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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.7 | 151 | /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.7 | 151 | /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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10366 ORDER BY f.position ASC |
0.7 | 4 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10280) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722140) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10374) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722222) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10464) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722393) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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 |
0.6 | 0 | /classes/Hook.php:131 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.6 | 764 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10460) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722389) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|4530363c893a595a479e2cbb02ecbab83b6cbad9|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.6 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10399 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.5 | 2 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10232) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 719260) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10366 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.5 | 1 | Yes | /override/classes/Link.php:19 | |
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.5 | 147 | Yes | /classes/Dispatcher.php:457 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10409) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722301) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10447 ORDER BY f.position ASC |
0.5 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10447) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722373) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10444" AND compile_id="" LIMIT 1 |
0.5 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10444) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722370) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10401) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722288) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10429) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722342) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10399) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722282) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10330) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722122) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10232 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.5 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10405) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722295) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|17bd13b42c3caf48fe32af5633f7f7286de0bb1f|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.5 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10275) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722132) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10274) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722131) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10277) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722137) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10366) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722209) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10361) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722201) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10401 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.5 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10347) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722186) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|11|2fab87b58327be0e9432ad51e82333da4afbb6ea|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.5 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10428) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722341) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10280 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10234) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 719270) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.4 | 6 | Yes | /classes/SpecificPrice.php:362 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10347|1|5","", FROM_UNIXTIME(1735046440)) |
0.4 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 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, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10456) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722385) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-24 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-24 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.4 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10347 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10448 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722393 LIMIT 1 |
0.4 | 1 | /classes/Combination.php:343 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10456|1|5","", FROM_UNIXTIME(1735046440)) |
0.4 | 1 | /classes/SmartyCustom.php:263 | ||
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10234 ORDER BY f.position ASC |
0.4 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10330 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10444 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|51d9ecafa80b62bf28ddcdf4751eb1ad581f481c|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10361 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10399 ORDER BY f.position ASC |
0.4 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10234 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 2 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10417 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
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` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10275 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10409 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 3 | Yes | Yes | /classes/Product.php:2092 |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10347 ORDER BY f.position ASC |
0.4 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10277 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10361 ORDER BY f.position ASC |
0.4 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10464 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10405 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
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 =26 AND m.page = "best-sales" LIMIT 1 |
0.3 | 1 | /classes/Theme.php:275 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10429) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10428 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10374 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10232) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10447 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
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` = 5 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722122 LIMIT 1 |
0.3 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10366 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10405 ORDER BY f.position ASC |
0.3 | 2 | Yes | /classes/Product.php:4452 | |
SHOW COLUMNS FROM `ps_miravia_product_attribute` LIKE 'id_miravia_product_attribute' |
0.3 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2577 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10405) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10444 ORDER BY f.position ASC |
0.3 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10448) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10374|1|5","", FROM_UNIXTIME(1735046440)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10274 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10232 ORDER BY f.position ASC |
0.3 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10428 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.3 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10374" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10417) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.3 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.3 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.3 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10456) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10456 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10401|1|5","", FROM_UNIXTIME(1735046440)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
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` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10464 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:196 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10447|1|5","", FROM_UNIXTIME(1735046440)) |
0.3 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10444) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` 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) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10460 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10447) LIMIT 1 |
0.3 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10409 ORDER BY f.position ASC |
0.3 | 2 | Yes | /classes/Product.php:4452 | |
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.3 | 10 | Yes | /classes/shop/Shop.php:663 | |
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 = 'www.comarfi.com' OR su.domain_ssl = 'www.comarfi.com') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC |
0.3 | 10 | Yes | /classes/shop/Shop.php:334 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10347) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10429|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 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` = 10280) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 6 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.2 | 1 | Yes | /classes/tax/TaxRulesTaxManager.php:108 | |
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` = 10275) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE acg.*, acgl.* FROM `ps_pm_advancedsearch_criterion_group_1` acg LEFT JOIN `ps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 5 ) WHERE acg.`id_search` = 1 ORDER BY `position` |
0.2 | 12 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10447) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10401) LIMIT 1 |
0.2 | 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` = 10274) |
0.2 | 1 | /classes/Product.php:2998 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10234|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10274|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10374) LIMIT 1 |
0.2 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10464" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10460) |
0.2 | 1 | /classes/Product.php:2998 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10274) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10280) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10274) LIMIT 1 |
0.2 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10280|1|5" AND compile_id="" LIMIT 1 |
0.2 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10409) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10280) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10464) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10444|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10277) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10275) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SHOW COLUMNS FROM `ps_miravia_product` LIKE 'has_alert' |
0.2 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2592 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10234) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10460) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10464) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10429 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10417 ORDER BY f.position ASC |
0.2 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10464 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10428) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10330) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10361|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10405|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10460 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10277) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10330 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 1 | /classes/SpecificPrice.php:196 | ||
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` = 10464) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722288 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10444) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10366|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10361) LIMIT 1 |
0.2 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10409|1|5" AND compile_id="" LIMIT 1 |
0.2 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10399) LIMIT 1 |
0.2 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10330 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722341 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10456 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10417|1|5" AND compile_id="" LIMIT 1 |
0.2 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10417) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10232) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10275) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10366) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10330) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10401 ORDER BY f.position ASC |
0.2 | 2 | Yes | /classes/Product.php:4452 | |
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` = 10232) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search` FROM `ps_pm_advancedsearch` ads LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 5 ) WHERE ads.`id_search` = 1 AND `active` = 1 LIMIT 1 |
0.2 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE ps_customer_group.id_group , ps_group_lang.name FROM ps_customer_group LEFT JOIN ps_group_lang ON ps_group_lang.id_group = ps_customer_group.id_group WHERE ps_customer_group.id_customer = '' AND ps_group_lang.id_lang = '5' |
0.2 | 1 | /modules/customergroup/customergroup.php:38 | ||
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` = 10401) |
0.2 | 3 | /classes/Product.php:2998 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10409) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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.2 | 16 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|14|f5483e1fff3cd2c8089021a4f87481b365956f22|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|2e2438d5ff64a0ae8e2f2485af7beacb4099c6c2|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10447|1|5" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10401) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10417) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10401 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search` FROM `ps_pm_advancedsearch` ads JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1) WHERE 1 AND ads.`active`=1 ORDER BY ads.`position` |
0.2 | 1 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10456 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10464|1|5","", FROM_UNIXTIME(1735046440)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10277 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10429) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10429 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10374) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10456) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 29 LIMIT 1 |
0.2 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10347 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 2 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722131 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
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` = 10409) |
0.2 | 3 | /classes/Product.php:2998 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10448) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722222 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10232 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:318 | ||
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` = 10444) |
0.2 | 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` = 10330) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10448 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10399" AND compile_id="" LIMIT 1 |
0.2 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10280" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 62) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10405) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722282 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_fbpsc_connector_position` |
0.2 | 7 | /modules/facebookpsconnect/lib/module-dao_class.php:356 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10274 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10280 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:318 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10234) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10347) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10280 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10460) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10361 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10274 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10234|1|5" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10275 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10361) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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` = 10366) |
0.2 | 1 | /classes/Product.php:2998 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10366) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10361 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10399) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10275 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10444 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
CREATE TABLE IF NOT EXISTS `ps_miravia_manufacturer_data` ( `id_manufacturer` INT(11) NOT NULL, `miravia_name` VARCHAR(128) NOT NULL, `EU_Responsible` VARCHAR(128) NOT NULL, `Manufacturer_info` VARCHAR(128) NOT NULL, PRIMARY KEY (id_manufacturer) ) ENGINE=InnoDB DEFAULT CHARSET=UTF8; |
0.2 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2574 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.2 | 2 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722389 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10374 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10277 ORDER BY f.position ASC |
0.1 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10448|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10428) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10399 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10374 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
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` = 10448) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) 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 = 10374 ORDER BY f.position ASC |
0.1 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10429|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10280 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10417 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10429 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10460 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 28 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
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.1 | 1 | /classes/shop/Shop.php:202 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 719260 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10428|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE required FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10448 AND `id_shop` = 1 |
0.1 | 4 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10277) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 85 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10460 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.1 | 87 | /classes/Hook.php:187 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10366" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10444|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10460" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10447) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10401 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10456 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10275 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
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` = 10234) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10366 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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.1 | 25 | /classes/Language.php:892 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10444 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10464|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|08791267623aeee753db0ce208f1afec8a04c220|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10234 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10274 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722370 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10274" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10447 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE additional FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10428 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10330 AND `id_shop` = 1 |
0.1 | 4 | /Adapter/Adapter_EntityMapper.php:68 | ||
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.1 | 16 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10330 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 2 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10234 AND `id_shop` = 1 |
0.1 | 5 | /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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10361" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10347 AND `id_shop` = 1 |
0.1 | 5 | /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`='906d705b18c1d50c3d702c4fa29a88ed' AND cache_id="blocksearch_mod|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10277 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 6) LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10456|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10405|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10274 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10405 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10275|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 135 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
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.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10277" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search` FROM `ps_pm_advancedsearch` ads LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 5 ) WHERE ads.`id_search` IN (1) ORDER BY ads.`position` |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10374|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_item`,`type` FROM `stories_home` where `active` = 1 ORDER BY `fecha_actualizacion` ASC; |
0.1 | 131 | Yes | /modules/customergroup/customergroup.php:136 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10232" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 6 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.1 | 0 | /classes/tax/TaxRulesTaxManager.php:108 | ||
SELECT SQL_NO_CACHE `id_default_group` FROM `ps_customer` WHERE `id_customer` = 0 LIMIT 1 |
0.1 | 0 | /classes/Customer.php:724 | ||
SELECT SQL_NO_CACHE * FROM ps_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "best-sales" OR m.page = "bestsales" ) AND ml.id_lang = 5 AND ml.id_shop = 1 LIMIT 1 |
0.1 | 2 | /classes/Meta.php:149 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10409 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:95 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 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`='b39c455dbdd27cd3a624c5bbee120b85' AND cache_id="blocksearch_mod|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10399|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10347" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10456|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10234) AND (id_product_attribute = 719271) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10429|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10417" AND compile_id="" LIMIT 1 |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10428" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10417 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10447|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10444|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10448 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10234" AND compile_id="" LIMIT 1 |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10275" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.1 | 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` = 10456) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10447 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 10374) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 22 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|86ada09a3412cec67caf0d3f86b186ed822a3d8f|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10428) |
0.1 | 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` = 10399) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10277|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
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.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10448 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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` = 10429) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10464 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE keyword,contador,results FROM `trending_statssearch` WHERE id_lang = 5 order by contador DESC |
0.1 | 25 | Yes | /modules/customergroup/customergroup.php:97 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10401" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_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 =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 17 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10448" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10405) |
0.1 | 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` = 10361) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1) WHERE c.`active` = 1 LIMIT 1 |
0.1 | 4 | /classes/Currency.php:470 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'en' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10417 AND `id_shop` = 1 |
0.1 | 5 | /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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10374|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10330|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10447 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10401) AND (id_product_attribute = 722289) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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` = 5) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10374 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 80 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 110 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE active FROM `ps_cart_rule` where id_cart_rule = 364 and active = 1 and date_from <= NOW() and date_to >= NOW() order by id_cart_rule DESC limit 1; |
0.1 | 0 | /modules/customergroup/customergroup.php:100 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 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` = 10347) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/shop/ShopUrl.php:169 | ||
SELECT SQL_NO_CACHE * FROM `ps_group_lang` WHERE `id_group` = 1 |
0.1 | 8 | /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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getProductsSearched|60a6c74f94d097f40f362cfed11f281ffdbfb4d5|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10232|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_image_type` |
0.1 | 19 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 135 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10232) AND (id_product_attribute = 719259) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_category FROM `ps_pm_advancedsearch_category` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10448 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10405|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10405 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10460 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722137 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10464) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10409 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypalwithfee" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10366 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "shiptopay" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10274|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10405" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10456) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10274|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10366|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10464|1|5" AND compile_id="" LIMIT 1 |
0.1 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10429" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10232) AND (id_product_attribute = 719261) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10399 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10275) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10460 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT 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 =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10330) AND (id_product_attribute = 722122) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1 |
0.1 | 2 | /classes/shop/Shop.php:1068 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10330" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 120 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722373 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722295 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10444 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkout_klarna" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10456) AND (id_product_attribute = 722385) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10366 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10366) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10409) AND (id_product_attribute = 722302) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10448 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 122 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 523 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
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.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10366 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10232 AND `id_shop` = 1 |
0.1 | 5 | /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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10347|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10409 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10275) AND (id_product_attribute = 722132) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10274 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 25 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 5 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 26) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10401) AND (id_product_attribute = 722290) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722186 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 11 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10280 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10447 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10275 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='b8d72141874b4ab07a0f13e7134f188e' AND cache_id="iqitmegamenu|1|1|1|1|5|1|6|10" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 84 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10277 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10409" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10464 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_currency_shop` WHERE `id_currency` = 1 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE id_category FROM `ps_pm_advancedsearch_products_cat` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10409) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10447" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 92) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10232) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE id_cms FROM `ps_pm_advancedsearch_cms` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10401 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10361 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckout" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 536 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10234 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10232 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10234 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10460|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='3ff7719ba20fdf62fbc6b5297f98a1a2' AND cache_id="blockcontactinfos|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10409 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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.1 | 5 | /classes/Language.php:777 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10275) AND (id_product_attribute = 722133) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722377 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10401|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722342 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10409) AND (id_product_attribute = 722303) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
0.1 | 1 | /classes/Group.php:133 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 124) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 120 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722132 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 111 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10399) AND (id_product_attribute = 722376) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 95) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 29 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1 |
0.1 | 1 | /classes/Image.php:471 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 125) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10401|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10234 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10456" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10460) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10429 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10232 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10401) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722140 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
0.1 | 1 | /override/classes/Hook.php:61 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10409 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10428 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "yotpo" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 80 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10429) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10361|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10460) AND (id_product_attribute = 722389) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10405 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10366) AND (id_product_attribute = 722209) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10280 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10444) AND (id_product_attribute = 722370) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'small_default' LIMIT 1 |
0.1 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10429) AND (id_product_attribute = 722342) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:142 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 375 AND `id_shop` = 1 LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-12-24 00:00:00' AND '2024-12-24 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:302 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10464) AND (id_product_attribute = 722393) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10464 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10447) AND (id_product_attribute = 722373) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10274) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10347 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10448) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10275) AND (id_product_attribute = 722134) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10429 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722385 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722301 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 111 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 10 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 14 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10280) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10417) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10456 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10366|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722209 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 84 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 28 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 19 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722201 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_attribute_group` FROM `ps_attribute_group` WHERE `is_color_group`=1 |
0.1 | 7 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10277) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 17 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 719270 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10401 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10417 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10280) AND (id_product_attribute = 722140) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10447) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 14 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10347|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10330) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10234|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10361|1|5","", FROM_UNIXTIME(1735046440)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_pm_advancedsearch_manufacturers` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 122 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'it' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10374) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 110 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 11 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10448) AND (id_product_attribute = 722377) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10444) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10234) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10409) AND (id_product_attribute = 722301) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10417) AND (id_product_attribute = 722321) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 22 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10374 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10428) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10405) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 19 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 10 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10361) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10399) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 85 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10399 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10456 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10347) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10277) AND (id_product_attribute = 722137) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10274) AND (id_product_attribute = 722131) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-12-24 00:00:00' AND '2024-12-24 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:306 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10275 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 25 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10274 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10444 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10374) AND (id_product_attribute = 722222) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10232 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10405) AND (id_product_attribute = 722295) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10428) AND (id_product_attribute = 722341) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10399 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10277 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10401) AND (id_product_attribute = 722288) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_supplier FROM `ps_pm_advancedsearch_suppliers` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10330 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "supercheckout" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10232) AND (id_product_attribute = 719260) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10347 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE page FROM `ps_pm_advancedsearch_special_pages` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10361) AND (id_product_attribute = 722201) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_product FROM `ps_pm_advancedsearch_products` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10399) AND (id_product_attribute = 722282) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
< 1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10456 AND id_shop=1 LIMIT 1 |
< 1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10361 AND id_shop=1 LIMIT 1 |
< 1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10417 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10347) AND (id_product_attribute = 722186) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
< 1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10460 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10428 AND id_shop=1 LIMIT 1 |
< 1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10234) AND (id_product_attribute = 719270) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
< 1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10401 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10405 AND id_shop=1 LIMIT 1 |
< 1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10280 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
< 1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10374 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10429 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10444 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10275 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 78 AND `id_shop` = 1 LIMIT 1 |
< 1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10447 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10399 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10330 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10277 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10361 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10405 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10347 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10428 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "klarnaofficial" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 |
58 | 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 |
38 | SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX |
26 | INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES (XX,"productlist_colors|XX|XX|XX","", FROM_UNIXTIME(XX)) |
24 | SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX |
24 | SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX |
24 | SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX |
24 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX |
24 | SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC |
24 | SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
24 | SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` IN (XX, XX) AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX |
24 | SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
24 | SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
24 | SELECT id_image FROM ps_image WHERE id_product = XX AND (cover = XX or cover IS NULL) ORDER BY `position` LIMIT XX |
24 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productcomments|XX|XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
24 | SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
24 | SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
24 | SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
11 | SELECT IFNULL( ( SELECT 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 =XX AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =XX LIMIT XX |
11 | SELECT IFNULL( ( SELECT left_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 =XX AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =XX LIMIT XX |
10 | DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%" |
7 | 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 `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
4 | SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX |
3 | SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m |
2 | SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
2 | SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX ORDER BY `name` ASC |
2 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blocksearch_mod|XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
2 | SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX |
2 | SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX |
98 product_shop |
74 product |
74 product_attribute_shop |
71 smarty_lazy_cache |
59 stock_available |
49 product_attribute |
49 product_lang |
47 theme |
45 category_lang |
28 specific_price |
26 image |
26 attribute_group |
25 meta |
25 attribute_lang |
25 product_attribute_combination |
25 attribute |
24 specific_price_priority |
24 attribute_group_lang |
24 feature_product |
24 product_group_reduction_cache |
24 feature_value_lang |
24 feature |
24 feature_shop |
24 feature_lang |
23 theme_meta |
18 module |
9 module_shop |
8 lang |
7 category_shop |
7 category |
5 lang_shop |
5 shop |
5 currency_shop |
5 lgcookieslaw_lang |
4 cms |
4 cms_lang |
4 cms_shop |
4 shop_url |
4 currency |
4 hook |
3 pm_advancedsearch |
3 image_type |
3 tax_rule |
2 product_comment |
2 product_sale |
2 meta_lang |
2 group_shop |
2 tax |
2 shop_group |
2 tax_rules_group |
2 group_lang |
2 smarty_last_flush |
2 country |
2 configuration |
2 hook_alias |
2 group |
2 customer |
2 hook_module |
2 pm_advancedsearch_lang |
2 country_shop |
2 country_lang |
1 miravia_product_attribute |
1 configuration_lang |
1 miravia_product |
1 tax_lang |
1 lgcookieslaw |
1 module_group |
1 cart_rule |
1 category_group |
1 pm_advancedsearch_special_pages |
1 pm_advancedsearch_shop |
1 pm_advancedsearch_category |
1 pm_advancedsearch_products_cat |
1 pm_advancedsearch_suppliers |
1 pm_advancedsearch_manufacturers |
1 pm_advancedsearch_products |
1 pm_advancedsearch_criterion_group_1 |
1 category_product |
1 pm_advancedsearch_criterion_group_1_lang |
1 customer_group |
1 fbpsc_connector_position |
1 hook_module_exceptions |
1 image_shop |
1 image_lang |
1 manufacturer |
1 pm_advancedsearch_cms |
Name | Instances | Source |
---|---|---|
Product | 48 | /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] |
Category | 15 | /modules/customergroup/customergroup.php [59] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] |
CMS | 7 | /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] |
Language | 3 | /config/config.inc.php [195] /classes/Tools.php [564] /classes/Tools.php [498] |
Country | 2 | /config/config.inc.php [142] /classes/controller/FrontController.php [279] |
Group | 2 | /classes/Cart.php [184] /modules/customergroup/customergroup.php [42] |
Address | 2 | /classes/Product.php [2937] /classes/Product.php [4404] |
Shop | 1 | /config/config.inc.php [114] |
Theme | 1 | /config/config.inc.php [115] |
ShopGroup | 1 | /classes/shop/Shop.php [518] |
Customer | 1 | /config/config.inc.php [221] |
Currency | 1 | /classes/Tools.php [615] |
Cart | 1 | /classes/controller/FrontController.php [348] |
Tax | 1 | /classes/tax/TaxRulesTaxManager.php [115] |
# | 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 | /classes/Validate.php |
23 | /classes/cache/Cache.php |
24 | /Adapter/Adapter_EntityMapper.php |
25 | /classes/db/DbQuery.php |
26 | /classes/Theme.php |
27 | /config/defines_uri.inc.php |
28 | /tools/htmlpurifier/HTMLPurifier.standalone.php |
29 | /classes/Language.php |
30 | /classes/Country.php |
31 | /classes/PrestaShopCollection.php |
32 | /classes/shop/ShopGroup.php |
33 | /classes/Cookie.php |
34 | /classes/Blowfish.php |
35 | /config/smarty.config.inc.php |
36 | /tools/smarty/Smarty.class.php |
37 | /tools/smarty/sysplugins/smarty_internal_data.php |
38 | /tools/smarty/sysplugins/smarty_internal_templatebase.php |
39 | /tools/smarty/sysplugins/smarty_internal_template.php |
40 | /tools/smarty/sysplugins/smarty_resource.php |
41 | /tools/smarty/sysplugins/smarty_internal_resource_file.php |
42 | /tools/smarty/sysplugins/smarty_cacheresource.php |
43 | /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php |
44 | /classes/SmartyCustom.php |
45 | /config/smartyfront.config.inc.php |
46 | /classes/Customer.php |
47 | /classes/Group.php |
48 | /classes/Link.php |
49 | /override/classes/Link.php |
50 | /classes/shop/ShopUrl.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/pm_advancedsearch4/pm_advancedsearch4.php |
58 | /modules/pm_advancedsearch4/classes/LinkPM.php |
59 | /modules/pm_advancedsearch4/classes/As4SearchEngineLogger.php |
60 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php |
61 | /modules/pm_advancedsearch4/classes/As4SearchEngine.php |
62 | /modules/pm_advancedsearch4/classes/As4SearchEngineIndexation.php |
63 | /modules/pm_advancedsearch4/classes/As4SearchEngineSeo.php |
64 | /modules/pm_advancedsearch4/classes/AdvancedSearchClass.php |
65 | /modules/pm_advancedsearch4/classes/AdvancedSearchCriterionGroupClass.php |
66 | /modules/pm_advancedsearch4/classes/AdvancedSearchCriterionClass.php |
67 | /modules/pm_advancedsearch4/classes/AdvancedSearchSeoClass.php |
68 | /modules/pm_advancedsearch4/AdvancedSearchCoreClass.php |
69 | /modules/pm_advancedsearch4/classes/AdvancedSearchWidgetProxy.php |
70 | /modules/lgmiravia/lgmiravia.php |
71 | /modules/lgmiravia/classes/MiraviaConf.php |
72 | /modules/lgmiravia/classes/MiraviaLicense.php |
73 | /modules/lgmiravia/classes/MiraviaApi.php |
74 | /modules/lgmiravia/classes/apiMiravia/IopSdk.php |
75 | /modules/lgmiravia/classes/apiMiravia/MiraviaAutoloader.php |
76 | /modules/lgmiravia/classes/MiraviaContent.php |
77 | /modules/lgmiravia/classes/MiraviaError.php |
78 | /modules/lgmiravia/classes/MiraviaRequestLog.php |
79 | /modules/lgmiravia/classes/MiraviaCategory.php |
80 | /modules/lgmiravia/classes/MiraviaCategoryRelation.php |
81 | /modules/lgmiravia/classes/MiraviaCarrier.php |
82 | /modules/lgmiravia/classes/MiraviaProduct.php |
83 | /modules/lgmiravia/classes/MiraviaProductCombination.php |
84 | /modules/lgmiravia/classes/MiraviaProperties.php |
85 | /modules/lgmiravia/classes/MiraviaAttribute.php |
86 | /modules/lgmiravia/classes/MiraviaFeature.php |
87 | /modules/lgmiravia/classes/MiraviaOrder.php |
88 | /modules/lgmiravia/classes/MiraviaValidate.php |
89 | /modules/lgmiravia/classes/MiraviaImage.php |
90 | /modules/lgmiravia/classes/MiraviaFeed.php |
91 | /modules/lgmiravia/classes/MiraviaReport.php |
92 | /modules/lgmiravia/classes/MiraviaRate.php |
93 | /modules/lgmiravia/classes/MiraviaTools.php |
94 | /modules/lgmiravia/classes/MiraviaExtras.php |
95 | /classes/Translate.php |
96 | /modules/lgmiravia/translations/fr.php |
97 | /controllers/front/BestSalesController.php |
98 | /classes/controller/FrontController.php |
99 | /themes/warehouse/lang/fr.php |
100 | /classes/Currency.php |
101 | /classes/Cart.php |
102 | /classes/CartRule.php |
103 | /classes/Meta.php |
104 | /classes/Product.php |
105 | /classes/webservice/WebserviceRequest.php |
106 | /override/classes/webservice/WebserviceRequest.php |
107 | /modules/cedconnector/classes/WebserviceSpecificManagementCedproducts.php |
108 | /modules/cedconnector/classes/CedPrepareProducts.php |
109 | /modules/cedconnector/classes/cedconnector.class.helper.php |
110 | /classes/webservice/WebserviceSpecificManagementInterface.php |
111 | /modules/cedconnector/classes/WebserviceSpecificManagementCedShipping.php |
112 | /modules/cedconnector/classes/WebserviceSpecificManagementCedCurrency.php |
113 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderStatus.php |
114 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderCreate.php |
115 | /modules/cedconnector/classes/cedconnector.class.order.import.php |
116 | /modules/cedconnector/classes/WebserviceSpecificManagementCedAttribute.php |
117 | /modules/cedconnector/classes/WebserviceSpecificManagementCedNestedCategories.php |
118 | /modules/cedconnector/classes/WebserviceSpecificManagementCedFeatures.php |
119 | /modules/cedconnector/classes/WebserviceSpecificManagementCedUpdateStock.php |
120 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderDetails.php |
121 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderUpdate.php |
122 | /modules/cedconnector/classes/WebserviceSpecificManagementCedExecuteQuery.php |
123 | /modules/cedconnector/classes/WebserviceSpecificManagementCedStockSync.php |
124 | /classes/Media.php |
125 | /modules/blockcurrencies/blockcurrencies.php |
126 | /themes/warehouse/modules/blockcurrencies/translations/fr.php |
127 | /modules/blockcurrencies/translations/fr.php |
128 | /modules/blocklanguages/blocklanguages.php |
129 | /themes/warehouse/modules/blocklanguages/translations/fr.php |
130 | /modules/blocklanguages/translations/fr.php |
131 | /modules/blockmanufacturer/blockmanufacturer.php |
132 | /themes/warehouse/modules/blockmanufacturer/translations/fr.php |
133 | /modules/blockmanufacturer/translations/fr.php |
134 | /modules/blockmyaccount/blockmyaccount.php |
135 | /themes/warehouse/modules/blockmyaccount/translations/fr.php |
136 | /modules/blockmyaccount/translations/fr.php |
137 | /modules/feeder/feeder.php |
138 | /themes/warehouse/modules/feeder/translations/fr.php |
139 | /modules/feeder/translations/fr.php |
140 | /cache/smarty/compile/da/a5/80/daa5801dba03ca6be725f91e8e03207dbdbcfced.file.feederHeader.tpl.php |
141 | /tools/smarty/sysplugins/smarty_internal_filter_handler.php |
142 | /tools/minify_html/minify_html.class.php |
143 | /modules/blockuserinfo/blockuserinfo.php |
144 | /themes/warehouse/modules/blockuserinfo/translations/fr.php |
145 | /modules/blockuserinfo/translations/fr.php |
146 | /modules/productcomments/productcomments.php |
147 | /themes/warehouse/modules/productcomments/translations/fr.php |
148 | /modules/productcomments/translations/fr.php |
149 | /modules/blockcontactinfos/blockcontactinfos.php |
150 | /themes/warehouse/modules/blockcontactinfos/translations/fr.php |
151 | /modules/blockcontactinfos/translations/fr.php |
152 | /modules/productsnavpn/productsnavpn.php |
153 | /themes/warehouse/modules/productsnavpn/translations/fr.php |
154 | /modules/customcontactpage/customcontactpage.php |
155 | /themes/warehouse/modules/customcontactpage/translations/fr.php |
156 | /modules/blockwishlist/blockwishlist.php |
157 | /modules/blockwishlist/WishList.php |
158 | /themes/warehouse/modules/blockwishlist/translations/fr.php |
159 | /modules/blockwishlist/translations/fr.php |
160 | /modules/productsmanufacturer/productsmanufacturer.php |
161 | /themes/warehouse/modules/productsmanufacturer/translations/fr.php |
162 | /modules/footercontent/footercontent.php |
163 | /themes/warehouse/modules/footercontent/translations/fr.php |
164 | /modules/footercontent/HtmlFooterContent.php |
165 | /modules/mailalerts/mailalerts.php |
166 | /modules/mailalerts/MailAlert.php |
167 | /themes/warehouse/modules/mailalerts/translations/fr.php |
168 | /modules/mailalerts/translations/fr.php |
169 | /modules/crossselling_mod/crossselling_mod.php |
170 | /themes/warehouse/modules/crossselling_mod/translations/fr.php |
171 | /modules/pluginadder/pluginadder.php |
172 | /themes/warehouse/modules/pluginadder/translations/fr.php |
173 | /modules/blockcart/blockcart.php |
174 | /themes/warehouse/modules/blockcart/translations/fr.php |
175 | /modules/blocksearch_mod/blocksearch_mod.php |
176 | /themes/warehouse/modules/blocksearch_mod/translations/fr.php |
177 | /modules/blocksearch_mod/translations/fr.php |
178 | /cache/smarty/compile/32/38/0c/32380c944294386a2da475bb5223e2456c9b9a14.file.blocksearch_modh.tpl.php |
179 | /modules/themeeditor/themeeditor.php |
180 | /themes/warehouse/modules/themeeditor/translations/fr.php |
181 | /classes/Image.php |
182 | /modules/iqitmegamenu/iqitmegamenu.php |
183 | /modules/iqitmegamenu/models/IqitMenuTab.php |
184 | /modules/iqitmegamenu/models/IqitMenuHtml.php |
185 | /modules/iqitmegamenu/models/IqitMenuLinks.php |
186 | /themes/warehouse/modules/iqitmegamenu/translations/fr.php |
187 | /modules/pdfcatalogo/pdfcatalogo.php |
188 | /modules/pdfcatalogo/PdfCatalogoHelper.php |
189 | /themes/warehouse/modules/pdfcatalogo/translations/fr.php |
190 | /modules/baabandonedcartreminder/baabandonedcartreminder.php |
191 | /init.php |
192 | /themes/warehouse/modules/baabandonedcartreminder/translations/fr.php |
193 | /modules/customergroup/customergroup.php |
194 | /themes/warehouse/modules/customergroup/translations/fr.php |
195 | /classes/Category.php |
196 | /modules/masbarato/masbarato.php |
197 | /themes/warehouse/modules/masbarato/translations/fr.php |
198 | /modules/masbarato/translations/fr.php |
199 | /modules/eicaptcha/eicaptcha.php |
200 | /themes/warehouse/modules/eicaptcha/translations/fr.php |
201 | /modules/eicaptcha/translations/fr.php |
202 | /modules/rcpgtagmanager/rcpgtagmanager.php |
203 | /modules/rcpgtagmanager/vendor/autoload.php |
204 | /modules/rcpgtagmanager/vendor/composer/autoload_real.php |
205 | /modules/rcpgtagmanager/vendor/composer/ClassLoader.php |
206 | /modules/rcpgtagmanager/vendor/composer/autoload_namespaces.php |
207 | /modules/rcpgtagmanager/vendor/composer/autoload_psr4.php |
208 | /modules/rcpgtagmanager/vendor/composer/autoload_classmap.php |
209 | /themes/warehouse/modules/rcpgtagmanager/translations/fr.php |
210 | /modules/rcpgtagmanager/translations/fr.php |
211 | /modules/rcpgtagmanager/src/rcpgtagmanagertools.php |
212 | /cache/smarty/compile/8e/2d/2e/8e2d2eb1ffcf45aa672c8bba53c3e2aeb20a1706.file.header.tpl.php |
213 | /themes/warehouse/modules/pm_advancedsearch4/translations/fr.php |
214 | /modules/pm_advancedsearch4/translations/fr.php |
215 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/6/08791267623aeee753db0ce208f1afec8a04c220/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
216 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/7/4530363c893a595a479e2cbb02ecbab83b6cbad9/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
217 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/9/86ada09a3412cec67caf0d3f86b186ed822a3d8f/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
218 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/10/51d9ecafa80b62bf28ddcdf4751eb1ad581f481c/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
219 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getPriceRangeForSearchBloc/11/2fab87b58327be0e9432ad51e82333da4afbb6ea/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
220 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/14/f5483e1fff3cd2c8089021a4f87481b365956f22/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
221 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/12/17bd13b42c3caf48fe32af5633f7f7286de0bb1f/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
222 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/13/2e2438d5ff64a0ae8e2f2485af7beacb4099c6c2/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
223 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getProductsSearched/60a6c74f94d097f40f362cfed11f281ffdbfb4d5/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
224 | /cache/smarty/compile/62/65/7b/62657b649dad20c337ed10f06ea424d307592ece.file.pm_advancedsearch.tpl.php |
225 | /cache/smarty/compile/e3/b2/bd/e3b2bd4d773742a3894ed967b7d3362b1fcc8164.file.pm_advancedsearch_header_block.tpl.php |
226 | /cache/smarty/compile/50/e6/82/50e6826bf54f7600a537120ec1ff7b2c78d146d2.file.pm_advancedsearch_criterions.tpl.php |
227 | /cache/smarty/compile/4a/92/ec/4a92ecf704a311daf8563e8bc2575a6ecbb20297.file.pm_advancedsearch_criterions_select.tpl.php |
228 | /cache/smarty/compile/d5/6f/3a/d56f3a28ce1edd1b98fca644b2c50b9183a30f77.file.pm_advancedsearch_criterions_range.tpl.php |
229 | /cache/smarty/compile/41/73/34/417334e0fdbba2184dcf050ffd2df2f2d6143804.file.pm_advancedsearch_footer_block.tpl.php |
230 | /tools/js_minify/jsmin.php |
231 | /modules/facebookpsconnect/facebookpsconnect.php |
232 | /modules/facebookpsconnect/conf/common.conf.php |
233 | /modules/facebookpsconnect/lib/warning_class.php |
234 | /modules/facebookpsconnect/lib/module-tools_class.php |
235 | /themes/warehouse/modules/facebookpsconnect/translations/fr.php |
236 | /modules/facebookpsconnect/fr.php |
237 | /modules/facebookpsconnect/conf/hook.conf.php |
238 | /modules/facebookpsconnect/lib/hook/hook-ctrl_class.php |
239 | /modules/facebookpsconnect/lib/hook/i-hook_class.php |
240 | /modules/facebookpsconnect/lib/hook/hook-display_class.php |
241 | /modules/facebookpsconnect/lib/module-dao_class.php |
242 | /modules/facebookpsconnect/lib/render/facade-render-connectors_class.php |
243 | /modules/facebookpsconnect/lib/render/render-connectors_class.php |
244 | /cache/smarty/compile/e7/66/db/e766db28fdf284b55b8a9087321ddfb532a72173.file.header.tpl.php |
245 | /modules/blockbanner/blockbanner.php |
246 | /themes/warehouse/modules/blockbanner/translations/fr.php |
247 | /modules/blockbanner/translations/fr.php |
248 | /modules/nxr_product_bestseller/nxr_product_bestseller.php |
249 | /themes/warehouse/modules/nxr_product_bestseller/translations/fr.php |
250 | /modules/paypalwithfee/paypalwithfee.php |
251 | /modules/paypalwithfee/classes/PaypalOrder.php |
252 | /modules/paypalwithfee/classes/PaypalRefund.php |
253 | /classes/PaymentModule.php |
254 | /themes/warehouse/modules/paypalwithfee/translations/fr.php |
255 | /modules/paypalwithfee/translations/fr.php |
256 | /modules/lgcookieslaw/lgcookieslaw.php |
257 | /themes/warehouse/modules/lgcookieslaw/translations/fr.php |
258 | /modules/lgcookieslaw/translations/fr.php |
259 | /modules/glsshipping/glsshipping.php |
260 | /modules/glsshipping/classes/GlsshippingUpdate.php |
261 | /classes/module/CarrierModule.php |
262 | /classes/log/FileLogger.php |
263 | /classes/log/AbstractLogger.php |
264 | /themes/warehouse/modules/glsshipping/translations/fr.php |
265 | /modules/redsys/redsys.php |
266 | /modules/redsys/api/apiRedsys.php |
267 | /modules/redsys/api/json.php |
268 | /modules/redsys/api/hmac.php |
269 | /modules/redsys/api/hash.php |
270 | /modules/redsys/api/idnovateUtils.php |
271 | /modules/redsys/classes/RedsysTpv.php |
272 | /themes/warehouse/modules/redsys/translations/fr.php |
273 | /modules/iqitcontentcreator/iqitcontentcreator.php |
274 | /modules/iqitcontentcreator/models/IqitCreatorHtml.php |
275 | /themes/warehouse/modules/iqitcontentcreator/translations/fr.php |
276 | /modules/sekeywords/sekeywords.php |
277 | /classes/module/ModuleGraph.php |
278 | /themes/warehouse/modules/sekeywords/translations/fr.php |
279 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/5/1/6/ce/2c/27/ce2c27172c7a4e41ad12781dd622db414db40db1.blocksearch-top_mod.tpl.php |
280 | /cache/smarty/compile/12/ae/c7/12aec79669229e021da11d18ac3ec280dcc2baf1.file.blockuserinfo.tpl.php |
281 | /Adapter/Adapter_AddressFactory.php |
282 | /Adapter/Adapter_ProductPriceCalculator.php |
283 | /Adapter/Adapter_Configuration.php |
284 | /Core/Business/Core_Business_ConfigurationInterface.php |
285 | /classes/Customization.php |
286 | /cache/smarty/compile/72/7e/d5/727ed5f4a47097d819d3f831aedb113965e921cd.file.blockcart.tpl.php |
287 | /tools/smarty/plugins/modifier.replace.php |
288 | /tools/smarty/plugins/function.counter.php |
289 | /cache/smarty/compile/c8/56/86/c85686185a917643f4b42c2b4c967c34304d3b45.file.blockwishlist_top.tpl.php |
290 | /modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php |
291 | /cache/smarty/compile/3d/4d/92/3d4d923a54aa229deb1614884366255dae01e77d.file.connector-buttons-js.tpl.php |
292 | /classes/ProductSale.php |
293 | /classes/Combination.php |
294 | /classes/stock/StockAvailable.php |
295 | /classes/tax/Tax.php |
296 | /classes/Address.php |
297 | /classes/SpecificPrice.php |
298 | /classes/tax/TaxManagerFactory.php |
299 | /classes/tax/TaxRulesTaxManager.php |
300 | /classes/tax/TaxManagerInterface.php |
301 | /classes/tax/TaxCalculator.php |
302 | /classes/GroupReduction.php |
303 | /classes/Feature.php |
304 | /cache/smarty/cache/productlist_colors/10275/1/5/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
305 | /cache/smarty/compile/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.file.product-list-colors.tpl.cache.php |
306 | /tools/smarty/sysplugins/smarty_internal_write_file.php |
307 | /classes/ImageType.php |
308 | /cache/smarty/cache/blockcontactinfos/1/1/1/1/5/1/6/bc/3e/6f/bc3e6f0d6bd38ec8a7c392752be20f0eeeb06022.blockcontactinfos.tpl.php |
309 | /cache/smarty/compile/95/61/a1/9561a1e14f547cf63206a2dfa3bf581a775df28f.file.footer.tpl.php |
310 | /classes/CMS.php |
311 | /cache/smarty/compile/7a/c4/e0/7ac4e0fd50add7456c47f0e68531425ef3787f20.file.cookieslaw.tpl.php |
312 | /cache/smarty/compile/40/3d/71/403d71a762947f16a7fb708839cd0d533130111f.file.best-sales.tpl.php |
313 | /cache/smarty/compile/4d/78/46/4d7846777d384bb54495bfdb53cdda08bfa9a66b.file.product-sort.tpl.php |
314 | /cache/smarty/compile/19/e8/0c/19e80caf79a50922b6bf78fd9404185cc9ffee17.file.nbr-product-page.tpl.php |
315 | /cache/smarty/compile/6d/1f/52/6d1f52f3906b603c4bb386ed9a01c576f34b5006.file.pagination.tpl.php |
316 | /cache/smarty/compile/84/33/2c/84332cd8dc3b11b7526c3c542137e3fb30374436.file.product-list.tpl.php |
317 | /tools/smarty/plugins/function.math.php |
318 | /cache/smarty/compile/3c/16/62/3c1662553ab7198b9693ba318f146941c0624bc0.file.blockwishlist_button.tpl.php |
319 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10464/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
320 | /modules/attributes/attributes.php |
321 | /themes/warehouse/modules/attributes/translations/fr.php |
322 | /cache/smarty/compile/52/f0/1e/52f01e3a52fd9c7b842f598556a9af2e6c64a60d.file.combinations.tpl.php |
323 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10460/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
324 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10456/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
325 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10448/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
326 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10447/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
327 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10444/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
328 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10429/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
329 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10428/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
330 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10417/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
331 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10409/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
332 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10405/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
333 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10401/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
334 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10399/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
335 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10374/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
336 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10366/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
337 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10361/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
338 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10347/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
339 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10330/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
340 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10280/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
341 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10277/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
342 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10275/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
343 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10274/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
344 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10234/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
345 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10232/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
346 | /cache/smarty/compile/53/1d/43/531d43d333f323e579e1f876532a548044dc298f.file.layout.tpl.php |
347 | /cache/smarty/compile/4a/35/98/4a3598bffa820b6b0d5494707365394e96698ac9.file.header.tpl.php |
348 | /tools/smarty/plugins/function.implode.php |
349 | /cache/smarty/compile/3c/6c/34/3c6c34e1cac2e2861343e8e60925e1dfb9d27f2e.file.global.tpl.php |
350 | /cache/smarty/compile/58/63/a4/5863a4956e9578fe17f1584ec77fa232640fdacd.file.blockcurrencies.tpl.php |
351 | /cache/smarty/compile/9c/3f/72/9c3f72fbff97ede10bfca51a951faf01955cc06d.file.blocklanguages.tpl.php |
352 | /tools/smarty/plugins/modifier.regex_replace.php |
353 | /cache/smarty/compile/52/e1/45/52e145a3af78feaf349d33da9ab1c5aa33c7c596.file.mobile-header1.tpl.php |
354 | /cache/smarty/compile/02/8c/16/028c16af65e4de77ec1985877c23c0db654e709b.file.mobile-user.tpl.php |
355 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/5/1/6/8e/c1/db/8ec1dbda411bcdd440fc29d6b6783fe94fe76a08.blocksearch-mobile.tpl.php |
356 | /cache/smarty/cache/iqitmegamenu/1/1/1/1/5/1/6/10/41/f0/34/41f034112f7eceb4890d132af08ee3198f1d6bef.iqitmegamenu.tpl.php |
357 | /cache/smarty/compile/e5/58/f6/e558f6c22cf7f00714cabf72ab8862c3ac4263ff.file.breadcrumb.tpl.php |
358 | /cache/smarty/compile/82/97/9c/82979c59cc436fcbe825fac6cbe7769592ce500f.file.footer.tpl.php |
359 | /tools/smarty/plugins/modifier.date_format.php |
360 | /tools/smarty/plugins/shared.mb_str_replace.php |
361 | /cache/smarty/compile/42/2e/17/422e17da2efcc7a9532d918d2efb5a17d931bec9.file.javascript.tpl.php |