Filtrovat podle

Kategorie

Kategorie

Dostupnost

Dostupnost

Strana

Strana

12V

12V

24V

24V

Žárovkové

Žárovkové

LED

LED

Vícefunkční lampa

Vícefunkční lampa

Jednofunkční lampa

Jednofunkční lampa

Poziční lampa přední-bílá

Poziční lampa přední-bílá

Poziční lampa boční-oranžová

Poziční lampa boční-oranžová

Poziční lampa zadní-červená

Poziční lampa zadní-červená

Blinkr statický

Blinkr statický

Brzdová lampa

Brzdová lampa

Mlhová lampa

Mlhová lampa

Couvací lampa

Couvací lampa

Osvětlení SPZ

Osvětlení SPZ

Odrazka

Odrazka

Zapojení

Zapojení

Homologace

Homologace

Krytí IP

Krytí IP

Blinkr dynamický

Blinkr dynamický

Výměnné kryty

Výměnné kryty

EMC

EMC

Pravá

Pravá

Levá

Levá

Cena

Cena

  • 54,00 Kč - 2 838,00 Kč

banner

Koncová světla

Koncové světla LED nebo žárovkové.

Koncové lampy světla

Aktivní filtry

Zpět na začátek
Load Time 4618 ms
Querying Time 4238 ms
Queries 738
Memory Peak Usage 29.6 Mb
Included Files 1165 files - 12.60 Mb
PrestaShop Cache - Mb
Global vars 0.29 Mb
PrestaShop Version 8.1.7
PHP Version 8.0.30
MySQL Version 10.3.39-MariaDB
Memory Limit 256M
Max Execution Time 300s
Smarty Cache disabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 4.383 ms 4.383 ms 5.69 Mb 7.0 Mb
__construct 0.020 ms 4.403 ms - Mb 7.0 Mb
init 40.227 ms 44.630 ms 1.73 Mb 7.6 Mb
checkAccess 0.002 ms 44.632 ms - Mb 7.6 Mb
setMedia 3.726 ms 48.358 ms 0.21 Mb 7.6 Mb
postProcess 0.002 ms 48.360 ms - Mb 7.6 Mb
initHeader 0.002 ms 48.362 ms - Mb 7.6 Mb
initContent 471.529 ms 519.891 ms 11.81 Mb 19.6 Mb
initFooter 0.003 ms 519.894 ms - Mb 19.6 Mb
display 4098 ms 4618 ms 9.57 Mb 29.6 Mb
Hook Time Memory Usage
DisplayBanner 2130 ms 0.17 Mb
DisplayFooter 1654 ms 0.29 Mb
DisplayHeader 126.241 ms 2.51 Mb
DisplayProductListReviews 68.741 ms 1.45 Mb
displayProductListReviews 64.674 ms 1.08 Mb
displayFooter 45.086 ms 1.09 Mb
DisplayFooterAfter 14.292 ms 1.44 Mb
DisplayBeforeBodyClosingTag 11.808 ms 0.34 Mb
DisplayLeftColumn 6.895 ms 0.21 Mb
displayTop 5.959 ms 0.37 Mb
displayLeftColumn 5.959 ms 0.33 Mb
displayNav2 5.569 ms 0.23 Mb
displayFooterBefore 3.875 ms 0.21 Mb
displayNav1 2.296 ms 0.09 Mb
HookHead 1.828 ms 0.03 Mb
DisplayGDPRConsent 1.817 ms 0.09 Mb
ActionFrontControllerSetMedia 1.680 ms 0.01 Mb
ProductSearchProvider 1.406 ms 0.01 Mb
DisplayMyAccountBlock 0.801 ms 0.01 Mb
ModuleRoutes 0.013 ms - Mb
DisplayAfterBodyOpeningTag 0.012 ms - Mb
DisplayTop 0.008 ms - Mb
DisplayFooterBefore 0.007 ms - Mb
ActionBuildFrontEndObject 0.006 ms - Mb
DisplayDmBody 0.004 ms - Mb
ActionDispatcher 0.003 ms - Mb
Top 0.003 ms - Mb
27 hook(s) 4153 ms 9.97 Mb
Module Time Memory Usage
ph_simpleblog 15.579 ms 1.99 Mb
blackholebots 1.550 ms 0.12 Mb
thecheckout 16.577 ms 1.72 Mb
ps_emailsubscription 4.689 ms 0.25 Mb
blockreassurance 0.784 ms 0.04 Mb
ps_socialfollow 3.769 ms 0.12 Mb
ps_emailalerts 1.205 ms 0.11 Mb
ps_imageslider 0.862 ms 0.04 Mb
hiaddtocartbutton 22.166 ms 0.44 Mb
htmlanywhere 2.701 ms 0.08 Mb
fixedheader 0.706 ms 0.03 Mb
oa_features 49.381 ms 1.15 Mb
dm_gtm 117.800 ms 2.62 Mb
dm_heureka 0.597 ms 0.05 Mb
dm_zbozi 0.245 ms 0.02 Mb
phblogrecentposts 1.738 ms 0.04 Mb
dm_facebook 19.481 ms 1.15 Mb
dm_ares 6.378 ms 0.13 Mb
dm_remainingprice 3.024 ms 0.03 Mb
productcomments 65.311 ms 1.18 Mb
ps_searchbar 2.347 ms 0.07 Mb
ps_shoppingcart 2.077 ms 0.07 Mb
ets_recaptcha_free 0.281 ms 0.03 Mb
ps_googleanalytics 6.028 ms 0.17 Mb
dm_adwords 0.370 ms 0.02 Mb
pp_eshopinfo 3782 ms 0.33 Mb
ps_facetedsearch 2.925 ms 0.19 Mb
ppheadcode 2.186 ms 0.07 Mb
ps_languageselector 1.005 ms 0.06 Mb
ps_currencyselector 3.213 ms 0.15 Mb
ps_customersignin 1.810 ms 0.07 Mb
ps_mainmenu 2.857 ms 0.30 Mb
pagesnotfound 0.148 ms 0.02 Mb
sekeywords 0.643 ms 0.06 Mb
ps_categorytree 6.067 ms 0.34 Mb
psgdpr 2.179 ms 0.14 Mb
ps_linklist 37.933 ms 0.91 Mb
ps_customeraccountlinks 3.190 ms 0.14 Mb
ps_contactinfo 3.646 ms 0.09 Mb
dm_sklik 6.428 ms 0.18 Mb
dm_google 4.040 ms 0.04 Mb
statsdata 6.824 ms 0.23 Mb
42 module(s) 4213 ms 15.02 Mb

