> ARMYTRIX

TORQEN is an authorised distributor of ARMYTRIX in UK / Europe

per page
Showing 361 - 384 of 926 items
Load Time381 ms - Unicorn powered webserver!
Querying Time214 ms
Queries515
Memory Peak Usage16.3 Mb
Included Files258 files - 5.94 Mb
PrestaShop Cache- Mb
Global vars0.53 Mb
PrestaShop Version1.6.1.24
PHP Version7.0.33 (OK)
MySQL Version10.11.2-MariaDB-log (OK)
Memory Limit1024M
Max Execution Time1800s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 53 ms 53 ms 4.53 Mb 5.48 Mb
__construct 0 ms 53 ms - Mb 5.48 Mb
init 5 ms 58 ms 0.46 Mb 5.48 Mb
checkAccess 0 ms 58 ms - Mb 5.48 Mb
setMedia 1 ms 59 ms 0.01 Mb 5.48 Mb
postProcess 0 ms 59 ms - Mb 5.48 Mb
initHeader 0 ms 59 ms - Mb 5.48 Mb
initContent 251 ms 310 ms 7.85 Mb 12.85 Mb
initFooter 9 ms 319 ms 0.49 Mb 14.15 Mb
display 62 ms 381 ms 2.02 Mb 16.35 Mb
Hook Time Memory Usage
hookm4DiscountSpecificPriceClass 21 ms - Mb
hookdisplayHeader 10 ms - Mb
__construct 8 ms - Mb
hookdisplayMegaMenu 5 ms - Mb
hookdisplayFooter 5 ms - Mb
hookheader 4 ms - Mb
hookfooter 3 ms - Mb
hooktop 3 ms - Mb
hookdisplayHomeTab 2 ms - Mb
hookdisplayNav 1 ms - Mb
hookdisplayTop 1 ms - Mb
hookdisplayBanner 0 ms - Mb
hookdisplayTopColumn 0 ms - Mb
hookmoduleRoutes - ms - Mb
14 hooks 63 ms - Mb
Module Time Memory Usage
m4manufacturerdiscount 21 ms - Mb
ets_megamenu 10 ms - Mb
whatsappchat 8 ms - Mb
ets_superspeed 4 ms - Mb
sfkseoschema 3 ms - Mb
omicronCategories 3 ms - Mb
blockcart 2 ms - Mb
blocksearch 1 ms - Mb
uecookie 1 ms - Mb
simpleimportproduct 1 ms - Mb
blockomicronnewsletter 1 ms - Mb
trustpilot 1 ms - Mb
blockcontactinfos 1 ms - Mb
spreset 1 ms - Mb
blockcms 1 ms - Mb
blockcontact 1 ms - Mb
blockuserinfo 1 ms - Mb
clearpay 0 ms - Mb
blockwishlist 0 ms - Mb
reviewsadv 0 ms - Mb
omicron_themecontroller 0 ms - Mb
blockviewed 0 ms - Mb
blockpaymentlogo 0 ms - Mb
vatnumber 0 ms - Mb
paypalwithfee 0 ms - Mb
a4ppaypalpro 0 ms - Mb
homeslider 0 ms - Mb
blockmyaccount 0 ms - Mb
oversizeproducts 0 ms - Mb
guestbook 0 ms - Mb
blocklayered 0 ms - Mb
blockfeaturedfooter 0 ms - Mb
32 modules 63 ms - Mb
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

Stopwatch SQL - 515 queries

Query Time (ms) Rows Filesort Group By Location 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.`id_product_attribute`,0) id_product_attribute
, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`,
pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2025-08-13 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new 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 (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` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON (m.`id_manufacturer` = p.`id_manufacturer`)
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  )JOIN `ps_category_product` cp ON (p.id_product = cp.id_product)JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` IN (1))JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_manufacturer` = 47
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY pl.`name` asc
LIMIT 360,24
 47.2 932 Yes Yes /classes/Manufacturer.php:386 
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`)
 25.7 11244 /classes/Configuration.php:148 
SELECT SQL_NO_CACHE p.`id_product`
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)
WHERE p.id_manufacturer = 47 AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND EXISTS (
SELECT 1
FROM `ps_category_group` cg
LEFT JOIN `ps_category_product` cp ON (cp.`id_category` = cg.`id_category`) INNER JOIN `ps_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE p.`id_product` = cp.`id_product` AND cg.`id_group` IN (1)
)
 6.2 932 /classes/Manufacturer.php:322 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2736 AND c.nright >= 2737)
ORDER BY c.nleft
 3.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2862 AND c.nright >= 2863)
ORDER BY c.nleft
 2.8 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2874 AND c.nright >= 2875)
ORDER BY c.nleft
 2.5 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.5 590 /classes/Hook.php:235 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2862 AND c.nright >= 2863)
ORDER BY c.nleft
 2.5 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2876 AND c.nright >= 2877)
ORDER BY c.nleft
 2.5 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2660 AND c.nright >= 2661)
ORDER BY c.nleft
 2.3 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2506 AND c.nright >= 2507)
