Koncové světlo W150DD č.1123 Dynamic

Koncové světlo W150DD č.1123 Dynamic
search
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic
  • Koncové světlo W150DD č.1123 Dynamic

Parametry

video
produktové video
LED
12V
24V
Levá
Pravá
Vícefunkční lampa
Poziční lampa zadní-červená
Blinkr dynamický
Couvací lampa
Odrazka
EMC
Brzdová lampa
Mlhová lampa
Zapojení
Kabeláž
Homologace
E20
Délka kabelu
200cm YLY-S 6x0,5mm2
Rozměry VxŠxH - mm
104x236x40
Krytí IP
IP66/68
1123
Dax
1 647,11 Kč S DPH 1 361,25 Kč (bez DPH)
Počet
skladem


Dostupná doprava
  • GLS 129,00 Kč
  • do 48 hodin


Kontaktujte nás

  • produktové video produktové video

W150DD je moderní LED zadní skupinová svítilna s charakteristickým tvarem obrysového světla a dynamickým blinkrem  ("Audi") . Obrysové světlo je vyrobeno ze speciálního materiálu, díky kterému nejsou vidět jednotlivé světelné LED body a vzniká efekt NEONU, tento efekt je velmi příjemný a lahodící oku. Dynamický blinkr postupně rozsvící LEDky od začátku do konce jak můžete znát třeba u nových vozidel Audi. Lampa může pracovat v rozmezí 12V a 24V, má schválení EMC a krytí IP 66/68.


napětí 12V:
- Obrysové světlo: 1,4W
- Brzdové světlo: 1,4W
- Blinkr: 2,2W
- Couvací světlo: 2,2W
- Mlhové světlo: 1,3W

napětí 24V:
- Obrysové světlo: 2.9W
- Brzdové světlo: 2.9W
- Blinkr: 4,3W
- Couvací světlo: 4,3W
- Mlhové světlo: 1,3W

Hmotnost lampy: 0,62kg

1123
19 ks

Parametry

video
produktové video
LED
Ano
12V
Ano
24V
ANO
Levá
ANO
Pravá
ANO
Vícefunkční lampa
ANO
Poziční lampa zadní-červená
ANO
Blinkr dynamický
ANO
Couvací lampa
ANO
Odrazka
ANO
EMC
ano
Brzdová lampa
ANO
Mlhová lampa
ANO
Zapojení
Kabeláž
Homologace
E20
Délka kabelu
200cm YLY-S 6x0,5mm2
Rozměry VxŠxH - mm
104x236x40
Krytí IP
IP66/68
Komentáře (0)
Na tento produkt momentálně není přidána žádná recenze.

Zákazníci, kteří si koupili tento produkt, koupili také:

