Home

Home

List of products by supplier CEPRO

CEPRO is a dutch company, created 25 tears ago. 

It excels in the welding protection products, such as welding curtains, welding screens, and welding blankets.. 

The partnership between CEPRO and HDSOUDAGE allows : 

-The distribution of high-quality products, selected following your applications.

-Very short deadline on all the standard products.

-Specific technical solutions 

The product range (/catalogue) : 

- Welding curtains, strap

-Anti-heat curtains

-Welding screens

-Welding booths / chamber...

CEPRO is a specialist in the safe fit-out of welding and grinding workshops and offers an extensive package of products and services. CEPRO products not only increase the safety of the workplace but also the efficiency which, in turn, improves the workflow and generates cost savings. The products comply with all applicable standards and regulations, also where the different subfields are concerned.

There are 8 products.

Sort by:

There are 8 products.

Load Time1118 ms - OK... for a shared hosting
Querying Time371 ms
Queries424
Memory Peak Usage19.4 Mb
Included Files1077 files - 11.73 Mb
PrestaShop Cache- Mb
Global vars0.26 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 39 ms 1.65 Mb 6.39 Mb
checkAccess 0 ms 39 ms - Mb 6.39 Mb
setMedia 4 ms 43 ms 0.40 Mb 7.29 Mb
postProcess 0 ms 43 ms - Mb 7.29 Mb
initHeader - ms 43 ms - Mb 7.29 Mb
initContent 457 ms 500 ms 8.58 Mb 15.34 Mb
initFooter 0 ms 500 ms - Mb 15.34 Mb
display 618 ms 1118 ms 3.88 Mb 19.43 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 424 queries

