Fundus

Nein, wir kaufen keine Produkte wie TCG-Karten, Schachsets oder Gesellschaftsspiele von Privatpersonen an. Aufwand und Ertrag klaffen für einzelne Produkte schlicht zu weit auseinander. Wir empfehlen dir, es auf Plattformen wie Tutti, Ricardo oder in Facebook-Gruppen zu versuchen.

Falls du Ladenbesitzer oder Shopbetreiber bist und dein Geschäft auflöst, kannst du uns gerne per E-Mail kontaktieren.

Load time	212 ms - Unicorn powered webserver!
Querying time	80 ms
Queries	529
Memory peak usage	9.2 Mb
Included files	508 files - 7.03 Mb
thirty bees cache	1.34 Mb
Global vars	1.94 Mb
- global $_MODULES	717k
- global $context	570k
- global $smarty	549k
- global $_LANG	123k
- global $_SERVER	7k
- global $customer	4k
- global $_MODULE	3k
- global $default_country	2k
- global $cart	2k
- global $defaultCountry	2k
- global $currency	2k
- global $language	1k
- global $__composer_autoload_files	1k

thirty bees version	1.5.0
PrestaShop (emulated) version	1.6.1.999
PHP version	8.1.31 (OK)
MySQL version	10.11.6-MariaDB-0+deb12u1-log (OK)
Memory limit	512M
Max execution time	600s
Smarty cache	disabled
Smarty Compilation	auto

	Time	Cumulated Time	Memory Usage	Memory Peak Usage
config	48 ms	48 ms	2.56 Mb	2.59 Mb
__construct	0 ms	48 ms	- Mb	2.59 Mb
init	3 ms	50 ms	0.25 Mb	2.82 Mb
checkAccess	0 ms	50 ms	- Mb	2.82 Mb
setMedia	5 ms	55 ms	0.14 Mb	3.00 Mb
postProcess	- ms	55 ms	- Mb	3.00 Mb
initHeader	0 ms	55 ms	- Mb	3.00 Mb
initContent	106 ms	161 ms	4.26 Mb	7.22 Mb
initFooter	3 ms	165 ms	0.02 Mb	7.31 Mb
display	47 ms	212 ms	1.63 Mb	9.23 Mb

