Panier

Téléviseur ROCH RH-LE32ST

125 000 FCFA

125 000 FCFA

1 article 125 000 FCFA

Livraison gratuit

Total (HT) 125 000 FCFA

Warning: Trying to access array offset on null in /home/hascor/hascorburkina/var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/22/46/44/2246449ceccb31f70db00b26fa6f91be27f1419a_2.file.cart-detailed-totals.tpl.php on line 114

Warning: Trying to access array offset on null in /home/hascor/hascorburkina/var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/22/46/44/2246449ceccb31f70db00b26fa6f91be27f1419a_2.file.cart-detailed-totals.tpl.php on line 116

Commander

PRODUITS GARANTIES

(Produits de qualité sous garanties solides)

Paiement securisé

(Faites vos achats en toute securité)

Livraison gratuite

(Nous vous offrons gratuitement la livraison)

Suivez-nous sur Facebook

Facebook

Load Time	1525 ms
Querying Time	234 ms
Queries	209
Memory Peak Usage	62.9 Mb
Included Files	1437 files - 16.77 Mb
PrestaShop Cache	- Mb
Global vars	0.43 Mb
- global $_MODULES	403k
- global $_SERVER	12k
- global $_ENV	6k
- global $__composer_autoload_files	6k
- global $context	4k
- global $config	4k
- global $exportPhpConfigFile	3k

PrestaShop Version	8.1.5
PHP Version	8.3.0
MySQL Version	5.7.42-log
Memory Limit	512M
Max Execution Time	165s
Smarty Cache	enabled
Smarty Compilation	force compile

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	62.375 ms	62.375 ms	19.80 Mb	21.1 Mb
__construct	0.040 ms	62.415 ms	- Mb	21.1 Mb
init	285.404 ms	347.819 ms	12.74 Mb	33.9 Mb
checkAccess	0.001 ms	347.820 ms	- Mb	33.9 Mb
setMedia	75.474 ms	423.294 ms	5.08 Mb	38.5 Mb
postProcess	282.732 ms	706.026 ms	7.91 Mb	45.6 Mb
initHeader	0.002 ms	706.028 ms	- Mb	45.6 Mb
initContent	292.114 ms	998 ms	10.40 Mb	56.2 Mb
initFooter	0.002 ms	998 ms	- Mb	56.2 Mb
display	527.081 ms	1525 ms	6.13 Mb	62.9 Mb

Hook	Time	Memory Usage
ActionObjectCartAddAfter	118.810 ms	2.79 Mb
=> ps_eventbus	118.810 ms	2.79 Mb
DisplayFooter	106.943 ms	0.83 Mb
=> angarcontact	1.163 ms	0.02 Mb
=> angarscrolltop	3.405 ms	0.01 Mb
=> angarthemeconfigurator	102.375 ms	0.80 Mb
DisplayHeader	94.635 ms	2.78 Mb
=> angarmanufacturer	0.434 ms	- Mb
=> angarfacebook	0.625 ms	- Mb
=> angarcmsinfo	0.413 ms	- Mb
=> angarparallax	0.417 ms	- Mb
=> angarscrolltop	0.637 ms	- Mb
=> gformbuilderpro	4.368 ms	0.02 Mb
=> ybc_productimagehover	17.756 ms	1.21 Mb
=> ets_livechat_free	17.074 ms	0.13 Mb
=> angarcatproduct	0.423 ms	- Mb
=> angarfastconfig	0.010 ms	- Mb
=> angarhomecat	0.410 ms	- Mb
=> angarthemeconfigurator	20.234 ms	0.23 Mb
=> angarbanners	0.424 ms	- Mb
=> ets_whatsapp	0.635 ms	- Mb
=> ps_facebook	0.011 ms	- Mb
=> angarslider	0.464 ms	- Mb
=> ets_megamenu	28.525 ms	1.17 Mb
=> ps_googleanalytics	0.325 ms	0.01 Mb
=> ps_shoppingcart	0.254 ms	- Mb
=> coreimage	0.064 ms	- Mb
=> productcomments	1.131 ms	- Mb
displayNav2	81.657 ms	0.33 Mb
=> ps_customersignin (widget)	17.745 ms	0.04 Mb
=> ps_languageselector (widget)	6.749 ms	0.05 Mb
=> ps_currencyselector (widget)	12.872 ms	0.17 Mb
=> ps_shoppingcart (widget)	44.291 ms	0.08 Mb
ActionFrontControllerSetMedia	62.094 ms	3.76 Mb
=> blockwishlist	1.802 ms	0.12 Mb
=> ps_emailsubscription	0.706 ms	- Mb
=> blockreassurance	0.720 ms	- Mb
=> ps_checkout	57.040 ms	3.63 Mb
=> ps_socialfollow	0.552 ms	- Mb
=> ps_facebook	0.576 ms	- Mb
=> klaviyopsautomation	0.005 ms	- Mb
=> psxdesign	0.693 ms	0.01 Mb
ActionCartUpdateQuantityBefore	55.287 ms	1.16 Mb
=> psxmarketingwithgoogle	36.831 ms	0.48 Mb
=> ps_checkout	0.033 ms	- Mb
=> ps_googleanalytics	18.423 ms	0.68 Mb
DisplayReassurance	41.640 ms	0.16 Mb
=> blockreassurance	41.640 ms	0.16 Mb
ActionCartSave	27.730 ms	1.15 Mb
=> ps_facebook	27.724 ms	1.15 Mb
=> ps_facebook	0.006 ms	- Mb
DisplayBeforeBodyClosingTag	20.160 ms	0.31 Mb
=> angarslider	3.541 ms	0.01 Mb
=> angarcatproduct	5.003 ms	0.03 Mb
=> angarmanufacturer	3.968 ms	0.01 Mb
=> statsdata	7.648 ms	0.25 Mb
displayNavFullWidth	13.360 ms	0.49 Mb
=> ps_mainmenu (widget)	13.360 ms	0.49 Mb
DisplayBanner	12.867 ms	0.08 Mb
=> angarbanners	12.867 ms	0.08 Mb
DisplayFooterAfter	10.640 ms	0.06 Mb
=> angarbanners	10.640 ms	0.06 Mb
displayFooterAfter	10.485 ms	0.11 Mb
=> ps_emailsubscription (widget)	6.350 ms	0.06 Mb
=> ps_socialfollow (widget)	4.135 ms	0.05 Mb
displayFooter	7.529 ms	0.12 Mb
=> ps_linklist (widget)	4.175 ms	0.06 Mb
=> ps_customeraccountlinks (widget)	3.354 ms	0.05 Mb
DisplayNav1	5.531 ms	0.10 Mb
=> angarcontact	5.531 ms	0.10 Mb
displayTop	4.084 ms	0.01 Mb
=> ps_searchbar (widget)	4.084 ms	0.01 Mb
DisplayAfterTitleTag	3.239 ms	0.01 Mb
=> psxdesign	3.239 ms	0.01 Mb
AngarFacebook	2.790 ms	0.03 Mb
=> angarfacebook	2.790 ms	0.03 Mb
ModuleRoutes	1.798 ms	0.02 Mb
=> gformbuilderpro	0.012 ms	- Mb
=> lgseoredirect	1.783 ms	0.02 Mb
=> klaviyopsautomation	0.003 ms	- Mb
ActionDispatcherBefore	1.446 ms	0.08 Mb
=> psxdesign	1.406 ms	0.08 Mb
=> psassistant	0.040 ms	- Mb
ActionDispatcher	1.221 ms	- Mb
=> lgseoredirect	1.207 ms	- Mb
=> mbeshipping	0.004 ms	- Mb
=> psassistant	0.010 ms	- Mb
ActionObjectCartUpdateAfter	0.877 ms	0.01 Mb
=> ps_eventbus	0.877 ms	0.01 Mb
ActionOutputHTMLBefore	0.047 ms	- Mb
=> coreimage	0.047 ms	- Mb
ActionModuleRegisterHookAfter	0.002 ms	- Mb
=> ps_customeraccountlinks	0.002 ms	- Mb
24 hook(s)	684.871 ms	14.40 Mb

