Deprecated: Non-static method modSpearheadFacebookLikeHelper::getFacebookLike() should not be called statically in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/mod_spearheadfacebooklike.php on line 23

Deprecated: Non-static method modSpearheadFacebookLikeHelper::autoDiscovery() should not be called statically in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/helper.php on line 52

Notice: Only variables should be assigned by reference in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/helper.php on line 179

Notice: Only variables should be assigned by reference in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/helper.php on line 92

Notice: Only variables should be assigned by reference in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/helper.php on line 95

Notice: Undefined variable: appID in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/helper.php on line 109

Deprecated: Non-static method modSpearheadFacebookLikeHelper::getStyle() should not be called statically in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/mod_spearheadfacebooklike.php on line 24

Deprecated: Non-static method modSpearheadFacebookLikeHelper::copyRight() should not be called statically in /home/shared/WEB/hatsche/html/joomla_365/modules/mod_spearheadfacebooklike/mod_spearheadfacebooklike.php on line 25

LINKS PHILIPPINEN

BILDER PHILIPPINEN

Philippinen 2004

19. Januar 2004: Gulf-Air oder "wie tanke ich ein Flugzeug voll?"

Wegen des starken Schneefalls und der schlechten Sicht verzögerte sich der Abflug des Airbus A340 von Frankfurt nach Bahreain mit Gulf Air schon um ca. 30 Minuten. Als der Flieger dann endlich an der 3. Startposition angkam wurde der von der Flugsicherheitsbehörde rausgewunken. Der Kapitän teilte über Bordfunk mit, dass er sich beim Auftanken der Maschine verkalkuliert hat und zu wenig Sprit an Bord hat (kaum zu glauben). Also ab zur nächsten Tankstelle. Danach konnte er sich natürlich wieder hinten anstellen. Bis der dann endlich abgehoben hat sassen wir Passagiere schon gute vier Stunden im Flugzeug. Damit war natürlich der Anschlussflug von Bahrain über Abu Dhabi nach Manila weg. Die Gulf Air hat deshalb im Gegenzug einen Ersatzflug am nächsten Tag angeboten und uns auf deren Kosten in einem Hotel in Bahrain untergebracht. So wird es wohl morgen anstatt Sightseeing in Manila ein Sightseeing in Bahrain geben.

Philippinen 2004 Bilder

20. Januar 2004 - Bahrain

Habe im Flugzeug Günther aus Neustadt getroffen. Der will auch nach Manila und sitzt wegen des Tankmissgeschicks hier in Bahrain fest. Wir verbringen den Tag damit uns die Stadt anzusehen. Die gibt jedoch nicht viel her. Ausgenommen die grossen Einkaufszentren wo man echt günstig Markenklamotten einkaufen kann. So gesehen wäre es besser wir hätten des Stop hier bei der Rückreise.

Alle Bilder Landkarte Philippinen Links zu den Philippinen Diashow

21. Januar 2004 - Ankunft in Manila

Nach weiteren 9 Stunden Flug kommen wir endlich in Manila an. Ich habe ausnahmsweise mal Glück denn Günther wird von seinem Arbeitskollegen Thomas vom Flughafen abgeholt. Der ist gerade hier um sich mit einer Filipina zu verheiraten. Günthers Bruder Hermann ist derzeut auch auf den Philippinen. Er macht hier "Langzeiturlaub" und ist grade in Angeles einer Stadt nördlich von Manila. Ich schliesse mich Günther an und wir nehmen einen Bus nach Angeles um Hermann zu besuchen.

Philippinen 2004 Bilder

22. Januar 2004 - Angeles

Angeles ist eine Kleinstadt neben der ehemaligen Militärbasis der Amis. Hier waren bis vor 12 Jahren ca. 70000 GI's stationiert. Nach dem Ausbruch des Mount Pinatubos 1991 haben die Amis die Basis jedoch geschlossen. Alles was noch übrig ist sind einige Kneipen, Bars und Nachtclubs. Hatte heute früh einen kleinen 'Hangover' da wir gestern mit Hermann etwas gefeiert haben.

Philippinen 2004 Bilder

23. Januar 2004 - Subic

Nach 3 schlaflosen Nächten, vielen Partys und nicht wenig Bier wird es Zeit mal aus Angeles herauszukommen und das Meer zu sehen. Immerhin bestehen die Philippinen aus mehr als 7000 Inseln. Zu acht haben wir einen Van gemietet und sind ins nahe gelegene 'Subic' an der Westküste der Hauptinsel Luzon gefahren. Dabei waren ausser Grünther, Hermann mit Freundin die Aussies Don, David und Steven mit Freundin/Sohn. Bin nachmittags mit Grünther mittels Jeepney nach Olongapo auf den Markt gefahren. Hier kann man günstig Klamotten Musik-CD's und DVD's kaufen.

Philippinen 2004 Bilder

24. Januar 2004 - zurück nach Angeles

Gegen Mittag fahren wir wieder mit dem Van zurück nach Angeles und packen unsere sieben Sachen. Denn Hermann hat für den nächsten Tag einen Flug nach Palawan (West-Philippinen) gebucht wo wir wohl die nächsten Tage verbringen werden.

Philippinen 2004 Bilder

25. Januar 2004 - auf nach Palawan

Viel Zeit zum Feiern meines Geburtstages bleibt nicht, denn um 2 Uhr in der Früh fährt der Bus nach Manila ab und um 6 Uhr geht der Flieger nach Busuanga Island. Deshalb haben wir für heute Nacht kein Hotel gebucht und stattdessen ein paar Biere in diversen Bars zu uns genommen. Busuanga ist eine ca. 50 km grosse Insel im Norden Palawans. Vom kleinen Flugplatz der im Norden der Insel mitten im Niemandsland liegt bis yur Hauptstadt 'Coron' ist es ca. 1 Std. mit dem Jeep über Schotterpisten und diversen Flussüberquerungen. Hermann kommt öfters hierher da er sich hier ein Haus bauen will. Da er als Ausländer kein Stück Land auf den Philippinen kaufen darf, hat er halt ein Stück Wasser in Ufernähe gekauft und dort schon die ersten Pfeiler für sein Haus betoniert. Mit seinem Nachbarn, Terry, einem Engländer und dessen philippinischer Familie unternehmen wir einen Ausflug zu heissen, vulkanischen Quellen in denen man baden kann.

Philippinen 2004 Bilder

26. Januar 2004 - Bootsausflug

