100%
Naturel
  • Rose Papaya - Gel nettoyant illuminateur
  • Rose Papaya - Gel nettoyant illuminateur
  • Rose Papaya - Gel nettoyant illuminateur
  • Rose Papaya - Gel nettoyant illuminateur

Rose Papaya

Gel nettoyant illuminateur

63,00 €

100 ml
Ce produit est indisponible pour le moment

Trésor du monde®

Ce gel-baume nettoyant illuminateur nettoie quotidiennement les pores en éliminant l'excès de sébum, les peaux mortes et la pollution, tout en maintenant l'hydratation de la peau. Le grain de peau est affiné et la peau saine et lumineuse.

Composé sans détergent et sans parfum synthétique, Rose Papaya fond sur la peau grâce à sa délicieuse texture gel et s’émulsionne au contact de l’eau. Les sucres naturels présents dans ce gel éliminent les impuretés tandis que les enzymes de papaye, mangue et grenade exfolient et que l’aloe vera calme et apaise la peau.


Ce produit est sans paraben, sans huiles minérales, sans tricosan, EDTA, sans huile de palme, sans PEG, sans phtalates, sans OGM, sans alcool, sans gluten, sans parfum, ni colorant de synthèse. Il est composé d’actifs de qualité comprenant des nutriments et des vitamines que la peau reconnaît naturellement. 

       

        

  • En savoir plus
  • Partager ce produit :
Me tenir informé lorsque ce produit sera à nouveau en stock :

Ajouter à ma wishlist

"L’intégrité réconfortante de la cosmétique française"

Created by potrace 1.16, written by Peter Selinger 2001-2019

"Pour qui ? Pour celles qui sont sensibles à la noblesse des ingrédients de leur crème."

Created by potrace 1.16, written by Peter Selinger 2001-2019

"Les petites marques qui se lancent dans la cour des grands."

"Le mimosa tenuiflora, une écorce fétiche des femmes mayas bien connues pour ses propriétés anti-âge est la star des produits de la marque."

Besoin d’aide ?
Pour toute question beauté, contactez nos beauty trotter
100%
Naturel
Rose Papaya - Gel nettoyant illuminateur

"L’intégrité réconfortante de la cosmétique française"

Created by potrace 1.16, written by Peter Selinger 2001-2019

"Pour qui ? Pour celles qui sont sensibles à la noblesse des ingrédients de leur crème."

Created by potrace 1.16, written by Peter Selinger 2001-2019

"Les petites marques qui se lancent dans la cour des grands."

"Le mimosa tenuiflora, une écorce fétiche des femmes mayas bien connues pour ses propriétés anti-âge est la star des produits de la marque."

Description

Produit 100 % naturel - Made in France

Contenance : 100 ml   3.4 fl oz

Pour quel type de peau :

Le gel nettoyant illuminateur Rose Papaya est idéal pour tous types de peau y compris les plus ternes. 

Résultats : 

Avec sa texture crémeuse ultra-rafraîchissante, la peau est parfaitement équilibrée, hydratée et rayonnante. Pas de sensation de dessèchement après le rinçage. 



Flacon en verre recyclable ou réutilisable.

Ingrédients

Acides de papaye, mangue et grenade :

Pour faire peau neuve, ces acides naturels de fruits ont une action « peeling » en agissant sur le renouvellement cellulaire. Ils aident à lisser le grain de peau, à uniformiser et à rendre le teint plus lumineux.

Aloe vera :

L’aloe vera hydrate, adoucit, protège et nourrit la peau en profondeur tout en rééquilibrant son ph. Astringent (resserre les pores de la peau), il est aussi riche en vitamines, acides aminés et minéraux à l’action hydratante anti-inflammatoire et émolliente.

Huile de moringa :

Très prisée par la médecine ayurvédique, l’huile de moringa permet de nourrir, d’assouplir et de revitaliser les peaux matures (vitamine E, antioxydant et anti-radicaux libres), les peaux fragiles ou très sèches sujettes à une desquamation ou des démangeaisons (vitamine A, acides gras insaturés).

Tepezcohuite :

Surnomée la « plante miracle maya », la poudre de tepezcohuite possède des propriétés antibactériennes, antifongiques et astringentes qui resserrent les pores et repulpent la peau. Grâce à sa capacité à capter les radicaux libres, elle peut également avoir une action sur certaines enzymes responsables du vieillissement cutané. 

Helianthus annuus seed oil, Coconut alkanes, Glycerin**, Coco caprylate/caprate, Lactobacillus/Punica granatum fruit ferment extract, Polyglyceryl-10 myristate, Tocopherol, Rose extract, Squalene, Carica papaya fruit extract, Mangifera indica fruit extract, Mimosa tenuiflora bark extract, Hibiscus sabdariffa flower extract, Sclerocarya birrea seed oil, Leuconostoc/Radish root ferment filtrate, Eclipta prostrata extract, Beta-sitosterol, Melia azadirachta leaf extract, Citrus aurantium dulcis peel extract, Citrus tangerina peel extract, Eugenia caryophyllus flower extract, Prunus armeniaca fruit extract, Pyrus malus fruit extract, Moringa oleifera seed oil, Camellia sinensis leaf extract, Cananga odorata flower extract, Coffea arabica leaf/seed extract, Cucumis melo cantalupensis fruit extract, Cucumis melo fruit extract, Hyacinthus orientalis flower extract, Impatiens balsamina flower extract, Jasminum officinale flower/leaf extract, Lavandula angustifolia flower/leaf/stem extract, Rubus idaeus leaf extract, Vitis vinifera fruit extract, Polyglyceryl-3 diisostearate, Caprylic/Capric triglyceride, Aqua

* Ingrédients issus de l’agriculture biologique

** transformés à partir d’ingrédients biologiques 

100 % du total des ingrédients sont d’origine naturelle

65 % du total des ingrédients sont issus de l’agriculture biologique

Contient l’actif breveté : « Sublime Nature »

Ingrédients : Pour en savoir plus sur nos ingrédients, consultez notre rubrique « Ingrédients »

Conseils d’utilisation

Appliquer généreusement le nettoyant illuminateur sur visage sec puis masser par mouvements circulaires. Utiliser un tissu imbibé d'eau chaude ou une éponge Konjac sur le visage et sur le cou pendant quelques secondes en respirant profondément puis rincer abondamment. Vous pouvez maintenant utiliser l’essence hydratante Rose Bamboo Mawena pour parfaire le nettoyage. 

Le conseil de Helena Mendès : 

Je n’hésite pas à chauffer le soin entre mes mains avant de l’appliquer sur mon visage sec en réalisant des mouvements circulaires pour tonifier les muscles de mon visage. J’apprécie particulièrement l’instant où j’émulsionne le soin avec un peu d’eau, car à ce moment-là, je sens que ma peau est parfaitement propre et fraîche. 

