Leider sind wegen des unsicheren Wetters keine weiteren Camping-Parkplätze mehr verfügbar.

Danke für dein Verständniss.

Dein DSO-Team

Gelesen: 827

images/agility/zeitplan/2018_helfer.pdf

Gelesen: 1199

Du erreichst uns unter:

Moni Fillinger / Turnier-Administration / + 41 79 257 07 50 / Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!

Martin Zäch / Technische Belange / + 41 79 224 98 04 / Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!

Per Post:

Martin Zäch
DogSportOstschweiz.ch
Schocherswilerstr. 7
8586 Buchackern

Gelesen: 1570

Moni Fillinger

	Wohnort:	St. Margarethen (TG)
	Beruf:	Projektleiterin Hochbau
	Hobby:	Hunde, Pferde
	Stärken:	Flexibilität, organisieren
	Schwächen:	kann nicht nein sagen, Süsses, pingelig
	Lebensmotto:	nur Idioten halten Ordnung, ein Genie beherrscht das Chaos…
	mail:	Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
	Tel:	+41 79 257 07 50

Martin Zäch

	Wohnort:	Buchackern (TG)
	Beruf:	Inhaber Zoo-Shop GmbH
	Hobby:	Hundesport, Agility / Trailen
	Stärken:	Flexibel, Technisch begabt
	Schwächen:	ungeduldig
	Lebensmotto:	behandle Andere so wie Du gerne behandelt werden möchtest…
	mail:	Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
	Tel:	+41 79 224 98 04

Gelesen: 1599

Plauschmeeting

DSO - Plausch-Agility Meeting

mit oder ohne Lizenz auch für Oldies

Nächster Termin: 6.04.2019 & 30.11.2019 in Winterthur / Lageplan

Das Meeting startet ca. 14h und endet je nach Teilnehmer ca. 18h

Teilnehmerzahl limitiert

Es werden 2 Läufe für 30.- durchgeführt.

Mindestalter: neu gem. FCI Reglement 18Mt

Kategorie 1 = Anfänger: ohne Wippe ohne Slalom

Kategorie 2 = Jung-Profis: mit allen Geräten ohne Lizenz

Grössen:

Grösse Small: kleiner 35cm, Hindernishöhe: 25cm

Grösse Medium: grösser 35 kleiner 43cm, Hindernishöhe: 35cm

Grösse Large: ab 43cm, Hindernishöhe: 55cm

Was bieten wir Dir an:

Du bekommst die Möglichkeit 2 Läufe zu absolvieren

1. einen Agility-Lauf "mit Kontaktzonen"

2. einen Jumping Lauf "ohne Kontaktzonen" zu laufen.

Der Ablauf wird wie an einem offiziellen Agility Meeting sein.

Wir stellen mit Euch zusammen einen Parcour,

Du bekommst Zeit um ihn Dir anzuschauen und ein zu prägen.

Dann startest Du mit Deinem Hund.

Wir erstellen die Ranglisten der einzelnen Läufe und eine Kombi-Rangliste aus allen Läufen zusammen.

Wir organisieren einen Gabentisch von dem JEDER, der Kombi-Rangliste entsprechend, seinen Preis aussuchen darf,

und natürlich erhalten die Ränge 1-3 aus jedem Lauf ein kleines Andenken für die guten Team-Leistungen.

Startgeld: Fr. 30.-

Achtung mit der Anmeldung stellst Du Dich gleichzeitig als Parcourhelfer zur Verfügung, natürlich nur in der Kategorie in der Du NICHT selber startest.
Es werden meist nicht alle Teilnehmer als Helfer gebraucht.

Anmeldungen hier

Infos zum Meeting hier
Rangliste Plauschmeeting

Wegbeschreibung / Lageplan

In welcher Kategorie möchtest Du starten ?

Kat. 1, Anfänger, ohne Wippe, Slalom

Kat. 2, Jung-Profi alle Geräte ohne Lizenz

Grösse Hund ?

Grösse Small: kleiner 35cm

Grösse Medium: grösser 35 kleiner 43cm

Grösse Large : ab 43cm

Wenn Dein Hund schon älter ist oder noch im Aufbau darfst Du auch in einer Kategorie tiefer starten.

Du erreichst uns per mail unter Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein!
oder Tel +41 79 224 98 04

Weiterlesen: Plauschmeeting

Gelesen: 5125

Weitere Beiträge ...

Martin Zäch & Monika Fillinger | Schocherswilerstr. 7 | 8586 Buchackern
Diese E-Mail-Adresse ist vor Spambots geschützt! Zur Anzeige muss JavaScript eingeschaltet sein! / +41 79 224 98 04

Joomla!-Debug-Konsole

Sitzung

{
    "__default": {
        "session": {
            "counter": 1,
            "timer": {
                "start": 1561443585,
                "last": 1561443585,
                "now": 1561443585
            },
            "token": "o82dMHz0N5jC0rrPb2WMfNb2vAFi0XUG"
        },
        "registry": {
            "com_installer": {
                "message": "",
                "extension_message": ""
            }
        },
        "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
        },
        "com_mailto": {
            "links": {
                "f2d4134e98ce353ffd0e9e42c1ce922a64ea4d86": {
                    "link": "http:\/\/www.mein-werbeplatz.ch\/neu\/index.php\/ueber-dso\/kontakt\/2-uncategorised\/12-eo-camping-ausgebucht",
                    "expiry": 1561443589
                },
                "b357f53b2b4d5ed0ba6d27862ea38426a35b95dd": {
                    "link": "http:\/\/www.mein-werbeplatz.ch\/neu\/index.php\/ueber-dso\/kontakt\/2-uncategorised\/11-helferliste",
                    "expiry": 1561443589
                },
                "c0f8de0c15e84387af633f156895d7389b82d757": {
                    "link": "http:\/\/www.mein-werbeplatz.ch\/neu\/index.php\/ueber-dso\/kontakt",
                    "expiry": 1561443589
                },
                "6eba1f6966d9719b4ff2a7fe8a04b4bb9ca3d824": {
                    "link": "http:\/\/www.mein-werbeplatz.ch\/neu\/index.php\/ueber-dso\/dso-team",
                    "expiry": 1561443589
                },
                "25a142e3b9d61ba567207ee41bc2f16eada61560": {
                    "link": "http:\/\/www.mein-werbeplatz.ch\/neu\/index.php\/plauschmeeting",
                    "expiry": 1561443589
                }
            }
        }
    }
}

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 19.85 ms / 19.85 ms Speicher: 0.705 MB / 1.07 MB Application: afterLoad