Hook	Time	Memory Usage
hookactionProductListOverride	71 ms	2.00 Mb
=> genzo_filter	71 ms	2.00 Mb
hookdisplayHeader	26 ms	- Mb
=> revws	- ms	- Mb
=> genzo_shortcodes	0 ms	- Mb
=> tb_framework	24 ms	- Mb
=> genzo_affiliate	- ms	- Mb
=> genzo_filter	0 ms	- Mb
=> genzo_questions	0 ms	- Mb
=> genzo_category	0 ms	- Mb
=> genzo_tags	0 ms	- Mb
=> genzo_theme_configurator	0 ms	- Mb
=> genzo_krona	0 ms	- Mb
=> genzo_quiz	- ms	- Mb
=> genzo_revws	0 ms	- Mb
=> ph_simpleblog	- ms	- Mb
=> genzo_erp	- ms	- Mb
=> genzo_accounting	- ms	- Mb
__construct	21 ms	4.00 Mb
=> collectlogs	1 ms	- Mb
=> ph_simpleblog	1 ms	- Mb
=> genzo_krona	1 ms	- Mb
=> revws	1 ms	- Mb
=> genzo_affiliate	1 ms	2.00 Mb
=> genzo_tags	1 ms	- Mb
=> genzo_filter	4 ms	- Mb
=> genzo_zar	1 ms	- Mb
=> genzo_events	0 ms	- Mb
=> genzo_faq	0 ms	- Mb
=> genzo_portal	0 ms	- Mb
=> genzo_questions	0 ms	- Mb
=> genzo_quiz	0 ms	- Mb
=> genzo_revws	0 ms	- Mb
=> genzo_search	0 ms	- Mb
=> tb_framework	0 ms	- Mb
=> genzo_theme_configurator	0 ms	- Mb
=> genzo_erp	0 ms	- Mb
=> genzo_crm	0 ms	- Mb
=> genzo_turnstile	0 ms	- Mb
=> genzo_shortcodes	0 ms	- Mb
=> genzo_category	0 ms	- Mb
=> genzo_accounting	1 ms	- Mb
=> statsmodule	0 ms	2.00 Mb
hookdisplayRevwsAverageRating	4 ms	2.00 Mb
=> genzo_revws	0 ms	- Mb
hookdisplayFooter	3 ms	- Mb
=> genzo_search	2 ms	- Mb
=> genzo_crm	1 ms	- Mb
hookdisplayTabContent	2 ms	- Mb
=> genzo_category	1 ms	- Mb
=> genzo_filter	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
=> genzo_revws	- ms	- Mb
=> genzo_questions	- ms	- Mb
=> genzo_tags	- ms	- Mb
=> genzo_faq	1 ms	- Mb
hookmoduleRoutes	1 ms	- Mb
=> ph_simpleblog	- ms	- Mb
=> genzo_krona	- ms	- Mb
=> revws	1 ms	- Mb
=> genzo_affiliate	- ms	- Mb
=> genzo_tags	- ms	- Mb
=> genzo_filter	0 ms	- Mb
=> genzo_zar	- ms	- Mb
=> genzo_events	- ms	- Mb
=> genzo_faq	- ms	- Mb
=> genzo_portal	- ms	- Mb
=> genzo_questions	0 ms	- Mb
=> genzo_quiz	- ms	- Mb
=> genzo_revws	- ms	- Mb
=> genzo_search	- ms	- Mb
=> tb_framework	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
=> genzo_erp	- ms	- Mb
=> genzo_crm	- ms	- Mb
hookdisplayLeftColumn	1 ms	- Mb
=> genzo_affiliate	- ms	- Mb
=> genzo_tags	0 ms	- Mb
=> genzo_theme_configurator	0 ms	- Mb
=> genzo_search	- ms	- Mb
=> genzo_erp	- ms	- Mb
hookdisplayBottomColumn	0 ms	- Mb
=> tb_framework	0 ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
=> genzo_erp	- ms	- Mb
hookactionFrontControllerSetMedia	0 ms	- Mb
=> genzo_turnstile	0 ms	- Mb
hookactionRegisterErrorHandlers	0 ms	- Mb
=> collectlogs	0 ms	- Mb
hookdisplayCenterColumnTop	0 ms	- Mb
=> genzo_filter	0 ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
hooktop	- ms	- Mb
=> statsmodule	- ms	- Mb
hookdisplayTop	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
hookdisplayTopColumn	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
hookdisplayCenterColumnBottom	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
16 hooks	130 ms	8.00 Mb

Module	Time	Memory Usage
genzo_filter	81 ms	2.00 Mb
=> __construct	4 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookactionProductListOverride	71 ms	2.00 Mb
=> hookdisplayCenterColumnTop	0 ms	- Mb
tb_framework	24 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	24 ms	- Mb
=> hookdisplayBottomColumn	0 ms	- Mb
genzo_revws	5 ms	2.00 Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayRevwsAverageRating	0 ms	- Mb
genzo_search	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
=> hookdisplayFooter	2 ms	- Mb
genzo_category	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayTabContent	1 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_crm	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayFooter	1 ms	- Mb
revws	2 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_tags	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayLeftColumn	0 ms	- Mb
genzo_faq	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	1 ms	- Mb
genzo_questions	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
ph_simpleblog	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_theme_configurator	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayTop	- ms	- Mb
=> hookdisplayLeftColumn	0 ms	- Mb
=> hookdisplayTopColumn	- ms	- Mb
=> hookdisplayCenterColumnTop	- ms	- Mb
=> hookdisplayCenterColumnBottom	- ms	- Mb
=> hookdisplayBottomColumn	- ms	- Mb
genzo_krona	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
collectlogs	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookactionRegisterErrorHandlers	0 ms	- Mb
genzo_accounting	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_affiliate	1 ms	2.00 Mb
=> __construct	1 ms	2.00 Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
genzo_turnstile	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookactionFrontControllerSetMedia	0 ms	- Mb
genzo_zar	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
genzo_quiz	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
statsmodule	0 ms	2.00 Mb
=> __construct	0 ms	2.00 Mb
=> hooktop	- ms	- Mb
genzo_events	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
genzo_portal	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
genzo_erp	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
=> hookdisplayBottomColumn	- ms	- Mb
genzo_shortcodes	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
24 modules	130 ms	8.00 Mb

