Wall moulding Z390

22,50 € /m

€45.00 /pc
Measure244 x 18 x 4,5 cm
2.00 m (45.00 €)pc

Estimated delivery 19-07-2024 - 22-07-2024

Hard to decide? Order a sample!

Order Sample — Up to four samples are free, you only pay shipping of €15. Discount will be deducted at checkout.
  • Simple installation
  • Water resistant
  • Termite resistant
  • Paint ready

Wall moulding Z390 is made of polyurethane; it has a thick, smooth, and white paintable surface. The wall moulding is easily mounted with glue and we recommend that you use water-based paints.

Wall moulding Z390

Today’s materials brought forth great creativity and potentials to recreate, repair, and redesign architectural buildings, aesthetic places and interiors: new as well as old! Originally, stuccos were made by carving out patterns in wood, but several hundred years later, industries developed stuccos in plaster instead. Today it has become way easier! In the early 1960s, new materials developed, and they almost became the only ones used today, namely polyurethane and polystyrene (styrofoam).

The wall mouldings are made of a shock- and water-resistant material with a smooth and paintable surface that accentuates the finest details and curves of the mouldings. The material is sandable and easy to process with standard hand tools. It can withstand moisture and most solvents, which makes cleaning an easy and safe process.

Regardless of which model you choose, mounting the mouldings is quite simple! Use standard hand tools for sawing, grinding and machining before assembly. Use glue to set up the mouldings, and if you happen to use superfluous glue, make sure you wipe off immediately with water or mild soap solution.

Z390 6
Material
Polyurethane / Profoam
Length (cm)
200
Height (cm)
18
Thickness (cm)
4.5

Download

Load Time519 ms - Unicorn powered webserver!
Querying Time192 ms
Queries973
Memory Peak Usage41.4 Mb
Included Files1370 files - 14.92 Mb
PrestaShop Cache- Mb
Global vars0.90 Mb
PrestaShop Version1.7.7.4
PHP Version7.3.33 (OK)
MySQL Version10.8.3-MariaDB (OK)
Memory Limit512M
Max Execution Time60s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 87 ms 87 ms 14.35 Mb 14.42 Mb
__construct 0 ms 87 ms - Mb 14.42 Mb
init 35 ms 121 ms 6.26 Mb 20.79 Mb
checkAccess 0 ms 121 ms - Mb 20.79 Mb
setMedia 4 ms 125 ms 0.53 Mb 21.22 Mb
postProcess 0 ms 125 ms - Mb 21.22 Mb
initHeader 0 ms 125 ms - Mb 21.22 Mb
initContent 117 ms 242 ms 9.58 Mb 30.80 Mb
initFooter 0 ms 242 ms - Mb 30.80 Mb
display 277 ms 519 ms 10.17 Mb 41.45 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 973 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `psdc_configuration` c
LEFT JOIN `psdc_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
8.6 13407 /classes/Configuration.php:160
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `psdc_module` m
INNER JOIN psdc_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 5 AND module_shop.enable_device & 1)
INNER JOIN `psdc_module_shop` `ms` ON ms.`id_module` = m.`id_module`
INNER JOIN `psdc_hook_module` `hm` ON hm.`id_module` = m.`id_module`
INNER JOIN `psdc_hook` `h` ON hm.`id_hook` = h.`id_hook`
LEFT JOIN `psdc_module_group` `mg` ON mg.`id_module` = m.`id_module`
WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 5) AND (mg.id_shop = 5 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
4.3 13408 Yes Yes /classes/Hook.php:1161
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM psdc_cms c
INNER JOIN psdc_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=5)
LEFT JOIN psdc_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=7
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
3.2 629 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2553
SELECT SQL_NO_CACHE p.*, pl.params, pl.id_lang
FROM psdc_appagebuilder p
LEFT JOIN psdc_appagebuilder_shop ps ON (ps.id_appagebuilder = p.id_appagebuilder AND id_shop=5)
LEFT JOIN psdc_appagebuilder_lang pl ON (pl.id_appagebuilder = p.id_appagebuilder)
WHERE
pl.id_lang=7
AND ps.id_shop=5
AND p.id_appagebuilder_positions IN (97,98,99,100)
ORDER BY p.id_appagebuilder
3.2 416 /modules/appagebuilder/classes/ApPageBuilderModel.php:302
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.7 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE p.`id_product`
FROM `psdc_product` p
INNER JOIN `psdc_product_lang` pl ON (pl.`id_product` = p.`id_product`)
INNER JOIN `psdc_category_lang` cl ON (cl.`link_rewrite` = 'wall-mouldings')
WHERE pl.`link_rewrite` = 'wall-moulding-z390'
AND pl.`id_lang` = 7
AND cl.`link_rewrite` = 'wall-mouldings'
AND p.`id_category_default` = cl.`id_category` AND pl.`id_shop` = 5 LIMIT 1
2.6 34833 /override/classes/Dispatcher.php:321
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.6 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.5 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE * FROM `psdc_mqc` WHERE id_product = 504 AND `group` = 1 LIMIT 1
2.4 20562 /modules/mqc/mqc.php:329
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.4 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND free_shipping = 1 AND carrier_restriction = 1)
2.3 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE DISTINCT apg.`id_accessory_group`,

apg.`id_accessory`,

apg.`default_quantity`,

apg.`min_quantity`,

apg.`required`,

apg.`position`,

pl.`link_rewrite`,

pl.`description_short`,

pl.`available_later`,

p.`id_product` AS `id_product`,

p.`is_virtual`,

stock.`quantity` AS `stock_available`,

stock.`out_of_stock`,

apg.`id_accessory_group_product`,		

apg.`id_product_attribute`,

i.`id_image`,

IF(`is`.`id_image`, `is`.`id_image`, i.`id_image`) `id_image`                    

FROM

`psdc_accessory_group_product` apg INNER JOIN `psdc_product` p ON (p.`id_product` = apg.`id_accessory` AND p.active =1)LEFT JOIN

`psdc_product_lang` pl ON (pl.`id_product` = apg.`id_accessory` AND pl.`id_shop` = 5 AND pl.`id_lang` = 7)

LEFT JOIN

`psdc_accessory_group_product_lang` agpl ON (agpl.`id_accessory_group_product` = apg.`id_accessory_group_product`  AND agpl.`id_lang` = 7)

LEFT JOIN

`psdc_image` i ON (i.`id_product` = apg.`id_accessory` AND `i`.`cover` = 1)

LEFT JOIN

`psdc_image_shop` `is` ON ( `is`.`id_image` = i.`id_image` AND `is`.id_shop = 5 AND `is`.`cover` = 1)

LEFT JOIN

`psdc_image_lang` il ON (il.`id_image` = i.`id_image`  AND il.`id_lang` = 7)

LEFT JOIN psdc_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )

INNER JOIN psdc_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 5)    

WHERE

apg.`id_accessory_group` IN (1) AND apg.`id_product` IN(504) AND p.`id_product` NOT IN (504) AND p.`visibility` != 'none'

GROUP BY

apg.`id_accessory_group`,

apg.`id_accessory`

ORDER BY apg.`position` ASC
1.9 710 Yes Yes /modules/hsmultiaccessoriespro/abstract/classes/HsAccessoriesGroupAbstract.php:641
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 `psdc_hook_module` hm
STRAIGHT_JOIN `psdc_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 5)
STRAIGHT_JOIN `psdc_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
1.5 682 /classes/Hook.php:487
SELECT SQL_NO_CACHE p.`id_product`
FROM `psdc_product` p
INNER JOIN `psdc_product_lang` pl ON (pl.`id_product` = p.`id_product`)
INNER JOIN `psdc_category_lang` cl ON (cl.`link_rewrite` = 'wall-mouldings')
WHERE pl.`link_rewrite` = 'wall-moulding-z390'
AND pl.`id_lang` = 7
AND cl.`link_rewrite` = 'wall-mouldings'
AND p.`id_category_default` = cl.`id_category` AND pl.`id_shop` = 5 LIMIT 1
1.2 34833 /override/classes/Dispatcher.php:321
SELECT SQL_NO_CACHE cl.*,c.*, cl.`name` country, z.`name` zone
FROM `psdc_country` c  INNER JOIN psdc_country_shop country_shop
ON (country_shop.id_country = c.id_country AND country_shop.id_shop = 5)
LEFT JOIN `psdc_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 7)
LEFT JOIN `psdc_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
1 240 Yes /classes/Country.php:147
SELECT SQL_NO_CACHE `id_hook`, `name`
FROM `psdc_hook`
UNION
SELECT `id_hook`, ha.`alias` as name
FROM `psdc_hook_alias` ha
INNER JOIN `psdc_hook` h ON ha.name = h.name
0.9 0 /classes/Hook.php:1221
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2024-07-15 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `psdc_accessory`
LEFT JOIN `psdc_product` p ON p.`id_product` = `id_product_2`
INNER JOIN psdc_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 5)
LEFT JOIN `psdc_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=5)
LEFT JOIN `psdc_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 7 AND pl.id_shop = 5 
)
LEFT JOIN `psdc_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 7 AND cl.id_shop = 5 
)
LEFT JOIN `psdc_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=5)
LEFT JOIN `psdc_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 7)
LEFT JOIN `psdc_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`)
LEFT JOIN psdc_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
WHERE `id_product_1` = 504 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
0.8 1 Yes /classes/Product.php:4142
SELECT SQL_NO_CACHE name, value, pf.id_feature, f.position, f.hide_on_front
FROM psdc_feature_product pf
LEFT JOIN psdc_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 7)
LEFT JOIN psdc_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7)
LEFT JOIN psdc_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 7)
INNER JOIN psdc_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 5)
WHERE pf.id_product = 504
ORDER BY f.position ASC
0.7 30 Yes /override/classes/Product.php:142
INSERT INTO `psdc_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('14010186', '1062', '2890263453', '', '5', '1', '2024-07-15 13:18:16')
0.6 1 /classes/ObjectModel.php:577
SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang
FROM `psdc_meta` m
LEFT JOIN `psdc_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 5 )
ORDER BY LENGTH(ml.url_rewrite) DESC
0.6 168 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM psdc_cms c
INNER JOIN psdc_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=5)
LEFT JOIN psdc_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=7
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.5 629 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2553
SELECT SQL_NO_CACHE pa.`id_product_attribute`,