Stopwatch SQL - 738 queries

# Query Time (ms) Rows Filesort Group By Location
589 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log` l
WHERE (message = "Hook: displayBanner, Mapovaná pozice: 1") AND (severity = 1) AND (error_code = 0) AND (object_type = "") AND (object_id = 0) AND (id_shop = 1) AND (id_shop_group = 0) AND (id_lang = 1) AND (in_all_shops = 0) LIMIT 1
 1102 ms 1158864 /classes/PrestaShopLogger.php:237
591 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log` l
WHERE (message = "Filtrované položky pro displayBanner: Array\n(\n)\n") AND (severity = 1) AND (error_code = 0) AND (object_type = "") AND (object_id = 0) AND (id_shop = 1) AND (id_shop_group = 0) AND (id_lang = 1) AND (in_all_shops = 0) LIMIT 1
 1023 ms 1158864 /classes/PrestaShopLogger.php:237
725 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log` l
WHERE (message = "Hook: displayFooter, Mapovaná pozice: 3") AND (severity = 1) AND (error_code = 0) AND (object_type = "") AND (object_id = 0) AND (id_shop = 1) AND (id_shop_group = 0) AND (id_lang = 1) AND (in_all_shops = 0) LIMIT 1
 846 ms 1158864 /classes/PrestaShopLogger.php:237
727 
SELECT SQL_NO_CACHE COUNT(*)
FROM `ps_log` l
WHERE (message = "Filtrované položky pro displayFooter: Array\n(\n)\n") AND (severity = 1) AND (error_code = 0) AND (object_type = "") AND (object_id = 0) AND (id_shop = 1) AND (id_shop_group = 0) AND (id_lang = 1) AND (in_all_shops = 0) LIMIT 1
 803 ms 1158864 /classes/PrestaShopLogger.php:237
420 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 1258 AND `id_group` = 1 LIMIT 1
 12.177 ms 0 /classes/GroupReduction.php:156
625 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 10 AND `id_shop` = 1 LIMIT 1
 10.904 ms 1 /classes/module/Module.php:2109
705 
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
 9.614 ms 1 /src/Adapter/EntityMapper.php:79
246 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 677) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 9.476 ms 1 /classes/stock/StockAvailable.php:753
567 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1197
 7.634 ms 1 /classes/Product.php:2902
650 
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 = IFNULL(`pa`.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 (1259) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 5.605 ms 1 Yes /classes/Product.php:4520
282 
SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1  AND sa.id_shop_group = 0 ) LEFT JOIN ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=3 AND c.nright<=8 GROUP BY p.id_product) p GROUP BY p.id_product ORDER BY p.date_add DESC, p.id_product DESC
 5.492 ms 12996 Yes /modules/ps_facetedsearch/src/Adapter/MySQL.php:85
576 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1194
 4.419 ms 2 /classes/Product.php:2902
239 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 677 LIMIT 1
 3.959 ms 1 /classes/SpecificPrice.php:435
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`)
 3.320 ms 1121 /classes/Configuration.php:180
