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 | 560 ms - Unicorn powered webserver! |
Querying Time | 188 ms |
Queries | 590 |
Memory Peak Usage | 18.5 Mb |
Included Files | 362 files - 8.11 Mb |
PrestaShop Cache | - Mb |
Global vars | 1.10 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 | 62 ms | 62 ms | 7.29 Mb | 7.40 Mb |
__construct | 0 ms | 62 ms | - Mb | 7.40 Mb |
init | 4 ms | 66 ms | 0.32 Mb | 7.61 Mb |
checkAccess | 0 ms | 66 ms | - Mb | 7.61 Mb |
setMedia | 2 ms | 68 ms | 0.01 Mb | 7.65 Mb |
postProcess | 0 ms | 68 ms | - Mb | 7.65 Mb |
initHeader | 0 ms | 68 ms | - Mb | 7.65 Mb |
initContent | 278 ms | 345 ms | 6.72 Mb | 14.35 Mb |
initFooter | 19 ms | 365 ms | 0.22 Mb | 14.61 Mb |
display | 195 ms | 560 ms | 3.21 Mb | 18.49 Mb |
Hook | Time | Memory Usage |
---|---|---|
__construct | 44 ms | - Mb |
hookheader | 44 ms | - Mb |
hookdisplayProductOnList | 33 ms | 2.00 Mb |
hookdisplayProductListReviews | 32 ms | - Mb |
hookfooter | 17 ms | - Mb |
hookdisplayHeader | 11 ms | - Mb |
hookdisplayProductListFunctionalButtons | 5 ms | - Mb |
hookcalculateGrid | 4 ms | - Mb |
hooktop | 4 ms | - Mb |
hookmaxHeader | 2 ms | - Mb |
hookdisplayNav | 2 ms | - Mb |
hookiqitMobileSearch | 1 ms | - Mb |
hookdisplayTop | 1 ms | - Mb |
hookdisplayFooter | 0 ms | - Mb |
hookmoduleRoutes | - ms | - Mb |
hookiqitMegaMenu | - ms | - Mb |
16 hooks | 202 ms | 2.00 Mb |
Module | Time | Memory Usage |
---|---|---|
attributes | 34 ms | 2.00 Mb |
productcomments | 33 ms | - Mb |
pm_advancedsearch4 | 29 ms | - Mb |
lgmiravia | 25 ms | - Mb |
rcpgtagmanager | 16 ms | - Mb |
facebookpsconnect | 8 ms | - Mb |
blockwishlist | 7 ms | - Mb |
themeeditor | 7 ms | - Mb |
customergroup | 6 ms | - Mb |
blocksearch_mod | 4 ms | - Mb |
iqitmegamenu | 4 ms | - Mb |
lgcookieslaw | 3 ms | - Mb |
blockcart | 3 ms | - Mb |
baabandonedcartreminder | 2 ms | - Mb |
pdfcatalogo | 2 ms | - Mb |
blockcontactinfos | 2 ms | - Mb |
blockcurrencies | 2 ms | - Mb |
blocklanguages | 2 ms | - Mb |
redsys | 2 ms | - Mb |
feeder | 2 ms | - Mb |
blockuserinfo | 1 ms | - Mb |
pluginadder | 1 ms | - Mb |
nxr_product_bestseller | 1 ms | - Mb |
paypalwithfee | 1 ms | - Mb |
glsshipping | 1 ms | - Mb |
footercontent | 1 ms | - Mb |
blockbanner | 1 ms | - Mb |
sekeywords | 1 ms | - Mb |
blockmyaccount | 1 ms | - Mb |
blockmanufacturer | 0 ms | - Mb |
iqitcontentcreator | 0 ms | - Mb |
mailalerts | 0 ms | - Mb |
eicaptcha | 0 ms | - Mb |
customcontactpage | 0 ms | - Mb |
productsmanufacturer | 0 ms | - Mb |
crossselling_mod | 0 ms | - Mb |
productsnavpn | 0 ms | - Mb |
masbarato | 0 ms | - Mb |
38 modules | 202 ms | 2.00 Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
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 |
26.7 | 3603 | /classes/ProductSale.php:53 | ||
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-29 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` = 7 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` = 7) 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 960, 24 |
26.3 | 1968 | /classes/ProductSale.php:140 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
19.9 | 8446 | /classes/SpecificPrice.php:230 | ||
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`) |
8.4 | 3415 | /classes/Configuration.php:148 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1 |
6.6 | 16891 | /classes/SpecificPrice.php:230 | ||
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position |
1.8 | 528 | /classes/Hook.php:235 | ||
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, 6766) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 8446) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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.1 | 4 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
1 | 152 | Yes | Yes | /override/classes/Hook.php:130 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 6780) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 8461) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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 | 4 | Yes | /classes/SpecificPrice.php:362 | |
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 = "7" and firstname not like "%Dario%" GROUP BY ps_product_comment.id_product ORDER BY ps_product_comment.id_product_comment DESC LIMIT 5; |
0.9 | 245 | 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, 6388) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7963) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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 * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.9 | 586 | /classes/module/Module.php:2141 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 6522) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 8139) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.8 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( 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, 9261) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 452318) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.8 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE 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.8 | 147 | Yes | /classes/Dispatcher.php:457 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 8218) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 221497) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.7 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m |
0.7 | 151 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE *, ( 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, 9588) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 503908) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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_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.7 | 245 | /modules/customergroup/customergroup.php:55 | ||
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m |
0.7 | 151 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1 LIMIT 1 ) as mshop FROM `ps_module` m |
0.7 | 151 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE *, ( 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, 8235) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 221681) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 8240) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 221695) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 9170) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 452208) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 6188) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 670670) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 8244) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 222187) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 9510) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 495427) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 8295) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 225408) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 6197) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7474) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6188 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.6 | 3 | Yes | Yes | /classes/Product.php:2092 |
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` = 7) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (9751,9689,9588,9510,9261,9176,9170,8442,8295,8244,8240,8235,8218,8204,7308,6766,6522,6351,6281,6197,6188,6147) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.6 | 41 | 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, 7308) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 9265) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 8204) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 195776) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.6 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name |
0.6 | 0 | /classes/Hook.php:131 | ||
SELECT SQL_NO_CACHE *, ( 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, 8442) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 263641) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 9751) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 589989) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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 * 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` = 8244) LIMIT 1 |
0.6 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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, 9689) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 509335) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 6351) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7908) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 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, 9176) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 452213) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6388 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.5 | 4 | 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6197 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.5 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 6281) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7629) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8244 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 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|7|1|6|9689" AND compile_id="" LIMIT 1 |
0.5 | 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9510 ORDER BY f.position ASC |
0.5 | 3 | 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, 6147) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7374) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-29 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.5 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|6780" 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|7|1|6|6281" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8295 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE 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|7|1|6|6522" AND compile_id="" LIMIT 1 |
0.4 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 536 AND `id_shop` = 1 LIMIT 1 |
0.4 | 1 | /classes/module/Module.php:2218 | ||
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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6351 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6281 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8235 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9751 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8442 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9510 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6766 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9176 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8218 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9261 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9689 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 4 | 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9170 ORDER BY f.position ASC |
0.3 | 1 | 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8240 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 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 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 8204 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9689 ORDER BY f.position ASC |
0.3 | 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9261 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 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6147 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9588 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8295) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8295 ORDER BY f.position ASC |
0.3 | 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 9170 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6188 ORDER BY f.position ASC |
0.3 | 3 | 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8244 ORDER BY f.position ASC |
0.3 | 4 | Yes | /classes/Product.php:4452 | |
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 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6780 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 * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8244) 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 7308 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6281 ORDER BY f.position ASC |
0.3 | 4 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|8295" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6147) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9176 ORDER BY f.position ASC |
0.3 | 1 | 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` = 7) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7) WHERE pa.`id_product` = 6522 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9751) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6780) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6197 ORDER BY f.position ASC |
0.3 | 3 | 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` = 9176) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9588) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8218 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6766) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri FROM ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = 1 WHERE s.deleted = 0 AND gs.deleted = 0 ORDER BY gs.name, s.name |
0.3 | 10 | Yes | /classes/shop/Shop.php:663 | |
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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9176) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8295) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = '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 * 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.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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8240) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6522) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8442) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6188) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8235 ORDER BY f.position ASC |
0.2 | 4 | Yes | /classes/Product.php:4452 | |
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_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6197) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9751 ORDER BY f.position ASC |
0.2 | 4 | 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` = 9261) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6522 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` = 9510) 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` = 6388) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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` = 7 ) WHERE acg.`id_search` = 1 ORDER BY `position` |
0.2 | 12 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6147 ORDER BY f.position ASC |
0.2 | 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9170) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8240 ORDER BY f.position ASC |
0.2 | 4 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|9261" 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 7308 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` = 9751) 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` = 6351) 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` = 8235) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6388) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6197) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6388 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8204) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9261) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6766 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` = 6766) 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` = 8218) 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` = 9689) 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` = 6281) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6281) 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` = 8204) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8235) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6780 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_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6351) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8442 ORDER BY f.position ASC |
0.2 | 3 | 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` = 8240) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8218) AND (b.`id_shop` = 1) 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` = 7 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.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8204 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` = 6147) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 9588 ORDER BY f.position ASC |
0.2 | 4 | 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` = 9170) 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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9689) AND (b.`id_shop` = 1) 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6766) AND (id_product_attribute = 8446) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.2 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 = 7 AND ml.id_shop = 1 LIMIT 1 |
0.2 | 2 | /classes/Meta.php:149 | ||
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` = 6188) 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` = 9588) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9170 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 7308) 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` = 8442) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 7308 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 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 6351 ORDER BY f.position ASC |
0.2 | 4 | 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 | |
SHOW COLUMNS FROM `ps_miravia_product` LIKE 'has_alert' |
0.2 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2592 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6780) 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 = 7) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7) 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 = 8204 ORDER BY f.position ASC |
0.2 | 1 | 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` = 8240) |
0.2 | 2 | /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` = 6522) |
0.2 | 1 | /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 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` = 6188) |
0.2 | 3 | /classes/Product.php:2998 | ||
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` = 7 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 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` = 6147) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 452318 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
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` = 7 ) WHERE ads.`id_search` = 1 AND `active` = 1 LIMIT 1 |
0.2 | 1 | /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` = 7 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9510) 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` = 9170) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9261 AND `id_shop` = 1 |
0.2 | 4 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6388 AND `id_shop` = 1 |
0.2 | 5 | /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` = 8204) |
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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|9176" AND compile_id="" LIMIT 1 |
0.2 | 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` = 7308) 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` = 6522) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6766 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search` FROM `ps_pm_advancedsearch` ads JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1) WHERE 1 AND ads.`active`=1 ORDER BY ads.`position` |
0.2 | 1 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
SELECT SQL_NO_CACHE 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` = 6766) |
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` = 9261) |
0.2 | 2 | /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` = 8244) |
0.2 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|6351" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
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` = 7 ) WHERE ads.`id_search` IN (1) ORDER BY ads.`position` |
0.2 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8442 AND `id_shop` = 1 |
0.2 | 5 | /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` = 7308) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.2 | 1 | /classes/shop/Shop.php:202 | ||
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` = 9510) |
0.2 | 3 | /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 IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE product_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` = 225408 LIMIT 1 |
0.2 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8235 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|6351|1|7","", FROM_UNIXTIME(1735492975)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 6281) |
0.2 | 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|9588" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9176 AND `id_shop` = 1 |
0.1 | 5 | /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` = 8442) |
0.1 | 1 | /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 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` = 6197) |
0.1 | 3 | /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` = 263641 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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.1 | 1 | /classes/Theme.php:275 | ||
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` = 7 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.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` = 8295) |
0.1 | 3 | /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` = 8235) |
0.1 | 3 | /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.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6522 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` = 6388) |
0.1 | 4 | /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.1 | 1 | /classes/Theme.php:301 | ||
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` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6197 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8218 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` = 6197 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6780 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` = 9510 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8204 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6147 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 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|7|1|6|7308" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 = '7' |
0.1 | 1 | /modules/customergroup/customergroup.php:38 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6281 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` = 6780) |
0.1 | 3 | /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.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8240 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` = 9751 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7 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_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 95) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9689 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` = 6351) |
0.1 | 1 | /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.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8244 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` = 6351 AND `id_shop` = 1 |
0.1 | 5 | /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` = 8218) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6281 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8218 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8204 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_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 = 6766 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`='906d705b18c1d50c3d702c4fa29a88ed' AND cache_id="blocksearch_mod|1|1|1|1|7|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 = 6351 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6388) AND (id_product_attribute = 7964) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 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` = 7374 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|11|3ac9c4d0558d5c5c4a7f6460e5259c0905e9a1b2|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6188 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9751 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 * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 7 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 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` = 9689) |
0.1 | 4 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8218 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` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 124) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8235 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` = 9176) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9689 AND `id_shop` = 1 |
0.1 | 5 | /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 * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 7 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.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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|14|ba5fd5c2d601d439f924cc422e029363cca90043|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|86678494462feb4f1c707b732d2757374519b690|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 6 AND tr.`id_tax_rules_group` = 0 AND tr.`id_state` IN (0, 0) AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
0.1 | 0 | /classes/tax/TaxRulesTaxManager.php:108 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8240 AND `id_shop` = 1 |
0.1 | 5 | /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 `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 = 9261 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9176 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` = 9751) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|8235|1|7" 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 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 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 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 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|a57efcc2bb02714192c3a3401d3c6c0675c66653|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|10|d34e12377f611d6a50fda73a868cf81732e87c19|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8244 AND `id_shop` = 1 |
0.1 | 4 | /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|7|1|6|9751" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6147 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='b8d72141874b4ab07a0f13e7134f188e' AND cache_id="iqitmegamenu|1|1|1|1|7|1|6|10" 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|9751|1|7" 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` = 8461 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 7308 AND `id_shop` = 1 |
0.1 | 5 | /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` = 9588) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6188 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|7|1|6|8240" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8442 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|7|1|6|6188" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax` a WHERE (a.`id_tax` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE product_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` = 221695 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6388 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|7|1|6|6147" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1 WHERE (a.`id_currency` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.1 | 87 | /classes/Hook.php:187 | ||
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` = 503908 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6388) AND (id_product_attribute = 7965) 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` = 222187 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` = 452208 LIMIT 1 |
0.1 | 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.1 | 1 | /classes/Theme.php:318 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|6351|1|7","", FROM_UNIXTIME(1735492975)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
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 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_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_group_lang` WHERE `id_group` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9689) AND (id_product_attribute = 509335) 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 = 9261) 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|6522|1|7" 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|7|1|6|6197" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_fbpsc_connector_position` |
0.1 | 7 | /modules/facebookpsconnect/lib/module-dao_class.php:356 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9588 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6522 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6388|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 125) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6766|1|7" 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 = 8295) AND (id_product_attribute = 225409) 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` = 7474 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|6766" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_image_type` |
0.1 | 19 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6780 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8295 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8442) 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 = 6197) AND (id_product_attribute = 7475) 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|9689|1|7" 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` = 670670 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getProductsSearched|60a6c74f94d097f40f362cfed11f281ffdbfb4d5|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 100 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6388) AND (id_product_attribute = 7967) 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|05d6ae3ccc7b27792bdc4d01e9c143c746591995|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6780|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9170 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` = 8295 AND `id_shop` = 1 |
0.1 | 5 | /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 id_image FROM ps_image WHERE id_product = 9588 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|8218|1|7" 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|26a1995f3a1ceec52c1485f1037b1a51b4007531|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" 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='compile' LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:95 | ||
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|8204|1|7" 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|8295|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1 WHERE (a.`id_group` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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|7|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='3ff7719ba20fdf62fbc6b5297f98a1a2' AND cache_id="blockcontactinfos|1|1|1|1|7|1|6" 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` = 7908 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8295) 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 keyword,contador,results FROM `trending_statssearch` WHERE id_lang = 7 order by contador DESC |
0.1 | 25 | Yes | /modules/customergroup/customergroup.php:97 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|6388" 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|7|1|6|8204" 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|7|1|6|8235" 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 = 9689) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 452213 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9510 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_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` = 221497 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` = 8139 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8218) AND (id_product_attribute = 221498) 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 = 9170) 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 = 8235) AND (id_product_attribute = 221682) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "shiptopay" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
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 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_lang` WHERE `id_tax` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6281) 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|8442|1|7" 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|9170|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9689 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 = 8235) 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 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|9261|1|7" 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|9176|1|7" 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 = 9751) AND (id_product_attribute = 594748) 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` = 589989 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9510) 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` = 7 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 83 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` = 8446 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8244) 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|8244|1|7" 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 = 6281) AND (id_product_attribute = 9664) 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` = 9588 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 = 6188) 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|6188|1|7" 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|7|1|6|9170" 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 = 8204) 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 = 9751) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 195776 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6197) 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 = 8218) AND (id_product_attribute = 221497) 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` = 509335 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 12 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|8218" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8442 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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 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|7|1|6|9510" 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|6351|1|7" 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 = 8240) AND (id_product_attribute = 221696) 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` = 7 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|7308|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9170 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8240 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 7 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8235 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` = 'it' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8235) AND (id_product_attribute = 221681) 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 = 9510) AND (id_product_attribute = 495428) 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|8240|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8244 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6188 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 = 8295) AND (id_product_attribute = 225408) 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` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 21 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6766) 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 = 6188) AND (id_product_attribute = 7449) 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|9588|1|7" 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|9510|1|7" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 23 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6147) AND (id_product_attribute = 7374) 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_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 = 6197) AND (id_product_attribute = 7476) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "yotpo" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|7|1|6|8442" 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|6281|1|7" 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|f8590f9ef8973f7eb6fd60fb6b4ae2f736fc73ac|1|1|1|1|7|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 6 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8295) AND (id_product_attribute = 225410) 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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 12 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE active FROM `ps_cart_rule` where id_cart_rule = 364 and active = 1 and date_from <= NOW() and date_to >= NOW() order by id_cart_rule DESC limit 1; |
0.1 | 0 | /modules/customergroup/customergroup.php:100 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6522) 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_default_group` FROM `ps_customer` WHERE `id_customer` = 0 LIMIT 1 |
0.1 | 0 | /classes/Customer.php:724 | ||
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` = 7) 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` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 6 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` = 6197 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 = 9176) 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 = 8240) 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 = 9689) AND (id_product_attribute = 509332) 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 = 8244) AND (id_product_attribute = 222187) 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 = 6522) AND (id_product_attribute = 8139) 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 = 7308) AND (id_product_attribute = 9265) 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` = 7963 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9261 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` = 9170 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 = 7308) 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` = 84 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 84 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6188) AND (id_product_attribute = 670670) 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 = 6780) AND (id_product_attribute = 8462) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 78 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
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` = 221681 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` = 495427 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 23 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9261) AND (id_product_attribute = 452318) 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 = 6780) 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 `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT 1 |
0.1 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 24 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` = 82 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|7|1|6|8244" 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-29 00:00:00' AND '2024-12-29 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:302 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 6281 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` = 19 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'pt' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
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` = 9265 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8244) AND (id_product_attribute = 222188) 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` = 9689 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 6766 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` = 6780 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_shop` WHERE `id_module` = 375 AND `id_shop` = 1 LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 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` = 8240 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 6188 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` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 19 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8442) AND (id_product_attribute = 263641) 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 = 8218) 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` = 8244 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE page FROM `ps_pm_advancedsearch_special_pages` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6147) 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|6147|1|7" 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` = 7629 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8442 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_category FROM `ps_pm_advancedsearch_products_cat` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6197) AND (id_product_attribute = 7474) 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` = 6522 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` = 9176 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` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 115 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9751 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 = 6388) 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_manufacturer FROM `ps_pm_advancedsearch_manufacturers` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 83 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9170 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "supercheckout" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9261 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9510 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` = 115 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-12-29 00:00:00' AND '2024-12-29 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:306 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 7 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6281 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` = 7308 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6197|1|7" 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` = 8235 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` = 6522 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 = 9176) AND (id_product_attribute = 452213) 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 = 9261) AND (id_product_attribute = 470660) 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 = 8204) AND (id_product_attribute = 195776) 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` = 9751 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6281) AND (id_product_attribute = 7629) 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 = 9751) AND (id_product_attribute = 589989) 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` = 6197 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9261 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` = 8295 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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 = 9170) AND (id_product_attribute = 452208) 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` = 6147 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 = 9510) AND (id_product_attribute = 495427) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6188) AND (id_product_attribute = 7450) 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 = 9510) AND (id_product_attribute = 495429) 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` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 97 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 82 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` = 6388 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 80 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6281 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` = 9751 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 = 9588) 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_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:142 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "paypalwithfee" 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6780) AND (id_product_attribute = 8463) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 7 AND cl.id_shop = 1 AND cl.`id_category` = 7 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8244 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` = 8442 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 8295 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9510 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 = 6780) AND (id_product_attribute = 8461) 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 = 9689) AND (id_product_attribute = 509333) 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` = 6766 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 = 9588) AND (id_product_attribute = 503908) 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6188 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` = 24 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` = 6351 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_shop` WHERE `id_module` = 523 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 6780 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` = 100 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` = 7308 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6147 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_attribute_group` FROM `ps_attribute_group` WHERE `is_color_group`=1 |
0.1 | 7 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8235) AND (id_product_attribute = 221683) 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` = 97 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9689) AND (id_product_attribute = 509334) 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` = 7308 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkout_klarna" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 8218 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 = 6388) AND (id_product_attribute = 7963) 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` = 8204 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` = 9689 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` = 6197 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` = 6780 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE COUNT(*) FROM ps_shop LIMIT 1 |
0.1 | 2 | /classes/shop/Shop.php:1068 | ||
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 `id_module` FROM `ps_module` WHERE `name` = "klarnaofficial" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9176 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 = 6351) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8240 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` = 8218 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 = 8240) AND (id_product_attribute = 221695) 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` = 8204 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9588 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` = 6147 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` = 6766 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` = 6351 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` = 8295 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` = 8235 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9176 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 = 6351) AND (id_product_attribute = 7908) 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` = 6388 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` = 9510 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` = 9588 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` = 6522 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 = 7 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
< 1 | 1 | /override/classes/Hook.php:61 | ||
SELECT SQL_NO_CACHE additional FROM ps_lgcookieslaw_lang WHERE id_lang = 7 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6351 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 7 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 7 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6388 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 |
72 | 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 |
30 | 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = 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 product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
24 | SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND 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 name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC |
24 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX |
24 | SELECT * 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 *, ( 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 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 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 id_image FROM ps_image WHERE id_product = XX AND (cover = XX or cover IS NULL) ORDER BY `position` 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 |
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 |
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_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 |
2 | 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)) |
2 | SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
2 | SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX ORDER BY `name` ASC |
2 | SELECT 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 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 |
98 product_shop |
74 product |
74 product_attribute_shop |
73 stock_available |
61 smarty_lazy_cache |
49 product_attribute |
49 product_lang |
47 theme |
37 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/pt.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/pt.php |
126 | /modules/blockcurrencies/translations/pt.php |
127 | /modules/blocklanguages/blocklanguages.php |
128 | /themes/warehouse/modules/blocklanguages/translations/pt.php |
129 | /modules/blocklanguages/translations/pt.php |
130 | /modules/blockmanufacturer/blockmanufacturer.php |
131 | /themes/warehouse/modules/blockmanufacturer/translations/pt.php |
132 | /modules/blockmanufacturer/translations/pt.php |
133 | /modules/blockmyaccount/blockmyaccount.php |
134 | /themes/warehouse/modules/blockmyaccount/translations/pt.php |
135 | /modules/blockmyaccount/translations/pt.php |
136 | /modules/feeder/feeder.php |
137 | /themes/warehouse/modules/feeder/translations/pt.php |
138 | /modules/feeder/translations/pt.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/pt.php |
144 | /modules/blockuserinfo/translations/pt.php |
145 | /modules/productcomments/productcomments.php |
146 | /themes/warehouse/modules/productcomments/translations/pt.php |
147 | /modules/productcomments/translations/pt.php |
148 | /modules/blockcontactinfos/blockcontactinfos.php |
149 | /themes/warehouse/modules/blockcontactinfos/translations/pt.php |
150 | /modules/blockcontactinfos/translations/pt.php |
151 | /modules/productsnavpn/productsnavpn.php |
152 | /themes/warehouse/modules/productsnavpn/translations/pt.php |
153 | /modules/customcontactpage/customcontactpage.php |
154 | /themes/warehouse/modules/customcontactpage/translations/pt.php |
155 | /modules/blockwishlist/blockwishlist.php |
156 | /modules/blockwishlist/WishList.php |
157 | /themes/warehouse/modules/blockwishlist/translations/pt.php |
158 | /modules/blockwishlist/translations/pt.php |
159 | /modules/productsmanufacturer/productsmanufacturer.php |
160 | /themes/warehouse/modules/productsmanufacturer/translations/pt.php |
161 | /modules/footercontent/footercontent.php |
162 | /themes/warehouse/modules/footercontent/translations/pt.php |
163 | /modules/footercontent/HtmlFooterContent.php |
164 | /modules/mailalerts/mailalerts.php |
165 | /modules/mailalerts/MailAlert.php |
166 | /themes/warehouse/modules/mailalerts/translations/pt.php |
167 | /modules/mailalerts/translations/pt.php |
168 | /modules/crossselling_mod/crossselling_mod.php |
169 | /themes/warehouse/modules/crossselling_mod/translations/pt.php |
170 | /modules/pluginadder/pluginadder.php |
171 | /themes/warehouse/modules/pluginadder/translations/pt.php |
172 | /modules/blockcart/blockcart.php |
173 | /themes/warehouse/modules/blockcart/translations/pt.php |
174 | /modules/blocksearch_mod/blocksearch_mod.php |
175 | /themes/warehouse/modules/blocksearch_mod/translations/pt.php |
176 | /cache/smarty/compile/32/38/0c/32380c944294386a2da475bb5223e2456c9b9a14.file.blocksearch_modh.tpl.php |
177 | /modules/themeeditor/themeeditor.php |
178 | /themes/warehouse/modules/themeeditor/translations/pt.php |
179 | /classes/Image.php |
180 | /modules/iqitmegamenu/iqitmegamenu.php |
181 | /modules/iqitmegamenu/models/IqitMenuTab.php |
182 | /modules/iqitmegamenu/models/IqitMenuHtml.php |
183 | /modules/iqitmegamenu/models/IqitMenuLinks.php |
184 | /themes/warehouse/modules/iqitmegamenu/translations/pt.php |
185 | /modules/pdfcatalogo/pdfcatalogo.php |
186 | /modules/pdfcatalogo/PdfCatalogoHelper.php |
187 | /themes/warehouse/modules/pdfcatalogo/translations/pt.php |
188 | /modules/pdfcatalogo/translations/pt.php |
189 | /modules/baabandonedcartreminder/baabandonedcartreminder.php |
190 | /init.php |
191 | /themes/warehouse/modules/baabandonedcartreminder/translations/pt.php |
192 | /modules/customergroup/customergroup.php |
193 | /themes/warehouse/modules/customergroup/translations/pt.php |
194 | /classes/Category.php |
195 | /modules/masbarato/masbarato.php |
196 | /themes/warehouse/modules/masbarato/translations/pt.php |
197 | /modules/eicaptcha/eicaptcha.php |
198 | /themes/warehouse/modules/eicaptcha/translations/pt.php |
199 | /modules/rcpgtagmanager/rcpgtagmanager.php |
200 | /modules/rcpgtagmanager/vendor/autoload.php |
201 | /modules/rcpgtagmanager/vendor/composer/autoload_real.php |
202 | /modules/rcpgtagmanager/vendor/composer/ClassLoader.php |
203 | /modules/rcpgtagmanager/vendor/composer/autoload_namespaces.php |
204 | /modules/rcpgtagmanager/vendor/composer/autoload_psr4.php |
205 | /modules/rcpgtagmanager/vendor/composer/autoload_classmap.php |
206 | /themes/warehouse/modules/rcpgtagmanager/translations/pt.php |
207 | /modules/rcpgtagmanager/src/rcpgtagmanagertools.php |
208 | /cache/smarty/compile/8e/2d/2e/8e2d2eb1ffcf45aa672c8bba53c3e2aeb20a1706.file.header.tpl.php |
209 | /themes/warehouse/modules/pm_advancedsearch4/translations/pt.php |
210 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/6/f8590f9ef8973f7eb6fd60fb6b4ae2f736fc73ac/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
211 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/7/26a1995f3a1ceec52c1485f1037b1a51b4007531/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
212 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/9/86678494462feb4f1c707b732d2757374519b690/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
213 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/10/d34e12377f611d6a50fda73a868cf81732e87c19/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
214 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getPriceRangeForSearchBloc/11/3ac9c4d0558d5c5c4a7f6460e5259c0905e9a1b2/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
215 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/14/ba5fd5c2d601d439f924cc422e029363cca90043/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
216 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/12/05d6ae3ccc7b27792bdc4d01e9c143c746591995/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
217 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/13/a57efcc2bb02714192c3a3401d3c6c0675c66653/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
218 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getProductsSearched/60a6c74f94d097f40f362cfed11f281ffdbfb4d5/1/1/1/1/7/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
219 | /cache/smarty/compile/62/65/7b/62657b649dad20c337ed10f06ea424d307592ece.file.pm_advancedsearch.tpl.php |
220 | /cache/smarty/compile/e3/b2/bd/e3b2bd4d773742a3894ed967b7d3362b1fcc8164.file.pm_advancedsearch_header_block.tpl.php |
221 | /cache/smarty/compile/50/e6/82/50e6826bf54f7600a537120ec1ff7b2c78d146d2.file.pm_advancedsearch_criterions.tpl.php |
222 | /cache/smarty/compile/4a/92/ec/4a92ecf704a311daf8563e8bc2575a6ecbb20297.file.pm_advancedsearch_criterions_select.tpl.php |
223 | /cache/smarty/compile/d5/6f/3a/d56f3a28ce1edd1b98fca644b2c50b9183a30f77.file.pm_advancedsearch_criterions_range.tpl.php |
224 | /cache/smarty/compile/41/73/34/417334e0fdbba2184dcf050ffd2df2f2d6143804.file.pm_advancedsearch_footer_block.tpl.php |
225 | /tools/js_minify/jsmin.php |
226 | /modules/facebookpsconnect/facebookpsconnect.php |
227 | /modules/facebookpsconnect/conf/common.conf.php |
228 | /modules/facebookpsconnect/lib/warning_class.php |
229 | /modules/facebookpsconnect/lib/module-tools_class.php |
230 | /themes/warehouse/modules/facebookpsconnect/translations/pt.php |
231 | /modules/facebookpsconnect/pt.php |
232 | /modules/facebookpsconnect/conf/hook.conf.php |
233 | /modules/facebookpsconnect/lib/hook/hook-ctrl_class.php |
234 | /modules/facebookpsconnect/lib/hook/i-hook_class.php |
235 | /modules/facebookpsconnect/lib/hook/hook-display_class.php |
236 | /modules/facebookpsconnect/lib/module-dao_class.php |
237 | /modules/facebookpsconnect/lib/render/facade-render-connectors_class.php |
238 | /modules/facebookpsconnect/lib/render/render-connectors_class.php |
239 | /cache/smarty/compile/e7/66/db/e766db28fdf284b55b8a9087321ddfb532a72173.file.header.tpl.php |
240 | /modules/blockbanner/blockbanner.php |
241 | /themes/warehouse/modules/blockbanner/translations/pt.php |
242 | /modules/blockbanner/translations/pt.php |
243 | /modules/nxr_product_bestseller/nxr_product_bestseller.php |
244 | /themes/warehouse/modules/nxr_product_bestseller/translations/pt.php |
245 | /modules/paypalwithfee/paypalwithfee.php |
246 | /modules/paypalwithfee/classes/PaypalOrder.php |
247 | /modules/paypalwithfee/classes/PaypalRefund.php |
248 | /classes/PaymentModule.php |
249 | /themes/warehouse/modules/paypalwithfee/translations/pt.php |
250 | /modules/paypalwithfee/translations/pt.php |
251 | /modules/lgcookieslaw/lgcookieslaw.php |
252 | /themes/warehouse/modules/lgcookieslaw/translations/pt.php |
253 | /modules/lgcookieslaw/translations/pt.php |
254 | /modules/glsshipping/glsshipping.php |
255 | /modules/glsshipping/classes/GlsshippingUpdate.php |
256 | /classes/module/CarrierModule.php |
257 | /classes/log/FileLogger.php |
258 | /classes/log/AbstractLogger.php |
259 | /themes/warehouse/modules/glsshipping/translations/pt.php |
260 | /modules/glsshipping/translations/pt.php |
261 | /modules/redsys/redsys.php |
262 | /modules/redsys/api/apiRedsys.php |
263 | /modules/redsys/api/json.php |
264 | /modules/redsys/api/hmac.php |
265 | /modules/redsys/api/hash.php |
266 | /modules/redsys/api/idnovateUtils.php |
267 | /modules/redsys/classes/RedsysTpv.php |
268 | /themes/warehouse/modules/redsys/translations/pt.php |
269 | /modules/iqitcontentcreator/iqitcontentcreator.php |
270 | /modules/iqitcontentcreator/models/IqitCreatorHtml.php |
271 | /themes/warehouse/modules/iqitcontentcreator/translations/pt.php |
272 | /modules/sekeywords/sekeywords.php |
273 | /classes/module/ModuleGraph.php |
274 | /themes/warehouse/modules/sekeywords/translations/pt.php |
275 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/7/1/6/ce/2c/27/ce2c27172c7a4e41ad12781dd622db414db40db1.blocksearch-top_mod.tpl.php |
276 | /cache/smarty/compile/12/ae/c7/12aec79669229e021da11d18ac3ec280dcc2baf1.file.blockuserinfo.tpl.php |
277 | /Adapter/Adapter_AddressFactory.php |
278 | /Adapter/Adapter_ProductPriceCalculator.php |
279 | /Adapter/Adapter_Configuration.php |
280 | /Core/Business/Core_Business_ConfigurationInterface.php |
281 | /classes/Customization.php |
282 | /cache/smarty/compile/72/7e/d5/727ed5f4a47097d819d3f831aedb113965e921cd.file.blockcart.tpl.php |
283 | /tools/smarty/plugins/modifier.replace.php |
284 | /tools/smarty/plugins/function.counter.php |
285 | /cache/smarty/compile/c8/56/86/c85686185a917643f4b42c2b4c967c34304d3b45.file.blockwishlist_top.tpl.php |
286 | /modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php |
287 | /cache/smarty/compile/3d/4d/92/3d4d923a54aa229deb1614884366255dae01e77d.file.connector-buttons-js.tpl.php |
288 | /classes/ProductSale.php |
289 | /classes/Combination.php |
290 | /classes/stock/StockAvailable.php |
291 | /classes/tax/Tax.php |
292 | /classes/Address.php |
293 | /classes/SpecificPrice.php |
294 | /classes/tax/TaxManagerFactory.php |
295 | /classes/tax/TaxRulesTaxManager.php |
296 | /classes/tax/TaxManagerInterface.php |
297 | /classes/tax/TaxCalculator.php |
298 | /classes/GroupReduction.php |
299 | /classes/Feature.php |
300 | /cache/smarty/cache/productlist_colors/6780/1/7/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
301 | /cache/smarty/cache/productlist_colors/6388/1/7/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
302 | /cache/smarty/compile/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.file.product-list-colors.tpl.cache.php |
303 | /tools/smarty/sysplugins/smarty_internal_write_file.php |
304 | /classes/ImageType.php |
305 | /cache/smarty/cache/blockcontactinfos/1/1/1/1/7/1/6/bc/3e/6f/bc3e6f0d6bd38ec8a7c392752be20f0eeeb06022.blockcontactinfos.tpl.php |
306 | /cache/smarty/compile/95/61/a1/9561a1e14f547cf63206a2dfa3bf581a775df28f.file.footer.tpl.php |
307 | /classes/CMS.php |
308 | /cache/smarty/compile/7a/c4/e0/7ac4e0fd50add7456c47f0e68531425ef3787f20.file.cookieslaw.tpl.php |
309 | /cache/smarty/compile/40/3d/71/403d71a762947f16a7fb708839cd0d533130111f.file.best-sales.tpl.php |
310 | /cache/smarty/compile/4d/78/46/4d7846777d384bb54495bfdb53cdda08bfa9a66b.file.product-sort.tpl.php |
311 | /cache/smarty/compile/19/e8/0c/19e80caf79a50922b6bf78fd9404185cc9ffee17.file.nbr-product-page.tpl.php |
312 | /cache/smarty/compile/6d/1f/52/6d1f52f3906b603c4bb386ed9a01c576f34b5006.file.pagination.tpl.php |
313 | /cache/smarty/compile/84/33/2c/84332cd8dc3b11b7526c3c542137e3fb30374436.file.product-list.tpl.php |
314 | /tools/smarty/plugins/function.math.php |
315 | /cache/smarty/compile/3c/16/62/3c1662553ab7198b9693ba318f146941c0624bc0.file.blockwishlist_button.tpl.php |
316 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9751/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
317 | /modules/attributes/attributes.php |
318 | /themes/warehouse/modules/attributes/translations/pt.php |
319 | /cache/smarty/compile/52/f0/1e/52f01e3a52fd9c7b842f598556a9af2e6c64a60d.file.combinations.tpl.php |
320 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9689/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
321 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9588/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
322 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9510/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
323 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9261/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
324 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9176/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
325 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/9170/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
326 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8442/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
327 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8295/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
328 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8244/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
329 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8240/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
330 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8235/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
331 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8218/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
332 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/8204/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
333 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/7308/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
334 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6780/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
335 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6766/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
336 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6522/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
337 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6388/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
338 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6351/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
339 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6281/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
340 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6197/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
341 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6188/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
342 | /cache/smarty/cache/productcomments/1/1/1/1/7/1/6/6147/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
343 | /cache/smarty/compile/53/1d/43/531d43d333f323e579e1f876532a548044dc298f.file.layout.tpl.php |
344 | /cache/smarty/compile/4a/35/98/4a3598bffa820b6b0d5494707365394e96698ac9.file.header.tpl.php |
345 | /tools/smarty/plugins/function.implode.php |
346 | /cache/smarty/compile/3c/6c/34/3c6c34e1cac2e2861343e8e60925e1dfb9d27f2e.file.global.tpl.php |
347 | /cache/smarty/compile/58/63/a4/5863a4956e9578fe17f1584ec77fa232640fdacd.file.blockcurrencies.tpl.php |
348 | /cache/smarty/compile/9c/3f/72/9c3f72fbff97ede10bfca51a951faf01955cc06d.file.blocklanguages.tpl.php |
349 | /tools/smarty/plugins/modifier.regex_replace.php |
350 | /cache/smarty/compile/52/e1/45/52e145a3af78feaf349d33da9ab1c5aa33c7c596.file.mobile-header1.tpl.php |
351 | /cache/smarty/compile/02/8c/16/028c16af65e4de77ec1985877c23c0db654e709b.file.mobile-user.tpl.php |
352 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/7/1/6/8e/c1/db/8ec1dbda411bcdd440fc29d6b6783fe94fe76a08.blocksearch-mobile.tpl.php |
353 | /cache/smarty/cache/iqitmegamenu/1/1/1/1/7/1/6/10/41/f0/34/41f034112f7eceb4890d132af08ee3198f1d6bef.iqitmegamenu.tpl.php |
354 | /cache/smarty/compile/e5/58/f6/e558f6c22cf7f00714cabf72ab8862c3ac4263ff.file.breadcrumb.tpl.php |
355 | /cache/smarty/compile/82/97/9c/82979c59cc436fcbe825fac6cbe7769592ce500f.file.footer.tpl.php |
356 | /tools/smarty/plugins/modifier.date_format.php |
357 | /tools/smarty/plugins/shared.mb_str_replace.php |
358 | /cache/smarty/compile/42/2e/17/422e17da2efcc7a9532d918d2efb5a17d931bec9.file.javascript.tpl.php |