Zeit: 445.85 ms / 465.70 ms Speicher: 1.482 MB / 2.55 MB Application: afterInitialise

Zeit: 3356.46 ms / 3822.16 ms Speicher: 1.588 MB / 4.14 MB Application: afterRoute

Zeit: 0.18 ms / 3822.34 ms Speicher: 0.001 MB / 4.14 MB Application: beforeRenderComponent com_content

Zeit: 6.18 ms / 3828.52 ms Speicher: 0.147 MB / 4.29 MB Application: Before Access::preloadComponents (all components)

Zeit: 0.51 ms / 3829.03 ms Speicher: 0.063 MB / 4.35 MB Application: After Access::preloadComponents (all components)

Zeit: 0.01 ms / 3829.05 ms Speicher: 0.000 MB / 4.35 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 0.27 ms / 3829.32 ms Speicher: 0.025 MB / 4.37 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.01 ms / 3829.33 ms Speicher: 0.000 MB / 4.37 MB Application: Before Access::getAssetRules (id:27 name:com_content.category.2)

Zeit: 0.56 ms / 3829.89 ms Speicher: 0.011 MB / 4.39 MB Application: After Access::getAssetRules (id:27 name:com_content.category.2)

Zeit: 2.39 ms / 3832.29 ms Speicher: 0.032 MB / 4.42 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 0.01 ms / 3832.30 ms Speicher: 0.002 MB / 4.42 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 33.77 ms / 3866.07 ms Speicher: 0.764 MB / 5.18 MB Application: afterRenderComponent com_content

Zeit: 1.45 ms / 3867.51 ms Speicher: 0.011 MB / 5.19 MB Application: afterDispatch

Zeit: 8.87 ms / 3876.38 ms Speicher: 0.181 MB / 5.37 MB Application: beforeRenderModule mod_menu ()

Zeit: 3.33 ms / 3879.71 ms Speicher: 0.149 MB / 5.52 MB Application: afterRenderModule mod_menu ()

Zeit: 0.02 ms / 3879.73 ms Speicher: 0.000 MB / 5.46 MB Application: beforeRenderModule mod_custom ()

Zeit: 1.06 ms / 3880.79 ms Speicher: 0.014 MB / 5.48 MB Application: afterRenderModule mod_custom ()

Zeit: 0.45 ms / 3881.24 ms Speicher: 0.003 MB / 5.48 MB Application: beforeRenderModule mod_menu ()

Zeit: 0.89 ms / 3882.14 ms Speicher: 0.064 MB / 5.54 MB Application: afterRenderModule mod_menu ()

Zeit: 4217.57 ms / 8099.71 ms Speicher: 0.331 MB / 5.87 MB Application: afterRender

Datenbankabfragen gesamt: 5990.08 ms

Speichernutzung

Datenbankabfragen

46 ausgeführte Abfragen 5990.08 ms

Abfragezeit: 0.20 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.538 MB Zeilen zurückgegeben: 0

SELECT `data`

  FROM `jospp_session`

  WHERE `session_id` = 'd01d4afa984e274d257aa3a48b4698a7'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.01 ms
Opening tables	0.02 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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
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:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php:758
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 0.16 ms Nach letzter Abfrage: 1.64 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.553 MB Zeilen zurückgegeben: 0

SELECT `session_id`

  FROM `jospp_session`

  WHERE `session_id` = 'd01d4afa984e274d257aa3a48b4698a7' 
  LIMIT 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_session	NULL	const	PRIMARY	PRIMARY	194	const	1	100.00	Using index

Profil (Profile)

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.02 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
8	JDatabaseDriver->loadResult()	JROOT/libraries/src/Session/MetadataManager.php:74
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 337.54 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.559 MB

