ZS7M400MU SE-ST14 V1R737 oldalstabilizáló készlet
search
  • ZS7M400MU SE-ST14 V1R737 oldalstabilizáló készlet

ZS7M400MU SE-ST14 V1R737 oldalstabilizáló készlet

20,96 €

(20,96 € / garnitúra)

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

Kompatibilis a MOVENTO BLUMOTION és MOVENTO TIP-ON fiókokhoz.

250-400mm-es névleges méretű sínekhez alkalmazható, maximum 1400mm korpuszszélességig.

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.

ZS7M400MU
Hozzászólások (0)
Load Time 520 ms
Querying Time 270 ms
Queries 1347
Memory Peak Usage 53.9 Mb
Included Files 870 files - 8.62 Mb
PrestaShop Cache - Mb
Global vars 0.29 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 9 ms 9 ms 3.60 Mb 3.6 Mb
__construct 6 ms 15 ms 1.80 Mb 6.2 Mb
init 53 ms 67 ms 3.73 Mb 9.2 Mb
checkAccess 0 ms 67 ms - Mb 9.2 Mb
setMedia 3 ms 70 ms 0.66 Mb 9.8 Mb
postProcess 0 ms 70 ms - Mb 9.8 Mb
initHeader 0 ms 70 ms - Mb 9.8 Mb
initContent 35 ms 105 ms 3.59 Mb 13.4 Mb
initFooter 0 ms 105 ms - Mb 13.4 Mb
display 415 ms 520 ms 40.30 Mb 53.9 Mb
Hook Time Memory Usage
displayFooterProduct 382 ms 36.14 Mb
displayProductListReviews 19 ms 0.16 Mb
DisplayHeader 6 ms 1.52 Mb
FilterProductContent 5 ms 0.44 Mb
DisplayFooterProduct 4 ms 0.25 Mb
displayTop 4 ms 0.55 Mb
ActionDispatcherBefore 2 ms 0.01 Mb
displayNav2 2 ms 0.41 Mb
ActionFrontControllerAfterInit 2 ms 0.01 Mb
Header 2 ms 0.26 Mb
displayFooter 2 ms 0.11 Mb
displayNav1 1 ms 0.07 Mb
DisplayFooter 1 ms 0.05 Mb
ActionFrontControllerSetMedia 1 ms 0.31 Mb
displayFooterBefore 1 ms 0.05 Mb
displayProductAdditionalInfo 1 ms 0.13 Mb
Footer 1 ms 0.08 Mb
DisplayProductActions 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
DisplayProductAdditionalInfo 0 ms - Mb
20 hook(s) 435 ms 40.55 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 29 ms 1.26 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.33 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 75 ms 7.69 Mb
ps_categoryproducts 307 ms 28.48 Mb
ps_socialfollow 1 ms 0.07 Mb
ps_linklist 1 ms 0.10 Mb
21 module(s) 439 ms 41.27 Mb