Query Time (ms) Rows Filesort Group By Location
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')
130.3 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 ('16005', '490', '56097438', '', '1', '2', '2022-01-22 21:23:36')
81.8 1 /classes/ObjectModel.php:559
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` = 98
AND product_shop.`active` = 1
AND product_shop.`visibility` IN ("both", "catalog")
GROUP BY ps.id_product
ORDER BY name asc
LIMIT 0,24
35.4 48 Yes Yes /classes/Supplier.php:398
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 = 15711
13.8 4 /classes/ProductAssembler.php:90
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 = 14168
9.4 1 /classes/Product.php:5215
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 = 17009
8.3 2 /classes/ProductAssembler.php:90
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` = 52493)
8 10 /classes/Product.php:3401
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.9 3358 /classes/Configuration.php:160
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 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 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.3 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.2 25 Yes /override/modules/pm_crosssellingoncart/pm_crosssellingoncart.php:83
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 * FROM `hd_state` ORDER BY `name` ASC
0.8 421 Yes /classes/Country.php:154
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.7 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244
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.6 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` = 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.6 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` = 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 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 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` = 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 = 17010
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 = 52493
0.5 11 /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 = 14168
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` = 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` = 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 = 14167
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 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 = 51863
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 = 45919
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 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.5 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` = 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 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 `id_hook`, `name` FROM `hd_hook`
0.5 637 /classes/Hook.php:1221
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 (17009) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 1 Yes Yes /classes/Product.php:3993
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 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` = 15711
ORDER BY `position`
0.4 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` = 17009
ORDER BY `position`
0.4 3 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` = 14168) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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 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 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 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` = 98
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
0.4 24 /classes/Supplier.php:330
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` = 17009
AND image_shop.`cover` = 1 LIMIT 1
0.4 3 /classes/Product.php:3118
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` = 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 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 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 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 *, ( 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` = 17009 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.3 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 (52493) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 190 Yes Yes /classes/Product.php:3993
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 *, ( 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` = 15711 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.3 2 Yes /classes/SpecificPrice.php:560
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` = 17009) 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` = 15711) 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.`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 `id_guest`
FROM `hd_connections`
WHERE `id_guest` = 16005
AND `date_add` > '2022-01-22 20:53: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 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.3 1 /classes/CartRule.php:342
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 (17010) 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 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 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` = 52493 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` = 52493 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 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 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` = 52493
ORDER BY `position`
0.3 8 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 14168 AND `id_shop` = 1
0.3 2 /src/Adapter/EntityMapper.php:82
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 (45919) 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 COUNT(DISTINCT `id_product`) FROM `hd_specific_price` WHERE `id_product` != 0 LIMIT 1
0.3 116 /classes/SpecificPrice.php:286
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` = 14168
ORDER BY `position`
0.3 2 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 (14167) 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 (14168) 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 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 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` = 17010
ORDER BY `position`
0.3 3 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` = 15711
AND image_shop.`cover` = 1 LIMIT 1
0.3 1 /classes/Product.php:3118
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 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.2 7 Yes /modules/jscomposer/classes/vccontentanywhere.php:147
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 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 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` = 52493) 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` = 14167
ORDER BY `position`
0.2 2 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` = 51863 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` = 51863 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 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 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` = 45919
ORDER BY `position`
0.2 2 Yes /classes/Product.php:3096
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 *
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` = 45919) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "blocklanguages" LIMIT 1
0.2 0 /classes/module/Module.php:2820
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 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` = 51863) 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` = 14168) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 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 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` = 52493
AND pac.`id_product_attribute` = 70897
AND agl.`id_lang` = 3
0.2 3 /classes/Product.php:6435
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 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 (51863) 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 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` = 17009 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` = 17009 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 "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 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` = 15711 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` = 15711 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` = 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.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` = 14168 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 *, ( 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` = 14167 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 DISTINCT `id_product` FROM `hd_specific_price` WHERE `id_product` != 0
0.2 124 /classes/SpecificPrice.php:294
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.2 2 /classes/ProductAssembler.php:90
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 *
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 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 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 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 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 (15711) 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 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 `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 15711
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` = 51863
ORDER BY `position`
0.2 2 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` = 52493) 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` = 14168 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` = 14168 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_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 17009
0.2 1 /classes/Product.php:2510
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 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.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 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 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 *
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` = 17010) 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` = 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 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` = 70897
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52493 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` = 70897
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52493 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 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` = 17009)
0.2 1 /classes/Product.php:3401
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` = 45919 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` = 45919 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` = 17010 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` = 17010 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 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_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.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` = 14167 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` = 14167 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 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` = 14167) 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` = 17010) 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 *
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 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 = 14167
ORDER BY f.position ASC
0.2 1 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 (70897, 70898, 70899, 70900, 70901, 70902, 70903, 70904, 70905, 70906) AND il.`id_lang` = 3 ORDER by i.`position`
0.2 10 Yes /classes/Product.php:2529
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_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 15711) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 l.*, ls.`id_shop`
FROM `hd_lang` l
LEFT JOIN `hd_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.2 4 /classes/Language.php:991
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 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_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 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 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 = 17009
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 = 52104
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 = 49076
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 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 * FROM `hd_currency` c ORDER BY `iso_code` ASC
0.2 2 Yes /classes/Currency.php:695
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 = 15711
ORDER BY f.position ASC
0.2 1 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` = 15303) 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` = 49076
ORDER BY `position`
0.2 2 Yes /classes/Product.php:3096
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.2 1 /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` = 15711)
0.2 1 /classes/Product.php:3401
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.2 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 52493 LIMIT 1
0.2 1 /classes/Pack.php:85
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.2 2 /classes/Product.php:5753
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` = 17009) 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` = 51863) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name, alias FROM `hd_hook_alias`
0.2 88 /classes/Hook.php:336
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.2 1 /classes/Product.php:5753
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 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` = 14168)
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` = 52124) 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` = 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` = 14167) 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` = 45919) 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 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 = 51863
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
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` = 104 LIMIT 1
0.2 1 /classes/Category.php:1369
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 = 14168
ORDER BY f.position ASC
0.2 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE `name`, `alias` FROM `hd_hook_alias`
0.2 88 /classes/Hook.php:284
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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)
WHERE pa.`id_product_attribute` = 70897 LIMIT 1
0.2 1 /classes/Combination.php:462
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 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.2 1 /modules/px_cmspaymentblock/px_cmspaymentblock.php:256
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 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` = 14167
AND image_shop.`cover` = 1 LIMIT 1
0.2 2 /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 = 17010
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 = 45919
ORDER BY f.position ASC
0.2 1 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` = 52104)
0.2 1 /classes/Product.php:3401
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 *
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` = 98) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_order`
FROM `hd_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
0.2 1 /classes/order/Order.php:1193
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` = 51863)
0.2 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 17009 LIMIT 1
0.2 1 /classes/SpecificPrice.php:419
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` = 14167
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52493) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 17010
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 14167 AND `id_shop` = 1
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 45919
0.2 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 15711 LIMIT 1
0.2 1 /classes/SpecificPrice.php:419
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 `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 52493 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5871
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.2 1 Yes /classes/Product.php:5195
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 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 `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 51863
0.1 1 /classes/Product.php:2510
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 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` = 52493
AND image_shop.`cover` = 1 LIMIT 1
0.1 8 /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` = 15303
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 = 120 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 0 LIMIT 1
0.1 1 /classes/SpecificPrice.php:410
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` = 98) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 15303 LIMIT 1
0.1 2 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE *
FROM `hd_product_attribute` a
LEFT JOIN `hd_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 70897) 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 = 52493
ORDER BY f.position ASC
0.1 1 Yes /classes/Product.php:5195
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` = 45919
AND image_shop.`cover` = 1 LIMIT 1
0.1 2 /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` = 14168
AND image_shop.`cover` = 1 LIMIT 1
0.1 2 /classes/Product.php:3118
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 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 `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 `reduction`
FROM `hd_group`
WHERE `id_group` = 1 LIMIT 1
0.1 1 /classes/Group.php:154
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 104 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 14168 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "ProductBundlesPro" LIMIT 1
0.1 1 /classes/module/Module.php:2820
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 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` = 51863
AND image_shop.`cover` = 1 LIMIT 1
0.1 2 /classes/Product.php:3118
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 52493 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 17009
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
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 `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 15711
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2335
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 *
FROM `hd_product_lang`
WHERE `id_product` = 17010 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 17009 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 51863 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_cms_lang`
WHERE `id_cms` = 4 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 15711 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_product_lang`
WHERE `id_product` = 45919 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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.1 7 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 52493
0.1 10 /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 *
FROM `hd_cms_lang`
WHERE `id_cms` = 11 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_country_lang`
WHERE `id_country` = 8
0.1 3 /src/Adapter/EntityMapper.php:82
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 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 *
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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52493) AND (id_product_attribute = 70897) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE id_shop FROM hd_shop
0.1 2 /classes/shop/Shop.php:739
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 *
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 *
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.1 2 /classes/Product.php:5215
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 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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 14168) 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` = 14168
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 7) 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` = 14167)
0.1 1 /classes/Product.php:3401
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` = 99 LIMIT 1
0.1 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE format
FROM `hd_address_format`
WHERE `id_country` = 8 LIMIT 1
0.1 1 /classes/AddressFormat.php:676
SELECT SQL_NO_CACHE `id_page`
FROM `hd_page`
WHERE `id_page_type` = 18 LIMIT 1
0.1 2 /classes/Page.php:83
SELECT SQL_NO_CACHE product_attribute_shop.`price`
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)
WHERE pa.`id_product_attribute` = 70318 LIMIT 1
0.1 1 /classes/Combination.php:462
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 *
FROM `hd_link_block_lang`
WHERE `id_link_block` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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 *
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 = 14167
0.1 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` = 17010)
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` = 45919)
0.1 1 /classes/Product.php:3401
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 pa.`available_date` FROM `hd_product` p LEFT JOIN `hd_product_attribute` pa ON (pa.`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) 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) WHERE p.`id_product` = 52493 AND pa.`id_product` = 52493 AND pa.`id_product_attribute` = 70897 LIMIT 1
0.1 1 /classes/Product.php:949
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 *
FROM `hd_link_block_lang`
WHERE `id_link_block` = 2
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 51863) 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 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` = 17010
AND image_shop.`cover` = 1 LIMIT 1
0.1 3 /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` = 28 LIMIT 1
0.1 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 14168 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 104 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 15303 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 15711 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 17009 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE pa.`available_date` FROM `hd_product` p LEFT JOIN `hd_product_attribute` pa ON (pa.`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) 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) WHERE p.`id_product` = 52124 AND pa.`id_product` = 52124 AND pa.`id_product_attribute` = 70318 LIMIT 1
0.1 1 /classes/Product.php:949
SELECT SQL_NO_CACHE *
FROM `hd_shop_group` a
WHERE (a.`id_shop_group` = 2) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_link_block` a
WHERE (a.`id_link_block` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 51863 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 14167 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
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` = 120 LIMIT 1
0.1 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE `iso_code`
FROM `hd_country`
WHERE `id_country` = 8 LIMIT 1
0.1 1 /classes/Country.php:274
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 104 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 15303 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE id_shop
FROM `hd_supplier_shop`
WHERE `id_supplier` = 98
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1628
SELECT SQL_NO_CACHE * FROM `hd_vc_image_type` WHERE 1 ORDER BY `name` ASC
0.1 1 Yes /modules/jscomposer/classes/VcImageType.php:86
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.1 0 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 167 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 104 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 = 52124
0.1 1 /classes/Product.php:5215
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 104 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE c.id_currency
FROM `hd_currency` c
WHERE (iso_code = 'GBP') LIMIT 1
0.1 1 /classes/Currency.php:866
SELECT SQL_NO_CACHE *
FROM `hd_hook` a
WHERE (a.`id_hook` = 35) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
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` = 2) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 143 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2335
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 `id_module` FROM `hd_module` WHERE `name` = "jscomposer" LIMIT 1
0.1 1 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE *
FROM `hd_link_block` a
WHERE (a.`id_link_block` = 2) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 120 LIMIT 1
0.1 1 /classes/Product.php:4937
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` = 167 LIMIT 1
0.1 1 /classes/Category.php:1369
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 = 52104
0.1 1 /classes/Product.php:5215
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` = 48 LIMIT 1
0.1 1 /classes/Category.php:1369
SELECT SQL_NO_CACHE *
FROM `hd_cms_lang`
WHERE `id_cms` = 7 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE `to` BETWEEN '2022-01-22 00:00:00' AND '2022-01-22 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:365
SELECT SQL_NO_CACHE `need_identification_number`
FROM `hd_country`
WHERE `id_country` = 8 LIMIT 1
0.1 1 /classes/Country.php:401
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 14167 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 28 LIMIT 1
0.1 1 /classes/Product.php:4937
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 `id_lang` FROM `hd_lang` WHERE `iso_code` = 'en' LIMIT 1
0.1 2 /classes/Language.php:761
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 120 LIMIT 1
0.1 0 /classes/Category.php:1369
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_module` FROM `hd_module` WHERE `name` = "smartshortcode" LIMIT 1
0.1 0 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE *
FROM `hd_product_attribute` a
LEFT JOIN `hd_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 70318) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 15303 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 14168 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 120 LIMIT 1
0.1 1 /classes/Product.php:4937
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 = 99 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 52493 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM hd_required_field
0.1 1 /classes/ObjectModel.php:1491
SELECT SQL_NO_CACHE name FROM hd_image_type ORDER BY name ASC
0.1 7 /modules/jscomposer/jscomposer.php:3361
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` = 14167 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 52104 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2335
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 14168
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 48 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 15303 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE COUNT(*) FROM hd_shop LIMIT 1
0.1 2 /classes/shop/Shop.php:1163
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "smartblog" LIMIT 1
0.1 0 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE id_shop
FROM `hd_lang_shop`
WHERE `id_lang` = 3
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1628
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "revsliderprestashop" LIMIT 1
0.1 0 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 15711 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 52124 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 `id_module` FROM `hd_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2335
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 49076 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2335
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 14168 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_cms_lang`
WHERE `id_cms` = 2 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` = 21) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_group` a
LEFT JOIN `hd_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
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_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_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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 17009) 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 *
FROM `hd_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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_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 1 FROM `hd_specific_price` WHERE `from` BETWEEN '2022-01-22 00:00:00' AND '2022-01-22 23:59:59' LIMIT 1
0.1 1 /classes/SpecificPrice.php:361
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 15711) 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 *
FROM `hd_currency` a
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.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 14167) 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 *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 11) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
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 1 FROM `hd_specific_price` WHERE id_product = 52493 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
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 COUNT(*) FROM `hd_pack` WHERE id_product_pack = 15711 LIMIT 1
0.1 1 /classes/Pack.php:85
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_country`
FROM `hd_country`
WHERE `iso_code` = 'US' LIMIT 1
0.1 1 /classes/Country.php:193
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 17009 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 49076
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 49076 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 52104 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52124) AND (id_product_attribute = 70318) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
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 1 FROM `hd_specific_price` WHERE id_product = 45919 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 15303
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52104) 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_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_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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 17010) 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_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 52124 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE *
FROM `hd_country_lang`
WHERE `id_country` = 21
0.1 3 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52124) 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 SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 45919) 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 *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 4) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `hd_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.1 4 /classes/module/Module.php:2244
SELECT SQL_NO_CACHE 1 FROM `hd_specific_price` WHERE id_product = 17010 LIMIT 1
0.1 1 /classes/SpecificPrice.php:419
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 49076) 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 COUNT(*) FROM `hd_pack` WHERE id_product_pack = 52124 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 52104
0.1 1 /classes/Product.php:2510
SELECT SQL_NO_CACHE *
FROM `hd_currency_lang`
WHERE `id_currency` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 52104 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 104 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 51863 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 49076 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `hd_group_lang`
WHERE `id_group` = 1
0.1 1 /src/Adapter/EntityMapper.php:82
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_country`
FROM `hd_country`
WHERE `iso_code` = 'US' LIMIT 1
0.1 1 /classes/Country.php:193
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 17010 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 51863 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 14167
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 45919 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 49076 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 28 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 17010 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 48 LIMIT 1
0.1 1 /classes/Product.php:4937
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 17009 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 15303
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `hd_product_shop`
WHERE `id_product` = 45919 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5871
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 167 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 99 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `hd_specific_price_priority`
WHERE `id_product` = 49076
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.1 0 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 14167 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_module` FROM `hd_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2335
SELECT SQL_NO_CACHE id_shop
FROM `hd_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1628
SELECT SQL_NO_CACHE id_shop
FROM `hd_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1628
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 52104 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 52124 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 51863 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 49076 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 17010 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 45919 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156

Doubles

16
SELECT 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` = XX)
                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 = XX)
                LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX)
                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 = XX AND cal.id_shop = XX )
                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 = XX)
                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 = XX)
                WHERE  ate.`active` = XX AND (ate.`active_desktop` = XX || ate.`active_mobile` = XX) AND ate.`id_column` = XX
                AND ((ate.`id_manufacturer` = XX AND ate.`id_supplier` = XX AND ate.`id_category` = XX AND ate.`id_cms` = XX)
                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` = XX OR cms_shop.`id_shop` IS NULL) AND (manufacturer_shop.`id_shop` = XX OR manufacturer_shop.`id_shop` IS NULL) AND (supplier_shop.`id_shop` = XX OR supplier_shop.`id_shop` IS NULL)AND IF (ate.`id_category` IS NULL OR ate.`id_category` = XX, XX, cg.`id_group` IN (XX))
                GROUP BY ate.`id_element`
                ORDER BY ate.`position`
14
SELECT `id_order`
            FROM `hd_orders`
            WHERE `id_cart` = XX AND id_shop IN (XX) LIMIT XX
14
SELECT SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop_group = XX) AND (id_shop = XX) LIMIT XX
14
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `hd_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX 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` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
13
SELECT XX FROM `hd_specific_price` WHERE id_product = XX LIMIT XX
12
SELECT
                    p.*,
                    pl.*,
                    sa.out_of_stock,
                    IFNULL(sa.quantity, XX) as quantity,
                    (DATEDIFF(
				p.`date_add`,
				DATE_SUB(
					'XX-XX-XX XX:XX:XX',
					INTERVAL XX DAY
				)
			) > XX) as new
                FROM hd_product p
                LEFT JOIN hd_product_lang pl
                    ON pl.id_product = p.id_product
                    AND pl.id_shop = XX
                    AND pl.id_lang = XX
                LEFT JOIN hd_stock_available sa
			        ON sa.id_product = p.id_product 
			        AND sa.id_shop = XX
			    WHERE p.id_product = XX
12
            SELECT 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 = XX)
            LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
12
SELECT *
							FROM `hd_product_lang`
							WHERE `id_product` = XX AND `id_shop` = XX
12
SELECT *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) LIMIT XX
12
                SELECT 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 = XX)
                LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX)
                LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX)
                 INNER JOIN hd_feature_shop feature_shop
        ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX)
                WHERE pf.id_product = XX
                ORDER BY f.position ASC
12
			SELECT cl.`link_rewrite`
			FROM `hd_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
12
SELECT 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 = XX)
                    WHERE i.`id_product` = XX
                    AND image_shop.`cover` = XX LIMIT XX
