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, Χρυσό Μετάλλιο Lépine Διεθνής Διαγωνισμός του Παρισιού

Μια κατοχυρωμένη με δίπλωμα ευρεσιτεχνίας γαλλική καινοτομία

Μαύρος Leaf, Χρυσό Μετάλλιο Διεθνής Διαγωνισμός Σπονδυλικής Στήλης στο Παρίσι

Μια κατοχυρωμένη με δίπλωμα ευρεσιτεχνίας γαλλική καινοτομία

ΠΕΡΙΕΧΟΜΕΝΟ ΤΗΣ ΣΥΣΚΕΥΑΣΗΣ ΜΑΥΡΟΣ ΗΛΙΟΣ 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
  • Μόνο Online!

TRIDENT: αγκυροβόληση εκτός δρόμου

Το πόδι αγκύρωσης TRIDENT είναι εύκολο στη χρήση. Σπρώξτε το στο έδαφος πιέζοντας με το πόδι σας στο έλκηθρο αλουμινίου για το σκοπό αυτό. Ανοίξτε το σφιγκτήρα στο σωλήνα αλουμινίου, τοποθετήστε το...

30,00 € με ΦΠΑ
Προσθήκη στο καλάθι
Προσθήκη στη λίστα επιθυμιών
Γρήγορη ματιά Μάθε περισσότερα

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

  • Μόνο Online!
Ανίς Γκριν σαμπάνια Ανθρακίτης Γκρι

Περιορισμένη έκδοση Black Leaf & Sun Leaf

ΠΕΡΙΕΧΌΜΕΝΟ ΤΗς ΔΈΣΜΗς ΜΑΎΡΩΝ LEAF 1 Τσάντα μεταφοράς και αποθήκευσης - 1 πόδι αγκύρωσης και το κεντράροντας μέρος του - 1 Musket - 1 καλώδιο - 1 πανί σκιάς και το τηλεσκοπικό πόδι τουΠεριεχόμενο...

99,17 € με ΦΠΑ
Προσθήκη στο καλάθι
Προσθήκη στη λίστα επιθυμιών
Γρήγορη ματιά Μάθε περισσότερα
Πλήρες πορτοκαλί Εκθαμβωτικό κόκκινο Βασιλικό μπλε Μπλε Τοπάζ

Black Leaf : Νομάδος Ομπρέλα

ΠΕΡΙΕΧΟΜΕΝΟ ΤΗΣ ΣΥΣΚΕΥΑΣΗΣ Μαύρο LEAF 1 Τσάντα μεταφοράς και αποθήκευσης - 1 πόδι αγκύρωσης και το κεντράξιμο μέρος του - 1 καλώδιο - 1 Μουσκέτο - 1 Πανί σκιάς και το τηλεσκοπικό πόδι του ΑΣΦΆΛΕΙΑ,...

99,17 € με ΦΠΑ
Προσθήκη στο καλάθι
Προσθήκη στη λίστα επιθυμιών
Γρήγορη ματιά Μάθε περισσότερα
  • Μόνο Online!
Πλήρες πορτοκαλί Εκθαμβωτικό κόκκινο Βασιλικό μπλε Μπλε Τοπάζ

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

ΠΕΡΙΕΧΟΜΕΝΟ ΤΗΣ ΣΥΣΚΕΥΑΣΗΣ ΜΑΥΡΟΣ ΗΛΙΟΣ LEAF 1 Τσάντα μεταφοράς και αποθήκευσης - 1 πόδι αγκύρωσης και το επεξεργασμένο στο μηχάνημα τμήμα κεντράρισμα αλουμινίου - 1 Μουσκέτο - 1Hauban - 1 Πανί...

157,50 € με ΦΠΑ
Προσθήκη στο καλάθι
Προσθήκη στη λίστα επιθυμιών
Γρήγορη ματιά Μάθε περισσότερα
  • Μόνο Online!
  • Με έκπτωση!
καμουφλάζ

Limited Edition Μαύρο Leaf Καμουφλάζ

ΜΑΎΡΟ LEAF ΠΕΡΙΕΧΌΜΕΝΑ ΣΥΣΚΕΥΑΣΊΑΣ1 τσάντα μεταφοράς και αποθήκευσης + 1 πόδι άγκυρας και το κεντρικό κομμάτι του + 1 καραμπίνερ + 1 Guyline + 1 πανί σκίασης και το τηλεσκοπικό του πόδιΠΕΡΙΕΧΟΜΕΝΑ...

74,17 € με ΦΠΑ
Προσθήκη στο καλάθι
Προσθήκη στη λίστα επιθυμιών
Γρήγορη ματιά Μάθε περισσότερα
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
  1. Stopwatch SQL
  2. Doubles
  3. Tables stress
  4. ObjectModel instances
  5. Included Files

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