AGPV - Landesausbilderseminar Voltigieren

Das nächste Landesausbilderseminar findet statt am

11. November 2017 in Bad Kreuznach
9:00 bis 16:00 Uhr

unter der Leitung des Fachbeirats Voltigieren Rheinland-Pfalz.

Eingeladen sind alle Trainer und Ausbilder, Richter und Interessierte.

Themen:

Änderungen LPO 2018/Aufgabenheft 2018
Nennung Online (NeOn)
Kürgestaltung

Kosten: 30 Euro pro Person
Ort: DEULA, Bad Kreuznach
Anmeldeschluss: 27.10.2017

Einladung Landesausbilderseminar 2017

Anmeldung Landesausbilderseminar 2017

Details: Zuletzt aktualisiert: 03. September 2017

Cookies erleichtern die Bereitstellung unserer Dienste. Mit der Nutzung unserer Dienste erklären Sie sich damit einverstanden, dass wir Cookies verwenden.

Weitere Informationen Ok

Joomla!-Debug-Konsole

Sitzung

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

Profil zum Laufzeitverhalten

Zeit

Speicher

Zeit: 19.69 ms / 19.69 ms Speicher: 0.512 MB / 0.88 MB Application: afterLoad

Zeit: 468.94 ms / 488.63 ms Speicher: 1.342 MB / 2.22 MB Application: afterInitialise

Zeit: 22.27 ms / 510.90 ms Speicher: 0.365 MB / 2.59 MB Application: afterRoute

Zeit: 119.42 ms / 630.32 ms Speicher: 0.063 MB / 2.65 MB Application: beforeRenderComponent com_content

Zeit: 3.27 ms / 633.59 ms Speicher: 0.048 MB / 2.70 MB Application: Before Access::preloadComponents (all components)

Zeit: 2.81 ms / 636.40 ms Speicher: 0.056 MB / 2.76 MB Application: After Access::preloadComponents (all components)

Zeit: 0.03 ms / 636.43 ms Speicher: 0.060 MB / 2.82 MB Application: Before Access::preloadPermissions (com_content)

Zeit: 3.58 ms / 640.01 ms Speicher: 0.207 MB / 3.03 MB Application: After Access::preloadPermissions (com_content)

Zeit: 0.03 ms / 640.04 ms Speicher: 0.000 MB / 3.01 MB Application: Before Access::getAssetRules (id:314 name:com_content.article.199)

Zeit: 0.63 ms / 640.67 ms Speicher: 0.010 MB / 3.02 MB Application: After Access::getAssetRules (id:314 name:com_content.article.199)

Zeit: 163.62 ms / 804.29 ms Speicher: 0.431 MB / 3.46 MB Application: afterRenderComponent com_content

Zeit: 4.57 ms / 808.86 ms Speicher: 0.010 MB / 3.47 MB Application: afterDispatch

Zeit: 5.78 ms / 814.64 ms Speicher: 0.055 MB / 3.52 MB Application: beforeRenderModule mod_jshareeasy (jShareEasy)

Zeit: 1.54 ms / 816.18 ms Speicher: 0.088 MB / 3.61 MB Application: afterRenderModule mod_jshareeasy (jShareEasy)

Zeit: 0.04 ms / 816.21 ms Speicher: 0.000 MB / 3.60 MB Application: beforeRenderModule mod_menu (Footermenu)

Zeit: 2.56 ms / 818.78 ms Speicher: 0.021 MB / 3.63 MB Application: afterRenderModule mod_menu (Footermenu)

Zeit: 0.06 ms / 818.83 ms Speicher: 0.000 MB / 3.62 MB Application: beforeRenderModule mod_menu (Menü)

Zeit: 2.40 ms / 821.23 ms Speicher: 0.058 MB / 3.68 MB Application: afterRenderModule mod_menu (Menü)

Zeit: 0.03 ms / 821.27 ms Speicher: 0.000 MB / 3.68 MB Application: beforeRenderModule mod_finder (Suche)

Zeit: 18.43 ms / 839.69 ms Speicher: 0.057 MB / 3.74 MB Application: afterRenderModule mod_finder (Suche)

Zeit: 0.03 ms / 839.73 ms Speicher: 0.000 MB / 3.73 MB Application: beforeRenderModule mod_menu (Link Menü)

Zeit: 1.68 ms / 841.41 ms Speicher: 0.023 MB / 3.75 MB Application: afterRenderModule mod_menu (Link Menü)

Zeit: 0.05 ms / 841.45 ms Speicher: 0.000 MB / 3.75 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 1.55 ms / 843.01 ms Speicher: 0.013 MB / 3.76 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)

Zeit: 0.07 ms / 843.07 ms Speicher: 0.000 MB / 3.76 MB Application: beforeRenderModule mod_articles_latest (News)

Zeit: 1.42 ms / 844.49 ms Speicher: 0.036 MB / 3.79 MB Application: Before Access::getAssetRules (id:8 name:com_content)

Zeit: 0.05 ms / 844.54 ms Speicher: 0.007 MB / 3.80 MB Application: After Access::getAssetRules (id:8 name:com_content)

Zeit: 37.76 ms / 882.30 ms Speicher: 0.082 MB / 3.88 MB Application: afterRenderModule mod_articles_latest (News)

Zeit: 0.05 ms / 882.35 ms Speicher: 0.000 MB / 3.80 MB Application: beforeRenderModule mod_dpcalendar_upcoming (Nächste Veranstaltungen)

Zeit: 11.86 ms / 894.21 ms Speicher: 0.197 MB / 3.99 MB Application: Before Access::preloadPermissions (com_dpcalendar)

