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

E-Cigarette

DIY

E-Liquide

Load Time	1399 ms
Querying Time	328 ms
Queries	1230
Memory Peak Usage	51.0 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	11.727 ms	11.727 ms	5.82 Mb	7.2 Mb
__construct	0.007 ms	11.734 ms	- Mb	7.2 Mb
init	35.887 ms	47.621 ms	0.53 Mb	7.2 Mb
checkAccess	0.001 ms	47.622 ms	- Mb	7.2 Mb
setMedia	3.727 ms	51.349 ms	0.05 Mb	7.2 Mb
postProcess	0.001 ms	51.350 ms	- Mb	7.2 Mb
initHeader	0.000 ms	51.350 ms	- Mb	7.2 Mb
initContent	326.188 ms	377.538 ms	11.73 Mb	18.6 Mb
initFooter	0.001 ms	377.539 ms	- Mb	18.6 Mb
display	1021 ms	1399 ms	30.06 Mb	51.0 Mb

199 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
164 queries	SELECT XX FROM `ps_specific_price` WHERE id_product = XX LIMIT XX
164 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)
164 queries	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
164 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
106 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
106 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
5 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	502.160 ms	20.32 Mb
=> tbcmsbestsellerproducts	56.397 ms	2.11 Mb
=> tbcmstestimonial	1.124 ms	0.05 Mb
=> tbcmsnewproducts	56.472 ms	1.89 Mb
=> tbcmsfeaturedproducts	128.384 ms	1.86 Mb
=> tbcmsspecialproducts	259.783 ms	14.40 Mb
DisplayReviewProductList	140.698 ms	- Mb
=> tbcmsproductcomments	1.034 ms	0.02 Mb
=> tbcmsproductcomments	0.705 ms	- Mb
=> tbcmsproductcomments	0.697 ms	- Mb
=> tbcmsproductcomments	0.674 ms	- Mb
=> tbcmsproductcomments	0.675 ms	- Mb
=> tbcmsproductcomments	0.680 ms	- Mb
=> tbcmsproductcomments	0.905 ms	- Mb
=> tbcmsproductcomments	0.862 ms	- Mb
=> tbcmsproductcomments	0.898 ms	- Mb
=> tbcmsproductcomments	0.856 ms	- Mb
=> tbcmsproductcomments	0.874 ms	- Mb
=> tbcmsproductcomments	0.869 ms	- Mb
=> tbcmsproductcomments	0.837 ms	- Mb
=> tbcmsproductcomments	0.708 ms	- Mb
=> tbcmsproductcomments	0.721 ms	- Mb
=> tbcmsproductcomments	0.676 ms	- Mb
=> tbcmsproductcomments	0.847 ms	- Mb
=> tbcmsproductcomments	0.705 ms	- Mb
=> tbcmsproductcomments	0.662 ms	- Mb
=> tbcmsproductcomments	0.712 ms	- Mb
=> tbcmsproductcomments	0.919 ms	- Mb
=> tbcmsproductcomments	0.689 ms	- Mb
=> tbcmsproductcomments	0.705 ms	- Mb
=> tbcmsproductcomments	0.641 ms	- Mb
=> tbcmsproductcomments	0.945 ms	- Mb
=> tbcmsproductcomments	0.683 ms	- Mb
=> tbcmsproductcomments	0.664 ms	- Mb
=> tbcmsproductcomments	0.706 ms	- Mb
=> tbcmsproductcomments	0.881 ms	- Mb
=> tbcmsproductcomments	0.666 ms	- Mb
=> tbcmsproductcomments	0.734 ms	- Mb
=> tbcmsproductcomments	0.657 ms	- Mb
=> tbcmsproductcomments	0.843 ms	- Mb

