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	195 ms - Unicorn powered webserver!
Querying time	77 ms
Queries	566
Memory peak usage	9.6 Mb
Included files	512 files - 7.04 Mb
thirty bees cache	1.42 Mb
Global vars	1.89 Mb
- global $_MODULES	717k
- global $context	543k
- global $smarty	523k
- 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	35 ms	35 ms	2.56 Mb	2.59 Mb
__construct	0 ms	35 ms	- Mb	2.59 Mb
init	3 ms	37 ms	0.25 Mb	2.82 Mb
checkAccess	0 ms	37 ms	- Mb	2.82 Mb
setMedia	3 ms	40 ms	0.14 Mb	2.98 Mb
postProcess	0 ms	40 ms	- Mb	2.98 Mb
initHeader	0 ms	40 ms	- Mb	2.98 Mb
initContent	113 ms	154 ms	4.60 Mb	7.56 Mb
initFooter	4 ms	157 ms	0.09 Mb	7.67 Mb
display	37 ms	195 ms	1.55 Mb	9.56 Mb

Hook	Time	Memory Usage
hookactionProductListOverride	65 ms	- Mb
=> genzo_filter	65 ms	- Mb
hookdisplayHeader	28 ms	- Mb
=> revws	0 ms	- Mb
=> genzo_shortcodes	0 ms	- Mb
=> tb_framework	26 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	- 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	5 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	1 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	1 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
hookdisplayTop	4 ms	- Mb
=> genzo_theme_configurator	4 ms	- Mb
hookdisplayRevwsAverageRating	4 ms	- Mb
=> genzo_revws	0 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	137 ms	- Mb

Module	Time	Memory Usage
genzo_filter	75 ms	- Mb
=> __construct	5 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookactionProductListOverride	65 ms	- Mb
=> hookdisplayCenterColumnTop	0 ms	- Mb
tb_framework	26 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	26 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	4 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookdisplayRevwsAverageRating	0 ms	- Mb
genzo_category	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayTabContent	2 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_search	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
=> hookdisplayFooter	2 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	0 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	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
ph_simpleblog	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_accounting	1 ms	- Mb
=> __construct	1 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	1 ms	- Mb
=> hookactionFrontControllerSetMedia	0 ms	- Mb
collectlogs	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookactionRegisterErrorHandlers	- ms	- Mb
genzo_quiz	1 ms	- Mb
=> __construct	1 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_zar	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
genzo_shortcodes	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_erp	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
=> hookdisplayBottomColumn	- ms	- Mb
statsmodule	0 ms	- Mb
=> __construct	0 ms	- 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
24 modules	137 ms	- Mb