Zeit: 5.86 ms / 900.07 ms Speicher: 0.012 MB / 4.01 MB Application: After Access::preloadPermissions (com_dpcalendar)

Zeit: 0.02 ms / 900.09 ms Speicher: 0.000 MB / 4.01 MB Application: Before Access::getAssetRules (id:287 name:com_dpcalendar.category.25)

Zeit: 0.04 ms / 900.13 ms Speicher: 0.007 MB / 4.01 MB Application: After Access::getAssetRules (id:287 name:com_dpcalendar.category.25)

Zeit: 5.58 ms / 905.71 ms Speicher: 0.018 MB / 4.03 MB Application: Before Access::getAssetRules (id:291 name:com_dpcalendar.category.26)

Zeit: 0.02 ms / 905.73 ms Speicher: 0.002 MB / 4.03 MB Application: After Access::getAssetRules (id:291 name:com_dpcalendar.category.26)

Zeit: 5.55 ms / 911.28 ms Speicher: 0.021 MB / 4.05 MB Application: Before Access::getAssetRules (id:292 name:com_dpcalendar.category.27)

Zeit: 0.02 ms / 911.30 ms Speicher: 0.002 MB / 4.05 MB Application: After Access::getAssetRules (id:292 name:com_dpcalendar.category.27)

Zeit: 16.33 ms / 927.63 ms Speicher: 0.108 MB / 4.16 MB Application: Before Access::getAssetRules (id:286 name:com_dpcalendar)

Zeit: 0.02 ms / 927.65 ms Speicher: 0.002 MB / 4.16 MB Application: After Access::getAssetRules (id:286 name:com_dpcalendar)

Zeit: 52.88 ms / 980.53 ms Speicher: 0.138 MB / 4.30 MB Application: afterRenderModule mod_dpcalendar_upcoming (Nächste Veranstaltungen)

Zeit: 0.04 ms / 980.57 ms Speicher: 0.000 MB / 4.27 MB Application: beforeRenderModule mod_pro_facebook_widget (AGPV auf Facebook)

Zeit: 0.82 ms / 981.39 ms Speicher: 0.008 MB / 4.28 MB Application: afterRenderModule mod_pro_facebook_widget (AGPV auf Facebook)

Zeit: 0.07 ms / 981.46 ms Speicher: 0.000 MB / 4.27 MB Application: beforeRenderModule mod_menu (Hauptmenü)

Zeit: 2.12 ms / 983.58 ms Speicher: 0.078 MB / 4.35 MB Application: afterRenderModule mod_menu (Hauptmenü)

Zeit: 3.13 ms / 986.71 ms Speicher: 0.076 MB / 4.43 MB Application: afterRender

Datenbankabfragen gesamt: 779.94 ms

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

Error
MySql have_profiling = off

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
15	JDatabaseDriver->loadResult()	JROOT/libraries/joomla/session/storage/database.php:45
14	JSessionStorageDatabase->read()	Derselbe Aufruf in der Zeile darunter.
13	session_start()	JROOT/libraries/joomla/session/handler/native.php:260
12	JSessionHandlerNative->doSessionStart()	JROOT/libraries/joomla/session/handler/native.php:50
11	JSessionHandlerNative->start()	JROOT/libraries/joomla/session/handler/joomla.php:88
10	JSessionHandlerJoomla->start()	JROOT/libraries/src/Session/Session.php:660
9	Joomla\CMS\Session\Session->_start()	JROOT/libraries/src/Session/Session.php:620
8	Joomla\CMS\Session\Session->start()	JROOT/libraries/src/Session/Session.php:498
7	Joomla\CMS\Session\Session->get()	JROOT/libraries/src/Session/Session.php:455
6	Joomla\CMS\Session\Session->isNew()	JROOT/libraries/src/Application/CMSApplication.php: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

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

„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `agpvtest191_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'7239386539326b73696132646f356c65666731386a6365663569', 1, 1571815100, 0, '', 0)

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

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: 10.09 ms Nach letzter Abfrage: 2.29 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 1.301 MB Zeilen zurückgegeben: 40

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

  FROM `agpvtest191_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_extensions	ref	extension	extension	62	const	40	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
11	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Component/ComponentHelper.php:445
10	Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}()	Derselbe 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: 3.44 ms Nach letzter Abfrage: 1.70 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.348 MB Zeilen zurückgegeben: 5

SELECT id, rules

  FROM `agpvtest191_viewlevels`

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
9	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Access/Access.php:1063
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 4.50 ms Nach letzter Abfrage: 0.09 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 1.360 MB Zeilen zurückgegeben: 2

SELECT b.id

  FROM agpvtest191_usergroups AS a

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

  WHERE a.id = 9

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
10	JDatabaseDriver->loadColumn()	JROOT/libraries/src/Access/Access.php:980
9	Joomla\CMS\Access\Access::getGroupsByUser()	JROOT/libraries/src/Access/Access.php:1095
8	Joomla\CMS\Access\Access::getAuthorisedViewLevels()	JROOT/libraries/src/User/User.php:458
7	Joomla\CMS\User\User->getAuthorisedViewLevels()	JROOT/libraries/src/Plugin/PluginHelper.php: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: 6.18 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 1.382 MB Zeilen zurückgegeben: 93

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

  FROM agpvtest191_extensions

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

  ORDER BY ordering

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_extensions	ref	extension	extension	62	const	117	Using where; filesort wurde genutzt

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
10	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Plugin/PluginHelper.php:354
9	Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}()	Derselbe 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: 4.00 ms Nach letzter Abfrage: 8.44 ms Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 1.744 MB Zeilen zurückgegeben: 1