387 
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 = 1263
ORDER BY f.position ASC
 3.235 ms 6 Yes /classes/Product.php:6017
524 
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` = 1373
ORDER BY `position`
 2.939 ms 8 Yes /classes/Product.php:3545
82 
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.872 ms 375 /classes/Hook.php:456
584 
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` = 1164) AND (b.`id_shop` = 1) LIMIT 1
 2.804 ms 1 /src/Adapter/EntityMapper.php:71
520 
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` = 1374) AND (b.`id_shop` = 1) LIMIT 1
 2.802 ms 1 /src/Adapter/EntityMapper.php:71
279 
SELECT SQL_NO_CACHE type, id_value, filter_show_limit, filter_type FROM ps_layered_category
WHERE controller = 'category'
AND id_category = 4
AND id_shop = 1
GROUP BY `type`, id_value ORDER BY position ASC
 2.729 ms 30 Yes Yes /modules/ps_facetedsearch/src/Filters/Provider.php:61
580 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1178
 2.664 ms 1 /classes/Product.php:2902
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
 2.660 ms 1 Yes /classes/shop/Shop.php:715
406 
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` = 1259
AND image_shop.`cover` = 1 LIMIT 1
 2.606 ms 15 /classes/Product.php:3570
95 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 549) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.591 ms 1 /classes/stock/StockAvailable.php:453
90 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 549)
 2.557 ms 1 /classes/Product.php:3860
81 
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.549 ms 0 /classes/Hook.php:1326
106 
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` = 559) LIMIT 1
 2.460 ms 1 /src/Adapter/EntityMapper.php:71
553 
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` = 1259) AND (b.`id_shop` = 1) LIMIT 1
 2.433 ms 1 /src/Adapter/EntityMapper.php:71
415 
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` = 1258
AND image_shop.`cover` = 1 LIMIT 1
 2.432 ms 15 /classes/Product.php:3570
115 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 559) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.419 ms 1 /classes/stock/StockAvailable.php:453
397 
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` = 1261
AND image_shop.`cover` = 1 LIMIT 1
 2.418 ms 15 /classes/Product.php:3570
515 
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` = 1474
ORDER BY `position`
 2.413 ms 11 Yes /classes/Product.php:3545
14 
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.398 ms 176 Yes Yes /classes/Hook.php:1267
686 
SELECT SQL_NO_CACHE *
FROM `ps_link_block_lang`
WHERE `id_link_block` = 1
 2.376 ms 1 /src/Adapter/EntityMapper.php:79
654 
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 = IFNULL(`pa`.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 (1242) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 2.374 ms 1 Yes /classes/Product.php:4520
38 
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
 2.360 ms 1 /src/Adapter/EntityMapper.php:79
85 
SELECT SQL_NO_CACHE *
FROM `ps_tax_lang`
WHERE `id_tax` = 1
 2.338 ms 1 /src/Adapter/EntityMapper.php:79
101 
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` = 4 LIMIT 1
 2.330 ms 1 /classes/Category.php:1585
