Stellenausschreibung

1
Kursname	Alles Schoggi oder was?
Kursleitung	Angela Flückiger und Monique Geissmann
Datum	31.01.2022-04.02.2022
Klassen	3. bis 5. Klasse
Bedingungen	Muss gerne Schoggi haben ;)
Elternbeitrag	5 Fr.
Kursbeschreibung	Woher kommt die Schokolade? Wächst sie auf den Bäumen? Im Kurs lernst du, wie Schokolade hergestellt wird, wie sie schmeckt und was man alles daraus machen kann. Natürlich werden wir feine Sachen aus Schokolade herstellen und geniessen. Ein Ausflug zu einem Chocolatier ist auch mit dabei.
Ziele	Du lernst die Herkunft von Schokolade kennen und lernst, was man alles damit machen kann.

2
Kursname	Welt von Harry Potter
Kursleitung	Barbara Büchi und Tanja Pantic
Datum	31.01.2022-04.02.2022
Klassen	3. bis 6. Klasse
Bedingungen	Du hast schon eine Ahnung von der Harry Potter - Reihe.
Elternbeitrag	0 Fr.
Kursbeschreibung	Du tauchst für eine Woche in die Zauberwelt von Harry Potter ein. Wir lernen Zaubersprüche und brauchen unseren Zauberstab, verkleiden uns und vertiefen uns in die Geschichte von Hogwarts. Du bist Mitglied von einem der vier Häuser und sammelst fleissig Punkte für dein Team, indem du Aufgaben löst. Viele spannende Herausforderungen erwarten dich.
Ziele	Du lernst die Bücher kennen und beschäftigst dich mit der Zauberwelt.

3
Kursname	Adventure-Trekking Lötschenpass
Kursleitung	Beat Schmid
Datum	04.07.2022 - 08.07.2022
Klassen	6. bis 9. Klasse
Bedingungen	Du bist Naturfreund(in), abenteurlustig und Teamplayer(in). Bereitschaft sich vor dem Lager auf das Coronavirus testen zu lassen. (Teilnahme am repetitiven Testen der Schule oder ein privater PCR-Test, falls nicht geimpft oder genesen)
Elternbeitrag	150.-
Kursbeschreibung	Nur etwas Mut brauchst du bei der Anmeldung zu diesem Kurs, aber wenn du mit dabei bist, erlebst du eine fantastische, erlebnisreiche und unvergessliche Abenteuerwoche! Aus dem Kandertal im Berner Oberland wandern wir ins wilde Gasterental, überqueren den eindrücklichen Lötschenpass und gelangen ins urtümliche Lötschental im Wallis. Baden in kalten Bergseen, spannende Wildtierbeobachtungen (Gämsen, Steinböcke, Bartgeier, ...), Grillieren am Feuer, Schwemmholz-Schnitzen, Spiele im Freien, eine Gletscherüberquerung, ... und vieles mehr kannst du während dieser Projektwoche aktiv erfahren und geniessen! Wir übernachten in kleinen, gemütlichen Touristenlagern, auf dem Lötschenpass auch einmal in einer (sehr komfortablen) SAC-Hütte. Die Verpflegung tagsüber kommt aus dem Rucksack, das Morgen- und Abendessen ist jeweils in einem Bergbeizli. Die reine Wanderzeit der täglichen Etappen beträgt etwa 4 Stunden.
Ziele	Du trainiert deine persönliche Fitness und lernst dabei eine fantastische Urlandschaft der Schweiz kennen. Du erlebst eine spannende Zeit in der Gruppe.

4
Kursname	work&chill - Lesen und Schreiben im Französisch
Kursleitung	Piera Armellino
Datum	31.01.-04.02.2021
Klassen	6. bis 9. Klasse
Bedingungen	Du willst Französisch eine Chance geben und herausfinden, wie Du diese Sprache einfacher lernen kannst. Es ist vollkommen egal, welche Noten Du im Französisch hast. Wichtiger ist, dass Du bereit bist, mit allen respektvoll zusammen zu arbeiten.
Elternbeitrag	-
Kursbeschreibung	Wir lernen im entspannten Umfeld, wie eine Sprache gelernt wird und probieren neue Techniken aus und werden so Lesen und Schreiben verbessern. Ebenfalls lernen wir, was das Gehirn braucht um eine Sprache zu lernen. Am Vormittag heissts "work": wir lernen, verbessern die Sprache und probieren neue Techniken aus. Am Nachmittag heisst's "chill": wir spielen, malen, vertreten uns die Beine, etc. Die Nachmittage planen wir gemeinsam. Am Freitag essen wir zusammen in der Schule, besprechen den Kurs und sind stolz auf uns.
Ziele	Techniken zum Erlernen einer Sprache verbessern - Fähigkeit im Lesen und Schreiben im Französisch verbessern - im entspannten Umfeld lernen und Mitschüler/innen unterstützen

5
Kursname	Ball is life
Kursleitung	Sandrina Kopp und Larissa Kebben
Datum	25.04.2022 - 29.04.2022
Klassen	3. bis 6. Klasse
Bedingungen	Du bewegst dich gerne und hast Spass an Ballspielen
Elternbeitrag	5 Fr.
Kursbeschreibung	Du hast eine sportliche Woche vor dir! Wir werden verschiedene Ballspiele wie Unihockey, Sitzball, Völkerball, Basketball und Badminton ausprobieren und auch der Fussball kommt natürlich nicht zu kurz! Ausserdem erwartet dich ein toller Ausflug ins FIFA - Museum in Zürich, sowie ein spannender Film am letzten Tag.
Ziele	Du verbesserst deine Technik und Kondition in verschiedenen Ballspielen. Du lernst neue Ballspiele kennen und du vertiefst dein Regelwissen zu gewissen Sportarten.