SELECT `enabled`

  FROM `agpvtest191_extensions`

  WHERE `element` = 'com_akeeba' 
  AND `type` = 'component'

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_extensions	ref	element_clientid,element_folder_clientid,extension	element_clientid	302	const	1	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
9	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1740
8	JDatabaseDriver->loadResult()	JROOT/plugins/system/backuponupdate/backuponupdate.php:36
7	require_once JROOT/plugins/system/backuponupdate/backuponupdate.php	JROOT/libraries/src/Plugin/PluginHelper.php:253
6	Joomla\CMS\Plugin\PluginHelper::import()	JROOT/libraries/src/Plugin/PluginHelper.php:182
5	Joomla\CMS\Plugin\PluginHelper::importPlugin()	JROOT/libraries/src/Application/CMSApplication.php:625
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: 2.21 ms Nach letzter Abfrage: 18.66 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 2.214 MB Zeilen zurückgegeben: 22

SELECT *

  FROM agpvtest191_rsform_config

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
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: 9.69 ms Nach letzter Abfrage: 3.18 ms Abfragespeichernutzung: 0.068 MB Speichernutzung vor Abfrage: 2.256 MB Zeilen zurückgegeben: 40

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

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

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

  ORDER BY m.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	idx_client_id_parent_id_alias_language	idx_client_id_parent_id_alias_language	1	const	47	Using where; filesort wurde genutzt
1	SIMPLE	e	eq_ref	PRIMARY	PRIMARY	4	DB23609.m.component_id	1

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Menu/SiteMenu.php:93
17	Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}()	Derselbe 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: 3.60 ms Nach letzter Abfrage: 10.38 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 2.608 MB Zeilen zurückgegeben: 1

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

  FROM `agpvtest191_extensions`

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_extensions	ref	element_clientid,element_folder_clientid,extension	extension	364	const,const	1	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/libraries/src/Helper/LibraryHelper.php:167
13	Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}()	Derselbe Aufruf in der Zeile darunter.
12	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
11	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/LibraryHelper.php:175
10	Joomla\CMS\Helper\LibraryHelper::loadLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:43
9	Joomla\CMS\Helper\LibraryHelper::getLibrary()	JROOT/libraries/src/Helper/LibraryHelper.php:90
8	Joomla\CMS\Helper\LibraryHelper::getParams()	JROOT/libraries/src/Version.php:321
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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: 110.10 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.599 MB

UPDATE `agpvtest191_extensions`

  SET `params` = '{\"mediaversion\":\"83075b3692ea00dd28d5f8d7995ea5a8\"}'

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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
10	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Helper/LibraryHelper.php:117
9	Joomla\CMS\Helper\LibraryHelper::saveParams()	JROOT/libraries/src/Version.php:372
8	Joomla\CMS\Version->setMediaVersion()	JROOT/libraries/src/Version.php:331
7	Joomla\CMS\Version->getMediaVersion()	JROOT/libraries/src/Factory.php:778
6	Joomla\CMS\Factory::createDocument()	JROOT/libraries/src/Factory.php:234
5	Joomla\CMS\Factory::getDocument()	JROOT/libraries/src/Application/WebApplication.php:1130
4	Joomla\CMS\Application\WebApplication->loadDocument()	JROOT/libraries/src/Application/SiteApplication.php:133
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: 1.16 ms Nach letzter Abfrage: 1.35 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.633 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agpvtest191_languages

  WHERE published=1

  ORDER BY ordering ASC

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
7	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
6	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Language/LanguageHelper.php:150
5	Joomla\CMS\Language\LanguageHelper::getLanguages()	JROOT/libraries/src/Application/SiteApplication.php:330
4	Joomla\CMS\Application\SiteApplication->getParams()	JROOT/libraries/src/Application/SiteApplication.php:138
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: 1.54 ms Nach letzter Abfrage: 0.31 ms Abfragespeichernutzung: 0.019 MB Speichernutzung vor Abfrage: 2.646 MB Zeilen zurückgegeben: 4