ORDER BY c.nleft
 2.3 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2632 AND c.nright >= 2633)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2546 AND c.nright >= 2547)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2652 AND c.nright >= 2653)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2930 AND c.nright >= 2931)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2654 AND c.nright >= 2655)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2664 AND c.nright >= 2665)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2628 AND c.nright >= 2629)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2644 AND c.nright >= 2645)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2648 AND c.nright >= 2649)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2548 AND c.nright >= 2549)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2932 AND c.nright >= 2933)
ORDER BY c.nleft
 2.2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 3016 AND c.nright >= 3017)
ORDER BY c.nleft
 2.1 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 3044 AND c.nright >= 3045)
ORDER BY c.nleft
 2.1 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2930 AND c.nright >= 2931)
ORDER BY c.nleft
 2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 2756 AND c.nright >= 2757)
ORDER BY c.nleft
 2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 3022 AND c.nright >= 3023)
ORDER BY c.nleft
 2 4395 Yes /classes/Product.php:5858 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 3038 AND c.nright >= 3039)
ORDER BY c.nleft
 2 4395 Yes /classes/Product.php:5858 
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 h.`name` != "displayPaymentEU") 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.6 114 Yes Yes /classes/Hook.php:355 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|55342|1|1","", FROM_UNIXTIME(1755085583))
 1.2 1 /classes/SmartyCustom.php:263 
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.8 0 /classes/Hook.php:131 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54936,55335,55342,53530,54529,54512,54507,54549,53541,56012,51732,50671,48239,48242,48275,48295,47667,47678,48110,49981,47289,47295,47281,47232) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
 0.7 90 Yes Yes /classes/Product.php:3464 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.7 320 /classes/SpecificPrice.php:230 
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.6 129 /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.6 129 /classes/module/Module.php:277 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.5 1 /classes/shop/Shop.php:1067 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 0.4 319 /classes/SpecificPrice.php:238 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
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.3 44 Yes /classes/Dispatcher.php:452 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54936) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.torqen.uk' OR su.domain_ssl = 'www.torqen.uk')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.3 1 Yes /classes/shop/Shop.php:334 
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
 0.3 1 Yes /classes/shop/Shop.php:663 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 50671) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 48239) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4303 LIMIT 1
 0.3 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 17
