Fino al 30 Aprile (compreso) Sconto EXTRA 10% su tutti i prodotti in catalogo, usa il codice APRILE-10. Offerta valida per ordini oltre 120 euro iva inclusa, riservata ai nuovi clienti, l'offerta non si applica ai prodotti Cangini & Tucci e GEA
  • -41%
Rossini Sax 20560-20 led faretto segnapasso IP66
  • Rossini Sax 20560-20 led faretto segnapasso IP66
  • Rossini Sax 20560-20 led faretto segnapasso IP66

Rossini Sax 20560-20 led faretto segnapasso IP66

51,48 €
30,38 € Risparmia 41%
IVA inclusa

Faretto segnapasso rettangolare IP66 led finitura bianco o nero.

Colore
Quantità

100% secure payments
  • Pagamenti sicuri su circuito SSL Pagamenti sicuri su circuito SSL
  • Spedizione gratis da 180€ di spesa (altrimenti 9,76 iva inclusa) Spedizione gratis da 180€ di spesa (altrimenti 9,76 iva inclusa)
  • Diritto di recesso 14 giorni Diritto di recesso 14 giorni

Rossini Sax 20560-20 IP66

Faretto segnapasso IP66 led di Rossini Illuminazione, realizzato in policarbonato anti urto stabilizzato, inattaccabile da ruggine e corrosione.
Diffusore in metacrilato con guarnizione in gomma siliconica

Corredato di cassaforma, alimentatore integrato.

20560-20-LED

Scheda tecnica

Altezza
113 mm
Larghezza
188 mm
Profondità
98 mm
Foro incasso
104x178 mm
Peso
0.7 kg
IP
66
Classe isolamento
II
Lampadine incluse
SI
Attacco lampadine
Led
Potenza massima lampadine
3W
Numero lampadine
1
Angolo apertura fascio luminoso
20°
Tensione utilizzo
220V
Lumen
350
Temperatura colore
4000° k
Spedizione
5/10 giorni lavorativi

Potrebbe anche piacerti

