Solana

Solana: Eine französische Qualitätsmarke

Solana, eine mutige französische Marke, bietet mehrere Produktlinien an, von E-Liquids über Shake'N'Vape mit intensiven Aromen bis hin zu konzentrierten Aromen für DIY.

Zwei Arten von PG/VG-Verhältnissen: 50/50 für ein ausgewogenes Dampferlebnis oder 20/80 für dichte Wolken aus Dampf.

Alle Produkte der Marke Solana

Solana: 100% französische e-Liquids

Eine große französische Marke im Bereich des Dampfen

Solana ist eine ikonische Marke in der Dampferindustrie, die vor vielen Jahren in Frankreich gegründet wurde. Ihre E-Liquids werden mit Leidenschaft und unter Einhaltung der höchsten Standards entwickelt und hergestellt und garantieren so eine einwandfreie Qualität.

Solana, hohe Ansprüche

Solana ist ein Hersteller von E-Liquids für elektronische Zigaretten und Konzentraten für Diy-Präparate. Die Produkte von Solana werden vollständig in Frankreich hergestellt, abgefüllt und kontrolliert. Analysiert und kontrolliert von der Ecole Nationale Supérieure de Chimie de Lille.

In den Warenkorb gelegt!
Anzahl
Weiter einkaufen
Load Time2248 ms - You'd better run your shop on a toaster
Querying Time1032 ms
Queries1059
Memory Peak Usage25.7 Mb
Included Files593 files - 9.47 Mb
PrestaShop Cache- Mb
Global vars1.90 Mb
PrestaShop Version1.6.1.24
PHP Version7.4.33 (OK)
MySQL Version10.5.26-MariaDB-0+deb11u2 (OK)
Memory Limit128M
Max Execution Time30s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 145 ms 145 ms 5.60 Mb 5.60 Mb
__construct 0 ms 145 ms - Mb 5.60 Mb
init 31 ms 176 ms 0.76 Mb 6.37 Mb
checkAccess 0 ms 176 ms - Mb 6.37 Mb
setMedia 12 ms 188 ms 0.03 Mb 6.55 Mb
postProcess 0 ms 188 ms - Mb 6.55 Mb
initHeader 0 ms 188 ms - Mb 6.55 Mb
initContent 1110 ms 1298 ms 9.33 Mb 15.74 Mb
initFooter 41 ms 1339 ms 0.24 Mb 16.53 Mb
display 908 ms 2248 ms 9.34 Mb 25.73 Mb
Hook Time Memory Usage
hookdisplayFooter1 213 ms 6.00 Mb
__construct 89 ms 6.00 Mb
hookmoduleRoutes 27 ms - Mb
hookfooter 22 ms - Mb
hookdisplayHeaderInfo 19 ms - Mb
hookdisplayHeader 18 ms - Mb
hookdisplayRightTop 15 ms 2.00 Mb
hookdisplayTop 14 ms - Mb
hookdisplayGDPRConsent 11 ms - Mb
hookdisplayNav 11 ms - Mb
hookdisplayModal 10 ms - Mb
hookdisplayFooter 10 ms - Mb
hookHeader 9 ms - Mb
hookdisplayLeftTop 6 ms - Mb
hookactionDispatcher 5 ms - Mb
hookdisplayLeftColumn 4 ms - Mb
hookdisplayProductListReviews 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayProductListFunctionalButtons 2 ms - Mb
hookdisplayReassurance 1 ms - Mb
hookdisplayFooterLeft 1 ms - Mb
hookdisplayProductPriceBlock 1 ms - Mb
hookdisplayFooterRight 1 ms - Mb
hookactionFrontControllerSetMedia 1 ms - Mb
hookdisplayHeaderMobile 0 ms - Mb
hooktop 0 ms - Mb
hookDisplayOverrideTemplate - ms - Mb
27 hooks 495 ms 14.00 Mb
Module Time Memory Usage
fsmenus 247 ms 8.00 Mb
fscontentmanagement 48 ms 2.00 Mb
g_megamenu 27 ms - Mb
blocknewsletter 27 ms - Mb
psgdpr 11 ms - Mb
trustedshopsintegration 10 ms - Mb
pm_advancedcookiebanner 10 ms - Mb
psproductcountdownpro 10 ms - Mb
fslogin 8 ms - Mb
pagecache 7 ms - Mb
favoriteproductsNova 7 ms - Mb
fsblockcms 5 ms 2.00 Mb
doofinder 5 ms 2.00 Mb
netreviews 5 ms - Mb
pm_advancedpack 4 ms - Mb
blockcart 4 ms - Mb
tradedoubler_affiliate_tracker 4 ms - Mb
colissimo 3 ms - Mb
blocklanguages 3 ms - Mb
fscities 3 ms - Mb
ukoobillboard 3 ms - Mb
ganalytics 3 ms - Mb
faqs 3 ms - Mb
blockcartNova 2 ms - Mb
dhldp 2 ms - Mb
opartlimitquantity 2 ms - Mb
blocksearch 2 ms - Mb
jprestawebp 2 ms - Mb
systempay 2 ms - Mb
fsjsonld 2 ms - Mb
blocksocial 2 ms - Mb
fsreinsurance 2 ms - Mb
favoriteproducts 2 ms - Mb
fsorderedproducts 2 ms - Mb
psgdprNova 1 ms - Mb
blocklayeredNova 1 ms - Mb
fsfeaturesextend 1 ms - Mb
mailalertsNova 1 ms - Mb
fsmodals 1 ms - Mb
sekeywordsNova 1 ms - Mb
pagesnotfound 1 ms - Mb
blocksearchNova 1 ms - Mb
ukooresponslide 1 ms - Mb
qcdshippingperproduct 1 ms 2.00 Mb
blocksocialNova 1 ms - Mb
fsadvancedsearch 1 ms - Mb
fsblockproducts 1 ms - Mb
editorial 0 ms - Mb
tradedoubler 0 ms - Mb
blocklayered 0 ms - Mb
sekeywords - ms - Mb
mailalerts - ms - Mb
52 modules 495 ms 14.00 Mb