699 
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "sitemap"
OR m.page = "sitemap"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 2.311 ms 1 /classes/Meta.php:193
50 
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` = 14) AND (b.`id_shop` = 1) LIMIT 1
 2.299 ms 1 /src/Adapter/EntityMapper.php:71
653 
SELECT SQL_NO_CACHE fl.name, fvl.value, fp.id_feature, fvl.id_feature_value
FROM ps_feature_product fp
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = fp.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 fp.id_product = 1258
 2.278 ms 16 /modules/oa_features/oa_features.php:376
512 
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` = 1164 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` = 1164 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 2.249 ms 0 /classes/Cart.php:1426
564 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1217
 2.197 ms 1 /classes/Product.php:2902
682 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
 2.178 ms 1 /classes/module/Module.php:2636
628 
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 = IFNULL(`pa`.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 (1374) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 2.152 ms 1 Yes /classes/Product.php:4520
403 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1261) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.143 ms 1 /classes/stock/StockAvailable.php:453
33 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 2.124 ms 1 /classes/Currency.php:893
710 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 16) LIMIT 1
 2.108 ms 1 /src/Adapter/EntityMapper.php:71
258 
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 693)
 2.071 ms 1 /classes/Product.php:3860
234 
SELECT SQL_NO_CACHE cl.link_rewrite
FROM ps_category c
LEFT JOIN ps_category_lang cl ON c.id_parent = cl.id_category
WHERE c.id_category = 4
AND cl.`id_shop` = 1
AND cl.`id_lang` = 1 LIMIT 1
 2.046 ms 1 /modules/dm_gtm/dm_gtm.php:528
613 
SELECT SQL_NO_CACHE c.*, cl.*
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 cl.id_shop = 1 
LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `ps_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1 AND c.`level_depth` <= 3 AND `id_lang` = 1
AND c.`active` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC, category_shop.`position` ASC
 2.042 ms 72 Yes Yes /classes/Category.php:799
46 
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `categories` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
 1.990 ms 8 Yes /classes/ImageType.php:109
253 
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` = 693) LIMIT 1
 1.955 ms 1 /src/Adapter/EntityMapper.php:71
627 
SELECT SQL_NO_CACHE fl.name, fvl.value, fp.id_feature, fvl.id_feature_value
FROM ps_feature_product fp
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = fp.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 fp.id_product = 1425
 1.932 ms 11 /modules/oa_features/oa_features.php:376
265 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 693) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.890 ms 1 /classes/stock/StockAvailable.php:806
507 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1164 LIMIT 1
 1.802 ms 1 /classes/SpecificPrice.php:435
412 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1259) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.761 ms 1 /classes/stock/StockAvailable.php:453
692 
SELECT SQL_NO_CACHE *
FROM ps_meta m
LEFT JOIN ps_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 1
AND ml.id_shop = 1 LIMIT 1
 1.747 ms 2 /classes/Meta.php:193
413 
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` = 1259 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` = 1259 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.742 ms 0 /classes/Cart.php:1426
714 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_contactinfo" LIMIT 1
 1.736 ms 1 /classes/module/Module.php:2636
283 
SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="acf9dc58e1223607041b09bcace328b1" LIMIT 1
 1.730 ms 1 /modules/ps_facetedsearch/src/Filters/Block.php:186
737 
SELECT SQL_NO_CACHE al.`name` AS attribute_name
FROM `ps_product_attribute_combination` pac
LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `ps_attribute_lang` al ON (
a.`id_attribute` = al.`id_attribute`
AND al.`id_lang` = 1
)
WHERE pac.`id_product_attribute` = 148
ORDER BY ag.`position` ASC, a.`position` ASC
 1.708 ms 1 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:241
280 
SELECT SQL_NO_CACHE ag.id_attribute_group, agl.public_name as attribute_group_name, is_color_group, IF(liaglv.`url_name` IS NULL OR liaglv.`url_name` = "", NULL, liaglv.`url_name`) AS url_name, IF(liaglv.`meta_title` IS NULL OR liaglv.`meta_title` = "", NULL, liaglv.`meta_title`) AS meta_title, IFNULL(liag.indexable, TRUE) AS indexable FROM `ps_attribute_group` ag  INNER JOIN ps_attribute_group_shop attribute_group_shop
ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_attribute_group` liag ON (ag.`id_attribute_group` = liag.`id_attribute_group`) LEFT JOIN `ps_layered_indexable_attribute_group_lang_value` AS liaglv ON (ag.`id_attribute_group` = liaglv.`id_attribute_group` AND agl.`id_lang` = 1) GROUP BY ag.id_attribute_group ORDER BY ag.`position` ASC
 1.655 ms 6 Yes Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:137