INSERT INTO `jospp_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES 
('d01d4afa984e274d257aa3a48b4698a7', 1, 1561443585, 0, '', 0)

Erklären

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jospp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES ('d01d4afa984e274d257aa3a48b4698a7', 1, 1561443585, 0, '', 0)

Profil (Profile)

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
update	0.04 ms
Waiting for query cache lock	0.00 ms
update	0.00 ms
end	0.00 ms
query end	337.27 ms
closing tables	0.05 ms
freeing items	0.07 ms
cleaning up	0.03 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Session/MetadataManager.php:116
7	Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting()	JROOT/libraries/src/Application/CMSApplication.php:153
6	Joomla\CMS\Application\CMSApplication->checkSession()	JROOT/libraries/src/Application/CMSApplication.php:760
5	Joomla\CMS\Application\CMSApplication->loadSession()	JROOT/libraries/src/Application/CMSApplication.php:135
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:344
2	Joomla\CMS\Application\CMSApplication::getInstance()	JROOT/libraries/src/Factory.php:140
1	Joomla\CMS\Factory::getApplication()	JROOT/index.php:46

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

Abfragezeit: 1.37 ms Nach letzter Abfrage: 17.29 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.658 MB Zeilen zurückgegeben: 38

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

  FROM `jospp_extensions`

  WHERE `type` = 'component' 
  AND `state` = 0 
  AND `enabled` = 1

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_extensions	NULL	ref	extension	extension	82	const	38	1.00	Using where

Profil (Profile)

Status	Duration
starting	0.13 ms
checking permissions	0.03 ms
Opening tables	0.04 ms
init	0.06 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.14 ms
preparing	0.04 ms
executing	0.02 ms
Sending data	0.46 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.03 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Der selbe Aufruf in der Zeile darunter.
9	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
8	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Component/ComponentHelper.php:453
7	Joomla\CMS\Component\ComponentHelper::load()	JROOT/libraries/src/Component/ComponentHelper.php:519
6	Joomla\CMS\Component\ComponentHelper::getComponents()	JROOT/libraries/src/Component/ComponentHelper.php:44
5	Joomla\CMS\Component\ComponentHelper::getComponent()	JROOT/libraries/src/Component/ComponentHelper.php:103
4	Joomla\CMS\Component\ComponentHelper::getParams()	JROOT/libraries/src/Application/SiteApplication.php:594
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.43 ms Nach letzter Abfrage: 13.51 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 1.693 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `jospp_viewlevels`

Erklären

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

Profil (Profile)

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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.16 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.705 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM jospp_usergroups AS a

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

  WHERE a.id = 9

Erklären

id	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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 ms
checking permissions	0.01 ms
Opening tables	0.04 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.09 ms
preparing	0.03 ms
executing	0.01 ms
Sending data	0.04 ms
end	0.01 ms
query end	0.02 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
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:321
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.02 ms Nach letzter Abfrage: 3.28 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 1.790 MB Zeilen zurückgegeben: 86

SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`

  FROM jospp_extensions

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

  ORDER BY ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_extensions	NULL	ref	extension	extension	82	const	116	0.60	Using index condition; Using where; filesort wurde genutzt

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
Opening tables	0.02 ms
init	0.03 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.06 ms
preparing	0.03 ms
Sorting result	0.01 ms
executing	0.01 ms
Sending data	0.01 ms
Creating sort index	0.58 ms
end	0.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.03 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Der selbe Aufruf in der Zeile darunter.
8	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
7	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Plugin/PluginHelper.php:359
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 44.43 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.480 MB Zeilen zurückgegeben: 30

SELECT *

  FROM jospp_rsform_config

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_rsform_config	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	30	100.00	NULL

Profil (Profile)

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.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.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_rsform/helpers/config.php:50
11	RSFormProConfig->load()	JROOT/administrator/components/com_rsform/helpers/config.php:17
10	RSFormProConfig->__construct()	JROOT/administrator/components/com_rsform/helpers/config.php:97
9	RSFormProConfig::getInstance()	JROOT/plugins/system/rsformdeletesubmissions/rsformdeletesubmissions.php:28
8	plgSystemRsformdeletesubmissions->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:626
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 4.07 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 2.585 MB Zeilen zurückgegeben: 17

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 jospp_menu AS m

  LEFT JOIN jospp_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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	37	3.33	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.m.component_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.04 ms