Haben uns heute ein Boot für 800 Pesos gemietet (das sind ca. 12 Euro) und sind um einige Inseln "geschippert". Mittags machten wir dann Rast an einem kleinen, unberührten Strand der nur vom Meer aus zugänglich ist und den mitgebrachten Fisch gegrillt. Man kann hier wunderbar schnorcheln und Fischen. Gefangen haben wir jedoch nur ein paar kleine Fische. Abends sind wir nochmals an den heissen Vulkan-Quellen vorbeigefahren, haben uns ins 40 Grad heisse Wasser gesetzt und mit ein paar Bierchen den Tag ausklingen lassen.

Philippinen 2004 Bilder

27. Januar 2004 - Tauchen mit 'Sea Dive'

Heute bin ich mit 'Sea Dive' zum Tauchen rausgefahren. In der Bucht von Coron (Busuanga Island) liegt eine ganze japanische Flotte aus dem 2. Weltkrieg auf dem Meeresgrund. Der erste Tauchgang führte uns zur 'Akitsushima', einem Flugzeugträger für Wasserflugzeuge. Den haben die Amis am 24. September 1944 versenkt. Er ist ca. 150 m lang und liegt in 30 m Tiefe. Wir sind vorne ins Innere des Rumpfes reingetaucht und hinten wieder raus. Auf dem Deck kann man noch gut die Kanonen erkennen und den grossen Schwenkkranen mit dem die Flugzeuge zu Wasser gelassen wurden. Beim zweiten Tauchgang gings zur 'Taei Maru', einem 200 m langen Öltanker. Reingetaucht sind wir am Heck des Schiffes durch die schmale Öffnung wo mal die Schiffsschraube war. Da war's mir nicht so sehr wohl denn ich bin 3 mal steckengeblieben. Ausserdem hat man fast nichts gesehen und meine Taschenlampe war relativ schwach. Aber das Tauchen hier ist so günstig wie nirgendwo anders. Ein Tauchgang kostet nur ca. 11 Euro.

Muss noch einen Nachtrag loswerden. Gestern abend sass ich bei einem Ami der hier eine Kneipe hat. Der hat mir gezeigt was man hier so als Delikatesse verspeist: BALLOT - das sind Enteneier; Das besondere daran ist, dass die Eier fas vollständig ausgebrütet sind. Man klopft das Ei an der Stirnseite auf und saugt die Flüssigkeit heraus. Dann wird es halb geschält, das Entenküken mit Salz bestreut und in einem Happen gegessen !?! Er sagte mir vier von fünf die es mal probiert haben bleiben dabei - habe es erst gar nicht probiert. Lustig an diesem Abend war auch ein heftiger Streit der vor der Kneipe ausgebrochen war zwischen den Nachbarseheleuten. ER wollte wohl unbedingt noch ein Bierchen trinken und SIE wollte es verhindern. Als Ergebnis der lautstarken Diskussion auf der Strasse hat ER doch ein Bier getrunken. Etwas später kamen dann Opa und Oma beide im Nachthemd und mit Krückstock bewaffnet in die Kneipe um IHN zur Vernunft zu bringen - was natürlich nicht gelang.

Philippinen 2004 Bilder

28. Januar 2004 - nochmals Tauchen mit 'Sea Dive'

Bin heute nochmals mit 'Sea Dive' zum Tauchen rausgefahren. Wir hatten eigentlich zwei spezielle Tauchgänge geplant. Der erste sollte uns zu 'Gunthers Kathedrale', eine grosse Unterwasserhöhle führen in der man innen auftauchen kann. Die liegt jedoch nicht in der Bucht von Coron sondern am offenen Meer wo der Seegang und der Wind recht stark waren sodass ein Reintauchen zu gefährlich gewesen wäre. Als Ersatz sind wir dann ein weiteres Wrack angefahren - hier liegen ja genug herum. Es handelte sich um einen philippinischen Frachter, der vor ca. 30 Jahren gesunken ist. Beim zweiten Tauchgang mussten wir mitsamt der Ausrüstung an Land schwimmen und über einige Klippen zu einem Vulkansee klettern. Da war höchste Konzentration gefordert. Die Sicht in dem See war nicht so toll. Das besondere daran ist jedoch, dass der See aus abwechselnden Süss- und Salzwasserschichten besteht und das Wasser wegen des vulkanischen Ursprungs verschieden temperiert ist (25 - 40 Grad).

Philippinen 2004 Bilder

"Jeepneys"

Jeepneys entstehen wenn man einen Militär-Jeep der Amis mit einem Bus kreuzt. Sie sind das Haupttransportmittel für Personen und Lasten auf den Philippinen. Man steigt hinten ein und auch wieder aus. Hinten links und rechts befindet sich je eine lange Sitzbank auf der man Platz nehmen kann. Reicht dieser nicht aus kann man selbstverständlich auch auf das Dach steigen oder auf der hinteren Platform 'surfen'. Eine Fahrt kostet je nach Entfernung zwischen vier und zehn Peso (ca. 10 Cent).

Philippinen 2004 Bilder

31. Januar 2004 - wieder mal in Angeles

Nach knapp einer Woche Palawan sind wir wieder zurück in Angeles. Habe dort einen Teil meines Gepäcks deponiert. Am Sonntag oder Montag werde ich wohl Richtung Puorto Galera auf die Insel Mindoro weiterziehen. Bis dahin gehen wir nochmals Hermanns Lieblingsbeschäftigung nach: "Barhopping".

Philippinen 2004 Bilder

2. Februar 2004 - Stopover in Manila

Bin heute zum ersten Mal in Manila abgestiegen. Aber nur für eine Nacht. Denn morgen geht's weiter mit dem Bus bzw. der Fähre nach Puerto Galera auf der Nachbarinsel 'Mindoro'. In der Nähe von Puerto Galera gibt's einige Strände an denen man gut Baden und Tauchen kann. In Manila gibt's eigentlich nicht besonderes zu sehen. Die Stadt ist ein einziger 'Moloch' - viel Dreck und noch mehr Abgase von dem stetigen Verkehr. Werde ab sofort wieder alleine reisen denn Günther hat die Rückreise nach Deutschland angetreten.

Philippinen 2004 Bilder

3. Februar 2004 - Ankuft auf der Insel 'Mindoro'