Les avis
Avis clients
(22 avis)
Hermine
Véritable coup de coeur
Ce baume nettoyant a été un véritable coup de coeur. Ce que je préfère dans ce produit c'est sa texture gel qui se transforme en huile sur le visage. C'est très ludique et super doux. Son application reste très simple et agréable. Il se rince facilement et rapidement à l'eau claire et élimine tous les résidus de maquillage. Il laisse un film protecteur hydratant sur la peau, super agréable. Je n'ai pas ressenti les petits tiraillements ou les effets poisseux que peuvent laisser sur la peau certains produits nettoyants sans doute trop abrasifs. Appliquer une crème hydratante après l'utilisation de ce baume était même parfois devenu superflu. J'ai aimé le parfum de ce baume nettoyant : exotique et fruité. Nettoyer mon visage est devenu un vrai plaisir gourmand. Le parfum est très présent durant l'application mais s'estompe rapidement après le rinçage pour ne pas devenir écœurant sur le long terme. J'ai aussi été séduite par la couleur rose girly du produit. Au niveau de l'efficacité : après deux semaines d'utilisation matin et soir, j'ai une peau confortable, bien hydratée et un teint lumineux. Je n'ai pas remarqué une nette amélioration grâce à ce produit mais pas d'apparition de petits boutons non plus. Pas de point négatif pour ce produit. Si ce n'est que le contenant en pot n'est pas très adapté à une utilisation quotidienne parfois sous la douche. Un flacon pompe serait beaucoup plus pratique. J'imagine que le rose du baume n'est pas le fruit de colorant 100% naturel.
Lire plus
Charlotte
Parfum gourmand
Texture très agréable à étaler et parfum gourmand.
Lire plus
Barbara
Peau collante !
Cette crème a une très bonne texture. Elle est onctueuse, avec un très bel aspect et une très belle couleur. L'odeur est trop faible et peu féminine. Je n'ai pas trouvé le produit très efficace, ma peau n'est pas douce mais plutôt collante.
Lire plus
Coralie
Efficace, moins d'imperfections
L'effet huile associée à l'eau donne une autre texture. C'est très agréable, efficace, et ma peau a moins d'imperfections.
Lire plus
Ophellia
Agréable, facile à appliquer...
L'odeur et la texture sont agréables, il est facile à appliquer, j'ai vraiment aimé ce produit.
Lire plus
Marie - Sophie
les résultats sur la peau sont rapides
Ce baume en gel nettoie bien, il laisse la peau très douce et sent bon. Il rend la peau très nette, son efficacité est très bonne et les résultats sur la peau sont rapides. Ce qui est bien c'est ce que ce baume a plusieurs actions, le fait que ce soit une huile rend la peau agréable.
Lire plus
Mina
L'efficacité du produit est top.
L'odeur est très agréable, elle me fait penser à quelque chose de frais, de sain et de naturel. L'utilisation du produit est facile et laisse une peau extrêmement douce. L'efficacité du produit est top. La texture demande une application soignée et parfois le matin ce n'est pas pratique car je n'ai pas le temps. Lorsque le produit mousse, il commence à couler, ça en met de partout donc le plus simple ce serait d'être dans sa douche pour l'utiliser.
Lire plus
Célia
ma peau est plus lumineuse
La texture est ultra agréable, le parfum merveilleux, utiliser ce baume est un vrai moment de détente. Très efficace, ma peau est moins grasse, plus lumineuse, et beaucoup plus belle depuis que je l'utilise. Le produit est parfois un peu difficile à doser.
Lire plus
Fatima
excellente découverte
C'est une excellente découverte. Ce produit est agréable à utiliser. C'est devenu un rituel que je n'oublie pas tellement j'ai aimé ce produit.
Lire plus
Faustine
bon nettoyant
Point très important, le gel se rince très facilement. J'ai une peau réactive qui tolère très peu de cosmétiques. Avec le gel, ma peau est nettoyée et nette. Je ne brille pas et je peux mettre ma crème de soin après sans soucis. Il nettoie bien la peau. L'utilisation du produit n'est pas pratique, on ne peut pas l'utiliser sous la douche, vu qu'on a déjà le visage et les mains mouillées. Il ne mousse pas assez à mon goût quand on l'humidifie pour le retravailler, du coup on ne sait pas si on a mis assez d'eau. Je trouve la texture baume du début fort épaisse pour un nettoyant.
Lire plus
Valérie
Peau douce toute la journée
Il laisse la peau douce toute la journée. Je trouve qu'il manque juste un peu de senteur.
Lire plus
Chloé
belle couleur mais film gras
Ce produit a une belle couleur, une odeur agréable et le changement de texture est original. J'ai une sensation de peau pas assez lavée et de film gras sur la peau.
Lire plus
Séverine
Peau bien nettoyée et hydratée
La texture collante est spéciale au début, je n'ai pas l'habitude de ce genre de baume. Facile à nettoyer, il rend la peau bien nettoyée et très bien hydratée. Il est très simple à appliquer et la couleur donne envie de l'utiliser. J'ai trouvé que l'odeur de fruit n'est pas assez présente.
Lire plus
Sarah
Agréable
Il a une très bonne texture. C'est un très bon concept. La texture est agréable sur la peau. Il laisse après rinçage un petit film huileux très agréable pour les peaux de nature sèche et laisse une peau douce. Il a aussi une jolie couleur. C'est un bon produit en général. L'odeur est assez faible.
Lire plus
Marion
Original
Il nettoie bien la peau. La texture et la couleur sont originales.
Lire plus
Marie
Très ludique
Ce produit est ludique à utiliser, il sent très bon et est efficace. Aucune remarque négative.
Lire plus
Mélissa
facile à appliquer
Il est facile à appliquer, l'odeur est agréable, il nettoie en douceur et laisse un film protecteur quand on a la peau sèche et facilement irritable.
Lire plus
Julie
Ma peau est plus belle
J'ai vraiment apprécié ce produit, j'ai apprécié les différentes textures qui apparaissent au fur et à mesure de l'application. Ma peau est beaucoup plus belle, moins terne, plus lumineuse, je trouve que j'ai moins d'imperfections. Ma peau est hydratée également. Son parfum est agréable même s'il n'est pas très marqué.
Lire plus
Chahra
Bon nettoyant
Le parfum est très agréable, il fait bien son rôle de nettoyant.
Lire plus
Hadjira
peau douce !
La texture est agréable, il a rendu ma peau douce. On n'a pas besoin d'utiliser beaucoup de produit car la deuxième étape avec l'eau le transforme en lotion. Le parfum est trop léger.
Lire plus
Angélique
Agréable
L'odeur est discrète et agréable, facile d'emploi, bonne texture, agréable sur la peau et bel aspect.
Lire plus
Amélie
Texture et odeur agréables
La texture et l'odeur sont agréables. Le produit est efficace. La couleur est trop intense.
Lire plus
Donnez votre avis !
Rose Papaya

Rose Papaya

Trésor du monde®

Ce gel-baume nettoyant illuminateur nettoie quotidiennement les pores en éliminant l'excès de sébum, les peaux mortes et la pollution, tout en maintenant l'hydratation de la peau. Le grain de peau est affiné et la peau saine et lumineuse.

Composé sans détergent et sans parfum synthétique, Rose Papaya fond sur la peau grâce à sa délicieuse texture gel et s’émulsionne au contact de l’eau. Les sucres naturels présents dans ce gel éliminent les impuretés tandis que les enzymes de papaye, mangue et grenade exfolient et que l’aloe vera calme et apaise la peau.


Ce produit est sans paraben, sans huiles minérales, sans tricosan, EDTA, sans huile de palme, sans PEG, sans phtalates, sans OGM, sans alcool, sans gluten, sans parfum, ni colorant de synthèse. Il est composé d’actifs de qualité comprenant des nutriments et des vitamines que la peau reconnaît naturellement. 

       

        

Voir l'attestation de confiance
  • Pour plus d'informations sur les caractéristiques du contrôle des avis et la possibilité de contacter l'auteur de l'avis, merci de consulter nos CGU.
  • Aucune contrepartie n'a été fournie en échange des avis
  • Les avis sont publiés et conservés pendant une durée de cinq ans
  • Les avis ne sont pas modifiables : si un client souhaite modifier son avis, il doit contacter Avis Verifiés afin de supprimer l'avis existant, et en publier un nouveau
  • Les motifs de suppression des avis sont disponibles ici.

5 /5

Calculé à partir de 9 avis client(s)

  • 1
    0
  • 2
    0
  • 3
    0
  • 4
    0
  • 5
    9
Trier l'affichage des avis :

Melody M. publié le 28/12/2021 suite à une commande du 01/12/2021

5/5

Chaque détail est magnifique : le packaging, les couleurs, le flacon, la texture ! La senteur est très douce et agréable. L'application sur la peau est incroyable. J'adore ce produit.

Commentaire de Mawena le 27/12/2021
Chère cliente, merci de votre retour. Votre avis nous est précieux. Cordialement

Cet avis vous a-t-il été utile ? Oui 0 Non 0

Aurelia L. publié le 19/06/2021 suite à une commande du 09/04/2021

5/5

3e fois que je l'achète. Le gel est enveloppant, laisse la peau hydratée et satinée. Je l'ai offert à ma mère, peu prompte à prendre soin d'elle, elle apprécie énormément le produit et j'ai constaté un effet sur le teint : éclairci et unifié, et sur la qualité de sa peau: repulpée.

Commentaire de Mawena le 18/06/2021
Bonjour,Nous sommes ravies que vous et votre maman ayez trouvées votre bonheur à travers notre soin !Cordialement

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Fabienne R. publié le 31/05/2021 suite à une commande du 28/04/2021

5/5

un produit divin pour nettoyez et nourrir sa peau sans l'agresser

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Aurelia L. publié le 08/04/2021 suite à une commande du 18/03/2021

5/5

Produit incroyable: peau réellement lumineuse après utilisation, la peau ne tire pas, edt déjà hydratée. Très agréable à utiliser. Ma mère, pas friande de cosmétique, l'a adopté ! C'est un de mes basiques, dorénavant.

Commentaire de Mawena le 07/04/2021
Bonjour, Nous sommes ravis que ce soin vous apporte entière satisfaction. Notre ambition est d'apporter des rituels de beauté efficaces et sains à nos clients. Merci de votre confiance !

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Hibi M. publié le 16/01/2021 suite à une commande du 29/12/2020

5/5

Peau mixte et sèche en hiver, sensation très agréable et ma bien nourrit après application + un teint lumineux ..

Cet avis vous a-t-il été utile ? Oui 0 Non 0

Martha M. publié le 11/01/2021 suite à une commande du 12/12/2020

5/5

J'utilise cette huile en soin du soir 1 à 2 gouttes suffisent pour l'ensemble de mon visage et du cou. Une peau douce et soyeuse à l'application, au réveil je trouve que ma peau est lumineuse. l'odeur est très agréable Je me hate de prendre le rose bambou .

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Tugay O. publié le 02/01/2021 suite à une commande du 12/12/2020

5/5

adapté à ma peau sèche à tendance acnéique

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Anonymous A. publié le 22/11/2020 suite à une commande du 07/10/2020

5/5

Très bien, conforme à mes attentes, je recommande !

Cet avis vous a-t-il été utile ? Oui 1 Non 0

Anonymous A. publié le 04/11/2020 suite à une commande du 03/10/2020

5/5

J'ai découvert ce produit il y a très peu de temps et vraiment fan! Simple d'utilisation, il sent bon et redonne de l'éclat à la peau. Produit au top !

