Promotions

Promotions
Akrapovic Evolution Line Yamaha YZF-R1 2015
  • Promo !
yamaha
Akrapovic Evolution Line Yamaha...
Le tout nouveau système d'échappement Akrapovic Evolution Line pour la Yamaha R1 2015 à 2019...
1 830,84 € Prix de base -5% 1 927,20 € Prix
Akrapovic Evolution Line 'Titanium' Yamaha YZF-R6 2006 à 2016
  • Promo !
yamaha
Akrapovic Evolution Line 'Titanium'...
La ligne d'échappement Akrapovič evolution line titane est conçue pour les pilotes et teams...
1 675,66 € Prix de base -5% 1 763,85 € Prix
Ligne d'échappement Titane Spark Force Yamaha YZF-R1 2015/2018
  • Prix réduit
yamaha
Ligne d'échappement Titane Spark...
Ligne complète d'échappement Inox Spark avec silencieux Force en titane pour Yamaha YZF-R1...
1 558,41 € Prix de base -10% 1 731,57 € Prix
Akrapovic Evolution Line Kawasaki ZX-6R 2013 à 2015
  • Promo !
kawasaki
Akrapovic Evolution Line Kawasaki...
La ligne d'échappement Akrapovič evolution line titane est conçue pour les pilotes et teams...
1 557,37 € Prix de base -5% 1 639,34 € Prix
Ligne d'échappement Titane Evo 2 Spark Force Yamaha YZF-R6 2017/2019
  • Prix réduit
yamaha
Ligne d'échappement Titane Evo 2...
Ligne complète d'échappement Titane Evo 2 Spark avec silencieux Force en titane pour Yamaha...
1 471,83 € Prix de base -10% 1 635,37 € Prix
Akrapovic Evolution line BMW S1000 RR 2010 à 2014
  • Promo !
bmw
Akrapovic Racing Line Carbone BMW...
La ligne d'échappement " Racing Line Akrapovic Carbone pour BMW S1000 RR 2010 à 2014"...
1 243,55 € Prix de base -5% 1 309,01 € Prix
Ligne d'échappement Inox Spark Force Yamaha YZF-R1 2015/2018
  • Prix réduit
yamaha
Ligne d'échappement Inox Spark Force...
Ligne complète d'échappement Inox Spark avec silencieux Force en titane pour Yamaha YZF-R1...
1 156,76 € Prix de base -10% 1 285,29 € Prix
Amortisseur Arrière Öhlins BMW HP4 13-14 / S1000RR 15-18 (T36PR1C1LB)
  • Prix réduit
bmw
Amortisseur Arrière Öhlins BMW HP4...
Amortisseur Arrière Öhlins BMW HP4 2013 à 2014 / S1000RR 2015 à 2018 (T36PR1C1LB) * Veuillez...
1 144,20 € Prix de base -8% 1 243,70 € Prix
Tous les produits en promotion
  • Prix réduit
Araignée aluminium Motoholders Kawasaki ZX-10R 2004 à 2005
  • Araignée aluminium Motoholders Kawasaki ZX-10R 2004 à 2005

Araignée carenage Motoholders Kawasaki ZX-10R 2004 à 2005

97,04 €
87,34 € Économisez 10%

 Araignée aluminium Motoholders Kawasaki ZX-10R 2004 à 2005

 L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.

Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.

 

  • Nous garantissons la sécurité de vos données & paiements Nous garantissons la sécurité de vos données & paiements
  • Livraison gratuite à partir de 99€ avec DPD Parcel  & Mondial Relay Livraison gratuite à partir de 99€ avec DPD Parcel & Mondial Relay
  • Retour sous 14 jours gratuit si commande de stock Retour sous 14 jours gratuit si commande de stock

Araignée Motoholders Kawasaki ZX-10R 2004 à 2005

Excellent rapport qualité / prix pour remplacer sur votre moto

Les araignées racing Motoholders permettent le montage de votre compteur d'origine mais pas le système de phares.

  • Fabriqué artisanalement en alliage d'aluminium aérospatial.
  • Finition en poudre de couleur noire pour la protéger.
  • Un remplacement beaucoup moins cher pour le support de carénage OEM.
  • Plus léger approx. 33% que l'article original.
  • Plus résistant que les supports de carénage d'origine.
  • S'adapte à toutes les carrosseries de course qui suivent les points de montage originaux de la carrosserie d'origine.

Les araignées carénages sont uniquement destinés à la course. Ils n'ont pas de points de montage pour les rétroviseurs

MOKA079

Cliquez ici pour laisser un commentaire

16 autres produits dans la même catégorie :

