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	192 ms - Unicorn powered webserver!
Querying time	70 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.89 Mb
- global $_MODULES	717k
- global $context	544k
- 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	43 ms	43 ms	2.56 Mb	2.59 Mb
__construct	0 ms	43 ms	- Mb	2.59 Mb
init	2 ms	46 ms	0.25 Mb	2.82 Mb
setMedia	5 ms	51 ms	0.14 Mb	3.00 Mb
postProcess	0 ms	51 ms	- Mb	3.00 Mb
initHeader	0 ms	51 ms	- Mb	3.00 Mb
initContent	102 ms	152 ms	4.62 Mb	7.58 Mb
initFooter	4 ms	157 ms	0.09 Mb	7.69 Mb
display	35 ms	192 ms	1.57 Mb	9.60 Mb

Hook	Time	Memory Usage
hookactionProductListOverride	57 ms	2.00 Mb
=> genzo_filter	57 ms	2.00 Mb
hookdisplayHeader	25 ms	- Mb
=> revws	- ms	- Mb
=> genzo_shortcodes	0 ms	- Mb
=> tb_framework	23 ms	- Mb
=> genzo_affiliate	- ms	- Mb
=> genzo_filter	0 ms	- Mb
=> genzo_questions	0 ms	- Mb
=> genzo_category	0 ms	- Mb
=> genzo_tags	1 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	4.00 Mb
=> collectlogs	1 ms	- Mb
=> ph_simpleblog	1 ms	- Mb
=> genzo_krona	1 ms	- Mb
=> revws	1 ms	- Mb
=> genzo_affiliate	1 ms	2.00 Mb
=> genzo_tags	1 ms	- Mb
=> genzo_filter	4 ms	- Mb
=> genzo_zar	0 ms	- Mb
=> genzo_events	0 ms	- Mb
=> genzo_faq	0 ms	- Mb
=> genzo_portal	0 ms	- Mb
=> genzo_questions	0 ms	- Mb
=> genzo_quiz	0 ms	- Mb
=> genzo_revws	0 ms	- Mb
=> genzo_search	0 ms	- Mb
=> tb_framework	0 ms	- Mb
=> genzo_theme_configurator	0 ms	- Mb
=> genzo_erp	0 ms	- Mb
=> genzo_crm	0 ms	- Mb
=> genzo_turnstile	0 ms	- Mb
=> genzo_shortcodes	0 ms	- Mb
=> genzo_category	0 ms	- Mb
=> genzo_accounting	1 ms	- Mb
=> statsmodule	0 ms	2.00 Mb
hookdisplayLeftColumn	7 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
hookdisplayFooter	4 ms	- Mb
=> genzo_search	2 ms	- Mb
=> genzo_crm	2 ms	- Mb
hookdisplayTop	4 ms	- Mb
=> genzo_theme_configurator	4 ms	- Mb
hookdisplayRevwsAverageRating	4 ms	- Mb
=> genzo_revws	0 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	- 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	125 ms	6.00 Mb

Module	Time	Memory Usage
genzo_filter	67 ms	2.00 Mb
=> __construct	4 ms	- Mb
=> hookmoduleRoutes	0 ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
=> hookactionProductListOverride	57 ms	2.00 Mb
=> hookdisplayCenterColumnTop	0 ms	- Mb
tb_framework	24 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	23 ms	- Mb
=> hookdisplayBottomColumn	0 ms	- Mb
genzo_theme_configurator	11 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	3 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	2 ms	- Mb
genzo_search	2 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
=> hookdisplayFooter	2 ms	- Mb
revws	2 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_tags	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	1 ms	- Mb
=> hookdisplayLeftColumn	0 ms	- Mb
genzo_faq	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	1 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_questions	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayTabContent	- ms	- Mb
=> hookdisplayHeader	0 ms	- Mb
genzo_accounting	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookdisplayHeader	- ms	- Mb
collectlogs	1 ms	- Mb
=> __construct	1 ms	- Mb
=> hookactionRegisterErrorHandlers	- ms	- Mb
genzo_affiliate	1 ms	2.00 Mb
=> __construct	1 ms	2.00 Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
=> hookdisplayLeftColumn	- ms	- Mb
genzo_turnstile	1 ms	- Mb
=> __construct	0 ms	- Mb
=> hookactionFrontControllerSetMedia	0 ms	- Mb
genzo_zar	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
statsmodule	0 ms	2.00 Mb
=> __construct	0 ms	2.00 Mb
=> hooktop	- ms	- Mb
genzo_quiz	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookmoduleRoutes	- ms	- Mb
=> hookdisplayHeader	- ms	- Mb
genzo_shortcodes	0 ms	- Mb
=> __construct	0 ms	- Mb
=> hookdisplayHeader	0 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
24 modules	125 ms	6.00 Mb