checking permissions	0.00 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
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.13 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Der selbe Aufruf in der Zeile darunter.
16	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
15	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Menu/SiteMenu.php:101
14	Joomla\CMS\Menu\SiteMenu->load()	JROOT/libraries/src/Menu/AbstractMenu.php:76
13	Joomla\CMS\Menu\AbstractMenu->__construct()	JROOT/libraries/src/Menu/SiteMenu.php:62
12	Joomla\CMS\Menu\SiteMenu->__construct()	JROOT/libraries/src/Menu/AbstractMenu.php:131
11	Joomla\CMS\Menu\AbstractMenu::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:375
10	Joomla\CMS\Application\CMSApplication->getMenu()	JROOT/libraries/src/Application/SiteApplication.php:275
9	Joomla\CMS\Application\SiteApplication->getMenu()	JROOT/libraries/src/Router/SiteRouter.php:64
8	Joomla\CMS\Router\SiteRouter->__construct()	JROOT/libraries/src/Router/Router.php:189
7	Joomla\CMS\Router\Router::getInstance()	JROOT/libraries/src/Application/CMSApplication.php:491
6	Joomla\CMS\Application\CMSApplication::getRouter()	JROOT/libraries/src/Application/SiteApplication.php:403
5	Joomla\CMS\Application\SiteApplication::getRouter()	JROOT/libraries/src/Application/CMSApplication.php:1073
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1560.76 ms Nach letzter Abfrage: 17.37 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 2.965 MB Zeilen zurückgegeben: 2

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

  FROM `jospp_categories` AS `s`

  INNER JOIN `jospp_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 = 2

  ORDER BY c.lft

Erklären

id	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	NULL
1	SIMPLE	c	NULL	range	cat_idx,idx_access,idx_left_right	idx_left_right	4	NULL	2	62.50	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 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	1559.89 ms
preparing	0.16 ms
Sorting result	0.05 ms
executing	0.02 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.04 ms
closing tables	0.03 ms
freeing items	0.08 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
12	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
11	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/helpers/legacyrouter.php:350
10	ContentRouterRulesLegacy->parse()	JROOT/libraries/src/Component/Router/RouterView.php:266
9	Joomla\CMS\Component\Router\RouterView->parse()	JROOT/libraries/src/Router/SiteRouter.php:437
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:138
5	Joomla\CMS\Router\SiteRouter->parse()	JROOT/libraries/src/Application/CMSApplication.php:1074
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.13 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 2.983 MB Zeilen zurückgegeben: 3

SELECT id, home, template, s.params

  FROM jospp_template_styles as s

  LEFT JOIN jospp_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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	s	NULL	ALL	idx_template	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	5	20.00	Using where
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid,extension	element_clientid	403	meinwerb_joom980.s.template,const	1	4.44	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.14 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.04 ms
statistics	0.15 ms
preparing	0.05 ms
executing	0.02 ms
Sending data	0.21 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
10	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/plugins/system/yootheme/yootheme.php:112
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.26 ms Nach letzter Abfrage: 28.00 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 3.948 MB Zeilen zurückgegeben: 1

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

  FROM `jospp_extensions`

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	NULL

Profil (Profile)

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.03 ms
end	0.00 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1656
31	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
30	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Der selbe Aufruf in der Zeile darunter.
29	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
28	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
27	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
26	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
25	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
24	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
23	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
22	Joomla\CMS\Factory::getDocument()	Der selbe Aufruf in der Zeile darunter.
21	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:26
20	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:28
19	YOOtheme\Theme\Joomla->onInit()	Der selbe Aufruf in der Zeile darunter.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Der selbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1734.28 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.011 MB Speichernutzung vor Abfrage: 3.945 MB

UPDATE `jospp_extensions`

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jospp_extensions	NULL	range	element_clientid,element_folder_clientid,extension	extension	484	const,const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.01 ms
Opening tables	0.01 ms
init	0.01 ms
System lock	0.03 ms
updating	0.03 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	1734.08 ms
closing tables	0.03 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
26	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
25	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
24	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
23	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
22	Joomla\CMS\Factory::getDocument()	Der selbe Aufruf in der Zeile darunter.
21	call_user_func()	JROOT/templates/yootheme/vendor/yootheme/framework/src/ContainerTrait.php:26
20	YOOtheme\Module->__get()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:28
19	YOOtheme\Theme\Joomla->onInit()	Der selbe Aufruf in der Zeile darunter.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Der selbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.25 ms Nach letzter Abfrage: 3.99 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 4.036 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jospp_languages

  WHERE published=1

  ORDER BY ordering ASC

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_languages	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where; filesort wurde genutzt

Profil (Profile)

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.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.04 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
26	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
25	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
24	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:57
23	YOOtheme\Theme\Joomla->onSite()	Der selbe Aufruf in der Zeile darunter.
22	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
21	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
20	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/src/Joomla.php:47
19	YOOtheme\Theme\Joomla->onInit()	Der selbe Aufruf in der Zeile darunter.
18	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
17	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
16	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla/index.php:177
15	YOOtheme\Theme\Joomla->{closure}()	Der selbe Aufruf in der Zeile darunter.
14	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventManager.php:119
13	YOOtheme\EventManager->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/event/src/EventTrait.php:42
12	YOOtheme\Application->trigger()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/app/src/Application.php:58
11	YOOtheme\Application->init()	JROOT/plugins/system/yootheme/yootheme.php:153
10	plgSystemYOOtheme->loadTemplate()	JROOT/plugins/system/yootheme/yootheme.php:114
9	plgSystemYOOtheme->handleRequest()	JROOT/plugins/system/yootheme/yootheme.php:30
8	plgSystemYOOtheme->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:1122
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 10.61 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 4.294 MB Zeilen zurückgegeben: 38

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

  FROM `jospp_assets`

  WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_ajax','com_akeeba','com_associations','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','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_privacy','com_redirect','com_rseventspro','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper','com_zoo')

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_assets	NULL	ALL	idx_asset_name	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	95	41.05	Using where

Profil (Profile)

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.08 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.12 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
18	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.350 MB Zeilen zurückgegeben: 18

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

  FROM `jospp_assets`

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

Erklären

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

Profil (Profile)

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.06 ms
end	0.00 ms
query end	0.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
18	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
17	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
16	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
15	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
14	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/category.php:139
13	ContentModelCategory->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
12	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/libraries/src/MVC/View/CategoryView.php:116
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.39 ms Nach letzter Abfrage: 0.71 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 4.389 MB Zeilen zurückgegeben: 2

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

  FROM `jospp_content` AS `i`

  WHERE i.`catid` = c.id 
  AND i.state = 1) AS numitems

  FROM `jospp_categories` AS `s`

  INNER JOIN `jospp_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 = 2

  ORDER BY c.lft

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	PRIMARY	s	NULL	const	PRIMARY,idx_left_right	PRIMARY	4	const	1	100.00	NULL
1	PRIMARY	c	NULL	range	cat_idx,idx_left_right	idx_left_right	4	NULL	2	37.50	Using index condition; Using where
2	DEPENDENT SUBQUERY	i	NULL	ref	idx_state,idx_catid	idx_catid	4	meinwerb_joom980.c.id	7	92.86	Using index condition; Using where

Profil (Profile)

Status	Duration
starting	0.08 ms
checking permissions	0.00 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.05 ms
preparing	0.01 ms
Sorting result	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
executing	0.00 ms
Sending data	0.03 ms
executing	0.00 ms
Sending data	0.02 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.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
15	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
14	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/models/category.php:355
13	ContentModelCategory->getCategory()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:122
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.54 ms Nach letzter Abfrage: 1.94 ms Abfragespeichernutzung: 0.121 MB Speichernutzung vor Abfrage: 4.417 MB Zeilen zurückgegeben: 7

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

  FROM jospp_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-25 06:19:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-25 06:19:46')

  ORDER BY  c.lft,   
  CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END  DESC ,  a.created

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	filesort wurde genutzt
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	14.85	Using index condition; Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.created_by	1	100.00	Using where
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.modified_by	1	100.00	Using where
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.09 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.05 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 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.01 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.20 ms Nach letzter Abfrage: 1.95 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.662 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.03 ms
checking permissions	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.682 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.703 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.723 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.744 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.764 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.17 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 4.784 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

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

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.02 ms
System lock	0.00 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.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
17	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
16	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
15	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/models/articles.php:706
14	ContentModelArticles->getItems()	JROOT/components/com_content/models/category.php:253
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.30 ms Nach letzter Abfrage: 1.29 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.803 MB Zeilen zurückgegeben: 1