Stopwatch SQL - 1347 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
24495 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
4942 ms 1225 /classes/Category.php:986
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `prs_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `prs_hook_alias` ha
INNER JOIN `prs_hook` h ON ha.name = h.name
1603 ms 0 /classes/Hook.php:1233
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `prs_configuration` c
LEFT JOIN `prs_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
1587 ms 603 /classes/Configuration.php:160
SELECT SQL_NO_CACHE DISTINCT od.product_id
FROM prs_order_detail od
LEFT JOIN prs_product p ON (p.id_product = od.product_id)
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)LEFT JOIN `prs_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
LEFT JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1 AND product_attribute_shop.`default_on` = 1)
LEFT JOIN prs_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = IFNULL(`product_attribute_shop`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN prs_product_lang pl ON (pl.id_product = od.product_id AND pl.id_shop = 1 )
LEFT JOIN prs_category_lang cl ON (cl.id_category = product_shop.id_category_default AND cl.id_shop = 1 )
LEFT JOIN prs_image i ON (i.id_product = od.product_id)
LEFT JOIN `prs_category_product` cp ON (cp.`id_category` = product_shop.id_category_default AND cp.id_product = product_shop.id_product)
LEFT JOIN `prs_category_group` cg ON (cp.`id_category` = cg.`id_category`)
WHERE od.id_order IN (3410,4045)
AND pl.id_lang = 3
AND cl.id_lang = 3
AND od.product_id NOT IN (7146)
AND i.cover = 1
AND product_shop.active = 1
AND cg.`id_group` =1
ORDER BY RAND()
LIMIT 8
1469 ms 17 Yes /modules/ps_crossselling/ps_crossselling.php:307
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`
1125 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
936 ms 230 /classes/Hook.php:494
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2022-05-16 00:00:00",
INTERVAL 360 DAY
)
) > 0 AS new
FROM `prs_accessory`
LEFT JOIN `prs_product` p ON p.`id_product` = `id_product_2`
INNER JOIN prs_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `prs_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `prs_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 
)
LEFT JOIN `prs_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 
)
LEFT JOIN `prs_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `prs_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3)
LEFT JOIN `prs_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN prs_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 7146 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
742 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` = 21016
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
662 ms 5 Yes /classes/Pack.php:350
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` = 7146
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
656 ms 1 Yes Yes /classes/Product.php:4541
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` = 91656
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
618 ms 6 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` = 21125
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
617 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` = 20940
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
602 ms 4 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
596 ms 7 Yes Yes /classes/Category.php:919
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prs_hook`
596 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` = 91628
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
595 ms 6 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` = 21199
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
591 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` = 21002
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
589 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` = 21206
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
583 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` = 20865
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
576 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` = 20905
GROUP BY a.`id_product_item`, a.`id_product_attribute_item`
572 ms 4 Yes /classes/Pack.php:350
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
471 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 = 7385
LIMIT 1
467 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
465 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 = 21016
LIMIT 1
448 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
432 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 = 6553
LIMIT 1
411 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 = 91628
LIMIT 1
406 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` = 7146) AND (b.`id_shop` = 1) LIMIT 1
404 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 = 20905
LIMIT 1
402 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6581) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
399 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *, ( 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
398 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
397 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (21199) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
397 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 20865
LIMIT 1
396 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` = 6895 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` = 6895 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
392 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 = 6715
LIMIT 1
390 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
389 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 = 21206
LIMIT 1
388 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
388 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 6895
LIMIT 1
386 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 = 21125
LIMIT 1
384 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 = 21199
LIMIT 1
381 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
380 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE 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 = 6525
LIMIT 1
379 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 = 92028
LIMIT 1
378 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 = 92027
LIMIT 1
377 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 = 91656
LIMIT 1
377 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6895) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
376 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7386
LIMIT 1
373 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 = 7359
LIMIT 1
373 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 = 20940
LIMIT 1
372 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 6492
LIMIT 1
372 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7153
LIMIT 1
371 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
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
371 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 = 7152
LIMIT 1
370 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 = 6556
LIMIT 1
370 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
369 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
368 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` = 20940) AND (b.`id_shop` = 1) LIMIT 1
368 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
367 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `prs_attribute` a
LEFT JOIN `prs_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `prs_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `prs_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `prs_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN prs_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 7146
366 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` = 21016 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` = 21016 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
366 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 (21125) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
365 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
365 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
363 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
362 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE 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 (20940) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
362 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6525) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
362 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 7117
LIMIT 1
362 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
362 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` = 7385 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` = 7385 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 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` = 7146 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` = 7146 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`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
361 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
360 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
359 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
358 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
358 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-05-16 00:00:00',
INTERVAL 360 DAY
)
) > 0) as new
FROM prs_product p
LEFT JOIN prs_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN prs_stock_available sa
ON sa.id_product = p.id_product
AND sa.id_shop = 1
LEFT JOIN prs_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 1
WHERE p.id_product = 6581
LIMIT 1
358 ms 1 /classes/ProductAssembler.php:95
SELECT SQL_NO_CACHE active
FROM `prs_hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
357 ms 0 /classes/Hook.php:1270
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 *, ( 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 *, ( 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 *, ( 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
353 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (6553) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
352 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
352 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `prs_module` m
LEFT JOIN `prs_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
352 ms 55 /classes/module/Module.php:340
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
351 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
351 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
351 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
351 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
350 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
350 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
350 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
349 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
349 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
349 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
349 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
348 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
348 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
348 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
347 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
347 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
346 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
346 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
346 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
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
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
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
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
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 *, ( 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 *, ( 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 *, ( 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
343 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (91656) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
343 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
343 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
343 ms 9 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `prs_product` a
LEFT JOIN `prs_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `prs_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7146) AND (b.`id_shop` = 1) LIMIT 1
341 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
338 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
338 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
335 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` = 21199 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` = 21199 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
335 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 (21016) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
333 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 142, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `prs_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 142) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-05-16 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
328 ms 16 Yes /classes/SpecificPrice.php:624
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20940 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` = 20940 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` = 20905 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` = 20905 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 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` = 6525 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` = 6525 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
324 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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
324 ms 1 Yes /classes/shop/Shop.php:711
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` = 20865 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` = 20865 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 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` = 21206 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` = 21206 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 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
320 ms 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21125 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` = 21125 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
318 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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` = 21199 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` = 21199 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 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
316 ms 7 Yes Yes /classes/Category.php:1146
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` = 92028 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` = 92028 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 *
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` = 21016) AND (b.`id_shop` = 1) LIMIT 1
316 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` = 21002 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` = 21002 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
315 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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` = 21016 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` = 21016 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
315 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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 (7385) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
313 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE 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` = 7152 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` = 7152 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
311 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 6715 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` = 6715 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
311 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 91628 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` = 91628 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
310 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 6492 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` = 6492 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
309 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20865 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` = 20865 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
307 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 20905 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` = 20905 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
307 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 21002 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` = 21002 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
307 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `prs_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7117 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` = 7117 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` = 91656 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` = 91656 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` = 21125 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` = 21125 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
303 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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` = 7386 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` = 7386 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 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 = 6895
ORDER BY f.position ASC
301 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` = 6556 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` = 6556 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
301 ms 0 /classes/Cart.php:1426
SELECT SQL_NO_CACHE 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` = 20940 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` = 20940 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
300 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` = 7153 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` = 7153 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
300 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` = 21206 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` = 21206 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
299 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 (7359) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
299 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `prs_product_attribute` pa
INNER JOIN prs_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `prs_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `prs_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `prs_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `prs_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (20905) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
298 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE 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` = 6553 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` = 6553 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
297 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` = 7359 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` = 7359 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
296 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` = 6715) AND (b.`id_shop` = 1) LIMIT 1
296 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` = 92027 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` = 92027 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
295 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` = 6581 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` = 6581 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
294 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` = 6556) AND (b.`id_shop` = 1) LIMIT 1
293 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` = 91628 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` = 91628 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
293 ms 0 /classes/Cart.php:1426