Module	Time	Memory Usage
gformbuilderpro	13.210 ms	0.76 Mb
__construct	8.824 ms	0.74 Mb
hookModuleRoutes	0.016 ms	- Mb
hookDisplayHeader	4.370 ms	0.02 Mb
lgseoredirect	10.181 ms	0.38 Mb
__construct	7.184 ms	0.36 Mb
hookModuleRoutes	1.785 ms	0.02 Mb
hookActionDispatcher	1.212 ms	- Mb
klaviyopsautomation	12.948 ms	2.26 Mb
__construct	12.936 ms	2.25 Mb
hookModuleRoutes	0.006 ms	- Mb
hookActionFrontControllerSetMedia	0.006 ms	- Mb
psxdesign	31.225 ms	3.18 Mb
__construct	25.877 ms	3.08 Mb
hookActionDispatcherBefore	1.410 ms	0.08 Mb
hookActionFrontControllerSetMedia	0.695 ms	0.01 Mb
hookDisplayAfterTitleTag	3.243 ms	0.01 Mb
psassistant	2.483 ms	0.04 Mb
__construct	2.430 ms	0.04 Mb
hookActionDispatcherBefore	0.042 ms	- Mb
hookActionDispatcher	0.011 ms	- Mb
mbeshipping	16.882 ms	2.20 Mb
__construct	16.875 ms	2.20 Mb
hookActionDispatcher	0.007 ms	- Mb
blockwishlist	2.365 ms	0.17 Mb
__construct	0.559 ms	0.06 Mb
hookActionFrontControllerSetMedia	1.806 ms	0.12 Mb
ps_emailsubscription	8.856 ms	0.35 Mb
__construct	1.793 ms	0.28 Mb
hookActionFrontControllerSetMedia	0.709 ms	- Mb
displayFooterAfter	6.354 ms	0.06 Mb
blockreassurance	43.105 ms	0.26 Mb
__construct	0.737 ms	0.09 Mb
hookActionFrontControllerSetMedia	0.722 ms	- Mb
hookDisplayReassurance	41.646 ms	0.16 Mb
ps_checkout	62.236 ms	4.28 Mb
__construct	5.158 ms	0.65 Mb
hookActionFrontControllerSetMedia	57.044 ms	3.63 Mb
hookActionCartUpdateQuantityBefore	0.034 ms	- Mb
ps_accounts	1.894 ms	0.07 Mb
__construct	1.894 ms	0.07 Mb
ps_socialfollow	5.403 ms	0.12 Mb
__construct	0.712 ms	0.06 Mb
hookActionFrontControllerSetMedia	0.554 ms	- Mb
displayFooterAfter	4.137 ms	0.05 Mb
ps_facebook	30.999 ms	1.31 Mb
__construct	2.675 ms	0.15 Mb
hookActionFrontControllerSetMedia	0.578 ms	- Mb
hookActionCartSave	27.727 ms	1.16 Mb
hookActionCartSave	0.007 ms	- Mb
hookDisplayHeader	0.012 ms	- Mb
ps_eventbus	121.541 ms	2.94 Mb
__construct	1.847 ms	0.14 Mb
hookActionObjectCartAddAfter	118.814 ms	2.79 Mb
hookActionObjectCartUpdateAfter	0.880 ms	0.01 Mb
psxmarketingwithgoogle	37.911 ms	0.53 Mb
__construct	1.077 ms	0.05 Mb
hookActionCartUpdateQuantityBefore	36.834 ms	0.48 Mb
ps_googleanalytics	19.279 ms	0.74 Mb
__construct	0.527 ms	0.05 Mb
hookActionCartUpdateQuantityBefore	18.425 ms	0.68 Mb
hookDisplayHeader	0.327 ms	0.01 Mb
coreimage	18.539 ms	1.84 Mb
__construct	18.424 ms	1.83 Mb
hookDisplayHeader	0.066 ms	- Mb
hookActionOutputHTMLBefore	0.049 ms	- Mb
angarmanufacturer	5.593 ms	0.03 Mb
__construct	1.184 ms	0.01 Mb
hookDisplayHeader	0.438 ms	- Mb
hookDisplayBeforeBodyClosingTag	3.971 ms	0.01 Mb
angarfacebook	4.338 ms	0.07 Mb
__construct	0.918 ms	0.04 Mb
hookDisplayHeader	0.627 ms	- Mb
hookAngarFacebook	2.793 ms	0.03 Mb
angarcmsinfo	1.911 ms	0.08 Mb
__construct	1.496 ms	0.08 Mb
hookDisplayHeader	0.415 ms	- Mb
angarparallax	1.475 ms	0.06 Mb
__construct	1.056 ms	0.06 Mb
hookDisplayHeader	0.419 ms	- Mb
angarscrolltop	4.768 ms	0.03 Mb
__construct	0.722 ms	0.02 Mb
hookDisplayHeader	0.639 ms	- Mb
hookDisplayFooter	3.407 ms	0.01 Mb
ybc_productimagehover	18.756 ms	1.26 Mb
__construct	0.995 ms	0.06 Mb
hookDisplayHeader	17.761 ms	1.21 Mb
ps_customeraccountlinks	3.652 ms	0.09 Mb
__construct	0.291 ms	0.03 Mb
hookActionModuleRegisterHookAfter	0.005 ms	- Mb
displayFooter	3.356 ms	0.06 Mb
ets_livechat_free	28.464 ms	0.81 Mb
__construct	11.386 ms	0.68 Mb
hookDisplayHeader	17.078 ms	0.13 Mb
angarcatproduct	6.773 ms	0.09 Mb
__construct	1.342 ms	0.06 Mb
hookDisplayHeader	0.425 ms	- Mb
hookDisplayBeforeBodyClosingTag	5.006 ms	0.03 Mb
angarfastconfig	1.196 ms	0.08 Mb
__construct	1.184 ms	0.08 Mb
hookDisplayHeader	0.012 ms	- Mb
angarhomecat	1.430 ms	0.06 Mb
__construct	1.018 ms	0.06 Mb
hookDisplayHeader	0.412 ms	- Mb
angarthemeconfigurator	124.896 ms	1.34 Mb
__construct	2.276 ms	0.31 Mb
hookDisplayHeader	20.239 ms	0.23 Mb
hookDisplayFooter	102.381 ms	0.80 Mb
angarbanners	25.742 ms	0.30 Mb
__construct	1.796 ms	0.15 Mb
hookDisplayHeader	0.427 ms	- Mb
hookDisplayBanner	12.874 ms	0.08 Mb
hookDisplayFooterAfter	10.645 ms	0.07 Mb
ets_whatsapp	2.508 ms	0.12 Mb
__construct	1.871 ms	0.12 Mb
hookDisplayHeader	0.637 ms	- Mb
angarslider	5.918 ms	0.23 Mb
__construct	1.908 ms	0.21 Mb
hookDisplayHeader	0.466 ms	- Mb
hookDisplayBeforeBodyClosingTag	3.544 ms	0.01 Mb
ets_megamenu	40.160 ms	2.39 Mb
__construct	11.629 ms	1.22 Mb
hookDisplayHeader	28.531 ms	1.17 Mb
ps_shoppingcart	45.103 ms	0.12 Mb
__construct	0.551 ms	0.04 Mb
hookDisplayHeader	0.256 ms	- Mb
displayNav2	44.296 ms	0.08 Mb
ps_searchbar	4.468 ms	0.04 Mb
__construct	0.382 ms	0.03 Mb
displayTop	4.086 ms	0.01 Mb
ps_customersignin	18.091 ms	0.06 Mb
__construct	0.340 ms	0.02 Mb
displayNav2	17.751 ms	0.04 Mb
productcomments	2.739 ms	0.18 Mb
__construct	1.605 ms	0.17 Mb
hookDisplayHeader	1.134 ms	- Mb
angarcontact	7.778 ms	0.14 Mb
__construct	1.078 ms	0.02 Mb
hookDisplayNav1	5.535 ms	0.10 Mb
hookDisplayFooter	1.165 ms	0.02 Mb
ps_languageselector	7.189 ms	0.08 Mb
__construct	0.436 ms	0.02 Mb
displayNav2	6.753 ms	0.05 Mb
ps_currencyselector	13.321 ms	0.20 Mb
__construct	0.445 ms	0.03 Mb
displayNav2	12.876 ms	0.17 Mb
ps_mainmenu	15.866 ms	0.74 Mb
__construct	2.502 ms	0.26 Mb
displayNavFullWidth	13.364 ms	0.49 Mb
ps_linklist	12.418 ms	1.87 Mb
__construct	8.240 ms	1.80 Mb
displayFooter	4.178 ms	0.06 Mb
statsdata	8.265 ms	0.30 Mb
__construct	0.613 ms	0.05 Mb
hookDisplayBeforeBodyClosingTag	7.652 ms	0.25 Mb
43 module(s)	852 ms	32.18 Mb

