Accueil

Nous utilisons des cookies pour améliorer votre expérience sur le site. En naviguant sur ce site, vous acceptez notre utilisation des cookies.

Terms & Conditions

Menthe Glaciale 10ml - CONCEPT AROME

Menthe

(0) Reviews

6,90 €

Menthe Fraiche 10ml - CONCEPT AROME

Menthe

(0) Reviews

6,90 €

Gout Americain 10ml - CONCEPT AROME

Classic

(0) Reviews

6,90 €

Louisiane 10ml - CONCEPT AROME

Classic

(0) Reviews

6,90 €

Nos meilleurs Ventes

Cindy Austin

Cliente

Très satisfaite. Je recommande ce site, car les E-liquides ne sont pas chers.

Nicolas Chaussée

Client

Depuis que je me suis inscrit à la newsletter, je suis informé des promo et des nouveautés qui arrivent sur le site. C'est pratique!

Garland Morin

Client

Merci beaucoup. Grâce à vous je peux commander mes articles en restant chez moi.

Thomas Fortin

invité

Le délai de livraison était un peu long. Mais vu la situation actuelle, c'est normal. Equipe très professionnelle. J'ai reçu toute ma marchandise comme convenu. Merci

Alice Favreau

Invitée

Personnellement je n'utilise le site que sur téléphone, et ça fonctionne nickel. Je n'ai rien à redire

CONCENTRE BLACK ASTAIRE 30ML T JUICE

Concentrés

(0) Reviews

12,90 €

CONCENTRE PINK ASTAIRE 30ML T JUICE

Concentrés

(0) Reviews

12,90 €

CONCENTRE BLUE ASTAIRE 30ML T JUICE

Concentrés

(0) Reviews

12,90 €

Black Astaire - 50ml - T Juice

Fruité

(0) Reviews

14,90 €

Blue Astaire - 50ml - T Juice

Fruité

(0) Reviews

14,90 €

Tous les Nouveaux Produits

Warning: Trying to access array offset on null in /var/www/vhosts/lebonvapoteur.fr/httpdocs/var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php on line 43

Warning: Trying to access array offset on null in /var/www/vhosts/lebonvapoteur.fr/httpdocs/var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php on line 43

Accueil

Subcategory

Load Time	3464 ms
Querying Time	594 ms
Queries	1414
Memory Peak Usage	56.2 Mb
Included Files	1102 files - 10.72 Mb
PrestaShop Cache	- Mb
Global vars	0.22 Mb
- global $_MODULES	198k
- global $_SERVER	7k
- global $smarty	5k
- global $config	5k
- global $context	3k
- global $exportPhpConfigFile	3k
- global $_COOKIE	1k
- global $__composer_autoload_files	1k
- global $_MODULE	1k

PrestaShop Version	8.1.3
PHP Version	8.3.27
MySQL Version	10.11.13-MariaDB-0ubuntu0.24.04.1-log
Memory Limit	128M
Max Execution Time	60s
Smarty Cache	enabled
Smarty Compilation	never recompile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	10.164 ms	10.164 ms	5.82 Mb	7.2 Mb
__construct	0.008 ms	10.172 ms	- Mb	7.2 Mb
init	40.430 ms	50.602 ms	0.53 Mb	7.2 Mb
checkAccess	0.001 ms	50.603 ms	- Mb	7.2 Mb
setMedia	5.002 ms	55.605 ms	0.05 Mb	7.2 Mb
postProcess	0.001 ms	55.606 ms	- Mb	7.2 Mb
initHeader	0.000 ms	55.606 ms	- Mb	7.2 Mb
initContent	704.054 ms	759.660 ms	12.06 Mb	18.7 Mb
initFooter	0.002 ms	759.662 ms	- Mb	18.7 Mb
display	2704 ms	3464 ms	35.14 Mb	56.2 Mb

