Error!

Noisette - 50ml

E liquide - Edition Natural - Noisette - 50ml

Saveur : Noisettes au Végétol.                                                                         

Le E-Liquide Natural Noisette 50ml de l'édition Natural est une noisette authentique torréfiée, légèrement gourmande, sur une base 100% végétale.Une noisette authentique torréfiée, légèrement gourmande. Cet e-liquide Natural NOISETTE de l'édition NATURAL est composé en 50% Végétol et 50% VG, soit en base 100% végétale.

Le Végétol est un substitut du PG, plus sain et moins irritant pour les voies respiratoires.      

Taux de nicotine
  • 00mg
IMPORTANT : Ce produit se commande uniquement par multiples de 6
Error!

Site réservé aux professionnels, connectez-vous pour pouvoir commander et afficher les tarifs.

Se connecter Pas de compte ? Créez-en un
 

Fioles vendues par 6 au format 50ml.

Important : E-liquide surboosté en arômes, optimisé pour 60ml. Les fioles peuvent accueillir jusqu'à 70ml.
Ce e-liquide est vendu sans booster. Il est recommandé pour les gammes au Végétol d'utiliser les boosters Natural sans PG.

---
Prix de vente conseillé : 21.90 €

Curieux présente l’édition NATURAL : une gamme complète de saveurs « all day » composée de18 recettes simplesfabriquées en France formulées avec soin.

C’est une édition qui s’adresse aux vapoteurs à la recherche de e-liquides de qualité supérieure à la composition irréprochable. L’édition Natural, en 18 e-liquides aux saveurs simples et justes, met le Végétol à la portée de toutes les papilles. Vous retrouverez 6 e-liquides Classiques, 3 menthes, 7 fruités et 2 gourmands en 50% Végétol et 50% VG. 

Poids
0.0778
Contenance
50ml
VEGETOL / VG
50/50
Saveurs
Classiques
Type de liquide
Végétol
NAT-NOIS-50-0MG
3760287588710

Vous aimerez aussi

Produit ajouté à vos favoris

En poursuivant votre navigation sur ce site, vous acceptez l’utilisation de cookies

Load Time 381 ms
Querying Time 194 ms
Queries 300
Memory Peak Usage 15.1 Mb
Included Files 1023 files - 12.24 Mb
PrestaShop Cache - Mb
Global vars 0.49 Mb
PrestaShop Version 1.7.8.2
PHP Version 7.4.33
MySQL Version 8.0.30
Memory Limit 512M
Max Execution Time 300s
Smarty Cache enabled
Smarty Compilation auto
  Time Cumulated Time Memory Usage Memory Peak Usage
config 0 ms 0 ms 3.48 Mb 3.9 Mb
__construct 0 ms 0 ms 0.01 Mb 3.9 Mb
init 68 ms 68 ms 3.43 Mb 7.1 Mb
checkAccess 0 ms 68 ms - Mb 7.1 Mb
setMedia 1 ms 69 ms 0.01 Mb 7.1 Mb
postProcess 0 ms 69 ms - Mb 7.1 Mb
initHeader 0 ms 69 ms - Mb 7.1 Mb
initContent 164 ms 233 ms 3.62 Mb 11.0 Mb
initFooter 0 ms 233 ms - Mb 11.0 Mb
display 148 ms 381 ms 4.36 Mb 15.1 Mb
Hook Time Memory Usage
DisplayHeader 18 ms 0.48 Mb
DisplayBeforeBodyClosingTag 12 ms 0.37 Mb
displayReassurance 6 ms 0.08 Mb
displayBeforeBodyClosingTag 5 ms 0.27 Mb
displayProductListFunctionalButtons 3 ms 0.03 Mb
displayFooter 3 ms 0.13 Mb
displayNav2 3 ms 0.10 Mb
Header 3 ms 0.13 Mb
displayProductElementor 3 ms 0.08 Mb
displayNav1 3 ms 0.08 Mb
displayMainMenu 2 ms 0.14 Mb
DisplayProductAdditionalInfo 2 ms 0.04 Mb
Productfooter 1 ms 0.03 Mb
displayCustomerLoginFormAfter 1 ms 0.06 Mb
DisplayFooter 1 ms 0.02 Mb
DisplayFooterProduct 1 ms 0.02 Mb
DisplayTop 0 ms - Mb
ActionOutputHTMLBefore 0 ms - Mb
ActionDispatcher 0 ms - Mb
DisplayCustomerLoginFormAfter 0 ms - Mb
20 hook(s) 67 ms 2.06 Mb
Module Time Memory Usage
iqitthemeeditor 2 ms 0.13 Mb
revsliderprestashop 15 ms 0.49 Mb
iqitcontactpage 2 ms 0.07 Mb
iqitcookielaw 2 ms 0.06 Mb
iqitsociallogin 1 ms 0.08 Mb
chronopost 0 ms 0.07 Mb
ps_emailalerts 0 ms 0.10 Mb
clientlogin 0 ms 0.03 Mb
ps_googleanalytics 3 ms 0.08 Mb
upsmodule 0 ms 0.10 Mb
iqitelementor 3 ms 0.14 Mb
iqitmegamenu 2 ms 0.26 Mb
iqitwishlist 8 ms 0.33 Mb
idxrvalidatinguser 2 ms 0.28 Mb
ohmminqty 7 ms 0.35 Mb
payzen 2 ms 0.15 Mb
recaptcha 0 ms 0.01 Mb
smartsupp 1 ms 0.02 Mb
iqitlinksmanager 4 ms 0.15 Mb
ps_currencyselector 1 ms 0.06 Mb
iqitsearch 0 ms 0.02 Mb
ps_customersignin 0 ms 0.02 Mb
pagesnotfound 1 ms 0.02 Mb
iqitadditionaltabs 6 ms 0.11 Mb
ps_linklist 2 ms 0.08 Mb
statsdata 12 ms 0.39 Mb
xycsvcart 0 ms 0.03 Mb
27 module(s) 79 ms 3.65 Mb

