0Nákupní košík-0 Kč
Váš nákupní košík je prázdný

Kategorie

Vybrané BIO a přírodní produkty
Newsletter

Přejete si dostávat jednou měsíčně email s novinkami, slevami a jinými zajímavostmi? Stačí jen zde napsat Váš email.

Cibule jarní salátová Globo - Allium cepa - semena - 180 ks

Cibule jarní salátová Globo - Allium cepa - semena - 180 ks

Cibule jarní salátová Globo je velmi výnosnou odrůdou jarní cibule,

Cibule o hmotnosti 750 g a více mají světle hnědou slupku a bílou dužinu s jemně nasládlou chutí. 

Hodí se k přímé konzumaci či tepelné úpravě.

Číst víceShow less
30 Kč
Skladem
Kód zboží:
1000403
Popis

Jak si vypěstovat cibuli?

  • Výsev semen provádíme v průběhu zimních měsíců do skleníku nebo od dubna na venkovní záhon.
  • Hloubka výsevu je 0,5–1 cm.
  • Ideální spon je 25–30 x 10–15 cm.
  • Optimální teplota ke klíčení je 12–18 °C.
  • Doba klíčení je 2–4 týdny, záleží na odrůdě a pěstebních podmínkách.
  • Stanoviště volíme teplé a slunečné, případně polostín.
  • Půda by měla být bohatá na živiny, dobře propustná, písčitohlinitá, humózní, neutrální nebo mírně zásaditá.
  • Hnojení není nutné, doporučujeme pravidelnou zálivku.
  • Doba sklizně nastává v době, kdy je porost z jedné třetiny až poloviny polehlý. 
  • Cibulky sušte ve svazcích a poté uskladněte v chladné a suché místnosti. 
Číst víceShow less
Detaily produktu
1000403

Parametry

Stanoviště
Slunečné
Výsev / výsadba
Duben
Leden
Únor
Barva odrůdy
Bílá
BIO kvalita
Ne
Odrůda
Nehybridní
Sklizeň
Srpen
Září
Ranost odrůdy
Pozdní
Pěstování
Venku
Mrazuvzdornost
Ne
Odrůda cibule
Jarní
Související produkty
8 ostatní produkty ze stejné kategorie:

Ověřeno našimi zákazníky

Prohlédněte si vybraná hodnocení našich zákazníků.

Celkový názor:
Velmi dobrý výběr, kvalita a cena. Rostliny přišly v dobrém stavu a včas.
Pečeť ověřeno zákazníky

Jarmila K. 10.04.2025

5.005.005.005.005.00
Výhody:
Děkuji, i za dárek .
Pečeť ověřeno zákazníky

Radek P. 09.04.2025

5.005.005.005.005.00
Celkový názor:
Vše OK,radost zde nakupovat.
Pečeť ověřeno zákazníky

Ludvík M. 07.04.2025

5.005.005.005.005.00

Menu

Menu

Nejdříve se, prosím, přihlašte

Přihlásit se
Load Time 391.699 ms
Querying Time 232 ms
Queries 989
Memory Peak Usage 36.4 Mb
Included Files 1119 files - 16.20 Mb
PrestaShop Cache - Mb
Global vars 0.20 Mb
PrestaShop Version 8.2.0
PHP Version 8.2.28
MySQL Version 10.11.11-MariaDB-0+deb12u1-log
Memory Limit 512M
Max Execution Time 7200s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 19.864 ms 19.864 ms 7.17 Mb 10.8 Mb
__construct 0.015 ms 19.879 ms - Mb 10.8 Mb
init 22.274 ms 42.153 ms 1.56 Mb 10.8 Mb
checkAccess 0.013 ms 42.166 ms - Mb 10.8 Mb
setMedia 0.931 ms 43.097 ms 0.02 Mb 10.8 Mb
postProcess 0.012 ms 43.109 ms - Mb 10.8 Mb
initHeader 0.003 ms 43.112 ms - Mb 10.8 Mb
initContent 103.248 ms 146.360 ms 4.59 Mb 13.4 Mb
initFooter 0.007 ms 146.367 ms - Mb 13.4 Mb
display 245.332 ms 391.699 ms 22.63 Mb 36.4 Mb
Hook Time Memory Usage
displayFooterProduct 116.926 ms 10.00 Mb
ActionStAssemble 95.253 ms 8.79 Mb
DisplayFooterProduct 64.282 ms 8.02 Mb
DisplayHeader 23.662 ms 0.94 Mb
DisplayBeforeBodyClosingTag 21.747 ms 0.87 Mb
DisplayProductCenterColumn 8.853 ms 0.74 Mb
DisplayFooterAfter 4.475 ms 0.62 Mb
DisplayBreadcrumb 3.979 ms 0.15 Mb
DisplayMobileBarLeft 1.854 ms 0.14 Mb
displayBanner 1.794 ms 0.09 Mb
DisplayProductExtraContent 1.438 ms 0.09 Mb
DisplaySideBar 1.380 ms 0.18 Mb
DisplayModuleCustomContent 1.348 ms 0.10 Mb
displayHeaderCenter 1.101 ms 0.05 Mb
DisplayLeftColumnProduct 0.846 ms 0.20 Mb
displayTop 0.690 ms 0.04 Mb
displayFullWidthTop 0.591 ms 0.04 Mb
displayFullWidthTop2 0.492 ms 0.05 Mb
DisplayWrapperBottom 0.419 ms 0.03 Mb
DisplayFooter 0.391 ms 0.04 Mb
ActionOutputHTMLBefore 0.361 ms - Mb
displayUnderProductName 0.289 ms 0.05 Mb
displayLeftColumnProduct 0.259 ms 0.02 Mb
DisplayMainMenu 0.162 ms 0.01 Mb
DisplayFooterBottomRight 0.149 ms 0.01 Mb
displayMobileNav 0.149 ms - Mb
DisplayMobileNav 0.145 ms 0.07 Mb
DisplayNav2 0.118 ms 0.03 Mb
displayMobileBarBottom 0.113 ms - Mb
DisplayRightBar 0.099 ms 0.01 Mb
DisplayMobileBarCenter 0.087 ms - Mb
ActionFrontControllerSetMedia 0.076 ms - Mb
DisplayMobileBar 0.072 ms - Mb
ModuleRoutes 0.066 ms 0.01 Mb
ActionDispatcherBefore 0.062 ms - Mb
DisplayMobileBarBottom 0.058 ms - Mb
Header 0.045 ms - Mb
displayFullWidthBottom 0.028 ms - Mb
ActionDispatcher 0.026 ms - Mb
DisplayOverrideTemplate 0.023 ms - Mb
OverrideLayoutTemplate 0.006 ms - Mb
DisplayReassurance 0.006 ms - Mb
DisplayProductAdditionalInfo 0.005 ms - Mb
DisplayFullWidthBottom 0.004 ms - Mb
44 hook(s) 353.929 ms 31.38 Mb
Module Time Memory Usage
sturls 0.785 ms 0.03 Mb
stblog 1.877 ms - Mb
stblogarchives 0.663 ms 0.02 Mb
stblogsearch 0.637 ms 0.02 Mb
gmerchantcenter 4.907 ms 0.16 Mb
ets_productmanager 1.266 ms 0.10 Mb
thecheckout 1.408 ms 0.17 Mb
stadvancedcache 0.148 ms 0.01 Mb
stfacetedsearch 4.136 ms 0.07 Mb
ps_emailalerts 0.358 ms 0.01 Mb
dm_heureka 1.264 ms 0.08 Mb
stvideo 1.590 ms 0.09 Mb
stmultilink 1.004 ms 0.08 Mb
stshoppingcart 1.471 ms 0.06 Mb
dm_cashondelivery 6.593 ms 0.08 Mb
stmegamenu 1.191 ms 0.27 Mb
stswiper 1.221 ms 0.10 Mb
stowlcarousel 0.450 ms 0.02 Mb
steasycontent 16.330 ms 1.58 Mb
stfeaturedslider 0.393 ms 0.02 Mb
stnewsletter 0.728 ms 0.13 Mb
stfeaturedcategories 0.296 ms 0.02 Mb
sthomenew 0.324 ms 0.02 Mb
stblogeditor 0.296 ms 0.03 Mb
stblogfeaturedarticles 0.284 ms 0.03 Mb
stbanner 1.011 ms 0.07 Mb
stspecialslider 0.331 ms 0.02 Mb
stthemeeditor 8.179 ms - Mb
stblogrecentarticles 0.466 ms 0.04 Mb
stbestsellers 0.326 ms 0.02 Mb
stblogcomments 0.124 ms 0.01 Mb
stblogrelatedarticles 0.964 ms 0.04 Mb
stcountdown 0.304 ms 0.02 Mb
sthoverimage 4.099 ms 0.48 Mb
stinstagram 0.836 ms 0.06 Mb
stnotification 1.956 ms 0.09 Mb
stproductcategoriesslider 0.967 ms 0.09 Mb
strelatedproducts 63.825 ms 8.02 Mb
stsidebar 3.628 ms 0.28 Mb
ststickers 87.891 ms 8.98 Mb
stviewedproducts 0.233 ms 0.02 Mb
ps_feeder 0.254 ms 0.01 Mb
cdcustomorderreferences 0.080 ms 0.01 Mb
addwebservices 0.107 ms 0.01 Mb
shaim_pplparcelshop 0.127 ms 0.02 Mb
dm_cookies 1.867 ms 0.08 Mb
shaim_zasilkovna_widget 0.199 ms 0.09 Mb
stgrecaptcha 1.425 ms 0.08 Mb
rcpgtagmanager 23.267 ms 0.93 Mb
stpagebanner 4.235 ms 0.17 Mb
dm_gdpr 0.100 ms 0.01 Mb
ambjolisearch 6.656 ms 0.26 Mb
dm_comgate 5.661 ms 0.02 Mb
stcustomersignin 0.540 ms 0.03 Mb
ps_categoryproducts 116.306 ms 9.93 Mb
ps_crossselling 0.778 ms 0.09 Mb
dm_google 5.568 ms 0.02 Mb
57 module(s) 391.929 ms 32.71 Mb

Stopwatch SQL - 989 queries

# Query Time (ms) Rows Filesort Group By Location
2 
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`)
 23.920 ms 11388 /classes/Configuration.php:180
622 
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS 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("2025-04-28 00:00:00",
INTERVAL 160 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_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` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 305 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 9
 3.832 ms 14 Yes /classes/Category.php:1062
67 
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
 2.339 ms 591 /classes/Hook.php:452
19 
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
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_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` != "paymentOptions") 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`
 2.095 ms 234 Yes Yes /classes/Hook.php:1267
66 
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
 2.038 ms 0 /classes/Hook.php:1326
105 
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(
"2025-04-28 00:00:00",
INTERVAL 160 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` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 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` = 1)
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` = 2607 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 1.871 ms 8 Yes /classes/Product.php:4702
93 
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`additional_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` = 1  AND cl.id_shop = 1 )
LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 305
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 1.540 ms 1 Yes Yes /classes/Category.php:916
97 
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != 0
 1.507 ms 894 /classes/SpecificPrice.php:310
625 
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` = 5710) AND (b.`id_shop` = 1) LIMIT 1
 1.256 ms 1 /src/Adapter/EntityMapper.php:71
637 
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` = 5626) AND (b.`id_shop` = 1) LIMIT 1
 1.107 ms 1 /src/Adapter/EntityMapper.php:71
334 
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_notification` snl
INNER JOIN ps_st_notification_shop st_notification_shop
ON (st_notification_shop.id_st_notification = snl.id_st_notification AND st_notification_shop.id_shop = 1)
LEFT JOIN `ps_st_notification_lang` snll ON (snl.`id_st_notification` = snll.`id_st_notification`)
WHERE snl.`active`=1 AND snll.`id_lang` = 1 
ORDER BY snl.`position`
 1.081 ms 9 Yes /modules/stnotification/classes/StNotificationClass.php:211
