Pack DIY Le Labo Vaponaute

Pack DIY
Packen Sie Le Labo, um Ihre E-Liquids einfach und sicher zuzubereiten

9,90 €

Auf Lager - Versand innerhalb von 24 Stunden

15 Produkte

Typ des Produkts :
Pack DIY
Nikotinspiegel :
3 mg/ml, 9 mg/ml, 12 mg/ml, 6 mg/ml
Fassungsvermögen der Flasche :
125 ml
Versand heute
Versand heute

bei Bestellung bis 12 Uhr

Pack DIY Vaponaute : Alles über Vape-Produkte wissen

Vaponaute bietet Ihnen sein DIY-Paket Le Labo an, mit dem Sie Ihre hausgemachten E-Liquids ganz einfach mit Produkten in pharmazeutischer Qualität herstellen können.
Je nach Bedarf sind mehrere Nikotinstärken erhältlich: 3 mg/ml, 6 mg/ml, 9 mg/ml und 12 mg/ml.

Produkt für Minderjährige unter 18 Jahren verboten. Vaping ist ein Übergang zu einem Leben ohne Tabak und dann ohne Nikotinabhängigkeit. Dampfen Sie nicht, wenn Sie nicht rauchen.

Kann gefährlich sein. Beachten Sie die Vorsichtsmaßnahmen bei der Verwendung. Flüssigkeiten können eine allergische Reaktion hervorrufen. Informieren Sie sich ausführlich über die Inhaltsstoffe und Gefahren (H/EUH) von E-Flüssigkeiten und elektronischen Zigaretten.. Der Nutzer wird in unseren Allgemeinen Geschäftsbedingungen über die Modalitäten der kostenlosen Rücknahme von Elektro- und Elektronik-Altgeräten informiert. .

Produktbeschreibung : Pack DIY Le Labo Vaponaute

Das Le Labo DIY Pack besteht aus einer 125 ml-Flasche und einer Basis, die zu 50% aus Propylenglykol und zu 50% aus pflanzlichem Glyzerin besteht.

Le Labo DIY Pack, ein Dampfen in aller Sicherheit. Die Basis und der Boost von Vaponaute Paris werden ausschließlich aus pharmazeutischen Komponenten hergestellt, die der AFNOR-Norm XP D 90-300-2 entsprechen und Ihnen somit eine unvergleichliche Sicherheit garantieren!

  • Pack 3 mg: eine Vaponaute-Basis von 82 ml in einer Flasche, die 125 ml fassen kann + 2 Vaponaute-Boosts von 18 mg/ml.
  • 6 mg Packung: 62 ml Vaponaute Basis in einer Flasche mit 125 ml Fassungsvermögen + 4 Vaponaute Boosts 18 mg/ml.
  • Pack 9 mg: 42 ml Vaponaute-Basislösung in einer Flasche, die 125 ml enthalten kann + 6 Vaponaute-Boosts zu 18 mg/ml.
  • Pack 12 mg: Eine 22 ml Vaponaute-Basis in einer Flasche, die 125 ml enthalten kann + 8 Vaponaute-Boosts von 18 mg/ml.
  • Das DIY-Paket Le Labo de Vaponaute wird in Frankreich von Gaïatrend hergestellt.

Sein eigenes E-Liquid zu entwerfen ermöglicht es, die Aromen zu dosieren, die Basis und den Nikotingehalt zu wählen, um ein einzigartiges E-Liquid zu kreieren, das ganz auf Ihren Geschmack und Ihre Bedürfnisse zugeschnitten ist.

E-Garette bietet Ihnen eine große Auswahl an konzentrierten Aromen für den DIY-Bereich zum besten Preis!

Konzentrierte Aromen

Die Vorbereitung des DIY-Pakets

  • Öffnen Sie den Flakon La Base.
  • Gießen Sie den Inhalt der 10mL-Flaschen Le Booste, je nach gewünschtem Nikotingehalt.
  • Fügen Sie 18mL des Aromas Ihrer Wahl hinzu. Sie erhalten 120mL nikotinhaltige e-Flüssigkeit.
  • Verschließen Sie die Flasche La Base und schütteln Sie sie 1 Minute lang energetisch.
  • Ihr Produkt ist nun bereit zum Dampfen.

Das im Nikotinbooster enthaltene Nikotin ist ein Produkt, das mit großer Vorsicht behandelt werden muss. Tragen Sie bei der Verwendung von Nikotinboostern immer Handschuhe und eine Schutzbrille.

Wie wählt man den richtigen Nikotingehalt?

Den richtigen Nikotingehalt für den Konsum von E-Liquids festzulegen, ist nicht trivial. Es ist einer der entscheidenden Schritte für eine erfolgreiche Raucherentwöhnung und einen erfolgreichen Umstieg auf das Dampfen.

Hier sind einige Anhaltspunkte:

  • 0 mg/ml Nikotin: Ihr E-Liquid ist nikotinfrei. Es ist für Dampfer gedacht, die sich am Ende der Raucherentwöhnung befinden.
  • Der 3 mg/ml Nikotin: Diese Dosierung entspricht in etwa einem durchschnittlichen Konsum von weniger als 10 Zigaretten pro Tag.
  • Die 6 mg/ml Nikotin: Diese Dosierung entspricht eher einem durchschnittlichen Konsum von mehr als 10 Zigaretten pro Tag.
  • Die 12 mg/ml Nikotin: Diese Dosierung entspricht einem durchschnittlichen Konsum von mehr als 15 Zigaretten pro Tag.

Achten Sie auf Über- und Unterdosierungen von Nikotin!

Wenn Sie ein E-Liquid mit einem im Vergleich zu Ihren Bedürfnissen zu niedrigen Nikotingehalt konsumieren, werden Sie einen Entzug verspüren. Dies könnte auf Dauer dazu führen, dass Sie wieder auf herkömmliche Zigaretten zurückgreifen.

