Le French liquide

Le French Liquide, der umweltbewusste Hersteller von e-Liquids par excellence

Le French Liquide bietet E-Liquids mit oder ohne Nikotin und mit verschiedenen PG/VG-Werten und atemberaubenden Aromen an. Für ein schmackhaftes und gesundes Dampfen ist Le French Liquide Ihr bester Partner!

Diese E-Liquid-Marke ist vor allem für ihr ikonisches E-Liquid La Chose bekannt, das in der Welt des Dampfes einhellige Zustimmung gefunden hat. Es ist ein von Dampfern geliebtes Produkt, das wegen seiner authentischen und herzerwärmenden Gourmet-Geschmacksrichtungen immer wieder hoch geschätzt wird.

Alle Produkte der Marke Le French liquide

Le French Liquide: eine 100 % französische Marke

Die Geschichte einer französischen Marke, die im Dampfen verwurzelt ist

Die in Frankreich vom Labor Lips hergestellten E-Liquids von Le French Liquide enthalten keine Produkte, die aus der Petrochemie stammen. Le French Liquide hat sich dafür entschieden, nur pflanzliche Rohstoffe für die Herstellung seiner e-Liquids zu verwenden.

Le French Liquide begann mit einer Gruppe von passionierten Dampfern in der Region Muscadet, was sie dazu inspirierte, ihre E-Liquids wie Wein zu kreieren, mit reichen und komplexen Aromen. Dadurch konnte sich die Marke sehr schnell auf dem Markt für hochwertige e-Liquids positionieren. Dank der AFNOR-Zertifizierung "Origine France Garantie" müssen ihre E-Liquids eine klare und präzise Rückverfolgbarkeit aufweisen, die Ihnen ein E-Liquid von höchster Qualität garantiert.

Im Laufe der Jahre hat Le French Liquide seine Produktpalette erweitert, um den unterschiedlichen Bedürfnissen und Geschmäckern der Dampfer gerecht zu werden. Neben ihren klassischen E-Liquids hat die Marke auch spezielle Kollektionen, limitierte Editionen und Kooperationen mit anderen Akteuren der Dampferbranche entwickelt.

Le French Liquide: höchst köstliche Produktreihen

  • Moonshiners: Die Moonshiners-Reihe von Le French Liquide nimmt Sie mit auf eine faszinierende Reise durch die Aromen der Prohibition. Inspiriert von der Atmosphäre der illegalen Destillerien im Amerika der 20er Jahre, bietet diese Reihe kühne und intensive e-Liquids, die Sie in eine geheimnisvolle und fesselnde Welt entführen werden.
  • Wonderful Tart: Tauchen Sie ein in die köstliche und säuerliche Welt der Wonderful Tart-Reihe von Le French Liquide. Diese Kollektion bietet Ihnen eine Explosion von köstlichen und fruchtigen Aromen, die perfekt ausbalanciert sind, um Ihnen ein befriedigendes und herrlich überraschendes Dampferlebnis zu bieten.
  • Polaris: Mit der Produktreihe Polaris von Le French Liquide können Sie auf Entdeckungsreise gehen und intensive und erfrischende polare Aromen genießen. Inspiriert von den eisigen Landschaften und der Reinheit der großen Weiten, bietet diese Kollektion E-Liquids mit frischen und belebenden Aromen, die Ihnen bei jedem Zug ein intensives Gefühl der Frische verleihen.
  • Leemo: Die Produktreihe Leemo von Le French Liquide lädt Sie dazu ein, eine Welt voller exotischer und betörender Aromen zu erkunden. Inspiriert von fernen Reisen und den Kulturen der Welt, bietet diese Kollektion E-Liquids mit reichen und komplexen Aromen, die Sie in ferne, sonnige Länder entführen werden.
