Fournitures

Sous-catégories

Stylo A BILLE Radius One Plus RADUIS

Type d'écriture Bille

Type de pointe Lisse

Option poignée en caoutchouc

Epaisseur de Trait 0.7 mm

0,850 TND

Stylo à Bille - Radius MX RADUIS

Type d'écriture Bille

Epaisseur de Trait 1.0 mm

0,600 TND

Stylo plume MUST - corps large MUST

Qualité premium : une plume en acier inoxydable et finition iridium sur la pointe pour une glisse parfaite et une solidité à toute épreuve

Confort : une zone de préhension antidérapante pour une meilleure prise en main

Bien vu : un produit rechargeable et un clip pour l'emporter partout

4,600 TND

STYLO A BILLE BLEU LINDA

Décor : Motif / Uni

Contenu de l’unité : Ensemble de 4 pièces

1,200 TND

Pochette de 6 Stylos Pointe Fine PLUMA, 0.4 Fine Point PLUMA

Pointe Fine de 0.4 mm : Chaque stylo est équipé d’une pointe fine de 0.4 mm, idéale pour une écriture précise et nette, parfaite pour la prise de notes, le dessin et les annotations détaillées.

Forme Triangulaire Ergonomique : Les stylos PLUMA sont conçus avec une forme triangulaire unique qui offre une prise en main confortable et réduit la fatigue lors d’une utilisation prolongée.

4,000 TND

POCHETTE DE 6 stylos à bille de la marque BEST. BEST

L’article est un lot de 6 stylos à bille de la marque BEST.

Contenu : 6 stylos de différentes couleurs (marron, violet, vert, bleu, orange, rose).

Type d’encre : encre gel ou encre fluide

Corps : transparent, permettant de voir le niveau d’encre.

Capuchon : coloré selon la couleur de l’encre.

Utilisation : écriture lisse sur papier, adaptée pour un usage scolaire ou bureautique.

3,800 TND

Pochette de 10 Stylos Pointe Fine PLUMA, 0.4 Fine Point PLUMA

Forme Triangulaire Ergonomique : Les stylos PLUMA sont conçus avec une forme triangulaire unique qui offre une prise en main confortable et réduit la fatigue lors d’une utilisation prolongée.

5,000 TND

POCHETTE DE 10 stylos à bille de la marque BEST. BEST

L’article est un lot de 6 stylos à bille de la marque BEST.

Contenu : 10 stylos de différentes couleurs

Type d’encre : encre gel ou encre fluide

Corps : transparent, permettant de voir le niveau d’encre.

Capuchon : coloré selon la couleur de l’encre.

Utilisation : écriture lisse sur papier, adaptée pour un usage scolaire ou bureautique.

6,100 TND

10 stylos-feutres 0,4 mm Fine Line PLUMA PLUMA

Pointe extra-fine de 0,4 mm pour des traits précis et délicats
10 couleurs variées et vives, idéales pour organiser, mettre en valeur et stimuler la créativité
Encre à base d’eau, séchage rapide et sans odeur forte
Corps léger et résistant pour un usage confortable
Polyvalent sur différentes surfaces telles que papier, cahiers, fiches ou illustrations techniques
Kit complet pour usage scolaire, artistique ou professionnel

5,700 TND

MARQUEUR TABLEAU RECHARGEABLE G-201 BEST BEST

MarqueurBEST effaçable à sec sur la plupart des surfaces , Effaçage facile. Ne pas agiter , Sèche rapidement , Encre indélébile à base d’alcool , Faible odeur , Capuchon ventilé anti-étouffement , Non toxique

1,700 TND

un marqueur pour tableau blanc de la marque Robusta. ROBUSTA

Type : Marqueur pour tableau blanc (White Board Marker).

Marque : Robusta.

Largeur d'écriture : 400 m (probablement la longueur d'écriture totale estimée).

Couleur : Noir.

1,600 TND

Stylo marqueur effaçable pour tableau blanc PLUMA PLUMA

Type d’encre: Effaçable à sec et à l'humidité

Type: Stylo marqueur

Material: plastic

Pointe d’écriture: normal

1,100 TND

Affichage 1-12 de 79 article(s)

Load Time	2922 ms
Querying Time	2160 ms
Queries	625
Memory Peak Usage	22.1 Mb
Included Files	771 files - 8.89 Mb
PrestaShop Cache	0.01 Mb
Global vars	0.26 Mb
- global $context	196k
- global $_MODULES	31k
- global $_SERVER	15k
- global $_ENV	15k
- global $config	5k
- global $exportPhpConfigFile	3k
- global $__composer_autoload_files	1k
- global $legacyContainer	1k

PrestaShop Version	8.2.5
PHP Version	8.0.30
MySQL Version	5.6.51-log
Memory Limit	512M
Max Execution Time	300s
Smarty Cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	386.015 ms	386.015 ms	3.02 Mb	3.0 Mb
__construct	10.970 ms	396.985 ms	0.01 Mb	3.6 Mb
init	103.718 ms	500.703 ms	0.97 Mb	4.0 Mb
checkAccess	0.003 ms	500.706 ms	- Mb	4.0 Mb
setMedia	23.762 ms	524.468 ms	0.37 Mb	4.4 Mb
postProcess	0.001 ms	524.469 ms	- Mb	4.4 Mb
initHeader	0.002 ms	524.471 ms	- Mb	4.4 Mb
initContent	1237 ms	1762 ms	5.67 Mb	10.3 Mb
initFooter	0.007 ms	1762 ms	- Mb	10.3 Mb
display	1160 ms	2922 ms	10.45 Mb	22.1 Mb

