Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola
  • Black Leaf : Eguzkitako parasola

Black Leaf : Eguzkitako parasola

99,17 €
BEZ barne Préparée et expédiée sous 24h
Coloris
Kopurua
Stockean

Inspirée de la fome naturelle des feuilles de Monstera Delicioso d'Amérique Centrale, la Voile d'Ombrage Nomade LEAF for lifeTM mixe design et technologie révolutionnaire.

Idéale pour la plage, le camping, la randonnée, les sorties champêtres, à utiliser pour soi, en famille ou entre amis. Un MUST HAVE pour l'été.

SECURITE, SANTE ET BIEN-ETRE

La Voile d'Ombrage Nomade LEAF for lifeTM vous garantit un espace ombragé optimum et une haute protection solaire en toute quiétude. Telle la souplesse du roseau, la LEAF absorbe l'énergie du vent sans lui résister, réduisant ainsi les risques d'arrachement au sol.

LEAF DESIGN

La Voile d'Ombrage LEAF for lifeTM s'intègre parfaitement comme mobilier design de décoration extérieure au bord d'une piscine, sur une terrasse ou dans un jardin.

LEAF'N FISH

La Voile d'Ombrage Nomade LEAF for lifeTM accompagne les passionnés de nature et de pêche au bord des lacs et des rivières. Léger et compact, son sac de transport offre un espace de rangement supplémentaire pour d'autres équipements. Très pratique, son pied d'ancrage s'adapte aux sols de toues les rives...

EASY PACK'N GO

Elégante, robuste et facile d'utilisation, la Voile d'Ombrage Nomade LEAF for lifeTM a été pensée pour vous! Son ergonomie et son caractère nomade ont été étudiés pour simplifier votre quotidien et améliorer considérablement votre confort.

Les points forts du modèle Leaf

PRATICITÉ

Sac de transport robuste, suffisamment grand et aménagé (poches de rangement) pour y loger les affaires de plages ( livre, goûter...).

Légèreté de la Voile d'Ombrage Nomade.

Pied excentré permettant de profiter pleinement de l'espace d'ombrage sous la voile.

Pied télescopique contribuant à l'optimisation de l'encombrement.

Facile, rapide et fiable le pied d'ancrage vous permet de fixer la Voile d'Ombrage Nomade LEAF for lifeTM sans effort.

Présence d'un système d'attaches à l'arrière de la voile comportant 1 œillet et 1 mousqueton permettant de suspendre sac de transport, serviettes de plage, palmes...

Rangement aisé de la Voile d'Ombrage Nomade et de son pied dans un sac de transport ergonomique.

CONFORT

Systeme Cool Breeze : Circulation libre de l'air sous la surface de la voile pour un bien-être inégalé.

QUALITÉ

Durabilité et robustesse des composants.

Possibilité d'interchanger les voiles.

Tissu de la voile antifongique et déperlant.

INNOVATION - Système breveté

CTS : Curve Tensioning System. Ouverture utra rapide par auto déploiement de la voile & Facilité de pliage

SFS : Sun Following System. Optimisation de la surface d'ombre portée : La rotule multidirectionnelle à 360° permet à la voile d'Ombrage Nomade LEAF for lifeTM de suivre la course du soleil.

SÉCURITÉ

Aucun angle vif sur le pourtour de la voile

Embout du pied usiné (pas de pointe aigüe)

Aérodynamique parfaite grâce à sa forme et son pied excentré, l'effet de portance est diminué et la tenue au sol est renforcée.

SANTÉ

Protection de la voile anti UV indice 50+ UPF

BLACK LEAF : ROYAL BLUE

4 other products in the same category:

Load Time395 ms - Unicorn powered webserver!
Querying Time158 ms
Queries332
Memory Peak Usage19.4 Mb
Included Files816 files - 9.00 Mb
PrestaShop Cache- Mb
Global vars0.17 Mb
PrestaShop Version1.7.5.0
PHP Version7.0.33-47+ubuntu18.04.1+deb.sury.org+1 (Consider upgrading)
MySQL Version10.1.48-MariaDB-0ubuntu0.18.04.1 (OK)
Memory Limit1024M
Max Execution Time0s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 54 ms 54 ms 5.78 Mb 6.14 Mb
__construct 0 ms 54 ms - Mb 6.14 Mb
init 59 ms 113 ms 2.96 Mb 8.93 Mb
checkAccess 0 ms 113 ms - Mb 8.93 Mb
setMedia 7 ms 121 ms 0.63 Mb 9.38 Mb
postProcess 0 ms 121 ms - Mb 9.38 Mb
initHeader 0 ms 121 ms - Mb 9.38 Mb
initContent 99 ms 220 ms 3.39 Mb 12.80 Mb
initFooter 0 ms 220 ms - Mb 12.80 Mb
display 174 ms 395 ms 6.32 Mb 19.41 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 332 queries