Wenn Sie umgekehrt ein Liquid mit einem zu hohen Nikotingehalt konsumieren, kann es zu einer Überdosierung kommen. Sie kann verschiedene Symptome hervorrufen, die von Person zu Person unterschiedlich sind.

le labo

Eigenschaften : Pack DIY Le Labo Vaponaute

Typ des ProduktsPack DIY
Nikotinspiegel3 mg/ml
Nikotinspiegel9 mg/ml
Nikotinspiegel12 mg/ml
Nikotinspiegel6 mg/ml
Nikotinmenge / Anzahl der Zigaretten6 mg / 10 cigarettes
Nikotinmenge / Anzahl der Zigaretten3 mg / 5 cigarettes
Nikotinmenge / Anzahl der Zigaretten9 mg / 15 cigarettes
Nikotinmenge / Anzahl der Zigaretten11 mg / entre 15 et 20 cigarettes
Fassungsvermögen der Flasche125 ml

Vaponaute, eine Marke mit tausend Qualitäten

Tauchen Sie mit den DIY-Produkten und E-Liquids der Marke Vaponaute in die exquisite Welt des Dampfens ein. Diese Produkte wurden mit einer der Kunst des Dampfens gewidmeten Leidenschaft entwickelt und laden dazu ein, einzigartige und bezaubernde Geschmackserlebnisse zu schaffen. Entdecken Sie eine Reihe von DIY-Basen und -Boostern, die akribisch ausgearbeitet wurden, um komplexe und ausgewogene Geschmacksrichtungen zu kreieren, die es Ihnen ermöglichen, das Dampferlebnis nach Ihren individuellen Vorlieben zu gestalten.

Die dampfbereiten Liquids entführen Sie in eine Welt der Kultiviertheit und Eleganz, mit subtilen und raffinierten Mischungen, die von der französischen Haute Couture inspiriert sind. Ob Sie ein Neuling oder ein Experte im Dampfen sind, die Produkte von Vaponaute versprechen ein unvergessliches sensorisches Erlebnis, bei dem jede Inhalation eine Einladung zu Eleganz und Raffinesse ist. Erliegen Sie der Exzellenz von Vaponaute und lassen Sie sich von der Kunst des Dampfens verführen.

Diese französische Premiummarke bietet E-Liquids mit originellen und kreativen Geschmacksrichtungen sowie DIY-Basen und Booster von höchster Qualität.

In den Warenkorb gelegt!
Anzahl
Weiter einkaufen
Load Time898 ms - OK... for a shared hosting
Querying Time270 ms
Queries426
Memory Peak Usage16.6 Mb
Included Files621 files - 9.87 Mb
PrestaShop Cache- Mb
Global vars1.94 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 146 ms 146 ms 5.60 Mb 5.60 Mb
__construct 0 ms 146 ms - Mb 5.60 Mb
init 69 ms 215 ms 2.04 Mb 7.89 Mb
checkAccess 0 ms 215 ms - Mb 7.89 Mb
setMedia 6 ms 222 ms 0.03 Mb 7.89 Mb
postProcess 0 ms 222 ms - Mb 7.89 Mb
initHeader 0 ms 222 ms - Mb 7.89 Mb
initContent 237 ms 459 ms 4.03 Mb 12.11 Mb
initFooter 31 ms 490 ms 0.02 Mb 12.11 Mb
display 408 ms 898 ms 4.57 Mb 16.60 Mb
Hook Time Memory Usage
__construct 83 ms 4.00 Mb
hookdisplayProductPriceBlock 63 ms 2.00 Mb
hookmoduleRoutes 28 ms - Mb
hookdisplayGDPRConsent 17 ms - Mb
hookactionProductOutOfStock 17 ms 2.00 Mb
hookdisplayHeader 16 ms - Mb
hookfooter 16 ms - Mb
hookdisplayNav 15 ms - Mb
hookdisplayModal 13 ms - Mb
hookdisplayTop 10 ms - Mb
hookdisplayHeaderInfo 8 ms - Mb
hookHeader 8 ms - Mb
hookdisplayFooter 7 ms - Mb
hookactionDispatcher 5 ms - Mb
hookdisplayLeftColumn 4 ms - Mb
hookdisplayProductActions 4 ms - Mb
hookproductfooter 4 ms - Mb
hookdisplayRightTop 3 ms - Mb
hookdisplayLeftTop 3 ms - Mb
hookdisplayProductTabContent 3 ms - Mb
hookdisplaySummaryBuyBlock 3 ms - Mb
hookdisplayProductButtons 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayFooterProduct 2 ms - Mb
hookdisplayFooter1 2 ms - Mb
hookdisplayReassurance 2 ms - Mb
hookdisplayFooterLeft 1 ms - Mb
hookdisplayProductTab 1 ms - Mb
hookdisplayFooterRight 1 ms - Mb
hookdisplayRightColumnProduct 1 ms - Mb
hookdisplayLeftColumnProduct 1 ms - Mb
hookdisplayHeaderMobile 1 ms - Mb
hookextraright 0 ms - Mb
hookdisplayBeforeHProduct 0 ms - Mb
hookdisplayProductListFunctionalButtons 0 ms - Mb
hookproducttabcontent 0 ms - Mb
hooktop 0 ms - Mb
hookactionFrontControllerSetMedia 0 ms - Mb
hookproducttab 0 ms - Mb
hookdisplayProductListReviews - ms - Mb
hookDisplayOverrideTemplate - ms - Mb
41 hooks 346 ms 8.00 Mb
Module Time Memory Usage
psproductcountdownpro 72 ms 2.00 Mb
fscontentmanagement 51 ms 2.00 Mb
g_megamenu 26 ms 2.00 Mb
blocknewsletter 23 ms - Mb
psgdpr 17 ms - Mb
mailalerts 17 ms 2.00 Mb
trustedshopsintegration 12 ms - Mb
fslogin 10 ms - Mb
pm_advancedcookiebanner 9 ms - Mb
fsmenus 7 ms - Mb
ukoosummary 7 ms - Mb
faqs 6 ms - Mb
pagecache 6 ms - Mb
blocklanguages 6 ms - Mb
doofinder 6 ms 2.00 Mb
fsblockcms 5 ms - Mb
blockcart 5 ms - Mb
opartlimitquantity 5 ms - Mb
pm_advancedpack 5 ms - Mb
colissimo 4 ms - Mb
fsreinsurance 3 ms - Mb
netreviews 3 ms - Mb
tradedoubler_affiliate_tracker 3 ms - Mb
dhldp 3 ms 2.00 Mb
blocksearch 3 ms - Mb
favoriteproducts 2 ms - Mb
blockcartNova 2 ms 2.00 Mb
jprestawebp 2 ms - Mb
ukoobillboard 2 ms - Mb
psgdprNova 2 ms - Mb
systempay 2 ms - Mb
fsfeaturesextend 2 ms - Mb
fsorderedproducts 1 ms - Mb
favoriteproductsNova 1 ms - Mb
loyalty 1 ms - Mb
blocksocial 1 ms - Mb
ganalytics 1 ms 2.00 Mb
blocklayeredNova 1 ms - Mb
fsmodals 1 ms - Mb
mailalertsNova 1 ms - Mb
blocksearchNova 1 ms - Mb
pagesnotfound 1 ms - Mb
ukooresponslide 1 ms - Mb
sekeywordsNova 1 ms - Mb
fscities 1 ms - Mb
blocksocialNova 1 ms - Mb
fsjsonld 1 ms - Mb
qcdshippingperproduct 1 ms - Mb
fsadvancedsearch 0 ms - Mb
editorial 0 ms - Mb
fsblockproducts 0 ms - Mb
tradedoubler 0 ms - Mb
blocklayered 0 ms - Mb
sekeywords - ms - Mb
54 modules 346 ms 8.00 Mb

