- wie viel Kraft braucht ein Schwimmer und
- was ist die richtige Balance zwischen hoch qualitativem Training und Ausdauer- Training+
In dem Artikel soll u.a. aufgezeigt werden, dass die Weiterentwicklung einer Größe wie z.B. Kraft bis zu einem gewissen Maß auch die Ausdauer fördert, dass aber ab einem gewissen Punkt zu viel Krafttraining die Ausdauer negativ beinflusst.
Wenn ein Schwimmer so schwach ist, dass er nahezu jede Muskelfaser in seinem Unterarm braucht, um seinen Arm durchs Wasser zu ziehen, werden alle Muskelfasern schnell ermüden. Wenn er jedoch seine Unterarmmuskulatur soweit trainiert, dass er nur einen kleinen Teil der Muskulatur benötigt, um eine bestimmte Handgeschwindigkeit zu erhalten, kann er seine Muskelfasern auch für was anderes gebrauchen. Von der Muskelphysiologie wissen wir, dass einige Fasern sich zusammenziehen, während andere ruhen und darauf warten, arbeiten zu müssen. Diese Kraftsteigerung erlaubt dem Schwimmer, eine schnellere Zeit zu schwimmen. Hat der Schwimmer, sine Ausdauer verbessert ? Das hängt davon ab, wie man Ausdauer definiert. Er hat die Fähigkeit der Arm-Druckmuskeln verbessert. die benötigte Kraft für eine längere Zeit aufzubringen, Daher kann man dies als eine Verbesserung der Ausdauerfähigkeit des gesamten Muskels ansehen. Die Ausdauerfähigkeit jeder Muskelfaser ist aber nicht verbessert worden. Im Gegenteil, sie wurde negativ beeinflusst. Jede Faser, die stärker geworden ist, ist auch größer im Durchmesser geworden. Dieser Größenzuwachs verlangsamt die Geschwindigkeit mit der CO2 aus dem Muskel heraus diffundieren kann und Sauerstoff in die Muskeln hinein. Das fördert den Aufbau von Ermüdungsprodukten und beeinflusst die Ausdauer negativ.
Können wir Kraft aufbauen, ohne die Muskelgröße zu vergrößern ? Offensichtlich nicht. Der Hauptfaktor für die Stärke eines Muskels, ist seim Durchmesser.
Es gibt komplexe Veränderungen der Enzyme, die die Geschwindigkeit positiv beeinflussen , aber negative Auswirkungen auf die Ausdauer haben und umgekehrt. Es ist wichtig für Trainer zu wissen, dass ein Schwimmer nicht maximale Kraft, maximale Ausdauer und maximale Geschwindigkeit in jede Muskelfaser packen kann. Wenn eine dieser Fähigkeiten besser wird, geht das zu Lasten der anderen. Daher muss das richtige Trainingsprogramm eine ausgewogene Mischung von verschiedenen Trainingsmethoden sein.
Wenn ein Schwimmer seine Muskelmasse so weit vergrößert, dass die Ausdauer jeder Faser so weit abnimmt, dass der Kraftvorteil, Muskelfasern wechseln zu können, verloren geht, dann hat der Schwimmer den Punkt erreicht, an dem das Training negative Auswirkungen hat. Der Sprinter braucht mehr Kraft und weniger Ausdauer als der Langstreckenschwimmer. Daher erreicht er den Punkt, an dem der Kraftzuwachs abnimmt später.
Früher waren die Schwimmer eher muskelbepackt. Aber spätestens seit den Zeiten eines Michael Groß ist dünner wieder in. Das heißt nicht, dass Krafttraining mit Gewichten out ist. Aber es heißt, dass Schwimmer nicht in Muskelbuden rennen sollen und auf Teufel komm raus auf Muskelmasse und -stärke trainieren sollen. Jeder Typ von Training hat positive Einflüsse auf eine bestimmte Eigenschaft, wie Schnelligkeit, Ausdauer usw. Er hat auch einen negativen Effekt auf andere Eigenschaften. Der Trainer muss also Trainingspläne entwerfen, die versuchen die Trainingsmethoden auszubalancieren mit dem Ziel, optimale, nicht maximale physiologische Anpassungen an alle gewünschten Eigenschaften zu erzielen.
In einem älteren Artikel of "Medicine in Science and Sports" überschrieben "Aerobe Antwort auf intensives Training von Läufern, war zu lesen , dass zu intensives Training zu einem Leistungsabfall bei längeren Strecken führen kann, zu einem Verlust der aeroben Fähigkeiten und der Ausdauer. Das gleiche passiert auch bei Schwimmern, die im Training alle Strecken mit vollem Einsatz schwimmen, dann am Ende der Saison langsamer werden als in der Vorsaison, in der sie nicht so hart trainiert haben. Diese Schwimmer haben schlicht zuviel intensiv trainiert, worunter die Ausdauer leidet.
Das ist für manche schwer zu akzeptieren. Manche tendieren dazu, die Schwimmer die hart trainieren, als Vorbild für andere darzustellen. Es gibt eine Zeit, in der man hart trainieren muss und eine, in der man nur gemäßigt hart trainieren soll. Die Worte, hart, locker, schnell, hohe Intensität und niedrige Intensität sind nur relative Ausdrücke. Sie sind ohne Bedeutung, so lange sie nicht definiert sind. Nur dann können sie verwendet werden, um Einsatz oder Anstrengung zu beschreiben.
Manchmal hört man auf die Frage, wie oft man im Training mit hohen Intensitäten trainiert als Antwort "Jeden Tag." Die Kraulschwimmer schwimmen z.B. 20x100 alle 1:15, Schnitt von 1:04 an einem Tag, 12x200m auf 2:30, Schnitt von 2:10, usw.
Diese Wiederholungsserien sind eine gute Trainingsmethode, aber sie sind kein intensives Training, sondern eine Form von Ausdauertraining. Programme wie 10x100 alle 4:;30, Schnitt unter 1:00 oder besser für männliche Schwimmer, das ist eine Form von intensivem Training.
In diesem Artikel steht "intensives Training" für ein Intensitätslevel oberhalb der anaeroben Schwelle. Das ist der Punkt, an dem der Körper nicht länger in der Lage ist, den Energiebedarf für die Muskeln aerob zu erzeugen, sondern auf anaerobe Mechanismen umschaltet. Das erzeugt eine Sauerstoffschuld und baut Laktat in den Muskeln auf. Der Blut-Laktatwert steigt ebenfalls an und Laktat wandert ins Blut. Anerkannt ist, dass die anaerobe Schwelle bei einem Laktatwert von 4mmol/Literr Blut erreicht ist. Der größte Teil des Trainings sollte an oder leicht unterhalb dieser 4mmol/Liter stattfinden. Training auf diesem Niveau maximiert die Ausdauer. Diese Art von Training hebt das Niveau, an dem die anaerobe Schwelle auftritt, verbessert aber nicht die Fähigkeit des Schwimmers anaerobe Übungsformen durchzuführen. Im Gegenteil dürfte es diese Qualität sogar verschlechtern.
Daher ist zu empfehlen, nicht das ganze Training auf diesem niedrigen Laktatlevel durchzuführen, sondern dass gelegentlich sehr harte Serien von Wiederholungen geschwommen werden, bei denen 20mmol/l und mehr erreicht werden. Während der Vorbereitungsphase kann man solche Einheiten bis zu zweimal pro Woche schwimmen.
Welche physiologischen Anpassungen als Resultat intensiven anaeroben Trainings auftreten, ist nicht ganz klar, aber es wird spekuliert, dass Veränderungen in der Pufferkapazität des Muskelgewebes auftreten, der Anstieg des pH-Wertes geringer wird und die anaerobe Kapazität verbessert wird.
Problematisch ist allerdings die aufwendige Durchführung der Laktattests. Praktikabler sind folgende Methoden, die Trainingsintensität zu bestimmen:
- die durchschnittliche Zeit bei einer Serie von Wiederholungen
- die durchschnittliche Zugzahl und
- die durchschnittliche Pulsrate nach den Wiederholungen.
Vergleicht man die Werte mehrerer Schwimmer untereinander, kann es große Unterschiede geben. Schwimmer und Coach müssen erkennen, dass aktuelle Werte mit den Werten vorheriger Serien verglichen werden müssen, um Unterschiede feststellen zu können. Zeiten nehmen für jeden Schwimmer, die Züge zu zählen und die Messung des Pulses nach jeder Wiederholung ist aber ebenfalls kaum durchführbar. Daher kann man auch die Züge jeweils auf der letzten Bahn jede zweiten oder dritten Wiederholung zählen. Den Puls kann man auch nur gelegentlich messen. Wenn ein Schwimmer langsam oder mit hoher Frequenz schwimmt sollte man ihn auch auffordern, seine Pulsfrequenz zu bestimmen.
Besonders sollte man solche Messungen durchführen bei sogenannten "Goal sets" - Wiederholungen mit hoher Intensität und langen Pausen und "Cruise intervals" - flüssiges Schwimmen mit kurzen Pausen.
Goal sets sind intensive oder anaerobe Wiederholungen mit langen Pausen. Die Pause is gewöhnlich 2,3 oder 4mal länger als die Dauer der Anstrengung. Es ist effizienter wenn alle zur gleichen Zeit abschwimmen, also z.B. 20x50 alle 2:00. Die Serien sollten mit einem Startsprung beginnen und damit Gelegenheit bieten, am Wettkampfstart zu feilen und sich daran zu gewöhnen, nach dem Start Wettkampftempo aufzunehmen. Die Schwimmer sollten genauso atmen, wie auch im Wettkampf.
Da die der Zweck der Goal sets u.a. ist, die Fähigkeit zu entwickeln, Renntempo für eine vorgegebene Zeit aufrecht zu erhalten, werden die Serien mit Renndistanz oder leicht darunter geschwommen. und mindestens mit 90% Anstrengung. Der Puls sollte nach jeder Wiederholung bei 170 bis 180 oder höher liegen. Da die anaerobe Schwelle bei den meisten Schwimmern bei Pulsfrequenzen von 150 bis 180 erreicht wird, können diese Serien als rein anaerob bezeichnet werden. Während der langen Pausen sollte der Puls auf 100 oder darunter absinken.
Beispiele:
Sprinter | 15x50 auf 1:30 bis 3min |
10x75 auf 2:00 oder 3:30 |
7x100 auf 2:30 bis 4:00 |
5x150 auf 3:00 bis 5:00 |
4x200 auf 4:30 bis 6:00 |
insgesamt 700 - 800m |
Mittel-Streckler | 20x50 auf 1:30 bis 3:00 |
14 x 75 auf 2:00 bis 3:30 |
10x100 auf 2:30 bis 4:00 |
7x150 auf 3:00 bis 5:00 |
5x200 auf 4:30 bis 6:00 |
Insgesamt 1000m |
Lang-Streckler | 10x200 auf 3:30 bis 5:00 |
7x300 auf 5:00 bis 7:00 |
5x400 auf 7:00 bis 8:30 |
4x500 auf 8: 9:30 |
3x800 auf 12:00 bis 13:00 |
Insgesamt 2000 bis 2400m |
Die Schwimmer sollten aufgefordert werden, die Wiederholungsserien mit maximaler Anstrengung zu schwimmen. Die Anstrengung sollte so verteilt sein, dass die durchschnittliche Zeit für alle Wiederholungen der best mögliche Schnitt ist, der erreicht werden kann. Die Durchschnittszeit sollte auch registriert werden und der Schwimmer in der Lage sein spontan seine Durchschnittszeiten über Serien wie 20x50 oder 10x100 nennen zu können.
Die meisten älteren Schwimmer sind in der Lage 1000m in einem goal set zu schwimmen. Da diese Serien sehr stressig sind, sind Serien mit 1500m oder mehr als eher zu hart einzustufen. Schwimmt man z.B. 32x50 alle 2:00 kann es drei oder vier Tage dauern, bis die Schwimmer sich erholt haben. Sprinter, Mittel-Streckler und Lang-Streckler sollten unterschiedliche Serien und Längen schwimmen. Langstreckler schwimmen oft mehr als 2000m, aber nicht so hart.
Nachwuchsschwimmer und Masters sollten in der Lage sein, Serien bis mindestens 500m (10x50, 5x100...) zu bewältigen. Man sollte die Belastung langsam steigern, z.B., bei 9 jährigen mit 4x50 alle 3:00 anfangen, beim nächsten mal 5x50 usw...
Diese Serien können ein - oder zweimal pro Woche geschwommen werden. Wenn am Wochenende Wettkampf ist, sollte man evtl. nur eine Serie in der Woche schwimmen und den Wettkampf selbst als anaerobe Trainingseinheit auffassen. Es dauert für die meisten Schwimmer nach einer harten Serie 2 bis 3 Tage, um sich vollständig zu erholen und wieder schnell schwimmen zu können. Andere Trainingsinhalte in dieser Zeit könnten z.B. sein: 4x50 alle 2:30 oder 12.x100 gesteigert von 1-4 alle 1:45, jeder vierte mit 90% Anstrengung. Kurze Sprints wie 20x25 alle 0:30 können ebenfalls eingestreut werden., Das ist nicht so ermüdend wie Serien mit langen Pausen.
Goal sets sind eine ausgezeichnete anaerobe Methode und sollten dauerhaft geschwommen werden. Das Augenmerk sollte aber darauf gerichtet sein, daß sie auch zu falschen physiologischen Anpassungen führen könne, wenn falsch angewandt. Es gibt eine Grenze für die Menge an hochintensivem Training, die ein Athlet verkraften kann und sich dem Trainingsstress anpassen kann. Wenn aerobe und anaerobe Phasen richtig gemischt werden, sollten die drei o.a. Variablen sich wie folgt verändern:
- Die Durchschnittszeit für die Serien sollte während der Saison abnehmen
- der Puls sollte sinken
- die Zugzahl sollte stabil bleiben oder abnehmen.
Wenn ein, zwei oder alle drei Parameter zunehmen, ist das ein Alarmzeichen. Meistens ist der Schwimmer dann ermüdet. Das kann auch durch andere Faktoren als das Training verursacht sein - Krankheit, Schulstress etc. Wenn das ganze Team schwach schwimmt, könnte allerdings das Trainingsprogramm zu hart gewesen sein und die Schwimmer übermäßig ermüdet haben. In diesem Fall sollte der Trainer mehr Training mit geringerer Intensität oder Ausdauercharakter einplanen. Man sollte keine goal sets schwimmen, wenn man nicht sicher ist, dass die Schwimmer ihn auch einigermaßen gut schwimmen können.
Um Trainingsfortschritt oder den Ermüdungsgrad zu bestimmen, reicht die Durchschnittszeit nicht als Information aus. Der Schwimmer könnte langsam sein, weil er nicht ausreichend motiviert ist oder andere Dinge im Kopf hat. Die zusätzlichen Indikatoren - Puls und Zugzahl - bieten zwei zusätzliche Parameter.
Folgendes Beispiel soll erzählen, wie ein Trainer goal sets verwenden kann, um Aussagen zu bekommen, ob ein Schwimmer übertrainiert ist oder aus anderen Gründen ermüdet ist.
Tag 1 : 20x50 Brust alle 2:00
Durchschnittszeit: 0:33,2
durchschnittlicher Puls: 188
durchschnittliche Zugzahl: 9,5
Tag 2- gleiche Serie
Durchschnittszeit: 0:32,1
durchschnittlicher Puls: 182
durchschnittliche Zugzahl: 9,1
Die Tatsache, dass die Zeiten besser wurden, der Puls niedriger war und die Zugzahl leicht abgenommen hat, zeigt, dass der Schwimmer seine Form gesteigert hat und dass das Training, zumindest in den letzten Tagen, nicht zu hart war. In anderen Worte, der Schwimmer hat zufriedenstellende Fortschritte gemacht.
Tag 3: 10x50 Brust alle 2:00
Durchschnittszeit: 0:33,8
durchschnittlicher Puls: 206
durchschnittliche Zugzahl: 10,2
Wenn die anderen Schwimmer sich weiterhin verbessert haben, könnte diese Resultate ein Anzeichen für Ermüdung, Erkältung oder anderen Stress sein.
Normalerweise sind die ersten Monate einer Trainingsphase dem Ausdauertraining gewidmet. Goal sets sollten in der zweiten Trainingsphase bis zur Taperphase eingebaut werden. Während des Beginns der Vorbereitungsphase ist eine solche Serie pro Woche ausreichend. Zum Ende hin können es aber auch schon mal zwei Serien sein.
Während der Taper Phase (zwei bis drei Wochen vor einer Meisterschaft) sollten nur Teilserien verwendet werden wie z.B. 4,6 oder 8x50 oder 3 oder 4 x 100. Während des Taperns sollte keine zu große Anzahl intensiver Wiederholungen trainiert werden. Zu oft trainieren Schwimmer während der Taperphase zu hart und wundern sich, wenn sie beim Wettkampf müde sind, obwohl sie doch den Trainingsumfang reduziert haben.
Während der Saison sollte die Art der goal sets variiert werden, um sie nicht langweilig werden oder zur Routine werden zu lassen. Es gibt eine Vielzahl von Möglichkeiten
- Serien mit gemischten Strecken
A: 2x200 auf 3:00 bis 6:00; 3x100 auf 2:30 bis 4:00, 6x50 auf 1:30 bis 2:30
B: 3x100 auf 2:30 bis 3:30; 4x75 auf 2:00 bis 3:00; 8x50 auf 1:30 bis 2:30
C: 2x150 auf 3:00 bis 4:00; 4x75 auf 2:00 bis 3:00; 8x50 auf 1:20 bis 2:30 usw. - Gebrochene Serien
Die Wiederholungen müssen nicht alle gleich sein. Im folgenden ein Beispiel eines Trainingsplans, in dem der goal set in drei Teile aufgesplittet ist
A: Einschwimmen 300 schwimmen, 300 Beine, 300 Arme, 300 schwimmen
B: 4x100 alle 3:00
C: 400 Beine, dann 8x100 alle 1:45
D: 3x100 alle 3:00
E: 20x50 Arme alle 0:50, 5er / 6er Zug
F: 3x100 alle 3:00
Zeiten, Puls etc bei B,D und F
Man kann im Verlauf einer Saison auch die Zahl der Wiederholungen abnehmen und die Pausenlänge zunehmen lassen. Während 10 Wochen Vorbereitungs- und Taperphase könnte z.B. folgender Plan gemacht werden:
- Woche: 10x100 alle 3:00
- Woche: 9x100 alle 4:00
- Woche: 8x100 alle 5:00
- Woche: 7x100 alle 6:00
- Woche: 6x100 alle 7:00
- Woche 5x100 alle 8:00
- Woche 4x100 alle 9:00
- - 10. Woche - keine goal sets
Ein Trainer kann z.B. 20x50, 10x100 und 5x200 als goal sets schwimmen lassen und nie oder nur selten andere Distanzen verwenden. In der nächsten Saison kann er 20x50, 14x75 und 7x150 als Standard goal sets verwenden. Alle möglichen Serien in einer Saison zu verwenden ist nicht ratsam, da es dann schwierig ist, Fortschritte festzustellen. Der 20x50er Test konnte als ein Standardtest in jeder Saison geschwommen werden.
Die Psychologie der goal sets ist einer der wesentlichen Aspekte. Sie motivieren sowohl Trainer als auch Schwimmer. Der Schwimmer kann sehen, dass sich im Laufe einer Saison seine Zeiten verbessern. Es kann ihn stimulieren, wenn er gut schwimmt, aber es auch ziemlich frustrierend sein, wenn er eine Serie langsamerer Wiederholungen schwimmt. Der Trainer sollte in der Lage sein zu erklären, warum der Schwimmer langsam geschwommen ist. Ein sorgfältiger Check von Puls und Zugzahl, gibt Auskunft darüber, ob der Schwimmer müde ist.
Der Teamgeist wird gefördert, da die Schwimmer sich gegenseitig zu guten Zeiten anfeuern. Diese Serien sind auch eine gute Wettkampfsimulation. Der Aktive lernt, wie er seine Energie und sein Tempo selbst auf eine vorgegebene Strecke verteilen muss. Die gefühlte Anstrengung ist ähnlich in goal sets und im Wettkampf.
Die Verwendung einer Kombination von goal sets und cruise intervals gibt dem Training und der Jahresplanung eine gewisse Struktur. Diese Struktur sollte flexibel sein, aber ihr Einsatz kann vermeiden, dass eine Unzahl von Trainingsmethoden in zufälliger Weise angewandt wird - in der Art ein bißchen von jedem und nicht viel von irgendwas. Die Konzepte bei der Verwendung dieser Programme sind logisch und dem Schwimmer verständlich, besonders wenn der Trainer sich die Mühe macht und sie erklärt. Unter diesen Bedingungen wird der Schwimmer mehr kooperieren und härter trainieren.
Während die intensiven goal sets submaximale anaerobe Kapazität aufbauen, wirken sie nicht in Richtung aerobe Kapazität (Ausdauer). Einer der Gründe ist die lange Pause zwischen den Wiederholungen, in der der Puls bis fast auf Normalniveau absinken kann. Es wichtig zu wissen, daß für einen Ausdauereffekt der Puls für eine längere Zeit auf einem höheren Niveau gehalten werden muß.
Cruise interval Serien sind das exakte Gegenteil von goal sets, da sie kurze Pausen haben und der Puls nicht merklich absinken kann. Während goal sets nur gelegentlich eingesetzt werden können, können cruise intervals in jeder Trainingseinheit geschwommen werden. Sie dienen primär dem Aufbau muskulärer Ausdauer und der Fitness des Herz-Kreislaufsystems.
Definition: Ein cruise interval ist die schnellste Abgangszeit, in der ein Schwimmer 5x100 schwimmen kann + 5 Sekunden.
Z.B. Der schnelle Willi kann 5x100 alle 1:20 schwimmen. Seion cruise intrerval ist dann 1:25. Für 200er wird das Intervall verdoppelt, für 400er vervierfacht etc. Seine cruise Intervalle sind also z.N. 0:45 für 50er, 1:25 für 100er, 2:50 für 200er, 5:40 für 400er....
Beispiele:
50 | 100 | 150 | 200 | 400 | |
Erwachsene Männer | 0:35 bis 0:40 | 1:20 bis 1:25 | 2:00 bis 2:10 | 2:40 bis 2:50 | 5:20 bis 5:30 |
Erwachsene Frauen | 0:40 bis 0:45 | 1:25 bis 1:30 | 2:10 bis 2:20 | 2:50 bis 3:00 | 5:30 bis 5:40 |
12 - 14 Jahre | 0:45 - 0:50 | 1:30 - 1:35 | 2:20 bis 2:30 | 3:00 bis 3:10 | 5:40 bis 5:50 |
Der Begriffe Cruise (Reise) Intervall vermittelt den Eindruck von Geschwindigkeit ohne extreme Anstrengung. Die Schwimmer lernen, daß der Puls 150 bis 180 betragen soll. Bei dieser Frequenz erreicht der Schwimmer sine anaerobe Schwelle zumindest während des letzten Teils jeder Wiederholung. Die kurze Pause, meist nur 5 bis 10 Sekunden, lässt den Puls leicht absinken (5-15 Schläge) und erlaubt eine gewisse Reduktion der Sauserstoffschuld. Derr Schwimmer kann ein schnelleres Tempo aufrecht erhalten, als wenn er durchschwimmt.
Schwimmer brauchen eine gewisse Hilfestellung dabei, ihr cruise Intervall zu bestimmen. Früh in der Saison sollte dieser Wert für alle Schwimmer, egal welche Lage, bestimmt werden. Ein paar Tage später das gleiche nochmal für die Speziallage. Der Wert sollte jeden oder jeden zweiten Monat erneut ermittelt werden. Wenn der Wert z.B. im November 1:25 ist, sollte er im Januar sich auf 1:20 verbessert haben. Im März sollte eine weitere Verbesserung etwa auf 1:17 erreicht worden sein.
Wenn die Aktiven ihre Kondition verbessern sollte auch ihr cruise interval (CI) sich verbessern. Wenn das nicht der Fall ist, ist das Trainingsprogramm nicht richtig gestaltet oder die Schwimmer sind zu müde. Dann sollte wieder einmal Puls und Zuglänge bestimmt werden.
Ein Programm zur Bestimmung des CI könnte z.B. sein:
A: Einschwimmen wie oben
B:
Kraul | Rücken/Delphin | Brust | Lagen | |
5x100 | 1:25 | 1:30 | 1:45 | 1:50 |
5x100 | 1:20 | 1:25 | 1:40 | 1:45 |
5x100 mit der kürzest möglichen Pause z.B. | 1:10 | 1:15 | 1:35 | 1:30 |
Der CI muss nicht unbedingt in 5 Sekunden-Schritten sein. auch wenn das der gewöhnliche Wert ist. Zu Beginn der Saison werden die meisten dieser Serien im Kreis geschwommen. Wenn jeder in diesem Kreis zu anderen Zeiten abschwimmt, bricht leicht das Chaos aus. Zum Ende der Saison kann man z.B. Gruppen einteilen wie Krauler alle 1:20, Brust Schwimmer alle 1:35 etc.
Die Cruise Speed (CS) wird bestimmt durch die Durchschnittszeit für die 5x100 multipliziert mit dem Zuwachs der Strecke und Addition der folgenden Werte:
100 | 200 | 300 | 400 | 500 | 800 |
1xDZ* | 2xDZ | 3xDZ | 4xDZ | 5xDZ | 8xDZ |
+ 2-4sec. | 5 - 11 | 9 - 18 | 13 - 25 | 18 - 32 | 35 - 48 |
* DZ Durchschnittszeit der 5x100. Je langsamer der Schwimmer, desto größer die zugeschlagene Zeit.
Der Grund für die große Spanne ist, dass es viele Unterschiede zwischen einzelnen Schwimmern gibt und dass ein Schwimmer sich von Tag zu Tag ändert, abhängig von seiner Ermüdung und seiner Motivation.
Während das cruise interval sich direkt mit der geschwommenen Strecke ändert, ändert sich die CS nicht linear, sondern eher in einer Kurve. Wenn die Schwimmer viel schneller schwimmen. geht es in Richtung anaerob. Das Ziel sollte sein, nicht so schnell zu schwimmen wie möglich.
Wie kann man Cruise intervals im Trainingsplan integrieren. Nach dem Aufwärmen könnte man z.B. eine erste Serie schwimmen, bei der in einer ersten Teilserie CI plus 5 Sekunden gilt. Die zweite Teilserie wird geschwommen mit dem exakten CI und eine dritte Serie mit CI minus 5 Sekunden. Eine Minute Pause sollte erlaubt werden. Beispiele:
Individueller CI | Serie 1 | Serie 2 | Serie 3 | Serie 4 |
CI plus 5 Sek. | 8 x 75 | 6x100 | 4x150 | 3x200 |
CI | 12x75 | 10x100 | 6x150 | 5x200 |
XI minus 5 Sek. | 6x75 | 4x100 | 3x150 | 2x200 |
Diese Serien sollten nicht angewandt werden, wenn die Schwimmer extrem müde sind, z.B. nach einem Goal set. Dann sollte allerhöchstens eine Serie mit CI plus 5 Sekunden geschwommen werden. Der Trainer sollte auch das CI der Länge der Wiederholungen anpassen. Wenn die Zahl der Wiederholungen größer wird, sollte die Abgangszeit leicht verkürzt werden. Z.B 30x100 als CI oder CI plus 5 Sekunden.
Obwohl die Priorität auf die beiden genannten Trainingsmethoden gelegt werden sollte, sind auch andere Trainingsmethoden notwendig, um Geschwindigkeit, anaerobe Kapazität oder Ausdauer zu fördern. Die folgende Liste zeigt verschiedene Methoden und die Fähigkeiten, die sie entwickeln:
Trainingsart | Fähigkeit | Fähigkeit, die nicht berührt wird |
Sprint Training (anaerob, Laktat)
20x25 alle 1:00 |
Geschwindigkeit oder Explosivität, verbessert Kraft und Fähigkeit, schneller zu ziehen |
Ausdauer |
Anaerobes Laktat Training Wettkämpfe, hoch intensive Serien, Tests |
Anaerober Stoffwechsel, hilft eine hohe Intensität über eine längere Zeit aufrecht zu erhalten, wie t.B. in 100m oder 200m Rennen | Kann Ausdauer negativ beeinflussen oder nur wenig zur Entwicklung selbiger beitragen. Mit Sicherheit nicht so viel wie Training längerer Strecken oder CI Serien. Trägt etwas zur Schnelligkeit bei, aber nicht so viel wie Sprint Training |
Cruise intervals, wie 15x100 auf CI | Ausdauer - etwas anaerobe Kapazität | Kein Beitrag für Schnelligkeit oder Explosivität |
Überdistanz Training wie 3000m oder 4x800 | Ausdauer, sowohl muskulär als auch Herz-Kreislauf System. Der Typ Training, der am meisten vernachlässigt werden, dessen Effekt aber nicht unterschätzt werden sollte. | Kein Beitrag zur Schnelligkeit und nur wenig zur anaeroben Kapazität. |
Neuere Artikel
Weitere Artikel
Beliebte Artikel
- Trainingspläne Schwimmen - 24/10/2009 - 37209 Artikel-Aufrufe
- Das Training der aeroben Ausdauer im Schulsport - 12/02/2007 - 28654 Artikel-Aufrufe
- Training von Michael Phelps - 14/02/2007 - 24591 Artikel-Aufrufe
- Trainingsplanung und Periodisierung - 29/09/2010 - 17510 Artikel-Aufrufe
- Verbesserung der Grundschnelligkeit - 14/02/2007 - 17096 Artikel-Aufrufe
- Aerobe Grundlage und Ausdauertraining für jugendliche Schwimmer - 12/02/2007 - 15620 Artikel-Aufrufe
Nächste Wettkämpfe und Veranstaltungen
-
Fr, 6. September 2024 - So, 8. September 2024
SwimIn 2024 -
Sa, 5. Oktober 2024
DMS Masters -
Fr, 1. November 2024 - So, 3. November 2024
Hessische Kurzbahnmeister... -
Sa, 9. November 2024
Hessische Meisterschaften... -
Fr, 29. November 2024 - So, 1. Dezember 2024
DMM Kurzbahn 2024 Freibur...
GSV History today....
- 3th anniversary of event Meldeergebnis::10. Sodenia Schwimmfest
- 13th anniversary of event Pflichtzeiten Hessische Meisterschaften 2011
- 23th anniversary of event Bericht: Deutsche Masters Wetzlar 2001
- 53th anniversary of event 1971::Zweiter Platz für GSV-Wasserballer in Friedrichshafen
- 73th anniversary of event 1951::Vorschau Hessische Jugendmeisterschaften Alsfeld
Nächste Events
Mo | Di | Mi | Do | Fr | Sa | So |
---|---|---|---|---|---|---|
1 | 2 | 3 | 4 | |||
5 | 6 | 7 | 8 | 9 | 10 | 11 |
12 | 13 | 14 | 15 | 16 | 17 | 18 |
19 | 20 | 21 | 22 | 23 | 24 | 25 |
26 | 27 | 28 | 29 | 30 |
Joomla!-Debug-Konsole
{ "__default": { "session": { "counter": 5, "timer": { "start": 1724566759, "last": 1724566760, "now": 1724566760 }, "token": "qvB5sOUgYUHYlbpdadQjnXo5oj2hEXgI" }, "registry": { "com_jvld": { "return": "L2xpZWJsaW5rcy9kZXRhaWwvaWFuLXRob3JwZQ==" }, "com_attachments": { "current_url": "&return=aHR0cHM6Ly9nc3Ytc2Nod2ltbWVuLmRlL2xpZWJsaW5rcy9kZXRhaWwvaWFuLXRob3JwZT9tb2RqZW1jYWxfaWQ9MzMxJm1vZGplbWNhbF9tb250aD0zJm1vZGplbWNhbF95ZWFyPTIwMjc%3D" }, "modjemcal": { "month": { "331": 4 }, "year": { "331": 2021 } } }, "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 } } }
Zeit
Speicher
66 ausgeführte Abfragen 38.96 ms
11 Duplikate gefunden!
- Abfragezeit: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.195 MB Zeilen zurückgegeben: 1
SELECT `data`
FROM `jos331_session`
WHERE `session_id` = X'3234323766303630643137396366646330666238336338666262633461326430'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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() Der selbe 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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 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:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 6.49 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.902 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `jos331_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_viewlevels NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.914 MB Zeilen zurückgegeben: 2
SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index Status Duration starting 0.04 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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 - Abfragezeit: 0.55 ms Nach letzter Abfrage: 10.70 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 6.376 MB Zeilen zurückgegeben: 2
SHOW FULL COLUMNS
FROM `jos331_gsd_config`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_gsd_config`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.20 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.04 ms checking permissions 0.02 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms removing tmp table 0.04 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 14 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 13 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 12 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 11 Joomla\CMS\Table\Table->__construct() JROOT/administrator/components/com_gsd/tables/config.php:26 10 GSDTableConfig->__construct() JROOT/libraries/src/Table/Table.php:328 9 Joomla\CMS\Table\Table::getInstance() JROOT/administrator/components/com_gsd/GSD/Helper.php:401 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.403 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_gsd_config
WHERE `name` = 'config'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_gsd_config NULL system NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 10 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 9 Joomla\CMS\Table\Table->load() JROOT/administrator/components/com_gsd/GSD/Helper.php:402 8 GSD\Helper::getParams() JROOT/plugins/system/gsd/gsd.php:61 7 plgSystemGSD->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.33 ms Nach letzter Abfrage: 61.94 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 11.380 MB
UPDATE `jos331_extensions`
SET `params` = '{\"mediaversion\":\"6f4e25ac2e67e22c6dee5cc6140420ac\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos331_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.08 ms updating 0.06 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.05 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # 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/seole/seole.php:159 8 plgSystemSEOle->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.33 ms Nach letzter Abfrage: 3.70 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.363 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos331_redirect_links`
WHERE (`old_url` = 'https://gsv-schwimmen.de/ratgeber/training/goal-sets-und-cruise-intervals?modjemcal_id=331&modjemcal_month=4&modjemcal_year=2021' OR `old_url` = '/ratgeber/training/goal-sets-und-cruise-intervals?modjemcal_id=331&modjemcal_month=4&modjemcal_year=2021' OR `old_url` = 'https://gsv-schwimmen.de/ratgeber/training/goal-sets-und-cruise-intervals' OR `old_url` = '/ratgeber/training/goal-sets-und-cruise-intervals')
AND published=1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_redirect_links NULL ALL idx_old_url ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.06 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.08 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 10 JDatabaseDriver->loadAssocList() JROOT/plugins/system/seole/class/seo.class.php:543 9 redim_seo_class::check_redirects() JROOT/plugins/system/seole/seole.php:171 8 plgSystemSEOle->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.26 ms Nach letzter Abfrage: 1.10 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.399 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '516'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.406 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '521'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.412 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '518'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.417 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '523'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 1 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:33 9 plgSystemAutoArchive->kat2kat() JROOT/plugins/system/autoarchive/autoarchive.php:22 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.422 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:23 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.428 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:24 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.433 MB Zeilen zurückgegeben: 0
SELECT c.id
FROM jos331_content AS c
WHERE c.catid = '0'
AND c.publish_down != '0000-00-00 00:00:00'
AND c.publish_down <= '2024-08-25 06:19:21'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ref idx_catid idx_catid 4 const 2 30.00 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/autoarchive/autoarchive.php:113 10 plgSystemAutoArchive->artRead() JROOT/plugins/system/autoarchive/autoarchive.php:82 9 plgSystemAutoArchive->kat2other() JROOT/plugins/system/autoarchive/autoarchive.php:25 8 plgSystemAutoArchive->OnAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 3.65 ms Abfragespeichernutzung: 0.061 MB Speichernutzung vor Abfrage: 12.672 MB Zeilen zurückgegeben: 1
select version, dir_online, value
from `jos331_jvld_settings`
where id = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jvld_settings NULL const PRIMARY PRIMARY 2 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.cfg.php:33 12 JvldCfg->loadData() JROOT/plugins/system/jvldframework/library/class.cfg.php:24 11 JvldCfg->__construct() JROOT/plugins/system/jvldframework/library/class.cfg.php:48 10 JvldCfg::getInstance() JROOT/plugins/system/jvldframework/jvldframework.php:101 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.40 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.734 MB Zeilen zurückgegeben: 1
select id
from jos331_menu
where link = 'index.php?option=com_jvld&view=jvld'
and published = 1
and client_id = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_menu NULL ref idx_client_id_parent_id_alias_language idx_client_id_parent_id_alias_language 1 const 68 1.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms executing 0.00 ms Sending data 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.db.php:53 10 JvldDb::getRow() JROOT/plugins/system/jvldframework/jvldframework.php:106 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 12.743 MB Zeilen zurückgegeben: 1
select sparams
from `jos331_jvld_styles`
where stylename = 'default'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jvld_styles NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 33.33 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/plugins/system/jvldframework/library/class.cfg.php:90 10 JvldCfg->overrideWithStyleParams() JROOT/plugins/system/jvldframework/jvldframework.php:123 9 plgSystemJvldframework->initializeDirectory() JROOT/plugins/system/jvldframework/jvldframework.php:47 8 plgSystemJvldframework->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 11.71 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.206 MB Zeilen zurückgegeben: 1
select email
from jos331_users
where id=706
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/bfstop/helpers/db.php:307 12 BFStopDBHelper->getUserEmailWhere() JROOT/plugins/system/bfstop/helpers/db.php:320 11 BFStopDBHelper->getUserEmailByID() JROOT/plugins/system/bfstop/helpers/notify.php:23 10 BFStopNotifier->__construct() JROOT/plugins/system/bfstop/bfstop.php:197 9 plgSystembfstop->init() JROOT/plugins/system/bfstop/bfstop.php:369 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.214 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE (ipaddress='18.118.1.93'
AND LOCATE('/', ipaddress) = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:224 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.26 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.220 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress
from jos331_bfstop_allowlist
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('18.118.1.93') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL Impossible WHERE noticed after reading const tables Status Duration starting 0.10 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:225 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.227 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE (ipaddress='18.118.1.93'
AND LOCATE('/', ipaddress) = 0)
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-08-25 08:19:21')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 10.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.b.id 1 100.00 Using index Status Duration starting 0.07 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:214 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.38 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.233 MB Zeilen zurückgegeben: 0
SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('18.118.1.93') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-08-25 08:19:21')
AND NOT EXISTS (SELECT 1
FROM jos331_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 47 100.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.b.id 1 100.00 Using index Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.02 ms preparing 0.02 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.05 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:215 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() 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:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 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 - Abfragezeit: 0.19 ms Nach letzter Abfrage: 11.44 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.053 MB Zeilen zurückgegeben: 4
select id, title, alias
from jos331_jumi
where published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jumi NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5 20.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1811 12 JDatabaseDriver->loadRowList() JROOT/plugins/system/jumirouter/jumirouter.php:57 11 parseJumiRouter() Der selbe Aufruf in der Zeile darunter. 10 call_user_func_array() JROOT/libraries/src/Router/Router.php:596 9 Joomla\CMS\Router\Router->processParseRules() JROOT/libraries/src/Router/SiteRouter.php:597 8 Joomla\CMS\Router\SiteRouter->processParseRules() JROOT/libraries/src/Router/Router.php:570 7 Joomla\CMS\Router\Router->_processParseRules() JROOT/libraries/src/Router/Router.php:216 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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 - Abfragezeit: 0.57 ms Nach letzter Abfrage: 1.76 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 15.175 MB Zeilen zurückgegeben: 9
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 `jos331_categories` AS `s`
INNER JOIN `jos331_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.published = 1
AND s.id = 314
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 18.71 Using where Status Duration starting 0.09 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.09 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.19 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 14 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 13 Joomla\CMS\Categories\Categories->get() JROOT/components/com_content/router.php:165 12 ContentRouter->getCategoryId() Der selbe Aufruf in der Zeile darunter. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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 - Abfragezeit: 0.21 ms Nach letzter Abfrage: 0.58 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 15.249 MB Zeilen zurückgegeben: 1
SELECT `id`
FROM `jos331_content`
WHERE alias = 'goal-sets-und-cruise-intervals'
AND catid = '65'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_content NULL ref idx_catid,alias,alias_2,idx_alias alias 766 const 1 17.43 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/components/com_content/router.php:225 12 ContentRouter->getArticleId() Der selbe Aufruf in der Zeile darunter. 11 call_user_func_array() JROOT/libraries/src/Component/Router/Rules/StandardRules.php:140 10 Joomla\CMS\Component\Router\Rules\StandardRules->parse() JROOT/libraries/src/Component/Router/RouterView.php:266 9 Joomla\CMS\Component\Router\RouterView->parse() JROOT/libraries/src/Router/SiteRouter.php:438 8 Joomla\CMS\Router\SiteRouter->parseSefRoute() JROOT/libraries/src/Router/Router.php:482 7 Joomla\CMS\Router\Router->_parseSefRoute() JROOT/libraries/src/Router/Router.php:227 6 Joomla\CMS\Router\Router->parse() JROOT/libraries/src/Router/SiteRouter.php:139 5 Joomla\CMS\Router\SiteRouter->parse() JROOT/libraries/src/Application/CMSApplication.php:1142 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 - Abfragezeit: 0.18 ms Nach letzter Abfrage: 5.43 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.658 MB Zeilen zurückgegeben: 1
SELECT s.*
FROM jos331_template_styles as s
WHERE s.client_id = 0
AND s.id =67id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_client_id,idx_client_id_home PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.01 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/phocaupgrade/phocaupgrade.php:216 8 plgSystemPhocaUpgrade->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:1190 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 - Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.65 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 15.691 MB Zeilen zurückgegeben: 4
SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`
WHERE `published` = 1
AND `feeded` = 1
ORDER BY `ordering`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_obrss NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 6 16.67 Using where; filesort wurde genutzt Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/obrss/obrss.php:40 8 plgSystemobrss->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:1190 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 - Abfragezeit: 1.13 ms Nach letzter Abfrage: 9.11 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 16.396 MB Zeilen zurückgegeben: 68
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_acymailing','com_admin','com_adminmenumanager','com_ajax','com_akeeba','com_alfcontact','com_articlegenerator','com_associations','com_asurveys','com_attachments','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_creativeimageslider','com_customproperties','com_dbreplacer','com_docindexer','com_fields','com_finder','com_flexicontactplus','com_googlesearch_cse','com_gsd','com_installer','com_instantfblogin','com_jce','com_jcomments','com_jem','com_jextranet','com_jmap','com_joomlaupdate','com_jsocialfeed','com_jumi','com_jvld','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_nextend2','com_obrss','com_offlajn_installer','com_phocadownload','com_phocagallery','com_phocamaps','com_phocapdf','com_plugins','com_postinstall','com_privacy','com_redirect','com_responsivizer','com_search','com_spambotcheck','com_tags','com_templateck','com_templates','com_userextranet','com_users','com_weblinks','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_assets NULL range idx_asset_name idx_asset_name 202 NULL 69 100.00 Using index condition Status Duration starting 0.09 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.08 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.24 ms preparing 0.01 ms executing 0.00 ms Sending data 0.58 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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 - Abfragezeit: 5.86 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.708 MB Speichernutzung vor Abfrage: 16.476 MB Zeilen zurückgegeben: 3822
SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_assets NULL ALL idx_asset_name,idx_parent_id ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 5696 21.48 Using where Status Duration starting 0.03 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 5.62 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # 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 - Abfragezeit: 0.56 ms Nach letzter Abfrage: 8.16 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 19.792 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `jos331_assets`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_assets`Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.15 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 19 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 18 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 17 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Asset.php:61 16 Joomla\CMS\Table\Asset->__construct() JROOT/libraries/src/Access/Access.php:783 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 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 - Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.814 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 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 - Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.95 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 19.852 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 17 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 16 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 15 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 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 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 19.738 MB Zeilen zurückgegeben: 31
SHOW FULL COLUMNS
FROM `jos331_content`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_content`Status Duration starting 0.02 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.10 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.02 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.02 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # 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:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 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:328 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 - Abfragezeit: 0.39 ms Nach letzter Abfrage: 2.37 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 19.957 MB
UPDATE jos331_content
SET `hits` = (`hits` + 1)
WHERE `id` = '240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE jos331_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.07 ms updating 0.09 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 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 - Abfragezeit: 0.42 ms Nach letzter Abfrage: 13.41 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 21.035 MB Zeilen zurückgegeben: 1
SELECT a.id,a.params
FROM jos331_users AS a
WHERE a.name='706' or a.id='706'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL index_merge PRIMARY,idx_name idx_name,PRIMARY 402,4 NULL 2 100.00 Using sort_union(idx_name,PRIMARY); Using where Status Duration starting 0.07 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 9 JDatabaseDriver->loadObject() JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:78 8 plgSystemJGoogleAuthor->_get_googleauthorlink() JROOT/plugins/system/jgoogleauthor/jgoogleauthor.php:55 7 plgSystemJGoogleAuthor->onAfterDispatch() 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/SiteApplication.php:199 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 - Abfragezeit: 0.75 ms Nach letzter Abfrage: 5.33 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 21.349 MB Zeilen zurückgegeben: 3
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 `jos331_categories` AS `s`
INNER JOIN `jos331_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,5)
AND c.published = 1
AND s.id = 65
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 17.31 Using where Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.14 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.20 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # 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() Der selbe 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/administrator/components/com_gsd/GSD/Helper.php:217 11 GSD\Helper::route() JROOT/administrator/components/com_gsd/GSD/Helper.php:89 10 GSD\Helper::getCrumbs() JROOT/plugins/system/gsd/gsd.php:299 9 plgSystemGSD->getJSONBreadcrumbs() JROOT/plugins/system/gsd/gsd.php:118 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.38 ms Nach letzter Abfrage: 3.63 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 21.578 MB Zeilen zurückgegeben: 1
SELECT a.*
FROM jos331_gsd a
WHERE a.state = 1
AND a.plugin = 'menus'
ORDER BY a.id descid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref state,plugin plugin 152 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.03 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # 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:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gsd/models/items.php:167 15 GSDModelItems->getItems() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 14 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.879 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 24 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 23 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 22 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 18 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.25 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.890 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 25 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 24 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 23 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 22 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 21 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 20 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 19 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 18 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:78 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.905 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 21 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 20 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:128 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.915 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_assets
WHERE `name` = 'com_content.article.240'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.00 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.02 ms executing 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 22 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/Table.php:747 21 Joomla\CMS\Table\Table->load() JROOT/libraries/src/Access/Access.php:784 20 Joomla\CMS\Access\Access::getAssetId() JROOT/libraries/src/Access/Access.php:544 19 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 18 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 17 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:128 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.54 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.118 MB Speichernutzung vor Abfrage: 21.766 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 jos331_content AS a
INNER JOIN jos331_categories AS c
on c.id = a.catid
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos331_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 240
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-08-25 06:19:21')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-08-25 06:19:21')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.13 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 17 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 16 ContentModelArticle->getItem() JROOT/plugins/gsd/content/content.php:57 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.76 ms Nach letzter Abfrage: 2.67 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 21.994 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 jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos331_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 (65,0,314))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; filesort wurde genutzt 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 usr_web689_1.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 usr_web689_1.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.12 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.06 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.11 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.17 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 21 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 20 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 19 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 18 FieldsHelper::getFields() JROOT/plugins/gsd/content/content.php:267 17 plgGSDContent->getCustomFields() JROOT/plugins/gsd/content/content.php:120 16 plgGSDContent->attachCustomFields() JROOT/plugins/gsd/content/content.php:103 15 plgGSDContent->viewArticle() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:318 14 GSD\PluginBase->getPayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:155 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 3.44 ms Nach letzter Abfrage: 3.14 ms Abfragespeichernutzung: 0.790 MB Speichernutzung vor Abfrage: 22.283 MB Zeilen zurückgegeben: 503
SELECT a.*
FROM jos331_gsd a
WHERE a.state = 1
AND a.plugin = 'content'
ORDER BY a.id descid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref state,plugin state 1 const 504 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 2.85 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.01 ms # 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:194 16 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_gsd/models/items.php:167 15 GSDModelItems->getItems() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:220 14 GSD\PluginBase->getSnippets() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:161 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.60 ms Nach letzter Abfrage: 40.55 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 22.682 MB Zeilen zurückgegeben: 18
SHOW FULL COLUMNS
FROM `jos331_users`„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `jos331_users`Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.14 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.01 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.06 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 32 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 31 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 30 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 29 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 28 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/User.php:41 27 Joomla\CMS\Table\User->__construct() JROOT/libraries/src/Table/Table.php:328 26 Joomla\CMS\Table\Table::getInstance() JROOT/libraries/src/User/User.php:603 25 Joomla\CMS\User\User::getTable() JROOT/libraries/src/User/User.php:877 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 20 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:161 19 NRFramework\SmartTags->addUserTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:105 18 NRFramework\SmartTags->addDefaultTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:431 17 NRFramework\SmartTags->prepare() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:369 16 NRFramework\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 15 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:347 14 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 22.717 MB Zeilen zurückgegeben: 0
SELECT *
FROM `jos331_users`
WHERE `id` = 62id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE NULL NULL NULL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL NULL NULL no matching row in const table Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms executing 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 27 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 26 JDatabaseDriver->loadAssoc() JROOT/libraries/src/Table/User.php:87 25 Joomla\CMS\Table\User->load() JROOT/libraries/src/User/User.php:880 24 Joomla\CMS\User\User->load() JROOT/libraries/src/User/User.php:248 23 Joomla\CMS\User\User->__construct() JROOT/libraries/src/User/User.php:301 22 Joomla\CMS\User\User::getInstance() JROOT/libraries/src/Factory.php:266 21 Joomla\CMS\Factory::getUser() JROOT/plugins/system/nrframework/NRFramework/Factory.php:41 20 NRFramework\Factory->getUser() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:161 19 NRFramework\SmartTags->addUserTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:105 18 NRFramework\SmartTags->addDefaultTags() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:431 17 NRFramework\SmartTags->prepare() JROOT/plugins/system/nrframework/NRFramework/SmartTags.php:369 16 NRFramework\SmartTags->replace() JROOT/administrator/components/com_gsd/GSD/MappingOptions.php:125 15 GSD\MappingOptions::replace() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:347 14 GSD\PluginBase->preparePayload() JROOT/administrator/components/com_gsd/GSD/PluginBase.php:171 13 GSD\PluginBase->onGSDBeforeRender() JROOT/libraries/joomla/event/event.php:70 12 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 11 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 10 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/administrator/components/com_gsd/GSD/Helper.php:439 9 GSD\Helper::event() JROOT/plugins/system/gsd/gsd.php:122 8 plgSystemGSD->init() JROOT/plugins/system/gsd/gsd.php:77 7 plgSystemGSD->onBeforeRender() 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:1102 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 - Abfragezeit: 0.24 ms Nach letzter Abfrage: 13.28 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 23.206 MB Zeilen zurückgegeben: 80
SELECT `keyname`,`value`
FROM jos331_jem_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jem_config NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 80 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.07 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 15 JDatabaseDriver->loadAssocList() JROOT/components/com_jem/classes/config.class.php:108 14 JemConfig->loadData() JROOT/components/com_jem/classes/config.class.php:65 13 JemConfig->__construct() JROOT/components/com_jem/classes/config.class.php:49 12 JemConfig::getInstance() JROOT/components/com_jem/helpers/helper.php:77 11 JemHelper::addFileLogger() JROOT/modules/mod_jem_cal/mod_jem_cal.php:25 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 3.48 ms Nach letzter Abfrage: 2.03 ms Abfragespeichernutzung: 0.134 MB Speichernutzung vor Abfrage: 23.371 MB Zeilen zurückgegeben: 596
SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid
WHERE c.published = 1
AND (c.access IN (1,1,5))
AND c.id IN (2,3,5,9,4,10)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL ALL PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 14 7.14 Using where; Using temporary 1 SIMPLE rel NULL ref category event relation,catid category event relation 4 usr_web689_1.c.id 20 100.00 Using where; Using index 1 SIMPLE a NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.rel.itemid 1 100.00 Using where; Using index Status Duration starting 0.07 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.01 ms Creating tmp table 0.02 ms executing 0.00 ms Sending data 3.14 ms end 0.01 ms query end 0.01 ms removing tmp table 0.01 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 17 JDatabaseDriver->loadColumn() JROOT/components/com_jem/models/eventslist.php:658 16 JemModelEventslist->getCategories() JROOT/components/com_jem/models/eventslist.php:375 15 JemModelEventslist->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 14 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_jem/models/eventslist.php:483 12 JemModelEventslist->getItems() JROOT/modules/mod_jem_cal/helper.php:154 11 ModJemCalHelper::getDays() JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 4.72 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 23.379 MB Zeilen zurückgegeben: 0
SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid
WHERE a.access IN (1,1,5)
AND ((`a`.published = 1))
AND DATEDIFF(IF (a.enddates IS NOT NULL, a.enddates, a.dates), '2021-04-01') >= 0
AND DATEDIFF(a.dates, '2021-04-30') <= 0
AND a.dates IS NOT NULL
AND c.id IN (2,3,4,5,9,10)
GROUP BY a.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range PRIMARY PRIMARY 4 NULL 6 100.00 Using where; Using index; Using temporary; filesort wurde genutzt 1 SIMPLE rel NULL ref category event relation,catid,itemid category event relation 4 usr_web689_1.c.id 20 100.00 Using where; Using index 1 SIMPLE a NULL eq_ref PRIMARY,idx_access,idx_pubstate PRIMARY 4 usr_web689_1.rel.itemid 1 5.00 Using index condition; Using where 1 SIMPLE u NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.created_by 1 100.00 Using where 1 SIMPLE l NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.a.locid 1 100.00 NULL 1 SIMPLE ct NULL ref iso2 iso2 8 usr_web689_1.l.country 1 100.00 NULL Status Duration starting 0.20 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.12 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.12 ms preparing 0.03 ms Creating tmp table 0.09 ms Sorting result 0.01 ms executing 0.00 ms Sending data 3.82 ms Creating sort index 0.04 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.04 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 14 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 13 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/components/com_jem/models/eventslist.php:483 12 JemModelEventslist->getItems() JROOT/modules/mod_jem_cal/helper.php:154 11 ModJemCalHelper::getDays() JROOT/modules/mod_jem_cal/mod_jem_cal.php:152 10 include JROOT/modules/mod_jem_cal/mod_jem_cal.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 1.94 ms Nach letzter Abfrage: 7.92 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 24.063 MB Zeilen zurückgegeben: 384
SHOW TABLES
„EXPLAIN“ unmöglich für Abfrage: SHOW TABLESStatus Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.03 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms checking permissions 1.49 ms Sending data 0.15 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.01 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 17 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 16 JDatabaseDriverMysqli->getTableList() JROOT/administrator/components/com_acymailing/compat/joomla.php:552 15 acymailing_getTableList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:18 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:523 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:25 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.25 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 24.110 MB Zeilen zurückgegeben: 182
SELECT *
FROM jos331_acymailing_configid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_config NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 182 100.00 NULL Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.11 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 16 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 15 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/cpanel.php:23 14 cpanelClass->load() JROOT/administrator/components/com_acymailing/helpers/helper.php:523 13 acymailing_config() JROOT/administrator/components/com_acymailing/compat/joomla.php:840 12 include_once JROOT/administrator/components/com_acymailing/compat/joomla.php JROOT/administrator/components/com_acymailing/helpers/helper.php:25 11 include_once JROOT/administrator/components/com_acymailing/helpers/helper.php JROOT/modules/mod_acymailing/mod_acymailing.php:13 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.25 ms Nach letzter Abfrage: 5.72 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 24.549 MB Zeilen zurückgegeben: 1
SELECT *
FROM jos331_acymailing_list
WHERE type = 'list'
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_list NULL system typeorderingindex,typeuseridindex ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/list.php:30 11 listClass->getLists() JROOT/modules/mod_acymailing/mod_acymailing.php:149 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.32 ms Nach letzter Abfrage: 24.78 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 26.966 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields` as a
WHERE a.`published` = 1
AND (a.access = 'all' OR a.access LIKE ('%,9,%'))
ORDER BY a.`ordering` ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref orderingindex orderingindex 1 const 2 55.56 Using index condition; Using where Status Duration starting 0.05 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.03 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.04 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.05 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/fields.php:85 11 fieldsClass->getFields() JROOT/modules/mod_acymailing/mod_acymailing.php:245 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 26.979 MB Zeilen zurückgegeben: 3
SELECT *
FROM `jos331_acymailing_fields`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_acymailing_fields NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 3 100.00 NULL Status Duration starting 0.01 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_acymailing/compat/joomla.php:478 12 acymailing_loadObjectList() JROOT/administrator/components/com_acymailing/classes/fields.php:100 11 fieldsClass->getFields() JROOT/modules/mod_acymailing/mod_acymailing.php:245 10 include JROOT/modules/mod_acymailing/mod_acymailing.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.37 ms Nach letzter Abfrage: 3.74 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 27.144 MB Zeilen zurückgegeben: 71
SELECT c.id AS CID
FROM jos331_categories AS c
LEFT JOIN jos331_content AS content
ON c.id = content.catid
WHERE ( c.id = 521 OR c.id = 516 OR c.id = 522 OR c.id = 517 OR c.id = 524 OR c.id = 519 )
AND c.extension = 'com_content'
AND c.published = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE c NULL range PRIMARY,cat_idx PRIMARY 4 NULL 6 43.27 Using where 1 SIMPLE content NULL ref idx_catid idx_catid 4 usr_web689_1.c.id 99 100.00 Using where; Using index Status Duration starting 0.06 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.06 ms preparing 0.02 ms executing 0.00 ms Sending data 0.08 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 13 JDatabaseDriver->loadObjectList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:64 12 NH_GK5_Joomla_Source::getSources() JROOT/modules/mod_highlighter_gk5/helper.php:91 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.74 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 27.153 MB Zeilen zurückgegeben: 20
SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM jos331_content AS content
WHERE content.state = 1
AND content.access IN (1,1,5)
AND ( content.publish_up = '0000-00-00 00:00:00' OR content.publish_up <= '2024-08-25 06:19:21' )
AND ( content.publish_down = '0000-00-00 00:00:00' OR content.publish_down >= '2024-08-25 06:19:21' )
AND ( content.catid = 517 OR content.catid = 522 )
ORDER BY content.created DESC
LIMIT 0,20;id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range idx_access,idx_state,idx_catid idx_catid 4 NULL 71 16.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.08 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.44 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:189 12 NH_GK5_Joomla_Source::getArticles() JROOT/modules/mod_highlighter_gk5/helper.php:93 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.57 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 27.189 MB Zeilen zurückgegeben: 20
SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM jos331_content AS content
LEFT JOIN jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN jos331_users AS users
ON users.id = content.created_by
LEFT JOIN jos331_content_rating AS content_rating
ON content_rating.content_id = content.id
WHERE content.id = 60464 OR content.id = 60448 OR content.id = 60447 OR content.id = 60439 OR content.id = 60431 OR content.id = 60374 OR content.id = 60307 OR content.id = 60275 OR content.id = 59763 OR content.id = 59755 OR content.id = 59725 OR content.id = 59722 OR content.id = 59680 OR content.id = 59668 OR content.id = 59657 OR content.id = 59650 OR content.id = 59638 OR content.id = 59614 OR content.id = 59603 OR content.id = 59599
ORDER BY content.created DESCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE content NULL range PRIMARY PRIMARY 4 NULL 20 100.00 Using where; filesort wurde genutzt 1 SIMPLE categories NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.catid 1 100.00 Using where 1 SIMPLE users NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.created_by 1 100.00 Using where 1 SIMPLE content_rating NULL eq_ref PRIMARY PRIMARY 4 usr_web689_1.content.id 1 100.00 Using where Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.04 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.05 ms preparing 0.02 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.24 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 13 JDatabaseDriver->loadAssocList() JROOT/modules/mod_highlighter_gk5/gk_classes/gk.source.joomla.php:238 12 NH_GK5_Joomla_Source::getArticles() JROOT/modules/mod_highlighter_gk5/helper.php:93 11 NH_GK5_Helper->getDatas() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:21 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.49 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 27.220 MB Zeilen zurückgegeben: 3
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 `jos331_categories` AS `s`
INNER JOIN `jos331_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,5)
AND c.published = 1
AND s.id = 522
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 filesort wurde genutzt 1 SIMPLE c NULL ALL cat_idx,idx_access,idx_left_right ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 104 26.63 Using where Status Duration starting 0.08 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.10 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.14 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.02 ms cleaning up 0.00 ms # 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() Der selbe 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/modules/mod_highlighter_gk5/helper.php:152 11 NH_GK5_Helper->renderLayout() JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php:22 10 include JROOT/modules/mod_highlighter_gk5/mod_highlighter_gk5.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.51 ms Nach letzter Abfrage: 9.78 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 27.653 MB Zeilen zurückgegeben: 1
SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp
WHERE sp.published = '1'
AND sp.id = '1'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sp NULL system PRIMARY ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 NULL Status Duration starting 0.14 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.07 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.01 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 14 JDatabaseDriver->loadAssoc() JROOT/components/com_creativeimageslider/helpers/helper.php:174 13 CreativeimagesliderHelper->get_slider_data() JROOT/components/com_creativeimageslider/helpers/helper.php:236 12 CreativeimagesliderHelper->render_slider() JROOT/components/com_creativeimageslider/helpers/helper.php:608 11 CreativeimagesliderHelper->render_html() JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 10 include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 27.669 MB Zeilen zurückgegeben: 13
SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa
WHERE sa.published = '1'
AND sa.id_slider = '1'
ORDER BY sa.ordering,sa.idid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE sa NULL ref id_slider id_slider 4 const 14 10.00 Using index condition; Using where; filesort wurde genutzt Status Duration starting 0.06 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.02 ms Creating sort index 0.15 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 15 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 14 JDatabaseDriver->loadAssocList() JROOT/components/com_creativeimageslider/helpers/helper.php:221 13 CreativeimagesliderHelper->get_slider_items() JROOT/components/com_creativeimageslider/helpers/helper.php:239 12 CreativeimagesliderHelper->render_slider() JROOT/components/com_creativeimageslider/helpers/helper.php:608 11 CreativeimagesliderHelper->render_html() JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php:30 10 include JROOT/modules/mod_creativeimageslider/mod_creativeimageslider.php JROOT/libraries/src/Helper/ModuleHelper.php:200 9 Joomla\CMS\Helper\ModuleHelper::renderModule() JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 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:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.14 ms Nach letzter Abfrage: 1.90 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 27.784 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #62
SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 309723485 & maskid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_cleantalk_sfw NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 16 JDatabaseDriverMysqli->execute() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:41 15 CleantalkSFW->unversal_query() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:88 14 CleantalkSFW->check_ip() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 13 plgSystemAntispambycleantalk->sfw_check() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 12 plgSystemAntispambycleantalk->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.03 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 27.791 MB Zeilen zurückgegeben: 1Doppelte Abfragen: #61
SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`
WHERE network = 309723485 & maskid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_cleantalk_sfw NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 13 10.00 Using where Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 17 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1465 16 JDatabaseDriver->loadAssoc() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:49 15 CleantalkSFW->unversal_fetch() JROOT/plugins/system/antispambycleantalk/classes/CleantalkSFW.php:89 14 CleantalkSFW->check_ip() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:2045 13 plgSystemAntispambycleantalk->sfw_check() JROOT/plugins/system/antispambycleantalk/antispambycleantalk.php:749 12 plgSystemAntispambycleantalk->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.22 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 27.792 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_metainfo
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/training/goal-sets-und-cruise-intervals'
AND `published` = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_metainfo NULL ALL published ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 40 10.00 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.03 ms preparing 0.01 ms executing 0.00 ms Sending data 0.09 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:426 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 27.798 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_canonicals
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/training/goal-sets-und-cruise-intervals'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_canonicals NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.01 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.00 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:504 12 plgSystemJMap->onBeforeCompileHead() JROOT/libraries/joomla/event/event.php:70 11 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 10 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 9 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:67 8 Joomla\CMS\Document\Renderer\Html\HeadRenderer->fetchHead() JROOT/libraries/src/Document/Renderer/Html/HeadRenderer.php:38 7 Joomla\CMS\Document\Renderer\Html\HeadRenderer->render() JROOT/libraries/src/Document/HtmlDocument.php:511 6 Joomla\CMS\Document\HtmlDocument->getBuffer() JROOT/libraries/src/Document/HtmlDocument.php:803 5 Joomla\CMS\Document\HtmlDocument->_renderTemplate() JROOT/libraries/src/Document/HtmlDocument.php:577 4 Joomla\CMS\Document\HtmlDocument->render() JROOT/libraries/src/Application/CMSApplication.php:1112 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 - Abfragezeit: 0.30 ms Nach letzter Abfrage: 16.13 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 29.710 MB Zeilen zurückgegeben: 1
SELECT a.id, a.alias, a.attribs, a.catid, c.alias AS category_alias
FROM jos331_content AS a
LEFT JOIN jos331_categories AS c
on c.id = a.catid
WHERE a.id = 240
LIMIT 0, 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL Status Duration starting 0.05 ms checking permissions 0.01 ms checking permissions 0.01 ms Opening tables 0.02 ms init 0.02 ms System lock 0.02 ms optimizing 0.01 ms statistics 0.07 ms preparing 0.01 ms executing 0.00 ms Sending data 0.01 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/phocapdf/phocapdf.php:62 7 plgSystemPhocaPDF->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:1118 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 - Abfragezeit: 0.20 ms Nach letzter Abfrage: 7.22 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 29.945 MB Zeilen zurückgegeben: 0
SELECT *
FROM jos331_jmap_headings
WHERE `linkurl` = 'https://gsv-schwimmen.de/ratgeber/training/goal-sets-und-cruise-intervals'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE jos331_jmap_headings NULL ALL NULL ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN NULL NULL 1 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms executing 0.00 ms Sending data 0.02 ms end 0.01 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # Aufrufer Datei und Zeilennummer 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 8 JDatabaseDriver->loadObject() JROOT/plugins/system/jmap/jmap.php:813 7 plgSystemJMap->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:1118 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
48 verwendete Abfragetypen, sortiert nach Häufigkeit ihrer Ausführung
SELECT-Tabellen:
7 × SELECT c.id
FROM jos331_content AS c6 × SELECT *
FROM jos331_assets3 × 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 `jos331_categories` AS `s`
INNER JOIN `jos331_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)2 × SELECT a.*
FROM jos331_gsd a2 × SELECT id, ipaddress
from jos331_bfstop_allowlist2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `jos331_assets`2 × SELECT id, ipaddress, crdate, duration
FROM jos331_bfstop_bannedip b2 × SELECT COUNT(network) AS cnt
FROM `jos331_cleantalk_sfw`1 × SELECT sa.id img_id, sa.name img_name, sa.img_name img_path, sa.img_url img_url_path ,sa.caption ,sa.showarrows item_showarrows, sa.showreadmore item_showreadmore, sa.readmoretext item_readmoretext, sa.readmorestyle item_readmorestyle, sa.readmoresize item_readmoresize, sa.readmoreicon item_readmoreicon, sa.readmorealign item_readmorealign, sa.readmoremargin item_readmoremargin, sa.captionalign item_captionalign, sa.captionmargin item_captionmargin, sa.overlaycolor item_overlaycolor, sa.overlayopacity item_overlayopacity, sa.textcolor item_textcolor, sa.overlayfontsize item_overlayfontsize, sa.textshadowcolor item_textshadowcolor, sa.textshadowsize item_textshadowsize, sa.overlayusedefault, sa.buttonusedefault, sa.redirect_url, sa.redirect_itemid, sa.redirect_target, sa.popup_img_name, sa.popup_img_url, sa.popup_open_event item_popup_open_event
FROM `jos331_cis_images` sa1 × SELECT sp.id slider_id, sp.id_template, sp.width, sp.height, sp.itemsoffset, sp.margintop, sp.marginbottom, sp.paddingtop, sp.paddingbottom, sp.showarrows, sp.bgcolor, sp.showreadmore, sp.readmoretext, sp.readmorestyle, sp.readmoresize, sp.readmoreicon, sp.readmorealign, sp.readmoremargin, sp.captionalign, sp.captionmargin, sp.overlaycolor, sp.overlayopacity, sp.textcolor, sp.overlayfontsize, sp.textshadowcolor, sp.textshadowsize, sp.arrow_template, sp.arrow_width, sp.arrow_left_offset, sp.arrow_center_offset, sp.arrow_passive_opacity, sp.move_step, sp.move_time, sp.move_ease, sp.autoplay, sp.autoplay_start_timeout, sp.autoplay_hover_timeout, sp.autoplay_step_timeout, sp.autoplay_evenly_speed, sp.overlayanimationtype, sp.popup_max_size, sp.popup_item_min_width, sp.popup_use_back_img, sp.popup_arrow_passive_opacity, sp.popup_arrow_left_offset, sp.popup_arrow_min_height, sp.popup_arrow_max_height, sp.popup_showarrows, sp.popup_image_order_opacity, sp.popup_image_order_top_offset, sp.popup_show_orderdata, sp.popup_icons_opacity, sp.popup_show_icons, sp.popup_autoplay_default, sp.popup_closeonend, sp.popup_autoplay_time, sp.popup_open_event, sp.link_open_event, sp.cis_touch_enabled, sp.cis_inf_scroll_enabled, sp.cis_mouse_scroll_enabled, sp.cis_item_correction_enabled, sp.cis_animation_type, sp.cis_item_hover_effect, sp.cis_items_appearance_effect, sp.cis_overlay_type, sp.cis_touch_type, sp.cis_font_family, sp.cis_font_effect, sp.icons_size, sp.icons_margin, sp.icons_offset, sp.icons_animation, sp.icons_color, sp.icons_valign, sp.cis_button_font_family, sp.ov_items_offset, sp.ov_items_m_offset, sp.custom_css, sp.custom_js,sp.slider_full_size
FROM `jos331_cis_sliders` sp1 × SELECT content.id AS iid, content.access AS access, categories.title AS catname, users.email AS author_email, content.created_by_alias AS author_alias, content_rating.rating_sum AS rating_sum, content_rating.rating_count AS rating_count,
CASE WHEN CHAR_LENGTH(content.alias) THEN CONCAT_WS(":", content.id, content.alias) ELSE content.id END as id,
CASE WHEN CHAR_LENGTH(categories.alias) THEN CONCAT_WS(":", categories.id, categories.alias) ELSE categories.id END as cid
FROM jos331_content AS content
LEFT JOIN jos331_categories AS categories
ON categories.id = content.catid
LEFT JOIN jos331_users AS users
ON users.id = content.created_by
LEFT JOIN jos331_content_rating AS content_rating
ON content_rating.content_id = content.id1 × SELECT `keyname`,`value`
FROM jos331_jem_confi1 × SELECT content.id AS iid, content.title AS title, content.introtext AS text, content.created AS date, content.publish_up AS date_publish, content.hits AS hits, content.language AS language, content.featured AS frontpage
FROM jos331_content AS content1 × SELECT *
FROM jos331_jmap_metainfo1 × SELECT c.id AS CID
FROM jos331_categories AS c
LEFT JOIN jos331_content AS content
ON c.id = content.catid1 × SELECT *
FROM `jos331_acymailing_fields1 × SELECT *
FROM `jos331_acymailing_fields` as a1 × SELECT *
FROM jos331_jmap_canonicals1 × SELECT a.id, a.alias, a.attribs, a.catid, c.alias AS category_alias
FROM jos331_content AS a
LEFT JOIN jos331_categories AS c
on c.id = a.catid1 × SELECT *
FROM jos331_acymailing_list1 × SELECT *
FROM jos331_acymailing_confi1 × SELECT a.access,a.alias,a.attribs,a.checked_out,a.checked_out_time,a.contactid,a.created,a.created_by,a.created_by_alias,a.custom1,a.custom2,a.custom3,a.custom4,a.custom5,a.custom6,a.custom7,a.custom8,a.custom9,a.custom10,a.dates,a.datimage,a.enddates,a.endtimes,a.featured,a.fulltext,a.hits,a.id,a.introtext,a.language,a.locid,a.maxplaces,a.metadata,a.meta_keywords,a.meta_description,a.modified,a.modified_by,a.published,a.registra,a.times,a.title,a.unregistra,a.waitinglist,DAYOFMONTH(a.dates) AS created_day, YEAR(a.dates) AS created_year, MONTH(a.dates) AS created_month,a.recurrence_byday,a.recurrence_counter,a.recurrence_first_id,a.recurrence_limit,a.recurrence_limit_date,a.recurrence_number, a.recurrence_type,a.version,u.name AS author,l.alias AS l_alias,l.checked_out AS l_checked_out,l.checked_out_time AS l_checked_out_time,l.city,l.country,l.created AS l_created,l.created_by AS l_createdby,l.custom1 AS l_custom1,l.custom2 AS l_custom2,l.custom3 AS l_custom3,l.custom4 AS l_custom4,l.custom5 AS l_custom5,l.custom6 AS l_custom6,l.custom7 AS l_custom7,l.custom8 AS l_custom8,l.custom9 AS l_custom9,l.custom10 AS l_custom10,l.id AS l_id,l.latitude,l.locdescription,l.locimage,l.longitude,l.map,l.meta_description AS l_meta_description,l.meta_keywords AS l_meta_keywords,l.modified AS l_modified,l.modified_by AS l_modified_by,l.postalCode,l.publish_up AS l_publish_up,l.publish_down AS l_publish_down,l.published AS l_published,l.state,l.street,l.url,l.venue,l.version AS l_version,ct.name AS countryname,
CASE WHEN CHAR_LENGTH(a.alias) != 0 THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug,
CASE WHEN CHAR_LENGTH(l.alias) != 0 THEN CONCAT_WS(':', a.locid, l.alias) ELSE a.locid END as venueslug
FROM jos331_jem_events as a
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_jem_venues AS l
ON l.id = a.locid
LEFT JOIN jos331_jem_countries AS ct
ON ct.iso2 = l.country
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.itemid = a.id
LEFT JOIN jos331_jem_categories AS c
ON c.id = rel.catid1 × SELECT DISTINCT c.id,c.catname,c.access,c.checked_out AS cchecked_out,c.color,
CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug,a.id AS multi
FROM jos331_jem_categories as c
LEFT JOIN jos331_jem_cats_event_relations AS rel
ON rel.catid = c.id
LEFT JOIN jos331_jem_events AS a
ON a.id = rel.itemid1 × SELECT `data`
FROM `jos331_session`1 × SELECT *
FROM `jos331_users`1 × select email
from jos331_users1 × SELECT b.id
FROM jos331_usergroups AS a
LEFT JOIN jos331_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt1 × SELECT *
FROM jos331_gsd_config1 × SELECT *
FROM `jos331_redirect_links`1 × select version, dir_online, value
from `jos331_jvld_settings`1 × select id
from jos331_menu1 × select sparams
from `jos331_jvld_styles`1 × select id, title, alias
from jos331_jumi1 × 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 jos331_fields AS a
LEFT JOIN `jos331_languages` AS l
ON l.lang_code = a.language
LEFT JOIN jos331_users AS uc
ON uc.id=a.checked_out
LEFT JOIN jos331_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN jos331_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN jos331_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `jos331_fields_categories` AS fc
ON fc.field_id = a.id1 × SELECT `id`
FROM `jos331_content`1 × SELECT s.*
FROM jos331_template_styles as s1 × SELECT `id`, `name`,`alias`, `use_feedburner`, `uri`, `feed_type`
FROM `jos331_obrss`1 × SELECT a.id,a.params
FROM jos331_users AS a1 × SELECT id, rules
FROM `jos331_viewlevels1 × 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 jos331_content AS a
INNER JOIN jos331_categories AS c
on c.id = a.catid
LEFT JOIN jos331_users AS u
on u.id = a.created_by
LEFT JOIN jos331_categories as parent
ON parent.id = c.parent_id
LEFT JOIN jos331_content_rating AS v
ON a.id = v.content_id1 × SELECT *
FROM jos331_jmap_headings
Andere Tabellen:
1 × SHOW FULL COLUMNS
FROM `jos331_gsd_config1 × UPDATE `jos331_extensions`
SET `params` = '{\"mediaversion\":\"6f4e25ac2e67e22c6dee5cc6140420ac\"}'1 × SHOW FULL COLUMNS
FROM `jos331_assets1 × SHOW FULL COLUMNS
FROM `jos331_content1 × UPDATE jos331_content
SET `hits` = (`hits` + 1)1 × SHOW FULL COLUMNS
FROM `jos331_users1 × SHOW TABLE