FOR RENT- GMAW (MIG) welding machine 350A/380V, portable

LOCMIG350

EWM PICOMIG 355 synergic welding machine is powerful with 350 A (270 A -100 %), 380 V and air cooled.

Perfect settings for welding with wires diam. 1 - 1.6 mm. in various activities such as repairing, naval industry, on-site assembly, maintenance.

This unit is powerful and easy to carry on-site and can be plugged to powergenerators giving the welder a really constant arc stability.

Settings are easy to handle thanks to built-in synergic characteristics for steel, CrNi and aluminium.

We ship our equipement for rent in France and in most EU countries. Check up with our team members for availability.

Better rates per week or per month. 

Show more Show less
From
(per day)
14.00 € (tax excl.)
14.00 € (tax incl.)
Quantity
Open contact form
close

Demande de devis






 
Calculate my hire cost
SAV par HD Soudage
SAV par HD Soudage
Expédié en 24H
Expédié en 24H
SAV par HD Soudage
Secure payment Secure payment
Expédié en 24H
Payment 3 or 4 times
Learn more
Need advice, a question?
Need advice, a question?

Calculate the hire cost

State your start and end dates to know the hire cost :

€28.00 (tax excl.)*
28 (tax incl.)
A total of €28.00 (tax excl.)
28 (tax incl.)
day

* This price does not include delivery and collection costs, deposit or consumables.

HD Soudage offers discount for volume

- 30% 7 to 20 days
- 50% Over 20 days

HD SOUDAGE has selected the EWM PICOMIG 355 synergic GMAW welding unit because it is strong, powerful and easy to use. This device is the universal machine for more than 80% of jobs.

Our customers really appreciate :

- one-knob operation

- compact with integrated wire feed mechanism

- ready-to-use synergic characteristics for steel, CrNi and aluminium.

This equipment FOR RENT includes :

- PICOMIG inverter welding unit

- Welding gun L 4m, air cooled

- Earth cable L 3 m

- Regulator + gas hose (according to country standard)

Option : Certificate of calibration can be provided

Main informations :

Voltage : 3x 400 V(-25%/+25%)

Setting range for welding current : 5A-350A, Duty cycle (40°C) : 270A (100%), 350A (40%)

Dimensions : 610 x 300 x 330 mm

Weight : 33.4 Kg

Type
380 V
Option
350A - Air cooled
HD Soudage Avis sur ekomi.fr

You might also like

Load Time2922 ms - You'd better run your shop on a toaster
Querying Time1759 ms
Queries507
Memory Peak Usage21.6 Mb
Included Files1069 files - 11.81 Mb
PrestaShop Cache- Mb
Global vars0.27 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 95 ms 95 ms 4.74 Mb 5.49 Mb
__construct 0 ms 95 ms - Mb 5.49 Mb
init 199 ms 295 ms 3.64 Mb 8.51 Mb
checkAccess 0 ms 295 ms - Mb 8.51 Mb
setMedia 4 ms 298 ms 0.33 Mb 9.26 Mb
postProcess 0 ms 298 ms - Mb 9.26 Mb
initHeader - ms 298 ms - Mb 9.26 Mb
initContent 682 ms 981 ms 5.47 Mb 14.18 Mb
initFooter 0 ms 981 ms - Mb 14.18 Mb
display 1942 ms 2922 ms 7.20 Mb 21.65 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 507 queries