12
SELECT name FROM hd_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
12
SELECT *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
12
SELECT COUNT(*) FROM `hd_pack` WHERE id_product_pack = XX LIMIT XX
12
SELECT product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,XX) 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 = XX)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX)
WHERE (p.`id_product` = XX)
12
                            SELECT `id_tax_rules_group`
                            FROM `hd_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT XX
12
SELECT `id_product_attribute`
            FROM `hd_product_attribute`
            WHERE `id_product` = XX
12
			SELECT `reduction`
			FROM `hd_product_group_reduction_cache`
			WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
8
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX 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 = XX)
            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` = XX)
            JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
6
SELECT `id_module` FROM `hd_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
6
			SELECT *, ( IF (`id_group` = XX, XX, XX) +  IF (`id_country` = XX, XX, XX) +  IF (`id_currency` = XX, XX, XX) +  IF (`id_shop` = XX, XX, XX) +  IF (`id_customer` = XX, XX, XX)) AS `score`
				FROM `hd_specific_price`
				WHERE
                `id_shop` IN (XX, XX) AND
                `id_currency` IN (XX, XX) AND
                `id_country` IN (XX, XX) AND
                `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX  AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)
				AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
6
        SELECT *
        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 = XX)
        WHERE pa.id_product = XX
6
				SELECT `priority`, `id_specific_price_priority`
				FROM `hd_specific_price_priority`
				WHERE `id_product` = XX
				ORDER BY `id_specific_price_priority` DESC LIMIT XX