Load Time 4781 ms
Querying Time 4536 ms
Queries 370
Memory Peak Usage 22.9 Mb
Included Files 1119 files - 12.20 Mb
PrestaShop Cache - Mb
Global vars 0.27 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.376 ms 4.376 ms 5.66 Mb 7.0 Mb
__construct 0.014 ms 4.390 ms - Mb 7.0 Mb
init 40.412 ms 44.802 ms 2.49 Mb 8.2 Mb
checkAccess 0.002 ms 44.804 ms - Mb 8.2 Mb
setMedia 2.243 ms 47.047 ms 0.20 Mb 8.3 Mb
postProcess 0.005 ms 47.052 ms - Mb 8.3 Mb
initHeader 0.002 ms 47.054 ms - Mb 8.3 Mb
initContent 94.854 ms 141.908 ms 4.42 Mb 13.1 Mb
initFooter 0.002 ms 141.910 ms - Mb 13.1 Mb
display 4639 ms 4781 ms 9.74 Mb 22.9 Mb
Hook Time Memory Usage
DisplayFooter 2627 ms 0.14 Mb
DisplayBanner 1745 ms 0.16 Mb
displayFooterProduct 134.832 ms 4.77 Mb
DisplayProductAdditionalInfo 25.799 ms 0.45 Mb
displayFooter 23.021 ms 0.98 Mb
DisplayProductListReviews 22.249 ms 0.50 Mb
DisplayHeader 16.710 ms 0.44 Mb
DisplayFooterProduct 16.369 ms 0.29 Mb
displayProductListReviews 13.796 ms 0.11 Mb
FilterProductContent 11.117 ms 0.82 Mb
displayReassurance 8.493 ms 0.38 Mb
displayTop 6.212 ms 0.33 Mb
displayNav2 5.781 ms 0.21 Mb
DisplayGDPRConsent 5.567 ms 0.25 Mb
DisplayBeforeBodyClosingTag 4.880 ms 0.24 Mb
displayFooterBefore 3.437 ms 0.15 Mb
displayNav1 2.787 ms 0.15 Mb
DisplayReassurance 2.700 ms 0.04 Mb
HookHead 1.157 ms 0.03 Mb
DisplayMyAccountBlock 1.028 ms 0.01 Mb
ActionFrontControllerSetMedia 0.972 ms 0.07 Mb
DisplayFooterAfter 0.033 ms - Mb
DisplayTop 0.024 ms - Mb
ModuleRoutes 0.013 ms - Mb
DisplayAfterBodyOpeningTag 0.012 ms - Mb
DisplayFooterBefore 0.009 ms - Mb
ActionBuildFrontEndObject 0.005 ms - Mb
DisplayDmBody 0.004 ms - Mb
ActionDispatcher 0.003 ms - Mb
Top 0.003 ms - Mb
30 hook(s) 4679 ms 10.54 Mb
Module Time Memory Usage
ph_simpleblog 9.667 ms 1.90 Mb
blackholebots 2.313 ms 0.13 Mb
thecheckout 2.378 ms 0.28 Mb
ps_emailsubscription 3.900 ms 0.25 Mb
blockreassurance 0.440 ms 0.04 Mb
ps_socialfollow 4.201 ms 0.18 Mb
ps_emailalerts 1.360 ms 0.05 Mb
productcomments 40.129 ms 1.23 Mb
ps_imageslider 0.545 ms 0.04 Mb
hiaddtocartbutton 8.610 ms 0.22 Mb
htmlanywhere 0.337 ms 0.05 Mb
fixedheader 0.456 ms 0.03 Mb
oa_features 18.139 ms 0.45 Mb
dm_gtm 9.494 ms 0.48 Mb
dm_heureka 0.716 ms 0.05 Mb
dm_zbozi 0.208 ms 0.02 Mb
phblogrecentposts 0.648 ms 0.04 Mb
dm_facebook 16.093 ms 1.15 Mb
dm_ares 7.304 ms 0.13 Mb
dm_remainingprice 29.482 ms 0.48 Mb
ps_searchbar 2.524 ms 0.06 Mb
ps_shoppingcart 1.903 ms 0.06 Mb
ets_recaptcha_free 0.229 ms 0.09 Mb
ps_googleanalytics 3.959 ms 0.12 Mb
dm_adwords 0.530 ms 0.02 Mb
pp_eshopinfo 4371 ms 0.32 Mb
ppheadcode 1.395 ms 0.06 Mb
ps_languageselector 1.090 ms 0.06 Mb
ps_currencyselector 3.325 ms 0.14 Mb
ps_customersignin 1.847 ms 0.07 Mb
ps_mainmenu 3.189 ms 0.27 Mb
pagesnotfound 0.199 ms 0.02 Mb
sekeywords 0.632 ms 0.06 Mb
ps_contactinfo 3.937 ms 0.12 Mb
contactform 6.464 ms 0.35 Mb
psgdpr 6.000 ms 0.36 Mb
ps_crossselling 135.000 ms 4.79 Mb
ps_linklist 17.270 ms 0.84 Mb
ps_customeraccountlinks 3.700 ms 0.13 Mb
dm_sklik 4.888 ms 0.05 Mb
dm_google 4.789 ms 0.12 Mb
statsdata 3.931 ms 0.22 Mb
42 module(s) 4735 ms 15.52 Mb

Stopwatch SQL - 370 queries

# Query Time (ms) Rows Filesort Group By Location
359 
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
 1323 ms 1158376 /classes/PrestaShopLogger.php:237
361 
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
 1300 ms 1158376 /classes/PrestaShopLogger.php:237
141 
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
 927 ms 1158376 /classes/PrestaShopLogger.php:237
139 
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
 814 ms 1158376 /classes/PrestaShopLogger.php:237
