Vanille Pompona Cupide Maison Fuel

E-liquid
Aroma vaniglia

5,90 €

In magazzino - Spedito entro 24 ore

10 prodotti

Tipo di prodotto :
E-liquid
Tipo di sapore :
Dessert
Origine :
Francia
pg/vg :
50/50
Livelli di nicotina :
3 mg/ml, 9 mg/ml, 12 mg/ml, 6 mg/ml, 0 mg/ml
Capacità della bottiglia :
10 ml
Spedizione oggi
Spedizione oggi

se ordinato prima delle 12:00

E-liquid Maison Fuel : Tutto quello che c'è da sapere sui prodotti da svapo

Un e-liquid di tipo dessert che offre un gusto di vaniglia.

Gli e-liquidi Vanille Pompona Cupide di Maison Fuel sono prodotti in Francia. Disponibile in rapporto 50/50 con 50 ml di liquido senza nicotina potenziato in aroma.

Prodotto vietato ai minori di 18 anni. Il vaping è una transizione verso una vita senza tabacco e quindi senza dipendenza da nicotina. Non svapare se non fumi.

Pericoloso. Osservare le precauzioni d'uso. I liquidi possono provocare una reazione allergica. Vedere in dettaglio i componenti e i pericoli (H/EUH) degli e-liquid e delle sigarette elettroniche.. Gli utenti sono informati dei termini e delle condizioni per la restituzione gratuita dei rifiuti di apparecchiature elettriche ed elettroniche nelle nostre Condizioni generali di vendita..

Perché scegliere l'e-liquid Vanille Pompona Cupide Maison Fuel ?

I liquidi Cupide con aroma fruttato di Maison Fuel sono composti in 50PG/50VG.

Cupide offre 37 sapori alla francese.

cupide maison fuel  (1)

Caratteristiche : Vanille Pompona Cupide Maison Fuel

Tipo di prodottoE-liquid
Tipo di saporeDessert
OrigineFrancia
pg/vg50/50
Livelli di nicotina3 mg/ml
Livelli di nicotina9 mg/ml
Livelli di nicotina12 mg/ml
Livelli di nicotina6 mg/ml
Livelli di nicotina0 mg/ml
Capacità della bottiglia10 ml

Maison Fuel, e-liquid di qualità

Gli e-liquid Maison Fuel sono disponibili in una gamma di gusti che si adattano a tutte le preferenze del vaping.

Questo marchio francese si impegna a offrire gusti per tutti i tipi di consumatori.