5
SELECT *
FROM `hd_cms` a
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX
WHERE (a.`id_cms` = XX) LIMIT XX
5
                SELECT 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` = XX AND ctg.`id_group` = XX LIMIT XX
5
SELECT *
							FROM `hd_cms_lang`
							WHERE `id_cms` = XX AND `id_shop` = XX
4
SELECT 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` = XX)
                WHERE  atmcw.`active` = XX AND (atmcw.`active_desktop` = XX || atmcw.`active_mobile` = XX) AND atmcw.`id_menu` = XX
                ORDER BY atmcw.`position`
4
                SELECT 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` = XX
4
SELECT `id_lang` FROM `hd_lang`
                    WHERE `locale` = 'en-us'
                    OR `language_code` = 'en-us' LIMIT XX
2
SELECT pa.`available_date` FROM `hd_product` p LEFT JOIN `hd_product_attribute` pa ON (pa.`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 = XX) 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 = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
2
SELECT *
FROM `hd_lang` a
LEFT JOIN `hd_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = XX
WHERE (a.`id_lang` = XX) LIMIT XX
2
(SELECT XX FROM `hd_cart_rule` WHERE date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `hd_cart_rule` WHERE date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX)UNION ALL (SELECT XX FROM `hd_cart_rule` WHERE date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX" AND `id_customer` IN (XX,XX) LIMIT XX) LIMIT XX
2
SELECT m.`name` FROM `hd_module` m
        JOIN `hd_module_shop` ms ON (m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX)
            WHERE m.active=XX
2
			SELECT `id_country`
			FROM `hd_country`
			WHERE `iso_code` = 'US' LIMIT XX
2
SELECT *
FROM `hd_supplier` a
LEFT JOIN `hd_supplier_lang` `b` ON a.`id_supplier` = b.`id_supplier` AND b.`id_lang` = XX
LEFT JOIN `hd_supplier_shop` `c` ON a.`id_supplier` = c.`id_supplier` AND c.`id_shop` = XX
WHERE (a.`id_supplier` = XX) LIMIT XX
2
SELECT *
FROM `hd_product_attribute` a
LEFT JOIN `hd_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX
WHERE (a.`id_product_attribute` = XX) LIMIT XX
2
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, 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` = XX)
            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 = XX)
            LEFT JOIN `hd_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
            WHERE pa.`id_product` = XX
                AND pac.`id_product_attribute` = XX
                AND agl.`id_lang` = XX