Hook	Time	Memory Usage
displayLeftColumn	765.448 ms	4.17 Mb
=> cp_leftbanner1 (widget)	7.134 ms	0.07 Mb
=> cp_sidebarfeaturedproducts (widget)	758.314 ms	4.10 Mb
DisplayCpHoverImage	42.892 ms	0.35 Mb
=> cp_imagehover	14.486 ms	0.03 Mb
=> cp_imagehover	9.087 ms	0.03 Mb
=> cp_imagehover	2.229 ms	0.03 Mb
=> cp_imagehover	2.292 ms	0.03 Mb
=> cp_imagehover	1.569 ms	0.03 Mb
=> cp_imagehover	1.621 ms	0.03 Mb
=> cp_imagehover	1.525 ms	0.03 Mb
=> cp_imagehover	1.591 ms	0.03 Mb
=> cp_imagehover	1.440 ms	0.03 Mb
=> cp_imagehover	1.621 ms	0.03 Mb
=> cp_imagehover	1.649 ms	0.03 Mb
=> cp_imagehover	3.782 ms	0.03 Mb
displayFooter	35.549 ms	1.01 Mb
=> ps_linklist (widget)	30.950 ms	0.89 Mb
=> cp_themeoptions (widget)	2.063 ms	0.07 Mb
=> cp_parallaximages (widget)	2.536 ms	0.04 Mb
displayHeaderLeft	19.247 ms	0.48 Mb
=> cp_sideverticalmenu (widget)	19.247 ms	0.48 Mb
displayNav1	12.211 ms	0.13 Mb
=> cp_headercms1 (widget)	4.524 ms	0.06 Mb
=> ps_contactinfo (widget)	7.687 ms	0.06 Mb
DisplayBeforeBodyClosingTag	11.011 ms	0.16 Mb
=> ps_googleanalytics	11.011 ms	0.16 Mb
DisplayStCompareButton	8.675 ms	0.03 Mb
=> stfeature	0.553 ms	0.01 Mb
=> stfeature	0.526 ms	- Mb
=> stfeature	0.391 ms	- Mb
=> stfeature	0.400 ms	- Mb
=> stfeature	0.282 ms	- Mb
=> stfeature	0.355 ms	- Mb
=> stfeature	0.367 ms	- Mb
=> stfeature	0.365 ms	- Mb
=> stfeature	0.320 ms	- Mb
=> stfeature	0.310 ms	- Mb
=> stfeature	0.317 ms	- Mb
=> stfeature	0.336 ms	- Mb
=> stfeature	0.319 ms	- Mb
=> stfeature	0.285 ms	- Mb
=> stfeature	0.351 ms	- Mb
=> stfeature	0.349 ms	- Mb
=> stfeature	0.295 ms	- Mb
=> stfeature	0.287 ms	- Mb
=> stfeature	0.415 ms	- Mb
=> stfeature	0.409 ms	- Mb
=> stfeature	0.330 ms	- Mb
=> stfeature	0.321 ms	- Mb
=> stfeature	0.415 ms	- Mb
=> stfeature	0.377 ms	- Mb
DisplayHeader	8.317 ms	0.05 Mb
=> ps_shoppingcart	0.097 ms	- Mb
=> ps_googleanalytics	0.915 ms	0.02 Mb
=> cp_sideverticalmenu	0.071 ms	- Mb
=> cp_imageslider	0.140 ms	- Mb
=> cp_themeoptions	0.759 ms	0.01 Mb
=> cp_countdown	0.112 ms	- Mb
=> stfeature	6.033 ms	0.01 Mb
=> ets_whatsapp	0.190 ms	- Mb
displayBanner	8.140 ms	0.09 Mb
=> cp_headercms2 (widget)	8.140 ms	0.09 Mb
displayNavFullWidth	7.052 ms	0.34 Mb
=> ps_mainmenu (widget)	7.052 ms	0.34 Mb
DisplayStWishlistButton	6.702 ms	0.03 Mb
=> stfeature	0.393 ms	0.01 Mb
=> stfeature	0.279 ms	- Mb
=> stfeature	0.267 ms	- Mb
=> stfeature	0.270 ms	- Mb
=> stfeature	0.264 ms	- Mb
=> stfeature	0.280 ms	- Mb
=> stfeature	0.270 ms	- Mb
=> stfeature	0.270 ms	- Mb
=> stfeature	0.248 ms	- Mb
=> stfeature	0.253 ms	- Mb
=> stfeature	0.253 ms	- Mb
=> stfeature	0.262 ms	- Mb
=> stfeature	0.303 ms	- Mb
=> stfeature	0.263 ms	- Mb
=> stfeature	0.255 ms	- Mb
=> stfeature	0.243 ms	- Mb
=> stfeature	0.304 ms	- Mb
=> stfeature	0.259 ms	- Mb
=> stfeature	0.302 ms	- Mb
=> stfeature	0.303 ms	- Mb
=> stfeature	0.268 ms	- Mb
=> stfeature	0.267 ms	- Mb
=> stfeature	0.284 ms	- Mb
=> stfeature	0.342 ms	- Mb
displayHeaderRight	5.631 ms	0.12 Mb
=> ps_shoppingcart (widget)	5.631 ms	0.12 Mb
displayFooterleft	4.311 ms	0.08 Mb
=> ps_contactinfo (widget)	1.893 ms	0.02 Mb
=> ps_socialfollow (widget)	2.418 ms	0.05 Mb
displayFooterAfter	3.558 ms	0.06 Mb
=> cp_footercms1 (widget)	3.558 ms	0.06 Mb
DisplayLeftColumn	2.773 ms	0.23 Mb
=> ps_facetedsearch	2.773 ms	0.23 Mb
displayFooterbefore	2.516 ms	0.04 Mb
=> ps_emailsubscription (widget)	2.516 ms	0.04 Mb
DisplayStCompareTopLink	2.453 ms	0.06 Mb
=> stfeature	1.388 ms	0.03 Mb
=> stfeature	1.065 ms	0.03 Mb
displaySide	2.381 ms	0.03 Mb
=> cp_headercms1 (widget)	2.381 ms	0.03 Mb
displayNav2	2.343 ms	0.04 Mb
=> ps_customersignin (widget)	2.343 ms	0.04 Mb
DisplayStWishlistTopLink	2.041 ms	0.04 Mb
=> stfeature	1.784 ms	0.04 Mb
=> stfeature	0.257 ms	- Mb
ActionFrontControllerSetMedia	0.706 ms	0.01 Mb
=> blockreassurance	0.311 ms	- Mb
=> ps_emailsubscription	0.236 ms	- Mb
=> ps_socialfollow	0.098 ms	- Mb
=> ps_emailalerts	0.061 ms	- Mb
displayCustomerSide	0.659 ms	- Mb
=> ps_customersignin (widget)	0.659 ms	- Mb
DisplayFooter	0.595 ms	0.03 Mb
=> ets_whatsapp	0.595 ms	0.03 Mb
ProductSearchProvider	0.591 ms	0.01 Mb
=> ps_facetedsearch	0.591 ms	0.01 Mb
DisplayTop	0.078 ms	- Mb
=> pagesnotfound	0.078 ms	- Mb
DisplayFooterAfter	0.018 ms	- Mb
=> cp_themeoptions	0.018 ms	- Mb
DisplayAfterBodyOpeningTag	0.012 ms	- Mb
=> blockreassurance	0.012 ms	- Mb
27 hook(s)	956 ms	7.57 Mb

