TCG & Sammelkarten online kaufen

Mit Expertentipps TCG kaufen

Sammelkarten haben sich zu einem wahren Massenphänomen entwickelt. [link category="464" title="Magic the Gathering"], [link category="454" title="Pokemon"], [link category="465" title="Yu-Gi-Oh"] und [link category="478" title="Dragonball"] sind nur einige der bekanntesten Sammelkartenspiele, die es auf dem Markt gibt. Jedes Spiel bietet eigene Mechaniken, Charaktere und Welten und lassen dich in eine Fantasiewelt eintauchen.

Magic the Gathering ist das älteste und erfolgreichste Sammelkartenspiel aller Zeiten. Seit 1993 werden Karten produziert und mittlerweile gibt es über 20.000 verschiedene Karten. Pokemon feiert ebenfalls seit den 90ern grosse Erfolge. In Japan wurden in den ersten zwei Wochen nach dem Release über eine Million Karten verkauft. Verrückt, oder?

TCG Shop für Neuware

Als grösster Onlineshop für analoge Spiele dürfen bei uns natürlich Sammelkarten nicht fehlen. Mit Einzelkarten handeln wir allerdings nicht und Sammlungen kaufen wir auch nicht auf. Wieso? Unsere Stärke liegt im Aufbau der Webseite mit effizienten Prozessen und viel Automatisierung. Daher können wir dir auch faire Preise mit blitzschneller Lieferung anbieten. Mit Einzelkarten wäre dies undenkbar.

Habt ihr Zubehör?

Ja, das haben mir. Ehrlichgesagt mehr als uns lieb ist. Soviele unterschiedliche [link category="431" title="Sleeves"], [link category="429" title="Ordner"] & [link category="430" title="Deckboxen"] kannst du in keinem anderem Schweizer Onlineshop kaufen. Sollten wir etwas noch nicht im Sortiment haben, wünscht du per Kontakformular bequem ein neues Produkt! Also worauf wartest du noch? Lass uns gemeinsam die Welt der Sammelkarten rocken!

TCG als Investment

Das Thema TCG als Investment wird heiss und kontrovers diskutiert. Das gute vorneweg: wir verkaufen nur sealed (also orginalverpackte) Produkte. Wir beziehen TCG nur von seriösen Lieferanten, mit denen wir seit Jahren zusammenarbeiten.

Unsere Meinung zu Thema Investment ist klar: spekuliere nicht darauf, dass diese Waren immer an Wert gewinnen. Im Internet gibt es zwar viele Gurus, die dir genau das versprechen, aber sobald der Hype weg ist, sind auch die Gurus weg. Du kannst uns glauben, dass wir als Familienbetrieb unseren "Einsatz" auch genau kalkulieren müssen. Also betrachte es als Hobby oder begrenze zumindest dein Risiko.

Load time	190 ms - Unicorn powered webserver!
Querying time	77 ms
Queries	571
Memory peak usage	9.6 Mb
Included files	512 files - 7.04 Mb
thirty bees cache	1.42 Mb
Global vars	1.90 Mb
- global $_MODULES	717k
- global $context	548k
- global $smarty	527k
- 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	38 ms	38 ms	2.56 Mb	2.59 Mb
__construct	0 ms	38 ms	- Mb	2.59 Mb
init	2 ms	40 ms	0.25 Mb	2.82 Mb
checkAccess	0 ms	40 ms	- Mb	2.82 Mb
setMedia	3 ms	43 ms	0.14 Mb	2.98 Mb
postProcess	0 ms	43 ms	- Mb	2.98 Mb
initHeader	0 ms	43 ms	- Mb	2.98 Mb
initContent	109 ms	153 ms	4.62 Mb	7.58 Mb
initFooter	4 ms	156 ms	0.09 Mb	7.69 Mb
display	33 ms	190 ms	1.56 Mb	9.60 Mb