634 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5710
ORDER BY f.position ASC
 1.074 ms 14 Yes /classes/Product.php:6013
633 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5710 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5710 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.073 ms 0 /classes/Cart.php:1430
335 
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 1 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
 0.945 ms 19 Yes /modules/stsidebar/classes/StSidebarClass.php:111
29 
show tables like "ps_gmc_feeds"
 0.901 ms 1 /modules/gmerchantcenter/lib/moduleTools.php:1711
347 
SELECT SQL_NO_CACHE sms.*, smsl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_page_banner` sms
LEFT JOIN `ps_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner` AND smsl.`id_lang` = 1)
INNER JOIN ps_st_page_banner_shop st_page_banner_shop
ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1)
WHERE 1 AND sms.`active`=1  AND sms.`item_k`=1 AND (sms.`show_subcate` = 0 AND sms.`item_v`="305" OR sms.`show_subcate` = 1 AND sms.`item_v` IN(305,281,205,194,879,2)) ORDER BY sms.`position`
LIMIT 1
 0.849 ms 4 Yes /modules/stpagebanner/classes/StPageBannerClass.php:186
283 
SELECT SQL_NO_CACHE s.*, sl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_sticker` s
LEFT JOIN `ps_st_sticker_lang` sl ON (s.`id_st_sticker` = sl.`id_st_sticker` AND sl.`id_lang` = 1)
LEFT JOIN `ps_st_sticker_shop` ss ON (s.`id_st_sticker` = ss.`id_st_sticker`)
LEFT JOIN `ps_st_sticker_group` sg ON (s.`id_st_sticker` = sg.`id_st_sticker`)
WHERE ss.`id_shop` = 1 AND s.`active`=1  AND s.`type` IN (1,2,3,4,5,6,7) AND sg.`id_group` IN (1)
GROUP BY s.`id_st_sticker`
ORDER BY s.`position` ASC, s.`id_st_sticker`
 0.837 ms 6 Yes Yes /modules/ststickers/classes/StStickersClass.php:161
102 
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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` = 2607
 0.808 ms 1 /classes/Product.php:7550
296 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "leoproductsearch" LIMIT 1
 0.795 ms 0 /classes/module/Module.php:2659
767 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (4942)
 0.766 ms 1 /classes/ProductAssembler.php:64
738 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.754 ms 719 Yes /classes/Category.php:1594
94 
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` = 1
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
 0.748 ms 28 Yes Yes /classes/Category.php:1151
755 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.736 ms 719 Yes /classes/Category.php:1594
732 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.735 ms 719 Yes /classes/Category.php:1594
813 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (2195)
 0.731 ms 1 /classes/ProductAssembler.php:64
752 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.727 ms 719 Yes /classes/Category.php:1594
775 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.713 ms 719 Yes /classes/Category.php:1594
348 
SELECT SQL_NO_CACHE sms.*, smsl.*
,IF(image_multi_lang<>"" && !ISNULL(image_multi_lang), image_multi_lang, image_lang_default) AS image_multi_lang
FROM `ps_st_page_banner` sms
LEFT JOIN `ps_st_page_banner_lang` smsl ON (sms.`id_st_page_banner` = smsl.`id_st_page_banner` AND smsl.`id_lang` = 1)
INNER JOIN ps_st_page_banner_shop st_page_banner_shop
ON (st_page_banner_shop.id_st_page_banner = sms.id_st_page_banner AND st_page_banner_shop.id_shop = 1)
WHERE 1 AND sms.`active`=1  AND sms.`item_k`=11 AND sms.`item_v`="1" ORDER BY sms.`position`
LIMIT 1
 0.701 ms 4 Yes /modules/stpagebanner/classes/StPageBannerClass.php:186
790 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (3910)
 0.700 ms 1 /classes/ProductAssembler.php:64
764 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.698 ms 719 Yes /classes/Category.php:1594
798 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.689 ms 719 Yes /classes/Category.php:1594
758 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.687 ms 719 Yes /classes/Category.php:1594
721 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5710)
 0.685 ms 1 /classes/ProductAssembler.php:64
729 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.672 ms 719 Yes /classes/Category.php:1594
735 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.671 ms 719 Yes /classes/Category.php:1594
781 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.663 ms 719 Yes /classes/Category.php:1594
972 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 627 AND c.`nright` >= 628 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.661 ms 719 Yes /classes/Category.php:1594
778 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.660 ms 719 Yes /classes/Category.php:1594
920 
SELECT SQL_NO_CACHE `id_st_blog` FROM ps_st_blog_product_link
WHERE `id_product` = 2607
 0.659 ms 2588 /modules/stblogrelatedarticles/stblogrelatedarticles.php:518
784 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.653 ms 719 Yes /classes/Category.php:1594
988 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 537 AND c.`nright` >= 548 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.651 ms 719 Yes /classes/Category.php:1594
761 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.647 ms 719 Yes /classes/Category.php:1594
661 
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` = 3910) AND (b.`id_shop` = 1) LIMIT 1
 0.641 ms 1 /src/Adapter/EntityMapper.php:71
967 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 557 AND c.`nright` >= 558 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.640 ms 719 Yes /classes/Category.php:1594
977 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 538 AND c.`nright` >= 539 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.640 ms 719 Yes /classes/Category.php:1594
787 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.634 ms 719 Yes /classes/Category.php:1594
101 
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 16, 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, 16) 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 '2025-04-28 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-04-28 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.630 ms 1 Yes /classes/SpecificPrice.php:646
741 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.629 ms 719 Yes /classes/Category.php:1594
962 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 555 AND c.`nright` >= 556 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.629 ms 719 Yes /classes/Category.php:1594
744 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5626)
 0.628 ms 1 /classes/ProductAssembler.php:64
18 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 0.616 ms 1147 /classes/Hook.php:1366
649 
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` = 4942) AND (b.`id_shop` = 1) LIMIT 1
 0.613 ms 1 /src/Adapter/EntityMapper.php:71
983 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 525 AND c.`nright` >= 526 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.613 ms 719 Yes /classes/Category.php:1594
646 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5626
ORDER BY f.position ASC
 0.605 ms 14 Yes /classes/Product.php:6013
801 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.601 ms 719 Yes /classes/Category.php:1594
645 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5626 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5626 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.592 ms 0 /classes/Cart.php:1430
804 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.589 ms 719 Yes /classes/Category.php:1594
359 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.589 ms 719 Yes /classes/Category.php:1594
346 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.582 ms 719 Yes /classes/Category.php:1594
364 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.581 ms 719 Yes /classes/Category.php:1594
21 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 0.573 ms 1147 /classes/Hook.php:1326
807 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.573 ms 719 Yes /classes/Category.php:1594
372 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.573 ms 719 Yes /classes/Category.php:1594
399 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.571 ms 719 Yes /classes/Category.php:1594
369 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.567 ms 719 Yes /classes/Category.php:1594
31 
SELECT SQL_NO_CACHE *
FROM `ps_gmc_feeds` ff
WHERE (ff.id_shop=1)
 0.564 ms 370 /modules/gmerchantcenter/models/Feeds.php:59
657 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4942 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4942 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.561 ms 0 /classes/Cart.php:1430
821 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.557 ms 719 Yes /classes/Category.php:1594
658 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4942
ORDER BY f.position ASC
 0.553 ms 15 Yes /classes/Product.php:6013
810 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.550 ms 719 Yes /classes/Category.php:1594
391 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5334)
 0.549 ms 1 /classes/ProductAssembler.php:64
419 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 525 AND c.`nright` >= 526 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.549 ms 719 Yes /classes/Category.php:1594
949 
SELECT SQL_NO_CACHE snl.*, snll.*
FROM `ps_st_sidebar` snl
INNER JOIN ps_st_sidebar_shop st_sidebar_shop
ON (st_sidebar_shop.id_st_sidebar = snl.id_st_sidebar AND st_sidebar_shop.id_shop = 1)
LEFT JOIN `ps_st_sidebar_lang` snll ON (snl.`id_st_sidebar` = snll.`id_st_sidebar`)
WHERE snll.`id_lang` = 1 AND snl.`active`=1 
ORDER BY snl.`location`, snl.`position`
 0.546 ms 19 Yes /modules/stsidebar/classes/StSidebarClass.php:111
414 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 537 AND c.`nright` >= 548 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.545 ms 719 Yes /classes/Category.php:1594
409 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.541 ms 719 Yes /classes/Category.php:1594
404 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 524 AND c.`nright` >= 551 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.540 ms 719 Yes /classes/Category.php:1594
841 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (4123)
 0.535 ms 1 /classes/ProductAssembler.php:64
770 
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` = 4942) LIMIT 1
 0.528 ms 1 /src/Adapter/EntityMapper.php:71
978 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4527) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.522 ms 1 Yes /classes/Product.php:4513
793 
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` = 3910) LIMIT 1
 0.520 ms 1 /src/Adapter/EntityMapper.php:71
127 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2064 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2064 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.511 ms 0 /classes/Cart.php:1430
500 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 538 AND c.`nright` >= 539 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.509 ms 719 Yes /classes/Category.php:1594
0 
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.zesemen.cz' OR su.domain_ssl = 'www.zesemen.cz')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.500 ms 1 Yes /classes/shop/Shop.php:1364
973 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4517) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.494 ms 1 Yes /classes/Product.php:4513
623 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 5710
AND image_shop.`cover` = 1 LIMIT 1
 0.489 ms 1 /classes/Product.php:3570
747 
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` = 5626) LIMIT 1
 0.486 ms 1 /src/Adapter/EntityMapper.php:71
669 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3910 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3910 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.483 ms 0 /classes/Cart.php:1430
128 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2064
ORDER BY f.position ASC
 0.478 ms 9 Yes /classes/Product.php:6013
984 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5334) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.476 ms 1 Yes /classes/Product.php:4513
979 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5324) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.475 ms 1 Yes /classes/Product.php:4513
1 
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.472 ms 1 Yes /classes/shop/Shop.php:715
835 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 671 AND c.`nright` >= 672 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.467 ms 719 Yes /classes/Category.php:1594
698 
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` = 1678) AND (b.`id_shop` = 1) LIMIT 1
 0.466 ms 1 /src/Adapter/EntityMapper.php:71
849 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.466 ms 719 Yes /classes/Category.php:1594
830 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.465 ms 719 Yes /classes/Category.php:1594
968 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (4007) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.464 ms 1 Yes /classes/Product.php:4513
827 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.463 ms 719 Yes /classes/Category.php:1594
377 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 669 AND c.`nright` >= 670 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.462 ms 719 Yes /classes/Category.php:1594
824 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.462 ms 719 Yes /classes/Category.php:1594
272 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.458 ms 719 Yes /classes/Category.php:1594
386 
SELECT SQL_NO_CACHE a.`id_product_2`
FROM `ps_accessory` a
INNER JOIN `ps_product` p ON (p.`id_product`= a.`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_lang` pl ON (p.`id_product`= pl.`id_product` AND pl.`id_lang`=1)
WHERE a.`id_product_1` = 2607
ORDER BY p.date_add DESC
 0.455 ms 8 Yes /modules/strelatedproducts/strelatedproducts.php:212
958 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2128) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.453 ms 1 Yes /classes/Product.php:4513
330 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-04-28 00:00:00" AND date_to <= "2025-04-28 23:59:59") OR (date_from >= "2025-04-28 00:00:00" AND date_from <= "2025-04-28 23:59:59") OR (date_from < "2025-04-28 00:00:00" AND date_to > "2025-04-28 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 0.450 ms 2 /classes/CartRule.php:357
838 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.450 ms 719 Yes /classes/Category.php:1594
953 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (2064) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.449 ms 1 Yes /classes/Product.php:4513
157 
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` = 4007) AND (b.`id_shop` = 1) LIMIT 1
 0.446 ms 1 /src/Adapter/EntityMapper.php:71
387 
SELECT SQL_NO_CACHE cp.`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)
LEFT JOIN `ps_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 305 AND product_shop.`visibility` IN ("both", "catalog")
AND product_shop.active = 1 
AND cp.`id_product` <> 2607
ORDER BY p.date_add DESC
LIMIT 192
 0.439 ms 14 Yes /modules/strelatedproducts/strelatedproducts.php:269
255 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 673) AND (a0.`nright` > 674) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 0.439 ms 719 Yes /classes/PrestaShopCollection.php:383
63 
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` = 2607) AND (b.`id_shop` = 1) LIMIT 1
 0.431 ms 1 /src/Adapter/EntityMapper.php:71