Module	Time	Memory Usage
colissimo	3.825 ms	0.27 Mb
__construct	3.816 ms	0.26 Mb
hookModuleRoutes	0.005 ms	- Mb
hookHeader	0.004 ms	- Mb
tbcmsblog	11.259 ms	1.89 Mb
__construct	9.735 ms	1.88 Mb
hookModuleRoutes	0.013 ms	- Mb
hookDisplayHeader	1.508 ms	- Mb
hookDisplayBeforeBodyClosingTag	0.003 ms	- Mb
blockreassurance	0.934 ms	0.05 Mb
__construct	0.365 ms	0.05 Mb
hookActionFrontControllerSetMedia	0.565 ms	0.01 Mb
hookDisplayNavFullWidth	0.004 ms	- Mb
psagechecker	2.332 ms	- Mb
__construct	0.293 ms	- Mb
hookDisplayHeader	2.039 ms	0.02 Mb
ps_emailsubscription	1.100 ms	0.03 Mb
__construct	0.090 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.124 ms	- Mb
displayFooterBefore	0.886 ms	0.02 Mb
ps_socialfollow	1.288 ms	0.04 Mb
__construct	0.084 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.217 ms	- Mb
displayFooterPart3	0.987 ms	0.03 Mb
blockwishlist	0.640 ms	0.01 Mb
__construct	0.139 ms	0.01 Mb
hookActionFrontControllerSetMedia	0.501 ms	- Mb
productcomments	0.529 ms	0.01 Mb
__construct	0.102 ms	0.01 Mb
hookDisplayHeader	0.427 ms	- Mb
hirecaptcha	1.185 ms	0.04 Mb
__construct	0.377 ms	0.01 Mb
hookDisplayHeader	0.802 ms	0.03 Mb
hookDisplayBanner	0.006 ms	- Mb
tbcmscustomsetting	4.305 ms	0.06 Mb
__construct	0.489 ms	- Mb
hookDisplayHeader	1.620 ms	0.01 Mb
hookDisplayBackgroundBody	0.325 ms	- Mb
hookDisplayTopOfferText	0.009 ms	- Mb
hookDisplayTopOfferText	0.005 ms	- Mb