Aggiunto al carrello!
Quantità
Continua gli acquisti
Load Time1551 ms - OK... for a shared hosting
Querying Time706 ms
Queries730
Memory Peak Usage24.3 Mb
Included Files628 files - 9.79 Mb
PrestaShop Cache- Mb
Global vars1.87 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 162 ms 162 ms 5.60 Mb 5.60 Mb
__construct 0 ms 162 ms - Mb 5.60 Mb
init 91 ms 254 ms 2.02 Mb 7.89 Mb
checkAccess 0 ms 254 ms - Mb 7.89 Mb
setMedia 6 ms 260 ms 0.03 Mb 7.89 Mb
postProcess 0 ms 260 ms - Mb 7.89 Mb
initHeader 0 ms 260 ms - Mb 7.89 Mb
initContent 307 ms 567 ms 4.36 Mb 12.39 Mb
initFooter 35 ms 602 ms 0.04 Mb 12.39 Mb
display 949 ms 1551 ms 11.95 Mb 24.30 Mb
Hook Time Memory Usage
hookdisplayFooter1 227 ms 8.00 Mb
__construct 92 ms 4.00 Mb
hookdisplayProductPriceBlock 64 ms 2.00 Mb
hookmoduleRoutes 29 ms - Mb
hookdisplayHeaderInfo 21 ms - Mb
hookdisplayHeader 21 ms - Mb
hookdisplayGDPRConsent 20 ms - Mb
hookdisplayModal 19 ms - Mb
hookfooter 18 ms - Mb
hookactionProductOutOfStock 18 ms - Mb
hookdisplayRightTop 16 ms 2.00 Mb
hookHeader 14 ms - Mb
hookdisplayTop 13 ms - Mb
hookdisplayNav 11 ms - Mb
hookdisplayLeftTop 8 ms - Mb
hookdisplayFooter 8 ms - Mb
hookactionDispatcher 7 ms - Mb
hookdisplayProductActions 5 ms - Mb
hookproductfooter 4 ms - Mb
hookdisplayFooterRight 3 ms - Mb
hookdisplayProductTabContent 3 ms - Mb
hookdisplayFooterProduct 3 ms - Mb
hookdisplaySummaryBuyBlock 2 ms - Mb
hookdisplayFooterLeft 2 ms - Mb
hookdisplayBanner 2 ms - Mb
hookdisplayProductTab 1 ms - Mb
hookdisplayLeftColumn 1 ms - Mb
hookdisplayRightColumnProduct 1 ms - Mb
hookdisplayReassurance 1 ms - Mb
hookdisplayProductButtons 1 ms - Mb
hookdisplayLeftColumnProduct 1 ms - Mb
hookdisplayHeaderMobile 1 ms - Mb
hookdisplayProductListReviews 0 ms - Mb
hookproducttabcontent 0 ms - Mb
hookdisplayBeforeHProduct 0 ms - Mb
hookactionFrontControllerSetMedia 0 ms - Mb
hookdisplayProductListFunctionalButtons 0 ms - Mb
hookextraright 0 ms - Mb
hookDisplayOverrideTemplate 0 ms - Mb
hooktop 0 ms - Mb
hookproducttab - ms - Mb
41 hooks 637 ms 16.00 Mb
Module Time Memory Usage
fsmenus 263 ms 10.00 Mb
psproductcountdownpro 78 ms 2.00 Mb
fscontentmanagement 53 ms 2.00 Mb
blocknewsletter 28 ms - Mb
g_megamenu 25 ms 2.00 Mb
psgdpr 20 ms - Mb
mailalerts 18 ms - Mb
fslogin 16 ms - Mb
pm_advancedcookiebanner 11 ms - Mb
trustedshopsintegration 10 ms - Mb
doofinder 9 ms 2.00 Mb
pm_advancedpack 9 ms - Mb
pagecache 8 ms - Mb
faqs 8 ms - Mb
fsblockcms 7 ms - Mb
ukoosummary 6 ms - Mb
opartlimitquantity 5 ms - Mb
blocklanguages 5 ms - Mb
blockcart 4 ms - Mb
tradedoubler_affiliate_tracker 4 ms - Mb
systempay 3 ms - Mb
netreviews 3 ms - Mb
colissimo 3 ms - Mb
jprestawebp 3 ms - Mb
fsreinsurance 3 ms - Mb
dhldp 3 ms - Mb
ukoobillboard 3 ms - Mb
favoriteproducts 2 ms - Mb
blocksearch 2 ms - Mb
fsorderedproducts 2 ms - Mb
blockcartNova 2 ms - Mb
favoriteproductsNova 2 ms - Mb
blocksocial 1 ms - Mb
mailalertsNova 1 ms - Mb
loyalty 1 ms - Mb
ganalytics 1 ms 2.00 Mb
blocklayeredNova 1 ms - Mb
psgdprNova 1 ms - Mb
fsfeaturesextend 1 ms - Mb
fsmodals 1 ms - Mb
ukooresponslide 1 ms - Mb
blocksearchNova 1 ms - Mb
editorial 1 ms - Mb
sekeywordsNova 1 ms - Mb
fscities 1 ms - Mb
pagesnotfound 1 ms - Mb
fsjsonld 1 ms - Mb
blocksocialNova 1 ms - Mb
qcdshippingperproduct 1 ms - Mb
tradedoubler 0 ms - Mb
fsadvancedsearch 0 ms - Mb
fsblockproducts 0 ms - Mb
blocklayered 0 ms - Mb
sekeywords - ms - Mb
54 modules 637 ms 16.00 Mb

