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 | 868 ms - OK... for a shared hosting |
Querying Time | 546 ms |
Queries | 599 |
Memory Peak Usage | 18.4 Mb |
Included Files | 366 files - 8.11 Mb |
PrestaShop Cache | - Mb |
Global vars | 1.13 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 | 59 ms | 59 ms | 7.29 Mb | 7.40 Mb |
__construct | 0 ms | 59 ms | - Mb | 7.40 Mb |
init | 4 ms | 63 ms | 0.32 Mb | 7.61 Mb |
checkAccess | 0 ms | 63 ms | - Mb | 7.61 Mb |
setMedia | 2 ms | 65 ms | 0.01 Mb | 7.65 Mb |
postProcess | 0 ms | 65 ms | - Mb | 7.65 Mb |
initHeader | 0 ms | 65 ms | - Mb | 7.65 Mb |
initContent | 633 ms | 698 ms | 6.79 Mb | 14.42 Mb |
initFooter | 15 ms | 713 ms | 0.23 Mb | 14.70 Mb |
display | 155 ms | 868 ms | 3.09 Mb | 18.43 Mb |
Hook | Time | Memory Usage |
---|---|---|
hookheader | 42 ms | - Mb |
__construct | 42 ms | - Mb |
hookdisplayProductOnList | 30 ms | 2.00 Mb |
hookdisplayProductListReviews | 29 ms | - Mb |
hookfooter | 13 ms | - Mb |
hookdisplayHeader | 10 ms | - Mb |
hookdisplayProductListFunctionalButtons | 5 ms | - Mb |
hookcalculateGrid | 4 ms | - Mb |
hooktop | 4 ms | - Mb |
hookdisplayTop | 2 ms | - Mb |
hookmaxHeader | 1 ms | 2.00 Mb |
hookiqitMobileSearch | 1 ms | - Mb |
hookdisplayNav | 1 ms | - Mb |
hookdisplayFooter | 0 ms | - Mb |
hookmoduleRoutes | - ms | - Mb |
hookiqitMegaMenu | - ms | - Mb |
16 hooks | 186 ms | 4.00 Mb |
Module | Time | Memory Usage |
---|---|---|
pm_advancedsearch4 | 31 ms | - Mb |
attributes | 30 ms | 2.00 Mb |
productcomments | 30 ms | - Mb |
lgmiravia | 23 ms | - Mb |
rcpgtagmanager | 11 ms | - Mb |
facebookpsconnect | 9 ms | - Mb |
themeeditor | 7 ms | - Mb |
customergroup | 6 ms | - Mb |
blockwishlist | 6 ms | - Mb |
lgcookieslaw | 4 ms | - Mb |
blocksearch_mod | 4 ms | - Mb |
blockcart | 3 ms | - Mb |
iqitmegamenu | 3 ms | 2.00 Mb |
pdfcatalogo | 2 ms | - Mb |
blockcurrencies | 2 ms | - Mb |
blockcontactinfos | 2 ms | - Mb |
baabandonedcartreminder | 2 ms | - Mb |
redsys | 1 ms | - Mb |
feeder | 1 ms | - Mb |
blocklanguages | 1 ms | - Mb |
blockuserinfo | 1 ms | - Mb |
pluginadder | 1 ms | - Mb |
paypalwithfee | 1 ms | - Mb |
nxr_product_bestseller | 1 ms | - Mb |
footercontent | 1 ms | - Mb |
glsshipping | 1 ms | - Mb |
blockbanner | 1 ms | - Mb |
iqitcontentcreator | 0 ms | - Mb |
blockmanufacturer | 0 ms | - Mb |
sekeywords | 0 ms | - Mb |
blockmyaccount | 0 ms | - Mb |
masbarato | 0 ms | - Mb |
productsnavpn | 0 ms | - Mb |
mailalerts | 0 ms | - Mb |
productsmanufacturer | 0 ms | - Mb |
customcontactpage | 0 ms | - Mb |
eicaptcha | 0 ms | - Mb |
crossselling_mod | 0 ms | - Mb |
38 modules | 186 ms | 4.00 Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1 |
75.5 | 8567 | /classes/SpecificPrice.php:230 | ||
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-22 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` = 8 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` = 8) 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 1272, 24 |
60.9 | 1296 | /classes/ProductSale.php:140 | ||
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 |
43.2 | 3601 | /classes/ProductSale.php:53 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
34 | 5712 | /classes/SpecificPrice.php:230 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5616|1|8%" |
20.1 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5568|1|8%" |
19.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|4678|1|8%" |
17.1 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|1919|1|8%" |
15.5 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5047|1|8%" |
15.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|1907|1|8%" |
15.3 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|4773|1|8%" |
15.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5499|1|8%" |
13.8 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5359|1|8%" |
11.9 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5348|1|8%" |
10.9 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5100|1|8%" |
10.7 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|4676|1|8%" |
10.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|2108|1|8%" |
10.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|1850|1|8%" |
10 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|5502|1|8%" |
9.9 | 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`) |
6.3 | 3997 | /classes/Configuration.php:148 | ||
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 |
5.5 | 528 | /classes/Hook.php:235 | ||
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` |
4.8 | 228 | Yes | Yes | /override/classes/Hook.php:130 |
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 |
2.6 | 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 |
1.3 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5616 ORDER BY f.position ASC |
1.1 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 1919 ORDER BY f.position ASC |
1.1 | 4 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5359 ORDER BY f.position ASC |
1.1 | 3 | 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 = "8" and firstname not like "%Dario%" GROUP BY ps_product_comment.id_product ORDER BY ps_product_comment.id_product_comment DESC LIMIT 5; |
1.1 | 337 | Yes | /modules/customergroup/customergroup.php:48 | |
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, 5422) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5924) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 |
1 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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` = 8) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (5616,5568,5502,5499,5492,5359,5348,5100,5047,4773,4732,4678,4676,4634,2108,1919,1907,1850,1703) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
1 | 28 | Yes | Yes | /classes/Product.php:3464 |
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, 5616) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6229) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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.9 | 6 | Yes | /classes/SpecificPrice.php:362 | |
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.9 | 337 | /modules/customergroup/customergroup.php:55 | ||
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, 5348) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5824) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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.9 | 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.8 | 151 | /classes/module/Module.php:277 | ||
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, 5614) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6227) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 1703) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 720) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5564) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6133) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 `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.7 | 0 | /classes/Hook.php:131 | ||
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, 5013) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5262) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5568) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6160) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5502) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6036) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 4773) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4656) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5499) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6033) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5047) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5312) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 *, ( 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, 5025) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5286) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 4634) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4287) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 5492) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6024) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 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.6 | 147 | Yes | /classes/Dispatcher.php:457 | |
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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 1703 ORDER BY f.position ASC |
0.6 | 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, 1907) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 2423) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 1850) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 1987) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5359 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.6 | 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, 5100) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5367) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 2108) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 1756) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 1919) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 2383) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 4678 ORDER BY f.position ASC |
0.6 | 4 | Yes | /classes/Product.php:4452 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|4634|1|8","", FROM_UNIXTIME(1734893772)) |
0.5 | 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, 5359) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 5842) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 2108) AND (id_product_attribute = 1756) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.5 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5568 ORDER BY f.position ASC |
0.5 | 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, 4678) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4663) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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, 4732) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4575) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1919 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.5 | 714 | /classes/module/Module.php:2141 | ||
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.5 | 1 | /classes/Theme.php:301 | ||
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 4634 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 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 4676 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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 2108 ORDER BY f.position ASC |
0.5 | 5 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5100 AND `id_shop` = 1 |
0.5 | 8 | /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` = 6160 LIMIT 1 |
0.5 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5359 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.5 | 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` = 5568) |
0.5 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 1907 ORDER BY f.position ASC |
0.4 | 4 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 4773 ORDER BY f.position ASC |
0.4 | 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, 4676) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4793) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-22 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 4678 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5499 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5616 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 1907 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 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|8|1|6|4773" AND compile_id="" LIMIT 1 |
0.4 | 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5348) 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5492 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 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` = 1987 LIMIT 1 |
0.4 | 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|8|1|6|4732" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|8|1|6|2108" AND compile_id="" LIMIT 1 |
0.4 | 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.4 | 1 | /classes/Theme.php:318 | ||
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 1703 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_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8 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.4 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5047 AND `id_shop` = 1 |
0.4 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
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.4 | 10 | Yes | /classes/shop/Shop.php:663 | |
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5614 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5499 ORDER BY f.position ASC |
0.4 | 4 | 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5502 ORDER BY f.position ASC |
0.4 | 4 | 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 1919 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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5100 ORDER BY f.position ASC |
0.4 | 5 | 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` = 5348) |
0.3 | 1 | /classes/Product.php:2998 | ||
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|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 6229 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 4732 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 4676 ORDER BY f.position ASC |
0.3 | 4 | Yes | /classes/Product.php:4452 | |
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5502) AND (b.`id_shop` = 1) 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` = 8 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 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5100 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5013 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 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` = 6024 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5564 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 2108 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 4773 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5025 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 1850 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 1703 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.3 | 1 | /classes/SpecificPrice.php:196 | ||
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5047 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5348 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 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|6d872b43b94a8d9aedcbb9b8b827f10bafe50e48|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5359) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 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` = 1703) |
0.3 | 1 | /classes/Product.php:2998 | ||
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5568 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 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|8|1|6|5100" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|8|1|6|1703" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5025) 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5348 ORDER BY f.position ASC |
0.3 | 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|14|8ab5f5dfc682f35b4430ef805813a4c4b37bc96a|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|cddaba4728b0ffe453019caf77206903fe342dbe|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 4634 ORDER BY f.position ASC |
0.3 | 4 | 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.3 | 1 | /classes/Theme.php:318 | ||
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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5422 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 2 | Yes | Yes | /classes/Product.php:2092 |
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` = 5499) |
0.3 | 2 | /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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5614) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5100) AND (b.`id_shop` = 1) 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` = 5842 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` = 8) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 8) WHERE pa.`id_product` = 5502 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( ( 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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5564 ORDER BY f.position ASC |
0.3 | 1 | Yes | /classes/Product.php:4452 | |
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5568) 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5492 ORDER BY f.position ASC |
0.3 | 4 | Yes | /classes/Product.php:4452 | |
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.2 | 10 | Yes | /classes/shop/Shop.php:334 | |
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|8|1|6|5047" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SHOW COLUMNS FROM `ps_miravia_product_attribute` LIKE 'id_miravia_product_attribute' |
0.2 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2577 | ||
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` = 8 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.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` = 2108) 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|89b7c588561fd0d42acb236a2ea14b4d7a91100a|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 8 ) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4634) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5616) 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` = 5616) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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.2 | 1 | /classes/Theme.php:275 | ||
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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5047 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_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4678) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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` = 8 ) WHERE ads.`id_search` IN (1) ORDER BY ads.`position` |
0.2 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
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|77ed59dc6bc32097591a71513672eeda4db4afce|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5614 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` = 1850) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4732) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5499) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5492) AND (b.`id_shop` = 1) 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 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` = 5564) |
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1703) 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` = 5047) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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_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` = 6133 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5013) 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5013 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_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5422) 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|1703|1|8","", FROM_UNIXTIME(1734893772)) |
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1907) AND (b.`id_shop` = 1) 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|8|1|6|5616" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5025 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` = 5924 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1850) 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` = 4773) 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` = 4676) 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 5422 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_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5025) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4773) 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|5492|1|8","", FROM_UNIXTIME(1734893772)) |
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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4676) 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` = 1703) 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` = 4678) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5564) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 2108) 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` = 1907) 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 4732 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` = 5013) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 5047) 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` = 4287 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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` = 4732) 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|11|51631dd0ec8bc479835c91ee3ddd3572ed2d2eba|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 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` = 8 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.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` = 5422) 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` = 5499) 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` = 5492) |
0.2 | 2 | /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` = 5824 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|4732|1|8","", FROM_UNIXTIME(1734893772)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8 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.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` = 5100) 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` = 1919) |
0.2 | 2 | /classes/Product.php:2998 | ||
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 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 = 8) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 8) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 8) 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 = 1850 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
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 * 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` = 4634) 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` = 4656 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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` = 5359) 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` = 4678) |
0.2 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5492 AND `id_shop` = 1 |
0.2 | 8 | /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` = 5614) 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` = 8 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1919) 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` = 5348) LIMIT 1 |
0.2 | 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` = 8 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.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 * 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` = 5492) 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` = 1756 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 * 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` = 5502) 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` = 4793 LIMIT 1 |
0.2 | 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` = 5367 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5492 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_lang` WHERE `id_product` = 5499 AND `id_shop` = 1 |
0.2 | 7 | /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` = 5564) 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|5616|1|8" 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` = 5614) |
0.2 | 1 | /classes/Product.php:2998 | ||
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 = 8 AND ml.id_shop = 1 LIMIT 1 |
0.2 | 2 | /classes/Meta.php:149 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5616 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 * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8 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.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` = 4634) |
0.2 | 2 | /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` = 5568) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8 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.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5568 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.2 | 1 | /classes/SpecificPrice.php:196 | ||
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` = 1919) 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` = 5047) |
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` = 5616) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 8 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.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5614 AND `id_shop` = 1 |
0.2 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 8 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.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|8|1|6|4634" 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` = 5502) |
0.2 | 1 | /classes/Product.php:2998 | ||
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|87bdcc777674275b9e6988c44903033530fd20d8|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4678 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` = 5013) |
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` = 4676) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 1703 AND `id_shop` = 1 |
0.1 | 8 | /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 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` = 5100) |
0.1 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 4773 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` = 4773) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5359 AND `id_shop` = 1 |
0.1 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.1 | 87 | /classes/Hook.php:187 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5616 AND `id_shop` = 1 |
0.1 | 8 | /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` = 5359) |
0.1 | 1 | /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|4634|1|8" 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` = 5422) |
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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|75b2a31d5c5e1a9bfface47253ab08237071f543|1|1|1|1|8|1|6|da39289efea23ad53591f376d27d81454ea99300" 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|5499|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 4773 AND `id_shop` = 1 |
0.1 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 * FROM `ps_product_lang` WHERE `id_product` = 1850 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5422 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1703) AND (id_product_attribute = 720) 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|8|1|6|1850" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 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 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 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` = 1907) |
0.1 | 2 | /classes/Product.php:2998 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4773 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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.1 | 1 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
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` = 2108) |
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` = 5025) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 2108 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 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` = 1850) |
0.1 | 1 | /classes/Product.php:2998 | ||
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|8|1|6|5492" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 4732 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` = 5025 AND `id_shop` = 1 |
0.1 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5013 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_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8 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 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|8|1|6|1919" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.1 | 5 | /classes/Language.php:777 | ||
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|8|1|6|5422" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 4575 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5564 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` = 5013 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5568 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 4732 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
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` = 8 ) WHERE ads.`id_search` = 1 AND `active` = 1 LIMIT 1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
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|2108|1|8" AND compile_id="" LIMIT 1 |
0.1 | 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.1 | 1 | /classes/Theme.php:318 | ||
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 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 id_image FROM ps_image WHERE id_product = 5499 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|5100|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5564 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 = 4634 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` = 2108 AND `id_shop` = 1 |
0.1 | 7 | /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`='b39c455dbdd27cd3a624c5bbee120b85' AND cache_id="blocksearch_mod|1|1|1|1|8|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 1703 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_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 * FROM `ps_product_lang` WHERE `id_product` = 4678 AND `id_shop` = 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 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` = 4732) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 1919 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 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 = '8' |
0.1 | 1 | /modules/customergroup/customergroup.php:38 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4634 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 4634 AND `id_shop` = 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|8|1|6|5502" 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|4676|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 4678 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_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 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` = 720 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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` = 8) LIMIT 1 |
0.1 | 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` = 2383 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 id_image FROM ps_image WHERE id_product = 4676 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5614) AND (id_product_attribute = 6227) 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|5492|1|8","", FROM_UNIXTIME(1734893772)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 80 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
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|1907|1|8" 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|1919|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5614 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 = 8 order by contador DESC |
0.1 | 25 | Yes | /modules/customergroup/customergroup.php:97 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5025 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 = 1850 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|8|1|6|4678" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 4676 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5502) 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 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|5422|1|8" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5100 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 id_image FROM ps_image WHERE id_product = 5422 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` = 5348 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.1 | 2 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5564 AND `id_shop` = 1 |
0.1 | 8 | /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` = 6036 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1919) AND (id_product_attribute = 2383) 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|8|1|6|5013" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 id_image FROM ps_image WHERE id_product = 5359 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 3 | 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|5502|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5348 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|5614|1|8" 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|8|1|6|5499" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 4663 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 1907 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 = 1919 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|5359|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 22 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` = 6227 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` = 2108 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|5025|1|8" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 1907 AND `id_shop` = 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|5564|1|8" 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|8|1|6|5564" 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|5047|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1703) 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 = 5568 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_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 * 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_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 8 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.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|5013|1|8" 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_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 = 5499) AND (id_product_attribute = 6034) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5564 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|8|1|6|5568" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5502 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|8|1|6|1907" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 5047 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 25 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` = 84 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5100) AND (id_product_attribute = 5368) 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 = 4676) AND (id_product_attribute = 4794) 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_fbpsc_connector_position` |
0.1 | 7 | /modules/facebookpsconnect/lib/module-dao_class.php:356 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5492) AND (id_product_attribute = 6024) 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` = 22 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 5502 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|4634|1|8","", FROM_UNIXTIME(1734893772)) |
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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|1850|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
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` = 6033 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` = 120 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5422 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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.1 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2574 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|4732|1|8","", FROM_UNIXTIME(1734893772)) |
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|8|1|6|4676" 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` = 1703 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` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 81 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
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 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|8|1|6|5025" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|5348|1|8" 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|4732|1|8" 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 = 5614) 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|1703|1|8" 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 = 1907) AND (id_product_attribute = 312873) 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`='906d705b18c1d50c3d702c4fa29a88ed' AND cache_id="blocksearch_mod|1|1|1|1|8|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-12-22 00:00:00' AND '2024-12-22 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 = 5492) AND (id_product_attribute = 6025) 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` = 25 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|8|1|6|5348" 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 = 1919) 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|1703|1|8","", FROM_UNIXTIME(1734893772)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 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` = 5262 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4634) AND (id_product_attribute = 7739) 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|8|1|6|5614" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4773) AND (id_product_attribute = 4656) 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_image_type` |
0.1 | 19 | /classes/ImageType.php:143 | ||
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|8|1|6|5359" 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|4678|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 8 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|5492|1|8" 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`='b8d72141874b4ab07a0f13e7134f188e' AND cache_id="iqitmegamenu|1|1|1|1|8|1|6|10" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 5312 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` = 5286 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4678) AND (id_product_attribute = 4664) 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 17 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 8 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1703 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5100) AND (id_product_attribute = 5369) 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` = 2423 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5348) 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 * 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|5568|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 11 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 1850 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 = 4732) AND (id_product_attribute = 4575) 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 = 5359) 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 = 5568) 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 = 5100) 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` = 5502 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` = 16 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5013) 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 = 5564) 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|4773|1|8" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4773) 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 = 5492) 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 9 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 79 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` = 5614 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 = 4634) 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` = 5100 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 = 5025) 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` = 11 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5422) 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` = 4676 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5047) 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 = 5422) AND (id_product_attribute = 5924) 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_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5359) AND (id_product_attribute = 5842) 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 = 1919) AND (id_product_attribute = 2385) 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 2108 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` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5614 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 81 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` = 5492 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 = 5100) AND (id_product_attribute = 5367) 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 = 1907) 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_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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5502) AND (id_product_attribute = 6036) 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 = 2108) 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 = 5047) AND (id_product_attribute = 5312) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 8 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5492 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 16 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` = 5499 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` = 4773 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 120 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` = 1850 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` = 4732 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5359 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` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 80 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5568 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 = 5422) AND (id_product_attribute = 5925) 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 = 4732) 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` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5025) AND (id_product_attribute = 5286) 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` = 5047 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 = 5616) 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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5025 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5616 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 1907 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` = 5422 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 = 5499) AND (id_product_attribute = 6033) 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` = 1919 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5502 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5348) AND (id_product_attribute = 5824) 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 = 4634) AND (id_product_attribute = 4287) 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` = 5616 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'de' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
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|8|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` = 5348 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 84 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5100 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 = 5013) AND (id_product_attribute = 5262) 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` = 5047 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` = "shiptopay" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 5013 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` = 5616 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5616) AND (id_product_attribute = 6229) 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` = 4634 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 8 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 4732 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1 |
0.1 | 2 | /classes/shop/Shop.php:1068 | ||
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_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5025 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` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 36 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5499) 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_supplier FROM `ps_pm_advancedsearch_suppliers` 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 = 4678) 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 = 1907) AND (id_product_attribute = 2423) 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` = 7 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` = 5348 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` = 5499 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` = 5422 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 5568) AND (id_product_attribute = 6160) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5614 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` = 17 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 5013 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 = 5564) AND (id_product_attribute = 6133) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-12-22 00:00:00' AND '2024-12-22 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:306 | ||
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 `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
0.1 | 1 | /classes/Group.php:133 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 8 AND cl.id_shop = 1 AND cl.`id_category` = 10 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5564 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1850) 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 = 1850) AND (id_product_attribute = 1987) 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` = 5100 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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 `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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4773 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4676) 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` = 4678 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` = 5502 AND `id_group` = 1 LIMIT 1 |
0.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 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5013 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4678) AND (id_product_attribute = 4663) 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 = 4676) AND (id_product_attribute = 4793) 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` = 4676 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5025 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5359 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4634 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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 `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5047 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` = 1907 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5568 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1919 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5348 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 79 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5492 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 2108 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4732 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE required FROM ps_lgcookieslaw_lang WHERE id_lang = 8 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 5499 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1907 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4678 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 1850 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE additional FROM ps_lgcookieslaw_lang WHERE id_lang = 8 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4676 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
< 1 | 1 | /override/classes/Hook.php:61 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" 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 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "supercheckout" 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` = "checkout_klarna" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" 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 |
32 | 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 |
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 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 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` |
24 | SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = 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 id_image FROM ps_image WHERE id_product = XX AND (cover = XX or cover IS NULL) ORDER BY `position` 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) |
15 | DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|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 |
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 |
8 | 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)) |
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 * 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 tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
2 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="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 |
76 smarty_lazy_cache |
74 product |
74 product_attribute_shop |
59 stock_available |
49 product_attribute |
49 product_lang |
47 theme |
39 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 lang |
9 module_shop |
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 | /controllers/front/BestSalesController.php |
97 | /classes/controller/FrontController.php |
98 | /themes/warehouse/lang/de.php |
99 | /classes/Currency.php |
100 | /classes/Cart.php |
101 | /classes/CartRule.php |
102 | /classes/Meta.php |
103 | /classes/Product.php |
104 | /classes/webservice/WebserviceRequest.php |
105 | /override/classes/webservice/WebserviceRequest.php |
106 | /modules/cedconnector/classes/WebserviceSpecificManagementCedproducts.php |
107 | /modules/cedconnector/classes/CedPrepareProducts.php |
108 | /modules/cedconnector/classes/cedconnector.class.helper.php |
109 | /classes/webservice/WebserviceSpecificManagementInterface.php |
110 | /modules/cedconnector/classes/WebserviceSpecificManagementCedShipping.php |
111 | /modules/cedconnector/classes/WebserviceSpecificManagementCedCurrency.php |
112 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderStatus.php |
113 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderCreate.php |
114 | /modules/cedconnector/classes/cedconnector.class.order.import.php |
115 | /modules/cedconnector/classes/WebserviceSpecificManagementCedAttribute.php |
116 | /modules/cedconnector/classes/WebserviceSpecificManagementCedNestedCategories.php |
117 | /modules/cedconnector/classes/WebserviceSpecificManagementCedFeatures.php |
118 | /modules/cedconnector/classes/WebserviceSpecificManagementCedUpdateStock.php |
119 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderDetails.php |
120 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderUpdate.php |
121 | /modules/cedconnector/classes/WebserviceSpecificManagementCedExecuteQuery.php |
122 | /modules/cedconnector/classes/WebserviceSpecificManagementCedStockSync.php |
123 | /classes/Media.php |
124 | /modules/blockcurrencies/blockcurrencies.php |
125 | /themes/warehouse/modules/blockcurrencies/translations/de.php |
126 | /modules/blockcurrencies/translations/de.php |
127 | /modules/blocklanguages/blocklanguages.php |
128 | /themes/warehouse/modules/blocklanguages/translations/de.php |
129 | /modules/blocklanguages/translations/de.php |
130 | /modules/blockmanufacturer/blockmanufacturer.php |
131 | /themes/warehouse/modules/blockmanufacturer/translations/de.php |
132 | /modules/blockmanufacturer/translations/de.php |
133 | /modules/blockmyaccount/blockmyaccount.php |
134 | /themes/warehouse/modules/blockmyaccount/translations/de.php |
135 | /modules/blockmyaccount/translations/de.php |
136 | /modules/feeder/feeder.php |
137 | /themes/warehouse/modules/feeder/translations/de.php |
138 | /modules/feeder/translations/de.php |
139 | /cache/smarty/compile/da/a5/80/daa5801dba03ca6be725f91e8e03207dbdbcfced.file.feederHeader.tpl.php |
140 | /tools/smarty/sysplugins/smarty_internal_filter_handler.php |
141 | /tools/minify_html/minify_html.class.php |
142 | /modules/blockuserinfo/blockuserinfo.php |
143 | /themes/warehouse/modules/blockuserinfo/translations/de.php |
144 | /modules/blockuserinfo/translations/de.php |
145 | /modules/productcomments/productcomments.php |
146 | /themes/warehouse/modules/productcomments/translations/de.php |
147 | /modules/productcomments/translations/de.php |
148 | /modules/blockcontactinfos/blockcontactinfos.php |
149 | /themes/warehouse/modules/blockcontactinfos/translations/de.php |
150 | /modules/blockcontactinfos/translations/de.php |
151 | /modules/productsnavpn/productsnavpn.php |
152 | /themes/warehouse/modules/productsnavpn/translations/de.php |
153 | /modules/customcontactpage/customcontactpage.php |
154 | /themes/warehouse/modules/customcontactpage/translations/de.php |
155 | /modules/blockwishlist/blockwishlist.php |
156 | /modules/blockwishlist/WishList.php |
157 | /themes/warehouse/modules/blockwishlist/translations/de.php |
158 | /modules/blockwishlist/translations/de.php |
159 | /modules/productsmanufacturer/productsmanufacturer.php |
160 | /themes/warehouse/modules/productsmanufacturer/translations/de.php |
161 | /modules/footercontent/footercontent.php |
162 | /themes/warehouse/modules/footercontent/translations/de.php |
163 | /modules/footercontent/HtmlFooterContent.php |
164 | /modules/mailalerts/mailalerts.php |
165 | /modules/mailalerts/MailAlert.php |
166 | /themes/warehouse/modules/mailalerts/translations/de.php |
167 | /modules/mailalerts/translations/de.php |
168 | /modules/crossselling_mod/crossselling_mod.php |
169 | /themes/warehouse/modules/crossselling_mod/translations/de.php |
170 | /modules/pluginadder/pluginadder.php |
171 | /themes/warehouse/modules/pluginadder/translations/de.php |
172 | /modules/pluginadder/de.php |
173 | /modules/blockcart/blockcart.php |
174 | /themes/warehouse/modules/blockcart/translations/de.php |
175 | /modules/blocksearch_mod/blocksearch_mod.php |
176 | /themes/warehouse/modules/blocksearch_mod/translations/de.php |
177 | /modules/blocksearch_mod/translations/de.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/de.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/de.php |
187 | /modules/pdfcatalogo/pdfcatalogo.php |
188 | /modules/pdfcatalogo/PdfCatalogoHelper.php |
189 | /themes/warehouse/modules/pdfcatalogo/translations/de.php |
190 | /modules/baabandonedcartreminder/baabandonedcartreminder.php |
191 | /init.php |
192 | /themes/warehouse/modules/baabandonedcartreminder/translations/de.php |
193 | /modules/customergroup/customergroup.php |
194 | /themes/warehouse/modules/customergroup/translations/de.php |
195 | /classes/Category.php |
196 | /modules/masbarato/masbarato.php |
197 | /themes/warehouse/modules/masbarato/translations/de.php |
198 | /modules/eicaptcha/eicaptcha.php |
199 | /themes/warehouse/modules/eicaptcha/translations/de.php |
200 | /modules/eicaptcha/translations/de.php |
201 | /modules/rcpgtagmanager/rcpgtagmanager.php |
202 | /modules/rcpgtagmanager/vendor/autoload.php |
203 | /modules/rcpgtagmanager/vendor/composer/autoload_real.php |
204 | /modules/rcpgtagmanager/vendor/composer/ClassLoader.php |
205 | /modules/rcpgtagmanager/vendor/composer/autoload_namespaces.php |
206 | /modules/rcpgtagmanager/vendor/composer/autoload_psr4.php |
207 | /modules/rcpgtagmanager/vendor/composer/autoload_classmap.php |
208 | /themes/warehouse/modules/rcpgtagmanager/translations/de.php |
209 | /modules/rcpgtagmanager/src/rcpgtagmanagertools.php |
210 | /cache/smarty/compile/8e/2d/2e/8e2d2eb1ffcf45aa672c8bba53c3e2aeb20a1706.file.header.tpl.php |
211 | /themes/warehouse/modules/pm_advancedsearch4/translations/de.php |
212 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/6/cddaba4728b0ffe453019caf77206903fe342dbe/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
213 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/7/87bdcc777674275b9e6988c44903033530fd20d8/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
214 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/9/6d872b43b94a8d9aedcbb9b8b827f10bafe50e48/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
215 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/10/89b7c588561fd0d42acb236a2ea14b4d7a91100a/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
216 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getPriceRangeForSearchBloc/11/51631dd0ec8bc479835c91ee3ddd3572ed2d2eba/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
217 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/14/8ab5f5dfc682f35b4430ef805813a4c4b37bc96a/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
218 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/12/77ed59dc6bc32097591a71513672eeda4db4afce/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
219 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/13/75b2a31d5c5e1a9bfface47253ab08237071f543/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
220 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getProductsSearched/60a6c74f94d097f40f362cfed11f281ffdbfb4d5/1/1/1/1/8/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
221 | /cache/smarty/compile/62/65/7b/62657b649dad20c337ed10f06ea424d307592ece.file.pm_advancedsearch.tpl.php |
222 | /cache/smarty/compile/e3/b2/bd/e3b2bd4d773742a3894ed967b7d3362b1fcc8164.file.pm_advancedsearch_header_block.tpl.php |
223 | /cache/smarty/compile/50/e6/82/50e6826bf54f7600a537120ec1ff7b2c78d146d2.file.pm_advancedsearch_criterions.tpl.php |
224 | /cache/smarty/compile/4a/92/ec/4a92ecf704a311daf8563e8bc2575a6ecbb20297.file.pm_advancedsearch_criterions_select.tpl.php |
225 | /cache/smarty/compile/d5/6f/3a/d56f3a28ce1edd1b98fca644b2c50b9183a30f77.file.pm_advancedsearch_criterions_range.tpl.php |
226 | /cache/smarty/compile/41/73/34/417334e0fdbba2184dcf050ffd2df2f2d6143804.file.pm_advancedsearch_footer_block.tpl.php |
227 | /tools/js_minify/jsmin.php |
228 | /modules/facebookpsconnect/facebookpsconnect.php |
229 | /modules/facebookpsconnect/conf/common.conf.php |
230 | /modules/facebookpsconnect/lib/warning_class.php |
231 | /modules/facebookpsconnect/lib/module-tools_class.php |
232 | /themes/warehouse/modules/facebookpsconnect/translations/de.php |
233 | /modules/facebookpsconnect/de.php |
234 | /modules/facebookpsconnect/conf/hook.conf.php |
235 | /modules/facebookpsconnect/lib/hook/hook-ctrl_class.php |
236 | /modules/facebookpsconnect/lib/hook/i-hook_class.php |
237 | /modules/facebookpsconnect/lib/hook/hook-display_class.php |
238 | /modules/facebookpsconnect/lib/module-dao_class.php |
239 | /modules/facebookpsconnect/lib/render/facade-render-connectors_class.php |
240 | /modules/facebookpsconnect/lib/render/render-connectors_class.php |
241 | /cache/smarty/compile/e7/66/db/e766db28fdf284b55b8a9087321ddfb532a72173.file.header.tpl.php |
242 | /modules/blockbanner/blockbanner.php |
243 | /themes/warehouse/modules/blockbanner/translations/de.php |
244 | /modules/blockbanner/translations/de.php |
245 | /modules/nxr_product_bestseller/nxr_product_bestseller.php |
246 | /themes/warehouse/modules/nxr_product_bestseller/translations/de.php |
247 | /modules/paypalwithfee/paypalwithfee.php |
248 | /modules/paypalwithfee/classes/PaypalOrder.php |
249 | /modules/paypalwithfee/classes/PaypalRefund.php |
250 | /classes/PaymentModule.php |
251 | /themes/warehouse/modules/paypalwithfee/translations/de.php |
252 | /modules/paypalwithfee/translations/de.php |
253 | /modules/lgcookieslaw/lgcookieslaw.php |
254 | /themes/warehouse/modules/lgcookieslaw/translations/de.php |
255 | /modules/lgcookieslaw/translations/de.php |
256 | /modules/glsshipping/glsshipping.php |
257 | /modules/glsshipping/classes/GlsshippingUpdate.php |
258 | /classes/module/CarrierModule.php |
259 | /classes/log/FileLogger.php |
260 | /classes/log/AbstractLogger.php |
261 | /themes/warehouse/modules/glsshipping/translations/de.php |
262 | /modules/redsys/redsys.php |
263 | /modules/redsys/api/apiRedsys.php |
264 | /modules/redsys/api/json.php |
265 | /modules/redsys/api/hmac.php |
266 | /modules/redsys/api/hash.php |
267 | /modules/redsys/api/idnovateUtils.php |
268 | /modules/redsys/classes/RedsysTpv.php |
269 | /themes/warehouse/modules/redsys/translations/de.php |
270 | /modules/iqitcontentcreator/iqitcontentcreator.php |
271 | /modules/iqitcontentcreator/models/IqitCreatorHtml.php |
272 | /themes/warehouse/modules/iqitcontentcreator/translations/de.php |
273 | /modules/sekeywords/sekeywords.php |
274 | /classes/module/ModuleGraph.php |
275 | /themes/warehouse/modules/sekeywords/translations/de.php |
276 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/8/1/6/ce/2c/27/ce2c27172c7a4e41ad12781dd622db414db40db1.blocksearch-top_mod.tpl.php |
277 | /cache/smarty/compile/12/ae/c7/12aec79669229e021da11d18ac3ec280dcc2baf1.file.blockuserinfo.tpl.php |
278 | /Adapter/Adapter_AddressFactory.php |
279 | /Adapter/Adapter_ProductPriceCalculator.php |
280 | /Adapter/Adapter_Configuration.php |
281 | /Core/Business/Core_Business_ConfigurationInterface.php |
282 | /classes/Customization.php |
283 | /cache/smarty/compile/72/7e/d5/727ed5f4a47097d819d3f831aedb113965e921cd.file.blockcart.tpl.php |
284 | /tools/smarty/plugins/modifier.replace.php |
285 | /tools/smarty/plugins/function.counter.php |
286 | /cache/smarty/compile/c8/56/86/c85686185a917643f4b42c2b4c967c34304d3b45.file.blockwishlist_top.tpl.php |
287 | /modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php |
288 | /cache/smarty/compile/3d/4d/92/3d4d923a54aa229deb1614884366255dae01e77d.file.connector-buttons-js.tpl.php |
289 | /classes/ProductSale.php |
290 | /classes/Combination.php |
291 | /classes/stock/StockAvailable.php |
292 | /classes/tax/Tax.php |
293 | /classes/Address.php |
294 | /classes/SpecificPrice.php |
295 | /classes/tax/TaxManagerFactory.php |
296 | /classes/tax/TaxRulesTaxManager.php |
297 | /classes/tax/TaxManagerInterface.php |
298 | /classes/tax/TaxCalculator.php |
299 | /classes/GroupReduction.php |
300 | /classes/Feature.php |
301 | /cache/smarty/cache/productlist_colors/5614/1/8/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
302 | /cache/smarty/cache/productlist_colors/5564/1/8/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
303 | /cache/smarty/cache/productlist_colors/5422/1/8/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
304 | /cache/smarty/cache/productlist_colors/5025/1/8/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
305 | /cache/smarty/cache/productlist_colors/5013/1/8/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
306 | /cache/smarty/compile/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.file.product-list-colors.tpl.cache.php |
307 | /tools/smarty/sysplugins/smarty_internal_write_file.php |
308 | /classes/ImageType.php |
309 | /cache/smarty/cache/blockcontactinfos/1/1/1/1/8/1/6/bc/3e/6f/bc3e6f0d6bd38ec8a7c392752be20f0eeeb06022.blockcontactinfos.tpl.php |
310 | /cache/smarty/compile/95/61/a1/9561a1e14f547cf63206a2dfa3bf581a775df28f.file.footer.tpl.php |
311 | /classes/CMS.php |
312 | /cache/smarty/compile/7a/c4/e0/7ac4e0fd50add7456c47f0e68531425ef3787f20.file.cookieslaw.tpl.php |
313 | /cache/smarty/compile/40/3d/71/403d71a762947f16a7fb708839cd0d533130111f.file.best-sales.tpl.php |
314 | /cache/smarty/compile/4d/78/46/4d7846777d384bb54495bfdb53cdda08bfa9a66b.file.product-sort.tpl.php |
315 | /cache/smarty/compile/19/e8/0c/19e80caf79a50922b6bf78fd9404185cc9ffee17.file.nbr-product-page.tpl.php |
316 | /cache/smarty/compile/6d/1f/52/6d1f52f3906b603c4bb386ed9a01c576f34b5006.file.pagination.tpl.php |
317 | /cache/smarty/compile/84/33/2c/84332cd8dc3b11b7526c3c542137e3fb30374436.file.product-list.tpl.php |
318 | /tools/smarty/plugins/function.math.php |
319 | /cache/smarty/compile/3c/16/62/3c1662553ab7198b9693ba318f146941c0624bc0.file.blockwishlist_button.tpl.php |
320 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5616/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
321 | /modules/attributes/attributes.php |
322 | /themes/warehouse/modules/attributes/translations/de.php |
323 | /cache/smarty/compile/52/f0/1e/52f01e3a52fd9c7b842f598556a9af2e6c64a60d.file.combinations.tpl.php |
324 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5614/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
325 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5568/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
326 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5564/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
327 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5502/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
328 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5499/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
329 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5492/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
330 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5422/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
331 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5359/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
332 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5348/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
333 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5100/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
334 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5047/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
335 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5025/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
336 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/5013/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
337 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/4773/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
338 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/4732/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
339 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/4678/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
340 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/4676/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
341 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/4634/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
342 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/2108/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
343 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/1919/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
344 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/1907/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
345 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/1850/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
346 | /cache/smarty/cache/productcomments/1/1/1/1/8/1/6/1703/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
347 | /cache/smarty/compile/53/1d/43/531d43d333f323e579e1f876532a548044dc298f.file.layout.tpl.php |
348 | /cache/smarty/compile/4a/35/98/4a3598bffa820b6b0d5494707365394e96698ac9.file.header.tpl.php |
349 | /tools/smarty/plugins/function.implode.php |
350 | /cache/smarty/compile/3c/6c/34/3c6c34e1cac2e2861343e8e60925e1dfb9d27f2e.file.global.tpl.php |
351 | /cache/smarty/compile/58/63/a4/5863a4956e9578fe17f1584ec77fa232640fdacd.file.blockcurrencies.tpl.php |
352 | /cache/smarty/compile/9c/3f/72/9c3f72fbff97ede10bfca51a951faf01955cc06d.file.blocklanguages.tpl.php |
353 | /tools/smarty/plugins/modifier.regex_replace.php |
354 | /cache/smarty/compile/52/e1/45/52e145a3af78feaf349d33da9ab1c5aa33c7c596.file.mobile-header1.tpl.php |
355 | /cache/smarty/compile/02/8c/16/028c16af65e4de77ec1985877c23c0db654e709b.file.mobile-user.tpl.php |
356 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/8/1/6/8e/c1/db/8ec1dbda411bcdd440fc29d6b6783fe94fe76a08.blocksearch-mobile.tpl.php |
357 | /cache/smarty/cache/iqitmegamenu/1/1/1/1/8/1/6/10/41/f0/34/41f034112f7eceb4890d132af08ee3198f1d6bef.iqitmegamenu.tpl.php |
358 | /cache/smarty/compile/e5/58/f6/e558f6c22cf7f00714cabf72ab8862c3ac4263ff.file.breadcrumb.tpl.php |
359 | /cache/smarty/compile/82/97/9c/82979c59cc436fcbe825fac6cbe7769592ce500f.file.footer.tpl.php |
360 | /tools/smarty/plugins/modifier.date_format.php |
361 | /tools/smarty/plugins/shared.mb_str_replace.php |
362 | /cache/smarty/compile/42/2e/17/422e17da2efcc7a9532d918d2efb5a17d931bec9.file.javascript.tpl.php |