SELECT * FROM tsprache31μs16.22KB20000000000000b790000000000000000default
SELECT * FROM tkundengruppe WHERE`cStandard`=?27μs16.7KB10000000000000b7d0000000000000000default
Params
0
Y
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section1.35ms17.39KB530000000000000b840000000000000000default
Params
:section
1
SELECT * FROM tkundengruppenattribut WHERE`kKundengruppe`=:kKundengruppe26μs16.25KB00000000000000b390000000000000000default
Params
:kKundengruppe
1
SELECT tpluginhook.nHook, tplugin.kPlugin, tplugin.nVersion, tpluginhook.cDateiname, tpluginhook.nPriority
FROM tplugin
JOIN tpluginhook
ON tpluginhook.kPlugin = tplugin.kPlugin
WHERE tplugin.nStatus = :state
ORDERBY tpluginhook.nPriority, tplugin.kPlugin82μs16.69KB120000000000000b4f0000000000000000default
Params
:state
2
SELECT * FROM tsprache25μs16.22KB20000000000000aec0000000000000000default
SELECT * FROM twaehrung24μs16.23KB10000000000000ae80000000000000000default
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDERBY kSprache25μs16.08KB00000000000000a8b0000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section424μs16.95KB27000000000000090c0000000000000000default
Params
:section
7
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFTJOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDERBY tsprache.kSprache ASC54μs16.22KB200000000000008f00000000000000000default
SELECT *
FROM tglobals
WHERE dLetzteAenderung > :ts27μs16.2KB000000000000008f30000000000000000default
Params
:ts
2025-05-14 09:40:31
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFTJOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDERBY tsprache.kSprache ASC37μs16.22KB20000000000000baf0000000000000000default
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE`nAktiv`=:nAktiv35μs16.42KB30000000000000bb00000000000000000default
Params
:nAktiv
1
SELECT kPlugin AS id, bExtension AS modern
FROM tplugin
WHERE nStatus = :state
AND bBootstrap = 1ORDERBY nPrio ASC35μs16.31KB300000000000008fd0000000000000000default
Params
:state
2
SELECT * FROM tplugin WHERE`kPlugin`=?43μs17.2KB100000000000009020000000000000000default
Params
0
1
SELECT tstoreauth.auth_code, tstoreauth.access_token,
tadminlogin.cPass AS hash, tstoreauth.verified
FROM tstoreauth
INNERJOIN tadminlogin
ON tadminlogin.kAdminlogin = tstoreauth.owner
LIMIT 141μs16.11KB100000000000017000000000000000000default
SELECT * FROM licenses
WHERE returnCode = 200ORDERBY id DESC
LIMIT 132μs16.11KB100000000000017040000000000000000default
SELECT * FROM tplugin WHERE`exsID`=?43μs17.25KB200000000000017280000000000000000default
Params
0
d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE`exsID`=?28μs17.22KB000000000000017390000000000000000default
Params
0
56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort42μs16.34KB600000000000016f20000000000000000default
Params
:kPlugin
1
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin24μs16.3KB400000000000017100000000000000000default
Params
:kPlugin
1
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink83μs16.46KB400000000000017300000000000000000default
Params
:plgn
1
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (105,106,107,108)37μs16.14KB400000000000017030000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (105,106,107,108)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName537μs17KB800000000000017040000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink52μs16.12KB0000000000000173f0000000000000000default
Params
:kVaterLink
108
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink26μs16.12KB000000000000017440000000000000000default
Params
:kVaterLink
107
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink22μs16.12KB000000000000017490000000000000000default
Params
:kVaterLink
105
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB0000000000000174e0000000000000000default
Params
:kVaterLink
106
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort505μs17.34KB9000000000000172f0000000000000000default
Params
:pid
1
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable327μs34.06KB78000000000000170d0000000000000000default
Params
:pid
1
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin52μs16.34KB0000000000000179a0000000000000000default
Params
:kPlugin
1
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id72μs16.78KB400000000000017950000000000000000default
Params
:id
1
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid130μs16.98KB3000000000000178e0000000000000000default
Params
:pid
kPlugin\_1\_%
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort66μs16.55KB3000000000000178e0000000000000000default
Params
:val
kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart48μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart
73
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort46μs16.55KB3000000000000178e0000000000000000default
Params
:val
kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart30μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart
74
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort39μs16.55KB3000000000000178e0000000000000000default
Params
:val
kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart26μs16.28KB2000000000000178e0000000000000000default
Params
:kZahlungsart
75
SELECT * FROM tplugin WHERE`kPlugin`=?51μs17.2KB100000000000017c50000000000000000default
Params
0
2
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort44μs16.27KB100000000000018640000000000000000default
Params
:kPlugin
2
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin25μs16.24KB0000000000000186b0000000000000000default
Params
:kPlugin
2
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink69μs16.4KB0000000000000186a0000000000000000default
Params
:plgn
2
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort183μs17.19KB000000000000018710000000000000000default
Params
:pid
2
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable215μs17.13KB1800000000000018780000000000000000default
Params
:pid
2
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin46μs16.34KB0000000000000188d0000000000000000default
Params
:kPlugin
2
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id59μs16.72KB000000000000018880000000000000000default
Params
:id
2
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid52μs16.94KB000000000000018840000000000000000default
Params
:pid
kPlugin\_2\_%
SELECT cSektion AS sec, cWert AS val, cName AS name
FROM ttemplateeinstellungen
WHERE cTemplate = (SELECT cTemplate FROM ttemplate WHERE eTyp = 'standard')113μs17.08KB63000000000000187d0000000000000000default
SELECT * FROM tplugin WHERE`kPlugin`=?35μs17.2KB1000000000000187e0000000000000000default
Params
0
5
SELECT * FROM licenses
WHERE returnCode = 200ORDERBY id DESC
LIMIT 134μs16.11KB100000000000018be0000000000000000default
SELECT * FROM tplugin WHERE`exsID`=?33μs17.25KB2000000000000189a0000000000000000default
Params
0
d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE`exsID`=?26μs17.22KB000000000000018e60000000000000000default
Params
0
56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort37μs16.34KB600000000000018cd0000000000000000default
Params
:kPlugin
5
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin23μs16.37KB800000000000018ca0000000000000000default
Params
:kPlugin
5
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink81μs16.52KB800000000000018df0000000000000000default
Params
:plgn
5
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)37μs16.2KB800000000000018af0000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (432,433,434,435,436,437,438,439)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName554μs17.13KB1600000000000018ee0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink44μs16.12KB000000000000019030000000000000000default
Params
:kVaterLink
434
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.12KB000000000000019080000000000000000default
Params
:kVaterLink
437
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink22μs16.12KB0000000000000190d0000000000000000default
Params
:kVaterLink
432
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000019120000000000000000default
Params
:kVaterLink
433
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000019170000000000000000default
Params
:kVaterLink
439
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB0000000000000191c0000000000000000default
Params
:kVaterLink
435
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000019210000000000000000default
Params
:kVaterLink
436
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000019260000000000000000default
Params
:kVaterLink
438
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort158μs17.19KB000000000000018ac0000000000000000default
Params
:pid
5
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable172μs16.84KB200000000000018e30000000000000000default
Params
:pid
5
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin44μs16.34KB000000000000018ff0000000000000000default
Params
:kPlugin
5
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id56μs16.72KB000000000000018f90000000000000000default
Params
:id
5
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid50μs16.94KB000000000000018f50000000000000000default
Params
:pid
kPlugin\_5\_%
SELECT * FROM ttemplate WHERE`eTyp`=?30μs16.85KB1000000000000195c0000000000000000default
Params
0
standard
SELECT * FROM ttemplateeinstellungen WHERE`cTemplate`=:cTemplate91μs17.2KB6300000000000019620000000000000000default
Params
:cTemplate
BALTER
SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE`nStatus`=:nStatus ORDERBY nPrio39μs16.3KB300000000000019a10000000000000000default
Params
:nStatus
2
SELECT * FROM tconsent WHERE`active`=:active31μs16.27KB20000000000001ee40000000000000000default
Params
:active
1
SELECT * FROM tconsentlocalization WHERE`consentID`=:consentID29μs16.31KB20000000000001efe0000000000000000default
Params
:consentID
1
SELECT * FROM tsprache20μs16.22KB20000000000001efe0000000000000000default
SELECT * FROM tconsentlocalization WHERE`consentID`=:consentID23μs16.31KB20000000000001f090000000000000000default
Params
:consentID
2
SELECT * FROM tsprache17μs16.22KB20000000000001f090000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section59μs16.56KB30000000000001f090000000000000000default
Params
:section
129
SELECT tplugineinstellungen.*, tplugineinstellungenconf.cConf
FROM tplugin
JOIN tplugineinstellungen
ON tplugineinstellungen.kPlugin = tplugin.kPlugin
LEFTJOIN tplugineinstellungenconf
ON tplugineinstellungenconf.kPlugin = tplugin.kPlugin
AND tplugineinstellungen.cName = tplugineinstellungenconf.cWertName
WHERE tplugin.kPlugin = :pid356μs17.84KB720000000000001f190000000000000000default
Params
:pid
1
SELECT tkategorie.kKategorie, tkategorie.cSeo, tkategorie.cName, tkategorie.kOberKategorie, tkategoriepict.kKategoriePict FROM tkategorie
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
WHERE tkategorie.kOberKategorie = 047μs16.19KB40000000000001f510000000000000000default
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1LEFTJOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFTJOIN tseo ON tseo.cKey = 'kKategorie'AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFTJOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie ISNULL151μs18.39KB10000000000001f390000000000000000default
Params
:kid
108
:cgid
1
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section562μs17.02KB320000000000001f470000000000000000default
SELECT * FROM tkategorie WHERE`kOberKategorie`=?35μs16.87KB00000000000001f770000000000000000default
Params
0
220
SELECT id_category FROM submenusettings
WHERE id = 123μs16.04KB10000000000001f3a0000000000000000default
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1LEFTJOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFTJOIN tseo ON tseo.cKey = 'kKategorie'AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFTJOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie ISNULL127μs18.39KB10000000000001f310000000000000000default
Params
:kid
109
:cgid
1
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section3.53ms18.02KB910000000000001f7c0000000000000000default
Params
:section
9
SELECT tbranding.kBranding AS id, tbranding.cBildKategorie AS type,
tbrandingeinstellung.cPosition AS position, tbrandingeinstellung.cBrandingBild AS path,
tbrandingeinstellung.dTransparenz AS transparency, tbrandingeinstellung.dGroesse ASsizeFROM tbrandingeinstellung
INNERJOIN tbranding
ON tbrandingeinstellung.kBranding = tbranding.kBranding
WHERE tbrandingeinstellung.nAktiv = 145μs16.16KB00000000000001fd90000000000000000default
SELECT * FROM tkategorie WHERE`kOberKategorie`=?35μs16.87KB00000000000001fa10000000000000000default
Params
0
116
SELECT * FROM tland114μs20.19KB2360000000000001f970000000000000000default
SELECT cLaender FROM tversandart25μs16.05KB20000000000001f970000000000000000default
SELECTDISTINCT cLandIso FROM tstaat62μs16.52KB290000000000001f970000000000000000default
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName71μs16.56KB2400000000000020cb0000000000000000default
Params
:cLandIso
AR
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName36μs16.34KB900000000000020d80000000000000000default
Params
:cLandIso
AT
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName36μs16.34KB1000000000000020b70000000000000000default
Params
:cLandIso
BE
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName54μs16.69KB2800000000000020fa0000000000000000default
Params
:cLandIso
BG
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName55μs16.63KB2700000000000021160000000000000000default
Params
:cLandIso
BR
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName40μs16.41KB13000000000000213b0000000000000000default
Params
:cLandIso
CA
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName53μs16.63KB26000000000000210a0000000000000000default
Params
:cLandIso
CH
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName67μs16.81KB3400000000000021760000000000000000default
Params
:cLandIso
CN
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName28μs16.28KB6000000000000219f0000000000000000default
Params
:cLandIso
CY
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName38μs16.44KB1400000000000021970000000000000000default
Params
:cLandIso
CZ
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName40μs16.44KB1600000000000021710000000000000000default
Params
:cLandIso
DE
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName28μs16.27KB500000000000021d80000000000000000default
Params
:cLandIso
DK
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName39μs16.44KB15000000000000216d0000000000000000default
Params
:cLandIso
EE
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName82μs17.06KB5000000000000021f70000000000000000default
Params
:cLandIso
ES
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName44μs16.5KB1900000000000022320000000000000000default
Params
:cLandIso
FI
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName162μs18.19KB11400000000000022210000000000000000default
Params
:cLandIso
FR
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName28μs16.25KB400000000000022c40000000000000000default
Params
:cLandIso
GB
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName36μs16.41KB1300000000000022b20000000000000000default
Params
:cLandIso
GR
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName48μs16.56KB2100000000000022aa0000000000000000default
Params
:cLandIso
HR
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName65μs16.81KB3600000000000022880000000000000000default
Params
:cLandIso
IN
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName148μs17.94KB11000000000000022290000000000000000default
Params
:cLandIso
IT
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName77μs16.94KB4700000000000023a90000000000000000default
Params
:cLandIso
JP
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName34μs16.34KB10000000000000238a0000000000000000default
Params
:cLandIso
LT
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName173μs18.19KB11900000000000023950000000000000000default
Params
:cLandIso
LV
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName59μs16.69KB3200000000000024680000000000000000default
Params
:cLandIso
MX
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName36μs16.38KB12000000000000244e0000000000000000default
Params
:cLandIso
NL
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName72μs16.94KB4200000000000021ee0000000000000000default
Params
:cLandIso
RO
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName114μs17.44KB7800000000000024f70000000000000000default
Params
:cLandIso
TH
SELECT * FROM tstaat WHERE`cLandIso`=:cLandIso ORDERBY cName98μs17.19KB63000000000000256e0000000000000000default
Params
:cLandIso
US
SELECT * FROM tfirma LIMIT 130μs16.52KB10000000000001f9a0000000000000000default
SELECT * FROM tversandart
WHERE cNurAbhaengigeVersandart = :depOnly
AND cLaender LIKE :iso
AND (cVersandklassen = '-1'OR cVersandklassen RLIKE :sClasses)
AND (cKundengruppen = '-1'OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)
ORDERBY nSort75μs16.88KB00000000000001f9d0000000000000000default
Params
:iso
%DE%
:cGroupID
1
:sClasses
^([0-9 -]* )?
:depOnly
Y
SELECT g.*, l.cName AS localizedName, l.cISOSprache, g.cTemplatename AS template,
g.cName AS groupName, IFNULL(tsprache.kSprache, 0) AS kSprache
FROM tlinkgruppe AS g
LEFTJOIN tlinkgruppesprache AS l
ON g.kLinkgruppe = l.kLinkgruppe
LEFTJOIN tsprache
ON tsprache.cISO = l.cISOSprache
WHERE g.kLinkgruppe > 0AND l.kLinkgruppe > 0102μs16.59KB2200000000000020a70000000000000000default
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName52μs16.27KB000000000000020880000000000000000default
Params
:lgid
1
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName52μs16.37KB600000000000020830000000000000000default
Params
:lgid
4
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (440,442,68,71,443,444)32μs16.17KB600000000000020840000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (68,71,440,442,443,444)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName518μs17.06KB1200000000000020730000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink48μs16.12KB000000000000020620000000000000000default
Params
:kVaterLink
440
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.12KB0000000000000205d0000000000000000default
Params
:kVaterLink
442
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000020580000000000000000default
Params
:kVaterLink
68
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020530000000000000000default
Params
:kVaterLink
71
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000204e0000000000000000default
Params
:kVaterLink
443
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020490000000000000000default
Params
:kVaterLink
444
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName67μs16.37KB600000000000020680000000000000000default
Params
:lgid
5
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (69,67,59,49,73,74)36μs16.17KB600000000000020670000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (49,59,67,69,73,74)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName496μs17.06KB12000000000000207a0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink43μs16.12KB0000000000000203b0000000000000000default
Params
:kVaterLink
69
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.12KB000000000000020360000000000000000default
Params
:kVaterLink
67
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000020310000000000000000default
Params
:kVaterLink
59
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000202c0000000000000000default
Params
:kVaterLink
49
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020270000000000000000default
Params
:kVaterLink
73
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000020220000000000000000default
Params
:kVaterLink
74
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName95μs16.71KB2700000000000020410000000000000000default
Params
:lgid
8
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (77,76,79,78,81,75,80,85,86,434,437,83,432,433,108,107,105,106,439,435,436,438,84,3,63,4,72)55μs16.52KB2700000000000020400000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN 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)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName912μs33.75KB540000000000001ffb0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink48μs16.12KB000000000000025400000000000000000default
Params
:kVaterLink
77
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.12KB000000000000025450000000000000000default
Params
:kVaterLink
76
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink22μs16.12KB0000000000000254a0000000000000000default
Params
:kVaterLink
79
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000254f0000000000000000default
Params
:kVaterLink
78
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000025540000000000000000default
Params
:kVaterLink
81
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000025590000000000000000default
Params
:kVaterLink
75
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000255e0000000000000000default
Params
:kVaterLink
80
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000025630000000000000000default
Params
:kVaterLink
85
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000025680000000000000000default
Params
:kVaterLink
86
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB0000000000000260d0000000000000000default
Params
:kVaterLink
434
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026120000000000000000default
Params
:kVaterLink
437
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026170000000000000000default
Params
:kVaterLink
83
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB0000000000000261c0000000000000000default
Params
:kVaterLink
432
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026210000000000000000default
Params
:kVaterLink
433
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026260000000000000000default
Params
:kVaterLink
108
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000262b0000000000000000default
Params
:kVaterLink
107
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026300000000000000000default
Params
:kVaterLink
105
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026350000000000000000default
Params
:kVaterLink
106
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000263a0000000000000000default
Params
:kVaterLink
439
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000263f0000000000000000default
Params
:kVaterLink
435
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000026440000000000000000default
Params
:kVaterLink
436
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026490000000000000000default
Params
:kVaterLink
438
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000264e0000000000000000default
Params
:kVaterLink
84
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.1KB000000000000026530000000000000000default
Params
:kVaterLink
3
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026580000000000000000default
Params
:kVaterLink
63
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.1KB0000000000000265d0000000000000000default
Params
:kVaterLink
4
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink32μs16.12KB000000000000026620000000000000000default
Params
:kVaterLink
72
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName59μs16.37KB60000000000001f920000000000000000default
Params
:lgid
9
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (103,104,420,422,64,61)31μs16.17KB60000000000001f930000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (61,64,103,104,420,422)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName504μs17.03KB100000000000001f820000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink55μs16.12KB00000000000001fe50000000000000000default
Params
:kVaterLink
103
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.12KB00000000000001fea0000000000000000default
Params
:kVaterLink
104
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink26μs16.12KB00000000000001fef0000000000000000default
Params
:kVaterLink
420
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB00000000000001ff40000000000000000default
Params
:kVaterLink
422
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020160000000000000000default
Params
:kVaterLink
64
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020000000000000000000default
Params
:kVaterLink
61
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName63μs16.35KB50000000000001fdf0000000000000000default
Params
:lgid
10
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (109,112,111,110,113)31μs16.16KB50000000000001fe00000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (109,110,111,112,113)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName471μs17.03KB100000000000001f890000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink54μs16.12KB0000000000000200c0000000000000000default
Params
:kVaterLink
109
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink28μs16.12KB000000000000020110000000000000000default
Params
:kVaterLink
112
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000020400000000000000000default
Params
:kVaterLink
111
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000201b0000000000000000default
Params
:kVaterLink
110
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000207a0000000000000000default
Params
:kVaterLink
113
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName62μs16.32KB300000000000020060000000000000000default
Params
:lgid
11
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (446,448,447)28μs16.13KB300000000000020070000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (446,447,448)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName413μs16.97KB60000000000001f860000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink43μs16.12KB000000000000020670000000000000000default
Params
:kVaterLink
446
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink24μs16.12KB000000000000020840000000000000000default
Params
:kVaterLink
448
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000204a0000000000000000default
Params
:kVaterLink
447
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName58μs16.32KB30000000000001f310000000000000000default
Params
:lgid
12
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (115,50,66)27μs16.13KB30000000000001f7c0000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (50,66,115)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName402μs16.97KB600000000000020730000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink46μs16.12KB000000000000026710000000000000000default
Params
:kVaterLink
115
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink26μs16.12KB000000000000026760000000000000000default
Params
:kVaterLink
50
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB0000000000000267b0000000000000000default
Params
:kVaterLink
66
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName62μs16.34KB4000000000000266b0000000000000000default
Params
:lgid
13
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (116,118,119,117)29μs16.14KB4000000000000266c0000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (116,117,118,119)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName422μs17KB800000000000026800000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink41μs16.12KB0000000000000268d0000000000000000default
Params
:kVaterLink
116
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink24μs16.12KB000000000000026920000000000000000default
Params
:kVaterLink
118
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026970000000000000000default
Params
:kVaterLink
119
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000269c0000000000000000default
Params
:kVaterLink
117
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDERBY tlink.nSort, tlink.cName52μs16.29KB100000000000026870000000000000000default
Params
:lgid
14
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (120)21μs16.09KB100000000000026880000000000000000default
SELECT tlink.*, loc.cISOSprache,
tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle,
loc.cContent AS content, loc.cSeo AS linkURL,
loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle,
tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl,
tspezialseite.cDateiname,
tplugin.nStatus AS pluginState,
pld.cDatei AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (120)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName180μs16.91KB2000000000000267f0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink33μs16.12KB000000000000026800000000000000000default
Params
:kVaterLink
120
SELECT tlink.*, tlinksprache.cISOSprache,
tlink.cName AS displayName, tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle,
tsprache.kSprache, tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content,
tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords,
tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID,
tseo.cSeo AS localizedUrl, tspezialseite.cDateiname,
GROUP_CONCAT(tlinkgroupassociations.linkGroupID) AS linkGroups, 2AS pluginState
FROM tlinksprache
JOIN tlink
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
JOIN tlinkgroupassociations
ON tlinkgroupassociations.linkID = tlinksprache.kLink
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = tlink.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
WHERE tlink.kLink = tlinksprache.kLink
AND tlink.nLinkart >= 5GROUPBY tlink.kLink, tseo.kSprache752μs34KB74000000000000208f0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink48μs16.1KB000000000000026d50000000000000000default
Params
:kVaterLink
3
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink25μs16.1KB000000000000026da0000000000000000default
Params
:kVaterLink
4
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB000000000000026df0000000000000000default
Params
:kVaterLink
49
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026e40000000000000000default
Params
:kVaterLink
50
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026e90000000000000000default
Params
:kVaterLink
59
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026ee0000000000000000default
Params
:kVaterLink
61
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026f30000000000000000default
Params
:kVaterLink
63
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026f80000000000000000default
Params
:kVaterLink
64
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026fd0000000000000000default
Params
:kVaterLink
66
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink22μs16.12KB000000000000027020000000000000000default
Params
:kVaterLink
67
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027070000000000000000default
Params
:kVaterLink
69
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000270c0000000000000000default
Params
:kVaterLink
72
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027110000000000000000default
Params
:kVaterLink
73
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027160000000000000000default
Params
:kVaterLink
74
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000271b0000000000000000default
Params
:kVaterLink
75
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027200000000000000000default
Params
:kVaterLink
76
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027250000000000000000default
Params
:kVaterLink
77
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000272a0000000000000000default
Params
:kVaterLink
78
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000272f0000000000000000default
Params
:kVaterLink
79
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027340000000000000000default
Params
:kVaterLink
80
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027390000000000000000default
Params
:kVaterLink
81
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000273e0000000000000000default
Params
:kVaterLink
83
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027430000000000000000default
Params
:kVaterLink
84
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027480000000000000000default
Params
:kVaterLink
85
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink32μs16.12KB0000000000000274d0000000000000000default
Params
:kVaterLink
86
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027520000000000000000default
Params
:kVaterLink
105
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027570000000000000000default
Params
:kVaterLink
106
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000275c0000000000000000default
Params
:kVaterLink
107
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027610000000000000000default
Params
:kVaterLink
108
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027660000000000000000default
Params
:kVaterLink
432
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000276b0000000000000000default
Params
:kVaterLink
433
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027700000000000000000default
Params
:kVaterLink
434
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027750000000000000000default
Params
:kVaterLink
435
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000277a0000000000000000default
Params
:kVaterLink
436
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB0000000000000277f0000000000000000default
Params
:kVaterLink
437
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027840000000000000000default
Params
:kVaterLink
438
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027890000000000000000default
Params
:kVaterLink
439
SELECT tspezialseite.kSpezialseite, tspezialseite.cName AS baseName, tspezialseite.cDateiname,
tspezialseite.nLinkart, tlink.kLink, tlink.cName AS displayName, tlink.reference,
tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle,
tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content,
tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords,
tlinksprache.cMetaTitle AS metaTitle, tlink.cKundengruppen, tseo.cSeo AS localizedUrl,
tsprache.cISO AS cISOSprache, tsprache.kSprache AS languageID, tlink.kVaterLink,
tspezialseite.kPlugin, tlink.cName, tlink.cNoFollow, tlink.cSichtbarNachLogin,
tlink.cDruckButton, tlink.nSort, tlink.bIsActive, tlink.bIsFluid, tlink.bSSL,
GROUP_CONCAT(tlinkgroupassociations.linkGroupID) AS linkGroups, 2AS pluginState
FROM tspezialseite
LEFTJOIN tlink
ON tlink.nLinkart = tspezialseite.nLinkart
LEFTJOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
JOIN tlinkgroupassociations
ON tlinkgroupassociations.linkID = tlinksprache.kLink
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = tlink.kLink
AND tseo.kSprache = tsprache.kSprache
WHERE cDateiname ISNOTNULLAND cDateiname != ''GROUPBY tlink.kLink, tsprache.kSprache580μs17.23KB2600000000000026d00000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink49μs16.1KB000000000000026af0000000000000000default
Params
:kVaterLink
4
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink24μs16.12KB000000000000026aa0000000000000000default
Params
:kVaterLink
61
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000026a50000000000000000default
Params
:kVaterLink
64
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000267f0000000000000000default
Params
:kVaterLink
66
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000268a0000000000000000default
Params
:kVaterLink
75
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020a10000000000000000default
Params
:kVaterLink
76
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000209f0000000000000000default
Params
:kVaterLink
77
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000020930000000000000000default
Params
:kVaterLink
78
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB0000000000000209a0000000000000000default
Params
:kVaterLink
79
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB0000000000000278f0000000000000000default
Params
:kVaterLink
80
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink19μs16.12KB000000000000027940000000000000000default
Params
:kVaterLink
81
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB000000000000027990000000000000000default
Params
:kVaterLink
85
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB0000000000000279e0000000000000000default
Params
:kVaterLink
86
SELECT tlink.*, tlinksprache.cISOSprache,
tlink.cName AS displayName, tlinksprache.cName AS localizedName,
tlinksprache.cTitle AS localizedTitle, tsprache.kSprache,
tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content,
tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords,
tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID,
tseo.cSeo AS localizedUrl, ''AS cDateiname, ''AS linkGroups, 2AS pluginState
FROM tlinksprache
JOIN tlink
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = tlink.kLink
AND tseo.kSprache = tsprache.kSprache
WHERE tlink.kLink NOTIN (SELECT linkID FROM tlinkgroupassociations)
GROUPBY tlink.kLink, tsprache.kSprache291μs16.75KB000000000000026b40000000000000000default
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section88μs16.56KB300000000000027a80000000000000000default
Params
:section
128
SELECT *
FROM tseo
WHERE cSeo = :slg39μs16.23KB1000000000000280a0000000000000000default
Params
:slg
Ueberwachungsmonitore
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 = 1LEFTJOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFTJOIN tseo ON tseo.cKey = 'kKategorie'AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFTJOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie ISNULL150μs18.39KB1000000000000280f0000000000000000default
SELECT * FROM tkategorie WHERE`kOberKategorie`=?40μs16.87KB000000000000028b90000000000000000default
Params
0
173
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section79μs16.59KB500000000000028c30000000000000000default
Params
:section
121
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1LEFTJOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFTJOIN tseo ON tseo.cKey = 'kKategorie'AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFTJOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie ISNULL131μs18.39KB1000000000000281b0000000000000000default
SELECT * FROM tkategorie WHERE`kOberKategorie`=?46μs16.99KB800000000000028e10000000000000000default
Params
0
123
SELECT * FROM tfirma LIMIT 132μs16.52KB100000000000028dc0000000000000000default
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)
ORDERBY nSort73μs16.88KB000000000000028e40000000000000000default
Params
:iso
%DE%
:cGroupID
1
:sClasses
^([0-9 -]* )?
:depOnly
Y
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFTJOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFTJOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = :skey
AND tseo.kSprache = therstellersprache.kSprache
WHEREEXISTS (
SELECT1FROM tartikel
WHERE tartikel.kHersteller = thersteller.kHersteller
ANDNOTEXISTS (
SELECT1FROM tartikelsichtbarkeit
WHERE tartikelsichtbarkeit.kArtikel = tartikel.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
)
)
GROUPBY thersteller.kHersteller, therstellersprache.kSprache
ORDERBY thersteller.nSortNr, thersteller.cName648μs18KB1200000000000028ea0000000000000000default
Params
:skey
kHersteller
:cgid
1
SELECT child.kKategorie
FROM tkategorie
LEFTJOIN tkategorie parent
ON tkategorie.kOberKategorie = parent.kKategorie
LEFTJOIN tkategorie child
ON tkategorie.lft <= child.lft
AND tkategorie.rght >= child.rght
WHERE tkategorie.kOberKategorie > 0AND parent.kKategorie ISNULL105μs16.02KB000000000000028fa0000000000000000default
SELECT * FROM tfirma LIMIT 131μs16.52KB1000000000000290c0000000000000000default
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
ORDERBY res.priority DESC80μs16.61KB30000000000002c530000000000000000default
Params
:state
2
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFTJOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section61μs16.53KB10000000000002c6e0000000000000000default
Params
:section
125
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDERBY kSprache26μs16.08KB00000000000002c770000000000000000default
SELECT * FROM tbesucherbot ORDERBY kBesucherBot DESC240μs40.16KB4990000000000002c840000000000000000default
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 :intervalHOUR)91μs688B00000000000002c830000000000000000default
Params
:interval
3
DELETEFROM tbesucher
WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :intervalHOUR)54μs128B00000000000002c830000000000000000default
Params
:interval
3
SELECT * FROM tbesucher WHERE`cSessID`=?52μs16.91KB00000000000002c830000000000000000default
Params
0
suui01790ej1kfvfvtmpj6sqq5
SELECT * FROM tbesucher WHERE`cID`=?67μs16.93KB10000000000002c830000000000000000default
Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
8
/Bedienelemente::BALTER?availability=1
9
Sonstige
10
/Ueberwachungsmonitore?Sortierung=100
11
0
12
2025-05-14 09:42:00
13
2025-05-14 09:41:51
14
149403
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE`nAktiv`=:nAktiv57μs16.38KB3000000000000090f0000000000000000default
Params
:nAktiv
1
SELECT cClass, kInitial FROM textensionpoint
WHERE (kSprache = :lid OR kSprache = 0)
AND (kKundengruppe = :cgid OR kKundengruppe = 0)
AND (nSeite = :ptype OR nSeite = 0)
AND ( (cKey = :cky AND (cValue = :cval OR cValue = '')) OR cValue = '')51μs16.42KB00000000000002e650000000000000000default
Params
:lid
1
:cgid
1
:ptype
2
:cky
kKategorie
:cval
173
SELECT * FROM tboxenanzeige37μs17.58KB820000000000002e5b0000000000000000default
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
LEFTJOIN tboxensichtbar
ON tboxen.kBox = tboxensichtbar.kBox
LEFTJOIN tplugin
ON tboxen.kCustomID = tplugin.kPlugin
LEFTJOIN tboxvorlage
ON tboxen.kBoxvorlage = tboxvorlage.kBoxvorlage
LEFTJOIN tboxsprache
ON tboxsprache.kBox = tboxen.kBox
LEFTJOIN tsprache
ON tsprache.cISO = tboxsprache.cISO
WHERE tboxen.kContainer > -1AND 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") > 0AND tboxen.ePosition IN ('left','bottom') AND (tplugin.nStatus = 2OR tboxvorlage.eTyp ISNULLOR (tboxvorlage.eTyp != 'plugin'AND tboxvorlage.eTyp != 'extension'))
GROUPBY tboxsprache.kBoxSprache, tboxen.kBox, tboxensichtbar.cFilter
ORDERBY tboxensichtbar.nSort, tboxen.kBox ASC7.42ms97KB320000000000002ddf0000000000000000default
SELECT * FROM tkategorie WHERE`kOberKategorie`=:kOberKategorie83μs16.41KB00000000000002ddc0000000000000000default
Params
:kOberKategorie
173
SELECT tsuchanfrage.cSuche FROM tsuchanfrage
LEFTJOIN tsuchcache
ON tsuchcache.cSuche = tsuchanfrage.cSuche
WHERE tsuchanfrage.nAktiv = 1AND tsuchcache.kSuchCache ISNULLORDERBY tsuchanfrage.nAnzahlTreffer, tsuchanfrage.nAnzahlGesuche LIMIT 1063μs16.02KB00000000000002e090000000000000000default
SELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl
FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel
FROM tartikel
#JOINfrom JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#JOIN1 from JTL\Filter\Items\Search::getOptions
JOIN tsuchcachetreffer ON tartikel.kArtikel = tsuchcachetreffer.kArtikel
#JOIN2 from JTL\Filter\Items\Search::getOptions
JOIN tsuchcache ON tsuchcache.kSuchCache = tsuchcachetreffer.kSuchCache
#JOIN3 from JTL\Filter\Items\Search::getOptions
JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche
AND tsuchanfrage.kSprache = 1
#product visiblity joinfrom getBaseQuery
LEFTJOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1WHERE tkategorieartikel.kKategorie = 173AND tsuchanfrage.nAktiv = 1AND tartikelsichtbarkeit.kArtikel ISNULLAND tartikel.kVaterArtikel = 0
#defaultgroupbyGROUPBY tsuchanfrage.kSuchanfrage, tartikel.kArtikel
#limit sqlORDERBY tartikel.nSort, tartikel.cName) AS ssMerkmal
GROUPBY ssMerkmal.kSuchanfrage
ORDERBY ssMerkmal.cSuche173μs16.09KB00000000000002e090000000000000000default
SELECT tartikel.kArtikel
FROM tartikel
JOIN tartikelsonderpreis
ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
JOIN tsonderpreise
ON tsonderpreise.kArtikelSonderpreis = tartikelsonderpreis.kArtikelSonderpreis
LEFTJOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
WHERE tartikelsichtbarkeit.kArtikel ISNULLAND tartikelsonderpreis.kArtikel = tartikel.kArtikel
AND tsonderpreise.kKundengruppe = :cgid
AND tartikelsonderpreis.cAktiv = 'Y'AND tartikelsonderpreis.dStart <= NOW()
AND (tartikelsonderpreis.dEnde ISNULLOR tartikelsonderpreis.dEnde >= CURDATE()) AND tartikel.kVaterArtikel = 0
LIMIT :lmt104μs17.27KB00000000000002dee0000000000000000default
Params
:lmt
10
:cgid
1
SELECT kPlugin, cPluginID, bExtension FROM tplugin32μs16.17KB60000000000002dd40000000000000000default
SELECT * FROM tplugin WHERE`kPlugin`=?38μs17.2KB10000000000002dcb0000000000000000default
Params
0
1
SELECT * FROM licenses
WHERE returnCode = 200ORDERBY id DESC
LIMIT 135μs16.11KB10000000000002e2c0000000000000000default
SELECT * FROM tplugin WHERE`exsID`=?34μs17.25KB20000000000002e440000000000000000default
Params
0
d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE`exsID`=?26μs17.22KB00000000000002e4f0000000000000000default
Params
0
56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort42μs16.34KB60000000000002dc00000000000000000default
Params
:kPlugin
1
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin25μs16.3KB40000000000002e340000000000000000default
Params
:kPlugin
1
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink77μs16.46KB40000000000002e490000000000000000default
Params
:plgn
1
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (105,106,107,108)34μs16.14KB40000000000002df10000000000000000default
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 AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (105,106,107,108)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName482μs17KB80000000000002e2c0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink47μs16.12KB00000000000002e540000000000000000default
Params
:kVaterLink
108
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink26μs16.12KB00000000000002e580000000000000000default
Params
:kVaterLink
107
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB00000000000002db50000000000000000default
Params
:kVaterLink
105
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB00000000000002db00000000000000000default
Params
:kVaterLink
106
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort510μs17.34KB90000000000002e000000000000000000default
Params
:pid
1
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable320μs34.06KB780000000000002e320000000000000000default
Params
:pid
1
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin49μs16.34KB00000000000002d640000000000000000default
Params
:kPlugin
1
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id74μs16.78KB40000000000002d690000000000000000default
Params
:id
1
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid62μs16.98KB30000000000002d700000000000000000default
Params
:pid
kPlugin\_1\_%
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort47μs16.55KB30000000000002d700000000000000000default
Params
:val
kPlugin_1_paypalcheckout\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart30μs16.28KB20000000000002d700000000000000000default
Params
:kZahlungsart
73
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort35μs16.55KB30000000000002d700000000000000000default
Params
:val
kPlugin_1_rechnungskaufmitratepay\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart22μs16.28KB20000000000002d700000000000000000default
Params
:kZahlungsart
74
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'ORDERBY nSort32μs16.55KB30000000000002d700000000000000000default
Params
:val
kPlugin_1_paypalkreditkarte\_%
SELECT * FROM tzahlungsartsprache WHERE`kZahlungsart`=:kZahlungsart20μs16.28KB20000000000002d700000000000000000default
Params
:kZahlungsart
75
SELECT kPlugin, cPluginID, bExtension FROM tplugin22μs16.17KB60000000000002dd10000000000000000default
SELECT * FROM tplugin WHERE`kPlugin`=?32μs17.2KB10000000000002d770000000000000000default
Params
0
2
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort31μs16.27KB10000000000002dab0000000000000000default
Params
:kPlugin
2
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin22μs16.24KB00000000000002d3b0000000000000000default
Params
:kPlugin
2
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink62μs16.4KB00000000000002e2f0000000000000000default
Params
:plgn
2
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort151μs17.19KB00000000000002d350000000000000000default
Params
:pid
2
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable194μs17.13KB180000000000002d2e0000000000000000default
Params
:pid
2
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin43μs16.34KB00000000000002d190000000000000000default
Params
:kPlugin
2
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id57μs16.72KB00000000000002d1e0000000000000000default
Params
:id
2
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid50μs16.94KB00000000000002d220000000000000000default
Params
:pid
kPlugin\_2\_%
SELECT kPlugin, cPluginID, bExtension FROM tplugin21μs16.17KB60000000000002dcf0000000000000000default
SELECT * FROM tplugin WHERE`kPlugin`=?31μs17.2KB10000000000002d280000000000000000default
Params
0
5
SELECT * FROM licenses
WHERE returnCode = 200ORDERBY id DESC
LIMIT 128μs16.11KB10000000000002cf70000000000000000default
SELECT * FROM tplugin WHERE`exsID`=?32μs17.25KB20000000000002cd30000000000000000default
Params
0
d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
SELECT * FROM tplugin WHERE`exsID`=?25μs17.22KB00000000000002cc20000000000000000default
Params
0
56fb166e-d504-438f-95a4-0df2a510884a
SELECT * FROM tpluginadminmenu WHERE`kPlugin`=:kPlugin ORDERBY nSort38μs16.34KB60000000000002d060000000000000000default
Params
:kPlugin
5
SELECT * FROM tpluginhook WHERE`kPlugin`=:kPlugin23μs16.37KB80000000000002d030000000000000000default
Params
:kPlugin
5
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUPBY tlink.kLink77μs16.52KB80000000000002cc90000000000000000default
Params
:plgn
5
SELECT`kLink`, `reference`, `kVaterLink`FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)36μs16.2KB80000000000002ce80000000000000000default
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 AShandler, 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
LEFTJOIN tseo
ON tseo.cKey = 'kLink'AND tseo.kKey = loc.kLink
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tlinkgroupassociations assoc
ON assoc.linkID = loc.kLink
LEFTJOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
LEFTJOIN tplugin
ON tplugin.kPlugin = tlink.kPlugin
LEFTJOIN tpluginlinkdatei pld
ON tplugin.kPlugin = pld.kPlugin
AND tlink.kLink = pld.kLink
WHERE tlink.kLink IN (432,433,434,435,436,437,438,439)
GROUPBY tlink.kLink, tsprache.kSprache
ORDERBY tlink.nSort, tlink.cName535μs17.13KB160000000000002cba0000000000000000default
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink56μs16.12KB00000000000002ca50000000000000000default
Params
:kVaterLink
434
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink27μs16.12KB00000000000002ca00000000000000000default
Params
:kVaterLink
437
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink22μs16.12KB00000000000002c9b0000000000000000default
Params
:kVaterLink
432
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB00000000000002c960000000000000000default
Params
:kVaterLink
433
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB00000000000002c910000000000000000default
Params
:kVaterLink
439
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink21μs16.12KB00000000000002c8c0000000000000000default
Params
:kVaterLink
435
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB00000000000002c870000000000000000default
Params
:kVaterLink
436
SELECT kLink FROM tlink WHERE`kVaterLink`=:kVaterLink20μs16.12KB00000000000002e7d0000000000000000default
Params
:kVaterLink
438
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFTJOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFTJOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUPBY id, confValue
ORDERBY c.nSort150μs17.19KB00000000000002ce50000000000000000default
Params
:pid
5
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFTJOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDERBY l.kPluginSprachvariable158μs16.84KB20000000000002cc50000000000000000default
Params
:pid
5
SELECT * FROM tadminwidgets WHERE`kPlugin`=:kPlugin42μs16.34KB00000000000002ca90000000000000000default
Params
:kPlugin
5
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id55μs16.72KB00000000000002caf0000000000000000default
Params
:id
5
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid49μs16.94KB00000000000002cb30000000000000000default
Params
:pid
kPlugin\_5\_%
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1LEFTJOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFTJOIN tseo ON tseo.cKey = 'kKategorie'AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFTJOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFTJOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFTJOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie ISNULL156μs18.39KB10000000000002e950000000000000000default
Durch Klicken auf „Alle akzeptieren“ gestatten Sie den Einsatz folgender Dienste auf unserer Website: YouTube, Vimeo. Sie können die Einstellung jederzeit ändern (Fingerabdruck-Icon links unten). Weitere Details finden Sie unte Konfigurieren und in unserer Datenschutzerklärung.
Datenschutz-Einstellungen
Einstellungen, die Sie hier vornehmen, werden auf Ihrem Endgerät im „Local Storage“ gespeichert und sind beim nächsten Besuch unseres Onlineshops wieder aktiv. Sie können diese Einstellungen jederzeit ändern (Fingerabdruck-Icon links unten).
Informationen zur Cookie-Funktionsdauer sowie Details zu technisch notwendigen Cookies erhalten Sie in unserer Datenschutzerklärung.
Um Inhalte von YouTube auf dieser Seite zu entsperren, ist Ihre Zustimmung zur Datenweitergabe und
Speicherung von Drittanbieter-Cookies des Anbieters YouTube (Google) erforderlich.
Dies erlaubt uns,
unser Angebot sowie das Nutzererlebnis für Sie zu verbessern und interessanter auszugestalten.
Ohne
Ihre Zustimmung findet keine Datenweitergabe an YouTube statt, jedoch können die Funktionen von YouTube
dann auch nicht auf dieser Seite verwendet werden.
Um Inhalte von Vimeo auf dieser Seite zu entsperren, ist Ihre Zustimmung zur Datenweitergabe und
Speicherung von Drittanbieter-Cookies des Anbieters Vimeo erforderlich.
Dies erlaubt uns,
unser Angebot sowie das Nutzererlebnis für Sie zu verbessern und interessanter auszugestalten.
Ohne
Ihre Zustimmung findet keine Datenweitergabe an Vimeo statt, jedoch können die Funktionen von Vimeo
dann auch nicht auf dieser Seite verwendet werden.
Sie möchten diesen Inhalt sehen? Aktivieren Sie den gewünschten Inhalt einmalig oder legen Sie eine dauerhafte Freigabe fest. Bei Zustimmung werden Daten beim genannten Drittanbieter abgerufen. Dabei werden unter Umständen Drittanbieter-Cookies auf Ihrem Endgerät gespeichert. Sie können diese Einstellungen jederzeit ändern (Fingerabdruck-Icon links unten). Weitere Details finden Sie in unserer Datenschutzerklärung.