pa.`id_product`,

stock.`quantity` AS `stock_available`,

stock.`out_of_stock`,

GROUP_CONCAT( DISTINCT CONCAT(ag.`id_attribute_group`, ":" , a.`id_attribute`) SEPARATOR "-") AS `id_attributes`, GROUP_CONCAT( DISTINCT CONCAT( al.`name`) ORDER BY agl.`public_name`, al.`name` SEPARATOR " - ") AS `name` 

FROM `psdc_product_attribute` pa

INNER JOIN psdc_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 5)

LEFT JOIN

`psdc_product_attribute_shop` pas

ON

pas.`id_product_attribute` = pa.`id_product_attribute`

AND pas.`id_shop` = 5

LEFT JOIN

`psdc_product_attribute_combination` pac

ON

pac.`id_product_attribute` = pa.`id_product_attribute`

LEFT JOIN

`psdc_attribute` a

ON

a.`id_attribute` = pac.`id_attribute`

LEFT JOIN

`psdc_attribute_group` ag

ON

ag.`id_attribute_group` = a.`id_attribute_group`

LEFT JOIN

`psdc_attribute_lang` al

ON

a.`id_attribute` = al.`id_attribute`

AND al.`id_lang` = 7

LEFT JOIN

`psdc_attribute_group_lang` agl

ON

ag.`id_attribute_group` = agl.`id_attribute_group`

AND agl.`id_lang` = 7

INNER JOIN psdc_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )

WHERE

pa.`id_product` IN (1350)

AND stock.`id_product_attribute` = pa.`id_product_attribute`

GROUP BY

pa.`id_product`, pa.`id_product_attribute`