Stopwatch SQL - 730 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` = 4 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` = 4)
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` = 130
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
296.6 129780 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
24 6793 sses/SpecificPrice.php:230
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
7.2 1551 sses/Configuration.php:148
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 14
AND `nright` > 15
6.6 8 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `ps_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `ps_hook_alias` ha
INNER JOIN `ps_hook` h ON ha.name = h.name
5.5 0 sses/Hook.php:131
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, hm.`id_hook_behavior`, m.`name` as module, h.`live_edit`
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module`
INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module`
INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 1) AND (mg.`id_shop` = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.7 182 Yes Yes a/classes/Hook.php:109
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, hm.id_hook_behavior, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
4.7 532 a/classes/Hook.php:410
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `ps_country` c  INNER JOIN ps_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 4)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
4 244 Yes sses/Country.php:130
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
2.8 647 sses/SpecificPrice.php:238
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
2.6 647 sses/SpecificPrice.php:230
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` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 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` = 4)
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` = 4790 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.4 4 Yes sses/Product.php:3602
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` = 4)
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_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` = 4 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 4 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` = 4)
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` = 4790 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.9 1 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:139
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` = 4790) AND (b.`id_shop` = 1) LIMIT 1
1.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.8 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 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.7 2 Yes sses/SpecificPrice.php:362
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` = 4790
AND al.`id_lang` = 4
AND agl.`id_lang` = 4
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.7 5 Yes Yes sses/Product.php:3517
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
1.7 1 sses/shop/Shop.php:1067
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=4
1.6 1241 a/classes/Product.php:216
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 1) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 66) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 19268) 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.6 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=4
1.6 1241 a/classes/Product.php:216
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('5a8b33fb9c66397d445d151eee7305f9',"fsmenus|displayLeftTop|1|1|1|4|1|8|1|product|4790","", FROM_UNIXTIME(1733350408))
1.6 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 28) AND (b.`id_shop` = 1) LIMIT 1
1.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 13 AND `id_shop` = 1
1.6 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
1.6 325 Yes sses/Country.php:137
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 9) AND (b.`id_shop` = 1) LIMIT 1
1.6 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.5 95 a/classes/module/Module.php:82
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` = 4790 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` = 4 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 4 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` = 4)
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` = 4790 AND ua.`id_group` = 1 ORDER BY ua.`position` ASC
LIMIT 0,10
1.5 1 Yes /modules/ukoosummary/classes/UkooSummarySummary.php:212
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.5 2 Yes sses/SpecificPrice.php:419
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.5 108 Yes sses/Dispatcher.php:452
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, 10941) 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.5 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.5 95 a/classes/module/Module.php:82
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` = 4  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 282
AND `active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.4 1 Yes Yes sses/Category.php:656
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` = 4219) AND (b.`id_shop` = 1) LIMIT 1
1.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 4) AND (b.`id_shop` = 1) LIMIT 1
1.4 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 (13,135,280,282,310,414,517,1,2,1,2,13,133,1,2,13,1,2,13,1,2,13,138,1,2,13,1,2,13,138,310)
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
1.3 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.3 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 7) AND (b.`id_shop` = 1) LIMIT 1
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, 10031) 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 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 <= 266
AND c.nright >= 267
AND c.nleft >= 2
AND c.nright <= 671
AND cl.id_lang = 4
AND c.active = 1
AND c.level_depth > 1
ORDER BY c.level_depth ASC
1.3 129 Yes sses/Tools.php:1308
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, 9871) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.3 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 6509) 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 *
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` = 4170) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 9) AND (b.`id_shop` = 1) LIMIT 1
1.3 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column
FROM ps_theme t
LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme)
LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta)
WHERE t.id_theme =1 AND m.page = "product" LIMIT 1
1.2 1 sses/Theme.php:275
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, 5247) 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_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
1.2 1 sses/Country.php:173
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` = 4)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
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` = 4790
AND a.`id_attribute` NOT IN(112, 111, 961, 960)
1.2 5 sses/Product.php:5665
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, 10942) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.2 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 2218) 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 *, ( 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, 10991) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1.1 2 Yes sses/SpecificPrice.php:362
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('29229ea482358ac182b62d6e88b341e7',"fsmenus|displayFooter1|1|1|1|4|1|8|1|product|4790","", FROM_UNIXTIME(1733350408))
1.1 1 sses/SmartyCustom.php:263
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayHeaderInfo/1/1/1/4/1/8/1/product/4790/e7/13/6b/e7136b37ec3d626cb3911235c0b213e7624eac24.menublock-displayheaderinfo.tpl.php'
WHERE `template_hash`='b8c5bef7265340ce2f6e5204863da515' AND cache_id="fsmenus|displayHeaderInfo|1|1|1|4|1|8|1|product|4790" AND compile_id=""
1.1 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 10122) 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=1564
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=78
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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` = 4790
AND product_attribute_shop.default_on = 1 LIMIT 1
1.1 5 /modules/psproductcountdownpro/psproductcountdownpro.php:2672
SELECT SQL_NO_CACHE id_fs_media_category FROM ps_fs_media_category_media WHERE id_fs_media=1969
1.1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
SELECT SQL_NO_CACHE 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 (13,135,280,282,310,414,517,1,2,1,2,13,133,1,2,13,1,2,13,1,2,13,138,1,2,13,1,2,13,138,310)
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
1.1 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
1.1 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 331) AND (b.`id_shop` = 1) LIMIT 1
1.1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 280 AND `id_shop` = 1
1 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE name, id_category FROM ps_category_lang WHERE id_lang=4
1 1241 a/classes/Product.php:216
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=9
1 1491 /modules/fscontentmanagement/classes/FSMediaFile.php:93
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 = 4
AND pl.id_product = 4790
AND product_shop.active = 1 LIMIT 1
1 1 sses/Meta.php:259
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, 10939) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 7) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 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` = 4)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 4)
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` = 4790
AND a.`id_attribute` NOT IN(112, 111, 961, 960)
1 5 sses/Product.php:5665
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, 19267) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1 2 Yes sses/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 134) AND (b.`id_shop` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 137) AND (b.`id_shop` = 1) LIMIT 1
1 1 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 *
FROM `ps_theme` a
WHERE (a.`id_theme` = 1) LIMIT 1
1 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 4790) WHERE gl.`id_lang` = 4
GROUP BY g.`id_ukoosummary_group` ORDER BY g.`position` ASC
1 1 Yes Yes /modules/ukoosummary/classes/UkooSummaryGroup.php:170
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 11) AND (b.`id_shop` = 1) LIMIT 1
1 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 *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 135 AND `id_shop` = 1
0.9 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` = "category"
AND pspco.`id_object` IN (13,135,280,282,310,414,517,1,2,1,2,13,133,1,2,13,1,2,13,1,2,13,138,1,2,13,1,2,13,138,310)
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
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayLeftTop/1/1/1/4/1/8/1/product/4790/06/0b/ac/060bac65e4bad467f3a4ec595f7ac9a32893a8c7.menublock-displaylefttop.tpl.php'
WHERE `template_hash`='5a8b33fb9c66397d445d151eee7305f9' AND cache_id="fsmenus|displayLeftTop|1|1|1|4|1|8|1|product|4790" AND compile_id=""
0.9 1 sses/SmartyCustom.php:183
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 m.`id_module`, m.`name`, (
SELECT id_module
FROM `ps_module_shop` ms
WHERE m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
LIMIT 1
) as mshop
FROM `ps_module` m
0.9 95 a/classes/module/Module.php:82
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 136) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 138) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 4139
ORDER BY f.position ASC
0.9 11 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 45) AND (b.`id_shop` = 1) LIMIT 1
0.9 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.9 1 sses/tax/TaxRulesTaxManager.php:108
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 424) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 4790) WHERE gl.`id_lang` = 4
GROUP BY g.`id_ukoosummary_group` ORDER BY g.`position` ASC
0.9 1 Yes Yes /modules/ukoosummary/classes/UkooSummaryGroup.php:170
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayFooter1/1/1/1/4/1/8/1/product/4790/e5/bd/20/e5bd20563a338e14b34e5100aa7918fc88c39559.menublock-displayfooter1.tpl.php'
WHERE `template_hash`='29229ea482358ac182b62d6e88b341e7' AND cache_id="fsmenus|displayFooter1|1|1|1|4|1|8|1|product|4790" AND compile_id=""
0.9 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 4
WHERE (a.`id_fs_menu_item` = 214) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
0.9 4 a/Adapter/Adapter_EntityMapper.php:70
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 = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 4170
ORDER BY f.position ASC
0.9 10 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.9 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "configb2b" LIMIT 1
0.9 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 266
AND `nright` > 267
0.8 134 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.8 1 sses/Country.php:173
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=5 ORDER BY mi.id_parent,mi.position
0.8 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 2) AND (b.`id_shop` = 1) LIMIT 1
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 (13,135,280,282,310,414,517,1,2,1,2,13,133,1,2,13,1,2,13,1,2,13,138,1,2,13,1,2,13,138,310)
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 *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 63) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 4) 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.8 31 /modules/fscontentmanagement/classes/FSObjectBase.php:473
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` = 4
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.8 18 Yes Yes sses/Category.php:859
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` = 2127) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 135) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 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.8 0 sses/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2645) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4790) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 580) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 2127
ORDER BY f.position ASC
0.8 6 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.8 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=7 ORDER BY mi.id_parent,mi.position
0.8 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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 (130)
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 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 = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 4403
ORDER BY f.position ASC
0.8 12 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4790
0.8 7 sses/Product.php:2619
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` = 4)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 4790
0.8 5 sses/Product.php:5624
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.7 9 /modules/psproductcountdownpro/psproductcountdownpro.php:2947
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 = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 2645
ORDER BY f.position ASC
0.7 4 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4139) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4790) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 300) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
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` = 4403) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE name, value, pf.id_feature, pf.id_feature_value
FROM ps_feature_product pf
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 4790
ORDER BY f.position ASC
0.7 10 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "displaypricedeal" LIMIT 1
0.7 13 /modules/fscontentmanagement/classes/FSObject.php:284
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 = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 4219
ORDER BY f.position ASC
0.7 8 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 108
AND `nright` > 109
0.7 56 /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 = 4)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 4)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 4)
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 = 580
ORDER BY f.position ASC
0.7 4 Yes a/tmp/4d9d8b4bc6583f0f604f2172e4c1c3ce3cb1cfcf.php:23
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "autolanguagecurrency" LIMIT 1
0.7 1 sses/module/Module.php:2568
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` = 4)
WHERE la.`url_name` IS NOT NULL AND la.`url_name` != ''
AND pa.`id_product` = 4790
0.7 5 sses/Product.php:5624
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|4|1|8|1|product|4790" AND compile_id="" LIMIT 1
0.7 1 sses/SmartyCustom.php:215
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 4
WHERE (a.`id_fs_menu_item` = 212) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 11) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 4
WHERE (a.`id_fs_menu_item` = 213) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 4790) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = 10991 LIMIT 1
0.7 1 sses/Combination.php:343
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.7 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.7 13 /modules/fscontentmanagement/classes/FSObject.php:345
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` = 4790
AND l.`active` = 1
0.7 16 sses/Product.php:5017
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` = 6509 LIMIT 1
0.7 1 sses/Combination.php:343
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 (13,135,280,282,310,414,517,1,2,1,2,13,133,1,2,13,1,2,13,1,2,13,138,1,2,13,1,2,13,138,310)
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.7 9 Yes /modules/psproductcountdownpro/classes/PSPC.php:435
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 249) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('64057145ca61a41f3fcc884f4f62c395',"fsmenus|displayRightTop|1|1|1|4|1|8|1|product|4790","", FROM_UNIXTIME(1733350408))
0.7 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.7 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` = "product"
AND pspco.`id_object` IN (4790)
AND pspco.`id_product_attribute` IN (0, 10939)
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.7 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` = "manufacturer"
AND pspco.`id_object` IN (130)
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 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 (130)
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 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 (4790)
AND pspco.`id_product_attribute` IN (0, 10941)
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 *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 4
WHERE (a.`id_fs_menu_item` = 211) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.6 13 /modules/fscontentmanagement/classes/FSObject.php:345
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` = 4) 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 cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 282 LIMIT 1
0.6 0 sses/Category.php:1054
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 281) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 282) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
UPDATE `ps_smarty_lazy_cache`
SET filepath='fsmenus/displayRightTop/1/1/1/4/1/8/1/product/4790/62/3d/11/623d119985e9a1c710dee232646e46b2bc295f35.menublock-displayrighttop.tpl.php'
WHERE `template_hash`='64057145ca61a41f3fcc884f4f62c395' AND cache_id="fsmenus|displayRightTop|1|1|1|4|1|8|1|product|4790" AND compile_id=""
0.6 1 sses/SmartyCustom.php:183
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2127
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.6 1 sses/SpecificPrice.php:196
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` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.6 13 /modules/fscontentmanagement/classes/FSObject.php:284
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 = 2127 LIMIT 1
0.6 5 sses/Product.php:752
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 = "4"))
WHERE
yml.id_fs_media = 1564
0.6 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
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` = 4)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 23:13:28"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 23:13:28")
OR (b.`date_start` = "0000-00-00 00:00:00"
AND b.`date_end` = "0000-00-00 00:00:00"))
AND b.`display_page` = "all" OR b.`display_page` = "product"
OR b.`display_page` = "category" AND b.`display_mod` = "display_popup" ORDER BY b.`position` ASC
0.6 1 Yes /modules/ukoobillboard/classes/UkooBillboardBillboard.php:188
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` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = "manufacturer"
AND pspco.`id_object` IN (130)
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 *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = "product"
AND pspco.`id_object` IN (4790)
AND pspco.`id_product_attribute` IN (0, 19267)
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
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('b8c5bef7265340ce2f6e5204863da515',"fsmenus|displayHeaderInfo|1|1|1|4|1|8|1|product|4790","", FROM_UNIXTIME(1733350408))
0.6 1 sses/SmartyCustom.php:263
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 257) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM ps_shop_group gs
LEFT JOIN ps_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN ps_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.6 1 Yes sses/shop/Shop.php:663
SELECT SQL_NO_CACHE 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 (4790)
AND pspco.`id_product_attribute` IN (0, 19268)
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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 329) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 4) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM ps_shop_url su
LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.e-garette.fr' OR su.domain_ssl = 'www.e-garette.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.6 1 Yes sses/shop/Shop.php:334
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.6 1 sses/Country.php:173
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 266
AND `nright` > 267
0.6 134 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 101
AND `nright` > 112
0.6 52 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 4 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.6 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4139)
0.6 5 sses/Product.php:3002
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` = 4790
0.6 5 sses/Product.php:5506
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 4 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.6 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
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` = 280) LIMIT 1
0.6 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 = "4"))
WHERE
yml.id_fs_media = 10
0.6 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 4 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.6 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
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 = 4790
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-04 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.6 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` = 2127)
0.5 5 sses/Product.php:3002
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'large_default' LIMIT 1
0.5 1 sses/Image.php:471
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` = 4)
WHERE i.`id_product` = 4790
ORDER BY `position`
0.5 1 Yes sses/Product.php:2725
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.5 1 sses/shop/Shop.php:202
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:345
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` = 4170)
0.5 5 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.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` = 580)
0.5 5 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 6) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 4 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.5 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
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` = 517) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.5 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 = "4"))
WHERE
yml.id_fs_media = 1452
0.5 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
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` = 4) 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.5 2 Yes /modules/fscontentmanagement/classes/FSObjectBase.php:473
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_stores` a
LEFT JOIN `ps_fs_object_stores_lang` `b` ON a.`id_fs_object_stores` = b.`id_fs_object_stores` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_stores_shop` `c` ON a.`id_fs_object_stores` = c.`id_fs_object_stores` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_stores` = 8) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 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.5 1 Yes /modules/g_megamenu/classes/gmegamenusModel.php:94
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 = 4790
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 *
FROM `ps_trustedshopsintegration`
WHERE (id_shop = 1 AND id_lang = 4 AND uuid = "d2eb6cea3f8768d46174921f02d52e70") LIMIT 1
0.5 2 /modules/trustedshopsintegration/trustedshopsintegration.php:646
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `name` ASC
0.5 2 Yes sses/Currency.php:231
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 227) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2127 AND `id_group` = 1 LIMIT 1
0.5 0 sses/GroupReduction.php:149
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 344) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
WHERE (a.`id_fs_object` = 11) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_landing` a
LEFT JOIN `ps_fs_object_landing_lang` `b` ON a.`id_fs_object_landing` = b.`id_fs_object_landing` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_landing_shop` `c` ON a.`id_fs_object_landing` = c.`id_fs_object_landing` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_landing` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
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` = 4
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 COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.5 2 sses/Currency.php:470
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT 1
0.5 1 sses/module/Module.php:2568
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2645) AND (id_product_attribute = 6509) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.5 1 sses/stock/StockAvailable.php:380
SELECT SQL_NO_CACHE quantity,batch_type FROM ps_opartlimitquantity_product_batch WHERE id_product = 4790 LIMIT 1
0.5 1 /modules/opartlimitquantity/opartlimitquantity.php:768
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 101
AND `nright` > 112
0.5 52 /modules/psproductcountdownpro/psproductcountdownpro.php:3888
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 = "4"))
WHERE
yml.id_fs_media = 9
0.5 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
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` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 65) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE 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|4|1|8|1" AND compile_id="" LIMIT 1
0.5 1 sses/SmartyCustom.php:215
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` = 4
LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 130) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:345
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "my-account"
OR m.page = "myaccount"
)
AND ml.id_lang = 4
AND ml.id_shop = 1 LIMIT 1
0.5 2 sses/Meta.php:149
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.5 0 sses/Supplier.php:192
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 388) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=8 ORDER BY mi.id_parent,mi.position
0.5 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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 = "4"))
WHERE
yml.id_fs_media = 1969
0.5 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
SELECT SQL_NO_CACHE *
FROM `ps_fs_object_guides` a
LEFT JOIN `ps_fs_object_guides_lang` `b` ON a.`id_fs_object_guides` = b.`id_fs_object_guides` AND b.`id_lang` = 4
LEFT JOIN `ps_fs_object_guides_shop` `c` ON a.`id_fs_object_guides` = c.`id_fs_object_guides` AND c.`id_shop` = 1
WHERE (a.`id_fs_object_guides` = 10) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
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.5 4 sses/Language.php:777
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` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE g.`id_attribute_group`, g.`name` as `group`
FROM `ps_attribute_group_lang` g
LEFT JOIN `ps_attribute` a
ON (a.`id_attribute_group` = g.`id_attribute_group`)
WHERE a.`id_attribute` = 111
AND g.`id_lang` = 4
AND g.`name` IS NOT NULL
0.5 1 sses/Product.php:5646
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`=4790
0.5 1 sses/Tag.php:205
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=4 ORDER BY mi.id_parent,mi.position
0.5 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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` = 4
WHERE (a.`id_fs_media` = 10) 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` = 4219)
0.5 1 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 282 AND `id_shop` = 1
0.5 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` = 2645)
0.5 3 sses/Product.php:3002
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` = 4
WHERE (a.`id_fs_media` = 1969) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 292) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 4
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "stores" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'home_default' LIMIT 1
0.5 1 sses/Image.php:471
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` = 4
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` = 4403)
0.5 5 sses/Product.php:3002
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 289) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE product_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 = 4403 LIMIT 1
0.5 5 sses/Product.php:765
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` = 4790)
0.5 5 sses/Product.php:3002
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "popup" LIMIT 1
0.5 13 /modules/fscontentmanagement/classes/FSObject.php:284
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 = "4"))
WHERE
yml.id_fs_media = 78
0.5 1 /modules/fscontentmanagement/classes/FSMediaFile.php:323
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` = 4
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.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=6 ORDER BY mi.id_parent,mi.position
0.4 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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` = 4
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 1) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
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` = 4
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.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 4
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 *
FROM `ps_category_lang`
WHERE `id_category` = 517 AND `id_shop` = 1
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
SELECT SQL_NO_CACHE id_fs_object FROM ps_fs_object WHERE slug = "guides" LIMIT 1
0.4 13 /modules/fscontentmanagement/classes/FSObject.php:284
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=1 ORDER BY mi.id_parent,mi.position
0.4 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
SELECT SQL_NO_CACHE 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 (10939, 10941, 10942, 19267, 19268) AND il.`id_lang` = 4 ORDER by i.`position`
0.4 5 Yes sses/Product.php:2189
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` = 4
WHERE (a.`id_fs_media` = 9) 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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 294) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_fs_object` a
LEFT JOIN `ps_fs_object_lang` `b` ON a.`id_fs_object` = b.`id_fs_object` AND b.`id_lang` = 4
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.4 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` = "manufacturer"
AND pspco.`id_object` IN (130)
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 *
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` = 4
WHERE (a.`id_fs_media` = 1564) LIMIT 1
0.4 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` = 13) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 282) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=10 ORDER BY mi.id_parent,mi.position
0.4 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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` = 4
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.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 24) AND (b.`id_shop` = 1) LIMIT 1
0.4 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` = 4) 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.4 2 /modules/fscontentmanagement/classes/FSObjectBase.php:473
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` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 113) AND (b.`id_shop` = 1) LIMIT 1
0.4 0 a/Adapter/Adapter_EntityMapper.php:61
INSERT IGNORE INTO `ps_smarty_lazy_cache`
(`template_hash`, `cache_id`, `compile_id`, `last_update`)
VALUES ('29229ea482358ac182b62d6e88b341e7',"fsmenus|displayFooter1|1|1|1|4|1|8|1|product|4790","", FROM_UNIXTIME(1733350408))
0.4 1 sses/SmartyCustom.php:263
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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 70) AND (b.`id_shop` = 1) LIMIT 1
0.4 0 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 6
0.4 4 a/Adapter/Adapter_EntityMapper.php:70
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` = 4
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 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 *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 4
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 167) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
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 mi.id_fs_menu_item, mi.id_parent FROM ps_fs_menu_item mi WHERE mi.id_fs_menu_block=2 ORDER BY mi.id_parent,mi.position
0.4 215 Yes /modules/fsmenus/src/FSMenuBlock.php:30
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` = 4
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.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE `id_category`
FROM `ps_category`
WHERE `nleft` < 244
AND `nright` > 247
0.4 123 /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` = 4
LEFT JOIN `ps_fs_object_shop` `c` ON a.`id_fs_object` = c.`id_fs_object` AND c.`id_shop` = 1
WHERE (a.`id_fs_object` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 a/Adapter/Adapter_EntityMapper.php:61
SELECT SQL_NO_CACHE weight FROM ps_product_attribute WHERE id_product_attribute=6509 LIMIT 1
0.4 1 a/classes/Product.php:201
SELECT SQL_NO_CACHE *
FROM `ps_fs_menu_item` a
LEFT JOIN `ps_fs_menu_item_lang` `b` ON a.`id_fs_menu_item` = b.`id_fs_menu_item` AND b.`id_lang` = 4
WHERE (a.`id_fs_menu_item` = 494) 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` = 4
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 *
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` = 4
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.4 1 a/Adapter/Adapter_EntityMapper.php:61
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` = 4
AND c.`id_category` IN (282)
0.4 1 sses/Category.php:1599
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` = 4)
WHERE b.`active` = "1"
AND b.`id_shop` = 1
AND (("2024-12-04 23:13:28"
BETWEEN b.`date_start` AND b.`date_end`)
OR (b.`date_end` = "0000-00-00 00:00:00"
AND b.`date_start` <= "2024-12-04 23:13:28")
OR (b.`date_start` = "0000-00-00 00:00:00"
AND b.`date_end` = "0000-00-00 00:00:00"))
AND b.`display_page` = "all" OR b.`display_page` = "product"
OR b.`display_page` = "category" AND b.`display_mod` = "display_header" ORDER BY b.`position` ASC
0.4 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 product_attribute_shop.default_on = 1  AND pa.id_product = 2645 LIMIT 1
0.4 3