816 
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` = 2195) LIMIT 1
 0.430 ms 1 /src/Adapter/EntityMapper.php:71
22 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.426 ms 100 /classes/module/Module.php:341
284 
INSERT INTO `ps_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
 0.426 ms 1 /classes/ObjectModel.php:622
925 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=1 AND sec.`location` IN (12,48,49,50,51,91,92,93,94,52,57)
ORDER BY sec.`position` LIMIT 0, 50
 0.425 ms 126 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
463 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.414 ms 719 Yes /classes/Category.php:1594
331 
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 0) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%"
 0.413 ms 1 /classes/CartRule.php:423
32 
SELECT SQL_NO_CACHE *
FROM `ps_gmc_feeds` ff
WHERE (ff.iso_lang="cs") AND (ff.id_shop=1)
 0.410 ms 370 /modules/gmerchantcenter/models/Feeds.php:68
952 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.409 ms 719 Yes /classes/Category.php:1594
382 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.408 ms 719 Yes /classes/Category.php:1594
635 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 5626
AND image_shop.`cover` = 1 LIMIT 1
 0.406 ms 1 /classes/Product.php:3570
685 
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` = 4123) AND (b.`id_shop` = 1) LIMIT 1
 0.403 ms 1 /src/Adapter/EntityMapper.php:71
263 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.400 ms 719 Yes /classes/Category.php:1594
479 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (4517)
 0.399 ms 1 /classes/ProductAssembler.php:64
266 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.397 ms 719 Yes /classes/Category.php:1594
269 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.395 ms 719 Yes /classes/Category.php:1594
506 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (4007)
 0.393 ms 1 /classes/ProductAssembler.php:64
538 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 557 AND c.`nright` >= 558 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.393 ms 719 Yes /classes/Category.php:1594
451 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (4527)
 0.392 ms 1 /classes/ProductAssembler.php:64
460 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 524 AND c.`nright` >= 551 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.390 ms 719 Yes /classes/Category.php:1594
260 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.389 ms 719 Yes /classes/Category.php:1594
544 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (2128)
 0.388 ms 1 /classes/ProductAssembler.php:64
388 
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` = 5334) LIMIT 1
 0.387 ms 1 /src/Adapter/EntityMapper.php:71
867 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (1678)
 0.386 ms 1 /classes/ProductAssembler.php:64
673 
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` = 2195) AND (b.`id_shop` = 1) LIMIT 1
 0.384 ms 1 /src/Adapter/EntityMapper.php:71
963 
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3532) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 0.381 ms 1 Yes /classes/Product.php:4513
42 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.379 ms 100 /classes/module/Module.php:341
87 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 305) AND (b.`id_shop` = 1) LIMIT 1
 0.379 ms 1 /src/Adapter/EntityMapper.php:71
582 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5711)
 0.378 ms 1 /classes/ProductAssembler.php:64
564 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (2064)
 0.377 ms 1 /classes/ProductAssembler.php:64
517 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (3532)
 0.377 ms 1 /classes/ProductAssembler.php:64
894 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (1292)
 0.366 ms 1 /classes/ProductAssembler.php:64
430 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-04-28 00:00:00',
INTERVAL 160 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_product_attribute = 0
AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product IN (5324)
 0.365 ms 1 /classes/ProductAssembler.php:64
719 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1292
ORDER BY f.position ASC
 0.363 ms 15 Yes /classes/Product.php:6013
457 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.362 ms 719 Yes /classes/Category.php:1594
957 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.360 ms 719 Yes /classes/Category.php:1594
439 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 524 AND c.`nright` >= 551 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.359 ms 719 Yes /classes/Category.php:1594
424 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 546 AND c.`nright` >= 547 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.356 ms 719 Yes /classes/Category.php:1594
436 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.355 ms 719 Yes /classes/Category.php:1594
445 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 525 AND c.`nright` >= 526 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.355 ms 719 Yes /classes/Category.php:1594
85 
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 2607
AND id_shop = 1 LIMIT 1
 0.353 ms 1 /classes/ObjectModel.php:1724
442 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.353 ms 719 Yes /classes/Category.php:1594
86 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 2607 AND ctg.`id_group` = 1 LIMIT 1
 0.352 ms 7 /classes/Product.php:6736
844 
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` = 4123) LIMIT 1
 0.349 ms 1 /src/Adapter/EntityMapper.php:71
681 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2195 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2195 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.345 ms 0 /classes/Cart.php:1430
670 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3910
ORDER BY f.position ASC
 0.344 ms 17 Yes /classes/Product.php:6013
682 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2195
ORDER BY f.position ASC
 0.344 ms 15 Yes /classes/Product.php:6013
40 
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `ps_meta` m
LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
 0.341 ms 40 Yes /classes/Dispatcher.php:654
693 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4123 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4123 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.339 ms 0 /classes/Cart.php:1430
861 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 669 AND c.`nright` >= 670 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.338 ms 719 Yes /classes/Category.php:1594
923 
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (2607)
ORDER BY o.id_order DESC
LIMIT 400
 0.338 ms 38 Yes /modules/ps_crossselling/ps_crossselling.php:257
215 
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 2064) AND (b.`id_shop` = 1) LIMIT 1
 0.336 ms 1 /src/Adapter/EntityMapper.php:71
600 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.336 ms 719 Yes /classes/Category.php:1594
606 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.335 ms 719 Yes /classes/Category.php:1594
876 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.334 ms 719 Yes /classes/Category.php:1594
885 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.333 ms 719 Yes /classes/Category.php:1594
694 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4123
ORDER BY f.position ASC
 0.332 ms 11 Yes /classes/Product.php:6013
864 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.332 ms 719 Yes /classes/Category.php:1594
609 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.331 ms 719 Yes /classes/Category.php:1594
710 
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` = 1292) AND (b.`id_shop` = 1) LIMIT 1
 0.331 ms 1 /src/Adapter/EntityMapper.php:71
246 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2607 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2607 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.330 ms 0 /classes/Cart.php:1430
466 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 537 AND c.`nright` >= 548 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.330 ms 719 Yes /classes/Category.php:1594
491 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.330 ms 719 Yes /classes/Category.php:1594
855 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.330 ms 719 Yes /classes/Category.php:1594
485 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.329 ms 719 Yes /classes/Category.php:1594
852 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.329 ms 719 Yes /classes/Category.php:1594
724 
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` = 5710) LIMIT 1
 0.328 ms 1 /src/Adapter/EntityMapper.php:71
888 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 669 AND c.`nright` >= 670 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.328 ms 719 Yes /classes/Category.php:1594
247 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2607
ORDER BY f.position ASC
 0.328 ms 13 Yes /classes/Product.php:6013
858 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.328 ms 719 Yes /classes/Category.php:1594
603 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.327 ms 719 Yes /classes/Category.php:1594
494 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 537 AND c.`nright` >= 548 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.326 ms 719 Yes /classes/Category.php:1594
576 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 527 AND c.`nright` >= 528 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.326 ms 719 Yes /classes/Category.php:1594
879 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.326 ms 719 Yes /classes/Category.php:1594
88 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2607 LIMIT 1
 0.324 ms 1 /classes/Pack.php:89
882 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.324 ms 719 Yes /classes/Category.php:1594
488 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 524 AND c.`nright` >= 551 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.323 ms 719 Yes /classes/Category.php:1594
911 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 673 AND c.`nright` >= 674 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.323 ms 719 Yes /classes/Category.php:1594
558 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 555 AND c.`nright` >= 556 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.322 ms 719 Yes /classes/Category.php:1594
24 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.322 ms 100 /classes/module/Module.php:341
469 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 525 AND c.`nright` >= 526 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.322 ms 719 Yes /classes/Category.php:1594
90 
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` = 16
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('158 00' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '158 00')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.321 ms 0 /classes/tax/TaxRulesTaxManager.php:100
222 
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` = 2128) AND (b.`id_shop` = 1) LIMIT 1
 0.321 ms 1 /src/Adapter/EntityMapper.php:71
474 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 538 AND c.`nright` >= 539 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.321 ms 719 Yes /classes/Category.php:1594
550 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.321 ms 719 Yes /classes/Category.php:1594
573 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 524 AND c.`nright` >= 551 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.321 ms 719 Yes /classes/Category.php:1594
627 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 5710)
 0.321 ms 1 /classes/Product.php:3860
718 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1292 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1292 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.320 ms 0 /classes/Cart.php:1430
140 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2128 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2128 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.320 ms 0 /classes/Cart.php:1430
553 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 554 AND c.`nright` >= 565 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.320 ms 719 Yes /classes/Category.php:1594
528 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.318 ms 719 Yes /classes/Category.php:1594
707 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 1678
ORDER BY f.position ASC
 0.318 ms 15 Yes /classes/Product.php:6013
914 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 669 AND c.`nright` >= 670 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.318 ms 719 Yes /classes/Category.php:1594
497 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 525 AND c.`nright` >= 526 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.317 ms 719 Yes /classes/Category.php:1594
193 
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` = 5324) AND (b.`id_shop` = 1) LIMIT 1
 0.317 ms 1 /src/Adapter/EntityMapper.php:71
570 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 523 AND c.`nright` >= 622 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.316 ms 719 Yes /classes/Category.php:1594
612 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.315 ms 719 Yes /classes/Category.php:1594
26 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.314 ms 100 /classes/module/Module.php:341
902 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 650 AND c.`nright` >= 873 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.314 ms 719 Yes /classes/Category.php:1594
908 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 668 AND c.`nright` >= 677 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.314 ms 719 Yes /classes/Category.php:1594
25 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.313 ms 100 /classes/module/Module.php:341
152 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3532 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3532 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.313 ms 0 /classes/Cart.php:1430
232 
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` = 5334) AND (b.`id_shop` = 1) LIMIT 1
 0.313 ms 1 /src/Adapter/EntityMapper.php:71
503 
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` = 4007) LIMIT 1
 0.313 ms 1 /src/Adapter/EntityMapper.php:71
533 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 554 AND c.`nright` >= 565 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.313 ms 719 Yes /classes/Category.php:1594
905 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 667 AND c.`nright` >= 684 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.312 ms 719 Yes /classes/Category.php:1594
891 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.310 ms 719 Yes /classes/Category.php:1594
165 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4007 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4007 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.309 ms 0 /classes/Cart.php:1430
594 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5711
ORDER BY f.position ASC
 0.309 ms 13 Yes /classes/Product.php:6013
120 
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` = 16
AND tr.`id_tax_rules_group` = 1
AND tr.`id_state` IN (0, 0)
AND ('158 00' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '158 00')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.307 ms 1 /classes/tax/TaxRulesTaxManager.php:100
141 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 2128
ORDER BY f.position ASC
 0.307 ms 12 Yes /classes/Product.php:6013