Stopwatch SQL - 300 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop
FROM `ps_configuration` c
LEFT JOIN `ps_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)
6974 ms 1873 /classes/Configuration.php:160
SELECT SQL_NO_CACHE `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
3039 ms 0 /classes/Hook.php:1233
SELECT SQL_NO_CACHE * FROM ps_ohmminqty
1852 ms 550 /modules/ohmminqty/ohmminqty.php:423
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 408
ORDER BY `position`
1507 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 483 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 483 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1316 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE 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` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 31
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
1312 ms 1 Yes /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, 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 = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
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 = 1)
WHERE pa.`id_product` = 483
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1171 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1304 ms 1 Yes Yes /classes/Product.php:4541
SELECT SQL_NO_CACHE * FROM ps_ohmminqty 
WHERE id_product_attribute = 1171 AND id_product = 483 AND id_shop IN (1)
1268 ms 550 /modules/ohmminqty/ohmminqty.php:428
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 483 AND `id_group` = 1 LIMIT 1
1267 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE * FROM ps_ohmminqty 
WHERE id_product_attribute = 1171 AND id_product = 483 AND id_shop IN (1)
1266 ms 550 /modules/ohmminqty/ohmminqty.php:428
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, 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 = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
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 = 1)
WHERE pa.`id_product` = 483
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1171 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1263 ms 1 Yes Yes /classes/Product.php:4541
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductElementor") LIMIT 1
1250 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 483
1232 ms 1 /classes/Product.php:7427
SELECT SQL_NO_CACHE 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 = 1 )
ORDER BY LENGTH(ml.url_rewrite) DESC
1189 ms 70 Yes /classes/Dispatcher.php:643
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayContentWrapperBottom") LIMIT 1
1172 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (151) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
1150 ms 4 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook`
1136 ms 834 /classes/Hook.php:1233
SELECT SQL_NO_CACHE `id_page`
FROM `ps_page`
WHERE `id_page_type` = 4 AND `id_object` = 483 LIMIT 1
1069 ms 1 /classes/Page.php:83
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, 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 = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
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 = 1)
WHERE pa.`id_product` = 483
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
AND product_attribute_shop.`id_product_attribute` = 1171 GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1062 ms 1 Yes Yes /classes/Product.php:4541
SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms
ON m.`id_module` = ms.`id_module`
AND ms.`id_shop` = 1
1056 ms 109 /classes/module/Module.php:340
SELECT SQL_NO_CACHE pa.*, product_attribute_shop.*
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 = 1)
WHERE pa.`id_product` = 408
GROUP BY pa.`id_product_attribute`
ORDER BY pa.`id_product_attribute`
1051 ms 1 Yes Yes /classes/Product.php:2707
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayNavCenter") LIMIT 1
1035 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE ag.`id_attribute_group`, ag.`is_color_group`, agl.`name` AS group_name, agl.`public_name` AS public_group_name,
a.`id_attribute`, al.`name` AS attribute_name, a.`color` AS attribute_color, product_attribute_shop.`id_product_attribute`,
IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.`price`, product_attribute_shop.`ecotax`, product_attribute_shop.`weight`,
product_attribute_shop.`default_on`, pa.`reference`, pa.`ean13`, pa.`mpn`, pa.`upc`, pa.`isbn`, 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 = 1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop_group = 1  AND stock.id_shop = 0  )
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 = 1)
WHERE pa.`id_product` = 483
AND al.`id_lang` = 1
AND agl.`id_lang` = 1
GROUP BY id_attribute_group, id_product_attribute
ORDER BY ag.`position` ASC, a.`position` ASC, agl.`name` ASC
1032 ms 1 Yes Yes /classes/Product.php:4541
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 151 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 151 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
1029 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 483 LIMIT 1
1020 ms 1 /classes/Product.php:1037
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 ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', 'en', '0')
1013 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 1171
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 483 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1171
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 483 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
988 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`id_attribute_group`, al.`name` as `attribute`, agl.`name` as `group`,pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
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 = 1)
INNER JOIN ps_attribute_shop attribute_shop
ON (attribute_shop.id_attribute = pac.id_attribute AND attribute_shop.id_shop = 1)
WHERE pa.`id_product` = 483
975 ms 1 /classes/Product.php:7427
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
968 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 421 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 421 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
957 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 408) LIMIT 1
951 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE c.id_elementor FROM ps_iqit_elementor_product c LEFT JOIN ps_iqit_elementor_product_shop s ON c.id_elementor = s.id_elementor WHERE c.id_product = 483 AND s.id_shop = 1 LIMIT 1
937 ms 1 /modules/iqitelementor/src/IqitElementorProduct.php:74
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 483) AND (b.`id_shop` = 1) LIMIT 1
935 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 1102
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 421 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1102
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 421 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
886 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE COUNT(DISTINCT c.id_currency) FROM `ps_currency` c
LEFT JOIN ps_currency_shop cs ON (cs.id_currency = c.id_currency AND cs.id_shop = 1)
WHERE c.`active` = 1 LIMIT 1
884 ms 2 /classes/Currency.php:1126
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (421) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
876 ms 55 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE *
FROM `ps_category` a
LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1
LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1
WHERE (a.`id_category` = 89) AND (b.`id_shop` = 1) LIMIT 1
873 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 408 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 0
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 408 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
859 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 408) AND (b.`id_shop` = 1) LIMIT 1
844 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE * FROM ps_revslider_sliders
833 ms 1 /modules/revsliderprestashop/includes/revslider_db.class.php:215
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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 = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 483
AND pac.`id_product_attribute` = 1171
AND agl.`id_lang` = 1
832 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE `name`, `alias` FROM `ps_hook_alias`
824 ms 88 /classes/Hook.php:291
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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 = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 421
AND pac.`id_product_attribute` = 1102
AND agl.`id_lang` = 1
811 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterTitle") LIMIT 1
810 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 14 LIMIT 1
795 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
794 ms 1 /classes/Hook.php:1270
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('1942839', '471', '65959298', '', '1', '1', '2024-04-15 16:54:52')
783 ms 1 /classes/ObjectModel.php:578
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 1037
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 408 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 1037
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 408 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
769 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
758 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE 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 = 'pro.curieuxeliquides.com' OR su.domain_ssl = 'pro.curieuxeliquides.com')
AND s.active = 1
AND s.deleted = 0
ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC
754 ms 1 Yes /classes/shop/Shop.php:1350
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (457, 459, 460, 461) AND il.`id_lang` = 1 ORDER by i.`position`
753 ms 4 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 151) AND (b.`id_shop` = 1) LIMIT 1
750 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity,
COALESCE(SUM(first_level_quantity), 0) as quantity
FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity
FROM `ps_cart_product` cp
WHERE cp.`id_product_attribute` = 461
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 151 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
WHERE cp.`id_product_attribute` = 461
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 151 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
744 ms 0 /classes/Cart.php:1429
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAboveProductsTabs") LIMIT 1
737 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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 = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 151
AND pac.`id_product_attribute` = 461
AND agl.`id_lang` = 1
736 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitcookielaw" LIMIT 1
736 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation
FROM `ps_product_attribute_combination` pac
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` AND al.`id_lang` = 1)
LEFT JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pac.id_product_attribute IN (1037)
GROUP BY pac.id_product_attribute
ORDER BY pac.id_product_attribute
736 ms 1 /classes/Product.php:2726
SELECT SQL_NO_CACHE 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 = 1)
WHERE l.`active` = 1 LIMIT 1
735 ms 1 /classes/Language.php:1198
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`, pa.`upc`, pa.`mpn`
FROM `ps_attribute` a
LEFT JOIN `ps_attribute_lang` al
ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = 1)
LEFT JOIN `ps_product_attribute_combination` pac
ON (pac.`id_attribute` = a.`id_attribute`)
LEFT JOIN `ps_product_attribute` pa
ON (pa.`id_product_attribute` = pac.`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 = 1)
LEFT JOIN `ps_attribute_group_lang` agl
ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1)
WHERE pa.`id_product` = 408
AND pac.`id_product_attribute` = 1037
AND agl.`id_lang` = 1
732 ms 1 /classes/Product.php:7398
SELECT SQL_NO_CACHE *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1
WHERE (a.`id_product` = 421) AND (b.`id_shop` = 1) LIMIT 1
732 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_country_lang`
WHERE `id_country` = 8
732 ms 2 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
730 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE i.`id_product` = 151
AND image_shop.`cover` = 1 LIMIT 1
716 ms 5 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
712 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1102) LIMIT 1
706 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_guest`
FROM `ps_connections`
WHERE `id_guest` = 1942839
AND `date_add` > '2024-04-15 16:24:00'
AND id_shop IN (1) 
ORDER BY `date_add` DESC LIMIT 1
688 ms 1 Yes /classes/Connection.php:154
SELECT SQL_NO_CACHE gs.*, s.*, gs.name AS group_name, s.name AS shop_name, s.active, su.domain, su.domain_ssl, su.physical_uri, su.virtual_uri
FROM 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 = 1
WHERE s.deleted = 0
AND gs.deleted = 0
ORDER BY gs.name, s.name
688 ms 1 Yes /classes/shop/Shop.php:711
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
683 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductAdditionalInfo") LIMIT 1
682 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 483
ORDER BY `position`
681 ms 1 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, 0 qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by
FROM `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 = 1)
JOIN `ps_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`)
JOIN `ps_attribute` a ON (a.`id_attribute` = pac.`id_attribute`)
JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1)
JOIN `ps_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`)
WHERE pa.`id_product` IN (408) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
673 ms 1 Yes Yes /classes/Product.php:4479
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 89 LIMIT 1
671 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "overrideMinimalPurchasePrice") LIMIT 1
670 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductVariants") LIMIT 1
670 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 483 LIMIT 1
669 ms 1 /classes/Product.php:1051
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitcontactpage" LIMIT 1
665 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
664 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 151
ORDER BY `position`
662 ms 5 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
660 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderTop") LIMIT 1
659 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiEnd") LIMIT 1
656 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1037) AND il.`id_lang` = 1 ORDER by i.`position`
655 ms 1 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
651 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE format
FROM `ps_address_format`
WHERE `id_country` = 8 LIMIT 1
649 ms 1 /classes/AddressFormat.php:672
SELECT SQL_NO_CACHE 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 = 1)
WHERE i.`id_product` = 408
AND image_shop.`cover` = 1 LIMIT 1
649 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionProductOutOfStock") LIMIT 1
648 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-refresh-addon/revslider-refresh-addon.php' LIMIT 1
642 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 1) LIMIT 1
641 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1)
WHERE i.`id_product` = 421
ORDER BY `position`
641 ms 5 Yes /classes/Product.php:3508
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
639 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_linklist" LIMIT 1
639 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE m.`id_module` as `active`, ms.`id_module` as `shop_active`
FROM `ps_module` m
LEFT JOIN `ps_module_shop` ms ON m.`id_module` = ms.`id_module`
WHERE `name` = "ps_categorytree"
AND ms.`id_shop` IN (1) LIMIT 1
635 ms 1 /src/Adapter/Module/ModuleDataProvider.php:174
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
634 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 0 AND `id_shop` = 1 LIMIT 1
634 ms 0 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE * FROM `ps_hook_module_exceptions`
WHERE `id_shop` IN (1)
633 ms 1 /classes/module/Module.php:2237
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "overrideLayoutTemplate") LIMIT 1
632 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
631 ms 0 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE su.physical_uri, su.virtual_uri, su.domain, su.domain_ssl
FROM ps_shop s
LEFT JOIN ps_shop_url su ON (s.id_shop = su.id_shop)
WHERE s.id_shop = 1
AND s.active = 1 AND s.deleted = 0 AND su.main = 1 LIMIT 1
629 ms 1 /classes/shop/Shop.php:205
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
628 ms 1 /src/Adapter/Module/ModuleDataProvider.php:198
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1102, 1103, 1104, 1105, 1106) AND il.`id_lang` = 1 ORDER by i.`position`
625 ms 5 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterBodyOpeningTag") LIMIT 1
624 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
624 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-duotonefilters-addon/revslider-duotonefilters-addon.php' LIMIT 1
623 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 21) LIMIT 1
623 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 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` = 1
AND tr.`id_country` = 21
AND tr.`id_tax_rules_group` = 0
AND tr.`id_state` IN (0, 0)
AND ('0' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to`
OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '0')))
ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
617 ms 0 /classes/tax/TaxRulesTaxManager.php:109
SELECT SQL_NO_CACHE data
FROM `ps_ganalytics_data`
WHERE id_cart = 0
AND id_shop = 1 LIMIT 1
617 ms 0 /modules/ps_googleanalytics/classes/Repository/GanalyticsDataRepository.php:43
SELECT SQL_NO_CACHE *
FROM `ps_currency_lang`
WHERE `id_currency` = 1
617 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
614 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionPresentCart") LIMIT 1
614 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiBegin") LIMIT 1
611 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderCenter") LIMIT 1
609 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 408 AND `id_shop` = 1
607 ms 1 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1171) LIMIT 1
606 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
605 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-slicey-addon/revslider-slicey-addon.php' LIMIT 1
603 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
602 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 151 LIMIT 1
600 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-polyfold-addon/revslider-polyfold-addon.php' LIMIT 1
599 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE * FROM `ps_image_type` WHERE 1 AND `products` = 1  ORDER BY `width` DESC, `height` DESC, `name`ASC
598 ms 8 Yes /classes/ImageType.php:109
SELECT SQL_NO_CACHE id_page_type
FROM ps_page_type
WHERE name = 'product' LIMIT 1
596 ms 1 /classes/Page.php:104
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 1037) LIMIT 1
595 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayNavFullWidth") LIMIT 1
594 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 89 LIMIT 1
594 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderButtonsMobile") LIMIT 1
589 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
588 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_lang` `b` ON a.`id_country` = b.`id_country` AND b.`id_lang` = 1
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
588 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionDispatcherBefore") LIMIT 1
588 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE value FROM `ps_configuration` WHERE `name` = "PS_MULTISHOP_FEATURE_ACTIVE" LIMIT 1
587 ms 1 /classes/shop/Shop.php:1171
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiEnd") LIMIT 1
586 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE i.`id_product` = 483
AND image_shop.`cover` = 1 LIMIT 1
586 ms 1 /classes/Product.php:3533
SELECT SQL_NO_CACHE name, alias FROM `ps_hook_alias`
586 ms 88 /classes/Hook.php:343
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
585 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
584 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE `need_identification_number`
FROM `ps_country`
WHERE `id_country` = 8 LIMIT 1
581 ms 1 /classes/Country.php:401
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayNav2") LIMIT 1
580 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionFrontControllerSetVariables") LIMIT 1
579 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectConnectionAddBefore") LIMIT 1
578 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-filmstrip-addon/revslider-filmstrip-addon.php' LIMIT 1
578 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 421 LIMIT 1
577 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
576 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE COUNT(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 = 1)
WHERE p.id_product = 483
AND DATEDIFF("2024-04-15 00:00:00", product_shop.`date_add`) < 20 LIMIT 1
575 ms 0 /classes/Product.php:1647
SELECT SQL_NO_CACHE *
FROM `ps_country` a
LEFT JOIN `ps_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = 1
WHERE (a.`id_country` = 8) LIMIT 1
569 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 151 LIMIT 1
568 ms 4 /classes/Product.php:1037
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitadditionaltabs" LIMIT 1
567 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = 1
WHERE (a.`id_product_attribute` = 461) LIMIT 1
567 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
566 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE id_shop
FROM `ps_product_shop`
WHERE `id_product` = 483
AND id_shop = 1 LIMIT 1
562 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_currencyselector" LIMIT 1
561 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectAddAfter") LIMIT 1
561 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiEnd") LIMIT 1
561 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
560 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 1
AND cl.id_shop = 1 
AND cl.`id_category` = 226 LIMIT 1
559 ms 1 /classes/Category.php:1371
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "filterHtmlContent") LIMIT 1
559 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListBelowButton") LIMIT 1
559 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayReassurance") LIMIT 1
554 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductExtraContent") LIMIT 1
553 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterTitleTag") LIMIT 1
553 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderButtons") LIMIT 1
551 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionPresentProduct") LIMIT 1
551 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-bubblemorph-addon/revslider-bubblemorph-addon.php' LIMIT 1
550 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1171) AND il.`id_lang` = 1 ORDER by i.`position`
549 ms 1 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 483 LIMIT 1
548 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
547 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 408 LIMIT 1
547 ms 1 /classes/Product.php:1037
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 421 AND `id_group` = 1 LIMIT 1
545 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
545 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayFooterAfter") LIMIT 1
545 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_currency` a
LEFT JOIN `ps_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = 1
LEFT JOIN `ps_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = 1
WHERE (a.`id_currency` = 2) LIMIT 1
544 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectAddBefore") LIMIT 1
542 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
542 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
540 ms 1 /classes/ObjectModel.php:1510
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
539 ms 1 /classes/shop/ShopUrl.php:182
SELECT SQL_NO_CACHE id_shop
FROM `ps_category_shop`
WHERE `id_category` = 89
AND id_shop = 1 LIMIT 1
538 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiBegin") LIMIT 1
536 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 421 LIMIT 1
536 ms 5 /classes/Product.php:1051
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeader") LIMIT 1
536 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayMainMenu") LIMIT 1
535 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE l.*, ls.`id_shop`
FROM `ps_lang` l
LEFT JOIN `ps_lang_shop` ls ON (l.id_lang = ls.id_lang)
535 ms 1 /classes/Language.php:1049
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 74 AND `id_shop` = 1 LIMIT 1
532 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitelementor" LIMIT 1
530 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionFrontControllerInitAfter") LIMIT 1
529 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE pai.`id_image`, pai.`id_product_attribute`, il.`legend`
FROM `ps_product_attribute_image` pai
LEFT JOIN `ps_image_lang` il ON (il.`id_image` = pai.`id_image`)
LEFT JOIN `ps_image` i ON (i.`id_image` = pai.`id_image`)
WHERE pai.`id_product_attribute` IN (1171) AND il.`id_lang` = 1 ORDER by i.`position`
528 ms 1 Yes /classes/Product.php:2894
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
528 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 151
524 ms 4 /classes/Product.php:2875
SELECT SQL_NO_CACHE 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 = 1)
WHERE i.`id_product` = 421
AND image_shop.`cover` = 1 LIMIT 1
523 ms 5 /classes/Product.php:3533
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListFunctionalButtons") LIMIT 1
521 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_group_lang`
WHERE `id_group` = 1
521 ms 2 /src/Adapter/EntityMapper.php:84
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionDispatcher") LIMIT 1
520 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 89 LIMIT 1
518 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 816 LIMIT 1
518 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE GROUP_CONCAT(a.`id_product_pack`)
FROM `ps_pack` a
WHERE a.`id_product_item` = 483 LIMIT 1
518 ms 1 /classes/Pack.php:409
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayBelowHeader") LIMIT 1
518 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitwishlist" LIMIT 1
517 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 483
516 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE cl.`link_rewrite`
FROM `ps_category_lang` cl
WHERE `id_lang` = 0
AND cl.id_shop = 1 
AND cl.`id_category` = 89 LIMIT 1
515 ms 0 /classes/Category.php:1371
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectAddAfter") LIMIT 1
511 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 13 AND `id_shop` = 1 LIMIT 1
511 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "DisplayOverrideTemplate") LIMIT 1
508 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_product_item, id_product_attribute_item, quantity FROM `ps_pack` where id_product_pack = 483
508 ms 1 /classes/Pack.php:164
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-addons' LIMIT 1
508 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitlinksmanager" LIMIT 1
504 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionBuildFrontEndObject") LIMIT 1
504 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
503 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
503 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectGuestAddBefore") LIMIT 1
503 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "litespeedEsiBegin") LIMIT 1
503 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListBelowButton") LIMIT 1
502 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
502 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayWrapperTop") LIMIT 1
499 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE *
FROM `ps_group` a
LEFT JOIN `ps_group_shop` `c` ON a.`id_group` = c.`id_group` AND c.`id_shop` = 1
WHERE (a.`id_group` = 1) LIMIT 1
496 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE `name`
FROM `ps_hook`
WHERE `id_hook` = 820 LIMIT 1
495 ms 1 /classes/Hook.php:229
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 151 AND `id_group` = 1 LIMIT 1
494 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-static-css' LIMIT 1
490 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
490 ms 1 /classes/ObjectModel.php:1647
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 78 AND `id_shop` = 1 LIMIT 1
490 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionFrontControllerSetMedia") LIMIT 1
490 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
489 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterProductThumbs") LIMIT 1
488 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayBanner") LIMIT 1
488 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderRight") LIMIT 1
488 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-maintenance-addon/revslider-maintenance-addon.php' LIMIT 1
488 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
488 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-beforeafter-addon/revslider-beforeafter-addon.php' LIMIT 1
487 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-global-settings' LIMIT 1
486 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-typewriter-addon/revslider-typewriter-addon.php' LIMIT 1
485 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "RevsliderPrestashop" LIMIT 1
485 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE *
FROM `ps_lang` a
LEFT JOIN `ps_lang_shop` `c` ON a.`id_lang` = c.`id_lang` AND c.`id_shop` = 1
WHERE (a.`id_lang` = 1) LIMIT 1
483 ms 1 /src/Adapter/EntityMapper.php:76
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayTop") LIMIT 1
480 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-whiteboard-addon/revslider-whiteboard-addon.php' LIMIT 1
480 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE 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 = 1)
WHERE pa.id_product = 421 LIMIT 1
479 ms 5 /classes/Product.php:1037
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-revealer-addon/revslider-revealer-addon.php' LIMIT 1
479 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_order`
FROM `ps_orders`
WHERE `id_cart` = 0 AND id_shop IN (1) LIMIT 1
478 ms 1 /classes/order/Order.php:1203
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
477 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 151 LIMIT 1
475 ms 4 /classes/Product.php:1051
SELECT SQL_NO_CACHE `id_lang`, IF(language_code = 'en-us', 0, LENGTH(language_code)) as found
FROM `ps_lang`
WHERE LEFT(`language_code`,2) = 'en'
ORDER BY found ASC LIMIT 1
475 ms 1 Yes /classes/Language.php:974
SELECT SQL_NO_CACHE COUNT(*) FROM `ps_pack` WHERE id_product_pack = 408 LIMIT 1
474 ms 1 /classes/Pack.php:89
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 87 AND `id_shop` = 1 LIMIT 1
473 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 22 AND `id_shop` = 1 LIMIT 1
473 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 79 AND `id_shop` = 1 LIMIT 1
472 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 408
471 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
471 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterBreadcrumb") LIMIT 1
466 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-backup-addon/revslider-backup-addon.php' LIMIT 1
466 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListFunctionalButtons") LIMIT 1
465 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitsociallogin" LIMIT 1
465 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-liquideffect-addon/revslider-liquideffect-addon.php' LIMIT 1
462 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 421
456 ms 5 /classes/Product.php:2875
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 408 AND `id_group` = 1 LIMIT 1
453 ms 0 /classes/GroupReduction.php:156
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
450 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
448 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayWrapperTopInContainer") LIMIT 1
445 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListReviews") LIMIT 1
444 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayNav1") LIMIT 1
443 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayWrapperBottomInContainer") LIMIT 1
442 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 483
442 ms 1 /classes/Product.php:2875
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayFooterBefore") LIMIT 1
442 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "moduleRoutes") LIMIT 1
440 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 71 AND `id_shop` = 1 LIMIT 1
440 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayBeforeBodyClosingTag") LIMIT 1
437 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayAfterProductThumbs2") LIMIT 1
435 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductRating") LIMIT 1
434 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
433 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayContentWrapperTop") LIMIT 1
432 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-particles-addon/revslider-particles-addon.php' LIMIT 1
431 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
431 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE 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 = 1)
WHERE product_attribute_shop.default_on = 1  AND pa.id_product = 408 LIMIT 1
431 ms 1 /classes/Product.php:1051
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-panorama-addon/revslider-panorama-addon.php' LIMIT 1
430 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayFooter") LIMIT 1
429 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionControllerInitBefore") LIMIT 1
428 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectConnectionAddAfter") LIMIT 1
428 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
426 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-weather-addon/revslider-weather-addon.php' LIMIT 1
425 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayCustomerLoginFormAfter") LIMIT 1
422 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 67 AND `id_shop` = 1 LIMIT 1
421 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
419 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionPresentProductListing") LIMIT 1
418 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE c.`nleft`, c.`nright`, c.`level_depth`
FROM `ps_category` c
WHERE (c.`id_category` = 2) LIMIT 1
418 ms 1 /classes/Category.php:1957
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListFunctionalButtons") LIMIT 1
413 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionFrontControllerInitBefore") LIMIT 1
412 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 226 LIMIT 1
411 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 89 LIMIT 1
410 ms 1 /classes/Product.php:5614
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT 1
408 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayProductListBelowButton") LIMIT 1
405 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 93 AND `id_shop` = 1 LIMIT 1
403 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT 1
400 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionControllerInitAfter") LIMIT 1
398 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
397 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayHeaderLeft") LIMIT 1
397 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "iqitmegamenu" LIMIT 1
396 ms 1 /classes/module/Module.php:2840
SELECT SQL_NO_CACHE option_value FROM `ps_revslider_options` WHERE `option_name`='revslider-snow-addon/revslider-snow-addon.php' LIMIT 1
388 ms 12 /modules/revsliderprestashop/includes/revslider_db.class.php:193
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT 1
384 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
381 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionOutputHTMLBefore") LIMIT 1
378 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "filterProductContent") LIMIT 1
378 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayFooterProduct") LIMIT 1
364 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_lang` FROM `ps_lang`
WHERE `locale` = 'fr-fr'
OR `language_code` = 'fr-fr' LIMIT 1
363 ms 1 /classes/Language.php:853
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "displayWrapperBottom") LIMIT 1
362 ms 1 /classes/Hook.php:1270
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionObjectGuestAddAfter") LIMIT 1
360 ms 0 /classes/Hook.php:1270
SELECT SQL_NO_CACHE `id_module` FROM `ps_module_shop` WHERE `id_module` = 70 AND `id_shop` = 1 LIMIT 1
351 ms 1 /classes/module/Module.php:2328
SELECT SQL_NO_CACHE active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT 1
333 ms 0 /classes/Hook.php:1270