kawasaki
Araignée racing + conduit d'air DBholders Kawasaki ZX-10R 2008 à 2010
Araignée racing + conduit d'air DBholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-10R 2008 à 2010 Les araignées racing DBHolders permettent le montage de votre compteur d'origine mais pas le système de phares.
123,97 € Prix
kawasaki
Araignée racing + conduit d'air DBholders Kawasaki ZX-300R 2013 à...
Araignée racing + conduit d'air DBholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-300R 2013 à 2017 (OEM replica) Les araignées racing DBHolders permettent le montage de votre compteur d'origine mais pas le système de phares.
90,91 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-10R 2016 à 2018
Araignée de carénage et support compteur Motoholders en aluminium pour moto Kawasaki ZX-10R 2016 à 2018 L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.
100,04 € Prix de base -10% 111,15 € Prix
kawasaki
Araignée racing + conduit d'air DBholders Kawasaki ZX-300R 2013 à...
Araignée racing + conduit d'air DBholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-300R 2013 à 2017 (Racing) Les araignées racing DBHolders permettent le montage de votre compteur d'origine mais pas le système de phares.
90,91 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-400R 2018 Street
Araignée racing + conduit d'air Motoholders  fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-400R 2018 Street Les araignées racing Motoholders permettent le montage de votre compteur d'origine mais pas le système de phares.
171,50 € Prix de base -10% 190,55 € Prix
kawasaki
Araignée carenage + conduit d'air Motoholders Kawasaki ZX-6R 2009 à...
Araignée de carénage et support compteur Motoholders en aluminium pour moto Kawasaki ZX-6R 2009 à 2016 L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.
141,33 € Prix de base -10% 157,03 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-250R Ninja 2009 à 2012
Araignée racing + conduit d'air Motoholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-250R Ninja 2009 à 2012 Modèle Street & Racing L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et...
134,97 € Prix de base -10% 149,97 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-400R 2018 Racing
Araignée racing + conduit d'air Motoholders  fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-400R 2018 Racing L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un...
150,85 € Prix de base -10% 167,61 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-10R 2006 à 2007
 Araignée aluminium Motoholders Kawasaki ZX-10R 2006 à 2007  L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.  
82,58 € Prix de base -10% 91,75 € Prix
kawasaki
Araignée racing + conduit d'air DBholders Kawasaki ZX-10R 2011 à 2015
Araignée racing + conduit d'air DBholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-10R 2011 à 2015 Les araignées racing DBHolders permettent le montage de votre compteur d'origine mais pas le système de phares.
109,09 € Prix de base -12% 123,97 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-6R / RR 2003 à 2004
 Araignée aluminium Motoholders Kawasaki ZX-6R / RR 2003 à 2004  L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.  
82,58 € Prix de base -10% 91,75 € Prix
kawasaki
Araignée racing + conduit d'air DBholders Kawasaki ZX-6R 2009 à 2012
Araignée racing + conduit d'air DBholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-6R 2009 à 2012 Les araignées racing DBHolders permettent le montage de votre compteur d'origine mais pas le système de phares.
109,09 € Prix de base -12% 123,97 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-10R 2008 à 2010
 Araignée aluminium Motoholders Kawasaki ZX-10R 2008 à 2010  L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.  
82,58 € Prix de base -10% 91,75 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-6R / RR 2007 à 2008
 Araignée aluminium Motoholders Kawasaki ZX-6R / RR 2007 à 2008  L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.  
82,58 € Prix de base -10% 91,75 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-6R 1998 à 2003
 Araignée aluminium Motoholders Kawasaki ZX-6R 1998 à 2003  L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un carénage en polyester pour la piste, elles permettent l'utilisation du compteur/compte-tours d'origine.  
103,21 € Prix de base -10% 114,68 € Prix
kawasaki
Araignée carenage Motoholders Kawasaki ZX-300R Ninja 2013 à 2018
Araignée racing + conduit d'air Motoholders fabriquée en Aluminium. Très léger et plus résistant que les modèles d'origine, il vous permet de remplacer celle d'origine de votre Kawasaki ZX-300R Ninja 2013 à 2018 L'araignée Motoholders Racing est entièrement en aluminium (ou carbone), augmente la rigidité et légèreté.Idéales lors du montage d'un...
134,97 € Prix de base -10% 149,97 € Prix
Load Time2025 ms - You'd better run your shop on a toaster
Querying Time1299 ms
Queries980
Memory Peak Usage34.1 Mb
Included Files590 files - 8.60 Mb
PrestaShop Cache- Mb
Global vars0.77 Mb
PrestaShop Version1.7.4.4
PHP Version7.1.30-2+0~20190710.21+debian9~1.gbp011d3c (OK)
MySQL Version10.1.38-MariaDB-0+deb9u1 (OK)
Memory Limit256M
Max Execution Time120s
Smarty Cacheenabled
Smarty Compilationauto
 TimeCumulated TimeMemory UsageMemory Peak Usage