Stopwatch SQL - 1059 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(
"2024-12-04 00:00:00",
INTERVAL 30 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` = 2 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` = 2)
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` = 165
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY p.`date_add` desc
LIMIT 0,80
53.7 32136 Yes Yes sses/Manufacturer.php:386
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 = 165 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)
)
36.3 819468 sses/Manufacturer.php:322
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5566|1|2%"
22.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4198|1|2%"
22.6 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4210|1|2%"
22.1 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5567|1|2%"
22 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4173|1|2%"
21.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5569|1|2%"
21.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4188|1|2%"
20.8 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5568|1|2%"
20.7 1 sses/SmartyCustom.php:295
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
19.8 6793 sses/SpecificPrice.php:230
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|5572|1|2%"
19.7 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4206|1|2%"
19.7 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4199|1|2%"
19.2 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4208|1|2%"
18.5 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4197|1|2%"
18.1 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4184|1|2%"
17.8 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4187|1|2%"
17.7 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4178|1|2%"
17.7 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4172|1|2%"
17.6 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4174|1|2%"
17.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4177|1|2%"
17.1 1 sses/SmartyCustom.php:295
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4195 AND id_shop=1 LIMIT 1
14.6 1 sses/Product.php:5037
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4204|1|2%"
14.6 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|4203|1|2%"
13.8 1 sses/SmartyCustom.php:295
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4208|1|2" AND compile_id="" LIMIT 1
12.6 0 sses/SmartyCustom.php:215
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`)
7 1551 sses/Configuration.php:148
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
5.4 0 sses/Hook.php:131
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, hm.id_hook_behavior, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
5.4 532 a/classes/Hook.php:410
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, hm.`id_hook_behavior`, 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`
4.8 182 Yes Yes a/classes/Hook.php:109
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.3 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
3.2 647 sses/SpecificPrice.php:230
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
3 647 sses/SpecificPrice.php:238
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` = 2)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6991,5571,5572,5573,5564,5565,5566,5567,5568,5569,4210,4208,4207,4206,4205,4204,4203,4202,4201,4200,4199,4198,4197,4196,4195,4194,4193,4192,4191,4190,4189,4188,4187,4186,4184,4183,4182,4180,4179,4178,4177,4176,4174,4173,4172,4171) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.5 61 Yes Yes a/classes/Product.php:98
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 66) AND (b.`id_shop` = 1) LIMIT 1
2.4 1 a/Adapter/Adapter_EntityMapper.php:61
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
2.3 108 Yes sses/Dispatcher.php:452
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1 AND c.active = 1
ORDER BY cl.name ASC
1.8 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.5 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 11) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 1) AND (b.`id_shop` = 1) LIMIT 1
1.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=2
1.4 1241 a/classes/Product.php:216
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|5573|1|2","", FROM_UNIXTIME(1733345625))
1.4 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4200) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10086) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.4 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.4 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4207) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10093) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4208) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10094) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4203) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10089) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4206) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10092) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4205) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10091) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4199) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10085) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10042) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4201) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10087) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4202) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10088) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4196) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10082) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10040) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10041) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1969
1.2 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1968
1.2 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10037) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=9
1.2 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4198) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10084) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4204) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10090) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5571 AND id_shop=1 LIMIT 1
1.2 1 sses/Product.php:5037
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|5564|1|2","", FROM_UNIXTIME(1733345625))
1.2 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10036) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10076) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 40689) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.2 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10077) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10063) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4194|1|2","", FROM_UNIXTIME(1733345625))
1.1 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10035) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.1 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10075) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10061) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10079) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10043) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 2) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
1.1 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 8) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 424) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10038) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 137) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10080) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10100) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE b.`id_ukoobillboard`, bl.`message`, b.`display_mod`, b.`message_position`, b.`bg_color`, b.`txt_color`,
b.`btn_color`, b.`btn_txt_color`, b.`use_cookie`, b.`position`, b.`display_page`, b.`display_product`,
b.`display_close_btn`
FROM `ps_ukoobillboard` b
LEFT JOIN `ps_ukoobillboard_lang` bl
ON (b.`id_ukoobillboard` = bl.`id_ukoobillboard`
AND bl.`id_lang` = 2)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 21:53:46"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 21:53:46")
OR (b.`date_start` = "0000-00-00 00:00:00"
AND b.`date_end` = "0000-00-00 00:00:00"))
AND b.`display_page` = "all" OR b.`display_page` = "manufacturer"
AND b.`display_mod` = "display_popup" ORDER BY b.`position` ASC
1 1 Yes /modules/ukoobillboard/classes/UkooBillboardBillboard.php:188
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10078) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
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` = 5571)
1 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10069) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10046) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayHeaderInfo/1/1/1/2/1/8/1/manufacturer/165/e7/13/6b/e7136b37ec3d626cb3911235c0b213e7624eac24.menublock-displayheaderinfo.tpl.php'
WHERE `template_hash`='b8c5bef7265340ce2f6e5204863da515' AND cache_id="fsmenus|displayHeaderInfo|1|1|1|2|1|8|1|manufacturer|165" AND compile_id=""
1 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10050) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10052) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4207) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
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.9 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4172
ORDER BY f.position ASC
0.9 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4207|1|2","", FROM_UNIXTIME(1733345625))
0.9 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4179
ORDER BY f.position ASC
0.9 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4206) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4172) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10044) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 6991
ORDER BY f.position ASC
0.9 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` IN (0, 4197) AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10083) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.9 4 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|5565|1|2","", FROM_UNIXTIME(1733345625))
0.9 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4204
ORDER BY f.position ASC
0.9 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4173) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 135) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4200) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4186) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4176) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4177) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5571
ORDER BY f.position ASC
0.9 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4184) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4189|1|2","", FROM_UNIXTIME(1733345625))
0.9 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4178
ORDER BY f.position ASC
0.9 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4205) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4201) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4188
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6991|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.8 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5567
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4184
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4207
ORDER BY f.position ASC
0.8 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4194) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4197
ORDER BY f.position ASC
0.8 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4196) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4191
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4197) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 165) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4182) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5566
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4188) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5564
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4174) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4171) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4187) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4190) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4195|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4193|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4208) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4191) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5571) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4183) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4196|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4204) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4198) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 5564)
0.8 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 9) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4192|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5565
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4203) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4173
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5572
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 329) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4190
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4176
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4180
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 249) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5573) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4178) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4195
ORDER BY f.position ASC
0.8 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5573
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4182|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4193) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4183
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5567) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4174
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4189) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4199) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5572) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 300) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4186
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4177
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5568
ORDER BY f.position ASC
0.8 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10081) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes sses/SpecificPrice.php:362
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4192) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4176|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5568) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4183|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4190|1|2","", FROM_UNIXTIME(1733345625))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4200
ORDER BY f.position ASC
0.8 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5569) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5565) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4195) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4210) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5566) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4194
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 134) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4171
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 138) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4187
ORDER BY f.position ASC
0.7 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4210
ORDER BY f.position ASC
0.7 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4180) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4201
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4193
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4208
ORDER BY f.position ASC
0.7 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4196
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5564) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4189
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4199
ORDER BY f.position ASC
0.7 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 11) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayRightTop/1/1/1/2/1/8/1/manufacturer/165/62/3d/11/623d119985e9a1c710dee232646e46b2bc295f35.menublock-displayrighttop.tpl.php'
WHERE `template_hash`='64057145ca61a41f3fcc884f4f62c395' AND cache_id="fsmenus|displayRightTop|1|1|1|2|1|8|1|manufacturer|165" AND compile_id=""
0.7 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('64057145ca61a41f3fcc884f4f62c395',"fsmenus|displayRightTop|1|1|1|2|1|8|1|manufacturer|165","", FROM_UNIXTIME(1733345626))
0.7 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5569
ORDER BY f.position ASC
0.7 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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.7 1 Yes sses/shop/Shop.php:663
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4192
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE b.`id_ukoobillboard`, bl.`message`, b.`display_mod`, b.`message_position`, b.`bg_color`, b.`txt_color`,
b.`btn_color`, b.`btn_txt_color`, b.`use_cookie`, b.`position`, b.`display_page`, b.`display_product`,
b.`display_close_btn`
FROM `ps_ukoobillboard` b
LEFT JOIN `ps_ukoobillboard_lang` bl
ON (b.`id_ukoobillboard` = bl.`id_ukoobillboard`
AND bl.`id_lang` = 2)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 21:53:46"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 21:53:46")
OR (b.`date_start` = "0000-00-00 00:00:00"
AND b.`date_end` = "0000-00-00 00:00:00"))
AND b.`display_page` = "all" OR b.`display_page` = "manufacturer"
AND b.`display_mod` = "display_header" ORDER BY b.`position` ASC
0.7 1 Yes /modules/ukoobillboard/classes/UkooBillboardBillboard.php:188
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 95 a/classes/module/Module.php:82
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4179) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4182
ORDER BY f.position ASC
0.7 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 6991) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|5571|1|2","", FROM_UNIXTIME(1733345625))
0.7 1 sses/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayFooter1/1/1/1/2/1/8/1/manufacturer/165/e5/bd/20/e5bd20563a338e14b34e5100aa7918fc88c39559.menublock-displayfooter1.tpl.php'
WHERE `template_hash`='29229ea482358ac182b62d6e88b341e7' AND cache_id="fsmenus|displayFooter1|1|1|1|2|1|8|1|manufacturer|165" AND compile_id=""
0.7 1 sses/SmartyCustom.php:183
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` = 8
AND tr.`id_tax_rules_group` = 23
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.7 1 sses/tax/TaxRulesTaxManager.php:108
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` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4202) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=10
0.7 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4186|1|2","", FROM_UNIXTIME(1733345625))
0.7 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4205
ORDER BY f.position ASC
0.7 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4206
ORDER BY f.position ASC
0.7 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('29229ea482358ac182b62d6e88b341e7',"fsmenus|displayFooter1|1|1|1|2|1|8|1|manufacturer|165","", FROM_UNIXTIME(1733345626))
0.7 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4207)
0.6 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/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`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4193|1|2" AND compile_id="" LIMIT 1
0.6 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1452
0.6 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=78
0.6 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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` = 4179)
0.6 1 sses/Product.php:3002
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4198
ORDER BY f.position ASC
0.6 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayLeftTop/1/1/1/2/1/8/1/manufacturer/165/06/0b/ac/060bac65e4bad467f3a4ec595f7ac9a32893a8c7.menublock-displaylefttop.tpl.php'
WHERE `template_hash`='5a8b33fb9c66397d445d151eee7305f9' AND cache_id="fsmenus|displayLeftTop|1|1|1|2|1|8|1|manufacturer|165" AND compile_id=""
0.6 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.e-garette.fr' OR su.domain_ssl = 'www.e-garette.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 1 Yes sses/shop/Shop.php:334
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4179|1|2","", FROM_UNIXTIME(1733345625))
0.6 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 63) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('b8c5bef7265340ce2f6e5204863da515',"fsmenus|displayHeaderInfo|1|1|1|2|1|8|1|manufacturer|165","", FROM_UNIXTIME(1733345626))
0.6 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5572 AND `id_group` = 1 LIMIT 1
0.6 0 sses/GroupReduction.php:149
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.6 1 sses/ObjectModel.php:1458
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4171|1|2","", FROM_UNIXTIME(1733345625))
0.6 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4201|1|2","", FROM_UNIXTIME(1733345625))
0.6 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5568)
0.6 1 sses/Product.php:3002
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` = 4187)
0.6 4 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 292) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/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` = 4178)
0.6 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 331) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4179) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5572)
0.6 1 sses/Product.php:3002
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4180|1|2","", FROM_UNIXTIME(1733345625))
0.6 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4202|1|2","", FROM_UNIXTIME(1733345625))
0.5 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4200|1|2","", FROM_UNIXTIME(1733345625))
0.5 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 4195)
0.5 1 sses/Product.php:3002
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` = 4183)
0.5 4 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4203
ORDER BY f.position ASC
0.5 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 231) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=7 ORDER BY mi.id_parent,mi.position
0.5 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4205|1|2","", FROM_UNIXTIME(1733345625))
0.5 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "guides" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 257) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "guides" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE pspc.`id_pspc`
FROM `ps_pspc` pspc
LEFT JOIN `ps_pspc_shop` pspcs
ON pspc.`id_pspc` = pspcs.`id_pspc`
WHERE pspcs.`active` = 1 AND `personal` = 0
AND pspcs.`id_shop` = 1
AND (
(`action_start` != "" AND `action_start` IS NOT NULL
AND `action_start_done` = 0 AND `from` <= UTC_TIMESTAMP())
OR
(`action_end` != "" AND `action_end` IS NOT NULL
AND `action_end_done` = 0 AND `to` <= UTC_TIMESTAMP())
)
0.5 9 /modules/psproductcountdownpro/psproductcountdownpro.php:2947
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` = 4206)
0.5 1 sses/Product.php:3002
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.5 2 Yes sses/Currency.php:231
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 165) LIMIT 1
0.5 1 a/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` = 4172)
0.5 1 sses/Product.php:3002
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|4191|1|2","", FROM_UNIXTIME(1733345625))
0.5 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4208)
0.5 1 sses/Product.php:3002
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` = 4176)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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`='5b7647a7825aa7a887b4ec8e6e551294' AND cache_id="fsblockcms|displayBanner|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.5 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4177)
0.5 1 sses/Product.php:3002
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` = 4173)
0.5 1 sses/Product.php:3002
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` = 6991)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 281) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 4197)
0.5 1 sses/Product.php:3002
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` = 4203)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.5 1 sses/Country.php:173
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4210|1|2" AND compile_id="" LIMIT 1
0.5 0 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "manufacturer" LIMIT 1
0.5 1 sses/Theme.php:275
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 4202
ORDER BY f.position ASC
0.5 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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` = 5566)
0.5 1 sses/Product.php:3002
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` = 4201)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.5 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
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` = 4188)
0.5 4 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.5 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5a8b33fb9c66397d445d151eee7305f9',"fsmenus|displayLeftTop|1|1|1|2|1|8|1|manufacturer|165","", FROM_UNIXTIME(1733345626))
0.5 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 65) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=5 ORDER BY mi.id_parent,mi.position
0.5 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4197|1|2" AND compile_id="" LIMIT 1
0.5 0 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5573)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 5567)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 4192)
0.5 1 sses/Product.php:3002
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` = 5569)
0.5 1 sses/Product.php:3002
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` = 5565)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4176
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.5 1 sses/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=10 ORDER BY mi.id_parent,mi.position
0.5 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 227) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 4205)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.5 1 a/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` = 4189)
0.5 1 sses/Product.php:3002
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` = 4180)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE item.id_g_megamenus FROM `ps_g_megamenus` item
LEFT JOIN  `ps_g_megamenus_shop` itemshop 
ON item.id_g_megamenus = itemshop.id_g_megamenus
WHERE FIND_IN_SET("MAN165", item.pages) AND itemshop.id_shop = 1 AND item.active = 1
GROUP BY item.id_g_megamenus ASC
0.5 1 Yes /modules/g_megamenu/classes/gmegamenusModel.php:94
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` = 4171)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 167) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 289) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/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` = 4202)
0.5 1 sses/Product.php:3002
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` = 4191)
0.5 1 sses/Product.php:3002
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` = 4210)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 388) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 2
WHERE (a.`id_fs_menu_item` = 490) LIMIT 1
0.5 1 a/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`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4177|1|2" AND compile_id="" LIMIT 1
0.5 0 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 2
WHERE (a.`id_fs_menu_item` = 222) LIMIT 1
0.5 1 a/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` = 4199)
0.5 1 sses/Product.php:3002
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` = 4186)
0.5 4 sses/Product.php:3002
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` = 4198)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE COUNT(c.`id_fs_object_popup`)
FROM
`ps_fs_object_popup` AS a
INNER JOIN
`ps_fs_object_popup_lang` AS b ON ((a.`id_fs_object_popup` = b.`id_fs_object_popup`) AND (b.`id_lang` = 2) AND (b.`id_shop` = 1))
INNER JOIN
`ps_fs_object_popup_shop` AS c ON ((a.`id_fs_object_popup` = c.`id_fs_object_popup`) AND (c.`id_shop` = 1))
WHERE
1 AND
c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.5 20 /modules/fscontentmanagement/classes/FSObjectBase.php:473
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` = 4193)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 330) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.5 2 sses/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` = 4200)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.5 1 sses/shop/Shop.php:1067
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 459 LIMIT 1
0.5 1 sses/Category.php:1054
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4198|1|2" AND compile_id="" LIMIT 1
0.4 0 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=1 ORDER BY mi.id_parent,mi.position
0.4 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='e002586a29594e46f9461f0df12e4f19' AND cache_id="productlist_colors|4173|1|2" AND compile_id="" LIMIT 1
0.4 0 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 344) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 2
WHERE (a.`id_fs_menu_item` = 228) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "my-account"
OR m.page = "myaccount"
)
AND ml.id_lang = 2
AND ml.id_shop = 1 LIMIT 1
0.4 2 sses/Meta.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='091c66d6cbea4e7d8388961b0f96c072' AND cache_id="blocksocial|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 2
WHERE (a.`id_fs_menu_item` = 227) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61