292 
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 1474) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 1.636 ms 1 /classes/stock/StockAvailable.php:453
649 
SELECT SQL_NO_CACHE fl.name, fvl.value, fp.id_feature, fvl.id_feature_value
FROM ps_feature_product fp
LEFT JOIN ps_feature_lang fl ON (fl.id_feature = fp.id_feature AND fl.id_lang = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = fp.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = fp.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 fp.id_product = 1261
 1.631 ms 17 /modules/oa_features/oa_features.php:376
297 
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` = 2 LIMIT 1
 1.626 ms 1 /classes/Category.php:1378
284 
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2025-01-13 00:00:00',
INTERVAL 30 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 (1474,1425,1374,1373,1371,1370,1347,1319,1318,1275,1263,1262,1261,1259,1258,1242,1217,1197,1196,1195,1194,1178,1165,1164)
 1.622 ms 24 /classes/ProductAssembler.php:95
572 
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` = 1195
ORDER BY `position`
 1.502 ms 5 Yes /classes/Product.php:3545
13 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 1.437 ms 970 /classes/Hook.php:1366
658 
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 = IFNULL(`pa`.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 (1197) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 1.377 ms 1 Yes /classes/Product.php:4520
684 
SELECT SQL_NO_CACHE lb.`id_link_block`
FROM ps_link_block lb
INNER JOIN ps_link_block_shop lbs ON lbs.`id_link_block` = lb.`id_link_block`
WHERE lb. `id_hook` = 35 AND lbs.`id_shop` = 1
ORDER by lbs.`position`
 1.376 ms 9 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:87
733 
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('3755500', '5', '308350552', '', '1', '1', '2025-01-13 12:07:42')
 1.342 ms 1 /classes/ObjectModel.php:622
586 
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1164
 1.314 ms 1 /classes/Product.php:2902
388 
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` = 1262
AND image_shop.`cover` = 1 LIMIT 1
 1.300 ms 15 /classes/Product.php:3570
48 
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` = 4
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 1.280 ms 2 Yes Yes /classes/Category.php:924
620 
SELECT SQL_NO_CACHE *
FROM `ps_simpleblog_category` sbc
LEFT JOIN `ps_simpleblog_category_lang` sbcl
ON (sbc.`id_simpleblog_category` = sbcl.`id_simpleblog_category` AND sbcl.`id_lang` = 1)
WHERE sbc.`id_parent` = 2 AND sbc.active = 1
ORDER BY sbc.`position` ASC
 1.276 ms 3 Yes /modules/ph_simpleblog/models/SimpleBlogCategory.php:203
630 
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 = IFNULL(`pa`.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 (1373) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 1.273 ms 1 Yes /classes/Product.php:4520
399 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1261 LIMIT 1
 1.267 ms 1 /classes/SpecificPrice.php:435
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)
 1.264 ms 1 /classes/Language.php:1080
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
 1.253 ms 1 /src/Adapter/EntityMapper.php:71
422 
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` = 1258 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` = 1258 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 1.221 ms 0 /classes/Cart.php:1426
574 
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` = 1194) AND (b.`id_shop` = 1) LIMIT 1
 1.217 ms 1 /src/Adapter/EntityMapper.php:71
294 
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 = 1474
ORDER BY f.position ASC
 1.216 ms 12 Yes /classes/Product.php:6017
405 
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 = 1261
ORDER BY f.position ASC
 1.119 ms 17 Yes /classes/Product.php:6017
40 
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
 1.117 ms 1 /src/Adapter/EntityMapper.php:71
734 
INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('3388045', '', 'www.led-svetla.eu/4-koncova-svetla', '', '2025-01-13 12:07:42')
 1.113 ms 1 /classes/ObjectModel.php:622
108 
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 = 559
AND DATEDIFF("2025-01-13 00:00:00", product_shop.`date_add`) < 30 LIMIT 1
 1.095 ms 0 /classes/Product.php:1732
271 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ph_simpleblog" LIMIT 1
 1.094 ms 1 /classes/module/Module.php:2636
729 
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')
 1.078 ms 1 /classes/ObjectModel.php:622
509 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1164 AND id_shop=1 LIMIT 1
 1.064 ms 1 /classes/Product.php:6872
590 
INSERT INTO `ps_log` (`severity`, `error_code`, `message`, `object_id`, `id_shop`, `id_shop_group`, `id_lang`, `in_all_shops`, `id_employee`, `object_type`, `date_add`, `date_upd`) VALUES ('1', '0', 'Hook: displayBanner, Mapovaná pozice: 1', '0', '1', NULL, '1', '0', '0', '', '2025-01-13 12:07:39', '2025-01-13 12:07:39')
 1.052 ms 1 /classes/ObjectModel.php:622
571 
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` = 1195) AND (b.`id_shop` = 1) LIMIT 1
 1.025 ms 1 /src/Adapter/EntityMapper.php:71
636 
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 = IFNULL(`pa`.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 (1347) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
HAVING qty > 0
ORDER BY a.`position` ASC;
 1.017 ms 1 Yes /classes/Product.php:4520
16 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 1.008 ms 970 /classes/Hook.php:1326
255 
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 = 693
AND DATEDIFF("2025-01-13 00:00:00", product_shop.`date_add`) < 30 LIMIT 1
 1.001 ms 0 /classes/Product.php:1732
285 
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` = 1474
AND image_shop.`cover` = 1 LIMIT 1
 0.999 ms 11 /classes/Product.php:3570
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.995 ms 1 /classes/shop/Shop.php:218
301 
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1425 AND id_shop=1 LIMIT 1
 0.991 ms 1 /classes/Product.php:6872
578 
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` = 1178) AND (b.`id_shop` = 1) LIMIT 1
 0.985 ms 1 /src/Adapter/EntityMapper.php:71
575 
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` = 1194
ORDER BY `position`
 0.966 ms 2 Yes /classes/Product.php:3545
408 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1259 LIMIT 1
 0.957 ms 1 /classes/SpecificPrice.php:435
707 
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 7 AND `id_shop` = 1
 0.952 ms 1 /src/Adapter/EntityMapper.php:79
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.led-svetla.eu' OR su.domain_ssl = 'www.led-svetla.eu')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
 0.943 ms 1 Yes /classes/shop/Shop.php:1364
617 
SELECT SQL_NO_CACHE `b`.`block_id`,`l`.`block_text`,`p`.`position`,`l`.`name` FROM `ps_htmlanywhere_blocks` as `b`
LEFT JOIN `ps_htmlanywhere_blocks_lang` as `l` ON `b`.`block_id` = `l`.`block_id`
LEFT JOIN `ps_htmlanywhere_blocks_hooks` as `relHooks` ON `b`.`block_id` = `relHooks`.`block_id`
LEFT JOIN `ps_htmlanywhere_blocks_shops` as `relShops` ON `b`.`block_id` = `relShops`.`block_id`
LEFT JOIN `ps_htmlanywhere_blocks_position` as `p` ON `b`.`block_id` = `p`.`block_id` AND `p`.`id_shop` = `relShops`.`id_shop` AND `p`.`hook_id` = `relHooks`.`hook_id`
LEFT JOIN `ps_htmlanywhere_hooks` as `h` ON `h`.`hook_id` = `relHooks`.`hook_id`
WHERE
`l`.`id_lang`="1" AND
`h`.`name` = "displayLeftColumn" AND
`b`.`status` = "1" AND
( `b`.`date_from` <= DATE("Y-m-d") OR `b`.`date_from` = "0000-00-00") AND
( `b`.`date_to` >= DATE("Y-m-d") OR `b`.`date_to` = "0000-00-00" ) AND
`relShops`.`id_shop` = "1"
ORDER BY `p`.`position` ASC
 0.938 ms 64 Yes /modules/htmlanywhere/models/HtmlAnywhereBlocks.php:346
98 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 549) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.927 ms 1 /classes/stock/StockAvailable.php:806
118 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 559) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 0.926 ms 1 /classes/stock/StockAvailable.php:806
261 
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`=693
 0.917 ms 4 /classes/Tag.php:244
735 
SELECT SQL_NO_CACHE data
FROM `ps_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
 0.916 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
29 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'CZK') LIMIT 1
 0.901 ms 1 /classes/Currency.php:893
416 
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 14 LIMIT 1
 0.900 ms 1 /classes/Product.php:5655
689 
SELECT SQL_NO_CACHE *
FROM `ps_link_block` a
LEFT JOIN `ps_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = 1
WHERE (a.`id_link_block` = 3) LIMIT 1
 0.897 ms 1 /src/Adapter/EntityMapper.php:71
281 
SELECT SQL_NO_CACHE DISTINCT f.id_feature, f.*, fl.*, IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `ps_feature` f  INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `ps_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `ps_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `ps_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC
 0.895 ms 31 Yes /modules/ps_facetedsearch/src/Filters/DataAccessor.php:171
45 
SELECT SQL_NO_CACHE state FROM ps_feature_flag WHERE name = 'multiple_image_format' LIMIT 1
 0.894 ms 1 /classes/FeatureFlag.php:105
517 
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` = 1425) AND (b.`id_shop` = 1) LIMIT 1
 0.878 ms 1 /src/Adapter/EntityMapper.php:71
