Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Μόνο Online!
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια
  • Black Sun Leaf : Ομπρέλα και κινητή ενέργεια

Black Sun Leaf : Ομπρέλα και κινητή ενέργεια

157,50 €
με ΦΠΑ
χρώμα
ηλιακός συλλέκτης
Ποσότητα
Δεν υπάρχουν αρκετά προϊόντα σε απόθεμα

Το Μαύρο Sun Nomad Shadow Sail leaf for lifeTM συνδυάζει την υγεία και την επαναστατική τεχνολογία. Αντι-αντήχηση χάρη στη μαύρη κάτω επιφάνεια που απορροφά τις ανακλώμενες ακτίνες του ήλιου στο έδαφος ή στο νερό, ενσωματώνει ένα αφαιρούμενο ηλιακό πάνελ 16W. Απαράμιλλη προστασία στη βεράντα σας, δίπλα στην πισίνα σας και για τις υπαίθριες δραστηριότητες, πεζοπορία, παραλία, βάρκα.

ΠΕΡΙΕΧΟΜΕΝΟ ΤΗΣ ΣΥΣΚΕΥΑΣΗΣ ΜΑΥΡΟΣ ΗΛΙΟΣ LEAF

1 Τσάντα μεταφοράς και αποθήκευσης - 1 πόδι αγκύρωσης και το επεξεργασμένο στο μηχάνημα τμήμα κεντράρισμα αλουμινίου - 1 Μουσκέτο - 1Hauban - 1 Πανί σκιάς και τηλεσκοπικό πόδι - 1 Αφαιρούμενο Ηλιακό Πάνελ 16 W

ΜΑΥΡΟΣ ΗΛΙΟς LEAF

Το BLACK SUN LEAF διαθέτει ένα εύκαμπτο φωτοβολταϊκό πάνελ 16W με 1 θύρα USB που μπορεί να φορτίσει smartphones, tablets, μπαταρίες καθώς και αξεσουάρ όπως μικρο-ανεμιστήρα, σύστημα ψύξης, ... Το φωτοβολταϊκό πάνελ είναι αφαιρούμενο και μπορεί να συνδεθεί με το πανί ή την τσάντα μεταφοράς.

ΑΣΦΆΛΕΙΑ, ΥΓΕΊΑ ΚΑΙ ΕΥΕΞΊΑ

Το Nomad leaf for lifeTM Shadow Sail εγγυάται βέλτιστο σκιερό χώρο, υψηλή προστασία από τον ήλιο και αντι-αντήχηση. Όπως και η ευελιξία του καλαμιού, το LEAF απορροφά την ενέργεια του ανέμου χωρίς να αντιστέκεται, μειώνοντας έτσι τον κίνδυνο να αποκόψει το έδαφος.

LEAF ΣΧΕΔΙΑΣΜΟΣ

Το Ιστιοπλοϊκό leaf for lifeTM ταιριάζει απόλυτα με έπιπλα εξωτερικού σχεδιασμού δίπλα σε πισίνα, βεράντα ή κήπο.

LEAF«Ν ΨΑΡΙ

Η ιστιοπλοΐα του Umbrage Nomad leaf for lifeTM συνοδεύει τους λάτρεις της φύσης και της αλιείας με λίμνες και ποτάμια. Ελαφρύς και συμπαγής, η τσάντα μεταφοράς του παρέχει επιπλέον χώρο αποθήκευσης για άλλο εξοπλισμό. Πολύ πρακτικό, το πόδι αγκύρωσης προσαρμόζεται στα εδάφη όλων των ακτών...

ΕΎΚΟΛΟ ΠΑΚΈΤΟ'N GO

Κομψό, στιβαρό και εύκολο στη χρήση, το leaf for life TM Nomad Shadow Sail έχει σχεδιαστεί για εσάς! Η εργονομία και ο νομαδικός χαρακτήρας του έχουν μελετηθεί για να απλοποιήσουν την καθημερινή σας ζωή και να βελτιώσουν σημαντικά την άνεσή σας.

Τα δυνατά σημεία του μοντέλου Black Sun Leaf

