Scheene Klamotten
Artikel 1 - 2 von 2
Artikel 1 - 2 von 2
Mir schaffe g'rad an denem Schopp!
Es werd awwa bald losgehe ...
Gugg doch änfach en e paar Daache nòmmò 'ren ...
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 unter Konfigurieren und in unserer Datenschutzerklärung.
Impressum | DatenschutzEinstellungen, 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.
| 1 x Shop start to end (85.19%) | 341ms |
| 1 x shop.hook.131 (2.69%) | 10.75ms |
| 1 x shop.hook.133 (1.57%) | 6.27ms |
| 2 x shop.hook.250 (0.51%) | 2.06ms |
| 11 x shop.hook.120 (0.34%) | 1.37ms |
| 1 x shop.hook.219 (0.24%) | 949μs |
| 1 x shop.hook.320 (0.23%) | 926μs |
| 1 x shop.hook.400 (0.2%) | 790μs |
| 3 x shop.hook.119 (0.16%) | 648μs |
| 81 x shop.hook.301 (0.04%) | 142μs |
| 81 x shop.hook.300 (0.02%) | 98μs |
| 20 x shop.hook.221 (0.01%) | 38μs |
| 16 x shop.hook.330 (0.01%) | 24μs |
| 21 x shop.hook.104 (0%) | 20μs |
| 9 x shop.hook.208 (0%) | 19μs |
| 15 x shop.hook.253 (0%) | 17μs |
| 4 x shop.hook.118 (0%) | 12μs |
| 7 x shop.hook.302 (0%) | 10μs |
| 1 x shop.hook.156 (0%) | 7μs |
| 2 x shop.hook.254 (0%) | 6μs |
| 2 x shop.hook.321 (0%) | 6μs |
| 1 x shop.hook.361 (0%) | 5μs |
| 2 x shop.hook.103 (0%) | 5μs |
| 2 x shop.hook.218 (0%) | 5μs |
| 2 x shop.hook.251 (0%) | 4μs |
| 2 x shop.hook.260 (0%) | 4μs |
| 2 x shop.hook.252 (0%) | 4μs |
| 1 x shop.hook.214 (0%) | 4μs |
| 1 x shop.hook.132 (0%) | 3μs |
| 1 x shop.hook.89 (0%) | 3μs |
| 1 x shop.hook.101 (0%) | 3μs |
| 1 x shop.hook.142 (0%) | 3μs |
| 1 x shop.hook.166 (0%) | 3μs |
| 2 x shop.hook.60 (0%) | 3μs |
| 1 x shop.hook.109 (0%) | 3μs |
| 1 x shop.hook.143 (0%) | 2μs |
| 1 x shop.hook.178 (0%) | 2μs |
| 1 x shop.hook.303 (0%) | 2μs |
| 2 x shop.hook.58 (0%) | 2μs |
| 2 x shop.hook.59 (0%) | 2μs |
| 2 x shop.hook.110 (0%) | 2μs |
| 1 x shop.hook.99 (0%) | 2μs |
| 1 x shop.hook.22 (0%) | 2μs |
| 1 x shop.hook.226 (0%) | 2μs |
| 1 x shop.hook.204 (0%) | 2μs |
| 1 x shop.hook.175 (0%) | 2μs |
| 1 x shop.hook.90 (0%) | 2μs |
| 1 x shop.hook.306 (0%) | 1μs |
| 1 x shop.hook.331 (0%) | 1μs |
SELECT * FROM tsprache184μs16.22KB20000000000000ba50000000000000000defaultSELECT G.*, S.cName AS nameLocalized, A.cName AS attributeName, A.cWert AS attributeValue
FROM tkundengruppe G
LEFT JOIN tkundengruppensprache S
ON G.kKundengruppe = S.kKundengruppe
AND S.kSprache = :lid
LEFT JOIN tkundengruppenattribut A
ON G.kKundengruppe = A.kKundengruppe
WHERE G.cStandard = 'Y'213μs16.73KB10000000000000ba20000000000000000default| Params |
|
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.kPlugin260μs16.63KB70000000000000b340000000000000000default| Params |
|
SELECT * FROM tsprache110μs16.22KB20000000000000aad0000000000000000defaultSELECT * FROM twaehrung114μs16.23KB10000000000000aad0000000000000000defaultSELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache100μs16.13KB30000000000000a490000000000000000defaultSELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFT JOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDER BY tsprache.kSprache ASC174μs16.22KB20000000000000a450000000000000000defaultSELECT * FROM tsprache WHERE `cShopStandard`=?90μs16.73KB10000000000000a440000000000000000default| Params |
|
SELECT * FROM tglobals73μs16.06KB10000000000000a440000000000000000defaultSELECT * FROM tsprache63μs16.22KB20000000000000a450000000000000000defaultSELECT * FROM twaehrung63μs16.23KB10000000000000bda0000000000000000defaultSELECT G.*, S.cName AS nameLocalized, A.cName AS attributeName, A.cWert AS attributeValue
FROM tkundengruppe G
LEFT JOIN tkundengruppensprache S
ON G.kKundengruppe = S.kKundengruppe
AND S.kSprache = :lid
LEFT JOIN tkundengruppenattribut A
ON G.kKundengruppe = A.kKundengruppe
WHERE G.cStandard = 'Y'171μs16.73KB10000000000000a360000000000000000default| Params |
|
SELECT * FROM tland303μs20.19KB2380000000000000a2e0000000000000000defaultSELECT cLaender FROM tversandart78μs16.15KB80000000000000a2e0000000000000000defaultSELECT DISTINCT cLandIso FROM tstaat129μs16.52KB290000000000000a2e0000000000000000defaultSELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName224μs16.56KB24000000000000091f0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName148μs16.34KB900000000000009140000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName167μs16.34KB1000000000000009330000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName228μs16.69KB2800000000000008f60000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName222μs16.63KB2700000000000008dc0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName159μs16.41KB1300000000000008b90000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName199μs16.63KB2600000000000008e80000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName238μs16.81KB3400000000000008820000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName134μs16.28KB6000000000000085b0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName173μs16.44KB1400000000000008610000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName174μs16.44KB1600000000000008890000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName125μs16.27KB500000000000008280000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName165μs16.44KB15000000000000088d0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName291μs17.06KB50000000000000080d0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName182μs16.5KB1900000000000007d40000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName540μs18.19KB11400000000000007e30000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName127μs16.25KB400000000000007460000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName154μs16.41KB1300000000000007560000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName208μs16.56KB21000000000000075c0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName249μs16.81KB36000000000000077b0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName507μs17.94KB11000000000000007d60000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName282μs16.94KB47000000000000066a0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName150μs16.34KB1000000000000006870000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName562μs18.19KB119000000000000067e0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName231μs16.69KB3200000000000005b20000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName154μs16.38KB1200000000000005ca0000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName269μs16.94KB4200000000000008100000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName410μs17.44KB7800000000000006820000000000000000default| Params |
|
SELECT * FROM tstaat WHERE `cLandIso`=:cLandIso ORDER BY cName353μs17.19KB6300000000000004b10000000000000000default| Params |
|
SELECT * FROM tfirma LIMIT 194μs16.52KB10000000000000a310000000000000000defaultSELECT tsprache.*, tsprachiso.kSprachISO FROM tsprache
LEFT JOIN tsprachiso
ON tsprache.cISO = tsprachiso.cISO
ORDER BY tsprache.kSprache ASC173μs16.22KB20000000000000a330000000000000000defaultSELECT kPlugin AS id, bExtension AS modern
FROM tplugin
WHERE nStatus = :state
AND bBootstrap = 1
ORDER BY nPrio ASC136μs16.39KB60000000000000a360000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?129μs17.24KB1000000000000093c0000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort133μs16.27KB100000000000015110000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin92μs16.26KB100000000000015170000000000000000default| Params |
|
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.kLink181μs16.4KB000000000000015190000000000000000default| Params |
|
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.nSort598μs17.19KB0000000000000151a0000000000000000default| Params |
|
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.kPluginSprachvariable533μs16.81KB0000000000000151f0000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin131μs16.39KB100000000000015220000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id167μs16.84KB000000000000015260000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid163μs16.94KB000000000000015280000000000000000default| Params |
|
SELECT * FROM ttemplate WHERE `eTyp`=?110μs16.85KB100000000000015760000000000000000default| Params |
|
SELECT * FROM ttemplate WHERE `cTemplate`=?88μs16.84KB0000000000000157b0000000000000000default| Params |
|
SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate117μs16.27KB4000000000000157b0000000000000000default| Params |
|
SELECT `key`,`license`,`compatibility`
FROM `xplugin_salepix_templater_extension`
WHERE `status` = :status119μs16.27KB0000000000000159d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?153μs17.27KB1000000000000159f0000000000000000default| Params |
|
SELECT tstoreauth.auth_code, tstoreauth.access_token,
tadminlogin.cPass AS hash, tstoreauth.verified
FROM tstoreauth
INNER JOIN tadminlogin
ON tadminlogin.kAdminlogin = tstoreauth.owner
LIMIT 1131μs16.23KB100000000000015e70000000000000000defaultSELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 1118μs16.15KB100000000000015eb0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?94μs17.27KB1000000000000162b0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?94μs17.27KB1000000000000163d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?93μs17.27KB1000000000000164e0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?81μs17.27KB1000000000000165f0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?87μs17.27KB100000000000016710000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort105μs16.28KB100000000000015d90000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin73μs16.26KB100000000000015e10000000000000000default| Params |
|
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.kLink147μs16.4KB000000000000015df0000000000000000default| Params |
|
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.nSort449μs17.19KB000000000000015dd0000000000000000default| Params |
|
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.kPluginSprachvariable380μs16.84KB200000000000016610000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin86μs16.39KB100000000000016710000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id126μs16.84KB000000000000016670000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid138μs16.94KB000000000000016690000000000000000default| Params |
|
SELECT
*
FROM
tDZMOptions
WHERE
cPluginId = :cPluginId
85μs16.55KB300000000000016650000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?102μs17.27KB100000000000016510000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 183μs16.15KB1000000000000170a0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?90μs17.27KB1000000000000174a0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?69μs17.27KB1000000000000175c0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?58μs17.27KB1000000000000176d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?89μs17.27KB1000000000000177e0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?75μs17.27KB100000000000017900000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort80μs16.33KB400000000000016fb0000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin65μs16.24KB000000000000016ff0000000000000000default| Params |
|
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.kLink126μs16.4KB000000000000017010000000000000000default| Params |
|
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.nSort544μs17.38KB1200000000000016fd0000000000000000default| Params |
|
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.kPluginSprachvariable292μs16.84KB200000000000017870000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin66μs16.38KB0000000000000178c0000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id86μs16.84KB0000000000000178b0000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid86μs16.94KB000000000000017900000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?61μs17.27KB100000000000017710000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 156μs16.15KB100000000000017ec0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?61μs17.27KB1000000000000182c0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?58μs17.27KB1000000000000183e0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB1000000000000184f0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB100000000000018600000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB100000000000018720000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort67μs16.3KB200000000000017dd0000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin46μs16.26KB100000000000017e10000000000000000default| Params |
|
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.kLink125μs16.4KB000000000000017df0000000000000000default| Params |
|
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.nSort493μs17.38KB1200000000000017e00000000000000000default| Params |
|
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.kPluginSprachvariable331μs16.81KB000000000000018630000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin84μs16.38KB0000000000000186a0000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id124μs16.84KB000000000000018670000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid123μs16.94KB0000000000000186d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?94μs17.27KB1000000000000182e0000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 189μs16.15KB1000000000000192e0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?96μs17.27KB1000000000000196e0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?94μs17.27KB100000000000019800000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?79μs17.27KB100000000000019910000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?61μs17.27KB100000000000019a20000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?96μs17.27KB100000000000019b40000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort77μs16.31KB3000000000000191f0000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin46μs16.24KB000000000000019250000000000000000default| Params |
|
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.kLink95μs16.4KB000000000000019260000000000000000default| Params |
|
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.nSort283μs17.19KB000000000000019240000000000000000default| Params |
|
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.kPluginSprachvariable312μs16.81KB0000000000000199e0000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin66μs16.38KB000000000000019a00000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id85μs16.84KB000000000000019980000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid84μs16.94KB0000000000000199b0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?66μs17.27KB100000000000019950000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 157μs16.15KB10000000000001f450000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?61μs17.27KB10000000000001f850000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?58μs17.27KB10000000000001f970000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000001fa80000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?54μs17.27KB10000000000001fb90000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?54μs17.27KB10000000000001fcb0000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort65μs16.36KB60000000000001f360000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin50μs16.3KB40000000000001f380000000000000000default| Params |
|
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.kLink119μs16.46KB40000000000001fca0000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (119,120,121,122)65μs16.14KB40000000000001fc30000000000000000defaultSELECT 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 (119,120,121,122)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName863μs17KB80000000000001fb80000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid64μs16.12KB10000000000001fac0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000001f990000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000001fa70000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000001fa60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000001fa50000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000001f9f0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid50μs16.12KB10000000000001fa20000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000001f9a0000000000000000default| Params |
|
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.nSort614μs17.44KB150000000000001f3b0000000000000000default| Params |
|
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.kPluginSprachvariable686μs34.56KB1000000000000001fbf0000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin86μs16.38KB00000000000001fe90000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id133μs16.91KB40000000000001fe60000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid106μs17.02KB50000000000001fe10000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort78μs16.55KB30000000000001fe10000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart57μs16.33KB20000000000001fe10000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort75μs16.55KB30000000000001fe10000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart70μs16.33KB20000000000001fe10000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort73μs16.55KB30000000000001fe10000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart51μs16.33KB20000000000001fe10000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort71μs16.55KB30000000000001fe10000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart60μs16.33KB20000000000001fe10000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort70μs16.55KB30000000000001fe10000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart50μs16.33KB20000000000001fe10000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?113μs17.27KB10000000000000a360000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?51μs17.27KB10000000000000a3d0000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 194μs16.15KB100000000000020200000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?96μs17.27KB100000000000020600000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?68μs17.27KB100000000000020720000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?67μs17.27KB100000000000020830000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?65μs17.27KB100000000000020940000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB100000000000020a60000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort72μs16.28KB10000000000001fc10000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin48μs16.26KB10000000000001fb40000000000000000default| Params |
|
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.kLink112μs16.4KB00000000000001faf0000000000000000default| Params |
|
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.nSort334μs17.19KB00000000000001fb20000000000000000default| Params |
|
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.kPluginSprachvariable325μs16.84KB200000000000020960000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin71μs16.39KB100000000000020a60000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id105μs16.84KB0000000000000209c0000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid93μs16.94KB0000000000000209e0000000000000000default| Params |
|
SELECT
*
FROM
tDZMOptions
WHERE
cPluginId = :cPluginId
64μs16.55KB300000000000020980000000000000000default| Params |
|
SELECT
*
FROM
tplugin
WHERE
nStatus = 2
AND cPluginID LIKE 'dzm%'
87μs16.72KB100000000000020850000000000000000default
SELECT
*
FROM
tplugin_resources
WHERE
path IN ('dist/resources.js','dzmCopyClipboard.js','dzmCouponCopy.js','dzm.dispatcher.js','dzmProgressbar.js','countdown/dist/dzmCountdown.js','dzmCountdown.js','dzmCountdownPlus.js','dzmPopUpContainer.js','dzmEventDispatcher.js','blueprintWrapperController.js','dzm_cookie_trigger.js','dzm_dev.css','animate.min.css','splide.min.js','splide.min.css','image-compare-viewer.min.js','image-compare-viewer.min.css','dzm-expander.js','dzm_container_plus.js','dzm-videoTitle.js','dzm_videoplayer.js','dzm_sales_countdown.js','dzm_resources.style.css','dzm_resources.main.js')
82μs16.38KB1000000000000020850000000000000000default
DELETE FROM
tplugin_resources
WHERE
id = :id
45μs168B000000000000020990000000000000000default| Params |
|
DELETE FROM
tplugin_resources
WHERE
id = :id
28μs168B000000000000020990000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?57μs17.27KB10000000000000a330000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `kPlugin`=?49μs17.27KB10000000000000a360000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 154μs16.15KB1000000000000205f0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?59μs17.27KB100000000000020a90000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?57μs17.27KB100000000000020bb0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB100000000000020cc0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB100000000000020dd0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?60μs17.27KB100000000000020ef0000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort67μs16.3KB200000000000020850000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin47μs16.26KB100000000000020680000000000000000default| Params |
|
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.kLink100μs16.4KB0000000000000206c0000000000000000default| Params |
|
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.nSort464μs17.38KB1200000000000020670000000000000000default| Params |
|
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.kPluginSprachvariable260μs16.81KB000000000000020e00000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin64μs16.38KB000000000000020e70000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id97μs16.84KB000000000000020e40000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid89μs16.94KB000000000000020ea0000000000000000default| Params |
|
SELECT kPlugin, cPluginID, bExtension FROM tplugin46μs16.17KB60000000000000a330000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?55μs17.27KB100000000000020ba0000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 153μs16.15KB100000000000020290000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?62μs17.27KB100000000000020fa0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?57μs17.27KB1000000000000210c0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?54μs17.27KB1000000000000211d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB1000000000000212e0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?54μs17.27KB100000000000021400000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort63μs16.3KB200000000000020b20000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin46μs16.26KB100000000000020af0000000000000000default| Params |
|
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.kLink92μs16.4KB000000000000020ae0000000000000000default| Params |
|
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.nSort440μs17.38KB1200000000000020ad0000000000000000default| Params |
|
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.kPluginSprachvariable259μs16.81KB000000000000021310000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin157μs16.38KB000000000000021380000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id177μs16.84KB000000000000021350000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid214μs16.94KB0000000000000213b0000000000000000default| Params |
|
SELECT * FROM tfirma LIMIT 189μs16.52KB100000000000021400000000000000000defaultSELECT tsteuerzone.kSteuerzone
FROM tsteuerzone, tsteuerzoneland
WHERE tsteuerzoneland.cISO = :ciso
AND tsteuerzoneland.kSteuerzone = tsteuerzone.kSteuerzone147μs16.29KB100000000000021360000000000000000default| Params |
|
SELECT * FROM tsteuerklasse71μs16.11KB200000000000021350000000000000000defaultSELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (1)) ORDER BY nPrio DESC144μs16.26KB100000000000021350000000000000000default| Params |
|
SELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (1)) ORDER BY nPrio DESC111μs16.26KB100000000000021350000000000000000default| Params |
|
SELECT cPluginID, cVerzeichnis, nVersion, bExtension FROM tplugin WHERE `nStatus`=:nStatus ORDER BY nPrio160μs16.34KB600000000000020b40000000000000000default| Params |
|
SELECT kPlugin, cPluginID, bExtension FROM tplugin141μs16.17KB6000000000000264f0000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?131μs17.24KB100000000000026770000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort143μs16.27KB100000000000026810000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin97μs16.26KB100000000000026870000000000000000default| Params |
|
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.kLink230μs16.4KB000000000000026890000000000000000default| Params |
|
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.nSort675μs17.19KB0000000000000268a0000000000000000default| Params |
|
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.kPluginSprachvariable646μs16.81KB0000000000000268f0000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin145μs16.39KB100000000000026920000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id199μs16.84KB000000000000026960000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid191μs16.94KB000000000000026980000000000000000default| Params |
|
SELECT `group`,`name`,`value` FROM xplugin_salepix_templater_template_setting WHERE `template`=:template295μs18.73KB13900000000000026830000000000000000default| Params |
|
SELECT
*
FROM
tDZMOptions
WHERE
cPluginId = :cPluginId
115μs16.55KB300000000000027100000000000000000default| Params |
|
SELECT
*
FROM
tDZMScripts
71μs16.46KB0000000000000165d0000000000000000default
SELECT
tDZMConsentItems.*
,IFNULL(CORE.connectedElements,0) AS 'connectedElements'
FROM
tDZMConsentItems
LEFT JOIN
(
SELECT
tDZMScripts.kDZMConsentItem
,COUNT(tDZMScripts.kDZMScript) AS 'connectedElements'
FROM
tDZMScripts
GROUP BY
tDZMScripts.kDZMConsentItem
) AS CORE ON tDZMConsentItems.kDZMConsentItem = CORE.kDZMConsentItem
258μs16.77KB000000000000027110000000000000000defaultSELECT * FROM xplugin_salepix_templater_logo106μs16.27KB300000000000026f40000000000000000defaultSELECT * FROM tconsent WHERE `active`=:active291μs16.27KB200000000000026dd0000000000000000default| Params |
|
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID402μs16.35KB200000000000026c50000000000000000default| Params |
|
SELECT * FROM tsprache79μs16.22KB200000000000026c50000000000000000defaultSELECT * FROM tconsentlocalization WHERE `consentID`=:consentID94μs16.35KB200000000000026bd0000000000000000default| Params |
|
SELECT * FROM tsprache68μs16.22KB200000000000026bd0000000000000000default
SELECT
tDZMConsentItems.*
,IFNULL(CORE.connectedElements,0) AS 'connectedElements'
FROM
tDZMConsentItems
LEFT JOIN
(
SELECT
tDZMScripts.kDZMConsentItem
,COUNT(tDZMScripts.kDZMScript) AS 'connectedElements'
FROM
tDZMScripts
GROUP BY
tDZMScripts.kDZMConsentItem
) AS CORE ON tDZMConsentItems.kDZMConsentItem = CORE.kDZMConsentItem
174μs16.77KB000000000000026da0000000000000000defaultSELECT 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 = :pid540μs18.09KB8700000000000026d90000000000000000default| Params |
|
SELECT `group`,`name`,`value` FROM xplugin_salepix_templater_template_setting WHERE `template`=:template250μs18.73KB13900000000000027190000000000000000default| Params |
|
SELECT *
FROM tseo
WHERE cSeo = :slg260μs16.27KB1000000000000267c0000000000000000default| Params |
|
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 NULL1.2ms18.39KB100000000000026770000000000000000default| Params |
|
SELECT tkategorieattribut.kKategorie,
COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) AS cName,
COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) AS cWert,
tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort
FROM tkategorieattribut
LEFT JOIN tkategorieattributsprache
ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut
AND tkategorieattributsprache.kSprache = 1
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort497μs16.44KB1900000000000026890000000000000000defaultSELECT COUNT(kKategorie) AS cnt FROM tkategorie WHERE kKategorie > 0266μs16.04KB1000000000000159a0000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, node.cBeschreibung, tkategoriepict.cPfad, atr.cWert As customImgName, COALESCE(s1.cnt, 0) cnt
FROM (SELECT node.kKategorie, node.nLevel, node.kOberKategorie, node.cName, node.cBeschreibung,
node.lft, node.rght
FROM tkategorie AS node
INNER JOIN tkategorie AS parent ON node.lft BETWEEN parent.lft AND parent.rght
WHERE parent.kOberKategorie = :startCat
AND node.nLevel > :startLvl
AND parent.nLevel > :startLvl ) AS node LEFT JOIN tseo
ON tseo.cKey = 'kKategorie'
AND tseo.kKey = node.kKategorie
AND tseo.kSprache = :langID LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = node.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = node.kKategorie
AND atr.cName = 'bildname'
LEFT JOIN tkategoriesichtbarkeit
ON node.kKategorie = tkategoriesichtbarkeit.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgID LEFT JOIN (
SELECT tkategorieartikel.kKategorie, COUNT(tkategorieartikel.kArtikel) AS cnt
FROM tkategorieartikel
INNER JOIN tartikel
ON tkategorieartikel.kArtikel = tartikel.kArtikel AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
LEFT JOIN tartikelsichtbarkeit
ON tkategorieartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgID
WHERE tartikelsichtbarkeit.kArtikel IS NULL
GROUP BY tkategorieartikel.kKategorie) AS s1 ON s1.kKategorie = node.kKategorie
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft1.53ms19.69KB21000000000000159a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 168μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 149μs16.18KB000000000000027dd0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 142μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000027df0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 148μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000027e10000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000027e30000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 146μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 145μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 152μs16.18KB0000000000000277f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 144μs16.18KB000000000000027e70000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ea0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ec0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ee0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f00000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027f40000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027f70000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f90000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027fb0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027fd0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027f20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 149μs16.18KB000000000000028010000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028040000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028060000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028080000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000280a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000027ff0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 144μs16.18KB0000000000000280e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028110000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028130000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028150000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028170000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000280c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000281b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000281e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028200000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028220000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028240000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028190000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028280000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000282b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000282d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000282f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028310000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028260000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028350000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028380000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000283a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000283c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000283e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028330000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028420000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028450000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028470000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028490000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000284b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028400000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000284f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028520000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1174μs16.18KB000000000000028540000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 142μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028560000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028580000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000284d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000285c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 163μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 155μs16.18KB0000000000000285f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 149μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000028610000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 149μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 149μs16.18KB000000000000028630000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028650000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000285a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028690000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000286c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 144μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000286e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028700000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028720000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028670000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028760000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028790000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 142μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000287b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000287d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000287f0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 145μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028740000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028830000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028860000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028880000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000288a0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000288c0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 143μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028810000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028900000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028930000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028950000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028970000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028990000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 137μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 137μs16.18KB0000000000000288e0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000289d0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a00000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a40000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a60000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 150μs16.18KB0000000000000289b0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028aa0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 142μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028ad0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028af0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b10000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b30000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028a80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028b70000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028ba0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028bc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028be0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028c00000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028b50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028c40000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028c70000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 137μs16.18KB000000000000028c90000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028cb0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 174μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 145μs16.18KB000000000000028cd0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 143μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 142μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028c20000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000028d10000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 144μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028d40000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028d60000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 144μs16.18KB000000000000028d80000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028da0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028cf0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 141μs16.18KB000000000000028de0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028e10000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028e30000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028e50000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028e70000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 139μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028e90000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 138μs16.18KB000000000000028dc0000000000000000default| Params |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 140μs16.18KB000000000000028eb0000000000000000default| Params |
|
SELECT `name`,`value` FROM xplugin_salepix_templater_catsettings WHERE categoryId=:categoryId AND languageId=:languageId190μs16.2KB000000000000028810000000000000000default| Params |
|
SELECT `name`,`value` FROM xplugin_salepix_templater_catsettings WHERE categoryId=:categoryId AND languageId=:languageId52μs16.2KB000000000000028810000000000000000default| Params |
|
SELECT `name`,`value` FROM xplugin_salepix_templater_catsettings WHERE categoryId=:categoryId AND languageId=:languageId44μs16.2KB000000000000028810000000000000000default| Params |
|
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.nSort319μs17KB000000000000028c20000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?86μs16.82KB100000000000028810000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?194μs16.8KB000000000000028330000000000000000default| Params |
|
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 NULL206μs18.39KB100000000000027170000000000000000default| Params |
|
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.nSort248μs17KB000000000000027170000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?69μs16.82KB100000000000026890000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?55μs16.8KB000000000000026890000000000000000default| Params |
|
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 NULL186μs18.39KB100000000000027150000000000000000default| Params |
|
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.nSort243μs17KB000000000000027150000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.82KB10000000000000ba60000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?54μs16.8KB00000000000000ba60000000000000000default| Params |
|
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 NULL188μs18.39KB1000000000000268b0000000000000000default| Params |
|
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.nSort253μs17KB0000000000000268b0000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.82KB10000000000002c150000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?55μs16.8KB00000000000002c150000000000000000default| Params |
|
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 NULL184μs18.39KB10000000000002c150000000000000000default| Params |
|
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.nSort241μs17KB00000000000002c150000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?67μs16.82KB10000000000002c1a0000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?54μs16.8KB00000000000002c1a0000000000000000default| Params |
|
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL189μs18.39KB10000000000002c1a0000000000000000default| Params |
|
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.nSort269μs17.03KB20000000000002c1a0000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.82KB10000000000002c1f0000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?55μs16.8KB00000000000002c1f0000000000000000default| Params |
|
SELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName669μs16.05KB20000000000002c260000000000000000defaultSELECT tseo.cSeo, ssMerkmal.kHersteller AS id, ssMerkmal.cName AS name,
ssMerkmal.nSortNr AS sort, ssMerkmal.cBildPfad, COUNT(*) AS cnt
FROM (SELECT thersteller.kHersteller, thersteller.cName, thersteller.nSortNr, thersteller.cBildPfad, tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#JOIN from JTL\Filter\States\BaseManufacturer::getOptions
JOIN thersteller ON tartikel.kHersteller = thersteller.kHersteller
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName) AS ssMerkmal
LEFT JOIN tseo
ON tseo.kKey = ssMerkmal.kHersteller
AND tseo.cKey = 'kHersteller'
AND tseo.kSprache = :lid
GROUP BY ssMerkmal.kHersteller
ORDER BY ssMerkmal.nSortNr, ssMerkmal.cName474μs18.67KB10000000000002c2a0000000000000000default| Params |
|
SELECT tseo.cSeo, tseo.kSprache, thersteller.cName, thersteller.kHersteller AS id
FROM tseo
JOIN thersteller
ON thersteller.kHersteller = tseo.kKey
AND thersteller.nAktiv = 1
WHERE cKey = 'kHersteller'95μs16.13KB20000000000002c260000000000000000defaultSELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFT JOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFT JOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = 'kHersteller'
AND tseo.kSprache = therstellersprache.kSprache
WHERE thersteller.kHersteller = :manfID
AND thersteller.nAktiv = 1
GROUP BY kSprache, thersteller.kHersteller412μs17.33KB10000000000002c2e0000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_manufacturer WHERE `herstellerId`=? AND `languageId`=?189μs16.77KB00000000000002c380000000000000000default| Params |
|
SELECT ssMerkmal.nSterne, COUNT(*) AS nAnzahl
FROM (SELECT ROUND(tartikelext.fDurchschnittsBewertung, 0) AS nSterne, tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#JOIN from JTL\Filter\Items\Rating::getSQLJoin
JOIN tartikelext ON tartikel.kArtikel = tartikelext.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName ) AS ssMerkmal
GROUP BY ssMerkmal.nSterne
ORDER BY ssMerkmal.nSterne DESC409μs16.05KB00000000000002c280000000000000000defaultSELECT kKategorie FROM tkategoriesichtbarkeit49μs16.02KB00000000000002c2a0000000000000000defaultSELECT tseo.cSeo AS slug, ssMerkmal.kKategorie AS id, ssMerkmal.cName AS name,
ssMerkmal.nSort AS sort, COUNT(*) AS cnt
FROM (SELECT tkategorie.kKategorie, tkategorie.nSort, tkategorie.cName
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#join4 from JTL\Filter\Items\Category::getOptions
JOIN tkategorie ON tkategorie.kKategorie = tkategorieartikel.kKategorie
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tkategorie.kKategorie, tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName ) AS ssMerkmal
LEFT JOIN tseo ON tseo.kKey = ssMerkmal.kKategorie
AND tseo.cKey = 'kKategorie'
AND tseo.kSprache = :lid
GROUP BY ssMerkmal.kKategorie
ORDER BY ssMerkmal.nSort, ssMerkmal.cName380μs18.64KB10000000000002c380000000000000000default| Params |
|
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 NULL239μs18.39KB10000000000002c3c0000000000000000default| Params |
|
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.nSort245μs17KB00000000000002c3c0000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?66μs16.8KB00000000000002c410000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?55μs16.8KB00000000000002c400000000000000000default| Params |
|
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 + 7.00) / 100), 2) AS fMin
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#join1 from JTL\Filter\Items\PriceRange::getSQLJoin
JOIN (tpreis
#subjoin for tpreis table
JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tartikel.kArtikel = tpreis.kArtikel
AND tpreis.kKundengruppe = 1
#join2 from JTL\Filter\Items\PriceRange::getSQLJoin
LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel
#join3 from JTL\Filter\Items\PriceRange::getSQLJoin
LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
AND tartikelsonderpreis.cAktiv = 'Y'
AND tartikelsonderpreis.dStart <= NOW()
AND (tartikelsonderpreis.nIstDatum = 0
OR tartikelsonderpreis.dEnde IS NULL
OR tartikelsonderpreis.dEnde >= CURDATE()
)
AND (tartikelsonderpreis.nIstAnzahl = 0
OR tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand)
#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 tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName ) AS ssMerkmal1.04ms16.06KB10000000000002c490000000000000000defaultSELECT SUM(ssMerkmal.anz0) AS anz0, SUM(ssMerkmal.anz1) AS anz1, SUM(ssMerkmal.anz2) AS anz2 FROM (SELECT COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),0)) < 20, tartikel.kArtikel, NULL)) AS anz0, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),0)) < 22.5, tartikel.kArtikel, NULL)) AS anz1, COUNT(DISTINCT IF(IF(tartikel.kSteuerklasse = 1,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 19) / 100), 2),IF(tartikel.kSteuerklasse = 2,
ROUND(LEAST((tpreisdetail.fVKNetto * 1) * ((100 - GREATEST(IFNULL(tartikelkategorierabatt.fRabatt, 0), 0, 0, 0)) / 100), IFNULL(tsonderpreise.fNettoPreis, (tpreisdetail.fVKNetto * 1))) * ((100 + 7) / 100), 2),0)) < 25, tartikel.kArtikel, NULL)) AS anz2
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
LEFT JOIN tartikelkategorierabatt ON tartikelkategorierabatt.kKundengruppe = 1 AND tartikelkategorierabatt.kArtikel = tartikel.kArtikel
LEFT JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
AND tartikelsonderpreis.cAktiv = 'Y'
AND tartikelsonderpreis.dStart <= NOW()
AND (tartikelsonderpreis.nIstDatum = 0
OR tartikelsonderpreis.dEnde IS NULL
OR tartikelsonderpreis.dEnde >= CURDATE())
AND (tartikelsonderpreis.nistAnzahl = 0
OR tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand)
LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis
AND tsonderpreise.kKundengruppe = 1
#join1 from JTL\Filter\Items\PriceRange::getOptions
JOIN (tpreis
#subjoin for tpreis table
JOIN tpreisdetail ON tpreisdetail.kPreis = tpreis.kPreis AND tpreisdetail.nAnzahlAb = 0) ON tpreis.kArtikel = tartikel.kArtikel
AND tpreis.kKundengruppe = 1
#join2 from JTL\Filter\Items\PriceRange::getOptions
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName ) AS ssMerkmal838μs16.19KB10000000000002c4b0000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#bestseller JOIN from JTL\Filter\Items\SearchSpecial::getOptions
JOIN tbestseller ON tbestseller.kArtikel = tartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND ROUND(tbestseller.fAnzahl) >= 10 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName337μs16.02KB00000000000002c240000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#special offer JOIN1 from JTL\Filter\Items\SearchSpecial::getOptions
JOIN tartikelsonderpreis ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
#special offer JOIN2 from JTL\Filter\Items\SearchSpecial::getOptions
JOIN tsonderpreise ON tsonderpreise.kArtikelSonderpreis = tartikelsonderpreis.kArtikelSonderpreis
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsonderpreis.cAktiv = 'Y'
AND tartikelsonderpreis.dStart <= NOW() AND (tartikelsonderpreis.nIstDatum = 0
OR tartikelsonderpreis.dEnde IS NULL
OR tartikelsonderpreis.dEnde >= CURDATE()) AND (tartikelsonderpreis.nIstAnzahl = 0
OR tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand) AND tsonderpreise.kKundengruppe = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName265μs16.02KB00000000000002c2a0000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikel.cNeu = 'Y'
AND DATE_SUB(NOW(), INTERVAL 31 DAY) < tartikel.dErstellt AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName334μs16.02KB00000000000002c3b0000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikel.cTopArtikel = 'Y' AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName213μs16.02KB00000000000002c280000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND NOW() < tartikel.dErscheinungsdatum AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName318μs16.02KB00000000000002c240000000000000000defaultSELECT tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#top reviews JOIN from JTL\Filter\Items\SearchSpecial::getOptions
JOIN tartikelext ON tartikelext.kArtikel = tartikel.kArtikel
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND ROUND(tartikelext.fDurchschnittsBewertung) >= 3 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName217μs16.02KB00000000000002c490000000000000000defaultSELECT ssMerkmal.cSeo, ssMerkmal.kMerkmal, ssMerkmal.kMerkmalWert, ssMerkmal.cMMWBildPfad,
ssMerkmal.nMehrfachauswahl, ssMerkmal.cWert, ssMerkmal.cName, ssMerkmal.cTyp,
ssMerkmal.cMMBildPfad, COUNT(DISTINCT ssMerkmal.kArtikel) AS nAnzahl
FROM (SELECT tmerkmalwertsprache.cWert, tmerkmalwertsprache.cSeo, tmerkmal.cName, tartikel.kArtikel AS kArtikel, tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert, tmerkmalwert.cBildPfad AS cMMWBildPfad, tmerkmal.nSort AS nSortMerkmal, tmerkmalwert.nSort, tmerkmal.cTyp, tmerkmal.nMehrfachauswahl, tmerkmal.cBildPfad AS cMMBildPfad
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#join1 from JTL\Filter\Items\Characteristic::getState
JOIN tartikelmerkmal ON tartikel.kArtikel = tartikelmerkmal.kArtikel
#join2 from JTL\Filter\Items\Characteristic::getState
JOIN tmerkmalwert ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert
#join4 from JTL\Filter\Items\Characteristic::getState
JOIN tmerkmal ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal
#join default lang from JTL\Filter\Items\Characteristic::getState
INNER JOIN tmerkmalwertsprache ON tmerkmalwertsprache.kMerkmalWert = tartikelmerkmal.kMerkmalWert
AND tmerkmalwertsprache.kSprache = 1
#product visiblity join from getBaseQuery
LEFT JOIN tartikelsichtbarkeit ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = 1
WHERE tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
) AS ssMerkmal
GROUP BY ssMerkmal.kMerkmalWert
ORDER BY ssMerkmal.nSortMerkmal, ssMerkmal.nSort, ssMerkmal.cWert864μs16.25KB00000000000002c280000000000000000defaultSELECT 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 NULL205μs18.39KB10000000000002c470000000000000000default| Params |
|
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.nSort250μs17KB00000000000002c470000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?69μs16.82KB10000000000002c580000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?55μs16.8KB00000000000002c580000000000000000default| Params |
|
SELECT cBrocken
FROM tbrocken
LIMIT 1158μs16.04KB10000000000002c600000000000000000defaultSELECT kStueckliste AS id, fLagerbestand AS stock
FROM tartikel
WHERE kArtikel = :pid52μs16.22KB10000000000002c620000000000000000default| Params |
|
SELECT tartikel.kArtikel, tartikel.kHersteller, tartikel.kLieferstatus, tartikel.kSteuerklasse,
tartikel.kEinheit, tartikel.kVPEEinheit, tartikel.kVersandklasse, tartikel.kEigenschaftKombi,
tartikel.kVaterArtikel, tartikel.kStueckliste, tartikel.kWarengruppe,
tartikel.cArtNr, tartikel.cName, tartikel.cBeschreibung, tartikel.cAnmerkung, tartikel.fLagerbestand, tartikel.fMwSt, tartikel.cSeo AS originalSeo,
IF (tartikelabnahme.fMindestabnahme IS NOT NULL,
tartikelabnahme.fMindestabnahme, tartikel.fMindestbestellmenge) AS fMindestbestellmenge,
IF (tartikelabnahme.fIntervall IS NOT NULL,
tartikelabnahme.fIntervall, tartikel.fAbnahmeintervall) AS fAbnahmeintervall,
tartikel.cBarcode, tartikel.cTopArtikel,
tartikel.fGewicht, tartikel.fArtikelgewicht, tartikel.cNeu, tartikel.cKurzBeschreibung, tartikel.fUVP,
tartikel.cLagerBeachten, tartikel.cLagerKleinerNull, tartikel.cLagerVariation, tartikel.cTeilbar,
tartikel.fPackeinheit, tartikel.cVPE, tartikel.fVPEWert, tartikel.cVPEEinheit, tartikel.cSuchbegriffe,
tartikel.nSort, tartikel.dErscheinungsdatum, tartikel.dErstellt, tartikel.dLetzteAktualisierung,
tartikel.cSerie, tartikel.cISBN, tartikel.cASIN, tartikel.cHAN, tartikel.cUNNummer, tartikel.cGefahrnr,
tartikel.nIstVater, date_format(tartikel.dErscheinungsdatum, '%d.%m.%Y') AS Erscheinungsdatum_de,
tartikel.cTaric, tartikel.cUPC, tartikel.cHerkunftsland, tartikel.cEPID, tartikel.fZulauf,
tartikel.dZulaufDatum, DATE_FORMAT(tartikel.dZulaufDatum, '%d.%m.%Y') AS dZulaufDatum_de,
tartikel.fLieferantenlagerbestand, tartikel.fLieferzeit,
tartikel.dMHD, DATE_FORMAT(tartikel.dMHD, '%d.%m.%Y') AS dMHD_de,
tartikel.kMassEinheit, tartikel.kGrundPreisEinheit, tartikel.fMassMenge, tartikel.fGrundpreisMenge,
tartikel.fBreite, tartikel.fHoehe, tartikel.fLaenge, tartikel.nLiefertageWennAusverkauft,
tartikel.nAutomatischeLiefertageberechnung, tartikel.nBearbeitungszeit, me.cCode AS cMasseinheitCode,
mes.cName AS cMasseinheitName, gpme.cCode AS cGrundpreisEinheitCode,
gpmes.cName AS cGrundpreisEinheitName,
tseo.cSeo,
tsonderpreise.fNettoPreis, tartikelext.fDurchschnittsBewertung,
tlieferstatus.cName AS cName_tlieferstatus, teinheit.cName AS teinheitcName,
tartikelsonderpreis.cAktiv AS cAktivSonderpreis, tartikelsonderpreis.dStart AS dStart_en,
DATE_FORMAT(tartikelsonderpreis.dStart, '%d.%m.%Y') AS dStart_de,
tartikelsonderpreis.dEnde AS dEnde_en,
DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de,
tversandklasse.cName AS cVersandklasse,
tbestseller.isBestseller AS bIsBestseller,
ROUND(tartikelext.fDurchschnittsBewertung) >= :trmr AS bIsTopBewertet,
COALESCE((SELECT 1 FROM tuploadschema ULS WHERE ULS.kCustomID = :pid LIMIT 1), 0) AS hasUploads
FROM tartikel
LEFT JOIN tartikelabnahme
ON tartikel.kArtikel = tartikelabnahme.kArtikel
AND tartikelabnahme.kKundengruppe = :cgid
LEFT JOIN tartikelsonderpreis
ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
AND tartikelsonderpreis.cAktiv = 'Y'
AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0)
LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis
AND tsonderpreise.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kArtikel' AND tseo.kKey = tartikel.kArtikel
AND tseo.kSprache = :lid
LEFT JOIN tbestseller
ON tbestseller.kArtikel = tartikel.kArtikel
LEFT JOIN tartikelext
ON tartikelext.kArtikel = tartikel.kArtikel
LEFT JOIN tlieferstatus
ON tlieferstatus.kLieferstatus = tartikel.kLieferstatus
AND tlieferstatus.kSprache = :lid
LEFT JOIN teinheit
ON teinheit.kEinheit = tartikel.kEinheit
AND teinheit.kSprache = :lid
LEFT JOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tversandklasse
ON tversandklasse.kVersandklasse = tartikel.kVersandklasse
LEFT JOIN tmasseinheit me ON me.kMassEinheit = tartikel.kMassEinheit
LEFT JOIN tmasseinheitsprache mes
ON mes.kMassEinheit = me.kMassEinheit
AND mes.kSprache = :lid
LEFT JOIN tmasseinheit gpme
ON gpme.kMassEinheit = tartikel.kGrundpreisEinheit
LEFT JOIN tmasseinheitsprache gpmes
ON gpmes.kMassEinheit = gpme.kMassEinheit
AND gpmes.kSprache = :lid
WHERE tartikel.kArtikel = :pid AND tartikelsichtbarkeit.kArtikel IS NULL AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')1.72ms42.52KB10000000000002c640000000000000000default| Params |
|
SELECT * FROM ttrennzeichen WHERE `nEinheit`=? AND `kSprache`=?819μs16.79KB10000000000002c640000000000000000default| Params |
|
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFT JOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFT JOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = 'kHersteller'
AND tseo.kSprache = therstellersprache.kSprache
WHERE thersteller.kHersteller = :manfID
AND thersteller.nAktiv = 1
GROUP BY kSprache, thersteller.kHersteller314μs17.33KB10000000000002c680000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_manufacturer WHERE `herstellerId`=? AND `languageId`=?71μs16.77KB00000000000002c6b0000000000000000default| Params |
|
SELECT kSuchspecialOverlay
FROM tsuchspecialoverlay258μs16.18KB90000000000002c710000000000000000defaultSELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 1262μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 199μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 192μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 191μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 192μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 191μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 196μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 190μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT ssos.*, sso.cSuchspecial
FROM tsuchspecialoverlaysprache ssos
LEFT JOIN tsuchspecialoverlay sso
ON ssos.kSuchspecialOverlay = sso.kSuchspecialOverlay
WHERE ssos.kSprache = :languageID
AND ssos.kSuchspecialOverlay = :overlayID
AND ssos.cTemplate IN (:templateName, :defaultTemplate)
ORDER BY FIELD(ssos.cTemplate, :templateName, :defaultTemplate)
LIMIT 191μs16.95KB10000000000002c710000000000000000default| Params |
|
SELECT kPreis, noDiscount, kKunde
FROM tpreis AS p
WHERE kArtikel = :pid AND kKundengruppe = :cgid177μs16.25KB10000000000002c6d0000000000000000default| Params |
|
SELECT kSteuerklasse, fMwSt
FROM tartikel
WHERE kArtikel = :pid49μs16.19KB10000000000002c6d0000000000000000default| Params |
|
SELECT nAnzahlAb, fVKNetto
FROM tpreisdetail
WHERE kPreis = :priceID
ORDER BY nAnzahlAb172μs16.25KB10000000000002c6d0000000000000000default| Params |
|
SELECT tsonderpreise.fNettoPreis, tartikelsonderpreis.dEnde AS dEnde_en,
DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de
FROM tsonderpreise
JOIN tartikel
ON tartikel.kArtikel = :productID
JOIN tartikelsonderpreis
ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis
AND tartikelsonderpreis.kArtikel = :productID
AND tartikelsonderpreis.cAktiv = 'Y'
AND tartikelsonderpreis.dStart <= CURDATE()
AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE())
AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand
OR tartikelsonderpreis.nIstAnzahl = 0)
WHERE tsonderpreise.kKundengruppe = :customerGroup235μs17.08KB00000000000002c6b0000000000000000default| Params |
|
SELECT tartikel.kArtikel, tartikel.nIstVater, COALESCE(teigenschaft.kArtikel, 0) AS kArtikelVariation,
tartikel.kSteuerklasse, tartikel.fLagerbestand,
tartikel.fStandardpreisNetto fNettoPreis,
tartikelkonfiggruppe.kKonfiggruppe g1, tkonfigitem.kKonfiggruppe g2
FROM tartikel
LEFT JOIN tartikelkonfiggruppe
ON tartikelkonfiggruppe.kArtikel = tartikel.kArtikel
LEFT JOIN tkonfigitem
ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe
LEFT JOIN teigenschaft
ON teigenschaft.kArtikel = tartikel.kArtikel
WHERE tartikel.kArtikel = :pid242μs16.95KB10000000000002c850000000000000000default| Params |
|
SELECT 1 AS cnt
FROM tartikelkategorierabatt
LIMIT 141μs16.02KB00000000000002c640000000000000000defaultSELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut303μs16.33KB100000000000002c840000000000000000default| Params |
|
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort236μs16.25KB00000000000002c900000000000000000default| Params |
|
SELECT cPfad, nNr
FROM tartikelpict
WHERE kArtikel = :pid
ORDER BY nNr391μs16.22KB10000000000002c900000000000000000default| Params |
|
SELECT tartikelwarenlager.*
FROM tartikelwarenlager
JOIN twarenlager
ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1
WHERE tartikelwarenlager.kArtikel = :productID210μs16.44KB00000000000002c8d0000000000000000default| Params |
|
SELECT tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert
FROM tartikelmerkmal
JOIN tmerkmal
ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal
JOIN tmerkmalwert
ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert
WHERE tartikelmerkmal.kArtikel = :kArtikel
ORDER BY tmerkmal.nSort, tmerkmalwert.nSort, tartikelmerkmal.kMerkmal112μs16.55KB00000000000002c8d0000000000000000default| Params |
|
SELECT tkategorieartikel.kKategorie
FROM tkategorieartikel
LEFT JOIN tkategoriesichtbarkeit
ON tkategoriesichtbarkeit.kKategorie = tkategorieartikel.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
JOIN tkategorie
ON tkategorie.kKategorie = tkategorieartikel.kKategorie
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
AND tkategorieartikel.kKategorie > 0
AND tkategorieartikel.kArtikel = :pid242μs16.66KB10000000000002c950000000000000000default| Params |
|
SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar,
teigenschaft.cTyp, teigenschaft.nSort,
teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert,
teigenschaftwert.fAufpreisNetto, teigenschaftwert.fGewichtDiff, teigenschaftwert.cArtNr,
teigenschaftwert.nSort AS teigenschaftwert_nSort, teigenschaftwert.fLagerbestand,
teigenschaftwert.fPackeinheit, teigenschaftwertpict.kEigenschaftWertPict,
teigenschaftwertpict.cPfad, NULL AS cType,
teigenschaftwertaufpreis.fAufpreisNetto AS fAufpreisNetto_teigenschaftwertaufpreis
FROM teigenschaft
LEFT JOIN teigenschaftwert
ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
LEFT JOIN teigenschaftsichtbarkeit
ON teigenschaft.kEigenschaft = teigenschaftsichtbarkeit.kEigenschaft
AND teigenschaftsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN teigenschaftwertsichtbarkeit
ON teigenschaftwert.kEigenschaftWert = teigenschaftwertsichtbarkeit.kEigenschaftWert
AND teigenschaftwertsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN teigenschaftwertpict
ON teigenschaftwertpict.kEigenschaftWert = teigenschaftwert.kEigenschaftWert
LEFT JOIN teigenschaftwertaufpreis
ON teigenschaftwertaufpreis.kEigenschaftWert = teigenschaftwert.kEigenschaftWert
AND teigenschaftwertaufpreis.kKundengruppe = :cgid
WHERE teigenschaft.kArtikel = :pid
AND teigenschaftsichtbarkeit.kEigenschaft IS NULL
AND teigenschaftwertsichtbarkeit.kEigenschaftWert IS NULL
ORDER BY teigenschaft.nSort ASC, teigenschaft.cName,
teigenschaftwert.nSort ASC, teigenschaftwert.cName210μs19.06KB00000000000002c970000000000000000default| Params |
|
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 > 0368μs16.51KB160000000000002c9c0000000000000000defaultSELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName191μs16.34KB00000000000002cb40000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName91μs16.41KB50000000000002cb70000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (68,61,71,50,66)62μs16.16KB50000000000002cb60000000000000000defaultSELECT 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,61,66,68,71)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName933μs17.03KB100000000000002cc20000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid54μs16.12KB10000000000002cd00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000002cd20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002cd40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002cd60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002cd80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cda0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002cdc0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cde0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002ce00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002ce20000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName88μs16.41KB50000000000002cca0000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (69,67,59,49,74)58μs16.16KB50000000000002ccb0000000000000000defaultSELECT 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,74)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName1.29ms137.03KB100000000000002cbe0000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid54μs16.12KB10000000000002ce90000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink44μs16.12KB00000000000002ceb0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002ced0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink41μs16.12KB00000000000002cef0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002cf10000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002cf30000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002cf50000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002cf70000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002cf90000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002cfb0000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName107μs16.65KB200000000000002ce30000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (77,76,79,78,81,75,80,97,98,87,122,121,119,120,88,3,63,4,73,72)73μs16.39KB200000000000002ce40000000000000000defaultSELECT 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,73,75,76,77,78,79,80,81,87,88,97,98,119,120,121,122)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName1.07ms33.5KB400000000000002d120000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid51μs16.12KB10000000000002d3e0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB00000000000002d400000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002d420000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink40μs16.12KB00000000000002d440000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid36μs16.12KB10000000000002d460000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d480000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid36μs16.12KB10000000000002d4a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d4c0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002d4e0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d500000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid36μs16.12KB10000000000002d520000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d540000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid36μs16.12KB10000000000002d560000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d580000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002d5a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d5c0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002d5e0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002d600000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d620000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d640000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d660000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d680000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002d6a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d6c0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d6e0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d700000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002d720000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d740000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d760000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d780000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d7a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.1KB00000000000002d7c0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d7e0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d800000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid38μs16.12KB10000000000002d820000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.1KB00000000000002d840000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d860000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d880000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002d8a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d8c0000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName78μs16.34KB00000000000002d380000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName75μs16.34KB00000000000002d350000000000000000default| Params |
|
SELECT kLink
FROM tlink
JOIN tlinkgroupassociations a
ON tlink.kLink = a.linkID
WHERE a.linkGroupID = :lgid
ORDER BY tlink.nSort, tlink.cName80μs16.35KB10000000000002d320000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (64)47μs16.09KB10000000000002d330000000000000000defaultSELECT 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 (64)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName242μs16.91KB20000000000002d2f0000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid48μs16.12KB10000000000002d290000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.12KB00000000000002d270000000000000000default| Params |
|
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.kSprache839μs113.75KB580000000000002cad0000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid51μs16.12KB10000000000002cfd0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink43μs16.1KB00000000000002cf80000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid36μs16.12KB10000000000002cc80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.1KB00000000000002cc60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002ccb0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cc10000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002cbf0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cbc0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002cba0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cc20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002d890000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d8e0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d900000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d920000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid39μs16.12KB10000000000002d940000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d960000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d980000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d9a0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002d9c0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d9e0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002da00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002da20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002da40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002da60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002da80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002daa0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002dac0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002dae0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002db00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002db20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002db40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002db60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002db80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002dba0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002dbc0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002dbe0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid38μs16.12KB10000000000002dc00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink39μs16.12KB00000000000002dc20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002dc40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002dc60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002dc80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002dca0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002dcc0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002dce0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002dd00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002dd20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002dd40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002dd60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002dd80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002dda0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002ddc0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002dde0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002de00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002de20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002de40000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002de60000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002de80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002dea0000000000000000default| Params |
|
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.kSprache730μs17.27KB260000000000002d020000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid51μs16.12KB10000000000002d230000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink42μs16.1KB00000000000002d250000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002d2a0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d330000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002d2d0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002d360000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002ca00000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002cae0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002ca80000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002ca20000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002ca30000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002ca40000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002ca50000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002d010000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002deb0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink36μs16.12KB00000000000002ded0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002def0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002df10000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002df30000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002df50000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002df70000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002df90000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002dfb0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink41μs16.12KB00000000000002dfd0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid33μs16.12KB10000000000002dff0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink37μs16.12KB00000000000002e010000000000000000default| Params |
|
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.kSprache431μs16.75KB00000000000002d1e0000000000000000defaultSELECT * FROM tversandart87μs16.56KB80000000000002c970000000000000000defaultSELECT *
FROM tversandart
WHERE fVersandkostenfreiAbX > 0
AND (cVersandklassen = '-1'
OR cVersandklassen RLIKE :sClasses)
AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)107μs16.91KB60000000000002c970000000000000000default| Params |
|
SELECT va.kVersandart, IF(vas.fPreis IS NOT NULL, vas.fPreis, va.fPreis) AS minPrice, va.nSort
FROM tversandart va
LEFT JOIN tversandartstaffel vas
ON vas.kVersandart = va.kVersandart
WHERE cIgnoreShippingProposal != 'Y'
AND va.cLaender LIKE :ccode
AND (va.cVersandklassen = '-1'
OR va.cVersandklassen RLIKE :sclass)
AND (va.cKundengruppen = '-1'
OR FIND_IN_SET(:cgid, REPLACE(va.cKundengruppen, ';', ',')) > 0)
AND va.kVersandart NOT IN (
SELECT vaza.kVersandart
FROM tversandartzahlungsart vaza
WHERE kZahlungsart = 6)
AND (
va.kVersandberechnung = 1
OR va.kVersandberechnung = 4
OR ( va.kVersandberechnung = 2 AND vas.fBis > 0 AND :wght <= vas.fBis )
OR ( va.kVersandberechnung = 3
AND vas.fBis = (
SELECT MIN(fBis)
FROM tversandartstaffel
WHERE fBis > :net
AND tversandartstaffel.kVersandart = va.kVersandart
)
)
) AND va.cNurAbhaengigeVersandart = 'N'
ORDER BY minPrice, nSort ASC LIMIT 1555μs17.59KB10000000000002e0b0000000000000000default| Params |
|
SELECT * FROM tversandart WHERE `kVersandart`=?70μs16.98KB10000000000002e0e0000000000000000default| Params |
|
SELECT * FROM tversandartsprache WHERE `kVersandart`=:kVersandart156μs16.3KB10000000000002e0e0000000000000000default| Params |
|
SELECT * FROM tversandartstaffel WHERE `kVersandart`=:kVersandart51μs16.2KB10000000000002e0e0000000000000000default| Params |
|
SELECT kVersandzuschlag
FROM tversandzuschlag
WHERE kVersandart = :kVersandart
ORDER BY kVersandzuschlag DESC167μs16.24KB00000000000002e0e0000000000000000default| Params |
|
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache55μs16.13KB30000000000002e100000000000000000defaultSELECT cSeo, kSprache
FROM tseo
WHERE cKey = :key
AND kKey = :id63μs16.22KB10000000000002e1b0000000000000000default| Params |
|
SELECT kStueckliste AS id, fLagerbestand AS stock
FROM tartikel
WHERE kArtikel = :pid58μs16.22KB10000000000002e0e0000000000000000default| Params |
|
SELECT tartikel.kArtikel, tartikel.kHersteller, tartikel.kLieferstatus, tartikel.kSteuerklasse,
tartikel.kEinheit, tartikel.kVPEEinheit, tartikel.kVersandklasse, tartikel.kEigenschaftKombi,
tartikel.kVaterArtikel, tartikel.kStueckliste, tartikel.kWarengruppe,
tartikel.cArtNr, tartikel.cName, tartikel.cBeschreibung, tartikel.cAnmerkung, tartikel.fLagerbestand, tartikel.fMwSt, tartikel.cSeo AS originalSeo,
IF (tartikelabnahme.fMindestabnahme IS NOT NULL,
tartikelabnahme.fMindestabnahme, tartikel.fMindestbestellmenge) AS fMindestbestellmenge,
IF (tartikelabnahme.fIntervall IS NOT NULL,
tartikelabnahme.fIntervall, tartikel.fAbnahmeintervall) AS fAbnahmeintervall,
tartikel.cBarcode, tartikel.cTopArtikel,
tartikel.fGewicht, tartikel.fArtikelgewicht, tartikel.cNeu, tartikel.cKurzBeschreibung, tartikel.fUVP,
tartikel.cLagerBeachten, tartikel.cLagerKleinerNull, tartikel.cLagerVariation, tartikel.cTeilbar,
tartikel.fPackeinheit, tartikel.cVPE, tartikel.fVPEWert, tartikel.cVPEEinheit, tartikel.cSuchbegriffe,
tartikel.nSort, tartikel.dErscheinungsdatum, tartikel.dErstellt, tartikel.dLetzteAktualisierung,
tartikel.cSerie, tartikel.cISBN, tartikel.cASIN, tartikel.cHAN, tartikel.cUNNummer, tartikel.cGefahrnr,
tartikel.nIstVater, date_format(tartikel.dErscheinungsdatum, '%d.%m.%Y') AS Erscheinungsdatum_de,
tartikel.cTaric, tartikel.cUPC, tartikel.cHerkunftsland, tartikel.cEPID, tartikel.fZulauf,
tartikel.dZulaufDatum, DATE_FORMAT(tartikel.dZulaufDatum, '%d.%m.%Y') AS dZulaufDatum_de,
tartikel.fLieferantenlagerbestand, tartikel.fLieferzeit,
tartikel.dMHD, DATE_FORMAT(tartikel.dMHD, '%d.%m.%Y') AS dMHD_de,
tartikel.kMassEinheit, tartikel.kGrundPreisEinheit, tartikel.fMassMenge, tartikel.fGrundpreisMenge,
tartikel.fBreite, tartikel.fHoehe, tartikel.fLaenge, tartikel.nLiefertageWennAusverkauft,
tartikel.nAutomatischeLiefertageberechnung, tartikel.nBearbeitungszeit, me.cCode AS cMasseinheitCode,
mes.cName AS cMasseinheitName, gpme.cCode AS cGrundpreisEinheitCode,
gpmes.cName AS cGrundpreisEinheitName,
tseo.cSeo,
tsonderpreise.fNettoPreis, tartikelext.fDurchschnittsBewertung,
tlieferstatus.cName AS cName_tlieferstatus, teinheit.cName AS teinheitcName,
tartikelsonderpreis.cAktiv AS cAktivSonderpreis, tartikelsonderpreis.dStart AS dStart_en,
DATE_FORMAT(tartikelsonderpreis.dStart, '%d.%m.%Y') AS dStart_de,
tartikelsonderpreis.dEnde AS dEnde_en,
DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de,
tversandklasse.cName AS cVersandklasse,
tbestseller.isBestseller AS bIsBestseller,
ROUND(tartikelext.fDurchschnittsBewertung) >= :trmr AS bIsTopBewertet,
COALESCE((SELECT 1 FROM tuploadschema ULS WHERE ULS.kCustomID = :pid LIMIT 1), 0) AS hasUploads
FROM tartikel
LEFT JOIN tartikelabnahme
ON tartikel.kArtikel = tartikelabnahme.kArtikel
AND tartikelabnahme.kKundengruppe = :cgid
LEFT JOIN tartikelsonderpreis
ON tartikelsonderpreis.kArtikel = tartikel.kArtikel
AND tartikelsonderpreis.cAktiv = 'Y'
AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand OR tartikelsonderpreis.nIstAnzahl = 0)
LEFT JOIN tsonderpreise ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis
AND tsonderpreise.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kArtikel' AND tseo.kKey = tartikel.kArtikel
AND tseo.kSprache = :lid
LEFT JOIN tbestseller
ON tbestseller.kArtikel = tartikel.kArtikel
LEFT JOIN tartikelext
ON tartikelext.kArtikel = tartikel.kArtikel
LEFT JOIN tlieferstatus
ON tlieferstatus.kLieferstatus = tartikel.kLieferstatus
AND tlieferstatus.kSprache = :lid
LEFT JOIN teinheit
ON teinheit.kEinheit = tartikel.kEinheit
AND teinheit.kSprache = :lid
LEFT JOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tversandklasse
ON tversandklasse.kVersandklasse = tartikel.kVersandklasse
LEFT JOIN tmasseinheit me ON me.kMassEinheit = tartikel.kMassEinheit
LEFT JOIN tmasseinheitsprache mes
ON mes.kMassEinheit = me.kMassEinheit
AND mes.kSprache = :lid
LEFT JOIN tmasseinheit gpme
ON gpme.kMassEinheit = tartikel.kGrundpreisEinheit
LEFT JOIN tmasseinheitsprache gpmes
ON gpmes.kMassEinheit = gpme.kMassEinheit
AND gpmes.kSprache = :lid
WHERE tartikel.kArtikel = :pid AND tartikelsichtbarkeit.kArtikel IS NULL AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')527μs42.52KB10000000000002e1a0000000000000000default| Params |
|
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFT JOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFT JOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = 'kHersteller'
AND tseo.kSprache = therstellersprache.kSprache
WHERE thersteller.kHersteller = :manfID
AND thersteller.nAktiv = 1
GROUP BY kSprache, thersteller.kHersteller317μs17.33KB10000000000002e1d0000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_manufacturer WHERE `herstellerId`=? AND `languageId`=?71μs16.77KB00000000000002e200000000000000000default| Params |
|
SELECT kPreis, noDiscount, kKunde
FROM tpreis AS p
WHERE kArtikel = :pid AND kKundengruppe = :cgid84μs16.25KB10000000000002e220000000000000000default| Params |
|
SELECT kSteuerklasse, fMwSt
FROM tartikel
WHERE kArtikel = :pid46μs16.19KB10000000000002e220000000000000000default| Params |
|
SELECT nAnzahlAb, fVKNetto
FROM tpreisdetail
WHERE kPreis = :priceID
ORDER BY nAnzahlAb71μs16.25KB10000000000002e220000000000000000default| Params |
|
SELECT tsonderpreise.fNettoPreis, tartikelsonderpreis.dEnde AS dEnde_en,
DATE_FORMAT(tartikelsonderpreis.dEnde, '%d.%m.%Y') AS dEnde_de
FROM tsonderpreise
JOIN tartikel
ON tartikel.kArtikel = :productID
JOIN tartikelsonderpreis
ON tartikelsonderpreis.kArtikelSonderpreis = tsonderpreise.kArtikelSonderpreis
AND tartikelsonderpreis.kArtikel = :productID
AND tartikelsonderpreis.cAktiv = 'Y'
AND tartikelsonderpreis.dStart <= CURDATE()
AND (tartikelsonderpreis.dEnde IS NULL OR tartikelsonderpreis.dEnde >= CURDATE())
AND (tartikelsonderpreis.nAnzahl <= tartikel.fLagerbestand
OR tartikelsonderpreis.nIstAnzahl = 0)
WHERE tsonderpreise.kKundengruppe = :customerGroup142μs17.08KB00000000000002e200000000000000000default| Params |
|
SELECT tartikel.kArtikel, tartikel.nIstVater, COALESCE(teigenschaft.kArtikel, 0) AS kArtikelVariation,
tartikel.kSteuerklasse, tartikel.fLagerbestand,
tartikel.fStandardpreisNetto fNettoPreis,
tartikelkonfiggruppe.kKonfiggruppe g1, tkonfigitem.kKonfiggruppe g2
FROM tartikel
LEFT JOIN tartikelkonfiggruppe
ON tartikelkonfiggruppe.kArtikel = tartikel.kArtikel
LEFT JOIN tkonfigitem
ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe
LEFT JOIN teigenschaft
ON teigenschaft.kArtikel = tartikel.kArtikel
WHERE tartikel.kArtikel = :pid107μs16.95KB10000000000002e270000000000000000default| Params |
|
SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut67μs16.33KB100000000000002e250000000000000000default| Params |
|
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort60μs16.25KB00000000000002e310000000000000000default| Params |
|
SELECT cPfad, nNr
FROM tartikelpict
WHERE kArtikel = :pid
ORDER BY nNr56μs16.22KB10000000000002e310000000000000000default| Params |
|
SELECT tartikelwarenlager.*
FROM tartikelwarenlager
JOIN twarenlager
ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1
WHERE tartikelwarenlager.kArtikel = :productID72μs16.44KB00000000000002e2e0000000000000000default| Params |
|
SELECT tartikelmerkmal.kMerkmal, tartikelmerkmal.kMerkmalWert
FROM tartikelmerkmal
JOIN tmerkmal
ON tmerkmal.kMerkmal = tartikelmerkmal.kMerkmal
JOIN tmerkmalwert
ON tmerkmalwert.kMerkmalWert = tartikelmerkmal.kMerkmalWert
WHERE tartikelmerkmal.kArtikel = :kArtikel
ORDER BY tmerkmal.nSort, tmerkmalwert.nSort, tartikelmerkmal.kMerkmal90μs16.55KB00000000000002e2e0000000000000000default| Params |
|
SELECT tkategorieartikel.kKategorie
FROM tkategorieartikel
LEFT JOIN tkategoriesichtbarkeit
ON tkategoriesichtbarkeit.kKategorie = tkategorieartikel.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
JOIN tkategorie
ON tkategorie.kKategorie = tkategorieartikel.kKategorie
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
AND tkategorieartikel.kKategorie > 0
AND tkategorieartikel.kArtikel = :pid103μs16.66KB10000000000002e360000000000000000default| Params |
|
SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar,
teigenschaft.cTyp, teigenschaft.nSort,
teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert,
teigenschaftwert.fAufpreisNetto, teigenschaftwert.fGewichtDiff, teigenschaftwert.cArtNr,
teigenschaftwert.nSort AS teigenschaftwert_nSort, teigenschaftwert.fLagerbestand,
teigenschaftwert.fPackeinheit, teigenschaftwertpict.kEigenschaftWertPict,
teigenschaftwertpict.cPfad, NULL AS cType,
teigenschaftwertaufpreis.fAufpreisNetto AS fAufpreisNetto_teigenschaftwertaufpreis
FROM teigenschaft
LEFT JOIN teigenschaftwert
ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
LEFT JOIN teigenschaftsichtbarkeit
ON teigenschaft.kEigenschaft = teigenschaftsichtbarkeit.kEigenschaft
AND teigenschaftsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN teigenschaftwertsichtbarkeit
ON teigenschaftwert.kEigenschaftWert = teigenschaftwertsichtbarkeit.kEigenschaftWert
AND teigenschaftwertsichtbarkeit.kKundengruppe = :cgid
LEFT JOIN teigenschaftwertpict
ON teigenschaftwertpict.kEigenschaftWert = teigenschaftwert.kEigenschaftWert
LEFT JOIN teigenschaftwertaufpreis
ON teigenschaftwertaufpreis.kEigenschaftWert = teigenschaftwert.kEigenschaftWert
AND teigenschaftwertaufpreis.kKundengruppe = :cgid
WHERE teigenschaft.kArtikel = :pid
AND teigenschaftsichtbarkeit.kEigenschaft IS NULL
AND teigenschaftwertsichtbarkeit.kEigenschaftWert IS NULL
ORDER BY teigenschaft.nSort ASC, teigenschaft.cName,
teigenschaftwert.nSort ASC, teigenschaftwert.cName170μs19.06KB00000000000002e380000000000000000default| Params |
|
SELECT va.kVersandart, IF(vas.fPreis IS NOT NULL, vas.fPreis, va.fPreis) AS minPrice, va.nSort
FROM tversandart va
LEFT JOIN tversandartstaffel vas
ON vas.kVersandart = va.kVersandart
WHERE cIgnoreShippingProposal != 'Y'
AND va.cLaender LIKE :ccode
AND (va.cVersandklassen = '-1'
OR va.cVersandklassen RLIKE :sclass)
AND (va.cKundengruppen = '-1'
OR FIND_IN_SET(:cgid, REPLACE(va.cKundengruppen, ';', ',')) > 0)
AND va.kVersandart NOT IN (
SELECT vaza.kVersandart
FROM tversandartzahlungsart vaza
WHERE kZahlungsart = 6)
AND (
va.kVersandberechnung = 1
OR va.kVersandberechnung = 4
OR ( va.kVersandberechnung = 2 AND vas.fBis > 0 AND :wght <= vas.fBis )
OR ( va.kVersandberechnung = 3
AND vas.fBis = (
SELECT MIN(fBis)
FROM tversandartstaffel
WHERE fBis > :net
AND tversandartstaffel.kVersandart = va.kVersandart
)
)
) AND va.cNurAbhaengigeVersandart = 'N'
ORDER BY minPrice, nSort ASC LIMIT 1238μs17.59KB10000000000002e2e0000000000000000default| Params |
|
SELECT * FROM tversandart WHERE `kVersandart`=?63μs16.98KB10000000000002e3b0000000000000000default| Params |
|
SELECT * FROM tversandartsprache WHERE `kVersandart`=:kVersandart50μs16.3KB10000000000002e3b0000000000000000default| Params |
|
SELECT * FROM tversandartstaffel WHERE `kVersandart`=:kVersandart47μs16.2KB10000000000002e3b0000000000000000default| Params |
|
SELECT kVersandzuschlag
FROM tversandzuschlag
WHERE kVersandart = :kVersandart
ORDER BY kVersandzuschlag DESC46μs16.24KB00000000000002e3b0000000000000000default| Params |
|
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache49μs16.13KB30000000000002e3d0000000000000000defaultSELECT cSeo, kSprache
FROM tseo
WHERE cKey = :key
AND kKey = :id101μs16.22KB10000000000002e480000000000000000default| Params |
|
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 NULL254μs18.39KB10000000000002e4b0000000000000000default| Params |
|
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.nSort357μs17.03KB20000000000002e4b0000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?85μs16.82KB10000000000002e510000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?58μs16.8KB00000000000002e510000000000000000default| Params |
|
SELECT * FROM tfirma LIMIT 150μs16.52KB10000000000002e510000000000000000defaultSELECT * 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 nSort96μs16.88KB00000000000002e4b0000000000000000default| Params |
|
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 (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
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.cName472μs18.83KB10000000000002e6e0000000000000000default| Params |
|
SELECT child.kKategorie
FROM tkategorie
LEFT JOIN tkategorie parent
ON tkategorie.kOberKategorie = parent.kKategorie
LEFT JOIN tkategorie child
ON tkategorie.lft <= child.lft
AND tkategorie.rght >= child.rght
WHERE tkategorie.kOberKategorie > 0
AND parent.kKategorie IS NULL107μs16.02KB00000000000002e720000000000000000defaultSELECT tartikel.kArtikel AS productID, tartikelattribut.cWert AS productValue
FROM tartikel
JOIN tartikelattribut
ON tartikelattribut.kArtikel = tartikel.kArtikel
AND tartikelattribut.cWert >= 0
LEFT JOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
WHERE tartikelsichtbarkeit.kArtikel IS NULL
AND tartikel.nIstVater = 0
AND tartikelattribut.cName = :attr
AND (tartikel.fLagerbestand > 0
OR tartikel.cLagerBeachten = :no
OR tartikel.cLagerKleinerNull = :yes)781μs16.92KB00000000000002e810000000000000000default| Params |
|
SELECT * FROM tfirma LIMIT 153μs16.52KB10000000000002e8d0000000000000000defaultSELECT 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 DESC112μs16.75KB110000000000002ea50000000000000000default| Params |
|
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache72μs16.13KB30000000000002ec10000000000000000defaultSELECT * FROM tbesucherbot ORDER BY kBesucherBot DESC640μs40.16KB4990000000000002ecd0000000000000000defaultINSERT 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)2.93ms688B30000000000002ecc0000000000000000default| Params |
|
DELETE FROM tbesucher
WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)589μs128B30000000000002ecc0000000000000000default| Params |
|
SELECT * FROM tbesucher WHERE `cSessID`=?68μs16.91KB00000000000002ecc0000000000000000default| Params |
|
SELECT * FROM tbesucher WHERE `cID`=?49μs16.91KB00000000000002ecc0000000000000000default| Params |
|
INSERT INTO tbesucher (`kBesucher`, `cIP`, `cSessID`, `cID`, `kKunde`, `kBestellung`, `cEinstiegsseite`, `cReferer`, `cUserAgent`, `cBrowser`, `cAusstiegsseite`, `dLetzteAktivitaet`, `dZeit`, `kBesucherBot`) VALUES (:kBesucher, :cIP, :cSessID, :cID, :kKunde, :kBestellung, :cEinstiegsseite, :cReferer, :cUserAgent, :cBrowser, :cAusstiegsseite, :dLetzteAktivitaet, :dZeit, :kBesucherBot)402μs3.2KB100000000000030be0000000000000000default| Params |
|
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv181μs16.38KB300000000000030be0000000000000000default| Params |
|
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 = '')188μs16.42KB000000000000030bb0000000000000000default| Params |
|
SELECT * FROM tboxenanzeige184μs17.33KB8000000000000030b70000000000000000defaultSELECT 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 ASC3.52ms16.72KB13000000000000303f0000000000000000defaultSELECT 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 10211μs16.02KB000000000000030340000000000000000defaultSELECT ssMerkmal.kSuchanfrage, ssMerkmal.kSuchCache, ssMerkmal.cSuche, COUNT(*) AS nAnzahl
FROM (SELECT tsuchanfrage.kSuchanfrage, tsuchcache.kSuchCache, tsuchanfrage.cSuche, tartikel.kArtikel
FROM tartikel
#JOIN from JTL\Filter\States\BaseCategory::getSQLJoin
JOIN tkategorieartikel ON tartikel.kArtikel = tkategorieartikel.kArtikel
#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 tkategorieartikel.kKategorie IN (
SELECT tchild.kKategorie FROM tkategorie AS tparent
JOIN tkategorie AS tchild
ON tchild.lft BETWEEN tparent.lft AND tparent.rght
WHERE tparent.kKategorie = 33) AND tsuchanfrage.nAktiv = 1 AND tartikelsichtbarkeit.kArtikel IS NULL AND tartikel.kVaterArtikel = 0 AND (tartikel.cLagerBeachten != 'Y'
OR tartikel.fLagerbestand > 0
OR (tartikel.cLagerVariation = 'Y'
AND (
SELECT MAX(teigenschaftwert.fLagerbestand)
FROM teigenschaft
INNER JOIN teigenschaftwert ON teigenschaftwert.kEigenschaft = teigenschaft.kEigenschaft
WHERE teigenschaft.kArtikel = tartikel.kArtikel
) > 0
) OR tartikel.cLagerKleinerNull = 'Y')
#default group by
GROUP BY tsuchanfrage.kSuchanfrage, tartikel.kArtikel
#limit sql
ORDER BY tartikel.dErstellt DESC, tartikel.cName) AS ssMerkmal
GROUP BY ssMerkmal.kSuchanfrage
ORDER BY ssMerkmal.cSuche568μs16.09KB000000000000030340000000000000000defaultSELECT kPlugin, cPluginID, bExtension FROM tplugin57μs16.17KB600000000000030220000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?63μs17.24KB1000000000000301a0000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort68μs16.27KB100000000000030420000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin50μs16.26KB100000000000030440000000000000000default| Params |
|
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.kLink97μs16.4KB0000000000000306f0000000000000000default| Params |
|
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.nSort289μs17.19KB000000000000030450000000000000000default| Params |
|
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.kPluginSprachvariable270μs16.81KB000000000000030730000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin69μs16.39KB100000000000030750000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id88μs16.84KB000000000000030780000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid91μs16.94KB000000000000030790000000000000000default| Params |
|
SELECT kPlugin, cPluginID, bExtension FROM tplugin42μs16.17KB600000000000030200000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?55μs17.27KB1000000000000307c0000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 158μs16.15KB1000000000000308d0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?62μs17.27KB100000000000030150000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?58μs17.27KB100000000000030030000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?56μs17.27KB10000000000002ff20000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?56μs17.27KB10000000000002fe10000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000002fcf0000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort62μs16.28KB100000000000030830000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin46μs16.26KB100000000000030880000000000000000default| Params |
|
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.kLink90μs16.4KB000000000000030870000000000000000default| Params |
|
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.nSort272μs17.19KB0000000000000304f0000000000000000default| Params |
|
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.kPluginSprachvariable276μs16.84KB20000000000002fdf0000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin68μs16.39KB10000000000002fcf0000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id83μs16.84KB00000000000002fd90000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid79μs16.94KB00000000000002fd70000000000000000default| Params |
|
SELECT kPlugin, cPluginID, bExtension FROM tplugin44μs16.17KB6000000000000301d0000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?55μs17.27KB10000000000002fdc0000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 154μs16.15KB100000000000030090000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?60μs17.27KB100000000000030950000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000002fc70000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?57μs17.27KB10000000000002fb60000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000002fa50000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?54μs17.27KB10000000000002f930000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort63μs16.3KB20000000000002feb0000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin46μs16.26KB10000000000002fe90000000000000000default| Params |
|
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.kLink89μs16.4KB00000000000002fe80000000000000000default| Params |
|
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.nSort447μs17.38KB120000000000002fe70000000000000000default| Params |
|
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.kPluginSprachvariable259μs16.81KB00000000000002fa20000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin65μs16.38KB00000000000002f9b0000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id83μs16.84KB00000000000002f9e0000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid79μs16.94KB00000000000002f980000000000000000default| Params |
|
SELECT kPlugin, cPluginID, bExtension FROM tplugin47μs16.17KB6000000000000301c0000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?54μs17.27KB10000000000002fc20000000000000000default| Params |
|
SELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 154μs16.15KB100000000000030590000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?61μs17.27KB10000000000002f8d0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?56μs17.27KB10000000000002f7b0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?57μs17.27KB10000000000002f6a0000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000002f590000000000000000default| Params |
|
SELECT * FROM tplugin WHERE `exsID`=?55μs17.27KB10000000000002f470000000000000000default| Params |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort64μs16.36KB600000000000030550000000000000000default| Params |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin45μs16.3KB40000000000002fcb0000000000000000default| Params |
|
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.kLink106μs16.46KB40000000000002f480000000000000000default| Params |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (119,120,121,122)61μs16.14KB40000000000002f4f0000000000000000defaultSELECT 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 (119,120,121,122)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName746μs17KB80000000000002f5a0000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid54μs16.12KB10000000000002f660000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB00000000000002f790000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid37μs16.12KB10000000000002f6b0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002f6c0000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid35μs16.12KB10000000000002f6d0000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002f730000000000000000default| Params |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid34μs16.12KB10000000000002f700000000000000000default| Params |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink38μs16.12KB00000000000002f780000000000000000default| Params |
|
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.nSort581μs17.44KB15000000000000308f0000000000000000default| Params |
|
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.kPluginSprachvariable499μs34.56KB1000000000000002f530000000000000000default| Params |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin65μs16.38KB00000000000002f290000000000000000default| Params |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id95μs16.91KB40000000000002f2c0000000000000000default| Params |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid89μs17.02KB50000000000002f310000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort76μs16.55KB30000000000002f310000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart57μs16.33KB20000000000002f310000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort70μs16.55KB30000000000002f310000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart52μs16.33KB20000000000002f310000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort69μs16.55KB30000000000002f310000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart51μs16.33KB20000000000002f310000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort76μs16.55KB30000000000002f310000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart58μs16.33KB20000000000002f310000000000000000default| Params |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort68μs16.55KB30000000000002f310000000000000000default| Params |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart50μs16.33KB20000000000002f310000000000000000default| Params |
|
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL284μs18.39KB100000000000031380000000000000000default| Params |
|
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.nSort317μs17KB000000000000031380000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?97μs16.82KB1000000000000313a0000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?72μs16.8KB0000000000000313a0000000000000000default| Params |
|
SELECT tkategorie.kKategorie, tkategorie.kOberKategorie,
tkategorie.nSort, tkategorie.dLetzteAktualisierung,
tkategoriepict.cPfad,
atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght,
COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo,
COALESCE(tkategoriesprache.cName, tkategorie.cName) cName,
COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung,
COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription,
COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords,
COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag,
tsprache.kSprache
FROM tkategorie
JOIN tsprache
ON tsprache.active = 1
LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie
AND tkategoriesichtbarkeit.kKundengruppe = :cgid
LEFT JOIN tseo ON tseo.cKey = 'kKategorie'
AND tseo.kKey = :kid
AND tseo.kSprache = tsprache.kSprache
LEFT JOIN tkategoriesprache
ON tkategoriesprache.kKategorie = tkategorie.kKategorie
AND tkategoriesprache.kSprache = tseo.kSprache
AND tkategoriesprache.kSprache = tsprache.kSprache
LEFT JOIN tkategoriepict
ON tkategoriepict.kKategorie = tkategorie.kKategorie
LEFT JOIN tkategorieattribut atr
ON atr.kKategorie = tkategorie.kKategorie
AND atr.cName = 'bildname'
WHERE tkategorie.kKategorie = :kid
AND tkategoriesichtbarkeit.kKategorie IS NULL190μs18.39KB1000000000000313d0000000000000000default| Params |
|
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.nSort314μs17.03KB2000000000000313d0000000000000000default| Params |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.82KB100000000000031680000000000000000default| Params |
|
SELECT * FROM xplugin_salepix_templater_builder_category WHERE `categoryId`=? AND `languageId`=?54μs16.8KB000000000000031680000000000000000default| Params |
|