Hook	Time	Memory Usage
hookactionProductListOverride	63 ms	- Mb
=> genzo_filter	63 ms	- 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	20 ms	- Mb
=> collectlogs	1 ms	- Mb
=> ph_simpleblog	1 ms	- Mb
=> genzo_krona	1 ms	- Mb
=> revws	1 ms	- Mb
=> genzo_affiliate	0 ms	- Mb
=> genzo_tags	1 ms	- Mb
=> genzo_filter	4 ms	- Mb
=> genzo_zar	0 ms	- Mb
=> genzo_events	0 ms	- Mb
=> genzo_faq	0 ms	- Mb
=> genzo_portal	0 ms	- Mb
=> genzo_questions	1 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	- Mb
hookdisplayLeftColumn	8 ms	- Mb
=> genzo_affiliate	- ms	- Mb
=> genzo_tags	0 ms	- Mb
=> genzo_theme_configurator	7 ms	- Mb
=> genzo_search	- ms	- Mb
=> genzo_erp	- ms	- Mb
hookdisplayRevwsAverageRating	4 ms	- Mb
=> genzo_revws	0 ms	- Mb
hookdisplayTop	4 ms	- Mb
=> genzo_theme_configurator	4 ms	- Mb
hookdisplayFooter	3 ms	- Mb
=> genzo_search	2 ms	- Mb
=> genzo_crm	1 ms	- Mb
hookdisplayTabContent	3 ms	- Mb
=> genzo_category	2 ms	- Mb
=> genzo_filter	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
=> genzo_revws	- ms	- Mb
=> genzo_questions	0 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	- 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
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
hookdisplayCenterColumnTop	0 ms	- Mb
=> genzo_filter	0 ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
hookactionRegisterErrorHandlers	- ms	- Mb
=> collectlogs	- ms	- Mb
hooktop	- ms	- Mb
=> statsmodule	- ms	- Mb
hookdisplayTopColumn	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
hookdisplayCenterColumnBottom	- ms	- Mb
=> genzo_theme_configurator	- ms	- Mb
16 hooks	132 ms	- Mb

Module	Time	Memory Usage
genzo_filter	72 ms	- Mb
=> __construct	4 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookactionProductListOverride	63 ms	- Mb
=> hookdisplayCenterColumnTop	0 ms	- Mb
tb_framework	25 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	24 ms	- Mb
=> hookdisplayBottomColumn	0 ms	- Mb
genzo_theme_configurator	12 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayTop	4 ms	- Mb
=> hookdisplayLeftColumn	7 ms	- Mb
=> hookdisplayTopColumn	- ms	- Mb
=> hookdisplayCenterColumnTop	- ms	- Mb
=> hookdisplayCenterColumnBottom	- ms	- Mb
=> hookdisplayBottomColumn	- ms	- Mb
genzo_revws	5 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayRevwsAverageRating	0 ms	- Mb
genzo_search	3 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	2 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_crm	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayFooter	1 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
revws	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_faq	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	1 ms	- Mb
genzo_questions	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_accounting	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
ph_simpleblog	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_krona	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_turnstile	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookactionFrontControllerSetMedia	0 ms	- Mb
collectlogs	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookactionRegisterErrorHandlers	- ms	- Mb
genzo_zar	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
genzo_quiz	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_affiliate	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayLeftColumn	- 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
statsmodule	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hooktop	- ms	- Mb
24 modules	132 ms	- Mb