Warenkorb

Destinies (Defekte Verpackung)

Spirit Island Erweiterung - Zerklüftete Erde (Defekte Verpackung)

Resident Evil 2 - The Board Game - EN (Defekte Verpackung)

Allianz Arena bei Nacht (Defekte Verpackung)

Das verflixte Schildkröten-Spiel (Defekte Verpackung)

Star Wars: The Clone Wars - DE (Defekte Verpackung)

Japanische Collage (Defekte Verpackung)

Mistwind - EN (Defekte Verpackung)

Eternitium - DE (Leicht defekte Verpackung)

Grosses Reise-Schachset blau

Gartenschachmatte CN gross

Royales Schachspiel 50x50cm (Einzelstück)

Hexenhammer (Defekte Verpackung)

Woodcraft (Defekte Verpackung)

Paartie - Plauderspiel für Partnerinnen (Defekte Verpackung)

Zombicide 2. Edition Erweiterung – Washington Z.C. (Defekte Verpackung)

Mythos Tales (Defekte Verpackung)

Chatuchak (Defekte Verpackung)

Blood Rage (Defekte Verpackung)

Die Riff Retter - DE (Defekte Verpackung)

Not Enough Mana - EN (Defekte Verpackung)

Star Wars: The Deckbuilding Game – Clone Wars Edition (Defekte Verpackung)

Heroquest - Avalon Hill HeroQuest Jungles of Delthrak Quest Pack - EN (Defekte Verpackung)

Dekoratives Schachspiel (Samurai) 50x50cm mit kleinem Schaden

Zug um Zug Europa - 15 Jahre Jubiläumsedition (Defekte Verpackung)

Shikoku 1889 - EN (Defekte Verpackung)

Puerto Rico 1897 (Defekte Verpackung)

Pampero - DE (Defekte Verpackung)

Auf den Wegen von Darwin (Leicht defekte Verpackung)

1941 - Race to Moscow (Defekete Verpackung)

Schnelle Lieferung

Sichere Bezahlung

Stopwatch SQL - 529 queries

Doubles

Tables stress

ObjectModel instances

Included Files