Panier

Suivez-nous sur Facebook

Stopwatch SQL - 209 queries

Doubles

Tables stress

ObjectModel instances

Included Files

17 queries	SELECT `id_module` FROM `prsp_module_shop` WHERE `id_module` = XX AND `id_shop` = XX LIMIT XX
10 queries	SELECT `id_lang` FROM `prsp_lang` WHERE `locale` = 'fr-fr' OR `language_code` = 'fr-fr' LIMIT XX
8 queries	SELECT cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, XX) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, XX, XX), LPAD(IFNULL(cp.`id_product_attribute`, XX), XX, XX), IFNULL(cp.`id_address_delivery`, XX), IFNULL(cp.`id_customization`, XX)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`eanXX`, '') = '', p.`eanXX`, pa.`eanXX`) AS eanXX, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > XX, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = XX AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = XX AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, XX) AND stock.id_shop = XX AND stock.id_shop_group = XX ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = XX LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_image_shop` `image_shop` ON image_shop.`id_product` = p.`id_product` AND image_shop.cover=XX AND image_shop.id_shop=XX LEFT JOIN `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = XX WHERE (cp.`id_cart` = XX) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC
8 queries	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = XX AND cr.code = "" AND cr.quantity > XX AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = XX ) AND ( cr.`carrier_restriction` = XX ) AND ( cr.`shop_restriction` = XX ) AND ( cr.`group_restriction` = XX OR crg.`id_group` = XX ) AND ( cr.`reduction_product` <= XX OR EXISTS ( SELECT XX FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = XX ) ) AND NOT EXISTS (SELECT XX FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = XX) ORDER BY priority
6 queries	SELECT m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `prsp_module` m LEFT JOIN `prsp_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = XX
5 queries	SELECT * FROM `prsp_currency` a LEFT JOIN `prsp_currency_lang` `b` ON a.`id_currency` = b.`id_currency` AND b.`id_lang` = XX LEFT JOIN `prsp_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
4 queries	SELECT `id_module` FROM `prsp_module` WHERE `name` = "ps_accounts" LIMIT XX
3 queries	SELECT * FROM `prsp_currency` a LEFT JOIN `prsp_currency_shop` `c` ON a.`id_currency` = c.`id_currency` AND c.`id_shop` = XX WHERE (a.`id_currency` = XX) LIMIT XX
3 queries	SELECT * FROM `prsp_currency_lang` WHERE `id_currency` = XX
3 queries	SELECT * FROM `prsp_country` a LEFT JOIN `prsp_country_shop` `c` ON a.`id_country` = c.`id_country` AND c.`id_shop` = XX WHERE (a.`id_country` = XX) LIMIT XX
2 queries	SELECT * FROM prsp_lgseoredirect WHERE (CONCAT("", url_old) = "/panier?add=&id_product=XX&token=XXcfXXbXXcXXbXXbfXXeXXd?add=&id_product=XX&token=XXcfXXbXXcXXbXXbfXXeXXd" OR CONCAT("", url_old) LIKE "/panier?add=&id_product=XX&token=XXcfXXbXXcXXbXXbfXXeXXd?add=&id_product=XX&token=XXcfXXbXXcXXbXXbfXXeXXd#%") AND id_shop = "XX" ORDER BY id DESC LIMIT XX
2 queries	SELECT XX FROM `prsp_specific_price` WHERE id_product = XX LIMIT XX
2 queries	SELECT cl.`link_rewrite` FROM `prsp_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = XX LIMIT XX
2 queries	INSERT INTO `prsp_eventbus_incremental_sync` (`id_shop`, `id_object`, `type`, `created_at`, `lang_iso`) VALUES ('XX', 'XX', 'carts', 'XX-XX-XXTXX:XX:XX+XX:XX', 'fr') ON DUPLICATE KEY UPDATE `id_shop` = 'XX',`id_object` = 'XX',`type` = 'carts',`created_at` = 'XX-XX-XXTXX:XX:XX+XX:XX',`lang_iso` = 'fr'
2 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 `prsp_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 `prsp_cart_product` cp JOIN `prsp_pack` p ON cp.`id_product` = p.`id_product_pack` JOIN `prsp_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
2 queries	SELECT XX FROM prsp_cart_product cp INNER JOIN prsp_product p ON (p.id_product = cp.id_product) INNER JOIN prsp_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=XX LIMIT XX
2 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 prsp_product p LEFT JOIN prsp_product_lang pl ON pl.id_product = p.id_product AND pl.id_shop = XX AND pl.id_lang = XX LEFT JOIN prsp_stock_available sa ON sa.id_product = p.id_product AND sa.id_product_attribute = XX AND sa.id_shop = XX LEFT JOIN prsp_product_shop ps ON ps.id_product = p.id_product AND ps.id_shop = XX WHERE p.id_product IN (XX)
2 queries	SELECT image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `prsp_image` i INNER JOIN prsp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = XX) LEFT JOIN `prsp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = XX) WHERE i.`id_product` = XX ORDER BY `position`
2 queries	SELECT `id_product_attribute` FROM `prsp_product_attribute` WHERE `id_product` = XX
2 queries	SELECT COUNT(`id_customization`) FROM `prsp_cart_product` WHERE `id_cart` = XX AND `id_customization` != XX LIMIT XX
2 queries	SELECT cd.`id_customization`, c.`id_address_delivery`, c.`id_product`, cfl.`id_customization_field`, c.`id_product_attribute`, cd.`type`, cd.`index`, cd.`value`, cd.`id_module`, cfl.`name` FROM `prsp_customized_data` cd NATURAL JOIN `prsp_customization` c LEFT JOIN `prsp_customization_field_lang` cfl ON (cfl.id_customization_field = cd.`index` AND id_lang = XX) WHERE c.`id_cart` = XX AND c.`in_cart` = XX ORDER BY `id_product`, `id_product_attribute`, `type`, `index`
2 queries	SELECT XX FROM `prsp_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

Name	Instances	Source
Product	9	/controllers/front/CartController.php:390 (__construct) [id: 509] /classes/Cart.php:1510 (__construct) [id: 509] /classes/Link.php:113 (__construct) [id: 509] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 509] /classes/Cart.php:2634 (__construct) [id: 509] /src/Adapter/Image/ImageRetriever.php:77 (__construct) [id: 509] /classes/Link.php:113 (__construct) [id: 509] /classes/Link.php:113 (__construct) [id: 509] /classes/Link.php:113 (__construct) [id: 509]
Currency	8	/src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 1] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 5] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 3] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 2] /src/Adapter/Currency/CurrencyDataProvider.php:101 (__construct) [id: 4] /classes/Tools.php:695 (getCurrencyInstance) [id: 4] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 1] /modules/ps_currencyselector/ps_currencyselector.php:112 (getCurrencies) [id: 2]
Carrier	6	/classes/Cart.php:2633 (getAvailableCarrierList) [id: 19] /classes/Cart.php:2899 (__construct) [id: 19] /classes/Cart.php:4957 (__construct) [id: 19] /classes/Cart.php:3721 (__construct) [id: 19] /classes/Cart.php:4957 (__construct) [id: 19] /classes/Cart.php:3094 (__construct) [id: 19]
Address	5	/classes/Product.php:741 (__construct) [id: ] /classes/Product.php:6889 (initialize) [id: ] /classes/Product.php:3804 (__construct) [id: ] /classes/Product.php:5958 (__construct) [id: ] /classes/shop/Shop.php:486 (__construct) [id: ]
Country	5	/config/config.inc.php:146 (__construct) [id: 60] /classes/controller/FrontController.php:354 (__construct) [id: 60] /classes/Carrier.php:1506 (__construct) [id: 60] /classes/AddressFormat.php:404 (__construct) [id: 245] /classes/controller/FrontController.php:1767 (__construct) [id: 245]
Language	3	/config/config.inc.php:211 (__construct) [id: 1] /classes/Tools.php:560 (__construct) [id: 1] /classes/Cart.php:676 (getAssociatedLanguage) [id: 1]
Customer	3	/config/config.inc.php:264 (__construct) [id: ] /classes/Carrier.php:1553 (__construct) [id: ] /classes/AddressFormat.php:404 (__construct) [id: ]
AddressFormat	1	/classes/controller/FrontController.php:1761 (generateAddress) [id: ]
Connection	1	/modules/statsdata/statsdata.php:118 (setPageConnection) [id: ]
Guest	1	/modules/statsdata/statsdata.php:82 (setNewGuest) [id: ]
State	1	/classes/controller/FrontController.php:1766 (__construct) [id: 0]
Shop	1	/config/config.inc.php:117 (initialize) [id: 1]
Risk	1	/classes/controller/FrontController.php:1694 (__construct) [id: ]
Gender	1	/classes/controller/FrontController.php:1691 (__construct) [id: 0]
Group	1	/classes/Cart.php:249 (getCurrent) [id: 1]
Cart	1	/classes/controller/FrontController.php:467 (__construct) [id: ]
ShopGroup	1	/classes/shop/Shop.php:561 (__construct) [id: 1]
ConnectionsSource	1	/modules/statsdata/statsdata.php:119 (logHttpReferer) [id: ]

#	Query	Time (ms)	Rows	Filesort	Group By	Location
2	SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IF(cl.`id_lang` IS NULL, c.`value`, cl.`value`) AS value, c.id_shop_group, c.id_shop FROM `prsp_configuration` c LEFT JOIN `prsp_configuration_lang` cl ON (c.`id_configuration` = cl.`id_configuration`)	12.344 ms	9402			/classes/Configuration.php:180 /classes/Configuration.php:229 (loadConfiguration) /classes/Configuration.php:302 (get) /classes/shop/Shop.php:398 (getMultiShopValues) /config/config.inc.php:117 (initialize) /index.php:27 (require)
60	SELECT SQL_NO_CACHE * FROM `prsp_product` a LEFT JOIN `prsp_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `prsp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 509) AND (b.`id_shop` = 1) LIMIT 1	9.655 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /controllers/front/CartController.php:390 (__construct) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
146	SELECT SQL_NO_CACHE * FROM prsp_cart_cart_rule WHERE id_cart = 4184	6.402 ms	1			/classes/Cart.php:3039 /classes/Cart.php:3418 (getDeliveryOptionList) /classes/Cart.php:3491 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2186 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
119	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	5.536 ms	1	Yes	Yes	/classes/Cart.php:742 /src/Adapter/Presenter/Cart/CartPresenter.php:326 (getProducts) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
13	SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module FROM `prsp_module` m INNER JOIN prsp_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 1 AND module_shop.enable_device & 1) INNER JOIN `prsp_hook_module` `hm` ON hm.`id_module` = m.`id_module` INNER JOIN `prsp_hook` `h` ON hm.`id_hook` = h.`id_hook` LEFT JOIN `prsp_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "paymentOptions") AND (hm.`id_shop` = 1) AND (mg.id_shop = 1 AND mg.`id_group` IN (1)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	3.840 ms	2510	Yes	Yes	/classes/Hook.php:1233 /classes/Hook.php:735 (getAllHookRegistrations) /classes/Hook.php:842 (getHookModuleExecList) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
170	SELECT SQL_NO_CACHE * FROM prsp_hook_module WHERE `id_hook` = 73 AND `id_module` = 135 AND `id_shop` = 1	3.809 ms	1			/classes/Hook.php:515 /classes/Hook.php:596 (isModuleRegisteredOnHook) /classes/module/Module.php:1061 (registerHook) /modules/ets_livechat_free/ets_livechat_free.php:72 (registerHook) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/controller/FrontController.php:622 (exec) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
104	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	3.618 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:1653 (getProducts) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
147	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	3.585 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:2140 (getProducts) /classes/Cart.php:2293 (getOrderTotal) /src/Adapter/Presenter/Cart/CartPresenter.php:336 (getDiscountSubtotalWithoutGifts) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
161	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	3.504 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:2140 (getProducts) /classes/Cart.php:2293 (getOrderTotal) /src/Adapter/Presenter/Cart/CartPresenter.php:336 (getDiscountSubtotalWithoutGifts) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
162	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	3.474 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:2140 (getProducts) /src/Adapter/Presenter/Cart/CartPresenter.php:337 (getOrderTotal) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
63	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prsp_hook` UNION SELECT `id_hook`, ha.`alias` as name FROM `prsp_hook_alias` ha INNER JOIN `prsp_hook` h ON ha.name = h.name	3.450 ms	0			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/tax/TaxManagerFactory.php:67 (getIdByName) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6892 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/CartController.php:390 (__construct) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
114	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	3.364 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:2140 (getProducts) /classes/Cart.php:498 (getOrderTotal) /classes/CartRule.php:1766 (getCartRules) /classes/Cart.php:1659 (autoRemoveFromCart) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
155	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	2.980 ms	1	Yes	Yes	/classes/Cart.php:742 /src/Adapter/Presenter/Cart/CartPresenter.php:326 (getProducts) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
64	SELECT SQL_NO_CACHE h.id_hook, h.name as h_name, title, description, h.position, hm.position as hm_position, m.id_module, m.name, m.active FROM `prsp_hook_module` hm STRAIGHT_JOIN `prsp_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 1) STRAIGHT_JOIN `prsp_module` as m ON (m.id_module = hm.id_module) ORDER BY hm.position	2.792 ms	685			/classes/Hook.php:452 /classes/Hook.php:493 (getHookModuleList) /classes/tax/TaxManagerFactory.php:67 (getModulesFromHook) /classes/tax/TaxManagerFactory.php:46 (execHookTaxManagerFactory) /classes/Product.php:6892 (getManager) /classes/Product.php:741 (getTaxesRate) /controllers/front/CartController.php:390 (__construct) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
25	SELECT SQL_NO_CACHE m.page, ml.url_rewrite, ml.id_lang FROM `prsp_meta` m LEFT JOIN `prsp_meta_lang` ml ON (m.id_meta = ml.id_meta AND ml.id_shop = 1 ) ORDER BY LENGTH(ml.url_rewrite) DESC	2.740 ms	322	Yes		/classes/Dispatcher.php:654 /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
159	SELECT SQL_NO_CACHE COUNT(`id_customization`) FROM `prsp_cart_product` WHERE `id_cart` = 4184 AND `id_customization` != 0 LIMIT 1	2.701 ms	1			/classes/Product.php:6105 /src/Adapter/Presenter/Cart/CartPresenter.php:199 (getAllCustomizedDatas) :undefined (PrestaShop\PrestaShop\Adapter\Presenter\Cart\{closure}) /src/Adapter/Presenter/Cart/CartPresenter.php:196 (array_map) /src/Adapter/Presenter/Cart/CartPresenter.php:330 (addCustomizedData) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
98	SELECT SQL_NO_CACHE cp.`id_category`, cp.`id_product`, cl.`name` FROM `prsp_category_product` cp LEFT JOIN `prsp_category` c ON (c.id_category = cp.id_category) LEFT JOIN `prsp_category_lang` cl ON (cp.`id_category` = cl.`id_category` AND cl.id_shop = 1 ) INNER JOIN prsp_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 1) WHERE cp.`id_product` IN (509) AND cl.`id_lang` = 1 ORDER BY c.`level_depth` DESC	2.652 ms	1	Yes		/modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:103 /modules/ps_googleanalytics/classes/Wrapper/ProductWrapper.php:191 (loadCategories) /modules/ps_googleanalytics/classes/Hook/HookActionCartUpdateQuantityBefore.php:82 (prepareItemFromProduct) /modules/ps_googleanalytics/ps_googleanalytics.php:188 (run) /classes/Hook.php:1043 (hookActionCartUpdateQuantityBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Cart.php:1550 (exec) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
148	SELECT SQL_NO_CACHE cp.`id_product_attribute`, cp.`id_product`, cp.`quantity` AS cart_quantity, cp.id_shop, cp.`id_customization`, pl.`name`, p.`is_virtual`, pl.`description_short`, pl.`available_now`, pl.`available_later`, product_shop.`id_category_default`, p.`id_supplier`, p.`id_manufacturer`, m.`name` AS manufacturer_name, product_shop.`on_sale`, product_shop.`ecotax`, product_shop.`additional_shipping_cost`, product_shop.`available_for_order`, product_shop.`show_price`, product_shop.`price`, product_shop.`active`, product_shop.`unity`, product_shop.`unit_price`, stock.`quantity` AS quantity_available, p.`width`, p.`height`, p.`depth`, stock.`out_of_stock`, p.`weight`, p.`available_date`, p.`date_add`, p.`date_upd`, IFNULL(stock.quantity, 0) as quantity, pl.`link_rewrite`, cl.`link_rewrite` AS category, CONCAT(LPAD(cp.`id_product`, 10, 0), LPAD(IFNULL(cp.`id_product_attribute`, 0), 10, 0), IFNULL(cp.`id_address_delivery`, 0), IFNULL(cp.`id_customization`, 0)) AS unique_id, cp.id_address_delivery, product_shop.advanced_stock_management, ps.product_supplier_reference supplier_reference, cu.`id_customization`, cu.`quantity` AS customization_quantity, product_attribute_shop.`price` AS price_attribute, product_attribute_shop.`ecotax` AS ecotax_attr, IF (IFNULL(pa.`reference`, '') = '', p.`reference`, pa.`reference`) AS reference, (p.`weight`+ IFNULL(product_attribute_shop.`weight`, pa.`weight`)) weight_attribute, IF (IFNULL(pa.`ean13`, '') = '', p.`ean13`, pa.`ean13`) AS ean13, IF (IFNULL(pa.`isbn`, '') = '', p.`isbn`, pa.`isbn`) AS isbn, IF (IFNULL(pa.`upc`, '') = '', p.`upc`, pa.`upc`) AS upc, IF (IFNULL(pa.`mpn`, '') = '', p.`mpn`, pa.`mpn`) AS mpn, IFNULL(product_attribute_shop.`minimal_quantity`, product_shop.`minimal_quantity`) as minimal_quantity, IF(product_attribute_shop.wholesale_price > 0, product_attribute_shop.wholesale_price, product_shop.`wholesale_price`) wholesale_price , image_shop.`id_image` id_image, il.`legend` FROM `prsp_cart_product` cp LEFT JOIN `prsp_product` `p` ON p.`id_product` = cp.`id_product` INNER JOIN `prsp_product_shop` `product_shop` ON (product_shop.`id_shop` = cp.`id_shop` AND product_shop.`id_product` = p.`id_product`) LEFT JOIN `prsp_product_lang` `pl` ON p.`id_product` = pl.`id_product` AND pl.`id_lang` = 1 AND pl.id_shop = cp.id_shop LEFT JOIN `prsp_category_lang` `cl` ON product_shop.`id_category_default` = cl.`id_category` AND cl.`id_lang` = 1 AND cl.id_shop = cp.id_shop LEFT JOIN `prsp_product_supplier` `ps` ON ps.`id_product` = cp.`id_product` AND ps.`id_product_attribute` = cp.`id_product_attribute` AND ps.`id_supplier` = p.`id_supplier` LEFT JOIN `prsp_manufacturer` `m` ON m.`id_manufacturer` = p.`id_manufacturer` LEFT JOIN prsp_stock_available stock ON (stock.id_product = `cp`.id_product AND stock.id_product_attribute = IFNULL(`cp`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) LEFT JOIN `prsp_customization` `cu` ON p.`id_product` = cu.`id_product` AND cp.`id_product_attribute` = cu.`id_product_attribute` AND cp.`id_customization` = cu.`id_customization` AND cu.`id_cart` = 4184 LEFT JOIN `prsp_product_attribute` `pa` ON pa.`id_product_attribute` = cp.`id_product_attribute` LEFT JOIN `prsp_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.`id_shop` = cp.`id_shop` AND product_attribute_shop.`id_product_attribute` = pa.`id_product_attribute`) LEFT JOIN `prsp_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 `prsp_image_lang` `il` ON il.`id_image` = image_shop.`id_image` AND il.`id_lang` = 1 WHERE (cp.`id_cart` = 4184) AND (p.`id_product` IS NOT NULL) GROUP BY cp.`id_product_attribute`, cp.`id_product`, cp.`id_shop`, cp.`id_customization` ORDER BY cp.`date_add`, cp.`id_product`, cp.`id_product_attribute` ASC	2.369 ms	1	Yes	Yes	/classes/Cart.php:742 /classes/Cart.php:2140 (getProducts) /src/Adapter/Presenter/Cart/CartPresenter.php:337 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
180	SELECT SQL_NO_CACHE pa.`id_product`, a.`color`, pac.`id_product_attribute`, SUM(IF(stock.`quantity` > 0, 1, 0)) qty, a.`id_attribute`, al.`name`, IF(color = "", a.id_attribute, color) group_by FROM `prsp_product_attribute` pa INNER JOIN prsp_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = 1) LEFT JOIN prsp_stock_available stock ON (stock.id_product = `pa`.id_product AND stock.id_product_attribute = IFNULL(`pa`.id_product_attribute, 0) AND stock.id_shop = 1 AND stock.id_shop_group = 0 ) JOIN `prsp_product_attribute_combination` pac ON (pac.`id_product_attribute` = product_attribute_shop.`id_product_attribute`) JOIN `prsp_attribute` a ON (a.`id_attribute` = pac.`id_attribute`) JOIN `prsp_attribute_lang` al ON (a.`id_attribute` = al.`id_attribute` AND al.`id_lang` = 1) JOIN `prsp_attribute_group` ag ON (a.id_attribute_group = ag.`id_attribute_group`) WHERE pa.`id_product` IN (509) AND ag.`is_color_group` = 1 GROUP BY pa.`id_product`, a.`id_attribute`, `group_by` HAVING qty > 0 ORDER BY a.`position` ASC;	2.323 ms	1	Yes		/classes/Product.php:4509 /src/Adapter/Product/ProductColorsRetriever.php:43 (getAttributesColorList) /src/Adapter/Presenter/Product/ProductLazyArray.php:528 (getColoredVariants) /src/Adapter/Presenter/AbstractLazyArray.php:261 (getMainVariants) /src/Adapter/Presenter/AbstractLazyArray.php:121 (offsetGet) :undefined (jsonSerialize) /classes/Smarty/SmartyLazyRegister.php:81 (json_encode) /var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/42/14/6f/42146fff3d78876ab3076460517b8c3f7323ea77_2.file.javascript.tpl.php:65 (__call) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e966dd04_99672812) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/cd/02/c7/cd02c7b3fd84824cc586324f31e5c878894715d9_2.file.head.tpl.php:298 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/cd/02/c7/cd02c7b3fd84824cc586324f31e5c878894715d9_2.file.head.tpl.php:57 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e962f2f0_24079438) /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 (getRenderedTemplateCode) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 (render) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 (render) /var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:270 (_subTemplateRender) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:248 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:184 (callBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_internal_runtime_inheritance.php:156 (process) /var/cache/dev/smarty/compile/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:42 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e960d570_40691101) /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/AngarThemelayouts_layout_full_width_tpl/1a/b9/96/1ab996b55620b6e8da8e03aacb4a1c3c1339e4d2_2.file.layout-full-width.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e95a0ef2_05670181) /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/AngarThemelayouts_layout_full_width_tpl/5e/1d/88/5e1d888da7928796a8e000f96ca45695227d3b42_2.file.cart.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e9578156_29780049) /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:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
117	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	2.185 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /controllers/front/CartController.php:545 (autoAddToCart) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
12	SELECT SQL_NO_CACHE lower(name) as name FROM `prsp_hook` h WHERE (h.active = 1)	2.160 ms	1093			/classes/Hook.php:1332 /classes/Hook.php:811 (getHookStatusByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
27	SELECT SQL_NO_CACHE m.`id_module`, m.`name`, ms.`id_module`as `mshop` FROM `prsp_module` m LEFT JOIN `prsp_module_shop` ms ON m.`id_module` = ms.`id_module` AND ms.`id_shop` = 1	2.120 ms	139			/classes/module/Module.php:340 /modules/psxdesign/psxdesign.php:68 (__construct) :undefined (__construct) /src/Core/Foundation/IoC/Container.php:123 (newInstance) /src/Core/Foundation/IoC/Container.php:153 (makeInstanceFromClassName) /src/Core/Foundation/IoC/Container.php:166 (doMake) /src/Adapter/ServiceLocator.php:70 (make) /classes/module/Module.php:1235 (get) /tools/profiling/Module.php:35 (coreLoadModule) /classes/module/Module.php:1214 (coreLoadModule) /classes/Hook.php:966 (getInstanceByName) /classes/Dispatcher.php:351 (exec) /index.php:28 (dispatch)
115	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	2.090 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:1661 (autoAddToCart) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
204	INSERT INTO `prsp_guest` (`id_operating_system`, `id_web_browser`, `id_customer`, `javascript`, `screen_resolution_x`, `screen_resolution_y`, `screen_color`, `sun_java`, `adobe_flash`, `adobe_director`, `apple_quicktime`, `real_player`, `windows_media`, `accept_language`, `mobile_theme`) VALUES ('0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '0', '', '0')	2.052 ms	1			/classes/ObjectModel.php:622 /classes/ObjectModel.php:576 (add) /classes/Guest.php:251 (save) /modules/statsdata/statsdata.php:82 (setNewGuest) /modules/statsdata/statsdata.php:73 (getScriptPlugins) /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/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:505 (__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/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:251 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e960d570_40691101) /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/AngarThemelayouts_layout_full_width_tpl/1a/b9/96/1ab996b55620b6e8da8e03aacb4a1c3c1339e4d2_2.file.layout-full-width.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e95a0ef2_05670181) /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/AngarThemelayouts_layout_full_width_tpl/5e/1d/88/5e1d888da7928796a8e000f96ca45695227d3b42_2.file.cart.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e9578156_29780049) /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:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
116	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	2.035 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:467 (autoAddToCart) /classes/CartRule.php:1766 (getCartRules) /controllers/front/CartController.php:544 (autoRemoveFromCart) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
110	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	1.982 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:467 (autoAddToCart) /classes/CartRule.php:1766 (getCartRules) /classes/Cart.php:1659 (autoRemoveFromCart) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
163	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	1.884 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:467 (autoAddToCart) /src/Adapter/Presenter/Cart/CartPresenter.php:512 (getCartRules) /src/Adapter/Presenter/Cart/CartPresenter.php:381 (getShippingDisplayValue) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
111	SELECT SQL_NO_CACHE cr.*, crl.`id_lang`, crl.`name`, cd.`id_cart` FROM `prsp_cart_cart_rule` cd LEFT JOIN `prsp_cart_rule` cr ON cd.`id_cart_rule` = cr.`id_cart_rule` LEFT JOIN `prsp_cart_rule_lang` crl ON ( cd.`id_cart_rule` = crl.`id_cart_rule` AND crl.id_lang = 1 ) WHERE `id_cart` = 4184 ORDER by cr.priority ASC, cr.gift_product DESC	1.841 ms	1	Yes		/classes/Cart.php:472 /classes/CartRule.php:1766 (getCartRules) /classes/Cart.php:1659 (autoRemoveFromCart) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
121	SELECT SQL_NO_CACHE image_shop.`cover`, i.`id_image`, il.`legend`, i.`position` FROM `prsp_image` i INNER JOIN prsp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) LEFT JOIN `prsp_image_lang` il ON (i.`id_image` = il.`id_image` AND il.`id_lang` = 1) WHERE i.`id_product` = 509 ORDER BY `position`	1.756 ms	1	Yes		/classes/Product.php:3539 /src/Adapter/Image/ImageRetriever.php:84 (getImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /src/Adapter/Presenter/Cart/CartPresenter.php:181 (present) :undefined (presentProduct) /src/Adapter/Presenter/Cart/CartPresenter.php:329 (array_map) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
126	SELECT SQL_NO_CACHE `id_module` FROM `prsp_module` WHERE `name` = "coreimage" LIMIT 1	1.738 ms	1			/classes/module/Module.php:2636 /classes/module/Module.php:2084 (getModuleIdByName) /override/classes/Link.php:33 (isInstalled) /src/Adapter/Image/ImageRetriever.php:251 (getImageLink) /src/Adapter/Image/ImageRetriever.php:111 (getImage) :undefined (PrestaShop\PrestaShop\Adapter\Image\{closure}) /src/Adapter/Image/ImageRetriever.php:104 (array_map) /src/Adapter/Presenter/Product/ProductLazyArray.php:687 (getAllProductImages) /src/Adapter/Presenter/Product/ProductLazyArray.php:126 (fillImages) /src/Adapter/Presenter/Product/ProductListingPresenter.php:49 (__construct) /src/Adapter/Presenter/Cart/CartPresenter.php:181 (present) :undefined (presentProduct) /src/Adapter/Presenter/Cart/CartPresenter.php:329 (array_map) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
130	SELECT SQL_NO_CACHE * FROM `prsp_product` a LEFT JOIN `prsp_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 1 WHERE (a.`id_product` = 509) LIMIT 1	1.713 ms	1			/src/Adapter/EntityMapper.php:71 /classes/ObjectModel.php:283 (load) /tools/profiling/ObjectModel.php:32 (__construct) /classes/Product.php:725 (__construct) /classes/Cart.php:2634 (__construct) /classes/Cart.php:2853 (getPackageList) /classes/Cart.php:3418 (getDeliveryOptionList) /classes/Cart.php:3491 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2186 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
87	INSERT INTO `prsp_eventbus_incremental_sync` (`id_shop`, `id_object`, `type`, `created_at`, `lang_iso`) VALUES ('1', '4184', 'carts', '2024-04-19T21:45:12+00:00', 'fr') ON DUPLICATE KEY UPDATE `id_shop` = '1',`id_object` = '4184',`type` = 'carts',`created_at` = '2024-04-19T21:45:12+00:00',`lang_iso` = 'fr'	1.664 ms	1			/modules/ps_eventbus/src/Repository/IncrementalSyncRepository.php:54 /modules/ps_eventbus/ps_eventbus.php:1549 (insertIncrementalObject) /modules/ps_eventbus/ps_eventbus.php:958 (insertIncrementalSyncObject) /classes/Hook.php:1043 (hookActionObjectCartAddAfter) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/ObjectModel.php:674 (exec) /classes/Cart.php:275 (add) /controllers/front/CartController.php:483 (add) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
118	SELECT SQL_NO_CACHE 1 FROM prsp_cart_product cp INNER JOIN prsp_product p ON (p.id_product = cp.id_product) INNER JOIN prsp_product_shop ps ON (ps.id_shop = cp.id_shop AND ps.id_product = p.id_product) WHERE cp.id_cart=4184 LIMIT 1	1.664 ms	1			/classes/Cart.php:4204 /controllers/front/CartController.php:111 (hasProducts) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
82	INSERT INTO `prsp_cart` (`id_shop_group`, `id_shop`, `id_address_delivery`, `id_address_invoice`, `id_carrier`, `id_currency`, `id_customer`, `id_guest`, `id_lang`, `recyclable`, `gift`, `gift_message`, `mobile_theme`, `delivery_option`, `secure_key`, `allow_seperated_package`, `date_add`, `date_upd`) VALUES ('1', '1', '0', '0', '0', '4', '0', '0', '1', '0', '0', '', '0', '', '', '0', '2024-04-19 21:45:12', '2024-04-19 21:45:12')	1.636 ms	1			/classes/ObjectModel.php:622 /classes/Cart.php:275 (add) /controllers/front/CartController.php:483 (add) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
208	INSERT INTO `prsp_connections` (`id_guest`, `id_page`, `ip_address`, `http_referer`, `id_shop`, `id_shop_group`, `date_add`) VALUES ('8423073', '403', '59797957', '', '1', '1', '2024-04-19 21:45:13')	1.621 ms	1			/classes/ObjectModel.php:622 /classes/Connection.php:188 (add) /classes/Connection.php:97 (setNewConnection) /modules/statsdata/statsdata.php:118 (setPageConnection) /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/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:505 (__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/AngarThemelayouts_layout_full_width_tpl/cf/f0/a9/cff0a9ce5fe527ecd9f23dbbff2cab90d107af0a_2.file.layout-both-columns.tpl.php:251 (instanceBlock) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e960d570_40691101) /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/AngarThemelayouts_layout_full_width_tpl/1a/b9/96/1ab996b55620b6e8da8e03aacb4a1c3c1339e4d2_2.file.layout-full-width.tpl.php:43 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e95a0ef2_05670181) /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/AngarThemelayouts_layout_full_width_tpl/5e/1d/88/5e1d888da7928796a8e000f96ca45695227d3b42_2.file.cart.tpl.php:36 (endChild) /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 (content_6622e5e9578156_29780049) /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:760 (fetch) /classes/controller/FrontController.php:742 (smartyOutputContent) /tools/profiling/Controller.php:106 (display) /tools/profiling/Controller.php:83 (displayProfiling) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
93	SELECT SQL_NO_CACHE image_shop.`id_image` FROM `prsp_image` i INNER JOIN prsp_image_shop image_shop ON (image_shop.id_image = i.id_image AND image_shop.id_shop = 1) WHERE i.`id_product` = 509 AND image_shop.`cover` = 1 LIMIT 1	1.548 ms	1			/classes/Product.php:3570 /classes/Product.php:5639 (getCover) /modules/ps_googleanalytics/classes/Hook/HookActionCartUpdateQuantityBefore.php:75 (getProductProperties) /modules/ps_googleanalytics/ps_googleanalytics.php:188 (run) /classes/Hook.php:1043 (hookActionCartUpdateQuantityBefore) /tools/profiling/Hook.php:35 (coreCallHook) /classes/Hook.php:418 (coreCallHook) /classes/Hook.php:981 (callHookOn) /classes/Cart.php:1550 (exec) /controllers/front/CartController.php:498 (updateQty) /controllers/front/CartController.php:242 (processChangeProductInCart) /controllers/front/CartController.php:231 (updateCart) /tools/profiling/Controller.php:52 (postProcess) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
138	SELECT SQL_NO_CACHE c.*, cl.delay FROM `prsp_carrier` c LEFT JOIN `prsp_carrier_lang` cl ON (c.`id_carrier` = cl.`id_carrier` AND cl.`id_lang` = 1 AND cl.id_shop = 1 ) LEFT JOIN `prsp_carrier_zone` cz ON (cz.`id_carrier` = c.`id_carrier`) LEFT JOIN `prsp_zone` z ON (z.`id_zone` = 4) INNER JOIN prsp_carrier_shop carrier_shop ON (carrier_shop.id_carrier = c.id_carrier AND carrier_shop.id_shop = 1) WHERE c.`deleted` = 0 AND c.`active` = 1 AND cz.`id_zone` = 4 AND z.`active` = 1 AND EXISTS (SELECT 1 FROM prsp_carrier_group WHERE prsp_carrier_group.id_carrier = c.id_carrier AND id_group IN (1)) AND (c.is_module = 0 OR c.need_range = 1) AND c.external_module_name <> "mbeshipping" AND c.external_module_name <> "mbeshipping" GROUP BY c.`id_carrier`	1.507 ms	3		Yes	/override/classes/Carrier.php:155 /classes/Carrier.php:707 (getCarriers) /classes/Carrier.php:1555 (getCarriersForOrder) /classes/Cart.php:2633 (getAvailableCarrierList) /classes/Cart.php:2853 (getPackageList) /classes/Cart.php:3418 (getDeliveryOptionList) /classes/Cart.php:3491 (getDeliveryOption) /src/Core/Cart/Fees.php:96 (getTotalShippingCost) /src/Core/Cart/Calculator.php:354 (processCalculation) /src/Core/Cart/Calculator.php:155 (calculateFees) /classes/Cart.php:2186 (processCalculation) /src/Adapter/Presenter/Cart/CartPresenter.php:334 (getOrderTotal) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
15	SELECT SQL_NO_CACHE `id_hook`, `name` FROM `prsp_hook`	1.505 ms	1093			/classes/Hook.php:1292 /classes/Hook.php:225 (getAllHookIds) /classes/Hook.php:851 (getIdByName) /classes/Dispatcher.php:606 (exec) /classes/Dispatcher.php:243 (loadRoutes) /classes/Dispatcher.php:201 (__construct) /index.php:28 (getInstance)
149	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	1.497 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:467 (autoAddToCart) /src/Adapter/Presenter/Cart/CartPresenter.php:512 (getCartRules) /src/Adapter/Presenter/Cart/CartPresenter.php:381 (getShippingDisplayValue) /classes/controller/FrontController.php:545 (present) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)
164	SELECT SQL_NO_CACHE cr.* FROM prsp_cart_rule cr LEFT JOIN prsp_cart_rule_shop crs ON cr.id_cart_rule = crs.id_cart_rule LEFT JOIN prsp_cart_rule_group crg ON cr.id_cart_rule = crg.id_cart_rule LEFT JOIN prsp_cart_rule_carrier crca ON cr.id_cart_rule = crca.id_cart_rule LEFT JOIN prsp_cart_rule_country crco ON cr.id_cart_rule = crco.id_cart_rule WHERE cr.active = 1 AND cr.code = "" AND cr.quantity > 0 AND NOW() BETWEEN cr.date_from AND cr.date_to AND ( cr.id_customer = 0 ) AND ( cr.`carrier_restriction` = 0 ) AND ( cr.`shop_restriction` = 0 ) AND ( cr.`group_restriction` = 0 OR crg.`id_group` = 1 ) AND ( cr.`reduction_product` <= 0 OR EXISTS ( SELECT 1 FROM `prsp_cart_product` WHERE `prsp_cart_product`.`id_product` = cr.`reduction_product` AND `id_cart` = 4184 ) ) AND NOT EXISTS (SELECT 1 FROM prsp_cart_cart_rule WHERE cr.id_cart_rule = prsp_cart_cart_rule.id_cart_rule AND id_cart = 4184) ORDER BY priority	1.458 ms	1	Yes		/classes/CartRule.php:1734 /override/classes/CartRule.php:20 (autoAddToCart) /classes/Cart.php:467 (autoAddToCart) /src/Adapter/Presenter/Cart/CartPresenter.php:546 (getCartRules) /src/Adapter/Presenter/Cart/CartPresenter.php:445 (getTemplateVarVouchers) /controllers/front/CartController.php:575 (present) /classes/controller/FrontController.php:550 (getTemplateVarPage) /classes/controller/FrontController.php:614 (assignGeneralPurposeVariables) /controllers/front/CartController.php:121 (initContent) /tools/profiling/Controller.php:60 (initContent) /classes/Dispatcher.php:510 (run) /index.php:28 (dispatch)

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