Stopwatch SQL - 426 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` = 128
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY p.id_product
ORDER BY pl.`name` ASC
LIMIT 0,2
20.7 26574 Yes Yes sses/Manufacturer.php:386
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `ps_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
17.3 6793 sses/SpecificPrice.php:230
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
8 0 sses/Hook.php:131
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6.1 1551 sses/Configuration.php:148
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
4.8 532 a/classes/Hook.php:410
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, hm.`id_hook_behavior`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.3 182 Yes Yes a/classes/Hook.php:109
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "category"
AND pspco.`id_object` IN (30,227,231,283,284,285,294,296,297,298,299,376,393,395,1,2,1,2,30,393,1,2,30,1,2,30,393,227,1,2,30,393,227,1,2,30,393,227,1,2,30,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,395,1,2,30,1,2,30)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
3.9 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
3.2 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
2.7 647 sses/SpecificPrice.php:238
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.5 647 sses/SpecificPrice.php:230
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.2 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 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, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
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_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.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 (p.`id_manufacturer`= m.`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  )
WHERE `id_product_1` = 5100 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.1 3 Yes sses/Product.php:3602
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`, 
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, 
image_shop.`id_image` id_image, il.`legend` as legend, m.`name` AS manufacturer_name, 
cl.`name` AS category_default, DATEDIFF(product_shop.`date_add`, 
DATE_SUB("2024-12-04 00:00:00", INTERVAL 30 DAY)) > 0 AS new, 
product_shop.price AS orderprice
FROM `ps_product` p
LEFT JOIN `ps_ukoosummary_association` ua 
ON (p.`id_product` = ua.`id_child`
AND ua.`id_parent` = 5100 AND ua.`id_group` = 1)
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_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  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.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`
WHERE product_shop.`id_shop` = 1 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") AND ua.`id_parent` = 5100 AND ua.`id_group` = 1 ORDER BY ua.`position` ASC
LIMIT 0,10
2 1 Yes /modules/ukoosummary/classes/UkooSummarySummary.php:212
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, 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, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory_bis`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
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_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.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 (p.`id_manufacturer`= m.`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  )
WHERE `id_product_1` = 5100 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2 1 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:139
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5100
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.7 3 Yes Yes sses/Product.php:3517
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.6 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description
FROM `ps_category` c
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 30
AND `active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.6 5 Yes Yes sses/Category.php:656
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.5 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=2
1.5 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, 11392) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.4 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
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` = 4481) AND (b.`id_shop` = 1) LIMIT 1
1.3 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, 11395) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=2
1.3 1241 a/classes/Product.php:216
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 *
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
1.2 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.2 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.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 id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1969
1.2 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE *, ( 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, 11197) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=9
1.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, 11394) 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, 12623) 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 c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
1.1 18 Yes Yes sses/Category.php:859
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_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` = 4983) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_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`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
1.1 2 Yes sses/SpecificPrice.php:419
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 26666) 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=10
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=2
1 1241 a/classes/Product.php:216
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` = 30) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5100) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1452
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=78
1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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` = 5100) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1968
0.9 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5100 AND `id_shop` = 1
0.9 4 a/Adapter/Adapter_EntityMapper.php:70
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 id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=443
0.9 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE gl.*, g.`id_ukoosummary_group`, g.`position`
FROM `ps_ukoosummary_group_lang` gl
LEFT JOIN `ps_ukoosummary_group` g
ON (gl.`id_ukoosummary_group` = g.`id_ukoosummary_group`)
INNER JOIN `ps_ukoosummary_association` a 
ON (g.`id_ukoosummary_group` = a.`id_group` 
AND a.`id_parent` = 5100) WHERE gl.`id_lang` = 2
GROUP BY g.`id_ukoosummary_group` ORDER BY g.`position` ASC
0.9 1 Yes Yes /modules/ukoosummary/classes/UkooSummaryGroup.php:170
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 gl.*, g.`id_ukoosummary_group`, g.`position`
FROM `ps_ukoosummary_group_lang` gl
LEFT JOIN `ps_ukoosummary_group` g
ON (gl.`id_ukoosummary_group` = g.`id_ukoosummary_group`)
INNER JOIN `ps_ukoosummary_association` a 
ON (g.`id_ukoosummary_group` = a.`id_group` 
AND a.`id_parent` = 5100) WHERE gl.`id_lang` = 2
GROUP BY g.`id_ukoosummary_group` ORDER BY g.`position` ASC
0.9 1 Yes Yes /modules/ukoosummary/classes/UkooSummaryGroup.php:170
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 2)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 5100
0.9 3 sses/Product.php:5624
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 11) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "category"
AND pspco.`id_object` IN (30,227,231,283,284,285,294,296,297,298,299,376,393,395,1,2,1,2,30,393,1,2,30,1,2,30,393,227,1,2,30,393,227,1,2,30,393,227,1,2,30,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,395,1,2,30,1,2,30)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.9 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
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 = 4481
ORDER BY f.position ASC
0.8 9 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5100
AND a.`id_attribute` NOT IN(112, 59, 111)
0.8 3 sses/Product.php:5665
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.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "category"
AND pspco.`id_object` IN (30,227,231,283,284,285,294,296,297,298,299,376,393,395,1,2,1,2,30,393,1,2,30,1,2,30,393,227,1,2,30,393,227,1,2,30,393,227,1,2,30,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,294,1,2,30,395,1,2,30,1,2,30)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.8 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE c.id_category, cl.name, cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE c.nleft <= 503
AND c.nright >= 576
AND c.nleft >= 2
AND c.nright <= 671
AND cl.id_lang = 2
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
0.8 34 Yes sses/Tools.php:1308
SELECT SQL_NO_CACHE DISTINCT la.`id_attribute`, la.`url_name` as `attribute`
FROM `ps_attribute` a
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `ps_layered_indexable_attribute_lang_value` la
ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = 2)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 5100
0.8 3 sses/Product.php:5624
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5100) 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` = 2846) 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` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.8 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.7 1 Yes sses/shop/Shop.php:663
SELECT SQL_NO_CACHE b.`link_rewrite` AS link_rewrite,b.`meta_title` AS meta_title,b.`meta_description` AS meta_description,b.`title` AS title,b.`description` AS description,a.`id_attribut` AS id_attribut,c.`id_fs_object_attributes` AS id,a.`id_employee` AS id_employee,a.`position` AS position,c.`active` AS active,c.`date_add` AS date_add,c.`date_upd` AS date_upd,c.`deleted` AS deleted
FROM
`ps_fs_object_attributes` AS a
INNER JOIN
`ps_fs_object_attributes_lang` AS b ON ((a.`id_fs_object_attributes` = b.`id_fs_object_attributes`) AND (b.`id_lang` = 2) AND (b.`id_shop` = 1))
INNER JOIN
`ps_fs_object_attributes_shop` AS c ON ((a.`id_fs_object_attributes` = c.`id_fs_object_attributes`) AND (c.`id_shop` = 1))
WHERE
1 AND
c.`active` = 1 AND c.`deleted` = 0
ORDER BY
a.`position` ASC
LIMIT
0,1000000
0.7 2 Yes /modules/fscontentmanagement/classes/FSObjectBase.php:473
SELECT SQL_NO_CACHE b.`id_ukoobillboard`, bl.`message`, b.`display_mod`, b.`message_position`, b.`bg_color`, b.`txt_color`,
b.`btn_color`, b.`btn_txt_color`, b.`use_cookie`, b.`position`, b.`display_page`, b.`display_product`,
b.`display_close_btn`
FROM `ps_ukoobillboard` b
LEFT JOIN `ps_ukoobillboard_lang` bl
ON (b.`id_ukoobillboard` = bl.`id_ukoobillboard`
AND bl.`id_lang` = 2)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 21:52:14"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 21:52:14")
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` = "product"
OR b.`display_page` = "category" 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 product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 5100 LIMIT 1
0.7 3 sses/Product.php:752
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 544
AND `nright` > 545
0.7 274 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='5a8b33fb9c66397d445d151eee7305f9' AND cache_id="fsmenus|displayLeftTop|1|1|1|2|1|8|1|product|5100" AND compile_id="" LIMIT 1
0.7 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 548
AND `nright` > 549
0.7 276 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2846) AND (id_product_attribute = 0) 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 = 4766
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 = 5704
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 = 2846
ORDER BY f.position ASC
0.7 3 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE b.`id_ukoobillboard`, bl.`message`, b.`display_mod`, b.`message_position`, b.`bg_color`, b.`txt_color`,
b.`btn_color`, b.`btn_txt_color`, b.`use_cookie`, b.`position`, b.`display_page`, b.`display_product`,
b.`display_close_btn`
FROM `ps_ukoobillboard` b
LEFT JOIN `ps_ukoobillboard_lang` bl
ON (b.`id_ukoobillboard` = bl.`id_ukoobillboard`
AND bl.`id_lang` = 2)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 21:52:14"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 21:52:14")
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` = "product"
OR b.`display_page` = "category" AND b.`display_mod` = "display_popup" ORDER BY b.`position` ASC
0.7 1 Yes /modules/ukoobillboard/classes/UkooBillboardBillboard.php:188
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` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pl.`id_lang`, pl.`link_rewrite`, p.`ean13`, cl.`link_rewrite` AS category_rewrite
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_lang` l ON (pl.`id_lang` = l.`id_lang`)
LEFT JOIN `ps_category_lang` cl ON (cl.`id_category` = product_shop.`id_category_default`  AND cl.`id_lang` = pl.`id_lang` AND cl.id_shop = 1 )
WHERE p.`id_product` = 5100
AND l.`active` = 1
0.7 16 sses/Product.php:5017
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.7 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5704) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE tr.*
FROM `ps_tax_rule` tr
JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 23
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.7 1 sses/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE 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 = 4983
ORDER BY f.position ASC
0.7 7 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE `active`
FROM `ps_pspc_shop`
WHERE `id_pspc` = 13
AND `id_shop` = 1 LIMIT 1
0.6 1 /modules/psproductcountdownpro/classes/PSPC.php:89
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 546
AND `nright` > 547
0.6 275 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (5100)
AND pspco.`id_product_attribute` IN (0, 11392)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.6 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 544
AND `nright` > 545
0.6 274 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE COUNT(c.`id_fs_object_displaypricedeal`)
FROM
`ps_fs_object_displaypricedeal` AS a
INNER JOIN
`ps_fs_object_displaypricedeal_lang` AS b ON ((a.`id_fs_object_displaypricedeal` = b.`id_fs_object_displaypricedeal`) AND (b.`id_lang` = 2) AND (b.`id_shop` = 1))
INNER JOIN
`ps_fs_object_displaypricedeal_shop` AS c ON ((a.`id_fs_object_displaypricedeal` = c.`id_fs_object_displaypricedeal`) AND (c.`id_shop` = 1))
WHERE
1 AND
c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.6 31 /modules/fscontentmanagement/classes/FSObjectBase.php:473
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "manufacturer"
AND pspco.`id_object` IN (128)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.6 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `ps_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
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)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5100
AND a.`id_attribute` NOT IN(112, 59, 111)
0.6 3 sses/Product.php:5665
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 10) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 504
AND `nright` > 515
0.6 253 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.6 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2846) AND (id_product_attribute = 26666) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.6 1 sses/stock/StockAvailable.php:380
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` = 4766) 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` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5100) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (11392, 11395, 11394) AND il.`id_lang` = 2 ORDER by i.`position`
0.6 3 Yes sses/Product.php:2189
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 565
AND `nright` > 568
0.6 284 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
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.6 20 /modules/fscontentmanagement/classes/FSObjectBase.php:473
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `ps_image` i
INNER JOIN ps_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 5100
ORDER BY `position`
0.6 4 Yes sses/Product.php:2725
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 513
AND `nright` > 514
0.6 258 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
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 = 5100
ORDER BY f.position ASC
0.6 10 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_manufacturer` a
LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 128) LIMIT 1
0.6 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` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 516
AND `nright` > 537
0.6 259 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(c.`id_fs_object_attributes`)
FROM
`ps_fs_object_attributes` AS a
INNER JOIN
`ps_fs_object_attributes_lang` AS b ON ((a.`id_fs_object_attributes` = b.`id_fs_object_attributes`) AND (b.`id_lang` = 2) AND (b.`id_shop` = 1))
INNER JOIN
`ps_fs_object_attributes_shop` AS c ON ((a.`id_fs_object_attributes` = c.`id_fs_object_attributes`) AND (c.`id_shop` = 1))
WHERE
1 AND
c.`active` = 1 AND c.`deleted` = 0 LIMIT 1
0.6 2 /modules/fscontentmanagement/classes/FSObjectBase.php:473
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.6 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 542
AND `nright` > 563
0.6 272 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5704)
0.6 3 sses/Product.php:3002
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 4983 LIMIT 1
0.6 1 sses/Product.php:765
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 30 AND `id_shop` = 1
0.5 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.5 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 5100
0.5 3 sses/Product.php:2171
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.5 1 Yes sses/shop/Shop.php:334
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2846)
0.5 3 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5100)
0.5 3 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 513
AND `nright` > 514
0.5 258 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 513
AND `nright` > 514
0.5 258 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 564
AND `nright` > 575
0.5 283 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4983 LIMIT 1
0.5 1 sses/Product.php:752
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 542
AND `nright` > 563
0.5 272 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 564
AND `nright` > 575
0.5 283 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (5100)
AND pspco.`id_product_attribute` IN (0, 11394)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.5 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "product"
AND pspco.`id_object` IN (5100)
AND pspco.`id_product_attribute` IN (0, 11395)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.5 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 10
0.5 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "manufacturer"
AND pspco.`id_object` IN (128)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.5 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 511
AND `nright` > 512
0.5 257 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 548
AND `nright` > 549
0.5 276 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 511
AND `nright` > 512
0.5 257 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 507
AND `nright` > 508
0.5 255 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 503
AND `nright` > 576
0.5 252 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 543
AND `nright` > 550
0.5 273 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
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` = 9) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 516
AND `nright` > 537
0.5 259 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4481 LIMIT 1
0.5 1 sses/Product.php:752
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 507
AND `nright` > 508
0.5 255 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
0.5 86 sses/Hook.php:187
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 503
AND `nright` > 576
0.5 252 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='582e3b5913725a86916f5149f182ca56' AND cache_id="fsblockcms|displayFooterLeft|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.5 1 sses/SmartyCustom.php:215
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|product|5100" AND compile_id="" LIMIT 1
0.5 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.5 2 Yes sses/Currency.php:231
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_product = 5100
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.5 0 sses/Product.php:1278
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4983)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short`
FROM `ps_product` p
LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = 1 )
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE pl.id_lang = 2
AND pl.id_product = 5100
AND product_shop.active = 1 LIMIT 1
0.5 1 sses/Meta.php:259
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 504
AND `nright` > 515
0.5 253 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=5100
0.4 1 sses/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.4 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
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` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.4 0 sses/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 297) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 509
AND `nright` > 510
0.4 256 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 296) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_attributes` a
LEFT JOIN `ps_fs_object_attributes_lang` `b` ON a.`id_fs_object_attributes` = b.`id_fs_object_attributes` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_attributes_shop` `c` ON a.`id_fs_object_attributes` = c.`id_fs_object_attributes` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_attributes` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 565
AND `nright` > 568
0.4 284 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 30) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4766)
0.4 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 1 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4481)
0.4 1 sses/Product.php:3002
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='973f4f4dc59100540995bb4f45ea7a77' AND cache_id="ukoosummary-product-tab-content|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "attributes" LIMIT 1
0.4 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.4 1 sses/Country.php:173
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 1452
0.4 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 11197 LIMIT 1
0.4 1 sses/Combination.php:343
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, cl.`id_lang`
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN ps_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE cl.`id_lang` = 2
AND c.`id_category` IN (30)
0.4 1 sses/Category.php:1599
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='bc3bff7cee537931504da8ac4f6c6ef0' AND cache_id="blocksearch-top|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE item.id_g_megamenus FROM `ps_g_megamenus` item
LEFT JOIN  `ps_g_megamenus_shop` itemshop 
ON item.id_g_megamenus = itemshop.id_g_megamenus
WHERE FIND_IN_SET("all_page", item.pages) AND itemshop.id_shop = 1 AND item.active = 1
GROUP BY item.id_g_megamenus ASC
0.4 1 Yes /modules/g_megamenu/classes/gmegamenusModel.php:94
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.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='b8c5bef7265340ce2f6e5204863da515' AND cache_id="fsmenus|displayHeaderInfo|1|1|1|2|1|8|1|product|5100" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='091c66d6cbea4e7d8388961b0f96c072' AND cache_id="blocksocial|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE pspc.`id_pspc`
FROM `ps_pspc` pspc
LEFT JOIN `ps_pspc_shop` pspcs
ON pspc.`id_pspc` = pspcs.`id_pspc`
WHERE pspcs.`active` = 1 AND `personal` = 0
AND pspcs.`id_shop` = 1
AND (
(`action_start` != "" AND `action_start` IS NOT NULL
AND `action_start_done` = 0 AND `from` <= UTC_TIMESTAMP())
OR
(`action_end` != "" AND `action_end` IS NOT NULL
AND `action_end_done` = 0 AND `to` <= UTC_TIMESTAMP())
)
0.4 9 /modules/psproductcountdownpro/psproductcountdownpro.php:2947
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 542
AND `nright` > 563
0.4 272 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 3 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE pspco.`id_pspc`
FROM `ps_pspc_object` pspco
LEFT JOIN `ps_pspc` pspc USING (`id_pspc`)
LEFT JOIN `ps_pspc_shop` pspcs USING (`id_pspc`)
LEFT JOIN `ps_pspc_group` pspcg USING (`id_pspc`)
WHERE pspcs.`id_shop` IN (1)
AND pspco.`type` = "manufacturer"
AND pspco.`id_object` IN (128)
AND pspco.`id_product_attribute` IN (0, 0)
AND (
pspc.`all_groups` = 1
OR pspcg.`id_group` IN (1)
)
ORDER BY pspco.`id_product_attribute` DESC, pspc.`to` ASC, pspco.`id_object` DESC LIMIT 1
0.4 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.4 1 sses/Product.php:5637
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='04918b188e47606286a82a4a76dfdc03' AND cache_id="fsblockcms|displayHeaderInfo|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `ps_lang` l
JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.4 16 sses/Language.php:892
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 285) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 298 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
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.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 283) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "attributes" LIMIT 1
0.4 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "product" LIMIT 1
0.4 1 sses/Theme.php:275
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 2 AND `id_shop` = 1 LIMIT 1
0.4 1 sses/module/Module.php:2218
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE url_rewrite FROM ps_meta_lang ml
INNER JOIN ps_meta m ON ml.id_meta=m.id_meta
WHERE
m.page="module-fscontentmanagement-media"
AND id_shop = 1
AND id_lang = 1 LIMIT 1
0.4 1 /modules/fscontentmanagement/fscontentmanagement.php:806
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 283 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4481
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 sses/SpecificPrice.php:196
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 5100) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.4 1 sses/stock/StockAvailable.php:672
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 565
AND `nright` > 568
0.4 284 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.4 1 sses/shop/Shop.php:202
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 2 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.4 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 546
AND `nright` > 547
0.4 275 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "netreviews" LIMIT 1
0.4 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 284) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 443
0.4 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 1452) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_attributes` a
LEFT JOIN `ps_fs_object_attributes_lang` `b` ON a.`id_fs_object_attributes` = b.`id_fs_object_attributes` AND b.`id_lang` = 2
LEFT JOIN `ps_fs_object_attributes_shop` `c` ON a.`id_fs_object_attributes` = c.`id_fs_object_attributes` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_attributes` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 1969
0.4 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 395) LIMIT 1
0.4 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` = 231 LIMIT 1
0.4 1 sses/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 78) LIMIT 1
0.4 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.4 1 sses/Country.php:173
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5704 AND id_shop=1 LIMIT 1
0.4 1 sses/Product.php:5037
SELECT SQL_NO_CACHE url_rewrite FROM ps_meta_lang ml
INNER JOIN ps_meta m ON ml.id_meta=m.id_meta
WHERE
m.page="module-fscontentmanagement-media"
AND id_shop = 1
AND id_lang = 1 LIMIT 1
0.4 1 a/tmp/7d22a50db7991b6b7f8a2589329450185ad8f6d6.php:48
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT 1
0.4 1 sses/SmartyCustom.php:95
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 1969) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 78
0.4 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 9
0.4 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE item.id_g_megamenus FROM `ps_g_megamenus` item
LEFT JOIN  `ps_g_megamenus_shop` itemshop 
ON item.id_g_megamenus = itemshop.id_g_megamenus
WHERE FIND_IN_SET("all_page", item.pages) AND itemshop.id_shop = 1 AND item.active = 1
GROUP BY item.id_g_megamenus ASC
0.4 1 Yes /modules/g_megamenu/classes/gmegamenusModel.php:94
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.4 1 sses/Country.php:173
SELECT SQL_NO_CACHE name FROM ps_configuration where name like 'AV_GROUP_CONF_%'
0.4 71 /modules/netreviews/netreviews.php:2756
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "displaypricedeal" LIMIT 1
0.4 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.4 13 /modules/fscontentmanagement/classes/FSObject.php:345
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.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='64057145ca61a41f3fcc884f4f62c395' AND cache_id="fsmenus|displayRightTop|1|1|1|2|1|8|1|product|5100" AND compile_id="" LIMIT 1
0.4 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.4 1 sses/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE quantity,batch_type FROM ps_opartlimitquantity_product_batch WHERE id_product = 5100 LIMIT 1
0.4 1 /modules/opartlimitquantity/opartlimitquantity.php:768
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 12 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE id_fs_object, slug FROM ps_fs_object WHERE 1 AND active = 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:318
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 11 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_g_megamenus` a
LEFT JOIN `ps_g_megamenus_lang` `b` ON a.`id_g_megamenus` = b.`id_g_megamenus` AND b.`id_lang` = 2
LEFT JOIN `ps_g_megamenus_shop` `c` ON a.`id_g_megamenus` = c.`id_g_megamenus` AND c.`id_shop` = 1
WHERE (a.`id_g_megamenus` = 2) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 30 LIMIT 1
0.3 0 sses/Category.php:1054
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 5100 LIMIT 1
0.3 3 sses/Product.php:765
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4766) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 12623 LIMIT 1
0.3 1 sses/Combination.php:343
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 4766 LIMIT 1
0.3 1 sses/Product.php:752
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 284 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
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.3 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_pspc` a
LEFT JOIN `ps_pspc_lang` `b` ON a.`id_pspc` = b.`id_pspc` AND b.`id_lang` = 2
WHERE (a.`id_pspc` = 13) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 376 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "attributes" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "displaypricedeal" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 112
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.3 1 sses/Product.php:5637
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 112
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.3 1 sses/Product.php:5637
SELECT SQL_NO_CACHE ym.id_fs_media,
yml.title,
yml.link_rewrite,
ym.type,
ym.extension,
ym.orientation
FROM
ps_fs_media AS ym
INNER JOIN
ps_fs_media_lang AS yml ON ((ym.id_fs_media = yml.id_fs_media) AND (yml.id_lang = "2"))
WHERE
yml.id_fs_media = 1968
0.3 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 299) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.3 1 sses/Image.php:471
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 sses/shop/Shop.php:1067
SELECT SQL_NO_CACHE pa.`id_product_attribute`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5100
AND product_attribute_shop.default_on = 1 LIMIT 1
0.3 3 /modules/psproductcountdownpro/psproductcountdownpro.php:2672
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 10 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
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_product = 5100
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 sses/Product.php:1278
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 4 sses/Language.php:777
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 13) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.3 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "attributes" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "displaypricedeal" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 5100) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:648
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4766
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 sses/SpecificPrice.php:196
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5100 LIMIT 1
0.3 1 sses/Pack.php:50
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 12) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5100
0.3 14 sses/Product.php:2619
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 285 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5704) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 395 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 6
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 503
AND `nright` > 576
0.3 252 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 294) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 26666 LIMIT 1
0.3 1 sses/Combination.php:343
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 2
AND id_shop = 1 LIMIT 1
0.3 1 sses/ObjectModel.php:1458
SELECT SQL_NO_CACHE DISTINCT app.`id_pack`
FROM `ps_pm_advancedpack` ap
INNER JOIN `ps_pm_advancedpack_products` app ON app.`id_pack` = ap.`id_pack`
WHERE (ap.`id_shop` IN (1)) AND (app.`id_product`=5100)
0.3 1 /modules/pm_advancedpack/AdvancedPack.php:1092
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_product = 5100
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.3 0 sses/Product.php:1278
SELECT SQL_NO_CACHE pa.id_product_attribute
FROM `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 5100
0.3 3 sses/Product.php:5506
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bvkseodispatcher" LIMIT 1
0.3 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 2) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 9) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_product_download`
FROM `ps_product_download`
WHERE `id_product` = 5100
AND `active` = 1
ORDER BY `id_product_download` DESC LIMIT 1
0.3 0 sses/ProductDownload.php:183
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` = 284 LIMIT 1
0.3 1 sses/Category.php:1054
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 509
AND `nright` > 510
0.3 256 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4481) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:380
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` = 30 LIMIT 1
0.3 1 sses/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 1968) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 3) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 30 LIMIT 1
0.3 1 sses/Category.php:1054
SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 3 AND psgdprl.id_lang =2 LIMIT 1
0.3 2 /modules/psgdpr/classes/GDPRConsent.php:94
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` = 451 LIMIT 1
0.3 1 sses/Category.php:1054
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 10) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang` WHERE `iso_code` = 'de' LIMIT 1
0.3 1 sses/Language.php:680
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "autolanguagecurrency" LIMIT 1
0.3 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 564
AND `nright` > 575
0.3 283 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE id_fs_object, slug FROM ps_fs_object WHERE 1 AND active = 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:318
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 59
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.3 1 sses/Product.php:5637
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 2 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `active`
FROM `ps_pspc_shop`
WHERE `id_pspc` = 13
AND `id_shop` = 1 LIMIT 1
0.3 1 /modules/psproductcountdownpro/classes/PSPC.php:89
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='387ace8f715dc2143fd493547dcc19fd' AND cache_id="fsreinsurance|displayRightColumnProduct|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.3 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE weight FROM ps_product_attribute WHERE id_product_attribute=12623 LIMIT 1
0.3 1 a/classes/Product.php:201
SELECT SQL_NO_CACHE ac.id_faq
FROM ps_faq_association_category ac
WHERE ac.id_category IN( 30,227,231,283,284,285,294,296,297,298,299,376,393,395)
0.3 1 /modules/faqs/classes/faqsPost.php:552
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5704 AND `id_group` = 1 LIMIT 1
0.3 0 sses/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_update) as last_update, filepath FROM `ps_smarty_lazy_cache`
WHERE `template_hash`='d6c669a577f59039a903c418d8687c5b' AND cache_id="displayFooterProduct2024-12-04 21|1|1|1|2|1|8|1" AND compile_id="" LIMIT 1
0.3 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 4 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 66 LIMIT 1
0.3 2 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE ac.id_faq
FROM ps_faq_association_product ac
WHERE ac.id_product = 5100
0.3 2 /modules/faqs/classes/faqsPost.php:565
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 5704
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 sses/SpecificPrice.php:196
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2024-12-04 00:00:00' AND '2024-12-04 23:59:59' LIMIT 1
0.3 1 sses/SpecificPrice.php:302
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 376) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 393) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE app.`id_pack`
FROM `ps_pm_advancedpack` app
0.3 34 /modules/pm_advancedpack/AdvancedPack.php:1069
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 507
AND `nright` > 508
0.3 255 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 59
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.3 1 sses/Product.php:5637
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 2) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.3 2 sses/Currency.php:470
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5100 AND ctg.`id_group` = 1 LIMIT 1
0.3 14 sses/Product.php:4921
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` = 283 LIMIT 1
0.3 1 sses/Category.php:1054
SELECT SQL_NO_CACHE psgdprl.message FROM `ps_psgdpr_consent` psgdpr
LEFT JOIN ps_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 66 AND psgdprl.id_lang =2 LIMIT 1
0.3 2 /modules/psgdpr/classes/GDPRConsent.php:94
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4983) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4481 AND id_shop=1 LIMIT 1
0.3 1 sses/Product.php:5037
SELECT SQL_NO_CACHE psgdpr.active FROM `ps_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 3 LIMIT 1
0.3 2 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 5100 LIMIT 1
0.3 1 sses/Pack.php:251
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 294 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sturls" LIMIT 1
0.3 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 543
AND `nright` > 550
0.3 273 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.3 1 sses/module/Module.php:2141
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 1) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'cart_default' LIMIT 1
0.3 1 sses/Image.php:471
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=5100
0.3 1 sses/Tag.php:205
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 298) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 4983
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.3 1 sses/SpecificPrice.php:196
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 7) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 30
AND id_shop = 1 LIMIT 1
0.3 1 sses/ObjectModel.php:1458
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 296 AND `id_shop` = 1
0.3 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4983 AND `id_group` = 1 LIMIT 1
0.3 0 sses/GroupReduction.php:149
SELECT SQL_NO_CACHE UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='template' LIMIT 1
0.3 1 sses/SmartyCustom.php:142
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 543
AND `nright` > 550
0.3 273 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM ps_tag t
LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=5100
0.3 1 sses/Tag.php:205
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4983 AND id_shop=1 LIMIT 1
0.3 1 sses/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 227) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5100) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'medium_default' LIMIT 1
0.3 1 sses/Image.php:471
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 4) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE weight FROM ps_product_attribute WHERE id_product_attribute=11197 LIMIT 1
0.3 1 a/classes/Product.php:201
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 6) LIMIT 1
0.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 5100
AND id_shop = 1 LIMIT 1
0.3 1 sses/ObjectModel.php:1458
SELECT SQL_NO_CACHE * FROM `ps_image_type`
0.3 14 sses/ImageType.php:143
SELECT SQL_NO_CACHE id_fs_object, slug FROM ps_fs_object WHERE 1 AND active = 1
0.3 13 /modules/fscontentmanagement/classes/FSObject.php:318
SELECT SQL_NO_CACHE weight FROM ps_product_attribute WHERE id_product_attribute=26666 LIMIT 1
0.2 1 a/classes/Product.php:201
SELECT SQL_NO_CACHE nleft, nright, level_depth
FROM ps_category
WHERE id_category = 2 LIMIT 1
0.2 1 sses/Category.php:1477
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 13 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 6 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 548
AND `nright` > 549
0.2 276 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 299 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `price_display_method`
FROM `ps_group`
WHERE `id_group` = 3 LIMIT 1
0.2 1 sses/Group.php:144
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "superuser" LIMIT 1
0.2 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE pspc.`id_pspc`
FROM `ps_pspc` pspc
LEFT JOIN `ps_pspc_shop` pspcs
ON pspc.`id_pspc` = pspcs.`id_pspc`
WHERE pspcs.`active` = 1 AND `personal` = 0
AND pspcs.`id_shop` = 1
AND `hours_restart` > 0 AND `to` <= UTC_TIMESTAMP()
0.2 9 /modules/psproductcountdownpro/psproductcountdownpro.php:2967
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "configb2b" LIMIT 1
0.2 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 544
AND `nright` > 545
0.2 274 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 297 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 393 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4766 AND `id_group` = 1 LIMIT 1
0.2 0 sses/GroupReduction.php:149
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2846 AND id_shop=1 LIMIT 1
0.2 1 sses/Product.php:5037
SELECT SQL_NO_CACHE *
FROM `ps_fs_media` a
LEFT JOIN `ps_fs_media_lang` `b` ON a.`id_fs_media` = b.`id_fs_media` AND b.`id_lang` = 2
WHERE (a.`id_fs_media` = 443) LIMIT 1
0.2 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 8) LIMIT 1
0.2 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5704) AND (id_product_attribute = 12623) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`url_name` as `group`
FROM `ps_layered_indexable_attribute_group_lang_value` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 2
AND g.`url_name` IS NOT NULL AND g.`url_name` != ''
0.2 1 sses/Product.php:5637
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 546
AND `nright` > 547
0.2 275 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_lang`
WHERE `id_fs_object` = 7 AND `id_shop` = 1
0.2 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.2 1 sses/Image.php:471
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4983) AND (id_product_attribute = 11197) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "attributes" LIMIT 1
0.2 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE `name`
FROM `ps_manufacturer`
WHERE `id_manufacturer` = 128
AND `active` = 1 LIMIT 1
0.2 1 sses/Manufacturer.php:246
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 509
AND `nright` > 510
0.2 256 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `active`
FROM `ps_pspc_shop`
WHERE `id_pspc` = 13
AND `id_shop` = 1 LIMIT 1
0.2 1 /modules/psproductcountdownpro/classes/PSPC.php:89
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 516
AND `nright` > 537
0.2 259 /modules/psproductcountdownpro/psproductcountdownpro.php:3888