Cet avis vous a-t-il été utile ? Oui 3 Non 0

Questions
  • Livraison offerte à partir de 60 € d’achat
  • Paiement sécurisé Visa, Mastercard, SSL
  • Soins certifiés bio Une question ? Appelez nos beauty trotters au 01 84 25 73 88

Complétez votre routine beauté

Nous vous recommandons ces soins en complément de Rose Papaya
Produit ajouté !
Quantité :
Vous avez 0 produits dans votre panier Vous avez 1 produit dans votre panier
Continuer mes achats Commander
Attention votre site passe par un
firewall applicatif. IP : 18.205.56.183
Configuration Information
  • Votre ip réel | 18.205.56.183
  • Controller | ProductController
  • Shop Name | mawena
  • Shop ID | 1
  • Theme | theme_nq
  • Theme Directory | theme_nq
Performance parameters
  • Smarty :
  • Cache des templates : Never recompile template files
  • Cache :No
  • Console de débogage : Do not open console
  • Optional features :
  • Combinations :Yes
  • Features :Yes
  • CCC (Combine, Compress and Cache) :
  • Smart cache for CSS :Yes
  • Smart cache for JavaScript :No
  • Minify HTML :Yes
  • Compress inline JavaScript in HTML :Yes
  • Apache optimization :Yes
  • Ciphering :
  • Algorithm : Keep the custom BlowFish class.
  • Caching :
  • Use cache :No
  • Caching system : Memcached
Load time
  • Total : 814ms
  • config: 0ms
  • Controller::init(): 83ms
  • Controller::setMedia(): 3ms
  • Controller::postProcess(): 0ms
  • Controller::initHeader(): 0ms
  • Controller::initContent(): 128ms
  • Controller::initFooter(): 83ms
  • Controller::display(): 516ms
Memory peak usage
  • Total : 46.14 Mb
  • config: -0 Mb
  • Controller::init(): 14.62 Mb
  • Controller::setMedia(): 0.27 Mb
  • Controller::postProcess(): 0 Mb
  • Controller::initHeader(): 0.01 Mb
  • Controller::initContent(): 14.08 Mb
  • Controller::initFooter(): 1.15 Mb
  • Controller::display(): 1.88 Mb
Size of included files (293 files)
  • Total : 6.21Mb
Globals variables
  • Globals (> 1 Ko only) : 1314 Ko
  • _MODULES : ≈ 717.3 Ko
  • _LANG : ≈ 227.7 Ko
  • cookie : ≈ 157.7 Ko
  • customer : ≈ 44 Ko
  • cart : ≈ 30.9 Ko
  • defaultCountry : ≈ 23 Ko
  • default_country : ≈ 23 Ko
  • container : ≈ 21.5 Ko
  • currency : ≈ 19.2 Ko
  • language : ≈ 16.6 Ko
  • _MODULE : ≈ 11.1 Ko
  • _SERVER : ≈ 8.3 Ko
  • NQ_ID : ≈ 6.9 Ko
  • link : ≈ 1.9 Ko
SQL Queries : 170 queries  |  Time spent querying : 76ms
Stopwatch (with SQL_NO_CACHE)

30.527 ms INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('?', '?', '?', '', '?', '?', '?-?-? ?:?:?')
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/Connection.php (line 158)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

29.062 ms INSERT INTO `ps_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 ('?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '?', '', '?')
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 445)
  • from /classes/Guest.php (line 193)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /modules/statsdata/statsdata.php (line 80)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.855 ms SELECT 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 `ps_configuration` c LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
  • in /home/www/mawena.com/www/classes/Configuration.php (line 148)
  • from /classes/Configuration.php (line 148)
  • from /classes/Configuration.php (line 185)
  • from /config/settings_custom.inc.php (line 34)
  • from /config/config.inc.php (line 70)
  • from /index.php (line 27)

0.477 ms SELECT SQL_NO_CACHE `id_guest` FROM `ps_connections` WHERE `id_guest` = ? AND `date_add` > '?-?-? ?:?:?' AND id_shop IN (?) ORDER BY `date_add` DESC LIMIT ?
  • in /home/www/mawena.com/www/classes/Connection.php (line 138)
  • from /classes/Connection.php (line 138)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.333 ms SELECT cl.*,c.*, cl.`name` country, z.`name` zone FROM `ps_country` c INNER JOIN ps_country_shop country_shop ON (country_shop.id_country = c.id_country AND country_shop.id_shop = ?) LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = ?) LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`) WHERE ? ORDER BY cl.name ASC
  • in /home/www/mawena.com/www/classes/Country.php (line 131)
  • from /classes/Country.php (line 131)
  • from /modules/blocknewsletter/blocknewsletter.php (line 74)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.331 ms SELECT h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = ? AND module_shop.enable_device & ?) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = ?) AND (mg.`id_shop` = ? AND mg.`id_group` IN (?)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`
  • in /home/www/mawena.com/www/classes/Hook.php (line 355)
  • from /classes/Hook.php (line 355)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.318 ms SELECT h.id_hook, h.name as h_name, title, description, h.position, live_edit, hm.position as hm_position, m.id_module, m.name, active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = ?) STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position
  • in /home/www/mawena.com/www/classes/Hook.php (line 236)
  • from /classes/Hook.php (line 236)
  • from /classes/Hook.php (line 275)
  • from /classes/tax/TaxManagerFactory.php (line 67)
  • from /classes/tax/TaxManagerFactory.php (line 46)
  • from /classes/Product.php (line 5052)
  • from /classes/Product.php (line 492)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.243 ms SELECT p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, ?) 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, ?) id_product_attribute, DATEDIFF( p.`date_add`, DATE_SUB( "?-?-? ?:?:?", INTERVAL ? DAY ) ) > ? AS new FROM `ps_accessory` LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_?` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = ? AND product_attribute_shop.id_shop=?) LEFT JOIN `ps_product_lang` pl ON ( p.`id_product` = pl.`id_product` AND pl.`id_lang` = ? AND pl.id_shop = ? ) LEFT JOIN `ps_category_lang` cl ON ( product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=? AND image_shop.id_shop=?) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = ?) LEFT JOIN `ps_manufacturer` m ON (p.`id_manufacturer`= m.`id_manufacturer`) LEFT JOIN ps_stock_available stock ON (stock.id_product = p.id_product AND stock.id_product_attribute = ? AND stock.id_shop = ? AND stock.id_shop_group = ? ) WHERE `id_product_?` = ? AND product_shop.`active` = ? AND product_shop.`visibility` != 'none' GROUP BY product_shop.id_product LIMIT ?
  • in /home/www/mawena.com/www/override/classes/Product.php (line 334)
  • from /override/classes/Product.php (line 334)
  • from /controllers/front/ProductController.php (line 253)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.225 ms SELECT * FROM `ps_state` ORDER BY `name` ASC
  • in /home/www/mawena.com/www/classes/Country.php (line 137)
  • from /classes/Country.php (line 137)
  • from /modules/blocknewsletter/blocknewsletter.php (line 74)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.217 ms SELECT `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name
  • in /home/www/mawena.com/www/classes/Hook.php (line 131)
  • from /classes/Hook.php (line 131)
  • from /override/classes/Hook.php (line 50)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.202 ms SELECT s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM ps_shop_url su LEFT JOIN ps_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'www.mawena.com' OR su.domain_ssl = 'www.mawena.com') AND s.active = ? AND s.deleted = ? ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
  • in /home/www/mawena.com/www/classes/shop/Shop.php (line 334)
  • from /classes/shop/Shop.php (line 334)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.183 ms SELECT 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 ps_shop_group gs LEFT JOIN ps_shop s ON s.id_shop_group = gs.id_shop_group LEFT JOIN ps_shop_url su ON s.id_shop = su.id_shop AND su.main = ? WHERE s.deleted = ? AND gs.deleted = ? ORDER BY gs.name, s.name
  • in /home/www/mawena.com/www/classes/shop/Shop.php (line 670)
  • from /classes/shop/Shop.php (line 670)
  • from /classes/shop/Shop.php (line 724)
  • from /classes/Configuration.php (line 244)
  • from /classes/shop/Shop.php (line 369)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.171 ms SELECT value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT ?
  • in /home/www/mawena.com/www/classes/shop/Shop.php (line 1074)
  • from /classes/shop/Shop.php (line 1074)
  • from /classes/shop/Shop.php (line 952)
  • from /classes/Configuration.php (line 192)
  • from /config/settings_custom.inc.php (line 34)
  • from /config/config.inc.php (line 70)
  • from /index.php (line 27)

0.159 ms SELECT `name`, `meta_title`, `meta_description`, `meta_keywords`, `description_short` FROM `ps_product` p LEFT JOIN `ps_product_lang` pl ON (pl.`id_product` = p.`id_product` AND pl.id_shop = ? ) INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE pl.id_lang = ? AND pl.id_product = ? AND product_shop.active = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Meta.php (line 259)
  • from /classes/Meta.php (line 259)
  • from /classes/Meta.php (line 207)
  • from /classes/controller/FrontController.php (line 393)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.157 ms SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = ? LIMIT ? ) as mshop FROM `ps_module` m
  • in /home/www/mawena.com/www/classes/module/Module.php (line 277)
  • from /classes/module/Module.php (line 277)
  • from /modules/nq_cache/nq_cache.php (line 14)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 60)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.153 ms SELECT * FROM `ps_country` a LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = ? LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = ? WHERE (a.`id_country` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /config/config.inc.php (line 142)
  • from /index.php (line 27)

0.151 ms SELECT 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, ?) 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 `ps_product_attribute` pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) LEFT JOIN ps_stock_available stock ON (stock.id_product = pa.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, ?) AND stock.id_shop = ? AND stock.id_shop_group = ? ) LEFT JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_attribute_group` ag ON (ag.`id_attribute_group` = a.`id_attribute_group`) LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute`) LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group`) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = ?) WHERE pa.`id_product` = ? AND al.`id_lang` = ? AND agl.`id_lang` = ? GROUP BY id_attribute_group, id_product_attribute ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
  • in /home/www/mawena.com/www/classes/Product.php (line 3513)
  • from /classes/Product.php (line 3513)
  • from /controllers/front/ProductController.php (line 428)
  • from /controllers/front/ProductController.php (line 237)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.146 ms SELECT m.page, ml.url_rewrite, ml.id_lang FROM `ps_meta` m LEFT JOIN `ps_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = ? ) ORDER BY LENGTH(ml.url_rewrite) DESC
  • in /home/www/mawena.com/www/classes/Dispatcher.php (line 452)
  • from /classes/Dispatcher.php (line 452)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.144 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "nq_cache" LIMIT ?
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2195)
  • from /tools/newquest/developertoolbar/classes/NQTools.php (line 128)
  • from /tools/newquest/developertoolbar/classes/NQDisplay.php (line 75)
  • from /override/classes/controller/Controller.php (line 98)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.141 ms SELECT * FROM `ps_hook_alias`
  • in /home/www/mawena.com/www/classes/Hook.php (line 187)
  • from /classes/Hook.php (line 187)
  • from /classes/Hook.php (line 209)
  • from /classes/Hook.php (line 381)
  • from /override/classes/Hook.php (line 46)
  • from /classes/Dispatcher.php (line 407)
  • from /classes/Dispatcher.php (line 228)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.141 ms SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` = ? AND `id_customer` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 419)
  • from /classes/SpecificPrice.php (line 419)
  • from /controllers/front/ProductController.php (line 335)
  • from /controllers/front/ProductController.php (line 232)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.139 ms SELECT IFNULL(left_column, default_left_column) as left_column, IFNULL(right_column, default_right_column) as right_column FROM ps_theme t LEFT JOIN ps_theme_meta tm ON (t.id_theme = tm.id_theme) LEFT JOIN ps_meta m ON (m.id_meta = tm.id_meta) WHERE t.id_theme =? AND m.page = "product" LIMIT ?
  • in /home/www/mawena.com/www/classes/Theme.php (line 275)
  • from /classes/Theme.php (line 275)
  • from /classes/controller/FrontController.php (line 147)
  • from /classes/controller/Controller.php (line 134)
  • from /classes/Dispatcher.php (line 359)
  • from /index.php (line 28)

