Türstationen

Filter
Empfehlung Preis aufsteigend Preis absteigend Neueste zuerst Bestseller
Unterputz In Kürze verfügbar Alle Filter zurücksetzen
Konfigurationstool
Das Online-Konfigurationstool hilft Ihnen bei der Zusammenstellung des Sicherheitssystems...
Konfigurationstool
Das Online-Konfigurationstool hilft Ihnen bei der Zusammenstellung des Sicherheitssystems...
Unternehmen
Services
Kontakt
Elektro-Lexikon
Ratgeber
FAQ
TimelineDatabase586ConfigMessagesRequestExceptionsErrors9Smarty
165msRequest Duration8.2.28Version11MBMemory Usage
  • Shop start to end (142ms)
  • shop.hook.250 (4μs)
  • shop.hook.254 (2μs)
  • shop.hook.252 (1μs)
  • shop.hook.251 (1μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.131 (2μs)
  • shop.hook.156 (0μs)
  • shop.hook.361 (1μs)
  • shop.hook.133 (3μs)
  • shop.hook.320 (464μs)
  • shop.hook.250 (2μs)
  • shop.hook.254 (1μs)
  • shop.hook.252 (23.66ms)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (2μs)
  • shop.hook.118 (2μs)
  • shop.hook.302 (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 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.302 (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 (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.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μ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 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μ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 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (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 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μ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.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μ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 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μ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 (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 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μ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.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 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.251 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.214 (1μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (1μs)
  • shop.hook.178 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μ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 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (0μs)
  • shop.hook.221 (3μs)
  • shop.hook.221 (1μs)
  • shop.hook.22 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.118 (2μs)
  • shop.hook.221 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.226 (2μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (0μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (1μs)
  • shop.hook.331 (0μs)
  • shop.hook.118 (1μs)
  • shop.hook.204 (3μs)
  • shop.hook.175 (1μs)
  • shop.hook.109 (3μs)
  • shop.hook.99 (4μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (1μs)
  • shop.hook.89 (2μs)
  • shop.hook.90 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.208 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (3μs)
  • shop.hook.101 (2μs)
  • 1 x Shop start to end (85.99%)
    141.66ms
    2 x shop.hook.252 (14.36%)
    23.66ms
    1 x shop.hook.320 (0.28%)
    464μs
    135 x shop.hook.301 (0.05%)
    81μs
    135 x shop.hook.300 (0.05%)
    75μs
    22 x shop.hook.120 (0.02%)
    33μs
    20 x shop.hook.221 (0.02%)
    26μs
    12 x shop.hook.208 (0.01%)
    21μs
    10 x shop.hook.302 (0%)
    8μs
    15 x shop.hook.253 (0%)
    7μs
    2 x shop.hook.250 (0%)
    6μs
    3 x shop.hook.118 (0%)
    5μs
    6 x shop.hook.330 (0%)
    5μs
    1 x shop.hook.99 (0%)
    4μs
    1 x shop.hook.133 (0%)
    3μs
    1 x shop.hook.109 (0%)
    3μs
    2 x shop.hook.254 (0%)
    3μs
    1 x shop.hook.204 (0%)
    3μs
    1 x shop.hook.132 (0%)
    2μs
    1 x shop.hook.22 (0%)
    2μs
    1 x shop.hook.226 (0%)
    2μs
    1 x shop.hook.89 (0%)
    2μs
    2 x shop.hook.251 (0%)
    2μs
    1 x shop.hook.131 (0%)
    2μs
    1 x shop.hook.142 (0%)
    2μs
    1 x shop.hook.101 (0%)
    2μs
    1 x shop.hook.361 (0%)
    1μs
    1 x shop.hook.303 (0%)
    1μs
    1 x shop.hook.175 (0%)
    1μs
    1 x shop.hook.306 (0%)
    1μs
    1 x shop.hook.400 (0%)
    1μs
    1 x shop.hook.166 (0%)
    1μs
    1 x shop.hook.143 (0%)
    1μs
    1 x shop.hook.214 (0%)
    1μs
    1 x shop.hook.178 (0%)
    1μs
    1 x shop.hook.90 (0%)
    1μs
    1 x shop.hook.156 (0%)
    0μs
    1 x shop.hook.331 (0%)
    0μs
586 statements were executed, 410 of which were duplicates, 176 unique101ms9.58MB
default
  • SELECT * FROM tsprache92μs16.22KB20000000000000b790000000000000000default
  • SELECT * FROM tkundengruppe WHERE `cStandard`=?95μs16.7KB10000000000000b7d0000000000000000default
    Params
    0Y
  • 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.33ms17.39KB530000000000000b840000000000000000default
    Params
    :section1
  • SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe100μs16.25KB00000000000000b390000000000000000default
    Params
    :kKundengruppe1
  • 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.kPlugin144μs16.69KB120000000000000b4f0000000000000000default
    Params
    :state2
  • SELECT * FROM tsprache103μs16.22KB20000000000000aec0000000000000000default
  • SELECT * FROM twaehrung91μs16.23KB10000000000000ae80000000000000000default
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache90μ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 = :section459μs16.95KB27000000000000090b0000000000000000default
    Params
    :section7
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC128μs16.22KB200000000000008ef0000000000000000default
  • SELECT * FROM tglobals WHERE dLetzteAenderung > :ts99μs16.2KB000000000000008f20000000000000000default
    Params
    :ts2025-04-27 10:53:20
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC69μs16.22KB20000000000000baf0000000000000000default
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv111μs16.42KB30000000000000bb00000000000000000default
    Params
    :nAktiv1
  • SELECT kPlugin AS id, bExtension AS modern FROM tplugin WHERE nStatus = :state AND bBootstrap = 1 ORDER BY nPrio ASC47μs16.31KB300000000000008fc0000000000000000default
    Params
    :state2
  • SELECT * FROM tplugin WHERE `kPlugin`=?43μs17.2KB100000000000009010000000000000000default
    Params
    01
  • SELECT tstoreauth.auth_code, tstoreauth.access_token, tadminlogin.cPass AS hash, tstoreauth.verified FROM tstoreauth INNER JOIN tadminlogin ON tadminlogin.kAdminlogin = tstoreauth.owner LIMIT 169μs16.11KB100000000000017010000000000000000default
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 130μs16.11KB100000000000017050000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?34μs17.25KB200000000000017290000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?24μs17.22KB0000000000000173a0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort38μs16.34KB600000000000016f30000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin20μs16.3KB400000000000017110000000000000000default
    Params
    :kPlugin1
  • 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.kLink76μs16.46KB400000000000017310000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)32μs16.14KB400000000000017040000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (105,106,107,108) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName490μs17KB800000000000017050000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB000000000000017400000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000017450000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000174a0000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000174f0000000000000000default
    Params
    :kVaterLink106
  • 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.nSort450μs17.34KB900000000000017300000000000000000default
    Params
    :pid1
  • 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.kPluginSprachvariable316μs34.06KB78000000000000170e0000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin45μs16.34KB0000000000000179b0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id67μs16.78KB400000000000017960000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid58μs16.98KB3000000000000178f0000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort42μs16.55KB3000000000000178f0000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart26μs16.28KB2000000000000178f0000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort32μs16.55KB3000000000000178f0000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart19μs16.28KB2000000000000178f0000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort29μs16.55KB3000000000000178f0000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart23μs16.28KB2000000000000178f0000000000000000default
    Params
    :kZahlungsart75
  • SELECT * FROM tplugin WHERE `kPlugin`=?34μs17.2KB100000000000017c60000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort29μs16.27KB100000000000018650000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin19μs16.24KB0000000000000186c0000000000000000default
    Params
    :kPlugin2
  • 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.kLink56μs16.4KB0000000000000186b0000000000000000default
    Params
    :plgn2
  • 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.nSort131μs17.19KB000000000000018720000000000000000default
    Params
    :pid2
  • 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.kPluginSprachvariable186μs17.13KB1800000000000018790000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin42μs16.34KB0000000000000188e0000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id55μs16.72KB000000000000018890000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid47μs16.94KB000000000000018850000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT cSektion AS sec, cWert AS val, cName AS name FROM ttemplateeinstellungen WHERE cTemplate = (SELECT cTemplate FROM ttemplate WHERE eTyp = 'standard')90μs17.08KB63000000000000187e0000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?32μs17.2KB1000000000000187f0000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 128μs16.11KB100000000000018bf0000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?29μs17.25KB2000000000000189b0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?23μs17.22KB000000000000018e70000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort32μs16.34KB600000000000018ce0000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin21μs16.37KB800000000000018cb0000000000000000default
    Params
    :kPlugin5
  • 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.kLink72μs16.52KB800000000000018e00000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)32μs16.2KB800000000000018b00000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName525μs17.13KB1600000000000018ef0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink48μs16.12KB000000000000019040000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000019090000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000190e0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000019130000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000019180000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000191d0000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000019220000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000019270000000000000000default
    Params
    :kVaterLink438
  • 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.nSort141μs17.19KB000000000000018ad0000000000000000default
    Params
    :pid5
  • 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.kPluginSprachvariable174μs16.84KB200000000000018e40000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin38μs16.34KB000000000000019000000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id50μs16.72KB000000000000018fa0000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid46μs16.94KB000000000000018f60000000000000000default
    Params
    :pidkPlugin\_5\_%
  • SELECT * FROM ttemplate WHERE `eTyp`=?27μs16.85KB1000000000000195d0000000000000000default
    Params
    0standard
  • SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate77μs17.2KB6300000000000019630000000000000000default
    Params
    :cTemplateBALTER
  • SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio34μs16.3KB300000000000019a20000000000000000default
    Params
    :nStatus2
  • SELECT * FROM tconsent WHERE `active`=:active24μs16.27KB20000000000001ee50000000000000000default
    Params
    :active1
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID27μs16.31KB20000000000001eff0000000000000000default
    Params
    :consentID1
  • SELECT * FROM tsprache18μs16.22KB20000000000001eff0000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID20μs16.31KB20000000000001f0a0000000000000000default
    Params
    :consentID2
  • SELECT * FROM tsprache15μs16.22KB20000000000001f0a0000000000000000default
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section50μs16.56KB30000000000001f0a0000000000000000default
    Params
    :section129
  • 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 = :pid321μs17.84KB720000000000001f1a0000000000000000default
    Params
    :pid1
  • SELECT tkategorie.kKategorie, tkategorie.cSeo, tkategorie.cName, tkategorie.kOberKategorie, tkategoriepict.kKategoriePict FROM tkategorie LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie WHERE tkategorie.kOberKategorie = 043μs16.19KB40000000000001f520000000000000000default
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL130μs18.39KB10000000000001f3a0000000000000000default
    Params
    :kid108
    :cgid1
  • 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 = :section501μs17.02KB320000000000001f480000000000000000default
    Params
    :section110
  • 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.nSort132μs17KB00000000000001f740000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.93KB40000000000001f6f0000000000000000default
    Params
    0108
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL127μs18.39KB10000000000001f6e0000000000000000default
    Params
    :kid123
    :cgid1
  • 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.nSort115μs17KB00000000000001f6e0000000000000000default
    Params
    :cid123
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?42μs16.99KB80000000000001f230000000000000000default
    Params
    0123
  • 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 NULL123μs18.39KB10000000000001f240000000000000000default
    Params
    :kid132
    :cgid1
  • 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.nSort120μs17KB00000000000001f240000000000000000default
    Params
    :cid132
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?43μs16.99KB70000000000001f2d0000000000000000default
    Params
    0132
  • 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 NULL143μs18.39KB10000000000001f2e0000000000000000default
    Params
    :kid220
    :cgid1
  • 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.nSort113μs17KB00000000000001f2e0000000000000000default
    Params
    :cid220
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?33μs16.87KB00000000000001f780000000000000000default
    Params
    0220
  • SELECT id_category FROM submenusettings WHERE id = 122μs16.04KB10000000000001f3b0000000000000000default
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL117μs18.39KB10000000000001f320000000000000000default
    Params
    :kid109
    :cgid1
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section3.28ms18.02KB910000000000001f7d0000000000000000default
    Params
    :section9
  • 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 = 139μs16.16KB00000000000001fda0000000000000000default
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort122μs17KB00000000000001fdb0000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.95KB50000000000001fd40000000000000000default
    Params
    0109
  • 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 NULL128μs18.39KB10000000000001fd30000000000000000default
    Params
    :kid110
    :cgid1
  • 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.nSort117μs17KB00000000000001fd30000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?41μs16.95KB50000000000001fca0000000000000000default
    Params
    0110
  • 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 NULL120μs18.39KB10000000000001fc90000000000000000default
    Params
    :kid111
    :cgid1
  • 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.nSort113μs17KB00000000000001fc90000000000000000default
    Params
    :cid111
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?39μs16.93KB40000000000001fc00000000000000000default
    Params
    0111
  • 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 NULL117μs18.39KB10000000000001fbf0000000000000000default
    Params
    :kid112
    :cgid1
  • 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.nSort110μs17KB00000000000001fbf0000000000000000default
    Params
    :cid112
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?40μs16.95KB50000000000001fb60000000000000000default
    Params
    0112
  • 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 NULL114μs18.39KB10000000000001fb50000000000000000default
    Params
    :kid115
    :cgid1
  • 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.nSort107μs17KB00000000000001fb50000000000000000default
    Params
    :cid115
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?32μs16.87KB00000000000001fac0000000000000000default
    Params
    0115
  • 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 NULL117μs18.39KB10000000000001fac0000000000000000default
    Params
    :kid116
    :cgid1
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort130μs17KB00000000000001fac0000000000000000default
    Params
    :cid116
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?35μs16.87KB00000000000001fa20000000000000000default
    Params
    0116
  • SELECT * FROM tland107μs20.19KB2360000000000001f980000000000000000default
  • SELECT cLaender FROM tversandart21μs16.05KB20000000000001f980000000000000000default
  • SELECT DISTINCT cLandIso FROM tstaat49μs16.52KB290000000000001f980000000000000000default
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName64μs16.56KB2400000000000020cc0000000000000000default
    Params
    :cLandIsoAR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName34μs16.34KB900000000000020d90000000000000000default
    Params
    :cLandIsoAT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName33μs16.34KB1000000000000020b80000000000000000default
    Params
    :cLandIsoBE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName50μs16.69KB2800000000000020fb0000000000000000default
    Params
    :cLandIsoBG
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName50μs16.63KB2700000000000021170000000000000000default
    Params
    :cLandIsoBR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.41KB13000000000000213c0000000000000000default
    Params
    :cLandIsoCA
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.63KB26000000000000210b0000000000000000default
    Params
    :cLandIsoCH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName62μs16.81KB3400000000000021770000000000000000default
    Params
    :cLandIsoCN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName27μs16.28KB600000000000021a00000000000000000default
    Params
    :cLandIsoCY
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.44KB1400000000000021980000000000000000default
    Params
    :cLandIsoCZ
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.44KB1600000000000021720000000000000000default
    Params
    :cLandIsoDE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName25μs16.27KB500000000000021d90000000000000000default
    Params
    :cLandIsoDK
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.44KB15000000000000216e0000000000000000default
    Params
    :cLandIsoEE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName73μs17.06KB5000000000000021f80000000000000000default
    Params
    :cLandIsoES
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName41μs16.5KB1900000000000022330000000000000000default
    Params
    :cLandIsoFI
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName142μs18.19KB11400000000000022220000000000000000default
    Params
    :cLandIsoFR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName24μs16.25KB400000000000022c50000000000000000default
    Params
    :cLandIsoGB
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName33μs16.41KB1300000000000022b30000000000000000default
    Params
    :cLandIsoGR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName42μs16.56KB2100000000000022ab0000000000000000default
    Params
    :cLandIsoHR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName58μs16.81KB3600000000000022890000000000000000default
    Params
    :cLandIsoIN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName133μs17.94KB110000000000000222a0000000000000000default
    Params
    :cLandIsoIT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName69μs16.94KB4700000000000023aa0000000000000000default
    Params
    :cLandIsoJP
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName32μs16.34KB10000000000000238b0000000000000000default
    Params
    :cLandIsoLT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName152μs18.19KB11900000000000023960000000000000000default
    Params
    :cLandIsoLV
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.69KB3200000000000024690000000000000000default
    Params
    :cLandIsoMX
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName32μs16.38KB12000000000000244f0000000000000000default
    Params
    :cLandIsoNL
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName64μs16.94KB4200000000000021ef0000000000000000default
    Params
    :cLandIsoRO
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName101μs17.44KB7800000000000024f80000000000000000default
    Params
    :cLandIsoTH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName87μs17.19KB63000000000000256f0000000000000000default
    Params
    :cLandIsoUS
  • SELECT * FROM tfirma LIMIT 127μs16.52KB10000000000001f9b0000000000000000default
  • SELECT * FROM tversandart WHERE cNurAbhaengigeVersandart = :depOnly AND cLaender LIKE :iso AND (cVersandklassen = '-1' OR cVersandklassen RLIKE :sClasses) AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0) ORDER BY nSort67μs16.88KB00000000000001f9e0000000000000000default
    Params
    :iso%DE%
    :cGroupID1
    :sClasses^([0-9 -]* )?
    :depOnlyY
  • 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 > 095μs16.59KB2200000000000020a80000000000000000default
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName46μs16.27KB000000000000020890000000000000000default
    Params
    :lgid1
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName42μs16.37KB600000000000020840000000000000000default
    Params
    :lgid4
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (440,442,68,71,443,444)30μs16.17KB600000000000020850000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (68,71,440,442,443,444) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName472μs17.06KB1200000000000020740000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB000000000000020630000000000000000default
    Params
    :kVaterLink440
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB0000000000000205e0000000000000000default
    Params
    :kVaterLink442
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020590000000000000000default
    Params
    :kVaterLink68
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020540000000000000000default
    Params
    :kVaterLink71
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000204f0000000000000000default
    Params
    :kVaterLink443
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000204a0000000000000000default
    Params
    :kVaterLink444
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName61μs16.37KB600000000000020690000000000000000default
    Params
    :lgid5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (69,67,59,49,73,74)30μs16.17KB600000000000020680000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (49,59,67,69,73,74) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName463μs17.06KB12000000000000207b0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.12KB0000000000000203c0000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000020370000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020320000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000202d0000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020280000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020230000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName84μs16.71KB2700000000000020420000000000000000default
    Params
    :lgid8
  • 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)50μs16.52KB2700000000000020410000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (3,4,63,72,75,76,77,78,79,80,81,83,84,85,86,105,106,107,108,432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName829μs33.75KB540000000000001ffc0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB000000000000025410000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000025460000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000254b0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025500000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025550000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000255a0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000255f0000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000025640000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025690000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000260e0000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026130000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026180000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000261d0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026220000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026270000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000262c0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026310000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026360000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000263b0000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026400000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026450000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000264a0000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000264f0000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.1KB000000000000026540000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026590000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.1KB0000000000000265e0000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026630000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName62μs16.37KB60000000000001f930000000000000000default
    Params
    :lgid9
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (103,104,420,422,64,61)31μs16.17KB60000000000001f940000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (61,64,103,104,420,422) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName437μs17.03KB100000000000001f830000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000001fe60000000000000000default
    Params
    :kVaterLink103
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB00000000000001feb0000000000000000default
    Params
    :kVaterLink104
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000001ff00000000000000000default
    Params
    :kVaterLink420
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB00000000000001ff50000000000000000default
    Params
    :kVaterLink422
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020170000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020010000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName60μs16.35KB50000000000001fe00000000000000000default
    Params
    :lgid10
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (109,112,111,110,113)29μs16.16KB50000000000001fe10000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (109,110,111,112,113) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName435μs17.03KB100000000000001f8a0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB0000000000000200d0000000000000000default
    Params
    :kVaterLink109
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000020120000000000000000default
    Params
    :kVaterLink112
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020410000000000000000default
    Params
    :kVaterLink111
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000201c0000000000000000default
    Params
    :kVaterLink110
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000207b0000000000000000default
    Params
    :kVaterLink113
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName58μs16.32KB300000000000020070000000000000000default
    Params
    :lgid11
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (446,448,447)27μs16.13KB300000000000020080000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (446,447,448) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName386μs16.97KB60000000000001f870000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink40μs16.12KB000000000000020680000000000000000default
    Params
    :kVaterLink446
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000020850000000000000000default
    Params
    :kVaterLink448
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000204b0000000000000000default
    Params
    :kVaterLink447
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName55μs16.32KB30000000000001f320000000000000000default
    Params
    :lgid12
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (115,50,66)26μs16.13KB30000000000001f7d0000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (50,66,115) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName404μs16.97KB600000000000020740000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB000000000000026720000000000000000default
    Params
    :kVaterLink115
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000026770000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000267c0000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName55μs16.34KB4000000000000266c0000000000000000default
    Params
    :lgid13
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (116,118,119,117)27μs16.14KB4000000000000266d0000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (116,117,118,119) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName409μs17KB800000000000026810000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink41μs16.12KB0000000000000268e0000000000000000default
    Params
    :kVaterLink116
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026930000000000000000default
    Params
    :kVaterLink118
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026980000000000000000default
    Params
    :kVaterLink119
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000269d0000000000000000default
    Params
    :kVaterLink117
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName50μs16.29KB100000000000026880000000000000000default
    Params
    :lgid14
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (120)20μs16.09KB100000000000026890000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (120) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName168μs16.91KB200000000000026800000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink31μs16.12KB000000000000026810000000000000000default
    Params
    :kVaterLink120
  • 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.kSprache701μs34KB7400000000000020900000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.1KB000000000000026d60000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.1KB000000000000026db0000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000026e00000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026e50000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026ea0000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000026ef0000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026f40000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026f90000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026fe0000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027030000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027080000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB0000000000000270d0000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027120000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027170000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000271c0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027210000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027260000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000272b0000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027300000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027350000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000273a0000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000273f0000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000027440000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027490000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000274e0000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000027530000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027580000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000275d0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027620000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027670000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000276c0000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027710000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027760000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000277b0000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027800000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027850000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000278a0000000000000000default
    Params
    :kVaterLink439
  • 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.kSprache539μs17.23KB2600000000000026d10000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.1KB000000000000026b00000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000026ab0000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026a60000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026800000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000268b0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020a20000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020a00000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020940000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000209b0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027900000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027950000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000279a0000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000279f0000000000000000default
    Params
    :kVaterLink86
  • 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.kSprache265μs16.75KB000000000000026b50000000000000000default
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section75μs16.56KB300000000000027a90000000000000000default
    Params
    :section128
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?39μs16.74KB1000000000000280b0000000000000000default
    Params
    0kMerkmalWert
    1Unterputz_1
  • SELECT * FROM tseo WHERE cSeo = :slg20μs16.22KB1000000000000280e0000000000000000default
    Params
    :slgTuerstationen
  • 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 NULL131μs18.39KB100000000000028120000000000000000default
    Params
    :kid114
    :cgid1
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort124μs17KB000000000000028120000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.93KB4000000000000281c0000000000000000default
    Params
    0114
  • SELECT tmerkmalwert.kMerkmal, tmerkmalwert.kMerkmalWert, tmerkmal.nMehrfachauswahl FROM tmerkmalwert JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal WHERE kMerkmalWert IN (18)37μs16.09KB10000000000001f540000000000000000default
  • 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 = :val52μs16.89KB1000000000000281c0000000000000000default
    Params
    :val18
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache42μs16.08KB2000000000000281d0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache27μs16.08KB200000000000028230000000000000000default
  • 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 NULL119μs18.39KB1000000000000282b0000000000000000default
    Params
    :kid114
    :cgid1
  • 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.nSort117μs17KB0000000000000282b0000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?42μs16.93KB400000000000028350000000000000000default
    Params
    0114
  • 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 NULL120μs18.39KB100000000000028360000000000000000default
    Params
    :kid114
    :cgid1
  • 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.nSort113μs17KB000000000000028360000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?41μs16.93KB4000000000000283f0000000000000000default
    Params
    0114
  • 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 NULL119μs18.39KB1000000000000283a0000000000000000default
    Params
    :kid114
    :cgid1
  • 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.nSort118μs17KB0000000000000283a0000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?38μs16.93KB400000000000028480000000000000000default
    Params
    0114
  • 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 NULL116μs18.39KB100000000000028430000000000000000default
    Params
    :kid114
    :cgid1
  • 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.nSort109μs17KB000000000000028430000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?39μs16.93KB400000000000028510000000000000000default
    Params
    0114
  • 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 NULL114μs18.39KB1000000000000284c0000000000000000default
    Params
    :kid109
    :cgid1
  • 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.nSort135μs17KB0000000000000284c0000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?41μs16.95KB5000000000000285a0000000000000000default
    Params
    0109
  • 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 NULL111μs18.39KB1000000000000285b0000000000000000default
    Params
    :kid108
    :cgid1
  • 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.nSort107μs17KB0000000000000285b0000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?40μs16.93KB400000000000028640000000000000000default
    Params
    0108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie27μs16.47KB4000000000000286a0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB0000000000000286a0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000286a0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000286a0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000286a0000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((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.cName128μs16.02KB000000000000028680000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie33μs16.47KB4000000000000287f0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((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.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.cName188μs17.91KB000000000000028830000000000000000default
    Params
    :lid1
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie35μs16.47KB4000000000000287e0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB0000000000000287e0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB0000000000000287e0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie16μs16.41KB0000000000000287e0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB0000000000000287e0000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((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.cName ) AS ssMerkmal GROUP BY ssMerkmal.nSterne ORDER BY ssMerkmal.nSterne DESC138μs16.05KB000000000000028950000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.47KB400000000000028850000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie16μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie202
  • SELECT kKategorie FROM tkategoriesichtbarkeit13μs16.02KB000000000000028a70000000000000000default
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((NOW() < tartikel.dErscheinungsdatum)) 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.cName151μs17.88KB000000000000028b60000000000000000default
    Params
    :lid1
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.47KB400000000000028950000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028950000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028950000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028950000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028950000000000000000default
    Params
    :kOberKategorie202
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.47KB400000000000028cf0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie16μs16.41KB000000000000028cf0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028cf0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028cf0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB000000000000028cf0000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((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.cName ) AS ssMerkmal241μs16.06KB100000000000028e30000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie43μs16.47KB400000000000028be0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028be0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000028be0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028be0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028be0000000000000000default
    Params
    :kOberKategorie202
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.47KB400000000000028e50000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028e50000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028e50000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028e50000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000028e50000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName122μs16.02KB000000000000028bc0000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.47KB400000000000028ee0000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000028ee0000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028ee0000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000028ee0000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie16μs16.41KB000000000000028ee0000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName140μs16.02KB000000000000028d40000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.47KB400000000000029000000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029000000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000029000000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029000000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029000000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName103μs16.02KB000000000000028950000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.47KB400000000000029150000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029150000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029150000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029150000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029150000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName110μs16.02KB000000000000029010000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.47KB400000000000029220000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029220000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029220000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029220000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000029220000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName97μs16.02KB000000000000029020000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.47KB400000000000029330000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000029330000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029330000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029330000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000029330000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz 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.cName115μs16.02KB000000000000028f10000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.47KB400000000000029240000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000029240000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000029240000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029240000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB000000000000029240000000000000000default
    Params
    :kOberKategorie202
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((NOW() < tartikel.dErscheinungsdatum)) 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 ASC144μs16.05KB000000000000029440000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.47KB400000000000029340000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029340000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000029340000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie16μs16.41KB000000000000029340000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie17μs16.41KB000000000000029340000000000000000default
    Params
    :kOberKategorie202
  • SELECT ssMerkmal.cSeo, ssMerkmal.kMerkmal, ssMerkmal.kMerkmalWert, ssMerkmal.cMMWBildPfad, ssMerkmal.nMehrfachauswahl, ssMerkmal.cWert, ssMerkmal.cName, ssMerkmal.cTyp, ssMerkmal.cMMBildPfad, COUNT(DISTINCT ssMerkmal.kArtikel) AS nAnzahl FROM (SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.cSeo, tmerkmal.cName, tartikel.kArtikel AS kArtikel, tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert, tmerkmalwert.cBildPfad AS cMMWBildPfad, tmerkmal.nSort AS nSortMerkmal, tmerkmalwert.nSort, tmerkmal.cTyp, tmerkmal.nMehrfachauswahl, tmerkmal.cBildPfad AS cMMBildPfad FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join1 from JTL\Filter\Items\Characteristic::getState JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join2 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert #join4 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal #join default lang from JTL\Filter\Items\Characteristic::getState INNER JOIN tmerkmalwertsprache ON tmerkmalwertsprache.kMerkmalWert = tartikelmerkmal.kMerkmalWert AND tmerkmalwertsprache.kSprache = 1 #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 = 114 OR tkategorieartikel.kKategorie = 113 OR tkategorieartikel.kKategorie = 200 OR tkategorieartikel.kKategorie = 201 OR tkategorieartikel.kKategorie = 202 AND #condition from filter qf ((NOW() < tartikel.dErscheinungsdatum)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 ) AS ssMerkmal GROUP BY ssMerkmal.kMerkmalWert ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert297μs16.3KB300000000000029330000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 129μs16.16KB1000000000000297d0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 117μs16.16KB100000000000029820000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 114μs16.16KB100000000000029810000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029870000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB1000000000000298a0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 114μs16.16KB1000000000000298d0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029900000000000000000default
    Params
    :cid1
  • 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 (2)56μs16.17KB1000000000000297c0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache40μs16.08KB200000000000029970000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 116μs16.2KB100000000000029960000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB1000000000000299d0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB1000000000000299c0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029a20000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029a50000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029a80000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029ab0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029ab0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029b30000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029b20000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029b80000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029bb0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029be0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029c10000000000000000default
    Params
    :cid11
  • 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)43μs16.17KB100000000000029ae0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache31μs16.08KB200000000000029c70000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 115μs16.2KB100000000000029c60000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB100000000000029cd0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029cc0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB100000000000029d20000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029d50000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029d80000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB100000000000029db0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029db0000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029e30000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029e20000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029e80000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029eb0000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 112μs16.16KB100000000000029ee0000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 113μs16.16KB100000000000029f10000000000000000default
    Params
    :cid12
  • 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)39μs16.17KB100000000000029de0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache28μs16.08KB200000000000029f70000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 114μs16.2KB100000000000029f60000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB100000000000029fd0000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB100000000000029fc0000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB10000000000002a020000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB10000000000002a050000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 112μs16.2KB10000000000002a080000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 113μs16.2KB10000000000002a0b0000000000000000default
    Params
    :cid18
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache26μs16.08KB200000000000029330000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB200000000000029720000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB200000000000029340000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB200000000000029610000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a0e0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB200000000000029740000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a100000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a120000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a150000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache26μs16.08KB20000000000002a180000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a1b0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB20000000000002a1e0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB200000000000029780000000000000000default
  • 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.89KB10000000000002a1b0000000000000000default
    Params
    :val12
  • 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 = :val34μs16.89KB10000000000002a250000000000000000default
    Params
    :val12
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache26μs16.08KB20000000000002a290000000000000000default
  • 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 = :val34μs16.89KB10000000000002a2c0000000000000000default
    Params
    :val18
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache25μs16.08KB20000000000002a2e0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a290000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB20000000000002a210000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a320000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a230000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache23μs16.08KB20000000000002a230000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache24μs16.08KB20000000000002a3c0000000000000000default
  • 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.1ms17.39KB510000000000002a3d0000000000000000default
    Params
    :section4
  • 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 (200, 113, 201, 202)) ORDER BY rand() LIMIT 6145μs16.9KB00000000000002a730000000000000000default
    Params
    :cgid1
  • 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 (200, 113, 201, 202)) ORDER BY tbestseller.fAnzahl DESC LIMIT 6107μs17.02KB00000000000002a6f0000000000000000default
    Params
    :cgid1
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section63μs16.59KB50000000000002a6b0000000000000000default
    Params
    :section121
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (5) ORDER BY kSprache37μs16.08KB20000000000002a670000000000000000default
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB1000000000000282a0000000000000000default
    Params
    :kid109
    :cgid1
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort127μs17KB0000000000000282a0000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.95KB50000000000002a550000000000000000default
    Params
    0109
  • 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 NULL125μs18.39KB10000000000002a540000000000000000default
    Params
    :kid108
    :cgid1
  • 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.nSort117μs17KB00000000000002a540000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?43μs16.93KB40000000000002a4b0000000000000000default
    Params
    0108
  • SELECT * FROM tfirma LIMIT 127μs16.52KB10000000000002a500000000000000000default
  • 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 nSort61μs16.88KB00000000000002a480000000000000000default
    Params
    :iso%DE%
    :cGroupID1
    :sClasses^([0-9 -]* )?
    :depOnlyY
  • 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.cName642μs18KB120000000000002a420000000000000000default
    Params
    :skeykHersteller
    :cgid1
  • 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 NULL95μs16.02KB00000000000002a800000000000000000default
  • SELECT * FROM tfirma LIMIT 130μs16.52KB10000000000002a920000000000000000default
  • 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 DESC71μs16.61KB30000000000002dd90000000000000000default
    Params
    :state2
  • 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 = :section51μs16.53KB10000000000002df40000000000000000default
    Params
    :section125
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache23μs16.08KB00000000000002dfd0000000000000000default
  • SELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC217μs40.16KB4990000000000002e0a0000000000000000default
  • 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)19.18ms688B10000000000002e090000000000000000default
    Params
    :interval3
  • DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)8ms128B10000000000002e090000000000000000default
    Params
    :interval3
  • SELECT * FROM tbesucher WHERE `cSessID`=?16.46ms16.91KB00000000000002e090000000000000000default
    Params
    0k30qlvsvhp5h2rhajlgdub5ls5
  • SELECT * FROM tbesucher WHERE `cID`=?112μs16.93KB10000000000002e090000000000000000default
    Params
    06de963f636af106cc9d06807afb778fa
  • UPDATE tbesucher SET `kBesucher`=?,`cIP`=?,`cSessID`=?,`cID`=?,`kKunde`=?,`kBestellung`=?,`cReferer`=?,`cUserAgent`=?,`cEinstiegsseite`=?,`cBrowser`=?,`cAusstiegsseite`=?,`kBesucherBot`=?,`dLetzteAktivitaet`=?,`dZeit`=? WHERE `kBesucher`=?7.94ms2.28KB10000000000002e090000000000000000default
    Params
    0129104
    13.147.0.0
    2k30qlvsvhp5h2rhajlgdub5ls5
    36de963f636af106cc9d06807afb778fa
    40
    50
    6
    7Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    8/Monitore::BALTER?Sortierung=100
    9Sonstige
    10/Tuerstationen__Unterputz_1?qf=5
    110
    122025-04-27 10:56:28
    132025-04-27 10:56:18
    14129104
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv120μs16.38KB3000000000000090d0000000000000000default
    Params
    :nAktiv1
  • 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 = '')111μs16.42KB00000000000002feb0000000000000000default
    Params
    :lid1
    :cgid1
    :ptype2
    :ckykKategorie
    :cval114
  • SELECT * FROM tboxenanzeige38μs17.58KB820000000000002fe10000000000000000default
  • SELECT tboxen.kBox, tboxen.kBoxvorlage, tboxen.kCustomID, tboxen.kContainer, tboxen.cTitel, tboxen.ePosition, tboxensichtbar.kSeite, tboxensichtbar.nSort, tboxensichtbar.cFilter, tboxvorlage.eTyp, tboxvorlage.cVerfuegbar, tboxvorlage.cName, tboxvorlage.cTemplate, tplugin.nStatus AS pluginStatus, GROUP_CONCAT(tboxensichtbar.nSort) AS sortBypageIDs, GROUP_CONCAT(tboxensichtbar.kSeite) AS pageIDs, GROUP_CONCAT(tboxensichtbar.bAktiv) AS pageVisibilities, tsprache.kSprache, tboxsprache.cInhalt, tboxsprache.cTitel FROM tboxen LEFT JOIN tboxensichtbar ON tboxen.kBox = tboxensichtbar.kBox LEFT JOIN tplugin ON tboxen.kCustomID = tplugin.kPlugin LEFT JOIN tboxvorlage ON tboxen.kBoxvorlage = tboxvorlage.kBoxvorlage LEFT JOIN tboxsprache ON tboxsprache.kBox = tboxen.kBox LEFT JOIN tsprache ON tsprache.cISO = tboxsprache.cISO WHERE tboxen.kContainer > -1 AND FIND_IN_SET(tboxensichtbar.kSeite, "0,1,2,3,4,5,7,8,9,10,11,12,14,15,16,17,18,19,20,21,23,24,25,26,27,28,29,31,32,33,36,38,40,41,42") > 0 AND tboxen.ePosition IN ('left','bottom') AND (tplugin.nStatus = 2 OR tboxvorlage.eTyp IS NULL OR (tboxvorlage.eTyp != 'plugin' AND tboxvorlage.eTyp != 'extension')) GROUP BY tboxsprache.kBoxSprache, tboxen.kBox, tboxensichtbar.cFilter ORDER BY tboxensichtbar.nSort, tboxen.kBox ASC7.08ms97KB320000000000002f650000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie70μs16.47KB40000000000002f660000000000000000default
    Params
    :kOberKategorie114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie28μs16.41KB00000000000002f660000000000000000default
    Params
    :kOberKategorie113
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB00000000000002f660000000000000000default
    Params
    :kOberKategorie200
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie35μs16.41KB00000000000002f660000000000000000default
    Params
    :kOberKategorie201
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB00000000000002f660000000000000000default
    Params
    :kOberKategorie202
  • 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 1054μs16.02KB00000000000002f670000000000000000default
  • 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 #condition from filter mf tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #condition from filter qf ((NOW() < tartikel.dErscheinungsdatum)) 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.cSuche235μs16.09KB00000000000002f670000000000000000default
  • 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 :lmt95μs17.27KB00000000000002f780000000000000000default
    Params
    :lmt10
    :cgid1
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin30μs16.17KB60000000000002f5a0000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?35μs17.2KB10000000000002f510000000000000000default
    Params
    01
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 132μs16.11KB10000000000002fba0000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?35μs17.25KB20000000000002fd20000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?26μs17.22KB00000000000002f8c0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort43μs16.34KB60000000000002f460000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin23μs16.3KB40000000000002fc20000000000000000default
    Params
    :kPlugin1
  • 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.kLink76μs16.46KB40000000000002f8a0000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)31μs16.14KB40000000000002f7b0000000000000000default
  • 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.cName465μs17KB80000000000002fba0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB00000000000002f390000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB00000000000002f340000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002f2f0000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002f2a0000000000000000default
    Params
    :kVaterLink106
  • 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.nSort491μs17.34KB90000000000002fd70000000000000000default
    Params
    :pid1
  • 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.kPluginSprachvariable315μs34.06KB780000000000002fc00000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin51μs16.34KB00000000000002ede0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id72μs16.78KB40000000000002ee30000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid66μs16.98KB30000000000002eea0000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort47μs16.55KB30000000000002eea0000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart29μs16.28KB20000000000002eea0000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort35μs16.55KB30000000000002eea0000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart21μs16.28KB20000000000002eea0000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort32μs16.55KB30000000000002eea0000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart20μs16.28KB20000000000002eea0000000000000000default
    Params
    :kZahlungsart75
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin21μs16.17KB60000000000002f570000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?32μs17.2KB10000000000002ef10000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort30μs16.27KB10000000000002f250000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin22μs16.24KB00000000000002eb50000000000000000default
    Params
    :kPlugin2
  • SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink61μs16.4KB00000000000002fbd0000000000000000default
    Params
    :plgn2
  • 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.nSort149μs17.19KB00000000000002eaf0000000000000000default
    Params
    :pid2
  • 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.kPluginSprachvariable195μs17.13KB180000000000002ea80000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin48μs16.34KB00000000000002e930000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id60μs16.72KB00000000000002e980000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid50μs16.94KB00000000000002e9c0000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin23μs16.17KB60000000000002f550000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?32μs17.2KB10000000000002ea20000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 127μs16.11KB10000000000002e710000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?34μs17.25KB20000000000002e4d0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?25μs17.22KB00000000000002e3c0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort37μs16.34KB60000000000002e800000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin24μs16.37KB80000000000002e7d0000000000000000default
    Params
    :kPlugin5
  • SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink79μs16.52KB80000000000002e430000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)35μs16.2KB80000000000002e620000000000000000default
  • 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.cName525μs17.13KB160000000000002e340000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB00000000000002e1f0000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB00000000000002e1a0000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB00000000000002e150000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000002e100000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000030000000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000030050000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000300a0000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000300f0000000000000000default
    Params
    :kVaterLink438
  • 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.nSort157μs17.19KB00000000000002e5f0000000000000000default
    Params
    :pid5
  • 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.kPluginSprachvariable163μs16.84KB20000000000002e3f0000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin42μs16.34KB00000000000002e230000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id67μs16.72KB00000000000002e290000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid50μs16.94KB00000000000002e2d0000000000000000default
    Params
    :pidkPlugin\_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 NULL148μs18.39KB100000000000030270000000000000000default
    Params
    :kid114
    :cgid1
  • 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.nSort133μs17KB000000000000030270000000000000000default
    Params
    :cid114
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?48μs16.93KB400000000000030310000000000000000default
    Params
    0114
  • 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 NULL143μs18.39KB100000000000030320000000000000000default
    Params
    :kid109
    :cgid1
  • 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.nSort137μs17KB000000000000030320000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?51μs16.95KB5000000000000303b0000000000000000default
    Params
    0109
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL137μs18.39KB1000000000000303c0000000000000000default
    Params
    :kid108
    :cgid1
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort129μs17KB0000000000000303c0000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.93KB400000000000030450000000000000000default
    Params
    0108
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:2 [ "qf" => "5" "mf" => array:1 [ 0 => 18 ] ]
    $_POST
    []
    $_SESSION
    array:31 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#2695 +k...
    $_COOKIE
    array:1 [ "JTLSHOP" => "k30qlvsvhp5h2rhajlgdub5ls5" ]
    $_SERVER
    array:62 [ "USER" => "jtlbalter" "HOME" => "/var/www/vhosts/k08.de" "SCRIPT_NAME" => "/index.p...
      TracedStatement.php:39
      {#12356 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataCollector\PDO\Trac...
      TraceablePDOStatement.php:86
      {#12353 +"level": 8192 +"message": "Use of "parent" in callables is deprecated" +"file": "/var...
      DataFormatter.php:23
      {#2906 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataFormatter\DataForma...
      DataFormatter.php:24
      {#2904 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataFormatter\DataForma...
      Bootstrap.php:139
      {#8095 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      Bootstrap.php:144
      {#8365 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      ProductFilter.php:1662
      {#10344 +"level": 2 +"message": "Attempt to read property "kKategorie" on null" +"file": "/var...
      smarty_internal_debug.php:146
      {#12653 +"level": 2 +"message": "Undefined array key "start_time"" +"file": "/var/www/vhosts/k...
      smarty_internal_debug.php:73
      {#12589 +"level": 2 +"message": "Undefined array key "start_template_time"" +"file": "/var/www...
      tplDir
      "/var/www/vhosts/k08.de/httpdocs/templates/BALTER/"
      parentTemplateDir
      null
      newsletter_url
      "https://www.k08.de/plugins/balter_custom/NewsletterHandler.php"
      activated_categories
      array:6 [ 0 => JTL\Catalog\Category\Kategorie {#7995 -parentID: 108 -sort: 0 -names: a...
      submenu_items
      array:4 [ 0 => JTL\Catalog\Category\Kategorie {#8018 -parentID: 0 -sort: 0 -names: arr...
      categories_count
      4
      activated_categories_count
      6
      homeurl
      "https://www.k08.de/Start"
      coupon
      0.0
      currentCoupon
      null
      cart
      JTL\Cart\Cart {#2695 +kWarenkorb: null +kKunde: null +kLieferadresse: null +kZahlungsInfo: 0...
      FavourableShipping
      null
      oNaviSeite_arr
      array:2 [ "vor" => JTL\Filter\Pagination\Item {#10619 -page: 0 -url: null -isActive: f...
      filterPagination
      JTL\Filter\Pagination\Pagination {#10275 -pages: [] -prev: JTL\Filter\Pagination\Item {#10278 ...
      oBestseller_arr
      []
      KategorieInhalt
      {#2318 +"Unterkategorien": JTL\Catalog\Category\KategorieListe {#10811 +elemente: array:4 [ ...
      NaviFilter
      JTL\Filter\ProductFilter {#8039 -category: JTL\Filter\States\BaseCategory {#8034 #icon: null ...
      priceRangeMax
      0
      oErweiterteDarstellung
      {#2319 +"cURL_arr": array:2 [ 1 => "https://www.k08.de/Tuerstationen__Unterputz_1?qf=5&amp;ed=...
      Suchergebnisse
      JTL\Filter\SearchResults {#10351 -products: Illuminate\Support\Collection {#10614 #items: [] ...
      oNavigationsinfo
      JTL\Filter\Metadata {#8037 -conf: array:32 [ "global" => array:53 [ "systemlog_flag" => ...
      priceRange
      null
      nMaxAnzahlArtikel
      0
      linkgroups
      JTL\Link\LinkGroupCollection {#8359 #items: array:13 [ 0 => JTL\Link\LinkGroup {#9915 -n...
      manufacturers
      array:2 [ 2 => JTL\Catalog\Hersteller {#10884 -kHersteller: 2 -names: array:6 [ 1 =>...
      oUnterKategorien_arr
      array:4 [ 200 => JTL\Catalog\Category\MenuItem {#2435 -id: 200 -parentID: 114 -languag...
      session_name
      "JTLSHOP"
      session_id
      "k30qlvsvhp5h2rhajlgdub5ls5"
      NettoPreise
      0
      KaufabwicklungsURL
      "https://www.k08.de/Bestellvorgang"
      WarenkorbArtikelPositionenanzahl
      0
      WarenkorbWarensumme
      array:2 [ 0 => "0,00 &euro;" 1 => "0,00 &euro;" ]
      WarenkorbGesamtsumme
      array:2 [ 0 => "0,00 &euro;" 1 => "0,00 &euro;" ]
      WarenkorbGesamtgewicht
      0
      Warenkorbtext
      "Es befinden sich keine Artikel im Warenkorb."
      zuletztInWarenkorbGelegterArtikel
      null
      WarenkorbVersandkostenfreiHinweis
      ""
      oSpezialseiten_arr
      Illuminate\Support\Collection {#10912 #items: array:25 [ 5 => JTL\Link\Link {#9940 -data...
      bAjaxRequest
      false
      jtl_token
      "<input type="hidden" class="jtl_token" name="jtl_token" value="9dfaac30d5d0dccc47c3c680d5e8ea9f567a...
      nSeitenTyp
      2
      bExclusive
      false
      bAdminWartungsmodus
      false
      WarensummeLocalized
      array:2 [ 0 => "0,00 &euro;" 1 => "0,00 &euro;" ]
      Steuerpositionen
      []
      favourableShippingString
      ""
      Einstellungen
      array:32 [ "global" => array:53 [ "systemlog_flag" => 330 "admin_login_logger_mode" => arr...
      deletedPositions
      []
      updatedPositions
      []
      Firma
      JTL\Firma {#10899 +cName: "Balter GmbH" +cUnternehmer: "" +cStrasse: "Elisabeth Selbert Str. 1...
      showLoginCaptcha
      false
      AktuelleKategorie
      JTL\Catalog\Category\Kategorie {#10288 -parentID: 109 -sort: 1 -names: array:1 [ 1 => "Tür...
      cSessionID
      "k30qlvsvhp5h2rhajlgdub5ls5"
      opc
      JTL\OPC\Service {#10886 #adminName: "" #db: JTL\OPC\DB {#10913 #mapping: [] #shopDB: JTL...
      opcPageService
      JTL\OPC\PageService {#11730 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#10886 #a...
      wishlists
      Illuminate\Support\Collection {#10892 #items: [] #escapeWhenCastingToString: false }
      shippingCountry
      "DE"
      countries
      Illuminate\Support\Collection {#9535 #items: array:236 [ 60 => JTL\Country\Country {#8700 ...
      Link
      JTL\Link\Link {#10848 -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 {#11736 #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/Tuerstationen"
      robotsContent
      null
      cShopName
      ""
      bBoxenFilterNach
      true
      oPlugin_jtl_paypal_commerce
      JTL\Plugin\Plugin {#12109 #id: 1 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plugi...
      oPlugin_jtl_theme_editor
      JTL\Plugin\Plugin {#12062 #id: 2 #pluginID: "jtl_theme_editor" #state: 2 #meta: JTL\Plugin\D...
      oPlugin_balter_custom
      JTL\Plugin\Plugin {#11911 #id: 5 #pluginID: "balter_custom" #state: 2 #meta: JTL\Plugin\Data...
      parentBlockParams
      array:19 [ "class" => scc\ComponentProperty {#12732 -defaultValue: null -isRequired: false...
      pbp
      array:19 [ "class" => scc\ComponentProperty {#12732 -defaultValue: null -isRequired: false...
      bCookieErlaubt
      true
      Brotnavi
      array:4 [ 0 => JTL\Catalog\NavigationEntry {#12794 -name: "Startseite" -url: "/" -urlF...
      nIsSSL
      1
      boxes
      array:4 [ "top" => null "right" => null "bottom" => """ <div class="box box-linkgroup box-...
      boxesLeftActive
      true
      consentItems
      Illuminate\Support\Collection {#7914 #items: array:2 [ 0 => JTL\Consent\Item {#7913 -id:...
      nZeitGebraucht
      0.16448211669922
      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"