529 
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` = 1370) AND (b.`id_shop` = 1) LIMIT 1
 0.877 ms 1 /src/Adapter/EntityMapper.php:71
697 
SELECT SQL_NO_CACHE *
FROM `ps_cms_lang`
WHERE `id_cms` = 5 AND `id_shop` = 1
 0.875 ms 1 /src/Adapter/EntityMapper.php:79
93 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_group`
WHERE `id_group` = 1 LIMIT 1
 0.868 ms 1 /classes/Group.php:154
652 
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 = IFNULL(`pa`.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 (1258) 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.853 ms 1 Yes /classes/Product.php:4520
268 
SELECT SQL_NO_CACHE c.`nleft`, c.`nright` FROM `ps_category` c
WHERE c.`id_category` = 2 LIMIT 1
 0.847 ms 1 /classes/Category.php:1591
242 
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 677 AND `id_group` = 1 LIMIT 1
 0.842 ms 0 /classes/GroupReduction.php:156
404 
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` = 1261 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` = 1261 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.842 ms 0 /classes/Cart.php:1426
731 
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'category' LIMIT 1
 0.835 ms 1 /classes/Page.php:104
288 
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1474 LIMIT 1
 0.830 ms 1 /classes/SpecificPrice.php:435
702 
SELECT SQL_NO_CACHE *
FROM `ps_cms` a
LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
 0.810 ms 1 /src/Adapter/EntityMapper.php:71
236 
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 677 AND `id_shop` = 1
 0.809 ms 1 /src/Adapter/EntityMapper.php:79
565 
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` = 1197) AND (b.`id_shop` = 1) LIMIT 1
 0.798 ms 1 /src/Adapter/EntityMapper.php:71
638 
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 = IFNULL(`pa`.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 (1319) 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.792 ms 1 Yes /classes/Product.php:4520
656 
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 = IFNULL(`pa`.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 (1217) 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.784 ms 1 Yes /classes/Product.php:4520
550 
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` = 1261) AND (b.`id_shop` = 1) LIMIT 1
 0.781 ms 1 /src/Adapter/EntityMapper.php:71