153 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 3532
ORDER BY f.position ASC
 0.307 ms 13 Yes /classes/Product.php:6013
706 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 1678 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 1678 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.304 ms 0 /classes/Cart.php:1430
917 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 649 AND c.`nright` >= 920 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.302 ms 719 Yes /classes/Category.php:1594
514 
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` = 3532) LIMIT 1
 0.301 ms 1 /src/Adapter/EntityMapper.php:71
385 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=8 AND ((sec.id_manufacturer = 0 AND sec.id_category = 0 AND sec.id_product = "") OR (sec.id_category > 0 AND sec.id_category IN(305,194,205,281,879,2,306)) OR (sec.id_product LIKE "%,2607,%"))
ORDER BY sec.`position` LIMIT 0, 50
 0.301 ms 1 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
585 
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` = 5711) AND (b.`id_shop` = 1) LIMIT 1
 0.298 ms 1 /src/Adapter/EntityMapper.php:71
626 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5710 LIMIT 1
 0.297 ms 1 /classes/SpecificPrice.php:435
720 
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
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_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 305 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
 0.294 ms 14 /classes/Category.php:991
541 
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` = 2128) LIMIT 1
 0.293 ms 1 /src/Adapter/EntityMapper.php:71
477 
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` = 4517) LIMIT 1
 0.290 ms 1 /src/Adapter/EntityMapper.php:71
579 
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` = 5711) LIMIT 1
 0.290 ms 1 /src/Adapter/EntityMapper.php:71
68 
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` = 16
AND tr.`id_tax_rules_group` = 4
AND tr.`id_state` IN (0, 0)
AND ('158 00' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '158 00')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.285 ms 1 /classes/tax/TaxRulesTaxManager.php:100
227 
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` = 4517) AND (b.`id_shop` = 1) LIMIT 1
 0.283 ms 1 /src/Adapter/EntityMapper.php:71
561 
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` = 2064) LIMIT 1
 0.282 ms 1 /src/Adapter/EntityMapper.php:71
617 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=2 AND sec.`module` = "strelatedproducts" AND (sec.`module_align` >10 AND sec.`module_align` <23)
ORDER BY sec.`position` LIMIT 1
 0.281 ms 1 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
812 
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` = 1)
WHERE i.`id_product` = 3910
ORDER BY `position`
 0.281 ms 2 Yes /classes/Product.php:3539
8 
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
 0.281 ms 1 /src/Adapter/EntityMapper.php:71
224 
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` = 3532) AND (b.`id_shop` = 1) LIMIT 1
 0.279 ms 1 /src/Adapter/EntityMapper.php:71
427 
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` = 5324) LIMIT 1
 0.279 ms 1 /src/Adapter/EntityMapper.php:71
743 
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` = 1)
WHERE i.`id_product` = 5710
ORDER BY `position`
 0.278 ms 1 Yes /classes/Product.php:3539
95 
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` = 2607
 0.277 ms 1 /classes/Product.php:7492
618 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=2 AND sec.`module` = "strelatedproducts" AND (sec.`module_align` >30 AND sec.`module_align` <43)
ORDER BY sec.`position` LIMIT 1
 0.277 ms 1 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
448 
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` = 4527) LIMIT 1
 0.275 ms 1 /src/Adapter/EntityMapper.php:71
593 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5711 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5711 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.274 ms 0 /classes/Cart.php:1430
229 
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` = 4527) AND (b.`id_shop` = 1) LIMIT 1
 0.274 ms 1 /src/Adapter/EntityMapper.php:71
13 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.271 ms 100 /classes/module/Module.php:341
636 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.270 ms 1 /classes/Product.php:5659
45 
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
 0.268 ms 100 /classes/module/Module.php:341
238 
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` = 2607) LIMIT 1
 0.265 ms 1 /src/Adapter/EntityMapper.php:71
392 
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` = 1)
WHERE i.`id_product` = 5334
ORDER BY `position`
 0.264 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
129 
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` = 16
AND tr.`id_tax_rules_group` = 1
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.262 ms 1 /classes/tax/TaxRulesTaxManager.php:100
814 
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` = 1)
WHERE i.`id_product` = 2195
ORDER BY `position`
 0.262 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
166 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4007
ORDER BY f.position ASC
 0.261 ms 2 Yes /classes/Product.php:6013
96 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
 0.259 ms 894 /classes/SpecificPrice.php:297
106 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 2064 AND ctg.`id_group` = 1 LIMIT 1
 0.259 ms 3 /classes/Product.php:6736
235 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 2607 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 2607 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.254 ms 0 /classes/Cart.php:1430
632 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5710) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.254 ms 1 /classes/stock/StockAvailable.php:453
745 
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` = 1)
WHERE i.`id_product` = 5626
ORDER BY `position`
 0.253 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
624 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.252 ms 1 /classes/Product.php:5659
870 
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` = 1678) LIMIT 1
 0.252 ms 1 /src/Adapter/EntityMapper.php:71
3 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.251 ms 1 /src/Adapter/EntityMapper.php:71
274 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-04-28 00:00:00" AND date_to <= "2025-04-28 23:59:59") OR (date_from >= "2025-04-28 00:00:00" AND date_from <= "2025-04-28 23:59:59") OR (date_from < "2025-04-28 00:00:00" AND date_to > "2025-04-28 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 0.251 ms 2 /classes/CartRule.php:357
177 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4517 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4517 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.250 ms 0 /classes/Cart.php:1430
768 
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` = 1)
WHERE i.`id_product` = 4942
ORDER BY `position`
 0.246 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
178 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4517
ORDER BY f.position ASC
 0.246 ms 22 Yes /classes/Product.php:6013
615 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=2 AND sec.`module` = "strelatedproducts" AND sec.`module_align` = 1
ORDER BY sec.`position` LIMIT 0, 50
 0.244 ms 1 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
282 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "jscomposer" LIMIT 1
 0.244 ms 0 /classes/module/Module.php:2659
630 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5710 LIMIT 1
 0.242 ms 1 /classes/Pack.php:89
294 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
 0.241 ms 0 /classes/module/Module.php:2659
202 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5324
ORDER BY f.position ASC
 0.239 ms 24 Yes /classes/Product.php:6013
616 
SELECT SQL_NO_CACHE sec.*, secl.*, st_easy_content_shop.`id_shop`
FROM `ps_st_easy_content` sec
INNER JOIN ps_st_easy_content_shop st_easy_content_shop
ON (st_easy_content_shop.id_st_easy_content = sec.id_st_easy_content AND st_easy_content_shop.id_shop = 1)
LEFT JOIN `ps_st_easy_content_lang` secl ON (sec.`id_st_easy_content` = secl.`id_st_easy_content`)
WHERE secl.`id_lang` = 1 AND sec.`active`=1  AND sec.`type`=2 AND sec.`module` = "strelatedproducts" AND sec.`module_align` = 2
ORDER BY sec.`position` LIMIT 0, 50
 0.237 ms 1 Yes /modules/steasycontent/classes/StEasyContentClass.php:343
791 
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` = 1)
WHERE i.`id_product` = 3910
ORDER BY `position`
 0.237 ms 2 Yes /modules/stthemeeditor/stthemeeditor.php:5426
214 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 5334
ORDER BY f.position ASC
 0.236 ms 20 Yes /classes/Product.php:6013
897 
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` = 1292) LIMIT 1
 0.236 ms 1 /src/Adapter/EntityMapper.php:71
188 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 4527 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 4527 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.232 ms 0 /classes/Cart.php:1430
201 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5324 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5324 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.231 ms 0 /classes/Cart.php:1430
647 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 4942
AND image_shop.`cover` = 1 LIMIT 1
 0.231 ms 1 /classes/Product.php:3570
213 
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5334 UNION SELECT 0 as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5334 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.228 ms 0 /classes/Cart.php:1430
189 
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, fvl.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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
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 = 4527
ORDER BY f.position ASC
 0.227 ms 16 Yes /classes/Product.php:6013
659 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 3910
AND image_shop.`cover` = 1 LIMIT 1
 0.226 ms 2 /classes/Product.php:3570
114 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 2064
AND image_shop.`cover` = 1 LIMIT 1
 0.223 ms 1 /classes/Product.php:3570
766 
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` = 1)
WHERE i.`id_product` = 5626
ORDER BY `position`
 0.222 ms 1 Yes /classes/Product.php:3539
789 
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` = 1)
WHERE i.`id_product` = 4942
ORDER BY `position`
 0.221 ms 1 Yes /classes/Product.php:3539
722 
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` = 1)
WHERE i.`id_product` = 5710
ORDER BY `position`
 0.218 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
285 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_dm_cookies_consent`
WHERE `id_guest` = 20946119 LIMIT 1
 0.215 ms 0 /modules/dm_cookies/dm_cookies.php:1133
628 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5710 AND id_shop=1 LIMIT 1
 0.214 ms 1 /classes/Product.php:6873
964 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 225) AND (b.`id_shop` = 1) LIMIT 1
 0.212 ms 1 /src/Adapter/EntityMapper.php:71
286 
SELECT SQL_NO_CACHE c.`link_rewrite`, c.`meta_title`
FROM `ps_cms_lang` AS c
WHERE c.`id_cms` = 17
AND c.`id_lang` = 1
AND c.`id_shop` = 1 LIMIT 1
 0.212 ms 1 /modules/dm_cookies/dm_cookies.php:971
842 
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` = 1)
WHERE i.`id_product` = 4123
ORDER BY `position`
 0.210 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
631 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 5710 LIMIT 1
 0.205 ms 1 /classes/Pack.php:90
248 
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` = 16
AND tr.`id_tax_rules_group` = 4
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.202 ms 1 /classes/tax/TaxRulesTaxManager.php:100
242 
SELECT SQL_NO_CACHE v.*,vl.*
FROM `ps_st_video` v
LEFT JOIN `ps_st_video_lang` vl
ON (v.`id_st_video`=vl.`id_st_video` AND vl.`id_lang`=1)
INNER JOIN ps_st_video_shop st_video_shop
ON (st_video_shop.id_st_video = v.id_st_video AND st_video_shop.id_shop = 1)
WHERE v.`type` = 0
AND v.`active`=1 
AND (v.`location` = 0  OR (v.`location` = 2 AND (v.`id_category` = 0 OR v.`id_category` IN(194,205,281,305,306,879,883))) OR (v.`location` = 1 AND (v.`id_products` LIKE "%,2607,%")))
 0.199 ms 4 /modules/stvideo/classes/StVideoClass.php:193
98 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `from` BETWEEN '2025-04-28 00:00:00' AND '2025-04-28 23:59:59' LIMIT 1
 0.199 ms 1 /classes/SpecificPrice.php:377
980 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 407) AND (b.`id_shop` = 1) LIMIT 1
 0.198 ms 1 /src/Adapter/EntityMapper.php:71
355 
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` = 194) LIMIT 1
 0.198 ms 1 /src/Adapter/EntityMapper.php:71
969 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 427) AND (b.`id_shop` = 1) LIMIT 1
 0.197 ms 1 /src/Adapter/EntityMapper.php:71
974 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 873) AND (b.`id_shop` = 1) LIMIT 1
 0.197 ms 1 /src/Adapter/EntityMapper.php:71
71 
SELECT SQL_NO_CACHE COUNT(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 = 2607
AND DATEDIFF("2025-04-28 00:00:00", product_shop.`date_add`) < 160 LIMIT 1
 0.196 ms 0 /classes/Product.php:1732
118 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 2064)
 0.194 ms 1 /classes/Product.php:3860
792 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 3910 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.193 ms 2 Yes /classes/Image.php:284
840 
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` = 1)
WHERE i.`id_product` = 2195
ORDER BY `position`
 0.193 ms 1 Yes /classes/Product.php:3539
