Magic Corner Flex drótkosár szett
search
  • Magic Corner Flex drótkosár szett

546.17.266 Magic Corner Flex drótkosár garnitúra Króm

128,31 €

(128,31 € / garnitúra)

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

Polírozott króm drótkosár garnitúra Magic Corner sarokszekrény vasalathoz.

Ajtóméret: 400 - 500 mm.

Szállítási terjedelem: 

  • 2 darab polc (295 x 470 x 85 mm)
  • 2 darab polc (390 x 470 x 85 mm).

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

Mennyiség

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.

546.17.266

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

Hozzászólások (0)
Load Time 835 ms
Querying Time 624 ms
Queries 761
Memory Peak Usage 35.2 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 20 ms 20 ms 3.60 Mb 3.6 Mb
__construct 9 ms 29 ms 1.80 Mb 6.2 Mb
init 55 ms 84 ms 3.73 Mb 9.2 Mb
checkAccess 0 ms 84 ms - Mb 9.2 Mb
setMedia 3 ms 86 ms 0.66 Mb 9.8 Mb
postProcess 0 ms 86 ms - Mb 9.8 Mb
initHeader 0 ms 86 ms - Mb 9.8 Mb
initContent 72 ms 158 ms 4.33 Mb 14.1 Mb
initFooter 0 ms 158 ms - Mb 14.1 Mb
display 676 ms 835 ms 20.81 Mb 35.2 Mb
Hook Time Memory Usage
displayFooterProduct 636 ms 16.11 Mb
displayProductListReviews 14 ms 0.12 Mb
DisplayHeader 9 ms 1.54 Mb
FilterProductContent 7 ms 0.44 Mb
DisplayFooterProduct 4 ms 0.25 Mb
displayTop 3 ms 0.55 Mb
ActionDispatcherBefore 3 ms 0.01 Mb
Header 2 ms 0.25 Mb
displayNav2 2 ms 0.42 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
displayProductAdditionalInfo 1 ms 0.13 Mb
DisplayFooter 1 ms 0.05 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) 689 ms 20.49 Mb
Module Time Memory Usage
freegeo 6 ms 0.08 Mb
blockwishlist 4 ms 0.43 Mb
ps_emailalerts 0 ms 0.18 Mb
productcomments 26 ms 1.22 Mb
ps_searchbar 2 ms 0.51 Mb
msiliunas_googletagmanager 0 ms 0.04 Mb
ps_googleanalytics 3 ms 0.20 Mb
iseoassist 3 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 3 ms 0.59 Mb
pagesnotfound 0 ms 0.02 Mb
ps_sharebuttons 1 ms 0.15 Mb
ps_crossselling 2 ms 0.12 Mb
ps_categoryproducts 635 ms 16.03 Mb
ps_socialfollow 1 ms 0.07 Mb
ps_linklist 1 ms 0.16 Mb
21 module(s) 694 ms 21.27 Mb

