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 | 626 ms - Unicorn powered webserver! |
Querying Time | 319 ms |
Queries | 613 |
Memory Peak Usage | 18.7 Mb |
Included Files | 366 files - 8.33 Mb |
PrestaShop Cache | - Mb |
Global vars | 1.53 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 | 45 ms | 45 ms | 7.33 Mb | 7.44 Mb |
__construct | 0 ms | 45 ms | - Mb | 7.44 Mb |
init | 3 ms | 48 ms | 0.32 Mb | 7.65 Mb |
checkAccess | 0 ms | 48 ms | - Mb | 7.65 Mb |
setMedia | 2 ms | 50 ms | 0.01 Mb | 7.69 Mb |
postProcess | 0 ms | 50 ms | - Mb | 7.69 Mb |
initHeader | 0 ms | 50 ms | - Mb | 7.69 Mb |
initContent | 403 ms | 453 ms | 6.94 Mb | 14.60 Mb |
initFooter | 21 ms | 474 ms | 0.23 Mb | 14.88 Mb |
display | 152 ms | 626 ms | 3.17 Mb | 18.73 Mb |
Hook | Time | Memory Usage |
---|---|---|
hookheader | 45 ms | - Mb |
__construct | 36 ms | - Mb |
hookdisplayProductOnList | 29 ms | - Mb |
hookdisplayProductListReviews | 28 ms | - Mb |
hookfooter | 19 ms | - Mb |
hookdisplayHeader | 10 ms | - Mb |
hookdisplayProductListFunctionalButtons | 5 ms | - Mb |
hooktop | 4 ms | - Mb |
hookcalculateGrid | 4 ms | - Mb |
hookdisplayTop | 1 ms | - Mb |
hookmaxHeader | 1 ms | - Mb |
hookiqitMobileSearch | 1 ms | - Mb |
hookdisplayNav | 1 ms | - Mb |
hookdisplayFooter | 1 ms | - Mb |
hookmoduleRoutes | 0 ms | - Mb |
hookiqitMegaMenu | - ms | - Mb |
16 hooks | 184 ms | - Mb |
Module | Time | Memory Usage |
---|---|---|
pm_advancedsearch4 | 31 ms | - Mb |
attributes | 29 ms | - Mb |
productcomments | 28 ms | - Mb |
lgmiravia | 20 ms | - Mb |
rcpgtagmanager | 17 ms | - Mb |
facebookpsconnect | 8 ms | - Mb |
customergroup | 6 ms | - Mb |
themeeditor | 6 ms | - Mb |
blockwishlist | 6 ms | - Mb |
blocksearch_mod | 4 ms | - Mb |
lgcookieslaw | 4 ms | - Mb |
iqitmegamenu | 3 ms | - Mb |
blockcart | 3 ms | - Mb |
blockcontactinfos | 2 ms | - Mb |
baabandonedcartreminder | 2 ms | - Mb |
pdfcatalogo | 2 ms | - Mb |
blockcurrencies | 2 ms | - Mb |
redsys | 1 ms | - Mb |
feeder | 1 ms | - Mb |
blockuserinfo | 1 ms | - Mb |
blocklanguages | 1 ms | - Mb |
pluginadder | 1 ms | - Mb |
paypalwithfee | 1 ms | - Mb |
nxr_product_bestseller | 1 ms | - Mb |
blockbanner | 0 ms | - Mb |
glsshipping | 0 ms | - Mb |
footercontent | 0 ms | - Mb |
sekeywords | 0 ms | - Mb |
iqitcontentcreator | 0 ms | - Mb |
blockmanufacturer | 0 ms | - Mb |
eicaptcha | 0 ms | - Mb |
blockmyaccount | 0 ms | - Mb |
customcontactpage | 0 ms | - Mb |
mailalerts | 0 ms | - Mb |
masbarato | 0 ms | - Mb |
productsnavpn | 0 ms | - Mb |
productsmanufacturer | 0 ms | - Mb |
crossselling_mod | 0 ms | - Mb |
38 modules | 184 ms | - Mb |
Query | Time (ms) | Rows | Filesort | Group By | Location |
---|---|---|---|---|---|
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1 |
14.9 | 7922 | /classes/SpecificPrice.php:230 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|4647|1|5%" |
12.7 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|9539|1|5%" |
12.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|9752|1|5%" |
12.5 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|6362|1|5%" |
12.4 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10762|1|5%" |
12.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10432|1|5%" |
12.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10400|1|5%" |
12.2 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|8412|1|5%" |
12.1 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10180|1|5%" |
12.1 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|6493|1|5%" |
12 | 1 | /classes/SmartyCustom.php:295 | ||
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-28 00:00:00", INTERVAL 150 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 5 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 5) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 6 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND p.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` = 1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 504, 24 |
11 | 528 | /classes/ProductSale.php:140 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|6356|1|5%" |
10.8 | 1 | /classes/SmartyCustom.php:295 | ||
SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON p.`id_product` = ps.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) WHERE product_shop.`active` = 1 LIMIT 1 |
6.7 | 3603 | /classes/ProductSale.php:53 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10164|1|5%" |
6.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|9812|1|5%" |
6.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|9323|1|5%" |
6.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10093|1|5%" |
6.6 | 1 | /classes/SmartyCustom.php:295 | ||
DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash='9ac8918619debd9b4516a5e852a9e733' AND cache_id LIKE "productlist_colors|10208|1|5%" |
6.6 | 1 | /classes/SmartyCustom.php:295 | ||
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`) |
6.2 | 3308 | /classes/Configuration.php:148 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10331|1|5","", FROM_UNIXTIME(1735401485)) |
6 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1 |
5.3 | 15843 | /classes/SpecificPrice.php:230 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|1061|1|5","", FROM_UNIXTIME(1735401485)) |
5.3 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|10331|1|5","", FROM_UNIXTIME(1735401485)) |
4.1 | 1 | /classes/SmartyCustom.php:263 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|1310|1|5","", FROM_UNIXTIME(1735401485)) |
2.6 | 1 | /classes/SmartyCustom.php:263 | ||
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.4 | 528 | /classes/Hook.php:235 | ||
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.name != "displayPayment") AND (hm.id_shop = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position` |
1.1 | 152 | Yes | Yes | /override/classes/Hook.php:130 |
SELECT SQL_NO_CACHE MIN(ps_product_comment.id_product_comment) as id_product_comment,ps_product_comment.id_customer,ps_product_comment.id_product,ps_product_comment.content,ps_product_comment.customer_name,ps_product_comment.title,ps_product_comment.grade,ps_image.id_image FROM `ps_product_comment` JOIN ps_customer ON ps_customer.id_customer = ps_product_comment.id_customer JOIN `ps_image` ON ps_product_comment.id_product = ps_image.id_product WHERE ps_product_comment.grade > 3 and ps_customer.id_lang = "5" and firstname not like "%Dario%" GROUP BY ps_product_comment.id_product ORDER BY ps_product_comment.id_product_comment DESC LIMIT 5; |
1 | 242 | Yes | /modules/customergroup/customergroup.php:48 | |
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; |
1 | 242 | /modules/customergroup/customergroup.php:55 | ||
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 10180) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 700649) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 10762) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722902) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 300) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 322) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 1310) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 2104) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 10432) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722346) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 10400) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722285) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 9539) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 496810) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 6356) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7914) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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 | 4 | 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, 1061) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 1508) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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 | 4 | 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, 4647) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 4721) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 9752) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 589990) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 10208) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 718954) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC |
0.6 | 147 | Yes | /classes/Dispatcher.php:457 | |
SELECT SQL_NO_CACHE *, ( 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, 10331) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 722124) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (249,10164,10093,9812,9323,7468,7182,6356,4647,1310,1061,10762,10432,10400,10331,10208,10180,9752,9539,8412,6493,6362) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` ORDER BY a.`position` ASC; |
0.6 | 43 | Yes | Yes | /classes/Product.php:3464 |
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.5 | 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, 249) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 272) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 9812) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 590059) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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 * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (1) |
0.5 | 600 | /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, 7182) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 9116) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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 | 4 | 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, 10164) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 669618) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 10093) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 663567) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 8412) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 241741) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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, 9323) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 452383) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 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 | 4 | 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.4 | 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, 7468) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 9532) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE 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.4 | 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.4 | 151 | /classes/module/Module.php:277 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1310 ORDER BY f.position ASC |
0.4 | 4 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 6, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 6) AND `id_group` IN (0, 1) AND `id_product` IN (0, 6362) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 7920) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 4 | 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, 6571) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 8211) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE *, ( 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, 6493) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 9713) AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-28 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1 |
0.4 | 6 | Yes | /classes/SpecificPrice.php:362 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10208 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10164 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 5 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 7182 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.4 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 9539 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 300 ORDER BY f.position ASC |
0.4 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 6571 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` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10180 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 9812 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 1310 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 4647 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 8412 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 9752 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|9539" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10762 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 249 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10164" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10400 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 3 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 1061 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10432 ORDER BY f.position ASC |
0.3 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10331" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10331 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 9323 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9539 ORDER BY f.position ASC |
0.3 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10432 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 name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10762 ORDER BY f.position ASC |
0.3 | 3 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 10093 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 6356 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 7468 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 6362 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 acg.*, acgl.* FROM `ps_pm_advancedsearch_criterion_group_1` acg LEFT JOIN `ps_pm_advancedsearch_criterion_group_1_lang` acgl ON (acg.`id_criterion_group` = acgl.`id_criterion_group` AND acgl.`id_lang` = 5 ) WHERE acg.`id_search` = 1 ORDER BY `position` |
0.3 | 12 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9539) 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9812) AND (b.`id_shop` = 1) LIMIT 1 |
0.3 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10093 ORDER BY f.position ASC |
0.3 | 5 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 300 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.3 | 1 | Yes | Yes | /classes/Product.php:2092 |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|1061" AND compile_id="" LIMIT 1 |
0.3 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 5) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 5) WHERE pa.`id_product` = 6493 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
0.2 | 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 = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9752 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1061) 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` = 10400) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10180 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` = 10093) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6356) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 300) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10331) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 7182 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|1310|1|5","", FROM_UNIXTIME(1735401485)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10180) 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` = 10208) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10164) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4647) 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` = 10180) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10400) 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` = 6356) 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` = 7182) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10400 ORDER BY f.position ASC |
0.2 | 2 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10331) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 6356 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|7468|1|5","", FROM_UNIXTIME(1735401485)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10093 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10762) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10432) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|7182|1|5","", FROM_UNIXTIME(1735401485)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6362) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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.2 | 10 | Yes | /classes/shop/Shop.php:663 | |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10208 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|249|1|5","", FROM_UNIXTIME(1735401485)) |
0.2 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 1061 ORDER BY f.position ASC |
0.2 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 249 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` = 249) 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` = 6571) 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` = 10400) 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` = 10331) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10208) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SHOW COLUMNS FROM `ps_miravia_product` LIKE 'has_alert' |
0.2 | 1 | /modules/lgmiravia/classes/MiraviaTools.php:2592 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9752) 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` = 10180) 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` = 10762) 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` = 10432) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 4647 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` = 1061) 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` = 10762) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE ads.`id_search`, ads.`id_hook`, ads.`unique_search` FROM `ps_pm_advancedsearch` ads JOIN `ps_pm_advancedsearch_shop` adss ON (ads.`id_search`=adss.`id_search` AND adss.`id_shop`=1) WHERE 1 AND ads.`active`=1 ORDER BY ads.`position` |
0.2 | 1 | Yes | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9323) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9323 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10164 ORDER BY f.position ASC |
0.2 | 3 | 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` = 10432) |
0.2 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 7468) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10180 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 10331 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` = 1061) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6493) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9539 AND `id_shop` = 1 |
0.2 | 4 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 4647) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 7468 ORDER BY f.position ASC |
0.2 | 1 | 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.2 | 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|5|1|6|10432" 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` = 1310) 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` = 6362) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC |
0.2 | 16 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE 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` = 9752) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6571 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 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` = 300) |
0.2 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 8412) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 7468) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.2 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1310) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10208 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 10093) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6356 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9323 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` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9323) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10762 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|4647" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9752 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 2 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE product_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` = 1310) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 7182) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 6493 ORDER BY f.position ASC |
0.2 | 4 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6362 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10180" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 10164) |
0.2 | 5 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search` FROM `ps_pm_advancedsearch` ads LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 5 ) WHERE ads.`id_search` = 1 AND `active` = 1 LIMIT 1 |
0.2 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE * 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` = 9539) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 9812 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` = 10164) 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` = 9752) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6493) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1 |
0.2 | 2 | /classes/shop/Shop.php:1067 | ||
SELECT SQL_NO_CACHE * 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` = 8412) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 6571) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE ads.* , adsl.*, ads.`id_search` FROM `ps_pm_advancedsearch` ads LEFT JOIN `ps_pm_advancedsearch_lang` adsl ON (ads.`id_search` = adsl.`id_search` AND adsl.`id_lang` = 5 ) WHERE ads.`id_search` IN (1) ORDER BY ads.`position` |
0.2 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|6362" AND compile_id="" LIMIT 1 |
0.2 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10164 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.2 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 249) AND (b.`id_shop` = 1) LIMIT 1 |
0.2 | 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.2 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 6356) |
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` = 10208) |
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 * FROM `ps_product_lang` WHERE `id_product` = 6571 AND `id_shop` = 1 |
0.2 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 300) 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` = 4647) |
0.2 | 3 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 4647 AND `id_shop` = 1 |
0.1 | 7 | /Adapter/Adapter_EntityMapper.php:68 | ||
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.1 | 1 | Yes | /classes/tax/TaxRulesTaxManager.php:108 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10762" 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|300|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE 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 name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 8412 ORDER BY f.position ASC |
0.1 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE 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` = 9539) |
0.1 | 4 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 7468 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 = 10331 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 ps_customer_group.id_group , ps_group_lang.name FROM ps_customer_group LEFT JOIN ps_group_lang ON ps_group_lang.id_group = ps_customer_group.id_group WHERE ps_customer_group.id_customer = '' AND ps_group_lang.id_lang = '5' |
0.1 | 1 | /modules/customergroup/customergroup.php:38 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9812 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 3 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|6571" 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|10180|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|8412" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|1310|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 9812) 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 * FROM `ps_product_lang` WHERE `id_product` = 7182 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|10432|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6362|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|9539|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='906d705b18c1d50c3d702c4fa29a88ed' AND cache_id="blocksearch_mod|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10180 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|10400|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC |
0.1 | 16 | Yes | /classes/Currency.php:231 | |
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10331 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9539 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 su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = 1 AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1 |
0.1 | 1 | /classes/shop/Shop.php:202 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 6571 ORDER BY f.position ASC |
0.1 | 1 | Yes | /classes/Product.php:4452 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6356|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6356 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 5) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 5) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 5) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) WHERE pf.id_product = 6362 ORDER BY f.position ASC |
0.1 | 1 | 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.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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|8412|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10093 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_product_lang` WHERE `id_product` = 10432 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 14 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10400 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 9323 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|10208|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 8412) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 1061 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 7468 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10180) AND (id_product_attribute = 700650) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10331|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 28 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 6493 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_meta m LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta WHERE ( m.page = "best-sales" OR m.page = "bestsales" ) AND ml.id_lang = 5 AND ml.id_shop = 1 LIMIT 1 |
0.1 | 2 | /classes/Meta.php:149 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10762 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 98 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6362 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|9752|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_image_type` |
0.1 | 19 | /classes/ImageType.php:143 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 1310 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='b8d72141874b4ab07a0f13e7134f188e' AND cache_id="iqitmegamenu|1|1|1|1|5|1|6|10" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE content FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 10164 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|9323" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|9812" 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 = 10164) AND (id_product_attribute = 722063) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|249|1|5","", FROM_UNIXTIME(1735401485)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10208 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` = 7182) |
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_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` = 322 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9539) AND (id_product_attribute = 496750) 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 = 1061) 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 l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang) |
0.1 | 5 | /classes/Language.php:777 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6571|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|7182|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|4647|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10208" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 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` = 10093) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|6493|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9812) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 249) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 9323) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getProductsSearched|60a6c74f94d097f40f362cfed11f281ffdbfb4d5|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 249 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722124 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 2) AND (b.`id_shop` = 1) LIMIT 1 |
0.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 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` = 6493) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 7182) AND (id_product_attribute = 9116) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 300 AND `id_shop` = 1 |
0.1 | 8 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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 left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 19 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
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|5|1|6|7468" 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 = 10400) AND (id_product_attribute = 722286) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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` = 7468) |
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 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|10762|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_hook_alias` |
0.1 | 87 | /classes/Hook.php:187 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|9752" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9752 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|6493" 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 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|1061|1|5","", FROM_UNIXTIME(1735401485)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10762) AND (id_product_attribute = 722903) 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 = 5 order by contador DESC |
0.1 | 25 | Yes | /modules/customergroup/customergroup.php:97 | |
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|9812|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10762) 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` = 10762 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|10093" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1) WHERE (p.`id_product` = 8412) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6493) AND (id_product_attribute = 9712) 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` = 24 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 4647 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|10164|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722285 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 249 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` = 6571) |
0.1 | 2 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 669618 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:301 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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` = 272 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 7182 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|7468|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 5 LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1 WHERE (a.`id_cms` = 62) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10400 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 496810 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10400) 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 = 7182) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 9812 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 10 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE * FROM `ps_shop` a WHERE (a.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 10 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 97 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 8412 AND (cover = 0 or cover IS NULL) ORDER BY `position` LIMIT 1 |
0.1 | 1 | Yes | /override/classes/Link.php:19 | |
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 536 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10432) AND (id_product_attribute = 722347) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 19 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` = 300 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getPriceRangeForSearchBloc|11|2fab87b58327be0e9432ad51e82333da4afbb6ea|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.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` = 80 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 1061 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_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 COUNT(*) FROM ps_shop LIMIT 1 |
0.1 | 2 | /classes/shop/Shop.php:1068 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 1310 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` = 6362) |
0.1 | 1 | /classes/Product.php:2998 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 92) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10432 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 = 10093) 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_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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10331) 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 = 9539) AND (id_product_attribute = 496751) 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` = 2 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10432 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 = 4647) AND (id_product_attribute = 4722) 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|10|51d9ecafa80b62bf28ddcdf4751eb1ad581f481c|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|9|86ada09a3412cec67caf0d3f86b186ed822a3d8f|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 97 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|5|1|6|7182" 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 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 = 10093) AND (id_product_attribute = 663567) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10432 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_fbpsc_connector_position` |
0.1 | 7 | /modules/facebookpsconnect/lib/module-dao_class.php:356 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|7468|1|5","", FROM_UNIXTIME(1735401485)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10180 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` = 82 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 10331 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 7914 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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10331 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` = 1310 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
INSERT IGNORE INTO `ps_smarty_lazy_cache` (`template_hash`, `cache_id`, `compile_id`, `last_update`) VALUES ('9ac8918619debd9b4516a5e852a9e733',"productlist_colors|7182|1|5","", FROM_UNIXTIME(1735401485)) |
0.1 | 1 | /classes/SmartyCustom.php:263 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1310) AND (id_product_attribute = 2106) 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 = 9539) AND (id_product_attribute = 496752) 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` = 9752 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE required FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
0.1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 300 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` = 10164 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" 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` = 10093 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 95) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 10400 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|6|08791267623aeee753db0ce208f1afec8a04c220|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "shiptopay" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 5 LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1 WHERE (a.`id_country` = 6) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10164) AND (id_product_attribute = 669617) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =26 AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =26 LIMIT 1 |
0.1 | 1 | /classes/Theme.php:318 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|13|2e2438d5ff64a0ae8e2f2485af7beacb4099c6c2|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 124) AND (b.`id_shop` = 1) 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` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 125) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE 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` = 4721 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10093 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 = 10400) AND (id_product_attribute = 722287) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 6493 AND `id_shop` = 1 |
0.1 | 5 | /Adapter/Adapter_EntityMapper.php:68 | ||
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='3ff7719ba20fdf62fbc6b5297f98a1a2' AND cache_id="blockcontactinfos|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10400 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE * FROM `ps_product_lang` WHERE `id_product` = 8412 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_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 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` = 722902 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE domain, domain_ssl FROM ps_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/shop/ShopUrl.php:169 | ||
SELECT SQL_NO_CACHE * FROM `ps_theme` a WHERE (a.`id_theme` = 26) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
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 `id_module` FROM `ps_module` WHERE `name` = "paypalwithfee" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10331 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 5 LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 34) AND (b.`id_shop` = 1) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 10762 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|6356" 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 = 1310) AND (id_product_attribute = 2105) 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 = 4647) AND (id_product_attribute = 7756) 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` = 590059 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE id_image FROM ps_image WHERE id_product = 300 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|10093|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1310) 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 = 10762) AND (id_product_attribute = 722904) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1 WHERE (a.`id_lang` = 5) LIMIT 1 |
0.1 | 1 | /Adapter/Adapter_EntityMapper.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 79 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|1061|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|7|4530363c893a595a479e2cbb02ecbab83b6cbad9|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.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` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 2 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|5|1|6|10400" 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` = 249 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 1508 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6356) 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|9323|1|5" AND compile_id="" LIMIT 1 |
0.1 | 0 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 722346 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10208) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|1310" 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` = 700649 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9539 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-12-28 00:00:00' AND '2024-12-28 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:302 | ||
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 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` = 718954 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6571) AND (id_product_attribute = 9695) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 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`='8a4878b5c2e5c7f703642cfac35d660b' AND cache_id="productcomments|1|1|1|1|5|1|6|249" 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` = 6356 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` = 10093 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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 `id_module` FROM `ps_module` WHERE `name` = "supercheckout" LIMIT 1 |
0.1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "lgcookieslaw" LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 6 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10180) AND (id_product_attribute = 700649) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `width`, `height` FROM ps_image_type WHERE `name` = 'small_default' LIMIT 1 |
0.1 | 1 | /classes/Image.php:471 | ||
SELECT SQL_NO_CACHE `id_default_group` FROM `ps_customer` WHERE `id_customer` = 0 LIMIT 1 |
0.1 | 0 | /classes/Customer.php:724 | ||
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2024-12-28 00:00:00' AND '2024-12-28 23:59:59' LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:306 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10180) AND (id_product_attribute = 700648) 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` = 4647 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 = 10432) 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_shop` WHERE `id_module` = 523 AND `id_shop` = 1 LIMIT 1 |
0.1 | 1 | /classes/module/Module.php:2218 | ||
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 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` = 589990 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 4647 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 2104 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 1310 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`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|14|f5483e1fff3cd2c8089021a4f87481b365956f22|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9539 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 9116 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 13 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` = 9752 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 = 9539) 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 = 300) 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 = 1310) AND (id_product_attribute = 2104) 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 SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 9752) AND (id_product_attribute = 594749) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 25 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 6493 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` = 13 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 1061) AND (id_product_attribute = 1508) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 98 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10164) AND (id_product_attribute = 722064) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'fr' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 10208) AND (id_product_attribute = 718954) 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` = 6356 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 28 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` = 9532 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`='b39c455dbdd27cd3a624c5bbee120b85' AND cache_id="blocksearch_mod|1|1|1|1|5|1|6" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
SELECT SQL_NO_CACHE 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 = 6356) AND (id_product_attribute = 7914) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
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 = 10432) AND (id_product_attribute = 722346) 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` = 10208 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
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` = 452383 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 9812 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 = 10180) 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 = 9752) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_lang_shop` WHERE `id_lang` = 5 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
SELECT SQL_NO_CACHE * FROM `ps_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 = 7468) 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` = 663567 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 4647) 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 = 10400) AND (id_product_attribute = 722285) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE * FROM `ps_tax_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 = 9539) AND (id_product_attribute = 496810) 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` = 241741 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 79 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`='9ac8918619debd9b4516a5e852a9e733' AND cache_id="productlist_colors|249|1|5" AND compile_id="" LIMIT 1 |
0.1 | 1 | /classes/SmartyCustom.php:215 | ||
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 = 10762) AND (id_product_attribute = 722902) 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 = 249) 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 = 300) AND (id_product_attribute = 322) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE id_supplier FROM `ps_pm_advancedsearch_suppliers` WHERE id_search=1 |
0.1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`='8ede449796bfe53e8c4332c250b7771f' AND cache_id="pm_advancedsearch|1|customCache|getCriterionsForSearchBloc|12|17bd13b42c3caf48fe32af5633f7f7286de0bb1f|1|1|1|1|5|1|6|da39289efea23ad53591f376d27d81454ea99300" AND compile_id="" LIMIT 1 |
0.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` = 9713 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10762 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 = 10331) AND (id_product_attribute = 722124) 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 = 10164) AND (id_product_attribute = 722942) 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 = 9752) AND (id_product_attribute = 594750) 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` = 1061 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 14 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` = 1061 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 = 9752) AND (id_product_attribute = 589990) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 21 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` = 10400 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE pa.`id_product_attribute` = 8211 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10432 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 4647 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` = 1310 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 = 9323) 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` = 7920 LIMIT 1 |
0.1 | 1 | /classes/Combination.php:343 | ||
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 `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 10180 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 = 10164) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 249 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 = 8412) AND (id_product_attribute = 241741) 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` = 10208 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 = 9812) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 24 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` = 9323 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` = 5 AND cl.id_shop = 1 AND cl.`id_category` = 82 LIMIT 1 |
0.1 | 1 | /classes/Category.php:1054 | ||
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 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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6493 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` = 6356 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` = 7468 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` = 9323 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE id_module FROM ps_lgcookieslaw; |
0.1 | 1 | /override/classes/Hook.php:61 | ||
SELECT SQL_NO_CACHE cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = 0 AND cl.id_shop = 1 AND cl.`id_category` = 25 LIMIT 1 |
0.1 | 0 | /classes/Category.php:1054 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9539 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'es' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 7468) AND (id_product_attribute = 9532) 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 = 9812) AND (id_product_attribute = 590059) 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` = 7182 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 = 10164) AND (id_product_attribute = 669618) 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` = 10164 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` = 10208 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'it' LIMIT 1 |
0.1 | 1 | /classes/Language.php:680 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 7182 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 = 249) AND (id_product_attribute = 272) 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 `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 9812 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 = 6493) 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` = 7468 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` = 249 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 = 9323) AND (id_product_attribute = 452383) 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 = 6571) 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 = 4647) AND (id_product_attribute = 4721) 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` = 1061 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 = 6362) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
0.1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 8412 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
0.1 | 1 | /classes/SpecificPrice.php:196 | ||
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` = 9323 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` = 300 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 = 6571) AND (id_product_attribute = 8211) 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` = 6571 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` = 6571 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 = 6493) AND (id_product_attribute = 9713) 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` = 10180 AND `id_group` = 1 LIMIT 1 |
0.1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE id_shop FROM `ps_group_shop` WHERE `id_group` = 1 AND id_shop = 1 LIMIT 1 |
0.1 | 1 | /classes/ObjectModel.php:1450 | ||
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 `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9752 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` = 10164 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` = 6362 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` = 6362 AND id_shop=1 LIMIT 1 |
0.1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE id_manufacturer FROM `ps_pm_advancedsearch_manufacturers` WHERE id_search=1 |
< 1 | 1 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php:48 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 7182 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE SUM(quantity) FROM `ps_stock_available` WHERE (id_product = 6362) AND (id_product_attribute = 7920) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1 |
< 1 | 1 | /classes/stock/StockAvailable.php:380 | ||
SELECT SQL_NO_CACHE `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = 8412 AND id_shop=1 LIMIT 1 |
< 1 | 1 | /classes/Product.php:5033 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 78 AND `id_shop` = 1 LIMIT 1 |
< 1 | 1 | /classes/module/Module.php:2218 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 9812 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = 6493 ORDER BY `id_specific_price_priority` DESC LIMIT 1 |
< 1 | 1 | /classes/SpecificPrice.php:196 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarna" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE additional FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_group` WHERE `id_group` = 1 LIMIT 1 |
< 1 | 1 | /classes/Group.php:133 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockwishlist" LIMIT 1 |
< 1 | 1 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 7468 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button1 FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6362 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE button2 FROM ps_lgcookieslaw_lang WHERE id_lang = 5 LIMIT 1 |
< 1 | 1 | /modules/lgcookieslaw/lgcookieslaw.php:161 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 6571 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = 8412 AND `id_group` = 1 LIMIT 1 |
< 1 | 0 | /classes/GroupReduction.php:149 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkout_klarna" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "klarnaofficial" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 | ||
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "checkoutklarnauk" LIMIT 1 |
< 1 | 0 | /classes/module/Module.php:2568 |
70 | 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 * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX |
24 | SELECT product_attribute_shop.`price` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX |
24 | SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX |
24 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productlist_colors|XX|XX|XX" AND compile_id="" LIMIT XX |
24 | SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC |
24 | SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX |
24 | SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` IN (XX, XX) AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX |
24 | SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX |
24 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="productcomments|XX|XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
24 | SELECT pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute` FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute` |
24 | SELECT * FROM `ps_product_lang` WHERE `id_product` = XX AND `id_shop` = XX |
24 | SELECT * FROM `ps_product` a LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX |
24 | SELECT id_image FROM ps_image WHERE id_product = XX AND (cover = XX or cover IS NULL) ORDER BY `position` LIMIT XX |
24 | SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX) |
16 | DELETE FROM `ps_smarty_lazy_cache` WHERE template_hash=XX AND cache_id LIKE "productlist_colors|XX|XX|XX%" |
12 | 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)) |
11 | SELECT IFNULL( ( SELECT left_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =XX AND m.page = "best-sales" ) , default_left_column ) FROM ps_theme WHERE id_theme =XX LIMIT XX |
11 | SELECT IFNULL( ( SELECT right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON ( t.id_theme = tm.id_theme ) LEFT JOIN ps_meta m ON ( m.id_meta = tm.id_meta ) WHERE t.id_theme =XX AND m.page = "best-sales" ) , default_right_column ) FROM ps_theme WHERE id_theme =XX LIMIT XX |
7 | SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX |
4 | SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX |
4 | SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX |
3 | SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX LIMIT XX ) as mshop FROM `ps_module` m |
2 | SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = XX) WHERE `deleted` = XX AND c.`active` = XX ORDER BY `name` ASC |
2 | SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC |
2 | SELECT UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache` WHERE `template_hash`=XX AND cache_id="blocksearch_mod|XX|XX|XX|XX|XX|XX|XX" AND compile_id="" LIMIT XX |
2 | SELECT buttonXX FROM ps_lgcookieslaw_lang WHERE id_lang = XX LIMIT XX |
2 | SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = XX LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX |
2 | SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX WHERE (a.`id_lang` = XX) LIMIT XX |
98 product_shop |
77 smarty_lazy_cache |
74 product |
74 product_attribute_shop |
71 stock_available |
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 module_shop |
8 lang |
7 category_shop |
7 category |
5 lang_shop |
5 shop |
5 currency_shop |
5 lgcookieslaw_lang |
4 cms |
4 cms_lang |
4 cms_shop |
4 shop_url |
4 currency |
4 hook |
3 pm_advancedsearch |
3 image_type |
3 tax_rule |
2 product_comment |
2 product_sale |
2 meta_lang |
2 group_shop |
2 tax |
2 shop_group |
2 tax_rules_group |
2 group_lang |
2 smarty_last_flush |
2 country |
2 configuration |
2 hook_alias |
2 group |
2 customer |
2 hook_module |
2 pm_advancedsearch_lang |
2 country_shop |
2 country_lang |
1 miravia_product_attribute |
1 configuration_lang |
1 miravia_product |
1 tax_lang |
1 lgcookieslaw |
1 module_group |
1 cart_rule |
1 category_group |
1 pm_advancedsearch_special_pages |
1 pm_advancedsearch_shop |
1 pm_advancedsearch_category |
1 pm_advancedsearch_products_cat |
1 pm_advancedsearch_suppliers |
1 pm_advancedsearch_manufacturers |
1 pm_advancedsearch_products |
1 pm_advancedsearch_criterion_group_1 |
1 category_product |
1 pm_advancedsearch_criterion_group_1_lang |
1 customer_group |
1 fbpsc_connector_position |
1 hook_module_exceptions |
1 image_shop |
1 image_lang |
1 manufacturer |
1 pm_advancedsearch_cms |
Name | Instances | Source |
---|---|---|
Product | 48 | /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /classes/Link.php [104] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] /modules/attributes/attributes.php [26] |
Category | 15 | /modules/customergroup/customergroup.php [59] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] /modules/customergroup/customergroup.php [142] /classes/Link.php [177] |
CMS | 7 | /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] /classes/Link.php [277] |
Language | 3 | /config/config.inc.php [195] /classes/Tools.php [564] /classes/Tools.php [498] |
Country | 2 | /config/config.inc.php [142] /classes/controller/FrontController.php [279] |
Group | 2 | /classes/Cart.php [184] /modules/customergroup/customergroup.php [42] |
Address | 2 | /classes/Product.php [2937] /classes/Product.php [4404] |
Shop | 1 | /config/config.inc.php [114] |
Theme | 1 | /config/config.inc.php [115] |
ShopGroup | 1 | /classes/shop/Shop.php [518] |
Customer | 1 | /config/config.inc.php [221] |
Currency | 1 | /classes/Tools.php [615] |
Cart | 1 | /classes/controller/FrontController.php [348] |
Tax | 1 | /classes/tax/TaxRulesTaxManager.php [115] |
# | Filename |
---|---|
1 | /index.php |
2 | /config/config.inc.php |
3 | /config/defines.inc.php |
4 | /config/settings.inc.php |
5 | /config/autoload.php |
6 | /config/alias.php |
7 | /classes/PrestaShopAutoload.php |
8 | /cache/class_index.php |
9 | /config/bootstrap.php |
10 | /Core/Business/Core_Business_ContainerBuilder.php |
11 | /Core/Foundation/IoC/Core_Foundation_IoC_Container.php |
12 | /Adapter/Adapter_ServiceLocator.php |
13 | /classes/controller/Controller.php |
14 | /classes/ObjectModel.php |
15 | /Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php |
16 | /classes/db/Db.php |
17 | /classes/Tools.php |
18 | /classes/Context.php |
19 | /classes/shop/Shop.php |
20 | /classes/db/DbPDO.php |
21 | /classes/Configuration.php |
22 | /classes/Validate.php |
23 | /classes/cache/Cache.php |
24 | /Adapter/Adapter_EntityMapper.php |
25 | /classes/db/DbQuery.php |
26 | /classes/Theme.php |
27 | /config/defines_uri.inc.php |
28 | /tools/htmlpurifier/HTMLPurifier.standalone.php |
29 | /classes/Language.php |
30 | /classes/Country.php |
31 | /classes/PrestaShopCollection.php |
32 | /classes/shop/ShopGroup.php |
33 | /classes/Cookie.php |
34 | /classes/Blowfish.php |
35 | /config/smarty.config.inc.php |
36 | /tools/smarty/Smarty.class.php |
37 | /tools/smarty/sysplugins/smarty_internal_data.php |
38 | /tools/smarty/sysplugins/smarty_internal_templatebase.php |
39 | /tools/smarty/sysplugins/smarty_internal_template.php |
40 | /tools/smarty/sysplugins/smarty_resource.php |
41 | /tools/smarty/sysplugins/smarty_internal_resource_file.php |
42 | /tools/smarty/sysplugins/smarty_cacheresource.php |
43 | /tools/smarty/sysplugins/smarty_internal_cacheresource_file.php |
44 | /classes/SmartyCustom.php |
45 | /config/smartyfront.config.inc.php |
46 | /classes/Customer.php |
47 | /classes/Group.php |
48 | /classes/Link.php |
49 | /override/classes/Link.php |
50 | /classes/shop/ShopUrl.php |
51 | /classes/Dispatcher.php |
52 | /classes/Hook.php |
53 | /override/classes/Hook.php |
54 | /classes/module/Module.php |
55 | /tools/mobile_Detect/Mobile_Detect.php |
56 | /config/db_slave_server.inc.php |
57 | /modules/pm_advancedsearch4/pm_advancedsearch4.php |
58 | /modules/pm_advancedsearch4/classes/LinkPM.php |
59 | /modules/pm_advancedsearch4/classes/As4SearchEngineLogger.php |
60 | /modules/pm_advancedsearch4/classes/As4SearchEngineDb.php |
61 | /modules/pm_advancedsearch4/classes/As4SearchEngine.php |
62 | /modules/pm_advancedsearch4/classes/As4SearchEngineIndexation.php |
63 | /modules/pm_advancedsearch4/classes/As4SearchEngineSeo.php |
64 | /modules/pm_advancedsearch4/classes/AdvancedSearchClass.php |
65 | /modules/pm_advancedsearch4/classes/AdvancedSearchCriterionGroupClass.php |
66 | /modules/pm_advancedsearch4/classes/AdvancedSearchCriterionClass.php |
67 | /modules/pm_advancedsearch4/classes/AdvancedSearchSeoClass.php |
68 | /modules/pm_advancedsearch4/AdvancedSearchCoreClass.php |
69 | /modules/pm_advancedsearch4/classes/AdvancedSearchWidgetProxy.php |
70 | /modules/lgmiravia/lgmiravia.php |
71 | /modules/lgmiravia/classes/MiraviaConf.php |
72 | /modules/lgmiravia/classes/MiraviaLicense.php |
73 | /modules/lgmiravia/classes/MiraviaApi.php |
74 | /modules/lgmiravia/classes/apiMiravia/IopSdk.php |
75 | /modules/lgmiravia/classes/apiMiravia/MiraviaAutoloader.php |
76 | /modules/lgmiravia/classes/MiraviaContent.php |
77 | /modules/lgmiravia/classes/MiraviaError.php |
78 | /modules/lgmiravia/classes/MiraviaRequestLog.php |
79 | /modules/lgmiravia/classes/MiraviaCategory.php |
80 | /modules/lgmiravia/classes/MiraviaCategoryRelation.php |
81 | /modules/lgmiravia/classes/MiraviaCarrier.php |
82 | /modules/lgmiravia/classes/MiraviaProduct.php |
83 | /modules/lgmiravia/classes/MiraviaProductCombination.php |
84 | /modules/lgmiravia/classes/MiraviaProperties.php |
85 | /modules/lgmiravia/classes/MiraviaAttribute.php |
86 | /modules/lgmiravia/classes/MiraviaFeature.php |
87 | /modules/lgmiravia/classes/MiraviaOrder.php |
88 | /modules/lgmiravia/classes/MiraviaValidate.php |
89 | /modules/lgmiravia/classes/MiraviaImage.php |
90 | /modules/lgmiravia/classes/MiraviaFeed.php |
91 | /modules/lgmiravia/classes/MiraviaReport.php |
92 | /modules/lgmiravia/classes/MiraviaRate.php |
93 | /modules/lgmiravia/classes/MiraviaTools.php |
94 | /modules/lgmiravia/classes/MiraviaExtras.php |
95 | /classes/Translate.php |
96 | /modules/lgmiravia/translations/fr.php |
97 | /controllers/front/BestSalesController.php |
98 | /classes/controller/FrontController.php |
99 | /themes/warehouse/lang/fr.php |
100 | /classes/Currency.php |
101 | /classes/Cart.php |
102 | /classes/CartRule.php |
103 | /classes/Meta.php |
104 | /classes/Product.php |
105 | /classes/webservice/WebserviceRequest.php |
106 | /override/classes/webservice/WebserviceRequest.php |
107 | /modules/cedconnector/classes/WebserviceSpecificManagementCedproducts.php |
108 | /modules/cedconnector/classes/CedPrepareProducts.php |
109 | /modules/cedconnector/classes/cedconnector.class.helper.php |
110 | /classes/webservice/WebserviceSpecificManagementInterface.php |
111 | /modules/cedconnector/classes/WebserviceSpecificManagementCedShipping.php |
112 | /modules/cedconnector/classes/WebserviceSpecificManagementCedCurrency.php |
113 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderStatus.php |
114 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderCreate.php |
115 | /modules/cedconnector/classes/cedconnector.class.order.import.php |
116 | /modules/cedconnector/classes/WebserviceSpecificManagementCedAttribute.php |
117 | /modules/cedconnector/classes/WebserviceSpecificManagementCedNestedCategories.php |
118 | /modules/cedconnector/classes/WebserviceSpecificManagementCedFeatures.php |
119 | /modules/cedconnector/classes/WebserviceSpecificManagementCedUpdateStock.php |
120 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderDetails.php |
121 | /modules/cedconnector/classes/WebserviceSpecificManagementCedOrderUpdate.php |
122 | /modules/cedconnector/classes/WebserviceSpecificManagementCedExecuteQuery.php |
123 | /modules/cedconnector/classes/WebserviceSpecificManagementCedStockSync.php |
124 | /classes/Media.php |
125 | /modules/blockcurrencies/blockcurrencies.php |
126 | /themes/warehouse/modules/blockcurrencies/translations/fr.php |
127 | /modules/blockcurrencies/translations/fr.php |
128 | /modules/blocklanguages/blocklanguages.php |
129 | /themes/warehouse/modules/blocklanguages/translations/fr.php |
130 | /modules/blocklanguages/translations/fr.php |
131 | /modules/blockmanufacturer/blockmanufacturer.php |
132 | /themes/warehouse/modules/blockmanufacturer/translations/fr.php |
133 | /modules/blockmanufacturer/translations/fr.php |
134 | /modules/blockmyaccount/blockmyaccount.php |
135 | /themes/warehouse/modules/blockmyaccount/translations/fr.php |
136 | /modules/blockmyaccount/translations/fr.php |
137 | /modules/feeder/feeder.php |
138 | /themes/warehouse/modules/feeder/translations/fr.php |
139 | /modules/feeder/translations/fr.php |
140 | /cache/smarty/compile/da/a5/80/daa5801dba03ca6be725f91e8e03207dbdbcfced.file.feederHeader.tpl.php |
141 | /tools/smarty/sysplugins/smarty_internal_filter_handler.php |
142 | /tools/minify_html/minify_html.class.php |
143 | /modules/blockuserinfo/blockuserinfo.php |
144 | /themes/warehouse/modules/blockuserinfo/translations/fr.php |
145 | /modules/blockuserinfo/translations/fr.php |
146 | /modules/productcomments/productcomments.php |
147 | /themes/warehouse/modules/productcomments/translations/fr.php |
148 | /modules/productcomments/translations/fr.php |
149 | /modules/blockcontactinfos/blockcontactinfos.php |
150 | /themes/warehouse/modules/blockcontactinfos/translations/fr.php |
151 | /modules/blockcontactinfos/translations/fr.php |
152 | /modules/productsnavpn/productsnavpn.php |
153 | /themes/warehouse/modules/productsnavpn/translations/fr.php |
154 | /modules/customcontactpage/customcontactpage.php |
155 | /themes/warehouse/modules/customcontactpage/translations/fr.php |
156 | /modules/blockwishlist/blockwishlist.php |
157 | /modules/blockwishlist/WishList.php |
158 | /themes/warehouse/modules/blockwishlist/translations/fr.php |
159 | /modules/blockwishlist/translations/fr.php |
160 | /modules/productsmanufacturer/productsmanufacturer.php |
161 | /themes/warehouse/modules/productsmanufacturer/translations/fr.php |
162 | /modules/footercontent/footercontent.php |
163 | /themes/warehouse/modules/footercontent/translations/fr.php |
164 | /modules/footercontent/HtmlFooterContent.php |
165 | /modules/mailalerts/mailalerts.php |
166 | /modules/mailalerts/MailAlert.php |
167 | /themes/warehouse/modules/mailalerts/translations/fr.php |
168 | /modules/mailalerts/translations/fr.php |
169 | /modules/crossselling_mod/crossselling_mod.php |
170 | /themes/warehouse/modules/crossselling_mod/translations/fr.php |
171 | /modules/pluginadder/pluginadder.php |
172 | /themes/warehouse/modules/pluginadder/translations/fr.php |
173 | /modules/blockcart/blockcart.php |
174 | /themes/warehouse/modules/blockcart/translations/fr.php |
175 | /modules/blocksearch_mod/blocksearch_mod.php |
176 | /themes/warehouse/modules/blocksearch_mod/translations/fr.php |
177 | /modules/blocksearch_mod/translations/fr.php |
178 | /cache/smarty/compile/32/38/0c/32380c944294386a2da475bb5223e2456c9b9a14.file.blocksearch_modh.tpl.php |
179 | /modules/themeeditor/themeeditor.php |
180 | /themes/warehouse/modules/themeeditor/translations/fr.php |
181 | /classes/Image.php |
182 | /modules/iqitmegamenu/iqitmegamenu.php |
183 | /modules/iqitmegamenu/models/IqitMenuTab.php |
184 | /modules/iqitmegamenu/models/IqitMenuHtml.php |
185 | /modules/iqitmegamenu/models/IqitMenuLinks.php |
186 | /themes/warehouse/modules/iqitmegamenu/translations/fr.php |
187 | /modules/pdfcatalogo/pdfcatalogo.php |
188 | /modules/pdfcatalogo/PdfCatalogoHelper.php |
189 | /themes/warehouse/modules/pdfcatalogo/translations/fr.php |
190 | /modules/baabandonedcartreminder/baabandonedcartreminder.php |
191 | /init.php |
192 | /themes/warehouse/modules/baabandonedcartreminder/translations/fr.php |
193 | /modules/customergroup/customergroup.php |
194 | /themes/warehouse/modules/customergroup/translations/fr.php |
195 | /classes/Category.php |
196 | /modules/masbarato/masbarato.php |
197 | /themes/warehouse/modules/masbarato/translations/fr.php |
198 | /modules/masbarato/translations/fr.php |
199 | /modules/eicaptcha/eicaptcha.php |
200 | /themes/warehouse/modules/eicaptcha/translations/fr.php |
201 | /modules/eicaptcha/translations/fr.php |
202 | /modules/rcpgtagmanager/rcpgtagmanager.php |
203 | /modules/rcpgtagmanager/vendor/autoload.php |
204 | /modules/rcpgtagmanager/vendor/composer/autoload_real.php |
205 | /modules/rcpgtagmanager/vendor/composer/ClassLoader.php |
206 | /modules/rcpgtagmanager/vendor/composer/autoload_namespaces.php |
207 | /modules/rcpgtagmanager/vendor/composer/autoload_psr4.php |
208 | /modules/rcpgtagmanager/vendor/composer/autoload_classmap.php |
209 | /themes/warehouse/modules/rcpgtagmanager/translations/fr.php |
210 | /modules/rcpgtagmanager/translations/fr.php |
211 | /modules/rcpgtagmanager/src/rcpgtagmanagertools.php |
212 | /cache/smarty/compile/8e/2d/2e/8e2d2eb1ffcf45aa672c8bba53c3e2aeb20a1706.file.header.tpl.php |
213 | /themes/warehouse/modules/pm_advancedsearch4/translations/fr.php |
214 | /modules/pm_advancedsearch4/translations/fr.php |
215 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/6/08791267623aeee753db0ce208f1afec8a04c220/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
216 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/7/4530363c893a595a479e2cbb02ecbab83b6cbad9/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
217 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/9/86ada09a3412cec67caf0d3f86b186ed822a3d8f/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
218 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/10/51d9ecafa80b62bf28ddcdf4751eb1ad581f481c/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
219 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getPriceRangeForSearchBloc/11/2fab87b58327be0e9432ad51e82333da4afbb6ea/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
220 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/14/f5483e1fff3cd2c8089021a4f87481b365956f22/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
221 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/12/17bd13b42c3caf48fe32af5633f7f7286de0bb1f/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
222 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getCriterionsForSearchBloc/13/2e2438d5ff64a0ae8e2f2485af7beacb4099c6c2/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
223 | /cache/smarty/cache/pm_advancedsearch/1/customCache/getProductsSearched/60a6c74f94d097f40f362cfed11f281ffdbfb4d5/1/1/1/1/5/1/6/da39289efea23ad53591f376d27d81454ea99300/65/75/89/657589eb6708bbb08b8794cfa3387d13671644ed.cache.tpl.php |
224 | /cache/smarty/compile/62/65/7b/62657b649dad20c337ed10f06ea424d307592ece.file.pm_advancedsearch.tpl.php |
225 | /cache/smarty/compile/e3/b2/bd/e3b2bd4d773742a3894ed967b7d3362b1fcc8164.file.pm_advancedsearch_header_block.tpl.php |
226 | /cache/smarty/compile/50/e6/82/50e6826bf54f7600a537120ec1ff7b2c78d146d2.file.pm_advancedsearch_criterions.tpl.php |
227 | /cache/smarty/compile/4a/92/ec/4a92ecf704a311daf8563e8bc2575a6ecbb20297.file.pm_advancedsearch_criterions_select.tpl.php |
228 | /cache/smarty/compile/d5/6f/3a/d56f3a28ce1edd1b98fca644b2c50b9183a30f77.file.pm_advancedsearch_criterions_range.tpl.php |
229 | /cache/smarty/compile/41/73/34/417334e0fdbba2184dcf050ffd2df2f2d6143804.file.pm_advancedsearch_footer_block.tpl.php |
230 | /tools/js_minify/jsmin.php |
231 | /modules/facebookpsconnect/facebookpsconnect.php |
232 | /modules/facebookpsconnect/conf/common.conf.php |
233 | /modules/facebookpsconnect/lib/warning_class.php |
234 | /modules/facebookpsconnect/lib/module-tools_class.php |
235 | /themes/warehouse/modules/facebookpsconnect/translations/fr.php |
236 | /modules/facebookpsconnect/fr.php |
237 | /modules/facebookpsconnect/conf/hook.conf.php |
238 | /modules/facebookpsconnect/lib/hook/hook-ctrl_class.php |
239 | /modules/facebookpsconnect/lib/hook/i-hook_class.php |
240 | /modules/facebookpsconnect/lib/hook/hook-display_class.php |
241 | /modules/facebookpsconnect/lib/module-dao_class.php |
242 | /modules/facebookpsconnect/lib/render/facade-render-connectors_class.php |
243 | /modules/facebookpsconnect/lib/render/render-connectors_class.php |
244 | /cache/smarty/compile/e7/66/db/e766db28fdf284b55b8a9087321ddfb532a72173.file.header.tpl.php |
245 | /modules/blockbanner/blockbanner.php |
246 | /themes/warehouse/modules/blockbanner/translations/fr.php |
247 | /modules/blockbanner/translations/fr.php |
248 | /modules/nxr_product_bestseller/nxr_product_bestseller.php |
249 | /themes/warehouse/modules/nxr_product_bestseller/translations/fr.php |
250 | /modules/paypalwithfee/paypalwithfee.php |
251 | /modules/paypalwithfee/classes/PaypalOrder.php |
252 | /modules/paypalwithfee/classes/PaypalRefund.php |
253 | /classes/PaymentModule.php |
254 | /themes/warehouse/modules/paypalwithfee/translations/fr.php |
255 | /modules/paypalwithfee/translations/fr.php |
256 | /modules/lgcookieslaw/lgcookieslaw.php |
257 | /themes/warehouse/modules/lgcookieslaw/translations/fr.php |
258 | /modules/lgcookieslaw/translations/fr.php |
259 | /modules/glsshipping/glsshipping.php |
260 | /modules/glsshipping/classes/GlsshippingUpdate.php |
261 | /classes/module/CarrierModule.php |
262 | /classes/log/FileLogger.php |
263 | /classes/log/AbstractLogger.php |
264 | /themes/warehouse/modules/glsshipping/translations/fr.php |
265 | /modules/redsys/redsys.php |
266 | /modules/redsys/api/apiRedsys.php |
267 | /modules/redsys/api/json.php |
268 | /modules/redsys/api/hmac.php |
269 | /modules/redsys/api/hash.php |
270 | /modules/redsys/api/idnovateUtils.php |
271 | /modules/redsys/classes/RedsysTpv.php |
272 | /themes/warehouse/modules/redsys/translations/fr.php |
273 | /modules/iqitcontentcreator/iqitcontentcreator.php |
274 | /modules/iqitcontentcreator/models/IqitCreatorHtml.php |
275 | /themes/warehouse/modules/iqitcontentcreator/translations/fr.php |
276 | /modules/sekeywords/sekeywords.php |
277 | /classes/module/ModuleGraph.php |
278 | /themes/warehouse/modules/sekeywords/translations/fr.php |
279 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/5/1/6/ce/2c/27/ce2c27172c7a4e41ad12781dd622db414db40db1.blocksearch-top_mod.tpl.php |
280 | /cache/smarty/compile/12/ae/c7/12aec79669229e021da11d18ac3ec280dcc2baf1.file.blockuserinfo.tpl.php |
281 | /Adapter/Adapter_AddressFactory.php |
282 | /Adapter/Adapter_ProductPriceCalculator.php |
283 | /Adapter/Adapter_Configuration.php |
284 | /Core/Business/Core_Business_ConfigurationInterface.php |
285 | /classes/Customization.php |
286 | /cache/smarty/compile/72/7e/d5/727ed5f4a47097d819d3f831aedb113965e921cd.file.blockcart.tpl.php |
287 | /tools/smarty/plugins/modifier.replace.php |
288 | /tools/smarty/plugins/function.counter.php |
289 | /cache/smarty/compile/c8/56/86/c85686185a917643f4b42c2b4c967c34304d3b45.file.blockwishlist_top.tpl.php |
290 | /modules/facebookpsconnect/lib/render/iterator-render-connectors_class.php |
291 | /cache/smarty/compile/3d/4d/92/3d4d923a54aa229deb1614884366255dae01e77d.file.connector-buttons-js.tpl.php |
292 | /classes/ProductSale.php |
293 | /classes/Combination.php |
294 | /classes/stock/StockAvailable.php |
295 | /classes/tax/Tax.php |
296 | /classes/Address.php |
297 | /classes/SpecificPrice.php |
298 | /classes/tax/TaxManagerFactory.php |
299 | /classes/tax/TaxRulesTaxManager.php |
300 | /classes/tax/TaxManagerInterface.php |
301 | /classes/tax/TaxCalculator.php |
302 | /classes/GroupReduction.php |
303 | /classes/Feature.php |
304 | /cache/smarty/cache/productlist_colors/300/1/5/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
305 | /cache/smarty/cache/productlist_colors/6571/1/5/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.product-list-colors.tpl.php |
306 | /cache/smarty/compile/eb/6c/5f/eb6c5fe182bb26dd9619b9efe2c7acf95f8bd04d.file.product-list-colors.tpl.cache.php |
307 | /tools/smarty/sysplugins/smarty_internal_write_file.php |
308 | /classes/ImageType.php |
309 | /cache/smarty/cache/blockcontactinfos/1/1/1/1/5/1/6/bc/3e/6f/bc3e6f0d6bd38ec8a7c392752be20f0eeeb06022.blockcontactinfos.tpl.php |
310 | /cache/smarty/compile/95/61/a1/9561a1e14f547cf63206a2dfa3bf581a775df28f.file.footer.tpl.php |
311 | /classes/CMS.php |
312 | /cache/smarty/compile/7a/c4/e0/7ac4e0fd50add7456c47f0e68531425ef3787f20.file.cookieslaw.tpl.php |
313 | /cache/smarty/compile/40/3d/71/403d71a762947f16a7fb708839cd0d533130111f.file.best-sales.tpl.php |
314 | /cache/smarty/compile/4d/78/46/4d7846777d384bb54495bfdb53cdda08bfa9a66b.file.product-sort.tpl.php |
315 | /cache/smarty/compile/19/e8/0c/19e80caf79a50922b6bf78fd9404185cc9ffee17.file.nbr-product-page.tpl.php |
316 | /cache/smarty/compile/6d/1f/52/6d1f52f3906b603c4bb386ed9a01c576f34b5006.file.pagination.tpl.php |
317 | /cache/smarty/compile/84/33/2c/84332cd8dc3b11b7526c3c542137e3fb30374436.file.product-list.tpl.php |
318 | /tools/smarty/plugins/function.math.php |
319 | /cache/smarty/compile/3c/16/62/3c1662553ab7198b9693ba318f146941c0624bc0.file.blockwishlist_button.tpl.php |
320 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/249/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
321 | /modules/attributes/attributes.php |
322 | /themes/warehouse/modules/attributes/translations/fr.php |
323 | /cache/smarty/compile/52/f0/1e/52f01e3a52fd9c7b842f598556a9af2e6c64a60d.file.combinations.tpl.php |
324 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10164/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
325 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10093/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
326 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/9812/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
327 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/9323/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
328 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/7468/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
329 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/7182/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
330 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/6356/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
331 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/4647/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
332 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/1310/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
333 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/1061/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
334 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/300/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
335 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10762/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
336 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10432/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
337 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10400/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
338 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10331/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
339 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10208/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
340 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/10180/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
341 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/9752/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
342 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/9539/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
343 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/8412/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
344 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/6571/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
345 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/6493/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
346 | /cache/smarty/cache/productcomments/1/1/1/1/5/1/6/6362/64/b8/17/64b8176982eb378fa5ba1b61c746ffd1c61a0b19.productcomments_reviews.tpl.php |
347 | /cache/smarty/compile/53/1d/43/531d43d333f323e579e1f876532a548044dc298f.file.layout.tpl.php |
348 | /cache/smarty/compile/4a/35/98/4a3598bffa820b6b0d5494707365394e96698ac9.file.header.tpl.php |
349 | /tools/smarty/plugins/function.implode.php |
350 | /cache/smarty/compile/3c/6c/34/3c6c34e1cac2e2861343e8e60925e1dfb9d27f2e.file.global.tpl.php |
351 | /cache/smarty/compile/58/63/a4/5863a4956e9578fe17f1584ec77fa232640fdacd.file.blockcurrencies.tpl.php |
352 | /cache/smarty/compile/9c/3f/72/9c3f72fbff97ede10bfca51a951faf01955cc06d.file.blocklanguages.tpl.php |
353 | /tools/smarty/plugins/modifier.regex_replace.php |
354 | /cache/smarty/compile/52/e1/45/52e145a3af78feaf349d33da9ab1c5aa33c7c596.file.mobile-header1.tpl.php |
355 | /cache/smarty/compile/02/8c/16/028c16af65e4de77ec1985877c23c0db654e709b.file.mobile-user.tpl.php |
356 | /cache/smarty/cache/blocksearch_mod/1/1/1/1/5/1/6/8e/c1/db/8ec1dbda411bcdd440fc29d6b6783fe94fe76a08.blocksearch-mobile.tpl.php |
357 | /cache/smarty/cache/iqitmegamenu/1/1/1/1/5/1/6/10/41/f0/34/41f034112f7eceb4890d132af08ee3198f1d6bef.iqitmegamenu.tpl.php |
358 | /cache/smarty/compile/e5/58/f6/e558f6c22cf7f00714cabf72ab8862c3ac4263ff.file.breadcrumb.tpl.php |
359 | /cache/smarty/compile/82/97/9c/82979c59cc436fcbe825fac6cbe7769592ce500f.file.footer.tpl.php |
360 | /tools/smarty/plugins/modifier.date_format.php |
361 | /tools/smarty/plugins/shared.mb_str_replace.php |
362 | /cache/smarty/compile/42/2e/17/422e17da2efcc7a9532d918d2efb5a17d931bec9.file.javascript.tpl.php |