In den Warenkorb gelegt!
Anzahl
Weiter einkaufen
Load Time2874 ms - You'd better run your shop on a toaster
Querying Time1403 ms
Queries1533
Memory Peak Usage30.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 127 ms 127 ms 5.60 Mb 5.60 Mb
__construct 0 ms 127 ms - Mb 5.60 Mb
init 16 ms 143 ms 0.76 Mb 6.37 Mb
checkAccess 0 ms 143 ms - Mb 6.37 Mb
setMedia 4 ms 147 ms 0.03 Mb 6.55 Mb
postProcess 0 ms 147 ms - Mb 6.55 Mb
initHeader 0 ms 147 ms - Mb 6.55 Mb
initContent 1506 ms 1653 ms 13.90 Mb 20.31 Mb
initFooter 33 ms 1686 ms 0.25 Mb 21.09 Mb
display 1189 ms 2874 ms 9.44 Mb 30.72 Mb
Hook Time Memory Usage
hookdisplayFooter1 208 ms 8.00 Mb
__construct 78 ms 4.00 Mb
hookmoduleRoutes 21 ms - Mb
hookfooter 18 ms - Mb
hookdisplayHeaderInfo 17 ms 2.00 Mb
hookdisplayRightTop 14 ms - Mb
hookdisplayHeader 12 ms - Mb
hookdisplayTop 11 ms - Mb
hookdisplayNav 10 ms - Mb
hookHeader 10 ms - Mb
hookdisplayModal 10 ms - Mb
hookdisplayGDPRConsent 8 ms - Mb
hookdisplayFooter 7 ms - Mb
hookdisplayLeftTop 6 ms - Mb
hookdisplayProductListReviews 5 ms - Mb
hookdisplayProductListFunctionalButtons 5 ms - Mb
hookactionDispatcher 3 ms - Mb
hookdisplayProductPriceBlock 3 ms - Mb
hookdisplayLeftColumn 3 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayReassurance 2 ms - Mb
hookdisplayFooterLeft 1 ms - Mb
hookdisplayFooterRight 1 ms - Mb
hookdisplayHeaderMobile 0 ms - Mb
hooktop 0 ms - Mb
hookDisplayOverrideTemplate 0 ms - Mb
hookactionFrontControllerSetMedia 0 ms - Mb
27 hooks 455 ms 14.00 Mb
Module Time Memory Usage
fsmenus 240 ms 10.00 Mb
fscontentmanagement 41 ms 2.00 Mb
g_megamenu 22 ms - Mb
blocknewsletter 21 ms - Mb
favoriteproductsNova 11 ms - Mb
psproductcountdownpro 10 ms - Mb
fslogin 8 ms - Mb
psgdpr 8 ms - Mb
pm_advancedcookiebanner 8 ms - Mb
netreviews 7 ms - Mb
trustedshopsintegration 7 ms - Mb
doofinder 7 ms 2.00 Mb
fsblockcms 6 ms - Mb
fsjsonld 4 ms - Mb
pagecache 4 ms - Mb
pm_advancedpack 4 ms - Mb
blockcart 3 ms - Mb
ganalytics 3 ms - Mb
blocklanguages 3 ms - Mb
colissimo 3 ms - Mb
faqs 3 ms - Mb
blocksearch 2 ms - Mb
tradedoubler_affiliate_tracker 2 ms - Mb
fsreinsurance 2 ms - Mb
ukoobillboard 2 ms - Mb
fsfeaturesextend 2 ms - Mb
jprestawebp 2 ms - Mb
dhldp 2 ms 2.00 Mb
favoriteproducts 2 ms - Mb
blocksocial 2 ms - Mb
fsorderedproducts 2 ms - Mb
systempay 2 ms - Mb
blockcartNova 1 ms 2.00 Mb
psgdprNova 1 ms - Mb
pagesnotfound 1 ms - Mb
mailalertsNova 1 ms - Mb
blocklayeredNova 1 ms - Mb
sekeywordsNova 1 ms - Mb
ukooresponslide 1 ms - Mb
blocksearchNova 1 ms - Mb
fsmodals 1 ms - Mb
qcdshippingperproduct 0 ms - Mb
blocksocialNova 0 ms - Mb
tradedoubler 0 ms - Mb
fsblockproducts 0 ms - Mb
opartlimitquantity 0 ms - Mb
fscities 0 ms - Mb
fsadvancedsearch 0 ms - Mb
editorial 0 ms - Mb
blocklayered 0 ms - Mb
mailalerts - ms - Mb
sekeywords - ms - Mb
52 modules 455 ms 14.00 Mb