513 
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 = 1164
ORDER BY f.position ASC
 0.780 ms 15 Yes /classes/Product.php:6017
538 
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` = 1318) AND (b.`id_shop` = 1) LIMIT 1
 0.780 ms 1 /src/Adapter/EntityMapper.php:71
526 
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` = 1371) AND (b.`id_shop` = 1) LIMIT 1
 0.779 ms 1 /src/Adapter/EntityMapper.php:71
523 
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` = 1373) AND (b.`id_shop` = 1) LIMIT 1
 0.767 ms 1 /src/Adapter/EntityMapper.php:71
676 
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 = IFNULL(`pa`.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 (1164) 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.765 ms 1 Yes /classes/Product.php:4520
581 
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` = 1165) AND (b.`id_shop` = 1) LIMIT 1
 0.765 ms 1 /src/Adapter/EntityMapper.php:71
660 
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 = IFNULL(`pa`.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 (1196) 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.754 ms 1 Yes /classes/Product.php:4520
622 
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 = IFNULL(`pa`.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 (1474) 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.751 ms 1 Yes /classes/Product.php:4520
632 
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 = IFNULL(`pa`.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 (1371) 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.746 ms 1 Yes /classes/Product.php:4520
87 
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM ps_product_attribute pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.id_product = 549 LIMIT 1
 0.741 ms 1 /classes/Product.php:1106
559 
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` = 1242) AND (b.`id_shop` = 1) LIMIT 1
 0.739 ms 1 /src/Adapter/EntityMapper.php:71
249 
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` = 4 LIMIT 1
 0.734 ms 1 /classes/Category.php:1585
648 
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 = IFNULL(`pa`.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 (1261) 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.730 ms 1 Yes /classes/Product.php:4520