Module	Time	Memory Usage
blockreassurance	7.265 ms	0.12 Mb
__construct	6.932 ms	0.11 Mb
hookActionFrontControllerSetMedia	0.316 ms	0.01 Mb
hookDisplayAfterBodyOpeningTag	0.017 ms	- Mb
ps_emailsubscription	4.147 ms	0.07 Mb
__construct	1.386 ms	0.03 Mb
hookActionFrontControllerSetMedia	0.239 ms	- Mb
displayFooterbefore	2.522 ms	0.04 Mb
ps_socialfollow	2.637 ms	0.07 Mb
__construct	0.114 ms	0.02 Mb
hookActionFrontControllerSetMedia	0.100 ms	- Mb
displayFooterleft	2.423 ms	0.05 Mb
ps_emailalerts	0.305 ms	0.04 Mb
__construct	0.241 ms	0.04 Mb
hookActionFrontControllerSetMedia	0.064 ms	- Mb
ps_shoppingcart	5.905 ms	0.14 Mb
__construct	0.168 ms	0.02 Mb
hookDisplayHeader	0.102 ms	- Mb
displayHeaderRight	5.635 ms	0.12 Mb
ps_googleanalytics	12.096 ms	0.21 Mb
__construct	0.159 ms	0.03 Mb
hookDisplayHeader	0.919 ms	0.02 Mb
hookDisplayBeforeBodyClosingTag	11.018 ms	0.16 Mb
cp_sideverticalmenu	19.782 ms	0.51 Mb
__construct	0.457 ms	0.03 Mb
hookDisplayHeader	0.073 ms	- Mb
displayHeaderLeft	19.252 ms	0.48 Mb
cp_imageslider	0.376 ms	0.04 Mb
__construct	0.233 ms	0.04 Mb
hookDisplayHeader	0.143 ms	- Mb
cp_themeoptions	13.594 ms	0.23 Mb
__construct	10.739 ms	0.14 Mb
hookDisplayHeader	0.764 ms	0.01 Mb
displayFooter	2.070 ms	0.07 Mb
hookDisplayFooterAfter	0.021 ms	- Mb
cp_countdown	0.341 ms	0.02 Mb
__construct	0.227 ms	0.02 Mb
hookDisplayHeader	0.114 ms	- Mb
stfeature	26.489 ms	0.33 Mb
__construct	0.353 ms	0.14 Mb
hookDisplayHeader	6.037 ms	0.01 Mb
hookDisplayStWishlistTopLink	1.789 ms	0.04 Mb
hookDisplayStCompareTopLink	1.391 ms	0.04 Mb
hookDisplayStCompareTopLink	1.070 ms	0.03 Mb
hookDisplayStWishlistTopLink	0.260 ms	- Mb
hookDisplayStCompareButton	0.560 ms	0.01 Mb
hookDisplayStWishlistButton	0.397 ms	0.01 Mb
hookDisplayStCompareButton	0.532 ms	- Mb
hookDisplayStWishlistButton	0.283 ms	- Mb
hookDisplayStCompareButton	0.397 ms	- Mb
hookDisplayStWishlistButton	0.271 ms	- Mb
hookDisplayStCompareButton	0.406 ms	- Mb
hookDisplayStWishlistButton	0.274 ms	- Mb
hookDisplayStCompareButton	0.285 ms	- Mb
hookDisplayStWishlistButton	0.268 ms	- Mb
hookDisplayStCompareButton	0.360 ms	- Mb
hookDisplayStWishlistButton	0.283 ms	- Mb
hookDisplayStCompareButton	0.372 ms	- Mb
hookDisplayStWishlistButton	0.274 ms	- Mb
hookDisplayStCompareButton	0.371 ms	- Mb
hookDisplayStWishlistButton	0.274 ms	- Mb
hookDisplayStCompareButton	0.324 ms	- Mb
hookDisplayStWishlistButton	0.252 ms	- Mb
hookDisplayStCompareButton	0.315 ms	- Mb
hookDisplayStWishlistButton	0.257 ms	- Mb
hookDisplayStCompareButton	0.322 ms	- Mb
hookDisplayStWishlistButton	0.257 ms	- Mb
hookDisplayStCompareButton	0.340 ms	- Mb
hookDisplayStWishlistButton	0.266 ms	- Mb
hookDisplayStCompareButton	0.323 ms	- Mb
hookDisplayStWishlistButton	0.307 ms	- Mb
hookDisplayStCompareButton	0.290 ms	- Mb
hookDisplayStWishlistButton	0.267 ms	- Mb
hookDisplayStCompareButton	0.356 ms	- Mb
hookDisplayStWishlistButton	0.258 ms	- Mb
hookDisplayStCompareButton	0.353 ms	- Mb
hookDisplayStWishlistButton	0.246 ms	- Mb
hookDisplayStCompareButton	0.300 ms	- Mb
hookDisplayStWishlistButton	0.309 ms	- Mb
hookDisplayStCompareButton	0.292 ms	- Mb
hookDisplayStWishlistButton	0.263 ms	- Mb
hookDisplayStCompareButton	0.421 ms	- Mb
hookDisplayStWishlistButton	0.306 ms	- Mb
hookDisplayStCompareButton	0.414 ms	- Mb
hookDisplayStWishlistButton	0.307 ms	- Mb
hookDisplayStCompareButton	0.335 ms	- Mb
hookDisplayStWishlistButton	0.272 ms	- Mb
hookDisplayStCompareButton	0.325 ms	- Mb
hookDisplayStWishlistButton	0.271 ms	- Mb
hookDisplayStCompareButton	0.420 ms	- Mb
hookDisplayStWishlistButton	0.288 ms	- Mb
hookDisplayStCompareButton	0.382 ms	- Mb
hookDisplayStWishlistButton	0.345 ms	- Mb
ets_whatsapp	1.045 ms	0.06 Mb
__construct	0.252 ms	0.03 Mb
hookDisplayHeader	0.193 ms	- Mb
hookDisplayFooter	0.600 ms	0.03 Mb
ps_facetedsearch	4.179 ms	0.29 Mb
__construct	0.802 ms	0.05 Mb
hookProductSearchProvider	0.596 ms	0.01 Mb
hookDisplayLeftColumn	2.781 ms	0.23 Mb
cp_headercms2	8.465 ms	0.11 Mb
__construct	0.319 ms	0.02 Mb
displayBanner	8.146 ms	0.09 Mb
cp_headercms1	7.204 ms	0.11 Mb
__construct	0.285 ms	0.02 Mb
displayNav1	4.531 ms	0.06 Mb
displaySide	2.388 ms	0.03 Mb
ps_contactinfo	9.765 ms	0.17 Mb
__construct	0.174 ms	0.08 Mb
displayNav1	7.692 ms	0.06 Mb
displayFooterleft	1.899 ms	0.02 Mb
ps_customersignin	3.165 ms	0.06 Mb
__construct	0.151 ms	0.02 Mb
displayNav2	2.348 ms	0.04 Mb
displayCustomerSide	0.666 ms	- Mb
pagesnotfound	0.228 ms	0.02 Mb
__construct	0.147 ms	0.02 Mb
hookDisplayTop	0.081 ms	- Mb
ps_mainmenu	7.223 ms	0.36 Mb
__construct	0.165 ms	0.03 Mb
displayNavFullWidth	7.058 ms	0.34 Mb
cp_leftbanner1	7.501 ms	0.11 Mb
__construct	0.360 ms	0.03 Mb
displayLeftColumn	7.141 ms	0.07 Mb
cp_sidebarfeaturedproducts	759.441 ms	4.12 Mb
__construct	1.107 ms	0.02 Mb
displayLeftColumn	758.334 ms	4.10 Mb
cp_imagehover	45.616 ms	0.37 Mb
__construct	2.653 ms	0.02 Mb
hookDisplayCpHoverImage	14.495 ms	0.03 Mb
hookDisplayCpHoverImage	9.094 ms	0.03 Mb
hookDisplayCpHoverImage	2.235 ms	0.03 Mb
hookDisplayCpHoverImage	2.298 ms	0.03 Mb
hookDisplayCpHoverImage	1.574 ms	0.03 Mb
hookDisplayCpHoverImage	1.626 ms	0.03 Mb
hookDisplayCpHoverImage	1.530 ms	0.03 Mb
hookDisplayCpHoverImage	1.597 ms	0.03 Mb
hookDisplayCpHoverImage	1.445 ms	0.03 Mb
hookDisplayCpHoverImage	1.626 ms	0.03 Mb
hookDisplayCpHoverImage	1.653 ms	0.03 Mb
hookDisplayCpHoverImage	3.790 ms	0.03 Mb
ps_linklist	31.486 ms	0.92 Mb
__construct	0.530 ms	0.02 Mb
displayFooter	30.956 ms	0.89 Mb
cp_parallaximages	2.949 ms	0.06 Mb
__construct	0.406 ms	0.02 Mb
displayFooter	2.543 ms	0.05 Mb
cp_footercms1	4.014 ms	0.09 Mb
__construct	0.449 ms	0.02 Mb
displayFooterAfter	3.565 ms	0.06 Mb
25 module(s)	985 ms	8.61 Mb