SELECT id, home, template, s.params

  FROM agpvtest191_template_styles as s

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

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

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	s	ALL	idx_template,idx_client_id,idx_client_id_home	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	6	Using where
1	SIMPLE	e	ref	element_clientid,element_folder_clientid,extension	element_clientid	303	DB23609.s.template,const	1	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
6	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
5	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Application/SiteApplication.php:486
4	Joomla\CMS\Application\SiteApplication->getTemplate()	JROOT/libraries/src/Application/SiteApplication.php:168
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: 2.62 ms Nach letzter Abfrage: 4.24 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 2.705 MB Zeilen zurückgegeben: 40

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

  FROM `agpvtest191_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_dpcalendar','com_fields','com_finder','com_installer','com_j2xml','com_jce','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocadownload','com_plugins','com_postinstall','com_privacy','com_redirect','com_rsform','com_search','com_tags','com_templates','com_users','com_wrapper')

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:429
16	Joomla\CMS\Access\Access::preloadComponents()	JROOT/libraries/src/Access/Access.php:213
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:531
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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: 3.16 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.059 MB Speichernutzung vor Abfrage: 2.818 MB Zeilen zurückgegeben: 248

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

  FROM `agpvtest191_assets`

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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
18	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
17	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
16	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
15	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
14	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
13	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
12	Joomla\CMS\User\User->authorise()	JROOT/components/com_content/models/article.php:58
11	ContentModelArticle->populateState()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:440
10	Joomla\CMS\MVC\Model\BaseDatabaseModel->getState()	JROOT/components/com_content/models/article.php:251
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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: 4.46 ms Nach letzter Abfrage: 2.08 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 3.030 MB Zeilen zurückgegeben: 31

SHOW FULL COLUMNS 
  FROM `agpvtest191_content`

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php: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/Content.php:39
11	Joomla\CMS\Table\Content->__construct()	JROOT/libraries/src/Table/Table.php:312
10	Joomla\CMS\Table\Table::getInstance()	JROOT/components/com_content/models/article.php:253
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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: 2.33 ms Nach letzter Abfrage: 3.62 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.081 MB Zeilen zurückgegeben: 1

SELECT *

  FROM agpvtest191_content

  WHERE `id` = '199'

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
12	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
11	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/Table.php:731
10	Joomla\CMS\Table\Table->load()	JROOT/components/com_content/models/article.php:254
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
8	ContentController->display()	JROOT/libraries/src/MVC/Controller/BaseController.php: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: 108.51 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 3.088 MB

UPDATE agpvtest191_content

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

  WHERE `id` = '199'

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
11	JDatabaseDriverMysqli->execute()	JROOT/libraries/src/Table/Table.php:1245
10	Joomla\CMS\Table\Table->hit()	JROOT/components/com_content/models/article.php:255
9	ContentModelArticle->hit()	JROOT/components/com_content/controller.php:113
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: 2.19 ms Nach letzter Abfrage: 1.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.112 MB Zeilen zurückgegeben: 1

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

  FROM agpvtest191_content AS a

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

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

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

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

  WHERE a.id = 199 
  AND c.published > 0 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-23 07:18:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-23 07:18:21') 
  AND (a.state = 1 OR a.state =2)

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
14	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
13	JDatabaseDriver->loadObject()	JROOT/components/com_content/models/article.php:151
12	ContentModelArticle->getItem()	JROOT/libraries/src/MVC/View/HtmlView.php:425
11	Joomla\CMS\MVC\View\HtmlView->get()	JROOT/components/com_content/views/article/view.html.php:42
10	ContentViewArticle->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: 1.74 ms Nach letzter Abfrage: 3.06 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 3.151 MB Zeilen zurückgegeben: 3

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

  FROM `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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 = 15

  ORDER BY c.lft

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
24	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
23	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
22	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
21	Joomla\CMS\Categories\Categories->get()	JROOT/components/com_content/router.php:72
20	ContentRouter->getCategorySegment()	Derselbe Aufruf in der Zeile darunter.
19	call_user_func_array()	JROOT/libraries/src/Component/Router/RouterView.php:120
18	Joomla\CMS\Component\Router\RouterView->getPath()	JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111
17	Joomla\CMS\Component\Router\Rules\MenuRules->preprocess()	JROOT/libraries/src/Component/Router/RouterView.php:222
16	Joomla\CMS\Component\Router\RouterView->preprocess()	JROOT/libraries/src/Router/SiteRouter.php:672
15	Joomla\CMS\Router\SiteRouter->processBuildRules()	JROOT/libraries/src/Router/Router.php:266
14	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
13	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
12	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
11	Joomla\CMS\Router\Route::_()	JROOT/components/com_content/views/article/view.html.php:71
10	ContentViewArticle->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: 1.37 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.244 MB Zeilen zurückgegeben: 0

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

  FROM `agpvtest191_contentitem_tag_map` AS m 

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

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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Helper/TagsHelper.php:454
11	Joomla\CMS\Helper\TagsHelper->getItemTags()	JROOT/components/com_content/views/article/view.html.php:184
10	ContentViewArticle->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: 3.86 ms Nach letzter Abfrage: 6.82 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.314 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 agpvtest191_fields AS a

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

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

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

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

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

  LEFT JOIN `agpvtest191_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 (15,0,14)) 
  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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php: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:495
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/article/view.html.php:193
10	ContentViewArticle->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: 1.10 ms Nach letzter Abfrage: 3.68 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.428 MB Zeilen zurückgegeben: 1

SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
  FROM agpvtest191_phocadownload AS a 
  LEFT JOIN agpvtest191_phocadownload_categories AS c 
  ON a.catid = c.id 
  WHERE a.id = 77

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/content/phocadownload/phocadownload.php:333
13	plgContentPhocaDownload->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/article/view.html.php:193
10	ContentViewArticle->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.98 ms Nach letzter Abfrage: 0.29 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.440 MB Zeilen zurückgegeben: 1

SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
  FROM agpvtest191_phocadownload AS a 
  LEFT JOIN agpvtest191_phocadownload_categories AS c 
  ON a.catid = c.id 
  WHERE a.id = 78

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1662
14	JDatabaseDriver->loadObject()	JROOT/plugins/content/phocadownload/phocadownload.php:333
13	plgContentPhocaDownload->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/article/view.html.php:193
10	ContentViewArticle->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: 2.73 ms Nach letzter Abfrage: 22.29 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.512 MB Zeilen zurückgegeben: 11

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

  FROM agpvtest191_modules AS m

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

  LEFT JOIN agpvtest191_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-10-23 07:18:21') 
  AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2019-10-23 07:18:21') 
  AND m.access IN (1,1,5) 
  AND m.client_id = 0 
  AND (mm.menuid = 110 OR mm.menuid <= 0)

  ORDER BY m.position, m.ordering

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	Derselbe Aufruf in der Zeile darunter.
13	call_user_func_array()	JROOT/libraries/src/Cache/Controller/CallbackController.php:173
12	Joomla\CMS\Cache\Controller\CallbackController->get()	JROOT/libraries/src/Helper/ModuleHelper.php:432
11	Joomla\CMS\Helper\ModuleHelper::getModuleList()	JROOT/libraries/src/Helper/ModuleHelper.php:362
10	Joomla\CMS\Helper\ModuleHelper::load()	JROOT/libraries/src/Helper/ModuleHelper.php:87
9	Joomla\CMS\Helper\ModuleHelper::getModules()	JROOT/libraries/src/Document/HtmlDocument.php:581
8	Joomla\CMS\Document\HtmlDocument->countModules()	JROOT/templates/protostar-agpv/index.php:94
7	require JROOT/templates/protostar-agpv/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: 1.24 ms Nach letzter Abfrage: 10.49 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 3.712 MB Zeilen zurückgegeben: 5

SELECT `name`,`element`

  FROM `agpvtest191_extensions`

  WHERE `type` = 'plugin' 
  AND `folder` = 'finder' 
  AND `enabled` = 1

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_extensions	ref	extension	extension	62	const	117	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
13	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
12	JDatabaseDriver->loadObjectList()	JROOT/administrator/components/com_finder/helpers/language.php:126
11	FinderHelperLanguage::loadPluginLanguage()	JROOT/modules/mod_finder/mod_finder.php:51
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 1.03 ms Nach letzter Abfrage: 4.57 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 3.734 MB Zeilen zurückgegeben: 5

SELECT `title`

  FROM `agpvtest191_finder_taxonomy`

  WHERE `parent_id` = 1 
  AND `state` = 1 
  AND `access` IN (1,1,5)

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	agpvtest191_finder_taxonomy	ref	parent_id,state,access,idx_parent_published	parent_id	4	const	5	Using where

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1550
15	JDatabaseDriver->loadColumn()	JROOT/administrator/components/com_finder/helpers/indexer/taxonomy.php:258
14	FinderIndexerTaxonomy::getBranchTitles()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:750
13	FinderIndexerQuery->processString()	JROOT/administrator/components/com_finder/helpers/indexer/query.php:236
12	FinderIndexerQuery->__construct()	JROOT/modules/mod_finder/helper.php:84
11	ModFinderHelper::getQuery()	JROOT/modules/mod_finder/mod_finder.php:54
10	include JROOT/modules/mod_finder/mod_finder.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 36.55 ms Nach letzter Abfrage: 14.53 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 3.802 MB Zeilen zurückgegeben: 5

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 agpvtest191_content AS a

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

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

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

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

  LEFT JOIN agpvtest191_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.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-23 07:18:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-23 07:18:21')

  ORDER BY a.created DESC 
  LIMIT 5

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
14	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
13	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_content/models/articles.php:576
12	ContentModelArticles->getItems()	JROOT/modules/mod_articles_latest/helper.php:123
11	ModArticlesLatestHelper::getList()	JROOT/modules/mod_articles_latest/mod_articles_latest.php:15
10	include JROOT/modules/mod_articles_latest/mod_articles_latest.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 6.73 ms Nach letzter Abfrage: 6.22 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 3.978 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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 25

  ORDER BY c.lft

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 5.75 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 3.994 MB Zeilen zurückgegeben: 5

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

  FROM `agpvtest191_assets`

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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
19	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
18	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Access/Access.php:359
17	Joomla\CMS\Access\Access::preloadPermissions()	JROOT/libraries/src/Access/Access.php:226
16	Joomla\CMS\Access\Access::preload()	JROOT/libraries/src/Access/Access.php:540
15	Joomla\CMS\Access\Access::getAssetRules()	JROOT/libraries/src/Access/Access.php:183
14	Joomla\CMS\Access\Access::check()	JROOT/libraries/src/User/User.php:398
13	Joomla\CMS\User\User->authorise()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:53
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 5.38 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 4.019 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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 26

  ORDER BY c.lft

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 5.34 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.040 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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 27

  ORDER BY c.lft

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
16	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
15	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
14	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
13	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
12	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/models/calendar.php:67
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 6.74 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.062 MB Zeilen zurückgegeben: 0

SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access

  FROM `agpvtest191_dpcalendar_caldav_calendarinstances` c

  LEFT 
  OUTER JOIN agpvtest191_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri

  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from agpvtest191_dpcalendar_caldav_principals memberp
				
  inner join agpvtest191_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id
				
  inner join agpvtest191_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp
				
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

  WHERE (mainp.external_id = 0 or mp.member_external_id = 0)

  ORDER BY c.displayname ASC 
  LIMIT 20

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	PRIMARY	<derived2>	system	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	0	const row not found
1	PRIMARY	c	ALL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	1	Using temporary; filesort wurde genutzt
1	PRIMARY	mainp	ALL	uri	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	12	Range checked for each record (index map: 0x2)
2	DERIVED	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	no matching row in const table

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
21	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
20	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
19	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
18	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/profile.php:36
17	DPCalendarModelProfile->getItems()	JROOT/plugins/system/dpcalendar/dpcalendar.php:308
16	PlgSystemDpcalendar->fetchCalendars()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Plugin/DPCalendarPlugin.php:435
15	DPCalendar\Plugin\DPCalendarPlugin->onCalendarsFetch()	JROOT/libraries/joomla/event/event.php:70
14	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
13	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
12	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/components/com_dpcalendar/models/calendar.php:93
11	DPCalendarModelCalendar->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:43
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 8.01 ms Nach letzter Abfrage: 0.60 ms Abfragespeichernutzung: 0.042 MB Speichernutzung vor Abfrage: 4.074 MB Zeilen zurückgegeben: 3

SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author

  FROM `agpvtest191_dpcalendar_events` AS a

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

  LEFT JOIN agpvtest191_dpcalendar_events_location AS rel 
  ON a.id = rel.event_id

  LEFT JOIN agpvtest191_dpcalendar_locations AS v 
  ON rel.location_id = v.id

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

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

  WHERE a.access IN (1,1,5) 
  AND a.original_id > -1 
  AND a.catid IN ('25','26','27') 
  AND (c.access IN (1,1,5) or c.access is null) 
  AND a.state = 1 
  AND a.state != -2 
  AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2019-10-23 07:18:21') 
  AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2019-10-23 07:18:21') 
  AND (a.start_date  >= '2019-10-23 07:15:00') 
  AND a.language in ('de-DE','*')

  GROUP BY a.id

  ORDER BY a.start_date asc 
  LIMIT 3

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	a	range	idx_access,idx_start_date,idx_state,idx_catid,idx_language	idx_start_date	8	NULL	5	Using where; Using temporary
1	SIMPLE	c	eq_ref	PRIMARY	PRIMARY	4	DB23609.a.catid	1	Using where
1	SIMPLE	rel	ref	PRIMARY	PRIMARY	4	DB23609.a.id	1	Using index
1	SIMPLE	v	eq_ref	PRIMARY	PRIMARY	4	DB23609.rel.location_id	1	Using index
1	SIMPLE	ua	eq_ref	PRIMARY	PRIMARY	4	DB23609.a.created_by	1
1	SIMPLE	uam	eq_ref	PRIMARY	PRIMARY	4	DB23609.a.modified_by	1	Using index

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
15	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
14	JDatabaseDriver->loadObjectList()	JROOT/components/com_dpcalendar/models/events.php:504
13	DPCalendarModelEvents->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
12	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/components/com_dpcalendar/models/events.php:108
11	DPCalendarModelEvents->getItems()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:91
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 6.01 ms Nach letzter Abfrage: 1.35 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.177 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 agpvtest191_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_dpcalendar.event' 
  AND (fc.category_id IS NULL OR fc.category_id IN (26,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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:131
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 3.46 ms Nach letzter Abfrage: 1.60 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.196 MB Zeilen zurückgegeben: 0

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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 100

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
22	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85
21	DPCalendarRouterLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
20	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_dpcalendar/router.php:70
19	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:58
12	DPCalendarHelperRoute::getEventRoute()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29
11	DPCalendar\Router\Router->getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 3.25 ms Nach letzter Abfrage: 3.43 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.209 MB Zeilen zurückgegeben: 0

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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 99

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
22	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85
21	DPCalendarRouterLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
20	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_dpcalendar/router.php:70
19	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:58
12	DPCalendarHelperRoute::getEventRoute()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29
11	DPCalendar\Router\Router->getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 5.57 ms Nach letzter Abfrage: 2.05 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 4.217 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 agpvtest191_fields AS a

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

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

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

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

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

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

  WHERE a.context = 'com_dpcalendar.event' 
  AND (fc.category_id IS NULL OR fc.category_id IN (25,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

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
20	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
19	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308
18	Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList()	JROOT/administrator/components/com_fields/models/fields.php:333
17	FieldsModelFields->_getList()	JROOT/libraries/src/MVC/Model/ListModel.php:187
16	Joomla\CMS\MVC\Model\ListModel->getItems()	JROOT/administrator/components/com_fields/helpers/fields.php:135
15	FieldsHelper::getFields()	JROOT/plugins/system/fields/fields.php:495
14	PlgSystemFields->onContentPrepare()	JROOT/libraries/joomla/event/event.php:70
13	JEvent->update()	JROOT/libraries/joomla/event/dispatcher.php:160
12	JEventDispatcher->trigger()	JROOT/libraries/src/Application/BaseApplication.php:108
11	Joomla\CMS\Application\BaseApplication->triggerEvent()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:131
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 2.71 ms Nach letzter Abfrage: 1.52 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 4.233 MB Zeilen zurückgegeben: 0

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 `agpvtest191_categories` AS `s`

  INNER JOIN `agpvtest191_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_dpcalendar' OR c.extension='system') 
  AND c.access IN (1,1,5) 
  AND c.published = 1 
  AND s.id = 101

  ORDER BY c.lft

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	NULL	NULL	NULL	ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN	NULL	NULL	NULL	Impossible WHERE noticed after reading const tables

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
26	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
25	JDatabaseDriver->loadObjectList()	JROOT/libraries/src/Categories/Categories.php:324
24	Joomla\CMS\Categories\Categories->_load()	JROOT/libraries/src/Categories/Categories.php:184
23	Joomla\CMS\Categories\Categories->get()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/DPCalendarHelper.php:41
22	DPCalendar\Helper\DPCalendarHelper::getCalendar()	JROOT/components/com_dpcalendar/helpers/legacyrouter.php:85
21	DPCalendarRouterLegacy->build()	JROOT/libraries/src/Component/Router/RouterView.php:244
20	Joomla\CMS\Component\Router\RouterView->build()	JROOT/components/com_dpcalendar/router.php:70
19	DPCalendarRouter->build()	JROOT/libraries/src/Router/SiteRouter.php:528
18	Joomla\CMS\Router\SiteRouter->buildSefRoute()	JROOT/libraries/src/Router/SiteRouter.php:498
17	Joomla\CMS\Router\SiteRouter->_buildSefRoute()	JROOT/libraries/src/Router/Router.php:281
16	Joomla\CMS\Router\Router->build()	JROOT/libraries/src/Router/SiteRouter.php:154
15	Joomla\CMS\Router\SiteRouter->build()	JROOT/libraries/src/Router/Route.php:144
14	Joomla\CMS\Router\Route::link()	JROOT/libraries/src/Router/Route.php:93
13	Joomla\CMS\Router\Route::_()	JROOT/components/com_dpcalendar/helpers/route.php:58
12	DPCalendarHelperRoute::getEventRoute()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Router/Router.php:29
11	DPCalendar\Router\Router->getEventRoute()	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:137
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 3.28 ms Nach letzter Abfrage: 8.75 ms Abfragespeichernutzung: 0.033 MB Speichernutzung vor Abfrage: 4.288 MB Zeilen zurückgegeben: 16