0.138 ms SELECT COUNT(DISTINCT l.id_lang) FROM `ps_lang` l JOIN ps_lang_shop lang_shop ON (lang_shop.id_lang = l.id_lang AND lang_shop.id_shop = ?) WHERE l.`active` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Language.php (line 894)
  • from /classes/Language.php (line 894)
  • from /classes/Language.php (line 992)
  • from /classes/Dispatcher.php (line 391)
  • from /classes/Dispatcher.php (line 217)
  • from /classes/Dispatcher.php (line 193)
  • from /index.php (line 28)

0.138 ms SELECT * FROM `ps_lang` a LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = ? WHERE (a.`id_lang` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Language.php (line 90)
  • from /config/config.inc.php (line 195)
  • from /index.php (line 27)

0.136 ms SELECT * FROM `ps_shop` a WHERE (a.`id_shop` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/shop/Shop.php (line 131)
  • from /classes/shop/Shop.php (line 397)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.136 ms SELECT * FROM `ps_shop_group` a WHERE (a.`id_shop_group` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/shop/Shop.php (line 525)
  • from /config/config.inc.php (line 166)
  • from /index.php (line 27)

0.132 ms SELECT l.*, ls.`id_shop` FROM `ps_lang` l LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
  • in /home/www/mawena.com/www/classes/Language.php (line 777)
  • from /classes/Language.php (line 777)
  • from /config/config.inc.php (line 139)
  • from /index.php (line 27)

0.131 ms SELECT * FROM `ps_theme` a WHERE (a.`id_theme` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /config/config.inc.php (line 115)
  • from /index.php (line 27)

0.129 ms SELECT pc.`id_product_comment`, pcg.`grade`, pccl.`name`, pcc.`id_product_comment_criterion` FROM `ps_product_comment` pc LEFT JOIN `ps_product_comment_grade` pcg ON (pcg.`id_product_comment` = pc.`id_product_comment`) LEFT JOIN `ps_product_comment_criterion` pcc ON (pcc.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pccl.`id_product_comment_criterion` = pcg.`id_product_comment_criterion`) WHERE pc.`id_product` = ? AND pccl.`id_lang` = ? AND pc.`validate` = ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 180)
  • from /modules/productcomments/ProductComment.php (line 180)
  • from /modules/productcomments/ProductComment.php (line 215)
  • from /override/modules/productcomments/productcomments.php (line 19)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 279)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.128 ms SELECT * FROM `ps_currency` c INNER JOIN ps_currency_shop currency_shop ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = ?) WHERE `deleted` = ? AND c.`active` = ? ORDER BY `name` ASC
  • in /home/www/mawena.com/www/classes/Currency.php (line 231)
  • from /classes/Currency.php (line 231)
  • from /classes/controller/FrontController.php (line 453)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.126 ms SELECT * FROM `ps_currency` a LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = ? WHERE (a.`id_currency` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Currency.php (line 103)
  • from /classes/Currency.php (line 451)
  • from /classes/Tools.php (line 615)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.126 ms SELECT * FROM `ps_group` a LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = ? WHERE (a.`id_group` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 338)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.123 ms SELECT domain, domain_ssl FROM ps_shop_url WHERE main = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/shop/ShopUrl.php (line 169)
  • from /classes/shop/ShopUrl.php (line 169)
  • from /classes/shop/ShopUrl.php (line 183)
  • from /classes/Tools.php (line 312)
  • from /classes/Link.php (line 52)
  • from /config/config.inc.php (line 234)
  • from /index.php (line 27)

0.121 ms SELECT p.id_product FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = ?) WHERE p.id_product = ? AND DATEDIFF( product_shop.`date_add`, DATE_SUB( "?-?-? ?:?:?", INTERVAL ? DAY ) ) > ?
  • in /home/www/mawena.com/www/classes/Product.php (line 1278)
  • from /classes/Product.php (line 1278)
  • from /classes/Product.php (line 494)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.119 ms SELECT su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl, t.id_theme, t.name, t.directory FROM ps_shop s LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop) LEFT JOIN ps_theme t ON (t.id_theme = s.id_theme) WHERE s.id_shop = ? AND s.active = ? AND s.deleted = ? AND su.main = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/shop/Shop.php (line 203)
  • from /classes/shop/Shop.php (line 203)
  • from /classes/shop/Shop.php (line 133)
  • from /classes/shop/Shop.php (line 397)
  • from /config/config.inc.php (line 114)
  • from /index.php (line 27)