Query Time (ms) Rows Filesort Group By Location
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 `mod259_configuration` c
LEFT JOIN `mod259_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6.5 10908 /classes/Configuration.php:160
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `mod259_module` m
INNER JOIN mod259_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 `mod259_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `mod259_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `mod259_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
5.5 274 Yes Yes /classes/Hook.php:666
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `mod259_meta` m
LEFT JOIN `mod259_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
4.2 366 Yes /classes/Dispatcher.php:634
INSERT INTO `mod259_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')
3.3 1 /classes/ObjectModel.php:551
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 `mod259_hook_module` hm
STRAIGHT_JOIN `mod259_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `mod259_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
3 757 /classes/Hook.php:403
SELECT SQL_NO_CACHE `id_date_range`, `time_end`
FROM `mod259_date_range`
WHERE `time_end` = (SELECT MAX(`time_end`) FROM `mod259_date_range`) LIMIT 1
3 13395600 /classes/DateRange.php:60
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2024-12-14 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `mod259_category_product` cp
LEFT JOIN `mod259_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `mod259_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 mod259_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 )
LEFT JOIN `mod259_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 )
LEFT JOIN `mod259_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 `mod259_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 7)
LEFT JOIN `mod259_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 12 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
2.6 112 Yes /override/classes/Category.php:120
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(
"2024-12-14 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `mod259_accessory`
LEFT JOIN `mod259_product` p ON p.`id_product` = `id_product_2`
INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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 `mod259_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 1 
)
LEFT JOIN `mod259_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 1 
)
LEFT JOIN `mod259_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 `mod259_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7)
LEFT JOIN `mod259_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN mod259_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 52 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2.5 28 Yes Yes /classes/Product.php:4003
SHOW TABLES LIKE '%psblog_blog%'
2.5 1 /modules/psblog/psblog.php:44
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 mod259_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
2 8 Yes Yes /classes/Product.php:3915
UPDATE `mod259_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 3660
AND `id_page` = 82
AND `id_shop` = 1
1.7 1 /classes/Page.php:127
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 mod259_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.7 8 Yes Yes /classes/Product.php:3915
INSERT INTO `mod259_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14100236', '82', '308350555', '', '1', '1', '2024-12-14 19:39:12')
1.7 1 /classes/ObjectModel.php:551
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 52
ORDER BY `position`
1.5 73 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 102
ORDER BY `position`
1.5 72 Yes /classes/Product.php:3042
INSERT IGNORE INTO `mod259_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('13862787', '82', '2024-12-14 19:39:12')
1.5 1 /classes/Connection.php:122
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `mod259_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `mod259_hook_alias` ha
INNER JOIN `mod259_hook` h ON ha.name = h.name
1.5 0 /classes/Hook.php:190
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 mod259_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.5 8 Yes Yes /classes/Product.php:3915
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 53
ORDER BY `position`
1.3 77 Yes /classes/Product.php:3042
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 `mod259_category` c
INNER JOIN mod259_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `mod259_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7  AND cl.id_shop = 1 )
WHERE `id_parent` = 12
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1.3 3 Yes Yes /classes/Category.php:872
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 mod259_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.3 8 Yes Yes /classes/Product.php:3915
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 52
ORDER BY `position`
1.2 73 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
1.2 14 /src/Adapter/EntityMapper.php:82
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN mod259_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 mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
1.1 4 /classes/Product.php:6203
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 mod259_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
AND al.`id_lang` = 7
AND agl.`id_lang` = 7
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.1 8 Yes Yes /classes/Product.php:3915
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "backupleaf" AND TABLE_NAME = "mod259_psblog_blog" AND COLUMN_NAME = "thumb"
1.1 0 /modules/psblog/psblog.php:44
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 54
ORDER BY `position`
1.1 72 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1 180 /classes/module/Module.php:305
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM mod259_shop_url su
LEFT JOIN mod259_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'leaforlife.com' OR su.domain_ssl = 'leaforlife.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
1 1 Yes /classes/shop/Shop.php:345
SELECT SQL_NO_CACHE COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = "backupleaf"
AND TABLE_NAME = "mod259_tab"
AND COLUMN_NAME = "hide_host_mode" LIMIT 1
0.9 0 /modules/seoexpert/seoexpert.php:376
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 7 ORDER by i.`position`
0.9 50 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE hs.`id_customtabs_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`category`, hssl.`description`, hssl.`image`
FROM mod259_customtabs hs
LEFT JOIN mod259_customtabs_slides hss ON (hs.id_customtabs_slides = hss.id_customtabs_slides)
LEFT JOIN mod259_customtabs_slides_lang hssl ON (hss.id_customtabs_slides = hssl.id_customtabs_slides)
WHERE id_shop = 1
AND hssl.id_lang = 7 AND hss.`active` = 1
ORDER BY hss.position
0.9 1 Yes /modules/customtabs/customtabs.php:759
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (102) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 1 Yes Yes /classes/Product.php:3860
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.8 180 /classes/module/Module.php:305
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN mod259_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 mod259_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 52
0.8 4 /classes/Product.php:6203
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (149, 150, 151, 152, 153, 154) AND il.`id_lang` = 7 ORDER by i.`position`
0.8 70 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM mod259_tag t
LEFT JOIN mod259_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=52
0.8 41 /classes/Tag.php:229
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-14 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM mod259_product p
LEFT JOIN mod259_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 53
0.8 8 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE tr.*
FROM `mod259_tax_rule` tr
JOIN `mod259_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` = 60
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.8 1 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 52
ORDER BY `position`
0.8 73 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`, a.`position`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `mod259_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `mod259_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 52
AND pa.`id_product_attribute` = 144
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.7 1 Yes /classes/Product.php:2435
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 7 ORDER by i.`position`
0.7 50 Yes /classes/Product.php:2483
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 `mod259_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` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-12-14 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-14 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.7 1 Yes /classes/SpecificPrice.php:612
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 mod259_shop_group gs
LEFT JOIN mod259_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN mod259_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.7 1 Yes /classes/shop/Shop.php:704
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 144
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 144
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.7 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 180 /classes/module/Module.php:305
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 1 Yes Yes /classes/Product.php:3860
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 12 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE `id_country`
FROM `mod259_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.7 1 /classes/Country.php:192
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.7 180 /classes/module/Module.php:305
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE hs.`id_customtabs_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`category`, hssl.`description`, hssl.`image`
FROM mod259_customtabs hs
LEFT JOIN mod259_customtabs_slides hss ON (hs.id_customtabs_slides = hss.id_customtabs_slides)
LEFT JOIN mod259_customtabs_slides_lang hssl ON (hss.id_customtabs_slides = hssl.id_customtabs_slides)
WHERE id_shop = 1
AND hssl.id_lang = 7 AND hss.`active` = 1
ORDER BY hss.position
0.7 1 Yes /modules/customtabs/customtabs.php:759
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
0.7 14 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-14 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM mod259_product p
LEFT JOIN mod259_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 52
0.6 5 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 5 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-14 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM mod259_product p
LEFT JOIN mod259_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 54
0.6 8 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 23 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 23 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (102) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 1 Yes Yes /classes/Product.php:3860
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 151
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 54 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 151
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 54 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`customclass`, hssl.`image`
FROM mod259_htmlbanners6 hs
LEFT JOIN mod259_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides)
LEFT JOIN mod259_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides)
WHERE id_shop = 1
AND hssl.id_lang = 7 AND hss.`active` = 1
ORDER BY hss.position
0.6 5 Yes /modules/htmlbanners6/htmlbanners6.php:599
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-14 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM mod259_product p
LEFT JOIN mod259_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 7
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 102
0.6 2 /classes/ProductAssembler.php:90
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (23) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 5) AND (b.`id_shop` = 1) LIMIT 1
0.6 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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 176
AND agl.`id_lang` = 7
0.6 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE id_tab, class_name FROM `mod259_tab`
0.6 259 /classes/Tab.php:318
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 10
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.6 180 /classes/module/Module.php:305
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 4
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.6 180 /classes/module/Module.php:305
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 12 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE SQL_BIG_RESULT msr.id_rule, msr.id_lang, msr.id_shop, msr.active, mso.id_obj, msp.field, msp.pattern
FROM `mod259_module_seohelping_rules` msr
LEFT JOIN `mod259_module_seohelping_objects` mso ON (msr.id_rule = mso.id_rule)
LEFT JOIN `mod259_module_seohelping_patterns` msp ON (msr.id_rule = msp.id_rule)
WHERE msr.type = "product"
AND msr.active = 1
AND (msp.field like "fb_%" OR msp.field like "tw_%")
AND mso.id_obj  = 0
AND msr.id_shop = 1
AND msr.id_lang = 7
0.5 1 /modules/seoexpert/seoexpert.php:878
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 180 /classes/module/Module.php:305
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 5
ORDER BY `position`
0.5 2 Yes /classes/Product.php:3042
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 175
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 175
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 7 ORDER by i.`position`
0.5 50 Yes /classes/Product.php:2483
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 15
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 15
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 9
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (5) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 6
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.5 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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 151
AND agl.`id_lang` = 7
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 7 ORDER by i.`position`
0.5 50 Yes /classes/Product.php:2483
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 `mod259_product_attribute` pa
INNER JOIN mod259_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 `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `mod259_category` c
LEFT JOIN `mod259_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN mod259_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 7
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.5 14 Yes Yes /classes/Category.php:1098
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (175, 176, 178, 179) AND il.`id_lang` = 7 ORDER by i.`position`
0.5 47 Yes /classes/Product.php:2483
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 178
AND agl.`id_lang` = 7
0.5 2 /classes/Product.php:6176
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 102 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 102 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.5 0 /classes/Cart.php:1234
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 172
AND agl.`id_lang` = 7
0.5 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 23
ORDER BY `position`
0.5 6 Yes /classes/Product.php:3042
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 102
AND pac.`id_product_attribute` = 300
AND agl.`id_lang` = 7
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE tr.*
FROM `mod259_tax_rule` tr
JOIN `mod259_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.5 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE *
FROM `mod259_country` a
LEFT JOIN `mod259_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `mod259_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.5 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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 300
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 102 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 300
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 102 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 141
AND agl.`id_lang` = 7
0.4 1 /classes/Product.php:6176
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `mod259_lang` l
JOIN mod259_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.4 11 /classes/Language.php:1029
SELECT SQL_NO_CACHE * FROM `mod259_psreassurance` pr
LEFT JOIN mod259_psreassurance_lang prl ON (pr.id_psreassurance = prl.id_psreassurance)
WHERE prl.id_lang = "7"
AND pr.status = 1
ORDER BY pr.position
0.4 24 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
WHERE i.`id_product` = 52
AND image_shop.`cover` = 1 LIMIT 1
0.4 73 /classes/Product.php:3064
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 52)
0.4 4 /classes/Product.php:3342
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 54 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_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` = 54 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE count(id_wishlist_product) FROM mod259_wishlist w, mod259_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1
0.4 43 /modules/blockwishlist/blockwishlist.php:189
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 140
AND agl.`id_lang` = 7
0.4 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `mod259_country` a
LEFT JOIN `mod259_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7
LEFT JOIN `mod259_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.4 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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 23
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 7
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE hs.`id_htmlbanners7_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM mod259_htmlbanners7 hs
LEFT JOIN mod259_htmlbanners7_slides hss ON (hs.id_htmlbanners7_slides = hss.id_htmlbanners7_slides)
LEFT JOIN mod259_htmlbanners7_slides_lang hssl ON (hss.id_htmlbanners7_slides = hssl.id_htmlbanners7_slides)
WHERE id_shop = 1
AND hssl.id_lang = 7 AND hss.`active` = 1
ORDER BY hss.position
0.4 2 Yes /modules/htmlbanners7/htmlbanners7.php:590
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `mod259_lang` l
LEFT JOIN `mod259_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.4 14 /classes/Language.php:882
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `mod259_currency` c
LEFT JOIN mod259_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.4 5 /classes/Currency.php:661
SELECT SQL_NO_CACHE *
FROM mod259_meta m
LEFT JOIN mod259_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.4 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 53) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_group` a
LEFT JOIN `mod259_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 15
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_guest`
FROM `mod259_connections`
WHERE `id_guest` = 14100236
AND `date_add` > '2024-12-14 19:09:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.4 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 12
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 11
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_category` a0
LEFT JOIN `mod259_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 3) AND (a0.`nright` > 10) AND (a1.`id_lang` = 7)
ORDER BY a0.`nleft` asc
0.4 14 /classes/PrestaShopCollection.php:373
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 `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 172
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 172
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 149
AND agl.`id_lang` = 7
0.4 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 13
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `mod259_hook_alias`
0.4 88 /classes/Hook.php:234
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 179
AND agl.`id_lang` = 7
0.4 2 /classes/Product.php:6176
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 144
AND agl.`id_lang` = 7
0.4 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 14
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `iso_code`
FROM `mod259_country`
WHERE `id_country` = 8 LIMIT 1
0.4 1 /classes/Country.php:272
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod259_product_attribute pa
INNER JOIN mod259_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 = 52 LIMIT 1
0.4 4 /classes/Product.php:845
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 52 AND pa.`id_product` = 52 AND pa.`id_product_attribute` = 144 LIMIT 1
0.4 1 /classes/Product.php:938
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `mod259_specific_price` WHERE `id_product` != 0 LIMIT 1
0.4 3 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (15) AND il.`id_lang` = 7 ORDER by i.`position`
0.3 1 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
0.3 14 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM mod259_product_attachment pa
LEFT JOIN mod259_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN mod259_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 7)
WHERE pa.id_product = 52
0.3 1 /classes/Product.php:4972
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 102) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 54 AND pa.`id_product` = 54 AND pa.`id_product_attribute` = 151 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE 1 FROM mod259_cart_product cp INNER JOIN mod259_product p
ON (p.id_product = cp.id_product) INNER JOIN mod259_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.3 1 /classes/Cart.php:4013
SELECT SQL_NO_CACHE *
FROM `mod259_currency` c
INNER JOIN mod259_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
0.3 25 Yes /classes/Currency.php:302
SELECT SQL_NO_CACHE *
FROM `mod259_category` a
LEFT JOIN `mod259_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `mod259_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 0 LIMIT 1
0.3 1 /classes/SpecificPrice.php:407
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 5 AND `id_shop` = 1
0.3 14 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SQL_BIG_RESULT msr.id_rule, msr.id_lang, msr.id_shop, msr.active, mso.id_obj, msp.field, msp.pattern
FROM `mod259_module_seohelping_rules` msr
LEFT JOIN `mod259_module_seohelping_objects` mso ON (msr.id_rule = mso.id_rule)
LEFT JOIN `mod259_module_seohelping_patterns` msp ON (msr.id_rule = msp.id_rule)
WHERE msr.type = "product"
AND msr.active = 1
AND (msp.field like "fb_%" OR msp.field like "tw_%")
AND mso.id_obj  = 12
AND msr.id_shop = 1
AND msr.id_lang = 7
0.3 1 /modules/seoexpert/seoexpert.php:878
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 150
AND agl.`id_lang` = 7
0.3 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total
FROM `mod259_product` p
INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_category_product` cp ON p.`id_product` = cp.`id_product`
WHERE cp.`id_category` = 12 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.3 16 /override/classes/Category.php:53
SELECT SQL_NO_CACHE p.id_product
FROM `mod259_product` p
INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 52
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-14 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.3 0 /classes/Product.php:1399
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (300) AND il.`id_lang` = 7 ORDER by i.`position`
0.3 11 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `name` FROM `mod259_supplier` WHERE `id_supplier` = 1 LIMIT 1
0.3 1 /classes/Supplier.php:243
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 5
AND pac.`id_product_attribute` = 15
AND agl.`id_lang` = 7
0.3 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.3 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 175
AND agl.`id_lang` = 7
0.3 2 /classes/Product.php:6176
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`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `mod259_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `mod259_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN mod259_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 `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 152
AND agl.`id_lang` = 7
0.3 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE id_shop
FROM `mod259_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.3 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE COUNT(*)
FROM `mod259_hook_module` hm
LEFT JOIN `mod259_hook` h ON (h.`id_hook` = hm.`id_hook`)
WHERE h.`name` = 'displayHome' AND hm.`id_module` = 135 LIMIT 1
0.3 1 /classes/module/Module.php:2299
SELECT SQL_NO_CACHE *
FROM `mod259_group_lang`
WHERE `id_group` = 1
0.3 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `name`
FROM `mod259_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.3 0 /classes/Manufacturer.php:310
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod259_product_attribute pa
INNER JOIN mod259_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 = 52 LIMIT 1
0.3 4 /classes/Product.php:859
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 23)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE *
FROM `mod259_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod259_product_attribute pa
INNER JOIN mod259_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 = 5 LIMIT 1
0.3 1 /classes/Product.php:845
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 52 AND pa.`id_product` = 52 AND pa.`id_product_attribute` = 172 LIMIT 1
0.3 1 /classes/Product.php:938
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 53)
0.3 4 /classes/Product.php:3342
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 5)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE depends_on_stock
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:729
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM mod259_link_block cb
WHERE `id_hook` = 26
ORDER by cb.`position`
0.3 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `mod259_specific_price` WHERE `id_product` != 0
0.3 2 /classes/SpecificPrice.php:291
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 102)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE psgdpr.active FROM `mod259_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 134 LIMIT 1
0.3 3 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 151) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_page_type
FROM mod259_page_type
WHERE name = 'product' LIMIT 1
0.3 1 /classes/Page.php:100
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 102 AND pa.`id_product` = 102 AND pa.`id_product_attribute` = 300 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE * FROM `mod259_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.3 1 /classes/module/Module.php:2188
SELECT SQL_NO_CACHE value FROM `mod259_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.3 1 /classes/shop/Shop.php:1160
SELECT SQL_NO_CACHE *
FROM `mod259_country` a
LEFT JOIN `mod259_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7
LEFT JOIN `mod259_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 product_shop.`id_category_default`
FROM `mod259_product` p
INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.`id_product` = 52 LIMIT 1
0.3 1 /classes/Product.php:6562
SELECT SQL_NO_CACHE * FROM mod259_rec_whitelist WHERE ip_address = "18.97.14.91"
0.2 1 /modules/recaptchapro/recaptchapro.php:662
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE psgdprl.message FROM `mod259_psgdpr_consent` psgdpr
LEFT JOIN mod259_psgdpr_consent_lang psgdprl ON (psgdpr.id_gdpr_consent = psgdprl.id_gdpr_consent)
WHERE psgdpr.id_module = 134 AND psgdprl.id_lang =7 LIMIT 1
0.2 3 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `mod259_hook_alias`
0.2 88 /classes/Hook.php:260
SELECT SQL_NO_CACHE * FROM `mod259_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.2 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM mod259_shop s
LEFT JOIN mod259_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 `id_module` FROM `mod259_module` WHERE `name` = "blocklanguages" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE `id_country`
FROM `mod259_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:192
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 144) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_link_block_lang`
WHERE `id_link_block` = 1
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 12 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE data
FROM `mod259_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
0.2 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_page`
FROM `mod259_page`
WHERE `id_page_type` = 9 AND `id_object` = 52 LIMIT 1
0.2 1 /classes/Page.php:80
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.2 1 /src/Adapter/Module/ModuleDataProvider.php:185
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 53 AND pa.`id_product` = 53 AND pa.`id_product_attribute` = 175 LIMIT 1
0.2 1 /classes/Product.php:938
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `mod259_specific_price_priority`
WHERE `id_product` = 52
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:246
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 23
0.2 1 /classes/Product.php:2465
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 `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_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` = 54)
0.2 6 /classes/Product.php:3342
SELECT SQL_NO_CACHE *
FROM `mod259_category_lang`
WHERE `id_category` = 12 AND `id_shop` = 1
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `mod259_module` m
LEFT JOIN `mod259_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.2 1 /src/Adapter/Module/ModuleDataProvider.php:174
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_category` a
LEFT JOIN `mod259_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 12) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_currencyselector" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_featuredproducts" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE id_shop
FROM `mod259_category_shop`
WHERE `id_category` = 12
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 5
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE *
FROM `mod259_lang` a
LEFT JOIN `mod259_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_contactinfo" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 15) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM mod259_meta m
LEFT JOIN mod259_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 7
AND ml.id_shop = 1 LIMIT 1
0.2 1 /classes/Meta.php:189
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `mod259_category` c
WHERE (c.`id_category` = 2) LIMIT 1
0.2 1 /classes/Category.php:1870
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 172) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_country` a
LEFT JOIN `mod259_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `mod259_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.2 3 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_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` = 5 AND pa.`id_product` = 5 AND pa.`id_product_attribute` = 15 LIMIT 1
0.2 1 /classes/Product.php:938
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 23 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE *
FROM `mod259_link_block` a
WHERE (a.`id_link_block` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE domain, domain_ssl
FROM mod259_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/shop/ShopUrl.php:173
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 300 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "deluxedownloadfilesb2b" LIMIT 1
0.2 0 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 53
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_lang` a
LEFT JOIN `mod259_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 7) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_shop
FROM `mod259_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod259_product_attribute pa
INNER JOIN mod259_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 = 23 LIMIT 1
0.2 1 /classes/Product.php:845
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 300) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 172 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE *
FROM `mod259_country_lang`
WHERE `id_country` = 8
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_link_block` a
WHERE (a.`id_link_block` = 2) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE id_shop
FROM `mod259_product_shop`
WHERE `id_product` = 52
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE location
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:782
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 14
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 12 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM mod259_product_attribute pa
INNER JOIN mod259_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 = 5 LIMIT 1
0.2 1 /classes/Product.php:859
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 175) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 8
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE *
FROM `mod259_link_block_lang`
WHERE `id_link_block` = 2
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE ctg.`id_group`
FROM mod259_category_group ctg
WHERE ctg.`id_category` = 12 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Category.php:1654
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 3) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE format
FROM `mod259_address_format`
WHERE `id_country` = 8 LIMIT 1
0.2 1 /classes/AddressFormat.php:618
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 12 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 10
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 5
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 54) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 5) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "braintreeofficial" LIMIT 1
0.2 0 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 52 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 54
0.2 6 /classes/Product.php:2465
SELECT SQL_NO_CACHE out_of_stock
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:754
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 9
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 151 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_hook` a
WHERE (a.`id_hook` = 26) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 102
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 144 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 5) AND (id_product_attribute = 15) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 144 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 4
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 131 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 13
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 23) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 15
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM mod259_required_field
0.1 1 /classes/ObjectModel.php:1453
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 175 LIMIT 1
0.1 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 147 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 172) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 6
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 144) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 54) AND (id_product_attribute = 151) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 54 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 53) AND (id_product_attribute = 175) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 102) AND (id_product_attribute = 300) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 102) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 102 LIMIT 1
0.1 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 53) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE DISTINCT `id_product_attribute` FROM `mod259_specific_price` WHERE `id_product_attribute` != 0
0.1 2 /classes/SpecificPrice.php:291
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE `from` BETWEEN '2024-12-14 00:00:00' AND '2024-12-14 23:59:59' LIMIT 1
0.1 2 /classes/SpecificPrice.php:358
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_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` = 15 LIMIT 1
0.1 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 23 LIMIT 1
0.1 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 251 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 12
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_languageselector" LIMIT 1
0.1 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_lang` FROM `mod259_lang` WHERE `iso_code` = 'eu' LIMIT 1
0.1 14 /classes/Language.php:722
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 7
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
0.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 142 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE `price_display_method`
FROM `mod259_group`
WHERE `id_group` = 3 LIMIT 1
0.1 1 /classes/Group.php:170
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.1 0 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE id_shop
FROM `mod259_lang_shop`
WHERE `id_lang` = 7
AND id_shop = 1 LIMIT 1
0.1 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 132 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 52 LIMIT 1
0.1 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_customersignin" LIMIT 1
0.1 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 102 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 11
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.1 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 53 LIMIT 1
0.1 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE `to` BETWEEN '2024-12-14 00:00:00' AND '2024-12-14 23:59:59' LIMIT 1
0.1 2 /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 53 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 229 AND `id_shop` = 1 LIMIT 1
0.1 1 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 7 AND id_category = 12 LIMIT 1
0.1 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 54 LIMIT 1
0.1 1 /classes/SpecificPrice.php:416