60	SELECT * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = XX AND cl.id_shop = XX WHERE (c.nleft <= XX AND c.nright >= XX) ORDER BY c.nleft
30	SELECT product_attribute_shop.id_product_attribute FROM ps_product_attribute pa INNER JOIN ps_product_attribute_shop product_attribute_shop ON (product_attribute_shop.id_product_attribute = pa.id_product_attribute AND product_attribute_shop.id_shop = XX) WHERE pa.id_product = XX LIMIT XX
30	SELECT * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = XX LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = XX WHERE (a.`id_product` = XX) AND (b.`id_shop` = XX) LIMIT XX
30	SELECT `priority`, `id_specific_price_priority` FROM `ps_specific_price_priority` WHERE (`id_product` = XX) ORDER BY `id_specific_price_priority` DESC LIMIT XX
30	SELECT *, ( IF (`id_group` = XX, XX, XX) + IF (`id_country` = XX, XX, XX) + IF (`id_currency` = XX, XX, XX) + IF (`id_shop` = XX, XX, XX)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (XX, XX)) AND (`id_currency` IN (XX, XX)) AND (`id_country` IN (XX, XX)) AND (`id_group` IN (XX, XX) AND `id_product` IN (XX, XX) AND `id_customer` = XX AND `id_product_attribute` = XX AND `id_cart` = XX AND (`from` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' >= `from`) AND (`to` = 'XX-XX-XX XX:XX:XX' OR 'XX-XX-XX XX:XX:XX' <= `to`)) AND (IF(`from_quantity` > XX, `from_quantity`, XX) <= XX) ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT XX
30	SELECT product_shop.`price`, product_shop.`ecotax`, IFNULL(product_attribute_shop.id_product_attribute,XX) AS id_product_attribute, product_attribute_shop.`price` AS attribute_price, product_attribute_shop.default_on, product_attribute_shop.`ecotax` AS attribute_ecotax FROM `ps_product` p INNER JOIN `ps_product_shop` product_shop ON (product_shop.id_product=p.id_product AND product_shop.id_shop = XX) LEFT JOIN `ps_product_attribute_shop` `product_attribute_shop` ON (product_attribute_shop.id_product = p.id_product AND product_attribute_shop.id_shop = XX) WHERE (p.`id_product` = XX)
30	SELECT `id_tax_rules_group` FROM `ps_product_shop` WHERE `id_product` = XX AND id_shop=XX LIMIT XX
30	SELECT `reduction` FROM `ps_product_group_reduction_cache` WHERE (`id_product` = XX) AND (`id_group` = XX) LIMIT XX
30	SELECT SUM(quantity) FROM `ps_stock_available` WHERE (id_product = XX) AND (id_product_attribute = XX) AND (id_shop = XX) AND (id_shop_group = XX) LIMIT XX
30	SELECT COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = XX AND pfl.id_product = XX) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = XX) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = XX) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = XX) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = XX) WHERE pf.id_product = XX ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC
30	SELECT * FROM ps_product_attachment pa LEFT JOIN ps_attachment a ON a.id_attachment = pa.id_attachment LEFT JOIN ps_attachment_lang al ON (a.id_attachment = al.id_attachment AND al.id_lang = XX) WHERE pa.id_product = XX
30	SELECT (SUM(ra.grade) / COUNT(XX)) AS grade, COUNT(distinct r.id_review) as cnt FROM ps_revws_review r LEFT JOIN ps_revws_review_grade ra ON (r.id_review = ra.id_review) WHERE r.entity_type = 'product' AND r.id_entity = XX AND r.deleted = XX AND r.id_lang = XX AND r.validated = XX LIMIT XX
20	SELECT m.`id_module`, m.`name`, ms.`id_module` AS `mshop` FROM `ps_module` m LEFT JOIN `ps_module_shop` `ms` ON ms.`id_module` = m.`id_module` AND ms.`id_shop` = XX
10	SELECT `id_category` FROM `ps_category` WHERE (`nleft` > XX AND `nright` < XX)
9	SELECT c., cl. FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.`id_category` = cl.`id_category` WHERE (`id_lang` = XX AND cl.id_shop = XX ) AND (c.`id_category` = XX) LIMIT XX
8	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_lang` `b` ON a.`id_category` = b.`id_category` AND b.`id_lang` = XX LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) AND (b.`id_shop` = XX) LIMIT XX
6	SELECT * FROM `ps_cms` a LEFT JOIN `ps_cms_lang` `b` ON a.`id_cms` = b.`id_cms` AND b.`id_lang` = XX LEFT JOIN `ps_cms_shop` `c` ON a.`id_cms` = c.`id_cms` AND c.`id_shop` = XX WHERE (a.`id_cms` = XX) AND (b.`id_shop` = XX) LIMIT XX
6	SELECT `id_cms_category` FROM `ps_cms` WHERE (`id_cms` = XX) LIMIT XX
5	SELECT * FROM `ps_category` a LEFT JOIN `ps_category_shop` `c` ON a.`id_category` = c.`id_category` AND c.`id_shop` = XX WHERE (a.`id_category` = XX) LIMIT XX
5	SELECT * FROM `ps_category_lang` WHERE (`id_category` = XX) AND (`id_shop` = XX)
2	SELECT `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = XX) LIMIT XX
2	SELECT tr.* FROM `ps_tax_rule` tr JOIN `ps_tax_rules_group` trg ON (tr.`id_tax_rules_group` = trg.`id_tax_rules_group`) WHERE trg.`active` = XX AND tr.`id_country` = XX AND tr.`id_tax_rules_group` = XX AND tr.`id_state` IN (XX, XX) AND ('XX' BETWEEN tr.`zipcode_from` AND tr.`zipcode_to` OR (tr.`zipcode_to` = XX AND tr.`zipcode_from` IN(XX, 'XX'))) ORDER BY tr.`zipcode_from` DESC, tr.`zipcode_to` DESC, tr.`id_state` DESC, tr.`id_country` DESC