2
				SELECT 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` = XX
				AND tr.`id_country` = XX
				AND tr.`id_tax_rules_group` = XX
				AND tr.`id_state` IN (XX, XX)
				AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
					OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX')))
				ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2
			SELECT product_attribute_shop.`price`
			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 = XX)
			WHERE pa.`id_product_attribute` = XX LIMIT XX
2
SELECT *
FROM `hd_link_block` a
WHERE (a.`id_link_block` = XX) LIMIT XX
2
SELECT *
FROM `hd_currency` a
LEFT JOIN `hd_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX
LEFT JOIN `hd_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX
WHERE (a.`id_currency` = XX) LIMIT XX
2
SELECT 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` = XX)
                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 = XX)
                LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = XX)
                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 = XX AND cal.id_shop = XX )
                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 = XX)
                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 = XX)
                WHERE  atmc.`active` = XX AND (atmc.`active_desktop` = XX || atmc.`active_mobile` = XX) AND  atmc.`id_wrap` = XX
                AND ((atmc.`id_manufacturer` = XX AND atmc.`id_supplier` = XX AND atmc.`id_category` = XX AND atmc.`id_cms` = XX)
                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` = XX, XX, cg.`id_group` IN (XX))
                GROUP BY atmc.`id_column`
                ORDER BY atmc.`position`
2
SELECT *
							FROM `hd_link_block_lang`
							WHERE `id_link_block` = XX
2
        		SELECT *
        		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 = XX
		 AND ml.id_shop = XX LIMIT XX
2
SELECT *
							FROM `hd_country_lang`
							WHERE `id_country` = XX
2
SELECT *
FROM `hd_country` a
LEFT JOIN `hd_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX
WHERE (a.`id_country` = XX) LIMIT XX
2
SELECT hm.`id_module`
                    FROM `hd_hook_module` hm, `hd_hook` h
                    WHERE hm.`id_module` = XX AND h.`id_hook` = XX
                    AND h.`id_hook` = hm.`id_hook` AND `id_shop` = XX LIMIT XX

Tables stress

68 product
54 product_shop
46 category_lang
38 product_lang
30 product_attribute_shop
29 product_attribute
29 cart_product
28 stock_available
27 category_group
27 image
26 pack
26 image_shop
24 cms
24 cms_shop
24 cms_lang
23 specific_price
23 category
22 supplier
22 supplier_shop
21 manufacturer
19 manufacturer_shop
16 image_lang
16 pm_advancedtopmenu_elements
16 pm_advancedtopmenu_elements_lang
15 module
14 module_shop
14 orders
12 feature_shop
12 feature
12 feature_value_lang
12 feature_lang
12 feature_product
12 product_group_reduction_cache
10 product_attribute_combination
10 attribute_lang
10 attribute
9 lang
8 country
8 attribute_group
7 hook
7 category_product
7 currency
6 product_attachment
6 cart_rule
6 shop
6 specific_price_priority
6 attachment_lang
6 attachment
5 shop_url
5 lang_shop
5 vccontentanywhere
5 ets_ctf_contact_lang
5 meta
5 meta_lang
5 currency_shop
5 ets_ctf_contact
5 ets_ctf_contact_shop
4 pm_advancedtopmenu_columns_wrap
4 pm_advancedtopmenu_columns_wrap_lang
4 vccontentanywhere_shop
4 vccontentanywhere_lang
4 hook_module
4 country_lang
4 country_shop
3 tax_rule
3 link_block
3 currency_lang
3 hook_alias
2 configuration
2 pm_advancedtopmenu_columns_lang
2 product_attribute_image
2 attribute_group_lang
2 product_supplier
2 supplier_lang
2 group
2 group_shop
2 category_shop
2 shop_group
2 link_block_lang
2 tax_rules_group
2 image_type
2 pm_advancedtopmenu_columns
1 connections
1 configuration_lang
1 pxcmspaymentblockinfo_lang
1 pxcmspaymentblockinfo
1 page_type
1 tab
1 pm_advancedtopmenu_lang
1 pm_advancedtopmenu_shop
1 pm_advancedtopmenu
1 pxcmsheaderblockinfo_lang
1 pxcmsheaderblockinfo
1 module_group
1 group_lang
1 hook_module_exceptions
1 zone
1 state
1 vc_image_type
1 address_format
1 tax_lang
1 tax
1 required_field
1 page

ObjectModel instances

NameInstancesSource
Product 44 /classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/src/Adapter/Image/ImageRetriever.php [62]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/src/Adapter/Image/ImageRetriever.php [62]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/src/Adapter/Image/ImageRetriever.php [62]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/src/Adapter/Image/ImageRetriever.php [62]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/classes/Link.php [106]
/modules/lmcustom/lmcustom.php [167]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/src/Adapter/Image/ImageRetriever.php [62]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
/classes/Link.php [106]
Combination 12 /classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
/classes/Product.php [5123]
Supplier 8 /controllers/front/listing/SupplierController.php [55]
/classes/Meta.php [454]
/classes/Link.php [596]
/classes/Link.php [596]
/classes/Link.php [596]
/classes/Link.php [596]
/classes/Link.php [596]
/classes/Link.php [596]
CMS 6 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [134]
Country 4 /config/config.inc.php [147]
/classes/controller/FrontController.php [893]
/classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1647]
Address 4 /classes/shop/Shop.php [465]
/classes/Product.php [3238]
/classes/Product.php [3347]
/classes/Product.php [5145]
Language 3 /config/config.inc.php [200]
/classes/Tools.php [646]
/classes/Tools.php [569]
Currency 3 /src/Adapter/Currency/CurrencyDataProvider.php [101]
/src/Adapter/Currency/CurrencyDataProvider.php [101]
/classes/Tools.php [690]
State 2 /classes/AddressFormat.php [404]
/classes/controller/FrontController.php [1646]
Hook 2 /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [60]
/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php [60]
PrestaShop\Module\LinkList\Model\LinkBlock 2 /modules/ps_linklist/src/LegacyLinkBlockRepository.php [75]
/modules/ps_linklist/src/LegacyLinkBlockRepository.php [75]
Shop 1 /config/config.inc.php [118]
Guest 1 /modules/statsdata/statsdata.php [77]
Category 1 /modules/ps_categorytree/ps_categorytree.php [320]
Risk 1 /classes/controller/FrontController.php [1608]
AddressFormat 1 /classes/controller/FrontController.php [1641]
Gender 1 /classes/controller/FrontController.php [1605]
vccontentanywhere 1 /modules/jscomposer/jscomposer.php [2597]
Group 1 /classes/Cart.php [246]
Cart 1 /classes/controller/FrontController.php [416]
Customer 1 /config/config.inc.php [226]
ShopGroup 1 /classes/shop/Shop.php [549]
Connection 1 /modules/statsdata/statsdata.php [111]