AND tr.`id_tax_rules_group` = 10
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.3 1 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 17, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 17) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2025-08-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-08-13 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.3 1 Yes /classes/SpecificPrice.php:361 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 48242) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 48275) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 55335) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 56012) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 48295) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47667) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayBanner" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47678) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54507) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 55342) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54549) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53541) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53530) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 48110) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 51732) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54529) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "badge" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.3 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
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` = 50671)
 0.3 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54512) AND (b.`id_shop` = 1) LIMIT 1
 0.3 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =2 AND m.page = "manufacturer" LIMIT 1
 0.3 1 /classes/Theme.php:275 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47289) AND (b.`id_shop` = 1) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "top" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
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` = 48239)
 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 49981) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47232) 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` = 54936)
 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47281) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 47295) 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` = 55335)
 0.2 3 /classes/Product.php:2998 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 55342)
 0.2 3 /classes/Product.php:2998 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 54549)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayHeader" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
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` = 51732)
 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` = 56012)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
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` = 48242)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.2 1 /classes/shop/Shop.php:202 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 53541)
 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` = 53530)
 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` = 48275)
 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` = 48295)
 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` = 54507)
 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` = 54529)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `active` = 1 ORDER BY position
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:78 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48239
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 54512)
 0.2 1 /classes/Product.php:2998 
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 1 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` = 47667)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE id_lang FROM `ps_lang` WHERE is_rtl=0 AND active=1 LIMIT 1
 0.2 1 /modules/ets_megamenu/classes/MM_Obj.php:462 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 50671
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 47678)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54936
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM ps_memcached_servers
 0.2 1 /classes/cache/CacheMemcached.php:230 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
 0.2 1 /classes/Image.php:471 
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.2 1 /classes/Language.php:892 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55335
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
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.2 1 /classes/Currency.php:470 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 49981)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayFooter" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='9e7aced908cbfc6e5e48d8dfec8b659e' AND cache_id="blockcontact|1|1|1|17" AND compile_id="" LIMIT 1
 0.2 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48275
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "hookDisplayTopColumn" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48239
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 1 
WHERE (c.nleft <= 0 AND c.nright >= 0)
ORDER BY c.nleft
 0.2 1 /classes/Product.php:5858 
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` = 302639 LIMIT 1
 0.2 1 /classes/Combination.php:343 
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` = 48110)
 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` = 47232)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 47289)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48239
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 50671
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54936
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48242
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "floating" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48275
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 50671
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53530
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54507
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
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.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55342
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54512
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.2 65 /classes/module/Module.php:2141 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 56012
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48242
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54529
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54936
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53541
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54549
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47678
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 47281)
 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` = 47295)
 0.2 1 /classes/Product.php:2998 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55335
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54936
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 17) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54549
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53541
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53530
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55342
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
 0.2 86 /classes/Hook.php:187 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48242
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54529
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_image_shop` image_shop
WHERE image_shop.`id_product` = 0
AND image_shop.`cover`= 1 LIMIT 1
 0.2 1 /classes/Image.php:294 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 51732
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54512
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54512
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 49981
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54507
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48275
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 48239
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.2 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 51732
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47667
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "topWidthSticky" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE * FROM `ps_whatsappchatblock` LEFT JOIN `ps_whatsappchatblock_lang` ON (`ps_whatsappchatblock`.`id_whatsappchatblock` = `ps_whatsappchatblock_lang`.`id_whatsappchatblock` AND `id_lang` = 1) WHERE `id_hook` = "bottomWidth" AND `id_shop` = 1 AND `active` = 1 ORDER BY position DESC;
 0.2 1 Yes /modules/whatsappchat/classes/WhatsappChatBlock.php:135 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53541
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48239
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 49981
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 56012
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47667
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47678
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48275
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54549
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 49981
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 56012
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54507
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55335
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53530
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 50671
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47667
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 17
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.2 0 /classes/tax/TaxRulesTaxManager.php:108 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48242
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54529
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55342
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 49981
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 51732
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54549
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
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.2 1 /classes/Language.php:777 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54512
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 1
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 47) LIMIT 1
 0.2 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47678
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `name` ASC
 0.2 9 Yes /classes/ImageType.php:108 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47289
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53530
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 50671
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.2 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55342
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 51732
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54529
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 55335
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 53541
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47678
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 56012
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 54507
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.2 1 /classes/shop/ShopUrl.php:169 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47289
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48110
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47667
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47232
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47281
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47232
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47281
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48110
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47289
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.2 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blockcart" LIMIT 1
 0.2 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 50671) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48239) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.2 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE sfk_title FROM ps_sfkcustomhead  WHERE sfk_status= 1 AND sfk_bodytag = 0 AND FIND_IN_SET('1', `sfk_language`) AND FIND_IN_SET('47', `sfk_manufacturer`) AND FIND_IN_SET('1', `sfk_shop_group`) AND FIND_IN_SET('1', `sfk_shop`) order by id_sfkcustomhead desc LIMIT 1
 0.1 1 /modules/sfkseoschema/sfkseoschema.php:2606 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47232
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE *
FROM `ps_whatsappchatblock_agent` LEFT JOIN `ps_whatsappchatblock_agent_lang` ON (`ps_whatsappchatblock_agent`.`id_whatsappchatblock_agent` = `ps_whatsappchatblock_agent_lang`.`id_whatsappchatblock_agent` AND `id_lang` = 1) WHERE 1 = 1 AND `ps_whatsappchatblock_agent`.`id_whatsappchatblock` = 1 AND `active` = 1 ORDER BY position
 0.1 1 Yes /modules/whatsappchat/classes/WhatsappChatBlockAgent.php:78 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48110
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47281
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
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 md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47281
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 302813 LIMIT 1
 0.1 1 /classes/Combination.php:343 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47232
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47289
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 48110
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
FROM `ps_product` p
LEFT OUTER JOIN `ps_m4_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
WHERE p.`id_product` = 47295
AND md.`id_group` = 1 AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT 1
 0.1 1 /modules/m4manufacturerdiscount/m4manufacturerdiscount.php:263 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 17) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 54936) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|53530|1|1" AND compile_id="" LIMIT 1
 0.1 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE * FROM ps_sfkhreflang WHERE sfk_status =1 AND sfk_shop_group ='1' AND sfk_blogurl='0'
 0.1 1 /modules/sfkseoschema/sfkseoschema.php:2348 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48242) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE domain,physical_uri FROM ps_shop_url WHERE id_shop='1'
 0.1 1 /modules/sfkseoschema/sfkseoschema.php:1554 
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
 0.1 1 /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` = 302792 LIMIT 1
 0.1 1 /classes/Combination.php:343 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3898 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` = 56012
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`
FROM `ps_manufacturer_lang` ml
LEFT JOIN `ps_manufacturer` m ON (ml.`id_manufacturer` = m.`id_manufacturer`)
WHERE ml.id_lang = 1
AND ml.id_manufacturer = 47 LIMIT 1
 0.1 1 /classes/Meta.php:334 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pagecache" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
 0.1 1 /classes/SmartyCustom.php:95 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 53530) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48275) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 56012) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 55342) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 49981
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 = 55335) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
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 SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 48295) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 51732) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 53541) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 54529) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 54512) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 47667) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 53530
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` = 51732
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 = 49981) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 54549) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 54507) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 17
 0.1 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 47678) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3882 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
 0.1 1 /classes/SpecificPrice.php:230 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='2db471bff8deffe8229c20ce113970a5' AND cache_id="blockcontactinfos|1|1|1|17" 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` = 48275
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 '2025-08-13 00:00:00' AND '2025-08-13 23:59:59' LIMIT 1
 0.1 1 /classes/SpecificPrice.php:301 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 54936
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` = "ultimateimagetool" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4303 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "deluxeprivateshop" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `ps_specific_price` WHERE `id_product_attribute` != 0
 0.1 1 /classes/SpecificPrice.php:238 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|54936|1|1" 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 = 47289) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE *
FROM `ps_theme` a
WHERE (a.`id_theme` = 2) LIMIT 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:61 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|54529|1|1" 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 = 47295) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47232|1|1" 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` = 55335
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`='d3ccb7b7da692b7b6d234c1d5da4d516' AND cache_id="blockcms|2|1|1|1|17" 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 = 47281) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 47232) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a1364e2cf034f6de1b7d9aa0060b8c1f' AND cache_id="blocksearch-top|1|1|1|17" 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 = 48110) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4071 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|54512|1|1" AND compile_id="" LIMIT 1
 0.1 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
 0.1 1 /classes/SmartyCustom.php:142 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|48239|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|54507|1|1" AND compile_id="" LIMIT 1
 0.1 1 /classes/SmartyCustom.php:215 
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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|51732|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|54549|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47667|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47281|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|56012|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|48110|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47295|1|1" 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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4323 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47678|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|50671|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|49981|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|48295|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|48275|1|1" 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 = 54936) AND (id_product_attribute = 302639) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 55342) AND (id_product_attribute = 302813) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|53541|1|1" AND compile_id="" LIMIT 1
 0.1 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "productcomments" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|48242|1|1" AND compile_id="" LIMIT 1
 0.1 1 /classes/SmartyCustom.php:215 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocksearch" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 54529
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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4225 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 47667
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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4223 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 54936 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 54549
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE domain,physical_uri FROM ps_shop_url WHERE id_shop='1'
 0.1 1 /modules/sfkseoschema/sfkseoschema.php:2152 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 53541
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` = "ybc_blog" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 48242
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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|55335|1|1" 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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3814 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
 0.1 1 /Adapter/Adapter_EntityMapper.php:68 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 54507
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1450 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 55335) AND (id_product_attribute = 302792) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.1 1 /classes/stock/StockAvailable.php:378 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 47289
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` = 48239 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_imageslider" 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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3820 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` = 47678
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` = "blockbanner" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 48295
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE id_lang FROM `ps_lang` WHERE is_rtl=1 AND active=1 LIMIT 1
 0.1 1 /modules/ets_megamenu/classes/MM_Obj.php:462 
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|55342|1|1" 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`='3d3837de2f4f368c2d3f4715553290f1' AND cache_id="productlist_colors|47289|1|1" 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` = 53541 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2025-08-13 00:00:00' AND '2025-08-13 23:59:59' LIMIT 1
 0.1 1 /classes/SpecificPrice.php:305 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 54512
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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4220 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 374 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3821 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 48295 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 48275 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 50671 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 48242 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4335 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4077 LIMIT 1
 0.1 1 /classes/Category.php:1054 
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 `id_module` FROM `ps_module` WHERE `name` = "blockuserinfo" 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` = 54507 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 47295
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` = 47232
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` = 56012 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 51732 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 53530 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3814 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 55342 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 55342
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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4073 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 4324 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 55335 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 54529 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 54549 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "homeslider" 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` = 54512 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47667 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 661 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4323 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47678 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "idxprivateshop" 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` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3882 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3776 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3821 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3820 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_banner" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 0 LIMIT 1
 0.1 0 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "extendedregistration" LIMIT 1
 0.1 1 /classes/module/Module.php:2568 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4225 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4071 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4223 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4077 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 5 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4335 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 374 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 47667 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4220 LIMIT 1
 0.1 1 /classes/Category.php:1477 
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 nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4324 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE id_shop
FROM `ps_manufacturer_shop`
WHERE `id_manufacturer` = 47
AND id_shop = 1 LIMIT 1
 0.1 1 /classes/ObjectModel.php:1450 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3898 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 4073 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 48110
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` = 54936 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3774 LIMIT 1
 0.1 1 /classes/Category.php:1054 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54936|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 661 LIMIT 1
 0.1 1 /classes/Category.php:1477 
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 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54936|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 48239 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|53530|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 55335 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 216 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` = 50671 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 139 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 209 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 47281
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.1 1 /classes/SpecificPrice.php:196 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 120 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3861 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 28 AND `id_shop` = 1 LIMIT 1
 0.1 1 /classes/module/Module.php:2218 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 48295 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47289 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3779 LIMIT 1
 0.1 1 /classes/Category.php:1054 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 49981 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.1 1 /classes/Group.php:133 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47678|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 3770 LIMIT 1
 0.1 1 /classes/Category.php:1054 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54529|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47281 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48295|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47295 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_zone`
FROM `ps_country`
WHERE `id_country` = 17 LIMIT 1
 0.1 1 /classes/Country.php:196 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 47232 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 48110 AND id_shop=1 LIMIT 1
 0.1 1 /classes/Product.php:5032 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 48242 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` = 48275 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54512|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 151 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47295|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 53530 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54507|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 54507 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` = 55342 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` = 51732 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48295|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47232|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 54549 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` = 47678 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|56012|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48239|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 2 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54549|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 54529 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` = 53541 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3861 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3779 LIMIT 1
 0.1 1 /classes/Category.php:1477 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3770 LIMIT 1
 0.1 1 /classes/Category.php:1477 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|51732|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3774 LIMIT 1
 0.1 1 /classes/Category.php:1477 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47281|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 54512 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48275|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|53541|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48110|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 56012 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 3776 LIMIT 1
 0.1 1 /classes/Category.php:1477 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|50671|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47667|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48242|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.1 0 /classes/module/Module.php:2218 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|55335|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 47281 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` = 47295 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|49981|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 49981 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47289|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 47232 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` = 47289 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` = 48110 AND `id_group` = 1 LIMIT 1
 0.1 0 /classes/GroupReduction.php:149 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|55335|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48275|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47289|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54549|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|55342|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|53530|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48239|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|50671|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|51732|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47295|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54529|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54512|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|56012|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48242|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47667|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47232|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47281|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|54507|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|49981|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|47678|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|48110|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263 
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('3d3837de2f4f368c2d3f4715553290f1',"productlist_colors|53541|1|1","", FROM_UNIXTIME(1755085583))
 0.1 1 /classes/SmartyCustom.php:263

Doubles

96
SELECT md.`id_manufacturer`, md.`id_group`, md.`reduction_price`, md.`reduction_percent`
                FROM `ps_product` p
                LEFT OUTER JOIN `ps_mXX_manufacturer_discount` md ON md.`id_manufacturer` = p.`id_manufacturer`
                WHERE p.`id_product` = XX
                AND md.`id_group` = XX AND md.`id_shop` IS NULL AND md.`id_shop_group` IS NULL LIMIT XX
48
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))
27
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
25
SELECT *
FROM `ps_category` c
LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = XX AND cl.id_shop = XX 
WHERE (c.nleft <= XX AND c.nright >= XX)
ORDER BY c.nleft
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 `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 *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `ps_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
24
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
24
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = 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 `id_tax_rules_group`
							FROM `ps_product_shop`
							WHERE `id_product` = XX AND id_shop=XX LIMIT XX
23
			SELECT nleft, nright, level_depth
			FROM ps_category
			WHERE id_category = XX LIMIT XX
22
			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
11
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
3
			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
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 id_lang FROM `ps_lang` WHERE is_rtl=XX AND active=XX LIMIT XX
2
				SELECT m.`id_module`, m.`name`, (
					SELECT id_module
					FROM `ps_module_shop` ms
					WHERE m.`id_module` = ms.`id_module`
					AND ms.`id_shop` = XX
					LIMIT XX
				) as mshop
				FROM `ps_module` m
2
SELECT domain,physical_uri FROM ps_shop_url WHERE id_shop='XX'

Tables stress

146 product
96 m4_manufacturer_discount
74 product_shop
50 category
47 category_lang
30 specific_price
29 product_attribute_shop
28 stock_available
28 smarty_lazy_cache
25 product_lang
24 specific_price_priority
24 product_group_reduction_cache
18 module
15 module_shop
10 whatsappchatblock
10 whatsappchatblock_lang
6 shop_url
5 lang
4 hook
4 lang_shop
4 currency_shop
4 product_attribute
4 shop
3 country
3 currency
3 theme
3 manufacturer
2 category_product
2 tax_rule
2 tax_rules_group
2 image_shop
2 category_group
2 image_type
2 whatsappchatblock_agent_lang
2 whatsappchatblock_agent
2 shop_group
2 configuration
2 country_lang
2 country_shop
2 hook_module
2 hook_alias
2 meta
2 group
2 group_shop
2 manufacturer_shop
2 smarty_last_flush
2 manufacturer_lang
1 product_attribute_combination
1 attribute
1 tax_lang
1 attribute_lang
1 tax
1 memcached_servers
1 image_lang
1 sfkcustomhead
1 sfkhreflang
1 hook_module_exceptions
1 group_lang
1 theme_meta
1 meta_lang
1 module_group
1 configuration_lang
1 attribute_group

ObjectModel instances

NameInstancesSource
Product 25 /modules/sfkseoschema/sfkseoschema.php [1748]
/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]
Address 12 /modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/classes/Product.php [2937]
/classes/Product.php [4403]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
/modules/whatsappchat/classes/WhatsappChatBlock.php [150]
Country 12 /config/config.inc.php [142]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/sfkseoschema/sfkseoschema.php [2071]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
/modules/whatsappchat/classes/WhatsappChatBlock.php [162]
Customer 11 /config/config.inc.php [221]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
/modules/whatsappchat/classes/WhatsappChatBlock.php [160]
WhatsappChatBlockAgent 11 /modules/whatsappchat/whatsappchat.php [305]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
/modules/whatsappchat/whatsappchat.php [592]
WhatsappChatBlock 10 /modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
/modules/whatsappchat/whatsappchat.php [591]
Language 2 /config/config.inc.php [195]
/classes/Tools.php [498]
Currency 2 /classes/Tools.php [610]
/modules/sfkseoschema/sfkseoschema.php [2080]
Manufacturer 2 /classes/Link.php [341]
/controllers/front/ManufacturerController.php [59]
Shop 1 /config/config.inc.php [114]
Theme 1 /config/config.inc.php [115]
ShopGroup 1 /classes/shop/Shop.php [518]
Cart 1 /classes/controller/FrontController.php [348]
Group 1 /classes/Cart.php [184]
Tax 1 /classes/tax/TaxRulesTaxManager.php [115]

Included Files

#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/cache/Cache.php
22/classes/cache/CacheMemcached.php
23/config/db_slave_server.inc.php
24/classes/Configuration.php
25/override/classes/Configuration.php
26/classes/Validate.php
27/Adapter/Adapter_EntityMapper.php
28/classes/db/DbQuery.php
29/classes/Theme.php
30/config/defines_uri.inc.php
31/tools/htmlpurifier/HTMLPurifier.standalone.php
32/classes/Language.php
33/classes/Country.php
34/classes/PrestaShopCollection.php
35/classes/shop/ShopGroup.php
36/classes/Cookie.php
37/override/classes/Cookie.php
38/classes/Rijndael.php
39/config/smarty.config.inc.php
40/tools/smarty/Smarty.class.php
41/tools/smarty/sysplugins/smarty_internal_data.php
42/tools/smarty/sysplugins/smarty_internal_templatebase.php
43/tools/smarty/sysplugins/smarty_internal_template.php
44/tools/smarty/sysplugins/smarty_resource.php
45/tools/smarty/sysplugins/smarty_internal_resource_file.php
46/tools/smarty/sysplugins/smarty_cacheresource.php
47/tools/smarty/sysplugins/smarty_internal_cacheresource_file.php
48/classes/SmartyCustom.php
49/config/smartyfront.config.inc.php
50/classes/Customer.php
51/override/classes/Customer.php
52/classes/Group.php
53/override/classes/Group.php
54/classes/Link.php
55/override/classes/Link.php
56/classes/shop/ShopUrl.php
57/classes/module/Module.php
58/classes/Dispatcher.php
59/override/classes/Dispatcher.php
60/classes/Hook.php
61/override/classes/Hook.php
62/tools/mobile_Detect/Mobile_Detect.php
63/modules/simpleimportproduct/simpleimportproduct.php
64/modules/simpleimportproduct/classes/mpmImportTools.php
65/classes/Translate.php
66/modules/pagecache/pagecache.php
67/modules/pagecache/PageCacheURLNormalizer.php
68/modules/pagecache/PageCacheUtils.php
69/modules/pagecache/PageCacheCache.php
70/modules/pagecache/PageCacheCacheSimpleFS.php
71/modules/pagecache/PageCacheCacheMultiStore.php
72/modules/pagecache/PageCacheCacheZipArchive.php
73/modules/pagecache/PageCacheDAO.php
74/modules/pagecache/http_build_url.php
75/controllers/front/ManufacturerController.php
76/classes/controller/FrontController.php
77/override/classes/controller/FrontController.php
78/override/controllers/front/ManufacturerController.php
79/themes/gadgets/lang/en.php
80/classes/Currency.php
81/classes/Cart.php
82/override/classes/Cart.php
83/classes/CartRule.php
84/override/classes/CartRule.php
85/classes/Meta.php
86/classes/Product.php
87/override/classes/Product.php
88/classes/webservice/WebserviceRequest.php
89/classes/Manufacturer.php
90/classes/Media.php
91/override/classes/Media.php
92/modules/ets_superspeed/ets_superspeed.php
93/modules/ets_superspeed/classes/cache.php
94/modules/ets_superspeed/classes/http_build_url.php
95/modules/ets_superspeed/ets_superspeed_defines.php
96/modules/ets_superspeed/classes/ets_superspeed_cache_page.php
97/modules/ets_superspeed/classes/ets_superspeed_paggination_class.php
98/modules/ets_superspeed/ets_superspeed_compressor_image.php
99/modules/ets_superspeed/classes/ets_superspeed_upload_image.php
100/modules/ets_superspeed/classes/ets_superspeed_browse_image.php
101/modules/ets_superspeed/classes/ext/temp
102/cache/smarty/compile/a3/25/5d/a3255d985eb68599ca79959b75ae7d64f9f0313f.file.javascript.tpl.php
103/tools/smarty/sysplugins/smarty_internal_filter_handler.php
104/tools/minify_html/minify_html.class.php
105/tools/js_minify/jsmin.php
106/modules/blocklayered/blocklayered.php
107/modules/blocklayered/translations/en.php
108/modules/blockcms/blockcms.php
109/modules/blockcms/BlockCMSModel.php
110/themes/gadgets/modules/blockcms/translations/en.php
111/modules/blockcms/translations/en.php
112/modules/blockcontact/blockcontact.php
113/modules/blockcontact/translations/en.php
114/modules/blockmyaccount/blockmyaccount.php
115/modules/blockmyaccount/translations/en.php
116/modules/blockpaymentlogo/blockpaymentlogo.php
117/modules/blockpaymentlogo/translations/en.php
118/modules/blockuserinfo/blockuserinfo.php
119/modules/blockuserinfo/translations/en.php
120/modules/blockviewed/blockviewed.php
121/modules/blockviewed/translations/en.php
122/modules/blockwishlist/blockwishlist.php
123/modules/blockwishlist/WishList.php
124/modules/blockwishlist/translations/en.php
125/modules/blockfeaturedfooter/blockfeaturedfooter.php
126/modules/blockfeaturedfooter/en.php
127/modules/omicron_themecontroller/omicron_themecontroller.php
128/cache/smarty/compile/8a/03/b2/8a03b296a7774c44fe306cfed40775b94c7b76b8.file.omicron_themecontroller.tpl.php
129/modules/blockomicronnewsletter/blockomicronnewsletter.php
130/modules/blockomicronnewsletter/translations/en.php
131/modules/blocksearch/blocksearch.php
132/modules/blocksearch/translations/en.php
133/modules/blockcart/blockcart.php
134/modules/blockcart/translations/en.php
135/modules/homeslider/homeslider.php
136/modules/homeslider/HomeSlide.php
137/modules/homeslider/translations/en.php
138/modules/paypalwithfee/paypalwithfee.php
139/classes/PaymentModule.php
140/override/classes/PaymentModule.php
141/modules/paypalwithfee/en.php
142/modules/reviewsadv/reviewsadv.php
143/cache/smarty/compile/6a/b0/ba/6ab0ba4c6dda80adfd440296d6de5a4b1ad51676.file.head.tpl.php
144/modules/guestbook/guestbook.php
145/modules/guestbook/models/GuestBookComment.php
146/modules/guestbook/models/GuestBookCommentCriterion.php
147/modules/guestbook/models/GuestBookOrder.php
148/modules/uecookie/uecookie.php
149/modules/uecookie/key.php
150/modules/oversizeproducts/oversizeproducts.php
151/modules/blockcontactinfos/blockcontactinfos.php
152/modules/blockcontactinfos/translations/en.php
153/modules/trustpilot/trustpilot.php
154/modules/trustpilot/orders.php
155/modules/trustpilot/config.php
156/modules/trustpilot/globals.php
157/modules/trustpilot/pastOrders.php
158/modules/trustpilot/apiClients/TrustpilotHttpClient.php
159/modules/trustpilot/products.php
160/modules/trustpilot/trustbox.php
161/modules/trustpilot/viewLoader.php
162/modules/trustpilot/updater.php
163/modules/trustpilot/pluginStatus.php
164/modules/trustpilot/translations/en.php
165/cache/smarty/compile/d5/dd/10/d5dd100255d6636f9d5a3b396ac78d69e3d8a39e.file.head.tpl.php
166/modules/a4ppaypalpro/a4ppaypalpro.php
167/modules/ets_megamenu/ets_megamenu.php
168/modules/ets_megamenu/classes/MM_Obj.php
169/modules/ets_megamenu/classes/MM_Menu.php
170/modules/ets_megamenu/classes/MM_Column.php
171/modules/ets_megamenu/classes/MM_Block.php
172/modules/ets_megamenu/classes/MM_Config.php
173/modules/ets_megamenu/classes/MM_Cache.php
174/modules/ets_megamenu/classes/MM_Tab.php
175/modules/ets_megamenu/classes/MM_Products.php
176/modules/ets_megamenu/classes/Ets_megamenu_defines.php
177/modules/ets_megamenu/classes/MM_ImportExport.php
178/classes/ImageType.php
179/modules/clearpay/clearpay.php
180/modules/clearpay/vendor/autoload.php
181/modules/clearpay/vendor/composer/autoload_real.php
182/modules/clearpay/vendor/composer/ClassLoader.php
183/modules/clearpay/vendor/composer/autoload_static.php
184/modules/clearpay/src/UAHeader.php
185/modules/clearpay/vendor/afterpay-global/afterpay-sdk-php/src/HTTP.php
186/modules/spreset/spreset.php
187/cache/smarty/compile/df/97/14/df97146470ef64e6494e543c237d771ffea14803.file.spreset.tpl.php
188/modules/whatsappchat/whatsappchat.php
189/modules/whatsappchat/classes/WhatsappChatBlock.php
190/modules/whatsappchat/classes/WhatsappChatBlockAgent.php
191/modules/whatsappchat/translations/en.php
192/classes/Address.php
193/modules/sfkseoschema/sfkseoschema.php
194/classes/Image.php
195/classes/Category.php
196/override/classes/Category.php
197/cache/smarty/compile/24/a4/96/24a496fd1a4e85d7b917fe41678ab6110b6bdaad.file.sfkmerge16.tpl.php
198/cache/smarty/compile/e6/b0/85/e6b085ffa6e4bbe0e44b0898ea6b0acb136a853d.file.blockuserinfo.tpl.php
199/cache/smarty/compile/18/47/ed/1847ed009dfeca545e0be0d80532e7f48c721ed1.file.blockwishlist_top.tpl.php
200/cache/smarty/cache/blocksearch_top/1/1/1/17/4c/f2/75/4cf275abf6f89a85ff399826a5a10bcb17bd1739.blocksearch-top.tpl.php
201/Adapter/Adapter_AddressFactory.php
202/Adapter/Adapter_ProductPriceCalculator.php
203/Adapter/Adapter_Configuration.php
204/Core/Business/Core_Business_ConfigurationInterface.php
205/classes/Customization.php
206/cache/smarty/compile/22/72/a4/2272a42dc144c48e971ab79794e512c684ddbde7.file.blockcart.tpl.php
207/tools/smarty/plugins/modifier.replace.php
208/tools/smarty/plugins/function.counter.php
209/classes/Combination.php
210/override/classes/Combination.php
211/classes/stock/StockAvailable.php
212/override/classes/stock/StockAvailable.php
213/classes/tax/Tax.php
214/classes/SpecificPrice.php
215/override/classes/SpecificPrice.php
216/modules/m4manufacturerdiscount/m4manufacturerdiscount.php
217/modules/m4manufacturerdiscount/translations/en.php
218/classes/tax/TaxManagerFactory.php
219/modules/vatnumber/vatnumber.php
220/classes/tax/TaxManagerModule.php
221/modules/vatnumber/translations/en.php
222/modules/vatnumber/VATNumberTaxManager.php
223/classes/tax/TaxManagerInterface.php
224/classes/tax/TaxRulesTaxManager.php
225/classes/tax/TaxCalculator.php
226/classes/GroupReduction.php
227/classes/Feature.php
228/cache/smarty/cache/blockcontactinfos/1/1/1/17/9f/d0/60/9fd060d1ffd26c55e5f36da796f8f3847fc39929.blockcontactinfos.tpl.php
229/cache/smarty/cache/blockcms/2/1/1/1/17/18/f5/93/18f5935903ceaa03c8b19af7ac1b3760007148a3.blockcms.tpl.php
230/cache/smarty/compile/d2/be/1d/d2be1d1ede35d2114021ca843bad90fa31875685.file.blockomicronnewsletter.tpl.php
231/cache/smarty/compile/f7/0d/ed/f70ded06e81b6fcde75beafd5a9b6741e37e283f.file.top.tpl.php
232/cache/smarty/compile/88/ad/54/88ad54a85fe6066b5b3bdb22bc144952ac416c23.file.bottom.tpl.php
233/cache/smarty/compile/a6/50/5d/a6505d2f82b8e43897f554c9d2bb6bff23ac3219.file.template.tpl.php
234/cache/smarty/compile/6e/cb/02/6ecb0253f05e7a9d29109f63435ce312c843937e.file.manufacturer.tpl.php
235/cache/smarty/compile/b5/67/20/b567200fd3eef4815b7865f4a461cc6c4511615a.file.errors.tpl.php
236/cache/smarty/compile/ff/20/d1/ff20d192a46b2e2dcfad5ecc8968958d5405287b.file.product-sort.tpl.php
237/cache/smarty/compile/08/80/d5/0880d59f670d71764524df3a8a903077adb9d841.file.nbr-product-page.tpl.php
238/cache/smarty/compile/94/0e/49/940e49fc5518e3ffc6346a1960c6e63e858b863c.file.product-list.tpl.php
239/tools/smarty/plugins/function.math.php
240/cache/smarty/compile/21/c9/f2/21c9f277da455d6836ac0292aac85657428dc2f9.file.product-compare.tpl.php
241/cache/smarty/compile/43/1a/03/431a03f580d0c4d136bb4c0ad3e0f4a7dcd1c169.file.pagination.tpl.php
242/cache/smarty/compile/44/cc/8a/44cc8adfa3270bdeabcd4add60f5f00e533a0e1c.file.layout.tpl.php
243/cache/smarty/compile/18/55/69/185569c7891c817fa9e3a05bb2e14199ac3ff672.file.header.tpl.php
244/tools/smarty/plugins/function.implode.php
245/cache/smarty/compile/dc/df/c1/dcdfc11261fb22299786eb2bb2fa5e16bb32186a.file.nav.tpl.php
246/cache/smarty/cache/blockcontact/1/1/1/17/14/fe/00/14fe00f77f4dc993c4c42a9235c7d596570a346c.nav.tpl.php
247/cache/smarty/compile/ce/59/19/ce5919749124141c8b353ba755b1f4cac9e676d9.file.megamenu.tpl.php
248/cache/smarty/compile/c0/8c/e2/c08ce213a401d8de6614bac8769cbe0b1a5ce33b.file.breadcrumb.tpl.php
249/modules/omicronCategories/omicronCategories.php
250/modules/omicronCategories/en.php
251/cache/smarty/compile/ac/45/b3/ac45b3a25b512037aa6ff96f75be099167139016.file.omicronCategories.tpl.php
252/cache/smarty/compile/98/15/64/981564caf01b6eef35ccc5dc7d05cb0cc922d518.file.footer.tpl.php
253/cache/smarty/compile/bf/30/2c/bf302c5f81240f19d08ca8601a204c5423495ed7.file.global.tpl.php
254/cache/smarty/compile/62/6f/91/626f91c2f1b4b17c6e9f2489d58051dd6a2acfae.file.javascript.tpl.php