ZE7V482G Legrabox belső fiók üvegfront
search
  • ZE7V482G Legrabox belső fiók üvegfront

ZE7V482G Legrabox belső fiók üvegfront

3 683,00 €

(3 683,00 € / darab)

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

Szállítási határidõ 10 munkanap.

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.

Amennyiben segítségre van szüksége, használja a BLUM terméktervező programot vagy keresse írásban ügyfélszolgálatunkat.

ZE7V482G KL
Hozzászólások (0)
Load Time 458 ms
Querying Time 248 ms
Queries 1137
Memory Peak Usage 46.9 Mb
Included Files 868 files - 8.60 Mb
PrestaShop Cache - Mb
Global vars 0.24 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 15 ms 15 ms 3.60 Mb 3.6 Mb
__construct 6 ms 21 ms 1.80 Mb 6.2 Mb
init 45 ms 66 ms 3.73 Mb 9.2 Mb
checkAccess 0 ms 66 ms - Mb 9.2 Mb
setMedia 2 ms 68 ms 0.66 Mb 9.8 Mb
postProcess 0 ms 68 ms - Mb 9.8 Mb
initHeader 0 ms 68 ms - Mb 9.8 Mb
initContent 35 ms 103 ms 3.60 Mb 13.4 Mb
initFooter 0 ms 103 ms - Mb 13.4 Mb
display 354 ms 458 ms 33.23 Mb 46.9 Mb
Hook Time Memory Usage
displayFooterProduct 322 ms 29.10 Mb
displayProductListReviews 13 ms 0.13 Mb
DisplayHeader 6 ms 1.53 Mb
FilterProductContent 5 ms 0.44 Mb
DisplayFooterProduct 4 ms 0.25 Mb
displayTop 4 ms 0.55 Mb
ActionDispatcherBefore 3 ms 0.01 Mb
displayNav2 2 ms 0.41 Mb
Header 2 ms 0.26 Mb
displayFooter 1 ms 0.11 Mb
ActionFrontControllerAfterInit 1 ms 0.01 Mb
displayNav1 1 ms 0.07 Mb
ActionFrontControllerSetMedia 1 ms 0.31 Mb
DisplayFooter 1 ms 0.05 Mb
displayProductAdditionalInfo 1 ms 0.13 Mb
displayFooterBefore 1 ms 0.05 Mb
Footer 1 ms 0.08 Mb
DisplayProductActions 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
DisplayProductAdditionalInfo 0 ms - Mb
20 hook(s) 368 ms 33.50 Mb
Module Time Memory Usage
freegeo 5 ms 0.08 Mb
blockwishlist 3 ms 0.43 Mb
ps_emailalerts 0 ms 0.18 Mb
productcomments 22 ms 1.23 Mb
ps_searchbar 2 ms 0.51 Mb
msiliunas_googletagmanager 0 ms 0.04 Mb
ps_googleanalytics 3 ms 0.20 Mb
iseoassist 2 ms 0.34 Mb
ps_shoppingcart 2 ms 0.55 Mb
scrolltop 1 ms 0.24 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 320 ms 29.02 Mb
ps_socialfollow 1 ms 0.07 Mb
ps_linklist 1 ms 0.16 Mb
21 module(s) 373 ms 34.27 Mb