Query Time (ms) Rows Filesort Group By Location
INSERT INTO `hd_address` (`id_customer`, `id_manufacturer`, `id_supplier`, `id_warehouse`, `id_country`, `id_state`, `alias`, `company`, `lastname`, `firstname`, `vat_number`, `address1`, `address2`, `postcode`, `city`, `other`, `phone`, `phone_mobile`, `dni`, `deleted`, `date_add`, `date_upd`) VALUES ('0', '0', '0', '0', '21', '0', 'TEMPORARY_ADDRESS_TO_DELETE', '', '.', '.', '', '.', '', '', '.', '', '0000000000', '0000000000', '.', '0', '2022-01-22 21:14:38', '2022-01-22 21:14:38')
165.4 1 /classes/ObjectModel.php:559
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')
123.4 1 /classes/ObjectModel.php:559
INSERT INTO `hd_cart_product` (`id_product`, `id_product_attribute`, `id_cart`, `id_address_delivery`, `id_shop`, `quantity`, `date_add`, `id_customization`) VALUES ('52452', '0', '2370039', '0', '1', '1', '2022-01-22 21:14:38', '0')
123.3 1 /classes/Cart.php:1625
SELECT SQL_NO_CACHE DISTINCT od.product_id 
FROM hd_order_detail od 
LEFT JOIN `hd_product` p ON (p.`id_product` = od.`product_id`)
LEFT JOIN `hd_category_product` cp ON (cp.`id_category` = p.`id_category_default` AND cp.`id_product` = od.`product_id`)
LEFT JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category` AND ctg.`id_group` = 1)
WHERE od.product_id NOT IN (52452) AND od.id_order IN (
SELECT od.id_order FROM hd_orders o
JOIN hd_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1 AND od.product_id IN (52452) AND TO_DAYS("2022-01-22 00:00:00") - TO_DAYS(o.date_add) <= 160
)
AND ctg.id_group IS NOT NULL 
LIMIT 3
119.1 1 /modules/pm_crosssellingoncart/pm_crosssellingoncart.php:885
INSERT INTO `hd_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('0', '1', '2334950', '0', '0', '1', '0', '0', '3', '0', '0', '', '0', '', '', '0', '2022-01-22 21:14:38', '2022-01-22 21:14:38')
103.6 1 /classes/ObjectModel.php:559
DELETE FROM `hd_cart_product` WHERE `id_cart` = 2370039
82.1 1 /classes/Cart.php:402
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity,
IF(product_attribute_shop.wholesale_price > 0,  product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price
,
image_shop.`id_image` id_image, il.`legend`
FROM `hd_cart_product` cp
LEFT JOIN `hd_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `hd_product_lang` `pl` ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = cp.id_shop 
LEFT JOIN `hd_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = cp.id_shop 
LEFT JOIN `hd_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`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 = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `hd_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 2370039
LEFT JOIN `hd_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
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 il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 3
WHERE (cp.`id_cart` = 2370039) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
78.6 1 Yes Yes /override/classes/Cart.php:115
UPDATE hd_cart
SET id_address_delivery = 0
WHERE id_address_delivery = 2334950
76.9 1 /classes/Address.php:252
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN hd_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52452
74.5 1 /classes/Product.php:6462
INSERT INTO `hd_page` (`id_page_type`, `id_object`) VALUES ('5', '52452')
71.8 1 /classes/Page.php:88
DELETE FROM `hd_cart` WHERE `id_cart` = 2370039
70.9 1 /classes/ObjectModel.php:858
DELETE FROM `hd_address` WHERE `id_address` = 2334950
66.7 1 /classes/ObjectModel.php:858
INSERT INTO `hd_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('15999', '1412', '56097438', '', '1', '2', '2022-01-22 21:14:39')
66.6 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`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2022-01-22 00:00:00",
INTERVAL 30 DAY
)
) > 0 AS new
FROM `hd_accessory`
LEFT JOIN `hd_product` p ON p.`id_product` = `id_product_2`
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 (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_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.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_manufacturer` m ON (p.`id_manufacturer`= m.`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  )
WHERE `id_product_1` = 52452 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
63.4 6 Yes Yes /classes/Product.php:4137
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
46.5 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE cr.*
FROM hd_cart_rule cr
LEFT JOIN hd_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN hd_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN hd_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN hd_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 1
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `hd_cart_product`
WHERE `hd_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 2370039
)
)
AND NOT EXISTS (SELECT 1 FROM hd_cart_cart_rule WHERE cr.id_cart_rule = hd_cart_cart_rule.id_cart_rule
AND id_cart = 2370039)
ORDER BY priority
41.9 1 Yes /classes/CartRule.php:1633
SELECT SQL_NO_CACHE *
FROM `hd_carrier` a
LEFT JOIN `hd_carrier_shop` `c` ON a.`id_carrier` = c.`id_carrier` AND c.`id_shop` = 1
WHERE (a.`id_carrier` = 142) LIMIT 1
37.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_adod_product`
WHERE (id_product = 52452) LIMIT 1
33.6 1 /modules/advanceddateofdelivery/advanceddateofdelivery.php:1905
SELECT SQL_NO_CACHE *
FROM `hd_manufacturer` a
LEFT JOIN `hd_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 3
LEFT JOIN `hd_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 108) LIMIT 1
30.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_carrier_lang`
WHERE `id_carrier` = 142 AND `id_shop` = 1
29.4 685 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE COUNT(`id_order`) AS used
FROM `hd_orders`
WHERE `id_address_delivery` = 2334950
OR `id_address_invoice` = 2334950 LIMIT 1
26.9 2 /classes/Address.php:401
SELECT SQL_NO_CACHE cd.`value`
FROM `hd_customized_data` cd
INNER JOIN `hd_customization` c ON (cd.`id_customization`= c.`id_customization`)
WHERE cd.`type`= 0 AND c.`id_cart`=2370039
19.9 1 /classes/Cart.php:379
SELECT SQL_NO_CACHE * FROM hd_product_carrier WHERE id_product = 52452
19.8 1 /override/modules/advanceddateofdelivery/advanceddateofdelivery.php:140
SELECT SQL_NO_CACHE * 
FROM `hd_adod_carriers` 
WHERE `id_carrier_reference` = 142 LIMIT 1
17.4 1 /modules/advanceddateofdelivery/advanceddateofdelivery.php:2467
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` = 2370039 AND cp.`id_product` = 52452 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` = 2370039 AND p.`id_product_item` = 52452 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
13.9 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_ets_ctf_contact_lang`
WHERE `id_contact` = 1
12.7 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_page`
FROM `hd_page`
WHERE `id_page_type` = 5 AND `id_object` = 52452 LIMIT 1
10.3 1 /classes/Page.php:83
SELECT SQL_NO_CACHE count(*) FROM `hd_orders` WHERE `id_cart` = 2370039 LIMIT 1
10 1 /classes/Cart.php:1798
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 14687 LIMIT 1
9.9 3 /classes/Product.php:856
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` = 70548
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 14687 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` = 70548
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 14687 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
9.8 0 /classes/Cart.php:1404
UPDATE hd_cart
SET id_address_invoice = 0
WHERE id_address_invoice = 2334950
8.1 1 /classes/Address.php:256
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`)
4 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.3 5096 Yes Yes /classes/Hook.php:1161
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.5 25 Yes /override/modules/pm_crosssellingoncart/pm_crosssellingoncart.php:83
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `hd_hook_module` hm
STRAIGHT_JOIN `hd_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `hd_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.4 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.4 244 Yes /classes/Country.php:147
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 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.9 32 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuClass.php:244
SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart`
FROM `hd_cart_cart_rule` cd
LEFT JOIN `hd_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule`
LEFT JOIN `hd_cart_rule_lang` crl ON (
cd.`id_cart_rule` = crl.`id_cart_rule`
AND crl.id_lang = 3
)
WHERE `id_cart` = 2370039
AND gift_product != 0
ORDER by cr.priority ASC, cr.gift_product DESC
0.9 1 Yes /classes/Cart.php:506
SELECT SQL_NO_CACHE * FROM `hd_state` ORDER BY `name` ASC
0.8 421 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`,
pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`,
p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`,
product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price_ratio`,
stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`,
p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category,
CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery,
product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference,
cu.`id_customization`, cu.`quantity` AS customization_quantity,
product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr,
IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference,
(p.`weight`+ pa.`weight`) weight_attribute,
IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13,
IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn,
IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc,
IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity,
IF(product_attribute_shop.wholesale_price > 0,  product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price
,
image_shop.`id_image` id_image, il.`legend`
FROM `hd_cart_product` cp
LEFT JOIN `hd_product` `p` ON p.`id_product` = cp.`id_product`
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`)
LEFT JOIN `hd_product_lang` `pl` ON p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 3 AND pl.id_shop = cp.id_shop 
LEFT JOIN `hd_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 3 AND cl.id_shop = cp.id_shop 
LEFT JOIN `hd_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`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 = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `hd_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 2370039
LEFT JOIN `hd_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute`
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`)
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 il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 3
WHERE (cp.`id_cart` = 2370039) AND (p.`id_product` IS NOT NULL)
GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization`
ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
0.7 1 Yes Yes /override/classes/Cart.php:115
SELECT SQL_NO_CACHE atmc.*, atmcl.*,
cl.link_rewrite, cl.meta_title,
cal.link_rewrite as category_link_rewrite, cal.name as category_name,
m.name as manufacturer_name,
s.name as supplier_name
FROM `hd_pm_advancedtopmenu_columns` atmc
LEFT JOIN `hd_pm_advancedtopmenu_columns_lang` atmcl ON (atmc.`id_column` = atmcl.`id_column` AND atmcl.`id_lang` = 3)
LEFT JOIN hd_cms c ON (c.id_cms = atmc.`id_cms`)
LEFT JOIN hd_cms_shop cms_shop
ON (cms_shop.id_cms = c.id_cms AND cms_shop.id_shop = 1)
LEFT JOIN hd_cms_lang cl ON (c.id_cms = cl.id_cms AND cl.id_lang = 3)
LEFT JOIN hd_category ca ON (ca.id_category = atmc.`id_category`)
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = ca.`id_category`)
LEFT JOIN hd_category_lang cal ON (ca.id_category = cal.id_category AND cal.id_lang = 3 AND cal.id_shop = 1 )
LEFT JOIN `hd_manufacturer` m ON (atmc.`id_manufacturer` = m.`id_manufacturer`)
LEFT JOIN hd_manufacturer_shop manufacturer_shop
ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)
LEFT JOIN `hd_supplier` s ON (atmc.`id_supplier` = s.`id_supplier`)
LEFT JOIN hd_supplier_shop supplier_shop
ON (supplier_shop.id_supplier = s.id_supplier AND supplier_shop.id_shop = 1)
WHERE  atmc.`active` = 1 AND (atmc.`active_desktop` = 1 || atmc.`active_mobile` = 1) AND  atmc.`id_wrap` = 5
AND ((atmc.`id_manufacturer` = 0 AND atmc.`id_supplier` = 0 AND atmc.`id_category` = 0 AND atmc.`id_cms` = 0)
OR c.id_cms IS NOT NULL OR m.id_manufacturer IS NOT NULL OR ca.id_category IS NOT NULL OR s.`id_supplier` IS NOT NULL)AND IF (atmc.`id_category` IS NULL OR atmc.`id_category` = 0, 1, cg.`id_group` IN (1))
GROUP BY atmc.`id_column`
ORDER BY atmc.`position`
0.7 96 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnClass.php:247
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN hd_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `hd_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `hd_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN hd_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52452
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 1 Yes Yes /classes/Product.php:4048
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
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)
LEFT JOIN hd_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 2  AND stock.id_shop = 0  )
LEFT JOIN `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `hd_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `hd_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN hd_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52452
AND al.`id_lang` = 3
AND agl.`id_lang` = 3
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.6 1 Yes Yes /classes/Product.php:4048
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 "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0  AND v.`prd_page` = 1 ) ) UNION
SELECT v_1.*,vl_1.content,vs_1.id_shop FROM `hd_vccontentanywhere` v_1
INNER JOIN `hd_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `hd_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "DisplayNavFullWidth" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 52452) ORDER BY `position` ASC
0.6 0 /modules/jscomposer/classes/vccontentanywhere.php:147
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 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 "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0  AND v.`prd_page` = 1 ) ) UNION
SELECT v_1.*,vl_1.content,vs_1.id_shop FROM `hd_vccontentanywhere` v_1
INNER JOIN `hd_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `hd_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "DisplayFooterBefore" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 52452) ORDER BY `position` ASC
0.6 0 /modules/jscomposer/classes/vccontentanywhere.php:147
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` = 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 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 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 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 "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0  AND v.`prd_page` = 1 ) ) UNION
SELECT v_1.*,vl_1.content,vs_1.id_shop FROM `hd_vccontentanywhere` v_1
INNER JOIN `hd_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `hd_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "DisplayFooterAfter" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 52452) ORDER BY `position` ASC
0.5 0 /modules/jscomposer/classes/vccontentanywhere.php:147
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` = 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 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 (14687) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 3 Yes Yes /classes/Product.php:3993
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 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 `id_hook`, `name` FROM `hd_hook`
0.5 637 /classes/Hook.php:1221
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 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.5 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE id_tab, class_name FROM `hd_tab`
0.5 183 /classes/Tab.php:340
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.5 106 Yes /classes/Dispatcher.php:643
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 "%product%") OR ( v.`exception_type` != 1 AND v.`display_type`= 1 ) OR ( v.`exception_type` != 1 AND v.`display_type` = 0  AND v.`prd_page` = 1 ) ) UNION
SELECT v_1.*,vl_1.content,vs_1.id_shop FROM `hd_vccontentanywhere` v_1
INNER JOIN `hd_vccontentanywhere_lang` vl_1 ON (v_1.`id_vccontentanywhere` = vl_1.`id_vccontentanywhere` AND vl_1.`id_lang` = 3)
INNER JOIN `hd_vccontentanywhere_shop` vs_1 ON (v_1.`id_vccontentanywhere` = vs_1.`id_vccontentanywhere` AND vs_1.`id_shop` = 1 AND v_1.`active` = 1) INNER JOIN `hd_vccontentanywhere_filter` vs_f_1 ON (vs_f_1.`id_vccontentanywhere` = v_1.`id_vccontentanywhere` ) WHERE v_1.`hook_name` = "displayFooter" AND v_1.active = 1 AND v_1.`exception_type` != 1 AND (vs_f_1.page = 1 AND vs_f_1.id_specify_page = 52452) ORDER BY `position` ASC
0.5 0 /modules/jscomposer/classes/vccontentanywhere.php:147
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 = 14687
ORDER BY f.position ASC
0.5 2 Yes /classes/Product.php:5195
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.4 24 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `hd_category` c
INNER JOIN hd_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `hd_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 3  AND cl.id_shop = 1 )
LEFT JOIN `hd_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 131
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.4 5 Yes Yes /classes/Category.php:918
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 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` = 52452
ORDER BY `position`
0.4 3 Yes /classes/Product.php:3096
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` = 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 *
FROM `hd_ets_ctf_contact` a
LEFT JOIN `hd_ets_ctf_contact_lang` `b` ON a.`id_contact` = b.`id_contact` AND b.`id_lang` = 3
WHERE (a.`id_contact` = 1) LIMIT 1
0.4 2 /src/Adapter/EntityMapper.php:75
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.4 2 Yes /classes/shop/Shop.php:1341
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` = 14719
ORDER BY `position`
0.4 1 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE `id_guest`
FROM `hd_connections`
WHERE `id_guest` = 15999
AND `date_add` > '2022-01-22 20:44: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 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.3 8 Yes Yes /modules/pm_advancedtopmenu/AdvancedTopMenuElementsClass.php:183
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 14718
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
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.3 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 "%displayTop%" AND cs.id_shop="1";
0.3 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE SUM(quantity)
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE o.id_order
FROM hd_orders o
LEFT JOIN hd_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (52452)
0.3 1 /modules/ps_crossselling/ps_crossselling.php:251
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.3 102 /classes/module/Module.php:322
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2022-01-22 00:00:00',
INTERVAL 30 DAY
)
) > 0) as new
FROM hd_product p
LEFT JOIN hd_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 3
LEFT JOIN hd_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 15303
0.3 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN hd_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52452
0.3 1 /classes/Product.php:6462
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 stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity
FROM hd_product p
INNER 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  )
WHERE p.id_product = 52452 LIMIT 1
0.3 1 /classes/Cart.php:1600
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 cr.*
FROM hd_cart_rule cr
LEFT JOIN hd_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN hd_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN hd_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN hd_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 1
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `hd_cart_product`
WHERE `hd_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 2370039
)
)
AND NOT EXISTS (SELECT 1 FROM hd_cart_cart_rule WHERE cr.id_cart_rule = hd_cart_cart_rule.id_cart_rule
AND id_cart = 2370039)
ORDER BY priority
0.3 1 Yes /classes/CartRule.php:1633
SELECT SQL_NO_CACHE cr.*
FROM hd_cart_rule cr
LEFT JOIN hd_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule
LEFT JOIN hd_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule
LEFT JOIN hd_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule
LEFT JOIN hd_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule
WHERE cr.active = 1
AND cr.code = ""
AND cr.quantity > 0
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND (
cr.id_customer = 0
)
AND (
cr.`carrier_restriction` = 0
)
AND (
cr.`shop_restriction` = 0
OR crs.id_shop = 1
)
AND (
cr.`group_restriction` = 0
OR crg.`id_group` = 1
)
AND (
cr.`reduction_product` <= 0
OR EXISTS (
SELECT 1
FROM `hd_cart_product`
WHERE `hd_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 2370039
)
)
AND NOT EXISTS (SELECT 1 FROM hd_cart_cart_rule WHERE cr.id_cart_rule = hd_cart_cart_rule.id_cart_rule
AND id_cart = 2370039)
ORDER BY priority
0.3 1 Yes /classes/CartRule.php:1633
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.3 1 /src/Adapter/Module/ModuleDataProvider.php:174
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` = 70554) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
(SELECT 1 FROM `hd_cart_rule` WHERE date_to >= "2022-01-22 00:00:00" AND date_to <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from >= "2022-01-22 00:00:00" AND date_from <= "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `hd_cart_rule` WHERE date_from < "2022-01-22 00:00:00" AND date_to > "2022-01-22 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.3 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` = 52452) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 52452
AND image_shop.`cover` = 1 LIMIT 1
0.3 3 /classes/Product.php:3118
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 "%product_thumbs%" AND cs.id_shop="1";
0.3 2 /modules/ets_contactform7/ets_contactform7.php:1471
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` = 52452 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` = 52452 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `hd_product_attribute` pa
INNER JOIN hd_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `hd_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `hd_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `hd_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
JOIN `hd_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (14719) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 2 Yes Yes /classes/Product.php:3993
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` = 14687 AND ctg.`id_group` = 1 LIMIT 1
0.3 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 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, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2022-01-22 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2022-01-22 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.3 2 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 14687 LIMIT 1
0.3 3 /classes/Product.php:870
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 (14718) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.3 2 Yes Yes /classes/Product.php:3993
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 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.3 1 Yes /modules/pm_advancedtopmenu/AdvancedTopMenuColumnWrapClass.php:129
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` = 14687 AND pa.`id_product` = 14687 AND pa.`id_product_attribute` = 70548 LIMIT 1
0.3 1 /classes/Product.php:949
SELECT SQL_NO_CACHE *
FROM `hd_cms` a
LEFT JOIN `hd_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 3
LEFT JOIN `hd_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM hd_ets_ctf_contact c, hd_ets_ctf_contact_shop cs WHERE c.id_contact="1" AND c.id_contact=cs.id_contact AND cs.id_shop="1"
0.3 1 /modules/ets_contactform7/ets_contactform7.php:2758
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `hd_category` c
LEFT JOIN `hd_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN hd_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 3
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.3 20 Yes Yes /classes/Category.php:1144
SELECT SQL_NO_CACHE * FROM `hd_currency` c ORDER BY `iso_code` ASC
0.3 2 Yes /classes/Currency.php:695
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` = 14718 AND ctg.`id_group` = 1 LIMIT 1
0.3 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE id_feature, id_product, id_feature_value
FROM `hd_feature_product`
WHERE `id_product` IN (52452)
0.3 2 /classes/Product.php:4268
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` = 14687
ORDER BY `position`
0.3 1 Yes /classes/Product.php:3096
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 *, ( 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.3 3 Yes /classes/SpecificPrice.php:560
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` = 14687 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` = 14687 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 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 "%product_footer%" AND cs.id_shop="1";
0.3 2 /modules/ets_contactform7/ets_contactform7.php:1471
SELECT SQL_NO_CACHE DISTINCT pl.name as name
FROM `hd_product_lang` pl
WHERE (pl.id_product = 52452) AND (pl.id_lang = 3 AND pl.id_shop = 1 ) LIMIT 1
0.3 1 /classes/Product.php:6650
SELECT SQL_NO_CACHE `name`
FROM `hd_manufacturer`
WHERE `id_manufacturer` = 108
AND `active` = 1 LIMIT 1
0.3 1 /classes/Manufacturer.php:312
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.3 0 /modules/psblog/psblog.php:61
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` = 131) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.`available_date` 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) WHERE p.`id_product` = 52452 LIMIT 1
0.3 1 /modules/advanceddateofdelivery/advanceddateofdelivery.php:2236
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "blocklanguages" LIMIT 1
0.3 0 /classes/module/Module.php:2820
SELECT SQL_NO_CACHE *
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.3 1 /src/Adapter/EntityMapper.php:75
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.3 4 /classes/Language.php:991
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 DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`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)
INNER JOIN hd_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52452
0.2 1 /classes/Product.php:6462
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 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 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 = 52452
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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` = 52452 AND ctg.`id_group` = 1 LIMIT 1
0.2 3 /classes/Product.php:5753
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 14718 LIMIT 1
0.2 2 /classes/Product.php:856
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.2 102 /modules/jscomposer/classes/vccontentanywhere.php:868
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14718) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_zone`
FROM `hd_country`
WHERE `id_country` = 21 LIMIT 1
0.2 1 /classes/Country.php:223
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` = 14687) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM hd_link_block cb
WHERE `id_hook` = 35
ORDER by cb.`position`
0.2 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
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` = 14687
AND pac.`id_product_attribute` = 70548
AND agl.`id_lang` = 3
0.2 1 /classes/Product.php:6435
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 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 *
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 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` = 1
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52452) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `hd_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 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 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 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` = 14718 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` = 14718 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.2 0 /classes/Cart.php:1404
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52452) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 = 52452 LIMIT 1
0.2 1 /classes/Product.php:856
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=2370039 LIMIT 1
0.2 1 /classes/Cart.php:4193
SELECT SQL_NO_CACHE *
FROM `hd_address` a
WHERE (a.`id_address` = 2334950) LIMIT 1
0.2 0 /src/Adapter/EntityMapper.php:75
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 (70548, 70549, 70550) AND il.`id_lang` = 3 ORDER by i.`position`
0.2 3 Yes /classes/Product.php:2529
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 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 p.id_product
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)
WHERE p.id_product = 52452
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2022-01-22 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.2 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 52452
0.2 1 /classes/Product.php:2510
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 = 14687
0.2 1 /classes/Product.php:5215
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.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` = 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 COUNT(DISTINCT `id_product`) FROM `hd_specific_price` WHERE `id_product` != 0 LIMIT 1
0.2 116 /classes/SpecificPrice.php:286
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_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 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 out_of_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:757
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_category` a0
LEFT JOIN `hd_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 145) AND (a0.`nright` > 156) AND (a1.`id_lang` = 3)
ORDER BY a0.`nleft` asc
0.2 33 Yes /classes/PrestaShopCollection.php:381
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` = 14719 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` = 14719 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` = 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 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.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` = 70552
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 14718 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` = 70552
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 14718 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 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` = 70554
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 14719 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` = 70554
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 14719 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 *
FROM `hd_product` a
LEFT JOIN `hd_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 3
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52104) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE image_shop.`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` = 14687
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE `name`, `alias` FROM `hd_hook_alias`
0.2 88 /classes/Hook.php:284
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 *
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 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 t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.2 7 /classes/Tag.php:229
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` = 131 LIMIT 1
0.2 1 /classes/Category.php:1369
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` = 14719) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 15303 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Product.php:5753
SELECT SQL_NO_CACHE *
FROM `hd_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14687) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_shop FROM hd_shop
0.2 2 /classes/shop/Shop.php:739
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` = 70548) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_category_lang`
WHERE `id_category` = 131 AND `id_shop` = 1
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 14718 LIMIT 1
0.2 2 /classes/Product.php:870
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 *
FROM `hd_link_block_lang`
WHERE `id_link_block` = 1
0.2 2 /src/Adapter/EntityMapper.php:82
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 = 49076
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN hd_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 52124
AND pac.`id_product_attribute` = 70318
AND agl.`id_lang` = 3
0.2 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE *
FROM `hd_cart` a
WHERE (a.`id_cart` = 2370039) LIMIT 1
0.2 0 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_category` a
LEFT JOIN `hd_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 131) 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 `name`
FROM `hd_hook`
WHERE `id_hook` = 14 LIMIT 1
0.2 1 /classes/Hook.php:222
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 52104
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `hd_product_attribute_image` pai
LEFT JOIN `hd_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `hd_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (70553, 70554) AND il.`id_lang` = 3 ORDER by i.`position`
0.2 2 Yes /classes/Product.php:2529
SELECT SQL_NO_CACHE id_shop
FROM `hd_product_shop`
WHERE `id_product` = 52452
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1628
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 52452
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2022-01-22 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.2 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE format
FROM `hd_address_format`
WHERE `id_country` = 8 LIMIT 1
0.2 1 /classes/AddressFormat.php:676
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 52452
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2022-01-22 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.2 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE SUM(`quantity`)
FROM `hd_cart_product`
WHERE `id_product` = 52452
AND `id_cart` = 2370039 LIMIT 1
0.2 1 /classes/Product.php:3224
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 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 = 14718
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
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 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 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 *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "new-products"
OR m.page = "newproducts"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.2 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 14719
ORDER BY f.position ASC
0.2 2 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `hd_attribute` a
LEFT JOIN `hd_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 3)
LEFT JOIN `hd_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `hd_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN hd_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
LEFT JOIN `hd_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 3)
WHERE pa.`id_product` = 14718
AND pac.`id_product_attribute` = 70552
AND agl.`id_lang` = 3
0.2 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE 1 FROM hd_cart_product cp INNER JOIN hd_product p
ON (p.is_virtual = 0 AND 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=2370039 LIMIT 1
0.2 1 /classes/Cart.php:4210
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 t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.2 7 /classes/Tag.php:229
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 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_product` a
LEFT JOIN `hd_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 14718) 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_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.2 7 Yes /classes/ImageType.php:109
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` = 14719) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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` = 14719
AND pac.`id_product_attribute` = 70554
AND agl.`id_lang` = 3
0.2 1 /classes/Product.php:6435
SELECT SQL_NO_CACHE `name`
FROM `hd_country_lang`
WHERE `id_lang` = 1
AND `id_country` = 21 LIMIT 1
0.2 1 /classes/Country.php:251
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` = 70552) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `hd_link_block_lang`
WHERE `id_link_block` = 2
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE id_page_type
FROM hd_page_type
WHERE name = 'product' LIMIT 1
0.2 1 /classes/Page.php:104
SELECT SQL_NO_CACHE *
FROM `hd_link_block` a
WHERE (a.`id_link_block` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `hd_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.2 4 /classes/module/Module.php:2244
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` = 14718
AND image_shop.`cover` = 1 LIMIT 1
0.2 1 /classes/Product.php:3118
SELECT SQL_NO_CACHE `id_address` FROM hd_address a WHERE a.`id_address` = 0 LIMIT 1
0.2 0 /classes/Address.php:441
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.2 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE out_of_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:757
SELECT SQL_NO_CACHE depends_on_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:732
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 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` = 14687)
0.1 3 /classes/Product.php:3401
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 15303
AND image_shop.`cover` = 1 LIMIT 1
0.1 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.1 2 /classes/Meta.php:189
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.1 2 /classes/Language.php:1123
SELECT SQL_NO_CACHE location
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:785
DELETE FROM `hd_customized_data`
WHERE `id_customization` IN (
SELECT `id_customization`
FROM `hd_customization`
WHERE `id_cart`=2370039
)
0.1 1 /classes/Cart.php:392
SELECT SQL_NO_CACHE location
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:785
SELECT SQL_NO_CACHE depends_on_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:732
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.1 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM hd_feature_product pf
LEFT JOIN hd_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 3)
LEFT JOIN hd_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 3)
LEFT JOIN hd_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 3)
INNER JOIN hd_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 52124
ORDER BY f.position ASC
0.1 1 Yes /classes/Product.php:5195
SELECT SQL_NO_CACHE 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 *
FROM `hd_cms_lang`
WHERE `id_cms` = 7 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 14719
0.1 2 /classes/Product.php:2510
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `hd_specific_price` WHERE `id_product` != 0
0.1 124 /classes/SpecificPrice.php:294
SELECT SQL_NO_CACHE p.id_product
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)
WHERE p.id_product = 52452
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2022-01-22 00:00:00",
INTERVAL 30 DAY
)
) > 0
0.1 0 /classes/Product.php:1428
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 *
FROM `hd_cart_product`
WHERE (id_cart = 2370039) AND (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
0.1 1 /modules/productbundlespro/models/PBPCartProductModel.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 *
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 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_module` FROM `hd_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.1 1 /src/Adapter/Module/ModuleDataProvider.php:198
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 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` = 14719 AND ctg.`id_group` = 1 LIMIT 1
0.1 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE COUNT(*) FROM `hd_pack` WHERE id_product_pack = 52452 LIMIT 1
0.1 1 /classes/Pack.php:85
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 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` = 14719
AND image_shop.`cover` = 1 LIMIT 1
0.1 1 /classes/Product.php:3118
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 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 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 *
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 t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229
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 = 14718
0.1 1 /classes/Product.php:5215
SELECT SQL_NO_CACHE *
FROM `hd_ets_ctf_contact` a
WHERE (a.`id_contact` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`need_identification_number` FROM `hd_country` c WHERE c.`id_country` = 21 LIMIT 1
0.1 1 /classes/Address.php:382
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 (70551, 70552) AND il.`id_lang` = 3 ORDER by i.`position`
0.1 2 Yes /classes/Product.php:2529
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 `id_module` FROM `hd_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.1 0 /classes/module/Module.php:2820
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 location
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:785
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 *
FROM hd_meta m
LEFT JOIN hd_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 3
AND ml.id_shop = 1 LIMIT 1
0.1 1 /classes/Meta.php:189
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 15303 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `hd_cart` a
WHERE (a.`id_cart` = 2370039) LIMIT 1
0.1 0 /src/Adapter/EntityMapper.php:75
DELETE FROM `hd_customization`
WHERE `id_cart` = 2370039
0.1 1 /classes/Cart.php:398
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 52104 AND ctg.`id_group` = 1 LIMIT 1
0.1 1 /classes/Product.php:5753
SELECT SQL_NO_CACHE *
FROM `hd_cart_product`
WHERE (id_cart = 2370039) AND (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
0.1 1 /modules/productbundlespro/models/PBPCartProductModel.php:82
SELECT SQL_NO_CACHE value FROM `hd_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.1 1 /classes/shop/Shop.php:1162
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `hd_image` i
INNER JOIN hd_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `hd_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 3)
WHERE i.`id_product` = 49076
ORDER BY `position`
0.1 2 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE *
FROM `hd_product_lang`
WHERE `id_product` = 52124 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_module` FROM `hd_module` WHERE `name` = "revsliderprestashop" LIMIT 1
0.1 0 /classes/module/Module.php:2820
DELETE FROM `hd_cart_cart_rule` WHERE `id_cart` = 2370039
0.1 1 /classes/Cart.php:401
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 `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 `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 ctg.`id_group`
FROM `hd_category_product` cp
INNER JOIN `hd_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 49076 AND ctg.`id_group` = 1 LIMIT 1
0.1 2 /classes/Product.php:5753
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
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 product_attribute_shop.default_on = 1  AND pa.id_product = 14719 LIMIT 1
0.1 2 /classes/Product.php:870
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_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 product_attribute_shop.id_product_attribute
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 = 14719 LIMIT 1
0.1 2 /classes/Product.php:856
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `hd_module` m
LEFT JOIN `hd_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.1 1 /src/Adapter/Module/ModuleDataProvider.php:174
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` = 52452)
0.1 1 /classes/Product.php:3401
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` = 52124)
0.1 7 /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` = 49076)
0.1 1 /classes/Product.php:3401
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 *
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 `reduction`
FROM `hd_product_group_reduction_cache`
WHERE `id_product` = 52452 AND `id_group` = 1 LIMIT 1
0.1 0 /classes/GroupReduction.php:156
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` = 14718)
0.1 2 /classes/Product.php:3401
SELECT SQL_NO_CACHE out_of_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:757
SELECT SQL_NO_CACHE name, alias FROM `hd_hook_alias`
0.1 88 /classes/Hook.php:336
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 `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_product_lang`
WHERE `id_product` = 52104 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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 `id_country`
FROM `hd_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.1 1 /classes/Country.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 14687
0.1 3 /classes/Product.php:2510
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 *
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 GROUP_CONCAT(a.`id_product_pack`)
FROM `hd_pack` a
WHERE a.`id_product_item` = 52452 LIMIT 1
0.1 1 /classes/Pack.php:401
SELECT SQL_NO_CACHE `name` FROM `hd_supplier` WHERE `id_supplier` = 0 LIMIT 1
0.1 0 /classes/Supplier.php:244
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 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 name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 131 LIMIT 1
0.1 1 /classes/Product.php:4937
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` = 70552 LIMIT 1
0.1 1 /classes/Combination.php:462
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `hd_pack` where id_product_pack = 52452
0.1 1 /classes/Pack.php:160
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` = 14719)
0.1 2 /classes/Product.php:3401
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 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 *
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_country_lang`
WHERE `id_country` = 8
0.1 3 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `hd_product` p
INNER JOIN `hd_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `hd_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 52104)
0.1 1 /classes/Product.php:3401
SELECT SQL_NO_CACHE hm.`id_module`
FROM `hd_hook_module` hm, `hd_hook` h
WHERE hm.`id_module` = 143 AND h.`id_hook` = 51
AND h.`id_hook` = hm.`id_hook` AND `id_shop` = 2 LIMIT 1
0.1 1 /classes/Hook.php:617
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `hd_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 68 LIMIT 1
0.1 0 /classes/Category.php:1369
SELECT SQL_NO_CACHE out_of_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:757
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 `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 *
FROM `hd_product_lang`
WHERE `id_product` = 52452 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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 depends_on_stock
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:732
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_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_product_attribute`
FROM `hd_product_attribute`
WHERE `id_product` = 15303
0.1 1 /classes/Product.php:2510
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 name FROM hd_category_lang WHERE id_shop = 1 AND id_lang = 3 AND id_category = 68 LIMIT 1
0.1 1 /classes/Product.php:4937
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_shop_group` a
WHERE (a.`id_shop_group` = 2) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_shop
FROM `hd_category_shop`
WHERE `id_category` = 131
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1628
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 c.`nleft`, c.`nright`, c.`level_depth`
FROM `hd_category` c
WHERE (c.`id_category` = 2) LIMIT 1
0.1 1 /classes/Category.php:1919
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 *
FROM `hd_cart_product`
WHERE (id_cart = 2370039) AND (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
0.1 1 /modules/productbundlespro/models/PBPCartProductModel.php:82
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 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` = 14718 AND pa.`id_product` = 14718 AND pa.`id_product_attribute` = 70552 LIMIT 1
0.1 1 /classes/Product.php:949
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 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` = 14719 AND pa.`id_product` = 14719 AND pa.`id_product_attribute` = 70554 LIMIT 1
0.1 1 /classes/Product.php:949
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_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 *
FROM `hd_product_lang`
WHERE `id_product` = 14687 AND `id_shop` = 1
0.1 2 /src/Adapter/EntityMapper.php:82
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 `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.`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 *
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 t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229
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 *
FROM `hd_cart_product`
WHERE (id_cart = 2370039) AND (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
0.1 1 /modules/productbundlespro/models/PBPCartProductModel.php:82
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 = 14719
0.1 1 /classes/Product.php:5215
SELECT SQL_NO_CACHE location
FROM `hd_stock_available`
WHERE (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop_group = 2) AND (id_shop = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:785
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_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 *
FROM `hd_cart_product`
WHERE (id_cart = 2370039) AND (id_product = 52452) AND (id_product_attribute = 0) AND (id_shop = 1) LIMIT 1
0.1 1 /modules/productbundlespro/models/PBPCartProductModel.php:82
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229
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_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 t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM hd_tag t
LEFT JOIN hd_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52452
0.1 7 /classes/Tag.php:229