1 x Shop start to end (90.96%) | 299ms |
1 x shop.hook.156 (5.24%) | 17.20ms |
1 x shop.hook.320 (0.62%) | 2.05ms |
1 x shop.hook.131 (0.14%) | 446μs |
1 x shop.hook.99 (0.07%) | 234μs |
2 x shop.hook.208 (0.07%) | 217μs |
1 x shop.hook.133 (0.06%) | 197μs |
1 x shop.hook.400 (0.06%) | 190μs |
36 x shop.hook.104 (0.03%) | 101μs |
14 x shop.hook.221 (0.02%) | 64μs |
22 x shop.hook.330 (0.02%) | 57μs |
6 x shop.hook.118 (0.01%) | 43μs |
14 x shop.hook.301 (0.01%) | 36μs |
14 x shop.hook.300 (0.01%) | 30μs |
6 x shop.hook.219 (0.01%) | 17μs |
3 x shop.hook.321 (0%) | 14μs |
1 x shop.hook.214 (0%) | 13μs |
2 x shop.hook.250 (0%) | 12μs |
4 x shop.hook.60 (0%) | 12μs |
3 x shop.hook.103 (0%) | 11μs |
2 x shop.hook.303 (0%) | 10μs |
3 x shop.hook.260 (0%) | 10μs |
3 x shop.hook.120 (0%) | 9μs |
2 x shop.hook.251 (0%) | 7μs |
2 x shop.hook.69 (0%) | 7μs |
2 x shop.hook.254 (0%) | 6μs |
2 x shop.hook.252 (0%) | 6μs |
3 x shop.hook.110 (0%) | 6μs |
1 x shop.hook.132 (0%) | 6μs |
3 x shop.hook.59 (0%) | 6μs |
1 x shop.hook.113 (0%) | 6μs |
1 x shop.hook.226 (0%) | 6μs |
3 x shop.hook.58 (0%) | 5μs |
1 x shop.hook.143 (0%) | 5μs |
1 x shop.hook.109 (0%) | 5μs |
1 x shop.hook.361 (0%) | 4μs |
1 x shop.hook.142 (0%) | 4μs |
1 x shop.hook.166 (0%) | 4μs |
1 x shop.hook.115 (0%) | 4μs |
1 x shop.hook.204 (0%) | 4μs |
1 x shop.hook.101 (0%) | 4μs |
1 x shop.hook.114 (0%) | 3μs |
1 x shop.hook.72 (0%) | 3μs |
1 x shop.hook.70 (0%) | 3μs |
1 x shop.hook.57 (0%) | 2μs |
1 x shop.hook.331 (0%) | 2μs |
1 x shop.hook.175 (0%) | 2μs |
SELECT * FROM tsprache
158μs16.28KB600000000000000750000000000000000defaultSELECT 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'
283μs16.73KB1000000000000007c0000000000000000defaultParams |
|
SELECT * FROM tsprache
113μs16.28KB6000000000000017d0000000000000000defaultSELECT * FROM twaehrung
108μs16.31KB6000000000000017d0000000000000000defaultSELECT * FROM tsprache WHERE `cShopStandard`=?
107μs16.73KB1000000000000023d0000000000000000defaultParams |
|
SELECT * FROM tglobals
106μs16.06KB1000000000000023d0000000000000000defaultSELECT * FROM tsprache
97μs16.28KB600000000000002410000000000000000defaultSELECT * FROM twaehrung
102μs16.31KB600000000000000470000000000000000defaultSELECT 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'
193μs16.73KB100000000000000490000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
161μs17.23KB1000000000000023f0000000000000000defaultParams |
|
SELECT * FROM twaehrung
136μs16.31KB600000000000037ac0000000000000000defaultSELECT * FROM tsprache
85μs16.28KB600000000000037c90000000000000000defaultSELECT * FROM twaehrung
142μs16.31KB600000000000037ec0000000000000000defaultSELECT tsteuerzone.kSteuerzone
FROM tsteuerzone, tsteuerzoneland
WHERE tsteuerzoneland.cISO = :ciso
AND tsteuerzoneland.kSteuerzone = tsteuerzone.kSteuerzone
156μs16.29KB100000000000038c00000000000000000defaultParams |
|
SELECT * FROM tsteuerklasse
132μs16.11KB200000000000038ac0000000000000000defaultSELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (7)) ORDER BY nPrio DESC
169μs16.26KB100000000000038ac0000000000000000defaultParams |
|
SELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (7)) ORDER BY nPrio DESC
118μs16.26KB100000000000038ac0000000000000000defaultParams |
|
SELECT 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.kKundengruppe = :id
411μs16.73KB100000000000038c60000000000000000defaultParams |
|
SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe
131μs16.25KB0000000000000004a0000000000000000defaultParams |
|
SELECT tsteuerzone.kSteuerzone
FROM tsteuerzone, tsteuerzoneland
WHERE tsteuerzoneland.cISO = :ciso
AND tsteuerzoneland.kSteuerzone = tsteuerzone.kSteuerzone
326μs16.29KB100000000000037aa0000000000000000defaultParams |
|
SELECT * FROM tsteuerklasse
78μs16.11KB2000000000000389a0000000000000000defaultSELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (7)) ORDER BY nPrio DESC
172μs16.26KB1000000000000389a0000000000000000defaultParams |
|
SELECT fSteuersatz
FROM tsteuersatz
WHERE kSteuerklasse = :tcid
AND (kSteuerzone IN (7)) ORDER BY nPrio DESC
168μs16.26KB1000000000000389a0000000000000000defaultParams |
|
SELECT * FROM ttemplate WHERE `eTyp`=?
289μs16.85KB100000000000035d90000000000000000defaultParams |
|
SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate
1.48ms17.44KB6900000000000035d40000000000000000defaultParams |
|
SELECT * FROM tconsent WHERE `active`=:active
306μs16.3KB40000000000003c110000000000000000defaultParams |
|
SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID
381μs16.31KB20000000000003c2b0000000000000000defaultParams |
|
SELECT * FROM tsprache
86μs16.28KB60000000000003c2b0000000000000000defaultSELECT * FROM tconsentlocalization WHERE `consentID`=:consentID
118μs16.31KB20000000000003c330000000000000000defaultParams |
|
SELECT * FROM tsprache
79μs16.28KB60000000000003c330000000000000000defaultSELECT * FROM tconsentlocalization WHERE `consentID`=:consentID
98μs16.36KB50000000000003c490000000000000000defaultParams |
|
SELECT * FROM tsprache
75μs16.28KB60000000000003c490000000000000000defaultSELECT * FROM tconsentlocalization WHERE `consentID`=:consentID
111μs16.38KB60000000000003c4d0000000000000000defaultParams |
|
SELECT * FROM tsprache
90μs16.28KB60000000000003c4d0000000000000000defaultSELECT 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 = :pid
1.57ms18.09KB890000000000003c4d0000000000000000defaultParams |
|
SELECT *
FROM tseo
WHERE cSeo = :slg
436μs16.22KB10000000000003d260000000000000000defaultParams |
|
SELECT kEigenschaftKombi
FROM tartikel
WHERE kArtikel = :pid
384μs16.16KB10000000000003d260000000000000000defaultParams |
|
SELECT kVaterArtikel
FROM tartikel
WHERE kArtikel = :pid
121μs16.16KB10000000000003d250000000000000000defaultParams |
|
SELECT cBrocken
FROM tbrocken
LIMIT 1
284μs16.04KB10000000000003d350000000000000000defaultSELECT kStueckliste AS id, fLagerbestand AS stock
FROM tartikel
WHERE kArtikel = :pid
145μs16.22KB10000000000003d370000000000000000defaultParams |
|
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,
tartikelsprache.cName AS cName_spr, tartikelsprache.cBeschreibung AS cBeschreibung_spr,
tartikelsprache.cKurzBeschreibung AS cKurzBeschreibung_spr,
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 tartikelsprache
ON tartikelsprache.kArtikel = :pid
AND tartikelsprache.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
950μs42.52KB10000000000003d390000000000000000defaultParams |
|
SELECT cName
FROM teinheit
WHERE kEinheit = (SELECT kEinheit
FROM teinheit
WHERE cName = :vpe LIMIT 0, 1)
AND kSprache = :lid LIMIT 0, 1
152μs16.4KB00000000000003d390000000000000000defaultParams |
|
SELECT * FROM ttrennzeichen WHERE `nEinheit`=? AND `kSprache`=?
400μs16.79KB10000000000003d3c0000000000000000defaultParams |
|
SELECT txsell.*, txsellgruppe.cName, txsellgruppe.cBeschreibung
FROM txsell
JOIN tartikel
ON txsell.kXSellArtikel = tartikel.kArtikel
LEFT JOIN txsellgruppe
ON txsellgruppe.kXSellGruppe = txsell.kXSellGruppe
AND txsellgruppe.kSprache = :lid
WHERE txsell.kArtikel = :aid
ORDER BY tartikel.cName
197μs16.69KB00000000000003d400000000000000000defaultParams |
|
SELECT 1 AS hasData FROM cross_selling_view LIMIT 1
97μs16.02KB00000000000003d420000000000000000defaultSELECT kXSellArtikel
FROM txsellkauf
WHERE kArtikel = :pid
ORDER BY nAnzahl DESC
LIMIT :lmt
124μs16.21KB00000000000003d440000000000000000defaultParams |
|
SELECT tartikelmerkmal.kArtikel, tartikel.kVaterArtikel
FROM tartikelmerkmal
JOIN tartikel
ON tartikel.kArtikel = tartikelmerkmal.kArtikel
AND tartikel.kVaterArtikel != :kArtikel
AND (tartikel.nIstVater = 1 OR tartikel.kEigenschaftKombi = 0)
JOIN tartikelmerkmal similarMerkmal
ON similarMerkmal.kArtikel = :kArtikel
AND similarMerkmal.kMerkmal = tartikelmerkmal.kMerkmal
AND similarMerkmal.kMerkmalWert = tartikelmerkmal.kMerkmalWert
LEFT JOIN tartikelsichtbarkeit
ON tartikelsichtbarkeit.kArtikel = tartikel.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :customerGroupID
WHERE tartikelsichtbarkeit.kArtikel IS NULL
AND tartikelmerkmal.kArtikel != :kArtikel
GROUP BY tartikelmerkmal.kArtikel
ORDER BY COUNT(tartikelmerkmal.kMerkmal) DESC
LIMIT :lmt
298μs17.3KB00000000000003d400000000000000000defaultParams |
|
SELECT tsuchcachetreffer.kArtikel, tartikel.kVaterArtikel
FROM
(
SELECT kSuchCache
FROM tsuchcachetreffer
WHERE kArtikel = :pid
AND nSort <= 10
) AS ssSuchCache
JOIN tsuchcachetreffer
ON tsuchcachetreffer.kSuchCache = ssSuchCache.kSuchCache
AND tsuchcachetreffer.kArtikel != :pid
LEFT JOIN tartikelsichtbarkeit
ON tsuchcachetreffer.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
JOIN tartikel
ON tartikel.kArtikel = tsuchcachetreffer.kArtikel
AND tartikel.kVaterArtikel != :pid
WHERE tartikelsichtbarkeit.kArtikel IS NULL
GROUP BY tsuchcachetreffer.kArtikel
ORDER BY COUNT(*) DESC
LIMIT :lmt
257μs17.3KB00000000000003d400000000000000000defaultParams |
|
SELECT kSuchspecialOverlay
FROM tsuchspecialoverlay
259μs16.18KB90000000000003d4c0000000000000000defaultSELECT 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 1
324μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
184μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
180μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
183μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
186μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
129μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
124μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
119μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
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 1
116μs16.95KB10000000000003d4c0000000000000000defaultParams |
|
SELECT kPreis, noDiscount, kKunde
FROM tpreis AS p
WHERE kArtikel = :pid AND kKundengruppe = :cgid
398μs16.28KB10000000000003d480000000000000000defaultParams |
|
SELECT kSteuerklasse, fMwSt
FROM tartikel
WHERE kArtikel = :pid
74μs16.19KB10000000000003d480000000000000000defaultParams |
|
SELECT nAnzahlAb, fVKNetto
FROM tpreisdetail
WHERE kPreis = :priceID
ORDER BY nAnzahlAb
533μs16.25KB10000000000003d480000000000000000defaultParams |
|
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 = :customerGroup
178μs17.08KB00000000000003d460000000000000000defaultParams |
|
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 = :pid
203μs16.95KB10000000000003d600000000000000000defaultParams |
|
SELECT 1 AS cnt
FROM tartikelkategorierabatt
LIMIT 1
99μs16.02KB00000000000003d390000000000000000defaultSELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut
128μs16.17KB00000000000003d4a0000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort
133μs16.25KB00000000000003d4a0000000000000000defaultParams |
|
SELECT cPfad, nNr
FROM tartikelpict
WHERE kArtikel = :pid
ORDER BY nNr
596μs16.22KB10000000000003d4a0000000000000000defaultParams |
|
SELECT tartikelwarenlager.*
FROM tartikelwarenlager
JOIN twarenlager
ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1
WHERE tartikelwarenlager.kArtikel = :productID
141μs16.44KB00000000000003d640000000000000000defaultParams |
|
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.kMerkmal
170μs16.55KB00000000000003d640000000000000000defaultParams |
|
SELECT tmediendatei.kMedienDatei, tmediendatei.cPfad, tmediendatei.cURL, tmediendatei.cTyp,
tmediendatei.nSort, lang.cName, lang.cBeschreibung, lang.kSprache
FROM tmediendatei
LEFT JOIN tmediendateisprache AS lang
ON lang.kMedienDatei = tmediendatei.kMedienDatei
AND lang.kSprache = 1
WHERE tmediendatei.kArtikel = :pid
ORDER BY tmediendatei.nSort ASC
116μs16.81KB00000000000003d640000000000000000defaultParams |
|
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 = :pid
221μs16.66KB10000000000003dcc0000000000000000defaultParams |
|
SELECT teigenschaft.kEigenschaft, teigenschaft.kArtikel, teigenschaft.cName, teigenschaft.cWaehlbar,
teigenschaft.cTyp, teigenschaft.nSort, teigenschaftsprache.cName AS cName_teigenschaftsprache,
teigenschaftwert.kEigenschaftWert, teigenschaftwert.cName AS cName_teigenschaftwert, teigenschaftwertsprache.cName AS localizedName,
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 teigenschaftsprache
ON teigenschaftsprache.kEigenschaft = teigenschaft.kEigenschaft
AND teigenschaftsprache.kSprache = :lid
LEFT JOIN teigenschaftwertsprache
ON teigenschaftwertsprache.kEigenschaftWert = teigenschaftwert.kEigenschaftWert
AND teigenschaftwertsprache.kSprache = :lid
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.cName
328μs19.59KB00000000000003dce0000000000000000defaultParams |
|
SELECT * FROM tversandart
142μs16.5KB40000000000003d640000000000000000defaultSELECT *
FROM tversandart
WHERE fVersandkostenfreiAbX > 0
AND (cVersandklassen = '-1'
OR cVersandklassen RLIKE :sClasses)
AND (cKundengruppen = '-1' OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)
174μs16.81KB00000000000003d640000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?
91μs16.82KB00000000000003d640000000000000000defaultParams |
|
SELECT tartikeldownload.kDownload
FROM tartikeldownload
LEFT JOIN tdownload ON tartikeldownload.kDownload = tdownload.kDownload
WHERE kArtikel = :pid OR
tartikeldownload.kArtikel IN (
SELECT tstueckliste.kArtikel
FROM tstueckliste
LEFT JOIN tartikel
ON tstueckliste.kStueckliste = tartikel.kStueckliste
WHERE tartikel.kArtikel = :pid)
GROUP BY tartikeldownload.kDownload
ORDER BY tdownload.nSort, tdownload.dErstellt DESC
201μs16.77KB00000000000003d640000000000000000defaultParams |
|
SELECT tartikelkonfiggruppe.kKonfiggruppe
FROM tartikelkonfiggruppe
JOIN tkonfigitem
ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe
AND tartikelkonfiggruppe.kArtikel = :pid
92μs16.34KB00000000000003d640000000000000000defaultParams |
|
SELECT cName, kSprache, cWertName
FROM tglobalemetaangaben
ORDER BY kSprache
328μs16.33KB150000000000003dda0000000000000000defaultSELECT DISTINCT tbewertung.*,
DATE_FORMAT(dDatum, '%d.%m.%Y') AS Datum,
DATE_FORMAT(dAntwortDatum, '%d.%m.%Y') AS AntwortDatum,
tbewertunghilfreich.nBewertung AS rated,
IF(tbestellung.kKunde IS NOT NULL, 1, 0) AS wasPurchased
FROM tbewertung
LEFT JOIN tbewertunghilfreich
ON tbewertung.kBewertung = tbewertunghilfreich.kBewertung
AND tbewertunghilfreich.kKunde = :customerID
LEFT JOIN (
tbestellung
INNER JOIN twarenkorbpos ON tbestellung.kWarenkorb = twarenkorbpos.kWarenkorb
) ON tbestellung.kKunde = tbewertung.kKunde AND twarenkorbpos.kArtikel = tbewertung.kArtikel
WHERE tbewertung.kArtikel = :pid
AND tbewertung.nAktiv = 1
ORDER BY tbewertung.nHilfreich DESC
LIMIT 1
433μs17.88KB00000000000003def0000000000000000defaultParams |
|
SELECT COUNT(*) AS nAnzahl, nSterne
FROM tbewertung
WHERE kArtikel = :pid AND tbewertung.nAktiv = 1
GROUP BY nSterne
ORDER BY nSterne DESC
111μs16.3KB00000000000003ded0000000000000000defaultParams |
|
SELECT DISTINCT tbewertung.*,
DATE_FORMAT(dDatum, '%d.%m.%Y') AS Datum,
DATE_FORMAT(dAntwortDatum, '%d.%m.%Y') AS AntwortDatum,
tbewertunghilfreich.nBewertung AS rated,
IF(EXISTS (SELECT 1
FROM tbestellung
INNER JOIN twarenkorbpos ON tbestellung.kWarenkorb = twarenkorbpos.kWarenkorb
INNER JOIN tartikel ON twarenkorbpos.kArtikel = tartikel.kArtikel
WHERE tbestellung.kKunde = tbewertung.kKunde
AND tbewertung.kArtikel IN (tartikel.kArtikel,
tartikel.kVaterArtikel)), 1, 0) AS wasPurchased
FROM tbewertung
LEFT JOIN tbewertunghilfreich
ON tbewertung.kBewertung = tbewertunghilfreich.kBewertung
AND tbewertunghilfreich.kKunde = :customerID
WHERE tbewertung.kArtikel = :pid AND tbewertung.nAktiv = 1
ORDER BY tbewertung.dDatum DESC
371μs17.88KB00000000000003ded0000000000000000defaultParams |
|
SELECT COUNT(*) AS nAnzahl, tartikelext.fDurchschnittsBewertung AS fDurchschnitt
FROM tartikelext
JOIN tbewertung
ON tbewertung.kArtikel = tartikelext.kArtikel
WHERE tartikelext.kArtikel = :pid AND tbewertung.nAktiv = 1
GROUP BY tartikelext.kArtikel
103μs16.42KB00000000000003ded0000000000000000defaultParams |
|
SELECT COUNT(*) AS nAnzahlSprache
FROM tbewertung
WHERE kArtikel = :pid AND tbewertung.nAktiv = 1
77μs16.2KB10000000000003ded0000000000000000defaultParams |
|
SELECT cSeo, kSprache
FROM tseo
WHERE cKey = :key
AND kKey = :id
96μs16.22KB10000000000003de90000000000000000defaultParams |
|
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 NULL
1.2ms18.47KB6000000000000411d0000000000000000defaultParams |
|
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 = 2
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort
340μs16.13KB000000000000041250000000000000000defaultSELECT COUNT(kKategorie) AS cnt FROM tkategorie WHERE kKategorie > 0
117μs16.04KB100000000000041240000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
827μs18.16KB600000000000041240000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
152μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
118μs16.18KB000000000000041360000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
113μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
111μs16.18KB000000000000041380000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
112μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
98μs16.18KB0000000000000413a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
106μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
57μs16.18KB0000000000000413c0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
63μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
66μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
72μs16.18KB000000000000041330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
88μs16.18KB000000000000041400000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
67μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
59μs16.18KB000000000000041430000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
61μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
138μs16.18KB000000000000041450000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
125μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
115μs16.18KB000000000000041470000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
68μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
94μs16.18KB000000000000041490000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
63μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
92μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
92μs16.18KB0000000000000413e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
61μs16.18KB0000000000000414d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
61μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
61μs16.18KB000000000000041500000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
60μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
61μs16.18KB000000000000041520000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
118μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
100μs16.18KB000000000000041540000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
94μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
59μs16.18KB000000000000041560000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
66μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
92μs16.18KB000000000000041580000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
89μs16.18KB0000000000000414b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
64μs16.18KB0000000000000415a0000000000000000defaultParams |
|
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 = 4
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort
127μs16.13KB0000000000000412a0000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
576μs18.16KB6000000000000412a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
113μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
113μs16.18KB000000000000041650000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
90μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
88μs16.18KB000000000000041670000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
56μs16.18KB000000000000041690000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
111μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
108μs16.18KB0000000000000416b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
63μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
108μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
106μs16.18KB000000000000041620000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
110μs16.18KB0000000000000416f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
63μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
107μs16.18KB000000000000041720000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
60μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
57μs16.18KB000000000000041740000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
84μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
83μs16.18KB000000000000041760000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
84μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
90μs16.18KB000000000000041780000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
56μs16.18KB0000000000000416d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB0000000000000417c0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
57μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB0000000000000417f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB000000000000041810000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
56μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
95μs16.18KB000000000000041830000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
109μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
106μs16.18KB000000000000041850000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
106μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
89μs16.18KB000000000000041870000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
97μs16.18KB0000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
83μs16.18KB000000000000041890000000000000000defaultParams |
|
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.nSort
144μs16.13KB0000000000000415a0000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
455μs18.16KB6000000000000415a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
70μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
104μs16.18KB000000000000041920000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
108μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
103μs16.18KB000000000000041940000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
102μs16.18KB000000000000041960000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
59μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
83μs16.18KB000000000000041980000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
70μs16.18KB0000000000000418f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB0000000000000419c0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB0000000000000419f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
102μs16.18KB000000000000041a10000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
56μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
103μs16.18KB000000000000041a30000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
57μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
85μs16.18KB000000000000041a50000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
85μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB0000000000000419a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041a90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041ac0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
49μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041ae0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041b00000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041b20000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
104μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB000000000000041b40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB000000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB000000000000041b60000000000000000defaultParams |
|
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 = 6
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort
98μs16.13KB0000000000000417a0000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
488μs18.16KB6000000000000417a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
123μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
105μs16.18KB000000000000041bf0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
102μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
115μs16.18KB000000000000041c10000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
109μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
104μs16.18KB000000000000041c30000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
57μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
85μs16.18KB000000000000041c50000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041bc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041c90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041cc0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
107μs16.18KB000000000000041ce0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
88μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041d00000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
55μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041d20000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
103μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
107μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
60μs16.18KB000000000000041c70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
83μs16.18KB000000000000041d60000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
84μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
82μs16.18KB000000000000041d90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041db0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041dd0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041df0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB000000000000041e10000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041e30000000000000000defaultParams |
|
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 = 5
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort
115μs16.13KB000000000000041a70000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
532μs18.16KB600000000000041a70000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
115μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
71μs16.18KB000000000000041ec0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
130μs16.18KB000000000000041ee0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
106μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
103μs16.18KB000000000000041f00000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
56μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041f20000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
54μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041e90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
104μs16.18KB000000000000041f60000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB000000000000041f90000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
82μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
53μs16.18KB000000000000041fb0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB000000000000041fd0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041ff0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000041f40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000042030000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000042060000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
52μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000042080000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
51μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
50μs16.18KB0000000000000420a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
103μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
102μs16.18KB0000000000000420c0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
84μs16.18KB0000000000000420e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
82μs16.18KB000000000000042010000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
87μs16.18KB000000000000042100000000000000000defaultParams |
|
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 = 3
ORDER BY tkategorieattribut.kKategorie, tkategorieattribut.bIstFunktionsAttribut DESC,
tkategorieattribut.nSort
126μs16.13KB000000000000041d40000000000000000defaultSELECT node.kKategorie, node.lft, node.rght, node.nLevel, node.kOberKategorie, tseo.cSeo, node.cName, tkategoriesprache.cName AS cName_spr, node.cBeschreibung, tkategoriesprache.cBeschreibung AS cBeschreibung_spr, tkategoriepict.cPfad, atr.cWert As customImgName, -1 AS 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 tkategoriesprache
ON tkategoriesprache.kKategorie = node.kKategorie
AND tkategoriesprache.kSprache = :langID 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
WHERE tkategoriesichtbarkeit.kKategorie IS NULL
ORDER BY node.lft
473μs18.16KB600000000000041d40000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
99μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
136μs16.18KB000000000000042190000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
134μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
132μs16.18KB0000000000000421b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
133μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
136μs16.18KB0000000000000421d0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
74μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
79μs16.18KB0000000000000421f0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
48μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
48μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
48μs16.18KB000000000000042160000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042230000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
48μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042260000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042280000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422a0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
49μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422c0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042210000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042300000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042330000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
46μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042350000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042370000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB000000000000042390000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000423b0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000422e0000000000000000defaultParams |
|
SELECT cPfad AS path
FROM tkategoriepict
WHERE kKategorie = :cid LIMIT 1
47μs16.18KB0000000000000423d0000000000000000defaultParams |
|
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.nSort
214μs17KB000000000000042100000000000000000defaultParams |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?
68μs16.8KB000000000000041e10000000000000000defaultParams |
|
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 NULL
291μs18.47KB600000000000041230000000000000000defaultParams |
|
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.nSort
194μs17KB000000000000041f40000000000000000defaultParams |
|
SELECT * FROM tkategorie WHERE `kOberKategorie`=?
112μs16.82KB1000000000000413e0000000000000000defaultParams |
|
SELECT tartikel.kArtikel
FROM tkategorieartikel, tartikel
LEFT JOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
WHERE tartikelsichtbarkeit.kArtikel IS NULL
AND tartikel.kArtikel = tkategorieartikel.kArtikel
AND tartikel.kVaterArtikel = 0
AND tkategorieartikel.kKategorie = :cid
AND tartikel.kArtikel < :pid
ORDER BY tartikel.kArtikel DESC
LIMIT 1
331μs16.79KB100000000000041e30000000000000000defaultParams |
|
SELECT tartikel.kArtikel
FROM tkategorieartikel, tartikel
LEFT JOIN tartikelsichtbarkeit
ON tartikel.kArtikel = tartikelsichtbarkeit.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
WHERE tartikelsichtbarkeit.kArtikel IS NULL
AND tartikel.kArtikel = tkategorieartikel.kArtikel
AND tartikel.kVaterArtikel = 0
AND tkategorieartikel.kKategorie = :cid
AND tartikel.kArtikel > :pid
ORDER BY tartikel.kArtikel
LIMIT 1
1.23ms16.79KB100000000000041e30000000000000000defaultParams |
|
SELECT kStueckliste AS id, fLagerbestand AS stock
FROM tartikel
WHERE kArtikel = :pid
94μs16.22KB1000000000000423b0000000000000000defaultParams |
|
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,
tartikelsprache.cName AS cName_spr, tartikelsprache.cBeschreibung AS cBeschreibung_spr,
tartikelsprache.cKurzBeschreibung AS cKurzBeschreibung_spr,
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 tartikelsprache
ON tartikelsprache.kArtikel = :pid
AND tartikelsprache.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
661μs42.52KB1000000000000423f0000000000000000defaultParams |
|
SELECT cName
FROM teinheit
WHERE kEinheit = (SELECT kEinheit
FROM teinheit
WHERE cName = :vpe LIMIT 0, 1)
AND kSprache = :lid LIMIT 0, 1
158μs16.4KB0000000000000423f0000000000000000defaultParams |
|
SELECT kPreis, noDiscount, kKunde
FROM tpreis AS p
WHERE kArtikel = :pid AND kKundengruppe = :cgid
155μs16.28KB100000000000042450000000000000000defaultParams |
|
SELECT kSteuerklasse, fMwSt
FROM tartikel
WHERE kArtikel = :pid
127μs16.19KB100000000000042450000000000000000defaultParams |
|
SELECT nAnzahlAb, fVKNetto
FROM tpreisdetail
WHERE kPreis = :priceID
ORDER BY nAnzahlAb
161μs16.25KB100000000000042450000000000000000defaultParams |
|
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 = :customerGroup
134μs17.08KB000000000000042430000000000000000defaultParams |
|
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 = :pid
153μs16.95KB1000000000000424a0000000000000000defaultParams |
|
SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut
65μs16.17KB000000000000042470000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort
65μs16.25KB000000000000042470000000000000000defaultParams |
|
SELECT cPfad, nNr
FROM tartikelpict
WHERE kArtikel = :pid
ORDER BY nNr
73μs16.22KB100000000000042470000000000000000defaultParams |
|
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.kMerkmal
114μs16.55KB0000000000000424d0000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?
70μs16.82KB0000000000000424d0000000000000000defaultParams |
|
SELECT tartikeldownload.kDownload
FROM tartikeldownload
LEFT JOIN tdownload ON tartikeldownload.kDownload = tdownload.kDownload
WHERE kArtikel = :pid OR
tartikeldownload.kArtikel IN (
SELECT tstueckliste.kArtikel
FROM tstueckliste
LEFT JOIN tartikel
ON tstueckliste.kStueckliste = tartikel.kStueckliste
WHERE tartikel.kArtikel = :pid)
GROUP BY tartikeldownload.kDownload
ORDER BY tdownload.nSort, tdownload.dErstellt DESC
157μs16.77KB0000000000000424d0000000000000000defaultParams |
|
SELECT tartikelkonfiggruppe.kKonfiggruppe
FROM tartikelkonfiggruppe
JOIN tkonfigitem
ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe
AND tartikelkonfiggruppe.kArtikel = :pid
68μs16.34KB0000000000000424d0000000000000000defaultParams |
|
SELECT cSeo, kSprache
FROM tseo
WHERE cKey = :key
AND kKey = :id
72μs16.22KB100000000000042610000000000000000defaultParams |
|
SELECT kStueckliste AS id, fLagerbestand AS stock
FROM tartikel
WHERE kArtikel = :pid
55μs16.22KB1000000000000425d0000000000000000defaultParams |
|
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,
tartikelsprache.cName AS cName_spr, tartikelsprache.cBeschreibung AS cBeschreibung_spr,
tartikelsprache.cKurzBeschreibung AS cKurzBeschreibung_spr,
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 tartikelsprache
ON tartikelsprache.kArtikel = :pid
AND tartikelsprache.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
595μs42.52KB1000000000000425b0000000000000000defaultParams |
|
SELECT cName
FROM teinheit
WHERE kEinheit = (SELECT kEinheit
FROM teinheit
WHERE cName = :vpe LIMIT 0, 1)
AND kSprache = :lid LIMIT 0, 1
123μs16.4KB0000000000000425b0000000000000000defaultParams |
|
SELECT kPreis, noDiscount, kKunde
FROM tpreis AS p
WHERE kArtikel = :pid AND kKundengruppe = :cgid
142μs16.28KB100000000000042670000000000000000defaultParams |
|
SELECT kSteuerklasse, fMwSt
FROM tartikel
WHERE kArtikel = :pid
82μs16.19KB100000000000042670000000000000000defaultParams |
|
SELECT nAnzahlAb, fVKNetto
FROM tpreisdetail
WHERE kPreis = :priceID
ORDER BY nAnzahlAb
99μs16.25KB100000000000042670000000000000000defaultParams |
|
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 = :customerGroup
125μs17.08KB000000000000042650000000000000000defaultParams |
|
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 = :pid
116μs16.95KB1000000000000426c0000000000000000defaultParams |
|
SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut
60μs16.17KB000000000000042690000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort
59μs16.25KB000000000000042690000000000000000defaultParams |
|
SELECT cPfad, nNr
FROM tartikelpict
WHERE kArtikel = :pid
ORDER BY nNr
65μs16.22KB100000000000042690000000000000000defaultParams |
|
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.kMerkmal
100μs16.55KB0000000000000426f0000000000000000defaultParams |
|
SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?
67μs16.82KB0000000000000426f0000000000000000defaultParams |
|
SELECT tartikeldownload.kDownload
FROM tartikeldownload
LEFT JOIN tdownload ON tartikeldownload.kDownload = tdownload.kDownload
WHERE kArtikel = :pid OR
tartikeldownload.kArtikel IN (
SELECT tstueckliste.kArtikel
FROM tstueckliste
LEFT JOIN tartikel
ON tstueckliste.kStueckliste = tartikel.kStueckliste
WHERE tartikel.kArtikel = :pid)
GROUP BY tartikeldownload.kDownload
ORDER BY tdownload.nSort, tdownload.dErstellt DESC
142μs16.77KB0000000000000426f0000000000000000defaultParams |
|
SELECT tartikelkonfiggruppe.kKonfiggruppe
FROM tartikelkonfiggruppe
JOIN tkonfigitem
ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe
AND tartikelkonfiggruppe.kArtikel = :pid
66μs16.34KB0000000000000426f0000000000000000defaultParams |
|
SELECT cSeo, kSprache
FROM tseo
WHERE cKey = :key
AND kKey = :id
71μs16.22KB100000000000042830000000000000000defaultParams |
|
SELECT * FROM tversandart
WHERE cNurAbhaengigeVersandart = :depOnly
AND cLaender LIKE :iso
AND (cVersandklassen = '-1'
OR cVersandklassen RLIKE :sClasses)
AND (cKundengruppen = '-1'
OR FIND_IN_SET(:cGroupID, REPLACE(cKundengruppen, ';', ',')) > 0)
ORDER BY nSort
143μs16.88KB000000000000042950000000000000000defaultParams |
|
SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr,
thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords,
therstellersprache.cMetaDescription, therstellersprache.cBeschreibung,
tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache
FROM thersteller
LEFT JOIN therstellersprache
ON therstellersprache.kHersteller = thersteller.kHersteller
LEFT JOIN tseo
ON tseo.kKey = thersteller.kHersteller
AND tseo.cKey = :skey
AND tseo.kSprache = therstellersprache.kSprache
WHERE EXISTS (
SELECT 1
FROM tartikel
WHERE tartikel.kHersteller = thersteller.kHersteller
AND NOT EXISTS (
SELECT 1 FROM tartikelsichtbarkeit
WHERE tartikelsichtbarkeit.kArtikel = tartikel.kArtikel
AND tartikelsichtbarkeit.kKundengruppe = :cgid
)
)
GROUP BY thersteller.kHersteller, therstellersprache.kSprache
ORDER BY thersteller.nSortNr, thersteller.cName
6.96ms18.19KB2400000000000042b20000000000000000defaultParams |
|
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 NULL
243μs16.02KB000000000000042ca0000000000000000defaultSELECT 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)
181μs16.96KB000000000000042b80000000000000000defaultParams |
|
SELECT type, bExtension, path, nVersion, cVerzeichnis, position, cName AS name
FROM tplugin_resources AS res
JOIN tplugin
ON tplugin.kPlugin = res.kPlugin
WHERE tplugin.nStatus = :state
ORDER BY res.priority DESC
504μs16.72KB900000000000042fa0000000000000000defaultParams |
|
INSERT IGNORE INTO tbesucherarchiv
(kBesucher, cIP, kKunde, kBestellung, cReferer, cEinstiegsseite, cBrowser,
cAusstiegsseite, nBesuchsdauer, kBesucherBot, dZeit)
SELECT kBesucher, cIP, kKunde, kBestellung, cReferer, cEinstiegsseite, cBrowser, cAusstiegsseite,
(UNIX_TIMESTAMP(dLetzteAktivitaet) - UNIX_TIMESTAMP(dZeit)) AS nBesuchsdauer, kBesucherBot, dZeit
FROM tbesucher
WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)
883μs688B000000000000043230000000000000000defaultParams |
|
DELETE FROM tbesucher
WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)
157μs128B000000000000043230000000000000000defaultParams |
|
SELECT * FROM tbesucher WHERE `cSessID`=?
145μs16.91KB000000000000043230000000000000000defaultParams |
|
SELECT * FROM tbesucher WHERE `cID`=?
139μs16.91KB000000000000043230000000000000000defaultParams |
|
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)
113μs3.07KB100000000000045130000000000000000defaultParams |
|
SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv
302μs16.38KB300000000000045130000000000000000defaultParams |
|
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 = '')
121μs16.42KB0000000000000450a0000000000000000defaultParams |
|
SELECT * FROM tboxenanzeige
231μs17.33KB8000000000000045020000000000000000defaultSELECT 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 ('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 ASC
2.15ms16.56KB4000000000000448a0000000000000000defaultSELECT kPlugin, cPluginID, bExtension FROM tplugin
70μs16.27KB1100000000000044700000000000000000defaultSELECT * FROM tplugin WHERE `kPlugin`=?
76μs17.23KB1000000000000447d0000000000000000defaultParams |
|
SELECT tstoreauth.auth_code, tstoreauth.access_token,
tadminlogin.cPass AS hash, tstoreauth.verified
FROM tstoreauth
INNER JOIN tadminlogin
ON tadminlogin.kAdminlogin = tstoreauth.owner
LIMIT 1
374μs16.11KB1000000000000448f0000000000000000defaultSELECT * FROM licenses
WHERE returnCode = 200
ORDER BY id DESC
LIMIT 1
561μs56.11KB100000000000044bb0000000000000000defaultSELECT * FROM tplugin WHERE `exsID`=?
127μs17.23KB100000000000044230000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `exsID`=?
117μs17.22KB000000000000044110000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `exsID`=?
117μs17.23KB100000000000044000000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `exsID`=?
149μs17.23KB100000000000043f00000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `exsID`=?
141μs17.22KB000000000000043c20000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
437μs16.28KB100000000000044870000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
201μs16.24KB000000000000044b40000000000000000defaultParams |
|
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.kLink
253μs16.4KB0000000000000448d0000000000000000defaultParams |
|
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.nSort
1.34ms17.94KB4600000000000044b10000000000000000defaultParams |
|
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.kPluginSprachvariable
1.74ms36.81KB195000000000000440f0000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
300μs16.38KB000000000000044d00000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
293μs16.88KB000000000000044d30000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
299μs16.94KB0000000000000449c0000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
83μs17.23KB100000000000044da0000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
81μs16.28KB100000000000044dc0000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
64μs16.32KB500000000000044e00000000000000000defaultParams |
|
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.kLink
111μs16.4KB000000000000044e40000000000000000defaultParams |
|
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.nSort
254μs17.19KB000000000000044a30000000000000000defaultParams |
|
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.kPluginSprachvariable
580μs16.91KB600000000000044e90000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
103μs16.38KB000000000000044a80000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
135μs16.91KB000000000000044a70000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
85μs16.94KB000000000000044e80000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
69μs17.23KB100000000000044ed0000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
81μs16.36KB600000000000044ad0000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
61μs16.29KB300000000000044fe0000000000000000defaultParams |
|
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.kLink
131μs16.43KB200000000000044ae0000000000000000defaultParams |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (199,200)
65μs16.11KB2000000000000445e0000000000000000defaultSELECT 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 (199,200)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName
1.32ms17.06KB1200000000000044520000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid
89μs16.12KB100000000000044490000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
57μs16.12KB0000000000000444b0000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
46μs16.12KB100000000000044470000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
50μs16.12KB000000000000044430000000000000000defaultParams |
|
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.nSort
211μs17.19KB000000000000045000000000000000000defaultParams |
|
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.kPluginSprachvariable
480μs17.56KB4200000000000044500000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
99μs16.38KB000000000000043e80000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
128μs16.91KB000000000000043e50000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
84μs16.94KB000000000000043ed0000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
69μs17.23KB100000000000044380000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
74μs16.28KB100000000000044390000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
57μs16.24KB000000000000044910000000000000000defaultParams |
|
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.kLink
102μs16.4KB0000000000000443e0000000000000000defaultParams |
|
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.nSort
1.06ms17.81KB40000000000000444c0000000000000000defaultParams |
|
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.kPluginSprachvariable
332μs17.69KB5000000000000043cf0000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
97μs16.38KB000000000000043520000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
135μs16.91KB000000000000043550000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
84μs16.94KB000000000000043570000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
72μs17.23KB100000000000044890000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
84μs16.36KB600000000000044550000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
59μs16.3KB400000000000044530000000000000000defaultParams |
|
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.kLink
139μs16.46KB4000000000000456d0000000000000000defaultParams |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (201,202,203,204)
62μs16.14KB400000000000045670000000000000000defaultSELECT 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 (201,202,203,204)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName
769μs33.25KB2400000000000045410000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid
53μs16.12KB100000000000043390000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
64μs16.12KB0000000000000432b0000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
55μs16.12KB1000000000000432c0000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
58μs16.12KB0000000000000432e0000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
50μs16.12KB100000000000043330000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
60μs16.12KB000000000000043300000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
52μs16.12KB100000000000043320000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
58μs16.12KB000000000000043350000000000000000defaultParams |
|
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.nSort
605μs17.44KB15000000000000444f0000000000000000defaultParams |
|
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.kPluginSprachvariable
1.21ms88.81KB30000000000000045210000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
121μs16.38KB0000000000000464a0000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
609μs33.07KB1000000000000046470000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
254μs17.02KB5000000000000463c0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
147μs16.55KB3000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
226μs16.34KB6000000000000463c0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
86μs16.55KB3000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
58μs16.34KB6000000000000463c0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
83μs16.55KB3000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
57μs16.34KB6000000000000463c0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
81μs16.55KB3000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
100μs16.34KB6000000000000463c0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
84μs16.55KB3000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
57μs16.34KB6000000000000463c0000000000000000defaultParams |
|
SELECT * FROM tplugin WHERE `kPlugin`=?
71μs17.23KB100000000000045f00000000000000000defaultParams |
|
SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort
92μs16.34KB500000000000045eb0000000000000000defaultParams |
|
SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin
63μs16.37KB800000000000045e70000000000000000defaultParams |
|
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.kLink
178μs16.52KB8000000000000458a0000000000000000defaultParams |
|
SELECT `kLink`, `reference`, `kVaterLink`
FROM tlink
WHERE kLink IN (191,192,193,194,195,196,197,198)
68μs16.2KB800000000000043c60000000000000000defaultSELECT 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 (191,192,193,194,195,196,197,198)
GROUP BY tlink.kLink, tsprache.kSprache
ORDER BY tlink.nSort, tlink.cName
984μs33.63KB4800000000000045ad0000000000000000defaultSELECT `reference` FROM `tlink` WHERE kLink = :lid
56μs16.12KB100000000000043240000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
96μs16.12KB000000000000045610000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
46μs16.12KB100000000000045690000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
48μs16.12KB000000000000045670000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
40μs16.12KB100000000000043360000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
46μs16.12KB000000000000043310000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
39μs16.12KB1000000000000458c0000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
73μs16.12KB0000000000000459b0000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
68μs16.12KB100000000000045a70000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
45μs16.12KB000000000000045a30000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
39μs16.12KB100000000000045a00000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
45μs16.12KB000000000000045a50000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
39μs16.12KB100000000000045a20000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
45μs16.12KB0000000000000459f0000000000000000defaultParams |
|
SELECT `reference` FROM `tlink` WHERE kLink = :lid
50μs16.12KB1000000000000458f0000000000000000defaultParams |
|
SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink
47μs16.12KB000000000000045990000000000000000defaultParams |
|
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.nSort
276μs17.23KB300000000000045e50000000000000000defaultParams |
|
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.kPluginSprachvariable
1.73ms104.81KB510000000000000457f0000000000000000defaultParams |
|
SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin
107μs16.38KB000000000000047fc0000000000000000defaultParams |
|
SELECT * FROM temailvorlage
JOIN temailvorlagesprache AS loc
ON loc.kEmailvorlage = temailvorlage.kEmailvorlage
WHERE temailvorlage.kPlugin = :id
450μs49.41KB3000000000000047f90000000000000000defaultParams |
|
SELECT *
FROM tzahlungsart
JOIN tpluginzahlungsartklasse
ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId
WHERE tzahlungsart.cModulId LIKE :pid
130μs16.95KB100000000000047da0000000000000000defaultParams |
|
SELECT *
FROM tplugineinstellungenconf
WHERE cWertName LIKE :val
AND cConf = 'Y'
ORDER BY nSort
92μs16.55KB300000000000047da0000000000000000defaultParams |
|
SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart
63μs16.34KB600000000000047da0000000000000000defaultParams |
|
Durch Klicken auf „Alle akzeptieren“ gestatten Sie den Einsatz folgender Dienste auf unserer Website: YouTube, Vimeo, giveAway, customerSwitch. 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.
Damit unser Dienst funktioniert, ist Ihre Zustimmung zur Speicherung von Drittanbieter-Cookies des Anbieters [tech]NEO GmbH erforderlich. Durch die Auswahl zwischen Privat oder Geschäftlich, werden die Preise Brutto oder Netto angezeigt. Stimmen Sie nicht zu, ist eine Nutzung der Funktion leider nicht möglich. Nehmen Sie bitte über einen alternativen Weg zu uns Kontakt auf.
Anzeigen von brutto oder netto Preisen
Verarbeitende Firma:[tech]NEO GmbH
Nutzungsbedingungen: LinkDamit unser Dienst funktioniert, ist Ihre Zustimmung zur Speicherung von Drittanbieter-Cookies des Anbieters [tech]NEO GmbH erforderlich. Durch die Auswahl zwischen Privat oder Geschäftlich, werden die Preise Brutto oder Netto angezeigt. Stimmen Sie nicht zu, ist eine Nutzung der Funktion leider nicht möglich. Nehmen Sie bitte über einen alternativen Weg zu uns Kontakt auf.
Anzeigen von brutto oder netto Preisen
Verarbeitende Firma:[tech]NEO GmbH
Nutzungsbedingungen: LinkSie 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.