Bin heute mit 'Swagman Travel' von Manila nach Batangas, einer Hafenstadt im Süden der Hauptinsel Luzon, gefahren und von dort aus mit einem Katamaran nach Puerto Galera. In Puerto Galera selbst ist nicht sehr viel los. Der grösste Touristenstrand ist im 6 km entfernten 'Sabang'. Von Puerto Galera ist das ein holpriger Ritt über teils unbefestigte Strassen mit dem Tricycle, eine Art Motorrad mit Seitenwagen. Bin bei 'Captain Jack' abgestiegen. Gleich am ersten Abend habe ich wieder Stefan aus der Schweiz getroffen der vorige Woche in Palawan auf demselben Tauchboot war. Bin eigentlich hierhergekommen um mal wieder etwas Ruhe zu geniessen. Damit wird's wohl wieder nichts, nachdem es hier in diesem verschlafenen Nest einige Kneipen mit Pool-Billard, Discos und sogar Nachtclubs gibt. Irgendwo ist immer was los rund um die Uhr.

Philippinen 2004 Bilder

4. Februar 2004 - Sabang Inn Dive Resort

Nachdem es hier sehr viele gute Tauchplätze gibt dia alle direkt vor Sabang liegen war ich heute mit 'Sabang Inn Dive Resort' zwei mal unten. Habe endlich mal ein Seepferdchen gesehen. Günther aus Freiburg schmeisst den Laden hier mit seinem Kollegen Ralf. Das Tauchen hier ist recht easy da die Tauchplätze alle um die Ecke sind. Selbst am Strand vor dem Hotel gibt's schöne Korallen. Sabang Inn Dive Resort

Philippinen 2004 Bilder

5. Februar 2004 - Sinandigan-Lodge

Bin heute nur 1 mal um die Mittagszeit zum Tauchen rausgefahren. Ziel war "Shark Cave", eine Unterwasserhöhle in der man meist Haie antrifft. Tatsächlich haben wir auch zwei kleine und einen grösseren Weisspitzenriffhai (White Tip) gesehen. Die sind jedoch nur faul in der Höhle rumgelegen. Auf der Rückfahrt haben wir einen an der Wasseroberfläche schwimmenden Schwarzspitzenriffhai (Black Tip) gesehen, besser gesagt nur die schwarze Rückenflosse. Abends waren wir mit der Tauchschule in der Sinandigan-Lodge etwas ausserhalb von Sabang. Hier gibt es sehr gute deutsche Küche. Habe mir nach 14 Tagen Reis mal wieder ein Rinderfilet mit Bratkartoffeln und Salat gegönnt. Man war das gut. Nach dem Essen hat der Wirt Freddy, ein Deutscher, noch zwei Flaschen selbstgebrannten Orangenschnaps spendiert - das war weniger gut. Glücklicherweise habe ich immer Aspirin dabei.

Philippinen 2004 Bilder

6. Februar 2004 - BBQ

Die beiden heutigen Tauchgänge waren weniger spektakulär. Erwähnenswert nur die vielen Jellyfish (Feuerquallen) die mich an den Armen und Beinen gestreift haben und sich zu allem Überfluss auch noch in meiner Tarierweste (BCD) verfingen. Nachmittags hatten wir die Mädels von der Tauchschule auf den Markt geschickt um Essen einzukaufen denn am Abend war BBQ Party angesagt.

Philippinen 2004 Bilder

7. Februar 2004 - Wieder mal Tauchen

Das Ausmass des "Jellyfish-Attacks" tags zuvor ist mit sofort nach dem Aufstehen klar. Ich sehe aus als ob ich in einen Haufen Brennnessel gefallen wäre. Tut zwar nicht weh, die Haut ist aber überall dort krebsrot und angeschwollen wo die mich erwischt haben. Habe trotzdem zwei weiter Tauchgänge unternommen: Vormittags Wracktauchen an der "Alma Jane", 30m tief und nachmittags an einem versenkten Trockendock (Dry Dock).

Philippinen 2004 Bilder

8. Februar 2004 - Abtauchen

Heute waren wieder zwei unspektakuläre Tauchgaenge angesagt.

Philippinen 2004 Bilder

10. Februar 2004 - Sabang-Trip

Bin heute nicht getaucht sondern habe mal die Halbinsel um Sabang abgelaufen. Brauche dringend wieder Bewegung.

Philippinen 2004 Bilder

13. Februar 2004 - Valentinstag in Angeles

Bin mittlerweile weg von Sabang und werde die letzten Tage nochmals in Angeles verbringen. Von dort ist es nicht weit nach Manila zum Flughafen. Denn die 4 Wochen Urlaub neigen sich leider dem Ende. Könnte locker noch die 6 Wochen von 2004 dranhängen. Habe morgen vor, mit Steve einen Rundflug um den Mount Pinatubo zu machen. Man kann hier in der ehemaligen US-Airbase kleinere Flieger mieten.

Philippinen 2004 Bilder

15. Februar 2004 - Rundflug um den Mount Pinatubo

Heute früh haben Steve und ich den Rundflug um den Mount Pinatubo gemacht. Beim Ausbruch des Pinatubos im Juni 1991 hat es die 300 m hohe Spitze des Vulkans abgesprengt und in der Gegend zerstreut. Zurückgeblieben ist ein riesiger Krater. Von Angeles ist der nur ca. 40 km entfernt. Tolles Erlebnis. Heute nachmittag fahre ich mit dem Bus nach Manila und morgen mittag sitze ich leider schon im Flieger nach Hause.

Philippinen 2004 Bilder

Joomla! Debug Console

Session

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

Profile Information

Time

Memory

Time: 0.02 ms / 0.02 ms Memory: 0.416 MB / 0.42 MB Application: afterLoad

Time: 378.18 ms / 378.20 ms Memory: 1.032 MB / 1.45 MB Application: afterInitialise

Time: 10.87 ms / 389.07 ms Memory: 1.985 MB / 3.43 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.79 ms / 389.86 ms Memory: 0.014 MB / 3.45 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.07 ms / 389.93 ms Memory: 0.000 MB / 3.44 MB Application: Start JAccess::getAssetRules Old (1)

Time: 0.69 ms / 390.62 ms Memory: 0.013 MB / 3.46 MB Application: Finish JAccess::getAssetRules Old (1)

Time: 0.10 ms / 390.72 ms Memory: 0.000 MB / 3.44 MB Application: afterRoute

Time: 2.08 ms / 392.80 ms Memory: 0.107 MB / 3.54 MB Application: beforeRenderComponent com_content

Time: 0.78 ms / 393.58 ms Memory: 0.048 MB / 3.59 MB Application: Start JAccess::preload(components)