Stopwatch SQL - 761 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
283642 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
185912 ms 36679 /classes/Category.php:986
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`)
2388 ms 603 /classes/Configuration.php:160
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
1977 ms 0 /classes/Hook.php:1233
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`
1402 ms 86 Yes Yes /classes/Hook.php:1173
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` = 11952 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1036 ms 2 Yes /classes/Product.php:4631
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
946 ms 230 /classes/Hook.php:494
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` = 11950
ORDER BY `position`
940 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prs_hook`
831 ms 825 /classes/Hook.php:1233
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute
FROM `prs_product` p
NATURAL LEFT JOIN `prs_product_lang` pl
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_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)
WHERE pl.`id_lang` = 3
AND pl.id_shop = 1 
AND p.`id_product` IN (91941,91942)
GROUP BY p.id_product LIMIT 1
750 ms 2 Yes /classes/Pack.php:434
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
736 ms 13 Yes Yes /classes/Category.php:919
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 = 12725
LIMIT 1
719 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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` = 11952
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
688 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
590 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
578 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image_shop.`id_image` id_image, il.`legend`, cl.`name` AS category_default, a.quantity AS pack_quantity, product_shop.`id_category_default`, a.id_product_pack, a.id_product_attribute_item
FROM `prs_pack` a
LEFT JOIN `prs_product` p ON p.id_product = a.id_product_item
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)
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_lang` cl
ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 
WHERE product_shop.`id_shop` = 1
AND a.`id_product_pack` = 91941
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
565 ms 2 Yes /classes/Pack.php:350
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
559 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
545 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
486 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE * FROM `prs_currency` c ORDER BY `iso_code` ASC
485 ms 4 Yes /classes/Currency.php:709
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
477 ms 9 Yes /classes/SpecificPrice.php:561
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` = 12725 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` = 12725 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
476 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` = 12725) AND (b.`id_shop` = 1) LIMIT 1
470 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
468 ms 9 Yes /classes/SpecificPrice.php:561
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
437 ms 1 Yes /classes/shop/Shop.php:1350
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 (11950) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
433 ms 1 Yes Yes /classes/Product.php:4479
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
430 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` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 11952) AND (b.`id_shop` = 1) LIMIT 1
429 ms 1 /src/Adapter/EntityMapper.php:76
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
427 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`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
423 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` = 11952 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` = 11952 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
422 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` = 12844 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` = 12844 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
422 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` = 11950 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` = 11950 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
419 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` = 91941 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` = 91941 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
412 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` = 22417) AND (b.`id_shop` = 1) LIMIT 1
404 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
403 ms 9 Yes /classes/SpecificPrice.php:561
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` = 11951 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` = 11951 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
401 ms 0 /classes/Cart.php:1426
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 = 22417
LIMIT 1
399 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 = 79129
LIMIT 1
398 ms 1 /classes/ProductAssembler.php:95
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` = 11952) AND (b.`id_shop` = 1) LIMIT 1
392 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
385 ms 9 Yes /classes/SpecificPrice.php:561
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
382 ms 55 /classes/module/Module.php:340
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` = 11950) AND (b.`id_shop` = 1) LIMIT 1
382 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 = 137865
LIMIT 1
381 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
380 ms 9 Yes /classes/SpecificPrice.php:561
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` = 11952
378 ms 1 /classes/Product.php:7427
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` = 91941 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` = 91941 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
377 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` = 12357 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` = 12357 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
377 ms 0 /classes/Cart.php:1426
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
376 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` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 12357) AND (b.`id_shop` = 1) LIMIT 1
376 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` = 12409 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` = 12409 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
375 ms 0 /classes/Cart.php:1426
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
375 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 = 24978
LIMIT 1
375 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
372 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 = 101820
LIMIT 1
372 ms 1 /classes/ProductAssembler.php:95
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
370 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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` = 22417 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` = 22417 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
370 ms 0 /classes/Cart.php:1426
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 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` = 11952
366 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 = 11951
ORDER BY f.position ASC
365 ms 1 Yes /classes/Product.php:5897
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
365 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 = 13956
LIMIT 1
365 ms 1 /classes/ProductAssembler.php:95
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
364 ms 7 Yes Yes /classes/Category.php:1146
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 = 11950
ORDER BY f.position ASC
364 ms 1 Yes /classes/Product.php:5897
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
363 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 = 8539
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) <= 20 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 *
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
360 ms 40 Yes /classes/PrestaShopCollection.php:381
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` = 12844) AND (b.`id_shop` = 1) LIMIT 1
359 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 = 12357
LIMIT 1
359 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 = 12468
LIMIT 1
357 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 = 53239
LIMIT 1
357 ms 1 /classes/ProductAssembler.php:95
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
357 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 = 13927
LIMIT 1
356 ms 1 /classes/ProductAssembler.php:95
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` = 91941) AND (b.`id_shop` = 1) LIMIT 1
355 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
355 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 = 12844
LIMIT 1
355 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
355 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 = 7475
LIMIT 1
351 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 = 13335
LIMIT 1
349 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 = 12409
LIMIT 1
348 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 (12725) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
348 ms 1 Yes Yes /classes/Product.php:4479
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 = 12725
ORDER BY f.position ASC
347 ms 1 Yes /classes/Product.php:5897
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` = 12357
AND image_shop.`cover` = 1 LIMIT 1
347 ms 3 /classes/Product.php:3533
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` = 101820 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` = 101820 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
330 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` = 13927 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` = 13927 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
328 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` = 13335 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` = 13335 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
327 ms 0 /classes/Cart.php:1426
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
326 ms 4 /classes/Language.php:1198
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` = 8466 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` = 8466 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
326 ms 0 /classes/Cart.php:1426
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` = 12725
AND image_shop.`cover` = 1 LIMIT 1
322 ms 2 /classes/Product.php:3533
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` = 53239 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` = 53239 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
320 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` = 137865) AND (b.`id_shop` = 1) LIMIT 1
319 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` = 13956 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` = 13956 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
318 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` = 7475) AND (b.`id_shop` = 1) LIMIT 1
316 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 = 11952
ORDER BY f.position ASC
316 ms 1 Yes /classes/Product.php:5897
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` = 137865 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` = 137865 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` = 13335) AND (b.`id_shop` = 1) LIMIT 1
315 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` = 11951) AND (b.`id_shop` = 1) LIMIT 1
314 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 (11951) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
313 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` = 8466) 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` = 8539 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` = 8539 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 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 = 12844
ORDER BY f.position ASC
309 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 = 91941
ORDER BY f.position ASC
309 ms 1 Yes /classes/Product.php:5897
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` = 79129 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` = 79129 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
308 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` = 12409) AND (b.`id_shop` = 1) LIMIT 1
307 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` = 101820) AND (b.`id_shop` = 1) LIMIT 1
307 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` = 24978 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` = 24978 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 *
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` = 53239) 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` = 12468 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` = 12468 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
303 ms 0 /classes/Cart.php:1426
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` = 12725)
301 ms 1 /classes/Product.php:3820
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` = 79129) AND (b.`id_shop` = 1) LIMIT 1
301 ms 1 /src/Adapter/EntityMapper.php:76
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
301 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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` = 11952
ORDER BY `position`
300 ms 1 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` = 12725
ORDER BY `position`
300 ms 2 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` = 13927) AND (b.`id_shop` = 1) LIMIT 1
299 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
299 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` = 7475 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` = 7475 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
298 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` = 13956) AND (b.`id_shop` = 1) LIMIT 1
298 ms 1 /src/Adapter/EntityMapper.php:76
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
295 ms 55 /classes/module/Module.php:340
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` = 11951
ORDER BY `position`
294 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 = 12357
ORDER BY f.position ASC
293 ms 1 Yes /classes/Product.php:5897
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
292 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `prs_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
289 ms 0 /classes/Hook.php:1270
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` = 8539) AND (b.`id_shop` = 1) LIMIT 1
289 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 = 22417
ORDER BY f.position ASC
288 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` = 12468) AND (b.`id_shop` = 1) LIMIT 1
288 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` = 24978) AND (b.`id_shop` = 1) LIMIT 1
286 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 (13956) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
285 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 (8539) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
285 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 (7475) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
285 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE id_tab, class_name FROM `prs_tab`
284 ms 140 /classes/Tab.php:359
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
282 ms 49 /classes/SpecificPrice.php:287
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 (22417) 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 (24978) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
279 ms 1 Yes Yes /classes/Product.php:4479
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 = 12409
ORDER BY f.position ASC
277 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 (13927) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
276 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 (137865) 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 *
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
274 ms 1 /src/Adapter/EntityMapper.php:76
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` = 11950)
272 ms 1 /classes/Product.php:3820
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 (13335) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
270 ms 1 Yes Yes /classes/Product.php:4479
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` = 11951)
270 ms 1 /classes/Product.php:3820
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 (12409) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
270 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 (79129) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
269 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 (101820) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
269 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM prs_product_attachment pa
LEFT JOIN prs_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN prs_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 11950
269 ms 1 /classes/Product.php:5928
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 (12844) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
268 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 (53239) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
265 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 (12357) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
265 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` = 12468
ORDER BY `position`
264 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 (12468) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
263 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE active
FROM `prs_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
263 ms 0 /classes/Hook.php:1270
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
262 ms 4 /classes/Currency.php:1126
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 91941) LIMIT 1
261 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM prs_shop s
LEFT JOIN prs_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
259 ms 1 /classes/shop/Shop.php:205
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 = 13956
ORDER BY f.position ASC
258 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE `name`, `alias` FROM `prs_hook_alias`
256 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` = 12357)
255 ms 1 /classes/Product.php:3820
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
253 ms 1 /src/Adapter/EntityMapper.php:76
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` = 11952)
252 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE *
FROM prs_product_attachment pa
LEFT JOIN prs_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN prs_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 11952
252 ms 1 /classes/Product.php:5928
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 = 13335
ORDER BY f.position ASC
252 ms 1 Yes /classes/Product.php:5897
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` = 11950
AND image_shop.`cover` = 1 LIMIT 1
249 ms 3 /classes/Product.php:3533
SELECT SQL_NO_CACHE *
FROM prs_product_attachment pa
LEFT JOIN prs_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN prs_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 91941
249 ms 1 /classes/Product.php:5928
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` = 12844)
249 ms 1 /classes/Product.php:3820
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` = 22417
ORDER BY `position`
247 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` = 137865
ORDER BY `position`
246 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 = 8466
ORDER BY f.position ASC
245 ms 1 Yes /classes/Product.php:5897
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` = 22417
AND image_shop.`cover` = 1 LIMIT 1
245 ms 3 /classes/Product.php:3533
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` = 8539
ORDER BY `position`
245 ms 2 Yes /classes/Product.php:3508
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` = 22417)
244 ms 1 /classes/Product.php:3820
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` = 7475
ORDER BY `position`
244 ms 2 Yes /classes/Product.php:3508
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)
244 ms 2 /classes/Language.php:1049
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 = 7475
ORDER BY f.position ASC
243 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM prs_product_attachment pa
LEFT JOIN prs_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN prs_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 13335
242 ms 1 /classes/Product.php:5928
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` = 11951
AND image_shop.`cover` = 1 LIMIT 1
241 ms 2 /classes/Product.php:3533
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 = 53239
ORDER BY f.position ASC
240 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` = 13335
ORDER BY `position`
240 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_order`
FROM `prs_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
239 ms 1 /classes/order/Order.php:1203
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 = 13927
ORDER BY f.position ASC
239 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE * FROM `prs_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
238 ms 7 Yes /classes/ImageType.php:109
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` = 12409
ORDER BY `position`
238 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `prs_group` a
LEFT JOIN `prs_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
237 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 = 137865
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 = 101820
ORDER BY f.position ASC
237 ms 1 Yes /classes/Product.php:5897
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` = 11950 AND ctg.`id_group` = 1 LIMIT 1
236 ms 3 /classes/Product.php:6615
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 = 79129
ORDER BY f.position ASC
235 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` = 13956
ORDER BY `position`
234 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_country`
FROM `prs_country`
WHERE `iso_code` = 'US' LIMIT 1
234 ms 1 /classes/Country.php:193
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 = 8539
ORDER BY f.position ASC
233 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE 1 FROM prs_cart_product cp INNER JOIN prs_product p
ON (p.id_product = cp.id_product) INNER JOIN prs_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
233 ms 1 /classes/Cart.php:4215
SELECT SQL_NO_CACHE *
FROM `prs_lang` a
LEFT JOIN `prs_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 3) LIMIT 1
232 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 = 24978
ORDER BY f.position ASC
232 ms 1 Yes /classes/Product.php:5897
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` = 2) LIMIT 1
232 ms 1 /src/Adapter/EntityMapper.php:76
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` = 11952 AND ctg.`id_group` = 1 LIMIT 1
230 ms 3 /classes/Product.php:6615
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 = 12468
ORDER BY f.position ASC
230 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` = 79129
ORDER BY `position`
229 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` = 24978
ORDER BY `position`
229 ms 2 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM prs_product_attachment pa
LEFT JOIN prs_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN prs_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 11951
229 ms 1 /classes/Product.php:5928
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` = 91941
AND image_shop.`cover` = 1 LIMIT 1
228 ms 4 /classes/Product.php:3533
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` = 3) LIMIT 1
227 ms 1 /src/Adapter/EntityMapper.php:76
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` = 12844
ORDER BY `position`
227 ms 2 Yes /classes/Product.php:3508
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` = 8539)
227 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` = 12844
AND image_shop.`cover` = 1 LIMIT 1
227 ms 2 /classes/Product.php:3533
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` = 12357
ORDER BY `position`
225 ms 3 Yes /classes/Product.php:3508
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` = 8466)
224 ms 1 /classes/Product.php:3820
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` = 13927
ORDER BY `position`
224 ms 3 Yes /classes/Product.php:3508
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` = 0
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
222 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE name, alias FROM `prs_hook_alias`
222 ms 88 /classes/Hook.php:343
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` = 101820
ORDER BY `position`
220 ms 1 Yes /classes/Product.php:3508
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 (11952)
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` = 91941)
220 ms 1 /classes/Product.php:3820
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` = 53239
ORDER BY `position`
220 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COUNT(p.id_product)
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)
WHERE p.id_product = 11952
AND DATEDIFF("2022-05-16 00:00:00", product_shop.`date_add`) < 360 LIMIT 1
220 ms 0 /classes/Product.php:1647
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `prs_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 1039 LIMIT 1
217 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `prs_module` m
LEFT JOIN `prs_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
217 ms 1 /src/Adapter/Module/ModuleDataProvider.php:174
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 = 11952 LIMIT 1
217 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE `id_country`
FROM `prs_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
216 ms 1 /classes/Country.php:193
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` = 11952
AND image_shop.`cover` = 1 LIMIT 1
216 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` = 101820)
215 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM prs_tag t
LEFT JOIN prs_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=11952
215 ms 1 /classes/Tag.php:229
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` = 12409)
214 ms 1 /classes/Product.php:3820
SELECT SQL_NO_CACHE `id_lang` FROM `prs_lang`
WHERE `locale` = 'hu-hu'
OR `language_code` = 'hu-hu' LIMIT 1
212 ms 2 /classes/Language.php:853
SELECT SQL_NO_CACHE `name`
FROM `prs_hook`
WHERE `id_hook` = 699 LIMIT 1
211 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `prs_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
210 ms 2 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE `id_order`
FROM `prs_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
208 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_order`
FROM `prs_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
206 ms 1 /classes/order/Order.php:1203
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` = 24978)
206 ms 1 /classes/Product.php:3820