815 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 2195 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.192 ms 1 Yes /classes/Image.php:284
275 
SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl 
ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE (cr.`id_customer` = 0) AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1
 0.191 ms 1 /classes/CartRule.php:423
107 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 2128 AND ctg.`id_group` = 1 LIMIT 1
 0.190 ms 3 /classes/Product.php:6736
249 
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` = 1)
WHERE i.`id_product` = 2607
ORDER BY `position`
 0.190 ms 1 Yes /classes/Product.php:3539
663 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 3910)
 0.190 ms 1 /classes/Product.php:3860
41 
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
 0.188 ms 1 /classes/module/Module.php:2041
578 
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` = 1)
WHERE i.`id_product` = 2064
ORDER BY `position`
 0.188 ms 1 Yes /classes/Product.php:3539
639 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 5626)
 0.188 ms 1 /classes/Product.php:3860
746 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 5626 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.187 ms 1 Yes /classes/Image.php:284
89 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 2607 LIMIT 1
 0.184 ms 1 /classes/Pack.php:90
769 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 4942 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.180 ms 1 Yes /classes/Image.php:284
92 
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 305
AND id_shop = 1 LIMIT 1
 0.179 ms 1 /classes/ObjectModel.php:1724
333 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
 0.179 ms 1 /classes/module/Module.php:2132
799 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.179 ms 1 /classes/Category.php:1584
753 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.178 ms 1 /classes/Category.php:1584
297 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.178 ms 0 /classes/module/Module.php:2132
319 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.178 ms 0 /classes/module/Module.php:2132
20 
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
 0.177 ms 88 /classes/Hook.php:287
243 
SELECT SQL_NO_CACHE v.*,vl.*
FROM `ps_st_video` v
LEFT JOIN `ps_st_video_lang` vl
ON (v.`id_st_video`=vl.`id_st_video` AND vl.`id_lang`=1)
INNER JOIN ps_st_video_shop st_video_shop
ON (st_video_shop.id_st_video = v.id_st_video AND st_video_shop.id_shop = 1)
WHERE v.`type` = 1
AND v.`active`=1 
AND (v.`location` = 0  OR (v.`location` = 2 AND (v.`id_category` = 0 OR v.`id_category` IN(194,205,281,305,306,879,883))) OR (v.`location` = 1 AND (v.`id_products` LIKE "%,2607,%")))
 0.177 ms 4 /modules/stvideo/classes/StVideoClass.php:193
108 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 3532 AND ctg.`id_group` = 1 LIMIT 1
 0.176 ms 4 /classes/Product.php:6736
985 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 232) AND (b.`id_shop` = 1) LIMIT 1
 0.176 ms 1 /src/Adapter/EntityMapper.php:71
502 
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` = 1)
WHERE i.`id_product` = 4517
ORDER BY `position`
 0.175 ms 1 Yes /classes/Product.php:3539
629 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5710 AND `id_group` = 1 LIMIT 1
 0.174 ms 0 /classes/GroupReduction.php:153
651 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 4942)
 0.174 ms 1 /classes/Product.php:3860
695 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 1678
AND image_shop.`cover` = 1 LIMIT 1
 0.174 ms 2 /classes/Product.php:3570
23 
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
 0.172 ms 88 /classes/Hook.php:339
393 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 5334 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.172 ms 1 Yes /classes/Image.php:284
742 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,879))) OR (location = 1 AND (id_products LIKE "%,5710,%")))
 0.172 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
216 
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` = 1)
WHERE i.`id_product` = 2064
ORDER BY `position`
 0.172 ms 1 Yes /classes/Product.php:3539
545 
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` = 1)
WHERE i.`id_product` = 2128
ORDER BY `position`
 0.171 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
142 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 3532
AND image_shop.`cover` = 1 LIMIT 1
 0.171 ms 1 /classes/Product.php:3570
154 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 4007
AND image_shop.`cover` = 1 LIMIT 1
 0.169 ms 1 /classes/Product.php:3570
595 
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` = 1)
WHERE i.`id_product` = 5711
ORDER BY `position`
 0.169 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
959 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 552) AND (b.`id_shop` = 1) LIMIT 1
 0.169 ms 1 /src/Adapter/EntityMapper.php:71
295 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.168 ms 0 /classes/module/Module.php:2132
311 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 246 AND `id_shop` = 1 LIMIT 1
 0.168 ms 0 /classes/module/Module.php:2132
748 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5626 AND `id_shop` = 1
 0.168 ms 1 /src/Adapter/EntityMapper.php:79
431 
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` = 1)
WHERE i.`id_product` = 5324
ORDER BY `position`
 0.167 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
725 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5710 AND `id_shop` = 1
 0.167 ms 1 /src/Adapter/EntityMapper.php:79
100 
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `ps_specific_price_priority`
WHERE `id_product` = 2607
ORDER BY `id_specific_price_priority` DESC LIMIT 1
 0.167 ms 1 /classes/SpecificPrice.php:256
452 
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` = 1)
WHERE i.`id_product` = 4527
ORDER BY `position`
 0.167 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
518 
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` = 1)
WHERE i.`id_product` = 3532
ORDER BY `position`
 0.166 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
17 
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.166 ms 1 /classes/Language.php:1214
110 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 4517 AND ctg.`id_group` = 1 LIMIT 1
 0.165 ms 6 /classes/Product.php:6736
223 
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` = 1)
WHERE i.`id_product` = 2128
ORDER BY `position`
 0.165 ms 1 Yes /classes/Product.php:3539
565 
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` = 1)
WHERE i.`id_product` = 2064
ORDER BY `position`
 0.165 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
811 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,879))) OR (location = 1 AND (id_products LIKE "%,3910,%")))
 0.165 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
868 
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` = 1)
WHERE i.`id_product` = 1678
ORDER BY `position`
 0.165 ms 2 Yes /modules/stthemeeditor/stthemeeditor.php:5426
109 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 4007 AND ctg.`id_group` = 1 LIMIT 1
 0.164 ms 1 /classes/Product.php:6736
507 
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` = 1)
WHERE i.`id_product` = 4007
ORDER BY `position`
 0.164 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
808 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.163 ms 1 /classes/Category.php:1584
130 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 2128
AND image_shop.`cover` = 1 LIMIT 1
 0.162 ms 1 /classes/Product.php:3570
708 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 1292
AND image_shop.`cover` = 1 LIMIT 1
 0.162 ms 1 /classes/Product.php:3570
91 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
 0.161 ms 1 /classes/Category.php:1974
99 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE `to` BETWEEN '2025-04-28 00:00:00' AND '2025-04-28 23:59:59' LIMIT 1
 0.161 ms 1 /classes/SpecificPrice.php:381
540 
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` = 1)
WHERE i.`id_product` = 3532
ORDER BY `position`
 0.160 ms 1 Yes /classes/Product.php:3539
671 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 2195
AND image_shop.`cover` = 1 LIMIT 1
 0.160 ms 1 /classes/Product.php:3570
111 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 4527 AND ctg.`id_group` = 1 LIMIT 1
 0.159 ms 6 /classes/Product.php:6736
112 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5324 AND ctg.`id_group` = 1 LIMIT 1
 0.159 ms 4 /classes/Product.php:6736
256 
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 1)
WHERE `level_depth` = 1
 0.159 ms 1 /classes/Category.php:2239
332 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stnotification" LIMIT 1
 0.159 ms 1 /classes/module/Module.php:2659
57 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
 0.158 ms 1 /src/Adapter/EntityMapper.php:71
84 
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` = 2607
 0.158 ms 1 /classes/Product.php:7492
480 
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` = 1)
WHERE i.`id_product` = 4517
ORDER BY `position`
 0.158 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
638 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5626 LIMIT 1
 0.158 ms 1 /classes/SpecificPrice.php:435
78 
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`=2607
 0.158 ms 1 /classes/Tag.php:240
167 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 4517
AND image_shop.`cover` = 1 LIMIT 1
 0.158 ms 1 /classes/Product.php:3570
53 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.157 ms 1 /src/Adapter/EntityMapper.php:71
765 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,879))) OR (location = 1 AND (id_products LIKE "%,5626,%")))
 0.157 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
794 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 3910 AND `id_shop` = 1
 0.157 ms 1 /src/Adapter/EntityMapper.php:79
919 
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` = 1)
WHERE i.`id_product` = 1292
ORDER BY `position`
 0.157 ms 1 Yes /classes/Product.php:3539
104 
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 2607 LIMIT 1
 0.156 ms 1 /classes/Pack.php:442
276 
SELECT SQL_NO_CACHE 1 FROM ps_cart_product cp INNER JOIN ps_product p
ON (p.id_product = cp.id_product) INNER JOIN ps_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
 0.156 ms 1 /classes/Cart.php:4249
817 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2195 AND `id_shop` = 1
 0.156 ms 1 /src/Adapter/EntityMapper.php:79
843 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 4123 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.156 ms 1 Yes /classes/Image.php:284
103 
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 2607
 0.155 ms 1 /classes/Pack.php:187
287 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stproductcomments" LIMIT 1
 0.155 ms 1 /classes/module/Module.php:2659
426 
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` = 1)
WHERE i.`id_product` = 5334
ORDER BY `position`
 0.155 ms 1 Yes /classes/Product.php:3539
895 
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` = 1)
WHERE i.`id_product` = 1292
ORDER BY `position`
 0.155 ms 1 Yes /modules/stthemeeditor/stthemeeditor.php:5426
113 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5334 AND ctg.`id_group` = 1 LIMIT 1
 0.154 ms 6 /classes/Product.php:6736
614 
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` = 1)
WHERE i.`id_product` = 5711
ORDER BY `position`
 0.154 ms 1 Yes /classes/Product.php:3539
650 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4942 LIMIT 1
 0.154 ms 1 /classes/SpecificPrice.php:435
662 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 3910 LIMIT 1
 0.154 ms 1 /classes/SpecificPrice.php:435
736 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.154 ms 1 /classes/Category.php:1584
954 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 231) AND (b.`id_shop` = 1) LIMIT 1
 0.154 ms 1 /src/Adapter/EntityMapper.php:71
560 
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` = 1)
WHERE i.`id_product` = 2128
ORDER BY `position`
 0.153 ms 1 Yes /classes/Product.php:3539
644 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5626) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.153 ms 1 /classes/stock/StockAvailable.php:453
225 
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` = 1)
WHERE i.`id_product` = 3532
ORDER BY `position`
 0.153 ms 1 Yes /classes/Product.php:3539
310 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stsearchbar" LIMIT 1
 0.152 ms 1 /classes/module/Module.php:2659
788 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,879))) OR (location = 1 AND (id_products LIKE "%,4942,%")))
 0.152 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
72 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
 0.151 ms 1 /classes/SpecificPrice.php:426
74 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 2607)
 0.151 ms 1 /classes/Product.php:3860
950 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.151 ms 1 /classes/Category.php:1584
447 
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` = 1)
WHERE i.`id_product` = 5324
ORDER BY `position`
 0.150 ms 1 Yes /classes/Product.php:3539
771 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4942 AND `id_shop` = 1
 0.150 ms 1 /src/Adapter/EntityMapper.php:79