ORDER BY  `name` ASC
0.5 0 /modules/hsmultiaccessoriespro/abstract/classes/HsMaProduct.php:258
SELECT SQL_NO_CACHE c.id_cms as value,CONCAT('mm_cms_',c.id_cms) as id, cl.meta_title as label            
FROM psdc_cms c
INNER JOIN psdc_cms_shop cs ON (c.id_cms= cs.id_cms AND cs.id_shop=5)
LEFT JOIN psdc_cms_lang cl ON c.id_cms=cl.id_cms AND cl.id_lang=7
WHERE c.active=1 
GROUP BY c.id_cms ORDER BY cl.meta_title asc
0.5 629 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2553
INSERT INTO `psdc_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')
0.5 1 /classes/ObjectModel.php:577
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=132 
ORDER BY b.sort_order asc,bl.title asc
0.4 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE * FROM `psdc_product_feature_value_pos` WHERE `id_product` = 504 ORDER BY `position` DESC
0.4 10 Yes /override/modules/multifeatures/multifeatures.php:181
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `psdc_specific_price_priority`
WHERE `id_product` = 1350
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.4 1 /classes/SpecificPrice.php:249
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 `psdc_category` c
INNER JOIN psdc_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
LEFT JOIN `psdc_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 7  AND cl.id_shop = 5 )
LEFT JOIN `psdc_category_group` cg ON (cg.`id_category` = c.`id_category`)
WHERE `id_parent` = 6
AND `active` = 1
AND cg.`id_group` =1
GROUP BY c.`id_category`
ORDER BY `level_depth` ASC, category_shop.`position` ASC
0.4 1 Yes Yes /classes/Category.php:918
SELECT SQL_NO_CACHE * FROM `psdc_state` ORDER BY `name` ASC
0.4 357 Yes /classes/Country.php:154
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=116 
ORDER BY b.sort_order asc,bl.title asc
0.4 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE * FROM psdc_product_videos WHERE id_product = 504 AND id_shop = 5 ORDER BY position ASC
0.4 1 Yes /modules/productvideo/productvideo.php:2026
SELECT SQL_NO_CACHE id_trustedshops_channel
FROM `psdc_trustedshops_channel`
WHERE (id_client = '61d3cd0b1e6b__PrestaShop') AND (id_lang = 7) AND (id_shop = 5) LIMIT 1
0.4 2 /modules/trustedshopseasyintegration/src/Repository/ChannelRepository.php:95
SELECT SQL_NO_CACHE * FROM `psdc_product_feature_pos` WHERE `id_product` = 504 ORDER BY `position` DESC
0.4 9 Yes /override/modules/multifeatures/multifeatures.php:177
SELECT SQL_NO_CACHE `id_product`,
pf.`id_feature`,
`name`,
pf.`id_feature_value`,
`value`,
f.`hide_on_front`
FROM
`psdc_feature_product` pf
LEFT JOIN
`psdc_feature_lang` fl
ON (
fl.id_feature = pf.id_feature AND fl.id_lang = 7
)
LEFT JOIN
`psdc_feature_value_lang` fvl
ON (
fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 7
)
LEFT JOIN `psdc_feature` f
ON (
f.id_feature = pf.id_feature
)
WHERE
`id_product` = 504
ORDER BY f.position ASC
0.4 510 Yes /override/modules/multifeatures/multifeatures.php:112
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.3 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE * FROM `psdc_accessory_group_product_lang` WHERE `id_accessory_group_product` =555
0.3 7 /modules/hsmultiaccessoriespro/abstract/classes/HsAccessoriesGroupProductAbstract.php:179
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `psdc_hook`
0.3 787 /classes/Hook.php:1221
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=117 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.3 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=120 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=118 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE *
FROM `psdc_product_supplier` a0
WHERE (a0.`id_product` = 504)
GROUP BY a0.`id_supplier`
0.3 1 Yes Yes /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE image_shop.`id_image`
FROM `psdc_image` i
INNER JOIN psdc_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 5)
WHERE i.`id_product` = 504
AND image_shop.`cover` = 1 LIMIT 1
0.3 3 /classes/Product.php:3118
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=124 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=119 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=122 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=129 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=134 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=136 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE * FROM psdc_appagebuilder_products p
INNER JOIN psdc_appagebuilder_products_shop ps on(p.id_appagebuilder_products = ps.id_appagebuilder_products) WHERE  ps.active=1 and ps.id_shop=5 LIMIT 1
0.3 10 /modules/appagebuilder/classes/ApPageBuilderProductsModel.php:147
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=138 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=121 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=126 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=137 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=130 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=123 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=133 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=127 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=135 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=125 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=131 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE b.*,bl.title,bl.title_link,bl.content,bl.image_link
FROM psdc_ets_mm_block b
LEFT JOIN psdc_ets_mm_block_lang bl
ON b.id_block=bl.id_block AND bl.id_lang=7
WHERE 1  AND b.id_column=128 
ORDER BY b.sort_order asc,bl.title asc
0.3 1 Yes /modules/ets_megamenu/ets_megamenu.php:2510
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.3 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE *
FROM `psdc_stockalert_alert` saa
LEFT JOIN `psdc_stockalert_alert_lang` saal ON (saa.id_stockalert_alert = saal.id_stockalert_alert 
AND id_lang = 7)
WHERE
`id_shop` = 5 AND `active` = 1 AND (
(`products` = "" AND `products_excluded` = "")
OR (
(`products` = "" OR FIND_IN_SET("504", `products`))
AND NOT FIND_IN_SET("504", `products_excluded`)
)
) AND (
(`manufacturers` = "" AND `manufacturers_excluded` = "")
OR (
(`manufacturers` = "" OR FIND_IN_SET("9223372036854775807", `manufacturers`))
AND NOT FIND_IN_SET("9223372036854775807", `manufacturers_excluded`)
)
)
AND (
(`suppliers` = "" AND `suppliers_excluded` = "")
OR (
(`suppliers` = "" OR FIND_IN_SET(2, `suppliers`))
AND NOT FIND_IN_SET("2", `suppliers_excluded`)
)) AND (`customers` = ""
OR `customers` IS NULL)
AND (
(`groups` = "" AND `groups_excluded` = "")
OR (
(`groups` = "" OR FIND_IN_SET(1, `groups`))
AND NOT FIND_IN_SET("1", `groups_excluded`)
)) ORDER BY `priority`;
0.3 5 Yes /modules/stockalert/classes/StockAlertAlert.php:265
SELECT SQL_NO_CACHE m.*,ml.title,ml.link,ml.bubble_text
FROM psdc_ets_mm_menu m
INNER JOIN psdc_ets_mm_menu_shop ms ON (m.id_menu =ms.id_menu AND ms.id_shop='5')            
LEFT JOIN psdc_ets_mm_menu_lang ml
ON m.id_menu=ml.id_menu AND ml.id_lang=7
WHERE 1  AND m.enabled=1 
GROUP BY m.id_menu
ORDER BY m.sort_order asc,ml.title asc
0.3 30 Yes Yes /modules/ets_megamenu/ets_megamenu.php:2419
SELECT SQL_NO_CACHE ctg.`id_group`
FROM `psdc_category_product` cp
INNER JOIN `psdc_category_group` ctg ON (ctg.`id_category` = cp.`id_category`)
WHERE cp.`id_product` = 504 AND ctg.`id_group` = 1 LIMIT 1
0.3 2 /classes/Product.php:5758
SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main
FROM psdc_shop_url su
LEFT JOIN psdc_shop s ON (s.id_shop = su.id_shop)
WHERE (su.domain = 'www.d-cor.eu' OR su.domain_ssl = 'www.d-cor.eu')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
0.3 2 Yes /classes/shop/Shop.php:1341
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 `psdc_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 504 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `psdc_cart_product` cp JOIN `psdc_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `psdc_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` = 504 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 1 = 1
))) as q LIMIT 1
0.3 0 /classes/Cart.php:1405
SELECT SQL_NO_CACHE a.`plist_key` FROM `psdc_appagebuilder_details` AS a INNER JOIN `psdc_appagebuilder_details_shop` AS b ON a.`id_appagebuilder_details` = b.`id_appagebuilder_details` WHERE b.`id_shop` = "5" AND b.`active` = 1 LIMIT 1
0.3 35 /modules/appagebuilder/appagebuilder.php:3942
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 psdc_shop_group gs
LEFT JOIN psdc_shop s
ON s.id_shop_group = gs.id_shop_group
LEFT JOIN psdc_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.2 25 Yes /classes/shop/Shop.php:703
(SELECT 1 FROM `psdc_cart_rule` WHERE date_to >= "2024-07-15 00:00:00" AND date_to <= "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `psdc_cart_rule` WHERE date_from >= "2024-07-15 00:00:00" AND date_from <= "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `psdc_cart_rule` WHERE date_from < "2024-07-15 00:00:00" AND date_to > "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.2 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 5, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `psdc_specific_price`
WHERE
`id_shop` IN (0, 5) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.2 1 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `psdc_attribute` a
LEFT JOIN `psdc_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `psdc_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `psdc_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `psdc_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN psdc_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 5)
INNER JOIN psdc_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 5)
WHERE pa.`id_product` = 504
0.2 1 /classes/Product.php:6467
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 5, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `psdc_specific_price`
WHERE
`id_shop` IN (0, 5) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.2 1 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `psdc_attribute` a
LEFT JOIN `psdc_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 7)
LEFT JOIN `psdc_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 7)
LEFT JOIN `psdc_product_attribute_combination` pac
ON (a.`id_attribute` = pac.`id_attribute`)
LEFT JOIN `psdc_product_attribute` pa
ON (pac.`id_product_attribute` = pa.`id_product_attribute`)
INNER JOIN psdc_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 5)
INNER JOIN psdc_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 5)
WHERE pa.`id_product` = 504
0.2 1 /classes/Product.php:6467
SELECT SQL_NO_CACHE `id_accessory_product_setting` FROM `psdc_accessory_product_setting` WHERE `id_product` = 504 LIMIT 1
0.2 3 /modules/hsmultiaccessoriespro/abstract/classes/HsMaProductSettingAbstract.php:120
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `psdc_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayProductAdditionalInfo') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
0.2 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:511
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 8, 4, 0) +  IF (`id_currency` = 4, 8, 0) +  IF (`id_shop` = 5, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `psdc_specific_price`
WHERE
`id_shop` IN (0, 5) AND
`id_currency` IN (0, 4) AND
`id_country` IN (0, 8) AND
`id_group` IN (0, 1) AND `id_product` = 0 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-07-15 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
0.2 1 Yes /classes/SpecificPrice.php:623
SELECT SQL_NO_CACHE *
FROM `psdc_stockalert_subscriber`
WHERE customer_email = ''
AND `id_product` = 504
AND `id_product_attribute` = 0
AND (`date_send` IS NULL OR `date_send` = "1970-01-01 01:00:00")
AND `id_shop` = 5 LIMIT 1
0.2 443 /modules/stockalert/classes/StockAlertSubscriber.php:90
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_stockalert_subscriber`
WHERE customer_email = ''
AND `id_product` = 504
AND `id_product_attribute` = 0
AND (`date_send` IS NULL OR `date_send` = "1970-01-01 01:00:00")
AND `id_shop` = 5 LIMIT 1
0.2 443 /modules/stockalert/classes/StockAlertSubscriber.php:90
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `psdc_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayProductExtraContent') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
0.2 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:511
SELECT SQL_NO_CACHE `id_page`
FROM `psdc_page`
WHERE `id_page_type` = 6 AND `id_object` = 504 LIMIT 1
0.2 1 /classes/Page.php:83
(SELECT 1 FROM `psdc_cart_rule` WHERE date_to >= "2024-07-15 00:00:00" AND date_to <= "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `psdc_cart_rule` WHERE date_from >= "2024-07-15 00:00:00" AND date_from <= "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `psdc_cart_rule` WHERE date_from < "2024-07-15 00:00:00" AND date_to > "2024-07-15 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
0.2 1 /classes/CartRule.php:342
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_input` tcf_i
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_input = tcf_i.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di.code_display = 'smarty') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
0.2 81 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplaySmarty.php:286
SELECT SQL_NO_CACHE pa.`id_product_attribute`,