Name	Instances	Source
Product	60	/override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22] /override/classes/Link.php [22]
Category	40	/override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [103] /controllers/front/CategoryController.php [124] /override/classes/Link.php [90] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /modules/genzo_erp/classes/ProductExtensionErp.php [1077] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [90] /override/classes/Link.php [90]
CMS	6	/classes/Link.php [712] /classes/Link.php [712] /classes/Link.php [712] /classes/Link.php [712] /classes/Link.php [712] /classes/Link.php [712]
Language	2	/config/config.inc.php [198] /classes/Tools.php [449]
Address	2	/classes/Product.php [1046] /classes/Product.php [1656]
Shop	1	/config/config.inc.php [122]
Theme	1	/config/config.inc.php [123]
Country	1	/config/config.inc.php [144]
ShopGroup	1	/classes/shop/Shop.php [542]
Customer	1	/config/config.inc.php [223]
Currency	1	/classes/Tools.php [695]
Cart	1	/classes/controller/FrontController.php [1487]
Group	1	/classes/Cart.php [284]
GenzoCategoryModule\GenzoCategory	1	/modules/genzo_category/genzo_category.php [193]
Tax	1	/classes/tax/TaxRulesTaxManager.php [137]

Query	Time (ms)	Rows	Filesort	Group By	Location
SELECT SQL_NO_CACHE 1 AS ajax, p.id_product, p.id_category_default, ps.price, ps.show_price, p.ean13, p.reference, lsa.out_of_stock, p.customizable, pl.link_rewrite, pl.name, pl.description_short, pl.available_now, pl.available_later, m.name AS manufacturer_name, i.id_image, IF(ps.`date_add`>'2024-11-04 00:00:00',1,0) AS new FROM ps_product AS p INNER JOIN ps_product_shop AS ps ON p.id_product=ps.id_product AND ps.id_shop=3 INNER JOIN ps_stock_available AS lsa ON lsa.id_product=p.id_product AND lsa.id_product_attribute=0 INNER JOIN ps_category_product AS cp ON p.id_product=cp.id_product INNER JOIN ps_product_lang AS pl ON p.id_product=pl.id_product AND pl.id_shop=3 AND pl.id_lang=1 LEFT JOIN ps_manufacturer AS m ON p.id_manufacturer=m.id_manufacturer LEFT JOIN ps_image AS i ON p.id_product=i.id_product AND cover=1 WHERE ps.active=1 AND cp.id_category=157 GROUP BY p.id_product ORDER BY cp.position asc LIMIT 30 OFFSET 90	4.4	751	Yes	Yes	/modules/genzo_filter/genzo_filter.php:1177 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COUNT(DISTINCT p.id_product) FROM ps_product AS p INNER JOIN ps_product_shop AS ps ON p.id_product=ps.id_product AND ps.id_shop=3 INNER JOIN ps_stock_available AS lsa ON lsa.id_product=p.id_product AND lsa.id_product_attribute=0 INNER JOIN ps_category_product AS cp ON p.id_product=cp.id_product WHERE ps.active=1 AND cp.id_category=157 LIMIT 1	2.4	751			/modules/genzo_filter/genzo_filter.php:1169 /modules/genzo_filter/genzo_filter.php:381 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1	1.3	2248			/classes/SpecificPrice.php:377 /classes/SpecificPrice.php:309 /classes/SpecificPrice.php:235 /classes/Product.php:1072 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE c.`name`, cl.`id_lang`, IFNULL(cl.`value`, c.`value`) AS `value`, c.`id_shop_group`, c.`id_shop` FROM `ps_configuration` c LEFT JOIN `ps_configuration_lang` `cl` ON c.`id_configuration` = cl.`id_configuration`	1.2	993			/classes/Configuration.php:529 /classes/db/Db.php:649 /classes/db/Db.php:604 /classes/shop/Shop.php:334 /config/config.inc.php:122 /index.php:32
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 39049) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 39049 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	1	11060	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 39054) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 39054 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.9	9954	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 39051) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 39051 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.9	8848	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE h.`name` as hook, m.`id_module`, h.`id_hook`, m.`name` as module, h.`live_edit` FROM `ps_module` m INNER JOIN ps_module_shop module_shop ON (module_shop.id_module = m.id_module AND module_shop.id_shop = 3 AND module_shop.enable_device & 1) INNER JOIN `ps_module_shop` ms ON ms.`id_module` = m.`id_module` INNER JOIN `ps_hook_module` hm ON hm.`id_module` = m.`id_module` INNER JOIN `ps_hook` h ON hm.`id_hook` = h.`id_hook` LEFT JOIN `ps_module_group` `mg` ON mg.`id_module` = m.`id_module` WHERE (h.`name` != "displayPayment" AND h.`name` != "displayPaymentEU") AND (hm.`id_shop` = 3) AND (mg.`id_shop` = 3 AND mg.`id_group` IN (3)) GROUP BY hm.id_hook, hm.id_module ORDER BY hm.`position`	0.8	96	Yes	Yes	/classes/Hook.php:666 /classes/Hook.php:449 /classes/Hook.php:263 /config/config.inc.php:327 /index.php:32
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 37526) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 37526 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.7	13272	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38910) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38910 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.6	13272	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38916) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38916 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.6	9954	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) + IF (`id_country` = 19, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 39051) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.6	2	Yes		/classes/SpecificPrice.php:253 /classes/Product.php:1072 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 37783) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 37783 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.5	16590	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) + IF (`id_country` = 19, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 39054) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.5	2	Yes		/classes/SpecificPrice.php:253 /classes/Product.php:1072 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 39055) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 39055 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.5	12166	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 27255) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 27255 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.5	15484	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE fv.id_feature, fv.id_feature_value, gfvl.link_rewrite AS link_rewrite_feature_value, gfl.link_rewrite AS link_rewrite_feature, gfvl.link_custom FROM `ps_feature_value` fv INNER JOIN `ps_genzo_tags_feature_value` gfv ON fv.id_feature_value=gfv.id_feature_value INNER JOIN `ps_genzo_tags_feature_value_lang` gfvl ON gfvl.id_feature_value_helper=gfv.id_feature_value_helper AND gfvl.id_lang = 1 INNER JOIN `ps_genzo_tags_feature` gf ON gf.id_feature = fv.id_feature INNER JOIN `ps_genzo_tags_feature_lang` gfl ON gf.id_feature_helper = gfl.id_feature_helper WHERE (gf.listing = 1 AND gfv.listing=1 AND gfl.link_rewrite!='' AND gfvl.link_rewrite!='') GROUP BY fv.id_feature_value	0.4	86	Yes	Yes	/override/classes/Product.php:350 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 33709) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 33709 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	15484	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 35426) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 35426 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	19908	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 28126) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 28126 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	15484	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE `id_hook`, `name` FROM `ps_hook` UNION SELECT `id_hook`, ha.`alias` AS name FROM `ps_hook_alias` ha INNER JOIN `ps_hook` h ON ha.name = h.name	0.4	0			/classes/Hook.php:799 /classes/Hook.php:454 /classes/Hook.php:263 /config/config.inc.php:328 /index.php:32
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 36383) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 36383 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	16590	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38026) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38026 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	8848	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 27380) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 27380 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	12166	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 37170) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 37170 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	13272	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 35001) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 35001 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	13272	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 35696) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 35696 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	9954	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 39048) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 39048 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	11060	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38912) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38912 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	11060	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 28135) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 28135 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	9954	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE h.id_hook, h.name AS h_name, h.title, h.description, h.position, h.live_edit, hm.position AS hm_position, m.id_module, m.name, m.active FROM `ps_hook_module` hm STRAIGHT_JOIN `ps_hook` h ON (h.id_hook = hm.id_hook AND hm.id_shop = 3) STRAIGHT_JOIN `ps_module` AS m ON (m.id_module = hm.id_module) ORDER BY hm.position	0.4	236			/classes/Hook.php:192 /classes/Hook.php:166 /classes/tax/TaxManagerFactory.php:82 /classes/tax/TaxManagerFactory.php:57 /classes/Product.php:1162 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 3 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 157 AND category_shop.`active` = 1 AND cg.`id_group` =3 GROUP BY c.`id_category` ORDER BY `level_depth` ASC, category_shop.`position` ASC	0.4	1	Yes	Yes	/classes/Category.php:1658 /controllers/front/CategoryController.php:231 /controllers/front/CategoryController.php:168 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 35000) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 35000 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	7742	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE *, ( IF (`id_group` = 3, 2, 0) + IF (`id_country` = 19, 4, 0) + IF (`id_currency` = 1, 8, 0) + IF (`id_shop` = 3, 16, 0)) AS `score` FROM `ps_specific_price` WHERE (`id_shop` IN (0, 3)) AND (`id_currency` IN (0, 1)) AND (`id_country` IN (0, 19)) AND (`id_group` IN (0, 3) AND `id_product` IN (0, 733) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-04 00:00:00' <= `to`)) AND (IF(`from_quantity` > 1, `from_quantity`, 0) <= 1) ORDER BY `id_cart` DESC, `id_product_attribute` DESC, `from_quantity` DESC, `id_specific_price_rule` ASC, `score` DESC, `to` DESC, `from` DESC LIMIT 1	0.4	2	Yes		/classes/SpecificPrice.php:253 /classes/Product.php:1072 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 WHERE (c.nleft <= 288 AND c.nright >= 289) ORDER BY c.nleft	0.4	187	Yes		/classes/Product.php:7840 /override/classes/Link.php:69 /classes/Product.php:1980 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 35136) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 35136 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	4424	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38373) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38373 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	3318	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3 WHERE (a.`id_product` = 39051) AND (b.`id_shop` = 3) LIMIT 1	0.4	1			/Adapter/Adapter_EntityMapper.php:74 /classes/ObjectModel.php:273 /tools/profiling/ObjectModel.php:51 /classes/Product.php:717 /override/classes/Link.php:22 /classes/Product.php:1980 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 733) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 733 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	1106	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE COALESCE(NULLIF(fl.public_name, ''), fl.name) AS name, fvl.value, IFNULL(pfl.displayable, fvl.displayable) AS displayable, fl.multiple_schema, fl.multiple_separator, pf.id_feature, pf.id_feature_value, f.allows_multiple_values FROM ps_feature_product pf LEFT JOIN ps_feature_product_lang pfl ON (pfl.id_feature_value = pf.id_feature_value AND pfl.id_lang = 1 AND pfl.id_product = 38487) LEFT JOIN ps_feature_lang fl ON (fl.id_feature = pf.id_feature AND fl.id_lang = 1) LEFT JOIN ps_feature_value fv ON (fv.id_feature_value = pf.id_feature_value) LEFT JOIN ps_feature_value_lang fvl ON (fvl.id_feature_value = pf.id_feature_value AND fvl.id_lang = 1) LEFT JOIN ps_feature f ON (f.id_feature = pf.id_feature AND fl.id_lang = 1) INNER JOIN ps_feature_shop feature_shop ON (feature_shop.id_feature = f.id_feature AND feature_shop.id_shop = 3) WHERE pf.id_product = 38487 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	1106	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33

#	Filename
1	/index.php
2	/config/config.inc.php
3	/config/defines_custom.inc.php
4	/config/defines.inc.php
5	/config/settings.inc.php
6	/config/autoload.php
7	/config/alias.php
8	/classes/PrestaShopAutoload.php
9	/vendor/autoload.php
10	/vendor/composer/autoload_real.php
11	/vendor/composer/platform_check.php
12	/vendor/composer/ClassLoader.php
13	/vendor/composer/include_paths.php
14	/vendor/composer/autoload_static.php
15	/vendor/ralouphie/getallheaders/src/getallheaders.php
16	/vendor/symfony/deprecation-contracts/function.php
17	/vendor/ezyang/htmlpurifier/library/HTMLPurifier.composer.php
18	/vendor/guzzlehttp/guzzle/src/functions_include.php
19	/vendor/guzzlehttp/guzzle/src/functions.php
20	/vendor/jakeasmith/http_build_url/src/http_build_url.php
21	/vendor/symfony/polyfill-mbstring/bootstrap.php
22	/vendor/symfony/polyfill-mbstring/bootstrap80.php
23	/cache/class_index.php
24	/config/bootstrap.php
25	/classes/core/ServiceLocator.php
26	/Core/Foundation/IoC/Core_Foundation_IoC_Container.php
27	/classes/error/response/DebugErrorPage.php
28	/classes/error/response/AbstractErrorPage.php
29	/classes/error/response/ErrorResponseInterface.php
30	/classes/error/ErrorHandler.php
31	/classes/controller/Controller.php
32	/classes/ObjectModel.php
33	/Core/Foundation/Database/Core_Foundation_Database_EntityInterface.php
34	/classes/db/Db.php
35	/classes/db/ReadOnlyConnection.php
36	/classes/Tools.php
37	/classes/Context.php
38	/classes/shop/Shop.php
39	/classes/Configuration.php
40	/classes/db/DbQuery.php