Load Time665 ms - Unicorn powered webserver!
Querying Time116 ms
Queries372
Memory Peak Usage41.1 Mb
Included Files944 files - 9.34 Mb
PrestaShop Cache- Mb
Global vars1.00 Mb
PrestaShop Version1.7.6.5
PHP Version7.0.33 (Consider upgrading)
MySQL Version5.6.51-log (OK)
Memory Limit1024M
Max Execution Time3600s
Smarty Cacheenabled
Smarty Compilationnever recompile
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 108 ms 108 ms 15.04 Mb 15.33 Mb
__construct 0 ms 108 ms - Mb 15.33 Mb
init 137 ms 245 ms 9.35 Mb 24.44 Mb
checkAccess 0 ms 245 ms - Mb 24.44 Mb
setMedia 66 ms 311 ms 1.95 Mb 26.85 Mb
postProcess 0 ms 311 ms - Mb 26.85 Mb
initHeader 0 ms 311 ms - Mb 26.85 Mb
initContent 116 ms 427 ms 6.72 Mb 33.12 Mb
initFooter 0 ms 427 ms - Mb 33.12 Mb
display 237 ms 665 ms 7.79 Mb 41.15 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 372 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `pr_specific_price` WHERE `id_product` != 0 LIMIT 1
9.6 7433 /classes/SpecificPrice.php:283
INSERT INTO `pr_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
2.3 1 /classes/ObjectModel.php:559
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `pr_country` c  INNER JOIN pr_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 1)
LEFT JOIN `pr_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 2)
LEFT JOIN `pr_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
2.1 244 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE * FROM `pr_state` ORDER BY `name` ASC
2.1 312 Yes /classes/Country.php:154
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 `pr_configuration` c
LEFT JOIN `pr_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
2 876 /classes/Configuration.php:160
SELECT SQL_NO_CACHE * FROM `pr_hook_module_exceptions`
WHERE `id_shop` IN (1)
1.7 12 /classes/module/Module.php:2221
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `pr_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `pr_hook_alias` ha
INNER JOIN `pr_hook` h ON ha.name = h.name
1.7 0 /classes/Hook.php:194
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `pr_module` m
INNER JOIN pr_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 `pr_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `pr_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `pr_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `pr_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
1.7 152 Yes Yes /classes/Hook.php:670
INSERT INTO `pr_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('5763532', '2880', '315359934', '', '1', '1', '2021-04-21 09:16:37')
1.6 1 /classes/ObjectModel.php:559
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 `pr_hook_module` hm
STRAIGHT_JOIN `pr_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `pr_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.4 387 /classes/Hook.php:407
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2021-04-21 00:00:00",
INTERVAL 60 DAY
)
) > 0 AS new
FROM `pr_accessory`
LEFT JOIN `pr_product` p ON p.`id_product` = `id_product_2`
INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pr_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 `pr_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 2 AND pl.id_shop = 1 
)
LEFT JOIN `pr_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 2 AND cl.id_shop = 1 
)
LEFT JOIN `pr_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 `pr_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 2)
LEFT JOIN `pr_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN pr_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 3463 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
1.2 1 Yes Yes /classes/Product.php:4031
(SELECT SQL_NO_CACHE * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
0.9 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(908,886)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.8 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 3463 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.8 4 Yes /classes/SpecificPrice.php:620
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `pr_pscheckout_funding_source`
WHERE `id_shop` = 1
0.8 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
(SELECT SQL_NO_CACHE * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1) UNION (SELECT * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
0.8 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3463
0.8 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_tab=4
ORDER BY sort_order asc
0.7 10 Yes /modules/ets_megamenu/ets_megamenu.php:2376
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 `pr_product_attribute` pa
INNER JOIN pr_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 `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
JOIN `pr_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (3461) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
0.7 2 Yes Yes /classes/Product.php:3887
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pr_product_attribute` pa
INNER JOIN pr_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 pr_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pr_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3463
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.7 2 Yes Yes /classes/Product.php:3942
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=5 
ORDER BY b.sort_order asc,bl.title asc
0.7 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=4 
ORDER BY b.sort_order asc,bl.title asc
0.7 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=1 
ORDER BY b.sort_order asc,bl.title asc
0.6 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*, ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, al.`name` AS attribute_name,
a.`id_attribute`
FROM `pr_product_attribute` pa
INNER JOIN pr_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 `pr_product_attribute_combination` pac ON pac.`id_product_attribute` = pa.`id_product_attribute`
LEFT JOIN `pr_attribute` a ON a.`id_attribute` = pac.`id_attribute`
LEFT JOIN `pr_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group`
LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 3461
GROUP BY pa.`id_product_attribute`,ag.`id_attribute_group`
ORDER BY pa.`id_product_attribute`
0.6 2 Yes Yes /classes/Product.php:2397
(SELECT SQL_NO_CACHE * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `pr_cart_rule` cr
LEFT JOIN `pr_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 2) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
0.6 1 /classes/CartRule.php:401
SELECT SQL_NO_CACHE *
FROM `pr_product` a
LEFT JOIN `pr_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3463) LIMIT 1
0.6 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.`id_lang`, cl.`name`, cl.`description`, cl.`link_rewrite`, cl.`meta_title`, cl.`meta_keywords`, cl.`meta_description`
FROM `pr_category` c
INNER JOIN pr_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
LEFT JOIN `pr_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 2  AND cl.id_shop = 1 )
LEFT JOIN `pr_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 917
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.6 1 Yes Yes /classes/Category.php:909
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pr_attribute` a
LEFT JOIN `pr_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pr_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `pr_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pr_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN pr_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3463
0.6 2 /classes/Product.php:6285
SELECT SQL_NO_CACHE tr.*
FROM `pr_tax_rule` tr
JOIN `pr_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 232)
AND ('01030' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '01030')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.6 0 /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=5 
ORDER BY b.sort_order asc,bl.title asc
0.6 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 77 /classes/module/Module.php:307
SELECT SQL_NO_CACHE *
FROM `pr_cms` a
LEFT JOIN `pr_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = 2
LEFT JOIN `pr_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = 1
WHERE (a.`id_cms` = 7) AND (b.`id_shop` = 1) LIMIT 1
0.5 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pr_product_attribute` pa
INNER JOIN pr_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 pr_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pr_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3463
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.5 2 Yes Yes /classes/Product.php:3942
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 3463 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM pr_manufacturer m
INNER JOIN pr_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=1)            
WHERE active=1 
ORDER BY name asc
0.5 49 Yes /modules/ets_megamenu/ets_megamenu.php:2426
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=1 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, product_attribute_shop.`unit_price_impact`,
product_attribute_shop.`minimal_quantity`, product_attribute_shop.`available_date`, ag.`group_type`
FROM `pr_product_attribute` pa
INNER JOIN pr_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 pr_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `pr_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
LEFT JOIN `pr_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pr_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`)
LEFT JOIN `pr_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`)
LEFT JOIN `pr_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`)
INNER JOIN pr_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3463
AND al.`id_lang` = 2
AND agl.`id_lang` = 2
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
0.5 2 Yes Yes /classes/Product.php:3942
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.5 77 /classes/module/Module.php:307
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 3463 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.5 4 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE m.*,ml.title,ml.link,ml.bubble_text
FROM pr_ets_mm_menu m
INNER JOIN pr_ets_mm_menu_shop ms ON (m.id_menu =ms.id_menu AND ms.id_shop='1')            
LEFT JOIN pr_ets_mm_menu_lang ml
ON m.id_menu=ml.id_menu AND ml.id_lang=2
WHERE 1  AND m.enabled=1 
GROUP BY m.id_menu
ORDER BY m.sort_order asc,ml.title asc
0.5 112 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2315
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=8 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=3 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=8 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `pr_attribute` a
LEFT JOIN `pr_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pr_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
LEFT JOIN `pr_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `pr_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN pr_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1)
INNER JOIN pr_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 3463
0.5 2 /classes/Product.php:6285
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=2 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=908 AND c.id_category!=908
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.5 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=7 
ORDER BY b.sort_order asc,bl.title asc
0.5 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=9 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=9 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=3 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=6 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `pr_meta` m
LEFT JOIN `pr_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.4 36 Yes /classes/Dispatcher.php:640
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_tab t
LEFT JOIN pr_ets_mm_tab_lang tl on (t.id_tab=tl.id_tab AND tl.id_lang=2)
WHERE 1  AND id_menu=2
ORDER BY sort_order asc
0.4 200 Yes /modules/ets_megamenu/ets_megamenu.php:2349
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=7 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=6 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 3461
ORDER BY `position`
0.4 2 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=10 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
0.4 77 /classes/module/Module.php:307
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM pr_shop_url su
LEFT JOIN pr_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.illuminazioneshop.com' OR su.domain_ssl = 'www.illuminazioneshop.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.4 1 Yes /classes/shop/Shop.php:345
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=2 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(881,907,926,927,928,934,935,13)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 8 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `pr_category` c
LEFT JOIN `pr_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 1 )
INNER JOIN pr_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1)
WHERE `id_lang` = 2
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.4 27 Yes Yes /classes/Category.php:1135
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(909,910,911,954)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 4 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 3461 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 4 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=909 AND c.id_category!=909
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_tab t
LEFT JOIN pr_ets_mm_tab_lang tl on (t.id_tab=tl.id_tab AND tl.id_lang=2)
WHERE 1  AND id_menu=3
ORDER BY sort_order asc
0.4 200 Yes /modules/ets_megamenu/ets_megamenu.php:2349
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_tab t
LEFT JOIN pr_ets_mm_tab_lang tl on (t.id_tab=tl.id_tab AND tl.id_lang=2)
WHERE 1  AND id_menu=4
ORDER BY sort_order asc
0.4 200 Yes /modules/ets_megamenu/ets_megamenu.php:2349
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 pr_shop_group gs
LEFT JOIN pr_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN pr_shop_url su
ON s.id_shop = su.id_shop AND su.main = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
0.4 1 Yes /classes/shop/Shop.php:705
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `pr_lang` l
JOIN pr_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 1)
WHERE l.`active` = 1 LIMIT 1
0.4 4 /classes/Language.php:1058
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `pr_currency` c
LEFT JOIN pr_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
0.4 2 /classes/Currency.php:858
SELECT SQL_NO_CACHE *
FROM `pr_category` a0
LEFT JOIN `pr_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 12) AND (a0.`nright` > 13) AND (a1.`id_lang` = 2)
ORDER BY a0.`nleft` asc
0.4 7 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM pr_ets_mm_block b
LEFT JOIN pr_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=2
WHERE 1  AND b.id_column=4 
ORDER BY b.sort_order asc,bl.title asc
0.4 338 Yes /modules/ets_megamenu/ets_megamenu.php:2404
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM pr_manufacturer m
INNER JOIN pr_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=1)            
WHERE active=1  AND m.id_manufacturer IN(3,14,35,7,16,52,53,39,55,24,25,31,10,6,47,17,13,4,34,38)
ORDER BY name ASC,m.id_manufacturer ASC
0.4 49 Yes /modules/ets_megamenu/ets_megamenu.php:2426
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `pr_pscheckout_funding_source`
WHERE `id_shop` = 1
0.4 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 10, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `pr_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 10) AND
`id_group` IN (0, 1) AND `id_product` = 3463 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2021-04-21 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
0.4 4 Yes /classes/SpecificPrice.php:557
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(880,891,923,15)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 4 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3463
ORDER BY f.position ASC
0.4 16 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(902,903,904,905,906,887)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 6 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE * FROM `pr_currency` c ORDER BY `iso_code` ASC
0.4 2 Yes /classes/Currency.php:507
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=881 AND c.id_category!=881
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_product` a
LEFT JOIN `pr_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pr_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3463) AND (b.`id_shop` = 1) LIMIT 1
0.4 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `pr_module` m
LEFT JOIN `pr_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
0.4 1 /src/Adapter/Module/ModuleDataProvider.php:174
SELECT SQL_NO_CACHE domain, domain_ssl
FROM pr_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
0.4 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position
FROM pr_feature_product pf
LEFT JOIN pr_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 2)
LEFT JOIN pr_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 2)
LEFT JOIN pr_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 2)
INNER JOIN pr_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 3461
ORDER BY f.position ASC
0.4 15 Yes /classes/Product.php:5020
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=880 AND c.id_category!=880
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.4 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `pr_pscheckout_funding_source`
WHERE `id_shop` = 1
0.3 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 907) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(20,879,914,922)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 4 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_categorytree" LIMIT 1
0.3 1 /src/Adapter/Module/ModuleDataProvider.php:198
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 `pr_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3461 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_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` = 3461 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:1238
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 `pr_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3463 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_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` = 3463 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:1238
SELECT SQL_NO_CACHE COUNT(*)
FROM `pr_product_attribute` pa
INNER JOIN pr_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` = 3461 LIMIT 1
0.3 2 /classes/Product.php:2546
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 935) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pr_country`
WHERE `id_country` = 10 LIMIT 1
0.3 1 /classes/Country.php:401
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `pr_lang` l
LEFT JOIN `pr_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.3 2 /classes/Language.php:911
SELECT SQL_NO_CACHE *
FROM `pr_product` a
LEFT JOIN `pr_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 2
LEFT JOIN `pr_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 3461) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=886 AND c.id_category!=886
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE id_lang FROM pr_lang WHERE is_rtl=0 AND active=1 LIMIT 1
0.3 2 /modules/ets_megamenu/ets_megamenu.php:3443
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_tab t
LEFT JOIN pr_ets_mm_tab_lang tl on (t.id_tab=tl.id_tab AND tl.id_lang=2)
WHERE 1  AND id_menu=5
ORDER BY sort_order asc
0.3 200 Yes /modules/ets_megamenu/ets_megamenu.php:2349
SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `iso_code` = 'en' LIMIT 1
0.3 2 /classes/Language.php:722
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=907 AND c.id_category!=907
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 19) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM pr_manufacturer m
INNER JOIN pr_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=1)            
WHERE active=1 
ORDER BY name asc
0.3 49 Yes /modules/ets_megamenu/ets_megamenu.php:2426
SELECT SQL_NO_CACHE tr.*
FROM `pr_tax_rule` tr
JOIN `pr_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 53
AND tr.`id_state` IN (0, 232)
AND ('01030' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '01030')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.3 2 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=917 AND c.id_category!=917
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_tab t
LEFT JOIN pr_ets_mm_tab_lang tl on (t.id_tab=tl.id_tab AND tl.id_lang=2)
WHERE 1  AND id_menu=7
ORDER BY sort_order asc
0.3 200 Yes /modules/ets_megamenu/ets_megamenu.php:2349
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product_attribute`) FROM `pr_specific_price` WHERE `id_product_attribute` != 0 LIMIT 1
0.3 1 /classes/SpecificPrice.php:283
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM pr_supplier s
INNER JOIN pr_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=1)            
WHERE active=1 
ORDER BY name asc
0.3 48 Yes /modules/ets_megamenu/ets_megamenu.php:2436
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 902) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=927 AND c.id_category!=927
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=915 AND c.id_category!=915
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 880) AND (b.`id_shop` = 1) LIMIT 1
0.3 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 `pr_cart_product` cp
WHERE cp.`id_product_attribute` = 8535
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3461 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 8535
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3461 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:1238
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=935 AND c.id_category!=935
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_currency` a
LEFT JOIN `pr_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `pr_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 18) AND (b.`id_shop` = 1) LIMIT 1
0.3 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 `pr_cart_product` cp
WHERE cp.`id_product_attribute` = 8540
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 3463 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `pr_cart_product` cp JOIN `pr_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `pr_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 8540
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 3463 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:1238
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 919) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 928) AND (b.`id_shop` = 1) LIMIT 1
0.3 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM pr_cms c
INNER JOIN pr_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=1)
LEFT JOIN pr_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.3 10 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2447
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_tab=2
ORDER BY sort_order asc
0.3 10 Yes /modules/ets_megamenu/ets_megamenu.php:2376
SELECT SQL_NO_CACHE `id_lang` FROM `pr_lang` WHERE `locale` = 'it-it' LIMIT 1
0.3 2 /classes/Language.php:744
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=15 AND c.id_category!=15
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
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 `pr_attribute` a
LEFT JOIN `pr_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pr_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pr_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pr_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 `pr_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 3461
AND pac.`id_product_attribute` = 8535
AND agl.`id_lang` = 2
0.3 1 /classes/Product.php:6258
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(919)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(915)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.3 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3461
0.3 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM pr_supplier s
INNER JOIN pr_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=1)            
WHERE active=1 
ORDER BY name asc
0.2 48 Yes /modules/ets_megamenu/ets_megamenu.php:2436
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=904 AND c.id_category!=904
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_group` a
LEFT JOIN `pr_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 c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM pr_cms c
INNER JOIN pr_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=1)
LEFT JOIN pr_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=2
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.2 10 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2447
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM pr_tag t
LEFT JOIN pr_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=3463
0.2 1 /classes/Tag.php:229
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=19 AND c.id_category!=19
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE `id_guest`
FROM `pr_connections`
WHERE `id_guest` = 5763532
AND `date_add` > '2021-04-21 08:46:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
0.2 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=934 AND c.id_category!=934
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
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 `pr_product` p
INNER JOIN `pr_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pr_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` = 3463)
0.2 2 /classes/Product.php:3364
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 `pr_attribute` a
LEFT JOIN `pr_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 2)
LEFT JOIN `pr_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `pr_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
INNER JOIN pr_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 `pr_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 2)
WHERE pa.`id_product` = 3463
AND pac.`id_product_attribute` = 8540
AND agl.`id_lang` = 2
0.2 1 /classes/Product.php:6258
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 884) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `pr_category` c
LEFT JOIN `pr_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 2)
WHERE `level_depth` = 1
0.2 1 /classes/Category.php:2167
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(917)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE * FROM `pr_hook_alias`
0.2 83 /classes/Hook.php:264
SELECT SQL_NO_CACHE tr.*
FROM `pr_tax_rule` tr
JOIN `pr_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 10
AND tr.`id_tax_rules_group` = 53
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 1 Yes /classes/tax/TaxRulesTaxManager.php:108
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(918)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE id_tab, class_name FROM `pr_tab`
0.2 147 /classes/Tab.php:320
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=923 AND c.id_category!=923
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=888 AND c.id_category!=888
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=919 AND c.id_category!=919
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 923) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3461
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=13 AND c.id_category!=13
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=918 AND c.id_category!=918
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=902 AND c.id_category!=902
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3463
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 886) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 915) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3463
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pr_product_attribute_image` pai
LEFT JOIN `pr_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pr_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (8535, 8537) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 2 Yes /classes/Product.php:2492
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=922 AND c.id_category!=922
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `pr_image` i
INNER JOIN pr_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1)
LEFT JOIN `pr_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 2)
WHERE i.`id_product` = 3463
ORDER BY `position`
0.2 2 Yes /classes/Product.php:3059
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=905 AND c.id_category!=905
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3463
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=911 AND c.id_category!=911
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=910 AND c.id_category!=910
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=879 AND c.id_category!=879
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=20 AND c.id_category!=20
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
DELETE FROM `pr_feedaty_cache` WHERE expiration < 1618989396
0.2 1 /modules/feedaty/lib/FeedatyWebservice.php:463
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(888)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category=cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_category IN(19)
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes /modules/ets_megamenu/ets_megamenu.php:3407
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=928 AND c.id_category!=928
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=906 AND c.id_category!=906
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE `id_country`
FROM `pr_country`
WHERE `iso_code` = 'CH' LIMIT 1
0.2 1 /classes/Country.php:193
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 905) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 13) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_product_lang`
WHERE `id_product` = 3463 AND `id_shop` = 1
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE `id_country`
FROM `pr_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:193
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=887 AND c.id_category!=887
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE 1 FROM `pr_specific_price` WHERE id_product = 0 LIMIT 1
0.2 1 /classes/SpecificPrice.php:407
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 20) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 914) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE psgdpr.active FROM `pr_psgdpr_consent` psgdpr
WHERE psgdpr.id_module = 16 LIMIT 1
0.2 1 /modules/psgdpr/classes/GDPRConsent.php:132
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 892) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_country` a
LEFT JOIN `pr_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 2
LEFT JOIN `pr_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 10) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=954 AND c.id_category!=954
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=891 AND c.id_category!=891
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=914 AND c.id_category!=914
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE c.*, cl.name,cl.link_rewrite
FROM pr_category c
INNER JOIN pr_category_shop cs ON (c.id_category =cs.id_category AND cs.id_shop=1)
LEFT JOIN pr_category_lang cl ON c.id_category=cl.id_category AND cl.id_lang=2
WHERE c.active=1 AND  c.id_parent=903 AND c.id_category!=903
GROUP BY c.id_category ORDER BY cl.name ASC,c.id_category ASC
0.2 2 Yes Yes /modules/ets_megamenu/ets_megamenu.php:3418
SELECT SQL_NO_CACHE p.id_product
FROM `pr_product` p
INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 3463
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-04-21 00:00:00",
INTERVAL 60 DAY
)
) > 0
0.2 0 /classes/Product.php:1403
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 `pr_product` p
INNER JOIN `pr_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `pr_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` = 3461)
0.2 2 /classes/Product.php:3364
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_tab=9
ORDER BY sort_order asc
0.2 10 Yes /modules/ets_megamenu/ets_megamenu.php:2376
SELECT SQL_NO_CACHE *
FROM `pr_state` a
WHERE (a.`id_state` = 232) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `iso_code`
FROM `pr_country`
WHERE `id_country` = 10 LIMIT 1
0.2 1 /classes/Country.php:274
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_tab=3
ORDER BY sort_order asc
0.2 10 Yes /modules/ets_megamenu/ets_megamenu.php:2376
SELECT SQL_NO_CACHE `need_identification_number`
FROM `pr_country`
WHERE `id_country` = 10 LIMIT 1
0.2 1 /classes/Country.php:401
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
0.2 1 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 927) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_manufacturer` a
LEFT JOIN `pr_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = 2
LEFT JOIN `pr_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = 1
WHERE (a.`id_manufacturer` = 17) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 906) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 15) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 909) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE 1 FROM pr_cart_product cp INNER JOIN pr_product p
ON (p.id_product = cp.id_product) INNER JOIN pr_product_shop ps
ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=0 LIMIT 1
0.2 1 /classes/Cart.php:4055
SELECT SQL_NO_CACHE *
FROM `pr_currency` a
LEFT JOIN `pr_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE data
FROM `pr_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 `name`, `active`, `position`
FROM `pr_pscheckout_funding_source`
WHERE `id_shop` = 1
0.2 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 888) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.id_currency
FROM `pr_currency` c
WHERE (deleted = 0) AND (iso_code = 'USD') LIMIT 1
0.2 1 /classes/Currency.php:677
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 922) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pr_product_attribute_image` pai
LEFT JOIN `pr_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pr_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (8540, 8541) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 2 Yes /classes/Product.php:2492
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 918) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `pr_product_attribute_image` pai
LEFT JOIN `pr_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `pr_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (8540, 8541) AND il.`id_lang` = 2 ORDER by i.`position`
0.2 2 Yes /classes/Product.php:2492
SELECT SQL_NO_CACHE *
FROM `pr_product_attribute` a
LEFT JOIN `pr_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 8540) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 908) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_country`
FROM `pr_country`
WHERE `iso_code` = 'US' AND active = 1 LIMIT 1
0.2 1 /classes/Country.php:193
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 881) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 917) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM `pr_hook_alias`
0.2 83 /classes/Hook.php:238
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `pr_product_attribute`
WHERE `id_product` = 3461
0.2 2 /classes/Product.php:2473
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3461
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE p.id_product
FROM `pr_product` p
INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
WHERE p.id_product = 3463
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2021-04-21 00:00:00",
INTERVAL 60 DAY
)
) > 0
0.2 0 /classes/Product.php:1403
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pr_product_attribute pa
INNER JOIN pr_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 = 3463 LIMIT 1
0.2 2 /classes/Product.php:847
SELECT SQL_NO_CACHE t.`id_lang`, t.`name`
FROM pr_tag t
LEFT JOIN pr_product_tag pt ON (pt.id_tag = t.id_tag)
WHERE pt.`id_product`=3463
0.2 1 /classes/Tag.php:229
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 903) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_currency` a
LEFT JOIN `pr_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 2
LEFT JOIN `pr_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 `priority`, `id_specific_price_priority`
FROM `pr_specific_price_priority`
WHERE `id_product` = 3463
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 0 /classes/SpecificPrice.php:246
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_tab=5
ORDER BY sort_order asc
0.2 10 Yes /modules/ets_megamenu/ets_megamenu.php:2376
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 934) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pr_category_product` cp
INNER JOIN `pr_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 3461 AND ctg.`id_group` = 1 LIMIT 1
0.2 4 /classes/Product.php:5576
SELECT SQL_NO_CACHE id_shop
FROM `pr_category_shop`
WHERE `id_category` = 917
AND id_shop = 1 LIMIT 1
0.2 1 /classes/ObjectModel.php:1610
SELECT SQL_NO_CACHE * FROM `pr_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.2 7 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE *
FROM pr_ets_mm_column
WHERE 1  AND id_menu=3
ORDER BY sort_order asc
0.2 10 Yes /modules/ets_megamenu/ets_megamenu.php:2389
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM pr_shop s
LEFT JOIN pr_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.2 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 879) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `pr_category_product` cp
INNER JOIN `pr_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 3463 AND ctg.`id_group` = 1 LIMIT 1
0.2 3 /classes/Product.php:5576
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 891) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_tax_lang`
WHERE `id_tax` = 53
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 904) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE `id_page`
FROM `pr_page`
WHERE `id_page_type` = 4 AND `id_object` = 3463 LIMIT 1
0.2 1 /classes/Page.php:83
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 887) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`available_date` FROM `pr_product` p LEFT JOIN `pr_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN pr_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` = 3463 AND pa.`id_product` = 3463 AND pa.`id_product_attribute` = 8540 LIMIT 1
0.2 1 /classes/Product.php:940
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.2 1 /classes/ImageType.php:131
DELETE FROM `pr_feedaty_cache` WHERE expiration < 1618989397
0.2 1 /modules/feedaty/lib/FeedatyWebservice.php:463
SELECT SQL_NO_CACHE name FROM pr_category_lang WHERE id_shop = 1 AND id_lang = 2 AND id_category = 19 LIMIT 1
0.2 1 /classes/Product.php:4762
SELECT SQL_NO_CACHE *
FROM `pr_product_attribute` a
LEFT JOIN `pr_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 8535) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 910) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
DELETE FROM `pr_feedaty_cache` WHERE expiration < 1618989397
0.2 1 /modules/feedaty/lib/FeedatyWebservice.php:463
SELECT SQL_NO_CACHE `name`
FROM `pr_manufacturer`
WHERE `id_manufacturer` = 17
AND `active` = 1 LIMIT 1
0.2 1 /classes/Manufacturer.php:312
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `pr_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
0.2 2 Yes /classes/Language.php:849
SELECT SQL_NO_CACHE *
FROM `pr_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `pr_group_lang`
WHERE `id_group` = 1
0.2 2 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE format
FROM `pr_address_format`
WHERE `id_country` = 10 LIMIT 1
0.2 1 /classes/AddressFormat.php:629
SELECT SQL_NO_CACHE * FROM pr_product WHERE id_product = 3461
0.2 1 /src/Adapter/Database.php:48
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pr_stock_available`
WHERE (id_product = 3461) AND (id_product_attribute = 8537) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 911) AND (b.`id_shop` = 1) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.id_currency
FROM `pr_currency` c
WHERE (deleted = 0) AND (iso_code = 'EUR') LIMIT 1
0.2 1 /classes/Currency.php:677
SELECT SQL_NO_CACHE `name`, `active`, `position`
FROM `pr_pscheckout_funding_source`
WHERE `id_shop` = 1
0.2 1 /modules/ps_checkout/src/FundingSource/FundingSourceConfigurationRepository.php:85
SELECT SQL_NO_CACHE SUM(quantity)
FROM `pr_stock_available`
WHERE (id_product = 3463) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
0.2 1 /classes/stock/StockAvailable.php:444
SELECT SQL_NO_CACHE `id_image_type`
FROM `pr_image_type`
WHERE `name` = 'home'
0.1 1 /classes/ImageType.php:131
SELECT SQL_NO_CACHE * FROM `pr_feedaty_cache` WHERE id_key = "FeedatyData10214290" LIMIT 1
0.1 1 /modules/feedaty/lib/FeedatyWebservice.php:487
SELECT SQL_NO_CACHE `id_module` FROM `pr_module` WHERE `name` = "braintreeofficial" LIMIT 1
0.1 0 /classes/module/Module.php:2786
SELECT SQL_NO_CACHE product_attribute_shop.id_product_attribute
FROM pr_product_attribute pa
INNER JOIN pr_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 = 3461 LIMIT 1
0.1 2 /classes/Product.php:847
SELECT SQL_NO_CACHE id_page_type
FROM pr_page_type
WHERE name = 'product' LIMIT 1
0.1 1 /classes/Page.php:104
SELECT SQL_NO_CACHE * FROM `pr_feedaty_cache` WHERE id_key = "FeedatyData10214290" LIMIT 1
0.1 1 /modules/feedaty/lib/FeedatyWebservice.php:487
SELECT SQL_NO_CACHE *
FROM `pr_category` a
LEFT JOIN `pr_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 2
LEFT JOIN `pr_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 954) AND (b.`id_shop` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pa.`available_date` FROM `pr_product` p LEFT JOIN `pr_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN pr_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) INNER JOIN pr_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` = 3461 AND pa.`id_product` = 3461 AND pa.`id_product_attribute` = 8535 LIMIT 1
0.1 1 /classes/Product.php:940
DELETE FROM `pr_feedaty_cache` WHERE expiration < 1618989397
0.1 1 /modules/feedaty/lib/FeedatyWebservice.php:463
SELECT SQL_NO_CACHE * FROM `pr_feedaty_cache` WHERE id_key = "FeedatyData10214290" LIMIT 1
0.1 1 /modules/feedaty/lib/FeedatyWebservice.php:487