Time: 2.66 ms / 396.24 ms Memory: 0.221 MB / 3.81 MB Application: Finish JAccess::preload(components)

Time: 21.26 ms / 417.50 ms Memory: 0.564 MB / 4.38 MB Application: afterRenderComponent com_content

Time: 1.97 ms / 419.47 ms Memory: 0.008 MB / 4.38 MB Application: afterDispatch

Time: 2.82 ms / 422.29 ms Memory: 0.066 MB / 4.45 MB Application: beforeRenderModule mod_custom (hatsches_reise_bilder)

Time: 2.82 ms / 425.10 ms Memory: 0.068 MB / 4.52 MB Application: afterRenderModule mod_custom (hatsches_reise_bilder)

Time: 0.09 ms / 425.19 ms Memory: 0.007 MB / 4.52 MB Application: beforeRenderModule mod_custom (reiselinks)

Time: 0.09 ms / 425.28 ms Memory: 0.003 MB / 4.53 MB Application: afterRenderModule mod_custom (reiselinks)

Time: 0.07 ms / 425.35 ms Memory: 0.001 MB / 4.53 MB Application: beforeRenderModule mod_spearheadfacebooklike (Spearhead Facebook Like Button.)

Time: 0.43 ms / 425.78 ms Memory: 0.018 MB / 4.55 MB Application: afterRenderModule mod_spearheadfacebooklike (Spearhead Facebook Like Button.)

Time: 0.12 ms / 425.90 ms Memory: 0.009 MB / 4.56 MB Application: beforeRenderModule mod_maximenuck (Maximenu CK)

Time: 52.06 ms / 477.96 ms Memory: 0.561 MB / 5.12 MB Application: afterRenderModule mod_maximenuck (Maximenu CK)

Time: 65.83 ms / 543.80 ms Memory: 0.237 MB / 5.35 MB Application: afterRender

Database queries total: 384.62 ms

Memory Usage

Database Queries

30 Queries Logged 384.62 ms

2 duplicate found!

2 duplicates: #15 #16

Query Time: 0.72 ms Query memory: 0.024 MB Memory before query: 0.761 MB Rows returned: 0

SELECT `data`

  FROM `hats_session`

  WHERE `session_id` = '3733305feee4d4a041a46c65aea1958d'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_session	const	PRIMARY	PRIMARY	602	const	1

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.02 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.04 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.14 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
13	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:44
12	JSessionStorageDatabase->read()	Same as call in the line below.
11	session_start()	JROOT/libraries/joomla/session/handler/native.php:259
10	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:49
9	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:81
8	JSessionHandlerJoomla->start()	JROOT/libraries/joomla/session/session.php:636
7	JSession->_start()	JROOT/libraries/joomla/session/session.php:596
6	JSession->start()	JROOT/libraries/cms/application/cms.php:773
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.62 ms After last query: 0.76 ms Query memory: 0.003 MB Memory before query: 0.779 MB

DELETE 

  FROM `hats_session`

  WHERE `time` < '1701767385'

Explain

EXPLAIN not possible on query: DELETE FROM `hats_session` WHERE `time` < '1701767385'

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.09 ms
updating	0.06 ms
end	0.02 ms
query end	0.03 ms
closing tables	0.01 ms
Unlocking tables	0.02 ms
freeing items	0.10 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:790
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.61 ms After last query: 0.21 ms Query memory: 0.021 MB Memory before query: 0.784 MB Rows returned: 0

SELECT `session_id`

  FROM `hats_session`

  WHERE `session_id` = '3733305feee4d4a041a46c65aea1958d' 
  LIMIT 1

Explain

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

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.10 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
7	JDatabaseDriver->loadResult()	JROOT/libraries/cms/application/cms.php:176
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 4.57 ms After last query: 0.23 ms Query memory: 0.003 MB Memory before query: 0.789 MB