0.112 ms SELECT c.`id_category`, cl.`name`, cl.`link_rewrite`, category_shop.`id_shop` FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.id_shop = ? ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) WHERE `id_lang` = ? AND c.`id_parent` = ? AND `active` = ? GROUP BY c.`id_category` ORDER BY category_shop.`position` ASC
  • in /home/www/mawena.com/www/classes/Category.php (line 859)
  • from /classes/Category.php (line 859)
  • from /classes/Category.php (line 806)
  • from /controllers/front/ProductController.php (line 615)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.112 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = ? LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Category.php (line 137)
  • from /controllers/front/ProductController.php (line 158)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.112 ms SELECT id_page_type FROM ps_page_type WHERE name = 'product' LIMIT ?
  • in /home/www/mawena.com/www/classes/Page.php (line 97)
  • from /classes/Page.php (line 97)
  • from /classes/Page.php (line 52)
  • from /classes/Connection.php (line 150)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.109 ms SELECT COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != ? LIMIT ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 230)
  • from /classes/SpecificPrice.php (line 283)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.107 ms SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = ?) WHERE i.`id_product` = ? ORDER BY `position`
  • in /home/www/mawena.com/www/classes/Product.php (line 2723)
  • from /classes/Product.php (line 2723)
  • from /controllers/front/ProductController.php (line 375)
  • from /controllers/front/ProductController.php (line 235)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.107 ms SELECT `name` FROM `ps_manufacturer` WHERE `id_manufacturer` = ? AND `active` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Manufacturer.php (line 248)
  • from /classes/Manufacturer.php (line 248)
  • from /classes/Product.php (line 485)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.106 ms SELECT id_shop FROM `ps_lang_shop` WHERE `id_lang` = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Tools.php (line 499)
  • from /classes/controller/FrontController.php (line 241)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.106 ms SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = ? AND cl.id_shop = ? AND cl.`id_category` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Category.php (line 1054)
  • from /classes/Category.php (line 1054)
  • from /classes/Product.php (line 509)
  • from /classes/Link.php (line 104)
  • from /override/classes/Link.php (line 92)
  • from /classes/Link.php (line 586)
  • from /classes/controller/FrontController.php (line 469)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.104 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "netreviews" LIMIT ?
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2195)
  • from /modules/netreviews/netreviews.php (line 60)
  • from (line undefined)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 124)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 157)
  • from /Core/Foundation/IoC/Core_Foundation_IoC_Container.php (line 170)
  • from /Adapter/Adapter_ServiceLocator.php (line 52)
  • from /classes/module/Module.php (line 1142)
  • from /classes/module/Module.php (line 1107)
  • from /override/classes/Hook.php (line 156)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.103 ms SELECT `id_product` FROM `ps_giftcardproduct`
  • in /home/www/mawena.com/www/modules/giftcard/models/GiftCardProduct.php (line 413)
  • from /modules/giftcard/models/GiftCardProduct.php (line 413)
  • from /modules/giftcard/models/GiftCardProduct.php (line 431)
  • from /modules/giftcard/giftcard.php (line 545)
  • from /override/classes/Link.php (line 49)
  • from /classes/Link.php (line 586)
  • from /classes/controller/FrontController.php (line 469)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.102 ms SELECT `name` FROM `ps_supplier` WHERE `id_supplier` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Supplier.php (line 192)
  • from /classes/Supplier.php (line 192)
  • from /classes/Product.php (line 486)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.102 ms SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Category.php (line 137)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 33)
  • from /modules/blocktopmenu/blocktopmenu.php (line 480)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 15)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.101 ms SELECT t.`id_lang`, t.`name` FROM ps_tag t LEFT JOIN ps_product_tag pt ON (pt.id_tag = t.id_tag) WHERE pt.`id_product`=?
  • in /home/www/mawena.com/www/classes/Tag.php (line 205)
  • from /classes/Tag.php (line 205)
  • from /classes/Product.php (line 502)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.101 ms SELECT UNIX_TIMESTAMP(last_flush) as last_flush FROM `ps_smarty_last_flush` WHERE type='compile' LIMIT ?
  • in /home/www/mawena.com/www/classes/SmartyCustom.php (line 95)
  • from /classes/SmartyCustom.php (line 95)
  • from /classes/SmartyCustom.php (line 118)
  • from /classes/module/Module.php (line 2335)
  • from /classes/module/Module.php (line 2309)
  • from /modules/nq_social/nq_social.php (line 269)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.099 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'cart_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.099 ms SELECT * FROM `ps_tax` a WHERE (a.`id_tax` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/tax/TaxRulesTaxManager.php (line 115)
  • from /classes/Product.php (line 5053)
  • from /classes/Product.php (line 492)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.099 ms SELECT pc.`id_product_comment`, (SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment` AND pcu.`usefulness` = ?) as total_useful, (SELECT count(*) FROM `ps_product_comment_usefulness` pcu WHERE pcu.`id_product_comment` = pc.`id_product_comment`) as total_advice, IF(c.id_customer, CONCAT(c.`firstname`, ' ', LEFT(c.`lastname`, ?)), pc.customer_name) customer_name, pc.`content`, pc.`grade`, pc.`date_add`, pc.title FROM `ps_product_comment` pc LEFT JOIN `ps_customer` c ON c.`id_customer` = pc.`id_customer` WHERE pc.`id_product` = ? AND pc.`validate` = ? ORDER BY pc.`date_add` DESC
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 126)
  • from /modules/productcomments/ProductComment.php (line 126)
  • from /modules/productcomments/productcomments.php (line 747)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 278)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.094 ms SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` = ? AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 362)
  • from /classes/SpecificPrice.php (line 362)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.094 ms SELECT * FROM ps_av_products_average WHERE ref_product = ? and iso_lang = '?' and id_shop IN(?,?) LIMIT ?
  • in /home/www/mawena.com/www/modules/netreviews/NetReviewsModel.php (line 126)
  • from /modules/netreviews/NetReviewsModel.php (line 126)
  • from /modules/netreviews/netreviews.php (line 1568)
  • from /modules/netreviews/netreviews.php (line 1689)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.092 ms SELECT c.*, cl.* FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) LEFT JOIN `ps_category_lang` cl ON c.`id_category` = cl.`id_category` AND cl.id_shop = ? LEFT JOIN `ps_category_group` cg ON c.`id_category` = cg.`id_category` RIGHT JOIN `ps_category` c? ON c?.`id_category` = ? AND c.`nleft` >= c?.`nleft` AND c.`nright` <= c?.`nright` WHERE ? AND `id_lang` = ? AND cg.`id_group` IN (?) GROUP BY c.`id_category` ORDER BY c.`level_depth` ASC , category_shop.`position` ASC
  • in /home/www/mawena.com/www/classes/Category.php (line 585)
  • from /classes/Category.php (line 585)
  • from /modules/blocktopmenu/blocktopmenu.php (line 480)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 15)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.092 ms SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = ? LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = ? WHERE (a.`id_product` = ?) AND (b.`id_shop` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Product.php (line 477)
  • from /classes/Link.php (line 104)
  • from /override/classes/Link.php (line 92)
  • from /classes/Link.php (line 586)
  • from /classes/controller/FrontController.php (line 469)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.09 ms SELECT pcc.`id_product_comment_criterion`, pccl.`name` FROM `ps_product_comment_criterion` pcc LEFT JOIN `ps_product_comment_criterion_lang` pccl ON (pcc.id_product_comment_criterion = pccl.id_product_comment_criterion) LEFT JOIN `ps_product_comment_criterion_product` pccp ON (pcc.`id_product_comment_criterion` = pccp.`id_product_comment_criterion` AND pccp.`id_product` = ?) LEFT JOIN `ps_product_comment_criterion_category` pccc ON (pcc.`id_product_comment_criterion` = pccc.`id_product_comment_criterion`) LEFT JOIN `ps_product_shop` ps ON (ps.id_category_default = pccc.id_category AND ps.id_product = ?) WHERE pccl.`id_lang` = ? AND ( pccp.id_product IS NOT NULL OR ps.id_product IS NOT NULL OR pcc.id_product_comment_criterion_type = ? ) AND pcc.active = ? GROUP BY pcc.id_product_comment_criterion
  • in /home/www/mawena.com/www/modules/productcomments/ProductCommentCriterion.php (line 184)
  • from /modules/productcomments/ProductCommentCriterion.php (line 184)
  • from /modules/productcomments/productcomments.php (line 795)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.09 ms SELECT id_required_field, object_name, field_name FROM ps_required_field
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1376)
  • from /classes/ObjectModel.php (line 1376)
  • from /classes/ObjectModel.php (line 1387)
  • from /classes/ObjectModel.php (line 999)
  • from /classes/ObjectModel.php (line 914)
  • from /classes/ObjectModel.php (line 246)
  • from /classes/ObjectModel.php (line 487)
  • from /classes/ObjectModel.php (line 445)
  • from /classes/Guest.php (line 193)
  • from /modules/statsdata/statsdata.php (line 104)
  • from /modules/statsdata/statsdata.php (line 80)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.09 ms SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = ? AND tr.`id_country` = ? AND tr.`id_tax_rules_group` = ? AND tr.`id_state` IN (?, ?) AND ('?' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = ? AND tr.`zipcode_from` IN(?, '?'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
  • in /home/www/mawena.com/www/classes/tax/TaxRulesTaxManager.php (line 109)
  • from /classes/tax/TaxRulesTaxManager.php (line 109)
  • from /classes/Product.php (line 5053)
  • from /classes/Product.php (line 492)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.09 ms SELECT DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group` FROM `ps_attribute` a LEFT JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = ?) LEFT JOIN `ps_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = ?) LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = ?) WHERE pa.`id_product` = ?
  • in /home/www/mawena.com/www/classes/Product.php (line 5677)
  • from /classes/Product.php (line 5677)
  • from /controllers/front/ProductController.php (line 568)
  • from /controllers/front/ProductController.php (line 240)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.089 ms SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = ?) WHERE (p.`id_product` = ?)
  • in /home/www/mawena.com/www/classes/Product.php (line 2998)
  • from /classes/Product.php (line 2998)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.088 ms SELECT * FROM `ps_category` a? LEFT JOIN `ps_category_lang` `a?` ON (a?.`id_category` = a?.`id_category`) WHERE (a?.`nleft` < ?) AND (a?.`nright` > ?) AND (a?.`id_lang` = ?)
  • in /home/www/mawena.com/www/classes/PrestaShopCollection.php (line 358)
  • from /classes/PrestaShopCollection.php (line 358)
  • from /classes/PrestaShopCollection.php (line 386)
  • from /override/controllers/front/ProductController.php (line 72)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.084 ms SELECT c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = ? AND cl.id_shop = ? ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = ? AND `active` = ? AND cg.`id_group` =? GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC
  • in /home/www/mawena.com/www/classes/Category.php (line 658)
  • from /classes/Category.php (line 658)
  • from /controllers/front/ProductController.php (line 605)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.084 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blocklayered" LIMIT ?
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2195)
  • from /classes/Product.php (line 5608)
  • from /controllers/front/ProductController.php (line 568)
  • from /controllers/front/ProductController.php (line 240)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.082 ms SELECT * FROM `ps_image_type` WHERE ? ORDER BY `name` ASC
  • in /home/www/mawena.com/www/classes/ImageType.php (line 108)
  • from /classes/ImageType.php (line 108)
  • from /override/classes/controller/FrontController.php (line 120)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.079 ms SELECT * FROM `ps_manufacturer` a LEFT JOIN `ps_manufacturer_lang` `b` ON a.`id_manufacturer` = b.`id_manufacturer` AND b.`id_lang` = ? LEFT JOIN `ps_manufacturer_shop` `c` ON a.`id_manufacturer` = c.`id_manufacturer` AND c.`id_shop` = ? WHERE (a.`id_manufacturer` = ?) LIMIT ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 61)
  • from /Adapter/Adapter_EntityMapper.php (line 61)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Manufacturer.php (line 103)
  • from /controllers/front/ProductController.php (line 268)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.076 ms SELECT DISTINCT la.`id_attribute`, la.`url_name` as `attribute` FROM `ps_attribute` a LEFT JOIN `ps_product_attribute_combination` pac ON (a.`id_attribute` = pac.`id_attribute`) LEFT JOIN `ps_product_attribute` pa ON (pac.`id_product_attribute` = pa.`id_product_attribute`) INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) LEFT JOIN `ps_layered_indexable_attribute_lang_value` la ON (la.`id_attribute` = a.`id_attribute` AND la.`id_lang` = ?) WHERE la.`url_name` IS NOT NULL AND la.`url_name` != '' AND pa.`id_product` = ?
  • in /home/www/mawena.com/www/classes/Product.php (line 5620)
  • from /classes/Product.php (line 5620)
  • from /controllers/front/ProductController.php (line 568)
  • from /controllers/front/ProductController.php (line 240)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.076 ms SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
  • in /home/www/mawena.com/www/override/classes/Product.php (line 282)
  • from /override/classes/Product.php (line 282)
  • from /override/classes/Product.php (line 225)
  • from /classes/Product.php (line 4424)
  • from /override/classes/Product.php (line 342)
  • from /controllers/front/ProductController.php (line 253)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.076 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = ? AND pc.`deleted` = ? AND pc.`validate` = ? LIMIT ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 209)
  • from /modules/productcomments/ProductComment.php (line 209)
  • from /modules/productcomments/productcomments.php (line 781)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.073 ms SELECT id_shop FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /controllers/front/ProductController.php (line 100)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.071 ms SELECT * FROM `ps_product_comment` pc WHERE pc.`id_product` = ? AND pc.`id_customer` = ? ORDER BY pc.`date_add` DESC LIMIT ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 149)
  • from /modules/productcomments/ProductComment.php (line 149)
  • from /modules/productcomments/productcomments.php (line 779)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.069 ms SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 198)
  • from /classes/SpecificPrice.php (line 198)
  • from /classes/SpecificPrice.php (line 176)
  • from /classes/SpecificPrice.php (line 350)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.066 ms SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
  • in /home/www/mawena.com/www/classes/stock/StockAvailable.php (line 380)
  • from /classes/stock/StockAvailable.php (line 380)
  • from /classes/Product.php (line 5869)
  • from /classes/Product.php (line 505)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.065 ms SELECT c.id_category, cl.name, cl.link_rewrite FROM ps_category c LEFT JOIN ps_category_lang cl ON (cl.id_category = c.id_category AND cl.id_shop = ? ) INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = ?) WHERE c.nleft <= ? AND c.nright >= ? AND c.nleft >= ? AND c.nright <= ? AND cl.id_lang = ? AND c.active = ? AND c.level_depth > ? ORDER BY c.level_depth ASC
  • in /home/www/mawena.com/www/override/classes/Tools.php (line 54)
  • from /override/classes/Tools.php (line 54)
  • from /controllers/front/ProductController.php (line 592)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.064 ms SELECT * FROM ps_av_products_reviews WHERE ref_product = '?' and iso_lang = '?' and id_shop IN(?,?) ORDER BY horodate DESC LIMIT ?, ?
  • in /home/www/mawena.com/www/modules/netreviews/NetReviewsModel.php (line 99)
  • from /modules/netreviews/NetReviewsModel.php (line 99)
  • from /modules/netreviews/netreviews.php (line 1572)
  • from /modules/netreviews/netreviews.php (line 1689)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.064 ms SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2218)
  • from /classes/module/Module.php (line 2218)
  • from /classes/Product.php (line 5608)
  • from /controllers/front/ProductController.php (line 568)
  • from /controllers/front/ProductController.php (line 240)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.064 ms SELECT image_shop.`id_image` FROM `ps_image` i INNER JOIN ps_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = ?) WHERE i.`id_product` = ? AND image_shop.`cover` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Product.php (line 2743)
  • from /classes/Product.php (line 2743)
  • from /modules/nq_social/nq_social.php (line 206)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.064 ms SELECT * FROM `ps_hook_module_exceptions` WHERE `id_shop` IN (?)
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2141)
  • from /classes/module/Module.php (line 2141)
  • from /override/classes/Hook.php (line 133)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.064 ms SELECT `id_page` FROM `ps_page` WHERE `id_page_type` = ? AND `id_object` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Page.php (line 77)
  • from /classes/Page.php (line 77)
  • from /classes/Connection.php (line 150)
  • from /classes/Connection.php (line 86)
  • from /modules/statsdata/statsdata.php (line 142)
  • from /modules/statsdata/statsdata.php (line 81)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.062 ms SELECT * FROM ps_product WHERE id_product =? LIMIT ?
  • in /home/www/mawena.com/www/modules/netreviews/NetReviewsModel.php (line 612)
  • from /modules/netreviews/NetReviewsModel.php (line 612)
  • from /modules/netreviews/netreviews.php (line 1615)
  • from /modules/netreviews/netreviews.php (line 1689)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.062 ms SELECT `id_product_download` FROM `ps_product_download` WHERE `id_product` = ? AND `active` = ? ORDER BY `id_product_download` DESC LIMIT ?
  • in /home/www/mawena.com/www/classes/ProductDownload.php (line 184)
  • from /classes/ProductDownload.php (line 184)
  • from /controllers/front/ProductController.php (line 182)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.062 ms SELECT DISTINCT c.* FROM `ps_category` c LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND cl.`id_lang` = ?) WHERE `level_depth` = ?
  • in /home/www/mawena.com/www/classes/Category.php (line 1673)
  • from /classes/Category.php (line 1673)
  • from /classes/Category.php (line 824)
  • from /override/controllers/front/ProductController.php (line 73)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.06 ms SELECT * FROM `ps_currency` WHERE `deleted` = ? AND `id_currency` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Currency.php (line 304)
  • from /classes/Currency.php (line 304)
  • from /modules/nq_social/nq_social.php (line 208)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 579)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.059 ms SELECT * FROM ps_footerlink a JOIN ps_footerlink_lang b ON b.id_footerlink = a.id_footerlink AND id_lang = ? WHERE ? AND active = ? ORDER BY position
  • in /home/www/mawena.com/www/modules/nq_footerlinks/classes/FooterLink.php (line 69)
  • from /modules/nq_footerlinks/classes/FooterLink.php (line 69)
  • from /modules/nq_footerlinks/nq_footerlinks.php (line 133)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.059 ms SELECT id_shop FROM `ps_currency_shop` WHERE `id_currency` = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Tools.php (line 619)
  • from /classes/controller/FrontController.php (line 289)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.058 ms SELECT * FROM `ps_group_lang` WHERE `id_group` = ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Group.php (line 75)
  • from /classes/Group.php (line 338)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.058 ms SELECT ctg.`id_group` FROM `ps_category_product` cp INNER JOIN `ps_category_group` ctg ON (ctg.`id_category` = cp.`id_category`) WHERE cp.`id_product` = ? AND ctg.`id_group` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Product.php (line 4917)
  • from /classes/Product.php (line 4917)
  • from /classes/Product.php (line 4901)
  • from /controllers/front/ProductController.php (line 130)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.055 ms SELECT out_of_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
  • in /home/www/mawena.com/www/classes/stock/StockAvailable.php (line 672)
  • from /classes/stock/StockAvailable.php (line 672)
  • from /classes/Product.php (line 5870)
  • from /classes/Product.php (line 505)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.055 ms SELECT id_shop FROM `ps_group_shop` WHERE `id_group` = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /classes/Group.php (line 341)
  • from /classes/Cart.php (line 184)
  • from /classes/Cart.php (line 179)
  • from /classes/controller/FrontController.php (line 348)
  • from /override/classes/controller/FrontController.php (line 105)
  • from /controllers/front/ProductController.php (line 82)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.055 ms SELECT l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label FROM ps_linksmenutop l LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = ? AND ll.id_shop=?) LEFT JOIN ps_shop s ON l.id_shop = s.id_shop WHERE ? AND l.id_linksmenutop = "?" AND l.id_shop IN (?, ?)
  • in /home/www/mawena.com/www/modules/blocktopmenu/menutoplinks.class.php (line 38)
  • from /modules/blocktopmenu/menutoplinks.class.php (line 38)
  • from /modules/blocktopmenu/menutoplinks.class.php (line 43)
  • from /modules/blocktopmenu/blocktopmenu.php (line 562)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 15)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.054 ms SELECT * FROM ps_footercol a JOIN ps_footercol_lang b ON b.id_footercol = a.id_footercol AND id_lang = ?
  • in /home/www/mawena.com/www/modules/nq_footerlinks/classes/FooterCol.php (line 35)
  • from /modules/nq_footerlinks/classes/FooterCol.php (line 35)
  • from /modules/nq_footerlinks/classes/FooterLink.php (line 52)
  • from /modules/nq_footerlinks/nq_footerlinks.php (line 133)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 1022)
  • from /override/classes/controller/FrontController.php (line 148)
  • from /override/classes/controller/Controller.php (line 72)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.054 ms SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS avg, MIN(pc.`grade`) AS min, MAX(pc.`grade`) AS max FROM `ps_product_comment` pc WHERE pc.`id_product` = ? AND pc.`deleted` = ? AND pc.`validate` = ? LIMIT ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 196)
  • from /modules/productcomments/ProductComment.php (line 196)
  • from /modules/productcomments/productcomments.php (line 798)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.053 ms SELECT depends_on_stock FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
  • in /home/www/mawena.com/www/classes/stock/StockAvailable.php (line 648)
  • from /classes/stock/StockAvailable.php (line 648)
  • from /classes/Product.php (line 5871)
  • from /classes/Product.php (line 505)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.053 ms SELECT * FROM ps_av_products_reviews WHERE ref_product = '?' and iso_lang = '?' and id_shop IN(?,?) ORDER BY horodate DESC
  • in /home/www/mawena.com/www/modules/netreviews/NetReviewsModel.php (line 99)
  • from /modules/netreviews/NetReviewsModel.php (line 99)
  • from /modules/netreviews/netreviews.php (line 1297)
  • from /modules/netreviews/netreviews.php (line 1519)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 279)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.052 ms SELECT ? FROM `ps_specific_price` WHERE `from` BETWEEN '?-?-? ?:?:?' AND '?-?-? ?:?:?' LIMIT ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 302)
  • from /classes/SpecificPrice.php (line 302)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.05 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'category_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.05 ms SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.id_product = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Product.php (line 752)
  • from /classes/Product.php (line 752)
  • from /classes/Product.php (line 2953)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.05 ms SELECT `reduction` FROM `ps_group` WHERE `id_group` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Group.php (line 133)
  • from /classes/Group.php (line 133)
  • from /classes/Product.php (line 3115)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.049 ms SELECT DISTINCT `id_product` FROM `ps_specific_price` WHERE `id_product` != ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 238)
  • from /classes/SpecificPrice.php (line 238)
  • from /classes/SpecificPrice.php (line 283)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.048 ms SELECT * FROM `ps_image_type`
  • in /home/www/mawena.com/www/classes/ImageType.php (line 143)
  • from /classes/ImageType.php (line 143)
  • from /classes/ImageType.php (line 174)
  • from /classes/Category.php (line 660)
  • from /controllers/front/ProductController.php (line 605)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.048 ms SELECT * FROM `ps_tax_lang` WHERE `id_tax` = ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/tax/TaxRulesTaxManager.php (line 115)
  • from /classes/Product.php (line 5053)
  • from /classes/Product.php (line 492)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.048 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'medium_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.048 ms SELECT COUNT(pc.`id_product`) AS nbr FROM `ps_product_comment` pc WHERE `id_product` = ? AND `validate` = ? AND `grade` > ? LIMIT ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 272)
  • from /modules/productcomments/ProductComment.php (line 272)
  • from /modules/productcomments/ProductComment.php (line 216)
  • from /override/modules/productcomments/productcomments.php (line 19)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 279)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.048 ms SELECT ? FROM `ps_specific_price` WHERE `to` BETWEEN '?-?-? ?:?:?' AND '?-?-? ?:?:?' LIMIT ?
  • in /home/www/mawena.com/www/classes/SpecificPrice.php (line 306)
  • from /classes/SpecificPrice.php (line 306)
  • from /classes/SpecificPrice.php (line 348)
  • from /classes/Product.php (line 2973)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.047 ms SELECT * FROM `ps_image_shop` image_shop WHERE image_shop.`id_product` = ? AND image_shop.`cover` = ? LIMIT ?
  • in /home/www/mawena.com/www/override/classes/Image.php (line 66)
  • from /override/classes/Image.php (line 66)
  • from /modules/netreviews/NetReviewsModel.php (line 645)
  • from /modules/netreviews/netreviews.php (line 1616)
  • from /modules/netreviews/netreviews.php (line 1689)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 245)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.047 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'scene_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.046 ms SELECT `id_module` FROM `ps_module` WHERE `name` = "blockcategories" LIMIT ?
  • in /home/www/mawena.com/www/classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2568)
  • from /classes/module/Module.php (line 2195)
  • from /controllers/front/ProductController.php (line 159)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.046 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'prepanier' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.046 ms SELECT * FROM `ps_category_lang` WHERE `id_category` = ? AND `id_shop` = ?
  • in /home/www/mawena.com/www/Adapter/Adapter_EntityMapper.php (line 68)
  • from /Adapter/Adapter_EntityMapper.php (line 68)
  • from /classes/ObjectModel.php (line 233)
  • from /classes/Category.php (line 137)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 33)
  • from /modules/blocktopmenu/blocktopmenu.php (line 480)
  • from /override/modules/blocktopmenu/blocktopmenu.php (line 15)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /classes/controller/FrontController.php (line 580)
  • from /override/classes/controller/FrontController.php (line 130)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.045 ms SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/GroupReduction.php (line 149)
  • from /classes/GroupReduction.php (line 149)
  • from /classes/Product.php (line 3111)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.045 ms SELECT COUNT(`id_product_comment`) AS "nbr" FROM `ps_product_comment` pc WHERE `id_product` = ? AND `validate` = ? LIMIT ?
  • in /home/www/mawena.com/www/modules/productcomments/ProductComment.php (line 251)
  • from /modules/productcomments/ProductComment.php (line 251)
  • from /modules/productcomments/productcomments.php (line 800)
  • from /classes/Hook.php (line 591)
  • from /override/classes/Hook.php (line 243)
  • from /controllers/front/ProductController.php (line 275)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.044 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'home_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.043 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'ingredient' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.043 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'm_scene_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.042 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'large_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.042 ms SELECT id_shop FROM `ps_category_shop` WHERE `id_category` = ? AND id_shop = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/ObjectModel.php (line 1459)
  • from /classes/ObjectModel.php (line 1459)
  • from /controllers/front/ProductController.php (line 591)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.041 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'small_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.041 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'thumbnail_product' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
  • in /home/www/mawena.com/www/classes/Product.php (line 5033)
  • from /classes/Product.php (line 5033)
  • from /classes/Product.php (line 3049)
  • from /classes/Product.php (line 2898)
  • from /override/classes/Product.php (line 465)
  • from /classes/Product.php (line 499)
  • from /controllers/front/ProductController.php (line 85)
  • from /override/controllers/front/ProductController.php (line 67)
  • from /override/classes/controller/Controller.php (line 37)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'thickbox_default' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.04 ms SELECT `width`, `height` FROM ps_image_type WHERE `name` = 'nq_social_share' LIMIT ?
  • in /home/www/mawena.com/www/classes/Image.php (line 472)
  • from /classes/Image.php (line 472)
  • from /override/classes/controller/FrontController.php (line 122)
  • from /controllers/front/ProductController.php (line 172)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.039 ms SELECT pl.sub_name FROM ps_product_lang pl WHERE pl.id_product = ? AND pl.id_lang = ? LIMIT ?
  • in /home/www/mawena.com/www/override/classes/Product.php (line 263)
  • from /override/classes/Product.php (line 263)
  • from /override/classes/Product.php (line 247)
  • from /classes/Product.php (line 4424)
  • from /override/classes/Product.php (line 342)
  • from /controllers/front/ProductController.php (line 253)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)

