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	2501 ms
Querying Time	429 ms
Queries	1244
Memory Peak Usage	50.6 Mb
Included Files	1101 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	8.735 ms	8.735 ms	5.82 Mb	7.2 Mb
__construct	0.007 ms	8.742 ms	- Mb	7.2 Mb
init	35.206 ms	43.948 ms	0.53 Mb	7.2 Mb
checkAccess	0.001 ms	43.949 ms	- Mb	7.2 Mb
setMedia	4.808 ms	48.757 ms	0.05 Mb	7.2 Mb
postProcess	0.001 ms	48.758 ms	- Mb	7.2 Mb
initHeader	0.001 ms	48.759 ms	- Mb	7.2 Mb
initContent	504.384 ms	553.143 ms	11.59 Mb	18.4 Mb
initFooter	0.002 ms	553.145 ms	- Mb	18.4 Mb
display	1948 ms	2501 ms	29.96 Mb	50.6 Mb

202 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
163 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
163 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)
163 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
163 queries	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE `id_product` = XX AND `id_group` = XX LIMIT XX
139 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
114 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
4 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)
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	454.927 ms	20.21 Mb
=> tbcmsbestsellerproducts	63.775 ms	2.11 Mb
=> tbcmstestimonial	1.523 ms	0.05 Mb
=> tbcmsnewproducts	65.335 ms	1.89 Mb
=> tbcmsfeaturedproducts	88.707 ms	1.87 Mb
=> tbcmsspecialproducts	235.587 ms	14.28 Mb
DisplayReviewProductList	139.888 ms	- Mb
=> tbcmsproductcomments	1.175 ms	0.02 Mb
=> tbcmsproductcomments	0.887 ms	- Mb
=> tbcmsproductcomments	0.876 ms	- Mb
=> tbcmsproductcomments	0.891 ms	- Mb
=> tbcmsproductcomments	0.861 ms	- Mb
=> tbcmsproductcomments	1.528 ms	- Mb
=> tbcmsproductcomments	1.002 ms	- Mb
=> tbcmsproductcomments	0.966 ms	- Mb
=> tbcmsproductcomments	0.948 ms	- Mb
=> tbcmsproductcomments	0.968 ms	- Mb
=> tbcmsproductcomments	0.661 ms	- Mb
=> tbcmsproductcomments	0.672 ms	- Mb
=> tbcmsproductcomments	0.872 ms	- Mb
=> tbcmsproductcomments	0.711 ms	- Mb
=> tbcmsproductcomments	0.711 ms	- Mb
=> tbcmsproductcomments	0.675 ms	- Mb
=> tbcmsproductcomments	0.877 ms	- Mb
=> tbcmsproductcomments	0.709 ms	- Mb
=> tbcmsproductcomments	0.701 ms	- Mb
=> tbcmsproductcomments	0.741 ms	- Mb
=> tbcmsproductcomments	0.892 ms	- Mb
=> tbcmsproductcomments	0.697 ms	- Mb
=> tbcmsproductcomments	0.686 ms	- Mb
=> tbcmsproductcomments	0.700 ms	- Mb
=> tbcmsproductcomments	0.872 ms	- Mb
=> tbcmsproductcomments	0.525 ms	- Mb
=> tbcmsproductcomments	0.672 ms	- Mb
=> tbcmsproductcomments	0.528 ms	- Mb
=> tbcmsproductcomments	0.824 ms	- Mb
=> tbcmsproductcomments	0.679 ms	- Mb
=> tbcmsproductcomments	0.681 ms	- Mb
=> tbcmsproductcomments	0.687 ms	- Mb
=> tbcmsproductcomments	0.942 ms	- Mb

