LED 2018 Olvasólámpa
search
  • LED 2018 Olvasólámpa
  • LED 2018 Olvasólámpa
  • LED 2018 Olvasólámpa
  • LED 2018 Olvasólámpa

833.74.110 Loox LED 2018 Olvasólámpa

48,77 €

(48,77 € / darab)

Adóval együtt Szállítási határidő: 3-12 munkanap

Meleg fehér fény 3000K.

Teljesítmény: 2W.

Szállítási terjedelem:

  • 1db lámpa
  • 2m vezeték.

DGH.png Tekintse meg ezt a terméket a katalógusban.

Mennyiség

Figyelem!

A Häfele Loox világítástechnikai termékek különleges műszaki paramétereik illetve speciális csatlakozóik miatt kizárólag egymással kapcsolhatóak össze. Mindennemű átalakítás tilos és a garancia automatikus elvesztését jelenti. A rendszer valamennyi eleméről, továbbá felépítésének lehetséges módjairól az online katalógusban részletes információkat talál. Amennyiban kérdése merülne fel, lépjen kapcsolatba ügyfélszolgálatunkkal.

Az oldalon szereplő képek illusztrációként szolgálnak, a termékek kis mértékben eltérhetnek a képeken szereplőktől.

833.74.110

További tartozékok és kiegészítők

Hozzászólások (0)
Load Time 768 ms
Querying Time 583 ms
Queries 727
Memory Peak Usage 35.0 Mb
Included Files 869 files - 8.61 Mb
PrestaShop Cache - Mb
Global vars 0.25 Mb
PrestaShop Version 1.7.8.0
PHP Version 7.2.34
MySQL Version 10.3.34-MariaDB-cll-lve
Memory Limit 1024M
Max Execution Time 300s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 14 ms 14 ms 3.60 Mb 3.6 Mb
__construct 6 ms 20 ms 1.80 Mb 6.2 Mb
init 46 ms 66 ms 3.74 Mb 9.2 Mb
checkAccess 0 ms 66 ms - Mb 9.2 Mb
setMedia 2 ms 69 ms 0.66 Mb 9.8 Mb
postProcess 0 ms 69 ms - Mb 9.8 Mb
initHeader 0 ms 69 ms - Mb 9.8 Mb
initContent 48 ms 117 ms 4.08 Mb 13.9 Mb
initFooter 0 ms 117 ms - Mb 13.9 Mb
display 651 ms 768 ms 20.84 Mb 35.0 Mb
Hook Time Memory Usage
displayFooterProduct 608 ms 16.13 Mb
displayProductListReviews 16 ms 0.12 Mb
DisplayHeader 6 ms 1.53 Mb
DisplayFooterProduct 5 ms 0.25 Mb
FilterProductContent 5 ms 0.44 Mb
displayTop 5 ms 0.55 Mb
ActionDispatcherBefore 2 ms 0.01 Mb
displayNav2 2 ms 0.42 Mb
Header 2 ms 0.25 Mb
displayFooter 2 ms 0.11 Mb
ActionFrontControllerAfterInit 1 ms 0.01 Mb
displayNav1 1 ms 0.07 Mb
ActionFrontControllerSetMedia 1 ms 0.31 Mb
DisplayFooter 1 ms 0.05 Mb
displayProductAdditionalInfo 1 ms 0.13 Mb
displayFooterBefore 1 ms 0.05 Mb
Footer 1 ms 0.08 Mb
DisplayProductActions 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
DisplayProductAdditionalInfo 0 ms - Mb
20 hook(s) 661 ms 20.51 Mb
Module Time Memory Usage
freegeo 5 ms 0.08 Mb
blockwishlist 3 ms 0.43 Mb
ps_emailalerts 0 ms 0.18 Mb
productcomments 27 ms 1.21 Mb
ps_searchbar 2 ms 0.51 Mb
msiliunas_googletagmanager 0 ms 0.04 Mb
ps_googleanalytics 3 ms 0.20 Mb
iseoassist 2 ms 0.34 Mb
ps_shoppingcart 2 ms 0.57 Mb
scrolltop 1 ms 0.23 Mb
myhreflang 1 ms 0.08 Mb
contentprotection 0 ms 0.04 Mb
uecookie 1 ms 0.08 Mb
ps_contactinfo 2 ms 0.13 Mb
ps_mainmenu 5 ms 0.59 Mb
pagesnotfound 0 ms 0.02 Mb
ps_sharebuttons 1 ms 0.15 Mb
ps_crossselling 3 ms 0.15 Mb
ps_categoryproducts 606 ms 16.01 Mb
ps_socialfollow 1 ms 0.07 Mb
ps_linklist 1 ms 0.16 Mb
21 module(s) 666 ms 21.29 Mb