stock.`quantity` AS `stock_available`,

stock.`out_of_stock`,

GROUP_CONCAT( DISTINCT CONCAT(ag.`id_attribute_group`, ":" , a.`id_attribute`) SEPARATOR "-") AS `id_attributes`, GROUP_CONCAT( DISTINCT CONCAT( al.`name`) ORDER BY agl.`public_name`, al.`name` SEPARATOR " - ") AS `name` 

FROM `psdc_product_attribute` pa

INNER JOIN psdc_product_attribute_shop product_attribute_shop
ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 5)

LEFT JOIN

`psdc_product_attribute_shop` pas

ON

pas.`id_product_attribute` = pa.`id_product_attribute`

AND pas.`id_shop` = 5

LEFT JOIN

`psdc_product_attribute_combination` pac

ON

pac.`id_product_attribute` = pa.`id_product_attribute`

LEFT JOIN

`psdc_attribute` a

ON

a.`id_attribute` = pac.`id_attribute`

LEFT JOIN

`psdc_attribute_group` ag

ON

ag.`id_attribute_group` = a.`id_attribute_group`

LEFT JOIN

`psdc_attribute_lang` al

ON

a.`id_attribute` = al.`id_attribute`

AND al.`id_lang` = 7

LEFT JOIN

`psdc_attribute_group_lang` agl

ON

ag.`id_attribute_group` = agl.`id_attribute_group`

AND agl.`id_lang` = 7

INNER JOIN psdc_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop_group = 1  AND stock.id_shop = 0  )

WHERE

pa.`id_product` = 504

AND stock.`id_product_attribute` = pa.`id_product_attribute`

GROUP BY

pa.`id_product`, pa.`id_product_attribute`