62	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
24	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
22	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
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)
8	SELECT `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`id_category` = XX) LIMIT XX
6	SELECT cl.`link_rewrite` FROM `ps_category_lang` cl WHERE `id_lang` = XX AND cl.id_shop = XX AND cl.`id_category` = 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 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
Category	69	/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 [103] /override/classes/Link.php [103] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /modules/genzo_theme_configurator/genzo_theme_configurator.php [566] /override/classes/Link.php [103] /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 [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] /override/classes/Link.php [90] /override/classes/Link.php [103] /override/classes/Link.php [90]
Product	62	/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] /override/classes/Link.php [22] /override/classes/Link.php [22]
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=422 GROUP BY p.id_product ORDER BY cp.position asc LIMIT 30 OFFSET 90	5.9	647	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=422 LIMIT 1	2.6	647			/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 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.7	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 COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1	1.2	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 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.7	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 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` = 422 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.6	17	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 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.5	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 = 37788) 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 = 37788 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	6636	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.5	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 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 = 38028) 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 = 38028 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	5530	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 = 38031) 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 = 38031 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	5530	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 = 7280) 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 = 7280 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 = 37468) 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 = 37468 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 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 = 34716) 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 = 34716 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 = 37053) 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 = 37053 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	6636	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 = 31164) 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 = 31164 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	6636	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 = 32017) 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 = 32017 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	5530	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 = 31402) 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 = 31402 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	5530	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 = 32499) 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 = 32499 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	6636	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 = 33598) 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 = 33598 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	5530	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 = 7273) 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 = 7273 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	5530	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 = 31163) 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 = 31163 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	6636	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 = 37054) 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 = 37054 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	6636	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 = 32537) 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 = 32537 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	5530	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 = 32538) 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 = 32538 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	6636	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 = 14527) 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 = 14527 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 = 21141) 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 = 21141 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 = 34845) 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 = 34845 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 = 38172) 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 = 38172 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 = 36714) 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 = 36714 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 = 37534) 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 = 37534 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 m.`page`, ml.`url_rewrite`, ml.`id_lang` FROM `ps_meta` m LEFT JOIN `ps_meta_lang` `ml` ON m.`id_meta` = ml.`id_meta` AND ml.id_shop = 3 ORDER BY LENGTH(ml.`url_rewrite`) DESC	0.3	137	Yes		/classes/Dispatcher.php:614 /classes/Dispatcher.php:484 /classes/Dispatcher.php:320 /index.php:33
SELECT SQL_NO_CACHE s.`id_shop`, CONCAT(su.`physical_uri`, su.`virtual_uri`) AS `uri`, su.`domain`, su.`main` FROM `ps_shop_url` su LEFT JOIN `ps_shop` `s` ON s.`id_shop` = su.`id_shop` WHERE (su.domain = 'www.genzo.ch' OR su.domain_ssl = 'www.genzo.ch') AND (s.`active` = 1) AND (s.`deleted` = 0) ORDER BY LENGTH(CONCAT(su.`physical_uri`, su.`virtual_uri`)) DESC	0.3	2	Yes		/classes/shop/Shop.php:342 /config/config.inc.php:122 /index.php:32
SELECT SQL_NO_CACHE gs., s., gs.`name` AS `group_name`, s.`name` AS `shop_name`, s.`active`, su.`domain`, su.`domain_ssl`, su.`physical_uri`, su.`virtual_uri` FROM `ps_shop_group` gs LEFT JOIN `ps_shop` `s` ON s.`id_shop_group` = gs.`id_shop_group` LEFT JOIN `ps_shop_url` `su` ON s.`id_shop` = su.`id_shop` AND su.`main` = 1 WHERE (s.`deleted` = 0) AND (gs.`deleted` = 0) ORDER BY gs.`name`, s.`name`	0.3	4	Yes		/classes/shop/Shop.php:707 /classes/shop/Shop.php:772 /classes/Configuration.php:624 /classes/shop/Shop.php:378 /config/config.inc.php:122 /index.php:32
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, 37566) 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.3	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 = 37566) 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 = 37566 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.3	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 *, ( 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, 37570) 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.2	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 *, ( 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, 37788) 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.2	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 *, ( 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, 38028) 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.2	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

#	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

Warenkorb

Trading Card Games

Altered - Art Sleeves - Teija

Altered - Expedition Soft Box - Mana Orb

Disney Lorcana: Ursula's Return - Playmat "Rapunzel"

Pokémon Palafin ex Box - EN

Pokémon - ex Battle Deck Miraidon - EN

Pokémon - ex Battle Deck Victini - EN

Pokémon SV06.5: Nebel der Sagen: Gladimperio IR Kollektion - DE

My Hero Academia Collectible Card Game - Izuku Midoriya vs. Katsuki Bakugo 2-Play Rival Decks - EN

Yu-Gi-Oh! Speed Duel Box GX - DE

Pokémon SWSH11 Verlorener Ursprung - Top Trainer Box - DE

Pokémon Premium-Turnierkollektion Zyrus - DE

Pokémon Klara Tournament Collection - EN

Pokémon SV01 - Scarlet & Violet 1 Build & Battle Stadium Box - EN

Pokémon SV01 - 3-Pack Blister - Arcanine - EN

Pokémon Trainers Toolkit 2023 - EN

Pokémon SV02 - Entwicklungen in Paldea Build & Battle Stadion - DE

Pokémon SV02 - Paldea Evolved Build & Battle Stadium - EN

Pokémon SV - Back to School Collector's Chest - EN

Star Wars: Unlimited Double Deck Pod (Green)

Star Wars: Unlimited Soft Crate – Luke/Vader

Pokémon SV04.5 - Elite Trainer Box - EN

Pokémon Combined Powers Premium Collection - EN

Disney Lorcana: Ursula's Return - Illumineer's Quest: Deep Trouble Gift-Set - EN

Pokémon Gardevoir ex League Battle Deck - EN

Pokémon Guardevoir Liga Kampf-Deck - DE

Pokémon SV06 Twilight Masquerade Elite Trainer Box - EN

Altered - Beyond the Gates Starter Deck Display (6 Decks) - EN

Star Wars: Unlimited Art Sleeves - Kylo Ren

Altered - Cards' Lair PRO - Altered Edition

Yu-Gi-Oh! Maximum Gold: El Dorado Tuck Box Unlimited Reprint - DE

Mit Expertentipps TCG kaufen

TCG Shop für Neuware

Habt ihr Zubehör?

TCG als Investment

Stopwatch SQL - 571 queries

Doubles

Tables stress

ObjectModel instances

Included Files