Verkaufshits Es gibt 19 Produkte.

Load Time445 ms - Unicorn powered webserver!
Querying Time184 ms
Queries364
Memory Peak Usage20.2 Mb
Included Files814 files - 9.71 Mb
PrestaShop Cache- Mb
Global vars0.62 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 65 ms 65 ms 5.84 Mb 6.16 Mb
__construct 0 ms 65 ms - Mb 6.16 Mb
init 16 ms 81 ms 1.43 Mb 7.32 Mb
checkAccess 0 ms 81 ms - Mb 7.32 Mb
setMedia 8 ms 89 ms 0.68 Mb 7.95 Mb
postProcess 0 ms 89 ms - Mb 7.95 Mb
initHeader 0 ms 89 ms - Mb 7.95 Mb
initContent 198 ms 287 ms 6.26 Mb 14.22 Mb
initFooter 0 ms 287 ms - Mb 14.22 Mb
display 159 ms 445 ms 5.65 Mb 20.18 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 364 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`)
9.4 10908 /classes/Configuration.php:160
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `mod259_module` m
INNER JOIN mod259_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `mod259_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `mod259_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `mod259_hook` `h` ON hm.`id_hook` = h.`id_hook`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1)
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
5 274 Yes Yes /classes/Hook.php:666
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
4.6 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
4.6 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
4.5 757 /classes/Hook.php:403
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute,
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`,
m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
DATEDIFF(p.`date_add`, DATE_SUB("2024-12-14 00:00:00",
INTERVAL 20 DAY)) > 0 AS new FROM `mod259_product_sale` ps
LEFT JOIN `mod259_product` p ON ps.`id_product` = p.`id_product`
LEFT 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` = 8 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` = 8)
LEFT JOIN `mod259_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `mod259_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
AND tr.`id_country` = 21
AND tr.`id_state` = 0
LEFT JOIN `mod259_tax` t ON (t.`id_tax` = tr.`id_tax`)
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 product_shop.`active` = 1
AND product_shop.`visibility` != 'none'
ORDER BY `sales` DESC
LIMIT 0, 12
3.5 7 /classes/ProductSale.php:151
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.6 1 /classes/ObjectModel.php:551
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 8)
WHERE i.`id_product` = 52
ORDER BY `position`
1.8 73 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute,
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`,
m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer,
image_shop.`id_image` id_image, il.`legend`,
ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`,
DATEDIFF(p.`date_add`, DATE_SUB("2024-12-14 00:00:00",
INTERVAL 20 DAY)) > 0 AS new FROM `mod259_product_sale` ps
LEFT JOIN `mod259_product` p ON ps.`id_product` = p.`id_product`
LEFT 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` = 8 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` = 8)
LEFT JOIN `mod259_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
LEFT JOIN `mod259_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`)
AND tr.`id_country` = 21
AND tr.`id_state` = 0
LEFT JOIN `mod259_tax` t ON (t.`id_tax` = tr.`id_tax`)
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 product_shop.`active` = 1
AND product_shop.`visibility` != 'none'
ORDER BY `sales` DESC
LIMIT 0, 4
1.8 7 /classes/ProductSale.php:151
SHOW TABLES LIKE '%psblog_blog%'
1.7 1 /modules/psblog/psblog.php:44
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 8)
WHERE i.`id_product` = 54
ORDER BY `position`
1.7 72 Yes /classes/Product.php:3042
UPDATE `mod259_page_viewed`
SET `counter` = `counter` + 1
WHERE `id_date_range` = 3660
AND `id_page` = 38
AND `id_shop` = 1
1.7 1 /classes/Page.php:127
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 3 AND `id_shop` = 1
1.6 14 /src/Adapter/EntityMapper.php:82
INSERT INTO `mod259_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14100395', '38', '308350555', '', '1', '1', '2024-12-14 20:40:37')
1.5 1 /classes/ObjectModel.php:551
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 54
1.5 8 /classes/ProductAssembler.php:90
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.4 0 /classes/Hook.php:190
SELECT SQL_NO_CACHE c.id_parent, c.id_category, cl.name, cl.description, cl.link_rewrite
FROM `mod259_category` c
INNER JOIN `mod259_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 8 AND cl.id_shop = 1 )
INNER JOIN `mod259_category_shop` cs ON (cs.`id_category` = c.`id_category` AND cs.`id_shop` = 1)
WHERE (c.`active` = 1 OR c.`id_category` = 2)
AND c.`id_category` != 1
AND `level_depth` <= 5
AND nleft >= 2 AND nright <= 27
AND c.id_category IN (
SELECT id_category
FROM `mod259_category_group`
WHERE `id_group` IN (3)
)
ORDER BY `level_depth` ASC, cs.`position` ASC
1.4 13 Yes /modules/ps_categorytree/ps_categorytree.php:166
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,
(DATEDIFF(product_shop.`date_add`,
DATE_SUB(
"2024-12-14 00:00:00",
INTERVAL 20 DAY
)
) > 0) as new,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute
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_lang` `pl` ON 
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 8 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` = 8
LEFT JOIN `mod259_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer`
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  )
WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (product_shop.`date_add` > "2024-11-24")
ORDER BY product_shop.`date_add` DESC
LIMIT 4
1.3 7 /classes/Product.php:2651
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` = 8)
WHERE i.`id_product` = 102
ORDER BY `position`
1.2 72 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` = 8)
WHERE i.`id_product` = 53
ORDER BY `position`
1.2 77 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`available_now`, pl.`available_later`,
IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`,
pl.`name`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-12-14 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
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 (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_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 8 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` = 8)
LEFT JOIN `mod259_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`)
WHERE product_shop.`active` = 1
AND product_shop.`show_price` = 1
AND product_shop.`visibility` IN ("both", "catalog")
AND p.`id_product` IN (0)
ORDER BY product_shop.price DESC
LIMIT 0, 4
1.2 0 /classes/Product.php:2907
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.1 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
1 180 /classes/module/Module.php:305
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 8)
WHERE i.`id_product` = 52
ORDER BY `position`
1 73 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `mod259_image` i
INNER JOIN mod259_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `mod259_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 8)
WHERE i.`id_product` = 54
ORDER BY `position`
1 72 Yes /classes/Product.php:3042
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 3
0.9 5 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COUNT(1)
FROM information_schema.COLUMNS
WHERE TABLE_SCHEMA = "backupleaf"
AND TABLE_NAME = "mod259_tab"
AND COLUMN_NAME = "hide_host_mode" LIMIT 1
0.9 0 /modules/seoexpert/seoexpert.php:376
SELECT SQL_NO_CACHE 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 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` = 8)
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.9 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.9 12 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 pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (149, 150, 151, 152, 153, 154) AND il.`id_lang` = 8 ORDER by i.`position`
0.9 70 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.9 12 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 8 ORDER by i.`position`
0.9 50 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.9 8 Yes Yes /classes/Product.php:3860
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 23
0.9 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (149, 150, 151, 152, 153, 154) AND il.`id_lang` = 8 ORDER by i.`position`
0.9 70 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE tr.*
FROM `mod259_tax_rule` tr
JOIN `mod259_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 60
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.8 1 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE 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 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE 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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 54
0.8 8 /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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 65
0.8 1 /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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 23
0.8 1 /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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 66
0.8 1 /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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 12 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` = 8)
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.8 1 Yes Yes /classes/Product.php:3860
INSERT IGNORE INTO `mod259_connections_page` (`id_connections`, `id_page`, `time_start`) VALUES ('13862940', '38', '2024-12-14 20:40:37')
0.8 1 /classes/Connection.php:122
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 53
0.8 8 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE "thumb" FROM INFORMATION_SCHEMA.COLUMNS WHERE TABLE_SCHEMA = "backupleaf" AND TABLE_NAME = "mod259_psblog_blog" AND COLUMN_NAME = "thumb"
0.8 0 /modules/psblog/psblog.php:44
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 102
0.8 2 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (102) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE 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 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.8 8 Yes Yes /classes/Product.php:3860
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 = 8
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 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 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` = 8)
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.7 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (53) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 8 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE 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` = 92 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` = 92 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` = 151
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 54 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 151
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 54 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 7
0.7 4 /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` = 8
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.7 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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 52
0.7 5 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 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.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` = 8)
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` = 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.7 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (140, 141, 144, 172) AND il.`id_lang` = 8 ORDER by i.`position`
0.7 50 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 300
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 102 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 300
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 102 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (52) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 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` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 52) AND (b.`id_shop` = 1) LIMIT 1
0.7 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 2 AND `id_shop` = 1
0.6 14 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (65) 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 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (92) 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 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (102) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (175, 176, 178, 179) AND il.`id_lang` = 8 ORDER by i.`position`
0.6 47 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` = 8
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.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 8)
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.6 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 92) AND (b.`id_shop` = 1) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
JOIN `mod259_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `mod259_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `mod259_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (23) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 1 Yes Yes /classes/Product.php:3860
SELECT SQL_NO_CACHE 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` = 8)
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.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` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 102 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 102 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.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` = 8
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 COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 172
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 172
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
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.6 1 Yes /classes/shop/Shop.php:345
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.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 144
AND agl.`id_lang` = 8
0.6 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 64 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` = 64 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 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.6 1 Yes /classes/shop/Shop.php:704
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 54 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 54 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.6 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE hs.`id_htmlbanners6_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`customclass`, hssl.`image`
FROM mod259_htmlbanners6 hs
LEFT JOIN mod259_htmlbanners6_slides hss ON (hs.id_htmlbanners6_slides = hss.id_htmlbanners6_slides)
LEFT JOIN mod259_htmlbanners6_slides_lang hssl ON (hss.id_htmlbanners6_slides = hssl.id_htmlbanners6_slides)
WHERE id_shop = 1
AND hssl.id_lang = 8 AND hss.`active` = 1
ORDER BY hss.position
0.6 5 Yes /modules/htmlbanners6/htmlbanners6.php:599
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2024-12-14 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM mod259_product p
LEFT JOIN mod259_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 92
0.6 1 /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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (64) 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 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` = 8)
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` = 8)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 165
AND agl.`id_lang` = 8
0.6 1 /classes/Product.php:6176
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 65 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` = 65 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 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` = 8)
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.6 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` = 8)
WHERE i.`id_product` = 23
ORDER BY `position`
0.6 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` = 8)
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` = 8)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 179
AND agl.`id_lang` = 8
0.6 2 /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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (54) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.6 12 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` = 8)
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` = 8)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 150
AND agl.`id_lang` = 8
0.6 2 /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` = 8)
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.6 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` = 8)
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` = 8)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 166
AND agl.`id_lang` = 8
0.5 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` = 8)
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 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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 64
0.5 1 /classes/ProductAssembler.php:90
SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb
FROM `mod259_product_sale` ps
LEFT JOIN `mod259_product` p ON p.`id_product` = ps.`id_product`
LEFT JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1 LIMIT 1
0.5 90 /classes/ProductSale.php:60
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` = 8)
WHERE i.`id_product` = 66
ORDER BY `position`
0.5 4 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` = 8)
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` = 8)
WHERE pa.`id_product` = 102
AND pac.`id_product_attribute` = 300
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 152
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 168
AND agl.`id_lang` = 8
0.5 1 /classes/Product.php:6176
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 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` = 8)
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` = 8)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 149
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 92
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 8
0.5 0 /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` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 64) AND (b.`id_shop` = 1) LIMIT 1
0.5 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` = 8)
WHERE i.`id_product` = 7
ORDER BY `position`
0.5 8 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 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.5 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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 7
0.5 4 /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` = 8)
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` = 8)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 178
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 176
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE `iso_code`
FROM `mod259_country`
WHERE `id_country` = 8 LIMIT 1
0.5 1 /classes/Country.php:272
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` = 8)
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` = 8)
WHERE pa.`id_product` = 59
AND pac.`id_product_attribute` = 167
AND agl.`id_lang` = 8
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` = 8)
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` = 8)
WHERE pa.`id_product` = 53
AND pac.`id_product_attribute` = 175
AND agl.`id_lang` = 8
0.5 2 /classes/Product.php:6176
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.5 11 /classes/Language.php:1029
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` = 8)
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` = 8)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 140
AND agl.`id_lang` = 8
0.5 1 /classes/Product.php:6176
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.5 25 Yes /classes/Currency.php:302
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 52 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 52 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE 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` = 8)
WHERE i.`id_product` = 59
ORDER BY `position`
0.4 12 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM mod259_meta m
LEFT JOIN mod259_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 8
AND ml.id_shop = 1 LIMIT 1
0.4 2 /classes/Meta.php:189
SELECT SQL_NO_CACHE hs.`id_htmlbanners7_slides` as id_slide, hss.`position`, hss.`active`, hssl.`title`,
hssl.`url`, hssl.`legend`, hssl.`customclass`, hssl.`description`, hssl.`image`
FROM mod259_htmlbanners7 hs
LEFT JOIN mod259_htmlbanners7_slides hss ON (hs.id_htmlbanners7_slides = hss.id_htmlbanners7_slides)
LEFT JOIN mod259_htmlbanners7_slides_lang hssl ON (hss.id_htmlbanners7_slides = hssl.id_htmlbanners7_slides)
WHERE id_shop = 1
AND hssl.id_lang = 8 AND hss.`active` = 1
ORDER BY hss.position
0.4 2 Yes /modules/htmlbanners7/htmlbanners7.php:590
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` = 8)
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` = 8)
WHERE pa.`id_product` = 54
AND pac.`id_product_attribute` = 151
AND agl.`id_lang` = 8
0.4 2 /classes/Product.php:6176
SELECT SQL_NO_CACHE `id_product`, `id_product_attribute`
FROM `mod259_specific_price`
WHERE	`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 3) AND
`from_quantity` = 1 AND
`reduction` > 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`)
0.4 1 /classes/SpecificPrice.php:671
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `mod259_currency` c
LEFT JOIN mod259_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.4 5 /classes/Currency.php:661
SELECT SQL_NO_CACHE count(id_wishlist_product) FROM mod259_wishlist w, mod259_wishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1
0.4 43 /modules/blockwishlist/blockwishlist.php:189
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `mod259_attribute` a
LEFT JOIN `mod259_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 8)
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` = 8)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 141
AND agl.`id_lang` = 8
0.4 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` = 8)
WHERE i.`id_product` = 7
ORDER BY `position`
0.4 8 Yes /classes/Product.php:3042
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 = 8
LEFT JOIN mod259_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 52
0.4 5 /classes/ProductAssembler.php:90
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` = 8
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.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 65) 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` = 8)
JOIN `mod259_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (23) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.4 1 Yes Yes /classes/Product.php:3860
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` = 8
LEFT JOIN `mod259_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 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.4 0 /classes/Cart.php:1234
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.4 4 /classes/Product.php:3342
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.4 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` = 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.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (23) AND il.`id_lang` = 8 ORDER by i.`position`
0.4 7 Yes /classes/Product.php:2483
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.4 1 /classes/Cart.php:4013
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 175
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 175
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
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` = 8)
WHERE i.`id_product` = 65
ORDER BY `position`
0.4 1 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 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.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 5 AND `id_shop` = 1
0.4 14 /src/Adapter/EntityMapper.php:82
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` = 102) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product` a
LEFT JOIN `mod259_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 8
LEFT JOIN `mod259_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 54) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE COUNT(ps.`id_product`) AS nb
FROM `mod259_product_sale` ps
LEFT JOIN `mod259_product` p ON p.`id_product` = ps.`id_product`
LEFT JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE product_shop.`active` = 1 LIMIT 1
0.4 90 /classes/ProductSale.php:60
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` = 8)
WHERE i.`id_product` = 23
ORDER BY `position`
0.4 6 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 53 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `mod259_cart_product` cp JOIN `mod259_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `mod259_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 53 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
0.4 0 /classes/Cart.php:1234
SELECT SQL_NO_CACHE 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` = 8 ORDER by i.`position`
0.4 12 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE *
FROM mod259_meta m
LEFT JOIN mod259_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "best-sales"
OR m.page = "bestsales"
)
AND ml.id_lang = 8
AND ml.id_shop = 1 LIMIT 1
0.4 2 /classes/Meta.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` = 8)
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` = 8)
WHERE pa.`id_product` = 65
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 8
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_featuredproducts" LIMIT 1
0.4 1 /classes/module/Module.php:2752
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` = 53) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_guest`
FROM `mod259_connections`
WHERE `id_guest` = 14100395
AND `date_add` > '2024-12-14 20:10:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.4 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE *
FROM `mod259_product_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.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 52)
0.4 4 /classes/Product.php:3342
SELECT SQL_NO_CACHE 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` = 8)
WHERE i.`id_product` = 3
ORDER BY `position`
0.4 1 Yes /classes/Product.php:3042
SELECT SQL_NO_CACHE *
FROM `mod259_cms_lang`
WHERE `id_cms` = 1 AND `id_shop` = 1
0.4 14 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_category` a
LEFT JOIN `mod259_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 8
LEFT JOIN `mod259_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.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` = 8)
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` = 8)
WHERE pa.`id_product` = 23
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 8
0.4 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `mod259_cart_product` cp
WHERE cp.`id_product_attribute` = 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.3 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` = 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.3 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` = 8)
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` = 8)
WHERE pa.`id_product` = 3
AND pac.`id_product_attribute` = 281
AND agl.`id_lang` = 8
0.3 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` = 8)
WHERE i.`id_product` = 92
ORDER BY `position`
0.3 6 Yes /classes/Product.php:3042
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` = 8 ORDER by i.`position`
0.3 2 Yes /classes/Product.php:2483
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 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` = 8)
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` = 8)
WHERE pa.`id_product` = 52
AND pac.`id_product_attribute` = 172
AND agl.`id_lang` = 8
0.3 1 /classes/Product.php:6176
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 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_hook_alias`
0.3 88 /classes/Hook.php:234
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_country_lang`
WHERE `id_country` = 8
0.3 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "blocklanguages" LIMIT 1
0.3 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM `mod259_hook_alias`
0.3 88 /classes/Hook.php:260
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` = 8)
WHERE i.`id_product` = 64
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` = 8)
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` = 8)
WHERE pa.`id_product` = 7
AND pac.`id_product_attribute` = 23
AND agl.`id_lang` = 8
0.3 1 /classes/Product.php:6176
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 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_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` = 92)
0.3 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` = 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_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 300 LIMIT 1
0.3 1 /classes/Combination.php:453
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.3 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 102 AND pa.`id_product` = 102 AND pa.`id_product_attribute` = 300 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 64
0.3 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `mod259_product_attribute_image` pai
LEFT JOIN `mod259_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `mod259_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (300) AND il.`id_lang` = 8 ORDER by i.`position`
0.3 11 Yes /classes/Product.php:2483
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 product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 53)
0.3 4 /classes/Product.php:3342
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 59 AND id_shop=1 LIMIT 1
0.3 1 /classes/Product.php:5620
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_hook_module_exceptions`
WHERE `id_shop` IN (1)
0.3 1 /classes/module/Module.php:2188
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 53 AND pa.`id_product` = 53 AND pa.`id_product_attribute` = 175 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 52 AND pa.`id_product` = 52 AND pa.`id_product_attribute` = 172 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE 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` = 8 ORDER by i.`position`
0.3 7 Yes /classes/Product.php:2483
SELECT SQL_NO_CACHE pa.`available_date` FROM `mod259_product` p LEFT JOIN `mod259_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN mod259_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) WHERE p.`id_product` = 54 AND pa.`id_product` = 54 AND pa.`id_product_attribute` = 151 LIMIT 1
0.3 1 /classes/Product.php:938
SELECT SQL_NO_CACHE 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` = 8)
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` = 8)
WHERE pa.`id_product` = 3
AND pac.`id_product_attribute` = 56
AND agl.`id_lang` = 8
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` = 102)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 7
0.3 1 /classes/Product.php:2465
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 `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 53
0.3 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 300) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cb.`id_link_block`
FROM mod259_link_block cb
WHERE `id_hook` = 26
ORDER by cb.`position`
0.3 2 Yes /modules/ps_linklist/src/LegacyLinkBlockRepository.php:71
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 59
0.3 4 /classes/Product.php:2465
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` = 8)
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` = 8)
WHERE pa.`id_product` = 64
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 8
0.3 0 /classes/Product.php:6176
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_contactinfo" LIMIT 1
0.3 1 /classes/module/Module.php:2752
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_meta m
LEFT JOIN mod259_meta_lang ml ON m.id_meta = ml.id_meta
WHERE (
m.page = "contact"
OR m.page = "contact"
)
AND ml.id_lang = 8
AND ml.id_shop = 1 LIMIT 1
0.3 1 /classes/Meta.php:189
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.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE format
FROM `mod259_address_format`
WHERE `id_country` = 8 LIMIT 1
0.3 1 /classes/AddressFormat.php:618
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 SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 54) AND (id_product_attribute = 151) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:441
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` = 65)
0.3 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 172 LIMIT 1
0.3 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 151) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 175) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
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.3 2 /classes/SpecificPrice.php:358
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 52) AND (id_product_attribute = 172) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.3 1 /classes/stock/StockAvailable.php:441
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` = 8)
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` = 8)
WHERE pa.`id_product` = 66
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 8
0.3 0 /classes/Product.php:6176
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.3 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 2) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_currencyselector" LIMIT 1
0.3 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 131 AND `id_shop` = 1 LIMIT 1
0.3 1 /classes/module/Module.php:2277
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 `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 54
0.2 6 /classes/Product.php:2465
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 7)
0.2 1 /classes/Product.php:3342
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 *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "idxforbiddenproducts" LIMIT 1
0.2 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE 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 `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 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.2 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 102) AND (id_product_attribute = 300) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "deluxeprivatetocategory" LIMIT 1
0.2 0 /classes/module/Module.php:2752
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` = 64)
0.2 1 /classes/Product.php:3342
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `mod259_product` p
INNER JOIN `mod259_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `mod259_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 54)
0.2 6 /classes/Product.php:3342
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 7
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_product_attribute` a
LEFT JOIN `mod259_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 172) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_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.2 1 /src/Adapter/EntityMapper.php:75
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 id_required_field, object_name, field_name
FROM mod259_required_field
0.2 1 /classes/ObjectModel.php:1453
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 `name`
FROM `mod259_manufacturer`
WHERE `id_manufacturer` = 1
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:310
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE id_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 `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` = 53 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
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 value FROM `mod259_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.2 1 /classes/shop/Shop.php:1160
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 64) 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 = 65) 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_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.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM mod259_mce_list as mcl WHERE mcl.shop_id = 1
0.2 1 /modules/btmailchimpecommerce/lib/module-dao_class.php:123
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 102
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_link_block_lang`
WHERE `id_link_block` = 1
0.2 15 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 54) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE 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.2 1 /classes/Product.php:938
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 64 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 3 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE *
FROM `mod259_cms` a
LEFT JOIN `mod259_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 3) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_link_block` a
WHERE (a.`id_link_block` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE `to` BETWEEN '2024-12-14 00:00:00' AND '2024-12-14 23:59:59' LIMIT 1
0.2 2 /classes/SpecificPrice.php:362
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 4) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 8
AND cl.id_shop = 1 
AND cl.`id_category` = 12 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE 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.2 1 /classes/Product.php:938
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 =8 LIMIT 1
0.2 3 /modules/psgdpr/classes/GDPRConsent.php:111
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 92) 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 = 102) 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 = 52) 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 cl.`link_rewrite`
FROM `mod259_category_lang` cl
WHERE `id_lang` = 8
AND cl.id_shop = 1 
AND cl.`id_category` = 23 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` = 56 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 54
0.2 6 /classes/Product.php:2465
SELECT SQL_NO_CACHE id_page_type
FROM mod259_page_type
WHERE name = 'bestsales' LIMIT 1
0.2 1 /classes/Page.php:100
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 23 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 65 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
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 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 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 1 FROM `mod259_specific_price` WHERE id_product = 52 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
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 `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 52
0.2 4 /classes/Product.php:2465
SELECT SQL_NO_CACHE *
FROM `mod259_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_link_block_lang`
WHERE `id_link_block` = 2
0.2 15 /src/Adapter/EntityMapper.php:82
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 1 FROM `mod259_specific_price` WHERE id_product = 59 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 13 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE *
FROM `mod259_currency` a
LEFT JOIN `mod259_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `mod259_group_lang`
WHERE `id_group` = 1
0.2 15 /src/Adapter/EntityMapper.php:82
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 `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 65
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_searchbar" LIMIT 1
0.2 1 /classes/module/Module.php:2752
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 * 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 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 1 FROM `mod259_specific_price` WHERE id_product = 66 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 175 LIMIT 1
0.2 1 /classes/Combination.php:453
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` = 2 LIMIT 1
0.2 1 /classes/Category.php:1322
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 92 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 92 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 142 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 23 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 23
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_page`
FROM `mod259_page`
WHERE `id_page_type` = 23 LIMIT 1
0.2 1 /classes/Page.php:80
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 23
0.2 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE 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 = 102 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
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` = 8) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_shop
FROM `mod259_lang_shop`
WHERE `id_lang` = 8
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1588
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 52 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 65 AND id_shop=1 LIMIT 1
0.2 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE 1 FROM `mod259_specific_price` WHERE id_product = 3 LIMIT 1
0.2 1 /classes/SpecificPrice.php:416
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
0.2 0 /classes/module/Module.php:2277
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 14 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 2 LIMIT 1
0.2 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 53) AND (id_product_attribute = 175) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE product_attribute_shop.`price`
FROM `mod259_product_attribute` pa
INNER JOIN mod259_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
WHERE pa.`id_product_attribute` = 151 LIMIT 1
0.2 1 /classes/Combination.php:453
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 3
0.2 2 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_lang` FROM `mod259_lang` WHERE `iso_code` = 'de' LIMIT 1
0.2 14 /classes/Language.php:722
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 14 LIMIT 1
0.1 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 3) AND (id_product_attribute = 56) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1 /classes/stock/StockAvailable.php:441
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `mod259_product_shop`
WHERE `id_product` = 102 AND id_shop=1 LIMIT 1
0.1 1 /classes/Product.php:5620
SELECT SQL_NO_CACHE name FROM mod259_category_lang WHERE id_shop = 1 AND id_lang = 8 AND id_category = 12 LIMIT 1
0.1 1 /classes/Product.php:4725
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `mod259_product_attribute`
WHERE `id_product` = 92
0.1 1 /classes/Product.php:2465
SELECT SQL_NO_CACHE `id_module` FROM `mod259_module` WHERE `name` = "ps_customersignin" LIMIT 1
0.1 1 /classes/module/Module.php:2752
SELECT SQL_NO_CACHE SUM(quantity)
FROM `mod259_stock_available`
WHERE (id_product = 53) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.1 1