893 
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` = 1)
WHERE i.`id_product` = 1678
ORDER BY `position`
 0.149 ms 2 Yes /classes/Product.php:3539
668 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3910) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.148 ms 1 /classes/stock/StockAvailable.php:453
289 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stnewsletter" LIMIT 1
 0.147 ms 1 /classes/module/Module.php:2659
805 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.146 ms 1 /classes/Category.php:1584
226 
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` = 1)
WHERE i.`id_product` = 4007
ORDER BY `position`
 0.146 ms 1 Yes /classes/Product.php:3539
228 
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` = 1)
WHERE i.`id_product` = 4517
ORDER BY `position`
 0.146 ms 1 Yes /classes/Product.php:3539
727 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.145 ms 1 /classes/Category.php:1584
866 
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` = 1)
WHERE i.`id_product` = 4123
ORDER BY `position`
 0.145 ms 1 Yes /classes/Product.php:3539
230 
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` = 1)
WHERE i.`id_product` = 4527
ORDER BY `position`
 0.144 ms 1 Yes /classes/Product.php:3539
315 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.144 ms 0 /classes/module/Module.php:2132
389 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5334 AND `id_shop` = 1
 0.144 ms 1 /src/Adapter/EntityMapper.php:79
233 
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` = 1)
WHERE i.`id_product` = 5334
ORDER BY `position`
 0.143 ms 1 Yes /classes/Product.php:3539
926 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=0 AND secc.`active`=1  AND secc.`id_st_easy_content`=121 ORDER BY secc.`position`
 0.143 ms 2 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
10 
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
 0.142 ms 1 /classes/shop/ShopUrl.php:178
501 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,217,231,232,407,873))) OR (location = 1 AND (id_products LIKE "%,4517,%")))
 0.142 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
656 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4942) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.142 ms 1 /classes/stock/StockAvailable.php:453
683 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 4123
AND image_shop.`cover` = 1 LIMIT 1
 0.141 ms 1 /classes/Product.php:3570
326 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "steasycontent" LIMIT 1
 0.141 ms 1 /classes/module/Module.php:2659
244 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 2607
AND image_shop.`cover` = 1 LIMIT 1
 0.140 ms 1 /classes/Product.php:3570
309 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.140 ms 0 /classes/module/Module.php:2132
779 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.140 ms 1 /classes/Category.php:1584
126 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2064) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.139 ms 1 /classes/stock/StockAvailable.php:453
360 
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` = 205) LIMIT 1
 0.139 ms 1 /src/Adapter/EntityMapper.php:71
476 
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` = 1)
WHERE i.`id_product` = 4527
ORDER BY `position`
 0.139 ms 1 Yes /classes/Product.php:3539
776 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.139 ms 1 /classes/Category.php:1584
220 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 0.138 ms 16 Yes /classes/ImageType.php:109
307 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.138 ms 0 /classes/module/Module.php:2132
723 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 5710 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.138 ms 1 Yes /classes/Image.php:284
802 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.138 ms 1 /classes/Category.php:1584
733 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.138 ms 1 /classes/Category.php:1584
317 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.137 ms 0 /classes/module/Module.php:2132
342 
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` = 305) LIMIT 1
 0.137 ms 1 /src/Adapter/EntityMapper.php:71
660 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.137 ms 1 /classes/Product.php:5659
316 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tdsearchblock" LIMIT 1
 0.137 ms 0 /classes/module/Module.php:2659
336 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stlovedproduct" LIMIT 1
 0.137 ms 1 /classes/module/Module.php:2659
231 
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` = 1)
WHERE i.`id_product` = 5324
ORDER BY `position`
 0.136 ms 1 Yes /classes/Product.php:3539
257 
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` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
 0.136 ms 1 /src/Adapter/EntityMapper.php:71
162 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 4007 LIMIT 1
 0.136 ms 1 /classes/Pack.php:89
525 
SELECT SQL_NO_CACHE c.*, cl.*  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`nleft` <= 2 AND c.`nright` >= 1437 AND c.`nleft` >= 2 AND c.`nright` <= 1437 ORDER BY `nleft` DESC
 0.136 ms 1 Yes /classes/Category.php:1594
796 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.136 ms 1 /classes/Category.php:1584
356 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 194 AND `id_shop` = 1
 0.135 ms 1 /src/Adapter/EntityMapper.php:79
365 
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` = 281) LIMIT 1
 0.135 ms 1 /src/Adapter/EntityMapper.php:71
373 
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` = 306) LIMIT 1
 0.135 ms 1 /src/Adapter/EntityMapper.php:71
513 
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` = 1)
WHERE i.`id_product` = 4007
ORDER BY `position`
 0.135 ms 1 Yes /classes/Product.php:3539
583 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 5711
AND image_shop.`cover` = 1 LIMIT 1
 0.135 ms 1 /classes/Product.php:3570
642 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 5626 LIMIT 1
 0.135 ms 1 /classes/Pack.php:89
648 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.135 ms 1 /classes/Product.php:5659
687 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 4123)
 0.135 ms 1 /classes/Product.php:3860
38 
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
 0.134 ms 1 /src/Adapter/EntityMapper.php:71
117 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2064 LIMIT 1
 0.134 ms 1 /classes/SpecificPrice.php:435
318 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "spsearchpro" LIMIT 1
 0.134 ms 0 /classes/module/Module.php:2659
329 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 323 AND `id_shop` = 1 LIMIT 1
 0.134 ms 1 /classes/module/Module.php:2132
750 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.134 ms 1 /classes/Category.php:1584
762 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.134 ms 1 /classes/Category.php:1584
305 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.133 ms 0 /classes/module/Module.php:2132
654 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 4942 LIMIT 1
 0.133 ms 1 /classes/Pack.php:89
970 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 427 LIMIT 1
 0.133 ms 1 /classes/Category.php:1584
35 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 16) LIMIT 1
 0.132 ms 1 /src/Adapter/EntityMapper.php:71
288 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stcustomersignin" LIMIT 1
 0.132 ms 1 /classes/module/Module.php:2659
328 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ambjolisearch" LIMIT 1
 0.132 ms 1 /classes/module/Module.php:2659
420 
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` = 869) LIMIT 1
 0.132 ms 1 /src/Adapter/EntityMapper.php:71
301 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.131 ms 0 /classes/module/Module.php:2132
739 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.131 ms 1 /classes/Category.php:1584
845 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4123 AND `id_shop` = 1
 0.131 ms 1 /src/Adapter/EntityMapper.php:79
146 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 3532)
 0.130 ms 1 /classes/Product.php:3860
306 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "labsearch" LIMIT 1
 0.130 ms 0 /classes/module/Module.php:2659
308 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tvcmssearch" LIMIT 1
 0.130 ms 0 /classes/module/Module.php:2659
376 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.130 ms 1 /classes/Category.php:1589
666 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 3910 LIMIT 1
 0.130 ms 1 /classes/Pack.php:89
37 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (deleted = 0) AND (iso_code = 'CZK') LIMIT 1
 0.129 ms 1 /classes/Currency.php:893
577 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,217,231))) OR (location = 1 AND (id_products LIKE "%,2064,%")))
 0.129 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
700 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 1678)
 0.129 ms 1 /classes/Product.php:3860
124 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2064 LIMIT 1
 0.128 ms 1 /classes/Pack.php:89
730 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.128 ms 1 /classes/Category.php:1584
819 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.128 ms 1 /classes/Category.php:1584
581 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `ps_category_product` cp
INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 5711 AND ctg.`id_group` = 1 LIMIT 1
 0.128 ms 6 /classes/Product.php:6736
839 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,307,879))) OR (location = 1 AND (id_products LIKE "%,2195,%")))
 0.128 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
323 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.127 ms 0 /classes/module/Module.php:2132
374 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 306 AND `id_shop` = 1
 0.127 ms 1 /src/Adapter/EntityMapper.php:79
640 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 5626 AND id_shop=1 LIMIT 1
 0.127 ms 1 /classes/Product.php:6873
728 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.127 ms 1 /classes/Category.php:1589
975 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 873 LIMIT 1
 0.127 ms 1 /classes/Category.php:1584
28 
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
 0.127 ms 1 /classes/shop/Shop.php:1183
453 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 4527 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.127 ms 1 Yes /classes/Image.php:284
159 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 4007)
 0.126 ms 1 /classes/Product.php:3860
366 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 281 AND `id_shop` = 1
 0.126 ms 1 /src/Adapter/EntityMapper.php:79
986 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 232 LIMIT 1
 0.126 ms 1 /classes/Category.php:1584
44 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.126 ms 0 /classes/module/Module.php:2132
134 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 2128)
 0.126 ms 1 /classes/Product.php:3860
303 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.126 ms 0 /classes/module/Module.php:2132
314 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bonsearch" LIMIT 1
 0.126 ms 0 /classes/module/Module.php:2659
643 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 5626 LIMIT 1
 0.126 ms 1 /classes/Pack.php:90
782 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.126 ms 1 /classes/Category.php:1584
818 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 2195
 0.126 ms 7 /classes/Product.php:3420
79 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2607) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.125 ms 1 /classes/stock/StockAvailable.php:453
158 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4007 LIMIT 1
 0.125 ms 1 /classes/SpecificPrice.php:435
304 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "labblocksearch" LIMIT 1
 0.125 ms 0 /classes/module/Module.php:2659
416 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 407 AND `id_shop` = 1
 0.125 ms 1 /src/Adapter/EntityMapper.php:79
652 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4942 AND id_shop=1 LIMIT 1
 0.125 ms 1 /classes/Product.php:6873
675 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 2195)
 0.125 ms 1 /classes/Product.php:3860
756 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.125 ms 1 /classes/Category.php:1584
773 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.125 ms 1 /classes/Category.php:1584
361 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 205 AND `id_shop` = 1
 0.124 ms 1 /src/Adapter/EntityMapper.php:79
343 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 305 AND `id_shop` = 1
 0.124 ms 1 /src/Adapter/EntityMapper.php:79
400 
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` = 217) LIMIT 1
 0.124 ms 1 /src/Adapter/EntityMapper.php:71
664 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3910 AND id_shop=1 LIMIT 1
 0.124 ms 1 /classes/Product.php:6873
960 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 552 LIMIT 1
 0.124 ms 1 /classes/Category.php:1584
115 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 231 LIMIT 1
 0.123 ms 1 /classes/Category.php:1373
273 
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 AND c.`deleted` = 0 LIMIT 1
 0.123 ms 2 /classes/Currency.php:1134
726 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5710
 0.123 ms 6 /classes/Product.php:3420
4 
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
 0.122 ms 1 /classes/shop/Shop.php:214
190 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 5324
AND image_shop.`cover` = 1 LIMIT 1
 0.122 ms 1 /classes/Product.php:3570
302 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ttblocksearch" LIMIT 1
 0.122 ms 0 /classes/module/Module.php:2659
370 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.122 ms 1 /classes/Category.php:1584
395 
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` = 15) LIMIT 1
 0.122 ms 1 /src/Adapter/EntityMapper.php:71
405 
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` = 231) LIMIT 1
 0.122 ms 1 /src/Adapter/EntityMapper.php:71
712 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 1292)
 0.122 ms 1 /classes/Product.php:3860
759 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.122 ms 1 /classes/Category.php:1584
415 
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` = 407) LIMIT 1
 0.122 ms 1 /src/Adapter/EntityMapper.php:71
73 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2607 LIMIT 1
 0.121 ms 1 /classes/SpecificPrice.php:435
546 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 2128 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.121 ms 1 Yes /classes/Image.php:284
869 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 1678 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.121 ms 2 Yes /classes/Image.php:284
410 
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` = 232) LIMIT 1
 0.121 ms 1 /src/Adapter/EntityMapper.php:71
596 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 5711 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.121 ms 1 Yes /classes/Image.php:284
785 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.121 ms 1 /classes/Category.php:1584
508 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 4007 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.120 ms 1 Yes /classes/Image.php:284
75 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2607 AND id_shop=1 LIMIT 1
 0.120 ms 1 /classes/Product.php:6873
