| 1 x Shop start to end (82.93%) | 116.41ms |
| 2 x shop.hook.252 (17.24%) | 24.20ms |
| 1 x shop.hook.320 (0.32%) | 454μs |
| 151 x shop.hook.301 (0.08%) | 108μs |
| 151 x shop.hook.300 (0.06%) | 81μs |
| 10 x shop.hook.208 (0.01%) | 14μs |
| 10 x shop.hook.120 (0.01%) | 12μs |
| 6 x shop.hook.330 (0.01%) | 7μs |
| 10 x shop.hook.302 (0%) | 7μs |
| 3 x shop.hook.118 (0%) | 6μs |
| 5 x shop.hook.221 (0%) | 6μs |
| 2 x shop.hook.250 (0%) | 6μs |
| 1 x shop.hook.109 (0%) | 3μs |
| 2 x shop.hook.254 (0%) | 3μs |
| 1 x shop.hook.133 (0%) | 3μs |
| 1 x shop.hook.226 (0%) | 2μs |
| 1 x shop.hook.99 (0%) | 2μs |
| 1 x shop.hook.204 (0%) | 2μs |
| 2 x shop.hook.253 (0%) | 2μs |
| 1 x shop.hook.89 (0%) | 2μs |
| 1 x shop.hook.101 (0%) | 2μs |
| 1 x shop.hook.90 (0%) | 1μs |
| 2 x shop.hook.251 (0%) | 1μs |
| 1 x shop.hook.131 (0%) | 1μs |
| 1 x shop.hook.156 (0%) | 1μs |
| 1 x shop.hook.361 (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.400 (0%) | 1μs |
| 1 x shop.hook.132 (0%) | 1μs |
| 1 x shop.hook.166 (0%) | 1μs |
| 1 x shop.hook.143 (0%) | 1μs |
| 2 x shop.hook.214 (0%) | 1μs |
| 1 x shop.hook.175 (0%) | 1μs |
| 1 x shop.hook.331 (0%) | 0μs |
.png){kind=small}
.png){kind=small}
.png){kind=small}
SELECT * FROM tsprache97μs16.22KB20000000000000b790000000000000000defaultSELECT * FROM tkundengruppe WHERE `cStandard`=?110μs16.7KB10000000000000b7d0000000000000000default| Params | |
|---|---|
| 0 | Y |
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFT JOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section1.42ms17.39KB530000000000000b840000000000000000default| Params | |
|---|---|
| :section | 1 |
SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe118μs16.25KB00000000000000b390000000000000000default| Params | |
|---|---|
| :kKundengruppe | 1 |
SELECT tpluginhook.nHook, tplugin.kPlugin, tplugin.nVersion, tpluginhook.cDateiname, tpluginhook.nPriority
FROM tplugin
JOIN tpluginhook
ON tpluginhook.kPlugin = tplugin.kPlugin
WHERE tplugin.nStatus = :state
ORDER BY tpluginhook.nPriority, tplugin.kPlugin157μs16.69KB120000000000000b4f0000000000000000default| Params | |
|---|---|
| :state | 2 |
SELECT * FROM tsprache100μs16.22KB20000000000000aec0000000000000000defaultSELECT * FROM twaehrung123μs16.23KB10000000000000ae80000000000000000defaultSELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache101μs16.08KB00000000000000a8b0000000000000000defaultSELECT 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 = :section490μs16.95KB27000000000000090c0000000000000000default| Params | |
|---|---|
| :section | 7 |
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFT JOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDER BY tsprache.kSprache ASC138μs16.22KB200000000000008f00000000000000000defaultSELECT *
FROM tglobals
WHERE dLetzteAenderung > :ts104μs16.2KB000000000000008f30000000000000000default| Params | |
|---|---|
| :ts | 2025-05-14 06:25:32 |
SELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFT JOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDER BY tsprache.kSprache ASC162μs16.22KB20000000000000baf0000000000000000defaultSELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv44μs16.42KB30000000000000bb00000000000000000default| Params | |
|---|---|
| :nAktiv | 1 |
SELECT kPlugin AS id, bExtension AS modern
FROM tplugin
WHERE nStatus = :state
AND bBootstrap = 1
ORDER BY nPrio ASC41μ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
INNER JOIN tadminlogin
ON tadminlogin.kAdminlogin = tstoreauth.owner
LIMIT 143μs16.11KB100000000000017000000000000000000defaultSELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 138μs16.11KB100000000000017040000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?38μs17.25KB200000000000017280000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?27μs17.22KB000000000000017390000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort39μs16.34KB600000000000016f20000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin23μs16.3KB400000000000017100000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink76μs16.46KB400000000000017300000000000000000default| Params | |
|---|---|
| :plgn | 1 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (105,106,107,108)36μs16.14KB400000000000017030000000000000000defaultSELECT 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.cName497μs17KB800000000000017040000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB0000000000000173f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 108 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000017440000000000000000default| Params | |
|---|---|
| :kVaterLink | 107 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB000000000000017490000000000000000default| Params | |
|---|---|
| :kVaterLink | 105 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB0000000000000174e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 106 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort487μs17.34KB9000000000000172f0000000000000000default| Params | |
|---|---|
| :pid | 1 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable316μs34.06KB78000000000000170d0000000000000000default| Params | |
|---|---|
| :pid | 1 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin50μs16.34KB0000000000000179a0000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id71μs16.78KB400000000000017950000000000000000default| Params | |
|---|---|
| :id | 1 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid62μs16.98KB3000000000000178e0000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_1\_% |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort50μs16.55KB3000000000000178e0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_paypalcheckout\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart29μs16.28KB2000000000000178e0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 73 |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort35μs16.55KB3000000000000178e0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_rechnungskaufmitratepay\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart20μs16.28KB2000000000000178e0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 74 |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort32μs16.55KB3000000000000178e0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_paypalkreditkarte\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart19μs16.28KB2000000000000178e0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 75 |
SELECT * FROM tplugin WHERE `kPlugin`=?35μs17.2KB100000000000017c50000000000000000default| Params | |
|---|---|
| 0 | 2 |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort40μs16.27KB100000000000018640000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin21μs16.24KB0000000000000186b0000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink60μs16.4KB0000000000000186a0000000000000000default| Params | |
|---|---|
| :plgn | 2 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort149μs17.19KB000000000000018710000000000000000default| Params | |
|---|---|
| :pid | 2 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable187μs17.13KB1800000000000018780000000000000000default| Params | |
|---|---|
| :pid | 2 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin43μs16.34KB0000000000000188d0000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id56μs16.72KB000000000000018880000000000000000default| Params | |
|---|---|
| :id | 2 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid51μ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')94μs17.08KB63000000000000187d0000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?32μs17.2KB1000000000000187e0000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 130μs16.11KB100000000000018be0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?35μs17.25KB2000000000000189a0000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?25μs17.22KB000000000000018e60000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort33μs16.34KB600000000000018cd0000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin22μs16.37KB800000000000018ca0000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink78μs16.52KB800000000000018df0000000000000000default| Params | |
|---|---|
| :plgn | 5 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)34μs16.2KB800000000000018af0000000000000000defaultSELECT 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.cName510μs17.13KB1600000000000018ee0000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink49μs16.12KB000000000000019030000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000019080000000000000000default| Params | |
|---|---|
| :kVaterLink | 437 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000190d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000019120000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000019170000000000000000default| Params | |
|---|---|
| :kVaterLink | 439 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000191c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000019210000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000019260000000000000000default| Params | |
|---|---|
| :kVaterLink | 438 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort150μs17.19KB000000000000018ac0000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable157μs16.84KB200000000000018e30000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin40μs16.34KB000000000000018ff0000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id54μs16.72KB000000000000018f90000000000000000default| Params | |
|---|---|
| :id | 5 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid49μs16.94KB000000000000018f50000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_5\_% |
SELECT * FROM ttemplate WHERE `eTyp`=?29μs16.85KB1000000000000195c0000000000000000default| Params | |
|---|---|
| 0 | standard |
SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate80μs17.2KB6300000000000019620000000000000000default| Params | |
|---|---|
| :cTemplate | BALTER |
SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio36μs16.3KB300000000000019a10000000000000000default| Params | |
|---|---|
| :nStatus | 2 |
SELECT * FROM tconsent WHERE `active`=:active26μs16.27KB20000000000001ee40000000000000000default| Params | |
|---|---|
| :active | 1 |
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID27μs16.31KB20000000000001efe0000000000000000default| Params | |
|---|---|
| :consentID | 1 |
SELECT * FROM tsprache22μs16.22KB20000000000001efe0000000000000000defaultSELECT * FROM tconsentlocalization WHERE `consentID`=:consentID24μs16.31KB20000000000001f090000000000000000default| Params | |
|---|---|
| :consentID | 2 |
SELECT * FROM tsprache16μs16.22KB20000000000001f090000000000000000defaultSELECT 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 = :section54μs16.56KB30000000000001f090000000000000000default| Params | |
|---|---|
| :section | 129 |
SELECT tplugineinstellungen.*, tplugineinstellungenconf.cConf
FROM tplugin
JOIN tplugineinstellungen
ON tplugineinstellungen.kPlugin = tplugin.kPlugin
LEFT JOIN tplugineinstellungenconf
ON tplugineinstellungenconf.kPlugin = tplugin.kPlugin
AND tplugineinstellungen.cName = tplugineinstellungenconf.cWertName
WHERE tplugin.kPlugin = :pid328μs17.84KB720000000000001f190000000000000000default| Params | |
|---|---|
| :pid | 1 |
SELECT tkategorie.kKategorie, tkategorie.cSeo, tkategorie.cName, tkategorie.kOberKategorie, tkategoriepict.kKategoriePict FROM tkategorie
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
WHERE tkategorie.kOberKategorie = 045μs16.19KB40000000000001f510000000000000000defaultSELECT 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.39KB10000000000001f390000000000000000default| Params | |
|---|---|
| :kid | 108 |
| :cgid | 1 |
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFT JOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section529μs17.02KB320000000000001f470000000000000000default| Params | |
|---|---|
| :section | 110 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort136μs17KB00000000000001f730000000000000000default| Params | |
|---|---|
| :cid | 108 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?47μs16.93KB40000000000001f6e0000000000000000default| Params | |
|---|---|
| 0 | 108 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL141μs18.39KB10000000000001f6d0000000000000000default| Params | |
|---|---|
| :kid | 123 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort129μs17KB00000000000001f6d0000000000000000default| Params | |
|---|---|
| :cid | 123 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?48μs16.99KB80000000000001f220000000000000000default| Params | |
|---|---|
| 0 | 123 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL132μs18.39KB10000000000001f230000000000000000default| Params | |
|---|---|
| :kid | 132 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort121μs17KB00000000000001f230000000000000000default| Params | |
|---|---|
| :cid | 132 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.99KB70000000000001f2c0000000000000000default| Params | |
|---|---|
| 0 | 132 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL125μs18.39KB10000000000001f2d0000000000000000default| Params | |
|---|---|
| :kid | 220 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort117μs17KB00000000000001f2d0000000000000000default| Params | |
|---|---|
| :cid | 220 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?34μs16.87KB00000000000001f770000000000000000default| Params | |
|---|---|
| 0 | 220 |
SELECT id_category FROM submenusettings
WHERE id = 122μs16.04KB10000000000001f3a0000000000000000defaultSELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB10000000000001f310000000000000000default| Params | |
|---|---|
| :kid | 109 |
| :cgid | 1 |
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFT JOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section3.42ms18.02KB910000000000001f7c0000000000000000default| Params | |
|---|---|
| :section | 9 |
SELECT tbranding.kBranding AS id, tbranding.cBildKategorie AS type,
tbrandingeinstellung.cPosition AS position, tbrandingeinstellung.cBrandingBild AS path,
tbrandingeinstellung.dTransparenz AS transparency, tbrandingeinstellung.dGroesse AS size
FROM tbrandingeinstellung
INNER JOIN tbranding
ON tbrandingeinstellung.kBranding = tbranding.kBranding
WHERE tbrandingeinstellung.nAktiv = 140μs16.16KB00000000000001fd90000000000000000defaultSELECT 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.nSort128μs17KB00000000000001fda0000000000000000default| Params | |
|---|---|
| :cid | 109 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?45μs16.95KB50000000000001fd30000000000000000default| Params | |
|---|---|
| 0 | 109 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL135μs18.39KB10000000000001fd20000000000000000default| Params | |
|---|---|
| :kid | 110 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort126μs17KB00000000000001fd20000000000000000default| Params | |
|---|---|
| :cid | 110 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?43μs16.95KB50000000000001fc90000000000000000default| Params | |
|---|---|
| 0 | 110 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL124μs18.39KB10000000000001fc80000000000000000default| Params | |
|---|---|
| :kid | 111 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort117μs17KB00000000000001fc80000000000000000default| Params | |
|---|---|
| :cid | 111 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?41μs16.93KB40000000000001fbf0000000000000000default| Params | |
|---|---|
| 0 | 111 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL124μs18.39KB10000000000001fbe0000000000000000default| Params | |
|---|---|
| :kid | 112 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort120μs17KB00000000000001fbe0000000000000000default| Params | |
|---|---|
| :cid | 112 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?44μs16.95KB50000000000001fb50000000000000000default| Params | |
|---|---|
| 0 | 112 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL128μs18.39KB10000000000001fb40000000000000000default| Params | |
|---|---|
| :kid | 115 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort114μs17KB00000000000001fb40000000000000000default| Params | |
|---|---|
| :cid | 115 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?34μs16.87KB00000000000001fab0000000000000000default| Params | |
|---|---|
| 0 | 115 |
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL126μs18.39KB10000000000001fab0000000000000000default| Params | |
|---|---|
| :kid | 116 |
| :cgid | 1 |
SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert,
COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
LEFT JOIN tsprache
ON tsprache.cStandard = 'Y'
WHERE kKategorie = :cid
ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort113μs17KB00000000000001fab0000000000000000default| Params | |
|---|---|
| :cid | 116 |
SELECT * FROM tkategorie WHERE `kOberKategorie`=?33μs16.87KB00000000000001fa10000000000000000default| Params | |
|---|---|
| 0 | 116 |
SELECT * FROM tland113μs20.19KB2360000000000001f970000000000000000defaultSELECT cLaender FROM tversandart23μs16.05KB20000000000001f970000000000000000defaultSELECT DISTINCT cLandIso FROM tstaat50μs16.52KB290000000000001f970000000000000000defaultSELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName66μs16.56KB2400000000000020cb0000000000000000default| Params | |
|---|---|
| :cLandIso | AR |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.34KB900000000000020d80000000000000000default| Params | |
|---|---|
| :cLandIso | AT |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.34KB1000000000000020b70000000000000000default| Params | |
|---|---|
| :cLandIso | BE |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName52μs16.69KB2800000000000020fa0000000000000000default| Params | |
|---|---|
| :cLandIso | BG |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName53μs16.63KB2700000000000021160000000000000000default| Params | |
|---|---|
| :cLandIso | BR |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName38μs16.41KB13000000000000213b0000000000000000default| Params | |
|---|---|
| :cLandIso | CA |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName49μs16.63KB26000000000000210a0000000000000000default| Params | |
|---|---|
| :cLandIso | CH |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName63μs16.81KB3400000000000021760000000000000000default| Params | |
|---|---|
| :cLandIso | CN |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName28μs16.28KB6000000000000219f0000000000000000default| Params | |
|---|---|
| :cLandIso | CY |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.44KB1400000000000021970000000000000000default| Params | |
|---|---|
| :cLandIso | CZ |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName38μs16.44KB1600000000000021710000000000000000default| Params | |
|---|---|
| :cLandIso | DE |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName26μs16.27KB500000000000021d80000000000000000default| Params | |
|---|---|
| :cLandIso | DK |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName37μs16.44KB15000000000000216d0000000000000000default| Params | |
|---|---|
| :cLandIso | EE |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName77μs17.06KB5000000000000021f70000000000000000default| Params | |
|---|---|
| :cLandIso | ES |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName43μs16.5KB1900000000000022320000000000000000default| Params | |
|---|---|
| :cLandIso | FI |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName151μs18.19KB11400000000000022210000000000000000default| Params | |
|---|---|
| :cLandIso | FR |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName26μs16.25KB400000000000022c40000000000000000default| Params | |
|---|---|
| :cLandIso | GB |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName35μs16.41KB1300000000000022b20000000000000000default| Params | |
|---|---|
| :cLandIso | GR |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName59μs16.56KB2100000000000022aa0000000000000000default| Params | |
|---|---|
| :cLandIso | HR |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName62μs16.81KB3600000000000022880000000000000000default| Params | |
|---|---|
| :cLandIso | IN |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName140μs17.94KB11000000000000022290000000000000000default| Params | |
|---|---|
| :cLandIso | IT |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName73μs16.94KB4700000000000023a90000000000000000default| Params | |
|---|---|
| :cLandIso | JP |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName33μs16.34KB10000000000000238a0000000000000000default| Params | |
|---|---|
| :cLandIso | LT |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName162μs18.19KB11900000000000023950000000000000000default| Params | |
|---|---|
| :cLandIso | LV |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName58μs16.69KB3200000000000024680000000000000000default| Params | |
|---|---|
| :cLandIso | MX |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName36μs16.38KB12000000000000244e0000000000000000default| Params | |
|---|---|
| :cLandIso | NL |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName70μs16.94KB4200000000000021ee0000000000000000default| Params | |
|---|---|
| :cLandIso | RO |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName107μs17.44KB7800000000000024f70000000000000000default| Params | |
|---|---|
| :cLandIso | TH |
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName92μs17.19KB63000000000000256e0000000000000000default| Params | |
|---|---|
| :cLandIso | US |
SELECT * FROM tfirma LIMIT 128μs16.52KB10000000000001f9a0000000000000000defaultSELECT * 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 nSort70μs16.88KB00000000000001f9d0000000000000000default| Params | |
|---|---|
| :iso | %DE% |
| :cGroupID | 1 |
| :sClasses | ^([0-9 -]* )? |
| :depOnly | Y |
SELECT g.*, l.cName AS localizedName, l.cISOSprache, g.cTemplatename AS template,
g.cName AS groupName, IFNULL(tsprache.kSprache, 0) AS kSprache
FROM tlinkgruppe AS g
LEFT JOIN tlinkgruppesprache AS l
ON g.kLinkgruppe = l.kLinkgruppe
LEFT JOIN tsprache
ON tsprache.cISO = l.cISOSprache
WHERE g.kLinkgruppe > 0 AND l.kLinkgruppe > 098μs16.59KB2200000000000020a70000000000000000defaultSELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName46μs16.27KB000000000000020880000000000000000default| Params | |
|---|---|
| :lgid | 1 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName43μs16.37KB600000000000020830000000000000000default| Params | |
|---|---|
| :lgid | 4 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (440,442,68,71,443,444)31μs16.17KB600000000000020840000000000000000defaultSELECT 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.cName492μs17.06KB1200000000000020730000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB000000000000020620000000000000000default| Params | |
|---|---|
| :kVaterLink | 440 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB0000000000000205d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 442 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020580000000000000000default| Params | |
|---|---|
| :kVaterLink | 68 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020530000000000000000default| Params | |
|---|---|
| :kVaterLink | 71 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000204e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 443 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000020490000000000000000default| Params | |
|---|---|
| :kVaterLink | 444 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName60μs16.37KB600000000000020680000000000000000default| Params | |
|---|---|
| :lgid | 5 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (69,67,59,49,73,74)29μs16.17KB600000000000020670000000000000000defaultSELECT 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.cName459μs17.06KB12000000000000207a0000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink40μs16.12KB0000000000000203b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 69 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000020360000000000000000default| Params | |
|---|---|
| :kVaterLink | 67 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020310000000000000000default| Params | |
|---|---|
| :kVaterLink | 59 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000202c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 49 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000020270000000000000000default| Params | |
|---|---|
| :kVaterLink | 73 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000020220000000000000000default| Params | |
|---|---|
| :kVaterLink | 74 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName83μ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)50μs16.52KB2700000000000020400000000000000000defaultSELECT 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.cName835μs33.75KB540000000000001ffb0000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB000000000000025400000000000000000default| Params | |
|---|---|
| :kVaterLink | 77 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink24μs16.12KB000000000000025450000000000000000default| Params | |
|---|---|
| :kVaterLink | 76 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000254a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 79 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μ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`=:kVaterLink19μs16.12KB0000000000000255e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 80 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000025630000000000000000default| Params | |
|---|---|
| :kVaterLink | 85 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000025680000000000000000default| Params | |
|---|---|
| :kVaterLink | 86 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000260d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026120000000000000000default| Params | |
|---|---|
| :kVaterLink | 437 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026170000000000000000default| Params | |
|---|---|
| :kVaterLink | 83 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000261c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026210000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026260000000000000000default| Params | |
|---|---|
| :kVaterLink | 108 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000262b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 107 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026300000000000000000default| Params | |
|---|---|
| :kVaterLink | 105 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026350000000000000000default| Params | |
|---|---|
| :kVaterLink | 106 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000263a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 439 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000263f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026440000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026490000000000000000default| Params | |
|---|---|
| :kVaterLink | 438 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000264e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 84 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.1KB000000000000026530000000000000000default| Params | |
|---|---|
| :kVaterLink | 3 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026580000000000000000default| Params | |
|---|---|
| :kVaterLink | 63 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.1KB0000000000000265d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 4 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000026620000000000000000default| Params | |
|---|---|
| :kVaterLink | 72 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName62μs16.37KB60000000000001f920000000000000000default| Params | |
|---|---|
| :lgid | 9 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (103,104,420,422,64,61)31μs16.17KB60000000000001f930000000000000000defaultSELECT 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.cName447μs17.03KB100000000000001f820000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB00000000000001fe50000000000000000default| Params | |
|---|---|
| :kVaterLink | 103 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB00000000000001fea0000000000000000default| Params | |
|---|---|
| :kVaterLink | 104 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB00000000000001fef0000000000000000default| Params | |
|---|---|
| :kVaterLink | 420 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB00000000000001ff40000000000000000default| Params | |
|---|---|
| :kVaterLink | 422 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020160000000000000000default| Params | |
|---|---|
| :kVaterLink | 64 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020000000000000000000default| Params | |
|---|---|
| :kVaterLink | 61 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName60μs16.35KB50000000000001fdf0000000000000000default| Params | |
|---|---|
| :lgid | 10 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (109,112,111,110,113)29μs16.16KB50000000000001fe00000000000000000defaultSELECT 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.cName425μs17.03KB100000000000001f890000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB0000000000000200c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 109 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000020110000000000000000default| Params | |
|---|---|
| :kVaterLink | 112 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020400000000000000000default| Params | |
|---|---|
| :kVaterLink | 111 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000201b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 110 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000207a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 113 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName54μs16.32KB300000000000020060000000000000000default| Params | |
|---|---|
| :lgid | 11 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (446,448,447)25μs16.13KB300000000000020070000000000000000defaultSELECT 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.cName398μs16.97KB60000000000001f860000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB000000000000020670000000000000000default| Params | |
|---|---|
| :kVaterLink | 446 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000020840000000000000000default| Params | |
|---|---|
| :kVaterLink | 448 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000204a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 447 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName52μs16.32KB30000000000001f310000000000000000default| Params | |
|---|---|
| :lgid | 12 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (115,50,66)26μs16.13KB30000000000001f7c0000000000000000defaultSELECT 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.cName392μs16.97KB600000000000020730000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000026710000000000000000default| Params | |
|---|---|
| :kVaterLink | 115 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink26μs16.12KB000000000000026760000000000000000default| Params | |
|---|---|
| :kVaterLink | 50 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000267b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 66 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName55μs16.34KB4000000000000266b0000000000000000default| Params | |
|---|---|
| :lgid | 13 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (116,118,119,117)27μs16.14KB4000000000000266c0000000000000000defaultSELECT 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.cName399μs17KB800000000000026800000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μ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`=:kVaterLink19μs16.12KB0000000000000269c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 117 |
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName50μs16.29KB100000000000026870000000000000000default| Params | |
|---|---|
| :lgid | 14 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (120)19μs16.09KB100000000000026880000000000000000defaultSELECT 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.cName165μs16.91KB2000000000000267f0000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink30μs16.12KB000000000000026800000000000000000default| Params | |
|---|---|
| :kVaterLink | 120 |
SELECT tlink.*, tlinksprache.cISOSprache,
tlink.cName AS displayName, tlinksprache.cName AS localizedName, tlinksprache.cTitle AS localizedTitle,
tsprache.kSprache, tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content,
tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords,
tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID,
tseo.cSeo AS localizedUrl, tspezialseite.cDateiname,
GROUP_CONCAT(tlinkgroupassociations.linkGroupID) AS linkGroups, 2 AS pluginState
FROM tlinksprache
JOIN tlink
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
JOIN tlinkgroupassociations
ON tlinkgroupassociations.linkID = tlinksprache.kLink
LEFT JOIN tseo
ON tseo.cKey = 'kLink'
AND tseo.kKey = tlink.kLink
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tspezialseite
ON tspezialseite.nLinkart = tlink.nLinkart
WHERE tlink.kLink = tlinksprache.kLink
AND tlink.nLinkart >= 5
GROUP BY tlink.kLink, tseo.kSprache728μs34KB74000000000000208f0000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.1KB000000000000026d50000000000000000default| Params | |
|---|---|
| :kVaterLink | 3 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.1KB000000000000026da0000000000000000default| Params | |
|---|---|
| :kVaterLink | 4 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000026df0000000000000000default| Params | |
|---|---|
| :kVaterLink | 49 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026e40000000000000000default| Params | |
|---|---|
| :kVaterLink | 50 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026e90000000000000000default| Params | |
|---|---|
| :kVaterLink | 59 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026ee0000000000000000default| Params | |
|---|---|
| :kVaterLink | 61 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026f30000000000000000default| Params | |
|---|---|
| :kVaterLink | 63 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026f80000000000000000default| Params | |
|---|---|
| :kVaterLink | 64 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026fd0000000000000000default| Params | |
|---|---|
| :kVaterLink | 66 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB000000000000027020000000000000000default| Params | |
|---|---|
| :kVaterLink | 67 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027070000000000000000default| Params | |
|---|---|
| :kVaterLink | 69 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000270c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 72 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027110000000000000000default| Params | |
|---|---|
| :kVaterLink | 73 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027160000000000000000default| Params | |
|---|---|
| :kVaterLink | 74 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink21μs16.12KB0000000000000271b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 75 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027200000000000000000default| Params | |
|---|---|
| :kVaterLink | 76 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink22μs16.12KB000000000000027250000000000000000default| Params | |
|---|---|
| :kVaterLink | 77 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000272a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 78 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000272f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 79 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027340000000000000000default| Params | |
|---|---|
| :kVaterLink | 80 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027390000000000000000default| Params | |
|---|---|
| :kVaterLink | 81 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000273e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 83 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027430000000000000000default| Params | |
|---|---|
| :kVaterLink | 84 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027480000000000000000default| Params | |
|---|---|
| :kVaterLink | 85 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000274d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 86 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027520000000000000000default| Params | |
|---|---|
| :kVaterLink | 105 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027570000000000000000default| Params | |
|---|---|
| :kVaterLink | 106 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000275c0000000000000000default| Params | |
|---|---|
| :kVaterLink | 107 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027610000000000000000default| Params | |
|---|---|
| :kVaterLink | 108 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027660000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000276b0000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027700000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000027750000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000277a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μ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, 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.kSprache543μs17.23KB2600000000000026d00000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.1KB000000000000026af0000000000000000default| Params | |
|---|---|
| :kVaterLink | 4 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB000000000000026aa0000000000000000default| Params | |
|---|---|
| :kVaterLink | 61 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000026a50000000000000000default| Params | |
|---|---|
| :kVaterLink | 64 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink20μs16.12KB0000000000000267f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 66 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000268a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 75 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000020a10000000000000000default| Params | |
|---|---|
| :kVaterLink | 76 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000209f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 77 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000020930000000000000000default| Params | |
|---|---|
| :kVaterLink | 78 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000209a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 79 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000278f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 80 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027940000000000000000default| Params | |
|---|---|
| :kVaterLink | 81 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000027990000000000000000default| Params | |
|---|---|
| :kVaterLink | 85 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB0000000000000279e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 86 |
SELECT tlink.*, tlinksprache.cISOSprache,
tlink.cName AS displayName, tlinksprache.cName AS localizedName,
tlinksprache.cTitle AS localizedTitle, tsprache.kSprache,
tlinksprache.cSeo AS linkURL, tlinksprache.cContent AS content,
tlinksprache.cMetaDescription AS metaDescription, tlinksprache.cMetaKeywords AS metaKeywords,
tlinksprache.cMetaTitle AS metaTitle, tseo.kSprache AS languageID,
tseo.cSeo AS localizedUrl, '' AS cDateiname, '' AS linkGroups, 2 AS pluginState
FROM tlinksprache
JOIN tlink
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
LEFT JOIN tseo
ON tseo.cKey = 'kLink'
AND tseo.kKey = tlink.kLink
AND tseo.kSprache = tsprache.kSprache
WHERE tlink.kLink NOT IN (SELECT linkID FROM tlinkgroupassociations)
GROUP BY tlink.kLink, tsprache.kSprache266μs16.75KB000000000000026b40000000000000000defaultSELECT 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 = :section73μs16.56KB300000000000027a80000000000000000default| Params | |
|---|---|
| :section | 128 |
SELECT *
FROM tseo
WHERE cSeo = :slg33μs16.23KB1000000000000280a0000000000000000default| Params | |
|---|---|
| :slg | katalog-und-broshure |
SELECT * FROM tplugin WHERE `kPlugin`=?35μs17.2KB100000000000028130000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM tpluginlinkdatei WHERE `kLink`=?18μs16.7KB100000000000028170000000000000000default| Params | |
|---|---|
| 0 | 432 |
SELECT * FROM tplugin WHERE `kPlugin`=?22μs17.2KB100000000000028170000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM tplugin WHERE `kPlugin`=?20μs17.2KB1000000000000281d0000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 129μs16.11KB100000000000028370000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?31μs17.25KB2000000000000285b0000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?36μs17.22KB0000000000000286c0000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort42μs16.34KB600000000000028280000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin23μs16.37KB8000000000000282b0000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink81μs16.52KB800000000000028650000000000000000default| Params | |
|---|---|
| :plgn | 5 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)39μs16.2KB800000000000028460000000000000000defaultSELECT 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.cName506μs17.13KB1600000000000028740000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink64μs16.12KB000000000000028890000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink23μs16.12KB0000000000000288e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 437 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000028930000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000028980000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB0000000000000289d0000000000000000default| Params | |
|---|---|
| :kVaterLink | 439 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink18μs16.12KB000000000000028a20000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000028a70000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink19μs16.12KB000000000000028ac0000000000000000default| Params | |
|---|---|
| :kVaterLink | 438 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort143μs17.19KB000000000000028490000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable154μs16.84KB200000000000028690000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin39μs16.34KB000000000000028850000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id53μs16.72KB0000000000000287f0000000000000000default| Params | |
|---|---|
| :id | 5 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid47μs16.94KB0000000000000287b0000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_5\_% |
SELECT kPlugin, cPluginID, bExtension FROM tplugin22μs16.17KB600000000000028720000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?31μs17.2KB1000000000000283f0000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 1158μs16.11KB100000000000028c30000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?156μs17.25KB200000000000028e70000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?149μs17.22KB000000000000028f80000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort129μs16.34KB600000000000028b40000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin105μs16.37KB800000000000028b70000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink204μs16.52KB800000000000028f10000000000000000default| Params | |
|---|---|
| :plgn | 5 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)136μs16.2KB800000000000028d20000000000000000defaultSELECT 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.cName900μs17.13KB1600000000000029000000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink70μs16.12KB000000000000029150000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink51μs16.12KB0000000000000291a0000000000000000default| Params | |
|---|---|
| :kVaterLink | 437 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB0000000000000291f0000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB000000000000029240000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000029290000000000000000default| Params | |
|---|---|
| :kVaterLink | 439 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.12KB0000000000000292e0000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000029330000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB000000000000029380000000000000000default| Params | |
|---|---|
| :kVaterLink | 438 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort237μs17.19KB000000000000028d50000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable266μs16.84KB200000000000028f50000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin66μs16.34KB000000000000029110000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id88μs16.72KB0000000000000290b0000000000000000default| Params | |
|---|---|
| :id | 5 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid86μs16.94KB000000000000029070000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_5\_% |
SELECT kKategorie, cSeo, cName FROM tkategorie76μs18.08KB11900000000000028720000000000000000defaultSELECT kKategorie, broshure_file_name, cName FROM tkategorie75μs18.08KB11900000000000028720000000000000000defaultSELECT * FROM tfirma LIMIT 146μs16.52KB10000000000002a210000000000000000defaultSELECT * FROM tversandart
WHERE cNurAbhaengigeVersandart = :depOnly
AND cLaender LIKE :iso
AND (cVersandklassen = '-1'
OR cVersandklassen RLIKE :sClasses)
AND (cKundengruppen = '-1'
OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)
ORDER BY nSort109μs16.88KB00000000000002a250000000000000000default| Params | |
|---|---|
| :iso | %DE% |
| :cGroupID | 1 |
| :sClasses | ^([0-9 -]* )? |
| :depOnly | Y |
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFT JOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFT JOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = :skey
AND tseo.kSprache = therstellersprache.kSprache
WHERE EXISTS (
SELECT 1
FROM tartikel
WHERE tartikel.kHersteller = thersteller.kHersteller
AND NOT EXISTS (
SELECT 1 FROM tartikelsichtbarkeit
WHERE tartikelsichtbarkeit.kArtikel = tartikel.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
)
)
GROUP BY thersteller.kHersteller, therstellersprache.kSprache
ORDER BY thersteller.nSortNr, thersteller.cName1.35ms18KB120000000000002a2c0000000000000000default| Params | |
|---|---|
| :skey | kHersteller |
| :cgid | 1 |
SELECT * FROM tfirma LIMIT 158μs16.52KB10000000000002a4c0000000000000000defaultSELECT 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 DESC127μs16.61KB30000000000002d930000000000000000default| Params | |
|---|---|
| :state | 2 |
SELECT teinstellungen.cName, teinstellungen.cWert, teinstellungenconf.cInputTyp AS type
FROM teinstellungen
LEFT JOIN teinstellungenconf
ON teinstellungenconf.cWertName = teinstellungen.cName
AND teinstellungenconf.kEinstellungenSektion = teinstellungen.kEinstellungenSektion
WHERE teinstellungen.kEinstellungenSektion = :section97μs16.53KB10000000000002dae0000000000000000default| Params | |
|---|---|
| :section | 125 |
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache46μs16.08KB00000000000002db70000000000000000defaultSELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC328μs40.16KB4990000000000002dc40000000000000000defaultINSERT 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)144μs688B00000000000002dc30000000000000000default| Params | |
|---|---|
| :interval | 3 |
DELETE FROM tbesucher
WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)97μs128B00000000000002dc30000000000000000default| Params | |
|---|---|
| :interval | 3 |
SELECT * FROM tbesucher WHERE `cSessID`=?102μs16.93KB10000000000002dc30000000000000000default| Params | |
|---|---|
| 0 | edo01pq1044s853ve0dhpcitcl |
UPDATE tbesucher SET `kBesucher`=?,`cIP`=?,`cSessID`=?,`cID`=?,`kKunde`=?,`kBestellung`=?,`cReferer`=?,`cUserAgent`=?,`cEinstiegsseite`=?,`cBrowser`=?,`cAusstiegsseite`=?,`kBesucherBot`=?,`dLetzteAktivitaet`=?,`dZeit`=? WHERE `kBesucher`=?8.52ms2.28KB10000000000002dc30000000000000000default| Params | |
|---|---|
| 0 | 149313 |
| 1 | 3.135.0.0 |
| 2 | edo01pq1044s853ve0dhpcitcl |
| 3 | b7dc5bf0bac7cd7b4e8ac3b909d4d76a |
| 4 | 0 |
| 5 | 0 |
| 6 | |
| 7 | Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com) |
| 8 | /Shepherd-SH-CAM-VR-8F |
| 9 | Sonstige |
| 10 | /katalog-und-broshure |
| 11 | 0 |
| 12 | 2025-05-14 06:30:03 |
| 13 | 2025-05-14 06:29:55 |
| 14 | 149313 |
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv79μ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 = '')78μs16.42KB00000000000002fa70000000000000000default| Params | |
|---|---|
| :lid | 1 |
| :cgid | 1 |
| :ptype | 28 |
| :cky | |
| :cval | |
SELECT * FROM tboxenanzeige59μs17.58KB820000000000002f9c0000000000000000defaultSELECT 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 ASC13.03ms97KB320000000000002f200000000000000000defaultSELECT 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 10145μs16.02KB00000000000002f9c0000000000000000defaultSELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl
FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel
FROM tartikel
#JOIN1 from JTL\Filter\Items\Search::getOptions
JOIN tsuchcachetreffer ON tartikel.kArtikel = tsuchcachetreffer.kArtikel
#JOIN2 from JTL\Filter\Items\Search::getOptions
JOIN tsuchcache ON tsuchcache.kSuchCache = tsuchcachetreffer.kSuchCache
#JOIN3 from JTL\Filter\Items\Search::getOptions
JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche
AND tsuchanfrage.kSprache = 1
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0
#default group by
GROUP BY tsuchanfrage.kSuchanfrage, tartikel.kArtikel
#limit sql
ORDER BY tartikel.nSort, tartikel.cName) AS ssMerkmal
GROUP BY ssMerkmal.kSuchanfrage
ORDER BY ssMerkmal.cSuche73μs16.37KB00000000000002f9c0000000000000000default[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tar...' at line 18INSERT INTO tjtllog (`cKey`, `nLevel`, `cLog`, `kKey`, `dErstellt`) VALUES (:cKey, :nLevel, :cLog, :kKey, :dErstellt)8.13ms2.98KB10000000000002f4c0000000000000000default| Params | |
|---|---|
| :cKey | jtllog |
| :nLevel | 400 |
| :cLog | Error executing query: SELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel FROM tartikel #JOIN1 from JTL\Filter\Items\Search::getOptions JOIN tsuchcachetreffer ON tartikel.kArtikel = tsuchcachetreffer.kArtikel #JOIN2 from JTL\Filter\Items\Search::getOptions JOIN tsuchcache ON tsuchcache.kSuchCache = tsuchcachetreffer.kSuchCache #JOIN3 from JTL\Filter\Items\Search::getOptions JOIN tsuchanfrage ON tsuchanfrage.cSuche = tsuchcache.cSuche AND tsuchanfrage.kSprache = 1 #product visiblity join from getBaseQuery LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel AND tartikelsichtbarkeit.kKundengruppe = 1 WHERE AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tsuchanfrage.kSuchanfrage, tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName) AS ssMerkmal GROUP BY ssMerkmal.kSuchanfrage ORDER BY ssMerkmal.cSuche SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tar...' at line 18 |
| :kKey | 0 |
| :dErstellt | 2025-05-14 06:30:03 |
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 :lmt167μs17.27KB00000000000002f680000000000000000default| Params | |
|---|---|
| :lmt | 10 |
| :cgid | 1 |
SELECT kPlugin, cPluginID, bExtension FROM tplugin52μs16.17KB60000000000002f150000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?62μs17.2KB10000000000002f0c0000000000000000default| Params | |
|---|---|
| 0 | 1 |
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 159μs16.11KB10000000000002f340000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?66μs17.25KB20000000000002f400000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?55μs17.22KB00000000000002f930000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort74μs16.34KB60000000000002f010000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin49μs16.3KB40000000000002f380000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink132μs16.46KB40000000000002f8d0000000000000000default| Params | |
|---|---|
| :plgn | 1 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (105,106,107,108)62μs16.14KB40000000000002f6e0000000000000000defaultSELECT 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.cName769μs17KB80000000000002f340000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink70μs16.12KB00000000000002f980000000000000000default| Params | |
|---|---|
| :kVaterLink | 108 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink49μs16.12KB00000000000002ef70000000000000000default| Params | |
|---|---|
| :kVaterLink | 107 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000002ef20000000000000000default| Params | |
|---|---|
| :kVaterLink | 105 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.12KB00000000000002eed0000000000000000default| Params | |
|---|---|
| :kVaterLink | 106 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort875μs17.34KB90000000000002f8c0000000000000000default| Params | |
|---|---|
| :pid | 1 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable504μs34.06KB780000000000002f370000000000000000default| Params | |
|---|---|
| :pid | 1 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin73μs16.34KB00000000000002ea10000000000000000default| Params | |
|---|---|
| :kPlugin | 1 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id108μs16.78KB40000000000002ea60000000000000000default| Params | |
|---|---|
| :id | 1 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid99μs16.98KB30000000000002ead0000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_1\_% |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort82μs16.55KB30000000000002ead0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_paypalcheckout\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart57μs16.28KB20000000000002ead0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 73 |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort74μs16.55KB30000000000002ead0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_rechnungskaufmitratepay\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart52μs16.28KB20000000000002ead0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 74 |
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort71μs16.55KB30000000000002ead0000000000000000default| Params | |
|---|---|
| :val | kPlugin_1_paypalkreditkarte\_% |
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart50μs16.28KB20000000000002ead0000000000000000default| Params | |
|---|---|
| :kZahlungsart | 75 |
SELECT kPlugin, cPluginID, bExtension FROM tplugin45μs16.17KB60000000000002f120000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?57μs17.2KB10000000000002eb40000000000000000default| Params | |
|---|---|
| 0 | 2 |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort63μs16.27KB10000000000002ee80000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin45μs16.24KB00000000000002e780000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink101μs16.4KB00000000000002f730000000000000000default| Params | |
|---|---|
| :plgn | 2 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort237μs17.19KB00000000000002e720000000000000000default| Params | |
|---|---|
| :pid | 2 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable306μs17.13KB180000000000002e6b0000000000000000default| Params | |
|---|---|
| :pid | 2 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin67μs16.34KB00000000000002e560000000000000000default| Params | |
|---|---|
| :kPlugin | 2 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id93μs16.72KB00000000000002e5b0000000000000000default| Params | |
|---|---|
| :id | 2 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid84μs16.94KB00000000000002e5f0000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_2\_% |
SELECT kPlugin, cPluginID, bExtension FROM tplugin42μs16.17KB60000000000002f100000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?56μs17.2KB10000000000002e650000000000000000default| Params | |
|---|---|
| 0 | 5 |
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 152μs16.11KB10000000000002e340000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?62μs17.25KB20000000000002e100000000000000000default| Params | |
|---|---|
| 0 | d5c1f01a-9c07-4c8c-9677-cbb5f0a20304 |
SELECT * FROM tplugin WHERE `exsID`=?54μs17.22KB00000000000002dff0000000000000000default| Params | |
|---|---|
| 0 | 56fb166e-d504-438f-95a4-0df2a510884a |
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort69μs16.34KB60000000000002e430000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin48μs16.37KB80000000000002e400000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT tlink.kLink
FROM tlink
JOIN tlinksprache
ON tlink.kLink = tlinksprache.kLink
JOIN tsprache
ON tsprache.cISO = tlinksprache.cISOSprache
WHERE tlink.kPlugin = :plgn
GROUP BY tlink.kLink129μs16.52KB80000000000002e060000000000000000default| Params | |
|---|---|
| :plgn | 5 |
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (432,433,434,435,436,437,438,439)67μs16.2KB80000000000002e250000000000000000defaultSELECT 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.cName860μs17.13KB160000000000002df70000000000000000defaultSELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink68μs16.12KB00000000000002de20000000000000000default| Params | |
|---|---|
| :kVaterLink | 434 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink54μs16.12KB00000000000002ddd0000000000000000default| Params | |
|---|---|
| :kVaterLink | 437 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB00000000000002dd80000000000000000default| Params | |
|---|---|
| :kVaterLink | 432 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000002dd30000000000000000default| Params | |
|---|---|
| :kVaterLink | 433 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB00000000000002dce0000000000000000default| Params | |
|---|---|
| :kVaterLink | 439 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.12KB00000000000002dc90000000000000000default| Params | |
|---|---|
| :kVaterLink | 435 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB00000000000002fbb0000000000000000default| Params | |
|---|---|
| :kVaterLink | 436 |
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.12KB00000000000002fc00000000000000000default| Params | |
|---|---|
| :kVaterLink | 438 |
SELECT c.kPluginEinstellungenConf AS id, c.cName AS name,
c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType,
c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile,
v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue,
c.cWertName AS confName
FROM tplugineinstellungenconf AS c
LEFT JOIN tplugineinstellungenconfwerte AS v
ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf
LEFT JOIN tplugineinstellungen AS e
ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName
WHERE c.kPlugin = :pid
GROUP BY id, confValue
ORDER BY c.nSort236μs17.19KB00000000000002e220000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT l.kPluginSprachvariable, l.kPlugin, l.cName, l.cBeschreibung, o.cISO,
COALESCE(c.cName, o.cName) AS customValue, l.type
FROM tpluginsprachvariable AS l
JOIN tpluginsprachvariablesprache AS o
ON o.kPluginSprachvariable = l.kPluginSprachvariable
LEFT JOIN tpluginsprachvariablecustomsprache AS c
ON c.kPluginSprachvariable = l.kPluginSprachvariable
AND o.cISO = c.cISO
WHERE l.kPlugin = :pid
ORDER BY l.kPluginSprachvariable255μs16.84KB20000000000002e020000000000000000default| Params | |
|---|---|
| :pid | 5 |
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin68μs16.34KB00000000000002de60000000000000000default| Params | |
|---|---|
| :kPlugin | 5 |
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id112μs16.72KB00000000000002dec0000000000000000default| Params | |
|---|---|
| :id | 5 |
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid62μs16.94KB00000000000002df00000000000000000default| Params | |
|---|---|
| :pid | kPlugin\_5\_% |
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
#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 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal76μs20.41KB00000000000002fc50000000000000000default[42000] SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0
#def...' at line 34INSERT INTO tjtllog (`cKey`, `nLevel`, `cLog`, `kKey`, `dErstellt`) VALUES (:cKey, :nLevel, :cLog, :kKey, :dErstellt)8.36ms4.23KB10000000000002fca0000000000000000default| Params | |
|---|---|
| :cKey | jtllog |
| :nLevel | 400 |
| :cLog | Error executing query: 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 #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 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #default group by GROUP BY tartikel.kArtikel #limit sql ORDER BY tartikel.nSort, tartikel.cName ) AS ssMerkmal SQLSTATE[42000]: Syntax error or access violation: 1064 You have an error in your SQL syntax; check the manual that corresponds to your MariaDB server version for the right syntax to use near 'AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 #def...' at line 34 |
| :kKey | 0 |
| :dErstellt | 2025-05-14 06:30:03 |
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.
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.