Question ? +32 (0)4 228 89 40 ou webmaster@bruyerre.be

Panier 0

Pièces montées et accessoires

Filtrer

Prix
Fabricants
Filtrer

Il y a 35 produits.

Affichage 1-12 de 35 article(s)

Produits populaires

Load Time 12273 ms
Querying Time 11868 ms
Queries 1667
Memory Peak Usage 64.7 Mb
Included Files 1082 files - 15.80 Mb
PrestaShop Cache - Mb
Global vars 1.33 Mb
PrestaShop Version 1.7.8.8
PHP Version 7.4.23
MySQL Version 10.6.16-MariaDB
Memory Limit 1024M
Max Execution Time 1200s
Smarty Cache enabled
Smarty Compilation never recompile
  Time Cumulated Time Memory Usage Memory Peak Usage
config 3 ms 3 ms 4.31 Mb 4.3 Mb
__construct 0 ms 3 ms - Mb 4.3 Mb
init 10 ms 13 ms 1.23 Mb 5.8 Mb
checkAccess 0 ms 13 ms - Mb 5.8 Mb
setMedia 3 ms 17 ms 0.48 Mb 6.1 Mb
postProcess 0 ms 17 ms - Mb 6.1 Mb
initHeader 0 ms 17 ms - Mb 6.1 Mb
initContent 9759 ms 9775 ms 7.94 Mb 64.7 Mb
initFooter 0 ms 9775 ms - Mb 64.7 Mb
display 2497 ms 12273 ms 35.57 Mb 64.7 Mb
Hook Time Memory Usage
displayPrimaryNav 1883 ms 30.32 Mb
DisplayHeader 424 ms 1.74 Mb
displayNewProducts 410 ms 0.13 Mb
DisplayProductAdditionalInfo 97 ms 3.07 Mb
DisplayBeforeBodyClosingTag 46 ms 0.23 Mb
displayCart 9 ms 0.07 Mb
displayTopLeft 7 ms 0.10 Mb
DisplayAmazzingFilter 6 ms 0.23 Mb
displayBrandList 3 ms - Mb
displayFooterCard4 3 ms 0.07 Mb
displayFooterCard1 3 ms 0.05 Mb
displaySearch 3 ms 0.04 Mb
DisplayHeaderCategory 3 ms 0.09 Mb
displayTopRight 2 ms 0.05 Mb
displayFeaturedProducts 2 ms 0.08 Mb
Header 1 ms 0.03 Mb
ActionFrontControllerSetMedia 1 ms 0.01 Mb
displayMobileTop 0 ms 0.02 Mb
displayFooterCard3 0 ms 0.02 Mb
DisplayProductPriceBlock 0 ms - Mb
displayBottomRight 0 ms 0.01 Mb
DisplayTop 0 ms - Mb
ModuleRoutes 0 ms 0.01 Mb
DisplayFooter 0 ms - Mb
DisplayFooterCategory 0 ms - Mb
ProductSearchProvider 0 ms - Mb
ActionFrontControllerInitAfter 0 ms - Mb
ActionObjectAddAfter 0 ms - Mb
28 hook(s) 2906 ms 36.38 Mb
Module Time Memory Usage
prestablog 3 ms 0.40 Mb
ets_abandonedcart 8 ms 0.51 Mb
gsnippetsreviews 5 ms 0.38 Mb
bruyerre_inscription 1 ms 0.25 Mb
ps_emailsubscription 3 ms 0.08 Mb
ps_facebook 7 ms 0.01 Mb
blockreassurance 0 ms 0.09 Mb
ps_emailalerts 0 ms 0.04 Mb
nxtalwishlist 4 ms 0.25 Mb
ps_socialfollow 5 ms 0.13 Mb
thpdfviewer 1 ms 0.05 Mb
ps_imageslider 0 ms 0.03 Mb
ps_accounts 0 ms 0.08 Mb
ps_searchbar 3 ms 0.11 Mb
ps_shoppingcart 10 ms 0.16 Mb
amazzingfilter 416 ms 1.50 Mb
bpostshm 2 ms 0.06 Mb
totshowmailalerts 1 ms 0.11 Mb
bruyerre_facture 0 ms 0.02 Mb
creatixnosingleviewforgiftcard 0 ms 0.02 Mb
bruyerre_combinationcustomfields 95 ms 3.07 Mb
psproductstats 1 ms 0.02 Mb
giftcard 1 ms 0.45 Mb
ps_languageselector 3 ms 0.02 Mb
ps_linklist 3 ms 0.11 Mb
ps_mainmenu 1883 ms 30.35 Mb
ps_featuredproducts 2 ms 0.10 Mb
ps_newproducts 410 ms 0.15 Mb
ps_brandlist 4 ms 0.02 Mb
ps_contactinfo 3 ms 0.08 Mb
statsdata 45 ms 0.20 Mb
cartmultistore 0 ms - Mb
32 module(s) 2918 ms 38.85 Mb

Stopwatch SQL - 1667 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product_attribute` FROM `bru21_specific_price` WHERE `id_product_attribute` != 0 GROUP BY id_product ) AS counted LIMIT 1
6596690 ms 2224272679903 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE COUNT(*) FROM (SELECT DISTINCT `id_product` FROM `bru21_specific_price` WHERE `id_product` != 0 GROUP BY id_product ) AS counted LIMIT 1
1708577 ms 574465024 /classes/SpecificPrice.php:287
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 30941
LIMIT 1
424468 ms 6 /classes/ProductAssembler.php:106
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,
(DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2023-12-05 00:00:00",
INTERVAL 1 DAY
)
) > 0) as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `bru21_product` p
INNER JOIN bru21_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `bru21_product_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 2 
LEFT JOIN `bru21_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=2
LEFT JOIN `bru21_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1
LEFT JOIN `bru21_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `bru21_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=2
LEFT JOIN bru21_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 2  AND stock.id_shop_group = 0  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2023-12-05 00:00:00",
INTERVAL 1 DAY
)
) > 0) AND (EXISTS(SELECT 1 FROM `bru21_category_product` cp
JOIN `bru21_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1)
WHERE cp.`id_product` = p.`id_product`))
ORDER BY product_shop.`date_add` DESC
LIMIT 4
395220 ms 217326564 Yes /classes/Product.php:3088
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 212 AND `id_shop` = 2
323354 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE i.id_product AS id, c, a, f, g,
m,
p_1_1 AS p
FROM `bru21_af_index` i
WHERE (i.id_shop = 2) AND (v <> 2) AND (FIND_IN_SET(507, i.c) > 0)
204454 ms 43130 /modules/amazzingfilter/amazzingfilter.php:491
SELECT SQL_NO_CACHE c.*, cl.*
FROM `bru21_category` c
INNER JOIN bru21_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 2)
LEFT JOIN `bru21_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = 2 
LEFT JOIN `bru21_category_group` cg ON c.`id_category` = cg.`id_category`
RIGHT JOIN `bru21_category` c2 ON c2.`id_category` = 2 AND c.`nleft` >= c2.`nleft` AND c.`nright` <= c2.`nright`
WHERE 1  AND `id_lang` = 1
AND cg.`id_group` IN (1)
GROUP BY c.`id_category`
ORDER BY c.`level_depth` ASC
, category_shop.`position` ASC
22131 ms 567 Yes Yes /classes/Category.php:793
INSERT INTO `bru21_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
21116 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `bru21_product` p
INNER JOIN `bru21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `bru21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 30941)
20053 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE m.id_manufacturer as id, name
FROM bru21_manufacturer m
INNER JOIN bru21_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 2)
WHERE active = 1 ORDER BY name ASC
17747 ms 996 Yes /modules/amazzingfilter/amazzingfilter.php:3146
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `bru21_product_attribute` pa
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.`id_product_attribute` = 41809 LIMIT 1
16338 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE `id_page`
FROM `bru21_page`
WHERE `id_page_type` = 6 AND `id_object` = 507 LIMIT 1
15968 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `bru21_cart_product` cp
WHERE cp.`id_product_attribute` = 41794
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 31351 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `bru21_cart_product` cp JOIN `bru21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `bru21_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 41794
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 31351 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
15707 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 593) LIMIT 1
15294 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `bru21_module` m
INNER JOIN bru21_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 2 AND module_shop.enable_device & 1)
INNER JOIN `bru21_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `bru21_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `bru21_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `bru21_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 2) AND (mg.id_shop = 2 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
14755 ms 780 Yes Yes /classes/Hook.php:1183
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 152) LIMIT 1
12823 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 176) LIMIT 1
12572 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_product_attribute_lang`
WHERE `id_product_attribute` = 44957
11924 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 158 AND `id_shop` = 2
11180 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 359) LIMIT 1
10602 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 183 AND `id_shop` = 2
10223 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE id_product AS id, position FROM bru21_category_product
WHERE id_category = 507
10099 ms 35 /modules/amazzingfilter/amazzingfilter.php:5454
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 652) LIMIT 1
9965 ms 1 /src/Adapter/EntityMapper.php:76
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 `bru21_hook_module` hm
STRAIGHT_JOIN `bru21_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 2)
STRAIGHT_JOIN `bru21_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
9581 ms 442 /classes/Hook.php:504
SELECT SQL_NO_CACHE p.*, product_shop.*, pl.*, image.id_image, il.legend, m.name AS manufacturer_name,
product_shop.date_add > '2023-12-04 19:44:43' AS new
FROM bru21_product p
INNER JOIN bru21_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 2)
INNER JOIN bru21_product_lang pl
ON (pl.id_product = p.id_product AND pl.id_shop = 2 
AND pl.id_lang = 1)
LEFT JOIN bru21_image image
ON (image.id_product = p.id_product AND image.cover = 1)
LEFT JOIN bru21_image_lang il
ON (il.id_image = image.id_image AND il.id_lang = 1)
LEFT JOIN bru21_manufacturer m
ON m.id_manufacturer = p.id_manufacturer
WHERE p.id_product IN (30941,30942,30943,31351,31359,34545,34554,34976,34977,34978,35243,35247)
9354 ms 12 /modules/amazzingfilter/amazzingfilter.php:5568
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `bru21_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 34545 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 48830) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-05 19:44:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-05 19:44: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
9059 ms 5 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 508) LIMIT 1
8539 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 122 AND `id_shop` = 2
8427 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 642) LIMIT 1
8310 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 312) LIMIT 1
8028 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(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 35243
LIMIT 1
7916 ms 4 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 214) LIMIT 1
7834 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 570) LIMIT 1
7802 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 137 AND `id_shop` = 2
7765 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 34976
LIMIT 1
7507 ms 6 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 282 AND `id_shop` = 2
7423 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE location
FROM `bru21_stock_available`
WHERE (id_product = 35243) AND (id_product_attribute = 49751) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
7336 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE `id_module` FROM `bru21_module` WHERE `name` = "ps_shoppingcart" LIMIT 1
7048 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 236) LIMIT 1
6956 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 368) LIMIT 1
6937 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 461 AND `id_shop` = 2
6929 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `bru21_image` i
INNER JOIN bru21_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
LEFT JOIN `bru21_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 30941
ORDER BY `position`
6920 ms 1 Yes /classes/Product.php:3517
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 101) LIMIT 1
6790 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(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 30942
LIMIT 1
6541 ms 6 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 604 AND `id_shop` = 2
6491 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 129 AND `id_shop` = 2
6342 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 528 AND `id_shop` = 2
6186 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_product_attribute_lang`
WHERE `id_product_attribute` = 49417
6136 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 567) LIMIT 1
6114 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 562 AND `id_shop` = 2
6038 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `bru21_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `bru21_hook_alias` ha
INNER JOIN `bru21_hook` h ON ha.name = h.name
6028 ms 0 /classes/Hook.php:1243
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 464 AND `id_shop` = 2
5986 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 283 AND `id_shop` = 2
5926 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 634 AND `id_shop` = 2
5898 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 458 AND `id_shop` = 2
5853 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 501 AND `id_shop` = 2
5798 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `bru21_product` p
INNER JOIN `bru21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `bru21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 30942)
5772 ms 1 /classes/Product.php:3829
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 568 AND `id_shop` = 2
5667 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM bru21_feature_product pf
LEFT JOIN bru21_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1)
LEFT JOIN bru21_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN bru21_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN bru21_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 2)
WHERE pf.id_product = 30943
ORDER BY f.position ASC
5481 ms 1 Yes /classes/Product.php:5905
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 697) LIMIT 1
5470 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(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 34545
LIMIT 1
5428 ms 4 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `bru21_product` a
LEFT JOIN `bru21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 30941) LIMIT 1
5390 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `bru21_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 2 
AND cl.`id_category` = 507 LIMIT 1
5298 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 566) LIMIT 1
5258 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 160 AND `id_shop` = 2
5210 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `bru21_image` i
INNER JOIN bru21_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 31359
AND image_shop.`cover` = 1 LIMIT 1
5085 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 358 AND `id_shop` = 2
4926 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 166 AND `id_shop` = 2
4904 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 462 AND `id_shop` = 2
4882 ms 3 /src/Adapter/EntityMapper.php:84
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 `bru21_cart_product` cp
WHERE cp.`id_product_attribute` = 41116
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 30941 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `bru21_cart_product` cp JOIN `bru21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `bru21_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 41116
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 30941 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
4753 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 602 AND `id_shop` = 2
4735 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 162) LIMIT 1
4722 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 296) LIMIT 1
4707 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 35247 LIMIT 1
4564 ms 271 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 471) LIMIT 1
4415 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 454 AND `id_shop` = 2
4330 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 453 AND `id_shop` = 2
4323 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 628 AND `id_shop` = 2
4315 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE SUM(quantity)
FROM `bru21_stock_available`
WHERE (id_product = 34977) AND (id_product_attribute = 49418) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
4209 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `bru21_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 34554 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 48839) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-05 19:44:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-05 19:44: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
4171 ms 5 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 669) LIMIT 1
4166 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `bru21_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
4150 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 527 AND `id_shop` = 2
4120 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 667 AND `id_shop` = 2
4103 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 154 AND `id_shop` = 2
4048 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 671 AND `id_shop` = 2
4013 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 30941 LIMIT 1
3959 ms 271 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `bru21_product_attribute` pa
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.`id_product_attribute` = 48830 LIMIT 1
3954 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE p.*,
ps.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 31351
LIMIT 1
3939 ms 6 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 469) LIMIT 1
3900 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 34545 LIMIT 1
3889 ms 272 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax
FROM `bru21_product` p
INNER JOIN `bru21_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 2)
LEFT JOIN `bru21_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 2)
WHERE (p.`id_product` = 31351)
3849 ms 1 /classes/Product.php:3829
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 `bru21_cart_product` cp
WHERE cp.`id_product_attribute` = 44274
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 30943 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `bru21_cart_product` cp JOIN `bru21_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `bru21_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 44274
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 30943 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3836 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 30942 LIMIT 1
3819 ms 271 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `bru21_product_attribute` pa
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.`id_product_attribute` = 41794 LIMIT 1
3816 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE out_of_stock
FROM `bru21_stock_available`
WHERE (id_product = 34978) AND (id_product_attribute = 0) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
3703 ms 1 /classes/stock/StockAvailable.php:769
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 156) LIMIT 1
3697 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 110 AND `id_shop` = 2
3684 ms 3 /src/Adapter/EntityMapper.php:84
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 `bru21_configuration` c
LEFT JOIN `bru21_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3670 ms 1551 /classes/Configuration.php:160
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 548) LIMIT 1
3657 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 471 AND `id_shop` = 2
3656 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 3, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 2, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `bru21_specific_price`
WHERE
`id_shop` IN (0, 2) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 3) AND
`id_group` IN (0, 1) AND `id_product` = 30943 AND `id_customer` = 0 AND `id_product_attribute` IN (0, 44274) AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2023-12-05 19:44:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2023-12-05 19:44: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
3628 ms 5 Yes /classes/SpecificPrice.php:561
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 300) LIMIT 1
3608 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `bru21_product_attribute`
WHERE `id_product` = 34545
3569 ms 1 /classes/Product.php:2879
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 533 AND `id_shop` = 2
3548 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `bru21_product_attribute` pa
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `bru21_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `bru21_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `bru21_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `bru21_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `bru21_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 30941
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
3515 ms 1 Yes Yes /classes/Product.php:2792
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 551 AND `id_shop` = 2
3489 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_product` a
LEFT JOIN `bru21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `bru21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 30942) AND (b.`id_shop` = 2) LIMIT 1
3458 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 134 AND `id_shop` = 2
3431 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 466 AND `id_shop` = 2
3423 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_module` FROM `bru21_module_shop` WHERE `id_module` = 59 AND `id_shop` = 2 LIMIT 1
3412 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 173 AND `id_shop` = 2
3395 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 30943 LIMIT 1
3384 ms 542 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 599 AND `id_shop` = 2
3317 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 309 AND `id_shop` = 2
3309 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `bru21_attribute` a
LEFT JOIN `bru21_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `bru21_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `bru21_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
LEFT JOIN `bru21_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 34554
AND pac.`id_product_attribute` = 48839
AND agl.`id_lang` = 1
3258 ms 1 /classes/Product.php:7406
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 177 AND `id_shop` = 2
3235 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE location
FROM `bru21_stock_available`
WHERE (id_product = 30943) AND (id_product_attribute = 44275) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
3222 ms 1 /classes/stock/StockAvailable.php:797
SELECT SQL_NO_CACHE *
FROM `bru21_category` a
LEFT JOIN `bru21_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 2
WHERE (a.`id_category` = 545) LIMIT 1
3211 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `bru21_product` a
LEFT JOIN `bru21_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `bru21_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 2
WHERE (a.`id_product` = 34978) AND (b.`id_shop` = 2) LIMIT 1
3185 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(
'2023-12-05 00:00:00',
INTERVAL 1 DAY
)
) > 0) as new
FROM bru21_product p
LEFT JOIN bru21_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 2
AND pl.id_lang = 1
LEFT JOIN bru21_stock_available sa   ON sa.id_product = p.id_product
AND sa.id_shop = 2 LEFT JOIN bru21_product_shop ps
ON ps.id_product = p.id_product
AND ps.id_shop = 2
WHERE p.id_product = 34554
LIMIT 1
3160 ms 4 /classes/ProductAssembler.php:106
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 34976 LIMIT 1
3115 ms 8 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `bru21_product_attribute` pa
INNER JOIN bru21_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 2)
WHERE pa.`id_product_attribute` = 49751 LIMIT 1
3110 ms 1 /classes/Combination.php:543
SELECT SQL_NO_CACHE SUM(quantity)
FROM `bru21_stock_available`
WHERE (id_product = 30941) AND (id_product_attribute = 41116) AND (id_shop = 2) AND (id_shop_group = 0) LIMIT 1
3105 ms 1 /classes/stock/StockAvailable.php:453
SELECT SQL_NO_CACHE 1 FROM `bru21_specific_price` WHERE id_product = 35243 LIMIT 1
3095 ms 271 /classes/SpecificPrice.php:420
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `bru21_image` i
INNER JOIN bru21_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 2)
WHERE i.`id_product` = 31351
AND image_shop.`cover` = 1 LIMIT 1
3092 ms 1 /classes/Product.php:3542
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 311 AND `id_shop` = 2
3090 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 522 AND `id_shop` = 2
3086 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `bru21_category_lang`
WHERE `id_category` = 153 AND `id_shop` = 2
3086 ms 3 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE `id_order`
FROM `bru21_orders`
WHERE `id_cart` = 0 AND id_shop IN (2) LIMIT 1
3081 ms 1