SHOW FULL COLUMNS 
  FROM `agpvtest191_users`

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
32	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1701
31	JDatabaseDriver->loadObjectList()	JROOT/libraries/joomla/database/driver/mysqli.php:445
30	JDatabaseDriverMysqli->getTableColumns()	JROOT/libraries/src/Table/Table.php:245
29	Joomla\CMS\Table\Table->getFields()	JROOT/libraries/src/Table/Table.php:164
28	Joomla\CMS\Table\Table->__construct()	JROOT/libraries/src/Table/User.php:40
27	Joomla\CMS\Table\User->__construct()	JROOT/libraries/src/Table/Table.php:312
26	Joomla\CMS\Table\Table::getInstance()	JROOT/libraries/src/User/User.php:603
25	Joomla\CMS\User\User::getTable()	JROOT/libraries/src/User/User.php:880
24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16
20	DPCalendar\Helper\UserHelper->getUser()	JROOT/components/com_dpcalendar/layouts/schema/performer.php:10
19	include JROOT/components/com_dpcalendar/layouts/schema/performer.php	JROOT/libraries/src/Layout/FileLayout.php:125
18	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
17	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
16	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/components/com_dpcalendar/layouts/schema/event.php:15
15	include JROOT/components/com_dpcalendar/layouts/schema/event.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
13	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
12	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:61
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 1.33 ms Nach letzter Abfrage: 0.12 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.321 MB Zeilen zurückgegeben: 1