Left Banner

Produit le plus vu

Produit le plus vu

FLASH DISQUE 8GB HIKSEMI...

رحلة نمرود

Calendrier mural islamique...

DEVOIRS DE SYNTHESE 1 ERE...

Palette artistique avec 26...

CUTTER Utilitaire DL,...

MA BASE 6ème

JOURNAL DE CLASSE

Fournitures

Sous-catégories

Fournitures Scolaires

Fournitures Bureautiques

Contactez-nous

Produits

Notre société

Information

Stopwatch SQL - 625 queries

Doubles

Tables stress

ObjectModel instances

Included Files

45 queries	SELECT SUM(quantity) FROM `preXX_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
32 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `preXX_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
26 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT SUM(cp.`quantity`) as first_level_quantity, XX as pack_quantity FROM `preXX_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, SUM(cp.`quantity` * p.`quantity`) as pack_quantity FROM `preXX_cart_product` cp JOIN `preXX_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `preXX_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
23 queries	SELECT a.`id_attribute`, a.`id_attribute_group`, al.`name`, agl.`name` as `group`, agl.`public_name` as `public_group`, pa.`reference`, pa.`eanXX`, pa.`isbn`, pa.`upc`, pa.`mpn`, pal.`available_now`, pal.`available_later` FROM `preXX_attribute` a LEFT JOIN `preXX_attribute_lang` al ON (al.`id_attribute` = a.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `preXX_product_attribute_combination` pac ON (pac.`id_attribute` = a.`id_attribute`) LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product_attribute` = pac.`id_product_attribute`) INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN `preXX_product_attribute_lang` pal ON (pal.`id_product_attribute` = pac.`id_product_attribute` AND pal.`id_lang` = XX) LEFT JOIN `preXX_attribute_group_lang` agl ON (a.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pa.`id_product` = XX AND pac.`id_product_attribute` = XX AND agl.`id_lang` = XX
21 queries	SELECT XX FROM `preXX_specific_price` WHERE id_product = XX LIMIT XX
20 queries	SELECT image_shop.`id_image` FROM `preXX_image` i INNER JOIN preXX_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) WHERE i.`id_product` = XX AND image_shop.`cover` = XX LIMIT XX
20 queries	SELECT name FROM preXX_category_lang WHERE id_shop = XX AND id_lang = XX AND id_category = XX LIMIT XX
20 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `preXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
20 queries	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `preXX_product` p INNER JOIN `preXX_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `preXX_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
20 queries	SELECT `id_tax_rules_group` FROM `preXX_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
20 queries	SELECT `reduction` FROM `preXX_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
20 queries	SELECT COUNT(*) FROM `preXX_pack` WHERE id_product_pack = XX LIMIT XX
20 queries	SELECT product_type FROM `preXX_product` WHERE id_product = XX LIMIT XX
20 queries	SELECT name, value, pf.id_feature, f.position, fvl.id_feature_value FROM preXX_feature_product pf LEFT JOIN preXX_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN preXX_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN preXX_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN preXX_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position ASC
20 queries	SELECT `id_product_attribute` FROM `preXX_product_attribute` WHERE `id_product` = XX
16 queries	SELECT `id_module` FROM `preXX_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
13 queries	SELECT cl.`link_rewrite` FROM `preXX_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
12 queries	SELECT pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > XX, XX, XX)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `preXX_product_attribute` pa INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) LEFT JOIN preXX_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) JOIN `preXX_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `preXX_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `preXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) JOIN `preXX_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (XX) AND ag.`is_color_group` = XX GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > XX ORDER BY a.`position` ASC;
10 queries	SELECT fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM preXX_product p LEFT JOIN preXX_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN preXX_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN preXX_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, XX) = sa.id_product_attribute AND sa.id_shop = XX AND sa.id_shop_group = XX ) LEFT JOIN preXX_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN preXX_category_product cp ON (p.id_product = cp.id_product) INNER JOIN preXX_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN preXX_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN preXX_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND p.id_manufacturer IN (XX, XX, XX, XX, XX, XX, XX, XX, XX) AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p INNER JOIN preXX_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=XX)) GROUP BY fp.id_feature_value
8 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
8 queries	SELECT p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, XX) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( 'XX-XX-XX XX:XX:XX', INTERVAL XX DAY ) ) > XX) as new FROM preXX_product p LEFT JOIN preXX_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN preXX_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN preXX_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
6 queries	SELECT `name` FROM `preXX_manufacturer` WHERE `id_manufacturer` = XX AND `active` = XX LIMIT XX
6 queries	SELECT product_attribute_shop.`price` FROM `preXX_product_attribute` pa INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product_attribute` = XX LIMIT XX
6 queries	SELECT pa.`available_date` FROM `preXX_product` p LEFT JOIN `preXX_product_attribute` pa ON (pa.`id_product` = p.`id_product`) INNER JOIN preXX_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = XX) INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE p.`id_product` = XX AND pa.`id_product` = XX AND pa.`id_product_attribute` = XX LIMIT XX
6 queries	SELECT * FROM `preXX_product_attribute` a LEFT JOIN `preXX_product_attribute_shop` `c` ON a.`id_product_attribute` = c.`id_product_attribute` AND c.`id_shop` = XX WHERE (a.`id_product_attribute` = XX) LIMIT XX
6 queries	SELECT * FROM `preXX_product_attribute_lang` WHERE `id_product_attribute` = XX
6 queries	SELECT * FROM `preXX_product` a LEFT JOIN `preXX_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) LIMIT XX
6 queries	SELECT * FROM `preXX_product_lang` WHERE `id_product` = XX AND `id_shop` = XX
6 queries	SELECT pa., product_attribute_shop. FROM `preXX_product_attribute` pa INNER JOIN preXX_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.`id_product` = XX GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`
5 queries	SELECT * FROM `preXX_cms` a LEFT JOIN `preXX_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) LIMIT XX
5 queries	SELECT * FROM `preXX_cms_lang` WHERE `id_cms` = XX AND `id_shop` = XX
5 queries	SELECT al.`name` AS attribute_name FROM `preXX_product_attribute_combination` pac LEFT JOIN `preXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `preXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `preXX_attribute_lang` al ON ( a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX ) WHERE pac.`id_product_attribute` = XX ORDER BY ag.`position` ASC, a.`position` ASC
4 queries	SELECT `id_lang` FROM `preXX_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
4 queries	SELECT tr.* FROM `preXX_tax_rule` tr JOIN `preXX_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC
3 queries	SELECT `need_identification_number` FROM `preXX_country` WHERE `id_country` = XX LIMIT XX
3 queries	SELECT v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `preXX_feature_value` v LEFT JOIN `preXX_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = XX) LEFT JOIN `preXX_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = XX) WHERE v.`id_feature` = XX ORDER BY vl.`value` ASC
3 queries	SELECT pai.`id_image`, pai.`id_product_attribute`, il.`legend` FROM `preXX_product_attribute_image` pai LEFT JOIN `preXX_image_lang` il ON (il.`id_image` = pai.`id_image`) LEFT JOIN `preXX_image` i ON (i.`id_image` = pai.`id_image`) WHERE pai.`id_product_attribute` IN (XX, XX, XX, XX) AND il.`id_lang` = XX ORDER by i.`position`
3 queries	SELECT * FROM `preXX_cpheadercmsXXblockinfo_lang` WHERE `id_lang` = XX AND `id_shop` = XX LIMIT XX
3 queries	SELECT pac.id_product_attribute, GROUP_CONCAT(agl.`name`, ' - ',al.`name` ORDER BY agl.`id_attribute_group` SEPARATOR ', ') as attribute_designation FROM `preXX_product_attribute_combination` pac LEFT JOIN `preXX_attribute` a ON a.`id_attribute` = pac.`id_attribute` LEFT JOIN `preXX_attribute_group` ag ON ag.`id_attribute_group` = a.`id_attribute_group` LEFT JOIN `preXX_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) LEFT JOIN `preXX_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) WHERE pac.id_product_attribute IN (XX,XX,XX,XX) GROUP BY pac.id_product_attribute ORDER BY pac.id_product_attribute
3 queries	SELECT * FROM `preXX_link_block` a LEFT JOIN `preXX_link_block_shop` `c` ON a.`id_link_block` = c.`id_link_block` AND c.`id_shop` = XX WHERE (a.`id_link_block` = XX) LIMIT XX
3 queries	SELECT * FROM `preXX_link_block_lang` WHERE `id_link_block` = XX
2 queries	SELECT * FROM `preXX_currency` a LEFT JOIN `preXX_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `preXX_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
2 queries	SELECT `id_category` FROM `preXX_category_shop` WHERE `id_category` = XX AND `id_shop` = XX LIMIT XX
2 queries	SELECT ctg.`id_group` FROM preXX_category_group ctg WHERE ctg.`id_category` = XX AND ctg.`id_group` = XX LIMIT XX
2 queries	SELECT m.*, ml.`description`, ml.`short_description` FROM `preXX_manufacturer` m INNER JOIN preXX_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = XX)INNER JOIN `preXX_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = XX)WHERE XX AND m.`active` = XX ORDER BY m.`name` ASC
2 queries	SELECT * FROM `preXX_category` a LEFT JOIN `preXX_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
2 queries	SELECT * FROM `preXX_category_lang` WHERE `id_category` = XX AND `id_shop` = XX
2 queries	SELECT `id_module` FROM `preXX_module` WHERE `name` = "cp_headercmsXX" LIMIT XX
2 queries	SELECT DISTINCT `id_product` FROM `preXX_stfeature_compare` c LEFT JOIN `preXX_stfeature_compare_product` cp ON (cp.`id_compare` = c.`id_compare`) WHERE cp.`id_compare` = XX

Name	Instances	Source
Product	96	/classes/Link.php:113 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3682] /classes/Link.php:113 (__construct) [id: 3699] /classes/Link.php:113 (__construct) [id: 3723] /classes/Link.php:113 (__construct) [id: 3733] /classes/Link.php:113 (__construct) [id: 3743] /classes/Link.php:113 (__construct) [id: 3744] /classes/Link.php:113 (__construct) [id: 3823] /classes/Link.php:113 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3835] /classes/Link.php:113 (__construct) [id: 3836] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3662] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3677] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3682] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3699] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3723] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3733] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3743] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3744] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3823] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3834] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3835] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3682] /classes/Link.php:113 (__construct) [id: 3699] /classes/Link.php:113 (__construct) [id: 3723] /classes/Link.php:113 (__construct) [id: 3733] /classes/Link.php:113 (__construct) [id: 3743] /classes/Link.php:113 (__construct) [id: 3744] /classes/Link.php:113 (__construct) [id: 3823] /classes/Link.php:113 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3835] /classes/Link.php:113 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 4908] /classes/Link.php:113 (__construct) [id: 4207] /classes/Link.php:113 (__construct) [id: 3112] /classes/Link.php:113 (__construct) [id: 4234] /classes/Link.php:113 (__construct) [id: 4724] /classes/Link.php:113 (__construct) [id: 3152] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4908] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 2417] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4207] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3112] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4234] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 4724] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 1537] /src/Adapter/Image/ImageRetriever.php:80 (__construct) [id: 3152] /classes/Link.php:113 (__construct) [id: 4908] /classes/Link.php:113 (__construct) [id: 4207] /classes/Link.php:113 (__construct) [id: 3112] /classes/Link.php:113 (__construct) [id: 4234] /classes/Link.php:113 (__construct) [id: 4724] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 4724] /classes/Link.php:113 (__construct) [id: 3152] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3662] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3662] /classes/Link.php:113 (__construct) [id: 3662] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3677] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /classes/Link.php:113 (__construct) [id: 3677] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3682] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3699] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 3699] /classes/Link.php:113 (__construct) [id: 3699] /classes/Link.php:113 (__construct) [id: 3699] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3723] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3733] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3743] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3744] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3823] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3834] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3834] /classes/Link.php:113 (__construct) [id: 3834] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3835] /modules/cp_imagehover/cp_imagehover.php:69 (__construct) [id: 3836] /src/Adapter/Presenter/Product/ProductLazyArray.php:658 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 3836] /classes/Link.php:113 (__construct) [id: 3836]
Category	18	/controllers/front/listing/CategoryController.php:78 (__construct) [id: 90] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 117] /controllers/front/listing/CategoryController.php:216 (__construct) [id: 92] /classes/Meta.php:379 (__construct) [id: 90] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 90] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 90] /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:271 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Meta.php:379 (__construct) [id: 62] /classes/Link.php:402 (__construct) [id: 62] /classes/Meta.php:379 (__construct) [id: 89] /classes/Link.php:402 (__construct) [id: 89] /classes/Meta.php:379 (__construct) [id: 79] /classes/Link.php:402 (__construct) [id: 79] /classes/Meta.php:379 (__construct) [id: 5] /classes/Link.php:402 (__construct) [id: 5]
Country	8	/config/config.inc.php:146 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /classes/controller/FrontController.php:1769 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 208] /classes/AddressFormat.php:404 (__construct) [id: 208] /modules/ps_contactinfo/ps_contactinfo.php:105 (__construct) [id: 208] /modules/ets_whatsapp/ets_whatsapp.php:498 (__construct) [id: 208]
CMS	6	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 0] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 4] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 1] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 2] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 3] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:138 (__construct) [id: 5]
Combination	6	/classes/Product.php:5923 (__construct) [id: 669] /classes/Product.php:5923 (__construct) [id: 744] /classes/Product.php:5923 (__construct) [id: 816] /classes/Product.php:5923 (__construct) [id: 838] /classes/Product.php:5923 (__construct) [id: 846] /classes/Product.php:5923 (__construct) [id: 1395]
State	5	/classes/controller/FrontController.php:1768 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:94 (__construct) [id: 369] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 369]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5975 (__construct) [id: ]
Hook	3	/modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45] /modules/ps_linklist/src/Presenter/LinkBlockPresenter.php:64 (__construct) [id: 45]
PrestaShop\Module\LinkList\Model\LinkBlock	3	/modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 1] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 2] /modules/ps_linklist/src/LegacyLinkBlockRepository.php:91 (__construct) [id: 3]
Currency	3	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:696 (getCurrencyInstance) [id: 2]
AddressFormat	3	/classes/controller/FrontController.php:1763 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:91 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:561 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:467 (__construct) [id: ] /classes/controller/FrontController.php:541 (__construct) [id: ]
Tax	2	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 33] /classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 33]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Gender	1	/classes/controller/FrontController.php:1692 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Customer	1	/config/config.inc.php:264 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
Risk	1	/classes/controller/FrontController.php:1695 (__construct) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
63	SELECT SQL_NO_CACHE p.id_manufacturer, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p GROUP BY p.id_manufacturer	315.092 ms	61058596	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:661 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
340	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("2026-05-03 00:00:00", INTERVAL 60 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `pre5554_category_product` cp LEFT JOIN `pre5554_product` p ON p.`id_product` = cp.`id_product` INNER JOIN pre5554_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre5554_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 pre5554_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 `pre5554_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `pre5554_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `pre5554_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 `pre5554_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `pre5554_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 8	313.162 ms	3969	Yes		/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:299 (runQuery) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:258 (getProducts) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:244 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:285 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:93 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
61	SELECT SQL_NO_CACHE cp.id_category, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE cg.id_group='1' AND c.nleft>155 AND c.nright<376 GROUP BY cp.id_category	42.323 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:992 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:158 (getCategoriesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
68	SELECT SQL_NO_CACHE pac.id_attribute, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN pre5554_attribute a ON (a.id_attribute = pac.id_attribute) WHERE ((a.id_attribute_group=1)) GROUP BY pac.id_attribute	31.239 ms	72200	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:737 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
71	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=5)) GROUP BY fp.id_feature_value	30.013 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
457	SELECT SQL_NO_CACHE COUNT(cp.`id_product`) AS total FROM `pre5554_product` p INNER JOIN pre5554_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `pre5554_category_product` cp ON p.`id_product` = cp.`id_product` WHERE cp.`id_category` = 2 AND product_shop.`visibility` IN ("both", "catalog") AND product_shop.`active` = 1 LIMIT 1	28.357 ms	3907			/classes/Category.php:991 /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:106 (getProductsOrCount) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:299 (runQuery) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:258 (getProducts) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:244 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:285 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:93 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
78	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=15)) GROUP BY fp.id_feature_value	27.216 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
73	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=7)) GROUP BY fp.id_feature_value	25.604 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
69	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=3)) GROUP BY fp.id_feature_value	24.649 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
59	SELECT SQL_NO_CACHE p.id_product FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) GROUP BY p.id_product ORDER BY p.position ASC, p.id_product DESC	24.521 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Filters/Products.php:87 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:189 (getProductByFilters) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
79	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=16)) GROUP BY fp.id_feature_value	23.143 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
77	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=14)) GROUP BY fp.id_feature_value	20.114 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
91	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `pre5554_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `pre5554_hook_alias` ha INNER JOIN `pre5554_hook` h ON ha.name = h.name	20.043 ms	0			/classes/Hook.php:1348 /classes/Hook.php:228 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
74	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=9)) GROUP BY fp.id_feature_value	19.770 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
10	SELECT SQL_NO_CACHE domain, domain_ssl FROM pre5554_shop_url WHERE main = 1 AND id_shop = 1 LIMIT 1	19.094 ms	1			/classes/shop/ShopUrl.php:182 /classes/shop/ShopUrl.php:198 (cacheMainDomainForShop) /classes/Tools.php:303 (getMainShopDomain) /classes/Link.php:65 (getShopDomain) /config/config.inc.php:277 (__construct) /index.php:27 (require)
75	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=11)) GROUP BY fp.id_feature_value	18.528 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
2	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 `pre5554_configuration` c LEFT JOIN `pre5554_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	16.308 ms	507			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
65	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=2)) GROUP BY fp.id_feature_value	15.104 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
70	SELECT SQL_NO_CACHE fp.id_feature, fp.id_feature_value, COUNT(DISTINCT p.id_product) c FROM (SELECT p.id_product, p.id_manufacturer, SUM(sa.quantity) as quantity, p.condition, p.weight, p.price, psales.quantity as sales, p.on_sale, p.date_add, cp.position FROM pre5554_product p LEFT JOIN pre5554_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN pre5554_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN pre5554_stock_available sa ON (p.id_product = sa.id_product AND IFNULL(pac.id_product_attribute, 0) = sa.id_product_attribute AND sa.id_shop = 1 AND sa.id_shop_group = 0 ) LEFT JOIN pre5554_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN pre5554_category_product cp ON (p.id_product = cp.id_product) INNER JOIN pre5554_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN pre5554_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN pre5554_category_group cg ON (cg.id_category = c.id_category) WHERE ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND p.id_manufacturer IN (52, 78, 74, 46, 144, 14, 50, 37, 61) AND c.nleft>=155 AND c.nright<=376 GROUP BY p.id_product) p INNER JOIN pre5554_feature_product fp ON (p.id_product = fp.id_product) WHERE ((fp.id_feature=4)) GROUP BY fp.id_feature_value	14.759 ms	36100	Yes		/modules/ps_facetedsearch/src/Adapter/MySQL.php:85 /modules/ps_facetedsearch/src/Adapter/MySQL.php:808 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:855 (valueCount) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
92	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, m.active FROM `pre5554_hook_module` hm STRAIGHT_JOIN `pre5554_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `pre5554_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	14.601 ms	336			/classes/Hook.php:459 /classes/Hook.php:496 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:3925 (getManager) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
76	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `pre5554_feature_value` v LEFT JOIN `pre5554_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre5554_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 11 ORDER BY vl.`value` ASC	14.520 ms	35	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	SELECT SQL_NO_CACHE * FROM `pre5554_currency` c ORDER BY `iso_code` ASC	14.105 ms	1	Yes		/classes/Currency.php:709 /src/Adapter/Currency/CurrencyDataProvider.php:84 (findAllInstalled) /src/Core/Localization/Currency/DataLayer/CurrencyInstalled.php:90 (findAllInstalled) /src/Core/Localization/Currency/CurrencyDataSource.php:96 (getAllInstalledCurrencyIsoCodes) /src/Core/Localization/Currency/Repository.php:87 (getAllInstalledCurrenciesData) /src/Core/Localization/Locale/Repository.php:207 (getAllInstalledCurrencies) /src/Core/Localization/Locale/Repository.php:150 (getPriceSpecifications) /classes/controller/Controller.php:209 (getLocale) /classes/controller/FrontController.php:284 (init) /controllers/front/listing/CategoryController.php:81 (init) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
3	SELECT SQL_NO_CACHE * FROM `pre5554_shop` a WHERE (a.`id_shop` = 1) LIMIT 1	13.905 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:145 (__construct) /classes/shop/Shop.php:431 (__construct) /config/config.inc.php:117 (initialize) /index.php:27 (require)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `pre5554_hook` h WHERE (h.active = 1)	13.596 ms	885			/classes/Hook.php:1388 /classes/Hook.php:817 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
493	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `pre5554_image` i INNER JOIN pre5554_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `pre5554_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 3662 ORDER BY `position`	13.587 ms	1	Yes		/classes/Product.php:3545 /modules/cp_imagehover/cp_imagehover.php:70 (getImages) /classes/Hook.php:1083 (hookDisplayCpHoverImage) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:421 (coreCallHook) /classes/Hook.php:989 (callHookOn) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/5b/bf/34/5bbf343ab38c63e7e320c8012fb6fa21135da331_2.file.product-listgrid.tpl.php:155 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/5b/bf/34/5bbf343ab38c63e7e320c8012fb6fa21135da331_2.file.product-listgrid.tpl.php:36 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fee78dad6_82558261) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/57/08/3f/57083f5151537e06997c890c7068a0f92bef445a_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/57/08/3f/57083f5151537e06997c890c7068a0f92bef445a_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fedc7d211_82695712) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:98 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
497	SELECT SQL_NO_CACHE pa., product_attribute_shop. FROM `pre5554_product_attribute` pa INNER JOIN pre5554_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` = 3662 GROUP BY pa.`id_product_attribute` ORDER BY pa.`id_product_attribute`	11.953 ms	4	Yes	Yes	/classes/Product.php:2734 /src/Adapter/Presenter/Product/ProductLazyArray.php:663 (getAttributesResume) /src/Adapter/Presenter/Product/ProductLazyArray.php:505 (shouldShowOutOfStockLabel) /src/Adapter/Presenter/AbstractLazyArray.php:269 (getFlags) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/c0/25/bf/c025bf5ba5dfc8e3e49b05d630148cfff0edfaa4_2.file.product-flags.tpl.php:44 (offsetGet) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/c0/25/bf/c025bf5ba5dfc8e3e49b05d630148cfff0edfaa4_2.file.product-flags.tpl.php:26 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fee902609_30698169) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/5b/bf/34/5bbf343ab38c63e7e320c8012fb6fa21135da331_2.file.product-listgrid.tpl.php:39 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fee78dad6_82558261) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/57/08/3f/57083f5151537e06997c890c7068a0f92bef445a_2.file.products.tpl.php:70 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/57/08/3f/57083f5151537e06997c890c7068a0f92bef445a_2.file.products.tpl.php:40 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fedc7d211_82695712) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:121 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:216 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:186 (process) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:324 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:98 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
0	SELECT SQL_NO_CACHE s.id_shop, CONCAT(su.physical_uri, su.virtual_uri) AS uri, su.domain, su.main FROM pre5554_shop_url su LEFT JOIN pre5554_shop s ON (s.id_shop = su.id_shop) WHERE (su.domain = 'schoolmarket.tn' OR su.domain_ssl = 'schoolmarket.tn') AND s.active = 1 AND s.deleted = 0 ORDER BY LENGTH(CONCAT(su.physical_uri, su.virtual_uri)) DESC	10.608 ms	1	Yes		/classes/shop/Shop.php:1364 /classes/shop/Shop.php:355 (findShopByHost) /config/config.inc.php:117 (initialize) /index.php:27 (require)
55	SELECT SQL_NO_CACHE DISTINCT f.id_feature, f., fl., IF(liflv.`url_name` IS NULL OR liflv.`url_name` = "", NULL, liflv.`url_name`) AS url_name, IF(liflv.`meta_title` IS NULL OR liflv.`meta_title` = "", NULL, liflv.`meta_title`) AS meta_title, lif.indexable FROM `pre5554_feature` f INNER JOIN pre5554_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 1) LEFT JOIN `pre5554_feature_lang` fl ON (f.`id_feature` = fl.`id_feature` AND fl.`id_lang` = 1) LEFT JOIN `pre5554_layered_indexable_feature` lif ON (f.`id_feature` = lif.`id_feature`) LEFT JOIN `pre5554_layered_indexable_feature_lang_value` liflv ON (f.`id_feature` = liflv.`id_feature` AND liflv.`id_lang` = 1) ORDER BY f.`position` ASC	10.361 ms	12	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:171 /modules/ps_facetedsearch/src/Filters/Converter.php:388 (getFeatures) /modules/ps_facetedsearch/src/Product/SearchProvider.php:165 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
80	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2026-05-03 00:00:00', INTERVAL 60 DAY ) ) > 0) as new FROM pre5554_product p LEFT JOIN pre5554_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN pre5554_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN pre5554_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (3662,3677,3682,3699,3723,3733,3743,3744,3823,3834,3835,3836)	10.323 ms	12			/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
44	SELECT SQL_NO_CACHE * FROM `pre5554_image_type` WHERE 1 AND `products` = 1 ORDER BY `width` DESC, `height` DESC, `name`ASC	10.226 ms	8	Yes		/classes/ImageType.php:109 /src/Adapter/Image/ImageRetriever.php:381 (getImagesTypes) /classes/controller/FrontController.php:1617 (getNoPictureImage) /classes/controller/FrontController.php:1743 (getTemplateVarUrls) /classes/controller/FrontController.php:563 (getTemplateVarShop) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
36	SELECT SQL_NO_CACHE * FROM `pre5554_category` a LEFT JOIN `pre5554_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `pre5554_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 117) AND (b.`id_shop` = 1) LIMIT 1	10.028 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:216 (__construct) :undefined ({closure}) /controllers/front/listing/CategoryController.php:230 (array_map) /controllers/front/listing/CategoryController.php:118 (getTemplateVarSubCategories) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
362	SELECT SQL_NO_CACHE product_type FROM `pre5554_product` WHERE id_product = 2417 LIMIT 1	10.021 ms	1			/classes/Pack.php:90 /classes/Product.php:4344 (isPack) /classes/Product.php:5813 (getQuantity) /classes/Product.php:6001 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /src/Adapter/Category/CategoryProductSearchProvider.php:79 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:299 (runQuery) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:258 (getProducts) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:244 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:285 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:93 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `pre5554_module` m INNER JOIN pre5554_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 `pre5554_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `pre5554_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `pre5554_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.886 ms	63	Yes	Yes	/classes/Hook.php:1289 /classes/Hook.php:738 (getAllHookRegistrations) /classes/Hook.php:848 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
66	SELECT SQL_NO_CACHE v., vl., IF(lifvlv.`url_name` IS NULL OR lifvlv.`url_name` = "", NULL, lifvlv.`url_name`) AS url_name, IF(lifvlv.`meta_title` IS NULL OR lifvlv.`meta_title` = "", NULL, lifvlv.`meta_title`) AS meta_title FROM `pre5554_feature_value` v LEFT JOIN `pre5554_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `pre5554_layered_indexable_feature_value_lang_value` lifvlv ON (v.`id_feature_value` = lifvlv.`id_feature_value` AND lifvlv.`id_lang` = 1) WHERE v.`id_feature` = 2 ORDER BY vl.`value` ASC	9.666 ms	25	Yes		/modules/ps_facetedsearch/src/Filters/DataAccessor.php:204 /modules/ps_facetedsearch/src/Filters/Block.php:864 (getFeatureValues) /modules/ps_facetedsearch/src/Filters/Block.php:154 (getFeaturesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (getFilterBlock) /classes/controller/ProductListingFrontController.php:357 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE tr.* FROM `pre5554_tax_rule` tr JOIN `pre5554_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = 1 AND tr.`id_country` = 208 AND tr.`id_tax_rules_group` = 6 AND tr.`id_state` IN (0, 369) AND ('3052' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = 0 AND tr.`zipcode_from` IN(0, '3052'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC	9.480 ms	1	Yes		/classes/tax/TaxRulesTaxManager.php:109 /classes/Product.php:3926 (getTaxCalculator) /classes/Product.php:3717 (priceCalculation) /classes/Product.php:5703 (getPriceStatic) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
7	SELECT SQL_NO_CACHE * FROM `pre5554_shop_group` a WHERE (a.`id_shop_group` = 1) LIMIT 1	9.386 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/shop/Shop.php:561 (__construct) /config/config.inc.php:171 (getGroup) /index.php:27 (require)
479	SELECT SQL_NO_CACHE * FROM `pre5554_product` a LEFT JOIN `pre5554_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `pre5554_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 1537) AND (b.`id_shop` = 1) LIMIT 1	9.075 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /src/Adapter/Image/ImageRetriever.php:80 (__construct) /src/Adapter/Presenter/Product/ProductLazyArray.php:684 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:127 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:57 (__construct) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:323 (present) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:258 (getProducts) /modules/cp_sidebarfeaturedproducts/cp_sidebarfeaturedproducts.php:244 (getWidgetVariables) /classes/Hook.php:1094 (renderWidget) /tools/profiling/Hook.php:64 (coreRenderWidget) /classes/Hook.php:1025 (coreRenderWidget) /config/smarty.config.inc.php:201 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:285 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/fc/a5/98/fca598ef3356728f1c316839ff9d0f887ba728bb_2.file.layout-both-columns.tpl.php:93 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe12e9370_67496615) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/1e/66/db/1e66dbfc69ad4ac26a01d71888a6cca5682f7aef_2.file.product-list.tpl.php:44 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe1095515_69914965) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:116 (_subTemplateRender) /var/cache/dev/smarty/compile/PRS01001layouts_layout_both_columns_tpl/2b/37/d1/2b37d1cad4f545d686c547590ff5553ded26848b_2.file.category.tpl.php:40 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_69f72fe0eaaef9_84358041) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:771 (fetch) /classes/controller/FrontController.php:753 (smartyOutputContent) /tools/profiling/Controller.php:111 (display) /tools/profiling/Controller.php:88 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
84	SELECT SQL_NO_CACHE * FROM `pre5554_product` a LEFT JOIN `pre5554_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `pre5554_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 3662) AND (b.`id_shop` = 1) LIMIT 1	8.611 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Link.php:113 (__construct) /classes/Link.php:189 (getProductObject) /classes/Product.php:5671 (getProductLink) /classes/ProductAssembler.php:209 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:379 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:139 (doProductSearch) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE * FROM `pre5554_category` a LEFT JOIN `pre5554_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = 1 LEFT JOIN `pre5554_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = 1 WHERE (a.`id_category` = 90) AND (b.`id_shop` = 1) LIMIT 1	8.004 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Category.php:164 (__construct) /controllers/front/listing/CategoryController.php:78 (__construct) /tools/profiling/Controller.php:46 (init) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
46	SELECT SQL_NO_CACHE `need_identification_number` FROM `pre5554_country` WHERE `id_country` = 208 LIMIT 1	7.918 ms	1			/classes/Country.php:405 /classes/AddressFormat.php:634 (isNeedDniByCountryId) /classes/AddressFormat.php:615 (getFormat) /classes/AddressFormat.php:562 (getAddressCountryFormat) /classes/AddressFormat.php:438 (getOrderedAddressFields) /classes/controller/FrontController.php:1763 (generateAddress) /classes/controller/FrontController.php:563 (getTemplateVarShop) /classes/controller/FrontController.php:625 (assignGeneralPurposeVariables) /controllers/front/listing/CategoryController.php:127 (initContent) /tools/profiling/Controller.php:65 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