161 
SELECT SQL_NO_CACHE c.`id_carrier`
FROM `ps_product_carrier` pc
INNER JOIN `ps_carrier` c ON (c.`id_reference` = pc.`id_carrier_reference` AND c.`deleted` = 0 AND c.`active` = 1)
INNER JOIN `ps_carrier_zone` cz ON (c.`id_carrier` = cz.`id_carrier` AND cz.`id_zone` = 9)
WHERE pc.`id_product` = 558
AND pc.`id_shop` = 1
 10.939 ms 1 /modules/dm_remainingprice/dm_remainingprice.php:800
190 
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM ps_order_detail od
LEFT JOIN ps_product p ON (p.id_product = od.product_id)
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 (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product)
LEFT JOIN `ps_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (13155,12519,12090,10798,10748,10563,10404,9326,9079,7529,7248,6982,6711,5857,5785,5332,5003,4888,4522,4465,4172,3858,3735,3629,3589,3259,2883,2735,2706,2668,2644,2110,1961,1826,1450,1168,1127,804,622,453,41,38,30)
AND od.product_id NOT IN (558)
AND product_shop.visibility IN ('both','catalog')
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 8
 3.472 ms 150 Yes /modules/ps_crossselling/ps_crossselling.php:288
166 
SELECT SQL_NO_CACHE location
FROM `ps_stock_available`
WHERE (id_product = 558) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 3.443 ms 1 /classes/stock/StockAvailable.php:806
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.146 ms 1121 /classes/Configuration.php:180
45 
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.248 ms 0 /classes/Hook.php:1326
324 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
 2.075 ms 1 /classes/module/Module.php:2636
165 
SELECT SQL_NO_CACHE depends_on_stock
FROM `ps_stock_available`
WHERE (id_product = 558) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
 2.012 ms 1 /classes/stock/StockAvailable.php:753
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`
 1.689 ms 176 Yes Yes /classes/Hook.php:1267
20 
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
 1.532 ms 95 /classes/module/Module.php:345
205 
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 (1035)
 1.276 ms 1 /classes/ProductAssembler.php:64
46 
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
 1.267 ms 375 /classes/Hook.php:456
233 
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 (408)
 1.189 ms 1 /classes/ProductAssembler.php:64
297 
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 = 316
ORDER BY f.position ASC
 1.189 ms 15 Yes /classes/Product.php:6017
81 
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-01-13 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 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` = 558 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
 1.124 ms 1 Yes /classes/Product.php:4698
219 
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 (315)
 1.107 ms 1 /classes/ProductAssembler.php:64
260 
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 (590)
 1.087 ms 1 /classes/ProductAssembler.php:64
288 
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 (316)
 1.078 ms 1 /classes/ProductAssembler.php:64
32 
SELECT SQL_NO_CACHE c.id_currency
FROM `ps_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
 1.068 ms 1 /classes/Currency.php:893
246 
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 (156)
 1.044 ms 1 /classes/ProductAssembler.php:64
191 
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 (1292)
 1.016 ms 1 /classes/ProductAssembler.php:64
13 
SELECT SQL_NO_CACHE lower(name) as name
FROM `ps_hook` h
WHERE (h.active = 1)
 0.933 ms 970 /classes/Hook.php:1366
301 
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 (1292) 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.932 ms 1 Yes /classes/Product.php:4520
274 
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 (726)
 0.920 ms 1 /classes/ProductAssembler.php:64
168 
SELECT SQL_NO_CACHE c.*, cl.delay
FROM `ps_carrier` c
LEFT JOIN `ps_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`)LEFT JOIN `ps_zone` z ON (z.`id_zone` = 9)
INNER JOIN ps_carrier_shop carrier_shop
ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1)
WHERE c.`deleted` = 0 AND c.`active` = 1  AND cz.`id_zone` = 9 AND z.`active` = 1  AND EXISTS (SELECT 1 FROM ps_carrier_group WHERE ps_carrier_group.id_carrier = c.id_carrier AND id_group IN (1))  AND (c.is_module = 0 OR c.need_range = 1)  GROUP BY c.`id_carrier` ORDER BY c.`position` ASC
 0.911 ms 3 Yes Yes /classes/Carrier.php:573