6
Kursname	Ski- und Snowboardlager in Savognin
Kursleitung	Priska Brunner, Gabriela Arnet und Michael Etterlin
Datum	30.01. - 04.02.2022
Klassen	3. bis 6. Klasse
Bedingungen	Schüler*innen bringen die eigene Ausrüstung mit. Bereitschaft sich vor dem Lager auf das Coronavirus testen zu lassen. (Teilnahme am repetitiven Testen der Schule oder ein privater PCR-Test, falls nicht geimpft oder genesen)
Elternbeitrag	240 Fr.
Kursbeschreibung	Ski oder Board, Sun and Fun!!! Wir verbringen eine Woche in Savognin im Ski- und Snowboardlager. Wir fahren den ganzen Tag in Gruppen entweder Ski oder Snowboard. Falls es die Schneeverhältnisse zulassen, werden wir auch Schlitteln gehen. Ein Skirennen darf natürlich auch nicht fehlen. Am Abend gibt es immer ein tolles Programm mit verschiedenen Aktivitäten. Du lernst andere Mädchen und Jungs kennen, die auch im Müma zur Schule gehen. Das Küchenteam wird dich mit feinen Menues verwöhnen. Es wird bestimmt nie langweilig. Komm doch mit, wir freuen uns auf dich!
Ziele	Du verbesserst deine Technik und dein Können beim Ski- oder Snowboardfahren. Du erlebst eine tolle Lagerwoche und lernst neue Kinder kennen

7
Kursname	Märchen
Kursleitung	Andrina Caviezel und Michèle Locher
Datum	25.04.2022 - 29.04.2022
Klassen	3. und 4. Klasse
Bedingungen	Interesse an Märchen, dem Gestalten, Zuhören und Spielen
Elternbeitrag	5 Fr.
Kursbeschreibung	Tauche mit uns in die Welt der Märchen und Geschichten ein. Wir hören, spielen, gestalten und erfinden Märchen. Auch an selbst zubereiteten, märchenhaften Leckereien soll es nicht fehlen. Bei einem Ausflug erleben wir die Märchenwelt hautnah.
Ziele	Märchen kennenlernen, gestalten und erfinden

8
Kursname	Mach Platz! - Jetzt wird aufgeräumt.
Kursleitung	Jolanda Schärli, Mirjam Häusermann
Datum	31.01.2022-04.02.2022
Klassen	3. bis 6. Klasse
Bedingungen	Freude und Interesse am Entwickeln eines eigenen Projekts (Schwerpunkt Kunst)
Elternbeitrag	0 Fr.
Kursbeschreibung	Mach Platz für deine Kreativität, neue Ideen, anderen Sichtweisen und bring Ordnung ins Chaos. Du räumst gerne auf? Wir nicht. Aber so macht's Spass!
Ziele	Kunstvoll Raum schaffen.

9
Kursname	Handlettering
Kursleitung	Anina Brunner
Datum	31.01.2022 - 04.02.2022
Klassen	4. bis 6. Klasse
Bedingungen	Du bist gerne kreativ und schreibst / zeichnest gerne.
Elternbeitrag	5 Fr.
Kursbeschreibung	Hast du Freude am Schreiben, Zeichnen und Gestalten? Dann bist du in meinem Kurs genau richtig. Ob Handlettering, Brushlettering, Watercolor oder Sketchnotes - du wirst in dieser Woche mit speziellen Stiften und Materialien arbeiten und tolle Produkte herstellen.
Ziele	Du probierst verschiedene Schriften aus und gestaltest schöne Karten und Geschenke.

10
Kursname	Schneesportlager Bergün
Kursleitung	Sybille Grolimund, Lara Diab, Leonie Schnegg
Datum	31.1. - 04.02.22
Klassen	3. bis 6. Klasse
Bedingungen	Du machst gerne Sport, magst Schnee und die Berge Du bist gerne in der Natur und möchtest den Kanton Graubünden näher kennen lernen. Du hast kein Heimweh :-) Bereitschaft sich vor dem Lager auf das Coronavirus testen zu lassen. (Teilnahme am repetitiven Testen der Schule oder ein privater PCR-Test, falls nicht geimpft oder genesen)
Elternbeitrag	240 Fr.
Kursbeschreibung	Ski- und Snowboardfahren ist nicht so dein Ding aber du magst Schnee, Sonne und Berge? Kein Problem, denn dieses Jahr gibt es einmalig ein Lager mit vielen anderen Sportarten im Schnee! Mit der berühmten Rhätischen Bahn fährst du über das Land-Wasser-Viadukt nach Bergün. Dort befindet sich eine der längsten Schlittelbahnen der Schweiz, welche wir natürlich mehrmals hinunterflitzen werden Auf dem Programm steht auch Schlittschuhlaufen, wenn es kalt genug ist durch einen geheimnisvollen Wald. Du kannst mit den kecken Bergüner Geissen einen Schneespaziergang machen oder einmal Schneeschuhe oder Snowtubing ausprobieren. Vor unserem Lagerhaus hat es eine riesige Wiese, wo man bei guten Schneeverhältnissen ein Iglu bauen oder einfach eine tolle Schneeballschlacht machen kann. Es wäre toll, wenn du auch mit dabei bist!!
Ziele	Du probierst verschiedene Schneesportarten aus. Du erfährst allerhand über das herzige Dörfchen Bergün. Du lernst neue Freunde kennen und erlebst eine unvergessliche Zeit.

11
Kursname	Achtung Baustelle!
Kursleitung	Mirjam Kölliker, Corinne Mühlemann
Datum	25.4. -29.4.2022
Klassen	3. bis 5. Klasse
Bedingungen	Du hast Freude, verschiedende Bautechniken kennen zu lernen.
Elternbeitrag	10 Fr.
Kursbeschreibung	Wir bauen, konstruieren und tüfteln mit Klötzen, Steinen, Karton, Legos und vielen anderen Materialien. In der Turnhalle bauen wir eigene Bewegungslandschaften und Parcours. Für den Pausenplatz bauen wir eine neue Aufbewahrungsmöglichkeit für die Spielsachen. Auch ein Ausflug wird uns in die Welt des Bauens bringen.
Ziele	Deine Freude am Bauen, Konstruieren und Tüfteln zu wecken.