Doubles

11 queries
SELECT `id_module` FROM `ps_module_shop` WHERE `id_module` = <span style="color:blue">XX</span> AND `id_shop` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
8 queries
SELECT
            COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), <span style="color:blue">XX</span>) as deep_quantity,
            COALESCE(SUM(first_level_quantity), <span style="color:blue">XX</span>) as quantity
          FROM (SELECT cp.`quantity` as first_level_quantity, <span style="color:blue">XX</span> as pack_quantity
          FROM `ps_cart_product` cp
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND cp.`id_product` = <span style="color:blue">XX</span> UNION SELECT <span style="color:blue">XX</span> as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity
          FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product`
            WHERE cp.`id_product_attribute` = <span style="color:blue">XX</span>
            AND cp.`id_customization` = <span style="color:blue">XX</span>
            AND cp.`id_cart` = <span style="color:blue">XX</span> AND p.`id_product_item` = <span style="color:blue">XX</span> AND (pr.`pack_stock_type` IN (<span style="color:blue">XX</span>,<span style="color:blue">XX</span>) OR (
            pr.`pack_stock_type` = <span style="color:blue">XX</span>
            AND <span style="color:blue">XX</span> = <span style="color:blue">XX</span>
        ))) as q LIMIT <span style="color:blue">XX</span>
8 queries
SELECT `id_order`
            FROM `ps_orders`
            WHERE `id_cart` = <span style="color:blue">XX</span> AND id_shop IN (<span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
7 queries
SELECT active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesBefore") LIMIT <span style="color:blue">XX</span>
5 queries
SELECT `id_product_attribute`
            FROM `ps_product_attribute`
            WHERE `id_product` = <span style="color:blue">XX</span>
4 queries
SELECT active
FROM `ps_hook` h
WHERE (h.name = "actionProductFlagsModifier") LIMIT <span style="color:blue">XX</span>
4 queries
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 = <span style="color:blue">XX</span>)
                 WHERE product_attribute_shop.default_on = <span style="color:blue">XX</span>  AND pa.id_product = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
4 queries
			SELECT `reduction`
			FROM `ps_product_group_reduction_cache`
			WHERE `id_product` = <span style="color:blue">XX</span> AND `id_group` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
4 queries
SELECT *
FROM `ps_product` a
LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = <span style="color:blue">XX</span>
LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_product` = <span style="color:blue">XX</span>) AND (b.`id_shop` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
4 queries
SELECT *
FROM `ps_product_attribute` a
LEFT JOIN `ps_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = <span style="color:blue">XX</span>
WHERE (a.`id_product_attribute` = <span style="color:blue">XX</span>) LIMIT <span style="color:blue">XX</span>
4 queries
            SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean<span style="color:blue">XX</span>`, pa.`isbn`, pa.`upc`, pa.`mpn`
            FROM `ps_attribute` a
            LEFT JOIN `ps_attribute_lang` al
                ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = <span style="color:blue">XX</span>)
            LEFT JOIN `ps_product_attribute_combination` pac
                ON (pac.`id_attribute` = a.`id_attribute`)
            LEFT JOIN `ps_product_attribute` pa
                ON (pa.`id_product_attribute` = pac.`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 = <span style="color:blue">XX</span>)
            LEFT JOIN `ps_attribute_group_lang` agl
                ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = <span style="color:blue">XX</span>)
            WHERE pa.`id_product` = <span style="color:blue">XX</span>
                AND pac.`id_product_attribute` = <span style="color:blue">XX</span>
                AND agl.`id_lang` = <span style="color:blue">XX</span>
4 queries
SELECT COUNT(*) FROM `ps_pack` WHERE id_product_pack = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
4 queries
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 = <span style="color:blue">XX</span>)
                    WHERE i.`id_product` = <span style="color:blue">XX</span>
                    AND image_shop.`cover` = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
4 queries
SELECT `id_lang` FROM `ps_lang`
                    WHERE `locale` = 'fr-fr'
                    OR `language_code` = 'fr-fr' LIMIT <span style="color:blue">XX</span>
4 queries
SELECT name FROM ps_category_lang WHERE id_shop = <span style="color:blue">XX</span> AND id_lang = <span style="color:blue">XX</span> AND id_category = <span style="color:blue">XX</span> LIMIT <span style="color:blue">XX</span>
4 queries
SELECT active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfter") LIMIT <span style="color:blue">XX</span>
4 queries
SELECT active
FROM `ps_hook` h
WHERE (h.name = "actionGetProductPropertiesAfterUnitPrice") LIMIT <span style="color:blue">XX</span>
4 queries
            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 = <span style="color:blue">XX</span>)
            LEFT JOIN `ps_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = <span style="color:blue">XX</span>)
            WHERE i.`id_product` = <span style="color:blue">XX</span>
            ORDER BY `position`
4 queries
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 = <span style="color:blue">XX</span>)