181 
SELECT SQL_NO_CACHE *
FROM `ps_contact` c
LEFT JOIN ps_contact_shop contact_shop
ON (contact_shop.id_contact = c.id_contact AND contact_shop.id_shop = 1)
LEFT JOIN `ps_contact_lang` cl ON (c.`id_contact` = cl.`id_contact`)
WHERE cl.`id_lang` = 1
AND contact_shop.`id_shop` IN (1)
GROUP BY c.`id_contact`
ORDER BY `name` ASC
 0.880 ms 9 Yes Yes /classes/Contact.php:100
305 
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 (1035) 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.868 ms 1 Yes /classes/Product.php:4520
315 
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 (726) 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.863 ms 1 Yes /classes/Product.php:4520
95 
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`,
pal.`available_now`, pal.`available_later`
FROM `ps_product_attribute` pa
INNER JOIN ps_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_product_attribute_lang` pal
ON (
pa.`id_product_attribute` = pal.`id_product_attribute` AND
pal.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 558
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
 0.863 ms 1 Yes Yes /classes/Product.php:4594
298 
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` = 316) AND (b.`id_shop` = 1) LIMIT 1
 0.849 ms 1 /src/Adapter/EntityMapper.php:71
307 
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 (315) 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.849 ms 1 Yes /classes/Product.php:4520
230 
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` = 315) AND (b.`id_shop` = 1) LIMIT 1
 0.847 ms 1 /src/Adapter/EntityMapper.php:71
309 
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 (408) 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.839 ms 1 Yes /classes/Product.php:4520
311 
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 (156) 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.836 ms 1 Yes /classes/Product.php:4520
42 
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` = 558) AND (b.`id_shop` = 1) LIMIT 1
 0.834 ms 1 /src/Adapter/EntityMapper.php:71
216 
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` = 1035) AND (b.`id_shop` = 1) LIMIT 1
 0.815 ms 1 /src/Adapter/EntityMapper.php:71
202 
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.806 ms 1 /src/Adapter/EntityMapper.php:71
257 
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` = 156) AND (b.`id_shop` = 1) LIMIT 1
 0.803 ms 1 /src/Adapter/EntityMapper.php:71
313 
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 (590) 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.793 ms 1 Yes /classes/Product.php:4520
244 
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` = 408
ORDER BY `position`
 0.785 ms 5 Yes /classes/Product.php:3545
189 
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 (558)
ORDER BY o.id_order DESC
LIMIT 400
 0.772 ms 45 Yes /modules/ps_crossselling/ps_crossselling.php:257
317 
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 (316) 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
184 
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 = 558
 0.744 ms 19 /modules/oa_features/oa_features.php:376
258 
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` = 156
ORDER BY `position`
 0.728 ms 5 Yes /classes/Product.php:3545
310 
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 = 408
 0.717 ms 16 /modules/oa_features/oa_features.php:376
16 
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
 0.712 ms 970 /classes/Hook.php:1326
285 
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` = 726) AND (b.`id_shop` = 1) LIMIT 1
 0.703 ms 1 /src/Adapter/EntityMapper.php:71
71 
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` = 14
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
 0.687 ms 1 Yes Yes /classes/Category.php:924
264 
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` = 590) AND (b.`id_shop` = 1) LIMIT 1
 0.685 ms 1 /src/Adapter/EntityMapper.php:71
72 
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.674 ms 27 Yes Yes /classes/Category.php:1151
21 
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.667 ms 50 Yes /classes/Dispatcher.php:654
243 
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` = 408) AND (b.`id_shop` = 1) LIMIT 1
 0.666 ms 1 /src/Adapter/EntityMapper.php:71
80 
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` = 558
 0.662 ms 1 /classes/Product.php:7559
312 
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 = 156
 0.659 ms 13 /modules/oa_features/oa_features.php:376
256 
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 = 156
ORDER BY f.position ASC
 0.658 ms 13 Yes /classes/Product.php:6017