ORDER BY  `name` ASC
0.2 0 /modules/hsmultiaccessoriespro/abstract/classes/HsMaProduct.php:142
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE `priority`, `id_specific_price_priority`
FROM `psdc_specific_price_priority`
WHERE `id_product` = 504
ORDER BY `id_specific_price_priority` DESC LIMIT 1
0.2 1 /classes/SpecificPrice.php:249
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `psdc_module` m
LEFT JOIN `psdc_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 5
0.2 113 /classes/module/Module.php:330
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `psdc_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayFooterProduct') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
0.2 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:511
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_product` a
LEFT JOIN `psdc_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `psdc_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 1350) AND (b.`id_shop` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `psdc_product` a
LEFT JOIN `psdc_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 7
LEFT JOIN `psdc_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 504) AND (b.`id_shop` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `psdc_product` a
LEFT JOIN `psdc_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 5
LEFT JOIN `psdc_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 504) AND (b.`id_shop` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop`
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = 5 )
INNER JOIN psdc_category_shop category_shop
ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 5)
WHERE `id_lang` = 7
AND c.`id_parent` = 2
AND `active` = 1
GROUP BY c.`id_category`
ORDER BY category_shop.`position` ASC
0.2 2 Yes Yes /classes/Category.php:1144
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `psdc_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayAfterProductThumbs') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
0.2 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:511
SELECT SQL_NO_CACHE `id_cart_rule` FROM `psdc_accessory_product_cart_rule` WHERE `id_main_product`=504 AND `id_accessory`=1350 LIMIT 1
0.2 1 /modules/hsmultiaccessoriespro/abstract/classes/HsMaCartRule.php:205
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_category` a0
LEFT JOIN `psdc_category_lang` `a1` ON (a0.`id_category` = a1.`id_category`)
WHERE (a0.`nleft` < 10) AND (a0.`nright` > 11) AND (a1.`id_lang` = 7)
ORDER BY a0.`nleft` asc
0.2 102 /classes/PrestaShopCollection.php:381
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
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.2 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
(SELECT SQL_NO_CACHE * FROM `psdc_cart_rule` cr
LEFT JOIN `psdc_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 7)
WHERE (cr.`id_customer` = 0
OR (cr.`id_customer` = 0 AND (cr.`highlight` = 1 OR cr.`code` = "")))
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.2 1 /classes/CartRule.php:403
SELECT SQL_NO_CACHE tr.*
FROM `psdc_tax_rule` tr
JOIN `psdc_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 10
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.2 1 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE * FROM `psdc_tooltips` a LEFT JOIN `psdc_tooltips_lang` l ON (l.`id_tooltips` = a.`id_tooltips` AND l.`id_lang` = 7) WHERE a.`active`=1 AND (a.`product`=1 OR a.`everywhere`=1)
0.2 448 /modules/tooltips/models/tooltip.php:62
SELECT SQL_NO_CACHE *
FROM `psdc_product` a
LEFT JOIN `psdc_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 504) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE tcf_i.id_input
FROM `psdc_totcustomfields_display_input_native_hooks` tcf_di_nh
INNER JOIN `psdc_totcustomfields_display_input` `tcf_di` ON tcf_di.id_display_input = tcf_di_nh.id_display_input
INNER JOIN `psdc_totcustomfields_input` `tcf_i` ON tcf_i.id_input = tcf_di.id_input
INNER JOIN `psdc_totcustomfields_input_shop` `tcf_i_s` ON tcf_i_s.id_input = tcf_i.id_input
WHERE (tcf_i.code_object = 'product') AND (tcf_i.active = 1) AND (tcf_di.active = 1) AND (tcf_di_nh.hook = 'displayFooter') AND (tcf_di.code_display = 'native_hooks') AND (  tcf_i_s.id_shop IN (5) )
GROUP BY tcf_i.id_input
ORDER BY position ASC
0.2 1 Yes Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Classes/Displays/CustomFieldsDisplayNativeHooks.php:511
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN `psdc_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
INNER JOIN `psdc_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayTop')
INNER JOIN `psdc_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 7)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 5 AND `id_family` = 9
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.2 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:299
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_product` a
LEFT JOIN `psdc_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 6
LEFT JOIN `psdc_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 5
WHERE (a.`id_product` = 504) AND (b.`id_shop` = 5) LIMIT 1
0.2 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.2 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN `psdc_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
INNER JOIN `psdc_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayFooterProduct')
INNER JOIN `psdc_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 7)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 5 AND `id_family` = 9
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.2 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:299
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.2 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
FROM `psdc_image` i
INNER JOIN psdc_image_shop image_shop
ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 5)
LEFT JOIN `psdc_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 7)
WHERE i.`id_product` = 504
ORDER BY `position`
0.2 3 Yes /classes/Product.php:3096
SELECT SQL_NO_CACHE p.*, ps.*,pl.*
FROM psdc_appagebuilder_profiles p
INNER JOIN psdc_appagebuilder_profiles_lang pl ON (p.id_appagebuilder_profiles = pl.id_appagebuilder_profiles)
INNER JOIN psdc_appagebuilder_profiles_shop ps ON (ps.id_appagebuilder_profiles = p.id_appagebuilder_profiles)
WHERE id_shop=5 AND id_lang=7
0.2 11 /modules/appagebuilder/classes/ApPageBuilderProfilesModel.php:137
SELECT SQL_NO_CACHE c.*, cl.*  FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 5 ) LEFT JOIN `psdc_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 5) AND cs.`id_shop` = 5 AND c.`id_parent` != 0 WHERE c.`nleft` <= 10 AND c.`nright` >= 11 AND c.`nleft` >= 2 AND c.`nright` <= 51 ORDER BY `nleft` DESC
0.2 6 /classes/Category.php:1584
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE pe.*, pel.* FROM `psdc_messagesanywhere_configuration` pe 
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.`id_messagesanywhere_configuration` = pel.`id_messagesanywhere_configuration` AND pel.`id_lang` = 7)
WHERE pe.`id_shop` = 5 
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00")
ORDER BY pe.`position` ASC
0.2 10 Yes /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:214
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN `psdc_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
INNER JOIN `psdc_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductPriceBlockProduct')
INNER JOIN `psdc_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 7)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 5 AND `id_family` = 9
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.2 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:299
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN `psdc_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
INNER JOIN `psdc_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayProductButtons')
INNER JOIN `psdc_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 7)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 5 AND `id_family` = 9
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.2 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:299
SELECT SQL_NO_CACHE DISTINCT(qdr.`id_quantity_discount_rule`)
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN `psdc_quantity_discount_rule_lang` qdrl
ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
INNER JOIN `psdc_quantity_discount_rule_message` qdrm
ON (qdrm.`id_quantity_discount_rule` = qdr.`id_quantity_discount_rule` AND qdrm.`hook_name` = 'hookDisplayFooter')
INNER JOIN `psdc_quantity_discount_rule_message_lang` qdrml
ON (qdrm.`id_quantity_discount_rule_message` = qdrml.`id_quantity_discount_rule_message` AND qdrml.`id_lang` = 7)
WHERE qdr.`active` = 1
AND qdr.`id_shop` = 5 AND `id_family` = 9
ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.2 1 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:299
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 46 AND c.nright >= 47)
ORDER BY c.nleft
0.2 5 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE id_tab, class_name FROM `psdc_tab`
0.2 234 /classes/Tab.php:340
SELECT SQL_NO_CACHE *
FROM psdc_product_attachment pa
LEFT JOIN psdc_attachment a ON a.id_attachment = pa.id_attachment
LEFT JOIN psdc_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = 7)
WHERE pa.id_product = 504
0.1 4 /classes/Product.php:5220
SELECT SQL_NO_CACHE `id_guest`
FROM `psdc_connections`
WHERE `id_guest` = 14010186
AND `date_add` > '2024-07-15 12:48:00'
AND id_shop_group = 1 
ORDER BY `date_add` DESC LIMIT 1
0.1 1 Yes /classes/Connection.php:163
SELECT SQL_NO_CACHE `name`
FROM `psdc_hook`
WHERE `id_hook` = 538 LIMIT 1
0.1 1 /classes/Hook.php:222
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 5 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE *, qdrl.`name`, '' as id_customer
FROM `psdc_quantity_discount_rule` qdr
LEFT JOIN `psdc_quantity_discount_rule_lang` qdrl ON (qdr.`id_quantity_discount_rule` = qdrl.`id_quantity_discount_rule` AND qdrl.`id_lang` = 7)
WHERE qdr.`active` = 1 AND `id_family` = 9 AND `code` != '' AND `highlight` = 1 ORDER BY qdr.`priority` ASC, qdr.`id_quantity_discount_rule` ASC
0.1 66 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:250
SELECT SQL_NO_CACHE *
FROM `psdc_totcustomfields_input_lang`
WHERE `id_input` = 6 AND `id_shop` = 5
0.1 1 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE 1 FROM psdc_cart_product cp INNER JOIN psdc_product p
ON (p.id_product = cp.id_product) INNER JOIN psdc_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.1 1 /classes/Cart.php:4195
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM psdc_manufacturer m
INNER JOIN psdc_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 1 Yes /modules/ets_megamenu/ets_megamenu.php:2532
SELECT SQL_NO_CACHE *
FROM `psdc_op_blists_blocks_index`
WHERE hook_name = 'DisplayFooterBefore' 
AND id_shop = 5
AND id_lang = 7
ORDER BY position
0.1 21 Yes /modules/blistsop/classes/helpers/DbQueriesBlists.php:353
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM psdc_manufacturer m
INNER JOIN psdc_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 1 Yes /modules/ets_megamenu/ets_megamenu.php:2532
SELECT SQL_NO_CACHE *
FROM `psdc_totcustomfields_input_lang`
WHERE `id_input` = 5 AND `id_shop` = 5
0.1 1 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE *
FROM psdc_ets_mm_column
WHERE 1  AND id_menu=30
ORDER BY sort_order asc
0.1 21 Yes /modules/ets_megamenu/ets_megamenu.php:2495
SELECT SQL_NO_CACHE r.id_redirection
FROM psdc_smpl_redirection r, psdc_smpl_redirection_shop rs
WHERE r.id_redirection = rs.id_redirection
AND ((old_request_path="/en/products/wall-mouldings/wall-moulding-z390" OR old_request_path="https://www.d-cor.eu/en/products/wall-mouldings/wall-moulding-z390"))
AND rs.id_shop IN (5)  
GROUP BY r.id_redirection
0.1 37 Yes /modules/smplredirectionsmanager/classes/SmplTools.php:153
SELECT SQL_NO_CACHE value FROM `psdc_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
0.1 6 /classes/shop/Shop.php:1162
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM psdc_supplier s
INNER JOIN psdc_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 10 Yes /modules/ets_megamenu/ets_megamenu.php:2542
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 6 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE m.id_manufacturer as value,CONCAT('mm_manufacturer_',m.id_manufacturer) as id, name as label
FROM psdc_manufacturer m
INNER JOIN psdc_manufacturer_shop ms ON (m.id_manufacturer=ms.id_manufacturer AND ms.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 1 Yes /modules/ets_megamenu/ets_megamenu.php:2532
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM psdc_supplier s
INNER JOIN psdc_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 10 Yes /modules/ets_megamenu/ets_megamenu.php:2542
SELECT SQL_NO_CACHE DISTINCT c.*
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = 7)
WHERE `level_depth` = 1
0.1 17 /classes/Category.php:2195
SELECT SQL_NO_CACHE COUNT(DISTINCT l.id_lang) FROM `psdc_lang` l
JOIN psdc_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = 5)
WHERE l.`active` = 1 LIMIT 1
0.1 3 /classes/Language.php:1123
UPDATE `psdc_hook_module`
SET `position` = 255
WHERE `id_hook` IN (701, 36, 703, 702)
AND `id_module` = 92
0.1 1 /modules/m4pdf/m4pdf.php:2276
SELECT SQL_NO_CACHE ag.`id_accessory_group`,

ag.`show_name`,

ag.`collapse_expand`,

ag.`buy_together`,

IF(ag.`display_style` = 3, 0 , ag.`display_style`) as display_style,

agl.`name`

FROM

`psdc_accessory_group` ag

LEFT JOIN

`psdc_accessory_group_lang` `agl` ON agl.`id_accessory_group` = ag.`id_accessory_group`

WHERE

`agl`.`id_lang` = 7 AND `ag`.`active` = 1

ORDER BY ag.`position` ASC
0.1 1 Yes /modules/hsmultiaccessoriespro/abstract/classes/HsAccessoriesGroupAbstract.php:167
SELECT SQL_NO_CACHE *
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 7 AND cl.id_shop = 5 
WHERE (c.nleft <= 10 AND c.nright >= 11)
ORDER BY c.nleft
0.1 26 Yes /classes/Product.php:6768
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`  FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 5 ) LEFT JOIN `psdc_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 5) AND cs.`id_shop` = 5 AND c.`id_parent` != 0 WHERE c.`id_category` = 6 LIMIT 1
0.1 1 /classes/Category.php:1569
SELECT SQL_NO_CACHE n.* FROM `psdc_nkm_delivery_date_config` n INNER JOIN psdc_nkm_delivery_date_config_shop nkm_delivery_date_config_shop
ON (nkm_delivery_date_config_shop.id_nkm_delivery_date_config = n.id_nkm_delivery_date_config AND nkm_delivery_date_config_shop.id_shop = 5) WHERE n.`id_product` IN (504) ORDER BY n.`preparation_time` DESC
0.1 1 Yes /modules/nkmdeliverydate/classes/NkmDeliveryDateConfigClass.php:173
SELECT SQL_NO_CACHE count(*) FROM `psdc_messagesanywhere_configuration` pe
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.id_messagesanywhere_configuration = pel.id_messagesanywhere_configuration AND pel.id_lang = 7) 
WHERE pe.`id_shop` = 5
AND pel.`message` LIKE "%{PRODUCTS_BOUGHT%"
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00") LIMIT 1
0.1 10 /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:494
SELECT SQL_NO_CACHE s.id_supplier as value,CONCAT('mm_supplier_',s.id_supplier) as id, name as label
FROM psdc_supplier s
INNER JOIN psdc_supplier_shop ss ON (s.id_supplier=ss.id_supplier AND ss.id_shop=5)            
WHERE active=1 
ORDER BY name asc
0.1 10 Yes /modules/ets_megamenu/ets_megamenu.php:2542
SELECT SQL_NO_CACHE count(*) FROM `psdc_messagesanywhere_configuration` pe
LEFT JOIN `psdc_messagesanywhere_configuration_lang` pel ON (pe.id_messagesanywhere_configuration = pel.id_messagesanywhere_configuration AND pel.id_lang = 7) 
WHERE pe.`id_shop` = 5
AND pel.`message` LIKE "%{PRODUCT_ADDED_TO_CART%"
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00") LIMIT 1
0.1 10 /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:507
SELECT SQL_NO_CACHE n.* FROM `psdc_nkm_delivery_date_config` n INNER JOIN psdc_nkm_delivery_date_config_shop nkm_delivery_date_config_shop
ON (nkm_delivery_date_config_shop.id_nkm_delivery_date_config = n.id_nkm_delivery_date_config AND nkm_delivery_date_config_shop.id_shop = 5) WHERE n.`id_product` IN (504) ORDER BY n.`preparation_time` DESC
0.1 1 Yes /modules/nkmdeliverydate/classes/NkmDeliveryDateConfigClass.php:173
SELECT SQL_NO_CACHE count(*) FROM `psdc_messagesanywhere_configuration` pe 
WHERE pe.`id_shop` = 5
AND pe.`effect` = "ma-marquee"
AND pe.`active` = 1 AND (pe.`date_from` <= "2024-07-15 13:18:16" OR pe.`date_from` = "0000-00-00 00:00:00") AND (pe.`date_to` >= "2024-07-15 13:18:16" OR pe.`date_to` = "0000-00-00 00:00:00") LIMIT 1
0.1 10 /modules/messagesanywhere/classes/MessagesAnywhereConfiguration.php:457
SELECT SQL_NO_CACHE id_trustedshops_channel
FROM `psdc_trustedshops_channel`
WHERE (id_client = '61d3cd0b1e6b__PrestaShop') AND (id_lang = 7) AND (id_shop = 5) LIMIT 1
0.1 2 /modules/trustedshopseasyintegration/src/Repository/ChannelRepository.php:95
SELECT SQL_NO_CACHE `name`, `alias` FROM `psdc_hook_alias`
0.1 88 /classes/Hook.php:284
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `psdc_currency` c
LEFT JOIN psdc_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 5)
WHERE c.`active` = 1 LIMIT 1
0.1 4 /classes/Currency.php:1099
SELECT SQL_NO_CACHE qdr.`id_quantity_discount_rule`, qdrc.`id_quantity_discount_rule_condition`
FROM `psdc_quantity_discount_rule` qdr
INNER JOIN  `psdc_quantity_discount_rule_condition` qdrc ON (qdr.`id_quantity_discount_rule` = qdrc.`id_quantity_discount_rule`)
WHERE qdrc.`id_type` = 27 AND qdr.`id_shop` = 5
0.1 27 /modules/quantitydiscountpro/classes/QuantityDiscountRule.php:268
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE *
FROM `psdc_country` a
LEFT JOIN `psdc_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 7
LEFT JOIN `psdc_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 5
WHERE (a.`id_country` = 8) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE p.id_product
FROM `psdc_product` p
INNER JOIN psdc_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 5)
WHERE p.id_product = 504
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-07-15 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.1 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE tr.*
FROM `psdc_tax_rule` tr
JOIN `psdc_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`)
WHERE trg.`active` = 1
AND tr.`id_country` = 8
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
0.1 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE `buy_together`,`id_accessory_group`
FROM `psdc_accessory_group`
WHERE (`active` = 1)
0.1 1 /modules/hsmultiaccessoriespro/abstract/classes/HsAccessoriesGroupAbstract.php:891
SELECT SQL_NO_CACHE name, alias FROM `psdc_hook_alias`
0.1 88 /classes/Hook.php:336
SELECT SQL_NO_CACHE *
FROM `psdc_category` a
LEFT JOIN `psdc_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `psdc_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 6) AND (b.`id_shop` = 5) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE * FROM psdc_pwcountryselections WHERE active=1 ORDER BY position ASC
0.1 11 Yes /modules/pwcountryselector/src/classes/pwcountryselection.php:60
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `psdc_specific_price` WHERE `id_product` != 0 LIMIT 1
0.1 3 /classes/SpecificPrice.php:286
SELECT SQL_NO_CACHE * FROM psdc_pwcountryselections WHERE active=1 ORDER BY position ASC
0.1 11 Yes /modules/pwcountryselector/src/classes/pwcountryselection.php:60
SELECT SQL_NO_CACHE p.id_product
FROM `psdc_product` p
INNER JOIN psdc_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 5)
WHERE p.id_product = 504
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-07-15 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.1 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE *
FROM psdc_ets_mm_column
WHERE 1  AND id_menu=31
ORDER BY sort_order asc
0.1 2 Yes /modules/ets_megamenu/ets_megamenu.php:2495
SELECT SQL_NO_CACHE *
FROM `psdc_product_lang`
WHERE `id_product` = 504 AND `id_shop` = 5
0.1 7 /src/Adapter/EntityMapper.php:82
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `psdc_lang` l
LEFT JOIN `psdc_lang_shop` ls ON (l.id_lang = ls.id_lang)
0.1 7 /classes/Language.php:991
SELECT SQL_NO_CACHE code_input_type
FROM `psdc_totcustomfields_input` tcf_input, `psdc_totcustomfields_input_shop` tcf_input_shop
WHERE (tcf_input.id_input = 5) AND (  tcf_input_shop.id_shop IN (5) )
GROUP BY tcf_input.id_input LIMIT 1
0.1 3 Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Services/CustomFieldsInputService.php:96
SELECT SQL_NO_CACHE p.id_product
FROM `psdc_product` p
INNER JOIN psdc_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 5)
WHERE p.id_product = 504
AND DATEDIFF(
product_shop.`date_add`,
DATE_SUB(
"2024-07-15 00:00:00",
INTERVAL 20 DAY
)
) > 0
0.1 0 /classes/Product.php:1428
SELECT SQL_NO_CACHE `id_similar_product`
FROM `psdc_cdcompare_similar_product`
WHERE `id_product` = 504
GROUP BY `id_similar_product`
ORDER BY `position` ASC
0.1 1 Yes Yes /modules/cdproductcomparisonplus/classes/CdSimilarProduct.php:103
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE * FROM psdc_pwcountryselections WHERE active=1 ORDER BY position ASC
0.1 11 Yes /modules/pwcountryselector/src/classes/pwcountryselection.php:60
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM psdc_shop s
LEFT JOIN psdc_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 5
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
0.1 1 /classes/shop/Shop.php:201
SELECT SQL_NO_CACHE code_input_type
FROM `psdc_totcustomfields_input` tcf_input, `psdc_totcustomfields_input_shop` tcf_input_shop
WHERE (tcf_input.id_input = 14) AND (  tcf_input_shop.id_shop IN (5) )
GROUP BY tcf_input.id_input LIMIT 1
0.1 3 Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Services/CustomFieldsInputService.php:96
SELECT SQL_NO_CACHE n.* FROM `psdc_nkm_delivery_date_config` n INNER JOIN psdc_nkm_delivery_date_config_shop nkm_delivery_date_config_shop
ON (nkm_delivery_date_config_shop.id_nkm_delivery_date_config = n.id_nkm_delivery_date_config AND nkm_delivery_date_config_shop.id_shop = 5) WHERE n.`id_category` IN (6) ORDER BY n.`preparation_time` DESC
0.1 1 Yes /modules/nkmdeliverydate/classes/NkmDeliveryDateConfigClass.php:191
SELECT SQL_NO_CACHE *
FROM `psdc_category` a
LEFT JOIN `psdc_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 7
LEFT JOIN `psdc_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 5
WHERE (a.`id_category` = 2) AND (b.`id_shop` = 5) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM psdc_ets_mm_column
WHERE 1  AND id_menu=32
ORDER BY sort_order asc
0.1 1 Yes /modules/ets_megamenu/ets_megamenu.php:2495
SELECT SQL_NO_CACHE id_trustedshops_channel
FROM `psdc_trustedshops_channel`
WHERE (id_client = '61d3cd0b1e6b__PrestaShop') AND (id_lang = 7) AND (id_shop = 5) LIMIT 1
0.1 2 /modules/trustedshopseasyintegration/src/Repository/ChannelRepository.php:95
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 5 ) LEFT JOIN `psdc_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 5) WHERE c.`id_category` = 3 AND cs.`id_shop` = 5 AND c.`id_parent` != 0 LIMIT 1
0.1 1 /override/classes/Link.php:75
SELECT SQL_NO_CACHE n.* FROM `psdc_nkm_delivery_date_config` n INNER JOIN psdc_nkm_delivery_date_config_shop nkm_delivery_date_config_shop
ON (nkm_delivery_date_config_shop.id_nkm_delivery_date_config = n.id_nkm_delivery_date_config AND nkm_delivery_date_config_shop.id_shop = 5) WHERE n.`id_category` IN (6) ORDER BY n.`preparation_time` DESC
0.1 1 Yes /modules/nkmdeliverydate/classes/NkmDeliveryDateConfigClass.php:191
SELECT SQL_NO_CACHE `id_order`
FROM `psdc_orders`
WHERE `id_cart` = 0 AND id_shop IN (5) LIMIT 1
0.1 1 /classes/order/Order.php:1193
SELECT SQL_NO_CACHE *
FROM `psdc_group` a
LEFT JOIN `psdc_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 5
WHERE (a.`id_group` = 1) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE `id_module` FROM `psdc_module` WHERE `name` = "bonwishlist" LIMIT 1
0.1 1 /classes/module/Module.php:2828
SELECT SQL_NO_CACHE code_input_type
FROM `psdc_totcustomfields_input` tcf_input, `psdc_totcustomfields_input_shop` tcf_input_shop
WHERE (tcf_input.id_input = 6) AND (  tcf_input_shop.id_shop IN (5) )
GROUP BY tcf_input.id_input LIMIT 1
0.1 3 Yes /modules/totcustomfields/vendor/totpsclasslib/src/Extensions/CustomFields/Services/CustomFieldsInputService.php:96
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE `width`, `height`
FROM psdc_image_type
WHERE `name` = 'home_default' LIMIT 1
0.1 1 /classes/Image.php:510
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 5 ) LEFT JOIN `psdc_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 5) WHERE c.`id_category` = 6 AND cs.`id_shop` = 5 AND c.`id_parent` != 0 LIMIT 1
0.1 1 /override/classes/Link.php:75
SELECT SQL_NO_CACHE * FROM `psdc_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
0.1 11 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE domain
FROM `psdc_shop_url`
WHERE (main = 1) AND (active = 1)
AND id_shop IN (3, 5, 4, 2, 1)
0.1 5 /classes/shop/Shop.php:793
SELECT SQL_NO_CACHE * FROM `psdc_currency` c ORDER BY `iso_code` ASC
0.1 4 Yes /classes/Currency.php:695
SELECT SQL_NO_CACHE qdrf.*
FROM `psdc_quantity_discount_rule_family` qdrf
WHERE 1
AND qdrf.active = 1 AND qdrf.`id_shop` = 5 ORDER BY qdrf.priority ASC;
0.1 9 Yes /modules/quantitydiscountpro/classes/QuantityDiscountRuleFamily.php:69
SELECT SQL_NO_CACHE COUNT(*) FROM `psdc_pack` WHERE id_product_pack = 504 LIMIT 1
0.1 1 /classes/Pack.php:85
SELECT SQL_NO_CACHE *
FROM `psdc_currency` a
LEFT JOIN `psdc_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 7
LEFT JOIN `psdc_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 5
WHERE (a.`id_currency` = 3) LIMIT 1
0.1 0 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE *
FROM `psdc_totcustomfields_input` a
LEFT JOIN `psdc_totcustomfields_input_shop` `c` ON a.`id_input` = c.`id_input` AND c.`id_shop` = 5
WHERE (a.`id_input` = 5) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_trustedshops_channel
FROM `psdc_trustedshops_channel`
WHERE (id_client = '61d3cd0b1e6b__PrestaShop') AND (id_lang = 7) AND (id_shop = 5) LIMIT 1
0.1 2 /modules/trustedshopseasyintegration/src/Repository/ChannelRepository.php:95
SELECT SQL_NO_CACHE c.*, cl.*
FROM `psdc_category` c
LEFT JOIN `psdc_category_lang` cl
ON (c.`id_category` = cl.`id_category`
AND `id_lang` = 7 AND cl.id_shop = 5 ) LEFT JOIN `psdc_category_shop` cs ON (c.`id_category` = cs.`id_category` AND cs.`id_shop` = 5) WHERE c.`id_category` = 2 AND cs.`id_shop` = 5 AND c.`id_parent` != 0 LIMIT 1
0.1 1 /override/classes/Link.php:75
SELECT SQL_NO_CACHE *
FROM `psdc_lang` a
LEFT JOIN `psdc_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 5
WHERE (a.`id_lang` = 7) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE page from `psdc_appagebuilder_page` where id_product = '504' AND id_shop = '5' LIMIT 1
0.1 1 /modules/appagebuilder/appagebuilder.php:3916
SELECT SQL_NO_CACHE *
FROM `psdc_totcustomfields_input` a
LEFT JOIN `psdc_totcustomfields_input_shop` `c` ON a.`id_input` = c.`id_input` AND c.`id_shop` = 5
WHERE (a.`id_input` = 14) LIMIT 1
0.1 1 /src/Adapter/EntityMapper.php:75
SELECT SQL_NO_CACHE id_input_value
FROM `psdc_totcustomfields_input_text_value`
WHERE (id_input = 6) AND (id_object = 504) AND (id_lang = 7) LIMIT 1
0.1 1