Πρακτικότητα

Μια ανθεκτική τσάντα μεταφοράς, αρκετά μεγάλη και εξοπλισμένη (τσέπες αποθήκευσης) για να στεγάσει αντικείμενα παραλίας (βιβλίο, σνακ ...).

Ελαφρότητα του Νομαδικού Σαλπάρι της Σκιάς.

Το off-center πόδι σας επιτρέπει να επωφεληθείτε πλήρως από το χώρο σκιάς κάτω από το πανί.

Τηλεσκοπικό πόδι που συμβάλλει στη βελτιστοποίηση της ακαταστασίας.

Το εύκολο, γρήγορο και αξιόπιστο πόδι αγκύρων και το επεξεργασμένο κομμάτι κεντράροντας αργιλίου επιτρέπουν σε σας για να στερεώσουν το πανί σκιών Nomad leaf for life TM αβίαστα.

Παρουσία ενός συστήματος συνδετήρων στο πίσω μέρος του πανιού με 1 carny και 1 μουσκέτο για να κρεμάσετε τσάντα μεταφοράς, πετσέτες παραλίας, βατραχοπέδιλα...

Εύκολη αποθήκευση του Nomad Shadow Sail και του ποδιού του σε εργονομική τσάντα μεταφοράς.

άνεση

Ηλιακός συλλέκτης Systeme Nomad: Ενσωμάτωση κινητού φωτοβολταϊκού πλαισίου.

Παρουσία μιας θύρας USB για να επαναφορτίσετε το smartphone σας, mp3 player, και τη δύναμη μικρο-ανεμιστήρα, ψύκτης, ...

Σύστημα Cool Breeze: Ελεύθερη κυκλοφορία αέρα κάτω από την επιφάνεια του πανιού για απαράμιλλη ευεξία.

ποιότητα

Βιωσιμότητα και ευρωστία των εξαρτημάτων.

Είναι δυνατή η ανταλλαγή των πανιών.

Αντιμυκητιασικό και απο-ψεκάζοντας ύφασμα πανιών.

ΚΑΙΝΟΤΟΜΙΑ - Κατοχυρωμένο με δίπλωμα ευρεσιτεχνίας σύστημα

CTS: Σύστημα τεντώματος καμπυλών. Γρήγορο άνοιγμα utra με αυτο-ανάπτυξη του ιστίου και της αναδιπλούμενης εγκατάστασης

SFS: Ήλιος που ακολουθεί το σύστημα. Βελτιστοποίηση της επιφάνειας σκιάς: Η πολυκατευθυντική επιγονατίδα 360 μοιρών επιτρέπει στο πανί να κατευθύνεται σύμφωνα με την πορεία του ήλιου. Αυτό σας δίνει την καλύτερη ποικιλία σκιάς οποιαδήποτε στιγμή της ημέρας.

ασφάλεια

Δεν υπάρχει απότομη γωνία γύρω από το πανί

Επεξεργασμένο στη μηχανή άκρη ποδιών (καμία υψηλή άκρη)

Τέλεια αεροδυναμική χάρη στο σχήμα και το off-center πόδι, το φαινόμενο ανύψωσης μειώνεται και το κράτημα του εδάφους ενισχύεται.

Υγεία

Προστασία πανιών ανθεκτική στην υπεριώδη ακτινοβολία πέρα από το δείκτη UPF 50 (99% της υπεριώδους ακτινοβολίας που εμποδίζεται από τα πανιά Black Leaf και Black Sun Leaf) και μια επίστρωση κατά της αντήχησης.

Νέο προϊόν
BLACK SUN LEAF : ROYAL BLUE

4 άλλα προϊόντα της ίδιας κατηγορίας:

Load Time363 ms - Unicorn powered webserver!
Querying Time150 ms
Queries316
Memory Peak Usage18.6 Mb
Included Files809 files - 9.84 Mb
PrestaShop Cache- Mb
Global vars0.19 Mb
PrestaShop Version1.7.5.0
PHP Version7.0.33-47+ubuntu18.04.1+deb.sury.org+1 (Consider upgrading)
MySQL Version10.1.48-MariaDB-0ubuntu0.18.04.1 (OK)
Memory Limit1024M
Max Execution Time0s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 61 ms 61 ms 5.78 Mb 6.14 Mb
__construct 0 ms 61 ms - Mb 6.14 Mb
init 45 ms 107 ms 3.01 Mb 8.97 Mb
checkAccess 0 ms 107 ms - Mb 8.97 Mb
setMedia 6 ms 113 ms 0.63 Mb 9.42 Mb
postProcess 0 ms 113 ms - Mb 9.42 Mb
initHeader 0 ms 113 ms - Mb 9.42 Mb
initContent 93 ms 206 ms 3.47 Mb 12.93 Mb
initFooter 0 ms 206 ms - Mb 12.93 Mb
display 157 ms 363 ms 5.31 Mb 18.59 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 316 queries

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

Doubles

19
SELECT *
FROM `modXX_product` a
LEFT JOIN `modXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX
LEFT JOIN `modXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX
WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
15
			SELECT cl.`link_rewrite`
			FROM `modXX_category_lang` cl
			WHERE `id_lang` = XX
			 AND cl.id_shop = XX 
			AND cl.`id_category` = XX LIMIT XX
15
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`eanXX`, pa.`isbn`,pa.`upc`
            FROM `modXX_attribute` a
            LEFT JOIN `modXX_attribute_lang` al
                ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX)
            LEFT JOIN `modXX_product_attribute_combination` pac
                ON (pac.`id_attribute` = a.`id_attribute`)
            LEFT JOIN `modXX_product_attribute` pa
                ON (pa.`id_product_attribute` = pac.`id_product_attribute`)
             INNER JOIN modXX_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            LEFT JOIN `modXX_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX)
            WHERE pa.`id_product` = XX
                AND pac.`id_product_attribute` = XX
                AND agl.`id_lang` = XX
13
SELECT `id_module` FROM `modXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
13
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity,
            COALESCE(SUM(first_level_quantity), XX) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity
          FROM `modXX_cart_product` cp
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `modXX_cart_product` cp JOIN `modXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `modXX_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = XX
            AND cp.`id_customization` = XX
            AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR (
            pr.`pack_stock_type` = XX
            AND XX = XX
        ))) as q LIMIT XX
12
SELECT SUM(quantity)
FROM `modXX_stock_available`
WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
11
            SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, XX qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
            FROM `modXX_product_attribute` pa
             INNER JOIN modXX_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
            JOIN `modXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
            JOIN `modXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
            JOIN `modXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX)
            JOIN `modXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
            WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX
            GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
            
            ORDER BY a.`position` ASC;
9
SELECT `id_product_attribute`
            FROM `modXX_product_attribute`
            WHERE `id_product` = XX
8
            SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position`
            FROM `modXX_image` i
             INNER JOIN modXX_image_shop image_shop
        ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX)
            LEFT JOIN `modXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX)
            WHERE i.`id_product` = XX
            ORDER BY `position`
7
SELECT name FROM modXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
7
                SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop`
                FROM `modXX_module` m
                LEFT JOIN `modXX_module_shop` ms
                ON m.`id_module` = ms.`id_module`
                AND ms.`id_shop` = XX
7
SELECT XX FROM `modXX_specific_price` WHERE id_product = XX LIMIT XX
6
SELECT pa.`available_date` FROM `modXX_product` p LEFT JOIN `modXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN modXX_product_shop product_shop
        ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN modXX_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
6
			SELECT product_attribute_shop.`price`
			FROM `modXX_product_attribute` pa
			 INNER JOIN modXX_product_attribute_shop product_attribute_shop
        ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX)
			WHERE pa.`id_product_attribute` = XX LIMIT XX
6
SELECT *
FROM `modXX_product_attribute` a
LEFT JOIN `modXX_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX
WHERE (a.`id_product_attribute` = XX) LIMIT XX
6
                            SELECT `id_tax_rules_group`
                            FROM `modXX_product_shop`
                            WHERE `id_product` = XX AND id_shop=XX LIMIT