Module	Time	Memory Usage
colissimo	3.187 ms	0.27 Mb
__construct	3.177 ms	0.26 Mb
hookModuleRoutes	0.005 ms	- Mb
hookHeader	0.005 ms	- Mb
tbcmsblog	9.378 ms	1.89 Mb
__construct	7.150 ms	1.88 Mb
hookModuleRoutes	0.011 ms	- Mb
hookDisplayHeader	2.214 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.003 ms	- Mb
blockreassurance	1.171 ms	0.05 Mb
__construct	0.460 ms	0.05 Mb
hookActionFrontControllerSetMedia	0.705 ms	0.01 Mb
hookDisplayNavFullWidth	0.006 ms	- Mb
psagechecker	3.056 ms	- Mb
__construct	0.359 ms	- Mb
hookDisplayHeader	2.697 ms	0.02 Mb
ps_emailsubscription	0.936 ms	0.03 Mb
__construct	0.128 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.141 ms	- Mb
displayFooterBefore	0.667 ms	0.02 Mb
ps_socialfollow	1.103 ms	0.04 Mb
__construct	0.121 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.245 ms	- Mb
displayFooterPart3	0.737 ms	0.03 Mb
blockwishlist	0.751 ms	0.01 Mb
__construct	0.192 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.559 ms	- Mb
productcomments	0.689 ms	0.01 Mb
__construct	0.141 ms	0.01 Mb
hookDisplayHeader	0.548 ms	- Mb
hirecaptcha	1.327 ms	0.04 Mb
__construct	0.498 ms	0.01 Mb
hookDisplayHeader	0.824 ms	0.03 Mb
hookDisplayBanner	0.005 ms	- Mb
tbcmscustomsetting	4.026 ms	0.06 Mb
__construct	0.499 ms	- Mb
hookDisplayHeader	1.744 ms	0.01 Mb
hookDisplayBackgroundBody	0.401 ms	- Mb
hookDisplayTopOfferText	0.008 ms	- Mb
hookDisplayTopOfferText	0.004 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Location
9	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) WHERE ((pac.id_attribute IN (39, 38, 44, 119, 132, 133, 135, 136, 156))) 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) WHERE ((pac.id_attribute IN (39, 38, 44, 119, 132, 133, 135, 136, 156)))	102.008 ms	3418		/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)
534	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	57.419 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)
8	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) WHERE ((pac.id_attribute IN (39, 38, 44, 119, 132, 133, 135, 136, 156))) 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	37.492 ms	2920681	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)
485	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	29.121 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)
436	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.308 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)
11	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 (1301,1135,51,1283,1319,1315,1302,1284,1281,1146,1134,1141,1152,1147,1117,46,1052,47,1158,1148,1121,1105,1144,1143,48,1115,1110,56,1095,1163,1150,1131,1156,1142,1118,1113,1111,1106,2299,1932,1159,1155,1149,1138,1133,1130,1114,1109,1107,502)	1.283 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)
10	SELECT SQL_NO_CACHE data FROM ps_layered_filter_block WHERE hash="149a68e1ee7a856cdb1b4929886f31dc" LIMIT 1	0.835 ms	1		/modules/ps_facetedsearch/src/Filters/Block.php:185 /modules/ps_facetedsearch/src/Product/SearchProvider.php:210 (getFromCache) /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)
1243	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('50042', '', 'www.lebonvapoteur.fr/2-accueil?p=25&q=Contenance-10ml-120ml-140ml-90ml-4.5ml-3.5ml-5ml-3ml-4ml', '', '2025-11-20 00:45:19')	0.738 ms	1		/classes/ObjectModel.php:622 /classes/ConnectionsSource.php:105 (add) /modules/statsdata/statsdata.php:119 (logHttpReferer) /modules/statsdata/statsdata.php:74 (getScriptCustomerPagesViews) /classes/Hook.php:1043 (hookDisplayBeforeBodyClosingTag) /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:277 (__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:82 (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)
1151	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` = 3264 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.579 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)
1091	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.574 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)
411	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` = 1109 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.553 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)
158	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` = 47 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` = 47 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.543 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)
179	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` = 1121 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.543 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)
418	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` = 3172 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1109 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` = 3172 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1109 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.535 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)
432	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` = 502 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` = 502 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.533 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)
408	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` = 3177 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1114 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` = 3177 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1114 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.526 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)
176	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` = 3220 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1148 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` = 3220 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1148 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.520 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)
241	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` = 56 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.519 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)
1133	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` = 3261 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.519 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)
231	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` = 1110 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.516 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)
416	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` = 1109 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` = 1109 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.516 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)
1127	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` = 3260 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.514 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)
221	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` = 1115 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.513 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)
426	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` = 3170 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1107 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` = 3170 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1107 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.512 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)
617	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` = 1195 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.511 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)
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.510 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)
226	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` = 1115 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` = 1115 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.508 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)
424	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` = 1107 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` = 1107 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.507 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)
208	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` = 1143 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` = 1143 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.503 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)
132	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` = 1117 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` = 1117 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)
152	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` = 3040 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1052 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` = 3040 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1052 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: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)
192	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` = 1105 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` = 1105 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.501 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)
406	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` = 1114 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` = 1114 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.498 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)
134	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` = 3180 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1117 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` = 3180 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1117 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: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)
238	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` = 3173 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1110 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` = 3173 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1110 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: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)
228	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` = 3178 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1115 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` = 3178 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1115 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: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)
236	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` = 1110 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` = 1110 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.492 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)
186	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` = 3184 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1121 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` = 3184 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1121 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.490 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)
140	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` = 46 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` = 46 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.489 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)
210	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` = 3215 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1143 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` = 3215 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1143 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.488 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)

Name	Instances	Source
Product	260	/classes/Link.php:113 (__construct) [id: 1301] /classes/Link.php:113 (__construct) [id: 1135] /classes/Link.php:113 (__construct) [id: 51] /classes/Link.php:113 (__construct) [id: 1283] /classes/Link.php:113 (__construct) [id: 1319] /classes/Link.php:113 (__construct) [id: 1315] /classes/Link.php:113 (__construct) [id: 1302] /classes/Link.php:113 (__construct) [id: 1284] /classes/Link.php:113 (__construct) [id: 1281] /classes/Link.php:113 (__construct) [id: 1146] /classes/Link.php:113 (__construct) [id: 1134] /classes/Link.php:113 (__construct) [id: 1141] /classes/Link.php:113 (__construct) [id: 1152] /classes/Link.php:113 (__construct) [id: 1147] /classes/Link.php:113 (__construct) [id: 1117] /classes/Link.php:113 (__construct) [id: 46] /classes/Link.php:113 (__construct) [id: 1052] /classes/Link.php:113 (__construct) [id: 47] /classes/Link.php:113 (__construct) [id: 1158] /classes/Link.php:113 (__construct) [id: 1148] /classes/Link.php:113 (__construct) [id: 1121] /classes/Link.php:113 (__construct) [id: 1105] /classes/Link.php:113 (__construct) [id: 1144] /classes/Link.php:113 (__construct) [id: 1143] /classes/Link.php:113 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 1115] /classes/Link.php:113 (__construct) [id: 1110] /classes/Link.php:113 (__construct) [id: 56] /classes/Link.php:113 (__construct) [id: 1095] /classes/Link.php:113 (__construct) [id: 1163] /classes/Link.php:113 (__construct) [id: 1150] /classes/Link.php:113 (__construct) [id: 1131] /classes/Link.php:113 (__construct) [id: 1156] /classes/Link.php:113 (__construct) [id: 1142] /classes/Link.php:113 (__construct) [id: 1118] /classes/Link.php:113 (__construct) [id: 1113] /classes/Link.php:113 (__construct) [id: 1111] /classes/Link.php:113 (__construct) [id: 1106] /classes/Link.php:113 (__construct) [id: 2299] /classes/Link.php:113 (__construct) [id: 1932] /classes/Link.php:113 (__construct) [id: 1159] /classes/Link.php:113 (__construct) [id: 1155] /classes/Link.php:113 (__construct) [id: 1149] /classes/Link.php:113 (__construct) [id: 1138] /classes/Link.php:113 (__construct) [id: 1133] /classes/Link.php:113 (__construct) [id: 1130] /classes/Link.php:113 (__construct) [id: 1114] /classes/Link.php:113 (__construct) [id: 1109] /classes/Link.php:113 (__construct) [id: 1107] /classes/Link.php:113 (__construct) [id: 502] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1301] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1135] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 51] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1283] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1319] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1315] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1302] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1284] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1281] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1146] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1134] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1141] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1152] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1147] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1117] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 46] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1052] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 47] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1158] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1148] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1121] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1105] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1144] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1143] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 48] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1115] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1110] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 56] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1095] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1163] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1150] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1131] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1156] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1142] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1118] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1113] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1111] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1106] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2299] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1932] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1159] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1155] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1149] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1138] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1133] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1130] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1114] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1109] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1107] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 502] /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: 2530] /classes/Link.php:113 (__construct) [id: 1608] /classes/Link.php:113 (__construct) [id: 2476] /classes/Link.php:113 (__construct) [id: 1444] /classes/Link.php:113 (__construct) [id: 1990] /classes/Link.php:113 (__construct) [id: 3248] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2530] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1608] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2476] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1444] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1990] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3248] /classes/Link.php:113 (__construct) [id: 1193] /classes/Link.php:113 (__construct) [id: 1194] /classes/Link.php:113 (__construct) [id: 1195] /classes/Link.php:113 (__construct) [id: 1197] /classes/Link.php:113 (__construct) [id: 1199] /classes/Link.php:113 (__construct) [id: 1200] /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: 1301] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1301] /classes/Link.php:113 (__construct) [id: 1135] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1135] /classes/Link.php:113 (__construct) [id: 51] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 51] /classes/Link.php:113 (__construct) [id: 1283] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1283] /classes/Link.php:113 (__construct) [id: 1319] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1319] /classes/Link.php:113 (__construct) [id: 1315] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1315] /classes/Link.php:113 (__construct) [id: 1302] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1302] /classes/Link.php:113 (__construct) [id: 1284] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1284] /classes/Link.php:113 (__construct) [id: 1281] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1281] /classes/Link.php:113 (__construct) [id: 1146] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1146] /classes/Link.php:113 (__construct) [id: 1134] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1134] /classes/Link.php:113 (__construct) [id: 1141] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1141] /classes/Link.php:113 (__construct) [id: 1152] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1152] /classes/Link.php:113 (__construct) [id: 1147] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1147] /classes/Link.php:113 (__construct) [id: 1117] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1117] /classes/Link.php:113 (__construct) [id: 46] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 46] /classes/Link.php:113 (__construct) [id: 1052] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1052] /classes/Link.php:113 (__construct) [id: 47] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 47] /classes/Link.php:113 (__construct) [id: 1158] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1158] /classes/Link.php:113 (__construct) [id: 1148] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1148] /classes/Link.php:113 (__construct) [id: 1121] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1121] /classes/Link.php:113 (__construct) [id: 1105] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1105] /classes/Link.php:113 (__construct) [id: 1144] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1144] /classes/Link.php:113 (__construct) [id: 1143] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1143] /classes/Link.php:113 (__construct) [id: 48] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 48] /classes/Link.php:113 (__construct) [id: 1115] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1115] /classes/Link.php:113 (__construct) [id: 1110] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1110] /classes/Link.php:113 (__construct) [id: 56] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 56] /classes/Link.php:113 (__construct) [id: 1095] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1095] /classes/Link.php:113 (__construct) [id: 1163] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1163] /classes/Link.php:113 (__construct) [id: 1150] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1150] /classes/Link.php:113 (__construct) [id: 1131] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1131] /classes/Link.php:113 (__construct) [id: 1156] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1156] /classes/Link.php:113 (__construct) [id: 1142] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1142] /classes/Link.php:113 (__construct) [id: 1118] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1118] /classes/Link.php:113 (__construct) [id: 1113] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1113] /classes/Link.php:113 (__construct) [id: 1111] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1111] /classes/Link.php:113 (__construct) [id: 1106] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1106] /classes/Link.php:113 (__construct) [id: 2299] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 2299] /classes/Link.php:113 (__construct) [id: 1932] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1932] /classes/Link.php:113 (__construct) [id: 1159] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1159] /classes/Link.php:113 (__construct) [id: 1155] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1155] /classes/Link.php:113 (__construct) [id: 1149] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1149] /classes/Link.php:113 (__construct) [id: 1138] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1138] /classes/Link.php:113 (__construct) [id: 1133] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1133] /classes/Link.php:113 (__construct) [id: 1130] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1130] /classes/Link.php:113 (__construct) [id: 1114] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1114] /classes/Link.php:113 (__construct) [id: 1109] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1109] /classes/Link.php:113 (__construct) [id: 1107] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1107] /classes/Link.php:113 (__construct) [id: 502] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 502]
Combination	65	/classes/Product.php:5893 (__construct) [id: 3781] /classes/Product.php:5893 (__construct) [id: 3207] /classes/Product.php:5893 (__construct) [id: 1852] /classes/Product.php:5893 (__construct) [id: 3769] /classes/Product.php:5893 (__construct) [id: 3787] /classes/Product.php:5893 (__construct) [id: 3784] /classes/Product.php:5893 (__construct) [id: 3783] /classes/Product.php:5893 (__construct) [id: 3771] /classes/Product.php:5893 (__construct) [id: 3765] /classes/Product.php:5893 (__construct) [id: 3218] /classes/Product.php:5893 (__construct) [id: 3206] /classes/Product.php:5893 (__construct) [id: 3213] /classes/Product.php:5893 (__construct) [id: 3224] /classes/Product.php:5893 (__construct) [id: 3219] /classes/Product.php:5893 (__construct) [id: 3180] /classes/Product.php:5893 (__construct) [id: 89] /classes/Product.php:5893 (__construct) [id: 3040] /classes/Product.php:5893 (__construct) [id: 1851] /classes/Product.php:5893 (__construct) [id: 3230] /classes/Product.php:5893 (__construct) [id: 3220] /classes/Product.php:5893 (__construct) [id: 3184] /classes/Product.php:5893 (__construct) [id: 3168] /classes/Product.php:5893 (__construct) [id: 3216] /classes/Product.php:5893 (__construct) [id: 3215] /classes/Product.php:5893 (__construct) [id: 1850] /classes/Product.php:5893 (__construct) [id: 3178] /classes/Product.php:5893 (__construct) [id: 3173] /classes/Product.php:5893 (__construct) [id: 1856] /classes/Product.php:5893 (__construct) [id: 3158] /classes/Product.php:5893 (__construct) [id: 3235] /classes/Product.php:5893 (__construct) [id: 3222] /classes/Product.php:5893 (__construct) [id: 3203] /classes/Product.php:5893 (__construct) [id: 3228] /classes/Product.php:5893 (__construct) [id: 3214] /classes/Product.php:5893 (__construct) [id: 3181] /classes/Product.php:5893 (__construct) [id: 3176] /classes/Product.php:5893 (__construct) [id: 3174] /classes/Product.php:5893 (__construct) [id: 3169] /classes/Product.php:5893 (__construct) [id: 7048] /classes/Product.php:5893 (__construct) [id: 4923] /classes/Product.php:5893 (__construct) [id: 3231] /classes/Product.php:5893 (__construct) [id: 3227] /classes/Product.php:5893 (__construct) [id: 3221] /classes/Product.php:5893 (__construct) [id: 3210] /classes/Product.php:5893 (__construct) [id: 3205] /classes/Product.php:5893 (__construct) [id: 3202] /classes/Product.php:5893 (__construct) [id: 3177] /classes/Product.php:5893 (__construct) [id: 3172] /classes/Product.php:5893 (__construct) [id: 3170] /classes/Product.php:5893 (__construct) [id: 2740] /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: 4350] /classes/Product.php:5893 (__construct) [id: 3992] /classes/Product.php:5893 (__construct) [id: 7720] /classes/Product.php:5893 (__construct) [id: 3357] /classes/Product.php:5893 (__construct) [id: 3362] /classes/Product.php:5893 (__construct) [id: 3367] /classes/Product.php:5893 (__construct) [id: 3382] /classes/Product.php:5893 (__construct) [id: 3398] /classes/Product.php:5893 (__construct) [id: 3407]
Category	18	/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] /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

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

CONCENTRE WESTBLEND 10ML E LIQUID FRANCE

CONCENTRE WESTBLEND 10ML E LIQUID FRANCE

CONCENTRE WESTBLEND 10ML E LIQUID FRANCE

CONCENTRE WESTBLEND 10ML E LIQUID FRANCE

ADDITIF Koolada EXTRAPURE

ADDITIF Koolada EXTRAPURE

ADDITIF Koolada EXTRAPURE

ADDITIF Koolada EXTRAPURE

PYREX ELLO S ELEAF

PYREX ELLO S ELEAF

PYREX ELLO S ELEAF

PYREX ELLO S ELEAF

PYREX ZLIDE 2 / 4ML INNOKIN

PYREX ZLIDE 2 / 4ML INNOKIN

PYREX ZLIDE 2 / 4ML INNOKIN

PYREX ZLIDE 2 / 4ML INNOKIN

PYREX TFV12 PRINCE 5 / 8ML SMOKTECH

PYREX TFV12 PRINCE 5 / 8ML SMOKTECH

PYREX TFV12 PRINCE 5 / 8ML SMOKTECH

PYREX TFV12 PRINCE 5 / 8ML SMOKTECH

PYREX NRG SE VAPORESSO

PYREX NRG SE VAPORESSO

PYREX NRG SE VAPORESSO

PYREX NRG SE VAPORESSO

PYREX MELO 3 ELEAF

PYREX MELO 3 ELEAF

PYREX MELO 3 ELEAF

PYREX MELO 3 ELEAF

PYREX ELLO ELEAF

PYREX ELLO ELEAF

PYREX ELLO ELEAF

PYREX ELLO ELEAF

CONCENTRE FRAISE 10ML E LIQUID FRANCE

CONCENTRE FRAISE 10ML E LIQUID FRANCE

CONCENTRE FRAISE 10ML E LIQUID FRANCE

CONCENTRE FRAISE 10ML E LIQUID FRANCE

CONCENTRE MENTHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE 10ML E LIQUID FRANCE

CONCENTRE BANANE 10ML E LIQUID FRANCE

CONCENTRE BANANE 10ML E LIQUID FRANCE

CONCENTRE BANANE 10ML E LIQUID FRANCE

CONCENTRE BANANE 10ML E LIQUID FRANCE

CONCENTRE MENTHE FRAÎCHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE FRAÎCHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE FRAÎCHE 10ML E LIQUID FRANCE

CONCENTRE MENTHE FRAÎCHE 10ML E LIQUID FRANCE

CONCENTRE ANANAS 10ML E LIQUID FRANCE

CONCENTRE ANANAS 10ML E LIQUID FRANCE

CONCENTRE ANANAS 10ML E LIQUID FRANCE

CONCENTRE ANANAS 10ML E LIQUID FRANCE

CONCENTRE COLA POMME 10ML FRUIZEE

CONCENTRE COLA POMME 10ML FRUIZEE

CONCENTRE COLA POMME 10ML FRUIZEE

CONCENTRE COLA POMME 10ML FRUIZEE

Seringue Aiguille

Seringue Aiguille

Seringue Aiguille

Seringue Aiguille

CONCENTRE RED ASTAIRE 10ML T JUICE

CONCENTRE RED ASTAIRE 10ML T JUICE

CONCENTRE RED ASTAIRE 10ML T JUICE

CONCENTRE RED ASTAIRE 10ML T JUICE