#	Query	Time (ms)	Rows	Filesort	Location
518	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	80.344 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)
469	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	17.839 ms	12303388	Yes	/classes/Product.php:3110 /modules/tbcmstabproducts/tbcmstabproducts.php:2349 (getNewProducts) /modules/tbcmsnewproducts/tbcmsnewproducts.php:156 (displayNewProducts) /modules/tbcmsnewproducts/tbcmsnewproducts.php:190 (showFrontSideResult) /classes/Hook.php:1043 (hookdisplayLeftColumn) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /config/smarty.config.inc.php:198 (exec) /classes/Smarty/SmartyLazyRegister.php:81 (smartyHook) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:184 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/63/d9/4e/63d94eaf33e1026dfe0e0ee5153be8ecb0e50d6b_2.file.layout-both-columns.tpl.php:70 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420259e03_42807721) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/90/1b/b3/901bb308ec32eb722c6c222c6f83e4d4788151cc_2.file.layout-left-column.tpl.php:30 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420245086_52031010) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/79/a7/65/79a7654bb1f8a93f7f7fa8b762d29936dea5b14b_2.file.product-list.tpl.php:33 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e542023dd26_81366209) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:115 (_subTemplateRender) /var/cache/dev/smarty/compile/TB_PS_Watch_Clock_201layouts_layout_left_column_tpl/11/a5/60/11a560a2f4e48bf5f387cf71bce1db497251efc6_2.file.category.tpl.php:29 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_691e5420233bf4_19633349) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 (_execute) /classes/Smarty/SmartyDev.php:40 (fetch) /classes/controller/FrontController.php:753 (fetch) /classes/controller/FrontController.php:735 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
9	SELECT SQL_NO_CACHE 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 (32, 44, 29, 132, 133, 135, 136, 137, 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 (32, 44, 29, 132, 133, 135, 136, 137, 156)))	17.548 ms	1522		/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)
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 (32, 44, 29, 132, 133, 135, 136, 137, 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	14.288 ms	579121	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)
420	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	3.806 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 (823,1301,613,44,1283,1319,1302,1284,1281,1551,1741,1555,847,1912,1753,1045,1546,610,748,1814,1661,1544,677,1553,675,1872,1554,1549,1543,607,1658,697,611,1550,1660,1609,1973,1837,42,2016,1962,1798,933,929,868,749,688,666,595,593)	1.155 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="c7135552c4b2c42d900e295f70385e72" LIMIT 1	0.645 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)
630	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` = 1200 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.555 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)
517	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` = 3349 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` = 3349 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/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
563	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 (1252)	0.527 ms	1		/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tbcmstabproducts/tbcmstabproducts.php:2328 (assembleProduct) /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)
570	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` = 1176 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.515 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)
612	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` = 1197 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.512 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)
600	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.509 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)
582	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` = 1192 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.508 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)
1229	INSERT INTO `ps_connections_source` (`id_connections`, `http_referer`, `request_uri`, `keywords`, `date_add`) VALUES ('49839', '', 'www.lebonvapoteur.fr/2-accueil?p=22&q=Contenance-50ml-140ml-180ml-4ml-4.5ml-3.5ml-5ml-3ml-8ml', '', '2025-11-20 00:37:11')	0.500 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)
496	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` = 3351 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.499 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
576	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` = 1177 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.495 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)
588	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` = 1193 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.494 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)
606	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` = 1196 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.494 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)
618	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` = 1198 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.491 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)
594	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` = 1194 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.487 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/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)
504	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` = 3350 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.482 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
565	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 (2781)	0.478 ms	1		/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tbcmstabproducts/tbcmstabproducts.php:2328 (assembleProduct) /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)
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.464 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)
567	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 (186)	0.464 ms	1		/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tbcmstabproducts/tbcmstabproducts.php:2328 (assembleProduct) /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)
509	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` = 3350 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` = 3350 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.463 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
564	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 (3050)	0.451 ms	1		/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tbcmstabproducts/tbcmstabproducts.php:2328 (assembleProduct) /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)
472	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` = 3354 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.443 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
1068	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` = 3252 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.437 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)
566	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 (3032)	0.436 ms	1		/classes/ProductAssembler.php:64 /classes/ProductAssembler.php:182 (addMissingProductFields) /modules/tbcmstabproducts/tbcmstabproducts.php:2328 (assembleProduct) /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)
501	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` = 3351 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` = 3351 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.432 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
536	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` = 4245 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 1573 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` = 4245 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 1573 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.420 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /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)
512	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` = 3349 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.418 ms	1	Yes	/classes/SpecificPrice.php:576 /classes/Product.php:3826 (getSpecificPrice) /classes/Product.php:3716 (priceCalculation) /classes/Product.php:5674 (getPriceStatic) /classes/Product.php:5971 (getProductProperties) /classes/Product.php:3127 (getProductsProperties) /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)
562	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` = 558 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND cp.`id_product` = 186 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` = 558 AND cp.`id_customization` = 0 AND cp.`id_cart` = 0 AND p.`id_product_item` = 186 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.416 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5791 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /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)
1092	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` = 3256 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.416 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)
548	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` = 2781 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` = 2781 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.415 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /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)
996	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` = 3240 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.414 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)
1086	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` = 3255 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.414 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)
1098	SELECT SQL_NO_CACHE *, ( IF (`id_group` = 1, 2, 0) + IF (`id_country` = 8, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 1, 16, 0) + IF (`id_customer` = 0, 32, 0)) AS `score` FROM `ps_specific_price` WHERE `id_shop` IN (0, 1) AND `id_currency` IN (0, 1) AND `id_country` IN (0, 8) AND `id_group` IN (0, 1) AND `id_product` = 3257 AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2025-11-20 00:00:00' <= `to`) AND IF(`from_quantity` > 1, `from_quantity`, 0) <= 1 ORDER BY `id_product_attribute` DESC, `id_cart` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.408 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)
554	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` = 3032 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` = 3032 AND (pr.`pack_stock_type` IN (1,2) OR ( pr.`pack_stock_type` = 3 AND 0 = 1 ))) as q LIMIT 1	0.407 ms	0		/classes/Cart.php:1410 /classes/Product.php:4342 (getProductQuantity) /classes/Product.php:5780 (getQuantity) /classes/Product.php:5971 (getProductProperties) /classes/Category.php:1074 (getProductsProperties) /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)

Name	Instances	Source
Product	260	/classes/Link.php:113 (__construct) [id: 823] /classes/Link.php:113 (__construct) [id: 1301] /classes/Link.php:113 (__construct) [id: 613] /classes/Link.php:113 (__construct) [id: 44] /classes/Link.php:113 (__construct) [id: 1283] /classes/Link.php:113 (__construct) [id: 1319] /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: 1551] /classes/Link.php:113 (__construct) [id: 1741] /classes/Link.php:113 (__construct) [id: 1555] /classes/Link.php:113 (__construct) [id: 847] /classes/Link.php:113 (__construct) [id: 1912] /classes/Link.php:113 (__construct) [id: 1753] /classes/Link.php:113 (__construct) [id: 1045] /classes/Link.php:113 (__construct) [id: 1546] /classes/Link.php:113 (__construct) [id: 610] /classes/Link.php:113 (__construct) [id: 748] /classes/Link.php:113 (__construct) [id: 1814] /classes/Link.php:113 (__construct) [id: 1661] /classes/Link.php:113 (__construct) [id: 1544] /classes/Link.php:113 (__construct) [id: 677] /classes/Link.php:113 (__construct) [id: 1553] /classes/Link.php:113 (__construct) [id: 675] /classes/Link.php:113 (__construct) [id: 1872] /classes/Link.php:113 (__construct) [id: 1554] /classes/Link.php:113 (__construct) [id: 1549] /classes/Link.php:113 (__construct) [id: 1543] /classes/Link.php:113 (__construct) [id: 607] /classes/Link.php:113 (__construct) [id: 1658] /classes/Link.php:113 (__construct) [id: 697] /classes/Link.php:113 (__construct) [id: 611] /classes/Link.php:113 (__construct) [id: 1550] /classes/Link.php:113 (__construct) [id: 1660] /classes/Link.php:113 (__construct) [id: 1609] /classes/Link.php:113 (__construct) [id: 1973] /classes/Link.php:113 (__construct) [id: 1837] /classes/Link.php:113 (__construct) [id: 42] /classes/Link.php:113 (__construct) [id: 2016] /classes/Link.php:113 (__construct) [id: 1962] /classes/Link.php:113 (__construct) [id: 1798] /classes/Link.php:113 (__construct) [id: 933] /classes/Link.php:113 (__construct) [id: 929] /classes/Link.php:113 (__construct) [id: 868] /classes/Link.php:113 (__construct) [id: 749] /classes/Link.php:113 (__construct) [id: 688] /classes/Link.php:113 (__construct) [id: 666] /classes/Link.php:113 (__construct) [id: 595] /classes/Link.php:113 (__construct) [id: 593] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 823] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1301] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 613] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 44] /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: 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: 1551] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1741] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1555] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 847] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1912] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1753] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1045] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1546] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 610] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 748] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1814] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1661] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1544] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 677] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1553] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 675] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1872] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1554] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1549] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1543] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 607] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1658] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 697] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 611] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1550] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1660] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1609] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1973] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1837] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 42] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2016] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1962] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1798] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 933] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 929] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 868] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 749] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 688] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 666] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 595] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 593] /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: 1252] /classes/Link.php:113 (__construct) [id: 1573] /classes/Link.php:113 (__construct) [id: 3050] /classes/Link.php:113 (__construct) [id: 2781] /classes/Link.php:113 (__construct) [id: 3032] /classes/Link.php:113 (__construct) [id: 186] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1252] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 1573] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3050] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 2781] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 3032] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 186] /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: 823] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 823] /classes/Link.php:113 (__construct) [id: 1301] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1301] /classes/Link.php:113 (__construct) [id: 613] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 613] /classes/Link.php:113 (__construct) [id: 44] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 44] /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: 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: 1551] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1551] /classes/Link.php:113 (__construct) [id: 1741] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1741] /classes/Link.php:113 (__construct) [id: 1555] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1555] /classes/Link.php:113 (__construct) [id: 847] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 847] /classes/Link.php:113 (__construct) [id: 1912] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1912] /classes/Link.php:113 (__construct) [id: 1753] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1753] /classes/Link.php:113 (__construct) [id: 1045] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1045] /classes/Link.php:113 (__construct) [id: 1546] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1546] /classes/Link.php:113 (__construct) [id: 610] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 610] /classes/Link.php:113 (__construct) [id: 748] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 748] /classes/Link.php:113 (__construct) [id: 1814] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1814] /classes/Link.php:113 (__construct) [id: 1661] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1661] /classes/Link.php:113 (__construct) [id: 1544] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1544] /classes/Link.php:113 (__construct) [id: 677] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 677] /classes/Link.php:113 (__construct) [id: 1553] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1553] /classes/Link.php:113 (__construct) [id: 675] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 675] /classes/Link.php:113 (__construct) [id: 1872] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1872] /classes/Link.php:113 (__construct) [id: 1554] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1554] /classes/Link.php:113 (__construct) [id: 1549] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1549] /classes/Link.php:113 (__construct) [id: 1543] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1543] /classes/Link.php:113 (__construct) [id: 607] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 607] /classes/Link.php:113 (__construct) [id: 1658] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1658] /classes/Link.php:113 (__construct) [id: 697] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 697] /classes/Link.php:113 (__construct) [id: 611] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 611] /classes/Link.php:113 (__construct) [id: 1550] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1550] /classes/Link.php:113 (__construct) [id: 1660] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1660] /classes/Link.php:113 (__construct) [id: 1609] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1609] /classes/Link.php:113 (__construct) [id: 1973] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1973] /classes/Link.php:113 (__construct) [id: 1837] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1837] /classes/Link.php:113 (__construct) [id: 42] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 42] /classes/Link.php:113 (__construct) [id: 2016] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 2016] /classes/Link.php:113 (__construct) [id: 1962] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1962] /classes/Link.php:113 (__construct) [id: 1798] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 1798] /classes/Link.php:113 (__construct) [id: 933] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 933] /classes/Link.php:113 (__construct) [id: 929] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 929] /classes/Link.php:113 (__construct) [id: 868] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 868] /classes/Link.php:113 (__construct) [id: 749] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 749] /classes/Link.php:113 (__construct) [id: 688] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 688] /classes/Link.php:113 (__construct) [id: 666] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 666] /classes/Link.php:113 (__construct) [id: 595] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 595] /classes/Link.php:113 (__construct) [id: 593] /src/Adapter/Presenter/Product/ProductLazyArray.php:662 (__construct) [id: 593]
Combination	65	/classes/Product.php:5893 (__construct) [id: 2780] /classes/Product.php:5893 (__construct) [id: 3781] /classes/Product.php:5893 (__construct) [id: 4488] /classes/Product.php:5893 (__construct) [id: 80] /classes/Product.php:5893 (__construct) [id: 3769] /classes/Product.php:5893 (__construct) [id: 3787] /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: 4153] /classes/Product.php:5893 (__construct) [id: 4680] /classes/Product.php:5893 (__construct) [id: 4157] /classes/Product.php:5893 (__construct) [id: 2807] /classes/Product.php:5893 (__construct) [id: 4898] /classes/Product.php:5893 (__construct) [id: 4695] /classes/Product.php:5893 (__construct) [id: 3027] /classes/Product.php:5893 (__construct) [id: 4148] /classes/Product.php:5893 (__construct) [id: 2533] /classes/Product.php:5893 (__construct) [id: 2675] /classes/Product.php:5893 (__construct) [id: 4758] /classes/Product.php:5893 (__construct) [id: 4470] /classes/Product.php:5893 (__construct) [id: 4146] /classes/Product.php:5893 (__construct) [id: 2596] /classes/Product.php:5893 (__construct) [id: 4155] /classes/Product.php:5893 (__construct) [id: 2595] /classes/Product.php:5893 (__construct) [id: 4853] /classes/Product.php:5893 (__construct) [id: 4156] /classes/Product.php:5893 (__construct) [id: 4151] /classes/Product.php:5893 (__construct) [id: 4145] /classes/Product.php:5893 (__construct) [id: 2530] /classes/Product.php:5893 (__construct) [id: 4467] /classes/Product.php:5893 (__construct) [id: 2612] /classes/Product.php:5893 (__construct) [id: 2534] /classes/Product.php:5893 (__construct) [id: 4152] /classes/Product.php:5893 (__construct) [id: 4469] /classes/Product.php:5893 (__construct) [id: 4351] /classes/Product.php:5893 (__construct) [id: 4983] /classes/Product.php:5893 (__construct) [id: 4791] /classes/Product.php:5893 (__construct) [id: 77] /classes/Product.php:5893 (__construct) [id: 5025] /classes/Product.php:5893 (__construct) [id: 4970] /classes/Product.php:5893 (__construct) [id: 4743] /classes/Product.php:5893 (__construct) [id: 2889] /classes/Product.php:5893 (__construct) [id: 2885] /classes/Product.php:5893 (__construct) [id: 2827] /classes/Product.php:5893 (__construct) [id: 2676] /classes/Product.php:5893 (__construct) [id: 2605] /classes/Product.php:5893 (__construct) [id: 2586] /classes/Product.php:5893 (__construct) [id: 2517] /classes/Product.php:5893 (__construct) [id: 2515] /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: 3733] /classes/Product.php:5893 (__construct) [id: 4245] /classes/Product.php:5893 (__construct) [id: 558] /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

Sun Tan Mango - 50ml - DINNER LADY

Sun Tan Mango - 50ml - DINNER LADY

Sun Tan Mango - 50ml - DINNER LADY

Sun Tan Mango - 50ml - DINNER LADY

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

PYREX VECO PLUS VAPORESSO

Dragon - 50ml - Freeze

Dragon - 50ml - Freeze

Dragon - 50ml - Freeze

Dragon - 50ml - Freeze

Flacon Aiguille

Flacon Aiguille

Flacon Aiguille

Flacon Aiguille

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 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

Menthe glaciale - 50ml - ELIQUID FRANCE

Menthe glaciale - 50ml - ELIQUID FRANCE

Menthe glaciale - 50ml - ELIQUID FRANCE

Menthe glaciale - 50ml - ELIQUID FRANCE

Fruits rouges - 50ML - CONCEPTAROME

Fruits rouges - 50ML - CONCEPTAROME

Fruits rouges - 50ML - CONCEPTAROME

Fruits rouges - 50ML - CONCEPTAROME

Classic EASTBLEND - 50ml - ELIQUID FRANCE

Classic EASTBLEND - 50ml - ELIQUID FRANCE

Classic EASTBLEND - 50ml - ELIQUID FRANCE

Classic EASTBLEND - 50ml - ELIQUID FRANCE

Rod - 50ml - Frukt

Rod - 50ml - Frukt

Rod - 50ml - Frukt

Rod - 50ml - Frukt

Sunset - 50ml - FULL MOON

Sunset - 50ml - FULL MOON

Sunset - 50ml - FULL MOON

Sunset - 50ml - FULL MOON

Bubble punch - 50ml - LIQUIDEO

Bubble punch - 50ml - LIQUIDEO

Bubble punch - 50ml - LIQUIDEO

Bubble punch - 50ml - LIQUIDEO

Tabac TBC - 50ml - Le Coq qui Vape

Tabac TBC - 50ml - Le Coq qui Vape

Tabac TBC - 50ml - Le Coq qui Vape

Tabac TBC - 50ml - Le Coq qui Vape

Fruits rouges - 50ml - ELIQUID FRANCE

Fruits rouges - 50ml - ELIQUID FRANCE

Fruits rouges - 50ml - ELIQUID FRANCE

Fruits rouges - 50ml - ELIQUID FRANCE