320 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "wbblocksearch" LIMIT 1
 0.120 ms 0 /classes/module/Module.php:2659
357 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.120 ms 1 /classes/Category.php:1584
831 
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` = 307) LIMIT 1
 0.120 ms 1 /src/Adapter/EntityMapper.php:71
924 
SELECT SQL_NO_CACHE *
FROM `ps_dm_heureka_recenze_obchodu`
WHERE `total_rating` != 0
AND `id_shop` = 1
AND `deleted` = 0
AND `validate` = 1 
AND (`source_review` = 'cs' OR `source_review` = '')
ORDER BY `rating_id` DESC
LIMIT 3
 0.120 ms 3 /modules/dm_heureka/dm_heureka.php:2845
125 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 2064 LIMIT 1
 0.119 ms 1 /classes/Pack.php:90
179 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 4527
AND image_shop.`cover` = 1 LIMIT 1
 0.119 ms 1 /classes/Product.php:3570
432 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 5324 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.119 ms 1 Yes /classes/Image.php:284
566 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 2064 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.119 ms 1 Yes /classes/Image.php:284
749 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5626
 0.119 ms 6 /classes/Product.php:3420
122 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 3
 0.118 ms 1 /src/Adapter/EntityMapper.php:79
655 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 4942 LIMIT 1
 0.118 ms 1 /classes/Pack.php:90
667 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3910 LIMIT 1
 0.118 ms 1 /classes/Pack.php:90
822 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.118 ms 1 /classes/Category.php:1584
971 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.118 ms 1 /classes/Category.php:1589
121 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 3) LIMIT 1
 0.118 ms 1 /src/Adapter/EntityMapper.php:71
277 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "steasybuilder" LIMIT 1
 0.117 ms 0 /classes/module/Module.php:2659
292 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "onepagecheckoutps" LIMIT 1
 0.117 ms 0 /classes/module/Module.php:2659
542 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2128 AND `id_shop` = 1
 0.117 ms 1 /src/Adapter/EntityMapper.php:79
965 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 225 LIMIT 1
 0.117 ms 1 /classes/Category.php:1584
362 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.116 ms 1 /classes/Category.php:1584
401 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 217 AND `id_shop` = 1
 0.116 ms 1 /src/Adapter/EntityMapper.php:79
203 
SELECT SQL_NO_CACHE image_shop.`id_image`
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)
WHERE i.`id_product` = 5334
AND image_shop.`cover` = 1 LIMIT 1
 0.116 ms 1 /classes/Product.php:3570
70 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 5
 0.115 ms 1 /src/Adapter/EntityMapper.php:79
299 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.115 ms 0 /classes/module/Module.php:2132
300 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "tmsearch" LIMIT 1
 0.115 ms 0 /classes/module/Module.php:2659
941 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=693 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.115 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
6 
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 16) LIMIT 1
 0.114 ms 1 /src/Adapter/EntityMapper.php:71
69 
SELECT SQL_NO_CACHE *
FROM `ps_tax` a
WHERE (a.`id_tax` = 5) LIMIT 1
 0.114 ms 1 /src/Adapter/EntityMapper.php:71
234 
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` = 2607
 0.114 ms 1 /classes/Product.php:7492
293 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.114 ms 0 /classes/module/Module.php:2132
927 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=680 AND secc.`active`=1  AND secc.`id_st_easy_content`=121 ORDER BY secc.`position`
 0.114 ms 2 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
932 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=688 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.114 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
936 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 905
AND setting_type = 2
 0.114 ms 33 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
119 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2064 AND id_shop=1 LIMIT 1
 0.113 ms 1 /classes/Product.php:6873
322 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "eagersearchbar" LIMIT 1
 0.113 ms 0 /classes/module/Module.php:2659
340 
SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `ps_cart_product`
WHERE `id_cart` = 0 LIMIT 1
 0.113 ms 1 /classes/Cart.php:1300
344 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.113 ms 1 /classes/Category.php:1584
396 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 15 AND `id_shop` = 1
 0.113 ms 1 /src/Adapter/EntityMapper.php:79
406 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 231 AND `id_shop` = 1
 0.113 ms 1 /src/Adapter/EntityMapper.php:79
519 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 3532 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.113 ms 1 Yes /classes/Image.php:284
33 
SELECT SQL_NO_CACHE `id_country`
FROM `ps_country`
WHERE `iso_code` = 'CZ' LIMIT 1
 0.112 ms 1 /classes/Country.php:189
772 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4942
 0.112 ms 6 /classes/Product.php:3420
43 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_edition_basic" LIMIT 1
 0.111 ms 0 /classes/module/Module.php:2659
133 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2128 LIMIT 1
 0.111 ms 1 /classes/SpecificPrice.php:435
172 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 4517 AND id_shop=1 LIMIT 1
 0.111 ms 1 /classes/Product.php:6873
619 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categoryproducts" LIMIT 1
 0.111 ms 1 /classes/module/Module.php:2659
367 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.111 ms 1 /classes/Category.php:1584
375 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 306 LIMIT 1
 0.111 ms 1 /classes/Category.php:1584
411 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 232 AND `id_shop` = 1
 0.111 ms 1 /src/Adapter/EntityMapper.php:79
896 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 1292 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.111 ms 1 Yes /classes/Image.php:284
349 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stswiper" LIMIT 1
 0.110 ms 1 /classes/module/Module.php:2659
481 
SELECT SQL_NO_CACHE *
FROM `ps_image` i
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image`) WHERE i.`id_product` = 4517 AND il.`id_lang` = 1
ORDER BY i.`position` ASC
 0.110 ms 1 Yes /classes/Image.php:284
931 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=0 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.110 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
847 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.109 ms 1 /classes/Category.php:1584
378 
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` = 879) LIMIT 1
 0.109 ms 1 /src/Adapter/EntityMapper.php:71
734 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.109 ms 1 /classes/Category.php:1589
832 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 307 AND `id_shop` = 1
 0.109 ms 1 /src/Adapter/EntityMapper.php:79
940 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 906
AND setting_type = 2
 0.109 ms 33 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
30 
SELECT SQL_NO_CACHE id_feed
FROM `ps_gmc_feeds` ff
WHERE (ff.id_shop=1) LIMIT 1
 0.108 ms 370 /modules/gmerchantcenter/models/Feeds.php:51
83 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 305 LIMIT 1
 0.108 ms 1 /classes/Category.php:1373
298 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "blocksearch_mod" LIMIT 1
 0.108 ms 0 /classes/module/Module.php:2659
539 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(2,15,222,225))) OR (location = 1 AND (id_products LIKE "%,3532,%")))
 0.108 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
641 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5626 AND `id_group` = 1 LIMIT 1
 0.108 ms 0 /classes/GroupReduction.php:153
981 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 407 LIMIT 1
 0.108 ms 1 /classes/Category.php:1584
50 
SELECT SQL_NO_CACHE * FROM `ps_currency` c ORDER BY `iso_code` ASC
 0.107 ms 2 Yes /classes/Currency.php:708
699 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1678 LIMIT 1
 0.107 ms 1 /classes/SpecificPrice.php:435
795 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 3910
 0.107 ms 6 /classes/Product.php:3420
27 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "pm_advancedpack" LIMIT 1
 0.107 ms 0 /classes/module/Module.php:2659
116 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 231 LIMIT 1
 0.106 ms 1 /classes/Product.php:5659
449 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4527 AND `id_shop` = 1
 0.106 ms 1 /src/Adapter/EntityMapper.php:79
665 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 3910 AND `id_group` = 1 LIMIT 1
 0.106 ms 0 /classes/GroupReduction.php:153
701 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1678 AND id_shop=1 LIMIT 1
 0.106 ms 1 /classes/Product.php:6873
944 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 908
AND setting_type = 2
 0.106 ms 33 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
428 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5324 AND `id_shop` = 1
 0.106 ms 1 /src/Adapter/EntityMapper.php:79
850 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.106 ms 1 /classes/Category.php:1584
327 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 71 AND `id_shop` = 1 LIMIT 1
 0.105 ms 1 /classes/module/Module.php:2132
504 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4007 AND `id_shop` = 1
 0.105 ms 1 /src/Adapter/EntityMapper.php:79
948 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 907
AND setting_type = 2
 0.105 ms 33 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
394 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 5334
 0.104 ms 6 /classes/Product.php:3420
674 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2195 LIMIT 1
 0.104 ms 1 /classes/SpecificPrice.php:435
397 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 15 LIMIT 1
 0.104 ms 1 /classes/Category.php:1584
580 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5711 AND `id_shop` = 1
 0.104 ms 1 /src/Adapter/EntityMapper.php:79
937 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=690 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.104 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
945 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=691 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.104 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
39 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
 0.103 ms 1 /src/Adapter/EntityMapper.php:79
312 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "jmsajaxsearch" LIMIT 1
 0.103 ms 0 /classes/module/Module.php:2659
425 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,217,231,232,407,869))) OR (location = 1 AND (id_products LIKE "%,5334,%")))
 0.103 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
740 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.103 ms 1 /classes/Category.php:1589
825 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 281 LIMIT 1
 0.103 ms 1 /classes/Category.php:1584
76 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2607 AND `id_group` = 1 LIMIT 1
 0.102 ms 0 /classes/GroupReduction.php:153
353 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ststickers" LIMIT 1
 0.102 ms 1 /classes/module/Module.php:2659
461 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 231 LIMIT 1
 0.102 ms 1 /classes/Category.php:1584
562 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2064 AND `id_shop` = 1
 0.102 ms 1 /src/Adapter/EntityMapper.php:79
836 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.102 ms 1 /classes/Category.php:1584
928 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=681 AND secc.`active`=1  AND secc.`id_st_easy_content`=121 ORDER BY secc.`position`
 0.102 ms 2 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
321 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.102 ms 0 /classes/module/Module.php:2132
123 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2064 AND `id_group` = 1 LIMIT 1
 0.101 ms 0 /classes/GroupReduction.php:153
313 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.101 ms 0 /classes/module/Module.php:2132
325 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
 0.101 ms 0 /classes/module/Module.php:2132
402 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 217 LIMIT 1
 0.101 ms 1 /classes/Category.php:1584
515 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 3532 AND `id_shop` = 1
 0.101 ms 1 /src/Adapter/EntityMapper.php:79
865 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,306,879))) OR (location = 1 AND (id_products LIKE "%,4123,%")))
 0.101 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
933 
SELECT SQL_NO_CACHE secc.*
FROM `ps_st_easy_content_column` secc
WHERE secc.`id_parent`=689 AND secc.`active`=1  AND secc.`id_st_easy_content`=123 ORDER BY secc.`position`
 0.101 ms 5 Yes /modules/steasycontent/classes/StEasyContentColumnClass.php:131
291 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stblogcomments" LIMIT 1
 0.101 ms 1 /classes/module/Module.php:2659
417 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 407 LIMIT 1
 0.101 ms 1 /classes/Category.php:1584
478 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4517 AND `id_shop` = 1
 0.101 ms 1 /src/Adapter/EntityMapper.php:79
828 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 305 LIMIT 1
 0.101 ms 1 /classes/Category.php:1584
11 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sturls" LIMIT 1
 0.100 ms 1 /classes/module/Module.php:2659
149 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 3532 LIMIT 1
 0.100 ms 1 /classes/Pack.php:89
686 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4123 LIMIT 1
 0.100 ms 1 /classes/SpecificPrice.php:435