SELECT COUNT(*)

  FROM jospp_content AS a

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

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

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

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

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

  WHERE a.access IN (1,1,5) 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND a.state = 1 
  AND a.catid = 2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-06-25 06:19:46') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-06-25 06:19:46')

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	c	NULL	const	PRIMARY,idx_access	PRIMARY	4	const	1	100.00	NULL
1	SIMPLE	a	NULL	ref	idx_access,idx_state,idx_catid	idx_catid	4	const	7	14.85	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.created_by	1	100.00	Using where; Using index
1	SIMPLE	uam	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.modified_by	1	100.00	Using where; Using index
1	SIMPLE	parent	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	Using where; Using index
1	SIMPLE	v	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.id	1	100.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.04 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.01 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.06 ms
preparing	0.02 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.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
17	JDatabaseDriver->loadResult()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:340
16	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount()	JROOT/libraries/src/MVC/Model/ListModel.php:282
15	Joomla\CMS\MVC\Model\ListModel->getTotal()	JROOT/libraries/src/MVC/Model/ListModel.php:232
14	Joomla\CMS\MVC\Model\ListModel->getPagination()	JROOT/components/com_content/models/category.php:265
13	ContentModelCategory->getItems()	JROOT/libraries/src/MVC/View/HtmlView.php:425
12	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/libraries/src/MVC/View/CategoryView.php:144
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 4.808 MB Zeilen zurückgegeben: 0

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

  FROM `jospp_contentitem_tag_map` AS m 

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

  WHERE `m`.`type_alias` = 'com_content.category' 
  AND `m`.`content_item_id` = 2 
  AND `t`.`published` = 1 
  AND t.access IN (1,1,5)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ALL	idx_tag_type	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	100.00	Using where
1	SIMPLE	t	NULL	eq_ref	PRIMARY,tag_idx,idx_access	PRIMARY	4	meinwerb_joom980.m.tag_id	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 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.00 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
13	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
12	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/libraries/src/MVC/View/CategoryView.php:229
11	Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay()	JROOT/components/com_content/views/category/view.html.php:75
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.51 ms Nach letzter Abfrage: 6.43 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 4.918 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 jospp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_content.article' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  AND a.access IN (1,1,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 ASC

Erklären

id	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	meinwerb_joom980.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.id	1	100.00	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.07 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.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.07 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.00 ms
closing tables	0.01 ms
freeing items	0.01 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
17	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
16	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
15	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
14	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
13	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
12	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
11	JEventDispatcher->trigger()	JROOT/components/com_content/views/category/view.html.php:113
10	ContentViewCategory->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:672
9	Joomla\CMS\MVC\Controller\BaseController->display()	JROOT/components/com_content/controller.php:118
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php:710
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:196
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.46 ms Nach letzter Abfrage: 23.96 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 5.257 MB Zeilen zurückgegeben: 10

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

  FROM jospp_modules AS m

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

  LEFT JOIN jospp_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 <= '2019-06-25 06:19:46') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-06-25 06:19:46') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 188 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	m	NULL	ref	PRIMARY,published,newsfeeds	published	1	const	16	3.12	Using index condition; Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	ref	element_clientid,element_folder_clientid	element_clientid	403	meinwerb_joom980.m.module,const	1	10.00	Using index condition; Using where