0.038 ms SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
  • in /home/www/mawena.com/www/classes/Category.php (line 1477)
  • from /classes/Category.php (line 1477)
  • from /classes/Category.php (line 1497)
  • from /controllers/front/ProductController.php (line 591)
  • from /controllers/front/ProductController.php (line 230)
  • from /override/controllers/front/ProductController.php (line 45)
  • from /override/classes/controller/Controller.php (line 64)
  • from /classes/Dispatcher.php (line 367)
  • from /index.php (line 28)
Doubles (IDs replaced by "?")

7 SELECT l.id_linksmenutop, l.new_window, s.name, ll.link, ll.label FROM ps_linksmenutop l LEFT JOIN ps_linksmenutop_lang ll ON (l.id_linksmenutop = ll.id_linksmenutop AND ll.id_lang = ? AND ll.id_shop=?) LEFT JOIN ps_shop s ON l.id_shop = s.id_shop WHERE ? AND l.id_linksmenutop = "?" AND l.id_shop IN (?, ?)
4 SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = ? ORDER BY `id_specific_price_priority` DESC LIMIT ?
4 SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = ?) WHERE pa.id_product = ? LIMIT ?
4 SELECT name, value, pf.id_feature FROM ps_feature_product pf LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = ?) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = ?) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = ?) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = ?) WHERE pf.id_product = ? ORDER BY f.position ASC
4 SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,?) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = ?) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = ?) WHERE (p.`id_product` = ?)
4 SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = ? LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = ? WHERE (a.`id_product` = ?) AND (b.`id_shop` = ?) LIMIT ?
4 SELECT *, ( IF (`id_group` = ?, ?, ?) + IF (`id_country` = ?, ?, ?) + IF (`id_currency` = ?, ?, ?) + IF (`id_shop` = ?, ?, ?) + IF (`id_customer` = ?, ?, ?)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (?, ?) AND `id_currency` IN (?, ?) AND `id_country` IN (?, ?) AND `id_group` IN (?, ?) AND `id_product` = ? AND `id_customer` = ? AND `id_product_attribute` = ? AND `id_cart` = ? AND (`from` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' >= `from`) AND (`to` = '?-?-? ?:?:?' OR '?-?-? ?:?:?' <= `to`) AND IF(`from_quantity` > ?, `from_quantity`, ?) <= ? ORDER BY `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT ?
4 SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = ? AND id_shop=? LIMIT ?
4 SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = ?) AND (id_product_attribute = ?) AND (id_shop = ?) AND (id_shop_group = ?) LIMIT ?
4 SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = ? AND `id_group` = ? LIMIT ?
3 SELECT pl.sub_name FROM ps_product_lang pl WHERE pl.id_product = ? AND pl.id_lang = ? LIMIT ?
3 SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = ? LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = ? WHERE (a.`id_category` = ?) AND (b.`id_shop` = ?) LIMIT ?
3 SELECT m.`id_module`, m.`name`, ( SELECT id_module FROM `ps_module_shop` ms WHERE m.`id_module` = ms.`id_module` AND ms.`id_shop` = ? LIMIT ? ) as mshop FROM `ps_module` m
3 SELECT * FROM ps_av_products_average WHERE ref_product = ? and iso_lang = '?' and id_shop IN(?,?) LIMIT ?
2 SELECT (SUM(pc.`grade`) / COUNT(pc.`grade`)) AS grade FROM `ps_product_comment` pc WHERE pc.`id_product` = ? AND pc.`deleted` = ? AND pc.`validate` = ? LIMIT ?
2 SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = ? AND `id_shop` = ? LIMIT ?
2 SELECT nleft, nright, level_depth FROM ps_category WHERE id_category = ? LIMIT ?
2 SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = ? AND tr.`id_country` = ? AND tr.`id_tax_rules_group` = ? AND tr.`id_state` IN (?, ?) AND ('?' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = ? AND tr.`zipcode_from` IN(?, '?'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
2 SELECT * FROM ps_product WHERE id_product =? LIMIT ?
2 SELECT * FROM ps_av_products_reviews WHERE ref_product = '?' and iso_lang = '?' and id_shop IN(?,?) ORDER BY horodate DESC LIMIT ?, ?
Tables stress

17 product_shop
15 image_type
13 category
13 product
12 category_lang
12 product_attribute_shop
11 shop
9 category_shop
9 specific_price
9 product_lang
9 module
8 stock_available
8 product_comment
7 linksmenutop_lang
7 linksmenutop
7 product_attribute
7 module_shop
4 image_shop
4 product_group_reduction_cache
4 feature_product
4 lang_shop
4 feature_shop
4 shop_url
4 feature
4 feature_value_lang
4 specific_price_priority
4 feature_lang
4 hook
3 attribute
3 av_products_reviews
3 av_products_average
3 product_attribute_combination
3 category_group
3 theme
3 lang
3 currency_shop
3 currency
3 manufacturer
2 attribute_group_lang
2 attribute_shop
2 image_lang
2 hook_alias
2 tax_rules_group
2 hook_module
2 country_lang
2 shop_group
2 product_comment_usefulness
2 product_comment_criterion_lang
2 product_comment_criterion
2 meta
2 country
2 country_shop
2 attribute_lang
2 configuration
2 group_shop
2 tax_rule
2 image
2 group
1 configuration_lang
1 page_type
1 tax
1 tax_lang
1 product_comment_criterion_category
1 page
1 product_comment_criterion_product
1 customer
1 product_comment_grade
1 footerlink
1 required_field
1 footercol_lang
1 footercol
1 connections
1 supplier
1 footerlink_lang
1 manufacturer_lang
1 theme_meta
1 module_group
1 attribute_group
1 product_download
1 smarty_last_flush
1 state
1 meta_lang
1 hook_module_exceptions
1 layered_indexable_attribute_lang_value
1 group_lang
1 zone
1 manufacturer_shop
1 tag
1 product_tag
1 accessory
1 category_product
1 giftcardproduct
Hook processing : 210ms - 15.48Mb - 17 hooks - 24 modules
  • moduleRoutes : 14ms - 1.68Mb
  • prestatemplate: 2ms - 0.14Mb
  • displayHeader : 47ms - 7.18Mb
  • nq_social: 6ms - 0.53Mb
  • blocktopmenu: 3ms - 0.55Mb
  • blockcart: 2ms - 0.27Mb
  • blockuserinfo: 1ms - 0.14Mb
  • paypal: 0ms - 0Mb
  • nq_footerlinks: 2ms - 0.35Mb
  • blockwishlist: 2ms - 0.43Mb
  • productcomments: 3ms - 0.46Mb
  • mailalerts: 3ms - 0.45Mb
  • sendtoafriend: 1ms - 0.15Mb
  • soflexibilite: 0ms - 0Mb
  • blocklayered: 0ms - 0Mb
  • giftcard: 0ms - 0Mb
  • recaptcha: 2ms - 0.19Mb
  • ganalytics: 2ms - 0.36Mb
  • nq_tags: 2ms - 0.22Mb
  • newquest_gdpr: 1ms - 0.22Mb
  • quickpass: 1ms - 0.11Mb
  • blocknewsletter: 4ms - 0.55Mb
  • blockbanner: 1ms - 0.12Mb
  • netreviews: 6ms - 0.87Mb
  • stripe_official: 6ms - 1.2Mb
  • displayTop : 8ms - 0.53Mb
  • pagesnotfound: 1ms - 0.08Mb
  • sekeywords: 2ms - 0.32Mb
  • blocktopmenu: 3ms - 0.08Mb
  • blockwishlist: 1ms - 0.03Mb
  • quickpass: 1ms - 0.03Mb
  • displayLeftColumn : 0ms - 0Mb
  • netreviews: 0ms - 0Mb
  • displayRightColumn : 0ms - 0Mb
  • netreviews: 0ms - 0Mb
  • displayBeforeTop : 5ms - 0.39Mb
  • blockuserinfo: 2ms - 0.09Mb
  • blockcart: 3ms - 0.3Mb
  • displayFooterProduct : 0ms - 0Mb
  • ganalytics: 0ms - 0Mb
  • netreviews: 0ms - 0Mb
  • displayLeftColumnProduct : 0ms - 0Mb
  • netreviews: 0ms - 0Mb
  • displayRightColumnProduct : 9ms - 0.77Mb
  • productcomments: 2ms - 0.26Mb
  • nq_social: 1ms - 0.04Mb
  • sendtoafriend: 2ms - 0.09Mb
  • netreviews: 4ms - 0.39Mb
  • actionProductOutOfStock : 18ms - 2.88Mb
  • mailalerts: 18ms - 2.88Mb
  • displayProductButtons : 1ms - 0.06Mb
  • blockwishlist: 1ms - 0.06Mb
  • netreviews: 0ms - -0Mb
  • displayProductTab : 2ms - 0.15Mb
  • productcomments: 1ms - 0.11Mb
  • netreviews: 1ms - 0.04Mb
  • displayProductTabContent : 23ms - 0.72Mb
  • productcomments: 12ms - 0.35Mb
  • netreviews: 11ms - 0.37Mb
  • displayFooter : 74ms - 0.96Mb
  • nq_footerlinks: 3ms - 0.1Mb
  • statsdata: 65ms - 0.53Mb
  • giftcard: 0ms - 0Mb
  • ganalytics: 0ms - 0Mb
  • nq_tags: 1ms - 0.02Mb
  • newquest_gdpr: 2ms - 0.08Mb
  • blocknewsletter: 2ms - 0.05Mb
  • netreviews: 0ms - -0Mb
  • affilae: 2ms - 0.18Mb
  • displayBottomFooter : 3ms - 0.05Mb
  • nq_social: 3ms - 0.05Mb
  • displayPrePanier : 5ms - 0.09Mb
  • blockcart: 3ms - 0.06Mb
  • nq_social: 3ms - 0.03Mb
  • displayProductPriceBlock : 0ms - 0Mb
  • netreviews: 0ms - 0Mb