INSERT INTO `hats_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES 
('3733305feee4d4a041a46c65aea1958d', 0, 1, '1701768285', 0, '')

Explain

EXPLAIN not possible on query: INSERT INTO `hats_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES ('3733305feee4d4a041a46c65aea1958d', 0, 1, '1701768285', 0, '')

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
update	0.11 ms
end	0.01 ms
query end	4.09 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/application/cms.php:212
6	JApplicationCms->checkSession()	JROOT/libraries/cms/application/cms.php:799
5	JApplicationCms->loadSession()	JROOT/libraries/cms/application/cms.php:131
4	JApplicationCms->__construct()	JROOT/libraries/cms/application/site.php:63
3	JApplicationSite->__construct()	JROOT/libraries/cms/application/cms.php:408
2	JApplicationCms::getInstance()	JROOT/libraries/joomla/factory.php:125
1	JFactory::getApplication()	JROOT/index.php:37

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.10 ms After last query: 0.73 ms Query memory: 0.028 MB Memory before query: 0.877 MB Rows returned: 36

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `hats_extensions`

  WHERE `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_extensions	ref	extension	extension	62	const	36	Using index condition

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.33 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.09 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
8	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
7	JCacheControllerCallback->get()	JROOT/libraries/cms/component/helper.php:448
6	JComponentHelper::load()	JROOT/libraries/cms/component/helper.php:43
5	JComponentHelper::getComponent()	JROOT/libraries/cms/component/helper.php:120
4	JComponentHelper::getParams()	JROOT/libraries/cms/application/site.php:589
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.67 ms After last query: 0.73 ms Query memory: 0.022 MB Memory before query: 0.904 MB Rows returned: 0

SELECT b.id

  FROM hats_usergroups AS a

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

  WHERE a.id = 13

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.03 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.01 ms
executing	0.03 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.06 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
10	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:835
9	JAccess::getGroupsByUser()	JROOT/libraries/joomla/access/access.php:904
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.67 ms After last query: 0.24 ms Query memory: 0.023 MB Memory before query: 0.909 MB Rows returned: 5

SELECT id, rules

  FROM `hats_viewlevels`

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_viewlevels	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	5

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.09 ms
Unlocking tables	0.09 ms
freeing items	0.01 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:921
8	JAccess::getAuthorisedViewLevels()	JROOT/libraries/joomla/user/user.php:454
7	JUser->getAuthorisedViewLevels()	JROOT/libraries/cms/plugin/helper.php:296
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.72 ms After last query: 0.25 ms Query memory: 0.031 MB Memory before query: 0.917 MB Rows returned: 49

SELECT folder AS type, element AS name, params

  FROM hats_extensions

  WHERE enabled = 1 
  AND type ='plugin' 
  AND state IN (0,1) 
  AND access IN (1,1)

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_extensions	ref	extension	extension	62	const	60	Using index condition; Using where; Using filesort

Profile

Status	Duration
starting	0.10 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.09 ms
preparing	0.08 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.67 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.23 ms
Unlocking tables	0.09 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
7	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/plugin/helper.php:310
6	JPluginHelper::load()	JROOT/libraries/cms/plugin/helper.php:86
5	JPluginHelper::getPlugin()	JROOT/libraries/cms/plugin/helper.php:128
4	JPluginHelper::isEnabled()	JROOT/libraries/cms/application/site.php:599
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.39 ms After last query: 7.40 ms Query memory: 0.026 MB Memory before query: 1.363 MB Rows returned: 1

SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`

  FROM `hats_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using index condition

Profile

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.07 ms
optimizing	0.03 ms
statistics	0.13 ms
preparing	0.05 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.06 ms
freeing items	0.02 ms
updating status	0.03 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
16	JDatabaseDriver->loadObject()	JROOT/libraries/joomla/cache/controller/callback.php:152
15	JCacheControllerCallback->get()	JROOT/libraries/cms/library/helper.php:156
14	JLibraryHelper::_load()	JROOT/libraries/cms/library/helper.php:47
13	JLibraryHelper::getLibrary()	JROOT/libraries/cms/library/helper.php:90
12	JLibraryHelper::getParams()	JROOT/libraries/cms/version/version.php:274
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:45
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.63 ms After last query: 0.41 ms Query memory: 0.006 MB Memory before query: 1.356 MB

UPDATE `hats_extensions`

  SET `params` = '{\"mediaversion\":\"13d46fc64f3b4cee994fa316d6976f0d\"}'

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

Explain

EXPLAIN not possible on query: UPDATE `hats_extensions` SET `params` = '{\"mediaversion\":\"13d46fc64f3b4cee994fa316d6976f0d\"}' WHERE `type` = 'library' AND `element` = 'joomla'

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.14 ms
updating	0.12 ms
end	0.03 ms
query end	4.94 ms
closing tables	0.03 ms
Unlocking tables	0.04 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/cms/library/helper.php:119
13	JLibraryHelper::saveParams()	JROOT/libraries/cms/version/version.php:325
12	JVersion->setMediaVersion()	JROOT/libraries/cms/version/version.php:284
11	JVersion->getMediaVersion()	JROOT/libraries/joomla/factory.php:755
10	JFactory::createDocument()	JROOT/libraries/joomla/factory.php:216
9	JFactory::getDocument()	JROOT/plugins/system/cwgears/cwgears.php:45
8	plgSystemCwgears->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 340.00 ms After last query: 0.96 ms Query memory: 0.022 MB Memory before query: 1.441 MB Rows returned: 1

SELECT count(*)

  FROM `hats_cwtraffic`

  WHERE ip = '18.206.48.243' 
  AND tm + '3600'>'1701768285'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_cwtraffic	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1275261	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.04 ms
statistics	0.03 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	339.46 ms
end	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
10	JDatabaseDriver->loadResult()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:109
9	plgSystemCwtrafficCount->countTraffic()	JROOT/plugins/system/cwtrafficcount/cwtrafficcount.php:32
8	plgSystemCwtrafficCount->onAfterInitialise()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:670
4	JApplicationCms->initialiseApp()	JROOT/libraries/cms/application/site.php:681
3	JApplicationSite->initialiseApp()	JROOT/libraries/cms/application/site.php:209
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 2.22 ms After last query: 0.49 ms Query memory: 0.270 MB Memory before query: 1.459 MB Rows returned: 231

SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component

  FROM hats_menu AS m

  LEFT JOIN hats_extensions AS e 
  ON m.component_id = e.extension_id

  WHERE m.published = 1 
  AND m.parent_id > 0 
  AND m.client_id = 0

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_client_id_parent_id_alias_language	NO INDEX KEY COULD BE USED	NULL	NULL	266	Using where; Using filesort
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	usr_web81_1.m.component_id	1	Using where

Profile

Status	Duration
starting	0.09 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.04 ms
optimizing	0.03 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	1.66 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/menu/site.php:86
14	JMenuSite->load()	JROOT/libraries/cms/menu/menu.php:74
13	JMenu->__construct()	JROOT/libraries/cms/menu/site.php:57
12	JMenuSite->__construct()	JROOT/libraries/cms/menu/menu.php:145
11	JMenu::getInstance()	JROOT/libraries/cms/application/cms.php:439
10	JApplicationCms->getMenu()	JROOT/libraries/cms/application/site.php:272
9	JApplicationSite->getMenu()	JROOT/libraries/cms/router/site.php:57
8	JRouterSite->__construct()	JROOT/libraries/cms/router/router.php:197
7	JRouter::getInstance()	JROOT/libraries/cms/application/cms.php:535
6	JApplicationCms::getRouter()	JROOT/libraries/cms/application/site.php:407
5	JApplicationSite::getRouter()	JROOT/libraries/cms/application/cms.php:1115
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.94 ms After last query: 6.59 ms Query memory: 0.029 MB Memory before query: 3.398 MB Rows returned: 8

SHOW FULL COLUMNS 
  FROM `hats_assets`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hats_assets`

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.27 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 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
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.05 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
16	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
15	JTable->__construct()	JROOT/libraries/joomla/table/asset.php:60
14	JTableAsset->__construct()	JROOT/libraries/joomla/table/table.php:308
13	JTable::getInstance()	JROOT/libraries/joomla/access/access.php:696
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:44
9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:107
8	plgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.48 ms After last query: 0.32 ms Query memory: 0.026 MB Memory before query: 3.430 MB Rows returned: 1

SELECT *

  FROM hats_assets

  WHERE `id` = '1'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.01 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
14	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
13	JTable->load()	JROOT/libraries/joomla/access/access.php:697
12	JAccess::getExtensionNameFromAsset()	JROOT/libraries/joomla/access/access.php:555
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:44
9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:107
8	plgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.52 ms After last query: 0.17 ms Query memory: 0.023 MB Memory before query: 3.434 MB Rows returned: 1

Duplicate queries: #16

SELECT a.rules

  FROM hats_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.01 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
12	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
11	JAccess::getAssetRules()	JROOT/libraries/joomla/user/user.php:385
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:44
9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:107
8	plgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.52 ms After last query: 0.33 ms Query memory: 0.023 MB Memory before query: 3.443 MB Rows returned: 1

