TRIDENT: off-road verankering
  • Alleen online
  • TRIDENT: off-road verankering
  • TRIDENT: off-road verankering
  • TRIDENT: off-road verankering
  • TRIDENT: off-road verankering
  • TRIDENT: off-road verankering
  • TRIDENT: off-road verankering

TRIDENT: off-road verankering

€ 30,00
Inclusief belasting
Hoeveelheid
Op voorraad

Leaf For Life heeft "TRIDENT" voor u ontworpen: de all-terrain ankervoet. Gemaakt van aluminium en roestvrij staal, dit ontwerpaccessoire, robuust en licht stelt u in staat om uw Leaf of Sun Leaf te gebruiken in uw tuin, aan de rand van een meer, een rivier of op stranden waarvoor de grond te hard is (grind, kleine kiezels, boekhoudzand, enz.).

De TRIDENT ankervoet is eenvoudig te gebruiken. Duw het in de grond door met uw voet op de aluminium richel te drukken voor dit doel. Open de klem in de aluminium buis, plaats de voet van uw Leaf of Sun Leaf en draai vervolgens de klem vast.

Met TRIDENT kunt u de mogelijkheden van het gebruik van uw Leaf of Sun Leaf drastisch vergroten.

Stel in recordtijd een schaduwgebied op uw gazon in voor uw jonge kinderen of laat uw schaduw op elke plaats in uw tuin volgen. Tijdens een wandeling heb je nu altijd een schaduw, ongeacht de grond die je tegenkomt.

TRIDENTLEAF

7 andere producten in dezelfde categorie:

