Orange - 4442

Orangen sind richtige Vitamin-C-Bomben. Schon ein Glas Orangensaft am Tag deckt unseren Vitamin-C-Bedarf. Doch in Orangen steckt noch viel mehr.
Preis auf Anfrage
  • Sofort verfügbar
328msRequest Duration8.2.27PHP Version18MBMemory Usage
  • Shop start to end (299ms)
  • shop.hook.250 (8μs)
  • shop.hook.254 (4μs)
  • shop.hook.252 (4μs)
  • shop.hook.251 (3μs)
  • shop.hook.118 (5μs)
  • shop.hook.131 (446μs)
  • shop.hook.156 (17.2ms)
  • shop.hook.118 (24μs)
  • shop.hook.118 (4μs)
  • shop.hook.303 (5μs)
  • shop.hook.303 (5μs)
  • shop.hook.118 (4μs)
  • shop.hook.361 (4μs)
  • shop.hook.133 (197μs)
  • shop.hook.320 (2.05ms)
  • shop.hook.250 (4μs)
  • shop.hook.254 (2μs)
  • shop.hook.252 (2μs)
  • shop.hook.142 (4μs)
  • shop.hook.400 (190μs)
  • shop.hook.132 (6μs)
  • shop.hook.166 (4μs)
  • shop.hook.143 (5μs)
  • shop.hook.251 (4μs)
  • shop.hook.221 (6μs)
  • shop.hook.221 (6μs)
  • shop.hook.221 (4μs)
  • shop.hook.321 (7μs)
  • shop.hook.260 (5μs)
  • shop.hook.330 (4μs)
  • shop.hook.330 (3μs)
  • shop.hook.103 (6μs)
  • shop.hook.330 (5μs)
  • shop.hook.60 (4μs)
  • shop.hook.58 (3μs)
  • shop.hook.59 (4μs)
  • shop.hook.113 (6μs)
  • shop.hook.114 (3μs)
  • shop.hook.115 (4μs)
  • shop.hook.330 (4μs)
  • shop.hook.330 (2μs)
  • shop.hook.110 (2μs)
  • shop.hook.214 (13μs)
  • shop.hook.69 (4μs)
  • shop.hook.69 (3μs)
  • shop.hook.72 (3μs)
  • shop.hook.221 (7μs)
  • shop.hook.104 (8μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.219 (4μs)
  • shop.hook.221 (5μs)
  • shop.hook.104 (5μs)
  • shop.hook.104 (4μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.219 (2μs)
  • shop.hook.221 (3μs)
  • shop.hook.104 (4μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.219 (3μs)
  • shop.hook.221 (5μs)
  • shop.hook.104 (5μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (3μs)
  • shop.hook.219 (3μs)
  • shop.hook.221 (5μs)
  • shop.hook.104 (5μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (3μs)
  • shop.hook.104 (2μs)
  • shop.hook.219 (3μs)
  • shop.hook.221 (4μs)
  • shop.hook.104 (4μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (1μs)
  • shop.hook.104 (2μs)
  • shop.hook.104 (1μs)
  • shop.hook.104 (1μs)
  • shop.hook.219 (2μs)
  • shop.hook.120 (3μs)
  • shop.hook.120 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.321 (3μs)
  • shop.hook.260 (3μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.103 (2μs)
  • shop.hook.330 (3μs)
  • shop.hook.60 (2μs)
  • shop.hook.58 (1μs)
  • shop.hook.59 (1μs)
  • shop.hook.330 (3μs)
  • shop.hook.330 (2μs)
  • shop.hook.110 (2μs)
  • shop.hook.221 (7μs)
  • shop.hook.321 (4μs)
  • shop.hook.260 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.103 (3μs)
  • shop.hook.330 (3μs)
  • shop.hook.60 (2μs)
  • shop.hook.58 (1μs)
  • shop.hook.59 (1μs)
  • shop.hook.330 (3μs)
  • shop.hook.330 (1μs)
  • shop.hook.110 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.57 (2μs)
  • shop.hook.120 (3μs)
  • shop.hook.118 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.221 (3μs)
  • shop.hook.226 (6μs)
  • shop.hook.330 (4μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.330 (2μs)
  • shop.hook.331 (2μs)
  • shop.hook.118 (3μs)
  • shop.hook.204 (4μs)
  • shop.hook.175 (2μs)
  • shop.hook.60 (4μs)
  • shop.hook.109 (5μs)
  • shop.hook.99 (234μs)
  • shop.hook.208 (108μs)
  • shop.hook.300 (5μs)
  • shop.hook.301 (4μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (3μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (3μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (3μs)
  • shop.hook.300 (1μs)
  • shop.hook.301 (2μs)
  • shop.hook.300 (2μs)
  • shop.hook.301 (2μs)
  • shop.hook.208 (109μs)
  • shop.hook.70 (3μs)
  • shop.hook.101 (4μs)
  • 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
475 statements were executed, 241 of which were duplicates, 234 unique. Show only duplicated83.56ms7.94MB
  • SELECT * FROM tsprache158μs16.28KB600000000000000750000000000000000default
  • 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.cStandard = 'Y'283μs16.73KB1000000000000007c0000000000000000default
    Params
    • :lid: 
  • SELECT * FROM tsprache113μs16.28KB6000000000000017d0000000000000000default
  • SELECT * FROM twaehrung108μs16.31KB6000000000000017d0000000000000000default
  • SELECT * FROM tsprache WHERE `cShopStandard`=?107μs16.73KB1000000000000023d0000000000000000default
    Params
    • 0: Y
  • SELECT * FROM tglobals106μs16.06KB1000000000000023d0000000000000000default
  • SELECT * FROM tsprache97μs16.28KB600000000000002410000000000000000default
  • SELECT * FROM twaehrung102μs16.31KB600000000000000470000000000000000default
  • 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.cStandard = 'Y'193μs16.73KB100000000000000490000000000000000default
    Params
    • :lid: 1
  • SELECT * FROM tplugin WHERE `kPlugin`=?161μs17.23KB1000000000000023f0000000000000000default
    Params
    • 0: 328
  • SELECT * FROM twaehrung136μs16.31KB600000000000037ac0000000000000000default
  • SELECT * FROM tsprache85μs16.28KB600000000000037c90000000000000000default
  • SELECT * FROM twaehrung142μs16.31KB600000000000037ec0000000000000000default
  • SELECT tsteuerzone.kSteuerzone FROM tsteuerzone, tsteuerzoneland WHERE tsteuerzoneland.cISO = :ciso AND tsteuerzoneland.kSteuerzone = tsteuerzone.kSteuerzone156μs16.29KB100000000000038c00000000000000000default
    Params
    • :ciso: AT
  • SELECT * FROM tsteuerklasse132μs16.11KB200000000000038ac0000000000000000default
  • SELECT fSteuersatz FROM tsteuersatz WHERE kSteuerklasse = :tcid AND (kSteuerzone IN (7)) ORDER BY nPrio DESC169μs16.26KB100000000000038ac0000000000000000default
    Params
    • :tcid: 1
  • SELECT fSteuersatz FROM tsteuersatz WHERE kSteuerklasse = :tcid AND (kSteuerzone IN (7)) ORDER BY nPrio DESC118μs16.26KB100000000000038ac0000000000000000default
    Params
    • :tcid: 2
  • 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 = :id411μs16.73KB100000000000038c60000000000000000default
    Params
    • :lid: 
    • :id: 1
  • SELECT * FROM tkundengruppenattribut WHERE `kKundengruppe`=:kKundengruppe131μs16.25KB0000000000000004a0000000000000000default
    Params
    • :kKundengruppe: 1
  • SELECT tsteuerzone.kSteuerzone FROM tsteuerzone, tsteuerzoneland WHERE tsteuerzoneland.cISO = :ciso AND tsteuerzoneland.kSteuerzone = tsteuerzone.kSteuerzone326μs16.29KB100000000000037aa0000000000000000default
    Params
    • :ciso: AT
  • SELECT * FROM tsteuerklasse78μs16.11KB2000000000000389a0000000000000000default
  • SELECT fSteuersatz FROM tsteuersatz WHERE kSteuerklasse = :tcid AND (kSteuerzone IN (7)) ORDER BY nPrio DESC172μs16.26KB1000000000000389a0000000000000000default
    Params
    • :tcid: 1
  • SELECT fSteuersatz FROM tsteuersatz WHERE kSteuerklasse = :tcid AND (kSteuerzone IN (7)) ORDER BY nPrio DESC168μs16.26KB1000000000000389a0000000000000000default
    Params
    • :tcid: 2
  • SELECT * FROM ttemplate WHERE `eTyp`=?289μs16.85KB100000000000035d90000000000000000default
    Params
    • 0: standard
  • SELECT * FROM ttemplateeinstellungen WHERE `cTemplate`=:cTemplate1.48ms17.44KB6900000000000035d40000000000000000default
    Params
    • :cTemplate: NOVA
  • SELECT * FROM tconsent WHERE `active`=:active306μs16.3KB40000000000003c110000000000000000default
    Params
    • :active: 1
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID381μs16.31KB20000000000003c2b0000000000000000default
    Params
    • :consentID: 1
  • SELECT * FROM tsprache86μs16.28KB60000000000003c2b0000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID118μs16.31KB20000000000003c330000000000000000default
    Params
    • :consentID: 2
  • SELECT * FROM tsprache79μs16.28KB60000000000003c330000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID98μs16.36KB50000000000003c490000000000000000default
    Params
    • :consentID: 11
  • SELECT * FROM tsprache75μs16.28KB60000000000003c490000000000000000default
  • SELECT * FROM tconsentlocalization WHERE `consentID`=:consentID111μs16.38KB60000000000003c4d0000000000000000default
    Params
    • :consentID: 48
  • SELECT * FROM tsprache90μs16.28KB60000000000003c4d0000000000000000default
  • SELECT tplugineinstellungen.*, tplugineinstellungenconf.cConf FROM tplugin JOIN tplugineinstellungen ON tplugineinstellungen.kPlugin = tplugin.kPlugin LEFT JOIN tplugineinstellungenconf ON tplugineinstellungenconf.kPlugin = tplugin.kPlugin AND tplugineinstellungen.cName = tplugineinstellungenconf.cWertName WHERE tplugin.kPlugin = :pid1.57ms18.09KB890000000000003c4d0000000000000000default
    Params
    • :pid: 183
  • SELECT * FROM tseo WHERE cSeo = :slg436μs16.22KB10000000000003d260000000000000000default
    Params
    • :slg: Orange-4442
  • SELECT kEigenschaftKombi FROM tartikel WHERE kArtikel = :pid384μs16.16KB10000000000003d260000000000000000default
    Params
    • :pid: 92698
  • SELECT kVaterArtikel FROM tartikel WHERE kArtikel = :pid121μs16.16KB10000000000003d250000000000000000default
    Params
    • :pid: 92698
  • SELECT cBrocken FROM tbrocken LIMIT 1284μs16.04KB10000000000003d350000000000000000default
  • SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid145μs16.22KB10000000000003d370000000000000000default
    Params
    • :pid: 92698
  • 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.52KB10000000000003d390000000000000000default
    Params
    • :lid: 1
    • :cgid: 1
    • :pid: 92698
    • :bsms: 10
    • :trmr: 3
  • SELECT cName FROM teinheit WHERE kEinheit = (SELECT kEinheit FROM teinheit WHERE cName = :vpe LIMIT 0, 1) AND kSprache = :lid LIMIT 0, 1152μs16.4KB00000000000003d390000000000000000default
    Params
    • :vpe: 
    • :lid: 1
  • SELECT * FROM ttrennzeichen WHERE `nEinheit`=? AND `kSprache`=?400μs16.79KB10000000000003d3c0000000000000000default
    Params
    • 0: 1
    • 1: 1
  • 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.cName197μs16.69KB00000000000003d400000000000000000default
    Params
    • :lid: 1
    • :aid: 92698
  • SELECT 1 AS hasData FROM cross_selling_view LIMIT 197μs16.02KB00000000000003d420000000000000000default
  • SELECT kXSellArtikel FROM txsellkauf WHERE kArtikel = :pid ORDER BY nAnzahl DESC LIMIT :lmt124μs16.21KB00000000000003d440000000000000000default
    Params
    • :pid: 92698
    • :lmt: 6
  • 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 :lmt298μs17.3KB00000000000003d400000000000000000default
    Params
    • :kArtikel: 92698
    • :customerGroupID: 1
    • :lmt: 10
  • 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 :lmt257μs17.3KB00000000000003d400000000000000000default
    Params
    • :pid: 92698
    • :cgid: 1
    • :lmt: 10
  • SELECT kSuchspecialOverlay FROM tsuchspecialoverlay259μs16.18KB90000000000003d4c0000000000000000default
  • 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 1324μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 1
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1184μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 2
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1180μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 3
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1183μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 4
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1186μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 5
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1129μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 6
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1124μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 7
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1119μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 8
    • :templateName: NOVA
    • :defaultTemplate: default
  • 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 1116μs16.95KB10000000000003d4c0000000000000000default
    Params
    • :languageID: 1
    • :overlayID: 9
    • :templateName: NOVA
    • :defaultTemplate: default
  • SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid398μs16.28KB10000000000003d480000000000000000default
    Params
    • :pid: 92698
    • :cgid: 1
  • SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid74μs16.19KB10000000000003d480000000000000000default
    Params
    • :pid: 92698
  • SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb533μs16.25KB10000000000003d480000000000000000default
    Params
    • :priceID: 31971
  • 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 = :customerGroup178μs17.08KB00000000000003d460000000000000000default
    Params
    • :productID: 92698
    • :customerGroup: 1
  • 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 = :pid203μs16.95KB10000000000003d600000000000000000default
    Params
    • :pid: 92698
  • SELECT 1 AS cnt FROM tartikelkategorierabatt LIMIT 199μs16.02KB00000000000003d390000000000000000default
  • SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut128μs16.17KB00000000000003d4a0000000000000000default
    Params
    • :kArtikel: 92698
  • SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort133μs16.25KB00000000000003d4a0000000000000000default
    Params
    • :kArtikel: 92698
  • SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr596μs16.22KB10000000000003d4a0000000000000000default
    Params
    • :pid: 92698
  • SELECT tartikelwarenlager.* FROM tartikelwarenlager JOIN twarenlager ON twarenlager.kWarenlager = tartikelwarenlager.kWarenlager AND twarenlager.nAktiv = 1 WHERE tartikelwarenlager.kArtikel = :productID141μs16.44KB00000000000003d640000000000000000default
    Params
    • :productID: 92698
  • 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.kMerkmal170μs16.55KB00000000000003d640000000000000000default
    Params
    • :kArtikel: 92698
  • 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 ASC116μs16.81KB00000000000003d640000000000000000default
    Params
    • :pid: 92698
  • 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 = :pid221μs16.66KB10000000000003dcc0000000000000000default
    Params
    • :cgid: 1
    • :pid: 92698
  • 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.cName328μs19.59KB00000000000003dce0000000000000000default
    Params
    • :pid: 92698
    • :cgid: 1
    • :lid: 1
  • SELECT * FROM tversandart142μs16.5KB40000000000003d640000000000000000default
  • SELECT * 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.81KB00000000000003d640000000000000000default
    Params
    • :sClasses: ^([0-9 -]* )?1
    • :cGroupID: 1
  • SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?91μs16.82KB00000000000003d640000000000000000default
    Params
    • 0: 92698
    • 1: steuertext
  • 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 DESC201μs16.77KB00000000000003d640000000000000000default
    Params
    • :pid: 92698
  • SELECT tartikelkonfiggruppe.kKonfiggruppe FROM tartikelkonfiggruppe JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe AND tartikelkonfiggruppe.kArtikel = :pid92μs16.34KB00000000000003d640000000000000000default
    Params
    • :pid: 92698
  • SELECT cName, kSprache, cWertName FROM tglobalemetaangaben ORDER BY kSprache328μs16.33KB150000000000003dda0000000000000000default
  • SELECT 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 1433μs17.88KB00000000000003def0000000000000000default
    Params
    • :customerID: 
    • :pid: 92698
  • SELECT COUNT(*) AS nAnzahl, nSterne FROM tbewertung WHERE kArtikel = :pid AND tbewertung.nAktiv = 1 GROUP BY nSterne ORDER BY nSterne DESC111μs16.3KB00000000000003ded0000000000000000default
    Params
    • :pid: 92698
  • 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 DESC371μs17.88KB00000000000003ded0000000000000000default
    Params
    • :customerID: 
    • :pid: 92698
  • 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.kArtikel103μs16.42KB00000000000003ded0000000000000000default
    Params
    • :pid: 92698
  • SELECT COUNT(*) AS nAnzahlSprache FROM tbewertung WHERE kArtikel = :pid AND tbewertung.nAktiv = 177μs16.2KB10000000000003ded0000000000000000default
    Params
    • :pid: 92698
  • SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id96μs16.22KB10000000000003de90000000000000000default
    Params
    • :key: kArtikel
    • :id: 92698
  • SELECT tkategorie.kKategorie, tkategorie.kOberKategorie, tkategorie.nSort, tkategorie.dLetzteAktualisierung, tkategoriepict.cPfad, atr.cWert AS customImgName, tkategorie.lft, tkategorie.rght, COALESCE(tseo.cSeo, tkategoriesprache.cSeo, '') cSeo, COALESCE(tkategoriesprache.cName, tkategorie.cName) cName, COALESCE(tkategoriesprache.cBeschreibung, tkategorie.cBeschreibung) cBeschreibung, COALESCE(tkategoriesprache.cMetaDescription, '') cMetaDescription, COALESCE(tkategoriesprache.cMetaKeywords, '') cMetaKeywords, COALESCE(tkategoriesprache.cTitleTag, '') cTitleTag, tsprache.kSprache FROM tkategorie JOIN tsprache ON tsprache.active = 1 LEFT JOIN tkategoriesichtbarkeit ON tkategoriesichtbarkeit.kKategorie = tkategorie.kKategorie AND tkategoriesichtbarkeit.kKundengruppe = :cgid LEFT JOIN tseo ON tseo.cKey = 'kKategorie' AND tseo.kKey = :kid AND tseo.kSprache = tsprache.kSprache LEFT JOIN tkategoriesprache ON tkategoriesprache.kKategorie = tkategorie.kKategorie AND tkategoriesprache.kSprache = tseo.kSprache AND tkategoriesprache.kSprache = tsprache.kSprache LEFT JOIN tkategoriepict ON tkategoriepict.kKategorie = tkategorie.kKategorie LEFT JOIN tkategorieattribut atr ON atr.kKategorie = tkategorie.kKategorie AND atr.cName = 'bildname' WHERE tkategorie.kKategorie = :kid AND tkategoriesichtbarkeit.kKategorie IS NULL1.2ms18.47KB6000000000000411d0000000000000000default
    Params
    • :kid: 247
    • :cgid: 1
  • 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.nSort340μs16.13KB000000000000041250000000000000000default
  • SELECT COUNT(kKategorie) AS cnt FROM tkategorie WHERE kKategorie > 0117μs16.04KB100000000000041240000000000000000default
  • SELECT 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.lft827μs18.16KB600000000000041240000000000000000default
    Params
    • :langID: 2
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1152μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1118μs16.18KB000000000000041360000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1113μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1111μs16.18KB000000000000041380000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1112μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 198μs16.18KB0000000000000413a0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1106μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 157μs16.18KB0000000000000413c0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 163μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 166μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 172μs16.18KB000000000000041330000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 188μs16.18KB000000000000041400000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 167μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 159μs16.18KB000000000000041430000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 161μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1138μs16.18KB000000000000041450000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1125μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1115μs16.18KB000000000000041470000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 168μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 194μs16.18KB000000000000041490000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 163μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 192μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 192μs16.18KB0000000000000413e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 161μs16.18KB0000000000000414d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 161μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 161μs16.18KB000000000000041500000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 160μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 161μs16.18KB000000000000041520000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1118μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1100μs16.18KB000000000000041540000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 194μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 159μs16.18KB000000000000041560000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 166μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 192μs16.18KB000000000000041580000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 189μs16.18KB0000000000000414b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 164μs16.18KB0000000000000415a0000000000000000default
    Params
    • :cid: 265
  • 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.nSort127μs16.13KB0000000000000412a0000000000000000default
  • SELECT 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.lft576μs18.16KB6000000000000412a0000000000000000default
    Params
    • :langID: 4
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1113μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1113μs16.18KB000000000000041650000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 190μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 188μs16.18KB000000000000041670000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 156μs16.18KB000000000000041690000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1111μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1108μs16.18KB0000000000000416b0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 163μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1108μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1106μs16.18KB000000000000041620000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1110μs16.18KB0000000000000416f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 163μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1107μs16.18KB000000000000041720000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 160μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 157μs16.18KB000000000000041740000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 184μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 183μs16.18KB000000000000041760000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 184μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 190μs16.18KB000000000000041780000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 156μs16.18KB0000000000000416d0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB0000000000000417c0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 157μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB0000000000000417f0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB000000000000041810000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 156μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 195μs16.18KB000000000000041830000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1109μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1106μs16.18KB000000000000041850000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1106μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 189μs16.18KB000000000000041870000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 197μs16.18KB0000000000000417a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 183μs16.18KB000000000000041890000000000000000default
    Params
    • :cid: 265
  • 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.nSort144μs16.13KB0000000000000415a0000000000000000default
  • SELECT 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.lft455μs18.16KB6000000000000415a0000000000000000default
    Params
    • :langID: 1
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 170μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1104μs16.18KB000000000000041920000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1108μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1103μs16.18KB000000000000041940000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1102μs16.18KB000000000000041960000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 159μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 183μs16.18KB000000000000041980000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 170μs16.18KB0000000000000418f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB0000000000000419c0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB0000000000000419f0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1102μs16.18KB000000000000041a10000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 156μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1103μs16.18KB000000000000041a30000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 157μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 185μs16.18KB000000000000041a50000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 185μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB0000000000000419a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041a90000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041ac0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 149μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041ae0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041b00000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041b20000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1104μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB000000000000041b40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB000000000000041a70000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB000000000000041b60000000000000000default
    Params
    • :cid: 265
  • 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.nSort98μs16.13KB0000000000000417a0000000000000000default
  • SELECT 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.lft488μs18.16KB6000000000000417a0000000000000000default
    Params
    • :langID: 6
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1123μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1105μs16.18KB000000000000041bf0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1102μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1115μs16.18KB000000000000041c10000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1109μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1104μs16.18KB000000000000041c30000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 157μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 185μs16.18KB000000000000041c50000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041bc0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041c90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041cc0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1107μs16.18KB000000000000041ce0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 188μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041d00000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 155μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041d20000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1103μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1107μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 160μs16.18KB000000000000041c70000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 183μs16.18KB000000000000041d60000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 184μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 182μs16.18KB000000000000041d90000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041db0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041dd0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041df0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB000000000000041e10000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041d40000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041e30000000000000000default
    Params
    • :cid: 265
  • 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.nSort115μs16.13KB000000000000041a70000000000000000default
  • SELECT 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.lft532μs18.16KB600000000000041a70000000000000000default
    Params
    • :langID: 5
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1115μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 171μs16.18KB000000000000041ec0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1130μs16.18KB000000000000041ee0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1106μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1103μs16.18KB000000000000041f00000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 156μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041f20000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 154μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041e90000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1104μs16.18KB000000000000041f60000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB000000000000041f90000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 182μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 153μs16.18KB000000000000041fb0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB000000000000041fd0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041ff0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000041f40000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000042030000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000042060000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 152μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000042080000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 151μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 150μs16.18KB0000000000000420a0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1103μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1102μs16.18KB0000000000000420c0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 184μs16.18KB0000000000000420e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 182μs16.18KB000000000000042010000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 187μs16.18KB000000000000042100000000000000000default
    Params
    • :cid: 265
  • 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.nSort126μs16.13KB000000000000041d40000000000000000default
  • SELECT 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.lft473μs18.16KB600000000000041d40000000000000000default
    Params
    • :langID: 3
    • :cgID: 1
    • :startCat: 
    • :startLvl: 
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 199μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1136μs16.18KB000000000000042190000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1134μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1132μs16.18KB0000000000000421b0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1133μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 1136μs16.18KB0000000000000421d0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 174μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 179μs16.18KB0000000000000421f0000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000042160000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042230000000000000000default
    Params
    • :cid: 248
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 148μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042260000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042280000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422a0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 149μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422c0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042210000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042300000000000000000default
    Params
    • :cid: 246
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042330000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 146μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042350000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042370000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB000000000000042390000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000423b0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000422e0000000000000000default
    Params
    • :cid: 265
  • SELECT cPfad AS path FROM tkategoriepict WHERE kKategorie = :cid LIMIT 147μs16.18KB0000000000000423d0000000000000000default
    Params
    • :cid: 265
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort214μs17KB000000000000042100000000000000000default
    Params
    • :cid: 247
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?68μs16.8KB000000000000041e10000000000000000default
    Params
    • 0: 247
  • 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 NULL291μs18.47KB600000000000041230000000000000000default
    Params
    • :kid: 240
    • :cgid: 1
  • SELECT COALESCE(tkategorieattributsprache.cName, tkategorieattribut.cName) cName, COALESCE(tkategorieattributsprache.cWert, tkategorieattribut.cWert) cWert, COALESCE(tkategorieattributsprache.kSprache, tsprache.kSprache) kSprache, tkategorieattribut.bIstFunktionsAttribut, tkategorieattribut.nSort FROM tkategorieattribut LEFT JOIN tkategorieattributsprache ON tkategorieattributsprache.kAttribut = tkategorieattribut.kKategorieAttribut LEFT JOIN tsprache ON tsprache.cStandard = 'Y' WHERE kKategorie = :cid ORDER BY tkategorieattribut.bIstFunktionsAttribut DESC, tkategorieattribut.nSort194μs17KB000000000000041f40000000000000000default
    Params
    • :cid: 240
  • SELECT * FROM tkategorie WHERE `kOberKategorie`=?112μs16.82KB1000000000000413e0000000000000000default
    Params
    • 0: 240
  • 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 1331μs16.79KB100000000000041e30000000000000000default
    Params
    • :cgid: 1
    • :pid: 92698
    • :cid: 247
  • 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 11.23ms16.79KB100000000000041e30000000000000000default
    Params
    • :cgid: 1
    • :pid: 92698
    • :cid: 247
  • SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid94μs16.22KB1000000000000423b0000000000000000default
    Params
    • :pid: 92697
  • 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.52KB1000000000000423f0000000000000000default
    Params
    • :lid: 1
    • :cgid: 1
    • :pid: 92697
    • :bsms: 10
    • :trmr: 3
  • SELECT cName FROM teinheit WHERE kEinheit = (SELECT kEinheit FROM teinheit WHERE cName = :vpe LIMIT 0, 1) AND kSprache = :lid LIMIT 0, 1158μs16.4KB0000000000000423f0000000000000000default
    Params
    • :vpe: 
    • :lid: 1
  • SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid155μs16.28KB100000000000042450000000000000000default
    Params
    • :pid: 92697
    • :cgid: 1
  • SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid127μs16.19KB100000000000042450000000000000000default
    Params
    • :pid: 92697
  • SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb161μs16.25KB100000000000042450000000000000000default
    Params
    • :priceID: 31964
  • 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 = :customerGroup134μs17.08KB000000000000042430000000000000000default
    Params
    • :productID: 92697
    • :customerGroup: 1
  • 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 = :pid153μs16.95KB1000000000000424a0000000000000000default
    Params
    • :pid: 92697
  • SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut65μs16.17KB000000000000042470000000000000000default
    Params
    • :kArtikel: 92697
  • SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort65μs16.25KB000000000000042470000000000000000default
    Params
    • :kArtikel: 92697
  • SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr73μs16.22KB100000000000042470000000000000000default
    Params
    • :pid: 92697
  • 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.kMerkmal114μs16.55KB0000000000000424d0000000000000000default
    Params
    • :kArtikel: 92697
  • SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?70μs16.82KB0000000000000424d0000000000000000default
    Params
    • 0: 92697
    • 1: steuertext
  • 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 DESC157μs16.77KB0000000000000424d0000000000000000default
    Params
    • :pid: 92697
  • SELECT tartikelkonfiggruppe.kKonfiggruppe FROM tartikelkonfiggruppe JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe AND tartikelkonfiggruppe.kArtikel = :pid68μs16.34KB0000000000000424d0000000000000000default
    Params
    • :pid: 92697
  • SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id72μs16.22KB100000000000042610000000000000000default
    Params
    • :key: kArtikel
    • :id: 92697
  • SELECT kStueckliste AS id, fLagerbestand AS stock FROM tartikel WHERE kArtikel = :pid55μs16.22KB1000000000000425d0000000000000000default
    Params
    • :pid: 92699
  • 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.52KB1000000000000425b0000000000000000default
    Params
    • :lid: 1
    • :cgid: 1
    • :pid: 92699
    • :bsms: 10
    • :trmr: 3
  • SELECT cName FROM teinheit WHERE kEinheit = (SELECT kEinheit FROM teinheit WHERE cName = :vpe LIMIT 0, 1) AND kSprache = :lid LIMIT 0, 1123μs16.4KB0000000000000425b0000000000000000default
    Params
    • :vpe: 
    • :lid: 1
  • SELECT kPreis, noDiscount, kKunde FROM tpreis AS p WHERE kArtikel = :pid AND kKundengruppe = :cgid142μs16.28KB100000000000042670000000000000000default
    Params
    • :pid: 92699
    • :cgid: 1
  • SELECT kSteuerklasse, fMwSt FROM tartikel WHERE kArtikel = :pid82μs16.19KB100000000000042670000000000000000default
    Params
    • :pid: 92699
  • SELECT nAnzahlAb, fVKNetto FROM tpreisdetail WHERE kPreis = :priceID ORDER BY nAnzahlAb99μs16.25KB100000000000042670000000000000000default
    Params
    • :priceID: 31978
  • 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 = :customerGroup125μs17.08KB000000000000042650000000000000000default
    Params
    • :productID: 92699
    • :customerGroup: 1
  • 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 = :pid116μs16.95KB1000000000000426c0000000000000000default
    Params
    • :pid: 92699
  • SELECT cName, cWert FROM tartikelattribut WHERE `kArtikel`=:kArtikel ORDER BY kArtikelAttribut60μs16.17KB000000000000042690000000000000000default
    Params
    • :kArtikel: 92699
  • SELECT * FROM tattribut WHERE `kArtikel`=:kArtikel ORDER BY nSort59μs16.25KB000000000000042690000000000000000default
    Params
    • :kArtikel: 92699
  • SELECT cPfad, nNr FROM tartikelpict WHERE kArtikel = :pid ORDER BY nNr65μs16.22KB100000000000042690000000000000000default
    Params
    • :pid: 92699
  • 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.kMerkmal100μs16.55KB0000000000000426f0000000000000000default
    Params
    • :kArtikel: 92699
  • SELECT * FROM tattribut WHERE `kArtikel`=? AND `cName`=?67μs16.82KB0000000000000426f0000000000000000default
    Params
    • 0: 92699
    • 1: steuertext
  • 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 DESC142μs16.77KB0000000000000426f0000000000000000default
    Params
    • :pid: 92699
  • SELECT tartikelkonfiggruppe.kKonfiggruppe FROM tartikelkonfiggruppe JOIN tkonfigitem ON tkonfigitem.kKonfiggruppe = tartikelkonfiggruppe.kKonfiggruppe AND tartikelkonfiggruppe.kArtikel = :pid66μs16.34KB0000000000000426f0000000000000000default
    Params
    • :pid: 92699
  • SELECT cSeo, kSprache FROM tseo WHERE cKey = :key AND kKey = :id71μs16.22KB100000000000042830000000000000000default
    Params
    • :key: kArtikel
    • :id: 92699
  • 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 nSort143μs16.88KB000000000000042950000000000000000default
    Params
    • :iso: %DE%
    • :cGroupID: 1
    • :sClasses: ^([0-9 -]* )?
    • :depOnly: Y
  • SELECT thersteller.kHersteller, thersteller.cName, thersteller.cHomepage, thersteller.nSortNr, thersteller.cBildpfad, therstellersprache.cMetaTitle, therstellersprache.cMetaKeywords, therstellersprache.cMetaDescription, therstellersprache.cBeschreibung, tseo.cSeo, thersteller.cSeo AS originalSeo, therstellersprache.kSprache FROM thersteller LEFT JOIN therstellersprache ON therstellersprache.kHersteller = thersteller.kHersteller LEFT JOIN tseo ON tseo.kKey = thersteller.kHersteller AND tseo.cKey = :skey AND tseo.kSprache = therstellersprache.kSprache WHERE EXISTS ( SELECT 1 FROM tartikel WHERE tartikel.kHersteller = thersteller.kHersteller AND NOT EXISTS ( SELECT 1 FROM tartikelsichtbarkeit WHERE tartikelsichtbarkeit.kArtikel = tartikel.kArtikel AND tartikelsichtbarkeit.kKundengruppe = :cgid ) ) GROUP BY thersteller.kHersteller, therstellersprache.kSprache ORDER BY thersteller.nSortNr, thersteller.cName6.96ms18.19KB2400000000000042b20000000000000000default
    Params
    • :skey: kHersteller
    • :cgid: 1
  • 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 NULL243μs16.02KB000000000000042ca0000000000000000default
  • SELECT 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.96KB000000000000042b80000000000000000default
    Params
    • :attr: gratisgeschenk ab
    • :no: N
    • :yes: Y
    • :cgid: 1
  • 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 DESC504μs16.72KB900000000000042fa0000000000000000default
    Params
    • :state: 2
  • 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μs688B000000000000043230000000000000000default
    Params
    • :interval: 3
  • DELETE FROM tbesucher WHERE dLetzteAktivitaet <= DATE_SUB(NOW(), INTERVAL :interval HOUR)157μs128B000000000000043230000000000000000default
    Params
    • :interval: 3
  • SELECT * FROM tbesucher WHERE `cSessID`=?145μs16.91KB000000000000043230000000000000000default
    Params
    • 0: h7l2c940psglau255jmjvq6gn6
  • SELECT * FROM tbesucher WHERE `cID`=?139μs16.91KB000000000000043230000000000000000default
    Params
    • 0: 957105a92a6b1bf8090752ef21ffcbd5
  • 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.07KB100000000000045130000000000000000default
    Params
    • :kBesucher: 
    • :cIP: 18.188.0.0
    • :cSessID: h7l2c940psglau255jmjvq6gn6
    • :cID: 957105a92a6b1bf8090752ef21ffcbd5
    • :kKunde: 
    • :kBestellung: 
    • :cEinstiegsseite: /Orange-4442
    • :cReferer: 
    • :cUserAgent: Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko; compatible; ClaudeBot/1.0; +claudebot@anthropic.com)
    • :cBrowser: Sonstige
    • :cAusstiegsseite: /Orange-4442
    • :dLetzteAktivitaet: 2025-01-25 23:48:42
    • :dZeit: 2025-01-25 23:48:42
    • :kBesucherBot: 
  • SELECT *, DATE_FORMAT(dErstellt, '%d.%m.%Y %H:%i:%s') AS dErstellt_DE FROM tkampagne WHERE `nAktiv`=:nAktiv302μs16.38KB300000000000045130000000000000000default
    Params
    • :nAktiv: 1
  • SELECT cClass, kInitial FROM textensionpoint WHERE (kSprache = :lid OR kSprache = 0) AND (kKundengruppe = :cgid OR kKundengruppe = 0) AND (nSeite = :ptype OR nSeite = 0) AND ( (cKey = :cky AND (cValue = :cval OR cValue = '')) OR cValue = '')121μs16.42KB0000000000000450a0000000000000000default
    Params
    • :lid: 1
    • :cgid: 1
    • :ptype: 1
    • :cky: kArtikel
    • :cval: 92698
  • SELECT * FROM tboxenanzeige231μs17.33KB8000000000000045020000000000000000default
  • SELECT tboxen.kBox, tboxen.kBoxvorlage, tboxen.kCustomID, tboxen.kContainer, tboxen.cTitel, tboxen.ePosition, tboxensichtbar.kSeite, tboxensichtbar.nSort, tboxensichtbar.cFilter, tboxvorlage.eTyp, tboxvorlage.cVerfuegbar, tboxvorlage.cName, tboxvorlage.cTemplate, tplugin.nStatus AS pluginStatus, GROUP_CONCAT(tboxensichtbar.nSort) AS sortBypageIDs, GROUP_CONCAT(tboxensichtbar.kSeite) AS pageIDs, GROUP_CONCAT(tboxensichtbar.bAktiv) AS pageVisibilities, tsprache.kSprache, tboxsprache.cInhalt, tboxsprache.cTitel FROM tboxen LEFT JOIN tboxensichtbar ON tboxen.kBox = tboxensichtbar.kBox LEFT JOIN tplugin ON tboxen.kCustomID = tplugin.kPlugin LEFT JOIN tboxvorlage ON tboxen.kBoxvorlage = tboxvorlage.kBoxvorlage LEFT JOIN tboxsprache ON tboxsprache.kBox = tboxen.kBox LEFT JOIN tsprache ON tsprache.cISO = tboxsprache.cISO WHERE tboxen.kContainer > -1 AND FIND_IN_SET(tboxensichtbar.kSeite, "0,1,2,3,4,5,7,8,9,10,11,12,14,15,16,17,18,19,20,21,23,24,25,26,27,28,29,31,32,33,36,38,40,41,42") > 0 AND tboxen.ePosition IN ('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 ASC2.15ms16.56KB4000000000000448a0000000000000000default
  • SELECT kPlugin, cPluginID, bExtension FROM tplugin70μs16.27KB1100000000000044700000000000000000default
  • SELECT * FROM tplugin WHERE `kPlugin`=?76μs17.23KB1000000000000447d0000000000000000default
    Params
    • 0: 23
  • SELECT tstoreauth.auth_code, tstoreauth.access_token, tadminlogin.cPass AS hash, tstoreauth.verified FROM tstoreauth INNER JOIN tadminlogin ON tadminlogin.kAdminlogin = tstoreauth.owner LIMIT 1374μs16.11KB1000000000000448f0000000000000000default
  • SELECT * FROM licenses WHERE returnCode = 200 ORDER BY id DESC LIMIT 1561μs56.11KB100000000000044bb0000000000000000default
  • SELECT * FROM tplugin WHERE `exsID`=?127μs17.23KB100000000000044230000000000000000default
    Params
    • 0: 5ad601de-2bb4-4ffd-9c9d-5de4e6146782
  • SELECT * FROM tplugin WHERE `exsID`=?117μs17.22KB000000000000044110000000000000000default
    Params
    • 0: 2e0916bd-73a6-4ee5-a2c2-116dbe7b262f
  • SELECT * FROM tplugin WHERE `exsID`=?117μs17.23KB100000000000044000000000000000000default
    Params
    • 0: d5c1f01a-9c07-4c8c-9677-cbb5f0a20304
  • SELECT * FROM tplugin WHERE `exsID`=?149μs17.23KB100000000000043f00000000000000000default
    Params
    • 0: c477df88-3226-4578-a600-6485fbcc1254
  • SELECT * FROM tplugin WHERE `exsID`=?141μs17.22KB000000000000043c20000000000000000default
    Params
    • 0: 0774d849-014e-423c-b21e-08b80cf4a00e
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort437μs16.28KB100000000000044870000000000000000default
    Params
    • :kPlugin: 23
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin201μs16.24KB000000000000044b40000000000000000default
    Params
    • :kPlugin: 23
  • 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.kLink253μs16.4KB0000000000000448d0000000000000000default
    Params
    • :plgn: 23
  • SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort1.34ms17.94KB4600000000000044b10000000000000000default
    Params
    • :pid: 23
  • 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.kPluginSprachvariable1.74ms36.81KB195000000000000440f0000000000000000default
    Params
    • :pid: 23
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin300μs16.38KB000000000000044d00000000000000000default
    Params
    • :kPlugin: 23
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id293μs16.88KB000000000000044d30000000000000000default
    Params
    • :id: 23
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid299μs16.94KB0000000000000449c0000000000000000default
    Params
    • :pid: kPlugin\_23\_%
  • SELECT * FROM tplugin WHERE `kPlugin`=?83μs17.23KB100000000000044da0000000000000000default
    Params
    • 0: 328
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort81μs16.28KB100000000000044dc0000000000000000default
    Params
    • :kPlugin: 328
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin64μs16.32KB500000000000044e00000000000000000default
    Params
    • :kPlugin: 328
  • SELECT tlink.kLink FROM tlink JOIN tlinksprache ON tlink.kLink = tlinksprache.kLink JOIN tsprache ON tsprache.cISO = tlinksprache.cISOSprache WHERE tlink.kPlugin = :plgn GROUP BY tlink.kLink111μs16.4KB000000000000044e40000000000000000default
    Params
    • :plgn: 328
  • 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.nSort254μs17.19KB000000000000044a30000000000000000default
    Params
    • :pid: 328
  • 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.kPluginSprachvariable580μs16.91KB600000000000044e90000000000000000default
    Params
    • :pid: 328
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin103μs16.38KB000000000000044a80000000000000000default
    Params
    • :kPlugin: 328
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id135μs16.91KB000000000000044a70000000000000000default
    Params
    • :id: 328
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid85μs16.94KB000000000000044e80000000000000000default
    Params
    • :pid: kPlugin\_328\_%
  • SELECT * FROM tplugin WHERE `kPlugin`=?69μs17.23KB100000000000044ed0000000000000000default
    Params
    • 0: 330
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort81μs16.36KB600000000000044ad0000000000000000default
    Params
    • :kPlugin: 330
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin61μs16.29KB300000000000044fe0000000000000000default
    Params
    • :kPlugin: 330
  • 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.kLink131μs16.43KB200000000000044ae0000000000000000default
    Params
    • :plgn: 330
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (199,200)65μs16.11KB2000000000000445e0000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (199,200) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName1.32ms17.06KB1200000000000044520000000000000000default
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid89μs16.12KB100000000000044490000000000000000default
    Params
    • :lid: 200
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink57μs16.12KB0000000000000444b0000000000000000default
    Params
    • :kVaterLink: 200
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid46μs16.12KB100000000000044470000000000000000default
    Params
    • :lid: 199
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink50μs16.12KB000000000000044430000000000000000default
    Params
    • :kVaterLink: 199
  • 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.nSort211μs17.19KB000000000000045000000000000000000default
    Params
    • :pid: 330
  • 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.kPluginSprachvariable480μs17.56KB4200000000000044500000000000000000default
    Params
    • :pid: 330
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin99μs16.38KB000000000000043e80000000000000000default
    Params
    • :kPlugin: 330
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id128μs16.91KB000000000000043e50000000000000000default
    Params
    • :id: 330
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid84μs16.94KB000000000000043ed0000000000000000default
    Params
    • :pid: kPlugin\_330\_%
  • SELECT * FROM tplugin WHERE `kPlugin`=?69μs17.23KB100000000000044380000000000000000default
    Params
    • 0: 182
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort74μs16.28KB100000000000044390000000000000000default
    Params
    • :kPlugin: 182
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin57μs16.24KB000000000000044910000000000000000default
    Params
    • :kPlugin: 182
  • 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.kLink102μs16.4KB0000000000000443e0000000000000000default
    Params
    • :plgn: 182
  • SELECT c.kPluginEinstellungenConf AS id, c.cName AS name, c.cBeschreibung AS description, c.kPluginAdminMenu AS menuID, c.cConf AS confType, c.nSort, c.cInputTyp AS inputType, c.cSourceFile AS sourceFile, v.cName AS confNicename, v.cWert AS confValue, v.nSort AS confSort, e.cWert AS currentValue, c.cWertName AS confName FROM tplugineinstellungenconf AS c LEFT JOIN tplugineinstellungenconfwerte AS v ON c.kPluginEinstellungenConf = v.kPluginEinstellungenConf LEFT JOIN tplugineinstellungen AS e ON e.kPlugin = c.kPlugin AND e.cName = c.cWertName WHERE c.kPlugin = :pid GROUP BY id, confValue ORDER BY c.nSort1.06ms17.81KB40000000000000444c0000000000000000default
    Params
    • :pid: 182
  • 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.kPluginSprachvariable332μs17.69KB5000000000000043cf0000000000000000default
    Params
    • :pid: 182
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin97μs16.38KB000000000000043520000000000000000default
    Params
    • :kPlugin: 182
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id135μs16.91KB000000000000043550000000000000000default
    Params
    • :id: 182
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid84μs16.94KB000000000000043570000000000000000default
    Params
    • :pid: kPlugin\_182\_%
  • SELECT * FROM tplugin WHERE `kPlugin`=?72μs17.23KB100000000000044890000000000000000default
    Params
    • 0: 183
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort84μs16.36KB600000000000044550000000000000000default
    Params
    • :kPlugin: 183
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin59μs16.3KB400000000000044530000000000000000default
    Params
    • :kPlugin: 183
  • 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.kLink139μs16.46KB4000000000000456d0000000000000000default
    Params
    • :plgn: 183
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (201,202,203,204)62μs16.14KB400000000000045670000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (201,202,203,204) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName769μs33.25KB2400000000000045410000000000000000default
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid53μs16.12KB100000000000043390000000000000000default
    Params
    • :lid: 204
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink64μs16.12KB0000000000000432b0000000000000000default
    Params
    • :kVaterLink: 204
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid55μs16.12KB1000000000000432c0000000000000000default
    Params
    • :lid: 203
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink58μs16.12KB0000000000000432e0000000000000000default
    Params
    • :kVaterLink: 203
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid50μs16.12KB100000000000043330000000000000000default
    Params
    • :lid: 201
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink60μs16.12KB000000000000043300000000000000000default
    Params
    • :kVaterLink: 201
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid52μs16.12KB100000000000043320000000000000000default
    Params
    • :lid: 202
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink58μs16.12KB000000000000043350000000000000000default
    Params
    • :kVaterLink: 202
  • 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.nSort605μs17.44KB15000000000000444f0000000000000000default
    Params
    • :pid: 183
  • 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.kPluginSprachvariable1.21ms88.81KB30000000000000045210000000000000000default
    Params
    • :pid: 183
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin121μs16.38KB0000000000000464a0000000000000000default
    Params
    • :kPlugin: 183
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id609μs33.07KB1000000000000046470000000000000000default
    Params
    • :id: 183
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid254μs17.02KB5000000000000463c0000000000000000default
    Params
    • :pid: kPlugin\_183\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort147μs16.55KB3000000000000463c0000000000000000default
    Params
    • :val: kPlugin_183_paypalcheckout\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart226μs16.34KB6000000000000463c0000000000000000default
    Params
    • :kZahlungsart: 103
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort86μs16.55KB3000000000000463c0000000000000000default
    Params
    • :val: kPlugin_183_rechnungskaufmitratepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart58μs16.34KB6000000000000463c0000000000000000default
    Params
    • :kZahlungsart: 104
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort83μs16.55KB3000000000000463c0000000000000000default
    Params
    • :val: kPlugin_183_paypalkreditkarte\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart57μs16.34KB6000000000000463c0000000000000000default
    Params
    • :kZahlungsart: 105
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort81μs16.55KB3000000000000463c0000000000000000default
    Params
    • :val: kPlugin_183_googlepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart100μs16.34KB6000000000000463c0000000000000000default
    Params
    • :kZahlungsart: 112
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort84μs16.55KB3000000000000463c0000000000000000default
    Params
    • :val: kPlugin_183_applepay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart57μs16.34KB6000000000000463c0000000000000000default
    Params
    • :kZahlungsart: 113
  • SELECT * FROM tplugin WHERE `kPlugin`=?71μs17.23KB100000000000045f00000000000000000default
    Params
    • 0: 220
  • SELECT * FROM tpluginadminmenu WHERE `kPlugin`=:kPlugin ORDER BY nSort92μs16.34KB500000000000045eb0000000000000000default
    Params
    • :kPlugin: 220
  • SELECT * FROM tpluginhook WHERE `kPlugin`=:kPlugin63μs16.37KB800000000000045e70000000000000000default
    Params
    • :kPlugin: 220
  • 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.kLink178μs16.52KB8000000000000458a0000000000000000default
    Params
    • :plgn: 220
  • SELECT `kLink`, `reference`, `kVaterLink` FROM tlink WHERE kLink IN (191,192,193,194,195,196,197,198)68μs16.2KB800000000000043c60000000000000000default
  • SELECT tlink.*, loc.cISOSprache, tlink.cName AS displayName, loc.cName AS localizedName, loc.cTitle AS localizedTitle, loc.cContent AS content, loc.cSeo AS linkURL, loc.cMetaDescription AS metaDescription, loc.cMetaKeywords AS metaKeywords, loc.cMetaTitle AS metaTitle, tsprache.kSprache, tsprache.kSprache AS languageID, tseo.cSeo AS localizedUrl, tspezialseite.cDateiname, tplugin.nStatus AS pluginState, pld.cDatei AS handler, pld.cTemplate AS template, pld.cFullscreenTemplate AS fullscreenTemplate, GROUP_CONCAT(assoc.linkGroupID) AS linkGroups FROM tlink JOIN tlinksprache loc ON tlink.kLink = loc.kLink JOIN tsprache ON tsprache.cISO = loc.cISOSprache LEFT JOIN tseo ON tseo.cKey = 'kLink' AND tseo.kKey = loc.kLink AND tseo.kSprache = tsprache.kSprache LEFT JOIN tlinkgroupassociations assoc ON assoc.linkID = loc.kLink LEFT JOIN tspezialseite ON tspezialseite.nLinkart = tlink.nLinkart LEFT JOIN tplugin ON tplugin.kPlugin = tlink.kPlugin LEFT JOIN tpluginlinkdatei pld ON tplugin.kPlugin = pld.kPlugin AND tlink.kLink = pld.kLink WHERE tlink.kLink IN (191,192,193,194,195,196,197,198) GROUP BY tlink.kLink, tsprache.kSprache ORDER BY tlink.nSort, tlink.cName984μs33.63KB4800000000000045ad0000000000000000default
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid56μs16.12KB100000000000043240000000000000000default
    Params
    • :lid: 197
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink96μs16.12KB000000000000045610000000000000000default
    Params
    • :kVaterLink: 197
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid46μs16.12KB100000000000045690000000000000000default
    Params
    • :lid: 193
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink48μs16.12KB000000000000045670000000000000000default
    Params
    • :kVaterLink: 193
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid40μs16.12KB100000000000043360000000000000000default
    Params
    • :lid: 191
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink46μs16.12KB000000000000043310000000000000000default
    Params
    • :kVaterLink: 191
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid39μs16.12KB1000000000000458c0000000000000000default
    Params
    • :lid: 192
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink73μs16.12KB0000000000000459b0000000000000000default
    Params
    • :kVaterLink: 192
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid68μs16.12KB100000000000045a70000000000000000default
    Params
    • :lid: 196
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB000000000000045a30000000000000000default
    Params
    • :kVaterLink: 196
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid39μs16.12KB100000000000045a00000000000000000default
    Params
    • :lid: 195
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB000000000000045a50000000000000000default
    Params
    • :kVaterLink: 195
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid39μs16.12KB100000000000045a20000000000000000default
    Params
    • :lid: 194
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink45μs16.12KB0000000000000459f0000000000000000default
    Params
    • :kVaterLink: 194
  • SELECT `reference` FROM `tlink` WHERE kLink = :lid50μs16.12KB1000000000000458f0000000000000000default
    Params
    • :lid: 198
  • SELECT kLink FROM tlink WHERE `kVaterLink`=:kVaterLink47μs16.12KB000000000000045990000000000000000default
    Params
    • :kVaterLink: 198
  • 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.nSort276μs17.23KB300000000000045e50000000000000000default
    Params
    • :pid: 220
  • 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.kPluginSprachvariable1.73ms104.81KB510000000000000457f0000000000000000default
    Params
    • :pid: 220
  • SELECT * FROM tadminwidgets WHERE `kPlugin`=:kPlugin107μs16.38KB000000000000047fc0000000000000000default
    Params
    • :kPlugin: 220
  • SELECT * FROM temailvorlage JOIN temailvorlagesprache AS loc ON loc.kEmailvorlage = temailvorlage.kEmailvorlage WHERE temailvorlage.kPlugin = :id450μs49.41KB3000000000000047f90000000000000000default
    Params
    • :id: 220
  • SELECT * FROM tzahlungsart JOIN tpluginzahlungsartklasse ON tpluginzahlungsartklasse.cModulID = tzahlungsart.cModulId WHERE tzahlungsart.cModulId LIKE :pid130μs16.95KB100000000000047da0000000000000000default
    Params
    • :pid: kPlugin\_220\_%
  • SELECT * FROM tplugineinstellungenconf WHERE cWertName LIKE :val AND cConf = 'Y' ORDER BY nSort92μs16.55KB300000000000047da0000000000000000default
    Params
    • :val: kPlugin_220_amazonpay\_%
  • SELECT * FROM tzahlungsartsprache WHERE `kZahlungsart`=:kZahlungsart63μs16.34KB600000000000047da0000000000000000default
    Params
    • :kZahlungsart: 114
global
array:52 [ "global_wunschliste_artikel_loeschen_nach_kauf" => "N" "global_versandermittlung_lief...
startseite
array:8 [ "startseite_neuimsortiment_anzahl" => 0 "startseite_neuimsortiment_sortnr" => 1 "sta...
emails
array:11 [ "email_methode" => "smtp" "email_sendmail_pfad" => "" "email_smtp_hostname" => "tec...
artikeluebersicht
array:51 [ "suche_prio_anmerkung" => 0 "suche_prio_name" => 10 "suche_prio_suchbegriffe" => 9 ...
artikeldetails
array:60 [ "artikeldetails_xselling_standard_anzeigen" => "Y" "artikeldetails_xselling_kauf_anze...
kunden
array:39 [ "kundenregistrierung_abfragen_titel" => "N" "kundenregistrierung_abfragen_anrede" => ...
logo
array:1 [ "shop_logo" => "demoshop_normal.png" ]
kaufabwicklung
array:27 [ "warenkorb_warenkorb2pers_merge" => "P" "warenkorbpers_nutzen" => "Y" "bestellvorga...
boxen
array:19 [ "box_bestseller_anzahl_anzeige" => 3 "box_bestseller_anzahl_basis" => 10 "box_sonde...
bilder
array:91 [ "bilder_hintergrundfarbe" => "#ffffff" "bilder_dateiformat" => "AUTO" "container_ve...
sonstiges
array:7 [ "sonstiges_gratisgeschenk_nutzen" => "Y" "sonstiges_gratisgeschenk_anzahl" => 10 "so...
zahlungsarten
array:18 [ "zahlungsart_lastschrift_max" => "0" "zahlungsart_lastschrift_min" => "0" "zahlungs...
kontakt
array:10 [ "kontakt_abfragen_anrede" => "N" "kontakt_abfragen_vorname" => "O" "kontakt_abfrage...
rss
array:10 [ "rss_nutzen" => "N" "rss_titel" => "" "rss_description" => "" "rss_copyright" => ...
vergleichsliste
array:14 [ "vergleichsliste_anzahl" => 10 "vergleichsliste_artikelnummer" => 0 "vergleichslist...
preisverlauf
array:2 [ "preisverlauf_anzeigen" => "N" "preisverlauf_anzahl_monate" => 0 ]
bewertung
array:15 [ "bewertungserinnerung_kundengruppen" => array:1 [ 0 => "" ] "bewertung_anzeigen...
newsletter
array:15 [ "newsletter_emailmethode" => "mail" "newsletter_sendmailpfad" => "" "newsletter_smt...
kundenfeld
array:1 [ "kundenfeld_anzeigen" => "Y" ]
navigationsfilter
array:31 [ "suchtrefferfilter_anzahl" => 0 "allgemein_weiterleitung" => "Y" "allgemein_herstel...
emailblacklist
array:1 [ "blacklist_benutzen" => "N" ]
metaangaben
array:7 [ "global_meta_publisher" => "" "global_meta_copyright" => "" "global_meta_title_anhae...
news
array:10 [ "news_benutzen" => "Y" "news_kommentare_nutzen" => "N" "news_anzahl_uebersicht" => ...
sitemap
array:18 [ "sitemap_seiten_anzeigen" => "Y" "sitemap_kategorien_anzeigen" => "Y" "sitemap_hers...
suchspecials
array:6 [ "suchspecials_sortierung_inkuerzeverfuegbar" => "-1" "suchspecials_sortierung_topangeb...
auswahlassistent
array:4 [ "auswahlassistent_allefragen" => "Y" "auswahlassistent_anzahl_anzeigen" => "Y" "ausw...
cron
array:2 [ "cron_type" => "s2s" "cron_freq" => 10 ]
fs
array:14 [ "ftp_hostname" => "localhost" "ftp_port" => 21 "ftp_user" => "" "ftp_pass" => "" ...
caching
array:17 [ "caching_types_disabled" => "" "caching_activated" => "Y" "caching_method" => "redi...
consentmanager
array:2 [ "consent_manager_active" => "Y" "consent_manager_show_banner" => "1" ]
template
array:9 [ "general" => array:3 [ "use_minify" => "Y" "use_cron" => "N" "is_nova" => "Y...
branding
[]
    $_GET
    []
    $_POST
    []
    $_SESSION
    array:36 [ "kSprachISO" => 1 "FremdParameter" => [] "Warenkorb" => JTL\Cart\Cart {#580 +kW...
    $_COOKIE
    []
      Get (Hits)
      0 (0)
      Set (Successes)
      0 (0)
      Flush (Successes)
      0 (0)
      Misses/Failures
      []
      tplDir
      "/var/www/vhosts/techneo.berlin/dev.techneo.berlin/templates/NOVA/"
      parentTemplateDir
      null
      jtlDebugActive
      true
      plgnJTLDebug
      JTL\Plugin\Plugin {#6005 #id: 182 #pluginID: "jtl_debug" #state: 2 #meta: JTL\Plugin\Data\Me...
      Anfrage
      {#15846 +"cAnrede": null +"cVorname": null +"cNachname": null +"cFirma": null +"cMail": nu...
      Benachrichtigung
      {#15674 +"cAnrede": null +"cVorname": null +"cNachname": null +"cFirma": null +"cMail": nu...
      showMatrix
      false
      arNichtErlaubteEigenschaftswerte
      []
      oAehnlicheArtikel_arr
      []
      UVPlocalized
      "0,00 &#8364;"
      UVPBruttolocalized
      "0,00 &#8364;"
      Artikel
      JTL\Catalog\Product\Artikel {#15663 +kArtikel: 92698 +kHersteller: 0 +kLieferstatus: 0 +kSte...
      Xselling
      {#17023 +"kArtikelXSellerKey_arr": [] +"oArtikelArr": [] +"Standard": {#15676 +"XSellGrupp...
      Artikelhinweise
      []
      verfuegbarkeitsBenachrichtigung
      0
      BlaetterNavi
      {#16775 +"nAktiv": 0 +"nSterne": 0 +"nAktuelleSeite": 1 +"nVon": 1 +"nBis": 9 }
      BewertungsTabAnzeigen
      1
      alertNote
      false
      bewertungSterneSelected
      0
      bPreisverlauf
      false
      preisverlaufData
      null
      NavigationBlaettern
      {#16897 +"vorherigerArtikel": JTL\Catalog\Product\Artikel {#16867 +kArtikel: 92697 +kHerst...
      bereitsBewertet
      false
      ratingPagination
      JTL\Pagination\Pagination {#17037 -id: "ratings" -dispPagesRadius: 2 -itemsPerPageOptions: arr...
      linkgroups
      JTL\Link\LinkGroupCollection {#14534 #items: array:8 [ 0 => JTL\Link\LinkGroup {#14608 -...
      NaviFilter
      JTL\Filter\ProductFilter {#15581 -category: JTL\Filter\States\BaseCategory {#15575 #icon: null...
      manufacturers
      array:4 [ 2 => JTL\Catalog\Hersteller {#17105 -kHersteller: 2 -names: array:6 [ 1 =>...
      oUnterKategorien_arr
      []
      session_name
      "JTLSHOP"
      session_id
      "h7l2c940psglau255jmjvq6gn6"
      NettoPreise
      0
      KaufabwicklungsURL
      "https://dev-at.techneo.berlin/Bestellvorgang"
      WarenkorbArtikelAnzahl
      0
      WarenkorbArtikelPositionenanzahl
      0
      WarenkorbWarensumme
      array:2 [ 0 => "0,00 &#8364;" 1 => "0,00 &#8364;" ]
      WarenkorbGesamtsumme
      array:2 [ 0 => "0,00 &#8364;" 1 => "0,00 &#8364;" ]
      WarenkorbGesamtgewicht
      0
      Warenkorbtext
      "Es befinden sich keine Artikel im Warenkorb."
      zuletztInWarenkorbGelegterArtikel
      null
      WarenkorbVersandkostenfreiHinweis
      ""
      nextFreeGiftMissingAmount
      0.0
      oSpezialseiten_arr
      Illuminate\Support\Collection {#17123 #items: array:25 [ 5 => JTL\Link\Link {#14624 -dat...
      bAjaxRequest
      false
      jtl_token
      "<input type="hidden" class="jtl_token" name="jtl_token" value="39bddc89737cab310c4bbb470f1cc3d11bc8...
      nSeitenTyp
      1
      bExclusive
      false
      bAdminWartungsmodus
      false
      WarensummeLocalized
      array:2 [ 0 => "0,00 &#8364;" 1 => "0,00 &#8364;" ]
      Steuerpositionen
      []
      FavourableShipping
      null
      favourableShippingString
      ""
      Einstellungen
      array:32 [ "global" => array:52 [ "global_wunschliste_artikel_loeschen_nach_kauf" => "N" "...
      deletedPositions
      []
      updatedPositions
      []
      Firma
      JTL\Firma {#17109 +cName: "[tech]NEO GmbH" +cUnternehmer: "Mirko Lange" +cStrasse: "Storkower ...
      showLoginCaptcha
      false
      AktuelleKategorie
      JTL\Catalog\Category\Kategorie {#15842 -parentID: 240 -sort: 0 -names: array:6 [ 2 => "Und...
      Suchergebnisse
      JTL\Filter\SearchResults {#15653 -products: Illuminate\Support\Collection {#15659 #items: [] ...
      cSessionID
      "h7l2c940psglau255jmjvq6gn6"
      opc
      JTL\OPC\Service {#15841 #adminName: "" #adminLangTag: "de-DE" #db: JTL\OPC\DB {#15839 #map...
      opcPageService
      JTL\OPC\PageService {#17139 #adminName: "" #curPage: null #opc: JTL\OPC\Service {#15841 #a...
      wishlists
      Illuminate\Support\Collection {#17136 #items: [] #escapeWhenCastingToString: false }
      shippingCountry
      "AT"
      countries
      Illuminate\Support\Collection {#1864 #items: array:238 [ 60 => JTL\Country\Country {#628 ...
      Link
      JTL\Link\Link {#17040 -data: [] #id: 0 #level: 0 #parent: 0 #linkGroupID: -1 #pluginID: ...
      cPluginCss_arr
      array:6 [ 0 => "plugins/jtl_dhlwunschpaket/frontend/css/jtl_pack.css" 1 => "plugins/jtl_paypal_c...
      cPluginJsHead_arr
      array:1 [ 0 => "plugins/tn_multiDomain/frontend/js/multiDomain.js" ]
      cPluginJsBody_arr
      array:2 [ 0 => "plugins/jtl_debug/frontend/js/jtl-debug.js" 1 => "plugins/jtl_dhlwunschpaket/fro...
      minifiedCSS
      array:2 [ "clear.css" => "asset/clear.css?v=1.3.1" "plugin_css" => "asset/plugin_css?v=1.3.1" ]
      minifiedJS
      array:3 [ "jtl3.js" => "asset/jtl3.js?v=1.3.1" "plugin_js_head" => "asset/plugin_js_head?v=1.3.1...
      combinedCSS
      "asset/clear.css,plugin_css?v=1.3.1"
      cCSS_arr
      array:2 [ 0 => "templates/NOVA/themes/clear/clear.css" 1 => "templates/NOVA/themes/clear/custom....
      cJS_arr
      array:21 [ 0 => "templates/NOVA/js/bootstrap-toolkit.js" 1 => "templates/NOVA/js/bootstrap.bundl...
      device
      Mobile_Detect {#17145 #cache: [] #userAgent: "Mozilla/5.0 AppleWebKit/537.36 (KHTML, like Gecko;...
      isMobile
      false
      isTablet
      false
      ShopURL
      "https://dev-at.techneo.berlin"
      opcDir
      "/var/www/vhosts/techneo.berlin/dev.techneo.berlin/admin/opc/"
      PFAD_SLIDER
      "https://dev-at.techneo.berlin/bilder/slider/"
      isNova
      true
      nTemplateVersion
      "1.3.1"
      currentTemplateDir
      "templates/NOVA/"
      currentTemplateDirFull
      "https://dev-at.techneo.berlin/templates/NOVA/"
      currentTemplateDirFullPath
      "/var/www/vhosts/techneo.berlin/dev.techneo.berlin/templates/NOVA/"
      currentThemeDir
      "templates/NOVA/themes/clear/"
      currentThemeDirFull
      "https://dev-at.techneo.berlin/templates/NOVA/themes/clear/"
      isFluidTemplate
      false
      shopFaviconURL
      "https://dev-at.techneo.berlin/bilder/intern/shoplogo/domain6_icon.jpg"
      ShopLogoURL
      "https://dev-at.techneo.berlin/bilder/intern/shoplogo/domain6_logo.jpg"
      lang
      "ger"
      ShopHomeURL
      "https://dev-at.techneo.berlin"
      ShopURLSSL
      "https://dev-at.techneo.berlin"
      imageBaseURL
      "https://dev-at.techneo.berlin/"
      isAjax
      false
      meta_title
      "Orange - 4442"
      meta_description
      "Orangen sind richtige Vitamin-C-Bomben Schon ein Glas Orangensaft am Tag deckt unseren Vitamin-C-Be...
      meta_keywords
      ""
      meta_publisher
      ""
      meta_copyright
      ""
      meta_language
      "de"
      bNoIndex
      false
      cCanonicalURL
      "https://dev-at.techneo.berlin/Orange-4442"
      robotsContent
      null
      cShopName
      "dev[tech]NEO"
      jtlPackPlugin
      JTL\Plugin\Plugin {#46 #id: 23 #pluginID: "jtl_dhlwunschpaket" #state: 2 #meta: JTL\Plugin\D...
      jtlPackFormTranslations
      "{"default":{"street":"Stra\u00dfe","streetnumber":"Hausnummer","additional":"Adresszusatz"},"packst...
      bBoxenFilterNach
      true
      multiDomain
      "active"
      multiDomainWaehrungDropdown
      "0"
      multiDomainLanguageDropdown
      "1"
      oPlugin_jtl_dhlwunschpaket
      JTL\Plugin\Plugin {#17536 #id: 23 #pluginID: "jtl_dhlwunschpaket" #state: 2 #meta: JTL\Plugi...
      oPlugin_tn_licenseManager
      JTL\Plugin\Plugin {#17650 #id: 330 #pluginID: "tn_licenseManager" #state: 2 #meta: JTL\Plugi...
      oPlugin_jtl_debug
      JTL\Plugin\Plugin {#17460 #id: 182 #pluginID: "jtl_debug" #state: 2 #meta: JTL\Plugin\Data\M...
      oPlugin_jtl_paypal_commerce
      JTL\Plugin\Plugin {#17245 #id: 183 #pluginID: "jtl_paypal_commerce" #state: 2 #meta: JTL\Plu...
      oPlugin_s360_amazonpay_shop5
      JTL\Plugin\Plugin {#17982 #id: 220 #pluginID: "s360_amazonpay_shop5" #state: 2 #meta: JTL\Pl...
      parentBlockParams
      array:27 [ "class" => scc\ComponentProperty {#18268 -isRequired: false -value: "" -nam...
      pbp
      array:27 [ "class" => scc\ComponentProperty {#18268 -isRequired: false -value: "" -nam...
      oPlugin_tn_multiDomain
      JTL\Plugin\Plugin {#18308 #id: 328 #pluginID: "tn_multiDomain" #state: 2 #meta: JTL\Plugin\D...
      bCookieErlaubt
      false
      Brotnavi
      array:4 [ 0 => JTL\Catalog\NavigationEntry {#17573 -id: 0 -name: "Startseite" -url: "/...
      nIsSSL
      2
      boxes
      array:4 [ "top" => null "right" => null "bottom" => """ <div class="box box-linkgroup box-...
      boxesLeftActive
      false
      consentItems
      Illuminate\Support\Collection {#15377 #items: array:4 [ 0 => JTL\Consent\Item {#15381 -i...
      nZeitGebraucht
      0.32705903053284
      Besucherzaehler
      0
      alertList
      JTL\Services\JTL\AlertService {#83 -alertList: Illuminate\Support\Collection {#84 #items: [] ...
      dbgBarHead
      """ <link rel="stylesheet" type="text/css" href="https://dev.techneo.berlin/includes/vendor/maximebf...
      SCRIPT_NAME
      "/index.php"