171 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
INNER JOIN `ps_range_price` r ON d.`id_range_price` = r.`id_range_price`
WHERE d.`id_zone` = 9
AND d.`id_carrier` = 75
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_price` = `d`.`id_range_price`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY r.`delimiter2` DESC LIMIT 1
 0.657 ms 2 Yes /classes/Carrier.php:479
214 
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` = 1035 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` = 1035 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.647 ms 0 /classes/Cart.php:1426
283 
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` = 726 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` = 726 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.638 ms 0 /classes/Cart.php:1426
228 
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` = 315 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` = 315 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.634 ms 0 /classes/Cart.php:1426
241 
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` = 408 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` = 408 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.633 ms 0 /classes/Cart.php:1426
270 
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` = 590 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` = 590 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.633 ms 0 /classes/Cart.php:1426
200 
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.619 ms 0 /classes/Cart.php:1426
255 
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` = 156 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` = 156 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.618 ms 0 /classes/Cart.php:1426
242 
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 = 408
ORDER BY f.position ASC
 0.610 ms 16 Yes /classes/Product.php:6017
229 
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 = 315
ORDER BY f.position ASC
 0.608 ms 15 Yes /classes/Product.php:6017
296 
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` = 316 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` = 316 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.598 ms 0 /classes/Cart.php:1426
308 
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 = 315
 0.598 ms 15 /modules/oa_features/oa_features.php:376
215 
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 = 1035
ORDER BY f.position ASC
 0.596 ms 9 Yes /classes/Product.php:6017
142 
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', 'Filtrované položky pro displayBanner: Array\n(\n)\n', '0', '1', NULL, '1', '0', '0', '', '2025-01-13 12:19:09', '2025-01-13 12:19:09')
 0.582 ms 1 /classes/ObjectModel.php:622
174 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_price` r ON d.`id_range_price` = r.`id_range_price`
WHERE d.`id_zone` = 9
AND 1647.1125 >= r.`delimiter1`
AND 1647.1125 < r.`delimiter2`
AND d.`id_carrier` = 75
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_price` = `d`.`id_range_price`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY r.`delimiter1` ASC LIMIT 1
 0.578 ms 2 Yes /classes/Carrier.php:405
318 
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 = 316
 0.569 ms 15 /modules/oa_features/oa_features.php:376
87 
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 = 558
ORDER BY f.position ASC
 0.562 ms 19 Yes /classes/Product.php:6017
316 
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 = 726
 0.551 ms 3 /modules/oa_features/oa_features.php:376
83 
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` = 558 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` = 558 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.550 ms 0 /classes/Cart.php:1426
314 
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 = 590
 0.550 ms 5 /modules/oa_features/oa_features.php:376
271 
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 = 590
ORDER BY f.position ASC
 0.548 ms 5 Yes /classes/Product.php:6017
175 
SELECT SQL_NO_CACHE d.`price`
FROM `ps_delivery` d
LEFT JOIN `ps_range_price` r ON d.`id_range_price` = r.`id_range_price`
WHERE d.`id_zone` = 9
AND 1647.1125 >= r.`delimiter1`
AND 1647.1125 < r.`delimiter2`
AND d.`id_carrier` = 75
AND d.id_delivery = (
SELECT d2.id_delivery
FROM ps_delivery d2
WHERE d2.id_carrier = `d`.id_carrier
AND d2.id_zone = `d`.id_zone
AND d2.`id_range_price` = `d`.`id_range_price`
AND (d2.id_shop = 1 OR (d2.id_shop_group = 1
AND d2.id_shop IS NULL) OR (d2.id_shop_group IS NULL AND d2.id_shop IS NULL))
ORDER BY d2.id_shop DESC, d2.id_shop_group DESC
LIMIT 1
)
ORDER BY r.`delimiter1` ASC LIMIT 1
 0.542 ms 2 Yes /classes/Carrier.php:449
109 
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name, a.`id_attribute`, stock.location 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_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute` LEFT JOIN `ps_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `ps_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 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_stock_available` stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(pa.`id_product_attribute`, 0)) WHERE pa.`id_product` = 558 GROUP BY pa.`id_product_attribute`, ag.`id_attribute_group` ORDER BY pa.`id_product_attribute`
 0.540 ms 1 Yes Yes /classes/Product.php:2815
302 
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 = 1292
 0.538 ms 1 /modules/oa_features/oa_features.php:376
306 
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 = 1035
 0.536 ms 9 /modules/oa_features/oa_features.php:376
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.528 ms 1 Yes /classes/shop/Shop.php:715
89 
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` = 558
ORDER BY `position`
 0.505 ms 9 Yes /classes/Product.php:3545
