Komplettsysteme

Filter

Balter 2-Draht Set, Graphit Edelstahl-Türstation für 1 Teilnehmer, 7" Videostation, Touchscreen, BUS-C6002H Hauptstromverteiler

Für Preise und Verfügbarkeiten bitte einloggen.

J7SV-1B-SET-BUS

Balter 2-Draht Set, Silver Edelstahl-Türstation für 1 Teilnehmer, 7" Videostation, Touchscreen, BUS-C6002H Hauptstromverteiler

Für Preise und Verfügbarkeiten bitte einloggen.

Artikel 1 - 2 von 2

Das Online-Konfigurationstool hilft Ihnen bei der Zusammenstellung des Sicherheitssystems...

Kataloge und broschüren

Bezugsquellen

Partner Werden

Hilfe für kunden

Unternehmen

Services

Kontakt

Elektro-Lexikon

Ratgeber

FAQ

Timeline Database502 Config Messages Request Exceptions Errors9 Smarty

133ms8.2.2811MB

Shop start to end (109ms)
shop.hook.250 (6μs)
shop.hook.254 (2μs)
shop.hook.252 (2μs)
shop.hook.251 (1μs)
shop.hook.300 (4μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (3μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.131 (2μs)
shop.hook.156 (1μs)
shop.hook.361 (1μs)
shop.hook.133 (3μs)
shop.hook.320 (497μs)
shop.hook.250 (2μs)
shop.hook.254 (1μs)
shop.hook.252 (26.56ms)
shop.hook.120 (2μs)
shop.hook.120 (2μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.120 (3μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.120 (2μs)
shop.hook.120 (4μs)
shop.hook.120 (2μs)
shop.hook.118 (3μs)
shop.hook.302 (3μs)
shop.hook.300 (2μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.302 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.302 (0μs)
shop.hook.300 (2μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.302 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.302 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.302 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (4μs)
shop.hook.302 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.302 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.302 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.302 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.306 (3μs)
shop.hook.303 (2μs)
shop.hook.142 (2μs)
shop.hook.400 (1μs)
shop.hook.132 (2μs)
shop.hook.166 (1μs)
shop.hook.143 (1μs)
shop.hook.120 (2μs)
shop.hook.251 (1μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.120 (1μs)
shop.hook.120 (1μs)
shop.hook.214 (1μs)
shop.hook.120 (1μs)
shop.hook.120 (2μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.178 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.119 (1μs)
shop.hook.119 (0μs)
shop.hook.119 (1μs)
shop.hook.119 (1μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.221 (2μs)
shop.hook.253 (1μs)
shop.hook.221 (2μs)
shop.hook.253 (0μs)
shop.hook.120 (2μs)
shop.hook.221 (2μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (0μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (0μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (0μs)
shop.hook.221 (1μs)
shop.hook.253 (0μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (3μs)
shop.hook.119 (2μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.119 (1μs)
shop.hook.321 (5μs)
shop.hook.260 (1μs)
shop.hook.330 (1μs)
shop.hook.330 (1μs)
shop.hook.103 (2μs)
shop.hook.330 (1μs)
shop.hook.60 (1μs)
shop.hook.58 (1μs)
shop.hook.59 (1μs)
shop.hook.110 (1μs)
shop.hook.221 (1μs)
shop.hook.119 (2μs)
shop.hook.119 (1μs)
shop.hook.119 (1μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.119 (0μs)
shop.hook.321 (2μs)
shop.hook.260 (1μs)
shop.hook.330 (0μs)
shop.hook.330 (0μs)
shop.hook.103 (1μs)
shop.hook.330 (2μs)
shop.hook.60 (1μs)
shop.hook.58 (0μs)
shop.hook.59 (1μs)
shop.hook.110 (1μs)
shop.hook.22 (1μs)
shop.hook.120 (2μs)
shop.hook.120 (2μs)
shop.hook.118 (2μs)
shop.hook.221 (2μs)
shop.hook.221 (1μs)
shop.hook.226 (2μs)
shop.hook.330 (1μs)
shop.hook.330 (1μs)
shop.hook.330 (0μs)
shop.hook.330 (1μs)
shop.hook.330 (1μs)
shop.hook.330 (0μs)
shop.hook.331 (1μs)
shop.hook.118 (0μs)
shop.hook.204 (3μs)
shop.hook.175 (1μs)
shop.hook.109 (6μs)
shop.hook.99 (2μs)
shop.hook.221 (4μs)
shop.hook.253 (2μs)
shop.hook.89 (2μs)
shop.hook.90 (1μs)
shop.hook.221 (1μs)
shop.hook.208 (2μs)
shop.hook.300 (3μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (1μs)
shop.hook.208 (2μs)
shop.hook.120 (1μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.208 (2μs)
shop.hook.208 (2μs)
shop.hook.208 (1μs)
shop.hook.208 (1μs)
shop.hook.208 (1μs)
shop.hook.208 (2μs)
shop.hook.208 (1μs)
shop.hook.208 (1μs)
shop.hook.208 (1μs)
shop.hook.208 (2μs)
shop.hook.208 (1μs)
shop.hook.208 (2μs)
shop.hook.208 (3μs)
shop.hook.101 (2μs)

1 x Shop start to end (82.3%)	109.11ms
2 x shop.hook.252 (20.04%)	26.56ms
1 x shop.hook.320 (0.37%)	497μs
135 x shop.hook.301 (0.09%)	115μs
135 x shop.hook.300 (0.07%)	89μs
23 x shop.hook.120 (0.03%)	42μs
21 x shop.hook.221 (0.02%)	30μs
15 x shop.hook.208 (0.02%)	24μs
16 x shop.hook.253 (0.01%)	12μs
18 x shop.hook.119 (0.01%)	10μs
12 x shop.hook.330 (0.01%)	9μs
2 x shop.hook.250 (0.01%)	8μs
2 x shop.hook.321 (0.01%)	7μs
10 x shop.hook.302 (0.01%)	7μs
1 x shop.hook.109 (0%)	6μs
3 x shop.hook.118 (0%)	5μs
1 x shop.hook.133 (0%)	3μs
1 x shop.hook.204 (0%)	3μs
2 x shop.hook.254 (0%)	3μs
1 x shop.hook.306 (0%)	3μs
2 x shop.hook.103 (0%)	3μs
2 x shop.hook.251 (0%)	2μs
1 x shop.hook.303 (0%)	2μs
1 x shop.hook.132 (0%)	2μs
2 x shop.hook.110 (0%)	2μs
1 x shop.hook.226 (0%)	2μs
1 x shop.hook.89 (0%)	2μs
1 x shop.hook.101 (0%)	2μs
1 x shop.hook.131 (0%)	2μs
1 x shop.hook.142 (0%)	2μs
2 x shop.hook.260 (0%)	2μs
2 x shop.hook.60 (0%)	2μs
2 x shop.hook.59 (0%)	2μs
1 x shop.hook.99 (0%)	2μs
1 x shop.hook.400 (0%)	1μs
1 x shop.hook.166 (0%)	1μs
1 x shop.hook.178 (0%)	1μs
1 x shop.hook.175 (0%)	1μs
1 x shop.hook.156 (0%)	1μs
1 x shop.hook.361 (0%)	1μs
1 x shop.hook.143 (0%)	1μs
1 x shop.hook.214 (0%)	1μs
2 x shop.hook.58 (0%)	1μs
1 x shop.hook.22 (0%)	1μs
1 x shop.hook.331 (0%)	1μs
1 x shop.hook.90 (0%)	1μs

502 statements were executed, 283 of which were duplicates, 219 unique63.76ms8.31MB

SELECT * FROM tsprache69μs16.22KB20000000000000b790000000000000000default
SELECT * FROM tkundengruppe WHERE `cStandard`=?76μs16.7KB10000000000000b7d0000000000000000default
Params
0 Y
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section1.37ms17.39KB530000000000000b840000000000000000default
Params
:section 1
SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe32μs16.25KB00000000000000b390000000000000000default
Params
:kKundengruppe 1
SELECT tpluginhook.nHook, tplugin.kPlugin, tplugin.nVersion, tpluginhook.cDateiname, tpluginhook.nPriority FROM tplugin JOIN tpluginhook ON tpluginhook.kPlugin = tplugin.kPlugin WHERE tplugin.nStatus = :state ORDER BY tpluginhook.nPriority, tplugin.kPlugin94μs16.69KB120000000000000b4f0000000000000000default
Params
:state 2
SELECT * FROM tsprache29μs16.22KB20000000000000aec0000000000000000default
SELECT * FROM twaehrung25μs16.23KB10000000000000ae80000000000000000default
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache105μs16.08KB00000000000000a8b0000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section510μs16.95KB27000000000000090b0000000000000000default
Params
:section 7
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC143μs16.22KB200000000000008ef0000000000000000default
SELECT * FROM tglobals WHERE dLetzteAenderung > :ts34μs16.2KB000000000000008f20000000000000000default
Params
:ts 2025-04-27 11:03:33
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC43μs16.22KB20000000000000baf0000000000000000default
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv37μs16.42KB30000000000000bb00000000000000000default
Params
:nAktiv 1
SELECT kPlugin AS id, bExtension AS modern FROM tplugin WHERE nStatus = :state AND bBootstrap = 1 ORDER BY nPrio ASC42μs16.31KB300000000000008fc0000000000000000default
Params
:state 2
SELECT * FROM tplugin WHERE `kPlugin`=?42μs17.2KB100000000000009010000000000000000default
Params
0 1
SELECT tstoreauth.auth_code, tstoreauth.access_token, tadminlogin.cPass AS hash, tstoreauth.verified FROM tstoreauth INNER JOIN tadminlogin ON tadminlogin.kAdminlogin = tstoreauth.owner LIMIT 140μs16.11KB100000000000017010000000000000000default
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 130μs16.11KB100000000000017050000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?53μs17.25KB200000000000017290000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?36μs17.22KB0000000000000173a0000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort42μs16.34KB600000000000016f30000000000000000default
Params
:kPlugin 1
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin23μs16.3KB400000000000017110000000000000000default
Params
:kPlugin 1
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink81μs16.46KB400000000000017310000000000000000default
Params
:plgn 1
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)34μs16.14KB400000000000017040000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (105,106,107,108) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName545μs17KB800000000000017050000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB000000000000017400000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000017450000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000174a0000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000174f0000000000000000default
Params
:kVaterLink 106
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort507μs17.34KB900000000000017300000000000000000default
Params
:pid 1
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable326μs34.06KB78000000000000170e0000000000000000default
Params
:pid 1
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin51μs16.34KB0000000000000179b0000000000000000default
Params
:kPlugin 1
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id73μs16.78KB400000000000017960000000000000000default
Params
:id 1
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid63μs16.98KB3000000000000178f0000000000000000default
Params
:pid kPlugin\_1\_%
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort48μs16.55KB3000000000000178f0000000000000000default
Params
:val kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart28μs16.28KB2000000000000178f0000000000000000default
Params
:kZahlungsart 73
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort34μs16.55KB3000000000000178f0000000000000000default
Params
:val kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart21μs16.28KB2000000000000178f0000000000000000default
Params
:kZahlungsart 74
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort32μs16.55KB3000000000000178f0000000000000000default
Params
:val kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart19μs16.28KB2000000000000178f0000000000000000default
Params
:kZahlungsart 75
SELECT * FROM tplugin WHERE `kPlugin`=?35μs17.2KB100000000000017c60000000000000000default
Params
0 2
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort32μs16.27KB100000000000018650000000000000000default
Params
:kPlugin 2
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin21μs16.24KB0000000000000186c0000000000000000default
Params
:kPlugin 2
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink61μs16.4KB0000000000000186b0000000000000000default
Params
:plgn 2
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort159μs17.19KB000000000000018720000000000000000default
Params
:pid 2
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable196μs17.13KB1800000000000018790000000000000000default
Params
:pid 2
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin45μs16.34KB0000000000000188e0000000000000000default
Params
:kPlugin 2
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id58μs16.72KB000000000000018890000000000000000default
Params
:id 2
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid52μs16.94KB000000000000018850000000000000000default
Params
:pid kPlugin\_2\_%
SELECT cSektion AS sec, cWert AS val, cName AS name FROM ttemplateeinstellungen WHERE cTemplate = (SELECT cTemplate FROM ttemplate WHERE eTyp = 'standard')106μs17.08KB63000000000000187e0000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?35μs17.2KB1000000000000187f0000000000000000default
Params
0 5
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 130μs16.11KB100000000000018bf0000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?32μs17.25KB2000000000000189b0000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?25μs17.22KB000000000000018e70000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort37μs16.34KB600000000000018ce0000000000000000default
Params
:kPlugin 5
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin22μs16.37KB800000000000018cb0000000000000000default
Params
:kPlugin 5
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink83μs16.52KB800000000000018e00000000000000000default
Params
:plgn 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)35μs16.2KB800000000000018b00000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName548μs17.13KB1600000000000018ef0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink48μs16.12KB000000000000019040000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000019090000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000190e0000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000019130000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000019180000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000191d0000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000019220000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000019270000000000000000default
Params
:kVaterLink 438
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort160μs17.19KB000000000000018ad0000000000000000default
Params
:pid 5
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable165μs16.84KB200000000000018e40000000000000000default
Params
:pid 5
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin43μs16.34KB000000000000019000000000000000000default
Params
:kPlugin 5
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id56μs16.72KB000000000000018fa0000000000000000default
Params
:id 5
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid51μs16.94KB000000000000018f60000000000000000default
Params
:pid kPlugin\_5\_%
SELECT * FROM ttemplate WHERE `eTyp`=?32μs16.85KB1000000000000195d0000000000000000default
Params
0 standard
SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate88μs17.2KB6300000000000019630000000000000000default
Params
:cTemplate BALTER
SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio39μs16.3KB300000000000019a20000000000000000default
Params
:nStatus 2
SELECT * FROM tconsent WHERE `active`=:active34μs16.27KB20000000000001ee50000000000000000default
Params
:active 1
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID32μs16.31KB20000000000001eff0000000000000000default
Params
:consentID 1
SELECT * FROM tsprache23μs16.22KB20000000000001eff0000000000000000default
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID26μs16.31KB20000000000001f0a0000000000000000default
Params
:consentID 2
SELECT * FROM tsprache21μs16.22KB20000000000001f0a0000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section63μs16.56KB30000000000001f0a0000000000000000default
Params
:section 129
SELECT tplugineinstellungen.*, tplugineinstellungenconf.cConf FROM tplugin JOIN tplugineinstellungen ON tplugineinstellungen.kPlugin = tplugin.kPlugin LEFT JOIN tplugineinstellungenconf ON tplugineinstellungenconf.kPlugin = tplugin.kPlugin AND tplugineinstellungen.cName = tplugineinstellungenconf.cWertName WHERE tplugin.kPlugin = :pid358μs17.84KB720000000000001f1a0000000000000000default
Params
:pid 1
SELECT tkategorie.kKategorie, tkategorie.cSeo, tkategorie.cName, tkategorie.kOberKategorie, tkategoriepict.kKategoriePict FROM tkategorie LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie WHERE tkategorie.kOberKategorie = 050μs16.19KB40000000000001f520000000000000000default
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL147μs18.39KB10000000000001f3a0000000000000000default
Params
:kid 108
:cgid 1
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section555μs17.02KB320000000000001f480000000000000000default
Params
:section 110
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort149μs17KB00000000000001f740000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?53μs16.93KB40000000000001f6f0000000000000000default
Params
0 108
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL146μs18.39KB10000000000001f6e0000000000000000default
Params
:kid 123
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort307μs17KB00000000000001f6e0000000000000000default
Params
:cid 123
SELECT * FROM tkategorie WHERE `kOberKategorie`=?53μs16.99KB80000000000001f230000000000000000default
Params
0 123
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL138μs18.39KB10000000000001f240000000000000000default
Params
:kid 132
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort148μs17KB00000000000001f240000000000000000default
Params
:cid 132
SELECT * FROM tkategorie WHERE `kOberKategorie`=?52μs16.99KB70000000000001f2d0000000000000000default
Params
0 132
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL133μs18.39KB10000000000001f2e0000000000000000default
Params
:kid 220
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort124μs17KB00000000000001f2e0000000000000000default
Params
:cid 220
SELECT * FROM tkategorie WHERE `kOberKategorie`=?38μs16.87KB00000000000001f780000000000000000default
Params
0 220
SELECT id_category FROM submenusettings WHERE id = 125μs16.04KB10000000000001f3b0000000000000000default
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB10000000000001f320000000000000000default
Params
:kid 109
:cgid 1
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section3.56ms18.02KB910000000000001f7d0000000000000000default
Params
:section 9
SELECT tbranding.kBranding AS id, tbranding.cBildKategorie AS type, tbrandingeinstellung.cPosition AS position, tbrandingeinstellung.cBrandingBild AS path, tbrandingeinstellung.dTransparenz AS transparency, tbrandingeinstellung.dGroesse AS size FROM tbrandingeinstellung INNER JOIN tbranding ON tbrandingeinstellung.kBranding = tbranding.kBranding WHERE tbrandingeinstellung.nAktiv = 153μs16.16KB00000000000001fda0000000000000000default
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort148μs17KB00000000000001fdb0000000000000000default
Params
:cid 109
SELECT * FROM tkategorie WHERE `kOberKategorie`=?59μs16.95KB50000000000001fd40000000000000000default
Params
0 109
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL147μs18.39KB10000000000001fd30000000000000000default
Params
:kid 110
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort131μs17KB00000000000001fd30000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.95KB50000000000001fca0000000000000000default
Params
0 110
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL137μs18.39KB10000000000001fc90000000000000000default
Params
:kid 111
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort123μs17KB00000000000001fc90000000000000000default
Params
:cid 111
SELECT * FROM tkategorie WHERE `kOberKategorie`=?44μs16.93KB40000000000001fc00000000000000000default
Params
0 111
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB10000000000001fbf0000000000000000default
Params
:kid 112
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort126μs17KB00000000000001fbf0000000000000000default
Params
:cid 112
SELECT * FROM tkategorie WHERE `kOberKategorie`=?44μs16.95KB50000000000001fb60000000000000000default
Params
0 112
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB10000000000001fb50000000000000000default
Params
:kid 115
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort141μs17KB00000000000001fb50000000000000000default
Params
:cid 115
SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.87KB00000000000001fac0000000000000000default
Params
0 115
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL135μs18.39KB10000000000001fac0000000000000000default
Params
:kid 116
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort125μs17KB00000000000001fac0000000000000000default
Params
:cid 116
SELECT * FROM tkategorie WHERE `kOberKategorie`=?39μs16.87KB00000000000001fa20000000000000000default
Params
0 116
SELECT * FROM tland115μs20.19KB2360000000000001f980000000000000000default
SELECT cLaender FROM tversandart23μs16.05KB20000000000001f980000000000000000default
SELECT DISTINCT cLandIso FROM tstaat54μs16.52KB290000000000001f980000000000000000default
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName70μs16.56KB2400000000000020cc0000000000000000default
Params
:cLandIso AR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName38μs16.34KB900000000000020d90000000000000000default
Params
:cLandIso AT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.34KB1000000000000020b80000000000000000default
Params
:cLandIso BE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName55μs16.69KB2800000000000020fb0000000000000000default
Params
:cLandIso BG
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName63μs16.63KB2700000000000021170000000000000000default
Params
:cLandIso BR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName40μs16.41KB13000000000000213c0000000000000000default
Params
:cLandIso CA
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName52μs16.63KB26000000000000210b0000000000000000default
Params
:cLandIso CH
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName66μs16.81KB3400000000000021770000000000000000default
Params
:cLandIso CN
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName30μs16.28KB600000000000021a00000000000000000default
Params
:cLandIso CY
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.44KB1400000000000021980000000000000000default
Params
:cLandIso CZ
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName40μs16.44KB1600000000000021720000000000000000default
Params
:cLandIso DE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName92μs16.27KB500000000000021d90000000000000000default
Params
:cLandIso DK
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName59μs16.44KB15000000000000216e0000000000000000default
Params
:cLandIso EE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName88μs17.06KB5000000000000021f80000000000000000default
Params
:cLandIso ES
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName48μs16.5KB1900000000000022330000000000000000default
Params
:cLandIso FI
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName166μs18.19KB11400000000000022220000000000000000default
Params
:cLandIso FR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName29μs16.25KB400000000000022c50000000000000000default
Params
:cLandIso GB
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.41KB1300000000000022b30000000000000000default
Params
:cLandIso GR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName46μs16.56KB2100000000000022ab0000000000000000default
Params
:cLandIso HR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName63μs16.81KB3600000000000022890000000000000000default
Params
:cLandIso IN
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName142μs17.94KB110000000000000222a0000000000000000default
Params
:cLandIso IT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName74μs16.94KB4700000000000023aa0000000000000000default
Params
:cLandIso JP
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.34KB10000000000000238b0000000000000000default
Params
:cLandIso LT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName163μs18.19KB11900000000000023960000000000000000default
Params
:cLandIso LV
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName60μs16.69KB3200000000000024690000000000000000default
Params
:cLandIso MX
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.38KB12000000000000244f0000000000000000default
Params
:cLandIso NL
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName69μs16.94KB4200000000000021ef0000000000000000default
Params
:cLandIso RO
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName107μs17.44KB7800000000000024f80000000000000000default
Params
:cLandIso TH
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName95μs17.19KB63000000000000256f0000000000000000default
Params
:cLandIso US
SELECT * FROM tfirma LIMIT 135μs16.52KB10000000000001f9b0000000000000000default
SELECT * FROM tversandart WHERE cNurAbhaengigeVersandart = :depOnly AND cLaender LIKE :iso AND (cVersandklassen = '-1' OR cVersandklassen RLIKE :sClasses) AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0) ORDER BY nSort77μs16.88KB00000000000001f9e0000000000000000default
Params
:iso %DE%
:cGroupID 1
:sClasses ^([0-9 -]* )?
:depOnly Y
SELECT g.*, l.cName AS localizedName, l.cISOSprache, g.cTemplatename AS template, g.cName AS groupName, IFNULL(tsprache.kSprache, 0) AS kSprache FROM tlinkgruppe AS g LEFT JOIN tlinkgruppesprache AS l ON g.kLinkgruppe = l.kLinkgruppe LEFT JOIN tsprache ON tsprache.cISO = l.cISOSprache WHERE g.kLinkgruppe > 0 AND l.kLinkgruppe > 0111μs16.59KB2200000000000020a80000000000000000default
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName58μs16.27KB000000000000020890000000000000000default
Params
:lgid 1
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName51μs16.37KB600000000000020840000000000000000default
Params
:lgid 4
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (440,442,68,71,443,444)36μs16.17KB600000000000020850000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (68,71,440,442,443,444) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName559μs17.06KB1200000000000020740000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000020630000000000000000default
Params
:kVaterLink 440
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000205e0000000000000000default
Params
:kVaterLink 442
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000020590000000000000000default
Params
:kVaterLink 68
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020540000000000000000default
Params
:kVaterLink 71
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000204f0000000000000000default
Params
:kVaterLink 443
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000204a0000000000000000default
Params
:kVaterLink 444
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName69μs16.37KB600000000000020690000000000000000default
Params
:lgid 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (69,67,59,49,73,74)33μs16.17KB600000000000020680000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (49,59,67,69,73,74) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName529μs17.06KB12000000000000207b0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB0000000000000203c0000000000000000default
Params
:kVaterLink 69
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000020370000000000000000default
Params
:kVaterLink 67
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB000000000000020320000000000000000default
Params
:kVaterLink 59
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000202d0000000000000000default
Params
:kVaterLink 49
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020280000000000000000default
Params
:kVaterLink 73
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020230000000000000000default
Params
:kVaterLink 74
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName106μs16.71KB2700000000000020420000000000000000default
Params
:lgid 8
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (77,76,79,78,81,75,80,85,86,434,437,83,432,433,108,107,105,106,439,435,436,438,84,3,63,4,72)57μs16.52KB2700000000000020410000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (3,4,63,72,75,76,77,78,79,80,81,83,84,85,86,105,106,107,108,432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName895μs33.75KB540000000000001ffc0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000025410000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000025460000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000254b0000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000025500000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000025550000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000255a0000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000255f0000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000025640000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000025690000000000000000default
Params
:kVaterLink 86
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000260e0000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026130000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026180000000000000000default
Params
:kVaterLink 83
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000261d0000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026220000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026270000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000262c0000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026310000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026360000000000000000default
Params
:kVaterLink 106
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000263b0000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026400000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026450000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000264a0000000000000000default
Params
:kVaterLink 438
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000264f0000000000000000default
Params
:kVaterLink 84
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.1KB000000000000026540000000000000000default
Params
:kVaterLink 3
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026590000000000000000default
Params
:kVaterLink 63
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.1KB0000000000000265e0000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026630000000000000000default
Params
:kVaterLink 72
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName70μs16.37KB60000000000001f930000000000000000default
Params
:lgid 9
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (103,104,420,422,64,61)32μs16.17KB60000000000001f940000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (61,64,103,104,420,422) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName490μs17.03KB100000000000001f830000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB00000000000001fe60000000000000000default
Params
:kVaterLink 103
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB00000000000001feb0000000000000000default
Params
:kVaterLink 104
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB00000000000001ff00000000000000000default
Params
:kVaterLink 420
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000001ff50000000000000000default
Params
:kVaterLink 422
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020170000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020010000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName67μs16.35KB50000000000001fe00000000000000000default
Params
:lgid 10
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (109,112,111,110,113)31μs16.16KB50000000000001fe10000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (109,110,111,112,113) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName456μs17.03KB100000000000001f8a0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB0000000000000200d0000000000000000default
Params
:kVaterLink 109
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020120000000000000000default
Params
:kVaterLink 112
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020410000000000000000default
Params
:kVaterLink 111
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000201c0000000000000000default
Params
:kVaterLink 110
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000207b0000000000000000default
Params
:kVaterLink 113
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName61μs16.32KB300000000000020070000000000000000default
Params
:lgid 11
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (446,448,447)27μs16.13KB300000000000020080000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (446,447,448) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName419μs16.97KB60000000000001f870000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB000000000000020680000000000000000default
Params
:kVaterLink 446
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020850000000000000000default
Params
:kVaterLink 448
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000204b0000000000000000default
Params
:kVaterLink 447
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName65μs16.32KB30000000000001f320000000000000000default
Params
:lgid 12
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (115,50,66)34μs16.13KB30000000000001f7d0000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (50,66,115) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName425μs16.97KB600000000000020740000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB000000000000026720000000000000000default
Params
:kVaterLink 115
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026770000000000000000default
Params
:kVaterLink 50
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000267c0000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName66μs16.34KB4000000000000266c0000000000000000default
Params
:lgid 13
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (116,118,119,117)30μs16.14KB4000000000000266d0000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (116,117,118,119) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName445μs17KB800000000000026810000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB0000000000000268e0000000000000000default
Params
:kVaterLink 116
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000026930000000000000000default
Params
:kVaterLink 118
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026980000000000000000default
Params
:kVaterLink 119
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000269d0000000000000000default
Params
:kVaterLink 117
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName55μs16.29KB100000000000026880000000000000000default
Params
:lgid 14
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (120)20μs16.09KB100000000000026890000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (120) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName174μs16.91KB200000000000026800000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB000000000000026810000000000000000default
Params
:kVaterLink 120
SELECT tlink.*, tlinksprache.cISOSprache, tlink.cName AS displayName, tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle, tsprache.kSprache, tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content, tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords, tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, GROUP_CONCAT(tlinkgroupassociations.linkGroupID) AS linkGroups, 2 AS pluginState FROM tlinksprache JOIN tlink ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache JOIN tlinkgroupassociations ON tlinkgroupassociations.linkID = tlinksprache.kLink LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = tlink.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart WHERE tlink.kLink = tlinksprache.kLink AND tlink.nLinkart >= 5 GROUP BY tlink.kLink, tseo.kSprache753μs34KB7400000000000020900000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.1KB000000000000026d60000000000000000default
Params
:kVaterLink 3
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.1KB000000000000026db0000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026e00000000000000000default
Params
:kVaterLink 49
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026e50000000000000000default
Params
:kVaterLink 50
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026ea0000000000000000default
Params
:kVaterLink 59
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026ef0000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026f40000000000000000default
Params
:kVaterLink 63
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026f90000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026fe0000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027030000000000000000default
Params
:kVaterLink 67
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000027080000000000000000default
Params
:kVaterLink 69
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000270d0000000000000000default
Params
:kVaterLink 72
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027120000000000000000default
Params
:kVaterLink 73
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027170000000000000000default
Params
:kVaterLink 74
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000271c0000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027210000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000027260000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000272b0000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027300000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027350000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000273a0000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000273f0000000000000000default
Params
:kVaterLink 83
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027440000000000000000default
Params
:kVaterLink 84
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027490000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000274e0000000000000000default
Params
:kVaterLink 86
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027530000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027580000000000000000default
Params
:kVaterLink 106
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000275d0000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027620000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027670000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000276c0000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027710000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027760000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000277b0000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027800000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027850000000000000000default
Params
:kVaterLink 438
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000278a0000000000000000default
Params
:kVaterLink 439
SELECT tspezialseite.kSpezialseite, tspezialseite.cName AS baseName, tspezialseite.cDateiname, tspezialseite.nLinkart, tlink.kLink, tlink.cName AS displayName, tlink.reference, tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle, tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content, tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords, tlinksprache.cMetaTitle AS metaTitle, tlink.cKundengruppen, tseo.cSeo AS localizedUrl, tsprache.cISO AS cISOSprache, tsprache.kSprache AS languageID, tlink.kVaterLink, tspezialseite.kPlugin, tlink.cName, tlink.cNoFollow, tlink.cSichtbarNachLogin, tlink.cDruckButton, tlink.nSort, tlink.bIsActive, tlink.bIsFluid, tlink.bSSL, GROUP_CONCAT(tlinkgroupassociations.linkGroupID) AS linkGroups, 2 AS pluginState FROM tspezialseite LEFT JOIN tlink ON tlink.nLinkart = tspezialseite.nLinkart LEFT JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache JOIN tlinkgroupassociations ON tlinkgroupassociations.linkID = tlinksprache.kLink LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = tlink.kLink AND tseo.kSprache = tsprache.kSprache WHERE cDateiname IS NOT NULL AND cDateiname != '' GROUP BY tlink.kLink, tsprache.kSprache589μs17.23KB2600000000000026d10000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.1KB000000000000026b00000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026ab0000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026a60000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000026800000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000268b0000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020a20000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020a00000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020940000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000209b0000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027900000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027950000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000279a0000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000279f0000000000000000default
Params
:kVaterLink 86
SELECT tlink.*, tlinksprache.cISOSprache, tlink.cName AS displayName, tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle, tsprache.kSprache, tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content, tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords, tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID, tseo.cSeo AS localizedUrl, '' AS cDateiname, '' AS linkGroups, 2 AS pluginState FROM tlinksprache JOIN tlink ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = tlink.kLink AND tseo.kSprache = tsprache.kSprache WHERE tlink.kLink NOT IN (SELECT linkID FROM tlinkgroupassociations) GROUP BY tlink.kLink, tsprache.kSprache309μs16.75KB000000000000026b50000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section91μs16.56KB300000000000027a90000000000000000default
Params
:section 128
SELECT * FROM tseo WHERE cSeo = :slg41μs16.22KB1000000000000280b0000000000000000default
Params
:slg Komplettsysteme_1
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL162μs18.39KB100000000000028100000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort144μs17KB000000000000028100000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?44μs16.87KB0000000000000281a0000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL142μs18.39KB1000000000000281d0000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort129μs17KB0000000000000281d0000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?40μs16.87KB000000000000028270000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL132μs18.39KB100000000000028270000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort124μs17KB000000000000028270000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?39μs16.87KB000000000000028310000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL134μs18.39KB1000000000000282c0000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort122μs17KB0000000000000282c0000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?36μs16.87KB0000000000000283a0000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL134μs18.39KB100000000000028350000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort121μs17KB000000000000028350000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?36μs16.87KB000000000000028430000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL127μs18.39KB1000000000000283e0000000000000000default
Params
:kid 112
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort121μs17KB0000000000000283e0000000000000000default
Params
:cid 112
SELECT * FROM tkategorie WHERE `kOberKategorie`=?49μs16.95KB5000000000000284c0000000000000000default
Params
0 112
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB1000000000000284d0000000000000000default
Params
:kid 108
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort127μs17KB0000000000000284d0000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?46μs16.93KB400000000000028560000000000000000default
Params
0 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.41KB0000000000000285b0000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName121μs16.05KB2000000000000285a0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie33μs16.41KB000000000000028640000000000000000default
Params
:kOberKategorie 207
SELECT tseo.cSeo, ssMerkmal.kHersteller, ssMerkmal.cName, ssMerkmal.nSortNr, ssMerkmal.cBildPfad, COUNT(*) AS nAnzahl FROM (SELECT thersteller.kHersteller, thersteller.cName, thersteller.nSortNr, thersteller.cBildPfad, tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #JOIN from JTL\Filter\States\BaseManufacturer::getOptions JOIN thersteller ON tartikel.kHersteller = thersteller.kHersteller #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName) AS ssMerkmal LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = :lid GROUP BY ssMerkmal.kHersteller ORDER BY ssMerkmal.nSortNr, ssMerkmal.cName185μs17.67KB1000000000000286a0000000000000000default
Params
:lid 1
SELECT tseo.cSeo, tseo.kSprache, thersteller.cName FROM tseo JOIN thersteller ON thersteller.kHersteller = tseo.kKey AND thersteller.nAktiv = 1 WHERE cKey = 'kHersteller' AND kKey IN (2)60μs16.11KB2000000000000286e0000000000000000default
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = therstellersprache.kSprache WHERE thersteller.kHersteller = :manfID AND thersteller.nAktiv = 1 GROUP BY kSprache, thersteller.kHersteller189μs17.41KB600000000000028720000000000000000default
Params
:manfID 2
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie46μs16.41KB0000000000000286a0000000000000000default
Params
:kOberKategorie 207
SELECT ssMerkmal.nSterne, COUNT(*) AS nAnzahl FROM (SELECT ROUND(tartikelext.fDurchschnittsBewertung, 0) AS nSterne, tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #JOIN from JTL\Filter\Items\Rating::getSQLJoin JOIN tartikelext ON tartikel.kArtikel = tartikelext.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName ) AS ssMerkmal GROUP BY ssMerkmal.nSterne ORDER BY ssMerkmal.nSterne DESC142μs16.05KB000000000000028780000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB0000000000000285a0000000000000000default
Params
:kOberKategorie 207
SELECT kKategorie FROM tkategoriesichtbarkeit19μs16.02KB000000000000028720000000000000000default
SELECT tseo.cSeo, ssMerkmal.kKategorie, ssMerkmal.cName, ssMerkmal.nSort, COUNT(*) AS nAnzahl FROM (SELECT tkategorie.kKategorie, tkategorie.nSort, tkategorie.cName FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join4 from JTL\Filter\Items\Category::getOptions JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tkategorie.kKategorie, tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName ) AS ssMerkmal LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kKategorie AND tseo.cKey = 'kKategorie' AND tseo.kSprache = :lid GROUP BY ssMerkmal.kKategorie ORDER BY ssMerkmal.nSort, ssMerkmal.cName164μs17.64KB1000000000000287d0000000000000000default
Params
:lid 1
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL144μs18.39KB100000000000028830000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort136μs17KB000000000000028830000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?39μs16.87KB0000000000000288d0000000000000000default
Params
0 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB000000000000028750000000000000000default
Params
:kOberKategorie 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000028930000000000000000default
Params
:kOberKategorie 207
SELECT MAX(ssMerkmal.fMax) AS fMax, MIN(ssMerkmal.fMin) AS fMin FROM (SELECT ROUND( LEAST( (tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19.00) / 100), 2) AS fMax, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0.00) / 100), 2) AS fMin FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join1 from JTL\Filter\Items\PriceRange::getSQLJoin JOIN (tpreis #subjoin for tpreis table JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tartikel.kArtikel = tpreis.kArtikel AND tpreis.kKundengruppe = 1 #join2 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel #join3 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) #join4 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = 1 #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName ) AS ssMerkmal266μs16.06KB1000000000000289b0000000000000000default
SELECT SUM(ssMerkmal.anz0) AS anz0, SUM(ssMerkmal.anz1) AS anz1, SUM(ssMerkmal.anz2) AS anz2, SUM(ssMerkmal.anz3) AS anz3 FROM (SELECT COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 700, tartikel.kArtikel, NULL)) AS anz0, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 750, tartikel.kArtikel, NULL)) AS anz1, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 800, tartikel.kArtikel, NULL)) AS anz2, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 850, tartikel.kArtikel, NULL)) AS anz3 FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = 1 #join1 from JTL\Filter\Items\PriceRange::getOptions JOIN (tpreis #subjoin for tpreis table JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tpreis.kArtikel = tartikel.kArtikel AND tpreis.kKundengruppe = 1 #join2 from JTL\Filter\Items\PriceRange::getOptions LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName ) AS ssMerkmal416μs16.23KB1000000000000289f0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie48μs16.41KB000000000000028820000000000000000default
Params
:kOberKategorie 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.41KB0000000000000289e0000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #bestseller JOIN from JTL\Filter\Items\SearchSpecial::getOptions JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND ROUND(tbestseller.fAnzahl) >= 10 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName92μs16.02KB0000000000000289f0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB000000000000028970000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #special offer JOIN1 from JTL\Filter\Items\SearchSpecial::getOptions JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel #special offer JOIN2 from JTL\Filter\Items\SearchSpecial::getOptions JOIN tsonderpreise ON tsonderpreise.kArtikelSonderpreis = tartikelsonderpreis.kArtikelSonderpreis #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) AND tsonderpreise.kKundengruppe = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName112μs16.02KB000000000000028980000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB000000000000028a20000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikel.cNeu = 'Y' AND DATE_SUB(NOW(), INTERVAL 31 DAY) < tartikel.dErstellt AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName93μs16.02KB0000000000000288f0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB000000000000028a20000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikel.cTopArtikel = 'Y' AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName75μs16.02KB000000000000028a50000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.41KB000000000000028ad0000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND NOW() < tartikel.dErscheinungsdatum AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName73μs16.02KB000000000000028900000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie43μs16.41KB000000000000028b20000000000000000default
Params
:kOberKategorie 207
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #top reviews JOIN from JTL\Filter\Items\SearchSpecial::getOptions JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND ROUND(tartikelext.fDurchschnittsBewertung) >= 3 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName89μs16.02KB000000000000028b10000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB000000000000028ad0000000000000000default
Params
:kOberKategorie 207
SELECT ssMerkmal.filterval, COUNT(*) AS nAnzahl FROM (SELECT 1 AS filterval FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel ) AS ssMerkmal GROUP BY ssMerkmal.filterval ORDER BY ssMerkmal.filterval ASC126μs16.06KB100000000000028b80000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie30μs16.41KB000000000000028ad0000000000000000default
Params
:kOberKategorie 207
SELECT ssMerkmal.cSeo, ssMerkmal.kMerkmal, ssMerkmal.kMerkmalWert, ssMerkmal.cMMWBildPfad, ssMerkmal.nMehrfachauswahl, ssMerkmal.cWert, ssMerkmal.cName, ssMerkmal.cTyp, ssMerkmal.cMMBildPfad, COUNT(DISTINCT ssMerkmal.kArtikel) AS nAnzahl FROM (SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.cSeo, tmerkmal.cName, tartikel.kArtikel AS kArtikel, tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert, tmerkmalwert.cBildPfad AS cMMWBildPfad, tmerkmal.nSort AS nSortMerkmal, tmerkmalwert.nSort, tmerkmal.cTyp, tmerkmal.nMehrfachauswahl, tmerkmal.cBildPfad AS cMMBildPfad FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join1 from JTL\Filter\Items\Characteristic::getState JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join2 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert #join4 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal #join default lang from JTL\Filter\Items\Characteristic::getState INNER JOIN tmerkmalwertsprache ON tmerkmalwertsprache.kMerkmalWert = tartikelmerkmal.kMerkmalWert AND tmerkmalwertsprache.kSprache = 1 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 ) AS ssMerkmal GROUP BY ssMerkmal.kMerkmalWert ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert203μs16.25KB000000000000028a50000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section1.54ms17.52KB5600000000000028cc0000000000000000default
Params
:section 5
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section1.18ms17.39KB5100000000000029060000000000000000default
Params
:section 4
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section314μs16.83KB2000000000000028d10000000000000000default
Params
:section 8
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section66μs16.64KB700000000000028e70000000000000000default
Params
:section 112
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section157μs16.77KB1500000000000028de0000000000000000default
Params
:section 107
SELECT cBrocken FROM tbrocken LIMIT 121μs16.04KB100000000000028d10000000000000000default
SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid29μs16.22KB100000000000028d60000000000000000default
Params
:pid 1558
SELECT tartikel.kArtikel, tartikel.kHersteller, tartikel.kLieferstatus, tartikel.kSteuerklasse, tartikel.kEinheit, tartikel.kVPEEinheit, tartikel.kVersandklasse, tartikel.kEigenschaftKombi, tartikel.kVaterArtikel, tartikel.kStueckliste, tartikel.kWarengruppe, tartikel.cArtNr, tartikel.cName, tartikel.cBeschreibung, tartikel.cAnmerkung, tartikel.fLagerbestand, tartikel.fMwSt, tartikel.cSeo AS originalSeo, IF (tartikelabnahme.fMindestabnahme IS NOT NULL, tartikelabnahme.fMindestabnahme, tartikel.fMindestbestellmenge) AS fMindestbestellmenge, IF (tartikelabnahme.fIntervall IS NOT NULL, tartikelabnahme.fIntervall, tartikel.fAbnahmeintervall) AS fAbnahmeintervall, tartikel.cBarcode, tartikel.cTopArtikel, tartikel.fGewicht, tartikel.fArtikelgewicht, tartikel.cNeu, tartikel.cKurzBeschreibung, tartikel.fUVP, tartikel.cLagerBeachten, tartikel.cLagerKleinerNull, tartikel.cLagerVariation, tartikel.cTeilbar, tartikel.fPackeinheit, tartikel.cVPE, tartikel.fVPEWert, tartikel.cVPEEinheit, tartikel.cSuchbegriffe, tartikel.nSort, tartikel.dErscheinungsdatum, tartikel.dErstellt, tartikel.dLetzteAktualisierung, tartikel.cSerie, tartikel.cISBN, tartikel.cASIN, tartikel.cHAN, tartikel.cUNNummer, tartikel.cGefahrnr, tartikel.nIstVater, date_format(tartikel.dErscheinungsdatum, '%d.%m.%Y') AS Erscheinungsdatum_de, tartikel.cTaric, tartikel.cUPC, tartikel.cHerkunftsland, tartikel.cEPID, tartikel.fZulauf, tartikel.dZulaufDatum, DATE_FORMAT(tartikel.dZulaufDatum, '%d.%m.%Y') AS dZulaufDatum_de, tartikel.fLieferantenlagerbestand, tartikel.fLieferzeit, tartikel.dMHD, DATE_FORMAT(tartikel.dMHD, '%d.%m.%Y') AS dMHD_de, tartikel.kMassEinheit, tartikel.kGrundPreisEinheit, tartikel.fMassMenge, tartikel.fGrundpreisMenge, tartikel.fBreite, tartikel.fHoehe, tartikel.fLaenge, tartikel.nLiefertageWennAusverkauft, tartikel.nAutomatischeLiefertageberechnung, tartikel.nBearbeitungszeit, me.cCode AS cMasseinheitCode, mes.cName AS cMasseinheitName, gpme.cCode AS cGrundpreisEinheitCode, gpmes.cName AS cGrundpreisEinheitName, tseo.cSeo, tsonderpreise.fNettoPreis, tartikelext.fDurchschnittsBewertung, tlieferstatus.cName AS cName_tlieferstatus, teinheit.cName AS teinheitcName, tartikelsonderpreis.cAktiv AS cAktivSonderpreis, tartikelsonderpreis.dStart AS dStart_en, DATE_FORMAT(tartikelsonderpreis.dStart, '%d.%m.%Y') AS dStart_de, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de, tversandklasse.cName AS cVersandklasse, round(tbestseller.fAnzahl) >= :bsms AS bIsBestseller, round(tartikelext.fDurchschnittsBewertung) >= :trmr AS bIsTopBewertet FROM tartikel LEFT JOIN tartikelabnahme ON tartikel.kArtikel = tartikelabnahme.kArtikel AND tartikelabnahme.kKundengruppe = :cgid LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kArtikel' AND tseo.kKey = tartikel.kArtikel AND tseo.kSprache = :lid LEFT JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel LEFT JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel LEFT JOIN tlieferstatus ON tlieferstatus.kLieferstatus = tartikel.kLieferstatus AND tlieferstatus.kSprache = :lid LEFT JOIN teinheit ON teinheit.kEinheit = tartikel.kEinheit AND teinheit.kSprache = :lid LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid LEFT JOIN tversandklasse ON tversandklasse.kVersandklasse = tartikel.kVersandklasse LEFT JOIN tmasseinheit me ON me.kMassEinheit = tartikel.kMassEinheit LEFT JOIN tmasseinheitsprache mes ON mes.kMassEinheit = me.kMassEinheit AND mes.kSprache = :lid LEFT JOIN tmasseinheit gpme ON gpme.kMassEinheit = tartikel.kGrundpreisEinheit LEFT JOIN tmasseinheitsprache gpmes ON gpmes.kMassEinheit = gpme.kMassEinheit AND gpmes.kSprache = :lid WHERE tartikel.kArtikel = :pid AND tartikelsichtbarkeit.kArtikel IS NULL354μs42.52KB100000000000028da0000000000000000default
Params
:lid 1
:cgid 1
:pid 1558
:bsms 10
:trmr 3
SELECT * FROM ttrennzeichen WHERE `nEinheit`=? AND `kSprache`=?42μs16.79KB100000000000028da0000000000000000default
Params
0 1
1 1
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = therstellersprache.kSprache WHERE thersteller.kHersteller = :manfID AND thersteller.nAktiv = 1 GROUP BY kSprache, thersteller.kHersteller228μs17.41KB600000000000028ec0000000000000000default
Params
:manfID 2
SELECT kSuchspecialOverlay FROM tsuchspecialoverlay39μs16.18KB900000000000028ec0000000000000000default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 186μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 1
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 148μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 2
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 139μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 3
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 137μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 4
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 5
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 6
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 7
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 134μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 8
:templateName BALTER
:defaultTemplate default
SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB100000000000028ec0000000000000000default
Params
:languageID 1
:overlayID 9
:templateName BALTER
:defaultTemplate default
SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid34μs16.25KB100000000000028f20000000000000000default
Params
:pid 1558
:cgid 1
SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid23μs16.19KB100000000000028f20000000000000000default
Params
:pid 1558
SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb32μs16.25KB100000000000028f20000000000000000default
Params
:priceID 3667
SELECT tsonderpreise.fNettoPreis, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de FROM tsonderpreise JOIN tartikel ON tartikel.kArtikel = :productID JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tartikelsonderpreis.kArtikel = :productID AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= CURDATE() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) WHERE tsonderpreise.kKundengruppe = :customerGroup78μs17.08KB000000000000029370000000000000000default
Params
:productID 1558
:customerGroup 1
SELECT tartikel.kArtikel, tartikel.nIstVater, COALESCE(teigenschaft.kArtikel, 0) AS kArtikelVariation, tartikel.kSteuerklasse, tartikel.fLagerbestand, tartikel.fStandardpreisNetto fNettoPreis, tartikelkonfiggruppe.kKonfiggruppe g1, tkonfigitem.kKonfiggruppe g2 FROM tartikel LEFT JOIN tartikelkonfiggruppe ON tartikelkonfiggruppe.kArtikel = tartikel.kArtikel LEFT JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe LEFT JOIN teigenschaft ON teigenschaft.kArtikel = tartikel.kArtikel WHERE tartikel.kArtikel = :pid66μs16.95KB100000000000029430000000000000000default
Params
:pid 1558
SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut27μs16.17KB0000000000000293e0000000000000000default
Params
:kArtikel 1558
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort26μs16.25KB0000000000000293e0000000000000000default
Params
:kArtikel 1558
SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr28μs16.25KB1000000000000293e0000000000000000default
Params
:pid 1558
SELECT tartikelwarenlager.* FROM tartikelwarenlager JOIN twarenlager ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1 WHERE tartikelwarenlager.kArtikel = :productID39μs16.44KB0000000000000294e0000000000000000default
Params
:productID 1558
SELECT tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert FROM tartikelmerkmal JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert WHERE tartikelmerkmal.kArtikel = :kArtikel ORDER BY tmerkmal.nSort, tmerkmalwert.nSort, tartikelmerkmal.kMerkmal54μs16.55KB0000000000000294e0000000000000000default
Params
:kArtikel 1558
SELECT tkategorieartikel.kKategorie FROM tkategorieartikel LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorieartikel.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie WHERE tkategoriesichtbarkeit.kKategorie IS NULL AND tkategorieartikel.kKategorie > 0 AND tkategorieartikel.kArtikel = :pid60μs16.66KB1000000000000295e0000000000000000default
Params
:cgid 1
:pid 1558
SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar, teigenschaft.cTyp, teigenschaft.nSort, teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert, teigenschaftwert.fAufpreisNetto, teigenschaftwert.fGewichtDiff, teigenschaftwert.cArtNr, teigenschaftwert.nSort AS teigenschaftwert_nSort, teigenschaftwert.fLagerbestand, teigenschaftwert.fPackeinheit, teigenschaftwertpict.kEigenschaftWertPict, teigenschaftwertpict.cPfad, teigenschaftwertpict.cType, teigenschaftwertaufpreis.fAufpreisNetto AS fAufpreisNetto_teigenschaftwertaufpreis FROM teigenschaft LEFT JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft LEFT JOIN teigenschaftsichtbarkeit ON teigenschaft.kEigenschaft = teigenschaftsichtbarkeit.kEigenschaft AND teigenschaftsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertsichtbarkeit ON teigenschaftwert.kEigenschaftWert = teigenschaftwertsichtbarkeit.kEigenschaftWert AND teigenschaftwertsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertpict ON teigenschaftwertpict.kEigenschaftWert = teigenschaftwert.kEigenschaftWert LEFT JOIN teigenschaftwertaufpreis ON teigenschaftwertaufpreis.kEigenschaftWert = teigenschaftwert.kEigenschaftWert AND teigenschaftwertaufpreis.kKundengruppe = :cgid WHERE teigenschaft.kArtikel = :pid AND teigenschaftsichtbarkeit.kEigenschaft IS NULL AND teigenschaftwertsichtbarkeit.kEigenschaftWert IS NULL ORDER BY teigenschaft.nSort ASC, teigenschaft.cName, teigenschaftwert.nSort ASC, teigenschaftwert.cName116μs19.03KB000000000000029630000000000000000default
Params
:pid 1558
:cgid 1
SELECT * FROM tversandart38μs16.47KB2000000000000294e0000000000000000default
SELECT * FROM tversandart WHERE fVersandkostenfreiAbX > 0 AND (cVersandklassen = '-1' OR cVersandklassen RLIKE :sClasses) AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)60μs16.81KB0000000000000294e0000000000000000default
Params
:sClasses ^([0-9 -]* )?1
:cGroupID 1
SELECT va.kVersandart, IF(vas.fPreis IS NOT NULL, vas.fPreis, va.fPreis) AS minPrice, va.nSort FROM tversandart va LEFT JOIN tversandartstaffel vas ON vas.kVersandart = va.kVersandart WHERE cIgnoreShippingProposal != 'Y' AND va.cLaender LIKE :ccode AND (va.cVersandklassen = '-1' OR va.cVersandklassen RLIKE :sclass) AND (va.cKundengruppen = '-1' OR FIND_IN_SET(:cgid, REPLACE(va.cKundengruppen, ';', ',')) > 0) AND va.kVersandart NOT IN ( SELECT vaza.kVersandart FROM tversandartzahlungsart vaza WHERE kZahlungsart = 6) AND ( va.kVersandberechnung = 1 OR va.kVersandberechnung = 4 OR ( va.kVersandberechnung = 2 AND vas.fBis > 0 AND :wght <= vas.fBis ) OR ( va.kVersandberechnung = 3 AND vas.fBis = ( SELECT MIN(fBis) FROM tversandartstaffel WHERE fBis > :net AND tversandartstaffel.kVersandart = va.kVersandart ) ) ) AND va.cNurAbhaengigeVersandart = 'N' ORDER BY minPrice, nSort ASC LIMIT 1178μs17.58KB0000000000000296f0000000000000000default
Params
:ccode %DE%
:cgid 1
:sclass ^([0-9 -]* )?1
:wght 0
:net 680
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache32μs16.08KB000000000000029770000000000000000default
SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id40μs16.22KB1000000000000296f0000000000000000default
Params
:key kArtikel
:id 1558
SELECT COUNT(kArtikel) AS cnt FROM tartikelkategorierabatt WHERE kKundengruppe = :cgid23μs16.2KB1000000000000296f0000000000000000default
Params
:cgid 1
SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid25μs16.22KB100000000000029820000000000000000default
Params
:pid 1559
SELECT tartikel.kArtikel, tartikel.kHersteller, tartikel.kLieferstatus, tartikel.kSteuerklasse, tartikel.kEinheit, tartikel.kVPEEinheit, tartikel.kVersandklasse, tartikel.kEigenschaftKombi, tartikel.kVaterArtikel, tartikel.kStueckliste, tartikel.kWarengruppe, tartikel.cArtNr, tartikel.cName, tartikel.cBeschreibung, tartikel.cAnmerkung, tartikel.fLagerbestand, tartikel.fMwSt, tartikel.cSeo AS originalSeo, IF (tartikelabnahme.fMindestabnahme IS NOT NULL, tartikelabnahme.fMindestabnahme, tartikel.fMindestbestellmenge) AS fMindestbestellmenge, IF (tartikelabnahme.fIntervall IS NOT NULL, tartikelabnahme.fIntervall, tartikel.fAbnahmeintervall) AS fAbnahmeintervall, tartikel.cBarcode, tartikel.cTopArtikel, tartikel.fGewicht, tartikel.fArtikelgewicht, tartikel.cNeu, tartikel.cKurzBeschreibung, tartikel.fUVP, tartikel.cLagerBeachten, tartikel.cLagerKleinerNull, tartikel.cLagerVariation, tartikel.cTeilbar, tartikel.fPackeinheit, tartikel.cVPE, tartikel.fVPEWert, tartikel.cVPEEinheit, tartikel.cSuchbegriffe, tartikel.nSort, tartikel.dErscheinungsdatum, tartikel.dErstellt, tartikel.dLetzteAktualisierung, tartikel.cSerie, tartikel.cISBN, tartikel.cASIN, tartikel.cHAN, tartikel.cUNNummer, tartikel.cGefahrnr, tartikel.nIstVater, date_format(tartikel.dErscheinungsdatum, '%d.%m.%Y') AS Erscheinungsdatum_de, tartikel.cTaric, tartikel.cUPC, tartikel.cHerkunftsland, tartikel.cEPID, tartikel.fZulauf, tartikel.dZulaufDatum, DATE_FORMAT(tartikel.dZulaufDatum, '%d.%m.%Y') AS dZulaufDatum_de, tartikel.fLieferantenlagerbestand, tartikel.fLieferzeit, tartikel.dMHD, DATE_FORMAT(tartikel.dMHD, '%d.%m.%Y') AS dMHD_de, tartikel.kMassEinheit, tartikel.kGrundPreisEinheit, tartikel.fMassMenge, tartikel.fGrundpreisMenge, tartikel.fBreite, tartikel.fHoehe, tartikel.fLaenge, tartikel.nLiefertageWennAusverkauft, tartikel.nAutomatischeLiefertageberechnung, tartikel.nBearbeitungszeit, me.cCode AS cMasseinheitCode, mes.cName AS cMasseinheitName, gpme.cCode AS cGrundpreisEinheitCode, gpmes.cName AS cGrundpreisEinheitName, tseo.cSeo, tsonderpreise.fNettoPreis, tartikelext.fDurchschnittsBewertung, tlieferstatus.cName AS cName_tlieferstatus, teinheit.cName AS teinheitcName, tartikelsonderpreis.cAktiv AS cAktivSonderpreis, tartikelsonderpreis.dStart AS dStart_en, DATE_FORMAT(tartikelsonderpreis.dStart, '%d.%m.%Y') AS dStart_de, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de, tversandklasse.cName AS cVersandklasse, round(tbestseller.fAnzahl) >= :bsms AS bIsBestseller, round(tartikelext.fDurchschnittsBewertung) >= :trmr AS bIsTopBewertet FROM tartikel LEFT JOIN tartikelabnahme ON tartikel.kArtikel = tartikelabnahme.kArtikel AND tartikelabnahme.kKundengruppe = :cgid LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kArtikel' AND tseo.kKey = tartikel.kArtikel AND tseo.kSprache = :lid LEFT JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel LEFT JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel LEFT JOIN tlieferstatus ON tlieferstatus.kLieferstatus = tartikel.kLieferstatus AND tlieferstatus.kSprache = :lid LEFT JOIN teinheit ON teinheit.kEinheit = tartikel.kEinheit AND teinheit.kSprache = :lid LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid LEFT JOIN tversandklasse ON tversandklasse.kVersandklasse = tartikel.kVersandklasse LEFT JOIN tmasseinheit me ON me.kMassEinheit = tartikel.kMassEinheit LEFT JOIN tmasseinheitsprache mes ON mes.kMassEinheit = me.kMassEinheit AND mes.kSprache = :lid LEFT JOIN tmasseinheit gpme ON gpme.kMassEinheit = tartikel.kGrundpreisEinheit LEFT JOIN tmasseinheitsprache gpmes ON gpmes.kMassEinheit = gpme.kMassEinheit AND gpmes.kSprache = :lid WHERE tartikel.kArtikel = :pid AND tartikelsichtbarkeit.kArtikel IS NULL326μs42.52KB100000000000029860000000000000000default
Params
:lid 1
:cgid 1
:pid 1559
:bsms 10
:trmr 3
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = therstellersprache.kSprache WHERE thersteller.kHersteller = :manfID AND thersteller.nAktiv = 1 GROUP BY kSprache, thersteller.kHersteller216μs17.41KB6000000000000298e0000000000000000default
Params
:manfID 2
SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid53μs16.25KB100000000000029940000000000000000default
Params
:pid 1559
:cgid 1
SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid26μs16.19KB100000000000029940000000000000000default
Params
:pid 1559
SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb34μs16.25KB100000000000029940000000000000000default
Params
:priceID 3670
SELECT tsonderpreise.fNettoPreis, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de FROM tsonderpreise JOIN tartikel ON tartikel.kArtikel = :productID JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tartikelsonderpreis.kArtikel = :productID AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= CURDATE() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) WHERE tsonderpreise.kKundengruppe = :customerGroup77μs17.08KB000000000000029920000000000000000default
Params
:productID 1559
:customerGroup 1
SELECT tartikel.kArtikel, tartikel.nIstVater, COALESCE(teigenschaft.kArtikel, 0) AS kArtikelVariation, tartikel.kSteuerklasse, tartikel.fLagerbestand, tartikel.fStandardpreisNetto fNettoPreis, tartikelkonfiggruppe.kKonfiggruppe g1, tkonfigitem.kKonfiggruppe g2 FROM tartikel LEFT JOIN tartikelkonfiggruppe ON tartikelkonfiggruppe.kArtikel = tartikel.kArtikel LEFT JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe LEFT JOIN teigenschaft ON teigenschaft.kArtikel = tartikel.kArtikel WHERE tartikel.kArtikel = :pid63μs16.95KB100000000000029a30000000000000000default
Params
:pid 1559
SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut26μs16.17KB0000000000000299e0000000000000000default
Params
:kArtikel 1559
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort27μs16.25KB0000000000000299e0000000000000000default
Params
:kArtikel 1559
SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr28μs16.25KB1000000000000299e0000000000000000default
Params
:pid 1559
SELECT tartikelwarenlager.* FROM tartikelwarenlager JOIN twarenlager ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1 WHERE tartikelwarenlager.kArtikel = :productID41μs16.44KB000000000000029ae0000000000000000default
Params
:productID 1559
SELECT tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert FROM tartikelmerkmal JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert WHERE tartikelmerkmal.kArtikel = :kArtikel ORDER BY tmerkmal.nSort, tmerkmalwert.nSort, tartikelmerkmal.kMerkmal54μs16.55KB000000000000029ae0000000000000000default
Params
:kArtikel 1559
SELECT tkategorieartikel.kKategorie FROM tkategorieartikel LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorieartikel.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie WHERE tkategoriesichtbarkeit.kKategorie IS NULL AND tkategorieartikel.kKategorie > 0 AND tkategorieartikel.kArtikel = :pid60μs16.66KB100000000000029be0000000000000000default
Params
:cgid 1
:pid 1559
SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar, teigenschaft.cTyp, teigenschaft.nSort, teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert, teigenschaftwert.fAufpreisNetto, teigenschaftwert.fGewichtDiff, teigenschaftwert.cArtNr, teigenschaftwert.nSort AS teigenschaftwert_nSort, teigenschaftwert.fLagerbestand, teigenschaftwert.fPackeinheit, teigenschaftwertpict.kEigenschaftWertPict, teigenschaftwertpict.cPfad, teigenschaftwertpict.cType, teigenschaftwertaufpreis.fAufpreisNetto AS fAufpreisNetto_teigenschaftwertaufpreis FROM teigenschaft LEFT JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft LEFT JOIN teigenschaftsichtbarkeit ON teigenschaft.kEigenschaft = teigenschaftsichtbarkeit.kEigenschaft AND teigenschaftsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertsichtbarkeit ON teigenschaftwert.kEigenschaftWert = teigenschaftwertsichtbarkeit.kEigenschaftWert AND teigenschaftwertsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertpict ON teigenschaftwertpict.kEigenschaftWert = teigenschaftwert.kEigenschaftWert LEFT JOIN teigenschaftwertaufpreis ON teigenschaftwertaufpreis.kEigenschaftWert = teigenschaftwert.kEigenschaftWert AND teigenschaftwertaufpreis.kKundengruppe = :cgid WHERE teigenschaft.kArtikel = :pid AND teigenschaftsichtbarkeit.kEigenschaft IS NULL AND teigenschaftwertsichtbarkeit.kEigenschaftWert IS NULL ORDER BY teigenschaft.nSort ASC, teigenschaft.cName, teigenschaftwert.nSort ASC, teigenschaftwert.cName140μs19.03KB000000000000029c30000000000000000default
Params
:pid 1559
:cgid 1
SELECT va.kVersandart, IF(vas.fPreis IS NOT NULL, vas.fPreis, va.fPreis) AS minPrice, va.nSort FROM tversandart va LEFT JOIN tversandartstaffel vas ON vas.kVersandart = va.kVersandart WHERE cIgnoreShippingProposal != 'Y' AND va.cLaender LIKE :ccode AND (va.cVersandklassen = '-1' OR va.cVersandklassen RLIKE :sclass) AND (va.cKundengruppen = '-1' OR FIND_IN_SET(:cgid, REPLACE(va.cKundengruppen, ';', ',')) > 0) AND va.kVersandart NOT IN ( SELECT vaza.kVersandart FROM tversandartzahlungsart vaza WHERE kZahlungsart = 6) AND ( va.kVersandberechnung = 1 OR va.kVersandberechnung = 4 OR ( va.kVersandberechnung = 2 AND vas.fBis > 0 AND :wght <= vas.fBis ) OR ( va.kVersandberechnung = 3 AND vas.fBis = ( SELECT MIN(fBis) FROM tversandartstaffel WHERE fBis > :net AND tversandartstaffel.kVersandart = va.kVersandart ) ) ) AND va.cNurAbhaengigeVersandart = 'N' ORDER BY minPrice, nSort ASC LIMIT 1177μs17.58KB000000000000029ae0000000000000000default
Params
:ccode %DE%
:cgid 1
:sclass ^([0-9 -]* )?1
:wght 0
:net 680
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache29μs16.08KB000000000000029ce0000000000000000default
SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id35μs16.22KB100000000000029ae0000000000000000default
Params
:key kArtikel
:id 1559
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section70μs16.59KB500000000000028bf0000000000000000default
Params
:section 121
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL138μs18.39KB1000000000000281c0000000000000000default
Params
:kid 112
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort142μs17KB0000000000000281c0000000000000000default
Params
:cid 112
SELECT * FROM tkategorie WHERE `kOberKategorie`=?56μs16.95KB500000000000029e60000000000000000default
Params
0 112
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL146μs18.39KB100000000000029e70000000000000000default
Params
:kid 108
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort130μs17KB000000000000029e70000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?46μs16.93KB400000000000029f00000000000000000default
Params
0 108
SELECT * FROM tfirma LIMIT 133μs16.52KB100000000000029eb0000000000000000default
SELECT * FROM tversandart WHERE cNurAbhaengigeVersandart = :depOnly AND cLaender LIKE :iso AND (cVersandklassen = '-1' OR cVersandklassen RLIKE :sClasses) AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0) ORDER BY nSort64μs16.88KB000000000000029f30000000000000000default
Params
:iso %DE%
:cGroupID 1
:sClasses ^([0-9 -]* )?
:depOnly Y
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = :skey AND tseo.kSprache = therstellersprache.kSprache WHERE EXISTS ( SELECT 1 FROM tartikel WHERE tartikel.kHersteller = thersteller.kHersteller AND NOT EXISTS ( SELECT 1 FROM tartikelsichtbarkeit WHERE tartikelsichtbarkeit.kArtikel = tartikel.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid ) ) GROUP BY thersteller.kHersteller, therstellersprache.kSprache ORDER BY thersteller.nSortNr, thersteller.cName658μs18KB1200000000000029f90000000000000000default
Params
:skey kHersteller
:cgid 1
SELECT child.kKategorie FROM tkategorie LEFT JOIN tkategorie parent ON tkategorie.kOberKategorie = parent.kKategorie LEFT JOIN tkategorie child ON tkategorie.lft <= child.lft AND tkategorie.rght >= child.rght WHERE tkategorie.kOberKategorie > 0 AND parent.kKategorie IS NULL113μs16.02KB00000000000002a090000000000000000default
SELECT * FROM tfirma LIMIT 132μs16.52KB10000000000002a1b0000000000000000default
SELECT type, bExtension, path, nVersion, cVerzeichnis, position, cName AS name FROM tplugin_resources AS res JOIN tplugin ON tplugin.kPlugin = res.kPlugin WHERE tplugin.nStatus = :state ORDER BY res.priority DESC87μs16.61KB30000000000002d620000000000000000default
Params
:state 2
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section63μs16.53KB10000000000002d7d0000000000000000default
Params
:section 125
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache24μs16.08KB00000000000002d860000000000000000default
SELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC223μs40.16KB4990000000000002d930000000000000000default
INSERT IGNORE INTO tbesucherarchiv (kBesucher, cIP, kKunde, kBestellung, cReferer, cEinstiegsseite, cBrowser, cAusstiegsseite, nBesuchsdauer, kBesucherBot, dZeit) SELECT kBesucher, cIP, kKunde, kBestellung, cReferer, cEinstiegsseite, cBrowser, cAusstiegsseite, (UNIX_TIMESTAMP(dLetzteAktivitaet) - UNIX_TIMESTAMP(dZeit)) AS nBesuchsdauer, kBesucherBot, dZeit FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)99μs688B00000000000002d920000000000000000default
Params
:interval 3
DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)61μs128B00000000000002d920000000000000000default
Params
:interval 3
SELECT * FROM tbesucher WHERE `cSessID`=?57μs16.93KB10000000000002d920000000000000000default
Params
0 as0mtdqs13mbuc1ipfogi1k8pg

Params
0	Y

Params
:section	1

Params
:kKundengruppe	1

Params
:state	2

Params
:section	7

Params
:ts	2025-04-27 11:03:33

Params
:nAktiv	1

Params
:state	2

Params
0	1

Params
0	d5c1f01a-9c07-4c8c-9677-cbb5f0a20304

Params
0	56fb166e-d504-438f-95a4-0df2a510884a

Params
:kPlugin	1

Params
:kPlugin	1

Params
:plgn	1

Params
:kVaterLink	108

Params
:kVaterLink	107

Params
:kVaterLink	105

Params
:kVaterLink	106

Params
:pid	1

Params
:pid	1

Params
:kPlugin	1

Params
:id	1

Params
:pid	kPlugin\_1\_%

Params
:val	kPlugin_1_paypalcheckout\_%

Params
:kZahlungsart	73

Params
:val	kPlugin_1_rechnungskaufmitratepay\_%

Params
:kZahlungsart	74

Params
:val	kPlugin_1_paypalkreditkarte\_%

Params
:kZahlungsart	75

Params
0	2

Params
:kPlugin	2

Params
:kPlugin	2

Params
:plgn	2

Params
:pid	2

Params
:pid	2

Params
:kPlugin	2

Params
:id	2

Params
:pid	kPlugin\_2\_%

Params
0	5

Params
0	d5c1f01a-9c07-4c8c-9677-cbb5f0a20304

Params
0	56fb166e-d504-438f-95a4-0df2a510884a

Params
:kPlugin	5

Params
:kPlugin	5

Params
:plgn	5

Params
:kVaterLink	434

Params
:kVaterLink	437

Params
:kVaterLink	432

Params
:kVaterLink	433

Params
:kVaterLink	439

UPDATE tbesucher SET `kBesucher`=?,`cIP`=?,`cSessID`=?,`cID`=?,`kKunde`=?,`kBestellung`=?,`cReferer`=?,`cUserAgent`=?,`cEinstiegsseite`=?,`cBrowser`=?,`cAusstiegsseite`=?,`kBesucherBot`=?,`dLetzteAktivitaet`=?,`dZeit`=? WHERE `kBesucher`=?

8.33ms2.28KB10000000000002d920000000000000000default

Params
0	129111
1	3.136.0.0
2	as0mtdqs13mbuc1ipfogi1k8pg
3	82f1a301f248867d4ce1e1796f382336
4	0
5	0
6
7	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
8	/Kabel-und-Stecker?availability=1
9	Sonstige
10	/Komplettsysteme_1?Sortierung=11
11	0
12	2025-04-27 11:08:14
13	2025-04-27 11:08:01
14	129111

SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv70μs16.38KB3000000000000090d0000000000000000default
Params
:nAktiv 1
SELECT cClass, kInitial FROM textensionpoint WHERE (kSprache = :lid OR kSprache = 0) AND (kKundengruppe = :cgid OR kKundengruppe = 0) AND (nSeite = :ptype OR nSeite = 0) AND ( (cKey = :cky AND (cValue = :cval OR cValue = '')) OR cValue = '')54μs16.42KB00000000000002f760000000000000000default
Params
:lid 1
:cgid 1
:ptype 2
:cky kKategorie
:cval 207
SELECT * FROM tboxenanzeige39μs17.58KB820000000000002f6c0000000000000000default
SELECT tboxen.kBox, tboxen.kBoxvorlage, tboxen.kCustomID, tboxen.kContainer, tboxen.cTitel, tboxen.ePosition, tboxensichtbar.kSeite, tboxensichtbar.nSort, tboxensichtbar.cFilter, tboxvorlage.eTyp, tboxvorlage.cVerfuegbar, tboxvorlage.cName, tboxvorlage.cTemplate, tplugin.nStatus AS pluginStatus, GROUP_CONCAT(tboxensichtbar.nSort) AS sortBypageIDs, GROUP_CONCAT(tboxensichtbar.kSeite) AS pageIDs, GROUP_CONCAT(tboxensichtbar.bAktiv) AS pageVisibilities, tsprache.kSprache, tboxsprache.cInhalt, tboxsprache.cTitel FROM tboxen LEFT JOIN tboxensichtbar ON tboxen.kBox = tboxensichtbar.kBox LEFT JOIN tplugin ON tboxen.kCustomID = tplugin.kPlugin LEFT JOIN tboxvorlage ON tboxen.kBoxvorlage = tboxvorlage.kBoxvorlage LEFT JOIN tboxsprache ON tboxsprache.kBox = tboxen.kBox LEFT JOIN tsprache ON tsprache.cISO = tboxsprache.cISO WHERE tboxen.kContainer > -1 AND FIND_IN_SET(tboxensichtbar.kSeite, "0,1,2,3,4,5,7,8,9,10,11,12,14,15,16,17,18,19,20,21,23,24,25,26,27,28,29,31,32,33,36,38,40,41,42") > 0 AND tboxen.ePosition IN ('left','bottom') AND (tplugin.nStatus = 2 OR tboxvorlage.eTyp IS NULL OR (tboxvorlage.eTyp != 'plugin' AND tboxvorlage.eTyp != 'extension')) GROUP BY tboxsprache.kBoxSprache, tboxen.kBox, tboxensichtbar.cFilter ORDER BY tboxensichtbar.nSort, tboxen.kBox ASC7.54ms97KB320000000000002ef00000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie81μs16.41KB00000000000002eed0000000000000000default
Params
:kOberKategorie 207
SELECT tsuchanfrage.cSuche FROM tsuchanfrage LEFT JOIN tsuchcache ON tsuchcache.cSuche = tsuchanfrage.cSuche WHERE tsuchanfrage.nAktiv = 1 AND tsuchcache.kSuchCache IS NULL ORDER BY tsuchanfrage.nAnzahlTreffer, tsuchanfrage.nAnzahlGesuche LIMIT 1069μs16.02KB00000000000002f1a0000000000000000default
SELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #JOIN1 from JTL\Filter\Items\Search::getOptions JOIN tsuchcachetreffer ON tartikel.kArtikel = tsuchcachetreffer.kArtikel #JOIN2 from JTL\Filter\Items\Search::getOptions JOIN tsuchcache ON tsuchcache.kSuchCache = tsuchcachetreffer.kSuchCache #JOIN3 from JTL\Filter\Items\Search::getOptions JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche AND tsuchanfrage.kSprache = 1 #join from SORT by bestseller LEFT JOIN tbestseller ON tartikel.kArtikel = tbestseller.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 207 AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tsuchanfrage.kSuchanfrage, tartikel.kArtikel #limit sql ORDER BY tbestseller.fAnzahl DESC, tartikel.cName) AS ssMerkmal GROUP BY ssMerkmal.kSuchanfrage ORDER BY ssMerkmal.cSuche189μs16.09KB00000000000002f1a0000000000000000default
SELECT tartikel.kArtikel FROM tartikel JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel JOIN tsonderpreise ON tsonderpreise.kArtikelSonderpreis = tartikelsonderpreis.kArtikelSonderpreis LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid WHERE tartikelsichtbarkeit.kArtikel IS NULL AND tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tsonderpreise.kKundengruppe = :cgid AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) AND tartikel.kVaterArtikel = 0 LIMIT :lmt107μs17.27KB00000000000002eff0000000000000000default
Params
:lmt 10
:cgid 1
SELECT kPlugin, cPluginID, bExtension FROM tplugin34μs16.17KB60000000000002ee50000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?39μs17.2KB10000000000002edc0000000000000000default
Params
0 1
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 135μs16.11KB10000000000002f3d0000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?36μs17.25KB20000000000002f550000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?26μs17.22KB00000000000002f600000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort42μs16.34KB60000000000002ed10000000000000000default
Params
:kPlugin 1
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin26μs16.3KB40000000000002f450000000000000000default
Params
:kPlugin 1
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink87μs16.46KB40000000000002f5a0000000000000000default
Params
:plgn 1
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)35μs16.14KB40000000000002f020000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (105,106,107,108) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName511μs17KB80000000000002f3d0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink53μs16.12KB00000000000002f650000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB00000000000002f690000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB00000000000002ec60000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002ec10000000000000000default
Params
:kVaterLink 106
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort511μs17.34KB90000000000002f110000000000000000default
Params
:pid 1
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable318μs34.06KB780000000000002f430000000000000000default
Params
:pid 1
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin50μs16.34KB00000000000002e750000000000000000default
Params
:kPlugin 1
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id73μs16.78KB40000000000002e7a0000000000000000default
Params
:id 1
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid66μs16.98KB30000000000002e810000000000000000default
Params
:pid kPlugin\_1\_%
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort48μs16.55KB30000000000002e810000000000000000default
Params
:val kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart31μs16.28KB20000000000002e810000000000000000default
Params
:kZahlungsart 73
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort37μs16.55KB30000000000002e810000000000000000default
Params
:val kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart22μs16.28KB20000000000002e810000000000000000default
Params
:kZahlungsart 74
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort32μs16.55KB30000000000002e810000000000000000default
Params
:val kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart20μs16.28KB20000000000002e810000000000000000default
Params
:kZahlungsart 75
SELECT kPlugin, cPluginID, bExtension FROM tplugin23μs16.17KB60000000000002ee20000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?32μs17.2KB10000000000002e880000000000000000default
Params
0 2
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort30μs16.27KB10000000000002ebc0000000000000000default
Params
:kPlugin 2
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin22μs16.24KB00000000000002e4c0000000000000000default
Params
:kPlugin 2
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink62μs16.4KB00000000000002f400000000000000000default
Params
:plgn 2
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort152μs17.19KB00000000000002e460000000000000000default
Params
:pid 2
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable199μs17.13KB180000000000002e3f0000000000000000default
Params
:pid 2
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin50μs16.34KB00000000000002e2a0000000000000000default
Params
:kPlugin 2
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id58μs16.72KB00000000000002e2f0000000000000000default
Params
:id 2
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid51μs16.94KB00000000000002e330000000000000000default
Params
:pid kPlugin\_2\_%
SELECT kPlugin, cPluginID, bExtension FROM tplugin22μs16.17KB60000000000002ee00000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?31μs17.2KB10000000000002e390000000000000000default
Params
0 5
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 129μs16.11KB10000000000002e080000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?32μs17.25KB20000000000002de40000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?25μs17.22KB00000000000002dd30000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort36μs16.34KB60000000000002e170000000000000000default
Params
:kPlugin 5
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin22μs16.37KB80000000000002e140000000000000000default
Params
:kPlugin 5
SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink79μs16.52KB80000000000002dda0000000000000000default
Params
:plgn 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)36μs16.2KB80000000000002df90000000000000000default
SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName541μs17.13KB160000000000002dcb0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB00000000000002db60000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB00000000000002db10000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB00000000000002dac0000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002da70000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002da20000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002d9d0000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002d980000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002f8a0000000000000000default
Params
:kVaterLink 438
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort160μs17.19KB00000000000002df60000000000000000default
Params
:pid 5
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO, COALESCE(c.cName, o.cName) AS customValue, l.type FROM tpluginsprachvariable AS l JOIN tpluginsprachvariablesprache AS o ON o.kPluginSprachvariable = l.kPluginSprachvariable LEFT JOIN tpluginsprachvariablecustomsprache AS c ON c.kPluginSprachvariable = l.kPluginSprachvariable AND o.cISO = c.cISO WHERE l.kPlugin = :pid ORDER BY l.kPluginSprachvariable166μs16.84KB20000000000002dd60000000000000000default
Params
:pid 5
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin47μs16.34KB00000000000002dba0000000000000000default
Params
:kPlugin 5
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id55μs16.72KB00000000000002dc00000000000000000default
Params
:id 5
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid50μs16.94KB00000000000002dc40000000000000000default
Params
:pid kPlugin\_5\_%
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL157μs18.39KB10000000000002fa20000000000000000default
Params
:kid 207
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort141μs17KB00000000000002fa20000000000000000default
Params
:cid 207
SELECT * FROM tkategorie WHERE `kOberKategorie`=?49μs16.87KB00000000000002fac0000000000000000default
Params
0 207
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL148μs18.39KB10000000000002fac0000000000000000default
Params
:kid 112
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort129μs17KB00000000000002fac0000000000000000default
Params
:cid 112
SELECT * FROM tkategorie WHERE `kOberKategorie`=?50μs16.95KB50000000000002fb60000000000000000default
Params
0 112
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL133μs18.39KB10000000000002fb70000000000000000default
Params
:kid 108
:cgid 1
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort127μs17KB00000000000002fb70000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.93KB40000000000002fc00000000000000000default
Params
0 108

global: array:53 [ "systemlog_flag" => 330 "admin_login_logger_mode" => array:1 [ 0 => "1" ] "re...
startseite: array:8 [ "startseite_neuimsortiment_anzahl" => 0 "startseite_neuimsortiment_sortnr" => 1 "sta...
emails: array:10 [ "email_methode" => "mail" "email_sendmail_pfad" => "" "email_smtp_hostname" => "" ...
artikeluebersicht: array:51 [ "suche_fulltext" => "N" "suche_prio_name" => 10 "suche_prio_suchbegriffe" => 9 "s...
artikeldetails: array:56 [ "artikeldetails_xselling_standard_anzeigen" => "Y" "artikeldetails_xselling_kauf_anze...
kunden: array:40 [ "configgroup_6_forgot_password" => "Passwort vergessen" "kundenregistrierung_abfragen...
logo: array:1 [ "shop_logo" => "logo.png" ]
kaufabwicklung: array:27 [ "warenkorb_warenkorb2pers_merge" => "P" "warenkorbpers_nutzen" => "Y" "bestellvorga...
boxen: array:20 [ "box_bestseller_anzahl_anzeige" => 3 "box_bestseller_anzahl_basis" => 10 "box_sonde...
bilder: array:91 [ "bilder_hintergrundfarbe" => "#ffffff" "bilder_dateiformat" => "AUTO" "container_ve...
sonstiges: array:5 [ "sonstiges_gratisgeschenk_nutzen" => "Y" "sonstiges_gratisgeschenk_anzahl" => 10 "so...
zahlungsarten: array:15 [ "zahlungsart_lastschrift_max" => "0" "zahlungsart_lastschrift_min" => "0" "zahlungs...
kontakt: array:10 [ "kontakt_abfragen_anrede" => "N" "kontakt_abfragen_vorname" => "O" "kontakt_abfrage...
rss: array:10 [ "rss_bewertungen_beachten" => "Y" "rss_news_beachten" => "Y" "rss_wawiabgleich" => ...
vergleichsliste: array:14 [ "vergleichsliste_anzahl" => 10 "vergleichsliste_artikelnummer" => 0 "vergleichslist...
preisverlauf: array:2 [ "preisverlauf_anzeigen" => "N" "preisverlauf_anzahl_monate" => 0 ]
bewertung: array:15 [ "bewertungserinnerung_kundengruppen" => array:1 [ 0 => "" ] "bewertung_anzeigen...
newsletter: array:15 [ "newsletter_active" => "N" "newsletter_emailmethode" => "mail" "newsletter_sendmail...
kundenfeld: array:1 [ "kundenfeld_anzeigen" => "Y" ]
navigationsfilter: array:32 [ "configgroup_110_manufacturer_filter" => "Herstellerfilter" "configgroup_110_availabi...
emailblacklist: array:1 [ "blacklist_benutzen" => "N" ]
metaangaben: array:7 [ "global_meta_publisher" => "" "global_meta_copyright" => "" "global_meta_title_anhae...
news: array:10 [ "news_benutzen" => "Y" "news_kommentare_nutzen" => "Y" "news_anzahl_uebersicht" => ...
sitemap: array:18 [ "sitemap_google_ping" => "N" "sitemap_seiten_anzeigen" => "Y" "sitemap_kategorien_a...
suchspecials: array:6 [ "suchspecials_sortierung_inkuerzeverfuegbar" => "-1" "suchspecials_sortierung_topangeb...
auswahlassistent: array:5 [ "auswahlassistent_allefragen" => "Y" "auswahlassistent_anzahl_anzeigen" => "Y" "ausw...
cron: array:3 [ "cron_freq" => 10 "cron_type" => "s2s" "configgroup_128_cron" => "Cron" ]
fs: array:18 [ "ftp_header" => "FTP Verbindung" "fs_general_header" => "General" "sftp_header" => ...
caching: array:17 [ "caching_types_disabled" => "" "configgroup_124_cache" => "Consent manager" "cachin...
consentmanager: array:3 [ "consent_manager_active" => "Y" "configgroup_129_consentmanager" => "Cache" "consent...
template: array:9 [ "colors" => array:9 [ "copyright-bg-color" => "" "footer-bg-color" => "" "fo...
branding: []

$_GET: array:1 [ "Sortierung" => "11" ]
$_POST: []
$_SESSION: array:33 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#2695 +k...
$_COOKIE: array:1 [ "JTLSHOP" => "as0mtdqs13mbuc1ipfogi1k8pg" ]
$_SERVER: array:62 [ "USER" => "jtlbalter" "HOME" => "/var/www/vhosts/k08.de" "SCRIPT_NAME" => "/index.p...

TracedStatement.php:39: {#12223 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataCollector\PDO\Trac...
TraceablePDOStatement.php:86: {#12220 +"level": 8192 +"message": "Use of "parent" in callables is deprecated" +"file": "/var...
DataFormatter.php:23: {#2906 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataFormatter\DataForma...
DataFormatter.php:24: {#2904 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataFormatter\DataForma...
Bootstrap.php:139: {#8095 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
Bootstrap.php:144: {#8365 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
ProductFilter.php:1662: {#10337 +"level": 2 +"message": "Attempt to read property "kKategorie" on null" +"file": "/var...
smarty_internal_debug.php:146: {#12489 +"level": 2 +"message": "Undefined array key "start_time"" +"file": "/var/www/vhosts/k...
smarty_internal_debug.php:73: {#12234 +"level": 2 +"message": "Undefined array key "start_template_time"" +"file": "/var/www...

tplDir: "/var/www/vhosts/k08.de/httpdocs/templates/BALTER/"
parentTemplateDir: null
newsletter_url: "https://www.k08.de/plugins/balter_custom/NewsletterHandler.php"
activated_categories: array:6 [ 0 => JTL\Catalog\Category\Kategorie {#7995 -parentID: 108 -sort: 0 -names: a...
submenu_items: array:4 [ 0 => JTL\Catalog\Category\Kategorie {#8018 -parentID: 0 -sort: 0 -names: arr...
categories_count: 4
activated_categories_count: 6
homeurl: "https://www.k08.de/Start"
coupon: 0.0
currentCoupon: null
cart: JTL\Cart\Cart {#2695 +kWarenkorb: null +kKunde: null +kLieferadresse: null +kZahlungsInfo: 0...
FavourableShipping: null
oNaviSeite_arr: array:2 [ "vor" => JTL\Filter\Pagination\Item {#10251 -page: 0 -url: null -isActive: f...
filterPagination: JTL\Filter\Pagination\Pagination {#8020 -pages: [] -prev: JTL\Filter\Pagination\Item {#10266 ...
oBestseller_arr: []
KategorieInhalt: null
NaviFilter: JTL\Filter\ProductFilter {#8039 -category: JTL\Filter\States\BaseCategory {#8034 #icon: null ...
priceRangeMax: 850.0
oErweiterteDarstellung: {#2319 +"cURL_arr": array:2 [ 1 => "https://www.k08.de/Komplettsysteme_1?ed=1" 2 => "https...
Suchergebnisse: JTL\Filter\SearchResults {#10336 -products: Illuminate\Support\Collection {#10441 #items: arra...
oNavigationsinfo: JTL\Filter\Metadata {#8037 -conf: array:32 [ "global" => array:53 [ "systemlog_flag" => ...
priceRange: null
nMaxAnzahlArtikel: 0
linkgroups: JTL\Link\LinkGroupCollection {#8359 #items: array:13 [ 0 => JTL\Link\LinkGroup {#9915 -n...
manufacturers: array:2 [ 2 => JTL\Catalog\Hersteller {#10765 -kHersteller: 2 -names: array:6 [ 1 =>...
oUnterKategorien_arr: []
session_name: "JTLSHOP"
session_id: "as0mtdqs13mbuc1ipfogi1k8pg"
NettoPreise: 0
KaufabwicklungsURL: "https://www.k08.de/Bestellvorgang"
WarenkorbArtikelPositionenanzahl: 0
WarenkorbWarensumme: array:2 [ 0 => "0,00 €" 1 => "0,00 €" ]
WarenkorbGesamtsumme: array:2 [ 0 => "0,00 €" 1 => "0,00 €" ]
WarenkorbGesamtgewicht: 0
Warenkorbtext: "Es befinden sich keine Artikel im Warenkorb."
zuletztInWarenkorbGelegterArtikel: null
WarenkorbVersandkostenfreiHinweis: ""
oSpezialseiten_arr: Illuminate\Support\Collection {#10793 #items: array:25 [ 5 => JTL\Link\Link {#9940 -data...
bAjaxRequest: false
jtl_token: "<input type="hidden" class="jtl_token" name="jtl_token" value="0eaa61f0705ee4d467750362b82d92719bff...
nSeitenTyp: 2
bExclusive: false
bAdminWartungsmodus: false
WarensummeLocalized: array:2 [ 0 => "0,00 €" 1 => "0,00 €" ]
Steuerpositionen: []
favourableShippingString: ""
Einstellungen: array:32 [ "global" => array:53 [ "systemlog_flag" => 330 "admin_login_logger_mode" => arr...
deletedPositions: []
updatedPositions: []
Firma: JTL\Firma {#10780 +cName: "Balter GmbH" +cUnternehmer: "" +cStrasse: "Elisabeth Selbert Str. 1...
showLoginCaptcha: false
AktuelleKategorie: JTL\Catalog\Category\Kategorie {#10274 -parentID: 112 -sort: 3 -names: array:1 [ 1 => "Kom...
cSessionID: "as0mtdqs13mbuc1ipfogi1k8pg"
opc: JTL\OPC\Service {#10767 #adminName: "" #db: JTL\OPC\DB {#10794 #mapping: [] #shopDB: JTL...
opcPageService: JTL\OPC\PageService {#11611 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#10767 #a...
wishlists: Illuminate\Support\Collection {#10773 #items: [] #escapeWhenCastingToString: false }
shippingCountry: "DE"
countries: Illuminate\Support\Collection {#9535 #items: array:236 [ 60 => JTL\Country\Country {#8700 ...
Link: JTL\Link\Link {#10715 -data: [] #id: 0 #level: 0 #parent: 0 #linkGroupID: -1 #pluginID: ...
cPluginCss_arr: array:2 [ 0 => "plugins/jtl_paypal_commerce/frontend/css/style.css" 1 => "plugins/balter_custom/...
cPluginJsHead_arr: array:1 [ 0 => "plugins/balter_custom/frontend/js/balter_scripts.js" ]
cPluginJsBody_arr: []
minifiedCSS: array:2 [ "clear.css" => "asset/clear.css?v=1.0.261" "plugin_css" => "asset/plugin_css?v=1.0.261...
minifiedJS: array:2 [ "jtl3.js" => "asset/jtl3.js?v=1.0.261" "plugin_js_head" => "asset/plugin_js_head?v=1.0...
combinedCSS: "asset/clear.css,plugin_css?v=1.0.261"
cCSS_arr: array:2 [ 0 => "templates/BALTER/themes/clear/clear.css" 1 => "templates/BALTER/themes/clear/cus...
cJS_arr: array:23 [ 0 => "templates/BALTER/js/bootstrap-toolkit.js" 1 => "templates/BALTER/js/popper.min....
device: Mobile_Detect {#11617 #cache: [] #userAgent: "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko;...
isMobile: false
isTablet: false
ShopURL: "https://www.k08.de"
opcDir: "/var/www/vhosts/k08.de/httpdocs/admin/opc/"
PFAD_SLIDER: "https://www.k08.de/bilder/slider/"
isNova: false
nTemplateVersion: "1.0.261"
currentTemplateDir: "templates/BALTER/"
currentTemplateDirFull: "https://www.k08.de/templates/BALTER/"
currentTemplateDirFullPath: "/var/www/vhosts/k08.de/httpdocs/templates/BALTER/"
currentThemeDir: "templates/BALTER/themes/clear/"
currentThemeDirFull: "https://www.k08.de/templates/BALTER/themes/clear/"
isFluidTemplate: false
shopFaviconURL: "https://www.k08.de/favicon-default.ico"
ShopLogoURL: "https://www.k08.de/bilder/intern/shoplogo/logo.png"
lang: "ger"
ShopHomeURL: "https://www.k08.de/"
ShopURLSSL: "https://www.k08.de"
imageBaseURL: "https://www.k08.de/"
isAjax: false
meta_title: ""
meta_description: ""
meta_keywords: ""
meta_publisher: ""
meta_copyright: ""
meta_language: "de"
bNoIndex: false
cCanonicalURL: "https://www.k08.de/Komplettsysteme_1"
robotsContent: null
cShopName: ""
bBoxenFilterNach: true
oPlugin_jtl_paypal_commerce: JTL\Plugin\Plugin {#11992 #id: 1 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plugi...
oPlugin_jtl_theme_editor: JTL\Plugin\Plugin {#11957 #id: 2 #pluginID: "jtl_theme_editor" #state: 2 #meta: JTL\Plugin\D...
oPlugin_balter_custom: JTL\Plugin\Plugin {#11806 #id: 5 #pluginID: "balter_custom" #state: 2 #meta: JTL\Plugin\Data...
parentBlockParams: array:19 [ "class" => scc\ComponentProperty {#12568 -defaultValue: null -isRequired: false...
pbp: array:19 [ "class" => scc\ComponentProperty {#12568 -defaultValue: null -isRequired: false...
bCookieErlaubt: true
Brotnavi: array:4 [ 0 => JTL\Catalog\NavigationEntry {#12630 -name: "Startseite" -url: "/" -urlF...
nIsSSL: 1
boxes: array:4 [ "top" => null "right" => null "bottom" => """ <div class="box box-linkgroup box-...
boxesLeftActive: true
consentItems: Illuminate\Support\Collection {#7914 #items: array:2 [ 0 => JTL\Consent\Item {#7913 -id:...
nZeitGebraucht: 0.13230204582214
Besucherzaehler: 0
alertList: JTL\Services\JTL\AlertService {#2923 -alertList: Illuminate\Support\Collection {#2924 #items: ...
dbgBarHead: """ <link rel="stylesheet" type="text/css" href="https://www.k08.de/includes/vendor/maximebf/debugba...
SCRIPT_NAME: "/index.php"

Als Kunde einloggen

Als Kunde einloggen

Komplettsysteme