Kataloge und broschüren

Bezugs-quellen

Partner werden

Hilfe für kunden

EVO HD - IP 2-Draht-BUS

Filter

Für diesen Filter wurden keine Ergebnisse gefunden.

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 Database665 Config Messages Request Exceptions Errors9 Smarty

184ms8.2.2812MB

Shop start to end (155ms)
shop.hook.250 (10μs)
shop.hook.254 (3μs)
shop.hook.252 (2μs)
shop.hook.251 (1μs)
shop.hook.300 (8μs)
shop.hook.301 (7μs)
shop.hook.300 (1μs)
shop.hook.301 (5μs)
shop.hook.300 (1μs)
shop.hook.301 (4μs)
shop.hook.300 (1μs)
shop.hook.301 (5μs)
shop.hook.300 (5μs)
shop.hook.301 (6μ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 (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 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.131 (2μs)
shop.hook.156 (1μs)
shop.hook.361 (2μs)
shop.hook.133 (5μs)
shop.hook.320 (697μs)
shop.hook.250 (2μs)
shop.hook.254 (1μs)
shop.hook.252 (33.68ms)
shop.hook.120 (4μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.120 (2μs)
shop.hook.120 (4μs)
shop.hook.120 (3μs)
shop.hook.120 (2μs)
shop.hook.120 (2μs)
shop.hook.120 (2μs)
shop.hook.120 (1μs)
shop.hook.118 (5μs)
shop.hook.302 (3μ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 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μ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 (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.302 (1μs)
shop.hook.300 (3μs)
shop.hook.301 (2μ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 (6μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (3μs)
shop.hook.300 (0μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (7μs)
shop.hook.300 (3μs)
shop.hook.301 (3μs)
shop.hook.300 (2μs)
shop.hook.301 (3μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (5μs)
shop.hook.300 (3μs)
shop.hook.301 (3μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (3μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (3μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.302 (2μs)
shop.hook.300 (3μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.302 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (1μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.302 (2μs)
shop.hook.300 (3μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.302 (1μs)
shop.hook.300 (3μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.302 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.302 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.302 (1μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (3μs)
shop.hook.300 (1μs)
shop.hook.301 (2μs)
shop.hook.300 (2μs)
shop.hook.301 (5μs)
shop.hook.300 (1μs)
shop.hook.301 (3μs)
shop.hook.300 (1μs)
shop.hook.301 (8μs)
shop.hook.300 (1μ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 (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 (0μ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 (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 (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 (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 (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 (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 (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 (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.306 (1μs)
shop.hook.303 (1μs)
shop.hook.142 (2μs)
shop.hook.400 (1μs)
shop.hook.132 (2μs)
shop.hook.166 (1μs)
shop.hook.143 (2μs)
shop.hook.120 (2μs)
shop.hook.251 (2μs)
shop.hook.120 (2μs)
shop.hook.120 (5μs)
shop.hook.120 (4μs)
shop.hook.120 (4μs)
shop.hook.214 (4μs)
shop.hook.120 (3μs)
shop.hook.221 (4μs)
shop.hook.253 (2μs)
shop.hook.178 (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 (2μs)
shop.hook.253 (1μs)
shop.hook.221 (1μs)
shop.hook.253 (1μs)
shop.hook.221 (2μ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 (2μs)
shop.hook.253 (0μs)
shop.hook.221 (5μs)
shop.hook.253 (2μs)
shop.hook.221 (4μs)
shop.hook.253 (1μs)
shop.hook.221 (3μs)
shop.hook.253 (1μs)
shop.hook.221 (6μs)
shop.hook.253 (2μs)
shop.hook.221 (3μs)
shop.hook.253 (1μs)
shop.hook.120 (6μs)
shop.hook.221 (12μs)
shop.hook.221 (5μs)
shop.hook.22 (5μs)
shop.hook.120 (6μs)
shop.hook.118 (2μs)
shop.hook.221 (2μs)
shop.hook.221 (0μs)
shop.hook.226 (2μs)
shop.hook.330 (2μs)
shop.hook.330 (0μs)
shop.hook.330 (1μs)
shop.hook.330 (0μs)
shop.hook.330 (1μs)
shop.hook.330 (0μs)
shop.hook.331 (1μs)
shop.hook.118 (1μs)
shop.hook.204 (3μs)
shop.hook.175 (1μs)
shop.hook.109 (12μs)
shop.hook.99 (4μs)
shop.hook.221 (6μs)
shop.hook.253 (1μs)
shop.hook.89 (4μs)
shop.hook.90 (1μs)
shop.hook.221 (1μs)
shop.hook.208 (2μ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 (0μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (6μ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 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (2μs)
shop.hook.300 (1μs)
shop.hook.301 (1μs)
shop.hook.300 (0μs)
shop.hook.301 (0μs)
shop.hook.208 (3μs)
shop.hook.120 (3μs)
shop.hook.120 (2μs)
shop.hook.208 (4μs)
shop.hook.208 (2μs)
shop.hook.208 (2μ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 (4μs)
shop.hook.101 (2μs)

1 x Shop start to end (83.91%)	154.67ms
2 x shop.hook.252 (18.28%)	33.68ms
1 x shop.hook.320 (0.38%)	697μs
135 x shop.hook.301 (0.12%)	227μs
135 x shop.hook.300 (0.09%)	172μs
20 x shop.hook.221 (0.03%)	62μs
20 x shop.hook.120 (0.03%)	60μs
12 x shop.hook.208 (0.01%)	26μs
15 x shop.hook.253 (0.01%)	17μs
10 x shop.hook.302 (0.01%)	14μs
2 x shop.hook.250 (0.01%)	12μs
1 x shop.hook.109 (0.01%)	12μs
3 x shop.hook.118 (0%)	8μs
1 x shop.hook.133 (0%)	5μs
1 x shop.hook.22 (0%)	5μs
6 x shop.hook.330 (0%)	4μs
1 x shop.hook.89 (0%)	4μs
2 x shop.hook.254 (0%)	4μs
1 x shop.hook.214 (0%)	4μs
1 x shop.hook.99 (0%)	4μs
2 x shop.hook.251 (0%)	3μs
1 x shop.hook.204 (0%)	3μs
1 x shop.hook.361 (0%)	2μs
1 x shop.hook.132 (0%)	2μs
1 x shop.hook.131 (0%)	2μs
1 x shop.hook.142 (0%)	2μs
1 x shop.hook.143 (0%)	2μs
1 x shop.hook.226 (0%)	2μs
1 x shop.hook.101 (0%)	2μs
1 x shop.hook.156 (0%)	1μs
1 x shop.hook.306 (0%)	1μs
1 x shop.hook.303 (0%)	1μ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.331 (0%)	1μs
1 x shop.hook.175 (0%)	1μs
1 x shop.hook.90 (0%)	1μs

665 statements were executed, 484 of which were duplicates, 181 unique87.97ms10.83MB

SELECT * FROM tsprache85μs16.22KB20000000000000b790000000000000000default
SELECT * FROM tkundengruppe WHERE `cStandard`=?73μ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.6ms17.39KB530000000000000b840000000000000000default
Params
:section 1
SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe78μ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.kPlugin176μs16.69KB120000000000000b4f0000000000000000default
Params
:state 2
SELECT * FROM tsprache109μs16.22KB20000000000000aec0000000000000000default
SELECT * FROM twaehrung81μs16.23KB10000000000000ae80000000000000000default
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache111μ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 = :section670μs16.95KB27000000000000090c0000000000000000default
Params
:section 7
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC191μs16.22KB200000000000008f00000000000000000default
SELECT * FROM tglobals WHERE dLetzteAenderung > :ts82μs16.2KB000000000000008f30000000000000000default
Params
:ts 2025-05-23 04:54:08
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC128μs16.22KB20000000000000baf0000000000000000default
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv144μs16.42KB30000000000000bb00000000000000000default
Params
:nAktiv 1
SELECT kPlugin AS id, bExtension AS modern FROM tplugin WHERE nStatus = :state AND bBootstrap = 1 ORDER BY nPrio ASC119μs16.31KB300000000000008fd0000000000000000default
Params
:state 2
SELECT * FROM tplugin WHERE `kPlugin`=?158μs17.2KB100000000000009020000000000000000default
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 1161μs16.11KB100000000000017000000000000000000default
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 1114μs16.11KB100000000000017040000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?146μs17.25KB200000000000017280000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?131μs17.22KB000000000000017390000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort179μs16.34KB600000000000016f20000000000000000default
Params
:kPlugin 1
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin96μs16.3KB400000000000017100000000000000000default
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.kLink206μs16.46KB400000000000017300000000000000000default
Params
:plgn 1
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)92μs16.14KB400000000000017030000000000000000default
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.cName726μs17KB800000000000017040000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink113μs16.12KB0000000000000173f0000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink90μs16.12KB000000000000017440000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink98μs16.12KB000000000000017490000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink88μs16.12KB0000000000000174e0000000000000000default
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.nSort767μs17.34KB9000000000000172f0000000000000000default
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.kPluginSprachvariable472μs34.06KB78000000000000170d0000000000000000default
Params
:pid 1
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin62μs16.34KB0000000000000179a0000000000000000default
Params
:kPlugin 1
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id92μs16.78KB400000000000017950000000000000000default
Params
:id 1
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid80μs16.98KB3000000000000178e0000000000000000default
Params
:pid kPlugin\_1\_%
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort60μs16.55KB3000000000000178e0000000000000000default
Params
:val kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart38μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart 73
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort44μs16.55KB3000000000000178e0000000000000000default
Params
:val kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart27μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart 74
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort39μs16.55KB3000000000000178e0000000000000000default
Params
:val kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart26μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart 75
SELECT * FROM tplugin WHERE `kPlugin`=?125μs17.2KB100000000000017c50000000000000000default
Params
0 2
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort101μs16.27KB100000000000018640000000000000000default
Params
:kPlugin 2
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin33μs16.24KB0000000000000186b0000000000000000default
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.kLink84μs16.4KB0000000000000186a0000000000000000default
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.nSort216μs17.19KB000000000000018710000000000000000default
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.kPluginSprachvariable274μs17.13KB1800000000000018780000000000000000default
Params
:pid 2
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin69μs16.34KB0000000000000188d0000000000000000default
Params
:kPlugin 2
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id119μs16.72KB000000000000018880000000000000000default
Params
:id 2
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid175μs16.94KB000000000000018840000000000000000default
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')252μs17.08KB63000000000000187d0000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?92μs17.2KB1000000000000187e0000000000000000default
Params
0 5
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 184μs16.11KB100000000000018be0000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?92μs17.25KB2000000000000189a0000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?77μs17.22KB000000000000018e60000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort100μs16.34KB600000000000018cd0000000000000000default
Params
:kPlugin 5
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin63μs16.37KB800000000000018ca0000000000000000default
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.kLink181μs16.52KB800000000000018df0000000000000000default
Params
:plgn 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)96μs16.2KB800000000000018af0000000000000000default
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.cName1.33ms17.13KB1600000000000018ee0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink119μs16.12KB000000000000019030000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink74μs16.12KB000000000000019080000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB0000000000000190d0000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000019120000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000019170000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink53μs16.12KB0000000000000191c0000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB000000000000019210000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink53μs16.12KB000000000000019260000000000000000default
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.nSort344μs17.19KB000000000000018ac0000000000000000default
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.kPluginSprachvariable358μs16.84KB200000000000018e30000000000000000default
Params
:pid 5
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin87μs16.34KB000000000000018ff0000000000000000default
Params
:kPlugin 5
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id113μs16.72KB000000000000018f90000000000000000default
Params
:id 5
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid130μs16.94KB000000000000018f50000000000000000default
Params
:pid kPlugin\_5\_%
SELECT * FROM ttemplate WHERE `eTyp`=?103μs16.85KB1000000000000195c0000000000000000default
Params
0 standard
SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate214μs17.2KB6300000000000019620000000000000000default
Params
:cTemplate BALTER
SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio91μs16.3KB300000000000019a10000000000000000default
Params
:nStatus 2
SELECT * FROM tconsent WHERE `active`=:active91μs16.27KB20000000000001ee40000000000000000default
Params
:active 1
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID86μs16.31KB20000000000001efe0000000000000000default
Params
:consentID 1
SELECT * FROM tsprache50μs16.22KB20000000000001efe0000000000000000default
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID66μs16.31KB20000000000001f090000000000000000default
Params
:consentID 2
SELECT * FROM tsprache46μs16.22KB20000000000001f090000000000000000default
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 = :section135μs16.56KB30000000000001f090000000000000000default
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 = :pid464μs17.84KB720000000000001f190000000000000000default
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 = 075μs16.19KB40000000000001f510000000000000000default
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 NULL194μs18.39KB10000000000001f390000000000000000default
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 = :section648μs17.02KB320000000000001f470000000000000000default
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.nSort236μs17KB00000000000001f730000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?80μs16.93KB40000000000001f6e0000000000000000default
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 NULL190μs18.39KB10000000000001f6d0000000000000000default
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.nSort180μs17KB00000000000001f6d0000000000000000default
Params
:cid 123
SELECT * FROM tkategorie WHERE `kOberKategorie`=?78μs16.99KB80000000000001f220000000000000000default
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 NULL169μs18.39KB10000000000001f230000000000000000default
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.nSort172μs17KB00000000000001f230000000000000000default
Params
:cid 132
SELECT * FROM tkategorie WHERE `kOberKategorie`=?66μs16.99KB70000000000001f2c0000000000000000default
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 NULL164μs18.39KB10000000000001f2d0000000000000000default
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.nSort167μs17KB00000000000001f2d0000000000000000default
Params
:cid 220
SELECT * FROM tkategorie WHERE `kOberKategorie`=?54μs16.87KB00000000000001f770000000000000000default
Params
0 220
SELECT id_category FROM submenusettings WHERE id = 141μs16.04KB10000000000001f3a0000000000000000default
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 NULL160μs18.39KB10000000000001f310000000000000000default
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 = :section4.27ms18.02KB910000000000001f7c0000000000000000default
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 = 177μs16.16KB00000000000001fd90000000000000000default
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.nSort202μs17KB00000000000001fda0000000000000000default
Params
:cid 109
SELECT * FROM tkategorie WHERE `kOberKategorie`=?70μs16.95KB50000000000001fd30000000000000000default
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 NULL175μs18.39KB10000000000001fd20000000000000000default
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.nSort173μs17KB00000000000001fd20000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?63μs16.95KB50000000000001fc90000000000000000default
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 NULL163μs18.39KB10000000000001fc80000000000000000default
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.nSort181μs17KB00000000000001fc80000000000000000default
Params
:cid 111
SELECT * FROM tkategorie WHERE `kOberKategorie`=?63μs16.93KB40000000000001fbf0000000000000000default
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 NULL165μs18.39KB10000000000001fbe0000000000000000default
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.nSort174μs17KB00000000000001fbe0000000000000000default
Params
:cid 112
SELECT * FROM tkategorie WHERE `kOberKategorie`=?61μs16.95KB50000000000001fb50000000000000000default
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 NULL157μs18.39KB10000000000001fb40000000000000000default
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.nSort168μs17KB00000000000001fb40000000000000000default
Params
:cid 115
SELECT * FROM tkategorie WHERE `kOberKategorie`=?51μs16.87KB00000000000001fab0000000000000000default
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 NULL161μs18.39KB10000000000001fab0000000000000000default
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.nSort162μs17KB00000000000001fab0000000000000000default
Params
:cid 116
SELECT * FROM tkategorie WHERE `kOberKategorie`=?49μs16.87KB00000000000001fa10000000000000000default
Params
0 116
SELECT * FROM tland135μs20.19KB2360000000000001f970000000000000000default
SELECT cLaender FROM tversandart33μs16.05KB20000000000001f970000000000000000default
SELECT DISTINCT cLandIso FROM tstaat74μs16.52KB290000000000001f970000000000000000default
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName90μs16.56KB2400000000000020cb0000000000000000default
Params
:cLandIso AR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName45μs16.34KB900000000000020d80000000000000000default
Params
:cLandIso AT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName47μs16.34KB1000000000000020b70000000000000000default
Params
:cLandIso BE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName66μs16.69KB2800000000000020fa0000000000000000default
Params
:cLandIso BG
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName81μs16.63KB2700000000000021160000000000000000default
Params
:cLandIso BR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName52μs16.41KB13000000000000213b0000000000000000default
Params
:cLandIso CA
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName61μs16.63KB26000000000000210a0000000000000000default
Params
:cLandIso CH
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName79μs16.81KB3400000000000021760000000000000000default
Params
:cLandIso CN
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.28KB6000000000000219f0000000000000000default
Params
:cLandIso CY
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName44μs16.44KB1400000000000021970000000000000000default
Params
:cLandIso CZ
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.44KB1600000000000021710000000000000000default
Params
:cLandIso DE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName34μs16.27KB500000000000021d80000000000000000default
Params
:cLandIso DK
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName45μs16.44KB15000000000000216d0000000000000000default
Params
:cLandIso EE
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName91μs17.06KB5000000000000021f70000000000000000default
Params
:cLandIso ES
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName51μs16.5KB1900000000000022320000000000000000default
Params
:cLandIso FI
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName178μs18.19KB11400000000000022210000000000000000default
Params
:cLandIso FR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName32μs16.25KB400000000000022c40000000000000000default
Params
:cLandIso GB
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName42μs16.41KB1300000000000022b20000000000000000default
Params
:cLandIso GR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName57μs16.56KB2100000000000022aa0000000000000000default
Params
:cLandIso HR
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName74μs16.81KB3600000000000022880000000000000000default
Params
:cLandIso IN
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName170μs17.94KB11000000000000022290000000000000000default
Params
:cLandIso IT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName89μs16.94KB4700000000000023a90000000000000000default
Params
:cLandIso JP
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName40μs16.34KB10000000000000238a0000000000000000default
Params
:cLandIso LT
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName189μs18.19KB11900000000000023950000000000000000default
Params
:cLandIso LV
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName73μs16.69KB3200000000000024680000000000000000default
Params
:cLandIso MX
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName45μs16.38KB12000000000000244e0000000000000000default
Params
:cLandIso NL
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName85μs16.94KB4200000000000021ee0000000000000000default
Params
:cLandIso RO
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName142μs17.44KB7800000000000024f70000000000000000default
Params
:cLandIso TH
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName116μs17.19KB63000000000000256e0000000000000000default
Params
:cLandIso US
SELECT * FROM tfirma LIMIT 142μs16.52KB10000000000001f9a0000000000000000default
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 nSort100μs16.88KB00000000000001f9d0000000000000000default
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 > 0135μs16.59KB2200000000000020a70000000000000000default
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName72μs16.27KB000000000000020880000000000000000default
Params
:lgid 1
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName59μs16.37KB600000000000020830000000000000000default
Params
:lgid 4
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (440,442,68,71,443,444)43μs16.17KB600000000000020840000000000000000default
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.cName672μs17.06KB1200000000000020730000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink72μs16.12KB000000000000020620000000000000000default
Params
:kVaterLink 440
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB0000000000000205d0000000000000000default
Params
:kVaterLink 442
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000020580000000000000000default
Params
:kVaterLink 68
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020530000000000000000default
Params
:kVaterLink 71
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB0000000000000204e0000000000000000default
Params
:kVaterLink 443
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020490000000000000000default
Params
:kVaterLink 444
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName84μs16.37KB600000000000020680000000000000000default
Params
:lgid 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (69,67,59,49,73,74)42μs16.17KB600000000000020670000000000000000default
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.cName602μs17.06KB12000000000000207a0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink69μs16.12KB0000000000000203b0000000000000000default
Params
:kVaterLink 69
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000020360000000000000000default
Params
:kVaterLink 67
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000020310000000000000000default
Params
:kVaterLink 59
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000202c0000000000000000default
Params
:kVaterLink 49
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020270000000000000000default
Params
:kVaterLink 73
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020220000000000000000default
Params
:kVaterLink 74
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName114μs16.71KB2700000000000020410000000000000000default
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)64μs16.52KB2700000000000020400000000000000000default
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.cName1.03ms33.75KB540000000000001ffb0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink68μs16.12KB000000000000025400000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB000000000000025450000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB0000000000000254a0000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink49μs16.12KB0000000000000254f0000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink48μs16.12KB000000000000025540000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000025590000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink35μs16.12KB0000000000000255e0000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB000000000000025630000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink40μs16.12KB000000000000025680000000000000000default
Params
:kVaterLink 86
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB0000000000000260d0000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000026120000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000026170000000000000000default
Params
:kVaterLink 83
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB0000000000000261c0000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink91μs16.12KB000000000000026210000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink58μs16.12KB000000000000026260000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink40μs16.12KB0000000000000262b0000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000026300000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000026350000000000000000default
Params
:kVaterLink 106
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB0000000000000263a0000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB0000000000000263f0000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB000000000000026440000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB000000000000026490000000000000000default
Params
:kVaterLink 438
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB0000000000000264e0000000000000000default
Params
:kVaterLink 84
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.1KB000000000000026530000000000000000default
Params
:kVaterLink 3
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026580000000000000000default
Params
:kVaterLink 63
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.1KB0000000000000265d0000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026620000000000000000default
Params
:kVaterLink 72
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName92μs16.37KB60000000000001f920000000000000000default
Params
:lgid 9
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (103,104,420,422,64,61)48μs16.17KB60000000000001f930000000000000000default
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.cName628μs17.03KB100000000000001f820000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink73μs16.12KB00000000000001fe50000000000000000default
Params
:kVaterLink 103
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000001fea0000000000000000default
Params
:kVaterLink 104
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB00000000000001fef0000000000000000default
Params
:kVaterLink 420
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB00000000000001ff40000000000000000default
Params
:kVaterLink 422
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB000000000000020160000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000020000000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName85μs16.35KB50000000000001fdf0000000000000000default
Params
:lgid 10
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (109,112,111,110,113)43μs16.16KB50000000000001fe00000000000000000default
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.cName543μs17.03KB100000000000001f890000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink66μs16.12KB0000000000000200c0000000000000000default
Params
:kVaterLink 109
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB000000000000020110000000000000000default
Params
:kVaterLink 112
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000020400000000000000000default
Params
:kVaterLink 111
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB0000000000000201b0000000000000000default
Params
:kVaterLink 110
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB0000000000000207a0000000000000000default
Params
:kVaterLink 113
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName77μs16.32KB300000000000020060000000000000000default
Params
:lgid 11
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (446,448,447)40μs16.13KB300000000000020070000000000000000default
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.cName499μs16.97KB60000000000001f860000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink66μs16.12KB000000000000020670000000000000000default
Params
:kVaterLink 446
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB000000000000020840000000000000000default
Params
:kVaterLink 448
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB0000000000000204a0000000000000000default
Params
:kVaterLink 447
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName77μs16.32KB30000000000001f310000000000000000default
Params
:lgid 12
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (115,50,66)40μs16.13KB30000000000001f7c0000000000000000default
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.cName491μs16.97KB600000000000020730000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink63μs16.12KB000000000000026710000000000000000default
Params
:kVaterLink 115
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB000000000000026760000000000000000default
Params
:kVaterLink 50
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB0000000000000267b0000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName77μs16.34KB4000000000000266b0000000000000000default
Params
:lgid 13
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (116,118,119,117)41μs16.14KB4000000000000266c0000000000000000default
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.cName510μs17KB800000000000026800000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink64μs16.12KB0000000000000268d0000000000000000default
Params
:kVaterLink 116
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink35μs16.12KB000000000000026920000000000000000default
Params
:kVaterLink 118
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026970000000000000000default
Params
:kVaterLink 119
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB0000000000000269c0000000000000000default
Params
:kVaterLink 117
SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName68μs16.29KB100000000000026870000000000000000default
Params
:lgid 14
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (120)31μs16.09KB100000000000026880000000000000000default
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.cName202μs16.91KB2000000000000267f0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000026800000000000000000default
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.kSprache812μs34KB74000000000000208f0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink66μs16.1KB000000000000026d50000000000000000default
Params
:kVaterLink 3
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.1KB000000000000026da0000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB000000000000026df0000000000000000default
Params
:kVaterLink 49
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026e40000000000000000default
Params
:kVaterLink 50
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB000000000000026e90000000000000000default
Params
:kVaterLink 59
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026ee0000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000026f30000000000000000default
Params
:kVaterLink 63
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB000000000000026f80000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB000000000000026fd0000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB000000000000027020000000000000000default
Params
:kVaterLink 67
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027070000000000000000default
Params
:kVaterLink 69
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB0000000000000270c0000000000000000default
Params
:kVaterLink 72
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027110000000000000000default
Params
:kVaterLink 73
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027160000000000000000default
Params
:kVaterLink 74
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB0000000000000271b0000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027200000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027250000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB0000000000000272a0000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000272f0000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027340000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027390000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000273e0000000000000000default
Params
:kVaterLink 83
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027430000000000000000default
Params
:kVaterLink 84
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027480000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000274d0000000000000000default
Params
:kVaterLink 86
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027520000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000027570000000000000000default
Params
:kVaterLink 106
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000275c0000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027610000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027660000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000276b0000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000027700000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000027750000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000277a0000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000277f0000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000027840000000000000000default
Params
:kVaterLink 438
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027890000000000000000default
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.kSprache638μs17.23KB2600000000000026d00000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink62μs16.1KB000000000000026af0000000000000000default
Params
:kVaterLink 4
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026aa0000000000000000default
Params
:kVaterLink 61
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026a50000000000000000default
Params
:kVaterLink 64
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000267f0000000000000000default
Params
:kVaterLink 66
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000268a0000000000000000default
Params
:kVaterLink 75
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000020a10000000000000000default
Params
:kVaterLink 76
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000209f0000000000000000default
Params
:kVaterLink 77
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000020930000000000000000default
Params
:kVaterLink 78
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000209a0000000000000000default
Params
:kVaterLink 79
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000278f0000000000000000default
Params
:kVaterLink 80
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027940000000000000000default
Params
:kVaterLink 81
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000027990000000000000000default
Params
:kVaterLink 85
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000279e0000000000000000default
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.kSprache334μs16.75KB000000000000026b40000000000000000default
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 = :section102μs16.56KB300000000000027a80000000000000000default
Params
:section 128
SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?53μs16.74KB1000000000000280a0000000000000000default
Params
0 kMerkmalWert
1 2-Familienhaus
SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?24μs16.74KB1000000000000280a0000000000000000default
Params
0 kMerkmalWert
1 3-Familienhaus
SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?20μs16.74KB1000000000000280d0000000000000000default
Params
0 kMerkmalWert
1 4-Familienhaus
SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?23μs16.74KB100000000000028100000000000000000default
Params
0 kMerkmalWert
1 Unterputz_1
SELECT * FROM tseo WHERE cSeo = :slg22μs16.23KB100000000000028140000000000000000default
Params
:slg EVO-HD-IP-2-Draht-BUS
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 NULL172μs18.39KB100000000000028170000000000000000default
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.nSort162μs17KB000000000000028170000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?65μs16.95KB500000000000028210000000000000000default
Params
0 110
SELECT tmerkmalwert.kMerkmal, tmerkmalwert.kMerkmalWert, tmerkmal.nMehrfachauswahl FROM tmerkmalwert JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal WHERE kMerkmalWert IN (2,3,4,18)64μs16.14KB40000000000001f530000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val63μs16.89KB100000000000028250000000000000000default
Params
:val 2
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val44μs16.89KB1000000000000282a0000000000000000default
Params
:val 3
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val43μs16.89KB1000000000000282f0000000000000000default
Params
:val 4
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val39μs16.89KB100000000000028340000000000000000default
Params
:val 18
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache45μs16.08KB200000000000028240000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache31μs16.08KB200000000000028220000000000000000default
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 NULL149μs18.39KB1000000000000283f0000000000000000default
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.nSort158μs17KB0000000000000283f0000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?57μs16.95KB500000000000028490000000000000000default
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 NULL162μs18.39KB1000000000000284a0000000000000000default
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.nSort170μs17KB0000000000000284a0000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?66μs16.95KB500000000000028530000000000000000default
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 NULL157μs18.39KB1000000000000284e0000000000000000default
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.nSort164μs17KB0000000000000284e0000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?66μs16.95KB5000000000000285c0000000000000000default
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 NULL168μs18.39KB100000000000028570000000000000000default
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.nSort190μs17KB000000000000028570000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.95KB500000000000028650000000000000000default
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 NULL158μs18.39KB100000000000028600000000000000000default
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.nSort157μs17KB000000000000028600000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?62μs16.93KB4000000000000286e0000000000000000default
Params
0 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.48KB500000000000028770000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie37μs16.41KB000000000000028770000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie88μs16.41KB000000000000028770000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie47μs16.45KB300000000000028770000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB000000000000028770000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB000000000000028770000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName275μs16.02KB000000000000028720000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie53μs16.48KB5000000000000287c0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB0000000000000287c0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB0000000000000287c0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.45KB3000000000000287c0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB0000000000000287c0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB0000000000000287c0000000000000000default
Params
:kOberKategorie 232
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\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #JOIN from JTL\Filter\States\BaseManufacturer::getOptions JOIN thersteller ON tartikel.kHersteller = thersteller.kHersteller #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, 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.cName351μs18.16KB000000000000028a10000000000000000default
Params
:lid 1
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie53μs16.48KB5000000000000286e0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB0000000000000286e0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB0000000000000286e0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.45KB3000000000000286e0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB0000000000000286e0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB0000000000000286e0000000000000000default
Params
:kOberKategorie 232
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\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #JOIN from JTL\Filter\Items\Rating::getSQLJoin JOIN tartikelext ON tartikel.kArtikel = tartikelext.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal GROUP BY ssMerkmal.nSterne ORDER BY ssMerkmal.nSterne DESC249μs16.05KB000000000000028b60000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie46μs16.48KB500000000000028970000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie30μs16.41KB000000000000028970000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028970000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.45KB300000000000028970000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028970000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.41KB000000000000028970000000000000000default
Params
:kOberKategorie 232
SELECT kKategorie FROM tkategoriesichtbarkeit19μs16.02KB000000000000028cb0000000000000000default
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 #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join4 from JTL\Filter\Items\Category::getOptions JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tkategorie.kKategorie, tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, 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.cName293μs17.88KB0000000000000286e0000000000000000default
Params
:lid 1
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.48KB500000000000028b60000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.41KB000000000000028b60000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028b60000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.45KB300000000000028b60000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028b60000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000028b60000000000000000default
Params
:kOberKategorie 232
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.48KB500000000000028ee0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000028ee0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000028ee0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.45KB300000000000028ee0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028ee0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028ee0000000000000000default
Params
:kOberKategorie 232
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 #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal413μs16.06KB100000000000028f40000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie63μs16.48KB500000000000028720000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.41KB000000000000028720000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028720000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.45KB300000000000028720000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028720000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028720000000000000000default
Params
:kOberKategorie 232
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.48KB500000000000029000000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000029000000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000029000000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.45KB300000000000029000000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029000000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000029000000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.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 tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) 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 tartikel.nSort, tartikel.cName218μs16.02KB000000000000028c00000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie47μs16.48KB500000000000029210000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB000000000000029210000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB000000000000029210000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.45KB300000000000029210000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000029210000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029210000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) 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 tartikel.nSort, tartikel.cName235μs16.02KB000000000000029010000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.48KB500000000000029360000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB000000000000029360000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029360000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.45KB300000000000029360000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB000000000000029360000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029360000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) 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 tartikel.nSort, tartikel.cName181μs16.02KB000000000000028d70000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie47μs16.48KB5000000000000294d0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB0000000000000294d0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB0000000000000294d0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.45KB3000000000000294d0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB0000000000000294d0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie35μs16.41KB0000000000000294d0000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND tartikel.cTopArtikel = 'Y' AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName214μs16.02KB000000000000029370000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie60μs16.48KB5000000000000295e0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.41KB0000000000000295e0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB0000000000000295e0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.45KB3000000000000295e0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB0000000000000295e0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB0000000000000295e0000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND NOW() < tartikel.dErscheinungsdatum AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName154μs16.02KB0000000000000290b0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie125μs16.48KB500000000000029720000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie126μs16.41KB000000000000029720000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie64μs16.41KB000000000000029720000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie70μs16.45KB300000000000029720000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000029720000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.41KB000000000000029720000000000000000default
Params
:kOberKategorie 232
SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #top reviews JOIN from JTL\Filter\Items\SearchSpecial::getOptions JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) 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 tartikel.nSort, tartikel.cName380μs16.02KB0000000000000295f0000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie120μs16.48KB500000000000028f60000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie69μs16.41KB000000000000028f60000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie60μs16.41KB000000000000028f60000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie65μs16.45KB300000000000028f60000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie55μs16.41KB000000000000028f60000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie53μs16.41KB000000000000028f60000000000000000default
Params
:kOberKategorie 232
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 JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.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 tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) 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 ASC400μs16.05KB000000000000029920000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie112μs16.48KB500000000000029220000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000029220000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie24μs16.41KB000000000000029220000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.45KB300000000000029220000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029220000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000029220000000000000000default
Params
:kOberKategorie 232
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, #2,3,4 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 #join active AND filters from JTL\Filter\Items\Characteristic::getState JOIN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18 ) GROUP BY kArtikel HAVING COUNT(*) = 1 ) AS ssj1 ON tartikel.kArtikel = ssj1.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tkategorieartikel.kKategorie = 110 OR tkategorieartikel.kKategorie = 119 OR tkategorieartikel.kKategorie = 225 OR tkategorieartikel.kKategorie = 226 OR tkategorieartikel.kKategorie = 231 OR tkategorieartikel.kKategorie = 232 OR tkategorieartikel.kKategorie = 227 OR tkategorieartikel.kKategorie = 228 OR tkategorieartikel.kKategorie = 229 AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 ) AS ssMerkmal GROUP BY ssMerkmal.kMerkmalWert ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert452μs16.38KB700000000000029930000000000000000default
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 147μs16.16KB100000000000029be0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 121μs16.16KB100000000000029c30000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB100000000000029c20000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 118μs16.16KB100000000000029c80000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB100000000000029cb0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 116μs16.16KB100000000000029ce0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB100000000000029d10000000000000000default
Params
:cid 1
SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (1,2,3)94μs16.2KB300000000000029bd0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache54μs16.08KB200000000000029da0000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 124μs16.2KB100000000000029d90000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB100000000000029dd0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB100000000000029da0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 118μs16.2KB100000000000029e50000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB100000000000029e80000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB100000000000029eb0000000000000000default
Params
:cid 1
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB100000000000029ee0000000000000000default
Params
:cid 1
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache39μs16.08KB200000000000029f20000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 120μs16.2KB100000000000029ee0000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB100000000000029f80000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB100000000000029f50000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 115μs16.2KB100000000000029fd0000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a000000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB10000000000002a030000000000000000default
Params
:cid 2
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB10000000000002a060000000000000000default
Params
:cid 2
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache34μs16.08KB20000000000002a0a0000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 118μs16.2KB10000000000002a060000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a100000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 123μs16.2KB10000000000002a0e0000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a150000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a180000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a1b0000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB10000000000002a1e0000000000000000default
Params
:cid 3
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 120μs16.16KB10000000000002a1e0000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB10000000000002a260000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 116μs16.16KB10000000000002a250000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB10000000000002a2b0000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 118μs16.16KB10000000000002a2e0000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB10000000000002a310000000000000000default
Params
:cid 13
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 116μs16.16KB10000000000002a340000000000000000default
Params
:cid 13
SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (25)65μs16.17KB10000000000002a210000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache45μs16.08KB20000000000002a210000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB100000000000029d50000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 118μs16.2KB10000000000002a3b0000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a210000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a430000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a460000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 119μs16.2KB10000000000002a490000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 117μs16.2KB10000000000002a4c0000000000000000default
Params
:cid 25
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 119μs16.16KB10000000000002a4c0000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 118μs16.16KB10000000000002a540000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 116μs16.16KB10000000000002a530000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 158μs16.16KB10000000000002a590000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 144μs16.16KB10000000000002a5c0000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 142μs16.16KB10000000000002a5f0000000000000000default
Params
:cid 5
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 142μs16.16KB10000000000002a620000000000000000default
Params
:cid 5
SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (20)130μs16.17KB10000000000002a4f0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache101μs16.08KB20000000000002a680000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 148μs16.2KB10000000000002a670000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB10000000000002a6b0000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002a680000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002a730000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002a760000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB10000000000002a790000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 144μs16.2KB10000000000002a7c0000000000000000default
Params
:cid 20
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 1102μs16.16KB10000000000002a7c0000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 158μs16.16KB10000000000002a840000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 122μs16.16KB10000000000002a830000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 118μs16.16KB10000000000002a890000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 186μs16.16KB10000000000002a8c0000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 156μs16.16KB10000000000002a8f0000000000000000default
Params
:cid 11
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB10000000000002a920000000000000000default
Params
:cid 11
SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (16)125μs16.17KB10000000000002a7f0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache109μs16.08KB20000000000002a980000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 155μs16.2KB10000000000002a970000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 144μs16.2KB10000000000002a9b0000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002a980000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB10000000000002aa30000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002aa60000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB10000000000002aa90000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB10000000000002aac0000000000000000default
Params
:cid 16
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB10000000000002aac0000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002ab40000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002ab30000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB10000000000002ab90000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 144μs16.16KB10000000000002abc0000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB10000000000002abf0000000000000000default
Params
:cid 12
SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB10000000000002ac20000000000000000default
Params
:cid 12
SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (18)122μs16.17KB10000000000002aaf0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache101μs16.08KB20000000000002ac80000000000000000default
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 153μs16.2KB10000000000002ac70000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 143μs16.2KB10000000000002acd0000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002acc0000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB10000000000002ad30000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 149μs16.2KB10000000000002ad60000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002ad90000000000000000default
Params
:cid 18
SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002adc0000000000000000default
Params
:cid 18
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache104μs16.08KB200000000000029b10000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache84μs16.08KB200000000000029930000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache77μs16.08KB200000000000029ad0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache76μs16.08KB200000000000029aa0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache75μs16.08KB200000000000029920000000000000000default
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 NULL295μs18.39KB100000000000029af0000000000000000default
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.nSort389μs17KB000000000000029af0000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?96μs16.95KB50000000000002ace0000000000000000default
Params
0 110
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache91μs16.08KB20000000000002ace0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache78μs16.08KB200000000000029a10000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache78μs16.08KB20000000000002ae60000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache75μs16.08KB20000000000002ae90000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache72μs16.08KB20000000000002aec0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache85μs16.08KB20000000000002aef0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache77μs16.08KB20000000000002af20000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache72μs16.08KB20000000000002adf0000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val118μs16.89KB10000000000002af30000000000000000default
Params
:val 1
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val104μs16.89KB10000000000002ae10000000000000000default
Params
:val 1
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache87μs16.08KB20000000000002afa0000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val121μs16.89KB10000000000002b000000000000000000default
Params
:val 2
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache110μs16.08KB20000000000002afd0000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val134μs16.89KB10000000000002b040000000000000000default
Params
:val 1
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val106μs16.89KB10000000000002b020000000000000000default
Params
:val 1
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache85μs16.08KB20000000000002b070000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val97μs16.89KB10000000000002b0d0000000000000000default
Params
:val 3
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache78μs16.08KB20000000000002b0a0000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val94μs16.89KB10000000000002b110000000000000000default
Params
:val 1
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val90μs16.89KB10000000000002b0f0000000000000000default
Params
:val 1
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache77μs16.08KB20000000000002b140000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val95μs16.89KB10000000000002b1a0000000000000000default
Params
:val 4
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache79μs16.08KB20000000000002b170000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val112μs16.89KB10000000000002b1e0000000000000000default
Params
:val 12
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val95μs16.89KB10000000000002b1c0000000000000000default
Params
:val 12
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache78μs16.08KB20000000000002b210000000000000000default
SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val92μs16.89KB10000000000002b270000000000000000default
Params
:val 18
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache75μs16.08KB20000000000002b240000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache74μs16.08KB20000000000002b210000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache75μs16.08KB20000000000002af50000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache77μs16.08KB20000000000002b2b0000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache71μs16.08KB20000000000002af70000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache73μs16.08KB20000000000002af70000000000000000default
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache82μs16.08KB20000000000002b300000000000000000default
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 = :section2.39ms17.39KB510000000000002b2c0000000000000000default
Params
:section 4
SELECT DISTINCT (tartikel.kArtikel) FROM tkategorieartikel, tartikel LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid JOIN tpreis AS tpreis ON tpreis.kArtikel = tartikel.kArtikel AND tpreis.kKundengruppe = 1 JOIN tpreisdetail AS tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0 WHERE tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kArtikel = tkategorieartikel.kArtikel AND tartikel.cTopArtikel = 'Y' AND (tkategorieartikel.kKategorie IN (119, 231, 226, 228, 229, 227, 225, 232)) ORDER BY rand() LIMIT 6370μs16.9KB00000000000002b6c0000000000000000default
Params
:cgid 1
SELECT DISTINCT (tartikel.kArtikel) FROM tkategorieartikel, tbestseller, tartikel LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid JOIN tpreis AS tpreis ON tpreis.kArtikel = tartikel.kArtikel AND tpreis.kKundengruppe = 1 JOIN tpreisdetail AS tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0 WHERE tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kArtikel = tkategorieartikel.kArtikel AND tartikel.kArtikel = tbestseller.kArtikel AND (tkategorieartikel.kKategorie IN (119, 231, 226, 228, 229, 227, 225, 232)) ORDER BY tbestseller.fAnzahl DESC LIMIT 6225μs17.02KB00000000000002b680000000000000000default
Params
: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 = :section144μs16.59KB50000000000002b640000000000000000default
Params
:section 121
SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache80μs16.08KB20000000000002b600000000000000000default
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 NULL206μs18.39KB10000000000002b570000000000000000default
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.nSort244μs17KB00000000000002b570000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?161μs16.93KB40000000000002b4d0000000000000000default
Params
0 108
SELECT * FROM tfirma LIMIT 172μs16.52KB10000000000002b520000000000000000default
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 nSort157μs16.88KB00000000000002b4a0000000000000000default
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.cName1.65ms18KB120000000000002b440000000000000000default
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 NULL185μs16.02KB00000000000002b700000000000000000default
SELECT * FROM tfirma LIMIT 171μs16.52KB10000000000002b820000000000000000default
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 DESC190μs16.61KB30000000000002ec90000000000000000default
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 = :section157μs16.53KB10000000000002ee40000000000000000default
Params
:section 125
SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache63μs16.08KB00000000000002eed0000000000000000default
SELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC373μs40.16KB4990000000000002efa0000000000000000default
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)170μs688B00000000000002ef90000000000000000default
Params
:interval 3
DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)92μs128B00000000000002ef90000000000000000default
Params
:interval 3
SELECT * FROM tbesucher WHERE `cSessID`=?99μs16.91KB00000000000002ef90000000000000000default
Params
0 n7f7bicgc16dphn0g25aqd3es2
SELECT * FROM tbesucher WHERE `cID`=?157μs16.93KB10000000000002ef90000000000000000default
Params
0 317ea9ade3904e072ae847972cf4dbd6

Params
0	Y

Params
:section	1

Params
:kKundengruppe	1

Params
:state	2

Params
:section	7

Params
:ts	2025-05-23 04:54:08

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.13ms2.41KB10000000000002ef90000000000000000default

Params
0	158146
1	3.148.0.0
2	n7f7bicgc16dphn0g25aqd3es2
3	317ea9ade3904e072ae847972cf4dbd6
4	0
5	0
6
7	Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
8	/EVO-HD-IP-2-Draht-BUS__1-Familienhaus__4-Familienhaus__Ohne-Smartphone-App__Silber?availability=1&qf=3
9	Sonstige
10	/EVO-HD-IP-2-Draht-BUS__2-Familienhaus__3-Familienhaus__4-Familienhaus__Unterputz_1?Sortierung=100&qf=4
11	0
12	2025-05-23 04:59:56
13	2025-05-23 04:59:43
14	158146

SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv176μs16.38KB3000000000000090f0000000000000000default
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 = '')81μs16.42KB000000000000030db0000000000000000default
Params
:lid 1
:cgid 1
:ptype 2
:cky kKategorie
:cval 110
SELECT * FROM tboxenanzeige63μs17.58KB8200000000000030d10000000000000000default
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 ASC8.89ms97KB3200000000000030550000000000000000default
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie119μs16.48KB5000000000000307e0000000000000000default
Params
:kOberKategorie 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie77μs16.41KB0000000000000307e0000000000000000default
Params
:kOberKategorie 119
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie41μs16.41KB0000000000000307e0000000000000000default
Params
:kOberKategorie 225
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie36μs16.45KB3000000000000307e0000000000000000default
Params
:kOberKategorie 226
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.41KB0000000000000307e0000000000000000default
Params
:kOberKategorie 231
SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie37μs16.41KB0000000000000307e0000000000000000default
Params
:kOberKategorie 232
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 1075μs16.02KB0000000000000308a0000000000000000default
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 #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,3,4)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) 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 tartikel.nSort, tartikel.cName) AS ssMerkmal GROUP BY ssMerkmal.kSuchanfrage ORDER BY ssMerkmal.cSuche334μs16.09KB0000000000000308a0000000000000000default
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 :lmt134μs17.27KB000000000000030690000000000000000default
Params
:lmt 10
:cgid 1
SELECT kPlugin, cPluginID, bExtension FROM tplugin39μs16.17KB6000000000000304a0000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?52μs17.2KB100000000000030410000000000000000default
Params
0 1
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 149μs16.11KB100000000000030ac0000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?45μs17.25KB200000000000030c40000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?34μs17.22KB0000000000000302c0000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort56μs16.34KB600000000000030360000000000000000default
Params
:kPlugin 1
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin31μs16.3KB400000000000030b40000000000000000default
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.kLink104μs16.46KB400000000000030ca0000000000000000default
Params
:plgn 1
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)43μs16.14KB4000000000000306c0000000000000000default
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.cName640μs17KB800000000000030ac0000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink71μs16.12KB000000000000030260000000000000000default
Params
:kVaterLink 108
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000030210000000000000000default
Params
:kVaterLink 107
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB0000000000000301c0000000000000000default
Params
:kVaterLink 105
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000030170000000000000000default
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.nSort657μs17.34KB900000000000030c90000000000000000default
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.kPluginSprachvariable422μs34.06KB7800000000000030b20000000000000000default
Params
:pid 1
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin74μs16.34KB00000000000002fcb0000000000000000default
Params
:kPlugin 1
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id102μs16.78KB40000000000002fd00000000000000000default
Params
:id 1
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid81μs16.98KB30000000000002fd70000000000000000default
Params
:pid kPlugin\_1\_%
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort61μs16.55KB30000000000002fd70000000000000000default
Params
:val kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart38μs16.28KB20000000000002fd70000000000000000default
Params
:kZahlungsart 73
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort42μs16.55KB30000000000002fd70000000000000000default
Params
:val kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart27μs16.28KB20000000000002fd70000000000000000default
Params
:kZahlungsart 74
SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort38μs16.55KB30000000000002fd70000000000000000default
Params
:val kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart23μs16.28KB20000000000002fd70000000000000000default
Params
:kZahlungsart 75
SELECT kPlugin, cPluginID, bExtension FROM tplugin29μs16.17KB600000000000030470000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?42μs17.2KB10000000000002fde0000000000000000default
Params
0 2
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort43μs16.27KB100000000000030120000000000000000default
Params
:kPlugin 2
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin29μs16.24KB00000000000002fa20000000000000000default
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.kLink84μs16.4KB000000000000030af0000000000000000default
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.nSort218μs17.19KB00000000000002f9c0000000000000000default
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.kPluginSprachvariable263μs17.13KB180000000000002f950000000000000000default
Params
:pid 2
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin61μs16.34KB00000000000002f800000000000000000default
Params
:kPlugin 2
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id72μs16.72KB00000000000002f850000000000000000default
Params
:id 2
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid62μs16.94KB00000000000002f890000000000000000default
Params
:pid kPlugin\_2\_%
SELECT kPlugin, cPluginID, bExtension FROM tplugin28μs16.17KB600000000000030450000000000000000default
SELECT * FROM tplugin WHERE `kPlugin`=?41μs17.2KB10000000000002f8f0000000000000000default
Params
0 5
SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 140μs16.11KB10000000000002f5e0000000000000000default
SELECT * FROM tplugin WHERE `exsID`=?45μs17.25KB20000000000002f3a0000000000000000default
Params
0 d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE `exsID`=?34μs17.22KB00000000000002f290000000000000000default
Params
0 56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort47μs16.34KB60000000000002f6d0000000000000000default
Params
:kPlugin 5
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin29μs16.37KB80000000000002f6a0000000000000000default
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.kLink99μs16.52KB80000000000002f300000000000000000default
Params
:plgn 5
SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)46μs16.2KB80000000000002f4f0000000000000000default
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.cName677μs17.13KB160000000000002f210000000000000000default
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink71μs16.12KB00000000000002f0c0000000000000000default
Params
:kVaterLink 434
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002f070000000000000000default
Params
:kVaterLink 437
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB00000000000002f020000000000000000default
Params
:kVaterLink 432
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink58μs16.12KB00000000000002efd0000000000000000default
Params
:kVaterLink 433
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000030f30000000000000000default
Params
:kVaterLink 439
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000030f80000000000000000default
Params
:kVaterLink 435
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000030fd0000000000000000default
Params
:kVaterLink 436
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000031020000000000000000default
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.nSort237μs17.19KB00000000000002f4c0000000000000000default
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.kPluginSprachvariable239μs16.84KB20000000000002f2c0000000000000000default
Params
:pid 5
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin62μs16.34KB00000000000002f100000000000000000default
Params
:kPlugin 5
SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id71μs16.72KB00000000000002f160000000000000000default
Params
:id 5
SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid64μs16.94KB00000000000002f1a0000000000000000default
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 NULL195μs18.39KB1000000000000311a0000000000000000default
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.nSort188μs17KB0000000000000311a0000000000000000default
Params
:cid 110
SELECT * FROM tkategorie WHERE `kOberKategorie`=?80μs16.95KB500000000000031240000000000000000default
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 NULL174μs18.39KB100000000000031250000000000000000default
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.nSort170μs17KB000000000000031250000000000000000default
Params
:cid 108
SELECT * FROM tkategorie WHERE `kOberKategorie`=?62μs16.93KB4000000000000312e0000000000000000default
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:3 [ "Sortierung" => "100" "qf" => "4" "mf" => array:4 [ 0 => 2 1 => 3 2 => 4...
$_POST: []
$_SESSION: array:36 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#2695 +k...
$_COOKIE: array:1 [ "JTLSHOP" => "n7f7bicgc16dphn0g25aqd3es2" ]
$_SERVER: array:62 [ "USER" => "jtlbalter" "HOME" => "/var/www/vhosts/k08.de" "SCRIPT_NAME" => "/index.p...

TracedStatement.php:39: {#12589 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataCollector\PDO\Trac...
TraceablePDOStatement.php:86: {#12586 +"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: {#8094 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
Bootstrap.php:144: {#8364 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
ProductFilter.php:1662: {#10355 +"level": 2 +"message": "Attempt to read property "kKategorie" on null" +"file": "/var...
smarty_internal_debug.php:146: {#12888 +"level": 2 +"message": "Undefined array key "start_time"" +"file": "/var/www/vhosts/k...
smarty_internal_debug.php:73: {#12614 +"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 {#7994 -parentID: 108 -sort: 0 -names: a...
submenu_items: array:4 [ 0 => JTL\Catalog\Category\Kategorie {#8017 -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 {#10684 -page: 0 -url: null -isActive: f...
filterPagination: JTL\Filter\Pagination\Pagination {#10274 -pages: [] -prev: JTL\Filter\Pagination\Item {#10298 ...
oBestseller_arr: []
KategorieInhalt: {#11057 +"Unterkategorien": JTL\Catalog\Category\KategorieListe {#11047 +elemente: array:5 [ ...
NaviFilter: JTL\Filter\ProductFilter {#8038 -category: JTL\Filter\States\BaseCategory {#8033 #icon: null ...
priceRangeMax: 0
oErweiterteDarstellung: {#10681 +"cURL_arr": array:2 [ 1 => "https://www.k08.de/EVO-HD-IP-2-Draht-BUS__2-Familienhaus_...
Suchergebnisse: JTL\Filter\SearchResults {#10378 -products: Illuminate\Support\Collection {#10980 #items: [] ...
oNavigationsinfo: JTL\Filter\Metadata {#8036 -conf: array:32 [ "global" => array:53 [ "systemlog_flag" => ...
priceRange: null
nMaxAnzahlArtikel: 0
linkgroups: JTL\Link\LinkGroupCollection {#8358 #items: array:13 [ 0 => JTL\Link\LinkGroup {#9914 -n...
manufacturers: array:2 [ 2 => JTL\Catalog\Hersteller {#11124 -kHersteller: 2 -names: array:6 [ 1 =>...
oUnterKategorien_arr: array:5 [ 119 => JTL\Catalog\Category\MenuItem {#2426 -id: 119 -parentID: 110 -languag...
session_name: "JTLSHOP"
session_id: "n7f7bicgc16dphn0g25aqd3es2"
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 {#11152 #items: array:25 [ 5 => JTL\Link\Link {#9939 -data...
bAjaxRequest: false
jtl_token: "<input type="hidden" class="jtl_token" name="jtl_token" value="c20c3bb13d2193124699b2760175e98182d8...
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 {#11139 +cName: "Balter GmbH" +cUnternehmer: "" +cStrasse: "Elisabeth Selbert Str. 1...
showLoginCaptcha: false
AktuelleKategorie: JTL\Catalog\Category\Kategorie {#10308 -parentID: 108 -sort: 1 -names: array:1 [ 1 => "EVO...
cSessionID: "n7f7bicgc16dphn0g25aqd3es2"
opc: JTL\OPC\Service {#11126 #adminName: "" #db: JTL\OPC\DB {#11153 #mapping: [] #shopDB: JTL...
opcPageService: JTL\OPC\PageService {#11970 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#11126 #a...
wishlists: Illuminate\Support\Collection {#11132 #items: [] #escapeWhenCastingToString: false }
shippingCountry: "DE"
countries: Illuminate\Support\Collection {#9534 #items: array:236 [ 60 => JTL\Country\Country {#8699 ...
Link: JTL\Link\Link {#11099 -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 {#11976 #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: true
cCanonicalURL: "https://www.k08.de/EVO-HD-IP-2-Draht-BUS"
robotsContent: null
cShopName: ""
bBoxenFilterNach: true
oPlugin_jtl_paypal_commerce: JTL\Plugin\Plugin {#12349 #id: 1 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plugi...
oPlugin_jtl_theme_editor: JTL\Plugin\Plugin {#12299 #id: 2 #pluginID: "jtl_theme_editor" #state: 2 #meta: JTL\Plugin\D...
oPlugin_balter_custom: JTL\Plugin\Plugin {#12148 #id: 5 #pluginID: "balter_custom" #state: 2 #meta: JTL\Plugin\Data...
parentBlockParams: array:19 [ "class" => scc\ComponentProperty {#12967 -defaultValue: null -isRequired: false...
pbp: array:19 [ "class" => scc\ComponentProperty {#12967 -defaultValue: null -isRequired: false...
bCookieErlaubt: true
Brotnavi: array:3 [ 0 => JTL\Catalog\NavigationEntry {#13029 -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 {#7913 #items: array:2 [ 0 => JTL\Consent\Item {#7912 -id:...
nZeitGebraucht: 0.18398904800415
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

EVO HD - IP 2-Draht-BUS