Stopwatch SQL - 1137 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` = 3 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
25216 ms 1225 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` = 3 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
4502 ms 1225 /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`)
1723 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
1554 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`
1024 ms 86 Yes Yes /classes/Hook.php:1173
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
980 ms 230 /classes/Hook.php:494
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` = 20895
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
950 ms 4 Yes /classes/Pack.php:350
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` = 21265
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
904 ms 5 Yes /classes/Pack.php:350
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` = 20988
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
834 ms 5 Yes /classes/Pack.php:350
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` = 20948
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
767 ms 4 Yes /classes/Pack.php:350
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` = 7377 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
750 ms 1 Yes /classes/Product.php:4631
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` = 21274
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
656 ms 5 Yes /classes/Pack.php:350
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` = 21167
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
644 ms 4 Yes /classes/Pack.php:350
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` = 21294
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
634 ms 5 Yes /classes/Pack.php:350
SELECT SQL_NO_CACHE `reduction`
FROM `prs_product_group_reduction_cache`
WHERE `id_product` = 7185 AND `id_group` = 1 LIMIT 1
618 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE SUM(quantity)
FROM `prs_stock_available`
WHERE (id_product = 7230) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
612 ms 1 /classes/stock/StockAvailable.php:453
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` = 20991
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
612 ms 5 Yes /classes/Pack.php:350
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` = 3
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
608 ms 7 Yes Yes /classes/Category.php:919
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` = 21092
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
600 ms 4 Yes /classes/Pack.php:350
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` = 21100
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
592 ms 4 Yes /classes/Pack.php:350
SELECT SQL_NO_CACHE `id_country`
FROM `prs_country`
WHERE `iso_code` = 'US' LIMIT 1
586 ms 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prs_hook`
581 ms 825 /classes/Hook.php:1233
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` = 21207
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
569 ms 4 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
554 ms 9 Yes /classes/SpecificPrice.php:561
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` = 7377
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
547 ms 1 Yes Yes /classes/Product.php:4541
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
535 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
518 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` = 7328) AND (b.`id_shop` = 1) LIMIT 1
500 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
494 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
490 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` = 20991 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` = 20991 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
488 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
477 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
477 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
476 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
475 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
475 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
474 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
474 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
473 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
468 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) <= 2 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 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` = 21265 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` = 21265 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
465 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
464 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 = 20988
LIMIT 1
462 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM prs_shop_url su
LEFT JOIN prs_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'butoralkatreszkft.hu' OR su.domain_ssl = 'butoralkatreszkft.hu')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
461 ms 1 Yes /classes/shop/Shop.php:1350
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
460 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
458 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
458 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 = 21100
LIMIT 1
456 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
452 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 = 7258
LIMIT 1
452 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
451 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 = 21265
LIMIT 1
444 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
437 ms 9 Yes /classes/SpecificPrice.php:561
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
437 ms 43 Yes /classes/Dispatcher.php:643
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 = 21604
LIMIT 1
434 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
430 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` = 21604 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` = 21604 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
423 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` = 21274 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` = 21274 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
420 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
408 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 = 7189
LIMIT 1
402 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
400 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 = 20948
LIMIT 1
400 ms 1 /classes/ProductAssembler.php:95
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 = 20988
ORDER BY f.position ASC
395 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` = 20948 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` = 20948 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
395 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 = 21167
LIMIT 1
392 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20895 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` = 20895 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
390 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` = 20895) AND (b.`id_shop` = 1) LIMIT 1
388 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 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 = 21274
LIMIT 1
385 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 = 6439
LIMIT 1
384 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20895 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` = 20895 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
383 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` = 21265 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` = 21265 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
382 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
380 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` = 20948) AND (b.`id_shop` = 1) LIMIT 1
380 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` = 78977) AND (b.`id_shop` = 1) LIMIT 1
380 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` = 7377) AND (b.`id_shop` = 1) LIMIT 1
379 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` = 78975) AND (b.`id_shop` = 1) LIMIT 1
378 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
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` = 20988) AND (b.`id_shop` = 1) LIMIT 1
375 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` = 7258 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` = 7258 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
374 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
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
372 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
371 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
367 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
367 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 = 20991
LIMIT 1
366 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
365 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` = 7189 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` = 7189 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
365 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
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 = 20895
LIMIT 1
363 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 = 21092
LIMIT 1
363 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
363 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` = 20988 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` = 20988 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
363 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
362 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
361 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` = 20988 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` = 20988 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
361 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`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
361 ms 16 Yes /classes/SpecificPrice.php:624
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 = 21294
LIMIT 1
359 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
357 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
357 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
356 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
355 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` = 21265) AND (b.`id_shop` = 1) LIMIT 1
354 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
354 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 = 7301
LIMIT 1
353 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` = 7258) AND (b.`id_shop` = 1) LIMIT 1
352 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 = 21207
LIMIT 1
351 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
350 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` = 21604) AND (b.`id_shop` = 1) LIMIT 1
349 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
349 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` = 7237) AND (b.`id_shop` = 1) LIMIT 1
349 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` = 7185) AND (b.`id_shop` = 1) LIMIT 1
349 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
348 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` = 20948 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` = 20948 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
346 ms 0 /classes/Cart.php:1426
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
346 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
346 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` = 7338) AND (b.`id_shop` = 1) LIMIT 1
345 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
345 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
344 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` = 7161) AND (b.`id_shop` = 1) LIMIT 1
342 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
342 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` = 78978) AND (b.`id_shop` = 1) LIMIT 1
342 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `prs_attribute` a
LEFT JOIN `prs_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `prs_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `prs_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 7377
342 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` = 7377 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` = 7377 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
341 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` = 7238) AND (b.`id_shop` = 1) LIMIT 1
339 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` = 1
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7377) AND (b.`id_shop` = 1) LIMIT 1
336 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
335 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` = 7329) AND (b.`id_shop` = 1) LIMIT 1
334 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` = 7166) AND (b.`id_shop` = 1) LIMIT 1
333 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 = 20895
ORDER BY f.position ASC
332 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` = 7300) AND (b.`id_shop` = 1) LIMIT 1
332 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` = 21294 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` = 21294 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
331 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` = 21167 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` = 21167 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` = 21100 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` = 21100 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 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` = 21100 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` = 21100 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 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 (7189) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
323 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20991 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` = 20991 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
322 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` = 21092 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` = 21092 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
321 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` = 6439) 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` = 154612 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` = 154612 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
317 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` = 6439 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` = 6439 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
316 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21092 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` = 21092 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
314 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` = 21167 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` = 21167 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
310 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7189) AND (b.`id_shop` = 1) LIMIT 1
307 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 = 7258
ORDER BY f.position ASC
307 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` = 21207 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` = 21207 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
306 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21207 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` = 21207 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
305 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` = 21274 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` = 21274 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
304 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21294 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` = 21294 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
304 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7301 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` = 7301 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
302 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` = 7294) AND (b.`id_shop` = 1) LIMIT 1
302 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 ('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
301 ms 1 /classes/tax/TaxRulesTaxManager.php:109
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 = 21265
ORDER BY f.position ASC
298 ms 1 Yes /classes/Product.php:5897
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` = 20948) LIMIT 1
298 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 = 20948
ORDER BY f.position ASC
297 ms 1 Yes /classes/Product.php:5897
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21274) AND (b.`id_shop` = 1) LIMIT 1
296 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `prs_attribute` a
LEFT JOIN `prs_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `prs_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `prs_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 7377
296 ms 1 /classes/Product.php:7427
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` = 7222) AND (b.`id_shop` = 1) LIMIT 1
295 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` = 21265
ORDER BY `position`
294 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21100) AND (b.`id_shop` = 1) LIMIT 1
293 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 = 21604
ORDER BY f.position ASC
292 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` = 21274
ORDER BY `position`
292 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21167) AND (b.`id_shop` = 1) LIMIT 1
290 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
290 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` = 20991) AND (b.`id_shop` = 1) LIMIT 1
290 ms 1 /src/Adapter/EntityMapper.php:76
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
288 ms 7 Yes Yes /classes/Category.php:1146
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` = 21092) 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_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 20895) LIMIT 1
287 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 21207) AND (b.`id_shop` = 1) LIMIT 1
285 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` = 7199) AND (b.`id_shop` = 1) LIMIT 1
284 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
284 ms 55 /classes/module/Module.php:340
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 (21167) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
283 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 154612) AND (b.`id_shop` = 1) LIMIT 1
283 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 (21294) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
282 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` = 20988
ORDER BY `position`
282 ms 3 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7155) AND (b.`id_shop` = 1) LIMIT 1
281 ms 1 /src/Adapter/EntityMapper.php:76