Stopwatch SQL - 727 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2022-05-16 00:00:00",
INTERVAL 360 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `prs_category_product` cp
LEFT JOIN `prs_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `prs_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 prs_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `prs_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 )
LEFT JOIN `prs_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 )
LEFT JOIN `prs_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 `prs_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 3)
LEFT JOIN `prs_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 4 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
249920 ms 36679 Yes /classes/Category.php:1057
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `prs_product` p
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 4 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
192143 ms 36679 /classes/Category.php:986
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `prs_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `prs_hook_alias` ha
INNER JOIN `prs_hook` h ON ha.name = h.name
2071 ms 0 /classes/Hook.php:1233
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 `prs_configuration` c
LEFT JOIN `prs_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1975 ms 603 /classes/Configuration.php:160
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
1674 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE `id_module` FROM `prs_module` WHERE `name` = "ps_mainmenu" LIMIT 1
1653 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `prs_module` m
INNER JOIN prs_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 `prs_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `prs_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `prs_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `prs_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`
1243 ms 86 Yes Yes /classes/Hook.php:1173
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `prs_lang` l
JOIN prs_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
1161 ms 4 /classes/Language.php:1198
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM prs_order_detail od
LEFT JOIN prs_product p ON (p.id_product = od.product_id)
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `prs_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
LEFT JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN prs_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN prs_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN prs_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN prs_image i ON (i.id_product = od.product_id)
LEFT JOIN `prs_category_product` cp ON (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product)
LEFT JOIN `prs_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (5657)
AND pl.id_lang = 3
AND cl.id_lang = 3
AND od.product_id NOT IN (12059)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 8
1099 ms 1 Yes /modules/ps_crossselling/ps_crossselling.php:307
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 21853
LIMIT 1
978 ms 1 /classes/ProductAssembler.php:95
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 `prs_hook_module` hm
STRAIGHT_JOIN `prs_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `prs_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
971 ms 230 /classes/Hook.php:494
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(
"2022-05-16 00:00:00",
INTERVAL 360 DAY
)
) > 0 AS new
FROM `prs_accessory`
LEFT JOIN `prs_product` p ON p.`id_product` = `id_product_2`
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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 `prs_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 
)
LEFT JOIN `prs_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 
)
LEFT JOIN `prs_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 `prs_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3)
LEFT JOIN `prs_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN prs_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` = 12059 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
921 ms 9 Yes /classes/Product.php:4631
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 91209
LIMIT 1
693 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `prs_category` c
INNER JOIN prs_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `prs_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3  AND cl.id_shop = 1 )
LEFT JOIN `prs_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
642 ms 13 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prs_hook`
604 ms 825 /classes/Hook.php:1233
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`
FROM `prs_product_attribute` pa
INNER JOIN prs_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 prs_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 `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `prs_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 12059
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
566 ms 1 Yes Yes /classes/Product.php:4541
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `prs_meta` m
LEFT JOIN `prs_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
457 ms 43 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
445 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
444 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
411 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (57362) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
399 ms 1 Yes Yes /classes/Product.php:4479
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 91209 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 91209 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
398 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12059) AND (b.`id_shop` = 1) LIMIT 1
393 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
388 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
388 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 8286
LIMIT 1
384 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (12674) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
383 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 12873
LIMIT 1
380 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
379 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 57947
LIMIT 1
378 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
378 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 13201
LIMIT 1
376 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
374 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
373 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
373 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
373 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12059) AND (b.`id_shop` = 1) LIMIT 1
372 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7621
LIMIT 1
372 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 24909
LIMIT 1
372 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 12674
LIMIT 1
371 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM prs_shop_url su
LEFT JOIN prs_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'butoralkatreszkft.hu' OR su.domain_ssl = 'butoralkatreszkft.hu')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
370 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7509
LIMIT 1
369 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 91252
LIMIT 1
369 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
368 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 36261
LIMIT 1
368 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 22044
LIMIT 1
368 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
367 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
366 ms 9 Yes /classes/SpecificPrice.php:561
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 prs_shop_group gs
LEFT JOIN prs_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN prs_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
365 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
364 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 92101
LIMIT 1
363 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
362 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
362 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 11768
LIMIT 1
362 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
361 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
358 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 53337
LIMIT 1
355 ms 1 /classes/ProductAssembler.php:95
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 57362 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 57362 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
353 ms 0 /classes/Cart.php:1426
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 `prs_attribute` a
LEFT JOIN `prs_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `prs_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `prs_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN prs_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 prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 12059
352 ms 1 /classes/Product.php:7427
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 91209
ORDER BY `position`
350 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 91209) AND (b.`id_shop` = 1) LIMIT 1
348 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_category` a0
LEFT JOIN `prs_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 145) AND (a0.`nright` > 610) AND (a1.`id_lang` = 3)
ORDER BY a0.`nleft` asc
347 ms 40 Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE tr.*
FROM `prs_tax_rule` tr
JOIN `prs_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 142
AND tr.`id_tax_rules_group` = 20
AND tr.`id_state` IN (0, 0)
AND ('2030' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '2030')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
343 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
339 ms 16 Yes /classes/SpecificPrice.php:624
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12873 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 12873 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
338 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (91209) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
337 ms 1 Yes Yes /classes/Product.php:4479
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12059 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 12059 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
332 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `prs_module` m
LEFT JOIN `prs_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
330 ms 55 /classes/module/Module.php:340
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 11768 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 11768 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
324 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 92101 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 92101 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
323 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12873
ORDER BY f.position ASC
320 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 11768) AND (b.`id_shop` = 1) LIMIT 1
318 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 57386 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 57386 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
316 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53337 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 53337 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
316 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12644 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 12644 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
315 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 57947) AND (b.`id_shop` = 1) LIMIT 1
313 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21853 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 21853 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
313 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 22044 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 22044 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
311 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7509 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 7509 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
310 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12674) AND (b.`id_shop` = 1) LIMIT 1
310 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7621 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 7621 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
310 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13201 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 13201 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
309 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 57947 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 57947 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
307 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 8286 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 8286 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
307 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 91252) AND (b.`id_shop` = 1) LIMIT 1
306 ms 1 /src/Adapter/EntityMapper.php:76
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 24909 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 24909 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
306 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 12674 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 12674 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
306 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 91252 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 91252 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
304 ms 0 /classes/Cart.php:1426
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 cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 36261 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `prs_cart_product` cp JOIN `prs_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prs_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` = 36261 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
301 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (12873) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
298 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12873) AND (b.`id_shop` = 1) LIMIT 1
298 ms 1 /src/Adapter/EntityMapper.php:76
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 `prs_attribute` a
LEFT JOIN `prs_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `prs_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `prs_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN prs_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 prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 12059
298 ms 1 /classes/Product.php:7427
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 91209
ORDER BY f.position ASC
297 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 57386) AND (b.`id_shop` = 1) LIMIT 1
297 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 24909) AND (b.`id_shop` = 1) LIMIT 1
296 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7621) AND (b.`id_shop` = 1) LIMIT 1
296 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7509) AND (b.`id_shop` = 1) LIMIT 1
295 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 57362) AND (b.`id_shop` = 1) LIMIT 1
293 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (36261) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
292 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 92101) AND (b.`id_shop` = 1) LIMIT 1
290 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7509) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
290 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21853) AND (b.`id_shop` = 1) LIMIT 1
289 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12644) AND (b.`id_shop` = 1) LIMIT 1
287 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 8286) AND (b.`id_shop` = 1) LIMIT 1
287 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53337) AND (b.`id_shop` = 1) LIMIT 1
287 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (92101) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
286 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (24909) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
286 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 21853
ORDER BY `position`
284 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13201) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
284 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (11768) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
283 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 36261) AND (b.`id_shop` = 1) LIMIT 1
282 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 91209
AND image_shop.`cover` = 1 LIMIT 1
281 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (21853) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
280 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (91252) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
280 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 57947
ORDER BY `position`
280 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 57947
ORDER BY f.position ASC
280 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (57947) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
278 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (8286) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
278 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13201) AND (b.`id_shop` = 1) LIMIT 1
278 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (22044) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
277 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `prs_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
277 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `prs_category` c
LEFT JOIN `prs_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN prs_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
276 ms 7 Yes Yes /classes/Category.php:1146
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7621) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
275 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 7621
ORDER BY `position`
275 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 57362
ORDER BY f.position ASC
273 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE tr.*
FROM `prs_tax_rule` tr
JOIN `prs_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 142
AND tr.`id_tax_rules_group` = 20
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
273 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 22044) AND (b.`id_shop` = 1) LIMIT 1
271 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13201
ORDER BY f.position ASC
271 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 22044
ORDER BY `position`
269 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 36261
ORDER BY `position`
268 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 12059
ORDER BY `position`
267 ms 4 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53337) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
267 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (57386) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
266 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 92101
ORDER BY `position`
265 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 8286
ORDER BY `position`
264 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `prs_module` m
LEFT JOIN `prs_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
263 ms 55 /classes/module/Module.php:340
SELECT SQL_NO_CACHE *
FROM `prs_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
261 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 92101
ORDER BY f.position ASC
261 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 11768
ORDER BY `position`
258 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 57362
ORDER BY `position`
257 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE domain, domain_ssl
FROM prs_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
256 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12059
ORDER BY f.position ASC
255 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7509
ORDER BY f.position ASC
253 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 57386
ORDER BY `position`
251 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE * FROM `prs_currency` c ORDER BY `iso_code` ASC
251 ms 4 Yes /classes/Currency.php:709
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13201
ORDER BY `position`
251 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 91252
ORDER BY `position`
250 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 12873
ORDER BY `position`
250 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12674
ORDER BY f.position ASC
249 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 24909
ORDER BY `position`
248 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 11768
ORDER BY f.position ASC
247 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 12644
ORDER BY f.position ASC
247 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 24909
ORDER BY f.position ASC
245 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE id_tab, class_name FROM `prs_tab`
245 ms 140 /classes/Tab.php:359
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 12674
ORDER BY `position`
245 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 8286
ORDER BY f.position ASC
245 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 7509
ORDER BY `position`
245 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `prs_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 53337
ORDER BY `position`
243 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 57386
ORDER BY f.position ASC
243 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 36261
ORDER BY f.position ASC
242 ms 1 Yes /classes/Product.php:5897
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 12873)
241 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 91252
ORDER BY f.position ASC
240 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 53337
ORDER BY f.position ASC
239 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 21853
ORDER BY f.position ASC
237 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 7621
ORDER BY f.position ASC
237 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `prs_currency` c
LEFT JOIN prs_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
236 ms 4 /classes/Currency.php:1126
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM prs_feature_product pf
LEFT JOIN prs_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN prs_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN prs_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN prs_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 22044
ORDER BY f.position ASC
233 ms 1 Yes /classes/Product.php:5897
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 13201)
230 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 12059)
228 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM `prs_currency` a
LEFT JOIN `prs_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 3
LEFT JOIN `prs_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
226 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_country` a
LEFT JOIN `prs_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 3
LEFT JOIN `prs_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 142) LIMIT 1
225 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_category` a
LEFT JOIN `prs_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `prs_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 4) AND (b.`id_shop` = 1) LIMIT 1
223 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_manufacturer` a
LEFT JOIN `prs_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 3
LEFT JOIN `prs_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 4) LIMIT 1
222 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE o.id_order
FROM prs_orders o
LEFT JOIN prs_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (12059)
220 ms 1 /modules/ps_crossselling/ps_crossselling.php:251
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 7621)
216 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 91209)
216 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 12674)
214 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 11768)
210 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 91252)
210 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 12873
AND image_shop.`cover` = 1 LIMIT 1
208 ms 1 /classes/Product.php:3533
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 36261)
208 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 57386)
207 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 57947)
206 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 92101)
206 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `name`, `alias` FROM `prs_hook_alias`
205 ms 88 /classes/Hook.php:291
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 24909)
205 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `prs_category_product` cp
INNER JOIN `prs_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 12059 AND ctg.`id_group` = 1 LIMIT 1
205 ms 3 /classes/Product.php:6615
SELECT SQL_NO_CACHE * FROM `prs_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
204 ms 7 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 36261
AND image_shop.`cover` = 1 LIMIT 1
204 ms 3 /classes/Product.php:3533
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 12644)
204 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM prs_product_attribute pa
INNER JOIN prs_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 = 12059 LIMIT 1
203 ms 1 /classes/Product.php:1037
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 53337)
203 ms 1 /classes/Product.php:3820
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 57362)
203 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `prs_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
201 ms 49 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `prs_lang` l
LEFT JOIN `prs_lang_shop` ls ON (l.id_lang = ls.id_lang)
201 ms 2 /classes/Language.php:1049
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 57947
AND image_shop.`cover` = 1 LIMIT 1
200 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 12059
AND image_shop.`cover` = 1 LIMIT 1
199 ms 4 /classes/Product.php:3533
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 `prs_product` p
INNER JOIN `prs_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_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` = 21853)
198 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `prs_image` i
INNER JOIN prs_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 11768
AND image_shop.`cover` = 1 LIMIT 1
197 ms 3 /classes/Product.php:3533