HD Türstationen

Filter
Empfehlung Preis aufsteigend Preis absteigend Neueste zuerst Bestseller
2-Familienhaus Schwarz Alle Filter zurücksetzen
Artikel 1 - 1 von 1
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
TimelineDatabase624ConfigMessagesRequestExceptionsErrors9Smarty
371msRequest Duration8.2.28Version12MBMemory Usage
  • Shop start to end (345ms)
  • shop.hook.250 (4μs)
  • shop.hook.254 (2μs)
  • shop.hook.252 (2μs)
  • shop.hook.251 (1μs)
  • shop.hook.300 (3μs)
  • shop.hook.301 (3μ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 (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 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.131 (3μs)
  • shop.hook.156 (1μs)
  • shop.hook.361 (3μs)
  • shop.hook.133 (4μs)
  • shop.hook.320 (823μs)
  • shop.hook.250 (2μs)
  • shop.hook.254 (1μs)
  • shop.hook.252 (30.21ms)
  • shop.hook.120 (3μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (3μs)
  • shop.hook.118 (3μs)
  • shop.hook.302 (2μ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 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.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.302 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.302 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (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 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (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.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.306 (1μs)
  • shop.hook.303 (1μs)
  • shop.hook.142 (1μs)
  • shop.hook.400 (0μs)
  • shop.hook.132 (2μs)
  • shop.hook.166 (1μs)
  • shop.hook.143 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.251 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.120 (4μs)
  • shop.hook.120 (3μs)
  • shop.hook.214 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (1μs)
  • shop.hook.178 (1μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (1μs)
  • shop.hook.119 (2μs)
  • shop.hook.119 (0μs)
  • shop.hook.119 (0μs)
  • shop.hook.119 (0μs)
  • shop.hook.119 (0μs)
  • shop.hook.119 (0μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (4μs)
  • shop.hook.253 (2μs)
  • shop.hook.120 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (2μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (3μs)
  • shop.hook.253 (2μs)
  • shop.hook.221 (3μs)
  • shop.hook.119 (2μs)
  • shop.hook.119 (0μs)
  • shop.hook.119 (1μs)
  • shop.hook.119 (1μs)
  • shop.hook.119 (1μs)
  • shop.hook.119 (0μs)
  • shop.hook.321 (2μs)
  • shop.hook.260 (2μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (1μs)
  • shop.hook.124 (2μs)
  • shop.hook.124 (1μs)
  • shop.hook.123 (2μs)
  • shop.hook.124 (0μs)
  • shop.hook.124 (0μs)
  • shop.hook.123 (1μs)
  • shop.hook.124 (0μs)
  • shop.hook.124 (0μs)
  • shop.hook.123 (1μs)
  • shop.hook.124 (0μs)
  • shop.hook.124 (0μs)
  • shop.hook.123 (1μs)
  • shop.hook.103 (2μs)
  • shop.hook.330 (1μs)
  • shop.hook.60 (1μs)
  • shop.hook.58 (0μs)
  • shop.hook.59 (1μs)
  • shop.hook.110 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.253 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.253 (1μs)
  • shop.hook.22 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.118 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.221 (1μs)
  • shop.hook.226 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (0μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (1μs)
  • shop.hook.330 (0μs)
  • shop.hook.331 (0μs)
  • shop.hook.118 (1μs)
  • shop.hook.204 (3μs)
  • shop.hook.175 (2μs)
  • shop.hook.109 (5μs)
  • shop.hook.99 (4μs)
  • shop.hook.221 (5μs)
  • shop.hook.253 (2μs)
  • shop.hook.89 (4μs)
  • shop.hook.90 (2μs)
  • shop.hook.221 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.300 (4μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (5μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (0μs)
  • shop.hook.301 (1μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (0μs)
  • shop.hook.300 (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.208 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (2μs)
  • shop.hook.120 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (1μs)
  • shop.hook.208 (2μs)
  • shop.hook.208 (2μs)
  • shop.hook.101 (2μs)
  • 1 x Shop start to end (93.1%)
    345.26ms
    2 x shop.hook.252 (8.15%)
    30.21ms
    1 x shop.hook.320 (0.22%)
    823μs
    135 x shop.hook.301 (0.03%)
    112μs
    135 x shop.hook.300 (0.03%)
    108μs
    23 x shop.hook.120 (0.01%)
    55μs
    20 x shop.hook.221 (0.01%)
    52μs
    17 x shop.hook.208 (0.01%)
    25μs
    16 x shop.hook.253 (0.01%)
    24μs
    10 x shop.hook.302 (0%)
    8μs
    9 x shop.hook.330 (0%)
    8μs
    12 x shop.hook.119 (0%)
    7μs
    2 x shop.hook.250 (0%)
    6μs
    3 x shop.hook.118 (0%)
    5μs
    4 x shop.hook.123 (0%)
    5μs
    1 x shop.hook.109 (0%)
    5μs
    1 x shop.hook.133 (0%)
    4μs
    1 x shop.hook.99 (0%)
    4μs
    1 x shop.hook.89 (0%)
    4μs
    2 x shop.hook.254 (0%)
    3μs
    8 x shop.hook.124 (0%)
    3μs
    2 x shop.hook.251 (0%)
    3μs
    1 x shop.hook.131 (0%)
    3μs
    1 x shop.hook.361 (0%)
    3μs
    1 x shop.hook.214 (0%)
    3μs
    1 x shop.hook.204 (0%)
    3μs
    1 x shop.hook.143 (0%)
    2μs
    1 x shop.hook.260 (0%)
    2μs
    1 x shop.hook.132 (0%)
    2μs
    1 x shop.hook.321 (0%)
    2μs
    1 x shop.hook.103 (0%)
    2μs
    1 x shop.hook.110 (0%)
    2μs
    1 x shop.hook.22 (0%)
    2μs
    1 x shop.hook.226 (0%)
    2μs
    1 x shop.hook.175 (0%)
    2μs
    1 x shop.hook.90 (0%)
    2μs
    1 x shop.hook.101 (0%)
    2μs
    1 x shop.hook.156 (0%)
    1μs
    1 x shop.hook.306 (0%)
    1μs
    1 x shop.hook.303 (0%)
    1μs
    1 x shop.hook.142 (0%)
    1μs
    1 x shop.hook.166 (0%)
    1μs
    1 x shop.hook.178 (0%)
    1μs
    1 x shop.hook.60 (0%)
    1μs
    1 x shop.hook.59 (0%)
    1μs
    1 x shop.hook.400 (0%)
    0μs
    1 x shop.hook.58 (0%)
    0μs
    1 x shop.hook.331 (0%)
    0μs
624 statements were executed, 402 of which were duplicates, 222 unique79.95ms10.25MB
default
  • SELECT * FROM tsprache63μs16.22KB20000000000000b790000000000000000default
  • SELECT * FROM tkundengruppe WHERE `cStandard`=?44μ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.39ms17.39KB530000000000000b840000000000000000default
    Params
    :section1
  • SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe33μ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.kPlugin134μs16.69KB120000000000000b4f0000000000000000default
    Params
    :state2
  • SELECT * FROM tsprache35μs16.22KB20000000000000aec0000000000000000default
  • SELECT * FROM twaehrung25μs16.23KB10000000000000ae80000000000000000default
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache39μs16.08KB00000000000000a8b0000000000000000default
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section588μs16.95KB27000000000000090a0000000000000000default
    Params
    :section7
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC104μs16.22KB200000000000008ee0000000000000000default
  • SELECT * FROM tglobals WHERE dLetzteAenderung > :ts38μs16.2KB000000000000008f10000000000000000default
    Params
    :ts2025-04-27 16:25:21
  • SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache LEFT JOIN tsprachiso ON tsprache.cISO = tsprachiso.cISO ORDER BY tsprache.kSprache ASC48μs16.22KB20000000000000baf0000000000000000default
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv40μs16.42KB30000000000000bb00000000000000000default
    Params
    :nAktiv1
  • SELECT kPlugin AS id, bExtension AS modern FROM tplugin WHERE nStatus = :state AND bBootstrap = 1 ORDER BY nPrio ASC47μs16.31KB300000000000008fb0000000000000000default
    Params
    :state2
  • SELECT * FROM tplugin WHERE `kPlugin`=?53μs17.2KB100000000000009000000000000000000default
    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 153μs16.11KB100000000000017020000000000000000default
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 133μs16.11KB100000000000017060000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?39μs17.25KB2000000000000172a0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?28μs17.22KB0000000000000173b0000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort47μs16.34KB600000000000016f40000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin73μs16.3KB400000000000017120000000000000000default
    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.kLink114μs16.46KB400000000000017320000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)43μs16.14KB400000000000017050000000000000000default
  • 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.cName575μs17KB800000000000017060000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB000000000000017410000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000017460000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000174b0000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000017500000000000000000default
    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.nSort554μs17.34KB900000000000017310000000000000000default
    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.kPluginSprachvariable326μs34.06KB78000000000000170f0000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin51μs16.34KB0000000000000179c0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id76μs16.78KB400000000000017970000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid62μs16.98KB300000000000017900000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort49μs16.55KB300000000000017900000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart29μs16.28KB200000000000017900000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort36μs16.55KB300000000000017900000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart21μs16.28KB200000000000017900000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort31μs16.55KB300000000000017900000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart19μs16.28KB200000000000017900000000000000000default
    Params
    :kZahlungsart75
  • SELECT * FROM tplugin WHERE `kPlugin`=?54μs17.2KB100000000000017c70000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort43μs16.27KB100000000000018660000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin63μs16.24KB0000000000000186d0000000000000000default
    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.4KB0000000000000186c0000000000000000default
    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.nSort193μs17.19KB000000000000018730000000000000000default
    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.kPluginSprachvariable227μs17.13KB18000000000000187a0000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin51μs16.34KB0000000000000188f0000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id64μs16.72KB0000000000000188a0000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid54μs16.94KB000000000000018860000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT cSektion AS sec, cWert AS val, cName AS name FROM ttemplateeinstellungen WHERE cTemplate = (SELECT cTemplate FROM ttemplate WHERE eTyp = 'standard')118μs17.08KB63000000000000187f0000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?36μs17.2KB100000000000018800000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 130μs16.11KB100000000000018c00000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?33μs17.25KB2000000000000189c0000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?149μs17.22KB000000000000018e80000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort133μs16.34KB600000000000018cf0000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin99μs16.37KB800000000000018cc0000000000000000default
    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.kLink208μs16.52KB800000000000018e10000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)145μs16.2KB800000000000018b10000000000000000default
  • 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.cName698μs17.13KB1600000000000018f00000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink121μs16.12KB000000000000019050000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink116μs16.12KB0000000000000190a0000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink115μs16.12KB0000000000000190f0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink105μs16.12KB000000000000019140000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink108μs16.12KB000000000000019190000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink106μs16.12KB0000000000000191e0000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink109μs16.12KB000000000000019230000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB000000000000019280000000000000000default
    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.nSort299μs17.19KB000000000000018ae0000000000000000default
    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.kPluginSprachvariable297μs16.84KB200000000000018e50000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin81μs16.34KB000000000000019010000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id101μs16.72KB000000000000018fb0000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid97μs16.94KB000000000000018f70000000000000000default
    Params
    :pidkPlugin\_5\_%
  • SELECT * FROM ttemplate WHERE `eTyp`=?76μs16.85KB1000000000000195e0000000000000000default
    Params
    0standard
  • SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate196μs17.2KB6300000000000019640000000000000000default
    Params
    :cTemplateBALTER
  • SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio91μs16.3KB300000000000019a30000000000000000default
    Params
    :nStatus2
  • SELECT * FROM tconsent WHERE `active`=:active70μs16.27KB20000000000001ee60000000000000000default
    Params
    :active1
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID64μs16.31KB20000000000001f000000000000000000default
    Params
    :consentID1
  • SELECT * FROM tsprache41μs16.22KB20000000000001f000000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID59μs16.31KB20000000000001f0b0000000000000000default
    Params
    :consentID2
  • SELECT * FROM tsprache37μs16.22KB20000000000001f0b0000000000000000default
  • 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 = :section113μs16.56KB30000000000001f0b0000000000000000default
    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 = :pid632μs17.84KB720000000000001f1b0000000000000000default
    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 = 098μs16.19KB40000000000001f530000000000000000default
  • 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 NULL236μs18.39KB10000000000001f3b0000000000000000default
    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 = :section890μs17.02KB320000000000001f490000000000000000default
    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.nSort261μs17KB00000000000001f750000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?85μs16.93KB40000000000001f700000000000000000default
    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 NULL219μs18.39KB10000000000001f6f0000000000000000default
    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.nSort214μs17KB00000000000001f6f0000000000000000default
    Params
    :cid123
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?88μs16.99KB80000000000001f240000000000000000default
    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 NULL220μs18.39KB10000000000001f250000000000000000default
    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.nSort214μs17KB00000000000001f250000000000000000default
    Params
    :cid132
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?81μs16.99KB70000000000001f2e0000000000000000default
    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 NULL213μs18.39KB10000000000001f2f0000000000000000default
    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.nSort229μs17KB00000000000001f2f0000000000000000default
    Params
    :cid220
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?141μs16.87KB00000000000001f790000000000000000default
    Params
    0220
  • SELECT id_category FROM submenusettings WHERE id = 149μs16.04KB10000000000001f3c0000000000000000default
  • 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 NULL213μs18.39KB10000000000001f330000000000000000default
    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 = :section5.5ms18.02KB910000000000001f7e0000000000000000default
    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 = 1114μs16.16KB00000000000001fdb0000000000000000default
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort174μs17KB00000000000001fdc0000000000000000default
    Params
    :cid109
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?61μs16.95KB50000000000001fd50000000000000000default
    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 NULL166μs18.39KB10000000000001fd40000000000000000default
    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.nSort150μs17KB00000000000001fd40000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?65μs16.95KB50000000000001fcb0000000000000000default
    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 NULL204μs18.39KB10000000000001fca0000000000000000default
    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.nSort155μs17KB00000000000001fca0000000000000000default
    Params
    :cid111
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?63μs16.93KB40000000000001fc10000000000000000default
    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 NULL195μs18.39KB10000000000001fc00000000000000000default
    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.nSort158μs17KB00000000000001fc00000000000000000default
    Params
    :cid112
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?56μs16.95KB50000000000001fb70000000000000000default
    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 NULL141μs18.39KB10000000000001fb60000000000000000default
    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.nSort130μs17KB00000000000001fb60000000000000000default
    Params
    :cid115
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?40μs16.87KB00000000000001fad0000000000000000default
    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 NULL132μs18.39KB10000000000001fad0000000000000000default
    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.nSort132μs17KB00000000000001fad0000000000000000default
    Params
    :cid116
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?69μs16.87KB00000000000001fa30000000000000000default
    Params
    0116
  • SELECT * FROM tland118μs20.19KB2360000000000001f990000000000000000default
  • SELECT cLaender FROM tversandart24μs16.05KB20000000000001f990000000000000000default
  • SELECT DISTINCT cLandIso FROM tstaat60μs16.52KB290000000000001f990000000000000000default
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName109μs16.56KB2400000000000020cd0000000000000000default
    Params
    :cLandIsoAR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName51μs16.34KB900000000000020da0000000000000000default
    Params
    :cLandIsoAT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName40μs16.34KB1000000000000020b90000000000000000default
    Params
    :cLandIsoBE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.69KB2800000000000020fc0000000000000000default
    Params
    :cLandIsoBG
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.63KB2700000000000021180000000000000000default
    Params
    :cLandIsoBR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.41KB13000000000000213d0000000000000000default
    Params
    :cLandIsoCA
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName51μs16.63KB26000000000000210c0000000000000000default
    Params
    :cLandIsoCH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName66μs16.81KB3400000000000021780000000000000000default
    Params
    :cLandIsoCN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName38μs16.28KB600000000000021a10000000000000000default
    Params
    :cLandIsoCY
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName76μs16.44KB1400000000000021990000000000000000default
    Params
    :cLandIsoCZ
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName47μs16.44KB1600000000000021730000000000000000default
    Params
    :cLandIsoDE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName29μs16.27KB500000000000021da0000000000000000default
    Params
    :cLandIsoDK
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName39μs16.44KB15000000000000216f0000000000000000default
    Params
    :cLandIsoEE
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName79μs17.06KB5000000000000021f90000000000000000default
    Params
    :cLandIsoES
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName46μs16.5KB1900000000000022340000000000000000default
    Params
    :cLandIsoFI
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName155μs18.19KB11400000000000022230000000000000000default
    Params
    :cLandIsoFR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName26μs16.25KB400000000000022c60000000000000000default
    Params
    :cLandIsoGB
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName93μs16.41KB1300000000000022b40000000000000000default
    Params
    :cLandIsoGR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName62μs16.56KB2100000000000022ac0000000000000000default
    Params
    :cLandIsoHR
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName67μs16.81KB36000000000000228a0000000000000000default
    Params
    :cLandIsoIN
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName143μs17.94KB110000000000000222b0000000000000000default
    Params
    :cLandIsoIT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName75μs16.94KB4700000000000023ab0000000000000000default
    Params
    :cLandIsoJP
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.34KB10000000000000238c0000000000000000default
    Params
    :cLandIsoLT
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName186μs18.19KB11900000000000023970000000000000000default
    Params
    :cLandIsoLV
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName117μs16.69KB32000000000000246a0000000000000000default
    Params
    :cLandIsoMX
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName54μs16.38KB1200000000000024500000000000000000default
    Params
    :cLandIsoNL
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName75μs16.94KB4200000000000021f00000000000000000default
    Params
    :cLandIsoRO
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName109μs17.44KB7800000000000024f90000000000000000default
    Params
    :cLandIsoTH
  • SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName100μs17.19KB6300000000000025700000000000000000default
    Params
    :cLandIsoUS
  • SELECT * FROM tfirma LIMIT 142μs16.52KB10000000000001f9c0000000000000000default
  • 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 nSort85μs16.88KB00000000000001f9f0000000000000000default
    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 > 0111μs16.59KB2200000000000020a90000000000000000default
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName57μs16.27KB0000000000000208a0000000000000000default
    Params
    :lgid1
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName49μs16.37KB600000000000020850000000000000000default
    Params
    :lgid4
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (440,442,68,71,443,444)35μs16.17KB600000000000020860000000000000000default
  • 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.cName556μs17.06KB1200000000000020750000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink55μs16.12KB000000000000020640000000000000000default
    Params
    :kVaterLink440
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink28μs16.12KB0000000000000205f0000000000000000default
    Params
    :kVaterLink442
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000205a0000000000000000default
    Params
    :kVaterLink68
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020550000000000000000default
    Params
    :kVaterLink71
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020500000000000000000default
    Params
    :kVaterLink443
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000204b0000000000000000default
    Params
    :kVaterLink444
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName76μs16.37KB6000000000000206a0000000000000000default
    Params
    :lgid5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (69,67,59,49,73,74)33μs16.17KB600000000000020690000000000000000default
  • 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.cName625μs17.06KB12000000000000207c0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB0000000000000203d0000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020380000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000020330000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000202e0000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020290000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020240000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName95μs16.71KB2700000000000020430000000000000000default
    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)56μs16.52KB2700000000000020420000000000000000default
  • 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.cName887μs33.75KB540000000000001ffd0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB000000000000025420000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000025470000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000254c0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025510000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000025560000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000255b0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025600000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025650000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000256a0000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000260f0000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026140000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026190000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000261e0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026230000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026280000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000262d0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026320000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026370000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000263c0000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026410000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026460000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000264b0000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026500000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.1KB000000000000026550000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000265a0000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.1KB0000000000000265f0000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026640000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName71μs16.37KB60000000000001f940000000000000000default
    Params
    :lgid9
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (103,104,420,422,64,61)34μs16.17KB60000000000001f950000000000000000default
  • 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.cName475μs17.03KB100000000000001f840000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB00000000000001fe70000000000000000default
    Params
    :kVaterLink103
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB00000000000001fec0000000000000000default
    Params
    :kVaterLink104
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB00000000000001ff10000000000000000default
    Params
    :kVaterLink420
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000001ff60000000000000000default
    Params
    :kVaterLink422
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020180000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020020000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName68μs16.35KB50000000000001fe10000000000000000default
    Params
    :lgid10
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (109,112,111,110,113)31μs16.16KB50000000000001fe20000000000000000default
  • 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.cName487μs17.03KB100000000000001f8b0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB0000000000000200e0000000000000000default
    Params
    :kVaterLink109
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020130000000000000000default
    Params
    :kVaterLink112
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020420000000000000000default
    Params
    :kVaterLink111
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000201d0000000000000000default
    Params
    :kVaterLink110
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000207c0000000000000000default
    Params
    :kVaterLink113
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName64μs16.32KB300000000000020080000000000000000default
    Params
    :lgid11
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (446,448,447)27μs16.13KB300000000000020090000000000000000default
  • 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.cName410μs16.97KB60000000000001f880000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB000000000000020690000000000000000default
    Params
    :kVaterLink446
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020860000000000000000default
    Params
    :kVaterLink448
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000204c0000000000000000default
    Params
    :kVaterLink447
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName65μs16.32KB30000000000001f330000000000000000default
    Params
    :lgid12
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (115,50,66)29μs16.13KB30000000000001f7e0000000000000000default
  • 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.cName415μs16.97KB600000000000020750000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000026730000000000000000default
    Params
    :kVaterLink115
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026780000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000267d0000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName63μs16.34KB4000000000000266d0000000000000000default
    Params
    :lgid13
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (116,118,119,117)31μs16.14KB4000000000000266e0000000000000000default
  • 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.cName437μs17KB800000000000026820000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB0000000000000268f0000000000000000default
    Params
    :kVaterLink116
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026940000000000000000default
    Params
    :kVaterLink118
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026990000000000000000default
    Params
    :kVaterLink119
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000269e0000000000000000default
    Params
    :kVaterLink117
  • SELECT kLink FROM tlink JOIN tlinkgroupassociations a ON tlink.kLink = a.linkID WHERE a.linkGroupID = :lgid ORDER BY tlink.nSort, tlink.cName57μs16.29KB100000000000026890000000000000000default
    Params
    :lgid14
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (120)20μs16.09KB1000000000000268a0000000000000000default
  • 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.cName170μs16.91KB200000000000026810000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000026820000000000000000default
    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.kSprache744μs34KB7400000000000020910000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.1KB000000000000026d70000000000000000default
    Params
    :kVaterLink3
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.1KB000000000000026dc0000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000026e10000000000000000default
    Params
    :kVaterLink49
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026e60000000000000000default
    Params
    :kVaterLink50
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026eb0000000000000000default
    Params
    :kVaterLink59
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026f00000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink32μs16.12KB000000000000026f50000000000000000default
    Params
    :kVaterLink63
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026fa0000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026ff0000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027040000000000000000default
    Params
    :kVaterLink67
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027090000000000000000default
    Params
    :kVaterLink69
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000270e0000000000000000default
    Params
    :kVaterLink72
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027130000000000000000default
    Params
    :kVaterLink73
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027180000000000000000default
    Params
    :kVaterLink74
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000271d0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027220000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027270000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000272c0000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027310000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027360000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000273b0000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027400000000000000000default
    Params
    :kVaterLink83
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027450000000000000000default
    Params
    :kVaterLink84
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000274a0000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000274f0000000000000000default
    Params
    :kVaterLink86
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027540000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027590000000000000000default
    Params
    :kVaterLink106
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000275e0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027630000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027680000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000276d0000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027720000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027770000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000277c0000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027810000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027860000000000000000default
    Params
    :kVaterLink438
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000278b0000000000000000default
    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.kSprache603μs17.23KB2600000000000026d20000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.1KB000000000000026b10000000000000000default
    Params
    :kVaterLink4
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000026ac0000000000000000default
    Params
    :kVaterLink61
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026a70000000000000000default
    Params
    :kVaterLink64
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026810000000000000000default
    Params
    :kVaterLink66
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000268c0000000000000000default
    Params
    :kVaterLink75
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020a30000000000000000default
    Params
    :kVaterLink76
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020a10000000000000000default
    Params
    :kVaterLink77
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020950000000000000000default
    Params
    :kVaterLink78
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000209c0000000000000000default
    Params
    :kVaterLink79
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027910000000000000000default
    Params
    :kVaterLink80
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027960000000000000000default
    Params
    :kVaterLink81
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000279b0000000000000000default
    Params
    :kVaterLink85
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027a00000000000000000default
    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.kSprache297μs16.75KB000000000000026b60000000000000000default
  • 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 = :section85μs16.56KB300000000000027aa0000000000000000default
    Params
    :section128
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?41μs16.74KB1000000000000280c0000000000000000default
    Params
    0kMerkmalWert
    12-Familienhaus
  • SELECT * FROM tseo WHERE `cKey`=? AND `cSeo`=?21μs16.73KB1000000000000280c0000000000000000default
    Params
    0kMerkmalWert
    1Schwarz_1
  • SELECT * FROM tseo WHERE cSeo = :slg19μs16.22KB100000000000028120000000000000000default
    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 NULL143μs18.39KB100000000000028150000000000000000default
    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.nSort140μs17KB000000000000028150000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?50μs16.91KB3000000000000281f0000000000000000default
    Params
    0226
  • SELECT tmerkmalwert.kMerkmal, tmerkmalwert.kMerkmalWert, tmerkmal.nMehrfachauswahl FROM tmerkmalwert JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal WHERE kMerkmalWert IN (2,35)53μs16.11KB20000000000001f550000000000000000default
  • 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 = :val55μs16.89KB100000000000028210000000000000000default
    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 = :val40μs16.89KB100000000000028260000000000000000default
    Params
    :val35
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL132μs18.39KB1000000000000282e0000000000000000default
    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.nSort131μs17KB0000000000000282e0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?46μs16.91KB300000000000028380000000000000000default
    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 NULL132μs18.39KB100000000000028390000000000000000default
    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.nSort122μs17KB000000000000028390000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?43μs16.91KB300000000000028420000000000000000default
    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 NULL143μs18.39KB1000000000000283d0000000000000000default
    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.nSort138μs17KB0000000000000283d0000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?51μs16.91KB3000000000000284b0000000000000000default
    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 NULL142μs18.39KB100000000000028460000000000000000default
    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.nSort135μs17KB000000000000028460000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?51μs16.91KB300000000000028540000000000000000default
    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 NULL201μs18.39KB1000000000000284f0000000000000000default
    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.nSort174μs17KB0000000000000284f0000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?64μs16.95KB5000000000000285d0000000000000000default
    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 NULL162μs18.39KB1000000000000285e0000000000000000default
    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.nSort146μs17KB0000000000000285e0000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?53μs16.93KB400000000000028670000000000000000default
    Params
    0108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie32μs16.45KB3000000000000286f0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie21μs16.41KB0000000000000286f0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB0000000000000286f0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB0000000000000286f0000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName251μs16.04KB1000000000000286c0000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie45μs16.45KB300000000000028800000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie23μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie29μs16.41KB000000000000028800000000000000000default
    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 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 #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, 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.cName750μs18.67KB100000000000028800000000000000000default
    Params
    :lid1
  • SELECT tseo.cSeo, tseo.kSprache, thersteller.cName FROM tseo JOIN thersteller ON thersteller.kHersteller = tseo.kKey AND thersteller.nAktiv = 1 WHERE cKey = 'kHersteller' AND kKey IN (2)114μs16.11KB200000000000028930000000000000000default
  • SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = therstellersprache.kSprache WHERE thersteller.kHersteller = :manfID AND thersteller.nAktiv = 1 GROUP BY kSprache, thersteller.kHersteller351μs17.41KB600000000000028960000000000000000default
    Params
    :manfID2
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie86μs16.45KB300000000000028850000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie57μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie94μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie94μs16.41KB000000000000028850000000000000000default
    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 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 #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName ) AS ssMerkmal GROUP BY ssMerkmal.nSterne ORDER BY ssMerkmal.nSterne DESC521μs16.05KB000000000000028850000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie93μs16.45KB300000000000028800000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie61μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB000000000000028800000000000000000default
    Params
    :kOberKategorie229
  • SELECT kKategorie FROM tkategoriesichtbarkeit74μs16.02KB000000000000028a50000000000000000default
  • SELECT tseo.cSeo, ssMerkmal.kKategorie, ssMerkmal.cName, ssMerkmal.nSort, COUNT(*) AS nAnzahl FROM (SELECT tkategorie.kKategorie, tkategorie.nSort, tkategorie.cName FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join4 from JTL\Filter\Items\Category::getOptions JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tkategorie.kKategorie, tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, 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.cName524μs18.14KB100000000000028b40000000000000000default
    Params
    :lid1
  • 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 NULL257μs18.39KB100000000000028ba0000000000000000default
    Params
    :kid227
    :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.nSort251μs17KB000000000000028ba0000000000000000default
    Params
    :cid227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?78μs16.87KB000000000000028c40000000000000000default
    Params
    0227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie76μs16.45KB300000000000028850000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie49μs16.41KB000000000000028850000000000000000default
    Params
    :kOberKategorie229
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie62μs16.45KB300000000000028d00000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie53μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie86μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie40μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #bestseller JOIN from JTL\Filter\Items\SearchSpecial::getOptions JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 tpreisdetail.fVKNetto, tartikel.cName290μs16.02KB000000000000028860000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.45KB300000000000028d00000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie120μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie65μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #special offer JOIN1 from JTL\Filter\Items\SearchSpecial::getOptions JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel #special offer JOIN2 from JTL\Filter\Items\SearchSpecial::getOptions JOIN tsonderpreise ON tsonderpreise.kArtikelSonderpreis = tartikelsonderpreis.kArtikelSonderpreis #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 tpreisdetail.fVKNetto, tartikel.cName507μs16.02KB000000000000028c50000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie131μs16.45KB300000000000028d00000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie109μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie58μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.41KB000000000000028d00000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 tpreisdetail.fVKNetto, tartikel.cName313μs16.02KB000000000000028b40000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie85μs16.45KB300000000000028f40000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000028f40000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB000000000000028f40000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie49μs16.41KB000000000000028f40000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikel.cTopArtikel = 'Y' AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName325μs16.02KB000000000000028e30000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie81μs16.45KB300000000000028fe0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie60μs16.41KB000000000000028fe0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie52μs16.41KB000000000000028fe0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB000000000000028fe0000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND NOW() < tartikel.dErscheinungsdatum AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName264μs16.02KB000000000000028c60000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie79μs16.45KB3000000000000290c0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB0000000000000290c0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.41KB0000000000000290c0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB0000000000000290c0000000000000000default
    Params
    :kOberKategorie229
  • SELECT tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #top reviews JOIN from JTL\Filter\Items\SearchSpecial::getOptions JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 tpreisdetail.fVKNetto, tartikel.cName424μs16.02KB000000000000029000000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie84μs16.45KB300000000000028b40000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie56μs16.41KB000000000000028b40000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.41KB000000000000028b40000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB000000000000028b40000000000000000default
    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 JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join from FilterAvailability JOIN tartikel AS taFA ON tartikel.kArtikel = taFA.kArtikel #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 ASC372μs16.06KB100000000000028c50000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie87μs16.45KB3000000000000291a0000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie57μs16.41KB0000000000000291a0000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie51μs16.41KB0000000000000291a0000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie50μs16.41KB0000000000000291a0000000000000000default
    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 tartikel.kArtikel AS kArtikel, tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert, tmerkmalwert.cBildPfad AS cMMWBildPfad, tmerkmal.nSort AS nSortMerkmal, tmerkmalwert.nSort, tmerkmal.cTyp, tmerkmal.nMehrfachauswahl, tmerkmal.cBildPfad AS cMMBildPfad FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join1 from JTL\Filter\Items\Characteristic::getState JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join2 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert #join4 from JTL\Filter\Items\Characteristic::getState JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal #join default lang from JTL\Filter\Items\Characteristic::getState INNER JOIN tmerkmalwertsprache ON tmerkmalwertsprache.kMerkmalWert = tartikelmerkmal.kMerkmalWert AND tmerkmalwertsprache.kSprache = 1 #join active AND filters from JTL\Filter\Items\Characteristic::getState JOIN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35 ) 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 tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 ) AS ssMerkmal GROUP BY ssMerkmal.kMerkmalWert ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert550μs16.34KB600000000000028e30000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 166μs16.16KB100000000000029510000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 147μs16.16KB100000000000029560000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB100000000000029550000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 141μs16.16KB1000000000000295b0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB1000000000000295e0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB100000000000029610000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029640000000000000000default
    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,4)145μs16.2KB300000000000029500000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 154μs16.2KB1000000000000296d0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB100000000000029710000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029700000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029760000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029790000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB1000000000000297c0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB1000000000000297f0000000000000000default
    Params
    :cid1
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 142μs16.2KB100000000000029820000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB100000000000029870000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029860000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB1000000000000298c0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB1000000000000298f0000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB100000000000029920000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB100000000000029950000000000000000default
    Params
    :cid2
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB100000000000029990000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 142μs16.2KB1000000000000299d0000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 162μs16.2KB1000000000000299c0000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 141μs16.2KB100000000000029a20000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB100000000000029a50000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029a80000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029ab0000000000000000default
    Params
    :cid4
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029ab0000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029b30000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 137μs16.16KB100000000000029b20000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029b80000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 141μs16.16KB100000000000029bb0000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029be0000000000000000default
    Params
    :cid13
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB100000000000029c10000000000000000default
    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)106μs16.17KB100000000000029ae0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 147μs16.2KB100000000000029ae0000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB100000000000029c90000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB100000000000029c80000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB100000000000029ce0000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 137μs16.2KB100000000000029d10000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029d40000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 164μs16.2KB100000000000029d70000000000000000default
    Params
    :cid25
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 130μs16.16KB100000000000029d70000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 121μs16.16KB100000000000029df0000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 120μs16.16KB100000000000029de0000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 149μs16.16KB100000000000029e40000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 141μs16.16KB100000000000029e70000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 140μs16.16KB100000000000029ea0000000000000000default
    Params
    :cid5
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB100000000000029ed0000000000000000default
    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)101μs16.17KB100000000000029da0000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 147μs16.2KB100000000000029f30000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB100000000000029f70000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029f60000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029fc0000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 138μs16.2KB100000000000029ff0000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 140μs16.2KB10000000000002a020000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002a050000000000000000default
    Params
    :cid20
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002a050000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002a0d0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002a0c0000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002a120000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 138μs16.16KB10000000000002a150000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 139μs16.16KB10000000000002a180000000000000000default
    Params
    :cid11
  • SELECT cBildpfad AS path FROM tmerkmal WHERE kMerkmal = :cid LIMIT 141μs16.16KB10000000000002a1b0000000000000000default
    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 (35)95μs16.17KB10000000000002a080000000000000000default
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 139μs16.2KB10000000000002a210000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 134μs16.2KB10000000000002a250000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB10000000000002a240000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 133μs16.2KB10000000000002a2a0000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB10000000000002a2d0000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 133μs16.2KB10000000000002a300000000000000000default
    Params
    :cid35
  • SELECT cBildpfad AS path FROM tmerkmalwert WHERE kMerkmalWert = :cid LIMIT 132μs16.2KB10000000000002a330000000000000000default
    Params
    :cid35
  • SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type FROM teinstellungen LEFT JOIN teinstellungenconf ON teinstellungenconf.cWertName = teinstellungen.cName AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion WHERE teinstellungen.kEinstellungenSektion = :section2.38ms17.52KB5600000000000029400000000000000000default
    Params
    :section5
  • 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.88ms17.39KB510000000000002a650000000000000000default
    Params
    :section4
  • 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 = :section531μs16.83KB20000000000000291a0000000000000000default
    Params
    :section8
  • 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 = :section150μs16.64KB70000000000002a460000000000000000default
    Params
    :section112
  • 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 = :section213μs16.77KB150000000000002a3d0000000000000000default
    Params
    :section107
  • SELECT cBrocken FROM tbrocken LIMIT 126μs16.04KB1000000000000291a0000000000000000default
  • SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid30μs16.22KB10000000000002a360000000000000000default
    Params
    :pid1305
  • SELECT tartikel.kArtikel, tartikel.kHersteller, tartikel.kLieferstatus, tartikel.kSteuerklasse, tartikel.kEinheit, tartikel.kVPEEinheit, tartikel.kVersandklasse, tartikel.kEigenschaftKombi, tartikel.kVaterArtikel, tartikel.kStueckliste, tartikel.kWarengruppe, tartikel.cArtNr, tartikel.cName, tartikel.cBeschreibung, tartikel.cAnmerkung, tartikel.fLagerbestand, tartikel.fMwSt, tartikel.cSeo AS originalSeo, IF (tartikelabnahme.fMindestabnahme IS NOT NULL, tartikelabnahme.fMindestabnahme, tartikel.fMindestbestellmenge) AS fMindestbestellmenge, IF (tartikelabnahme.fIntervall IS NOT NULL, tartikelabnahme.fIntervall, tartikel.fAbnahmeintervall) AS fAbnahmeintervall, tartikel.cBarcode, tartikel.cTopArtikel, tartikel.fGewicht, tartikel.fArtikelgewicht, tartikel.cNeu, tartikel.cKurzBeschreibung, tartikel.fUVP, tartikel.cLagerBeachten, tartikel.cLagerKleinerNull, tartikel.cLagerVariation, tartikel.cTeilbar, tartikel.fPackeinheit, tartikel.cVPE, tartikel.fVPEWert, tartikel.cVPEEinheit, tartikel.cSuchbegriffe, tartikel.nSort, tartikel.dErscheinungsdatum, tartikel.dErstellt, tartikel.dLetzteAktualisierung, tartikel.cSerie, tartikel.cISBN, tartikel.cASIN, tartikel.cHAN, tartikel.cUNNummer, tartikel.cGefahrnr, tartikel.nIstVater, date_format(tartikel.dErscheinungsdatum, '%d.%m.%Y') AS Erscheinungsdatum_de, tartikel.cTaric, tartikel.cUPC, tartikel.cHerkunftsland, tartikel.cEPID, tartikel.fZulauf, tartikel.dZulaufDatum, DATE_FORMAT(tartikel.dZulaufDatum, '%d.%m.%Y') AS dZulaufDatum_de, tartikel.fLieferantenlagerbestand, tartikel.fLieferzeit, tartikel.dMHD, DATE_FORMAT(tartikel.dMHD, '%d.%m.%Y') AS dMHD_de, tartikel.kMassEinheit, tartikel.kGrundPreisEinheit, tartikel.fMassMenge, tartikel.fGrundpreisMenge, tartikel.fBreite, tartikel.fHoehe, tartikel.fLaenge, tartikel.nLiefertageWennAusverkauft, tartikel.nAutomatischeLiefertageberechnung, tartikel.nBearbeitungszeit, me.cCode AS cMasseinheitCode, mes.cName AS cMasseinheitName, gpme.cCode AS cGrundpreisEinheitCode, gpmes.cName AS cGrundpreisEinheitName, tseo.cSeo, tsonderpreise.fNettoPreis, tartikelext.fDurchschnittsBewertung, tlieferstatus.cName AS cName_tlieferstatus, teinheit.cName AS teinheitcName, tartikelsonderpreis.cAktiv AS cAktivSonderpreis, tartikelsonderpreis.dStart AS dStart_en, DATE_FORMAT(tartikelsonderpreis.dStart, '%d.%m.%Y') AS dStart_de, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de, tversandklasse.cName AS cVersandklasse, round(tbestseller.fAnzahl) >= :bsms AS bIsBestseller, round(tartikelext.fDurchschnittsBewertung) >= :trmr AS bIsTopBewertet FROM tartikel LEFT JOIN tartikelabnahme ON tartikel.kArtikel = tartikelabnahme.kArtikel AND tartikelabnahme.kKundengruppe = :cgid LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kArtikel' AND tseo.kKey = tartikel.kArtikel AND tseo.kSprache = :lid LEFT JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel LEFT JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel LEFT JOIN tlieferstatus ON tlieferstatus.kLieferstatus = tartikel.kLieferstatus AND tlieferstatus.kSprache = :lid LEFT JOIN teinheit ON teinheit.kEinheit = tartikel.kEinheit AND teinheit.kSprache = :lid LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid LEFT JOIN tversandklasse ON tversandklasse.kVersandklasse = tartikel.kVersandklasse LEFT JOIN tmasseinheit me ON me.kMassEinheit = tartikel.kMassEinheit LEFT JOIN tmasseinheitsprache mes ON mes.kMassEinheit = me.kMassEinheit AND mes.kSprache = :lid LEFT JOIN tmasseinheit gpme ON gpme.kMassEinheit = tartikel.kGrundpreisEinheit LEFT JOIN tmasseinheitsprache gpmes ON gpmes.kMassEinheit = gpme.kMassEinheit AND gpmes.kSprache = :lid WHERE tartikel.kArtikel = :pid AND tartikelsichtbarkeit.kArtikel IS NULL 367μs42.52KB10000000000002a390000000000000000default
    Params
    :lid1
    :cgid1
    :pid1305
    :bsms10
    :trmr3
  • SELECT * FROM ttrennzeichen WHERE `nEinheit`=? AND `kSprache`=?41μs16.79KB10000000000002a390000000000000000default
    Params
    01
    11
  • SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = 'kHersteller' AND tseo.kSprache = therstellersprache.kSprache WHERE thersteller.kHersteller = :manfID AND thersteller.nAktiv = 1 GROUP BY kSprache, thersteller.kHersteller222μs17.41KB60000000000002a4b0000000000000000default
    Params
    :manfID2
  • SELECT kSuchspecialOverlay FROM tsuchspecialoverlay34μs16.18KB90000000000002a4b0000000000000000default
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 182μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID1
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 148μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID2
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 139μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID3
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 138μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID4
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 136μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID5
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID6
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID7
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 138μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID8
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT ssos.*, sso.cSuchspecial FROM tsuchspecialoverlaysprache ssos LEFT JOIN tsuchspecialoverlay sso ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay WHERE ssos.kSprache = :languageID AND ssos.kSuchspecialOverlay = :overlayID AND ssos.cTemplate IN (:templateName, :defaultTemplate) ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate) LIMIT 135μs16.95KB10000000000002a4b0000000000000000default
    Params
    :languageID1
    :overlayID9
    :templateNameBALTER
    :defaultTemplatedefault
  • SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid35μs16.25KB10000000000002a510000000000000000default
    Params
    :pid1305
    :cgid1
  • SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid24μs16.19KB10000000000002a510000000000000000default
    Params
    :pid1305
  • SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb31μs16.25KB10000000000002a510000000000000000default
    Params
    :priceID6318
  • SELECT tsonderpreise.fNettoPreis, tartikelsonderpreis.dEnde AS dEnde_en, DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de FROM tsonderpreise JOIN tartikel ON tartikel.kArtikel = :productID JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tartikelsonderpreis.kArtikel = :productID AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= CURDATE() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0) WHERE tsonderpreise.kKundengruppe = :customerGroup83μs17.08KB00000000000002a960000000000000000default
    Params
    :productID1305
    :customerGroup1
  • SELECT tartikel.kArtikel, tartikel.nIstVater, COALESCE(teigenschaft.kArtikel, 0) AS kArtikelVariation, tartikel.kSteuerklasse, tartikel.fLagerbestand, tartikel.fStandardpreisNetto fNettoPreis, tartikelkonfiggruppe.kKonfiggruppe g1, tkonfigitem.kKonfiggruppe g2 FROM tartikel LEFT JOIN tartikelkonfiggruppe ON tartikelkonfiggruppe.kArtikel = tartikel.kArtikel LEFT JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe LEFT JOIN teigenschaft ON teigenschaft.kArtikel = tartikel.kArtikel WHERE tartikel.kArtikel = :pid67μs16.95KB10000000000002aa20000000000000000default
    Params
    :pid1305
  • SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut38μs16.33KB90000000000002a9d0000000000000000default
    Params
    :kArtikel1305
  • SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort27μs16.25KB00000000000002aaf0000000000000000default
    Params
    :kArtikel1305
  • SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr27μs16.25KB10000000000002aaf0000000000000000default
    Params
    :pid1305
  • SELECT tartikelwarenlager.* FROM tartikelwarenlager JOIN twarenlager ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1 WHERE tartikelwarenlager.kArtikel = :productID44μs16.44KB00000000000002aa80000000000000000default
    Params
    :productID1305
  • SELECT tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert FROM tartikelmerkmal JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert WHERE tartikelmerkmal.kArtikel = :kArtikel ORDER BY tmerkmal.nSort, tmerkmalwert.nSort, tartikelmerkmal.kMerkmal64μs16.61KB40000000000002aa80000000000000000default
    Params
    :kArtikel1305
  • SELECT tmerkmalwert.*, COALESCE(loc.kSprache, def.kSprache) AS kSprache, COALESCE(loc.cWert, def.cWert) AS cWert, COALESCE(loc.cMetaTitle, def.cMetaTitle) AS cMetaTitle, COALESCE(loc.cMetaKeywords, def.cMetaKeywords) AS cMetaKeywords, COALESCE(loc.cMetaDescription, def.cMetaDescription) AS cMetaDescription, COALESCE(loc.cBeschreibung, def.cBeschreibung) AS cBeschreibung, COALESCE(loc.cSeo, def.cSeo) AS cSeo, COALESCE(tmerkmalsprache.cName, tmerkmal.cName) AS cName FROM tmerkmalwert INNER JOIN tmerkmalwertsprache AS def ON def.kMerkmalWert = tmerkmalwert.kMerkmalWert AND def.kSprache = :lid JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal LEFT JOIN tmerkmalwertsprache AS loc ON loc.kMerkmalWert = tmerkmalwert.kMerkmalWert LEFT JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = loc.kSprache WHERE tmerkmalwert.kMerkmalWert = :mid92μs17.59KB20000000000002ac10000000000000000default
    Params
    :mid2
    :lid1
  • SELECT tmerkmal.*, loc.kSprache, COALESCE(loc.cName, def.cName) AS cName FROM tmerkmal INNER JOIN tmerkmalsprache AS def ON def.kMerkmal = tmerkmal.kMerkmal AND def.kSprache = :lid LEFT JOIN tmerkmalsprache AS loc ON loc.kMerkmal = tmerkmal.kMerkmal WHERE tmerkmal.kMerkmal = :mid ORDER BY tmerkmal.nSort44μs16.7KB10000000000002ac60000000000000000default
    Params
    :mid1
    :lid1
  • SELECT tmerkmalwert.*, COALESCE(loc.kSprache, def.kSprache) AS kSprache, COALESCE(loc.cWert, def.cWert) AS cWert, COALESCE(loc.cMetaTitle, def.cMetaTitle) AS cMetaTitle, COALESCE(loc.cMetaKeywords, def.cMetaKeywords) AS cMetaKeywords, COALESCE(loc.cMetaDescription, def.cMetaDescription) AS cMetaDescription, COALESCE(loc.cBeschreibung, def.cBeschreibung) AS cBeschreibung, COALESCE(loc.cSeo, def.cSeo) AS cSeo, COALESCE(tmerkmalsprache.cName, tmerkmal.cName) AS cName FROM tmerkmalwert INNER JOIN tmerkmalwertsprache AS def ON def.kMerkmalWert = tmerkmalwert.kMerkmalWert AND def.kSprache = :lid JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal LEFT JOIN tmerkmalwertsprache AS loc ON loc.kMerkmalWert = tmerkmalwert.kMerkmalWert LEFT JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = loc.kSprache WHERE tmerkmalwert.kMerkmalWert = :mid69μs17.59KB20000000000002ac60000000000000000default
    Params
    :mid20
    :lid1
  • SELECT tmerkmal.*, loc.kSprache, COALESCE(loc.cName, def.cName) AS cName FROM tmerkmal INNER JOIN tmerkmalsprache AS def ON def.kMerkmal = tmerkmal.kMerkmal AND def.kSprache = :lid LEFT JOIN tmerkmalsprache AS loc ON loc.kMerkmal = tmerkmal.kMerkmal WHERE tmerkmal.kMerkmal = :mid ORDER BY tmerkmal.nSort36μs16.7KB10000000000002ad00000000000000000default
    Params
    :mid5
    :lid1
  • SELECT tmerkmalwert.*, COALESCE(loc.kSprache, def.kSprache) AS kSprache, COALESCE(loc.cWert, def.cWert) AS cWert, COALESCE(loc.cMetaTitle, def.cMetaTitle) AS cMetaTitle, COALESCE(loc.cMetaKeywords, def.cMetaKeywords) AS cMetaKeywords, COALESCE(loc.cMetaDescription, def.cMetaDescription) AS cMetaDescription, COALESCE(loc.cBeschreibung, def.cBeschreibung) AS cBeschreibung, COALESCE(loc.cSeo, def.cSeo) AS cSeo, COALESCE(tmerkmalsprache.cName, tmerkmal.cName) AS cName FROM tmerkmalwert INNER JOIN tmerkmalwertsprache AS def ON def.kMerkmalWert = tmerkmalwert.kMerkmalWert AND def.kSprache = :lid JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal LEFT JOIN tmerkmalwertsprache AS loc ON loc.kMerkmalWert = tmerkmalwert.kMerkmalWert LEFT JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = loc.kSprache WHERE tmerkmalwert.kMerkmalWert = :mid65μs17.59KB20000000000002ad00000000000000000default
    Params
    :mid35
    :lid1
  • SELECT tmerkmal.*, loc.kSprache, COALESCE(loc.cName, def.cName) AS cName FROM tmerkmal INNER JOIN tmerkmalsprache AS def ON def.kMerkmal = tmerkmal.kMerkmal AND def.kSprache = :lid LEFT JOIN tmerkmalsprache AS loc ON loc.kMerkmal = tmerkmal.kMerkmal WHERE tmerkmal.kMerkmal = :mid ORDER BY tmerkmal.nSort35μs16.7KB10000000000002ada0000000000000000default
    Params
    :mid11
    :lid1
  • SELECT tmerkmalwert.*, COALESCE(loc.kSprache, def.kSprache) AS kSprache, COALESCE(loc.cWert, def.cWert) AS cWert, COALESCE(loc.cMetaTitle, def.cMetaTitle) AS cMetaTitle, COALESCE(loc.cMetaKeywords, def.cMetaKeywords) AS cMetaKeywords, COALESCE(loc.cMetaDescription, def.cMetaDescription) AS cMetaDescription, COALESCE(loc.cBeschreibung, def.cBeschreibung) AS cBeschreibung, COALESCE(loc.cSeo, def.cSeo) AS cSeo, COALESCE(tmerkmalsprache.cName, tmerkmal.cName) AS cName FROM tmerkmalwert INNER JOIN tmerkmalwertsprache AS def ON def.kMerkmalWert = tmerkmalwert.kMerkmalWert AND def.kSprache = :lid JOIN tmerkmal ON tmerkmal.kMerkmal = tmerkmalwert.kMerkmal LEFT JOIN tmerkmalwertsprache AS loc ON loc.kMerkmalWert = tmerkmalwert.kMerkmalWert LEFT JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = loc.kSprache WHERE tmerkmalwert.kMerkmalWert = :mid62μs17.59KB20000000000002ada0000000000000000default
    Params
    :mid25
    :lid1
  • SELECT tmerkmal.*, loc.kSprache, COALESCE(loc.cName, def.cName) AS cName FROM tmerkmal INNER JOIN tmerkmalsprache AS def ON def.kMerkmal = tmerkmal.kMerkmal AND def.kSprache = :lid LEFT JOIN tmerkmalsprache AS loc ON loc.kMerkmal = tmerkmal.kMerkmal WHERE tmerkmal.kMerkmal = :mid ORDER BY tmerkmal.nSort35μs16.7KB10000000000002ae40000000000000000default
    Params
    :mid13
    :lid1
  • SELECT tkategorieartikel.kKategorie FROM tkategorieartikel LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorieartikel.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie WHERE tkategoriesichtbarkeit.kKategorie IS NULL AND tkategorieartikel.kKategorie > 0 AND tkategorieartikel.kArtikel = :pid62μs16.66KB10000000000002abf0000000000000000default
    Params
    :cgid1
    :pid1305
  • SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar, teigenschaft.cTyp, teigenschaft.nSort, teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert, teigenschaftwert.fAufpreisNetto, teigenschaftwert.fGewichtDiff, teigenschaftwert.cArtNr, teigenschaftwert.nSort AS teigenschaftwert_nSort, teigenschaftwert.fLagerbestand, teigenschaftwert.fPackeinheit, teigenschaftwertpict.kEigenschaftWertPict, teigenschaftwertpict.cPfad, teigenschaftwertpict.cType, teigenschaftwertaufpreis.fAufpreisNetto AS fAufpreisNetto_teigenschaftwertaufpreis FROM teigenschaft LEFT JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft LEFT JOIN teigenschaftsichtbarkeit ON teigenschaft.kEigenschaft = teigenschaftsichtbarkeit.kEigenschaft AND teigenschaftsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertsichtbarkeit ON teigenschaftwert.kEigenschaftWert = teigenschaftwertsichtbarkeit.kEigenschaftWert AND teigenschaftwertsichtbarkeit.kKundengruppe = :cgid LEFT JOIN teigenschaftwertpict ON teigenschaftwertpict.kEigenschaftWert = teigenschaftwert.kEigenschaftWert LEFT JOIN teigenschaftwertaufpreis ON teigenschaftwertaufpreis.kEigenschaftWert = teigenschaftwert.kEigenschaftWert AND teigenschaftwertaufpreis.kKundengruppe = :cgid WHERE teigenschaft.kArtikel = :pid AND teigenschaftsichtbarkeit.kEigenschaft IS NULL AND teigenschaftwertsichtbarkeit.kEigenschaftWert IS NULL ORDER BY teigenschaft.nSort ASC, teigenschaft.cName, teigenschaftwert.nSort ASC, teigenschaftwert.cName122μs19.03KB00000000000002aea0000000000000000default
    Params
    :pid1305
    :cgid1
  • SELECT * FROM tversandart39μs16.47KB20000000000002ac00000000000000000default
  • SELECT * FROM tversandart WHERE fVersandkostenfreiAbX > 0 AND (cVersandklassen = '-1' OR cVersandklassen RLIKE :sClasses) AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)58μs16.81KB00000000000002ac00000000000000000default
    Params
    :sClasses^([0-9 -]* )?1
    :cGroupID1
  • SELECT va.kVersandart, IF(vas.fPreis IS NOT NULL, vas.fPreis, va.fPreis) AS minPrice, va.nSort FROM tversandart va LEFT JOIN tversandartstaffel vas ON vas.kVersandart = va.kVersandart WHERE cIgnoreShippingProposal != 'Y' AND va.cLaender LIKE :ccode AND (va.cVersandklassen = '-1' OR va.cVersandklassen RLIKE :sclass) AND (va.cKundengruppen = '-1' OR FIND_IN_SET(:cgid, REPLACE(va.cKundengruppen, ';', ',')) > 0) AND va.kVersandart NOT IN ( SELECT vaza.kVersandart FROM tversandartzahlungsart vaza WHERE kZahlungsart = 6) AND ( va.kVersandberechnung = 1 OR va.kVersandberechnung = 4 OR ( va.kVersandberechnung = 2 AND vas.fBis > 0 AND :wght <= vas.fBis ) OR ( va.kVersandberechnung = 3 AND vas.fBis = ( SELECT MIN(fBis) FROM tversandartstaffel WHERE fBis > :net AND tversandartstaffel.kVersandart = va.kVersandart ) ) ) AND va.cNurAbhaengigeVersandart = 'N' ORDER BY minPrice, nSort ASC LIMIT 1199μs17.58KB00000000000002af60000000000000000default
    Params
    :ccode%DE%
    :cgid1
    :sclass^([0-9 -]* )?1
    :wght1.2
    :net299.15966387
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache32μs16.08KB00000000000002afe0000000000000000default
  • SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id38μs16.22KB10000000000002af60000000000000000default
    Params
    :keykArtikel
    :id1305
  • SELECT COUNT(kArtikel) AS cnt FROM tartikelkategorierabatt WHERE kKundengruppe = :cgid24μs16.2KB10000000000002af60000000000000000default
    Params
    :cgid1
  • 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.89KB10000000000002a3c0000000000000000default
    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 = :val38μs16.89KB10000000000002b0a0000000000000000default
    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 = :val35μs16.89KB10000000000002b0e0000000000000000default
    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 = :val35μs16.89KB10000000000002b0e0000000000000000default
    Params
    :val11
  • 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 = :val33μs16.89KB10000000000002b130000000000000000default
    Params
    :val11
  • SELECT tmerkmalwertsprache.cWert, tmerkmalwert.kMerkmal, tmerkmalwertsprache.cSeo, tmerkmalwertsprache.kSprache, tmerkmalsprache.cName AS characteristicName FROM tmerkmalwertsprache JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tmerkmalwertsprache.kMerkmalWert JOIN tmerkmalsprache ON tmerkmalsprache.kMerkmal = tmerkmalwert.kMerkmal AND tmerkmalsprache.kSprache = tmerkmalwertsprache.kSprache WHERE tmerkmalwertsprache.kMerkmalWert = :val34μs16.89KB10000000000002b170000000000000000default
    Params
    :val35
  • 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 = :section64μs16.59KB50000000000002b170000000000000000default
    Params
    :section121
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie34μs16.45KB300000000000028680000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie22μs16.41KB000000000000028680000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000028680000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB000000000000028680000000000000000default
    Params
    :kOberKategorie229
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.45KB30000000000002b340000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie20μs16.41KB00000000000002b340000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie18μs16.41KB00000000000002b340000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie19μs16.41KB00000000000002b340000000000000000default
    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 JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #join1 from JTL\Filter\Items\PriceRange::getSQLJoin JOIN (tpreis #subjoin for tpreis table JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tartikel.kArtikel = tpreis.kArtikel AND tpreis.kKundengruppe = 1 #join2 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel #join3 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) #join4 from JTL\Filter\Items\PriceRange::getSQLJoin LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = 1 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName ) AS ssMerkmal369μs16.06KB10000000000002b450000000000000000default
  • SELECT SUM(ssMerkmal.anz0) AS anz0, SUM(ssMerkmal.anz1) AS anz1, SUM(ssMerkmal.anz2) AS anz2, SUM(ssMerkmal.anz3) AS anz3, SUM(ssMerkmal.anz4) AS anz4, SUM(ssMerkmal.anz5) AS anz5 FROM (SELECT COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 300, tartikel.kArtikel, NULL)) AS anz0, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 312.5, tartikel.kArtikel, NULL)) AS anz1, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 325, tartikel.kArtikel, NULL)) AS anz2, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 337.5, tartikel.kArtikel, NULL)) AS anz3, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 350, tartikel.kArtikel, NULL)) AS anz4, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),IF(tartikel.kSteuerklasse = 3, ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 0) / 100), 2),0))) < 362.5, tartikel.kArtikel, NULL)) AS anz5 FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel AND tartikelsonderpreis.cAktiv = 'Y' AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE()) LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis AND tsonderpreise.kKundengruppe = 1 #join1 from JTL\Filter\Items\PriceRange::getOptions JOIN (tpreis #subjoin for tpreis table JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tpreis.kArtikel = tartikel.kArtikel AND tpreis.kKundengruppe = 1 #join2 from JTL\Filter\Items\PriceRange::getOptions LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tpreisdetail.fVKNetto, tartikel.cName ) AS ssMerkmal596μs16.36KB10000000000002b4c0000000000000000default
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL175μs18.39KB1000000000000282d0000000000000000default
    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.nSort158μs17KB0000000000000282d0000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?55μs16.95KB50000000000002b310000000000000000default
    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 NULL147μs18.39KB10000000000002b3a0000000000000000default
    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.nSort136μs17KB00000000000002b3a0000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.93KB40000000000002b550000000000000000default
    Params
    0108
  • SELECT * FROM tfirma LIMIT 130μs16.52KB10000000000002b530000000000000000default
  • 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 nSort68μs16.88KB00000000000002b4f0000000000000000default
    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.cName663μs18KB120000000000002b5b0000000000000000default
    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 NULL109μs16.02KB00000000000002b6b0000000000000000default
  • SELECT * FROM tfirma LIMIT 132μs16.52KB10000000000002b7d0000000000000000default
  • 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 DESC84μs16.61KB30000000000002ec40000000000000000default
    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 = :section60μs16.53KB10000000000002edf0000000000000000default
    Params
    :section125
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache27μs16.08KB00000000000002ee80000000000000000default
  • SELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC293μs40.16KB4990000000000002ef50000000000000000default
  • 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)149μs688B00000000000002ef40000000000000000default
    Params
    :interval3
  • DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)104μs128B00000000000002ef40000000000000000default
    Params
    :interval3
  • SELECT * FROM tbesucher WHERE `cSessID`=?105μs16.93KB10000000000002ef40000000000000000default
    Params
    0sibnso77dshl552fsq84s5n7m6
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv145μs16.42KB3000000000000090f0000000000000000default
    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 = '')137μs16.42KB000000000000030df0000000000000000default
    Params
    :lid1
    :cgid1
    :ptype2
    :ckykKategorie
    :cval226
  • SELECT * FROM tboxenanzeige94μs17.58KB8200000000000030d50000000000000000default
  • 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.19ms97KB3200000000000030590000000000000000default
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie103μs16.45KB300000000000030d50000000000000000default
    Params
    :kOberKategorie226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie38μs16.41KB000000000000030d50000000000000000default
    Params
    :kOberKategorie227
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie26μs16.41KB000000000000030d50000000000000000default
    Params
    :kOberKategorie228
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=:kOberKategorie25μs16.41KB000000000000030d50000000000000000default
    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 1070μs16.02KB000000000000030d50000000000000000default
  • SELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel FROM tartikel #JOIN from JTL\Filter\States\BaseCategory::getSQLJoin JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel #join from JTL\Filter\Items\Characteristic::getSQLJoin JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel #JOIN1 from JTL\Filter\Items\Search::getOptions JOIN tsuchcachetreffer ON tartikel.kArtikel = tsuchcachetreffer.kArtikel #JOIN2 from JTL\Filter\Items\Search::getOptions JOIN tsuchcache ON tsuchcache.kSuchCache = tsuchcachetreffer.kSuchCache #JOIN3 from JTL\Filter\Items\Search::getOptions JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche AND tsuchanfrage.kSprache = 1 #join from SORT by price ASC 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 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (35)) #condition from JTL\Filter\Items\Characteristic::getSQLCondition Schwarz AND #combined conditions from OR filter kMerkmalWert tartikelmerkmal.kArtikel IN (SELECT kArtikel FROM tartikelmerkmal WHERE kMerkmalWert IN (2)) 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 tpreisdetail.fVKNetto, tartikel.cName) AS ssMerkmal GROUP BY ssMerkmal.kSuchanfrage ORDER BY ssMerkmal.cSuche360μs16.09KB000000000000030d50000000000000000default
  • 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 :lmt157μs17.27KB0000000000000306b0000000000000000default
    Params
    :lmt10
    :cgid1
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin43μs16.17KB6000000000000304e0000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?49μs17.2KB100000000000030450000000000000000default
    Params
    01
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 141μs16.11KB100000000000030ac0000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?112μs17.25KB200000000000030c40000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?76μs17.22KB000000000000030d00000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort95μs16.34KB6000000000000303a0000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin111μs16.3KB400000000000030b40000000000000000default
    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.kLink198μs16.46KB400000000000030c90000000000000000default
    Params
    :plgn1
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (105,106,107,108)123μs16.14KB4000000000000306e0000000000000000default
  • 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.cName892μs17KB800000000000030ac0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink86μs16.12KB000000000000030300000000000000000default
    Params
    :kVaterLink108
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink119μs16.12KB0000000000000302b0000000000000000default
    Params
    :kVaterLink107
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink63μs16.12KB000000000000030260000000000000000default
    Params
    :kVaterLink105
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink52μs16.12KB000000000000030210000000000000000default
    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.nSort1.04ms17.34KB9000000000000307d0000000000000000default
    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.kPluginSprachvariable564μs34.06KB7800000000000030b20000000000000000default
    Params
    :pid1
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin89μs16.34KB00000000000002fd50000000000000000default
    Params
    :kPlugin1
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id134μs16.78KB40000000000002fda0000000000000000default
    Params
    :id1
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid119μs16.98KB30000000000002fe10000000000000000default
    Params
    :pidkPlugin\_1\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort94μs16.55KB30000000000002fe10000000000000000default
    Params
    :valkPlugin_1_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart66μs16.28KB20000000000002fe10000000000000000default
    Params
    :kZahlungsart73
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort82μs16.55KB30000000000002fe10000000000000000default
    Params
    :valkPlugin_1_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart59μs16.28KB20000000000002fe10000000000000000default
    Params
    :kZahlungsart74
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort84μs16.55KB30000000000002fe10000000000000000default
    Params
    :valkPlugin_1_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart58μs16.28KB20000000000002fe10000000000000000default
    Params
    :kZahlungsart75
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin58μs16.17KB6000000000000304b0000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?69μs17.2KB10000000000002fe80000000000000000default
    Params
    02
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort77μs16.27KB1000000000000301c0000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin52μs16.24KB00000000000002fac0000000000000000default
    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.kLink111μs16.4KB000000000000030af0000000000000000default
    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.nSort269μs17.19KB00000000000002fa60000000000000000default
    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.kPluginSprachvariable346μs17.13KB180000000000002f9f0000000000000000default
    Params
    :pid2
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin80μs16.34KB00000000000002f8a0000000000000000default
    Params
    :kPlugin2
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id99μs16.72KB00000000000002f8f0000000000000000default
    Params
    :id2
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid92μs16.94KB00000000000002f930000000000000000default
    Params
    :pidkPlugin\_2\_%
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin49μs16.17KB600000000000030490000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?64μs17.2KB10000000000002f990000000000000000default
    Params
    05
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 168μs16.11KB10000000000002f680000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?139μs17.25KB20000000000002f440000000000000000default
    Params
    0d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?70μs17.22KB00000000000002f330000000000000000default
    Params
    056fb166e-d504-438f-95a4-0df2a510884a
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort84μs16.34KB60000000000002f770000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin56μs16.37KB80000000000002f740000000000000000default
    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.kLink145μs16.52KB80000000000002f3a0000000000000000default
    Params
    :plgn5
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (432,433,434,435,436,437,438,439)76μs16.2KB80000000000002f590000000000000000default
  • 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.cName661μs17.13KB160000000000002f2b0000000000000000default
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink77μs16.12KB00000000000002f160000000000000000default
    Params
    :kVaterLink434
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink35μs16.12KB00000000000002f110000000000000000default
    Params
    :kVaterLink437
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB00000000000002f0c0000000000000000default
    Params
    :kVaterLink432
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB00000000000002f070000000000000000default
    Params
    :kVaterLink433
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002f020000000000000000default
    Params
    :kVaterLink439
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002efd0000000000000000default
    Params
    :kVaterLink435
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000002ef80000000000000000default
    Params
    :kVaterLink436
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000030ee0000000000000000default
    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.nSort175μs17.19KB00000000000002f560000000000000000default
    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.kPluginSprachvariable172μs16.84KB20000000000002f360000000000000000default
    Params
    :pid5
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin45μs16.34KB00000000000002f1a0000000000000000default
    Params
    :kPlugin5
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id60μs16.72KB00000000000002f200000000000000000default
    Params
    :id5
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid51μs16.94KB00000000000002f240000000000000000default
    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 NULL159μs18.39KB100000000000031060000000000000000default
    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.nSort144μs17KB000000000000031060000000000000000default
    Params
    :cid226
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?50μs16.91KB300000000000031100000000000000000default
    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 NULL141μs18.39KB100000000000031110000000000000000default
    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.nSort134μs17KB000000000000031110000000000000000default
    Params
    :cid110
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.95KB5000000000000311a0000000000000000default
    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 NULL134μs18.39KB1000000000000311b0000000000000000default
    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.nSort131μs17KB0000000000000311b0000000000000000default
    Params
    :cid108
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?46μs16.93KB400000000000031240000000000000000default
    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:1 [ "mf" => array:2 [ 0 => 2 1 => 35 ] ]
    $_POST
    []
    $_SESSION
    array:38 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#2695 +k...
    $_COOKIE
    array:1 [ "JTLSHOP" => "sibnso77dshl552fsq84s5n7m6" ]
    $_SERVER
    array:61 [ "USER" => "jtlbalter" "HOME" => "/var/www/vhosts/k08.de" "SCRIPT_NAME" => "/index.p...
      TracedStatement.php:39
      {#12579 +"level": 8192 +"message": "Creation of dynamic property DebugBar\DataCollector\PDO\Trac...
      TraceablePDOStatement.php:86
      {#12576 +"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
      {#8096 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      Bootstrap.php:144
      {#8366 +"level": 2 +"message": "Undefined array key "Kupon"" +"file": "/var/www/vhosts/k08.de/...
      ProductFilter.php:1662
      {#10345 +"level": 2 +"message": "Attempt to read property "kKategorie" on null" +"file": "/var...
      smarty_internal_debug.php:146
      {#12906 +"level": 2 +"message": "Undefined array key "start_time"" +"file": "/var/www/vhosts/k...
      smarty_internal_debug.php:73
      {#12869 +"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 {#7996 -parentID: 108 -sort: 0 -names: a...
      submenu_items
      array:4 [ 0 => JTL\Catalog\Category\Kategorie {#8019 -parentID: 0 -sort: 0 -names: arr...
      categories_count
      4
      activated_categories_count
      6
      homeurl
      "https://www.k08.de/Start"
      coupon
      0.0
      currentCoupon
      null
      cart
      JTL\Cart\Cart {#2695 +kWarenkorb: null +kKunde: null +kLieferadresse: null +kZahlungsInfo: 0...
      FavourableShipping
      null
      oNaviSeite_arr
      array:2 [ "vor" => JTL\Filter\Pagination\Item {#10272 -page: 0 -url: null -isActive: f...
      filterPagination
      JTL\Filter\Pagination\Pagination {#10271 -pages: [] -prev: JTL\Filter\Pagination\Item {#10283 ...
      oBestseller_arr
      []
      KategorieInhalt
      null
      NaviFilter
      JTL\Filter\ProductFilter {#8040 -category: JTL\Filter\States\BaseCategory {#8035 #icon: null ...
      priceRangeMax
      362.5
      oErweiterteDarstellung
      {#2317 +"cURL_arr": array:2 [ 1 => "https://www.k08.de/HD-Tuerstationen__2-Familienhaus__Schwa...
      Suchergebnisse
      JTL\Filter\SearchResults {#10355 -products: Illuminate\Support\Collection {#10783 #items: arra...
      oNavigationsinfo
      JTL\Filter\Metadata {#8038 -conf: array:32 [ "global" => array:53 [ "systemlog_flag" => ...
      priceRange
      null
      nMaxAnzahlArtikel
      0
      linkgroups
      JTL\Link\LinkGroupCollection {#8360 #items: array:13 [ 0 => JTL\Link\LinkGroup {#9916 -n...
      manufacturers
      array:2 [ 2 => JTL\Catalog\Hersteller {#11119 -kHersteller: 2 -names: array:6 [ 1 =>...
      oUnterKategorien_arr
      array:3 [ 228 => JTL\Catalog\Category\MenuItem {#2423 -id: 228 -parentID: 226 -languag...
      session_name
      "JTLSHOP"
      session_id
      "sibnso77dshl552fsq84s5n7m6"
      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 {#11147 #items: array:25 [ 5 => JTL\Link\Link {#9941 -data...
      bAjaxRequest
      false
      jtl_token
      "<input type="hidden" class="jtl_token" name="jtl_token" value="703a769c0dc97775a0a98796eabeedba5a22...
      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 {#11134 +cName: "Balter GmbH" +cUnternehmer: "" +cStrasse: "Elisabeth Selbert Str. 1...
      showLoginCaptcha
      false
      AktuelleKategorie
      JTL\Catalog\Category\Kategorie {#10291 -parentID: 110 -sort: 0 -names: array:1 [ 1 => "HD ...
      cSessionID
      "sibnso77dshl552fsq84s5n7m6"
      opc
      JTL\OPC\Service {#11121 #adminName: "" #db: JTL\OPC\DB {#11148 #mapping: [] #shopDB: JTL...
      opcPageService
      JTL\OPC\PageService {#11965 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#11121 #a...
      wishlists
      Illuminate\Support\Collection {#11127 #items: [] #escapeWhenCastingToString: false }
      shippingCountry
      "DE"
      countries
      Illuminate\Support\Collection {#9536 #items: array:236 [ 60 => JTL\Country\Country {#8701 ...
      Link
      JTL\Link\Link {#11035 -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 {#11971 #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 {#12353 #id: 1 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plugi...
      oPlugin_jtl_theme_editor
      JTL\Plugin\Plugin {#12309 #id: 2 #pluginID: "jtl_theme_editor" #state: 2 #meta: JTL\Plugin\D...
      oPlugin_balter_custom
      JTL\Plugin\Plugin {#12158 #id: 5 #pluginID: "balter_custom" #state: 2 #meta: JTL\Plugin\Data...
      parentBlockParams
      array:19 [ "class" => scc\ComponentProperty {#12985 -defaultValue: null -isRequired: false...
      pbp
      array:19 [ "class" => scc\ComponentProperty {#12985 -defaultValue: null -isRequired: false...
      bCookieErlaubt
      true
      Brotnavi
      array:4 [ 0 => JTL\Catalog\NavigationEntry {#13047 -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 {#7915 #items: array:2 [ 0 => JTL\Consent\Item {#7914 -id:...
      nZeitGebraucht
      0.37056589126587
      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"