#	Filename
0	/index.php
1	/config/config.inc.php
2	/config/defines.inc.php
3	/config/autoload.php
4	/vendor/autoload.php
5	/vendor/composer/autoload_real.php
6	/vendor/composer/platform_check.php
7	/vendor/composer/ClassLoader.php
8	/vendor/composer/include_paths.php
9	/vendor/composer/autoload_static.php
10	/vendor/symfony/polyfill-php72/bootstrap.php
11	/vendor/symfony/polyfill-mbstring/bootstrap.php
12	/vendor/symfony/polyfill-mbstring/bootstrap80.php
13	/vendor/symfony/polyfill-intl-normalizer/bootstrap.php
14	/vendor/symfony/polyfill-intl-normalizer/bootstrap80.php
15	/vendor/symfony/polyfill-intl-idn/bootstrap.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ralouphie/getallheaders/src/getallheaders.php
18	/vendor/symfony/polyfill-ctype/bootstrap.php
19	/vendor/symfony/polyfill-ctype/bootstrap80.php
20	/vendor/symfony/polyfill-php80/bootstrap.php
21	/vendor/guzzlehttp/promises/src/functions_include.php
22	/vendor/guzzlehttp/promises/src/functions.php
23	/vendor/guzzlehttp/guzzle/src/functions_include.php
24	/vendor/guzzlehttp/guzzle/src/functions.php
25	/vendor/symfony/polyfill-iconv/bootstrap.php
26	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
27	/vendor/jakeasmith/http_build_url/src/http_build_url.php
28	/vendor/lcobucci/jwt/compat/class-aliases.php
29	/vendor/lcobucci/jwt/src/Token.php
30	/vendor/lcobucci/jwt/src/Signature.php
31	/vendor/lcobucci/jwt/compat/json-exception-polyfill.php
32	/vendor/lcobucci/jwt/compat/lcobucci-clock-polyfill.php
33	/vendor/swiftmailer/swiftmailer/lib/swift_required.php
34	/vendor/swiftmailer/swiftmailer/lib/classes/Swift.php
35	/vendor/symfony/polyfill-intl-icu/bootstrap.php
36	/vendor/symfony/polyfill-php73/bootstrap.php
37	/vendor/symfony/polyfill-php81/bootstrap.php
38	/vendor/api-platform/core/src/deprecation.php
39	/vendor/api-platform/core/src/Api/FilterInterface.php

Left Banner  

Produit le plus vu

Produit le plus vu  

Fournitures

Sous-catégories

Left Banner

Produit le plus vu