SELECT *

  FROM `agpvtest191_users`

  WHERE `id` = 109

Explain

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

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1465
26	JDatabaseDriver->loadAssoc()	JROOT/libraries/src/Table/User.php:86
25	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16
20	DPCalendar\Helper\UserHelper->getUser()	JROOT/components/com_dpcalendar/layouts/schema/performer.php:10
19	include JROOT/components/com_dpcalendar/layouts/schema/performer.php	JROOT/libraries/src/Layout/FileLayout.php:125
18	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
17	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
16	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/components/com_dpcalendar/layouts/schema/event.php:15
15	include JROOT/components/com_dpcalendar/layouts/schema/event.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
13	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
12	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:61
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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: 1.10 ms Nach letzter Abfrage: 0.76 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 4.340 MB Zeilen zurückgegeben: 1

SELECT `g`.`id`,`g`.`title`

  FROM `agpvtest191_usergroups` AS g

  INNER JOIN `agpvtest191_user_usergroup_map` AS m 
  ON m.group_id = g.id

  WHERE `m`.`user_id` = 109

Explain

id	select_type	table	type	possible_keys	key	key_len	ref	rows	Extra
1	SIMPLE	m	ref	PRIMARY	PRIMARY	4	const	1	Using index
1	SIMPLE	g	eq_ref	PRIMARY	PRIMARY	4	DB23609.m.group_id	1