12
Kursname	Von Landart bis Streetart
Kursleitung	Dejan Beg
Datum	25.04.2022 - 29.04.2022
Klassen	4. bis 6. Klasse
Bedingungen	Du bist kreativ und hast Lust am Gestalten.
Elternbeitrag	5 Fr.
Kursbeschreibung	Ob im Wald oder auf der Strasse – wir verschönern unsere Umgebung und setzen verschiedene Kunstprojekte um. Dabei arbeiten wir mit unterschiedlichen Materialien und lernen neue Arbeitstechniken kennen. Ausserdem besuchen wir einen StreetArt-Künstler in seinem Atelier.
Ziele	Du lernst neue Techniken und spannendes Material kennen. Du kannst deine Gestaltungsideen verwirklichen.

13
Kursname	Bergschulwoche
Kursleitung	Cornelia Heimgartner, Anja Schwegler
Datum	25.04.2022-29.04.2022
Klassen	5. und 6. Klasse
Bedingungen	Dich faszinieren die Berge und das Bergsteigen und lange Wanderungen (ca. 6 Stunden) mit Anstiegen sind für dich kein Problem.
Elternbeitrag	25 Fr.
Kursbeschreibung	Einmal auf einem richtigen Berggipfel stehen und mit eigenen Augen sehen, wie klein die Welt von dort oben aussieht. Einmal über Stock und Stein klettern oder über Schneefelder rutschen. Den richtigen Weg durch den tiefen Wald mit Hilfe einer Karte finden und am Seil eines Bergführers gehen. Das alles kannst du während der Bergschulwoche erleben. Vielleicht unternehmen wir sogar eine zweitägige Wanderung (das ist aber witterungsabhängig).
Ziele	Du lernst die Berge und die wunderschöne, wilde Natur besser kennen und kannst dich frei und mutig in ihr bewegen.

14
Kursname	Schmuckatelier
Kursleitung	Annika Gotti
Datum	31.1. - 04.02.22
Klassen	3. bis 6. Klasse
Bedingungen	Du hast gerne Schmuck und arbeitest gerne mit Perlen und Bändern!
Elternbeitrag	0 Fr.
Kursbeschreibung	Ohrringe, Halsketten, Armbändern und Schlüsselanhängern - all das wirst du mit Perlen, Bändern und Harz auf verschiedene Art und Weise herstellen! Du kannst mehrere Techniken ausprobieren und deiner Kreativität freien Lauf lassen.
Ziele	Du lernst verschiedene Techniken und Materialien kennen, um Schmuck herzustellen.

15
Kursname	Improvisationstheater
Kursleitung	Christina Lobsiger und Katya Müller
Datum	25.04.2022-29.04.2022
Klassen	3. bis 6. Klasse
Bedingungen	Freude am Theater spielen
Elternbeitrag	0 Fr.
Kursbeschreibung	Du spielst gerne Theater? Du überlegst dir gerne eine Geschichte und spielst sie auch noch? Dann bist du hier am richtigen Ort. Wir spielen, bewegen uns, ahmen nach und treten miteinander auf. Am Ende halten wir die kurzen Theaterszenen auch noch per Video fest.
Ziele	Du lernst, in einer Gruppe Theater zu spielen, dich auszudrücken, aufzutreten.

16
Kursname	Schneelager der Pfadi Wohlen
Kursleitung	Nicola Riner
Datum	05.02.2022 - 12.02.2022 (Achtung: Dies ist die 2. Ferienwoche)
Klassen	5. bis 9. Klasse
Besonderes / Teilnahmebedingungen	Dieser Kurs wird nicht durch die Schule Villmergen organisiert. Es ist ein Angebot der Pfadi Wohlen und wird in ihrer Verantwortung durchgeführt. Es ist ein tolles Angebot, dass von der Schule Villmergen als Projektwoche anerkannt wird. Nach der Anmeldung für diesen Kurs erhalten Sie alle weiteren Informationen direkt von der Pfadi Wohlen. Bereitschaft sich vor dem Lager auf das Coronavirus testen zu lassen. (Teilnahme am repetitiven Testen der Schule oder ein privater PCR-Test, falls nicht geimpft oder genesen).
Elternbeitrag	250 Fr.
Kursbeschreibung	Wir verbringen eine coole Woche im Schnee, bei der du die Möglichkeit hast, einmal bei einem Lager der anderen Art dabei zu sein und Dinge zu erleben, wir Iglu bauen, Schneeschuh wandern, im Schnee übernachten, kochen, essen und Vieles mehr.
Ziele	Du lernst das Spielen im Schnee. Du lernst, dich in eine neue Gruppe einzufügen und neue Freunde zu finden. Du übernimmst Verantwortung für dich und die anderen.

17
Kursname	Cajatones und Rhythmus
Kursleitung	Mario Pasinelli
Datum	25. - 29.04.2022
Klassen	6. bis 9. Klasse
Bedingungen	Freude am Werken und an der Musik und du möchtest dich rhythmisch in der Musik weiterentwickeln. AnfängerInnen sehr willkommen, nichts für Profi-SchlagzeugerInnen.
Elternbeitrag	35.- Fr.
Kursbeschreibung	Als man den Afrikanischen Sklaven in Kuba im 19. Jh. ihre Trommeln weggenommen hatte, fingen sie an, auf Holzkisten, die zum Transport von Früchten und Fischen gedacht waren, ihre Rhythmen zu trommeln. Mittlerweile sind diese Kistchen aus Holz in der Musikwelt weit verbereitet und kaum mehr wegzudenekne. Aus diesem Grund möchte ich mit euch solche Cajones aus stabilem Karton (Cajatones) bauen und bemalen und euch die Technik lehren, wie man darauf tolle Rhythmen produziert. Und wenn alles gut läuft, schaffen wir es sogar ein Stück zu komponieren und aufzunehmen.
Ziele	Du schaffst es, ein Cajaton zu bauen und hast die Technik gelernt, wie man damit rhythmisch richtig gut spielt.

18
Kursname	Comic und Cartoon
Kursleitung	Juna Wettstein
Datum	31.1. - 04.02.22
Klassen	3. bis 6. Klasse
Bedingungen	Du bist kreativ und hast Lust, deine Ideen als Comic oder Cartoon selbständig umzusetzen.
Elternbeitrag	0 Fr.
Kursbeschreibung	Magst du Comics und hast gute Ideen, die du der Welt zeigen möchtest? Dann bist du in diesem Kurs richtig. Wir werden uns in der Projektwoche mit Comics und Cartoons beschäftigen. Du kannst Comics anschauen, lesen und analysieren. Du wirst lernen, wie du deine eigenen Comics umsetzt. In welcher Form, darfst du selbst entscheiden und deiner Kreativität kannst du freien Lauf lassen.
Ziele	Das Ziel ist, dass du am Ende der Woche dein eigenes Comic-Projekt umgesetzt hast.