453 queries	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
135 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
135 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 `ps_product` p INNER JOIN `ps_product_shop` `product_shop` ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_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)
135 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
135 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
131 queries	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX) + IF (`id_customer` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (XX, XX) AND `id_currency` IN (XX, XX) AND `id_country` IN (XX, XX) AND `id_group` IN (XX, XX) AND `id_product` = XX AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`) AND IF(`from_quantity` > XX, `from_quantity`, XX) <= XX ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
130 queries	SELECT COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), XX) as deep_quantity, COALESCE(SUM(first_level_quantity), XX) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, XX as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND cp.`id_product` = XX UNION SELECT XX as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = XX AND cp.`id_customization` = XX AND cp.`id_cart` = XX AND p.`id_product_item` = XX AND (pr.`pack_stock_type` IN (XX,XX) OR ( pr.`pack_stock_type` = XX AND XX = XX ))) as q LIMIT XX
114 queries	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE `id_product` = XX ORDER BY `id_specific_price_priority` DESC LIMIT XX
8 queries	SELECT DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = XX) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = XX) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = XX) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = XX) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = XX) WHERE ag.id_attribute_group = XX ORDER BY agl.`name` ASC, a.`position` ASC
6 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 ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
4 queries	SELECT 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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = XX AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=XX) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((pac.id_attribute IN (XX, XX, XX, XX, XX, XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) AND ps.id_shop='XX' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='XX' AND c.nleft>=XX AND c.nright<=XX GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_XX ON (pa.id_product_attribute = pac_XX.id_product_attribute) WHERE ((a.id_attribute_group=XX)) AND ((pac_XX.id_attribute IN (XX, XX, XX, XX, XX, XX, XX, XX))) AND ((pac_XX.id_attribute=XX)) GROUP BY pac.id_attribute
2 queries	SELECT XX FROM `ps_cart_rule` WHERE ((date_to >= "XX-XX-XX XX:XX:XX" AND date_to <= "XX-XX-XX XX:XX:XX") OR (date_from >= "XX-XX-XX XX:XX:XX" AND date_from <= "XX-XX-XX XX:XX:XX") OR (date_from < "XX-XX-XX XX:XX:XX" AND date_to > "XX-XX-XX XX:XX:XX")) AND `id_customer` IN (XX,XX) LIMIT XX

Hook	Time	Memory Usage
DisplayLeftColumn	372.838 ms	16.44 Mb
=> tbcmsbestsellerproducts	65.459 ms	2.13 Mb
=> tbcmstestimonial	1.252 ms	0.05 Mb
=> tbcmsnewproducts	53.323 ms	1.88 Mb
=> tbcmsfeaturedproducts	85.442 ms	1.55 Mb
=> tbcmsspecialproducts	167.362 ms	10.82 Mb
DisplayReviewProductList	139.322 ms	- Mb
=> tbcmsproductcomments	1.018 ms	0.02 Mb
=> tbcmsproductcomments	0.843 ms	- Mb
=> tbcmsproductcomments	0.689 ms	- Mb
=> tbcmsproductcomments	0.741 ms	- Mb
=> tbcmsproductcomments	0.748 ms	- Mb
=> tbcmsproductcomments	0.759 ms	- Mb
=> tbcmsproductcomments	0.774 ms	- Mb
=> tbcmsproductcomments	0.677 ms	- Mb
=> tbcmsproductcomments	0.680 ms	- Mb
=> tbcmsproductcomments	0.765 ms	- Mb
=> tbcmsproductcomments	0.726 ms	- Mb
=> tbcmsproductcomments	0.684 ms	- Mb
=> tbcmsproductcomments	1.023 ms	- Mb
=> tbcmsproductcomments	0.787 ms	- Mb
=> tbcmsproductcomments	0.795 ms	- Mb
=> tbcmsproductcomments	0.792 ms	- Mb
=> tbcmsproductcomments	0.713 ms	- Mb
=> tbcmsproductcomments	0.538 ms	- Mb
=> tbcmsproductcomments	0.538 ms	- Mb
=> tbcmsproductcomments	0.537 ms	- Mb
=> tbcmsproductcomments	0.788 ms	- Mb
=> tbcmsproductcomments	0.662 ms	- Mb
=> tbcmsproductcomments	0.530 ms	- Mb
=> tbcmsproductcomments	0.528 ms	- Mb
=> tbcmsproductcomments	0.722 ms	- Mb
=> tbcmsproductcomments	0.532 ms	- Mb
=> tbcmsproductcomments	0.539 ms	- Mb
=> tbcmsproductcomments	0.532 ms	- Mb
=> tbcmsproductcomments	0.744 ms	- Mb
=> tbcmsproductcomments	0.533 ms	- Mb
=> tbcmsproductcomments	0.527 ms	- Mb
=> tbcmsproductcomments	0.533 ms	- Mb
=> tbcmsproductcomments	0.707 ms	- Mb

Module	Time	Memory Usage
colissimo	3.529 ms	0.27 Mb
__construct	3.520 ms	0.26 Mb
hookModuleRoutes	0.005 ms	- Mb
hookHeader	0.004 ms	- Mb
tbcmsblog	10.415 ms	1.89 Mb
__construct	8.388 ms	1.88 Mb
hookModuleRoutes	0.013 ms	- Mb
hookDisplayHeader	2.011 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.003 ms	- Mb
blockreassurance	1.268 ms	0.05 Mb
__construct	0.514 ms	0.05 Mb
hookActionFrontControllerSetMedia	0.749 ms	0.01 Mb
hookDisplayNavFullWidth	0.005 ms	- Mb
psagechecker	3.126 ms	- Mb
__construct	0.393 ms	- Mb
hookDisplayHeader	2.733 ms	0.02 Mb
ps_emailsubscription	0.983 ms	0.03 Mb
__construct	0.130 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.173 ms	- Mb
displayFooterBefore	0.680 ms	0.02 Mb
ps_socialfollow	1.184 ms	0.04 Mb
__construct	0.121 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.278 ms	- Mb
displayFooterPart3	0.784 ms	0.03 Mb
blockwishlist	0.889 ms	0.01 Mb
__construct	0.203 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.686 ms	- Mb
productcomments	0.720 ms	0.01 Mb
__construct	0.138 ms	0.01 Mb
hookDisplayHeader	0.582 ms	- Mb
hirecaptcha	1.583 ms	0.04 Mb
__construct	0.515 ms	0.01 Mb
hookDisplayHeader	1.063 ms	0.03 Mb
hookDisplayBanner	0.005 ms	- Mb
tbcmscustomsetting	4.523 ms	0.06 Mb
__construct	0.634 ms	- Mb
hookDisplayHeader	2.110 ms	0.01 Mb
hookDisplayBackgroundBody	0.381 ms	- Mb
hookDisplayTopOfferText	0.006 ms	- Mb
hookDisplayTopOfferText	0.004 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Location
20	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=9)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) GROUP BY pac.id_attribute	101.564 ms	1176	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
613	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("2025-11-20 00:00:00", INTERVAL 100 DAY)) > 0 AS new, product_shop.price AS orderprice FROM `ps_category_product` cp LEFT JOIN `ps_product` p ON p.`id_product` = cp.`id_product` INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `ps_category_lang` cl ON (product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `ps_product_lang` pl ON (p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 ) LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON m.`id_manufacturer` = p.`id_manufacturer` WHERE product_shop.`id_shop` = 1 AND cp.`id_category` = 2 AND product_shop.`active` = 1 AND product_shop.`visibility` IN ("both", "catalog") ORDER BY RAND() LIMIT 6	58.206 ms	2825	Yes	/classes/Category.php:1062 /src/Adapter/Category/CategoryProductSearchProvider.php:70 (getProducts) /src/Adapter/Category/CategoryProductSearchProvider.php:105 (getProductsOrCount) /modules/tbcmstabproducts/tbcmstabproducts.php:2292 (runQuery) /modules/tbcmsfeaturedproducts/tbcmsfeaturedproducts.php:157 (displayFeaturedProducts) /modules/tbcmsfeaturedproducts/tbcmsfeaturedproducts.php:222 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
29	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p INNER JOIN ps_feature_product fp ON (p.id_product = fp.id_product) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((fp.id_feature=3)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_2.id_attribute=72)) GROUP BY fp.id_feature_value	39.218 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=6)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_2.id_attribute=72)) GROUP BY pac.id_attribute	31.184 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
10	SELECT SQL_NO_CACHE 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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72))	29.862 ms	1086		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (execute) /modules/ps_facetedsearch/src/Adapter/MySQL.php:764 (valueCount) /modules/ps_facetedsearch/src/Filters/Products.php:94 (count) /modules/ps_facetedsearch/src/Product/SearchProvider.php:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
17	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) WHERE ((pac.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((a.id_attribute_group=5)) AND ((pac_1.id_attribute=72)) GROUP BY pac.id_attribute	29.310 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND cg.id_group='1' AND c.level_depth<=2 AND c.nleft>2 AND c.nright<75 GROUP BY cp.id_category	24.542 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
28	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) GROUP BY p.id_manufacturer	22.783 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
564	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, image_shop.`id_image` id_image, il.`legend`, m.`name` AS manufacturer_name, (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-11-20 00:00:00", INTERVAL 100 DAY ) ) > 0) as new, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity, IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute FROM `ps_product` p INNER JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1 LEFT JOIN `ps_image_lang` `il` ON image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1 LEFT JOIN `ps_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1 LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE (product_shop.`active` = 1) AND (product_shop.`visibility` IN ("both", "catalog")) AND (DATEDIFF(product_shop.`date_add`, DATE_SUB( "2025-11-20 00:00:00", INTERVAL 100 DAY ) ) > 0) AND (EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`)) ORDER BY product_shop.`date_add` DESC LIMIT 6	16.855 ms	12303388	Yes	/classes/Product.php:3110 /modules/tbcmstabproducts/tbcmstabproducts.php:2349 (getNewProducts) /modules/tbcmsnewproducts/tbcmsnewproducts.php:156 (displayNewProducts) /modules/tbcmsnewproducts/tbcmsnewproducts.php:190 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
9	SELECT SQL_NO_CACHE p.id_product, p.id_product_attribute 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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ) GROUP BY p.id_product ORDER BY p.quantity ASC, p.id_product DESC LIMIT 0, 50	14.433 ms	382124304	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Filters/Products.php:90 (execute) /modules/ps_facetedsearch/src/Product/SearchProvider.php:186 (getProductByFilters) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
18	SELECT SQL_NO_CACHE psi.price_min, MIN(price_min) as min, MAX(price_max) as max FROM ps_product p INNER JOIN ps_layered_price_index psi ON (psi.id_product = p.id_product AND psi.id_shop = 1 AND psi.id_currency = 1 AND psi.id_country = 8) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75	10.019 ms	543		/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:58 (execute) /modules/ps_facetedsearch/src/Filters/Block.php:250 (getMinMaxPriceValue) /modules/ps_facetedsearch/src/Filters/Block.php:131 (getPriceRangeBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
515	SELECT SQL_NO_CACHE p., product_shop., stock.out_of_stock, IFNULL(stock.quantity, 0) as quantity, product_attribute_shop.minimal_quantity AS product_attribute_minimal_quantity,IFNULL(product_attribute_shop.id_product_attribute,0) id_product_attribute, pl.`description`, pl.`description_short`, pl.`link_rewrite`, pl.`meta_description`, pl.`meta_keywords`, pl.`meta_title`, pl.`name`, pl.`available_now`, pl.`available_later`, m.`name` AS manufacturer_name, p.`id_manufacturer` as id_manufacturer, image_shop.`id_image` id_image, il.`legend`, ps.`quantity` AS sales, t.`rate`, pl.`meta_keywords`, pl.`meta_title`, pl.`meta_description`, DATEDIFF(p.`date_add`, DATE_SUB("2025-11-20 00:00:00", INTERVAL 100 DAY)) > 0 AS new FROM `ps_product_sale` ps LEFT JOIN `ps_product` p ON ps.`id_product` = p.`id_product` LEFT JOIN ps_product_shop product_shop ON (product_shop.id_product = p.id_product AND product_shop.id_shop = 1) LEFT JOIN `ps_product_attribute_shop` product_attribute_shop ON (p.`id_product` = product_attribute_shop.`id_product` AND product_attribute_shop.`default_on` = 1 AND product_attribute_shop.id_shop=1) LEFT JOIN `ps_product_lang` pl ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = 1 LEFT JOIN `ps_image_shop` image_shop ON (image_shop.`id_product` = p.`id_product` AND image_shop.cover=1 AND image_shop.id_shop=1) LEFT JOIN `ps_image_lang` il ON (image_shop.`id_image` = il.`id_image` AND il.`id_lang` = 1) LEFT JOIN `ps_manufacturer` m ON (m.`id_manufacturer` = p.`id_manufacturer`) LEFT JOIN `ps_tax_rule` tr ON (product_shop.`id_tax_rules_group` = tr.`id_tax_rules_group`) AND tr.`id_country` = 8 AND tr.`id_state` = 0 LEFT JOIN `ps_tax` t ON (t.`id_tax` = tr.`id_tax`) LEFT JOIN ps_stock_available stock ON (stock.id_product = `p`.id_product AND stock.id_product_attribute = 0 AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) WHERE product_shop.`active` = 1 AND product_shop.`visibility` != 'none' AND EXISTS(SELECT 1 FROM `ps_category_product` cp JOIN `ps_category_group` cg ON (cp.id_category = cg.id_category AND cg.`id_group` =1) WHERE cp.`id_product` = p.`id_product`) ORDER BY `sales` DESC LIMIT 0, 6	4.403 ms	4366		/classes/ProductSale.php:151 /src/Adapter/BestSales/BestSalesProductSearchProvider.php:69 (getBestSales) /modules/tbcmstabproducts/tbcmstabproducts.php:2480 (runQuery) /modules/tbcmsbestsellerproducts/tbcmsbestsellerproducts.php:156 (displayBestSellers) /modules/tbcmsbestsellerproducts/tbcmsbestsellerproducts.php:190 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
26	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=12)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_2.id_attribute=72)) GROUP BY pac.id_attribute	3.107 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
22	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=2)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_2.id_attribute=72)) GROUP BY pac.id_attribute	2.968 ms	1086	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
32	SELECT SQL_NO_CACHE p., ps., pl.*, sa.out_of_stock, IFNULL(sa.quantity, 0) as quantity, (DATEDIFF( p.`date_add`, DATE_SUB( '2025-11-20 00:00:00', INTERVAL 100 DAY ) ) > 0) as new FROM ps_product p LEFT JOIN ps_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = 1 AND pl.id_lang = 1 LEFT JOIN ps_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = 0 AND sa.id_shop = 1 LEFT JOIN ps_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = 1 WHERE p.id_product IN (367,220,366,224,1522,378,375,373,223,221,1076,519,376,371,370,368,364,226,222,218,1203,1216,1204,1200,377,363,1228,1227,1225,1224,1223,1222,1221,1220,1219,1218,1215,1214,1213,1212,1211,1209,1208,1206,1205,1202,1201,1199,1198,1197)	1.518 ms	50		/classes/ProductAssembler.php:95 /classes/ProductAssembler.php:203 (addMissingProductFieldsForMultipleProducts) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
27	SELECT SQL_NO_CACHE m.*, ml.`description`, ml.`short_description` FROM `ps_manufacturer` m INNER JOIN ps_manufacturer_shop manufacturer_shop ON (manufacturer_shop.id_manufacturer = m.id_manufacturer AND manufacturer_shop.id_shop = 1)INNER JOIN `ps_manufacturer_lang` ml ON (m.`id_manufacturer` = ml.`id_manufacturer` AND ml.`id_lang` = 1)WHERE 1 AND m.`active` = 1 ORDER BY m.`name` ASC	1.052 ms	175	Yes	/classes/Manufacturer.php:201 /modules/ps_facetedsearch/src/Filters/Block.php:652 (getManufacturers) /modules/ps_facetedsearch/src/Filters/Block.php:146 (getManufacturersBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
31	REPLACE INTO ps_layered_filter_block (hash, data) VALUES ("608693b2f95f81381700f8b739bdb67f", "a:1:{s:7:\"filters\";a:7:{i:0;a:7:{s:9:\"type_lite\";s:8:\"category\";s:4:\"type\";s:8:\"category\";s:6:\"id_key\";i:0;s:4:\"name\";s:11:\"Catégories\";s:6:\"values\";a:2:{i:11;a:2:{s:4:\"name\";s:3:\"DIY\";s:3:\"nbr\";i:2;}i:12;a:2:{s:4:\"name\";s:9:\"E-Liquide\";s:3:\"nbr\";i:68;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:4;}i:1;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:6;s:4:\"name\";s:12:\"Base PG / VG\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:4:{i:50;a:4:{s:4:\"name\";s:11:\"70PG / 30VG\";s:3:\"nbr\";i:36;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:51;a:4:{s:4:\"name\";s:11:\"50PG / 50VG\";s:3:\"nbr\";i:11;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:4:{s:4:\"name\";s:11:\"40PG / 60VG\";s:3:\"nbr\";i:7;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:53;a:4:{s:4:\"name\";s:11:\"30PG / 70VG\";s:3:\"nbr\";i:16;s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:4;}i:2;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:5;s:4:\"name\";s:10:\"Contenance\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:1:{i:39;a:5:{s:4:\"name\";s:4:\"10ml\";s:3:\"nbr\";i:70;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:4;}i:3;a:12:{s:9:\"type_lite\";s:5:\"price\";s:4:\"type\";s:5:\"price\";s:6:\"id_key\";i:0;s:4:\"name\";s:4:\"Prix\";s:3:\"max\";d:59;s:3:\"min\";d:0;s:4:\"unit\";s:3:\"€\";s:14:\"specifications\";a:11:{s:6:\"symbol\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:12:\"currencyCode\";s:3:\"EUR\";s:14:\"currencySymbol\";s:3:\"€\";s:13:\"numberSymbols\";a:11:{i:0;s:1:\",\";i:1;s:3:\" \";i:2;s:1:\";\";i:3;s:1:\"%\";i:4;s:1:\"-\";i:5;s:1:\"+\";i:6;s:1:\"E\";i:7;s:2:\"×\";i:8;s:3:\"‰\";i:9;s:3:\"∞\";i:10;s:3:\"NaN\";}s:15:\"positivePattern\";s:12:\"#,##0.00 ¤\";s:15:\"negativePattern\";s:13:\"-#,##0.00 ¤\";s:17:\"maxFractionDigits\";i:2;s:17:\"minFractionDigits\";i:2;s:12:\"groupingUsed\";b:1;s:16:\"primaryGroupSize\";i:3;s:18:\"secondaryGroupSize\";i:3;}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:3;s:3:\"nbr\";i:70;s:5:\"value\";N;}i:4;a:10:{s:9:\"type_lite\";s:18:\"id_attribute_group\";s:4:\"type\";s:18:\"id_attribute_group\";s:6:\"id_key\";i:9;s:4:\"name\";s:4:\"Pack\";s:14:\"is_color_group\";b:0;s:6:\"values\";a:7:{i:69;a:4:{s:4:\"name\";s:11:\"à l\'unité\";s:3:\"nbr\";i:208;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:75;a:4:{s:4:\"name\";s:8:\"Lot de 2\";s:3:\"nbr\";i:5;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:70;a:4:{s:4:\"name\";s:2:\"x3\";s:3:\"nbr\";i:71;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:118;a:4:{s:4:\"name\";s:2:\"x4\";s:3:\"nbr\";i:9;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:71;a:4:{s:4:\"name\";s:2:\"x5\";s:3:\"nbr\";i:70;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:114;a:4:{s:4:\"name\";s:2:\"x6\";s:3:\"nbr\";i:1;s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:72;a:5:{s:4:\"name\";s:3:\"x10\";s:3:\"nbr\";i:70;s:8:\"url_name\";N;s:10:\"meta_title\";N;s:7:\"checked\";b:1;}}s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:4;}i:5;a:7:{s:9:\"type_lite\";s:12:\"manufacturer\";s:4:\"type\";s:12:\"manufacturer\";s:6:\"id_key\";i:0;s:4:\"name\";s:6:\"Marque\";s:6:\"values\";a:7:{i:24;a:2:{s:4:\"name\";s:2:\"N+\";s:3:\"nbr\";i:1;}i:41;a:2:{s:4:\"name\";s:6:\"Bordo2\";s:3:\"nbr\";i:8;}i:44;a:2:{s:4:\"name\";s:17:\"Fruizee (ELIQUID)\";s:3:\"nbr\";i:16;}i:101;a:2:{s:4:\"name\";s:11:\"Flavour Art\";s:3:\"nbr\";i:2;}i:110;a:2:{s:4:\"name\";s:4:\"Pulp\";s:3:\"nbr\";i:35;}i:112;a:2:{s:4:\"name\";s:12:\"Pulp Kitchen\";s:3:\"nbr\";i:7;}i:130;a:2:{s:4:\"name\";s:12:\"Tribal force\";s:3:\"nbr\";i:1;}}s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:6;}i:6;a:9:{s:9:\"type_lite\";s:10:\"id_feature\";s:4:\"type\";s:10:\"id_feature\";s:6:\"id_key\";i:3;s:6:\"values\";a:51:{i:30;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:6:\"Ananas\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:53;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:4:\"Anis\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:152;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Baies\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:31;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:6:\"Banane\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:128;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Biscuit\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:79;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Bonbon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:161;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:10:\"Cacahuète\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:55;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:6:\"Cactus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:70;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:5:\"Café\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:167;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"Cake\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:57;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Cannelle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:82;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:7:\"Caramel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:27;a:4:{s:3:\"nbr\";i:5;s:4:\"name\";s:6:\"Cassis\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:154;a:4:{s:3:\"nbr\";i:6;s:4:\"name\";s:6:\"Citron\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:112;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Classic Brun\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:69;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:4:\"Cola\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:20;a:4:{s:3:\"nbr\";i:6;s:4:\"name\";s:6:\"Fraise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:22;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:9:\"Framboise\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:33;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:15:\"Fruit du Dragon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:25;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:13:\"Fruits Rouges\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:169;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:15:\"Fruits à coque\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:34;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:6:\"Goyave\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:36;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:4:\"Kiwi\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:72;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Lait \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:446;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Malabar\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:15;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:9:\"Mandarine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:38;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:6:\"Mangue\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:41;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:5:\"Melon\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:109;a:4:{s:3:\"nbr\";i:8;s:4:\"name\";s:6:\"Menthe\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:108;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:19:\"Menthe Chlorophylle\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:107;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:17:\"Menthe Eucalyptus\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:106;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:16:\"Menthe Glaciale \";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:421;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Menthol\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:91;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"Miel\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:29;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:8:\"Myrtille\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:49;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:8:\"Noisette\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:51;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Noix de coco\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:157;a:4:{s:3:\"nbr\";i:13;s:4:\"name\";s:13:\"Note de Frais\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:14;a:4:{s:3:\"nbr\";i:4;s:4:\"name\";s:6:\"Orange\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:59;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:7:\"Oranger\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:93;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:14:\"Pain d\'épices\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:16;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:12:\"Pamplemousse\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:45;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:5:\"Pomme\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:419;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:11:\"Pâtisserie\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:43;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:6:\"Pêche\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:46;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:6:\"Raisin\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:98;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:9:\"Réglisse\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:67;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:9:\"Thé Vert\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:103;a:4:{s:3:\"nbr\";i:3;s:4:\"name\";s:7:\"Vanille\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:68;a:4:{s:3:\"nbr\";i:2;s:4:\"name\";s:8:\"Verveine\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}i:17;a:4:{s:3:\"nbr\";i:1;s:4:\"name\";s:4:\"Yuzu\";s:8:\"url_name\";N;s:10:\"meta_title\";N;}}s:4:\"name\";s:6:\"SAVEUR\";s:8:\"url_name\";N;s:10:\"meta_title\";N;s:17:\"filter_show_limit\";i:0;s:11:\"filter_type\";i:7;}}}")	0.849 ms	1		/modules/ps_facetedsearch/src/Filters/Block.php:209 /modules/ps_facetedsearch/src/Product/SearchProvider.php:217 (insertIntoCache) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
30	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 `ps_feature_value` v LEFT JOIN `ps_feature_value_lang` vl ON (v.`id_feature_value` = vl.`id_feature_value` AND vl.`id_lang` = 1) LEFT JOIN `ps_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` = 3 ORDER BY vl.`value` ASC	0.823 ms	393	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:194 /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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
24	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, pa.id_product_attribute FROM ps_product p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) LEFT JOIN ps_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 ps_product_sale psales ON (psales.id_product = p.id_product) INNER JOIN ps_product_shop ps ON (p.id_product = ps.id_product AND ps.id_shop = 1 AND ps.active = TRUE) INNER JOIN ps_category_product cp ON (p.id_product = cp.id_product) INNER JOIN ps_category c ON (cp.id_category = c.id_category AND c.active=1) LEFT JOIN ps_category_group cg ON (cg.id_category = c.id_category) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) WHERE ((pac.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_1.id_attribute=72)) AND ps.id_shop='1' AND ps.visibility IN ('both', 'catalog') AND cg.id_group='1' AND c.nleft>=2 AND c.nright<=75 GROUP BY p.id_product) p LEFT JOIN ps_product_attribute pa ON (p.id_product = pa.id_product) LEFT JOIN ps_product_attribute_combination pac ON (pa.id_product_attribute = pac.id_product_attribute) INNER JOIN ps_attribute a ON (a.id_attribute = pac.id_attribute) LEFT JOIN ps_product_attribute_combination pac_1 ON (pa.id_product_attribute = pac_1.id_product_attribute) LEFT JOIN ps_product_attribute_combination pac_2 ON (pa.id_product_attribute = pac_2.id_product_attribute) WHERE ((a.id_attribute_group=11)) AND ((pac_1.id_attribute IN (39, 40, 36, 164, 119, 133, 135, 136))) AND ((pac_2.id_attribute=72)) GROUP BY pac.id_attribute	0.807 ms	392	Yes	/modules/ps_facetedsearch/src/Adapter/MySQL.php:86 /modules/ps_facetedsearch/src/Adapter/MySQL.php:786 (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:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
321	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1223 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1223 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.713 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
14	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 6 ORDER BY agl.`name` ASC, a.`position` ASC	0.580 ms	15	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
16	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	0.578 ms	154	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
177	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 368 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 368 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.502 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
167	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 370 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 370 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.497 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
182	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 364 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.487 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
179	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 1555 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 368 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 1555 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 368 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.479 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
6	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 5 ORDER BY agl.`name` ASC, a.`position` ASC	0.476 ms	154	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Converter.php:427 (getAttributes) /modules/ps_facetedsearch/src/Product/SearchProvider.php:163 (createFacetedSearchFiltersFromQuery) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
169	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 1116 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 370 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 1116 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 370 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.473 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
19	SELECT SQL_NO_CACHE DISTINCT a.`id_attribute`, a.`color`, al.`name`, agl.`id_attribute_group`, IF(lialv.`url_name` IS NULL OR lialv.`url_name` = "", NULL, lialv.`url_name`) AS url_name, IF(lialv.`meta_title` IS NULL OR lialv.`meta_title` = "", NULL, lialv.`meta_title`) AS meta_title FROM `ps_attribute_group` ag INNER JOIN `ps_attribute_group_lang` agl ON (ag.`id_attribute_group` = agl.`id_attribute_group` AND agl.`id_lang` = 1) INNER JOIN `ps_attribute` a ON a.`id_attribute_group` = ag.`id_attribute_group` INNER JOIN `ps_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) INNER JOIN ps_attribute_group_shop attribute_group_shop ON (attribute_group_shop.id_attribute_group = ag.id_attribute_group AND attribute_group_shop.id_shop = 1) INNER JOIN ps_attribute_shop attribute_shop ON (attribute_shop.id_attribute = a.id_attribute AND attribute_shop.id_shop = 1) LEFT JOIN `ps_layered_indexable_attribute_lang_value` lialv ON (a.`id_attribute` = lialv.`id_attribute` AND lialv.`id_lang` = 1) WHERE ag.id_attribute_group = 9 ORDER BY agl.`name` ASC, a.`position` ASC	0.468 ms	12	Yes	/modules/ps_facetedsearch/src/Filters/DataAccessor.php:77 /modules/ps_facetedsearch/src/Filters/Block.php:731 (getAttributes) /modules/ps_facetedsearch/src/Filters/Block.php:150 (getAttributesBlock) /modules/ps_facetedsearch/src/Product/SearchProvider.php:215 (getFilterBlock) /classes/controller/ProductListingFrontController.php:356 (runQuery) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
172	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 368 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.467 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
403	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 3503 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1213 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 3503 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1213 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.459 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
346	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 1220 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.434 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
356	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 1219 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.434 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
421	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1211 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 0 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1211 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.428 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 370 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.425 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
887	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 2232 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.425 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tbcmstabproducts/tbcmstabproducts.php:2407 (getPricesDrop) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:156 (displaySpecialProducts) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:192 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
343	SELECT SQL_NO_CACHE COALESCE(SUM(first_level_quantity) + SUM(pack_quantity), 0) as deep_quantity, COALESCE(SUM(first_level_quantity), 0) as quantity FROM (SELECT cp.`quantity` as first_level_quantity, 0 as pack_quantity FROM `ps_cart_product` cp WHERE cp.`id_product_attribute` = 3568 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1221 UNION SELECT 0 as first_level_quantity, cp.`quantity` * p.`quantity` as pack_quantity FROM `ps_cart_product` cp JOIN `ps_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `ps_product` pr ON p.`id_product_pack` = pr.`id_product` WHERE cp.`id_product_attribute` = 3568 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1221 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.420 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1031	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 3257 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.420 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tbcmstabproducts/tbcmstabproducts.php:2407 (getPricesDrop) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:156 (displaySpecialProducts) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:192 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
1013	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 3254 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.412 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Tools.php:1700 (getPriceStatic) /classes/Product.php:3400 (orderbyPrice) /modules/tbcmstabproducts/tbcmstabproducts.php:2407 (getPricesDrop) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:156 (displaySpecialProducts) /modules/tbcmsspecialproducts/tbcmsspecialproducts.php:192 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__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/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /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:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /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:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
446	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 1206 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.405 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/ProductAssembler.php:206 (getProductProperties) /classes/controller/ProductListingFrontController.php:108 (assembleProducts) /classes/controller/ProductListingFrontController.php:378 (prepareMultipleProductsForTemplate) /classes/controller/ProductListingFrontController.php:635 (getProductSearchVariables) /controllers/front/listing/CategoryController.php:134 (doProductSearch) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

Name	Instances	Source
Product	256	/classes/Link.php:113 (__construct) [id: 367] /classes/Link.php:113 (__construct) [id: 220] /classes/Link.php:113 (__construct) [id: 366] /classes/Link.php:113 (__construct) [id: 224] /classes/Link.php:113 (__construct) [id: 1522] /classes/Link.php:113 (__construct) [id: 378] /classes/Link.php:113 (__construct) [id: 375] /classes/Link.php:113 (__construct) [id: 373] /classes/Link.php:113 (__construct) [id: 223] /classes/Link.php:113 (__construct) [id: 221] /classes/Link.php:113 (__construct) [id: 1076] /classes/Link.php:113 (__construct) [id: 519] /classes/Link.php:113 (__construct) [id: 376] /classes/Link.php:113 (__construct) [id: 371] /classes/Link.php:113 (__construct) [id: 370] /classes/Link.php:113 (__construct) [id: 368] /classes/Link.php:113 (__construct) [id: 364] /classes/Link.php:113 (__construct) [id: 226] /classes/Link.php:113 (__construct) [id: 222] /classes/Link.php:113 (__construct) [id: 218] /classes/Link.php:113 (__construct) [id: 1203] /classes/Link.php:113 (__construct) [id: 1216] /classes/Link.php:113 (__construct) [id: 1204] /classes/Link.php:113 (__construct) [id: 1200] /classes/Link.php:113 (__construct) [id: 377] /classes/Link.php:113 (__construct) [id: 363] /classes/Link.php:113 (__construct) [id: 1228] /classes/Link.php:113 (__construct) [id: 1227] /classes/Link.php:113 (__construct) [id: 1225] /classes/Link.php:113 (__construct) [id: 1224] /classes/Link.php:113 (__construct) [id: 1223] /classes/Link.php:113 (__construct) [id: 1222] /classes/Link.php:113 (__construct) [id: 1221] /classes/Link.php:113 (__construct) [id: 1220] /classes/Link.php:113 (__construct) [id: 1219] /classes/Link.php:113 (__construct) [id: 1218] /classes/Link.php:113 (__construct) [id: 1215] /classes/Link.php:113 (__construct) [id: 1214] /classes/Link.php:113 (__construct) [id: 1213] /classes/Link.php:113 (__construct) [id: 1212] /classes/Link.php:113 (__construct) [id: 1211] /classes/Link.php:113 (__construct) [id: 1209] /classes/Link.php:113 (__construct) [id: 1208] /classes/Link.php:113 (__construct) [id: 1206] /classes/Link.php:113 (__construct) [id: 1205] /classes/Link.php:113 (__construct) [id: 1202] /classes/Link.php:113 (__construct) [id: 1201] /classes/Link.php:113 (__construct) [id: 1199] /classes/Link.php:113 (__construct) [id: 1198] /classes/Link.php:113 (__construct) [id: 1197] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 367] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 220] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 366] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 224] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1522] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 378] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 375] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 373] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 223] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 221] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1076] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 519] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 376] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 371] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 370] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 368] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 364] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 226] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 222] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 218] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1203] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1216] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1204] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1200] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 377] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 363] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1228] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1227] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1225] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1224] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1223] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1222] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1221] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1220] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1219] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1218] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1215] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1214] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1213] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1212] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1211] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1209] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1208] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1206] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1205] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1202] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1201] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1199] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1198] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1197] /classes/Link.php:113 (__construct) [id: 430] /classes/Link.php:113 (__construct) [id: 429] /classes/Link.php:113 (__construct) [id: 425] /classes/Link.php:113 (__construct) [id: 423] /classes/Link.php:113 (__construct) [id: 422] /classes/Link.php:113 (__construct) [id: 448] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 430] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 429] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 425] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 423] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 422] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 448] /classes/Link.php:113 (__construct) [id: 430] /classes/Link.php:113 (__construct) [id: 429] /classes/Link.php:113 (__construct) [id: 425] /classes/Link.php:113 (__construct) [id: 423] /classes/Link.php:113 (__construct) [id: 422] /classes/Link.php:113 (__construct) [id: 448] /classes/Link.php:113 (__construct) [id: 3354] /classes/Link.php:113 (__construct) [id: 3353] /classes/Link.php:113 (__construct) [id: 3352] /classes/Link.php:113 (__construct) [id: 3351] /classes/Link.php:113 (__construct) [id: 3350] /classes/Link.php:113 (__construct) [id: 3349] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3354] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3353] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3352] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3351] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3350] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3349] /classes/Link.php:113 (__construct) [id: 3354] /classes/Link.php:113 (__construct) [id: 3353] /classes/Link.php:113 (__construct) [id: 3352] /classes/Link.php:113 (__construct) [id: 3351] /classes/Link.php:113 (__construct) [id: 3350] /classes/Link.php:113 (__construct) [id: 3349] /classes/Link.php:113 (__construct) [id: 1918] /classes/Link.php:113 (__construct) [id: 2333] /classes/Link.php:113 (__construct) [id: 1682] /classes/Link.php:113 (__construct) [id: 2866] /classes/Link.php:113 (__construct) [id: 3163] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1918] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2333] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1682] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 371] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2866] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3163] /classes/Link.php:113 (__construct) [id: 1193] /classes/Link.php:113 (__construct) [id: 1194] /classes/Link.php:113 (__construct) [id: 1195] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1193] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1194] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1195] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1197] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1199] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1200] /classes/Link.php:113 (__construct) [id: 367] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 367] /classes/Link.php:113 (__construct) [id: 220] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 220] /classes/Link.php:113 (__construct) [id: 366] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 366] /classes/Link.php:113 (__construct) [id: 224] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 224] /classes/Link.php:113 (__construct) [id: 1522] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1522] /classes/Link.php:113 (__construct) [id: 378] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 378] /classes/Link.php:113 (__construct) [id: 375] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 375] /classes/Link.php:113 (__construct) [id: 373] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 373] /classes/Link.php:113 (__construct) [id: 223] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 223] /classes/Link.php:113 (__construct) [id: 221] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 221] /classes/Link.php:113 (__construct) [id: 1076] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1076] /classes/Link.php:113 (__construct) [id: 519] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 519] /classes/Link.php:113 (__construct) [id: 376] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 376] /classes/Link.php:113 (__construct) [id: 371] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 371] /classes/Link.php:113 (__construct) [id: 370] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 370] /classes/Link.php:113 (__construct) [id: 368] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 368] /classes/Link.php:113 (__construct) [id: 364] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 364] /classes/Link.php:113 (__construct) [id: 226] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 226] /classes/Link.php:113 (__construct) [id: 222] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 222] /classes/Link.php:113 (__construct) [id: 218] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 218] /classes/Link.php:113 (__construct) [id: 1203] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1203] /classes/Link.php:113 (__construct) [id: 1216] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1216] /classes/Link.php:113 (__construct) [id: 1204] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1204] /classes/Link.php:113 (__construct) [id: 1200] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1200] /classes/Link.php:113 (__construct) [id: 377] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 377] /classes/Link.php:113 (__construct) [id: 363] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 363] /classes/Link.php:113 (__construct) [id: 1228] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1228] /classes/Link.php:113 (__construct) [id: 1227] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1227] /classes/Link.php:113 (__construct) [id: 1225] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1225] /classes/Link.php:113 (__construct) [id: 1224] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1224] /classes/Link.php:113 (__construct) [id: 1223] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1223] /classes/Link.php:113 (__construct) [id: 1222] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1222] /classes/Link.php:113 (__construct) [id: 1221] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1221] /classes/Link.php:113 (__construct) [id: 1220] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1220] /classes/Link.php:113 (__construct) [id: 1219] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1219] /classes/Link.php:113 (__construct) [id: 1218] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1218] /classes/Link.php:113 (__construct) [id: 1215] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1215] /classes/Link.php:113 (__construct) [id: 1214] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1214] /classes/Link.php:113 (__construct) [id: 1213] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1213] /classes/Link.php:113 (__construct) [id: 1212] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1212] /classes/Link.php:113 (__construct) [id: 1211] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1211] /classes/Link.php:113 (__construct) [id: 1209] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1209] /classes/Link.php:113 (__construct) [id: 1208] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1208] /classes/Link.php:113 (__construct) [id: 1206] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1206] /classes/Link.php:113 (__construct) [id: 1205] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1205] /classes/Link.php:113 (__construct) [id: 1202] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1202] /classes/Link.php:113 (__construct) [id: 1201] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1201] /classes/Link.php:113 (__construct) [id: 1199] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1199] /classes/Link.php:113 (__construct) [id: 1198] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1198] /classes/Link.php:113 (__construct) [id: 1197] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1197]
Combination	60	/classes/Product.php:5893 (__construct) [id: 1103] /classes/Product.php:5893 (__construct) [id: 1073] /classes/Product.php:5893 (__construct) [id: 1099] /classes/Product.php:5893 (__construct) [id: 1585] /classes/Product.php:5893 (__construct) [id: 4120] /classes/Product.php:5893 (__construct) [id: 1581] /classes/Product.php:5893 (__construct) [id: 1568] /classes/Product.php:5893 (__construct) [id: 1547] /classes/Product.php:5893 (__construct) [id: 1136] /classes/Product.php:5893 (__construct) [id: 1081] /classes/Product.php:5893 (__construct) [id: 3091] /classes/Product.php:5893 (__construct) [id: 1884] /classes/Product.php:5893 (__construct) [id: 1572] /classes/Product.php:5893 (__construct) [id: 1559] /classes/Product.php:5893 (__construct) [id: 1116] /classes/Product.php:5893 (__construct) [id: 1555] /classes/Product.php:5893 (__construct) [id: 1551] /classes/Product.php:5893 (__construct) [id: 1593] /classes/Product.php:5893 (__construct) [id: 1140] /classes/Product.php:5893 (__construct) [id: 1001] /classes/Product.php:5893 (__construct) [id: 3428] /classes/Product.php:5893 (__construct) [id: 3528] /classes/Product.php:5893 (__construct) [id: 3438] /classes/Product.php:5893 (__construct) [id: 3407] /classes/Product.php:5893 (__construct) [id: 1576] /classes/Product.php:5893 (__construct) [id: 996] /classes/Product.php:5893 (__construct) [id: 3622] /classes/Product.php:5893 (__construct) [id: 3617] /classes/Product.php:5893 (__construct) [id: 3608] /classes/Product.php:5893 (__construct) [id: 3598] /classes/Product.php:5893 (__construct) [id: 3588] /classes/Product.php:5893 (__construct) [id: 3578] /classes/Product.php:5893 (__construct) [id: 3568] /classes/Product.php:5893 (__construct) [id: 3558] /classes/Product.php:5893 (__construct) [id: 3548] /classes/Product.php:5893 (__construct) [id: 3538] /classes/Product.php:5893 (__construct) [id: 3522] /classes/Product.php:5893 (__construct) [id: 3513] /classes/Product.php:5893 (__construct) [id: 3503] /classes/Product.php:5893 (__construct) [id: 3493] /classes/Product.php:5893 (__construct) [id: 3487] /classes/Product.php:5893 (__construct) [id: 3478] /classes/Product.php:5893 (__construct) [id: 3472] /classes/Product.php:5893 (__construct) [id: 3453] /classes/Product.php:5893 (__construct) [id: 3447] /classes/Product.php:5893 (__construct) [id: 3422] /classes/Product.php:5893 (__construct) [id: 3413] /classes/Product.php:5893 (__construct) [id: 3398] /classes/Product.php:5893 (__construct) [id: 3388] /classes/Product.php:5893 (__construct) [id: 3382] /classes/Product.php:5893 (__construct) [id: 5611] /classes/Product.php:5893 (__construct) [id: 5624] /classes/Product.php:5893 (__construct) [id: 709] /classes/Product.php:5893 (__construct) [id: 718] /classes/Product.php:5893 (__construct) [id: 722] /classes/Product.php:5893 (__construct) [id: 1704] /classes/Product.php:5893 (__construct) [id: 4905] /classes/Product.php:5893 (__construct) [id: 3357] /classes/Product.php:5893 (__construct) [id: 3362] /classes/Product.php:5893 (__construct) [id: 3367]
Category	19	/controllers/front/listing/CategoryController.php:76 (__construct) [id: 2] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 10] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 11] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 12] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 15] /controllers/front/listing/CategoryController.php:213 (__construct) [id: 14] /classes/Meta.php:380 (__construct) [id: 2] /classes/PrestaShopCollection.php:385 (hydrateCollection) [id: ] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_facetedsearch/src/Product/Search.php:364 (__construct) [id: 2] /modules/ps_facetedsearch/src/Filters/Block.php:157 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/tbcmssearch/tbcmssearch.php:101 (getNestedCategories) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2] /modules/ps_categorytree/ps_categorytree.php:338 (__construct) [id: 2] /modules/tbcmstabproducts/tbcmstabproducts.php:2266 (__construct) [id: 2] /classes/Link.php:402 (__construct) [id: 2]
Country	5	/config/config.inc.php:146 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /classes/controller/FrontController.php:1760 (__construct) [id: 8] /classes/AddressFormat.php:404 (__construct) [id: 8] /modules/ps_contactinfo/ps_contactinfo.php:104 (__construct) [id: 8]
Currency	4	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /classes/Tools.php:690 (getCurrencyInstance) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2]
Address	4	/classes/shop/Shop.php:486 (__construct) [id: ] /classes/Product.php:3694 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5945 (__construct) [id: ]
Shop	2	/config/config.inc.php:117 (initialize) [id: 1] /modules/psagechecker/psagechecker.php:583 (__construct) [id: 1]
AddressFormat	2	/classes/controller/FrontController.php:1754 (generateAddress) [id: ] /modules/ps_contactinfo/ps_contactinfo.php:98 (generateAddress) [id: ]
Language	2	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1]
Cart	2	/classes/controller/FrontController.php:465 (__construct) [id: ] /classes/controller/FrontController.php:534 (__construct) [id: ]
State	2	/classes/controller/FrontController.php:1759 (__construct) [id: 0] /modules/ps_contactinfo/ps_contactinfo.php:93 (__construct) [id: 0]
Tax	1	/classes/tax/TaxRulesTaxManager.php:116 (__construct) [id: 1]
Gender	1	/classes/controller/FrontController.php:1684 (__construct) [id: 0]
Risk	1	/classes/controller/FrontController.php:1687 (__construct) [id: ]
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]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

Menthe Glaciale 10ml - CONCEPT AROME

Menthe Fraiche 10ml - CONCEPT AROME

Kentucky 10ml - CONCEPT AROME

Gout Americain 10ml - CONCEPT AROME

Gold 10ml - CONCEPT AROME

Louisiane 10ml - CONCEPT AROME

CONCENTRE BLACK ASTAIRE 30ML T JUICE

CONCENTRE PINK ASTAIRE 30ML T JUICE

CONCENTRE BLUE ASTAIRE 30ML T JUICE

Black Astaire - 50ml - T Juice

Pink Astaire - 50ml - T Juice

Blue Astaire - 50ml - T Juice

Citron Orange Mandarine 10ml - FRUIZEE

Citron Orange Mandarine 10ml - FRUIZEE

Citron Orange Mandarine 10ml - FRUIZEE

Citron Orange Mandarine 10ml - FRUIZEE

Chato Bordo2 10 ml -

Chato Bordo2 10 ml -

Chato Bordo2 10 ml -

Chato Bordo2 10 ml -

Citron Cassis 10ml - FRUIZEE

Citron Cassis 10ml - FRUIZEE

Citron Cassis 10ml - FRUIZEE

Citron Cassis 10ml - FRUIZEE

la Baronne 10ml - BORDO2

la Baronne 10ml - BORDO2

la Baronne 10ml - BORDO2

la Baronne 10ml - BORDO2

Royal - 10ml - Flavour Art

Royal - 10ml - Flavour Art

Royal - 10ml - Flavour Art

Royal - 10ml - Flavour Art

Tropikania 10ml - FRUIZEE

Tropikania 10ml - FRUIZEE

Tropikania 10ml - FRUIZEE

Tropikania 10ml - FRUIZEE

Spring Breack 10ml - FRUIZEE

Spring Breack 10ml - FRUIZEE

Spring Breack 10ml - FRUIZEE

Spring Breack 10ml - FRUIZEE

Ice Mint 10ml - FRUIZEE

Ice Mint 10ml - FRUIZEE

Ice Mint 10ml - FRUIZEE

Ice Mint 10ml - FRUIZEE

Dopamine Blue 10ml - BORDO2

Dopamine Blue 10ml - BORDO2

Dopamine Blue 10ml - BORDO2

Dopamine Blue 10ml - BORDO2

Chill Out 10ml - BORDO2

Chill Out 10ml - BORDO2

Chill Out 10ml - BORDO2

Chill Out 10ml - BORDO2

Maxx Blend - 10ml - Flavour Art

Maxx Blend - 10ml - Flavour Art

Maxx Blend - 10ml - Flavour Art

Maxx Blend - 10ml - Flavour Art

Jet Lag - 10ml BORDO2 Pack de 10

Jet Lag - 10ml BORDO2 Pack de 10

Jet Lag - 10ml BORDO2 Pack de 10

Jet Lag - 10ml BORDO2 Pack de 10

Summer Time 10ml - FRUIZEE

Summer Time 10ml - FRUIZEE

Summer Time 10ml - FRUIZEE

Summer Time 10ml - FRUIZEE

NO FRESH Crazy Mango 10ml - FRUIZEE

NO FRESH Crazy Mango 10ml - FRUIZEE

NO FRESH Crazy Mango 10ml - FRUIZEE

NO FRESH Crazy Mango 10ml - FRUIZEE

Crazy Mango 10ml - FRUIZEE

Crazy Mango 10ml - FRUIZEE

Crazy Mango 10ml - FRUIZEE

Crazy Mango 10ml - FRUIZEE

NO FRESH Citron Orange Mandarine 10ml - FRUIZEE

NO FRESH Citron Orange Mandarine 10ml - FRUIZEE

NO FRESH Citron Orange Mandarine 10ml - FRUIZEE

NO FRESH Citron Orange Mandarine 10ml - FRUIZEE

NO FRESH Bloody Summer 10ml - FRUIZEE

NO FRESH Bloody Summer 10ml - FRUIZEE

NO FRESH Bloody Summer 10ml - FRUIZEE

NO FRESH Bloody Summer 10ml - FRUIZEE