Profil (Profile)

Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)

Call Stack

#	Aufrufer	Datei und Zeilennummer
27	JDatabaseDriverMysqli->execute()	JROOT/libraries/joomla/database/driver.php:1506
26	JDatabaseDriver->loadAssocList()	JROOT/libraries/src/Table/User.php:111
25	Joomla\CMS\Table\User->load()	JROOT/libraries/src/User/User.php:883
24	Joomla\CMS\User\User->load()	JROOT/libraries/src/User/User.php:248
23	Joomla\CMS\User\User->__construct()	JROOT/libraries/src/User/User.php:301
22	Joomla\CMS\User\User::getInstance()	JROOT/libraries/src/Factory.php:266
21	Joomla\CMS\Factory::getUser()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/UserHelper.php:16
20	DPCalendar\Helper\UserHelper->getUser()	JROOT/components/com_dpcalendar/layouts/schema/performer.php:10
19	include JROOT/components/com_dpcalendar/layouts/schema/performer.php	JROOT/libraries/src/Layout/FileLayout.php:125
18	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
17	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
16	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/components/com_dpcalendar/layouts/schema/event.php:15
15	include JROOT/components/com_dpcalendar/layouts/schema/event.php	JROOT/libraries/src/Layout/FileLayout.php:125
14	Joomla\CMS\Layout\FileLayout->render()	JROOT/libraries/src/Layout/LayoutHelper.php:73
13	Joomla\CMS\Layout\LayoutHelper::render()	JROOT/administrator/components/com_dpcalendar/libraries/dpcalendar/DPCalendar/Helper/LayoutHelper.php:16
12	DPCalendar\Helper\LayoutHelper->renderLayout()	JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php:61
11	require JROOT/modules/mod_dpcalendar_upcoming/tmpl/default.php	JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php:168
10	include JROOT/modules/mod_dpcalendar_upcoming/mod_dpcalendar_upcoming.php	JROOT/libraries/src/Helper/ModuleHelper.php:200
9	Joomla\CMS\Helper\ModuleHelper::renderModule()	JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98
8	Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render()	JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47
7	Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render()	JROOT/libraries/src/Document/HtmlDocument.php: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]

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