19
Kursname	Helfer in der Not
Kursleitung	Jennifer Kalt
Datum	25. - 29.04.2022
Klassen	3. bis 6. Klassen
Bedingungen	Du bist neugierig und hast Freude daran, Neues zu lernen.
Elternbeitrag	0 Fr.
Kursbeschreibung	Ein Anruf erreicht die Notrufzentrale. Was geschieht nun? Wer wird alarmiert? Welche Aufgaben haben die verschiedenen Rettungsdienste Polizei, Feuerwehr und Sanität? Wir nehmen diese Rettungsdienste und ihre Arbeit genauer unter die Lupe und werden auch anschauen, was DU in einem Notfall tun kannst.
Ziele	Du lernst die verschiedenen Rettungsdienste kennen und weisst, wann und wie sie zum Einsatz kommen. Du kannst praktische Erfahrung sammeln in den verschiedenen Bereichen des schweizerischen Rettungsdienstes.

20
Kursname	Frühlingserwachen
Kursleitung	Ariane Gregor und Rahel Blaser
Datum	25. - 29.04.2022
Klassen	3. und 4. Klasse
Bedingungen	Freude an der Natur, am Kreativ sein und etwas Neues kennen lernen.
Elternbeitrag	0 Fr.
Kursbeschreibung	Wir erleben das Frühlingserwachen, hören den Vögeln beim Zwitschern zu, lassen uns von den frischen Blüten verzaubern, basteln einen Vogel im Käfig und drucken mit Naturmaterialien.
Ziele	Aus Filz stellst du deinen Fantasievogel her und baust ihm einen einfachen Käfig. Mit Naturmaterialien bedruckst du deine Tasche und gestaltest verschiedene Briefpapiere und Karten.

21
Kursname	Die Malkunst
Kursleitung	Nastia Zegarelli
Datum	31.01.2022 - 04.02.2022
Klassen	3. bis 6. Klasse
Bedingungen	Du zeichnest und malst gerne und bist bereit, in den Schuhen eines Künstlers zu laufen.
Elternbeitrag	0 Fr.
Kursbeschreibung	Willst du ein professionelles Bild wie ein echter Künstler selber kreieren? Dann bist du hier genau richtig! In diesem Projekt tauchst du während einer Woche in die Welt voller Farben ein, wo deine Kreativität keine Grenzen kennt! Du erstellst ein echtes Kunstwerk auf einer schönen Leinwand und entdeckst die Geheimnisse der Farben. Es besteht die Möglichkeit, ein Bild aus deiner Fantasie zu kreieren oder auch etwas nachzuzeichnen. Die Wahl liegt ganz bei dir und deinem Interesse!
Ziele	Du entdeckst, dass jeder einen Künstler in sich hat und kannst nach dieser Woche ein eigenes Kunstwerk mit Nachhause nehmen.

22
Kursname	Vive la France!
Kursleitung	Rahela Brunner
Datum	25.04.2022-29.04.2022
Klassen	5./6. Klasse
Bedingungen	Du bist neugierig, ein neues Land zu entdecken. Du bist gerne kreativ und magst Fremdsprachen. Keine Angst - du musst nicht fliessend Französisch sprechen können :)
Elternbeitrag	5 Fr.
Kursbeschreibung	Ah Paris, la ville d'amour! In diesem Kurs lernst du weit mehr als nur die schönste Stadt Europas kennen. Als Strassenkünstler, Pâtissier, Rugby-Spieler, Gourmet-Koch oder als Parfumier erkundest du die verschiedensten Ecken Frankreichs und probierst typische Handwerke und Sportarten aus. Du entdeckst die beste Küche der Welt und lernst, dass die Franzosen nicht nur Schnecken und Frösche essen.
Ziele	Du lernst die Vielfalt der französischen Kultur kennen und findest heraus, welches verborgene französische Talent in dir steckt!