Duplicate queries: #15

SELECT a.rules

  FROM hats_assets AS a

  WHERE (a.id = 1 OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	index_merge	PRIMARY,idx_asset_name	PRIMARY,idx_asset_name	4,152	NULL	2	Using union(PRIMARY,idx_asset_name); Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.04 ms
preparing	0.02 ms
executing	0.00 ms
Sending data	0.10 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
13	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:652
12	JAccess::getAssetRules()	JROOT/libraries/joomla/access/access.php:176
11	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
10	JUser->authorise()	JROOT/plugins/system/sourcerer/helper.php:44
9	plgSystemSourcererHelper->__construct()	JROOT/plugins/system/sourcerer/sourcerer.php:107
8	plgSystemSourcerer->onAfterRoute()	JROOT/libraries/joomla/event/event.php:69
7	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
6	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
5	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1125
4	JApplicationCms->route()	JROOT/libraries/cms/application/site.php:791
3	JApplicationSite->route()	JROOT/libraries/cms/application/site.php:215
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.49 ms After last query: 0.47 ms Query memory: 0.025 MB Memory before query: 3.466 MB Rows returned: 1

SELECT *

  FROM hats_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_languages	ALL	NULL	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where; Using filesort

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.02 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.07 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/language/helper.php:164
5	JLanguageHelper::getLanguages()	JROOT/libraries/cms/application/site.php:329
4	JApplicationSite->getParams()	JROOT/libraries/cms/application/site.php:135
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.65 ms After last query: 0.32 ms Query memory: 0.022 MB Memory before query: 3.476 MB Rows returned: 8

SELECT id, home, template, s.params

  FROM hats_template_styles as s

  LEFT JOIN hats_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

  WHERE s.client_id = 0 
  AND e.enabled = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template	NO INDEX KEY COULD BE USED	NULL	NULL	10	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	usr_web81_1.s.template,const	1	Using index condition; Using where

Profile

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.14 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.03 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/application/site.php:484
4	JApplicationSite->getTemplate()	JROOT/libraries/cms/application/site.php:165
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.62 ms After last query: 1.21 ms Query memory: 0.027 MB Memory before query: 3.592 MB Rows returned: 36

SELECT element

  FROM hats_extensions

  WHERE type = 'component' 
  AND enabled = '1'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_extensions	ref	extension	extension	62	const	36	Using index condition; Using where

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.03 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.15 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1538
16	JDatabaseDriver->loadColumn()	JROOT/libraries/joomla/access/access.php:413
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.81 ms After last query: 0.18 ms Query memory: 0.028 MB Memory before query: 3.606 MB Rows returned: 36

SELECT a.name, a.rules

  FROM hats_assets AS a

  WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_coalawebsociallinks','com_coalawebtraffic','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_extplorer','com_finder','com_installer','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_plugins','com_postinstall','com_profiles','com_redirect','com_search','com_tags','com_templates','com_users','com_vitabook','com_weblinks','com_wrapper') OR a.name = 'root.1')

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	ALL	idx_asset_name	NO INDEX KEY COULD BE USED	NULL	NULL	264	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.29 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.73 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1494
16	JDatabaseDriver->loadAssocList()	JROOT/libraries/joomla/access/access.php:441
15	JAccess::preloadComponents()	JROOT/libraries/joomla/access/access.php:213
14	JAccess::preload()	JROOT/libraries/joomla/access/access.php:168
13	JAccess::check()	JROOT/libraries/joomla/user/user.php:394
12	JUser->authorise()	JROOT/components/com_content/models/article.php:55
11	ContentModelArticle->populateState()	JROOT/libraries/legacy/model/legacy.php:435
10	JModelLegacy->getState()	JROOT/components/com_content/models/article.php:262
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.14 ms After last query: 1.18 ms Query memory: 0.035 MB Memory before query: 3.814 MB Rows returned: 30

SHOW FULL COLUMNS 
  FROM `hats_content`

Explain

EXPLAIN not possible on query: SHOW FULL COLUMNS FROM `hats_content`

Profile

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
closing tables	0.01 ms
Opening tables	0.29 ms
After opening tables	0.01 ms
System lock	0.00 ms
Table lock	0.01 ms
init	0.01 ms
optimizing	0.01 ms
statistics	0.01 ms
preparing	0.02 ms
executing	0.01 ms
Filling schema table	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
checking permissions	0.05 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
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
closing tables	0.01 ms
executing	0.00 ms
Sending data	0.08 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
removing tmp table	0.07 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:440
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/joomla/table/table.php:241
13	JTable->getFields()	JROOT/libraries/joomla/table/table.php:162
12	JTable->__construct()	JROOT/libraries/legacy/table/content.php:31
11	JTableContent->__construct()	JROOT/libraries/joomla/table/table.php:308
10	JTable::getInstance()	JROOT/components/com_content/models/article.php:264
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.71 ms After last query: 0.51 ms Query memory: 0.074 MB Memory before query: 3.883 MB Rows returned: 1

SELECT *

  FROM hats_content

  WHERE `id` = '63'

Explain

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

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.28 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.01 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1453
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/joomla/table/table.php:719
10	JTable->load()	JROOT/components/com_content/models/article.php:265
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 5.86 ms After last query: 0.22 ms Query memory: 0.005 MB Memory before query: 3.929 MB

UPDATE hats_content

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

  WHERE `id` = '63'

Explain

EXPLAIN not possible on query: UPDATE hats_content SET `hits` = (`hits` + 1) WHERE `id` = '63'

Profile

Status	Duration
starting	0.05 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
updating	0.08 ms
end	0.01 ms
query end	5.40 ms
closing tables	0.02 ms
Unlocking tables	0.02 ms
freeing items	0.01 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/table/table.php:1228
10	JTable->hit()	JROOT/components/com_content/models/article.php:266
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:109
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.40 ms After last query: 0.61 ms Query memory: 0.056 MB Memory before query: 3.952 MB Rows returned: 1

SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 hats_content AS a

  LEFT JOIN hats_categories AS c 
  on c.id = a.catid

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

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

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

  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hats_categories AS cat JOIN hats_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published <= 0 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  WHERE a.id = 63 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2023-12-05 09:24:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2023-12-05 09:24:46') 
  AND (a.state = 1 OR a.state =2)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	a	const	PRIMARY,idx_state	PRIMARY	4	const	1
1	PRIMARY	c	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	u	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	parent	const	PRIMARY	PRIMARY	4	const	1
1	PRIMARY	v	const	PRIMARY	PRIMARY	4	const	0	unique row not found
1	PRIMARY	<derived2>	ref	key0	key0	5	const	1	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	1	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	13	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.21 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.02 ms
checking permissions	0.01 ms
Opening tables	0.06 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.11 ms
optimizing	0.05 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.04 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
executing	0.00 ms
Sending data	0.03 ms
Creating sort index	0.04 ms
removing tmp table	0.01 ms
Creating sort index	0.22 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.02 ms
freeing items	0.02 ms
updating status	0.04 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1650
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:159
12	ContentModelArticle->getItem()	JROOT/libraries/legacy/view/legacy.php:408
11	JViewLegacy->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.99 ms After last query: 0.68 ms Query memory: 0.036 MB Memory before query: 4.081 MB Rows returned: 2

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

  FROM hats_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hats_categories AS cat JOIN hats_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hats_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=8

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	usr_web81_1.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	13	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.23 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.13 ms
optimizing	0.05 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.04 ms
statistics	0.13 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.03 ms
removing tmp table	0.01 ms
Creating sort index	0.43 ms
Creating sort index	0.07 ms
removing tmp table	0.07 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
removing tmp table	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.09 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
14	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
13	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
12	JCategories->get()	JROOT/components/com_content/helpers/route.php:44
11	ContentHelperRoute::getArticleRoute()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.62 ms After last query: 0.93 ms Query memory: 0.034 MB Memory before query: 4.115 MB Rows returned: 0

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

  FROM `hats_contentitem_tag_map` AS m 

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ALL	idx_tag_type,idx_tag	NO INDEX KEY COULD BE USED	NULL	NULL	1	Using where
1	SIMPLE	t	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	usr_web81_1.m.tag_id	1	Using where

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.03 ms
statistics	0.09 ms
preparing	0.04 ms
executing	0.01 ms
Sending data	0.06 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	1.14 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/cms/helper/tags.php:435
11	JHelperTags->getItemTags()	JROOT/components/com_content/views/article/view.html.php:156
10	ContentViewArticle->display()	JROOT/libraries/legacy/controller/legacy.php:664
9	JControllerLegacy->display()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/legacy/controller/legacy.php:702
7	JControllerLegacy->execute()	JROOT/components/com_content/content.php:38
6	require_once JROOT/components/com_content/content.php	JROOT/libraries/cms/component/helper.php:405
5	JComponentHelper::executeComponent()	JROOT/libraries/cms/component/helper.php:380
4	JComponentHelper::renderComponent()	JROOT/libraries/cms/application/site.php:191
3	JApplicationSite->dispatch()	JROOT/libraries/cms/application/site.php:230
2	JApplicationSite->doExecute()	JROOT/libraries/cms/application/cms.php:261
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 1.54 ms After last query: 9.02 ms Query memory: 0.028 MB Memory before query: 4.440 MB Rows returned: 11

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

  FROM hats_modules AS m

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

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

  WHERE m.published = 1 
  AND e.enabled = 1 
  AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2023-12-05 09:24:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2023-12-05 09:24:46') 
  AND m.access IN (1,1) 
  AND m.client_id = 0 
  AND (mm.menuid = 527 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profile

Status	Duration
starting	0.12 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.05 ms
optimizing	0.05 ms
statistics	0.08 ms
preparing	0.06 ms
Sorting result	0.02 ms
executing	0.01 ms
Sending data	0.02 ms
Creating sort index	0.78 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.01 ms
freeing items	0.07 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/cache/controller/callback.php:152
12	JCacheControllerCallback->get()	JROOT/libraries/cms/module/helper.php:425
11	JModuleHelper::getModuleList()	JROOT/libraries/cms/module/helper.php:361
10	JModuleHelper::load()	JROOT/libraries/cms/module/helper.php:84
9	JModuleHelper::getModules()	JROOT/libraries/joomla/document/html.php:501
8	JDocumentHtml->countModules()	JROOT/templates/hatsche_01/index.php:35
7	require JROOT/templates/hatsche_01/index.php	JROOT/libraries/joomla/document/html.php:578
6	JDocumentHtml->_loadTemplate()	JROOT/libraries/joomla/document/html.php:640
5	JDocumentHtml->_fetchTemplate()	JROOT/libraries/joomla/document/html.php:455
4	JDocumentHtml->parse()	JROOT/libraries/cms/application/cms.php:1072
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.91 ms After last query: 5.07 ms Query memory: 0.062 MB Memory before query: 4.780 MB Rows returned: 54

SELECT *
			
  FROM hats_modules
			
  WHERE published=1
			
  ORDER BY id
			;

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	hats_modules	ref	published	published	1	const	54	Using where; Using filesort

Profile

Status	Duration
starting	0.08 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.03 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.02 ms
Creating sort index	0.37 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
Unlocking tables	0.07 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
13	JDatabaseDriver->loadObjectList()	JROOT/modules/mod_maximenuck/helper.php:351
12	modMaximenuckHelper::CreateModulesList()	JROOT/modules/mod_maximenuck/helper.php:54
11	modMaximenuckHelper::getItems()	JROOT/modules/mod_maximenuck/mod_maximenuck.php:21
10	include JROOT/modules/mod_maximenuck/mod_maximenuck.php	JROOT/libraries/cms/module/helper.php:199
9	JModuleHelper::renderModule()	JROOT/libraries/joomla/document/renderer/html/module.php:93
8	JDocumentRendererHtmlModule->render()	JROOT/libraries/joomla/document/renderer/html/modules.php:42
7	JDocumentRendererHtmlModules->render()	JROOT/libraries/joomla/document/html.php:411
6	JDocumentHtml->getBuffer()	JROOT/libraries/joomla/document/html.php:702
5	JDocumentHtml->_renderTemplate()	JROOT/libraries/joomla/document/html.php:477
4	JDocumentHtml->render()	JROOT/libraries/cms/application/cms.php:1086
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 0.77 ms After last query: 96.57 ms Query memory: 0.024 MB Memory before query: 5.341 MB Rows returned: 1

SELECT alias

  FROM hats_content

  WHERE id=31

Explain

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

Profile

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.02 ms
optimizing	0.02 ms
statistics	0.05 ms
preparing	0.01 ms
Unlocking tables	0.03 ms
executing	0.01 ms
Sending data	0.36 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
Unlocking tables	0.01 ms
freeing items	0.01 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1728
14	JDatabaseDriver->loadResult()	JROOT/components/com_content/router.php:118
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

Query Time: 3.73 ms After last query: 0.20 ms Query memory: 0.037 MB Memory before query: 5.353 MB Rows returned: 2

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

  FROM hats_categories as c

  LEFT JOIN  (SELECT cat.id as id 
  FROM hats_categories AS cat JOIN hats_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt 
  WHERE parent.extension = 'com_content' 
  AND parent.published != 1 
  GROUP BY cat.id) AS badcats 
  ON badcats.id = c.id

  LEFT JOIN hats_categories AS s 
  ON (s.lft <= c.lft 
  AND s.rgt >= c.rgt) OR (s.lft > c.lft 
  AND s.rgt < c.rgt)

  WHERE (c.extension='com_content' OR c.extension='system') 
  AND c.access IN (1,1) 
  AND c.published = 1 
  AND badcats.id is null 
  AND s.id=9

  GROUP BY 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

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	s	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	Using temporary; Using filesort
1	PRIMARY	c	ALL	cat_idx,idx_access,idx_left_right	NO INDEX KEY COULD BE USED	NULL	NULL	13	Using where
1	PRIMARY	<derived2>	ref	key0	key0	5	usr_web81_1.c.id	2	Using where
2	DERIVED	parent	range	cat_idx,idx_left_right	cat_idx	153	NULL	2	Using index condition; Using temporary; Using filesort
2	DERIVED	cat	index	idx_left_right	idx_left_right	8	NULL	13	Using where; Using index; Using join buffer (flat, BNL join)

Profile

Status	Duration
starting	0.19 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
checking permissions	0.01 ms
Opening tables	0.03 ms
After opening tables	0.01 ms
System lock	0.01 ms
Table lock	0.01 ms
init	0.13 ms
optimizing	0.04 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.03 ms
Creating tmp table	0.02 ms
Sorting result	0.04 ms
statistics	0.14 ms
preparing	0.01 ms
Unlocking tables	0.05 ms
Creating tmp table	0.05 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.06 ms
executing	0.01 ms
Sending data	0.03 ms
Creating sort index	0.04 ms
removing tmp table	0.01 ms
Creating sort index	0.42 ms
Creating sort index	0.07 ms
removing tmp table	0.07 ms
Creating sort index	0.02 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.03 ms
removing tmp table	0.04 ms
closing tables	0.02 ms
Unlocking tables	0.01 ms
freeing items	0.02 ms
updating status	0.02 ms
cleaning up	0.01 ms

Call Stack

#	Caller	File and line number
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1689
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/legacy/categories/categories.php:309
15	JCategories->_load()	JROOT/libraries/legacy/categories/categories.php:184
14	JCategories->get()	JROOT/components/com_content/router.php:151
13	ContentRouter->build()	JROOT/libraries/cms/router/site.php:496
12	JRouterSite->buildSefRoute()	JROOT/libraries/cms/router/site.php:465
11	JRouterSite->_buildSefRoute()	JROOT/libraries/cms/router/router.php:281
10	JRouter->build()	JROOT/libraries/cms/router/site.php:147
9	JRouterSite->build()	JROOT/libraries/joomla/application/route.php:62
8	JRoute::_()	JROOT/plugins/system/sef/sef.php:110
7	PlgSystemSef->onAfterRender()	JROOT/libraries/joomla/event/event.php:69
6	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:159
5	JEventDispatcher->trigger()	JROOT/libraries/joomla/application/base.php:106
4	JApplicationBase->triggerEvent()	JROOT/libraries/cms/application/cms.php:1092
3	JApplicationCms->render()	JROOT/libraries/cms/application/site.php:773
2	JApplicationSite->render()	JROOT/libraries/cms/application/cms.php:267
1	JApplicationCms->execute()	JROOT/index.php:40

[Add xdebug.file_link_format directive to your php.ini file to have links for files.]

27 Query Types Logged, Sorted by Occurrences.

SELECT Tables:

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

2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled` 
  FROM `hats_extensions`

2 × SELECT a.rules 
  FROM hats_assets AS a

1 × SELECT `data` 
  FROM `hats_session`

1 × SELECT element 
  FROM hats_extensions

```
1 × SELECT *    
  FROM hats_modules
```

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

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

1 × SELECT a.id, a.asset_id, a.title, a.alias, a.introtext, a.fulltext, 
  CASE WHEN badcats.id is null THEN a.state ELSE 0 END AS 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 hats_content AS a 
  LEFT JOIN hats_categories AS c 
  on c.id = a.catid 
  LEFT JOIN hats_users AS u 
  on u.id = a.created_by 
  LEFT JOIN hats_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN hats_content_rating AS v 
  ON a.id = v.content_id 
  LEFT 
  OUTER JOIN  (SELECT cat.id as id 
  FROM hats_categories AS cat JOIN hats_categories AS parent 
  ON cat.lft BETWEEN parent.lft 
  AND parent.rgt

```
1 × SELECT * 
  FROM hats_content
```

1 × SELECT a.name, a.rules 
  FROM hats_assets AS a

```
1 × SELECT * 
  FROM hats_languages
```

1 × SELECT id, home, template, s.params 
  FROM hats_template_styles as s 
  LEFT JOIN hats_extensions as e 
  ON e.element=s.template 
  AND e.type='template' 
  AND e.client_id=s.client_id

1 × SELECT `session_id` 
  FROM `hats_session`

```
1 × SELECT * 
  FROM hats_assets
```

1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component 
  FROM hats_menu AS m 
  LEFT JOIN hats_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT count(*) 
  FROM `hats_cwtraffic`

1 × SELECT folder AS type, element AS name, params 
  FROM hats_extensions

1 × SELECT id, rules 
  FROM `hats_viewlevels

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

```
1 × SELECT alias 
  FROM hats_content
```

OTHER Tables:

```
1 × DELETE  
  FROM `hats_session`
```

1 × INSERT INTO `hats_session` (`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) 
  VALUES  ('3733305feee4d4a041a46c65aea1958d', 0, 1, '1701768285', 0, ''

1 × UPDATE `hats_extensions` 
  SET `params` = '{\"mediaversion\":\"13d46fc64f3b4cee994fa316d6976f0d\"}'

1 × SHOW FULL COLUMNS 
  FROM `hats_assets

1 × SHOW FULL COLUMNS 
  FROM `hats_content

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