HD Türstationen

Filter
Empfehlung Preis aufsteigend Preis absteigend Neueste zuerst Bestseller
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
TimelineDatabase638ConfigMessagesRequestExceptionsErrors9Smarty
1.32sRequest Duration8.2.28Version12MBMemory Usage
  • Shop start to end (1.29s)
  • shop.hook.250 (7μs)
  • shop.hook.254 (2μs)
  • shop.hook.252 (2μs)
  • shop.hook.251 (2μs)
  • shop.hook.300 (7μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (6μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (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 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.131 (2μs)
  • shop.hook.156 (1μs)
  • shop.hook.361 (2μs)
  • shop.hook.133 (6μs)
  • shop.hook.320 (949μs)
  • shop.hook.250 (3μs)
  • shop.hook.254 (1μs)
  • shop.hook.252 (43.45ms)
  • shop.hook.120 (7μs)
  • shop.hook.120 (5μs)
  • shop.hook.120 (5μs)
  • shop.hook.120 (5μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (1μs)
  • shop.hook.118 (6μs)
  • shop.hook.302 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (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.302 (1μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (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 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μ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 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μ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 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (10μs)
  • shop.hook.300 (3μs)
  • shop.hook.301 (4μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (4μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (4μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (5μs)
  • shop.hook.302 (3μs)
  • shop.hook.300 (5μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.302 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.302 (2μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.302 (2μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (8μ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 (7μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (5μs)
  • shop.hook.301 (8μs)
  • shop.hook.302 (2μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (7μs)
  • shop.hook.300 (3μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (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 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (5μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (6μ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 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (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 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.306 (3μs)
  • shop.hook.303 (2μs)
  • shop.hook.142 (9μs)
  • shop.hook.400 (2μs)
  • shop.hook.132 (5μs)
  • shop.hook.166 (2μs)
  • shop.hook.143 (5μs)
  • shop.hook.120 (5μs)
  • shop.hook.251 (4μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (4μs)
  • shop.hook.214 (4μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (3μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.178 (4μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (3μs)
  • shop.hook.221 (6μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (8μs)
  • shop.hook.221 (3μs)
  • shop.hook.22 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.118 (3μs)
  • shop.hook.221 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.226 (4μs)
  • shop.hook.330 (3μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (3μs)
  • shop.hook.330 (2μs)
  • shop.hook.331 (2μs)
  • shop.hook.118 (2μs)
  • shop.hook.204 (6μs)
  • shop.hook.175 (2μs)
  • shop.hook.109 (6μs)
  • shop.hook.99 (3μs)
  • shop.hook.221 (9μs)
  • shop.hook.253 (2μs)
  • shop.hook.89 (5μs)
  • shop.hook.90 (1μs)
  • shop.hook.221 (3μs)
  • shop.hook.208 (3μs)
  • shop.hook.300 (6μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (4μ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 (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.208 (3μs)
  • shop.hook.120 (5μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (2μs)
  • shop.hook.208 (6μs)
  • shop.hook.208 (7μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (3μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (3μs)
  • shop.hook.208 (4μs)
  • shop.hook.101 (3μs)
  • 1 x Shop start to end (97.68%)
    1.29s
    2 x shop.hook.252 (3.28%)
    43.45ms
    1 x shop.hook.320 (0.07%)
    949μs
    135 x shop.hook.301 (0.02%)
    227μs
    135 x shop.hook.300 (0.01%)
    173μs
    20 x shop.hook.221 (0.01%)
    90μs
    22 x shop.hook.120 (0.01%)
    80μs
    12 x shop.hook.208 (0%)
    38μs
    15 x shop.hook.253 (0%)
    31μs
    10 x shop.hook.302 (0%)
    19μs
    6 x shop.hook.330 (0%)
    13μs
    3 x shop.hook.118 (0%)
    11μs
    2 x shop.hook.250 (0%)
    10μs
    1 x shop.hook.142 (0%)
    9μs
    2 x shop.hook.251 (0%)
    6μs
    1 x shop.hook.133 (0%)
    6μs
    1 x shop.hook.204 (0%)
    6μs
    1 x shop.hook.109 (0%)
    6μs
    1 x shop.hook.132 (0%)
    5μs
    1 x shop.hook.143 (0%)
    5μs
    1 x shop.hook.89 (0%)
    5μs
    1 x shop.hook.214 (0%)
    4μs
    1 x shop.hook.178 (0%)
    4μs
    1 x shop.hook.226 (0%)
    4μs
    2 x shop.hook.254 (0%)
    3μs
    1 x shop.hook.306 (0%)
    3μs
    1 x shop.hook.22 (0%)
    3μs
    1 x shop.hook.101 (0%)
    3μs
    1 x shop.hook.99 (0%)
    3μs
    1 x shop.hook.131 (0%)
    2μs
    1 x shop.hook.361 (0%)
    2μs
    1 x shop.hook.331 (0%)
    2μs
    1 x shop.hook.175 (0%)
    2μs
    1 x shop.hook.303 (0%)
    2μs
    1 x shop.hook.400 (0%)
    2μs
    1 x shop.hook.166 (0%)
    2μs
    1 x shop.hook.156 (0%)
    1μs
    1 x shop.hook.90 (0%)
    1μs
638 statements were executed, 459 of which were duplicates, 179 unique92.93ms10.42MB
default
  • SELECT * FROM tsprache87μs16.22KB20000000000000b790000000000000000default
  • SELECT * FROM tkundengruppe WHERE `cStandard`=?94μ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.72ms17.39KB530000000000000b840000000000000000default
    Params
    :section1
  • SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe77μ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.kPlugin171μs16.69KB120000000000000b4f0000000000000000default
    Params
    :state2
  • SELECT * FROM tsprache89μs16.22KB20000000000000aeb0000000000000000default
  • SELECT * FROM twaehrung59μs16.23KB10000000000000ae70000000000000000default
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache69μs16.08KB00000000000000a8a0000000000000000default
  • 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 = :section661μs16.95KB2700000000000009090000000000000000default
    Params
    :section7
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC130μs16.22KB200000000000008ed0000000000000000default
  • SELECT * FROM tglobals WHERE dLetzteAenderung > :ts59μs16.2KB000000000000008f00000000000000000default
    Params
    :ts2025-05-23 04:54:08
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC64μs16.22KB20000000000000baf0000000000000000default
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv58μs16.42KB30000000000000bb00000000000000000default
    Params
    :nAktiv1
  • SELECT kPlugin AS id, bExtension AS modern FROM tplugin WHERE nStatus = :state AND bBootstrap = 1 ORDER BY nPrio ASC65μs16.31KB300000000000008fa0000000000000000default
    Params
    :state2
  • SELECT * FROM tplugin WHERE `kPlugin`=?189μs17.2KB100000000000008ff0000000000000000default
    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 1110μs16.11KB100000000000017030000000000000000default
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 1168μs16.11KB100000000000017070000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?178μs17.25KB2000000000000172b0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?171μs17.22KB0000000000000173c0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort188μs16.34KB600000000000016f50000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin86μs16.3KB400000000000017130000000000000000default
    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.kLink208μs16.46KB400000000000017330000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)150μs16.14KB400000000000017060000000000000000default
  • 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.cName758μs17KB800000000000017070000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink82μs16.12KB000000000000017420000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB000000000000017470000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB0000000000000174c0000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000017510000000000000000default
    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.nSort658μs17.34KB900000000000017320000000000000000default
    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.kPluginSprachvariable461μs34.06KB7800000000000017100000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin79μs16.34KB0000000000000179d0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id113μs16.78KB400000000000017980000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid83μs16.98KB300000000000017910000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort64μs16.55KB300000000000017910000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart77μs16.28KB200000000000017910000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort48μs16.55KB300000000000017910000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart28μs16.28KB200000000000017910000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort40μs16.55KB300000000000017910000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart26μs16.28KB200000000000017910000000000000000default
    Params
    :kZahlungsart75
  • SELECT * FROM tplugin WHERE `kPlugin`=?73μs17.2KB100000000000017c80000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort53μs16.27KB100000000000018670000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin32μs16.24KB0000000000000186e0000000000000000default
    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.kLink88μs16.4KB0000000000000186d0000000000000000default
    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.nSort228μs17.19KB000000000000018740000000000000000default
    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.kPluginSprachvariable296μs17.13KB18000000000000187b0000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin73μs16.34KB000000000000018900000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id84μs16.72KB0000000000000188b0000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid72μs16.94KB000000000000018870000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT cSektion AS sec, cWert AS val, cName AS name FROM ttemplateeinstellungen WHERE cTemplate = (SELECT cTemplate FROM ttemplate WHERE eTyp = 'standard')146μs17.08KB6300000000000018800000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?48μs17.2KB100000000000018810000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 149μs16.11KB100000000000018c10000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?50μs17.25KB2000000000000189d0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?37μs17.22KB000000000000018e90000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort70μs16.34KB600000000000018d00000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin36μs16.37KB800000000000018cd0000000000000000default
    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.kLink123μs16.52KB800000000000018e20000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)52μs16.2KB800000000000018b20000000000000000default
  • 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.cName756μs17.13KB1600000000000018f10000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink78μs16.12KB000000000000019060000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB0000000000000190b0000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB000000000000019100000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB000000000000019150000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB0000000000000191a0000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB0000000000000191f0000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000019240000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000019290000000000000000default
    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.nSort243μs17.19KB000000000000018af0000000000000000default
    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.kPluginSprachvariable247μs16.84KB200000000000018e60000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin72μs16.34KB000000000000019020000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id82μs16.72KB000000000000018fc0000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid70μs16.94KB000000000000018f80000000000000000default
    Params
    :pidkPlugin\_5\_%
  • SELECT * FROM ttemplate WHERE `eTyp`=?51μs16.85KB1000000000000195f0000000000000000default
    Params
    0standard
  • SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate132μs17.2KB6300000000000019650000000000000000default
    Params
    :cTemplateBALTER
  • SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio57μs16.3KB300000000000019a40000000000000000default
    Params
    :nStatus2
  • SELECT * FROM tconsent WHERE `active`=:active51μs16.27KB20000000000001ee70000000000000000default
    Params
    :active1
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID83μs16.31KB20000000000001f010000000000000000default
    Params
    :consentID1
  • SELECT * FROM tsprache83μs16.22KB20000000000001f010000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID91μs16.31KB20000000000001f0c0000000000000000default
    Params
    :consentID2
  • SELECT * FROM tsprache50μs16.22KB20000000000001f0c0000000000000000default
  • 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 = :section146μs16.56KB30000000000001f0c0000000000000000default
    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 = :pid710μs17.84KB720000000000001f1c0000000000000000default
    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 = 0110μs16.19KB40000000000001f540000000000000000default
  • 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 NULL284μs18.39KB10000000000001f3c0000000000000000default
    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 = :section977μs17.02KB320000000000001f4a0000000000000000default
    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.nSort379μs17KB00000000000001f760000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?123μs16.93KB40000000000001f710000000000000000default
    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 NULL291μs18.39KB10000000000001f700000000000000000default
    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.nSort331μs17KB00000000000001f700000000000000000default
    Params
    :cid123
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?149μs16.99KB80000000000001f250000000000000000default
    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 NULL281μs18.39KB10000000000001f260000000000000000default
    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.nSort312μs17KB00000000000001f260000000000000000default
    Params
    :cid132
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?119μs16.99KB70000000000001f2f0000000000000000default
    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 NULL270μs18.39KB10000000000001f300000000000000000default
    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.nSort312μs17KB00000000000001f300000000000000000default
    Params
    :cid220
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?102μs16.87KB00000000000001f7a0000000000000000default
    Params
    0220
  • SELECT id_category FROM submenusettings WHERE id = 165μs16.04KB10000000000001f3d0000000000000000default
  • 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 NULL262μs18.39KB10000000000001f340000000000000000default
    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 = :section4.56ms18.02KB910000000000001f7f0000000000000000default
    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 = 194μs16.16KB00000000000001fdc0000000000000000default
  • 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.nSort235μs17KB00000000000001fdd0000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?83μs16.95KB50000000000001fd60000000000000000default
    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 NULL194μs18.39KB10000000000001fd50000000000000000default
    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.nSort185μs17KB00000000000001fd50000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?72μs16.95KB50000000000001fcc0000000000000000default
    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 NULL171μs18.39KB10000000000001fcb0000000000000000default
    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.nSort173μs17KB00000000000001fcb0000000000000000default
    Params
    :cid111
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?64μs16.93KB40000000000001fc20000000000000000default
    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 NULL161μs18.39KB10000000000001fc10000000000000000default
    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.nSort231μs17KB00000000000001fc10000000000000000default
    Params
    :cid112
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?65μs16.95KB50000000000001fb80000000000000000default
    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 NULL157μs18.39KB10000000000001fb70000000000000000default
    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.nSort190μs17KB00000000000001fb70000000000000000default
    Params
    :cid115
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?53μs16.87KB00000000000001fae0000000000000000default
    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 NULL159μs18.39KB10000000000001fae0000000000000000default
    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.nSort170μs17KB00000000000001fae0000000000000000default
    Params
    :cid116
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?53μs16.87KB00000000000001fa40000000000000000default
    Params
    0116
  • SELECT * FROM tland142μs20.19KB2360000000000001f9a0000000000000000default
  • SELECT cLaender FROM tversandart37μs16.05KB20000000000001f9a0000000000000000default
  • SELECT DISTINCT cLandIso FROM tstaat71μs16.52KB290000000000001f9a0000000000000000default
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName92μs16.56KB2400000000000020ce0000000000000000default
    Params
    :cLandIsoAR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName46μs16.34KB900000000000020db0000000000000000default
    Params
    :cLandIsoAT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName45μs16.34KB1000000000000020ba0000000000000000default
    Params
    :cLandIsoBE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName68μs16.69KB2800000000000020fd0000000000000000default
    Params
    :cLandIsoBG
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName69μs16.63KB2700000000000021190000000000000000default
    Params
    :cLandIsoBR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName46μs16.41KB13000000000000213e0000000000000000default
    Params
    :cLandIsoCA
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName62μs16.63KB26000000000000210d0000000000000000default
    Params
    :cLandIsoCH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName82μs16.81KB3400000000000021790000000000000000default
    Params
    :cLandIsoCN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.28KB600000000000021a20000000000000000default
    Params
    :cLandIsoCY
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName47μs16.44KB14000000000000219a0000000000000000default
    Params
    :cLandIsoCZ
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName49μs16.44KB1600000000000021740000000000000000default
    Params
    :cLandIsoDE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName33μs16.27KB500000000000021db0000000000000000default
    Params
    :cLandIsoDK
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName46μs16.44KB1500000000000021700000000000000000default
    Params
    :cLandIsoEE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName92μs17.06KB5000000000000021fa0000000000000000default
    Params
    :cLandIsoES
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName55μs16.5KB1900000000000022350000000000000000default
    Params
    :cLandIsoFI
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName188μs18.19KB11400000000000022240000000000000000default
    Params
    :cLandIsoFR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.25KB400000000000022c70000000000000000default
    Params
    :cLandIsoGB
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName44μs16.41KB1300000000000022b50000000000000000default
    Params
    :cLandIsoGR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.56KB2100000000000022ad0000000000000000default
    Params
    :cLandIsoHR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName73μs16.81KB36000000000000228b0000000000000000default
    Params
    :cLandIsoIN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName163μs17.94KB110000000000000222c0000000000000000default
    Params
    :cLandIsoIT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName87μs16.94KB4700000000000023ac0000000000000000default
    Params
    :cLandIsoJP
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName40μs16.34KB10000000000000238d0000000000000000default
    Params
    :cLandIsoLT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName373μs18.19KB11900000000000023980000000000000000default
    Params
    :cLandIsoLV
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName150μs16.69KB32000000000000246b0000000000000000default
    Params
    :cLandIsoMX
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName139μs16.38KB1200000000000024510000000000000000default
    Params
    :cLandIsoNL
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName155μs16.94KB4200000000000021f10000000000000000default
    Params
    :cLandIsoRO
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName210μs17.44KB7800000000000024fa0000000000000000default
    Params
    :cLandIsoTH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName142μs17.19KB6300000000000025710000000000000000default
    Params
    :cLandIsoUS
  • SELECT * FROM tfirma LIMIT 145μs16.52KB10000000000001f9d0000000000000000default
  • 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 nSort109μs16.88KB00000000000001fa00000000000000000default
    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 > 0135μs16.59KB2200000000000020aa0000000000000000default
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName74μs16.27KB0000000000000208b0000000000000000default
    Params
    :lgid1
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName61μs16.37KB600000000000020860000000000000000default
    Params
    :lgid4
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (440,442,68,71,443,444)55μs16.17KB600000000000020870000000000000000default
  • 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.cName691μs17.06KB1200000000000020760000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink69μs16.12KB000000000000020650000000000000000default
    Params
    :kVaterLink440
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000020600000000000000000default
    Params
    :kVaterLink442
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000205b0000000000000000default
    Params
    :kVaterLink68
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000020560000000000000000default
    Params
    :kVaterLink71
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020510000000000000000default
    Params
    :kVaterLink443
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB0000000000000204c0000000000000000default
    Params
    :kVaterLink444
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName94μs16.37KB6000000000000206b0000000000000000default
    Params
    :lgid5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (69,67,59,49,73,74)41μs16.17KB6000000000000206a0000000000000000default
  • 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.cName630μs17.06KB12000000000000207d0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink70μs16.12KB0000000000000203e0000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000020390000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000020340000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000202f0000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB0000000000000202a0000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000020250000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName124μs16.71KB2700000000000020440000000000000000default
    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)65μs16.52KB2700000000000020430000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (3,4,63,72,75,76,77,78,79,80,81,83,84,85,86,105,106,107,108,432,433,434,435,436,437,438,439) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName1.07ms33.75KB540000000000001ffe0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink77μs16.12KB000000000000025430000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB000000000000025480000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB0000000000000254d0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000025520000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000025570000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB0000000000000255c0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000025610000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000025660000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB0000000000000256b0000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000026100000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000026150000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000261a0000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB0000000000000261f0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000026240000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000026290000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000262e0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB000000000000026330000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000026380000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000263d0000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000026420000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000026470000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000264c0000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000026510000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.1KB000000000000026560000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000265b0000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.1KB000000000000026600000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000026650000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName108μs16.37KB60000000000001f950000000000000000default
    Params
    :lgid9
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (103,104,420,422,64,61)49μs16.17KB60000000000001f960000000000000000default
  • 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.cName656μs17.03KB100000000000001f850000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink81μs16.12KB00000000000001fe80000000000000000default
    Params
    :kVaterLink103
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink84μs16.12KB00000000000001fed0000000000000000default
    Params
    :kVaterLink104
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB00000000000001ff20000000000000000default
    Params
    :kVaterLink420
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000001ff70000000000000000default
    Params
    :kVaterLink422
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink237μs16.12KB000000000000020190000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink63μs16.12KB000000000000020030000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName246μs16.35KB50000000000001fe20000000000000000default
    Params
    :lgid10
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (109,112,111,110,113)112μs16.16KB50000000000001fe30000000000000000default
  • 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.cName1.08ms17.03KB100000000000001f8c0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink113μs16.12KB0000000000000200f0000000000000000default
    Params
    :kVaterLink109
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink74μs16.12KB000000000000020140000000000000000default
    Params
    :kVaterLink112
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink71μs16.12KB000000000000020430000000000000000default
    Params
    :kVaterLink111
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink62μs16.12KB0000000000000201e0000000000000000default
    Params
    :kVaterLink110
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink62μs16.12KB0000000000000207d0000000000000000default
    Params
    :kVaterLink113
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName157μs16.32KB300000000000020090000000000000000default
    Params
    :lgid11
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (446,448,447)86μs16.13KB3000000000000200a0000000000000000default
  • 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.cName932μs16.97KB60000000000001f890000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink89μs16.12KB0000000000000206a0000000000000000default
    Params
    :kVaterLink446
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink62μs16.12KB000000000000020870000000000000000default
    Params
    :kVaterLink448
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB0000000000000204d0000000000000000default
    Params
    :kVaterLink447
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName140μs16.32KB30000000000001f340000000000000000default
    Params
    :lgid12
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (115,50,66)82μs16.13KB30000000000001f7f0000000000000000default
  • 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.cName953μs16.97KB600000000000020760000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink119μs16.12KB000000000000026740000000000000000default
    Params
    :kVaterLink115
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink71μs16.12KB000000000000026790000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink59μs16.12KB0000000000000267e0000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName149μs16.34KB4000000000000266e0000000000000000default
    Params
    :lgid13
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (116,118,119,117)84μs16.14KB4000000000000266f0000000000000000default
  • 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.cName927μs17KB800000000000026830000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink129μs16.12KB000000000000026900000000000000000default
    Params
    :kVaterLink116
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink89μs16.12KB000000000000026950000000000000000default
    Params
    :kVaterLink118
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink61μs16.12KB0000000000000269a0000000000000000default
    Params
    :kVaterLink119
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink60μs16.12KB0000000000000269f0000000000000000default
    Params
    :kVaterLink117
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName240μs16.29KB1000000000000268a0000000000000000default
    Params
    :lgid14
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (120)60μs16.09KB1000000000000268b0000000000000000default
  • 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.cName294μs16.91KB200000000000026820000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink102μs16.12KB000000000000026830000000000000000default
    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.kSprache1.05ms34KB7400000000000020920000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink116μs16.1KB000000000000026d80000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink77μs16.1KB000000000000026dd0000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink48μs16.12KB000000000000026e20000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink90μs16.12KB000000000000026e70000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink59μs16.12KB000000000000026ec0000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB000000000000026f10000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000026f60000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB000000000000026fb0000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB000000000000027000000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB000000000000027050000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB0000000000000270a0000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB0000000000000270f0000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink99μs16.12KB000000000000027140000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink63μs16.12KB000000000000027190000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB0000000000000271e0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB000000000000027230000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000027280000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB0000000000000272d0000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB000000000000027320000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000027370000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB0000000000000273c0000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB000000000000027410000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB000000000000027460000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink29μs16.12KB0000000000000274b0000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000027500000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000027550000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB0000000000000275a0000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB0000000000000275f0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink27μs16.12KB000000000000027640000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB000000000000027690000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000276e0000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink120μs16.12KB000000000000027730000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink88μs16.12KB000000000000027780000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink72μs16.12KB0000000000000277d0000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000027820000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000027870000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB0000000000000278c0000000000000000default
    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.kSprache1.37ms17.23KB2600000000000026d30000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink103μs16.1KB000000000000026b20000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink61μs16.12KB000000000000026ad0000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink55μs16.12KB000000000000026a80000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000026820000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB0000000000000268d0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB000000000000020a40000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000020a20000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000020960000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB0000000000000209d0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink53μs16.12KB000000000000027920000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB000000000000027970000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB0000000000000279c0000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000027a10000000000000000default
    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.kSprache632μs16.75KB000000000000026b70000000000000000default
  • 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 = :section251μs16.56KB300000000000027ab0000000000000000default
    Params
    :section128
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?183μs16.74KB1000000000000280d0000000000000000default
    Params
    0kMerkmalWert
    12-Familienhaus
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?85μs16.74KB1000000000000280d0000000000000000default
    Params
    0kMerkmalWert
    14-Familienhaus
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?70μs16.74KB100000000000028100000000000000000default
    Params
    0kMerkmalWert
    1Unterputz_1
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?61μs16.74KB100000000000028130000000000000000default
    Params
    0kMerkmalWert
    1Ohne-Smartphone-App
  • SELECT * FROM tseo WHERE cSeo = :slg64μs16.22KB100000000000028170000000000000000default
    Params
    :slgHD-Tuerstationen
  • 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 NULL388μs18.39KB1000000000000281a0000000000000000default
    Params
    :kid226
    :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.nSort421μs17KB0000000000000281a0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?148μs16.91KB300000000000028240000000000000000default
    Params
    0226
  • SELECT tmerkmalwert.kMerkmal, tmerkmalwert.kMerkmalWert, tmerkmal.nMehrfachauswahl FROM tmerkmalwert JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal WHERE kMerkmalWert IN (2,4,18,20)153μs16.14KB40000000000001f560000000000000000default
  • 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 = :val160μs16.89KB100000000000028280000000000000000default
    Params
    :val2
  • 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 = :val135μs16.89KB1000000000000282d0000000000000000default
    Params
    :val4
  • 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 = :val189μs16.89KB100000000000028320000000000000000default
    Params
    :val18
  • 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 = :val109μs16.89KB100000000000028370000000000000000default
    Params
    :val20
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache85μs16.08KB200000000000028270000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache44μs16.08KB200000000000028250000000000000000default
  • 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 NULL185μs18.39KB100000000000028430000000000000000default
    Params
    :kid226
    :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.nSort239μs17KB000000000000028430000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?85μs16.91KB3000000000000284d0000000000000000default
    Params
    0226
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL190μs18.39KB1000000000000284e0000000000000000default
    Params
    :kid226
    :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.nSort193μs17KB0000000000000284e0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?74μs16.91KB300000000000028570000000000000000default
    Params
    0226
  • 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 NULL182μs18.39KB100000000000028520000000000000000default
    Params
    :kid226
    :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.nSort196μs17KB000000000000028520000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?80μs16.91KB300000000000028600000000000000000default
    Params
    0226
  • 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 NULL182μs18.39KB1000000000000285b0000000000000000default
    Params
    :kid226
    :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.nSort185μs17KB0000000000000285b0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?72μs16.91KB300000000000028690000000000000000default
    Params
    0226
  • 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 NULL189μs18.39KB100000000000028640000000000000000default
    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.nSort201μs17KB000000000000028640000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?81μs16.95KB500000000000028720000000000000000default
    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 NULL180μs18.39KB100000000000028730000000000000000default
    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.nSort197μs17KB000000000000028730000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?77μs16.93KB4000000000000287c0000000000000000default
    Params
    0108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.45KB300000000000028860000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie37μs16.41KB000000000000028860000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000028860000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.41KB000000000000028860000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName437μs16.02KB000000000000028800000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie84μs16.45KB300000000000028980000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie38μs16.41KB000000000000028980000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie33μs16.41KB000000000000028980000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.41KB000000000000028980000000000000000default
    Params
    :kOberKategorie229
  • 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 FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName) AS ssMerkmal LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = :lid GROUP BY ssMerkmal.kHersteller ORDER BY ssMerkmal.nSortNr, ssMerkmal.cName658μs18.66KB000000000000028980000000000000000default
    Params
    :lid1
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie90μs16.45KB3000000000000287f0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie42μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie33μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie229
  • 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 FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal GROUP BY ssMerkmal.nSterne ORDER BY ssMerkmal.nSterne DESC706μs16.05KB0000000000000287f0000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie81μs16.45KB3000000000000289d0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie40μs16.41KB0000000000000289d0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.41KB0000000000000289d0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie30μs16.41KB0000000000000289d0000000000000000default
    Params
    :kOberKategorie229
  • SELECT kKategorie FROM tkategoriesichtbarkeit38μs16.02KB000000000000028b90000000000000000default
  • 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 FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tkategorie.kKategorie, tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kKategorie AND tseo.cKey = 'kKategorie' AND tseo.kSprache = :lid GROUP BY ssMerkmal.kKategorie ORDER BY ssMerkmal.nSort, ssMerkmal.cName553μs18.63KB000000000000028c60000000000000000default
    Params
    :lid1
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie177μs16.45KB3000000000000287f0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie93μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie74μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie72μs16.41KB0000000000000287f0000000000000000default
    Params
    :kOberKategorie229
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie115μs16.45KB300000000000028e00000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie70μs16.41KB000000000000028e00000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie61μs16.41KB000000000000028e00000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie60μs16.41KB000000000000028e00000000000000000default
    Params
    :kOberKategorie229
  • 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 FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal969μs16.06KB100000000000028f10000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie144μs16.45KB300000000000028800000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie78μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie65μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie61μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie229
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie106μs16.45KB300000000000028f50000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie65μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie58μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName1.06ms16.02KB000000000000028ac0000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie165μs16.45KB300000000000028f50000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie114μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie87μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie63μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName867μs16.02KB000000000000028f10000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie130μs16.45KB300000000000028f50000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie79μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie78μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie73μs16.41KB000000000000028f50000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName478μs16.02KB000000000000028d70000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie102μs16.45KB300000000000029190000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie45μs16.41KB000000000000029190000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie34μs16.41KB000000000000029190000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie39μs16.41KB000000000000029190000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName418μs16.02KB000000000000029080000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie79μs16.45KB300000000000029230000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie39μs16.41KB000000000000029230000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000029230000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.41KB000000000000029230000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName256μs16.02KB000000000000028f30000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie66μs16.45KB300000000000029310000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie38μs16.41KB000000000000029310000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie31μs16.41KB000000000000029310000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000029310000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) 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.cName649μs16.02KB000000000000029250000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie76μs16.45KB300000000000028cb0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie57μs16.41KB000000000000028cb0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie42μs16.41KB000000000000028cb0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie43μs16.41KB000000000000028cb0000000000000000default
    Params
    :kOberKategorie229
  • SELECT ssMerkmal.filterval, COUNT(*) AS nAnzahl FROM (SELECT 1 AS filterval FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel ) AS ssMerkmal GROUP BY ssMerkmal.filterval ORDER BY ssMerkmal.filterval ASC419μs16.05KB000000000000028d80000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie73μs16.45KB300000000000028f90000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie38μs16.41KB000000000000028f90000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000028f90000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.41KB000000000000028f90000000000000000default
    Params
    :kOberKategorie229
  • SELECT ssMerkmal.cSeo, ssMerkmal.kMerkmal, ssMerkmal.kMerkmalWert, ssMerkmal.cMMWBildPfad, ssMerkmal.nMehrfachauswahl, ssMerkmal.cWert, ssMerkmal.cName, ssMerkmal.cTyp, ssMerkmal.cMMBildPfad, COUNT(DISTINCT ssMerkmal.kArtikel) AS nAnzahl FROM (SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.cSeo, tmerkmal.cName, #2,4,20 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 #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 = 226 OR tkategorieartikel.kKategorie = 227 OR tkategorieartikel.kKategorie = 228 OR tkategorieartikel.kKategorie = 229 AND #condition from filter custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 ) AS ssMerkmal GROUP BY ssMerkmal.kMerkmalWert ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert608μs16.38KB700000000000028e00000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 177μs16.16KB100000000000029730000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 135μs16.16KB100000000000029780000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 126μs16.16KB100000000000029770000000000000000default
    Params
    :cid1
  • 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 129μs16.16KB100000000000029800000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 131μs16.16KB100000000000029830000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 131μs16.16KB100000000000029860000000000000000default
    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 (1,2,3)146μs16.2KB300000000000029720000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache82μs16.08KB2000000000000298f0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB1000000000000298e0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 129μs16.2KB1000000000000298f0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB100000000000029940000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB1000000000000299a0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB1000000000000299d0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB100000000000029a00000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029a30000000000000000default
    Params
    :cid1
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache50μs16.08KB200000000000029a70000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 128μs16.2KB100000000000029a30000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 125μs16.2KB100000000000029aa0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 125μs16.2KB100000000000029a70000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 128μs16.2KB100000000000029b20000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 130μs16.2KB100000000000029b50000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 130μs16.2KB100000000000029b80000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 133μs16.2KB100000000000029bb0000000000000000default
    Params
    :cid2
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache45μs16.08KB200000000000029bf0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB100000000000029bb0000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029bf0000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 124μs16.2KB100000000000029c40000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029ca0000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029cd0000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 129μs16.2KB100000000000029d00000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB100000000000029d30000000000000000default
    Params
    :cid3
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 131μs16.16KB100000000000029d30000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 127μs16.16KB100000000000029db0000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 126μs16.16KB100000000000029da0000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 130μs16.16KB100000000000029e00000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 129μs16.16KB100000000000029e30000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 125μs16.16KB100000000000029e60000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 127μs16.16KB100000000000029e90000000000000000default
    Params
    :cid13
  • SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (25)93μs16.17KB100000000000029d60000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache55μs16.08KB200000000000029d60000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 133μs16.2KB1000000000000298a0000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029d60000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 124μs16.2KB100000000000029f20000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 128μs16.2KB100000000000029f80000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 127μs16.2KB100000000000029fb0000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB100000000000029fe0000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 125μs16.2KB10000000000002a010000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 129μs16.16KB10000000000002a010000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 127μs16.16KB10000000000002a090000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 126μs16.16KB10000000000002a080000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 127μs16.16KB10000000000002a0e0000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 125μs16.16KB10000000000002a110000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 126μs16.16KB10000000000002a140000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 129μs16.16KB10000000000002a170000000000000000default
    Params
    :cid5
  • SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.kMerkmalWert, tmerkmalwertsprache.cSeo, tmerkmalwert.kMerkmal, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert IN (20)93μs16.17KB10000000000002a040000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache67μs16.08KB20000000000002a1d0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 143μs16.2KB10000000000002a1c0000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB10000000000002a210000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB10000000000002a200000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 142μs16.2KB10000000000002a280000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002a2b0000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB10000000000002a2e0000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB10000000000002a310000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 135μs16.16KB10000000000002a310000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 141μs16.16KB10000000000002a390000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 133μs16.16KB10000000000002a380000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 132μs16.16KB10000000000002a3e0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 133μs16.16KB10000000000002a410000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 132μs16.16KB10000000000002a440000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 132μs16.16KB10000000000002a470000000000000000default
    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)104μs16.17KB10000000000002a340000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache71μs16.08KB20000000000002a4d0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB10000000000002a4c0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 130μs16.2KB10000000000002a4d0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 126μs16.2KB10000000000002a520000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB10000000000002a580000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 147μs16.2KB10000000000002a5b0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 150μs16.2KB10000000000002a5e0000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 1132μs16.2KB10000000000002a610000000000000000default
    Params
    :cid16
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 193μs16.16KB10000000000002a610000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 1138μs16.16KB10000000000002a690000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 186μs16.16KB10000000000002a680000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 181μs16.16KB10000000000002a6e0000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 174μs16.16KB10000000000002a710000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 166μs16.16KB10000000000002a740000000000000000default
    Params
    :cid12
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 162μs16.16KB10000000000002a770000000000000000default
    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)181μs16.17KB10000000000002a640000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache158μs16.08KB20000000000002a7d0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 189μs16.2KB10000000000002a7c0000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 158μs16.2KB10000000000002a810000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 159μs16.2KB10000000000002a800000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 188μs16.2KB10000000000002a880000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 167μs16.2KB10000000000002a8b0000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 149μs16.2KB10000000000002a8e0000000000000000default
    Params
    :cid18
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 148μs16.2KB10000000000002a910000000000000000default
    Params
    :cid18
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache127μs16.08KB200000000000029660000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache92μs16.08KB20000000000002a7b0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache87μs16.08KB200000000000029610000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache87μs16.08KB2000000000000295e0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache85μs16.08KB2000000000000295a0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache79μs16.08KB200000000000029640000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache151μs16.08KB20000000000002a7b0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache72μs16.08KB2000000000000290a0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache43μs16.08KB20000000000002a910000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache38μs16.08KB20000000000002a970000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache37μs16.08KB20000000000002a9a0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache37μs16.08KB20000000000002a9d0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache37μs16.08KB2000000000000296e0000000000000000default
  • SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val97μs16.89KB10000000000002a9e0000000000000000default
    Params
    :val1
  • 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 = :val59μs16.89KB1000000000000296e0000000000000000default
    Params
    :val1
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache48μs16.08KB20000000000002aa40000000000000000default
  • 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 = :val60μs16.89KB10000000000002aab0000000000000000default
    Params
    :val2
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache42μs16.08KB20000000000002aa40000000000000000default
  • 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 = :val53μs16.89KB10000000000002aaf0000000000000000default
    Params
    :val1
  • 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 = :val49μs16.89KB10000000000002aa40000000000000000default
    Params
    :val1
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache39μs16.08KB20000000000002ab10000000000000000default
  • 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 = :val50μs16.89KB10000000000002ab80000000000000000default
    Params
    :val4
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache38μs16.08KB20000000000002ab10000000000000000default
  • 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.89KB10000000000002abc0000000000000000default
    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 = :val48μs16.89KB10000000000002ab10000000000000000default
    Params
    :val12
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache38μs16.08KB20000000000002abe0000000000000000default
  • 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 = :val51μs16.89KB10000000000002ac50000000000000000default
    Params
    :val18
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache38μs16.08KB20000000000002abe0000000000000000default
  • 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.89KB10000000000002ac90000000000000000default
    Params
    :val5
  • 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 = :val48μs16.89KB10000000000002abe0000000000000000default
    Params
    :val5
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache39μs16.08KB20000000000002acb0000000000000000default
  • 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.89KB10000000000002ad20000000000000000default
    Params
    :val20
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache39μs16.08KB20000000000002acb0000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache37μs16.08KB20000000000002ad00000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache35μs16.08KB20000000000002aa00000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache35μs16.08KB20000000000002ad60000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache35μs16.08KB20000000000002aa20000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache36μs16.08KB20000000000002aa20000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache36μs16.08KB20000000000002ad60000000000000000default
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache39μs16.08KB20000000000002adb0000000000000000default
  • 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.36ms17.39KB510000000000002ae00000000000000000default
    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 (228, 229, 227)) ORDER BY rand() LIMIT 6235μs16.9KB00000000000002b170000000000000000default
    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 (228, 229, 227)) ORDER BY tbestseller.fAnzahl DESC LIMIT 6153μs17.02KB00000000000002b130000000000000000default
    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 = :section98μs16.59KB50000000000002b0f0000000000000000default
    Params
    :section121
  • SELECT tseo.cSeo, tseo.kSprache FROM tseo WHERE cKey = 'suchspecial' AND kKey IN (4) ORDER BY kSprache74μs16.08KB20000000000002b0b0000000000000000default
  • 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 NULL198μs18.39KB100000000000028420000000000000000default
    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.nSort267μs17KB000000000000028420000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?98μs16.95KB50000000000002af90000000000000000default
    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 NULL216μs18.39KB10000000000002af80000000000000000default
    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.nSort207μs17KB00000000000002af80000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?76μs16.93KB40000000000002aef0000000000000000default
    Params
    0108
  • SELECT * FROM tfirma LIMIT 152μs16.52KB10000000000002af40000000000000000default
  • 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 nSort119μs16.88KB00000000000002aec0000000000000000default
    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.cName843μs18KB120000000000002ae60000000000000000default
    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 NULL162μs16.02KB00000000000002b240000000000000000default
  • SELECT * FROM tfirma LIMIT 152μs16.52KB10000000000002b360000000000000000default
  • 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 DESC133μs16.61KB30000000000002e7d0000000000000000default
    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 = :section102μs16.53KB10000000000002e980000000000000000default
    Params
    :section125
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache45μs16.08KB00000000000002ea10000000000000000default
  • SELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC317μs40.16KB4990000000000002eae0000000000000000default
  • 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)136μs688B00000000000002ead0000000000000000default
    Params
    :interval3
  • DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)69μs128B00000000000002ead0000000000000000default
    Params
    :interval3
  • SELECT * FROM tbesucher WHERE `cSessID`=?75μs16.93KB10000000000002ead0000000000000000default
    Params
    0n7f7bicgc16dphn0g25aqd3es2
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv51μs16.42KB3000000000000090e0000000000000000default
    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 = '')62μs16.42KB000000000000030980000000000000000default
    Params
    :lid1
    :cgid1
    :ptype2
    :ckykKategorie
    :cval226
  • SELECT * FROM tboxenanzeige60μs17.58KB82000000000000308e0000000000000000default
  • 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 ASC9.23ms97KB3200000000000030120000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie150μs16.45KB300000000000030140000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000030140000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie35μs16.41KB000000000000030140000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.41KB000000000000030140000000000000000default
    Params
    :kOberKategorie229
  • 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 10118μs16.02KB000000000000030140000000000000000default
  • 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 FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.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 custom ( (taFA.cLagerBeachten = 'Y' AND taFA.fLagerbestand > 0) OR taFA.cLagerBeachten = 'N' OR taFA.cLagerKleinerNull = 'Y' ) AND tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (18)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Unterputz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2,4)) AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (20)) AND #condition from filter qf ((tartikel.cTopArtikel = 'Y')) AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tsuchanfrage.kSuchanfrage, tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName) AS ssMerkmal GROUP BY ssMerkmal.kSuchanfrage ORDER BY ssMerkmal.cSuche543μs16.09KB000000000000030140000000000000000default
  • 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 :lmt165μs17.27KB000000000000030240000000000000000default
    Params
    :lmt10
    :cgid1
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin48μs16.17KB600000000000030070000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?58μs17.2KB10000000000002ffe0000000000000000default
    Params
    01
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 153μs16.11KB100000000000030650000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?51μs17.25KB2000000000000307d0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?35μs17.22KB000000000000030890000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort64μs16.34KB60000000000002ff30000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin33μs16.3KB4000000000000306d0000000000000000default
    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.kLink153μs16.46KB400000000000030820000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)62μs16.14KB400000000000030270000000000000000default
  • 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.cName719μs17KB800000000000030650000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink86μs16.12KB00000000000002fe90000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB00000000000002fe40000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB00000000000002fdf0000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink33μs16.12KB00000000000002fda0000000000000000default
    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.nSort690μs17.34KB900000000000030360000000000000000default
    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.kPluginSprachvariable778μs34.06KB78000000000000306b0000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin123μs16.34KB00000000000002f8e0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id130μs16.78KB40000000000002f930000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid109μs16.98KB30000000000002f9a0000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort85μs16.55KB30000000000002f9a0000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart50μs16.28KB20000000000002f9a0000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort56μs16.55KB30000000000002f9a0000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart35μs16.28KB20000000000002f9a0000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort48μs16.55KB30000000000002f9a0000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart32μs16.28KB20000000000002f9a0000000000000000default
    Params
    :kZahlungsart75
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin43μs16.17KB600000000000030040000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?66μs17.2KB10000000000002fa10000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort58μs16.27KB10000000000002fd50000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin41μs16.24KB00000000000002f650000000000000000default
    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.kLink108μs16.4KB000000000000030680000000000000000default
    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.nSort236μs17.19KB00000000000002f5f0000000000000000default
    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.kPluginSprachvariable299μs17.13KB180000000000002f580000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin89μs16.34KB00000000000002f430000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id92μs16.72KB00000000000002f480000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid75μs16.94KB00000000000002f4c0000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin37μs16.17KB600000000000030020000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?50μs17.2KB10000000000002f520000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 163μs16.11KB10000000000002f210000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?52μs17.25KB20000000000002efd0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?35μs17.22KB00000000000002eec0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort52μs16.34KB60000000000002f300000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin66μs16.37KB80000000000002f2d0000000000000000default
    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.kLink116μs16.52KB80000000000002ef30000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)49μs16.2KB80000000000002f120000000000000000default
  • 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.cName704μs17.13KB160000000000002ee40000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink76μs16.12KB00000000000002ecf0000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink34μs16.12KB00000000000002eca0000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB00000000000002ec50000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB00000000000002ec00000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB00000000000002ebb0000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB00000000000002eb60000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink25μs16.12KB00000000000002eb10000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000030a70000000000000000default
    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.nSort230μs17.19KB00000000000002f0f0000000000000000default
    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.kPluginSprachvariable239μs16.84KB20000000000002eef0000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin74μs16.34KB00000000000002ed30000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id81μs16.72KB00000000000002ed90000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid66μs16.94KB00000000000002edd0000000000000000default
    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 NULL255μs18.39KB100000000000030bf0000000000000000default
    Params
    :kid226
    :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.nSort228μs17KB000000000000030bf0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?86μs16.91KB300000000000030c90000000000000000default
    Params
    0226
  • 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 NULL222μs18.39KB100000000000030ca0000000000000000default
    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.nSort216μs17KB000000000000030ca0000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?80μs16.95KB500000000000030d30000000000000000default
    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 NULL182μs18.39KB100000000000030d40000000000000000default
    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.nSort205μs17KB000000000000030d40000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?71μs16.93KB400000000000030dd0000000000000000default
    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:3 [ "availability" => "1" "qf" => "4" "mf" => array:4 [ 0 => 2 1 => 4 2 => 1...
    $_POST
    []
    $_SESSION
    array:36 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#2694 +k...
    $_COOKIE
    array:1 [ "JTLSHOP" => "n7f7bicgc16dphn0g25aqd3es2" ]
    $_SERVER
    array:62 [ "USER" => "jtlbalter" "HOME" => "/var/www/vhosts/k08.de" "SCRIPT_NAME" => "/index.p...
      TracedStatement.php:39
      {#12508 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataCollector\PDO\Trac...
      TraceablePDOStatement.php:86
      {#12505 +"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
      {#8097 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      Bootstrap.php:144
      {#8367 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      ProductFilter.php:1662
      {#10370 +"level": 2 +"message": "Attempt to read property "kKategorie" on null" +"file": "/var...
      smarty_internal_debug.php:146
      {#12807 +"level": 2 +"message": "Undefined array key "start_time"" +"file": "/var/www/vhosts/k...
      smarty_internal_debug.php:73
      {#12635 +"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 {#7997 -parentID: 108 -sort: 0 -names: a...
      submenu_items
      array:4 [ 0 => JTL\Catalog\Category\Kategorie {#8020 -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 {#2694 +kWarenkorb: null +kKunde: null +kLieferadresse: null +kZahlungsInfo: 0...
      FavourableShipping
      null
      oNaviSeite_arr
      array:2 [ "vor" => JTL\Filter\Pagination\Item {#10609 -page: 0 -url: null -isActive: f...
      filterPagination
      JTL\Filter\Pagination\Pagination {#10303 -pages: [] -prev: JTL\Filter\Pagination\Item {#10277 ...
      oBestseller_arr
      []
      KategorieInhalt
      {#2315 +"Unterkategorien": JTL\Catalog\Category\KategorieListe {#10973 +elemente: array:3 [ ...
      NaviFilter
      JTL\Filter\ProductFilter {#8041 -category: JTL\Filter\States\BaseCategory {#8036 #icon: null ...
      priceRangeMax
      0
      oErweiterteDarstellung
      {#2316 +"cURL_arr": array:2 [ 1 => "https://www.k08.de/HD-Tuerstationen__2-Familienhaus__4-Fam...
      Suchergebnisse
      JTL\Filter\SearchResults {#10378 -products: Illuminate\Support\Collection {#10604 #items: [] ...
      oNavigationsinfo
      JTL\Filter\Metadata {#8039 -conf: array:32 [ "global" => array:53 [ "systemlog_flag" => ...
      priceRange
      null
      nMaxAnzahlArtikel
      0
      linkgroups
      JTL\Link\LinkGroupCollection {#8361 #items: array:13 [ 0 => JTL\Link\LinkGroup {#9917 -n...
      manufacturers
      array:2 [ 2 => JTL\Catalog\Hersteller {#11048 -kHersteller: 2 -names: array:6 [ 1 =>...
      oUnterKategorien_arr
      array:3 [ 228 => JTL\Catalog\Category\MenuItem {#2422 -id: 228 -parentID: 226 -languag...
      session_name
      "JTLSHOP"
      session_id
      "n7f7bicgc16dphn0g25aqd3es2"
      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 {#11076 #items: array:25 [ 5 => JTL\Link\Link {#9942 -data...
      bAjaxRequest
      false
      jtl_token
      "<input type="hidden" class="jtl_token" name="jtl_token" value="c20c3bb13d2193124699b2760175e98182d8...
      nSeitenTyp
      2
      bExclusive
      false
      bAdminWartungsmodus
      false
      WarensummeLocalized
      array:2 [ 0 => "0,00 &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 {#11063 +cName: "Balter GmbH" +cUnternehmer: "" +cStrasse: "Elisabeth Selbert Str. 1...
      showLoginCaptcha
      false
      AktuelleKategorie
      JTL\Catalog\Category\Kategorie {#10312 -parentID: 110 -sort: 0 -names: array:1 [ 1 => "HD ...
      cSessionID
      "n7f7bicgc16dphn0g25aqd3es2"
      opc
      JTL\OPC\Service {#11050 #adminName: "" #db: JTL\OPC\DB {#11077 #mapping: [] #shopDB: JTL...
      opcPageService
      JTL\OPC\PageService {#11894 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#11050 #a...
      wishlists
      Illuminate\Support\Collection {#11056 #items: [] #escapeWhenCastingToString: false }
      shippingCountry
      "DE"
      countries
      Illuminate\Support\Collection {#9537 #items: array:236 [ 60 => JTL\Country\Country {#8702 ...
      Link
      JTL\Link\Link {#11019 -data: [] #id: 0 #level: 0 #parent: 0 #linkGroupID: -1 #pluginID: ...
      cPluginCss_arr
      array:2 [ 0 => "plugins/balter_custom/frontend/css/style.css" 1 => "plugins/jtl_paypal_commerce/...
      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 {#11900 #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/HD-Tuerstationen"
      robotsContent
      null
      cShopName
      ""
      bBoxenFilterNach
      true
      oPlugin_jtl_paypal_commerce
      JTL\Plugin\Plugin {#12282 #id: 1 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plugi...
      oPlugin_jtl_theme_editor
      JTL\Plugin\Plugin {#12238 #id: 2 #pluginID: "jtl_theme_editor" #state: 2 #meta: JTL\Plugin\D...
      oPlugin_balter_custom
      JTL\Plugin\Plugin {#12087 #id: 5 #pluginID: "balter_custom" #state: 2 #meta: JTL\Plugin\Data...
      parentBlockParams
      array:19 [ "class" => scc\ComponentProperty {#12886 -defaultValue: null -isRequired: false...
      pbp
      array:19 [ "class" => scc\ComponentProperty {#12886 -defaultValue: null -isRequired: false...
      bCookieErlaubt
      true
      Brotnavi
      array:4 [ 0 => JTL\Catalog\NavigationEntry {#12948 -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 {#7916 #items: array:2 [ 0 => JTL\Consent\Item {#7915 -id:...
      nZeitGebraucht
      1.3244199752808
      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"