692 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4123) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.100 ms 1 /classes/stock/StockAvailable.php:453
800 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.100 ms 1 /classes/Category.php:1589
846 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4123
 0.100 ms 7 /classes/Product.php:3420
182 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 4527)
 0.100 ms 1 /classes/Product.php:3860
324 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "is_themecore" LIMIT 1
 0.100 ms 0 /classes/module/Module.php:2659
407 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 231 LIMIT 1
 0.100 ms 1 /classes/Category.php:1584
412 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 232 LIMIT 1
 0.100 ms 1 /classes/Category.php:1584
536 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 225 LIMIT 1
 0.100 ms 1 /classes/Category.php:1584
82 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 2607) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.099 ms 1 /classes/stock/StockAvailable.php:806
164 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4007) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.099 ms 1 /classes/stock/StockAvailable.php:453
717 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1292) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.099 ms 1 /classes/stock/StockAvailable.php:453
929 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 681
AND setting_type = 1
 0.099 ms 1 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
9 
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
 0.099 ms 1 /classes/ObjectModel.php:1724
145 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 3532 LIMIT 1
 0.099 ms 1 /classes/SpecificPrice.php:435
290 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "steasycheckout" LIMIT 1
 0.099 ms 0 /classes/module/Module.php:2659
383 
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` = 883) LIMIT 1
 0.099 ms 1 /src/Adapter/EntityMapper.php:71
696 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 306 LIMIT 1
 0.099 ms 1 /classes/Category.php:1373
239 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2607 AND `id_shop` = 1
 0.098 ms 1 /src/Adapter/EntityMapper.php:79
613 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,879))) OR (location = 1 AND (id_products LIKE "%,5711,%")))
 0.098 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
621 
SELECT SQL_NO_CACHE ctg.`id_group`
FROM ps_category_group ctg
WHERE ctg.`id_category` = 305 AND ctg.`id_group` = 1 LIMIT 1
 0.098 ms 1 /classes/Category.php:1751
833 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 307 LIMIT 1
 0.098 ms 1 /classes/Category.php:1584
36 
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 16
 0.097 ms 1 /src/Adapter/EntityMapper.php:79
151 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 3532) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.097 ms 1 /classes/stock/StockAvailable.php:453
446 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,217,231,407))) OR (location = 1 AND (id_products LIKE "%,5324,%")))
 0.097 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
684 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.097 ms 1 /classes/Product.php:5659
731 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.097 ms 1 /classes/Category.php:1589
171 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 4517)
 0.097 ms 1 /classes/Product.php:3860
139 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2128) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.096 ms 1 /classes/stock/StockAvailable.php:453
155 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 427 LIMIT 1
 0.096 ms 1 /classes/Category.php:1373
379 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 879 AND `id_shop` = 1
 0.096 ms 1 /src/Adapter/EntityMapper.php:79
653 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 4942 AND `id_group` = 1 LIMIT 1
 0.096 ms 0 /classes/GroupReduction.php:153
871 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1678 AND `id_shop` = 1
 0.096 ms 1 /src/Adapter/EntityMapper.php:79
418 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.095 ms 1 /classes/Category.php:1589
559 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,222,552))) OR (location = 1 AND (id_products LIKE "%,2128,%")))
 0.095 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
586 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5711 LIMIT 1
 0.095 ms 1 /classes/SpecificPrice.php:435
34 
SELECT SQL_NO_CACHE `name`
FROM `ps_country_lang`
WHERE `id_lang` = 1
AND `id_country` = 16 LIMIT 1
 0.095 ms 1 /classes/Country.php:247
280 
SELECT SQL_NO_CACHE `width`, `height`
FROM ps_image_type
WHERE `name` = 'brand_default' LIMIT 1
 0.095 ms 1 /classes/Image.php:560
554 
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` = 552) LIMIT 1
 0.095 ms 1 /src/Adapter/EntityMapper.php:71
676 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2195 AND id_shop=1 LIMIT 1
 0.095 ms 1 /classes/Product.php:6873
711 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1292 LIMIT 1
 0.095 ms 1 /classes/SpecificPrice.php:435
482 
SELECT SQL_NO_CACHE `id_category` FROM `ps_category_product`
WHERE `id_product` = 4517
 0.094 ms 6 /classes/Product.php:3420
705 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1678) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.094 ms 1 /classes/stock/StockAvailable.php:453
737 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.094 ms 1 /classes/Category.php:1589
80 
SELECT SQL_NO_CACHE out_of_stock
FROM `ps_stock_available`
WHERE (id_product = 2607) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.094 ms 1 /classes/stock/StockAvailable.php:778
81 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 2607) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.094 ms 1 /classes/stock/StockAvailable.php:753
195 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 5324)
 0.094 ms 1 /classes/Product.php:3860
521 
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` = 2) LIMIT 1
 0.094 ms 1 /src/Adapter/EntityMapper.php:71
680 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2195) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.094 ms 1 /classes/stock/StockAvailable.php:453
690 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 4123 LIMIT 1
 0.094 ms 1 /classes/Pack.php:89
892 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,306,879))) OR (location = 1 AND (id_products LIKE "%,1678,%")))
 0.094 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
510 
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` = 427) LIMIT 1
 0.093 ms 1 /src/Adapter/EntityMapper.php:71
5 
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.093 ms 1 /classes/Language.php:1080
131 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 552 LIMIT 1
 0.093 ms 1 /classes/Category.php:1373
168 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 873 LIMIT 1
 0.093 ms 1 /classes/Category.php:1373
176 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 4517) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.093 ms 1 /classes/stock/StockAvailable.php:453
261 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 194 LIMIT 1
 0.093 ms 1 /classes/Category.php:1584
384 
SELECT SQL_NO_CACHE *
FROM `ps_category_lang`
WHERE `id_category` = 883 AND `id_shop` = 1
 0.093 ms 1 /src/Adapter/EntityMapper.php:79
470 
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` = 873) LIMIT 1
 0.093 ms 1 /src/Adapter/EntityMapper.php:71
587 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 5711)
 0.093 ms 1 /classes/Product.php:3860
898 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 1292 AND `id_shop` = 1
 0.093 ms 1 /src/Adapter/EntityMapper.php:79
143 
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 225 LIMIT 1
 0.092 ms 1 /classes/Category.php:1373
390 
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` = 232 LIMIT 1
 0.092 ms 0 /classes/Category.php:1373
672 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.092 ms 1 /classes/Product.php:5659
60 
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
 0.092 ms 1 /src/Adapter/EntityMapper.php:71
350 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 68 AND `id_shop` = 1 LIMIT 1
 0.091 ms 1 /classes/module/Module.php:2132
352 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 78 AND `id_shop` = 1 LIMIT 1
 0.091 ms 1 /classes/module/Module.php:2132
809 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.091 ms 1 /classes/Category.php:1589
930 
SELECT SQL_NO_CACHE *
FROM `ps_st_easy_content_element`
WHERE `id_st_easy_content_column`=681 AND `active`=1 
ORDER BY `position` ASC
 0.091 ms 1 Yes /modules/steasycontent/classes/StEasyContentElementClass.php:60
207 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
0 as id_product_attribute
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` = 5334)
 0.091 ms 1 /classes/Product.php:3860
264 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.091 ms 1 /classes/Category.php:1584
458 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 217 LIMIT 1
 0.091 ms 1 /classes/Category.php:1584
194 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5324 LIMIT 1
 0.090 ms 1 /classes/SpecificPrice.php:435
475 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(15,217,231,232,407,873))) OR (location = 1 AND (id_products LIKE "%,4527,%")))
 0.090 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
678 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2195 LIMIT 1
 0.090 ms 1 /classes/Pack.php:89
751 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.090 ms 1 /classes/Category.php:1589
918 
SELECT SQL_NO_CACHE id_st_sticker FROM `ps_st_sticker_map`
WHERE active = 1 AND (location = 0 OR (location = 2 AND (id_category = 0 OR id_category IN(194,205,281,305,306,879))) OR (location = 1 AND (id_products LIKE "%,1292,%")))
 0.090 ms 4 /modules/ststickers/classes/StStickersMapClass.php:182
529 
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` = 222) LIMIT 1
 0.090 ms 1 /src/Adapter/EntityMapper.php:71
803 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.090 ms 1 /classes/Category.php:1589
351 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "stbanner" LIMIT 1
 0.089 ms 1 /classes/module/Module.php:2659
935 
SELECT SQL_NO_CACHE *
FROM `ps_st_easy_content_element`
WHERE `id_st_easy_content_column`=689 AND `active`=1 
ORDER BY `position` ASC
 0.089 ms 1 Yes /modules/steasycontent/classes/StEasyContentElementClass.php:60
52 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'CZK') LIMIT 1
 0.089 ms 1 /classes/Currency.php:893
455 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 15 LIMIT 1
 0.089 ms 1 /classes/Category.php:1584
703 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 1678 LIMIT 1
 0.088 ms 1 /classes/Pack.php:89
715 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 1292 LIMIT 1
 0.088 ms 1 /classes/Pack.php:89
777 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.088 ms 1 /classes/Category.php:1589
783 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.088 ms 1 /classes/Category.php:1589
934 
SELECT SQL_NO_CACHE * FROM `ps_st_easy_content_setting`
WHERE id_st_easy_content_setting = 689
AND setting_type = 1
 0.088 ms 1 /modules/steasycontent/classes/StEasyContentSettingClass.php:74
939 
SELECT SQL_NO_CACHE *
FROM `ps_st_easy_content_element`
WHERE `id_st_easy_content_column`=690 AND `active`=1 
ORDER BY `position` ASC
 0.088 ms 1 Yes /modules/steasycontent/classes/StEasyContentElementClass.php:60
137 
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 2128 LIMIT 1
 0.087 ms 1 /classes/Pack.php:89
138 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 2128 LIMIT 1
 0.087 ms 1 /classes/Pack.php:90
534 
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` = 225) LIMIT 1
 0.087 ms 1 /src/Adapter/EntityMapper.php:71
601 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 205 LIMIT 1
 0.087 ms 1 /classes/Category.php:1584
713 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1292 AND id_shop=1 LIMIT 1
 0.087 ms 1 /classes/Product.php:6873
806 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.087 ms 1 /classes/Category.php:1589
380 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.086 ms 1 /classes/Category.php:1584
966 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.086 ms 1 /classes/Category.php:1589
59 
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
 0.086 ms 1 /classes/ObjectModel.php:1724
163 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 4007 LIMIT 1
 0.086 ms 1 /classes/Pack.php:90
943 
SELECT SQL_NO_CACHE *
FROM `ps_st_easy_content_element`
WHERE `id_st_easy_content_column`=693 AND `active`=1 
ORDER BY `position` ASC
 0.086 ms 1 Yes /modules/steasycontent/classes/StEasyContentElementClass.php:60
258 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 879 LIMIT 1
 0.085 ms 1 /classes/Category.php:1584
278 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "sthoverimage" LIMIT 1
 0.085 ms 1 /classes/module/Module.php:2659
341 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 61 AND `id_shop` = 1 LIMIT 1
 0.085 ms 1 /classes/module/Module.php:2132
709 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 305 LIMIT 1
 0.085 ms 1 /classes/Product.php:5659
820 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.085 ms 1 /classes/Category.php:1589
147 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 3532 AND id_shop=1 LIMIT 1
 0.085 ms 1 /classes/Product.php:6873
150 
SELECT SQL_NO_CACHE product_type FROM `ps_product` WHERE id_product = 3532 LIMIT 1
 0.085 ms 1 /classes/Pack.php:90
548 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `ps_category` c
LEFT JOIN `ps_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 1 AND cl.id_shop = 1 ) WHERE c.`id_category` = 15 LIMIT 1
 0.085 ms 1 /classes/Category.php:1584