Kontakt

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1638266206,
                "last": 1638266206,
                "now": 1638266206
            },
            "token": "DHaEMGraxiilmdAOrzt7EUWmibX5mQko"
        },
        "registry": {},
        "user": {
            "id": 0,
            "name": null,
            "username": null,
            "email": null,
            "password": null,
            "password_clear": "",
            "block": null,
            "sendEmail": 0,
            "registerDate": null,
            "lastvisitDate": null,
            "activation": null,
            "params": null,
            "groups": [],
            "guest": 1,
            "lastResetTime": null,
            "resetCount": null,
            "requireReset": null,
            "aid": 0
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 3.03 ms / 3.03 ms Speicher: 0.414 MB / 0.75 MB Application: afterLoad

Zeit: 14.98 ms / 18.02 ms Speicher: 0.901 MB / 1.65 MB Application: afterInitialise

Zeit: 4.69 ms / 22.70 ms Speicher: 0.699 MB / 2.35 MB Application: afterRoute

Zeit: 1.02 ms / 23.73 ms Speicher: 0.077 MB / 2.42 MB Application: beforeRenderComponent com_content

Zeit: 0.90 ms / 24.63 ms Speicher: 0.113 MB / 2.54 MB Application: Before Access::preloadComponents (all components)

Zeit: 0.81 ms / 25.44 ms Speicher: 0.058 MB / 2.59 MB Application: After Access::preloadComponents (all components)

Zeit: 0.02 ms / 25.46 ms Speicher: -0.004 MB / 2.59 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 2.06 ms / 27.52 ms Speicher: 0.818 MB / 3.41 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.03 ms / 27.55 ms Speicher: -0.034 MB / 3.37 MB Application: Before Access::getAssetRules (id:1377 name:com_content.article.927)

Zeit: 0.19 ms / 27.74 ms Speicher: 0.010 MB / 3.38 MB Application: After Access::getAssetRules (id:1377 name:com_content.article.927)

Zeit: 18.98 ms / 46.72 ms Speicher: 0.969 MB / 4.35 MB Application: afterRenderComponent com_content

Zeit: 0.74 ms / 47.46 ms Speicher: 0.007 MB / 4.36 MB Application: afterDispatch

Zeit: 8.16 ms / 55.61 ms Speicher: 0.111 MB / 4.47 MB Application: beforeRenderModule mod_custom (phantom)

Zeit: 0.37 ms / 55.98 ms Speicher: 0.005 MB / 4.48 MB Application: afterRenderModule mod_custom (phantom)

Zeit: 2.40 ms / 58.39 ms Speicher: 0.003 MB / 4.48 MB Application: beforeRenderModule mod_articles_news (Kalender )

Zeit: 0.55 ms / 58.94 ms Speicher: 0.038 MB / 4.52 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 0.05 ms / 58.99 ms Speicher: 0.008 MB / 4.53 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 3.93 ms / 62.92 ms Speicher: 0.046 MB / 4.57 MB Application: afterRenderModule mod_articles_news (Kalender )

Zeit: 5.81 ms / 68.72 ms Speicher: -0.018 MB / 4.55 MB Application: beforeRenderModule mod_articles_news (Aktuelles alle Stufen)

Zeit: 8.97 ms / 77.70 ms Speicher: 0.211 MB / 4.77 MB Application: afterRenderModule mod_articles_news (Aktuelles alle Stufen)

Zeit: 3.34 ms / 81.04 ms Speicher: -0.059 MB / 4.71 MB Application: beforeRenderModule mod_menu (phantom1)

Zeit: 3.93 ms / 84.97 ms Speicher: 0.009 MB / 4.72 MB Application: afterRenderModule mod_menu (phantom1)

Zeit: 3.60 ms / 88.57 ms Speicher: -0.001 MB / 4.71 MB Application: beforeRenderModule mod_articles_news (advert)

Zeit: 3.13 ms / 91.70 ms Speicher: 0.061 MB / 4.78 MB Application: afterRenderModule mod_articles_news (advert)

Zeit: 0.98 ms / 92.68 ms Speicher: -0.021 MB / 4.76 MB Application: beforeRenderModule mod_hot_slicebox (Slicebox)

Zeit: 0.39 ms / 93.07 ms Speicher: 0.044 MB / 4.80 MB Application: afterRenderModule mod_hot_slicebox (Slicebox)

Zeit: 2.15 ms / 95.23 ms Speicher: -0.015 MB / 4.78 MB Application: beforeRenderModule mod_search (Search)

Zeit: 0.71 ms / 95.94 ms Speicher: 0.016 MB / 4.80 MB Application: afterRenderModule mod_search (Search)

Zeit: 3.89 ms / 99.83 ms Speicher: -0.005 MB / 4.80 MB Application: beforeRenderModule mod_menu (Top Menu)

Zeit: 12.99 ms / 112.82 ms Speicher: 0.228 MB / 5.02 MB Application: afterRenderModule mod_menu (Top Menu)

Zeit: 5.22 ms / 118.05 ms Speicher: 0.447 MB / 5.47 MB Application: afterRender

Datenbankabfragen gesamt: 20.41 ms

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_session	const	PRIMARY	PRIMARY	194	const	1

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:854
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_session	const	PRIMARY	PRIMARY	194	const	1	Using index

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `s3ke6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'63616a6e646e3761666d30696c63313062713038747574767638747262306739', 1, 1638266206, 0, '', 0)

Profil (Profile)

Status	Duration
Starting	0.02 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.01 ms
Update	0.06 ms
Waiting for query cache lock	0.00 ms
Update	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:154
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:856
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:136
4	Joomla\CMS\Application\CMSApplication->__construct()	JROOT/libraries/src/Application/SiteApplication.php:66
3	Joomla\CMS\Application\SiteApplication->__construct()	JROOT/libraries/src/Application/CMSApplication.php:414
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.19 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.121 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `s3ke6_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_viewlevels	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5

Profil (Profile)

Status	Duration
Starting	0.04 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.53 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.133 MB Zeilen zurückgegeben: 1

SELECT b.id

  FROM s3ke6_usergroups AS a

  LEFT JOIN s3ke6_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

  WHERE a.id = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	b	range	idx_usergroup_nested_set_lookup	idx_usergroup_nested_set_lookup	4	NULL	10	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.21 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.04 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php:318
6	Joomla\CMS\Plugin\PluginHelper::load()	JROOT/libraries/src/Plugin/PluginHelper.php:87
5	Joomla\CMS\Plugin\PluginHelper::getPlugin()	JROOT/libraries/src/Plugin/PluginHelper.php:129
4	Joomla\CMS\Plugin\PluginHelper::isEnabled()	JROOT/libraries/src/Application/SiteApplication.php:604
3	Joomla\CMS\Application\SiteApplication->initialiseApp()	JROOT/libraries/src/Application/SiteApplication.php:212
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.48 ms Nach letzter Abfrage: 10.43 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 2.327 MB

UPDATE `s3ke6_extensions`

  SET `params` = '{\"mediaversion\":\"e05b1e1c0b7e2a040794e48dd6526b5e\"}'

  WHERE `type` = 'library' 
  AND `element` = 'joomla'

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE `s3ke6_extensions` SET `params` = '{\"mediaversion\":\"e05b1e1c0b7e2a040794e48dd6526b5e\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profil (Profile)

Status	Duration
Starting	0.07 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init for update	0.09 ms
Updating	0.06 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
13	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
12	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
11	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
10	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
9	Joomla\CMS\Factory::getDocument()	JROOT/plugins/system/jcktypography/jcktypography.php:48
8	plgSystemJCKtypography->onAfterRoute()	JROOT/libraries/joomla/event/event.php:70
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
6	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
5	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1218
4	Joomla\CMS\Application\CMSApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:796
3	Joomla\CMS\Application\SiteApplication->route()	JROOT/libraries/src/Application/SiteApplication.php:218
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.68 ms Nach letzter Abfrage: 2.50 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.540 MB Zeilen zurückgegeben: 40

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `s3ke6_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_associations','com_banners','com_cache','com_categories','com_checkin','com_ckeditor','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_dpcalendar','com_fields','com_finder','com_installer','com_jckman','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_medialibrary','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_privacy','com_redirect','com_search','com_tags','com_templates','com_users','com_weblinks','com_wrapper','com_youtubegallery')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_assets	range	idx_asset_name	idx_asset_name	202	NULL	41	Using index condition

Profil (Profile)

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.01 ms
Statistics	0.10 ms
Preparing	0.02 ms
Executing	0.01 ms
Sending data	0.23 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 1.11 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.180 MB Speichernutzung vor Abfrage: 2.590 MB Zeilen zurückgegeben: 993

SELECT `id`,`name`,`rules`,`parent_id`

  FROM `s3ke6_assets`

  WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_assets	ALL	idx_asset_name,idx_parent_id	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1274	Using where

Profil (Profile)

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.80 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.63 ms Nach letzter Abfrage: 1.35 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 3.388 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `s3ke6_content`

Explain

„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `s3ke6_content`

Profil (Profile)

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Closing tables	0.01 ms
Opening tables	0.16 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
Checking permissions	0.09 ms
Closing tables	0.01 ms
Executing	0.00 ms
Sending data	0.04 ms
End of update loop	0.00 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Removing tmp table	0.04 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.00 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:448
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:253
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:172
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:320
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.58 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.437 MB

UPDATE s3ke6_content

  SET `hits` = (`hits` + 1)

  WHERE `id` = '927'

Explain

„EXPLAIN“ unmöglich für Abfrage: UPDATE s3ke6_content SET `hits` = (`hits` + 1) WHERE `id` = '927'

Profil (Profile)

Status	Duration
Starting	0.02 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.00 ms
Init for update	0.03 ms
Updating	0.31 ms
End of update loop	0.01 ms
Waiting for query cache lock	0.00 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1256
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.84 ms Nach letzter Abfrage: 4.73 ms Abfragespeichernutzung: 0.312 MB Speichernutzung vor Abfrage: 3.489 MB Zeilen zurückgegeben: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count

  FROM s3ke6_content AS a

  INNER JOIN s3ke6_categories AS c 
  on c.id = a.catid

  LEFT JOIN s3ke6_users AS u 
  on u.id = a.created_by

  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.id = 927 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-11-30 09:56:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-11-30 09:56:46') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	const	PRIMARY,idx_state,idx_catid	PRIMARY	4	const	1
1	SIMPLE	c	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	u	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	parent	const	PRIMARY	PRIMARY	4	const	1
1	SIMPLE	v	const	PRIMARY	PRIMARY	4	const	0	Unique row not found

Profil (Profile)

Status	Duration
Starting	0.11 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.03 ms
Statistics	0.10 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.28 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
13	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.47 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.728 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 2

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	3	Using index condition; Using where

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.05 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
25	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
24	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
23	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
22	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
21	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
20	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
19	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
18	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
17	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
16	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
15	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
14	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
13	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
12	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.36 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.896 MB Zeilen zurückgegeben: 0

SELECT `m`.`tag_id`,`t`.*

  FROM `s3ke6_contentitem_tag_map` AS m 

  INNER JOIN `s3ke6_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

  WHERE `m`.`type_alias` = 'com_content.article' 
  AND `m`.`content_item_id` = 927 
  AND `t`.`published` = 1 
  AND t.access IN (1,1)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	2	Using where
1	SIMPLE	t	ALL	PRIMARY,tag_idx,idx_access	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	3	Using where

Profil (Profile)

Status	Duration
Starting	0.03 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.03 ms
Preparing	0.02 ms
Executing	0.00 ms
Sending data	0.03 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.76 ms Nach letzter Abfrage: 1.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.963 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.05 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.03 ms
Creating tmp table	0.05 ms
Sorting result	0.02 ms
Executing	0.01 ms
Sending data	0.16 ms
Creating sort index	0.03 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/components/com_content/views/article/view.html.php:193
11	ContentViewArticle->display()	JROOT/libraries/src/Cache/Controller/ViewController.php:102
10	Joomla\CMS\Cache\Controller\ViewController->get()	JROOT/libraries/src/MVC/Controller/BaseController.php:655
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:702
7	Joomla\CMS\MVC\Controller\BaseController->execute()	JROOT/components/com_content/content.php:43
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/src/Component/ComponentHelper.php:402
5	Joomla\CMS\Component\ComponentHelper::executeComponent()	JROOT/libraries/src/Component/ComponentHelper.php:377
4	Joomla\CMS\Component\ComponentHelper::renderComponent()	JROOT/libraries/src/Application/SiteApplication.php:194
3	Joomla\CMS\Application\SiteApplication->dispatch()	JROOT/libraries/src/Application/SiteApplication.php:233
2	Joomla\CMS\Application\SiteApplication->doExecute()	JROOT/libraries/src/Application/CMSApplication.php:225
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 1.09 ms Nach letzter Abfrage: 10.99 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.407 MB Zeilen zurückgegeben: 12

SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid

  FROM s3ke6_modules AS m

  LEFT JOIN s3ke6_modules_menu AS mm 
  ON mm.moduleid = m.id

  LEFT JOIN s3ke6_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2021-11-30 09:56:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2021-11-30 09:56:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 195 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY,published,newsfeeds	published	1	const	71	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	ref	element_clientid,element_folder_clientid	element_clientid	403	schulev_v41.m.module,const	1	Using index condition; Using where
1	SIMPLE	mm	ref	PRIMARY	PRIMARY	4	schulev_v41.m.id	3	Using where; Using index

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.03 ms
Statistics	0.05 ms
Preparing	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.62 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:441
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:371
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:591
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/hot_corporate/index.php:67
7	require JROOT/templates/hot_corporate/index.php	JROOT/libraries/src/Document/HtmlDocument.php:668
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:730
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:545
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1126
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.73 ms Nach letzter Abfrage: 7.57 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.526 MB Zeilen zurückgegeben: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM s3ke6_content AS a

  LEFT JOIN s3ke6_categories AS c 
  ON c.id = a.catid

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN s3ke6_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (54) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-11-30 09:56:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-11-30 09:56:46')

  ORDER BY a.publish_up DESC 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where; filesort wurde genutzt
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.09 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.03 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.560 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 54

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.02 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.80 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 4.574 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  WHERE a.context = 'mod_articles_news.content' 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.08 ms
Checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.04 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.19 ms
Creating sort index	0.03 ms
Removing tmp table	0.04 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
25	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
24	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
23	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
22	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
21	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
20	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
19	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
18	JHtmlContent::prepare()	Derselbe Aufruf in der Zeile darunter.
17	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
16	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
15	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_articles_news/helper.php:123
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.587 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (54,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.80 ms Nach letzter Abfrage: 6.38 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 4.585 MB Zeilen zurückgegeben: 4

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM s3ke6_content AS a

  LEFT JOIN s3ke6_categories AS c 
  ON c.id = a.catid

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN s3ke6_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (72,71,70,69,89) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-11-30 09:56:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-11-30 09:56:46')

  ORDER BY a.publish_up DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_state,idx_catid	idx_catid	4	NULL	7	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.modified_by	1	Using where
1	SIMPLE	c	eq_ref	PRIMARY,idx_access	PRIMARY	4	schulev_v41.a.catid	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.c.parent_id	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.15 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.14 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.662 MB Zeilen zurückgegeben: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 89

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.71 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.686 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (89,0,74,73)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.03 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.703 MB Zeilen zurückgegeben: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 70

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.717 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (70,0,74,73)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.30 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.734 MB Zeilen zurückgegeben: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 69

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.05 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.67 ms Nach letzter Abfrage: 0.38 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.747 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (69,0,74,73)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.51 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 4.764 MB Zeilen zurückgegeben: 4

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 71

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.11 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.01 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.66 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.778 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (71,0,74,73)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.14 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.01 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.71 ms Nach letzter Abfrage: 11.58 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.745 MB Zeilen zurückgegeben: 1

SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,
							COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count

  FROM s3ke6_content AS a

  LEFT JOIN s3ke6_categories AS c 
  ON c.id = a.catid

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_by

  LEFT JOIN s3ke6_users AS uam 
  ON uam.id = a.modified_by

  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id

  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

  WHERE a.access IN (1,1) 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid IN (119) 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2021-11-30 09:56:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2021-11-30 09:56:46')

  ORDER BY a.publish_up DESC 
  LIMIT 5

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	c	const	PRIMARY,idx_access	PRIMARY	4	const	1
1	SIMPLE	a	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	1	Using where; filesort wurde genutzt
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_by	1	Using where
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.modified_by	1	Using where
1	SIMPLE	parent	eq_ref	PRIMARY	PRIMARY	4	const	1	Using where
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where

Profil (Profile)

Status	Duration
Starting	0.13 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.06 ms
Optimizing	0.03 ms
Statistics	0.07 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.02 ms
Sorting result	0.01 ms
Executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.02 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.03 ms
Reset for next command	0.01 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
15	ContentModelArticles->getItems()	JROOT/modules/mod_articles_news/helper.php:100
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.50 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.777 MB Zeilen zurückgegeben: 2

SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
				c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
				c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
				c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug

  FROM `s3ke6_categories` AS `s`

  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND s.id = 119

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1
1	SIMPLE	c	ALL	cat_idx,idx_access,idx_left_right	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	126	Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
Starting	0.05 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.05 ms
Preparing	0.00 ms
Unlocking tables	0.00 ms
Preparing	0.01 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.10 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
27	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
26	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
25	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
24	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
23	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
22	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
21	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
20	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
19	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
18	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
17	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
16	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
15	Joomla\CMS\Router\Route::_()	JROOT/modules/mod_articles_news/helper.php:113
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.69 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.790 MB Zeilen zurückgegeben: 0

SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note

  FROM s3ke6_fields AS a

  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language

  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out

  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access

  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id

  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (119,0)) 
  AND a.access IN (1,1) 
  AND (a.group_id = 0 OR g.access IN (1,1)) 
  AND a.state = 1 
  AND (a.group_id = 0 OR g.state = 1)

  ORDER BY a.ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ref	idx_state,idx_access,idx_context	idx_state	1	const	1	Using where; Using temporary; filesort wurde genutzt
1	SIMPLE	l	eq_ref	idx_langcode	idx_langcode	28	schulev_v41.a.language	1	Using where
1	SIMPLE	uc	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.checked_out	1
1	SIMPLE	ag	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.access	1	Using where
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.created_user_id	1	Using where
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	schulev_v41.a.group_id	1	Using where
1	SIMPLE	fc	ref	PRIMARY	PRIMARY	4	schulev_v41.a.id	1	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.03 ms
Optimizing	0.02 ms
Statistics	0.06 ms
Preparing	0.02 ms
Creating tmp table	0.04 ms
Sorting result	0.01 ms
Executing	0.00 ms
Sending data	0.15 ms
Creating sort index	0.02 ms
Removing tmp table	0.03 ms
Creating sort index	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.01 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322
22	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
21	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:189
20	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:136
19	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
18	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
17	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
16	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
15	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_articles_news/helper.php:164
14	ModArticlesNewsHelper::getList()	JROOT/modules/mod_articles_news/mod_articles_news.php:15
13	include JROOT/modules/mod_articles_news/mod_articles_news.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
12	Joomla\CMS\Helper\ModuleHelper::renderModule()	Derselbe Aufruf in der Zeile darunter.
11	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
10	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:628
9	Joomla\CMS\Helper\ModuleHelper::moduleCache()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:95
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:501
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:793
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:567
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1140
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.41 ms Nach letzter Abfrage: 23.19 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.415 MB Zeilen zurückgegeben: 1

SELECT `alias`

  FROM `s3ke6_content`

  WHERE id = '928'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.06 ms
Checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
Init	0.02 ms
Optimizing	0.01 ms
Statistics	0.05 ms
Preparing	0.01 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.02 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.429 MB Zeilen zurückgegeben: 1

SELECT alias

  FROM s3ke6_content

  WHERE id=928

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Checking permissions	0.01 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.01 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.604 MB Zeilen zurückgegeben: 1

SELECT `alias`

  FROM `s3ke6_content`

  WHERE id = '929'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.02 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.01 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.612 MB Zeilen zurückgegeben: 1

SELECT alias

  FROM s3ke6_content

  WHERE id=929

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.622 MB Zeilen zurückgegeben: 1

SELECT `alias`

  FROM `s3ke6_content`

  WHERE id = '927'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.01 ms
Commit	0.01 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
18	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:125
17	ContentRouter->getArticleSegment()	Derselbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
15	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
14	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
13	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:676
12	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.629 MB Zeilen zurückgegeben: 1

SELECT alias

  FROM s3ke6_content

  WHERE id=927

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s3ke6_content	const	PRIMARY	PRIMARY	4	const	1

Profil (Profile)

Status	Duration
Starting	0.01 ms
Checking permissions	0.00 ms
Opening tables	0.01 ms
After opening tables	0.00 ms
System lock	0.00 ms
Table lock	0.00 ms
Init	0.01 ms
Optimizing	0.01 ms
Statistics	0.01 ms
Preparing	0.00 ms
Unlocking tables	0.01 ms
Preparing	0.01 ms
Executing	0.00 ms
Sending data	0.01 ms
End of update loop	0.01 ms
Query end	0.00 ms
Commit	0.00 ms
Closing tables	0.00 ms
Unlocking tables	0.00 ms
Closing tables	0.01 ms
Starting cleanup	0.00 ms
Freeing items	0.00 ms
Updating status	0.01 ms
Reset for next command	0.00 ms

Call Stack

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
16	JDatabaseDriver->loadResult()	JROOT/components/com_content/helpers/legacyrouter.php:140
15	ContentRouterRulesLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
14	Joomla\CMS\Component\Router\RouterView->build()	JROOT/libraries/src/Router/SiteRouter.php:532
13	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:502
12	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
11	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:155
10	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
9	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
8	Joomla\CMS\Router\Route::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:70
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
5	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
4	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/libraries/src/Application/CMSApplication.php:1146
3	Joomla\CMS\Application\CMSApplication->render()	JROOT/libraries/src/Application/SiteApplication.php:778
2	Joomla\CMS\Application\SiteApplication->render()	JROOT/libraries/src/Application/CMSApplication.php:231
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

[Die „xdebug.file_link_format“-Anweisung der php.ini hinzufügen, um Links zu den Dateien zu erzeugen]

18 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

7 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM s3ke6_fields AS a 
  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `s3ke6_fields_categories` AS fc 
  ON fc.field_id = a.id

7 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,     c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,     c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,     c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version, 
  CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug 
  FROM `s3ke6_categories` AS `s` 
  INNER JOIN `s3ke6_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

3 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN c.published = 2 
  AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language,  LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum  / v.rating_count, 0), 0), 0) AS rating,        COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count 
  FROM s3ke6_content AS a 
  LEFT JOIN s3ke6_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN s3ke6_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

3 × SELECT `alias` 
  FROM `s3ke6_content`

3 × SELECT alias 
  FROM s3ke6_content

2 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `s3ke6_assets`

1 × SELECT `data` 
  FROM `s3ke6_session`

1 × SELECT `session_id` 
  FROM `s3ke6_session`

1 × SELECT id, rules 
  FROM `s3ke6_viewlevels

1 × SELECT b.id 
  FROM s3ke6_usergroups AS a 
  LEFT JOIN s3ke6_usergroups AS b 
  ON b.lft <= a.lft 
  AND b.rgt >= a.rgt

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, a.state, a.catid, a.created, a.created_by, a.created_by_alias, 
  CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, a.checked_out, a.checked_out_time, a.publish_up, a.publish_down, a.images, a.urls, a.attribs, a.version, a.ordering, a.metakey, a.metadesc, a.access, a.hits, a.metadata, a.featured, a.language, a.xreference,c.title AS category_title, c.alias AS category_alias, c.access AS category_access,u.name AS author,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count 
  FROM s3ke6_content AS a 
  INNER JOIN s3ke6_categories AS c 
  on c.id = a.catid 
  LEFT JOIN s3ke6_users AS u 
  on u.id = a.created_by 
  LEFT JOIN s3ke6_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN s3ke6_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `m`.`tag_id`,`t`.* 
  FROM `s3ke6_contentitem_tag_map` AS m  
  INNER JOIN `s3ke6_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid 
  FROM s3ke6_modules AS m 
  LEFT JOIN s3ke6_modules_menu AS mm 
  ON mm.moduleid = m.id 
  LEFT JOIN s3ke6_extensions AS e 
  ON e.element = m.module 
  AND e.client_id = m.client_id

1 × SELECT DISTINCT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state, g.note as group_note 
  FROM s3ke6_fields AS a 
  LEFT JOIN `s3ke6_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN s3ke6_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN s3ke6_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN s3ke6_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN s3ke6_fields_groups AS g 
  ON g.id = a.group_id

Andere Tabellen:

1 × INSERT INTO `s3ke6_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'63616a6e646e3761666d30696c63313062713038747574767638747262306739', 1, 1638266206, 0, '', 0

1 × UPDATE `s3ke6_extensions` 
  SET `params` = '{\"mediaversion\":\"e05b1e1c0b7e2a040794e48dd6526b5e\"}'

1 × SHOW FULL COLUMNS 
  FROM `s3ke6_content

1 × UPDATE s3ke6_content 
  SET `hits` = (`hits` + 1)

Stellenausschreibung

Klassenlehrperson für die 1. Realklasse

Gesund auf dem Weg - Stark in die Zukunft

Kalender

Aktuelles alle Stufen

Schulsport J&S 2021/2022
1. Semester

(Kindergarten bis 4. Klasse)

Projektwochen 2022

Winterlager Primar

Projektwochen Mittelstufe 2022

Kontakt

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

37 ausgeführte Abfragen 20.41 ms

18 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

Andere Tabellen:

Stellenausschreibung

Klassenlehrperson für die 1. Realklasse

Gesund auf dem Weg - Stark in die Zukunft

Kalender

Aktuelles alle Stufen

Schulsport J&S 2021/2022 1. Semester

(Kindergarten bis 4. Klasse)

Projektwochen 2022

Winterlager Primar

Projektwochen Mittelstufe 2022

Kontakt

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

37 ausgeführte Abfragen 20.41 ms

18 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung

SELECT-Tabellen:

Andere Tabellen:

Schulsport J&S 2021/2022
1. Semester