1	SIMPLE	mm	NULL	ref	PRIMARY	PRIMARY	4	meinwerb_joom980.m.id	1	40.00	Using where; Using index

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.01 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.06 ms
preparing	0.02 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
28	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
27	JDatabaseDriver->loadObjectList()	Der selbe Aufruf in der Zeile darunter.
26	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
25	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
24	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
23	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
22	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
21	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/Modules.php:140
20	YOOtheme\Theme\Modules->countModules()	Der selbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:74
18	YOOtheme\View->__call()	JROOT/templates/yootheme/templates/header-mobile.php:43
17	require JROOT/templates/yootheme/templates/header-mobile.php	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:249
16	YOOtheme\View->evaluate()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/index.php:50
15	YOOtheme\Module->{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
14	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/theme/src/Theme.php:114
13	YOOtheme\Theme->replace()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:145
12	YOOtheme\View->YOOtheme\{closure}()	JROOT/templates/yootheme/vendor/yootheme/framework/modules/view/src/View.php:217
11	YOOtheme\View->render()	Der selbe Aufruf in der Zeile darunter.
10	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
9	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:111
8	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/templates/yootheme/index.php:51
7	require JROOT/templates/yootheme/index.php	JROOT/libraries/src/Document/HtmlDocument.php:658
6	Joomla\CMS\Document\HtmlDocument->_loadTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:720
5	Joomla\CMS\Document\HtmlDocument->_fetchTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:535
4	Joomla\CMS\Document\HtmlDocument->parse()	JROOT/libraries/src/Application/CMSApplication.php:1030
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.57 ms Nach letzter Abfrage: 10.27 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.484 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 jospp_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'mod_custom.content' 
  AND (fc.category_id IS NULL OR fc.category_id IN (2,0)) 
  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 ASC

Erklären

id	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	meinwerb_joom980.a.language	1	100.00	Using where
1	SIMPLE	uc	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.checked_out	1	100.00	NULL
1	SIMPLE	ag	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.access	1	100.00	Using where
1	SIMPLE	ua	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.created_user_id	1	100.00	Using where
1	SIMPLE	g	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.group_id	1	100.00	Using where
1	SIMPLE	fc	NULL	ref	PRIMARY	PRIMARY	4	meinwerb_joom980.a.id	1	100.00	Using where; Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.09 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.00 ms
Opening tables	0.02 ms
init	0.04 ms
System lock	0.01 ms
optimizing	0.02 ms
statistics	0.08 ms
preparing	0.02 ms
Creating tmp table	0.03 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.10 ms
Creating sort index	0.02 ms
end	0.00 ms
query end	0.01 ms
removing tmp table	0.02 ms
query end	0.01 ms
closing tables	0.01 ms
freeing items	0.02 ms
cleaning up	0.01 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
23	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
22	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
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:187
19	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
18	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:488
17	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
16	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
15	JEventDispatcher->trigger()	JROOT/libraries/cms/html/content.php:41
14	JHtmlContent::prepare()	Der selbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/HTML/HTMLHelper.php:239
12	Joomla\CMS\HTML\HTMLHelper::call()	JROOT/libraries/src/HTML/HTMLHelper.php:146
11	Joomla\CMS\HTML\HTMLHelper::_()	JROOT/modules/mod_custom/mod_custom.php:15
10	include JROOT/modules/mod_custom/mod_custom.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/templates/yootheme/vendor/yootheme/theme/platforms/joomla-modules/src/ModulesRenderer.php:24
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php:491
6	Joomla\CMS\Document\HtmlDocument->getBuffer()	JROOT/libraries/src/Document/HtmlDocument.php:783
5	Joomla\CMS\Document\HtmlDocument->_renderTemplate()	JROOT/libraries/src/Document/HtmlDocument.php:557
4	Joomla\CMS\Document\HtmlDocument->render()	JROOT/libraries/src/Application/CMSApplication.php:1044
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 111.13 ms Nach letzter Abfrage: 4.04 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 5.538 MB

LOCK TABLES `jospp_extensions` WRITE

Erklären

„EXPLAIN“ unmöglich für Abfrage: LOCK TABLES `jospp_extensions` WRITE

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	111.05 ms
System lock	0.01 ms
query end	0.01 ms
closing tables	0.00 ms
freeing items	0.01 ms
cleaning up	0.00 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:548
8	JDatabaseDriverMysqli->lockTable()	JROOT/plugins/system/updatenotification/updatenotification.php:78
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 843.52 ms Nach letzter Abfrage: 0.08 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 5.542 MB

UPDATE `jospp_extensions`

  SET `params` = '{\"lastrun\":1561443589}'

  WHERE `type` = 'plugin' 
  AND `folder` = 'system' 
  AND `element` = 'updatenotification'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jospp_extensions	NULL	range	element_clientid,element_folder_clientid,extension	element_clientid	402	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.02 ms
checking permissions	0.00 ms
Opening tables	0.01 ms
init	0.05 ms
updating	0.04 ms
end	0.00 ms
Waiting for query cache lock	0.00 ms
end	0.01 ms
query end	843.20 ms
closing tables	0.05 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
8	JDatabaseDriverMysqli->execute()	JROOT/plugins/system/updatenotification/updatenotification.php:89
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.32 ms Nach letzter Abfrage: 625.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.562 MB

UNLOCK TABLES

Erklären

„EXPLAIN“ unmöglich für Abfrage: UNLOCK TABLES

Profil (Profile)

Status	Duration
starting	0.11 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver/mysqli.php:923
8	JDatabaseDriverMysqli->unlockTables()	JROOT/plugins/system/updatenotification/updatenotification.php:103
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 104.57 ms Nach letzter Abfrage: 375.31 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.637 MB Zeilen zurückgegeben: 1

SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query

  FROM `jospp_update_sites` AS `a`

  INNER JOIN jospp_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

  WHERE a.enabled = 1 
  AND b.extension_id IN (700)

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	a	NULL	ALL	PRIMARY	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	18	10.00	Using where; Using temporary
1	SIMPLE	b	NULL	eq_ref	PRIMARY	PRIMARY	8	meinwerb_joom980.a.update_site_id,const	1	100.00	Using index; Distinct

Profil (Profile)

Status	Duration
starting	0.05 ms
checking permissions	0.00 ms
checking permissions	0.00 ms
Opening tables	88.44 ms
init	0.07 ms
System lock	0.03 ms
optimizing	0.03 ms
statistics	0.07 ms
preparing	0.04 ms
Creating tmp table	0.10 ms
executing	0.02 ms
Sending data	15.34 ms
end	0.04 ms
query end	0.03 ms
removing tmp table	0.09 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1500
10	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Updater/Updater.php:240
9	Joomla\CMS\Updater\Updater->getUpdateSites()	JROOT/libraries/src/Updater/Updater.php:127
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 427.06 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 5.645 MB Zeilen zurückgegeben: 10

SELECT DISTINCT update_site_id

  FROM jospp_updates

  WHERE `update_site_id` IN (
SELECT update_site_id

  FROM jospp_update_sites

  WHERE `last_check_timestamp` IS NULL OR `last_check_timestamp` <= '1561421991')

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_updates	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	367	100.00	Using where; Using temporary
1	SIMPLE	jospp_update_sites	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.jospp_updates.update_site_id	1	40.00	Using where; Distinct

Profil (Profile)

Status	Duration
starting	0.12 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	22.12 ms
init	0.08 ms
System lock	0.02 ms
optimizing	0.04 ms
statistics	0.06 ms
preparing	0.04 ms
Creating tmp table	0.05 ms
executing	0.02 ms
Sending data	404.09 ms
end	0.03 ms
query end	0.03 ms
removing tmp table	0.03 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.07 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1544
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Updater/Updater.php:411
9	Joomla\CMS\Updater\Updater->getSitesWithUpdates()	JROOT/libraries/src/Updater/Updater.php:140
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.67 ms Nach letzter Abfrage: 48.65 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 5.655 MB Zeilen zurückgegeben: 1

SELECT `name`

  FROM `jospp_update_sites`

  WHERE `update_site_id` = '1'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_update_sites	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.11 ms
checking permissions	0.02 ms
Opening tables	0.06 ms
init	0.05 ms
System lock	0.04 ms
optimizing	0.03 ms
statistics	0.08 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.03 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
13	JDatabaseDriver->loadResult()	JROOT/libraries/src/Updater/UpdateAdapter.php:195
12	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteName()	JROOT/libraries/src/Updater/UpdateAdapter.php:222
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 461.13 ms Nach letzter Abfrage: 0.19 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.662 MB

UPDATE `jospp_update_sites`

  SET `enabled` = '0'

  WHERE `update_site_id` = '1'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jospp_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.03 ms
System lock	0.06 ms
updating	0.10 ms
end	0.03 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	460.56 ms
closing tables	0.05 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:245
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 186.10 ms Nach letzter Abfrage: 635.63 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.678 MB

UPDATE `jospp_update_sites`

  SET `enabled` = '1'

  WHERE `update_site_id` = '1'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jospp_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.13 ms
checking permissions	0.02 ms
Opening tables	0.04 ms
init	0.05 ms
System lock	0.08 ms
updating	0.11 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.03 ms
query end	185.40 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/UpdateAdapter.php:160
12	Joomla\CMS\Updater\UpdateAdapter->toggleUpdateSite()	JROOT/libraries/src/Updater/UpdateAdapter.php:265
11	Joomla\CMS\Updater\UpdateAdapter->getUpdateSiteResponse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:232
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.59 ms Nach letzter Abfrage: 27.03 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.686 MB Zeilen zurückgegeben: 14

SHOW FULL COLUMNS 
  FROM `jospp_updates`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.32 ms
init	0.03 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.03 ms
Opening tables	0.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
Sending data	0.15 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.01 ms
removing tmp table	0.08 ms
closing tables	0.02 ms
freeing items	0.06 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
17	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
16	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
15	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Update.php:32
14	Joomla\CMS\Table\Update->__construct()	JROOT/libraries/src/Table/Table.php:312
13	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:126
12	Joomla\CMS\Updater\Adapter\CollectionAdapter->_startElement()	Der selbe Aufruf in der Zeile darunter.
11	xml_parse()	JROOT/libraries/src/Updater/Adapter/CollectionAdapter.php:243
10	Joomla\CMS\Updater\Adapter\CollectionAdapter->findUpdate()	JROOT/libraries/src/Updater/Updater.php:278
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.61 ms Nach letzter Abfrage: 13.39 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 5.726 MB Zeilen zurückgegeben: 18

SHOW FULL COLUMNS 
  FROM `jospp_extensions`

Erklären

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

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
checking permissions	0.02 ms
Opening tables	0.28 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.03 ms
preparing	0.02 ms
executing	0.03 ms
Opening tables	0.03 ms
checking permissions	0.07 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.02 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
checking permissions	0.03 ms
Sending data	0.17 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
removing tmp table	0.07 ms
closing tables	0.04 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
14	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
13	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
12	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/Extension.php:32
11	Joomla\CMS\Table\Extension->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/Updater/Updater.php:322
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 1.66 ms Nach letzter Abfrage: 0.39 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 5.767 MB Zeilen zurückgegeben: 272

SELECT `update_id`

  FROM `jospp_updates`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_updates	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	367	0.27	Using where

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.03 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	1.04 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.03 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Update.php:114
10	Joomla\CMS\Table\Update->find()	JROOT/libraries/src/Updater/Updater.php:330
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.73 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 5.772 MB Zeilen zurückgegeben: 1

SELECT `extension_id`

  FROM `jospp_extensions`

  WHERE element = 'joomla' 
  AND type = 'file' 
  AND client_id = '0' 
  AND folder = ''

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_extensions	NULL	ref	element_clientid,element_folder_clientid,extension	extension	887	const,const,const,const	1	100.00	Using index

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
optimizing	0.03 ms
statistics	0.19 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.06 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1734
11	JDatabaseDriver->loadResult()	JROOT/libraries/src/Table/Extension.php:124
10	Joomla\CMS\Table\Extension->find()	JROOT/libraries/src/Updater/Updater.php:340
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.52 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.777 MB Zeilen zurückgegeben: 1

SELECT *

  FROM jospp_updates

  WHERE `update_id` = '3'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	jospp_updates	NULL	const	PRIMARY	PRIMARY	4	const	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.02 ms
Opening tables	0.02 ms
init	0.05 ms
System lock	0.02 ms
optimizing	0.02 ms
statistics	0.07 ms
preparing	0.03 ms
executing	0.02 ms
Sending data	0.05 ms
end	0.02 ms
query end	0.02 ms
closing tables	0.02 ms
freeing items	0.04 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1459
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/libraries/src/Updater/Updater.php:367
9	Joomla\CMS\Updater\Updater->getUpdateObjectsForSite()	JROOT/libraries/src/Updater/Updater.php:159
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 102.38 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.780 MB

INSERT INTO `jospp_updates`
(`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES 
('1','Joomla','','joomla','file','','0','3.9.8','','https://update.joomla.org/core/sts/extension_sts.xml','','')

Erklären

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `jospp_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) VALUES ('1','Joomla','','joomla','file','','0','3.9.8','','https://update.joomla.org/core/sts/extension_sts.xml','','')

Profil (Profile)

Status	Duration
starting	0.10 ms
checking permissions	0.02 ms
Opening tables	0.03 ms
init	0.04 ms
System lock	0.02 ms
update	0.11 ms
Waiting for query cache lock	0.02 ms
update	0.02 ms
end	0.02 ms
query end	101.77 ms
closing tables	0.03 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1415
10	JDatabaseDriver->insertObject()	JROOT/libraries/src/Table/Table.php:805
9	Joomla\CMS\Table\Table->store()	JROOT/libraries/src/Updater/Updater.php:169
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 103.47 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 5.782 MB

UPDATE `jospp_update_sites`

  SET `last_check_timestamp` = '1561443593'

  WHERE `update_site_id` = '1'

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	UPDATE	jospp_update_sites	NULL	range	PRIMARY	PRIMARY	4	const	1	100.00	Using where

Profil (Profile)

Status	Duration
starting	0.07 ms
checking permissions	0.02 ms
Opening tables	0.05 ms
init	0.04 ms
System lock	0.06 ms
updating	0.10 ms
end	0.02 ms
Waiting for query cache lock	0.02 ms
end	0.02 ms
query end	102.90 ms
closing tables	0.04 ms
freeing items	0.05 ms
cleaning up	0.02 ms

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Updater/Updater.php:440
9	Joomla\CMS\Updater\Updater->updateLastCheckTimestamp()	JROOT/libraries/src/Updater/Updater.php:174
8	Joomla\CMS\Updater\Updater->findUpdates()	JROOT/plugins/system/updatenotification/updatenotification.php:122
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

Abfragezeit: 0.38 ms Nach letzter Abfrage: 140.18 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 5.794 MB Zeilen zurückgegeben: 1

SELECT u.*,`e`.`manifest_cache`

  FROM `jospp_updates` AS `u`

  LEFT JOIN `jospp_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

  WHERE `u`.`extension_id` != '0' 
  AND `u`.`extension_id` = '700'

  ORDER BY `u`.`name` asc 
  LIMIT 20

Erklären

id	select_type	table	partitions	type	possible_keys	key	key_len	ref	rows	filtered	Extra
1	SIMPLE	u	NULL	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	367	9.00	Using where; filesort wurde genutzt
1	SIMPLE	e	NULL	eq_ref	PRIMARY	PRIMARY	4	meinwerb_joom980.u.extension_id	1	100.00	NULL

Profil (Profile)

Status	Duration
starting	0.06 ms
checking permissions	0.01 ms
checking permissions	0.00 ms
Opening tables	0.02 ms
init	0.02 ms
System lock	0.01 ms
optimizing	0.01 ms
statistics	0.02 ms
preparing	0.01 ms
Sorting result	0.01 ms
executing	0.00 ms
Sending data	0.01 ms
Creating sort index	0.14 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

Aufrufstapel (Call Stack)

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1695
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_installer/models/update.php:217
9	InstallerModelUpdate->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
8	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/plugins/system/updatenotification/updatenotification.php:136
7	PlgSystemUpdatenotification->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:1050
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:202
1	Joomla\CMS\Application\CMSApplication->execute()	JROOT/index.php:49

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

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

SELECT-Tabellen:

8 × SELECT `m`.`tag_id`,`t`.* 
  FROM `jospp_contentitem_tag_map` AS m  
  INNER JOIN `jospp_tags` AS t  
  ON `m`.`tag_id` = `t`.`id`

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

2 × 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 jospp_fields AS a 
  LEFT JOIN `jospp_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN jospp_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN jospp_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN jospp_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN jospp_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `jospp_fields_categories` AS fc 
  ON fc.field_id = a.id

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

1 × SELECT `data` 
  FROM `jospp_session`

```
1 × SELECT * 
  FROM jospp_updates
```

1 × SELECT `extension_id` 
  FROM `jospp_extensions`

1 × SELECT `update_id` 
  FROM `jospp_updates`

1 × SELECT `name` 
  FROM `jospp_update_sites`

1 × SELECT DISTINCT update_site_id 
  FROM jospp_updates

1 × SELECT DISTINCT a.update_site_id, a.type, a.location, a.last_check_timestamp, a.extra_query 
  FROM `jospp_update_sites` AS `a` 
  INNER JOIN jospp_update_sites_extensions AS b 
  ON a.update_site_id = b.update_site_id

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

1 × SELECT COUNT(*) 
  FROM jospp_content AS a 
  LEFT JOIN jospp_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN jospp_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN jospp_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN jospp_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN jospp_content_rating AS v 
  ON a.id = v.content_id

1 × 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,( SELECT COUNT(i.`id`) 
  FROM `jospp_content` AS `i`

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

1 × SELECT `session_id` 
  FROM `jospp_session`

```
1 × SELECT * 
  FROM jospp_languages
```

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

1 × 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 `jospp_categories` AS `s` 
  INNER JOIN `jospp_categories` AS `c` 
  ON (s.lft <= c.lft 
  AND c.lft < s.rgt) OR (c.lft < s.lft 
  AND s.rgt < c.rgt)

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 jospp_menu AS m 
  LEFT JOIN jospp_extensions AS e 
  ON m.component_id = e.extension_id

1 × SELECT * 
  FROM jospp_rsform_confi

1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id` 
  FROM jospp_extensions

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

1 × SELECT id, rules 
  FROM `jospp_viewlevels

1 × SELECT u.*,`e`.`manifest_cache` 
  FROM `jospp_updates` AS `u` 
  LEFT JOIN `jospp_extensions` AS `e` 
  ON `e`.`extension_id` = `u`.`extension_id`

Andere Tabellen:

1 × INSERT INTO `jospp_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  ('d01d4afa984e274d257aa3a48b4698a7', 1, 1561443585, 0, '', 0

1 × UPDATE `jospp_extensions` 
  SET `params` = '{\"mediaversion\":\"f67dd295648958694a8c25080fdde998\"}'

1 × LOCK TABLES `jospp_extensions` WRIT

1 × UPDATE `jospp_extensions` 
  SET `params` = '{\"lastrun\":1561443589}'

```
1 × UNLOCK TABLE
```

1 × UPDATE `jospp_update_sites` 
  SET `enabled` = '0'

1 × UPDATE `jospp_update_sites` 
  SET `enabled` = '1'

1 × SHOW FULL COLUMNS 
  FROM `jospp_updates

1 × SHOW FULL COLUMNS 
  FROM `jospp_extensions

1 × INSERT INTO `jospp_updates` (`update_site_id`,`name`,`description`,`element`,`type`,`folder`,`client_id`,`version`,`data`,`detailsurl`,`infourl`,`extra_query`) 
  VALUES  ('1','Joomla','','joomla','file','','0','3.9.8','','https://update.joomla.org/core/sts/extension_sts.xml','',''

1 × UPDATE `jospp_update_sites` 
  SET `last_check_timestamp` = '1561443593'