Load Time379 ms - Unicorn powered webserver!
Querying Time158 ms
Queries328
Memory Peak Usage19.4 Mb
Included Files808 files - 9.82 Mb
PrestaShop Cache- Mb
Global vars0.64 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 67 ms 67 ms 5.78 Mb 6.14 Mb
__construct 0 ms 67 ms - Mb 6.14 Mb
init 63 ms 130 ms 2.95 Mb 8.95 Mb
checkAccess 0 ms 130 ms - Mb 8.95 Mb
setMedia 9 ms 139 ms 0.67 Mb 9.40 Mb
postProcess 0 ms 139 ms - Mb 9.40 Mb
initHeader 0 ms 139 ms - Mb 9.40 Mb
initContent 56 ms 194 ms 2.87 Mb 12.29 Mb
initFooter 0 ms 194 ms - Mb 12.29 Mb
display 185 ms 379 ms 6.89 Mb 19.43 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 328 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`)
8.5 10908 /classes/Configuration.php:160
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
5.4 13395600 /classes/DateRange.php:60
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
5.3 366 Yes /classes/Dispatcher.php:634
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
5.2 757 /classes/Hook.php:403
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`
4.5 274 Yes Yes /classes/Hook.php:666
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_categorytree" LIMIT 1
3.5 1 /src/Adapter/Module/ModuleDataProvider.php:185
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` = 13 AND cl.id_shop = 1 )
LEFT JOIN `mod259_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 13 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` = 13)
LEFT JOIN `mod259_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 14 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
3.3 154 Yes /override/classes/Category.php:120
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')
2.3 1 /classes/ObjectModel.php:551
UPDATE `mod259_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 3660
AND `id_page` = 66
AND `id_shop` = 1
2 1 /classes/Page.php:127
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` = 13 AND pl.id_shop = 1 
)
LEFT JOIN `mod259_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 13 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` = 13)
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` = 23 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
2 28 Yes Yes /classes/Product.php:4003
INSERT INTO `mod259_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14100218', '66', '308350555', '', '1', '1', '2024-12-14 19:21:57')
1.8 1 /classes/ObjectModel.php:551
SHOW TABLES LIKE '%psblog_blog%'
1.7 1 /modules/psblog/psblog.php:44
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.6 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` = 23
AND al.`id_lang` = 13
AND agl.`id_lang` = 13
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1.5 1 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` = 13)
WHERE i.`id_product` = 28
ORDER BY `position`
1.1 8 Yes /classes/Product.php:3042
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 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` = 13  AND cl.id_shop = 1 )
WHERE `id_parent` = 14
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
1 4 Yes Yes /classes/Category.php:872
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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (28) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.9 16 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.9 180 /classes/module/Module.php:305
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.9 180 /classes/module/Module.php:305
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.9 180 /classes/module/Module.php:305
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "backupleaf" AND TABLE_NAME = "mod259_psblog_blog" AND COLUMN_NAME = "thumb"
0.9 0 /modules/psblog/psblog.php:44
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 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 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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 28
0.8 10 /classes/ProductAssembler.php:90
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 *
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` = 58) AND (b.`id_shop` = 1) LIMIT 1
0.8 1 /src/Adapter/EntityMapper.php:75
INSERT IGNORE INTO `mod259_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('13862773', '66', '2024-12-14 19:21:57')
0.8 1 /classes/Connection.php:122
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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (28) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 16 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` = 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.7 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` = 13
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.7 1 /src/Adapter/EntityMapper.php:75
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 = 13 AND hss.`active` = 1
ORDER BY hss.position
0.7 1 Yes /modules/customtabs/customtabs.php:759
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` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
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` = 13)
LEFT JOIN `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 13)
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` = 23
0.7 1 /classes/Product.php:6203
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` = 23
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 7 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` = 23
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 7 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 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (66) 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 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` = 66 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` = 66 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 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.7 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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 66
0.7 1 /classes/ProductAssembler.php:90
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.7 5 /classes/Currency.php:661
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.7 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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 59
0.7 5 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5
0.7 2 /classes/ProductAssembler.php:90
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 = 13 AND hss.`active` = 1
ORDER BY hss.position
0.7 1 Yes /modules/customtabs/customtabs.php:759
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` = 7 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` = 7 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 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 4 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` = 165
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 59 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` = 165
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 59 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 COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = "backupleaf"
AND TABLE_NAME = "mod259_tab"
AND COLUMN_NAME = "hide_host_mode" LIMIT 1
0.6 0 /modules/seoexpert/seoexpert.php:376
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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 3
0.6 5 /classes/ProductAssembler.php:90
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` = 28) AND (b.`id_shop` = 1) LIMIT 1
0.6 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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 28 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` = 28 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` = 13
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 66) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 7
0.6 4 /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` = 13)
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.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` = 56
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3 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` = 56
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3 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 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` = 3 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` = 3 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 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.6 1 Yes /classes/tax/TaxRulesTaxManager.php:108
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` = 59 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` = 59 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 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` = 58 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` = 58 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` = 13
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 7) 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` = 13
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 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 (83, 84, 85, 87, 89, 90, 248, 249) AND il.`id_lang` = 13 ORDER by i.`position`
0.6 8 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (58) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 10 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` = 83
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 28 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` = 83
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 28 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 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` = 155
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 58 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` = 155
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 58 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 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` = 13)
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` = 13)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 165
AND agl.`id_lang` = 13
0.6 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 7
AND pac.`id_product_attribute` = 23
AND agl.`id_lang` = 13
0.6 1 /classes/Product.php:6176
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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (58) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 10 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` = 13
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 59) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'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 = 13
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 58
0.5 6 /classes/ProductAssembler.php:90
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` = 13)
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` = 13)
WHERE pa.`id_product` = 5
AND pac.`id_product_attribute` = 15
AND agl.`id_lang` = 13
0.5 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 83
AND agl.`id_lang` = 13
0.5 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE id_tab, class_name FROM `mod259_tab`
0.5 259 /classes/Tab.php:318
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` = 13)
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` = 13)
WHERE pa.`id_product` = 58
AND pac.`id_product_attribute` = 157
AND agl.`id_lang` = 13
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` = 13)
WHERE i.`id_product` = 66
ORDER BY `position`
0.5 4 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` = 2
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.5 1 /src/Adapter/EntityMapper.php:75
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` = 13)
LEFT JOIN `mod259_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 13)
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` = 23
0.5 1 /classes/Product.php:6203
SELECT SQL_NO_CACHE `id_country`
FROM `mod259_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.5 1 /classes/Country.php:192
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` = 14 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1
0.5 22 /override/classes/Category.php:53
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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (59) 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 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.5 4 Yes Yes /classes/Product.php:3860
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` = 13)
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` = 13)
WHERE pa.`id_product` = 58
AND pac.`id_product_attribute` = 155
AND agl.`id_lang` = 13
0.5 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 90
AND agl.`id_lang` = 13
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` = 13)
WHERE i.`id_product` = 23
ORDER BY `position`
0.5 6 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` = 13)
WHERE i.`id_product` = 59
ORDER BY `position`
0.5 12 Yes /classes/Product.php:3042
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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (59) 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 *
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` = 23) 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` = 13)
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` = 13)
WHERE pa.`id_product` = 58
AND pac.`id_product_attribute` = 156
AND agl.`id_lang` = 13
0.5 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 84
AND agl.`id_lang` = 13
0.5 1 /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 (23) AND il.`id_lang` = 13 ORDER by i.`position`
0.5 7 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7) 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 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` = 13)
WHERE i.`id_product` = 7
ORDER BY `position`
0.5 8 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` = 15
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.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` = 13)
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` = 13)
WHERE pa.`id_product` = 66
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 13
0.5 0 /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` = 13)
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` = 13)
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` = 13)
WHERE pa.`id_product` = 3
AND pac.`id_product_attribute` = 56
AND agl.`id_lang` = 13
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` = 13)
WHERE i.`id_product` = 5
ORDER BY `position`
0.5 2 Yes /classes/Product.php:3042
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.5 1 /classes/shop/Shop.php:201
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
0.4 1 Yes /classes/shop/Shop.php:345
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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 87
AND agl.`id_lang` = 13
0.4 1 /classes/Product.php:6176
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_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.4 1 Yes /classes/SpecificPrice.php:612
SELECT SQL_NO_CACHE `id_guest`
FROM `mod259_connections`
WHERE `id_guest` = 14100218
AND `date_add` > '2024-12-14 18:51: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 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` = 13)
WHERE i.`id_product` = 58
ORDER BY `position`
0.4 10 Yes /classes/Product.php:3042
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`=23
0.4 20 /classes/Tag.php:229
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 (155, 156, 157, 158, 159) AND il.`id_lang` = 13 ORDER by i.`position`
0.4 10 Yes /classes/Product.php:2483
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.4 25 Yes /classes/Currency.php:302
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` = 23) AND (b.`id_shop` = 1) 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` = 13)
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` = 13)
WHERE pa.`id_product` = 58
AND pac.`id_product_attribute` = 158
AND agl.`id_lang` = 13
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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 (165, 166, 167, 168) AND il.`id_lang` = 13 ORDER by i.`position`
0.4 12 Yes /classes/Product.php:2483
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.4 1 Yes /classes/shop/Shop.php:704
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 13
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 14 Yes Yes /classes/Category.php:1098
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` = 7)
0.4 1 /classes/Product.php:3342
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` = 28 AND pa.`id_product` = 28 AND pa.`id_product_attribute` = 83 LIMIT 1
0.4 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` = 5)
0.4 1 /classes/Product.php:3342
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.4 1 /classes/Product.php:938
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.4 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` = 7 AND pa.`id_product` = 7 AND pa.`id_product_attribute` = 23 LIMIT 1
0.4 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` = 28)
0.4 8 /classes/Product.php:3342
SELECT SQL_NO_CACHE * FROM `mod259_hook_alias`
0.4 88 /classes/Hook.php:260
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 = "13"
AND pr.status = 1
ORDER BY pr.position
0.4 24 Yes /modules/blockreassurance/classes/ReassuranceActivity.php:159
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 `iso_code`
FROM `mod259_country`
WHERE `id_country` = 8 LIMIT 1
0.4 1 /classes/Country.php:272
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.4 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` = 13)
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.4 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` = 13)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (7) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 1 Yes Yes /classes/Product.php:3860
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.4 1 /classes/Product.php:3342
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` = 23
AND image_shop.`cover` = 1 LIMIT 1
0.4 6 /classes/Product.php:3064
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` = 23) AND (b.`id_shop` = 1) LIMIT 1
0.4 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` = 23) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
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` = 13 ORDER by i.`position`
0.4 1 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` = 10
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.4 1 /src/Adapter/EntityMapper.php:75
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 = 23
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-12-14 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.4 0 /classes/Product.php:1399
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` = 58 AND pa.`id_product` = 58 AND pa.`id_product_attribute` = 155 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 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` = 66)
0.3 1 /classes/Product.php:3342
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.3 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.3 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` = 165) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
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 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.3 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` = 13)
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` = 13)
WHERE pa.`id_product` = 58
AND pac.`id_product_attribute` = 159
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE * FROM `mod259_hook_alias`
0.3 88 /classes/Hook.php:234
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` = 58)
0.3 5 /classes/Product.php:3342
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` = 83) LIMIT 1
0.3 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.3 0 /classes/tax/TaxRulesTaxManager.php:108
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.3 1 /classes/Product.php:845
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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 85
AND agl.`id_lang` = 13
0.3 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 23
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 13
0.3 0 /classes/Product.php:6176
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 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` = 13)
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` = 13)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 167
AND agl.`id_lang` = 13
0.3 1 /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` = 13)
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` = 13)
WHERE pa.`id_product` = 3
AND pac.`id_product_attribute` = 281
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
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` = 3)
0.3 2 /classes/Product.php:3342
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 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` = 13)
WHERE i.`id_product` = 3
ORDER BY `position`
0.3 1 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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 249
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE *
FROM `mod259_group_lang`
WHERE `id_group` = 1
0.3 15 /src/Adapter/EntityMapper.php:82
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` = 13
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.3 1 /src/Adapter/EntityMapper.php:75
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.3 14 /classes/Language.php:882
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` = 13
LEFT JOIN `mod259_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 14) AND (b.`id_shop` = 1) LIMIT 1
0.3 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` = 13)
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` = 13)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 168
AND agl.`id_lang` = 13
0.3 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` = 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.3 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` = 15) LIMIT 1
0.3 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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 89
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
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` = 59 AND pa.`id_product` = 59 AND pa.`id_product_attribute` = 165 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` = 59)
0.3 4 /classes/Product.php:3342
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 = 13
0.3 1 /modules/seoexpert/seoexpert.php:878
SELECT SQL_NO_CACHE *
FROM `mod259_category` a0
LEFT JOIN `mod259_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 11) AND (a0.`nright` > 20) AND (a1.`id_lang` = 13)
ORDER BY a0.`nleft` asc
0.3 98 Yes /classes/PrestaShopCollection.php:373
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` = 13)
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` = 13)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 166
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
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` = 3 AND pa.`id_product` = 3 AND pa.`id_product_attribute` = 56 LIMIT 1
0.3 1 /classes/Product.php:938
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` = 23) AND (b.`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` = 6
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 *
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` = 14) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_page`
FROM `mod259_page`
WHERE `id_page_type` = 9 AND `id_object` = 23 LIMIT 1
0.3 1 /classes/Page.php:80
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.3 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` = 13)
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` = 13)
WHERE pa.`id_product` = 28
AND pac.`id_product_attribute` = 248
AND agl.`id_lang` = 13
0.3 1 /classes/Product.php:6176
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` = 155) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
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 (56, 281) AND il.`id_lang` = 13 ORDER by i.`position`
0.3 2 Yes /classes/Product.php:2483
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.3 1 /src/Adapter/EntityMapper.php:75
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 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_category_lang`
WHERE `id_category` = 14 AND `id_shop` = 1
0.3 15 /src/Adapter/EntityMapper.php:82
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` = 23 LIMIT 1
0.3 1 /classes/Product.php:6562
SELECT SQL_NO_CACHE * FROM `mod259_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.3 8 Yes /classes/ImageType.php:109
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.3 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` = 23 LIMIT 1
0.3 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE * FROM mod259_rec_whitelist WHERE ip_address = "18.97.14.91"
0.3 1 /modules/recaptchapro/recaptchapro.php:662
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 = 13)
WHERE pa.id_product = 23
0.3 1 /classes/Product.php:4972
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 *
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 value FROM `mod259_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.2 1 /classes/shop/Shop.php:1160
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` = 56) 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` = 83 LIMIT 1
0.2 1 /classes/Combination.php:453
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` = 165 LIMIT 1
0.2 1 /classes/Combination.php:453
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 =13 LIMIT 1
0.2 3 /modules/psgdpr/classes/GDPRConsent.php:111
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.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE *
FROM `mod259_country_lang`
WHERE `id_country` = 8
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 28) 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 1 FROM `mod259_specific_price` WHERE id_product = 0 LIMIT 1
0.2 1 /classes/SpecificPrice.php:407
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 13 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
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_shop` WHERE `id_module` = 97 AND `id_shop` = 1 LIMIT 1
0.2 1 /classes/module/Module.php:2277
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 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 *
FROM `mod259_country` a
LEFT JOIN `mod259_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 13
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 SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 59) 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 = 15) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
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 name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 13 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
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 cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 13
AND cl.id_shop = 1 
AND cl.`id_category` = 14 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` = 15 LIMIT 1
0.2 1 /classes/Combination.php:453
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_shop
FROM `mod259_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
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_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.`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` = 56 LIMIT 1
0.2 1 /classes/Combination.php:453
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 cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 8
AND cl.id_shop = 1 
AND cl.`id_category` = 14 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` = 155 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 28) AND (id_product_attribute = 83) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
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  = 14
AND msr.id_shop = 1
AND msr.id_lang = 13
0.2 1 /modules/seoexpert/seoexpert.php:878
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 58) AND (id_product_attribute = 155) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `mod259_specific_price` WHERE `id_product` != 0 LIMIT 1
0.2 3 /classes/SpecificPrice.php:283
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 `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 66 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 13 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE id_page_type
FROM mod259_page_type
WHERE name = 'product' LIMIT 1
0.2 1 /classes/Page.php:100
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 7) 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 = 66) 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_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 66
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 7) AND (id_product_attribute = 23) 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 = 58) 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_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 28
0.2 8 /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` = 13) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
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 SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 3) 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 cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 2
AND cl.id_shop = 1 
AND cl.`id_category` = 14 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 13 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE DISTINCT `id_product` FROM `mod259_specific_price` WHERE `id_product` != 0
0.2 2 /classes/SpecificPrice.php:291
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 7 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 28 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
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 1 FROM `mod259_specific_price` WHERE `from` BETWEEN '2024-12-14 00:00:00' AND '2024-12-14 23:59:59' LIMIT 1
0.2 2 /classes/SpecificPrice.php:358
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 5 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
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 *
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 cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 13
AND cl.id_shop = 1 
AND cl.`id_category` = 2 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 28 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
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_manufacturer`
WHERE `id_manufacturer` = 0
AND `active` = 1 LIMIT 1
0.2 0 /classes/Manufacturer.php:310
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 5 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
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_shop
FROM `mod259_product_shop`
WHERE `id_product` = 23
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 58 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE ctg.`id_group`
FROM mod259_category_group ctg
WHERE ctg.`id_category` = 14 AND ctg.`id_group` = 1 LIMIT 1
0.2 1 /classes/Category.php:1654
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 = 59) AND (id_product_attribute = 165) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 58
0.2 5 /classes/Product.php:2465