63	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)
7	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	63	/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] /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-03 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 30	5.4	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.7	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.5	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.1	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.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 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.6	236			/classes/Hook.php:192 /classes/Hook.php:166 /classes/tax/TaxManagerFactory.php:82 /classes/tax/TaxManagerFactory.php:57 /classes/Product.php:1162 /classes/Product.php:965 /classes/Product.php:1988 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE c.*, cl.id_lang, cl.name, cl.description, cl.link_rewrite, cl.meta_title, cl.meta_keywords, cl.meta_description FROM `ps_category` c INNER JOIN ps_category_shop category_shop ON (category_shop.id_category = c.id_category AND category_shop.id_shop = 3) LEFT JOIN `ps_category_lang` cl ON (c.`id_category` = cl.`id_category` AND `id_lang` = 1 AND cl.id_shop = 3 ) LEFT JOIN `ps_category_group` cg ON (cg.`id_category` = c.`id_category`) WHERE `id_parent` = 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.5	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 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 = 3) WHERE pa.id_product = 37786 LIMIT 1	0.5	1			/classes/Product.php:1313 /classes/Product.php:1946 /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 = 37786) 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 = 37786 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 fv.id_feature, fv.id_feature_value, gfvl.link_rewrite AS link_rewrite_feature_value, gfl.link_rewrite AS link_rewrite_feature, gfvl.link_custom FROM `ps_feature_value` fv INNER JOIN `ps_genzo_tags_feature_value` gfv ON fv.id_feature_value=gfv.id_feature_value INNER JOIN `ps_genzo_tags_feature_value_lang` gfvl ON gfvl.id_feature_value_helper=gfv.id_feature_value_helper AND gfvl.id_lang = 1 INNER JOIN `ps_genzo_tags_feature` gf ON gf.id_feature = fv.id_feature INNER JOIN `ps_genzo_tags_feature_lang` gfl ON gf.id_feature_helper = gfl.id_feature_helper WHERE (gf.listing = 1 AND gfv.listing=1 AND gfl.link_rewrite!='' AND gfvl.link_rewrite!='') GROUP BY fv.id_feature_value	0.4	86	Yes	Yes	/override/classes/Product.php:350 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE `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 = 33189) 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 = 33189 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 = 34717) 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 = 34717 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 = 36682) 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 = 36682 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 = 33213) 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 = 33213 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 = 16561) 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 = 16561 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 = 30296) 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 = 30296 ORDER BY f.position, (CASE WHEN f.sorting='' OR f.sorting='value_asc' THEN fvl.value END) ASC, (CASE WHEN f.sorting='value_desc' THEN fvl.value END) DESC, (CASE WHEN f.sorting='custom' THEN fv.position END) ASC	0.4	3318	Yes		/override/classes/Product.php:320 /classes/Product.php:2040 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE 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 = 37557) 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 = 37557 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 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 = 34506) 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 = 34506 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 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 = 34669) 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 = 34669 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 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 = 36715) 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 = 36715 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 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 = 19986) 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 = 19986 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 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 = 35177) 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 = 35177 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, 37786) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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 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.2	137	Yes		/classes/Dispatcher.php:614 /classes/Dispatcher.php:484 /classes/Dispatcher.php:320 /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 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.2	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, 36709) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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 * FROM `ps_category` c LEFT JOIN `ps_category_lang` `cl` ON c.id_category = cl.id_category AND id_lang = 1 AND cl.id_shop = 3 WHERE (c.nleft <= 255 AND c.nright >= 256) ORDER BY c.nleft	0.2	187	Yes		/classes/Product.php:7840 /override/classes/Link.php:69 /cache/smarty/compile/94/89/b4/9489b4bb8dcf362518f8676e876b48db3f296670_0.file.card_product.tpl.php:36 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:384 /cache/smarty/compile/c8/b9/99/c8b999e0370760d2970af1ec9771cef8948965a7_0.file.product-list.tpl.php:44 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:386 /cache/smarty/compile/91/93/13/919313b128a30b236c56fccc8343f924a95f6619_0.file.category.tpl.php:39 /vendor/smarty/smarty/libs/sysplugins/smarty_template_resource_base.php:123 /vendor/smarty/smarty/libs/sysplugins/smarty_template_compiled.php:114 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_template.php:217 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:238 /vendor/smarty/smarty/libs/sysplugins/smarty_internal_templatebase.php:116 /classes/smarty/SmartyCustom.php:196 /classes/controller/FrontController.php:833 /tools/profiling/Controller.php:897 /tools/profiling/Controller.php:338 /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, 34687) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 32960) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 37557) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 19986) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 36682) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 34717) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 36708) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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 * FROM `ps_product` a LEFT JOIN `ps_product_lang` `b` ON a.`id_product` = b.`id_product` AND b.`id_lang` = 1 LEFT JOIN `ps_product_shop` `c` ON a.`id_product` = c.`id_product` AND c.`id_shop` = 3 WHERE (a.`id_product` = 37786) AND (b.`id_shop` = 3) LIMIT 1	0.2	1			/Adapter/Adapter_EntityMapper.php:74 /classes/ObjectModel.php:273 /tools/profiling/ObjectModel.php:51 /classes/Product.php:717 /override/classes/Link.php:22 /classes/Product.php:1980 /classes/Product.php:1911 /modules/genzo_filter/genzo_filter.php:1179 /modules/genzo_filter/genzo_filter.php:382 /classes/Hook.php:843 /classes/Hook.php:544 /classes/Hook.php:263 /controllers/front/CategoryController.php:261 /controllers/front/CategoryController.php:169 /tools/profiling/Controller.php:317 /classes/controller/FrontController.php:267 /override/classes/Dispatcher.php:134 /index.php:33
SELECT SQL_NO_CACHE *, ( 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, 34506) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 34669) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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, 16561) AND `id_customer` = 0 AND `id_product_attribute` = 0 AND `id_cart` = 0 AND (`from` = '0000-00-00 00:00:00' OR '2024-12-03 00:00:00' >= `from`) AND (`to` = '0000-00-00 00:00:00' OR '2024-12-03 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 Kampfakademie Box 2024 - DE

Final Fantasy TCG - Anniversary Collection Set 2022 - DE

Pokémon Mimigma ex Box - DE

Pokémon Epittaf Epitaff ex Kollektion - DE

Pokémon Cards Classics Box - EN

Star Wars: Unlimited - Spark of Rebellion Booster Display (24 Booster) - EN

Star Wars: Unlimited Art Sleeves – Luke Skywalker (Einzelartikel)

Star Wars: Unlimited Prime Game Mat – X-Wing

Star Wars: Unlimited Prime Game Mat – TIE Fighter

Star Wars: Unlimited Soft Crate – X-Wing/TIE Fighter

Star Wars: Unlimited Art Sleeves Double Sleeving Pack – Luke Skywalker

Star Wars: Unlimited Soft Crate – Darth Vader

Disney Lorcana - Die Tintenlande - Geschenk-Set - DE

Disney Lorcana: Ursula's Return - Deck Box "Snow White"

Disney Lorcana: Ursula's Return - Illumineer's Trove Pack - EN

Pokémon SWSH10.5 GO Top Trainer Box - DE

Disney Lorcana - Card Binder/Sammelalbum - Stitch

Pokémon SV - Cards Back to School Sammelkoffer - DE

Star Wars: Unlimited Double Deck Pod (Black)

Disney Lorcana: Ursula's Return - Deck Box "Genie"

Star Wars: Unlimited Soft Crate - Mandalorian/Moff Gideon

Star Wars: Unlimited Art Sleeves - Moff Gideon

Altered - Beyond the Gates - Booster Display (36) - EN

Altered - Art Sleeves - Akesha

Star Wars: Unlimited Deck Pod (Red)

Star Wars: Unlimited Deck Pod (Blue)

Star Wars: Unlimited Deck Pod (Yellow)

Star Wars: Unlimited Prime Game Mat – Death Star

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

Disney Lorcana - Die Tintenlande - Starter Deck "Rubin/Saphir" - 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