Included Files

#Filename
1/index.php
2/config/config.inc.php
3/config/defines.inc.php
4/config/autoload.php
5/vendor/autoload.php
6/vendor/composer/autoload_real.php
7/vendor/composer/platform_check.php
8/vendor/composer/ClassLoader.php
9/vendor/composer/include_paths.php
10/vendor/composer/autoload_static.php
11/vendor/symfony/polyfill-mbstring/bootstrap.php
12/vendor/react/promise/src/functions_include.php
13/vendor/react/promise/src/functions.php
14/vendor/symfony/polyfill-php72/bootstrap.php
15/vendor/symfony/polyfill-intl-idn/bootstrap.php
16/vendor/symfony/polyfill-ctype/bootstrap.php
17/vendor/symfony/polyfill-iconv/bootstrap.php
18/vendor/swiftmailer/swiftmailer/lib/swift_required.php
19/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
20/vendor/paragonie/random_compat/lib/random.php
21/vendor/symfony/polyfill-php73/bootstrap.php
22/vendor/symfony/polyfill-php70/bootstrap.php
23/vendor/symfony/polyfill-php56/bootstrap.php
24/vendor/symfony/polyfill-intl-icu/bootstrap.php
25/vendor/symfony/polyfill-apcu/bootstrap.php
26/vendor/markbaker/matrix/classes/src/functions/adjoint.php
27/vendor/markbaker/matrix/classes/src/functions/antidiagonal.php
28/vendor/markbaker/matrix/classes/src/functions/cofactors.php
29/vendor/markbaker/matrix/classes/src/functions/determinant.php
30/vendor/markbaker/matrix/classes/src/functions/diagonal.php
31/vendor/markbaker/matrix/classes/src/functions/identity.php
32/vendor/markbaker/matrix/classes/src/functions/inverse.php
33/vendor/markbaker/matrix/classes/src/functions/minors.php
34/vendor/markbaker/matrix/classes/src/functions/trace.php
35/vendor/markbaker/matrix/classes/src/functions/transpose.php
36/vendor/markbaker/matrix/classes/src/operations/add.php
37/vendor/markbaker/matrix/classes/src/operations/directsum.php
38/vendor/markbaker/matrix/classes/src/operations/subtract.php
39/vendor/markbaker/matrix/classes/src/operations/multiply.php
40/vendor/markbaker/matrix/classes/src/operations/divideby.php
41/vendor/markbaker/matrix/classes/src/operations/divideinto.php
42/vendor/markbaker/complex/classes/src/functions/abs.php
43/vendor/markbaker/complex/classes/src/functions/acos.php
44/vendor/markbaker/complex/classes/src/functions/acosh.php
45/vendor/markbaker/complex/classes/src/functions/acot.php
46/vendor/markbaker/complex/classes/src/functions/acoth.php
47/vendor/markbaker/complex/classes/src/functions/acsc.php
48/vendor/markbaker/complex/classes/src/functions/acsch.php
49/vendor/markbaker/complex/classes/src/functions/argument.php
50/vendor/markbaker/complex/classes/src/functions/asec.php
51/vendor/markbaker/complex/classes/src/functions/asech.php
52/vendor/markbaker/complex/classes/src/functions/asin.php
53/vendor/markbaker/complex/classes/src/functions/asinh.php
54/vendor/markbaker/complex/classes/src/functions/atan.php
55/vendor/markbaker/complex/classes/src/functions/atanh.php
56/vendor/markbaker/complex/classes/src/functions/conjugate.php
57/vendor/markbaker/complex/classes/src/functions/cos.php
58/vendor/markbaker/complex/classes/src/functions/cosh.php
59/vendor/markbaker/complex/classes/src/functions/cot.php
60/vendor/markbaker/complex/classes/src/functions/coth.php
61/vendor/markbaker/complex/classes/src/functions/csc.php
62/vendor/markbaker/complex/classes/src/functions/csch.php
63/vendor/markbaker/complex/classes/src/functions/exp.php
64/vendor/markbaker/complex/classes/src/functions/inverse.php
65/vendor/markbaker/complex/classes/src/functions/ln.php
66/vendor/markbaker/complex/classes/src/functions/log2.php
67/vendor/markbaker/complex/classes/src/functions/log10.php
68/vendor/markbaker/complex/classes/src/functions/negative.php
69/vendor/markbaker/complex/classes/src/functions/pow.php
70/vendor/markbaker/complex/classes/src/functions/rho.php
71/vendor/markbaker/complex/classes/src/functions/sec.php
72/vendor/markbaker/complex/classes/src/functions/sech.php
73/vendor/markbaker/complex/classes/src/functions/sin.php
74/vendor/markbaker/complex/classes/src/functions/sinh.php
75/vendor/markbaker/complex/classes/src/functions/sqrt.php
76/vendor/markbaker/complex/classes/src/functions/tan.php
77/vendor/markbaker/complex/classes/src/functions/tanh.php
78/vendor/markbaker/complex/classes/src/functions/theta.php
79/vendor/markbaker/complex/classes/src/operations/add.php
80/vendor/markbaker/complex/classes/src/operations/subtract.php
81/vendor/markbaker/complex/classes/src/operations/multiply.php
82/vendor/markbaker/complex/classes/src/operations/divideby.php
83/vendor/markbaker/complex/classes/src/operations/divideinto.php
84/vendor/jakeasmith/http_build_url/src/http_build_url.php
85/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
86/vendor/ircmaxell/password-compat/lib/password.php
87/vendor/martinlindhe/php-mb-helpers/src/mb_helpers.php
88/app/AppKernel.php
89/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/Kernel.php
90/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/KernelInterface.php
91/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/HttpKernelInterface.php
92/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/RebootableInterface.php
93/vendor/symfony/symfony/src/Symfony/Component/HttpKernel/TerminableInterface.php
94/config/alias.php
95/classes/PrestaShopAutoload.php
96/app/cache/dev/class_index.php
97/config/bootstrap.php
98/src/Core/ContainerBuilder.php
99/src/Core/Foundation/IoC/Container.php
100/src/Adapter/ServiceLocator.php
101/vendor/symfony/symfony/src/Symfony/Component/Filesystem/Files