284 
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 = 726
ORDER BY f.position ASC
 0.503 ms 3 Yes /classes/Product.php:6017
79 
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-01-13 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-01-13 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
 0.499 ms 1 Yes /classes/SpecificPrice.php:656
23 
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.495 ms 95 /classes/module/Module.php:345
203 
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.495 ms 3 Yes /classes/Product.php:3545
167 
SELECT SQL_NO_CACHE id_carrier
FROM `ps_product_carrier` pc
INNER JOIN `ps_carrier` `c` ON c.id_reference = pc.id_carrier_reference AND c.deleted = 0 AND c.active = 1
WHERE (pc.id_product = 558) AND (pc.id_shop = 1)
 0.492 ms 1 /classes/Carrier.php:1524
201 
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.483 ms 1 Yes /classes/Product.php:6017
299 
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` = 316
ORDER BY `position`
 0.483 ms 4 Yes /classes/Product.php:3545
362 
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', 'Filtrované položky pro displayFooter: Array\n(\n)\n', '0', '1', NULL, '1', '0', '0', '', '2025-01-13 12:19:11', '2025-01-13 12:19:11')
 0.481 ms 1 /classes/ObjectModel.php:622
319 
SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `ps_category_product` cp
LEFT JOIN `ps_category` c ON (c.id_category = cp.id_category)
LEFT JOIN `ps_category_lang` cl ON (cp.`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 cp.`id_product` IN (558) AND cl.`id_lang` = 1
ORDER BY c.`level_depth` DESC
 0.479 ms 1 Yes /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:109
112 
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` = 558) LIMIT 1
 0.478 ms 1 /src/Adapter/EntityMapper.php:71
99 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-01-13 00:00:00" AND date_to <= "2025-01-13 23:59:59") OR (date_from >= "2025-01-13 00:00:00" AND date_from <= "2025-01-13 23:59:59") OR (date_from < "2025-01-13 00:00:00" AND date_to > "2025-01-13 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 0.471 ms 12 /classes/CartRule.php:357
286 
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` = 726
ORDER BY `position`
 0.471 ms 3 Yes /classes/Product.php:3545
217 
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` = 1035
ORDER BY `position`
 0.466 ms 2 Yes /classes/Product.php:3545
3 
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
 0.465 ms 1 /src/Adapter/EntityMapper.php:71
364 
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 3755525
AND `date_add` > '2025-01-13 11:49:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
 0.465 ms 1 Yes /classes/Connection.php:168
18 
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.463 ms 95 /classes/module/Module.php:345
97 
SELECT SQL_NO_CACHE 1 FROM `ps_cart_rule` WHERE ((date_to >= "2025-01-13 00:00:00" AND date_to <= "2025-01-13 23:59:59") OR (date_from >= "2025-01-13 00:00:00" AND date_from <= "2025-01-13 23:59:59") OR (date_from < "2025-01-13 00:00:00" AND date_to > "2025-01-13 23:59:59")) AND `id_customer` IN (0,0) LIMIT 1
 0.463 ms 12 /classes/CartRule.php:357
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` = 315
ORDER BY `position`
 0.462 ms 4 Yes /classes/Product.php:3545
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.457 ms 1 Yes /classes/shop/Shop.php:1364
145 
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.452 ms 2 /classes/Currency.php:1136
86 
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` = 558 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` = 558 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
 0.451 ms 0 /classes/Cart.php:1426
272 
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` = 590
ORDER BY `position`
 0.450 ms 2 Yes /classes/Product.php:3545
224 
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` = 315)
 0.436 ms 1 /classes/Product.php:3860
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.435 ms 1 /classes/Language.php:1080
47 
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 ('51743' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '51743')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
 0.434 ms 1 /classes/tax/TaxRulesTaxManager.php:109
146 
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_languageselector" LIMIT 1
 0.427 ms 1 /classes/module/Module.php:2636
108 
SELECT SQL_NO_CACHE *
FROM `ps_category` a0
LEFT JOIN `ps_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 6) AND (a0.`nright` > 7) AND (a1.`id_lang` = 1) AND (a1.`id_shop` = 1)
ORDER BY a0.`nleft` asc
 0.423 ms 4 /classes/PrestaShopCollection.php:383
363 
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.423 ms 1 /classes/ObjectModel.php:622