Stopwatch SQL - 1533 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` = 38
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
134.4 137814 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 = 38 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)
)
24.8 3514257 sses/Manufacturer.php:322
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7232|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|6921|1|2%"
20.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7236|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|7229|1|2%"
20.1 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6972|1|2%"
20.1 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7244|1|2%"
19 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6606|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|7226|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|7235|1|2%"
18.2 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7249|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|7250|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|7242|1|2%"
17.3 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7253|1|2%"
17.3 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7237|1|2%"
17.2 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7258|1|2%"
17.1 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7248|1|2%"
16.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7233|1|2%"
16.7 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6604|1|2%"
16.6 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7260|1|2%"
15.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6607|1|2%"
15.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7251|1|2%"
15.6 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7266|1|2%"
15.5 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7256|1|2%"
15.5 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7224|1|2%"
15.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7230|1|2%"
15.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6609|1|2%"
15.2 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7238|1|2%"
14.8 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6605|1|2%"
14.2 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7252|1|2%"
13.8 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7104|1|2%"
13.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7228|1|2%"
13.3 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7234|1|2%"
13 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7239|1|2%"
13 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7225|1|2%"
12.8 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|6603|1|2%"
12.4 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7101|1|2%"
11.5 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
11 6793 sses/SpecificPrice.php:230
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7231|1|2%"
10.9 1 sses/SmartyCustom.php:295
DELETE FROM `ps_smarty_lazy_cache`
WHERE template_hash='e002586a29594e46f9461f0df12e4f19' AND cache_id LIKE "productlist_colors|7227|1|2%"
9.7 1 sses/SmartyCustom.php:295
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
4.9 1551 sses/Configuration.php:148
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 (7274,7275,7276,7277,7278,7273,7272,7269,7270,7271,7265,7266,7267,7268,7262,7263,7264,7258,7259,7260,7261,7255,7256,7257,7251,7252,7253,7254,7248,7249,7250,7245,7246,7247,7242,7243,7244,7241,7239,7235,7236,7237,7238,7229,7230,7231,7232,7233,7234,7225,7226,7224,7227,7228,7104,7101,7102,7103,7099,7100,6971,6972,6925,6926,6927,6928,6929,6930,6924,6923,6921,6922,6918,6920,6609,6603,6604,6605,6606,6607) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.4 164 Yes Yes a/classes/Product.php:98
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
4.2 0 sses/Hook.php:131
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`
3.7 182 Yes Yes a/classes/Hook.php:109
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
2.9 532 a/classes/Hook.php:410
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
2.9 244 Yes sses/Country.php:130
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
2.1 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
1.9 647 sses/SpecificPrice.php:238
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayFooter1/1/1/1/2/1/8/1/manufacturer/38/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|38" AND compile_id=""
1.7 1 sses/SmartyCustom.php:183
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
1.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
1.6 647 sses/SpecificPrice.php:230
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` = 1) AND (b.`id_shop` = 1) LIMIT 1
1.3 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
1.3 108 Yes sses/Dispatcher.php:452
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.3 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` = 11) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.3 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.3 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, 45518) 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 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 name, id_category FROM ps_category_lang WHERE id_lang=2
1.2 1241 a/classes/Product.php:216
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, 48485) 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, 48389) 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=10
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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, 39018) 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, 48467) 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, 48395) 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 ('29229ea482358ac182b62d6e88b341e7',"fsmenus|displayFooter1|1|1|1|2|1|8|1|manufacturer|38","", FROM_UNIXTIME(1733347769))
1.1 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1968
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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, 48434) 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, 48391) 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, 39017) 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, 48390) 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 id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=9
1.1 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, 48437) 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, 48398) 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 id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=78
1.1 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, 30574) 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, 48413) 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, 48422) 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
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayHeaderInfo/1/1/1/2/1/8/1/manufacturer/38/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|38" AND compile_id=""
1.1 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1452
1.1 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=1969
1.1 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, 48429) 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, 48465) 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, 48440) 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, 48483) 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, 48416) 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, 48425) 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, 48475) 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_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
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, 48419) 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, 48477) 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, 48392) 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, 38995) 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, 39019) 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, 48394) 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, 48400) 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, 40668) 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, 40667) 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, 48463) 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, 39020) 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, 48387) 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, 45521) 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, 30570) 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, 48388) 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, 45506) 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, 39016) 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, 30573) 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_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 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, 45511) 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, 30572) 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` = 7274) AND (b.`id_shop` = 1) LIMIT 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, 38990) 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, 48396) 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, 38986) 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, 39015) 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_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 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, 39000) 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, 48393) 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, 39011) 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, 30576) 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, 48384) 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, 45522) 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 *, ( 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, 30571) 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 *, ( 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, 48385) 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 *, ( 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, 39006) 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 *, ( 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, 45516) 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6922|1|2","", FROM_UNIXTIME(1733347768))
0.9 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, 48410) 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 id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.9 13 /modules/fscontentmanagement/classes/FSObject.php:345
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayRightTop/1/1/1/2/1/8/1/manufacturer/38/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|38" AND compile_id=""
0.9 1 sses/SmartyCustom.php:183
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7254|1|2","", FROM_UNIXTIME(1733347767))
0.9 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.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, 48386) 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 UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='a96deb83dadd158e14a4744bc7605cbc' AND cache_id="fsreinsurance|displayReassurance|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.9 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7232) 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|7272|1|2","", FROM_UNIXTIME(1733347767))
0.9 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, 48484) 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7243|1|2","", FROM_UNIXTIME(1733347767))
0.9 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 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 *, ( 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, 48404) 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6918|1|2","", FROM_UNIXTIME(1733347768))
0.9 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.9 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` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.8 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` = 4) 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` = 6927) 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 = 7230
ORDER BY f.position ASC
0.8 8 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` = 9) 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` = 7264) 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` = 7266) 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` = 7239) 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` = 7261) 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|7241|1|2","", FROM_UNIXTIME(1733347767))
0.8 1 sses/SmartyCustom.php:263
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.8 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, 48454) 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` = 7270) AND (b.`id_shop` = 1) LIMIT 1
0.8 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, 48443) 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` = 7253) AND (b.`id_shop` = 1) LIMIT 1
0.8 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, 48459) 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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6925|1|2","", FROM_UNIXTIME(1733347768))
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` = 7242) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.8 1 sses/Country.php:173
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 = 7238
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, 48446) 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` = 7248) 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` = 7236) 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|6926|1|2","", FROM_UNIXTIME(1733347768))
0.8 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, 48473) 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 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.8 1 sses/tax/TaxRulesTaxManager.php:108
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayLeftTop/1/1/1/2/1/8/1/manufacturer/38/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|38" AND compile_id=""
0.8 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` = 329) 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` = 7241) 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` = 7255) 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 = 7242
ORDER BY f.position ASC
0.8 6 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, 48486) 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 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 = 7104
ORDER BY f.position ASC
0.8 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 = 6926
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 = 7102
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` = 331) 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|7261|1|2","", FROM_UNIXTIME(1733347767))
0.8 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 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.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` = 137) 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` = 6929) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 2) 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` = 7247) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48401) 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.7 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` = 7249) 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` = 7246) 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 = 7229
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` = 6607) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48457) 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.7 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
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` = 6928) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.7 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.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 = 6606
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='29229ea482358ac182b62d6e88b341e7' AND cache_id="fsmenus|displayFooter1|1|1|1|2|1|8|1|manufacturer|38" AND compile_id="" LIMIT 1
0.7 1 sses/SmartyCustom.php:215
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, 48397) 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.7 2 Yes sses/SpecificPrice.php:362
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.7 20 /modules/fscontentmanagement/classes/FSObjectBase.php:473
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` = 7103) AND (b.`id_shop` = 1) LIMIT 1
0.7 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.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|7247|1|2","", FROM_UNIXTIME(1733347767))
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 = 7270
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 ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7259|1|2","", FROM_UNIXTIME(1733347767))
0.7 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` = 7245) 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 = 6924
ORDER BY f.position ASC
0.7 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` = 7252) 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` = 7104) 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` = 7102) 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|7246|1|2","", FROM_UNIXTIME(1733347767))
0.7 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` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 134) 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|7267|1|2","", FROM_UNIXTIME(1733347767))
0.7 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, 48449) 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.7 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|7245|1|2","", FROM_UNIXTIME(1733347767))
0.7 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 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.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` = 7254) 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` = 7250) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48487) 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.7 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` = 7099) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48407) 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.7 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` = 7271) 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 = 7253
ORDER BY f.position ASC
0.7 6 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, 48455) 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.7 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 = 7231
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` = 6604) 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` = 7228) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48462) 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.7 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` = 7237) 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` = 7100) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 1) 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` = 6609) 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 = 6927
ORDER BY f.position ASC
0.7 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|6971|1|2","", FROM_UNIXTIME(1733347768))
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 = 7248
ORDER BY f.position ASC
0.7 5 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` = 6605) AND (b.`id_shop` = 1) LIMIT 1
0.7 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`='fa916b650f2b5532b6fefcf8645b9f0b' AND cache_id="blocksearch|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.7 1 sses/SmartyCustom.php:215
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6920|1|2","", FROM_UNIXTIME(1733347768))
0.7 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` = 7235) AND (b.`id_shop` = 1) LIMIT 1
0.7 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.7 2 sses/Meta.php:149
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
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` = 9) 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 = 6928
ORDER BY f.position ASC
0.7 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` = 138) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 462 LIMIT 1
0.7 1 sses/Category.php:1054
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|38","", FROM_UNIXTIME(1733347768))
0.7 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7103|1|2","", FROM_UNIXTIME(1733347768))
0.7 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|6924|1|2","", FROM_UNIXTIME(1733347768))
0.7 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` = 7234) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48451) 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.7 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` = 6926) 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 = 7250
ORDER BY f.position ASC
0.7 5 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|7257|1|2","", FROM_UNIXTIME(1733347767))
0.7 1 sses/SmartyCustom.php:263
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7255|1|2","", FROM_UNIXTIME(1733347767))
0.7 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` = 6922) 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 = 7249
ORDER BY f.position ASC
0.7 5 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` = 7265) AND (b.`id_shop` = 1) LIMIT 1
0.7 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`='9d952574f839fde7cdb48e56b31958cd' AND cache_id="fsblockcms|displayFooterRight|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.7 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 7275) AND (id_product_attribute = 48485) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.7 1 sses/stock/StockAvailable.php:380
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 = 7235
ORDER BY f.position ASC
0.7 9 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 22:29:28"
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 22:29:28")
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 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 = 6925
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` = 7275) 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` = 7233) 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` = 6972) AND (b.`id_shop` = 1) LIMIT 1
0.7 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.7 1 Yes sses/shop/Shop.php:334
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.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 = 7101
ORDER BY f.position ASC
0.7 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 = 7241
ORDER BY f.position ASC
0.7 5 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 = 7228
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` = 45) 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 = 7233
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` = 6971) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 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 = 6929
ORDER BY f.position ASC
0.7 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 = 7246
ORDER BY f.position ASC
0.7 5 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.7 13 /modules/fscontentmanagement/classes/FSObject.php:345
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 = 7260
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 = 7103
ORDER BY f.position ASC
0.7 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` = 7273) AND (b.`id_shop` = 1) LIMIT 1
0.7 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, 48469) 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.7 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` = 7224) AND (b.`id_shop` = 1) LIMIT 1
0.6 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, 48471) 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.6 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 = 7226
ORDER BY f.position ASC
0.6 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 = 7264
ORDER BY f.position ASC
0.6 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 = 7262
ORDER BY f.position ASC
0.6 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 = 7254
ORDER BY f.position ASC
0.6 5 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` = 6930) AND (b.`id_shop` = 1) LIMIT 1
0.6 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, 48431) 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.6 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` = 6923) 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 ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7270|1|2","", FROM_UNIXTIME(1733347767))
0.6 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 = 6920
ORDER BY f.position ASC
0.6 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 = 7265
ORDER BY f.position ASC
0.6 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 = 6972
ORDER BY f.position ASC
0.6 5 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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 ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7269|1|2","", FROM_UNIXTIME(1733347767))
0.6 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, 48488) 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.6 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` = 6603) 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 ('e002586a29594e46f9461f0df12e4f19',"productlist_colors|7102|1|2","", FROM_UNIXTIME(1733347768))
0.6 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` = 7231) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 7271
ORDER BY f.position ASC
0.6 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 = 7232
ORDER BY f.position ASC
0.6 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` = 6921) 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` = 257) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.6 1 Yes sses/shop/Shop.php:663
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.6 1 sses/SmartyCustom.php:215
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 = 6609
ORDER BY f.position ASC
0.6 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
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|7267|1|2" AND compile_id="" LIMIT 1
0.6 1 sses/SmartyCustom.php:215
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 = 7099
ORDER BY f.position ASC
0.6 5 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 = 6921
ORDER BY f.position ASC
0.6 6 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` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 7227) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cb.`id_fs_menu_block`
FROM ps_fs_menu_block cb
WHERE `id_hook` = 141 AND active=1 
ORDER by cb.`position`
0.6 9 Yes /modules/fsmenus/src/FSMenuBlockRepository.php:166
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` = 6918) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 6925) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 7224
ORDER BY f.position ASC
0.6 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 = 7225
ORDER BY f.position ASC
0.6 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` = 7101) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 7252
ORDER BY f.position ASC
0.6 5 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 = 6923
ORDER BY f.position ASC
0.6 6 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` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.6 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 = 6930
ORDER BY f.position ASC
0.6 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23