61	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)
6	SELECT `nleft`, `nright`, `level_depth` FROM `ps_category` WHERE (`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)
4	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
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	61	/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-05 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 120	5.3	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.5	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 COUNT(DISTINCT `id_product`) FROM `ps_specific_price` WHERE `id_product` != 0 LIMIT 1	1.7	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.3	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 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.9	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 = 21137) 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 = 21137 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	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 = 22003) 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 = 22003 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 = 29130) 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 = 29130 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 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 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 = 31971) 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 = 31971 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 = 37051) 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 = 37051 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 = 37052) 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 = 37052 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 = 37469) 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 = 37469 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 = 31972) 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 = 31972 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 = 31973) 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 = 31973 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 = 38405) 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 = 38405 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 = 31974) 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 = 31974 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 = 33627) 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 = 33627 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 = 22671) 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 = 22671 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 = 37787) 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 = 37787 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 = 38033) 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 = 38033 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 = 27382) 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 = 27382 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 = 33597) 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 = 33597 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 = 29128) 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 = 29128 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 = 35062) 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 = 35062 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 = 38404) 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 = 38404 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 = 32961) 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 = 32961 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 = 29889) 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 = 29889 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 = 29131) 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 = 29131 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 = 34781) 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 = 34781 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 = 24137) 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 = 24137 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	2212	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 = 38647) 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 = 38647 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 `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 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 id_tag FROM `ps_genzo_tags_lang` WHERE (link_rewrite = '') LIMIT 1	0.2	819			/modules/genzo_tags/classes/Tag.php:122 /modules/genzo_tags/genzo_tags.php:341 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:372 /classes/Hook.php:242 /classes/controller/FrontController.php:332 /controllers/front/CategoryController.php:152 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE * FROM `ps_genzo_faq_section` s INNER JOIN `ps_genzo_faq_section_lang` sl ON s.id_section=sl.id_section AND sl.id_lang=1 INNER JOIN `ps_genzo_faq_section_shop` ss ON s.id_section=ss.id_section AND ss.id_shop=3 INNER JOIN `ps_genzo_faq_section_entity` se ON s.id_section=se.id_section WHERE (entity_type='category') AND ((entity_ids_include='*' AND (FIND_IN_SET(422, entity_ids_exclude) = 0)) OR (FIND_IN_SET(422, entity_ids_include)>0)) ORDER BY s.position	0.2	16	Yes		/modules/genzo_faq/model/Section.php:78 /modules/genzo_faq/genzo_faq.php:191 /modules/genzo_faq/genzo_faq.php:167 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:372 /modules/tb_framework/tb_framework.php:107 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:372 /classes/Hook.php:242 /classes/controller/FrontController.php:287 /controllers/front/CategoryController.php:152 /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, 21137) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-05 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, 37052) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-05 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-05 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

Pokémon SWSH11 Verlorener Ursprung - Build & Battle Stadion - DE

Pokémon TCG GO Pin Box Charmander - EN

Pokémon SWSH12.5 V - Box - Crown Zenith - Regieleki V Collection - EN

Pokémon SV01 - Karmesin & Purpur Top Trainerbox - Koraidon (rot) - DE

Pokémon SV01 - Karmesin & Purpur Top Trainerbox - Miraidon (violett) - DE

Pokémon SV01 - Elite Trainer Box - Koraidon (red) - EN

Pokémon SV01 - Elite Trainer Box - Miraidon (violet) - EN

Disney Lorcana - The Evil Queen - Lorebook Card Portfolio

Pokémon KAPU03 - Obsidian Flammen - Display (36 Booster) - DE

Star Wars: Unlimited Art Sleeves – Darth Vader

Pokémon SV05 - Elite Trainer Box - EN

Pokémon Armarouge ex Premium Collection - EN

Pokémon Crimano ex Premium Kollektion - DE

Pokémon SV06 Maskerade im Zwielicht Top Trainer Box - DE

Altered - Expedition Soft Box - Beyond the Gates

Pokémon Delfinator ex Kollektion - DE

Pokémon - Kampfdeck Victini - DE

Disney Lorcana Set 5 - Deckbox Motiv Aladdin

Disney Lorcana Set 5 - Deckbox Motiv Tiana

Pokemon - Scarlet & Violet 7 - Stellar Crown Elite Trainer Box - EN

Pokémon GO Raid Kollektion Dragoran - VSTAR - DE

Pokémon TCG SWSH12 - Silberne Sturmwinde - Booster Display (36) - DE

Pokémon GO Pin Box Bisasam - DE

Pokémon SWSH12.5 V - Box - Zenit der Könige - Regieleki-V Kollektion - DE

Pokémon SWSH12.5 V - Box - Crown Zenith - Regidrago V Collection - EN

Pokémon Mimikyu ex Box - EN

Pokémon SV03 Enhanced 2-Pack Blister

Star Wars: Unlimited Art Sleeves Double Sleeving Pack – Space Blue (Einzelartikel)

Star Wars: Unlimited Double Deck Pod (Blue)

Pokémon SV04 - Paradoxrift Display (36 Booster) - DE

Mit Expertentipps TCG kaufen

TCG Shop für Neuware

Habt ihr Zubehör?

TCG als Investment

Stopwatch SQL - 566 queries

Doubles

Tables stress

ObjectModel instances

Included Files