config 110 ms 110 ms 3.98 Mb 4.01 Mb
__construct 0 ms 110 ms - Mb 4.01 Mb
init 224 ms 334 ms 2.76 Mb 6.90 Mb
checkAccess 0 ms 334 ms - Mb 6.90 Mb
setMedia 11 ms 345 ms 0.44 Mb 7.20 Mb
postProcess 0 ms 345 ms - Mb 7.20 Mb
initHeader 0 ms 345 ms - Mb 7.20 Mb
initContent 135 ms 479 ms 2.03 Mb 9.32 Mb
initFooter 0 ms 479 ms - Mb 9.32 Mb
display 1546 ms 2025 ms 24.45 Mb 34.13 Mb
Hook Time Memory Usage
0 hooks - ms - Mb
Module Time Memory Usage
0 modules - ms - Mb

Stopwatch SQL - 980 queries

Query Time (ms) Rows Filesort Group By Location
SELECT SQL_NO_CACHE o.id_order
FROM ps_orders o
LEFT JOIN ps_order_detail od ON (od.id_order = o.id_order)
WHERE o.valid = 1
AND od.product_id IN (1162)
18 1 /modules/ps_crossselling/ps_crossselling.php:252
SELECT SQL_NO_CACHE count(id_wishlist_product) FROM ps_ttwishlist w, ps_ttwishlist_product wp where w.id_wishlist = wp.id_wishlist and w.id_customer=0 LIMIT 1
13 34 /modules/ttproductwishlist/ttproductwishlist.php:169
SELECT SQL_NO_CACHE tt.*, ll.*
FROM ps_ttmegamenu_shop tt
LEFT JOIN `ps_ttmegamenu_lang` ll ON (ll.`id_ttmegamenu` = tt.`id_ttmegamenu` AND tt.`id_shop` = ll.`id_shop`)
WHERE tt.active = 1 AND ll.id_shop = 1 AND ll.id_lang=1 ORDER BY tt.position ASC, tt.id_ttmegamenu ASC
12.8 20 Yes /modules/ttmegamenu/classes/TtMegamenuClass.php:251
SELECT SQL_NO_CACHE id_shop
FROM `ps_lang_shop`
WHERE `id_lang` = 1
AND id_shop = 1 LIMIT 1
12.4 1 /classes/ObjectModel.php:1548
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 5191   AND active = 1   AND id_lang = 1 LIMIT 1
11.8 1 /modules/lgcomments/classes/LGProductComment.php:72
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)
10.9 2 /classes/Language.php:881
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 2683 AND `id_lang` = 1 LIMIT 1
10.7 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 1171   AND active = 1   AND id_lang = 1 LIMIT 1
10.7 1 /modules/lgcomments/classes/LGProductComment.php:72
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')
10.4 1 /classes/ObjectModel.php:529
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 (1164) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
10.4 1 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 4780
9.8 1 /classes/Product.php:2416
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module
FROM `ps_module` m
INNER JOIN ps_module_shop module_shop
ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1)
INNER JOIN `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` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND  mg.`id_group` IN (1))
GROUP BY hm.id_hook, hm.id_module
ORDER BY hm.`position`
9.6 73 Yes Yes /classes/Hook.php:629
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1169)
9.6 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 2681 AND `id_lang` = 1 LIMIT 1
9.6 0 /modules/ttproductcountdown/ttproductcountdown.php:676
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
9.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, active
FROM `ps_hook_module` hm
STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1)
STRAIGHT_JOIN `ps_module` as m ON (m.id_module = hm.id_module)
ORDER BY hm.position
9.2 361 /classes/Hook.php:374
SELECT SQL_NO_CACHE id_tab, class_name FROM `ps_tab`
9.2 147 /classes/Tab.php:314
SELECT SQL_NO_CACHE mr.*
FROM ps_ttmegamenu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_ttmegamenu = 13 AND mr.`active` = 1
9.1 22 /modules/ttmegamenu/ttmegamenu.php:1155
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 5194   AND active = 1   AND id_lang = 1 LIMIT 1
8.8 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 1167 AND `id_lang` = 1 LIMIT 1
8.7 0 /modules/ttproductcountdown/ttproductcountdown.php:676
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` = 330) AND (b.`id_shop` = 1) LIMIT 1
8.7 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2553)
8.6 2 /classes/Product.php:3280
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 2681
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
8.6 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 1163 AND `id_lang` = 1 LIMIT 1
8.5 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE domain, domain_ssl
FROM ps_shop_url
WHERE main = 1
AND id_shop = 1 LIMIT 1
8.4 1 /classes/shop/ShopUrl.php:169
SELECT SQL_NO_CACHE * FROM `ps_hook_alias`
8.4 83 /classes/Hook.php:249
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 2241
8.3 3 /classes/ProductAssembler.php:91
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` = 1135) AND (b.`id_shop` = 1) LIMIT 1
8.3 1 /src/Adapter/EntityMapper.php:67
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` = 2241
ORDER BY `position`
8.3 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE mc.*
FROM ps_ttmegamenu_column_shop mc
WHERE mc.`id_shop` = 1 AND mc.id_row = 21 AND mc.`active` = 1 ORDER BY mc.position ASC, mc.id_column ASC
8.2 68 Yes /modules/ttmegamenu/ttmegamenu.php:1173
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_searchbar" LIMIT 1
8.1 1 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 1163
7.9 1 /classes/ProductAssembler.php:91
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2019-07-23 00:00:00" AND date_to <= "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2019-07-23 00:00:00" AND date_from <= "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2019-07-23 00:00:00" AND date_to > "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
7.9 1 /classes/CartRule.php:335
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 65 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
7.9 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 4781   AND active = 1   AND id_lang = 1 LIMIT 1
7.8 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN `ps_country_lang` cl ON (c.`id_country` = cl.`id_country` AND cl.`id_lang` = 1)
LEFT JOIN `ps_zone` z ON (z.`id_zone` = c.`id_zone`)
WHERE 1
ORDER BY cl.name ASC
7.7 245 Yes /classes/Country.php:146
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1
7.6 4911 /classes/SpecificPrice.php:276
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 1162 AND active = 1 AND id_lang = 1 AND stars >= 10 AND stars < 11 LIMIT 1
7.6 1 /modules/lgcomments/classes/LGProductComment.php:174
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` = 1129) AND (b.`id_shop` = 1) LIMIT 1
7.6 1 /src/Adapter/EntityMapper.php:67
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` = 1517) AND (b.`id_shop` = 1) LIMIT 1
7.5 1 /src/Adapter/EntityMapper.php:67
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` = 1130) AND (b.`id_shop` = 1) LIMIT 1
7.5 1 /src/Adapter/EntityMapper.php:67
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` = 1160) AND (b.`id_shop` = 1) LIMIT 1
7.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 5193
ORDER BY f.position ASC
7.4 1 Yes /classes/Product.php:4860
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` = 1162
ORDER BY `position`
7.4 1 Yes /classes/Product.php:2984
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` = 1414) AND (b.`id_shop` = 1) LIMIT 1
7.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 5194)
7.3 2 /classes/Product.php:3280
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1291 LIMIT 1
7.3 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 5193 AND `id_lang` = 1 LIMIT 1
7 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 23 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
7 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 52 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
7 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
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` = 30) AND (b.`id_shop` = 1) LIMIT 1
7 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 1169   AND active = 1   AND id_lang = 1 LIMIT 1
6.6 1 /modules/lgcomments/classes/LGProductComment.php:72
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` = 801) AND (b.`id_shop` = 1) LIMIT 1
6.5 1 /src/Adapter/EntityMapper.php:67
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` = 832) AND (b.`id_shop` = 1) LIMIT 1
6.4 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) AS quantity, IFNULL(product_attribute_shop.id_product_attribute, 0) AS id_product_attribute,
product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, pl.`description`, pl.`description_short`, pl.`available_now`,
pl.`available_later`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, image_shop.`id_image` id_image,
il.`legend` as legend, m.`name` AS manufacturer_name, cl.`name` AS category_default,
DATEDIFF(product_shop.`date_add`, DATE_SUB("2019-07-23 00:00:00",
INTERVAL 20 DAY)) > 0 AS new, product_shop.price AS orderprice
FROM `ps_category_product` cp
LEFT JOIN `ps_product` p
ON p.`id_product` = cp.`id_product`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN ps_stock_available stock
ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
LEFT JOIN `ps_category_lang` cl
ON (product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 )
LEFT JOIN `ps_product_lang` pl
ON (p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 )
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il
ON (image_shop.`id_image` = il.`id_image`
AND il.`id_lang` = 1)
LEFT JOIN `ps_manufacturer` m
ON m.`id_manufacturer` = p.`id_manufacturer`
WHERE product_shop.`id_shop` = 1
AND cp.`id_category` = 1291 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 17
6.4 26 Yes /classes/Category.php:1010
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 71 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
6.3 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 2681   AND active = 1   AND id_lang = 1 LIMIT 1
6.2 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE mr.*
FROM ps_ttmegamenu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_ttmegamenu = 17 AND mr.`active` = 1
6.1 22 /modules/ttmegamenu/ttmegamenu.php:1155
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 36 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
6.1 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
(SELECT SQL_NO_CACHE * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`id_customer` = 0  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%") UNION (SELECT * FROM `ps_cart_rule` cr
LEFT JOIN `ps_cart_rule_lang` crl ON (cr.`id_cart_rule` = crl.`id_cart_rule` AND crl.`id_lang` = 1) WHERE cr.`group_restriction` = 1  AND NOW() BETWEEN cr.date_from AND cr.date_to
AND cr.`active` = 1
AND cr.`quantity` > 0 AND highlight = 1 AND code NOT LIKE "BO_ORDER_%")
6.1 1 /classes/CartRule.php:393
SELECT SQL_NO_CACHE * FROM `ps_state` ORDER BY `name` ASC
6 324 Yes /classes/Country.php:153
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` = 2553
ORDER BY `position`
5.9 2 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 33 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
5.8 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
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` = 1157) AND (b.`id_shop` = 1) LIMIT 1
5.7 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1291 LIMIT 1
5.6 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE p.*, product_shop.*, stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`,
pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`,
image_shop.`id_image` id_image, il.`legend`, m.`name` as manufacturer_name, cl.`name` AS category_default, IFNULL(product_attribute_shop.id_product_attribute, 0) id_product_attribute,
DATEDIFF(
p.`date_add`,
DATE_SUB(
"2019-07-23 00:00:00",
INTERVAL 20 DAY
)
) > 0 AS new
FROM `ps_accessory`
LEFT JOIN `ps_product` p ON p.`id_product` = `id_product_2`
INNER JOIN ps_product_shop product_shop
ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` product_attribute_shop
ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1)
LEFT JOIN `ps_product_lang` pl ON (
p.`id_product` = pl.`id_product`
AND pl.`id_lang` = 1 AND pl.id_shop = 1 
)
LEFT JOIN `ps_category_lang` cl ON (
product_shop.`id_category_default` = cl.`id_category`
AND cl.`id_lang` = 1 AND cl.id_shop = 1 
)
LEFT JOIN `ps_image_shop` image_shop
ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1)
LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1)
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 = 0 AND stock.id_shop = 1  AND stock.id_shop_group = 0  )
WHERE `id_product_1` = 1162 AND product_shop.`active` = 1 AND product_shop.`visibility` != 'none'
GROUP BY product_shop.id_product
5.6 1 Yes Yes /classes/Product.php:3927
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` = 1169
ORDER BY `position`
5.5 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE data FROM `ps_ganalytics_data` WHERE id_cart = '0' AND id_shop = '1' LIMIT 1
5.4 0 /modules/ps_googleanalytics/ps_googleanalytics.php:732
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` = 5191
ORDER BY `position`
5.4 2 Yes /classes/Product.php:2984
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 (2681) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
5.4 1 Yes Yes /classes/Product.php:3788
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 (5191) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
5.4 2 Yes Yes /classes/Product.php:3788
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` = 1167
ORDER BY `position`
5.4 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 1171 AND `id_lang` = 1 LIMIT 1
5.3 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2683)
5.3 1 /classes/Product.php:3280
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` = 5191 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` = 5191 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
5.3 0 /classes/Cart.php:1225
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` = 31) AND (b.`id_shop` = 1) LIMIT 1
5.3 1 /src/Adapter/EntityMapper.php:67
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` = 4781
ORDER BY `position`
5.3 2 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 1169 AND `id_lang` = 1 LIMIT 1
5.2 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 2683 AND `id_group` = 1 LIMIT 1
5.2 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 2241   AND active = 1   AND id_lang = 1 LIMIT 1
5.2 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 1163
5.2 1 /classes/Product.php:2416
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_legalcompliance" LIMIT 1
5.2 0 /classes/module/Module.php:2603
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 5195   AND active = 1   AND id_lang = 1 LIMIT 1
5.1 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 2553 AND `id_lang` = 1 LIMIT 1
5.1 0 /modules/ttproductcountdown/ttproductcountdown.php:676
(SELECT 1 FROM `ps_cart_rule` WHERE date_to >= "2019-07-23 00:00:00" AND date_to <= "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from >= "2019-07-23 00:00:00" AND date_from <= "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1)UNION ALL (SELECT 1 FROM `ps_cart_rule` WHERE date_from < "2019-07-23 00:00:00" AND date_to > "2019-07-23 23:59:59" AND `id_customer` IN (0,0) LIMIT 1) LIMIT 1
5.1 1 /classes/CartRule.php:335
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 1164   AND active = 1   AND id_lang = 1 LIMIT 1
5.1 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 1163   AND active = 1   AND id_lang = 1 LIMIT 1
5 1 /modules/lgcomments/classes/LGProductComment.php:72
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 5195 AND `id_lang` = 1 LIMIT 1
5 0 /modules/ttproductcountdown/ttproductcountdown.php:676
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` = 1333) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /src/Adapter/EntityMapper.php:67
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` = 1008) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /src/Adapter/EntityMapper.php:67
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` = 1377) AND (b.`id_shop` = 1) LIMIT 1
4.9 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_currency` c
INNER JOIN ps_currency_shop currency_shop
ON (currency_shop.id_currency = c.id_currency AND currency_shop.id_shop = 1) WHERE `deleted` = 0 AND c.`active` = 1 ORDER BY `iso_code` ASC
4.7 16 Yes /classes/Currency.php:300
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "ps_categorytree" LIMIT 1
4.6 1 /src/Adapter/Module/ModuleDataProvider.php:169
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 2684)
4.6 1 /classes/Product.php:3280
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
4.6 4 /classes/Currency.php:657
SELECT SQL_NO_CACHE COUNT(*) FROM ps_lgcomments_productcomments WHERE id_product = 5193   AND active = 1   AND id_lang = 1 LIMIT 1
4.6 1 /modules/lgcomments/classes/LGProductComment.php:72
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
4.4 0 /classes/tax/TaxRulesTaxManager.php:110
SELECT SQL_NO_CACHE id_shop
FROM `ps_currency_shop`
WHERE `id_currency` = 1
AND id_shop = 1 LIMIT 1
4.4 1 /classes/ObjectModel.php:1548
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` = 1337) AND (b.`id_shop` = 1) LIMIT 1
4.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE mr.*
FROM ps_ttmegamenu_row_shop mr
WHERE mr.`id_shop` = 1 AND mr.id_ttmegamenu = 14 AND mr.`active` = 1
4.3 22 /modules/ttmegamenu/ttmegamenu.php:1155
SELECT SQL_NO_CACHE `id_module` FROM `ps_module` WHERE `name` = "bestkit_opc" LIMIT 1
4.3 0 /src/Adapter/Module/ModuleDataProvider.php:169
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 (1162) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
4.2 1 Yes Yes /classes/Product.php:3788
INSERT INTO `ps_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('6', '3769', '598456227', '', '1', '1', '2019-07-23 20:54:19')
4.1 1 /classes/ObjectModel.php:529
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 2553
AND pac.`id_product_attribute` = 4599
AND agl.`id_lang` = 1
4.1 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_shop` a
WHERE (a.`id_shop` = 1) LIMIT 1
3.9 1 /src/Adapter/EntityMapper.php:67
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` = 945) AND (b.`id_shop` = 1) LIMIT 1
3.8 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 0, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group`  = 0 AND `id_product` = 2553 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.8 4 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 2553 AND `id_shop` = 1
3.8 2 /src/Adapter/EntityMapper.php:74
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` = 2683
ORDER BY `position`
3.8 1 Yes /classes/Product.php:2984
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 (2553) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.7 2 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 0, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group`  = 0 AND `id_product` = 1167 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.7 4 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 2241 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.7 4 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 0, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group`  = 0 AND `id_product` = 1169 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
3.7 4 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE mc.*
FROM ps_ttmegamenu_column_shop mc
WHERE mc.`id_shop` = 1 AND mc.id_row = 24 AND mc.`active` = 1 ORDER BY mc.position ASC, mc.id_column ASC
3.6 68 Yes /modules/ttmegamenu/ttmegamenu.php:1173
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 1167
3.6 1 /classes/ProductAssembler.php:91
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` = 2683
ORDER BY `position`
3.6 1 Yes /classes/Product.php:2984
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` = 5193) LIMIT 1
3.6 1 /src/Adapter/EntityMapper.php:67
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` = 5194) LIMIT 1
3.5 1 /src/Adapter/EntityMapper.php:67
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` = 4643
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND cp.`id_product` = 5194 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` = 4643
AND cp.`id_customization` = 0
AND cp.`id_cart` = 0 AND p.`id_product_item` = 5194 AND (pr.`pack_stock_type` IN (1,2) OR (
pr.`pack_stock_type` = 3
AND 0 = 1
))) as q LIMIT 1
3.5 0 /classes/Cart.php:1225
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` = 5191) AND (b.`id_shop` = 1) LIMIT 1
3.5 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 2241
AND pac.`id_product_attribute` = 4601
AND agl.`id_lang` = 1
3.5 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1163
ORDER BY f.position ASC
3.5 1 Yes /classes/Product.php:4860
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` = 5195
ORDER BY `position`
3.5 4 Yes /classes/Product.php:2984
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 (4781) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
3.5 1 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5195 AND `id_shop` = 1
3.5 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 5194
AND pac.`id_product_attribute` = 4642
AND agl.`id_lang` = 1
3.5 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 5195
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
3.4 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 5193
AND pac.`id_product_attribute` = 4640
AND agl.`id_lang` = 1
3.4 1 /classes/Product.php:6020
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` = 1171
ORDER BY `position`
3.4 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 2241
AND pac.`id_product_attribute` = 4602
AND agl.`id_lang` = 1
3.4 1 /classes/Product.php:6020
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1167)
3.4 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 4780
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
3.4 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 5191 AND `id_lang` = 1 LIMIT 1
3.4 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 4780 LIMIT 1
3.4 3 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE *
FROM `ps_ttproduct_comment` pc
WHERE pc.`id_product` = 1162
AND pc.`id_guest` = 6
ORDER BY pc.`date_add` DESC LIMIT 1
3.4 1 Yes /modules/ttproductcomments/classes/TtProductComment.php:118
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 4781)
3.4 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 5194 LIMIT 1
3.3 2 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2553 AND id_shop=1 LIMIT 1
3.3 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 1171 LIMIT 1
3.3 4 /classes/SpecificPrice.php:408
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
3.3 111 /classes/module/Module.php:301
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 2681 LIMIT 1
3.3 4 /classes/SpecificPrice.php:408
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 4781 AND `id_shop` = 1
3.3 2 /src/Adapter/EntityMapper.php:74
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` = 174) AND (b.`id_shop` = 1) LIMIT 1
3.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5191) AND (id_product_attribute = 4636) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
3.3 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 2684 AND id_shop=1 LIMIT 1
3.3 1 /classes/Product.php:5515
SELECT SQL_NO_CACHE name FROM ps_category_lang WHERE id_shop = 1 AND id_lang = 1 AND id_category = 1291 LIMIT 1
3.3 1 /classes/Product.php:4634
SELECT SQL_NO_CACHE `reduction`
FROM `ps_product_group_reduction_cache`
WHERE `id_product` = 5193 AND `id_group` = 1 LIMIT 1
3.3 0 /classes/GroupReduction.php:149
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1162)
3.2 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE id_required_field, object_name, field_name
FROM ps_required_field
3.1 1 /classes/ObjectModel.php:1416
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` = 1291 LIMIT 1
3 1 /classes/Category.php:1321
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 1162
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
3 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 4780 AND `id_lang` = 1 LIMIT 1
3 0 /modules/ttproductcountdown/ttproductcountdown.php:676
SELECT SQL_NO_CACHE *,
( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 1162 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
ORDER BY `from_quantity` ASC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC
3 3 Yes /classes/SpecificPrice.php:604
SELECT SQL_NO_CACHE *
FROM `ps_shop_group` a
WHERE (a.`id_shop_group` = 1) LIMIT 1
2.9 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE smi.*,smil.*
FROM ps_ttmegamenu_item_shop smi
LEFT JOIN ps_ttmegamenu_item_lang smil ON (smi.id_item = smil.id_item AND smi.id_shop = smil.id_shop)
WHERE smi.id_column = 58 AND smil.id_shop = 1 AND smil.id_lang = 1 AND smi.`active` = 1 ORDER BY smi.position ASC, smi.id_item ASC
2.9 341 Yes /modules/ttmegamenu/ttmegamenu.php:1183
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` = 3) LIMIT 1
2.9 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE 1 FROM `ps_specific_price` WHERE id_product = 0 LIMIT 1
2.9 1 /classes/SpecificPrice.php:399
SELECT SQL_NO_CACHE `name` FROM `ps_supplier` WHERE `id_supplier` = 0 LIMIT 1
2.8 0 /classes/Supplier.php:242
SELECT SQL_NO_CACHE id_shop
FROM `ps_group_shop`
WHERE `id_group` = 1
AND id_shop = 1 LIMIT 1
2.8 1 /classes/ObjectModel.php:1548
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 5193) AND (id_product_attribute = 4641) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.7 1 /classes/stock/StockAvailable.php:383
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 5194 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.7 2 Yes /classes/SpecificPrice.php:541
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` = 2684
ORDER BY `position`
2.6 4 Yes /classes/Product.php:2984
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` = 738) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /src/Adapter/EntityMapper.php:67
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
2.6 1 /src/Adapter/EntityMapper.php:67
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` = 47) AND (b.`id_shop` = 1) LIMIT 1
2.6 1 /src/Adapter/EntityMapper.php:67
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`)
2.5 1694 /classes/Configuration.php:157
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 1169
2.4 1 /classes/ProductAssembler.php:91
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` = 2683) LIMIT 1
2.3 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 0, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group`  = 0 AND `id_product` = 5195 AND `id_customer` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.3 2 Yes /classes/SpecificPrice.php:541
SELECT SQL_NO_CACHE product_shop.`price`, product_shop.`ecotax`,
IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on
FROM `ps_product` p
INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = 1)
LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = 1)
WHERE (p.`id_product` = 1171)
2.3 1 /classes/Product.php:3280
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5195
2.3 1 /classes/ProductAssembler.php:91
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` = 1171
ORDER BY `position`
2.3 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE 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 = 1)
LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1)
LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1)
INNER JOIN ps_feature_shop feature_shop
ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1)
WHERE pf.id_product = 1164
ORDER BY f.position ASC
2.3 1 Yes /classes/Product.php:4860
SELECT SQL_NO_CACHE p.*,
pl.*,
sa.out_of_stock,
IFNULL(sa.quantity, 0) as quantity,
(DATEDIFF(
p.`date_add`,
DATE_SUB(
'2019-07-23 00:00:00',
INTERVAL 20 DAY
)
) > 0) as new
FROM ps_product p
LEFT JOIN ps_product_lang pl
ON pl.id_product = p.id_product
AND pl.id_shop = 1
AND pl.id_lang = 1
LEFT JOIN ps_stock_available sa
ON sa.id_product = p.id_product 
AND sa.id_shop = 1
WHERE p.id_product = 5193
2.3 3 /classes/ProductAssembler.php:91
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` = 1167
ORDER BY `position`
2.3 1 Yes /classes/Product.php:2984
SELECT SQL_NO_CACHE SUM(stars) AS totalcomentarios FROM ps_lgcomments_storecomments WHERE active = 1 AND id_lang = 1 LIMIT 1
2.2 113 /modules/lgcomments/classes/LGStoreComment.php:57
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) +  IF (`id_country` = 21, 4, 0) +  IF (`id_currency` = 1, 8, 0) +  IF (`id_shop` = 1, 16, 0) +  IF (`id_customer` = 0, 32, 0)) AS `score`
FROM `ps_specific_price`
WHERE
`id_shop` IN (0, 1) AND
`id_currency` IN (0, 1) AND
`id_country` IN (0, 21) AND
`id_group` IN (0, 1) AND `id_product` = 2681 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0  AND (`from` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2019-07-23 00:00:00' <= `to`)
AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1
2.2 4 Yes /classes/SpecificPrice.php:541
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 (2553) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.2 2 Yes Yes /classes/Product.php:3788
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 (4780) AND ag.`is_color_group` = 1
GROUP BY pa.`id_product`, a.`id_attribute`, `group_by`
ORDER BY a.`position` ASC;
2.2 1 Yes Yes /classes/Product.php:3788
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5191 AND `id_shop` = 1
2.2 1 /src/Adapter/EntityMapper.php:74
SELECT SQL_NO_CACHE `id_product_attribute`
FROM `ps_product_attribute`
WHERE `id_product` = 2683
2.2 1 /classes/Product.php:2416
SELECT SQL_NO_CACHE a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, pa.`reference`, pa.`ean13`, pa.`isbn`,pa.`upc`
FROM `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` = 1163
AND pac.`id_product_attribute` = 0
AND agl.`id_lang` = 1
2.2 0 /classes/Product.php:6020
SELECT SQL_NO_CACHE *
FROM `ps_ttproductcountdown` ttpc
LEFT JOIN  `ps_ttproductcountdown_lang` ttpcl ON ttpc.`id_countdown` = ttpcl.`id_countdown`
WHERE `id_shop` = 1 AND `id_product` = 1164 AND `id_lang` = 1 LIMIT 1
2.1 0 /modules/ttproductcountdown/ttproductcountdown.php:676
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` = 2681
ORDER BY `position`
2.1 1 Yes /classes/Product.php:2984
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` = 2681) LIMIT 1
2.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE `id_tax_rules_group`
FROM `ps_product_shop`
WHERE `id_product` = 1169 AND id_shop=1 LIMIT 1
2.1 1 /classes/Product.php:5515
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` = 1162) AND (b.`id_shop` = 1) LIMIT 1
2.1 1 /src/Adapter/EntityMapper.php:67
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` = 4601) LIMIT 1
2.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE *
FROM `ps_product_lang`
WHERE `id_product` = 5194 AND `id_shop` = 1
2.1 2 /src/Adapter/EntityMapper.php:74
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` = 1164) LIMIT 1
2.1 1 /src/Adapter/EntityMapper.php:67
SELECT SQL_NO_CACHE SUM(quantity)
FROM `ps_stock_available`
WHERE (id_product = 2553) AND (id_product_attribute = 0) AND (id_shop = 1) AND (id_shop_group = 0) LIMIT 1
2.1 1 /classes/stock/StockAvailable.php:383
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` = 556) AND (b.`id_shop` = 1) LIMIT 1
2.1 1