SELECT-Tabellen:

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

3 × SELECT `id`,`name`,`rules`,`parent_id` 
  FROM `agpvtest191_assets`

3 × 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 agpvtest191_fields AS a 
  LEFT JOIN `agpvtest191_languages` AS l 
  ON l.lang_code = a.language 
  LEFT JOIN agpvtest191_users AS uc 
  ON uc.id=a.checked_out 
  LEFT JOIN agpvtest191_viewlevels AS ag 
  ON ag.id = a.access 
  LEFT JOIN agpvtest191_users AS ua 
  ON ua.id = a.created_user_id 
  LEFT JOIN agpvtest191_fields_groups AS g 
  ON g.id = a.group_id 
  LEFT JOIN `agpvtest191_fields_categories` AS fc 
  ON fc.field_id = a.id

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

2 × SELECT a.id, a.title, a.alias, a.filename_play, a.filename_preview, a.link_external, a.image_filename, a.filename, c.id as catid, a.confirm_license, c.title as cattitle, c.alias as catalias, 
  CASE WHEN CHAR_LENGTH(a.alias) THEN CONCAT_WS(':', a.id, a.alias) ELSE a.id END as slug, 
  CASE WHEN CHAR_LENGTH(c.alias) THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as catslug 
  FROM agpvtest191_phocadownload AS a 
  LEFT JOIN agpvtest191_phocadownload_categories AS c 
  ON a.catid = c.id

1 × SELECT `data` 
  FROM `agpvtest191_session`

1 × SELECT * 
  FROM `agpvtest191_users`

1 × SELECT a.*,GROUP_CONCAT(v.id SEPARATOR ', ') location_ids,
  CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author 
  FROM `agpvtest191_dpcalendar_events` AS a 
  LEFT JOIN agpvtest191_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN agpvtest191_dpcalendar_events_location AS rel 
  ON a.id = rel.event_id 
  LEFT JOIN agpvtest191_dpcalendar_locations AS v 
  ON rel.location_id = v.id 
  LEFT JOIN agpvtest191_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN agpvtest191_users AS uam 
  ON uam.id = a.modified_by

1 × SELECT c.*,mainp.uri as member_principal_uri, mainp.displayname as member_principal_name, mp.linkuri member_principal_access 
  FROM `agpvtest191_dpcalendar_caldav_calendarinstances` c 
  LEFT 
  OUTER JOIN agpvtest191_dpcalendar_caldav_principals mainp 
  on mainp.uri = c.principaluri 
  LEFT 
  OUTER JOIN (select memberp.external_id member_external_id, linkp.uri linkuri 
  from agpvtest191_dpcalendar_caldav_principals memberp     
  inner join agpvtest191_dpcalendar_caldav_groupmembers m 
  on memberp.id = m.member_id     
  inner join agpvtest191_dpcalendar_caldav_principals linkp 
  on m.principal_id = linkp.id) as mp     
  on mp.linkuri LIKE CONCAT(c.principaluri, '/%')

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 agpvtest191_content AS a 
  LEFT JOIN agpvtest191_categories AS c 
  ON c.id = a.catid 
  LEFT JOIN agpvtest191_users AS ua 
  ON ua.id = a.created_by 
  LEFT JOIN agpvtest191_users AS uam 
  ON uam.id = a.modified_by 
  LEFT JOIN agpvtest191_categories as parent 
  ON parent.id = c.parent_id 
  LEFT JOIN agpvtest191_content_rating AS v 
  ON a.id = v.content_id

1 × SELECT `title` 
  FROM `agpvtest191_finder_taxonomy`

1 × SELECT `name`,`element` 
  FROM `agpvtest191_extensions`

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

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

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

1 × SELECT `session_id` 
  FROM `agpvtest191_session`

1 × SELECT * 
  FROM agpvtest191_content

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

1 × SELECT * 
  FROM agpvtest191_languages

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

1 × SELECT * 
  FROM agpvtest191_rsform_confi

1 × SELECT `enabled` 
  FROM `agpvtest191_extensions`

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

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

1 × SELECT id, rules 
  FROM `agpvtest191_viewlevels

1 × SELECT `g`.`id`,`g`.`title` 
  FROM `agpvtest191_usergroups` AS g 
  INNER JOIN `agpvtest191_user_usergroup_map` AS m 
  ON m.group_id = g.id

Andere Tabellen:

1 × INSERT INTO `agpvtest191_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) 
  VALUES  (X'7239386539326b73696132646f356c65666731386a6365663569', 1, 1571815100, 0, '', 0

1 × UPDATE `agpvtest191_extensions` 
  SET `params` = '{\"mediaversion\":\"83075b3692ea00dd28d5f8d7995ea5a8\"}'

1 × SHOW FULL COLUMNS 
  FROM `agpvtest191_content

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

1 × SHOW FULL COLUMNS 
  FROM `agpvtest191_users

News

Nächste Veranstaltungen

AGPV auf Facebook

Landesausbilderseminar Voltigieren

Menü

Joomla!-Debug-Konsole

Sitzung

Profil zum Laufzeitverhalten

Zeit

Speicher

Speichernutzung

Datenbankabfragen

43 ausgeführte Abfragen 779.94 ms

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

SELECT-Tabellen:

Andere Tabellen: