Home

Home

List of products by supplier LE LORRAIN

"For more than 50 years, HAMPIAUX society has created a complete range of flame welding, under the brand LE LORRAIN. 

Founded in 1946, many industries (wether in the steel industry, metallurgy, boiler making, craftsmen or refrigerator specialists) are delighted to work with LE LORRAIN. Their reputation is excellent. 

 

The products are high standard and based on a great expertise. From the undercutting of the pieces to the assembly and testing of finished products.  

 

LE LORRAIN has chosen HD SOUDAGE as its official distributor for 9 years in the « NORD PAS DE CALAIS » region. We are in close collaboration, which allows us to give our customers a great reactivity, helpful tips concerning the choice and the use of the products. 

 

As the exclusive distributor of LE LORRAIN, we ensure a LE LORRAIN certified repair service on their holders and welding torches. 

 

 Why choosing LE LORRAIN ? 

*Products guaranteed made in france. 

*High quality and resistance

*Personalized realization of welding torches is possible. Thanks to our working relationship with LE LORRAIN, specific equipments are made shortly (approx. 1 week). 

*We take care of maintenance and the repair work of the welding torches and holders. 

 

Range of products : 

-welding, cutting, high pressure and low pressure torches,

-Cutting heads or nozzles for all gases

-All gases holders (gas bottles and canals), boards and stations for the installation of studio. 

-Pipes, quick coupling, flashback arrestors for pipe, welding torch or 

holder.

-Equipments and accessories 

-On demand realizations (welding torches, regulator system stations, standing distribution..) CONTACT US ! 

There are 314 products.

Sort by:

There are 314 products.

Load Time1348 ms - OK... for a shared hosting
Querying Time596 ms
Queries702
Memory Peak Usage24.1 Mb
Included Files1077 files - 11.73 Mb
PrestaShop Cache- Mb
Global vars0.29 Mb
PrestaShop Version1.7.7.2
PHP Version7.3.18 (OK)
MySQL Version5.7.27-log (OK)
Memory Limit512M
Max Execution Time1200s
Smarty Cachedisabled
Smarty Compilationforce compile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 23 ms 23 ms 4.70 Mb 4.70 Mb
__construct 0 ms 23 ms - Mb 4.70 Mb
init 15 ms 38 ms 1.65 Mb 6.40 Mb
checkAccess 0 ms 38 ms - Mb 6.40 Mb
setMedia 4 ms 43 ms 0.40 Mb 7.29 Mb
postProcess 0 ms 43 ms - Mb 7.29 Mb
initHeader 0 ms 43 ms - Mb 7.29 Mb
initContent 658 ms 701 ms 12.76 Mb 19.52 Mb
initFooter 0 ms 701 ms - Mb 19.52 Mb
display 647 ms 1348 ms 4.34 Mb 24.13 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 702 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,
pl.`description`,
pl.`description_short`,
pl.`link_rewrite`,
pl.`meta_description`,
pl.`meta_keywords`,
pl.`meta_title`,
pl.`name`,
image_shop.`id_image` id_image,
il.`legend`,
s.`name` AS supplier_name,
DATEDIFF(p.`date_add`, DATE_SUB("2022-01-22 00:00:00", INTERVAL 30 DAY)) > 0 AS new,
m.`name` AS manufacturer_name, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
FROM `hd_product` p
INNER JOIN hd_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
JOIN `hd_product_supplier` ps ON (ps.id_product = p.id_product
AND ps.id_product_attribute = 0) LEFT JOIN `hd_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 `hd_product_lang` pl ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 )
LEFT JOIN `hd_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 `hd_image_lang` il ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 3)
LEFT JOIN `hd_supplier` s ON s.`id_supplier` = p.`id_supplier`
LEFT JOIN `hd_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN hd_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 2  AND stock.id_shop = 0  )JOIN `hd_category_product` cp ON (p.id_product = cp.id_product)JOIN `hd_category_group` cg ON (cp.`id_category` = cg.`id_category` AND cg.`id_group` = 1)JOIN `hd_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE ps.`id_supplier` = 86
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY ps.id_product
ORDER BY name asc
LIMIT 0,24
202.6 950 Yes Yes /classes/Supplier.php:398
INSERT INTO `hd_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')
170.5 1 /classes/ObjectModel.php:559
INSERT INTO `hd_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('15975', '490', '56097438', '', '1', '2', '2022-01-22 20:55:39')
65.2 1 /classes/ObjectModel.php:559
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13651
ORDER BY `position`
10.5 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13627
7.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13553
AND image_shop.`cover` = 1 LIMIT 1
6.3 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13688
ORDER BY f.position ASC
6.3 2 Yes /classes/Product.php:5195
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 `hd_configuration` c
LEFT JOIN `hd_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
3.8 3358 /classes/Configuration.php:160
SELECT SQL_NO_CACHE COUNT(DISTINCT ps.`id_product`)
FROM `hd_product_supplier` ps
JOIN `hd_product` p ON (ps.`id_product`= p.`id_product`)
INNER JOIN hd_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE ps.`id_supplier` = 86
AND ps.id_product_attribute = 0
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND p.`id_product` IN (
SELECT cp.`id_product`
FROM `hd_category_product` cp
LEFT JOIN `hd_category_group` cg ON (cp.`id_category` = cg.`id_category`)
INNER JOIN `hd_category` ca ON cp.`id_category` = ca.`id_category` AND ca.`active` = 1
WHERE cg.`id_group` =1
) LIMIT 1
2.2 475 /classes/Supplier.php:330
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `hd_module` m
INNER JOIN hd_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 `hd_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `hd_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `hd_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `hd_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`
2.2 5096 Yes Yes /classes/Hook.php:1161
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `hd_country` c  INNER JOIN hd_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `hd_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 3)
LEFT JOIN `hd_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1.4 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, MAX(product_attribute_shop.id_product_attribute) 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`, MAX(image_shop.`id_image`) id_image,
il.`legend`, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2022-01-22 00:00:00",
INTERVAL 30 DAY)) > 0 AS new,
product_shop.price AS orderprice
FROM `hd_product` p
LEFT JOIN `hd_product_attribute` pa ON (p.`id_product` = pa.`id_product`)
INNER JOIN hd_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN hd_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 hd_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_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `hd_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = 1 
)
LEFT JOIN `hd_category_lang` cl ON (
p.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = 1 
)
LEFT JOIN `hd_image` i ON (p.`id_product` = i.`id_product`)
LEFT JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1 AND image_shop.cover=1)
LEFT JOIN `hd_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 3)
LEFT JOIN `hd_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer`
LEFT JOIN `hd_tax_rule` tr ON (p.`id_tax_rules_group` = tr.`id_tax_rules_group`
AND tr.`id_country` = 21
AND tr.`id_state` = 0
)
LEFT JOIN `hd_tax` t ON (t.`id_tax` = tr.`id_tax`)
LEFT JOIN `hd_tax_lang` tl ON (t.`id_tax` = tl.`id_tax` AND tl.`id_lang` = 3)
WHERE product_shop.`id_shop` = 1
AND product_shop.`active` = 1
AND product_shop.`available_for_order` = 1 
AND product_shop.`id_product` IN (15303,52124,14389,52104,49076)
AND product_shop.`visibility` IN ("both", "catalog") 
AND IF (
(stock.`id_product_attribute` = 0 AND pa.`id_product_attribute` IS NULL)
OR 
(product_attribute_shop.`id_product_attribute` IS NOT NULL AND stock.`id_product_attribute`=product_attribute_shop.`id_product_attribute`), 1, 0
)
AND IF (stock.`quantity` > 0, 1, IF (stock.`out_of_stock` = 2, 1 = 1, stock.`out_of_stock` = 1))
GROUP BY product_shop.`id_product`
ORDER BY FIELD(product_shop.`id_product`, 15303,52124,14389,52104,49076)
1.4 25 Yes /override/modules/pm_crosssellingoncart/pm_crosssellingoncart.php:83
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, active
FROM `hd_hook_module` hm
STRAIGHT_JOIN `hd_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `hd_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.3 453 /classes/Hook.php:487
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `hd_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `hd_hook_alias` ha
INNER JOIN `hd_hook` h ON ha.name = h.name
1.2 0 /classes/Hook.php:1221
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `hd_category` c
INNER JOIN `hd_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 3 AND cl.id_shop = 1 )
INNER JOIN `hd_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 169
AND c.id_category IN (
SELECT id_category
FROM `hd_category_group`
WHERE `id_group` IN (1)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
1.1 169 Yes /modules/ps_categorytree/ps_categorytree.php:149
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13545
1 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13688
1 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13876
0.8 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE atp.*, atpl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu` atp
INNER JOIN `hd_pm_advancedtopmenu_shop` atp_shop
ON atp_shop.id_menu = atp.id_menu
AND atp_shop.id_shop IN (1) 
LEFT JOIN `hd_pm_advancedtopmenu_lang` atpl ON (atp.`id_menu` = atpl.`id_menu` AND atpl.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = atp.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1 AND 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = atp.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (atp.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1 AND 1)
LEFT JOIN `hd_supplier` s ON (atp.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1 AND 1)
WHERE atp.`active` = 1 AND (atp.`active_desktop` = 1 || atp.`active_mobile` = 1)
AND ((atp.`id_manufacturer` = 0 AND atp.`id_supplier` = 0 AND atp.`id_category` = 0 AND atp.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND IF (atp.`id_category` IS NULL OR atp.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atp.`id_menu`
ORDER BY atp.`position`
0.8 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244
SELECT SQL_NO_CACHE * FROM `hd_state` ORDER BY `name` ASC
0.8 421 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_columns` atmc
LEFT JOIN `hd_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 5
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
0.7 96 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247
SHOW TABLES LIKE '%psblog_blog%'
0.6 1 /modules/psblog/psblog.php:61
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 30
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.6 72 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_columns` atmc
LEFT JOIN `hd_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 4
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
0.5 40 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 22
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 48 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 26
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 24
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13597
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 31
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 48 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13512
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13555
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13556
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13598
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 25
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13554
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 28
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 24 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13625
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13575
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13574
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13553
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `hd_hook`
0.5 637 /classes/Hook.php:1221
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13511
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13576
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13522
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 42
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 24 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13513
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13651
0.5 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 29
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 24 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 32
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.5 24 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 23
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 16 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 18
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 20
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `hd_meta` m
LEFT JOIN `hd_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.4 106 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 19
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 16
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE ate.*, atel.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_elements` ate
LEFT JOIN `hd_pm_advancedtopmenu_elements_lang` atel ON (ate.`id_element` = atel.`id_element` AND atel.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = ate.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = ate.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (ate.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (ate.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  ate.`active` = 1 AND (ate.`active_desktop` = 1 || ate.`active_mobile` = 1) AND ate.`id_column` = 17
AND ((ate.`id_manufacturer` = 0 AND ate.`id_supplier` = 0 AND ate.`id_category` = 0 AND ate.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)
AND (cms_shop.`id_shop` = 1 OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = 1 OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = 1 OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY ate.`id_element`
ORDER BY ate.`position`
0.4 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13545
ORDER BY `position`
0.4 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE c.id_contact FROM hd_ets_ctf_contact c
INNER JOIN hd_ets_ctf_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN hd_ets_ctf_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="3")
WHERE c.active=1 AND c.hook like "%header%" AND cs.id_shop="1";
0.3 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13688
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13876
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM hd_shop_url su
LEFT JOIN hd_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'hdsoudage.lemoni.fr' OR su.domain_ssl = 'hdsoudage.lemoni.fr')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 2 Yes /classes/shop/Shop.php:1341
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13530
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE c.id_contact FROM hd_ets_ctf_contact c
INNER JOIN hd_ets_ctf_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN hd_ets_ctf_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="3")
WHERE c.active=1 AND c.hook like "%displayTop%" AND cs.id_shop="1";
0.3 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13523
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE `id_guest`
FROM `hd_connections`
WHERE `id_guest` = 15975
AND `date_add` > '2022-01-22 20:25:00'
AND id_shop_group = 2 
ORDER BY `date_add` DESC LIMIT 1
0.3 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 52124
0.3 15 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13510
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 15303
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13688) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE m.`name` FROM `hd_module` m
JOIN `hd_module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1)
WHERE m.active=1
0.3 102 /modules/jscomposer/classes/vccontentanywhere.php:868
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13688) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13627) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.`name` FROM `hd_module` m
JOIN `hd_module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1)
WHERE m.active=1
0.3 102 /modules/jscomposer/classes/vccontentanywhere.php:868
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13553) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13688
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13511
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 52104
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13603
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 13557
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE v.*,vl.content,vs.id_shop FROM `hd_vccontentanywhere` v 
INNER JOIN `hd_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1)
WHERE v.`hook_name` = "DisplayNavFullWidth" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%supplier%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) )  ORDER BY `position` ASC
0.3 7 Yes /modules/jscomposer/classes/vccontentanywhere.php:147
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 15303 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 15303 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1404
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13557) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13627
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
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 hd_shop_group gs
LEFT JOIN hd_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN hd_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
0.3 2 Yes /classes/shop/Shop.php:703
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13876
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13598) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13574
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13556) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13876) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13513) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13576) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13575
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13555
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15303) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13597) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "blocklanguages" LIMIT 1
0.3 0 /classes/module/Module.php:2820
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52104 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 52104 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13603
ORDER BY f.position ASC
0.3 3 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13625) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13512 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13512 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `hd_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 49076 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-01-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-01-22 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
0.2 2 Yes /classes/SpecificPrice.php:560
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13651) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13522) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `hd_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `hd_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 3)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 7
ORDER BY atmcw.`position`
0.2 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13603 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13603 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE t.`class_name`, t.`module`
FROM `hd_tab` t
WHERE t.`module` IS NOT NULL AND t.`module` != ""
0.2 183 /classes/Tab.php:272
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13598
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13510) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE v.*,vl.content,vs.id_shop FROM `hd_vccontentanywhere` v 
INNER JOIN `hd_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1)
WHERE v.`hook_name` = "DisplayFooterBefore" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%supplier%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) )  ORDER BY `position` ASC
0.2 7 Yes /modules/jscomposer/classes/vccontentanywhere.php:147
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13627) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13651
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `hd_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 13603 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-01-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-01-22 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
0.2 2 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13512
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13530) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13625) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13597) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13688 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13688 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `hd_specific_price` WHERE `id_product` != 0 LIMIT 1
0.2 116 /classes/SpecificPrice.php:286
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52104) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13554
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13574) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13554) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 49076
0.2 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13513) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13512) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13512) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `hd_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 15303 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-01-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-01-22 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
0.2 3 Yes /classes/SpecificPrice.php:560
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13556
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13523) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `hd_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `hd_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 3)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 6
ORDER BY atmcw.`position`
0.2 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13553) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13522
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13603) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13575) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13574) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13625
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13555) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "hdsoudage-fr" AND TABLE_NAME = "hd_psblog_blog" AND COLUMN_NAME = "thumb"
0.2 0 /modules/psblog/psblog.php:61
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13553
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13576
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 52104
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13545
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `hd_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `hd_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 3)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 4
ORDER BY atmcw.`position`
0.2 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129
SELECT SQL_NO_CACHE *
FROM `hd_category` a
LEFT JOIN `hd_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 3
LEFT JOIN `hd_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE atmcw.*, atmcwl.*
FROM `hd_pm_advancedtopmenu_columns_wrap` atmcw
LEFT JOIN `hd_pm_advancedtopmenu_columns_wrap_lang` atmcwl ON (atmcw.`id_wrap` = atmcwl.`id_wrap` AND atmcwl.`id_lang` = 3)
WHERE  atmcw.`active` = 1 AND (atmcw.`active_desktop` = 1 || atmcw.`active_mobile` = 1) AND atmcw.`id_menu` = 16
ORDER BY atmcw.`position`
0.2 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129
SELECT SQL_NO_CACHE *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.2 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13512
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13597
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52124 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 52124 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13513
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13688) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.id_contact FROM hd_ets_ctf_contact c
INNER JOIN hd_ets_ctf_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN hd_ets_ctf_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="3")
WHERE c.active=1 AND c.hook like "%nav_top%" AND cs.id_shop="1";
0.2 2 /modules/ets_contactform7/ets_contactform7.php:1471
(SELECT 1 FROM `hd_cart_rule` WHERE date_to >= "2022-01-22 00:00:00" AND date_to <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from >= "2022-01-22 00:00:00" AND date_from <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from < "2022-01-22 00:00:00" AND date_to > "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.2 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13576) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13523
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE v.*,vl.content,vs.id_shop FROM `hd_vccontentanywhere` v 
INNER JOIN `hd_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1)
WHERE v.`hook_name` = "displayFooter" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%supplier%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) )  ORDER BY `position` ASC
0.2 7 Yes /modules/jscomposer/classes/vccontentanywhere.php:147
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13530
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15303) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13597) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE v.*,vl.content,vs.id_shop FROM `hd_vccontentanywhere` v 
INNER JOIN `hd_vccontentanywhere_lang` vl ON (v.`id_vccontentanywhere` = vl.`id_vccontentanywhere` AND vl.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs ON (v.`id_vccontentanywhere` = vs.`id_vccontentanywhere` AND vs.`id_shop` = 1 AND v.`active` = 1)
WHERE v.`hook_name` = "DisplayFooterAfter" AND v.`active` = 1 AND ( ( v.`exception_type` = 1 AND v.`exception` LIKE "%supplier%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) )  ORDER BY `position` ASC
0.2 7 Yes /modules/jscomposer/classes/vccontentanywhere.php:147
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13512) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13597 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13597 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 49076 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 49076 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE id_page_type
FROM hd_page_type
WHERE name = 'supplier' LIMIT 1
0.2 1 /classes/Page.php:104
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13575 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13575 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13553 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13553 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13557 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13557 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13627 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13627 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13627) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13576 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13576 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13545 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13545 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13876) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13876) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13554) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13625 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13625 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13603) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13876 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13876 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13598 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13598 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, alias FROM `hd_hook_alias`
0.2 88 /classes/Hook.php:336
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13688)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13545) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13511 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13511 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13530 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13530 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 15303
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13554 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13554 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13556 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13556 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13555 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13555 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13651 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13651 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13513 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13513 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13574 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13574 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13523 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13523 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13511) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13575) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 70318
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52124 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 70318
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52124 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13510 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13510 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13651) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 13522 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `hd_cart_product` cp JOIN `hd_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `hd_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` = 13522 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13545)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 49076) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52124) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13553)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13522) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
(SELECT 1 FROM `hd_cart_rule` WHERE date_to >= "2022-01-22 00:00:00" AND date_to <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from >= "2022-01-22 00:00:00" AND date_from <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from < "2022-01-22 00:00:00" AND date_to > "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.2 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13603) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 15303 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Product.php:5753
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13556) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13598) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13554) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13523) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13555) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13576) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13557) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2335
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13530) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13510) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13545) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "prices-drop"
OR m.page = "pricesdrop"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.2 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 49076
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE * FROM `hd_currency` c ORDER BY `iso_code` ASC
0.2 2 Yes /classes/Currency.php:695
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13510
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13557
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13553
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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 `hd_product_attribute` pa
INNER JOIN hd_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 `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (13511) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.2 1 Yes Yes /classes/Product.php:3993
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13575
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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 `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN hd_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 `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 52124
AND pac.`id_product_attribute` = 70318
AND agl.`id_lang` = 3
0.2 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13688
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13625
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `name`
FROM `hd_hook`
WHERE `id_hook` = 14 LIMIT 1
0.2 1 /classes/Hook.php:222
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13576
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13511
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13556
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13557
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 52124)
0.2 7 /classes/Product.php:3401
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13651
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE c.id_contact FROM hd_ets_ctf_contact c
INNER JOIN hd_ets_ctf_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN hd_ets_ctf_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="3")
WHERE c.active=1 AND c.hook like "%left_column%" AND cs.id_shop="1";
0.2 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `hd_currency` c
LEFT JOIN hd_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.2 2 /classes/Currency.php:1099
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13555
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13523
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `hd_product_attribute_image` pai
LEFT JOIN `hd_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `hd_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (70316, 70317, 70318, 70319, 70320, 70321, 70322) AND il.`id_lang` = 3 ORDER by i.`position`
0.2 7 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM hd_shop s
LEFT JOIN hd_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13513) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13625) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13554
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 13603
ORDER BY `position`
0.2 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13574
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13530
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13510
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13513
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13545) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13522
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13575) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13530) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13557) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13553) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13598) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13523) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13574) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13651) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13510) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13555) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13522) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13556) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13512
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 13511) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52124) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13627)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52104) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 49076) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE value FROM `hd_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.2 1 /classes/shop/Shop.php:1162
SELECT SQL_NO_CACHE *
FROM hd_product_attachment pa
LEFT JOIN hd_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN hd_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 15303
0.2 2 /classes/Product.php:5215
SELECT SQL_NO_CACHE c.id_contact FROM hd_ets_ctf_contact c
INNER JOIN hd_ets_ctf_contact_shop cs ON (c.id_contact= cs.id_contact)
LEFT JOIN hd_ets_ctf_contact_lang cl on (c.id_contact= cl.id_contact AND cl.id_lang="3")
WHERE c.active=1 AND c.hook like "%footer_page%" AND cs.id_shop="1";
0.2 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE 1 FROM hd_cart_product cp INNER JOIN hd_product p
ON (p.id_product = cp.id_product) INNER JOIN hd_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.2 1 /classes/Cart.php:4193
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13545
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13627
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.2 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13597
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13876
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE r.`id_pxcmsheaderblockinfo`, r.`id_shop`, rl.`text`
FROM `hd_pxcmsheaderblockinfo` r
LEFT JOIN `hd_pxcmsheaderblockinfo_lang` rl ON (r.`id_pxcmsheaderblockinfo` = rl.`id_pxcmsheaderblockinfo`)
WHERE `id_lang` = 3 AND  `id_shop` = 1 LIMIT 1
0.2 1 /modules/px_cmsheaderblock/px_cmsheaderblock.php:256
SELECT SQL_NO_CACHE *
FROM `hd_currency` a
LEFT JOIN `hd_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 3
LEFT JOIN `hd_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_supplier` a
LEFT JOIN `hd_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = 3
LEFT JOIN `hd_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 86) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 13598
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE *
FROM hd_product_attachment pa
LEFT JOIN hd_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN hd_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 13603
0.2 1 /classes/Product.php:5215
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13598)
0.2 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13597)
0.2 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13557)
0.2 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13512)
0.2 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13510)
0.2 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13555)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE tr.*
FROM `hd_tax_rule` tr
JOIN `hd_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 10
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13597
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 15303
ORDER BY `position`
0.2 3 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 13688 LIMIT 1
0.2 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `hd_lang` l
JOIN hd_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.2 2 /classes/Language.php:1123
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13513)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 15303
AND image_shop.`cover` = 1 LIMIT 1
0.2 3 /classes/Product.php:3118
SELECT SQL_NO_CACHE *
FROM `hd_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_page`
FROM `hd_page`
WHERE `id_page_type` = 18 LIMIT 1
0.2 2 /classes/Page.php:83
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13651
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 59 LIMIT 1
0.2 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE tr.*
FROM `hd_tax_rule` tr
JOIN `hd_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13555
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13598
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_supplier` a
LEFT JOIN `hd_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = 1
LEFT JOIN `hd_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = 1
WHERE (a.`id_supplier` = 86) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_country` a
LEFT JOIN `hd_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `hd_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 52124
ORDER BY f.position ASC
0.1 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `hd_specific_price` WHERE `id_product` != 0
0.1 124 /classes/SpecificPrice.php:294
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13575
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 13627 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 49076 AND ctg.`id_group` = 1 LIMIT 1
0.1 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 52124
AND image_shop.`cover` = 1 LIMIT 1
0.1 3 /classes/Product.php:3118
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 64 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13523
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE `hook_name`, count(`id_vccontentanywhere`) as contentCount   FROM `hd_vccontentanywhere` GROUP BY `hook_name`
0.1 7 Yes /modules/jscomposer/jscomposer.php:3077
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 13553 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 52124
ORDER BY `position`
0.1 3 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 58 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE *
FROM hd_product_attachment pa
LEFT JOIN hd_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN hd_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 13625
0.1 1 /classes/Product.php:5215
SELECT SQL_NO_CACHE `id_lang` FROM `hd_lang`
WHERE `locale` = 'en-us'
OR `language_code` = 'en-us' LIMIT 1
0.1 2 /classes/Language.php:790
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 13553 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13511
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 52104
AND image_shop.`cover` = 1 LIMIT 1
0.1 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 3
AND cl.id_shop = 1 
AND cl.`id_category` = 58 LIMIT 1
0.1 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 52104
ORDER BY `position`
0.1 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 49076
AND image_shop.`cover` = 1 LIMIT 1
0.1 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 59 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 13597 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 13625 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 52124 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13512
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 49076
ORDER BY `position`
0.1 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `hd_lang` l
LEFT JOIN `hd_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.1 4 /classes/Language.php:991
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13513
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13530
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13522
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 13574
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE `name`, `alias` FROM `hd_hook_alias`
0.1 88 /classes/Hook.php:284
SELECT SQL_NO_CACHE *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.1 1 /classes/Meta.php:189
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13688 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE * FROM `hd_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.1 7 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13603 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 52124 AND ctg.`id_group` = 1 LIMIT 1
0.1 1 /classes/Product.php:5753
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13576 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 52104 AND ctg.`id_group` = 1 LIMIT 1
0.1 1 /classes/Product.php:5753
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13554 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 14389 AND ctg.`id_group` = 1 LIMIT 1
0.1 2 /classes/Product.php:5753
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13625)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13625 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13553 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13555 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_country` a
LEFT JOIN `hd_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13510 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13530 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 13574 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM hd_link_block cb
WHERE `id_hook` = 35
ORDER by cb.`position`
0.1 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE *
FROM `hd_lang` a
LEFT JOIN `hd_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 49076)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE hm.`id_module`
FROM `hd_hook_module` hm, `hd_hook` h
WHERE hm.`id_module` = 143 AND h.`id_hook` = 51
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/Hook.php:617
SELECT SQL_NO_CACHE r.`id_pxcmspaymentblockinfo`, r.`id_shop`, rl.`text`
FROM `hd_pxcmspaymentblockinfo` r
LEFT JOIN `hd_pxcmspaymentblockinfo_lang` rl ON (r.`id_pxcmspaymentblockinfo` = rl.`id_pxcmspaymentblockinfo`)
WHERE `id_lang` = 3 AND  `id_shop` = 1 LIMIT 1
0.1 1 /modules/px_cmspaymentblock/px_cmspaymentblock.php:256
SELECT SQL_NO_CACHE `id_order`
FROM `hd_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
0.1 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13554
0.1 1 /classes/Product.php:2510
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 15303)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 13512 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 52104 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_country`
FROM `hd_country`
WHERE `iso_code` = 'US' LIMIT 1
0.1 1 /classes/Country.php:193
SELECT SQL_NO_CACHE *
FROM hd_product_attachment pa
LEFT JOIN hd_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN hd_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 3)
WHERE pa.id_product = 49076
0.1 4 /classes/Product.php:5215
SELECT SQL_NO_CACHE id_shop FROM hd_shop
0.1 2 /classes/shop/Shop.php:739
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13603)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_lang` a
LEFT JOIN `hd_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 3) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13530)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE domain
FROM `hd_shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (2, 1)
0.1 2 /classes/shop/Shop.php:793
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13522)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13513
0.1 1 /classes/Product.php:2510
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13574)
0.1 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13651)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE *
FROM `hd_link_block_lang`
WHERE `id_link_block` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE c.id_currency
FROM `hd_currency` c
WHERE (iso_code = 'EUR') LIMIT 1
0.1 1 /classes/Currency.php:866
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13627
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_country_lang`
WHERE `id_country` = 8
0.1 3 /src/Adapter/EntityMapper.php:82
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13876)
0.1 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 52104)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE domain, domain_ssl
FROM hd_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 15303) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 52124
0.1 7 /classes/Product.php:2510
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 13511
0.1 1 /classes/Product.php:2510
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13575)
0.1 1 /classes/Product.php:3401
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
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 13511)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE hm.`id_module`
FROM `hd_hook_module` hm, `hd_hook` h
WHERE hm.`id_module` = 143 AND h.`id_hook` = 51
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 2 LIMIT 1
0.1 1 /classes/Hook.php:617
SELECT SQL_NO_CACHE `id_order`
FROM `hd_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
0.1 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 59 LIMIT 1