Elbe-Elster Klinikum
In guten Händen.
In guten Händen.
**Joomla!-Debug-Konsole**
{
"__default": {
"session": {
"counter": 1,
"timer": {
"start": 1728891394,
"last": 1728891394,
"now": 1728891394
},
"token": "JbejIPOqrYHT38AVUMZvNqd8Pp37Yfgt"
},
"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
},
"jsn_mobilize_profile": null
}
}
**Zeit**
**Speicher**
**Zeit**: 14.90 ms / 14.90 ms **Speicher**: 2.024 MB / 2.43 MB Application: afterLoad
**Zeit**: 91.84 ms / 106.73 ms **Speicher**: 11.076 MB / 13.50 MB Application: afterInitialise
**Zeit**: 14.58 ms / 121.32 ms **Speicher**: 1.243 MB / 14.75 MB Application: afterRoute
**Zeit**: 0.63 ms / 121.95 ms **Speicher**: 0.031 MB / 14.78 MB Application: beforeRenderComponent com_content
**Zeit**: 3.74 ms / 125.68 ms **Speicher**: 0.351 MB / 15.13 MB Application: Before Access::preloadComponents (all components)
**Zeit**: 0.99 ms / 126.68 ms **Speicher**: 0.074 MB / 15.20 MB Application: After Access::preloadComponents (all components)
**Zeit**: 0.03 ms / 126.70 ms **Speicher**: -0.005 MB / 15.20 MB Application: Before Access::preloadPermissions (com_content)
**Zeit**: 2.94 ms / 129.64 ms **Speicher**: 0.313 MB / 15.51 MB Application: After Access::preloadPermissions (com_content)
**Zeit**: 0.03 ms / 129.68 ms **Speicher**: -0.019 MB / 15.49 MB Application: Before Access::getAssetRules (id:1357 name:com_content.article.276)
**Zeit**: 0.62 ms / 130.30 ms **Speicher**: 0.652 MB / 16.14 MB Application: After Access::getAssetRules (id:1357 name:com_content.article.276)
**Zeit**: 33.66 ms / 163.95 ms **Speicher**: 2.901 MB / 19.05 MB Application: afterRenderComponent com_content
**Zeit**: 0.54 ms / 164.49 ms **Speicher**: 0.053 MB / 19.10 MB Application: afterDispatch
**Zeit**: 69.43 ms / 233.92 ms **Speicher**: 6.398 MB / 25.50 MB Application: beforeRenderModule mod_menu (Information)
**Zeit**: 2.72 ms / 236.64 ms **Speicher**: 0.145 MB / 25.64 MB Application: afterRenderModule mod_menu (Information)
**Zeit**: 0.06 ms / 236.70 ms **Speicher**: -0.004 MB / 25.64 MB Application: beforeRenderModule mod_custom (Footer page info)
**Zeit**: 0.37 ms / 237.07 ms **Speicher**: 0.014 MB / 25.65 MB Application: afterRenderModule mod_custom (Footer page info)
**Zeit**: 0.05 ms / 237.12 ms **Speicher**: -0.000 MB / 25.65 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
**Zeit**: 0.92 ms / 238.04 ms **Speicher**: 0.047 MB / 25.70 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
**Zeit**: 0.05 ms / 238.09 ms **Speicher**: -0.004 MB / 25.70 MB Application: beforeRenderModule mod_breadcrumbs (Breadcrumbs)
**Zeit**: 0.45 ms / 238.54 ms **Speicher**: 0.025 MB / 25.72 MB Application: afterRenderModule mod_breadcrumbs (Breadcrumbs)
**Zeit**: 0.07 ms / 238.61 ms **Speicher**: -0.003 MB / 25.72 MB Application: beforeRenderModule mod_menu (Main Menu)
**Zeit**: 32.34 ms / 270.95 ms **Speicher**: 2.523 MB / 28.24 MB Application: afterRenderModule mod_menu (Main Menu)
**Zeit**: 0.09 ms / 271.04 ms **Speicher**: -0.016 MB / 28.22 MB Application: beforeRenderModule mod_search (Search)
**Zeit**: 1.22 ms / 272.25 ms **Speicher**: 0.034 MB / 28.26 MB Application: afterRenderModule mod_search (Search)
**Zeit**: 0.03 ms / 272.29 ms **Speicher**: -0.004 MB / 28.25 MB Application: beforeRenderModule mod_custom (EEKS und MVZ)
**Zeit**: 0.22 ms / 272.51 ms **Speicher**: 0.012 MB / 28.27 MB Application: afterRenderModule mod_custom (EEKS und MVZ)
**Zeit**: 26.50 ms / 299.01 ms **Speicher**: 3.600 MB / 31.87 MB Application: beforeRenderModule mod_custom (imagebilder_arbeitgeber)
**Zeit**: 0.24 ms / 299.25 ms **Speicher**: 0.022 MB / 31.89 MB Application: afterRenderModule mod_custom (imagebilder_arbeitgeber)
**Zeit**: 0.03 ms / 299.28 ms **Speicher**: -0.003 MB / 31.89 MB Application: beforeRenderModule mod_custom (imagebilder_arbeitgeber)
**Zeit**: 0.19 ms / 299.46 ms **Speicher**: 0.021 MB / 31.91 MB Application: afterRenderModule mod_custom (imagebilder_arbeitgeber)
**Zeit**: 2.98 ms / 302.44 ms **Speicher**: 0.017 MB / 31.92 MB Application: afterRender
**Datenbankabfragen gesamt: 31.45 ms**
33**,**01 MB (34**.**608**.**328 **Bytes**)
**129 ausgeführte Abfragen** 31.45 ms
**64 Duplikate gefunden!**
- **Abfragezeit: 0.20 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 4.198 MB** **Zeilen zurückgegeben: 0**
SELECT `data`
FROM `eek01n_session`
WHERE `session_id` = X'3236646431623038346435363330303461306665653134623466613164666137'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_session NULL const PRIMARY PRIMARY 194 const 1 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **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:661 9 Joomla\CMS\Session\Session->_start() JROOT/libraries/src/Session/Session.php:621 8 Joomla\CMS\Session\Session->start() JROOT/libraries/src/Session/Session.php:499 7 Joomla\CMS\Session\Session->get() JROOT/libraries/src/Session/Session.php:456 6 Joomla\CMS\Session\Session->isNew() JROOT/libraries/src/Application/CMSApplication.php:826 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Abfragezeit: 0.10 ms** **Nach letzter Abfrage: 1.09 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 4.294 MB** **Zeilen zurückgegeben: 0**
SELECT `session_id`
FROM `eek01n_session`
WHERE `session_id` = X'3236646431623038346435363330303461306665653134623466613164666137'
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_session NULL const PRIMARY PRIMARY 194 const 1 100.00 Using index **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 9 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 8 JDatabaseDriver->loadResult() JROOT/libraries/src/Session/MetadataManager.php:74 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Abfragezeit: 0.18 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 4.299 MB**
INSERT INTO `eek01n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES (X'3236646431623038346435363330303461306665653134623466613164666137', 1, 1728891394, 0, '', 0)**„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `eek01n_session` (`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES (X'3236646431623038346435363330303461306665653134623466613164666137', 1, 1728891394, 0, '', 0)****Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 8 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Session/MetadataManager.php:116 7 Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() JROOT/libraries/src/Application/CMSApplication.php:154 6 Joomla\CMS\Application\CMSApplication->checkSession() JROOT/libraries/src/Application/CMSApplication.php:828 5 Joomla\CMS\Application\CMSApplication->loadSession() JROOT/libraries/src/Application/CMSApplication.php:136 4 Joomla\CMS\Application\CMSApplication->__construct() JROOT/libraries/src/Application/SiteApplication.php:66 3 Joomla\CMS\Application\SiteApplication->__construct() JROOT/libraries/src/Application/CMSApplication.php:386 2 Joomla\CMS\Application\CMSApplication::getInstance() JROOT/libraries/src/Factory.php:140 1 Joomla\CMS\Factory::getApplication() JROOT/index.php:46 - **Abfragezeit: 0.22 ms** **Nach letzter Abfrage: 4.62 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.863 MB** **Zeilen zurückgegeben: 5**
SELECT id, rules
FROM `eek01n_viewlevels`id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_viewlevels NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 5 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 9 JDatabaseDriver->loadAssocList() JROOT/libraries/src/Access/Access.php:1063 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.17 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 4.875 MB** **Zeilen zurückgegeben: 2**
SELECT b.id
FROM eek01n_usergroups AS a
LEFT JOIN eek01n_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 9id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE b NULL range idx_usergroup_nested_set_lookup idx_usergroup_nested_set_lookup 4 NULL 2 100.00 Using where; Using index **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/src/Access/Access.php:980 9 Joomla\CMS\Access\Access::getGroupsByUser() JROOT/libraries/src/Access/Access.php:1095 8 Joomla\CMS\Access\Access::getAuthorisedViewLevels() JROOT/libraries/src/User/User.php:458 7 Joomla\CMS\User\User->getAuthorisedViewLevels() JROOT/libraries/src/Plugin/PluginHelper.php:318 6 Joomla\CMS\Plugin\PluginHelper::load() JROOT/libraries/src/Plugin/PluginHelper.php:87 5 Joomla\CMS\Plugin\PluginHelper::getPlugin() JROOT/libraries/src/Plugin/PluginHelper.php:129 4 Joomla\CMS\Plugin\PluginHelper::isEnabled() JROOT/libraries/src/Application/SiteApplication.php:604 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.20 ms** **Nach letzter Abfrage: 17.00 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 6.868 MB** **Zeilen zurückgegeben: 1**
SELECT `value`
FROM `eek01n_admintools_storage`
WHERE `key` = 'cparams'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_admintools_storage NULL const PRIMARY PRIMARY 402 const 1 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/administrator/components/com_admintools/Helper/Storage.php:122 12 Akeeba\AdminTools\Admin\Helper\Storage->load() JROOT/administrator/components/com_admintools/Helper/Storage.php:37 11 Akeeba\AdminTools\Admin\Helper\Storage->__construct() JROOT/administrator/components/com_admintools/Helper/Storage.php:49 10 Akeeba\AdminTools\Admin\Helper\Storage::getInstance() JROOT/plugins/system/admintools/admintools/main.php:409 9 plgSystemAdmintools->loadComponentParameters() JROOT/plugins/system/admintools/admintools/main.php:892 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.22 ms** **Nach letzter Abfrage: 1.25 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 6.984 MB** **Zeilen zurückgegeben: 0**
SELECT *
FROM `eek01n_admintools_wafexceptions`
WHERE NOT(`option` LIKE 'com_%')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_admintools_wafexceptions NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 1 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1506 11 JDatabaseDriver->loadAssocList() JROOT/plugins/system/admintools/admintools/main.php:729 10 plgSystemAdmintools->loadWAFExceptionsSEF() JROOT/plugins/system/admintools/admintools/main.php:640 9 plgSystemAdmintools->loadWAFExceptions() JROOT/plugins/system/admintools/admintools/main.php:901 8 plgSystemAdmintools->initialize() JROOT/plugins/system/admintools/admintools/main.php:84 7 plgSystemAdmintools->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.90 ms** **Nach letzter Abfrage: 16.32 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 8.607 MB** **Zeilen zurückgegeben: 192**
SHOW TABLES
**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES****Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 10 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 9 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68 8 JSNConfigHelper::get() JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98 7 plgSystemJsnpoweradmin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.13 ms** **Nach letzter Abfrage: 0.12 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 8.636 MB** **Zeilen zurückgegeben: 20**
SELECT name,value
FROM eek01n_jsn_poweradmin_config
WHERE 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_poweradmin_config NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 20 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 9 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81 8 JSNConfigHelper::get() JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:98 7 plgSystemJsnpoweradmin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.17 ms** **Nach letzter Abfrage: 0.98 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 8.675 MB** **Zeilen zurückgegeben: 1**
SELECT COUNT(*)
FROM eek01n_extensions
WHERE element="jsnadminbar"id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_extensions NULL ref element_clientid,element_folder_clientid element_clientid 402 const 1 100.00 Using index **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 10 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 9 JDatabaseDriver->loadResult() JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:913 8 plgSystemJsnpoweradmin->_removeAdminBarPlugin() JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:105 7 plgSystemJsnpoweradmin->__construct() JROOT/libraries/src/Plugin/PluginHelper.php:280 6 Joomla\CMS\Plugin\PluginHelper::import() JROOT/libraries/src/Plugin/PluginHelper.php:182 5 Joomla\CMS\Plugin\PluginHelper::importPlugin() JROOT/libraries/src/Application/CMSApplication.php:667 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.24 ms** **Nach letzter Abfrage: 15.88 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.518 MB** **Zeilen zurückgegeben: 0**
SELECT `source`,`keepurlparams`
FROM `eek01n_admintools_redirects`
WHERE ((`dest` = 'index.php/homepage1/karriere-ausbildung/facharztausbildung') OR (`dest` = 'index.php/homepage1/karriere-ausbildung/facharztausbildung') OR ('index.php/homepage1/karriere-ausbildung/facharztausbildung' LIKE `dest`))
AND `published` = '1'
ORDER BY `ordering` DESC
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_admintools_redirects NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 1 100.00 Using where; **filesort wurde genutzt** **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1773 11 JDatabaseDriver->loadRow() JROOT/plugins/system/admintools/feature/urlredir.php:91 10 AtsystemFeatureUrlredir->onAfterInitialise() JROOT/plugins/system/admintools/admintools/main.php:308 9 plgSystemAdmintools->runFeature() JROOT/plugins/system/admintools/admintools/main.php:144 8 plgSystemAdmintools->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.19 ms** **Nach letzter Abfrage: 0.78 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.596 MB** **Zeilen zurückgegeben: 1**
SELECT params
FROM eek01n_extensions
WHERE type = "plugin"
AND folder = "system"
AND element = 'jsnextfw'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_extensions NULL ref element_clientid,element_folder_clientid,extension element_folder_clientid 804 const,const 1 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 10 JDatabaseDriver->loadResult() JROOT/plugins/system/jsnextfw/includes/helper.php:169 9 JsnExtFwHelper::getSettings() JROOT/plugins/system/jsnextfw/jsnextfw.php:144 8 PlgSystemJsnExtFw->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.11 ms** **Nach letzter Abfrage: 0.17 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.608 MB** **Zeilen zurückgegeben: 1**
select email
from eek01n_users
where id=863
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_users NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/bfstop/helpers/db.php:307 12 BFStopDBHelper->getUserEmailWhere() JROOT/plugins/system/bfstop/helpers/db.php:320 11 BFStopDBHelper->getUserEmailByID() JROOT/plugins/system/bfstop/helpers/notify.php:23 10 BFStopNotifier->__construct() JROOT/plugins/system/bfstop/bfstop.php:197 9 plgSystembfstop->init() JROOT/plugins/system/bfstop/bfstop.php:369 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.13 ms** **Nach letzter Abfrage: 0.07 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.622 MB** **Zeilen zurückgegeben: 0**
SELECT id, ipaddress
from eek01n_bfstop_allowlist
WHERE (ipaddress='44.220.251.236'
AND LOCATE('/', ipaddress) = 0)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_bfstop_allowlist NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 3 33.33 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:224 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.17 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.634 MB** **Zeilen zurückgegeben: 0**
SELECT id, ipaddress
from eek01n_bfstop_allowlist
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('44.220.251.236') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_bfstop_allowlist NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 3 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:225 9 BFStopDBHelper->isIPOnAllowList() JROOT/plugins/system/bfstop/bfstop.php:388 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.18 ms** **Nach letzter Abfrage: 0.05 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 11.647 MB** **Zeilen zurückgegeben: 0**
SELECT id, ipaddress, crdate, duration
FROM eek01n_bfstop_bannedip b
WHERE (ipaddress='44.220.251.236'
AND LOCATE('/', ipaddress) = 0)
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-10-14 09:36:34')
AND NOT EXISTS (SELECT 1
FROM eek01n_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 28 10.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.b.id 1 100.00 Using index **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:214 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.22 ms** **Nach letzter Abfrage: 0.05 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 11.661 MB** **Zeilen zurückgegeben: 0**
SELECT id, ipaddress, crdate, duration
FROM eek01n_bfstop_bannedip b
WHERE ((LOCATE('/', ipaddress) != 0
AND LOCATE('.', ipaddress) != 0
AND (INET_ATON('44.220.251.236') & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1)) = (INET_ATON(SUBSTR(ipaddress, 1, LOCATE("/", ipaddress)-1)) & ~((1 << (32 - SUBSTR(ipaddress, LOCATE("/", ipaddress)+1, LENGTH(ipaddress)-LOCATE("/", ipaddress))))-1))))
AND (b.duration=0 OR DATE_ADD(b.crdate, INTERVAL b.duration MINUTE) >= '2024-10-14 09:36:34')
AND NOT EXISTS (SELECT 1
FROM eek01n_bfstop_unblock u
WHERE b.id = u.block_id)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 PRIMARY b NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 28 100.00 Using where 2 DEPENDENT SUBQUERY u NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.b.id 1 100.00 Using index **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/plugins/system/bfstop/helpers/db.php:188 10 BFStopDBHelper->checkForEntries() JROOT/plugins/system/bfstop/helpers/db.php:215 9 BFStopDBHelper->isIPBlocked() JROOT/plugins/system/bfstop/bfstop.php:392 8 plgSystembfstop->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.88 ms** **Nach letzter Abfrage: 1.52 ms** **Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 11.834 MB** **Zeilen zurückgegeben: 192**
SHOW TABLES
**„EXPLAIN“ unmöglich für Abfrage: SHOW TABLES****Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1550 11 JDatabaseDriver->loadColumn() JROOT/libraries/joomla/database/driver/mysqli.php:505 10 JDatabaseDriverMysqli->getTableList() JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:68 9 JSNConfigHelper::get() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.16 ms** **Nach letzter Abfrage: 0.11 ms** **Abfragespeichernutzung: 0.068 MB Speichernutzung vor Abfrage: 11.868 MB** **Zeilen zurückgegeben: 8**
SELECT name,value
FROM eek01n_jsn_mobilize_config
WHERE 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_mobilize_config NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 8 100.00 NULL **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 10 JDatabaseDriver->loadObjectList() JROOT/plugins/system/jsnframework/libraries/joomlashine/config/helper.php:81 9 JSNConfigHelper::get() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:114 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.22 ms** **Nach letzter Abfrage: 1.47 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.200 MB** **Zeilen zurückgegeben: 1**
SELECT *
FROM eek01n_jsn_mobilize_os
WHERE os_type = 'other'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_mobilize_os NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 12 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/templates/jsn_mobilize/helpers/mobilize.php:440 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.18 ms** **Nach letzter Abfrage: 0.20 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.214 MB** **Zeilen zurückgegeben: 0**
SELECT *
FROM eek01n_jsn_mobilize_profiles AS p
INNER JOIN eek01n_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 6 16.67 Using where 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.s.profile_id 1 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/templates/jsn_mobilize/helpers/mobilize.php:507 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.13 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 12.225 MB** **Zeilen zurückgegeben: 0**
SELECT *
FROM eek01n_jsn_mobilize_design
WHERE profile_id = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_mobilize_design NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 24 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/templates/jsn_mobilize/helpers/mobilize.php:514 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:144 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 1.45 ms** **Nach letzter Abfrage: 2.03 ms** **Abfragespeichernutzung: 0.259 MB Speichernutzung vor Abfrage: 12.488 MB** **Zeilen zurückgegeben: 190**
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 eek01n_menu AS m
LEFT JOIN eek01n_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.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_client_id_parent_id_alias_language **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 373 8.07 Using where; **filesort wurde genutzt** 1 SIMPLE e NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.m.component_id 1 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 23 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 22 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Menu/SiteMenu.php:93 21 Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() **Derselbe Aufruf in der Zeile darunter.** 20 call_user_func_array() JROOT/libraries/src/Cache/Controller/CallbackController.php:173 19 Joomla\CMS\Cache\Controller\CallbackController->get() JROOT/libraries/src/Menu/SiteMenu.php:101 18 Joomla\CMS\Menu\SiteMenu->load() JROOT/libraries/src/Menu/AbstractMenu.php:78 17 Joomla\CMS\Menu\AbstractMenu->__construct() JROOT/libraries/src/Menu/SiteMenu.php:62 16 Joomla\CMS\Menu\SiteMenu->__construct() JROOT/libraries/src/Menu/AbstractMenu.php:142 15 Joomla\CMS\Menu\AbstractMenu::getInstance() JROOT/libraries/src/Application/CMSApplication.php:417 14 Joomla\CMS\Application\CMSApplication->getMenu() JROOT/libraries/src/Application/SiteApplication.php:275 13 Joomla\CMS\Application\SiteApplication->getMenu() JROOT/libraries/src/Router/SiteRouter.php:65 12 Joomla\CMS\Router\SiteRouter->__construct() JROOT/libraries/src/Router/Router.php:189 11 Joomla\CMS\Router\Router::getInstance() JROOT/libraries/src/Application/CMSApplication.php:533 10 Joomla\CMS\Application\CMSApplication::getRouter() JROOT/libraries/src/Application/SiteApplication.php:403 9 Joomla\CMS\Application\SiteApplication::getRouter() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:170 8 PlgSystemJSNMobilize->onAfterInitialise() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:668 4 Joomla\CMS\Application\CMSApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:686 3 Joomla\CMS\Application\SiteApplication->initialiseApp() JROOT/libraries/src/Application/SiteApplication.php:212 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.35 ms** **Nach letzter Abfrage: 12.52 ms** **Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 14.097 MB**
UPDATE `eek01n_extensions`
SET `params` = '{\"mediaversion\":\"a9ef159b101eeef485911ba53330fa63\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE eek01n_extensions NULL range element_clientid,element_folder_clientid,extension extension 484 const,const 1 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Helper/LibraryHelper.php:117 13 Joomla\CMS\Helper\LibraryHelper::saveParams() JROOT/libraries/src/Version.php:372 12 Joomla\CMS\Version->setMediaVersion() JROOT/libraries/src/Version.php:331 11 Joomla\CMS\Version->getMediaVersion() JROOT/libraries/src/Factory.php:778 10 Joomla\CMS\Factory::createDocument() JROOT/libraries/src/Factory.php:234 9 Joomla\CMS\Factory::getDocument() JROOT/plugins/system/jsnpoweradmin/jsnpoweradmin.php:390 8 plgSystemJsnpoweradmin->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.22 ms** **Nach letzter Abfrage: 1.75 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.298 MB** **Zeilen zurückgegeben: 1**
SELECT *
FROM eek01n_jsn_mobilize_os
WHERE os_type = 'other'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_mobilize_os NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 12 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/templates/jsn_mobilize/helpers/mobilize.php:440 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 8 PlgSystemJSNMobilize->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.18 ms** **Nach letzter Abfrage: 0.20 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.312 MB** **Zeilen zurückgegeben: 0**
SELECT *
FROM eek01n_jsn_mobilize_profiles AS p
INNER JOIN eek01n_jsn_mobilize_os_support AS s
ON s.profile_id = p.profile_id
WHERE s.os_id = '11'
AND p.profile_state = 1
AND p.profile_device = "jsn_mobile"
LIMIT 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 6 16.67 Using where 1 SIMPLE p NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.s.profile_id 1 100.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 11 JDatabaseDriver->loadObject() JROOT/templates/jsn_mobilize/helpers/mobilize.php:507 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 8 PlgSystemJSNMobilize->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.12 ms** **Nach letzter Abfrage: 0.04 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.323 MB** **Zeilen zurückgegeben: 0**
SELECT *
FROM eek01n_jsn_mobilize_design
WHERE profile_id = ''id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_mobilize_design NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 24 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 11 JDatabaseDriver->loadObjectList() JROOT/templates/jsn_mobilize/helpers/mobilize.php:514 10 JSNMobilizeTemplateHelper::getOSSupport() JROOT/templates/jsn_mobilize/helpers/mobilize.php:85 9 JSNMobilizeTemplateHelper::getConfig() JROOT/plugins/system/jsnmobilize/jsnmobilize.php:282 8 PlgSystemJSNMobilize->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.25 ms** **Nach letzter Abfrage: 0.22 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.340 MB** **Zeilen zurückgegeben: 4**
SELECT id, home, template, s.params
FROM eek01n_template_styles as s
LEFT JOIN eek01n_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 = 1id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE e NULL ref element_clientid,element_folder_clientid,extension extension 82 const 7 1.00 Using index condition; Using where 1 SIMPLE s NULL ref idx_template,idx_client_id,idx_client_id_home idx_template 202 usr_web447_7.e.element 1 71.43 Using index condition; Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 13 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 12 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Application/SiteApplication.php:486 11 Joomla\CMS\Application\SiteApplication->getTemplate() JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:33 10 jsn_template_framework_class_loader() **Derselbe Aufruf in der Zeile darunter.** 9 spl_autoload_call() JROOT/plugins/system/jsntplframework/jsntplframework.php:187 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.13 ms** **Nach letzter Abfrage: 0.39 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 14.382 MB** **Zeilen zurückgegeben: 1**
SELECT manifest_cache
FROM eek01n_extensions
WHERE element LIKE 'jsn_reta_pro'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_extensions NULL range element_clientid,element_folder_clientid element_clientid 402 NULL 14 100.00 Using index condition **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 13 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:122 12 JSNTplHelper::getManifestCache() JROOT/plugins/system/jsntplframework/libraries/joomlashine/helper.php:217 11 JSNTplHelper::getTemplateVersion() JROOT/plugins/system/jsntplframework/libraries/joomlashine/loader.php:35 10 jsn_template_framework_class_loader() **Derselbe Aufruf in der Zeile darunter.** 9 spl_autoload_call() JROOT/plugins/system/jsntplframework/jsntplframework.php:187 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.20 ms** **Nach letzter Abfrage: 2.81 ms** **Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 14.742 MB** **Zeilen zurückgegeben: 1**
SELECT COUNT(*)
FROM eek01n_extensions
WHERE type = 'component'
AND element = 'com_sh404sef'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where **Kein „SHOW PROFILE“ (vielleicht weil es mehr als 100 Abfragen gab)**# **Aufrufer** **Datei und Zeilennummer** 12 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1740 11 JDatabaseDriver->loadResult() JROOT/plugins/system/jsntplframework/libraries/joomlashine/utils.php:1183 10 JSNTplUtils->checkSH404SEF() JROOT/plugins/system/jsntplframework/includes/core/jsntplframework.php:36 9 JSNTPLFramework::initial() JROOT/plugins/system/jsntplframework/jsntplframework.php:191 8 PlgSystemJSNTPLFramework->onAfterRoute() JROOT/libraries/joomla/event/event.php:70 7 JEvent->update() JROOT/libraries/joomla/event/dispatcher.php:160 6 JEventDispatcher->trigger() JROOT/libraries/src/Application/BaseApplication.php:108 5 Joomla\CMS\Application\BaseApplication->triggerEvent() JROOT/libraries/src/Application/CMSApplication.php:1190 4 Joomla\CMS\Application\CMSApplication->route() JROOT/libraries/src/Application/SiteApplication.php:796 3 Joomla\CMS\Application\SiteApplication->route() JROOT/libraries/src/Application/SiteApplication.php:218 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.18 ms** **Nach letzter Abfrage: 0.25 ms** **Abfragespeichernutzung: 0.020 MB Speichernutzung vor Abfrage: 14.765 MB** **Zeilen zurückgegeben: 2**
SELECT *
FROM eek01n_languages
WHERE published=1
ORDER BY ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_languages NULL ALL NULL **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 2 50.00 Using where; **filesort wurde genutzt** Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.02 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.01 ms preparing 0.01 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.01 ms Creating sort index 0.03 ms end 0.00 ms query end 0.02 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # **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:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.75 ms** **Nach letzter Abfrage: 4.15 ms** **Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 15.143 MB** **Zeilen zurückgegeben: 47**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `eek01n_assets`
WHERE `name` IN ('root.1','com_actionlogs','com_admin','com_admintools','com_ajax','com_akeeba','com_associations','com_banners','com_bfstop','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_easyslider','com_fields','com_finder','com_icagenda','com_imageshow','com_installer','com_jce','com_joomgallery','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_mobilize','com_modules','com_newsfeeds','com_osmap','com_otrsgateway','com_pagebuilder','com_plugins','com_postinstall','com_poweradmin','com_privacy','com_redirect','com_search','com_tags','com_templates','com_uniform','com_users','com_wrapper')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_assets NULL range idx_asset_name idx_asset_name 202 NULL 49 100.00 Using index condition Status Duration starting 0.05 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.14 ms preparing 0.01 ms executing 0.00 ms Sending data 0.40 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:429 16 Joomla\CMS\Access\Access::preloadComponents() JROOT/libraries/src/Access/Access.php:213 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:531 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 2.27 ms** **Nach letzter Abfrage: 0.24 ms** **Abfragespeichernutzung: 0.068 MB Speichernutzung vor Abfrage: 15.215 MB** **Zeilen zurückgegeben: 300**
SELECT `id`,`name`,`rules`,`parent_id`
FROM `eek01n_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_assets NULL ALL idx_asset_name,idx_parent_id **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 3220 20.56 Using where Status Duration starting 0.02 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.01 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.01 ms executing 0.00 ms Sending data 2.05 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Access/Access.php:359 16 Joomla\CMS\Access\Access::preloadPermissions() JROOT/libraries/src/Access/Access.php:226 15 Joomla\CMS\Access\Access::preload() JROOT/libraries/src/Access/Access.php:540 14 Joomla\CMS\Access\Access::getAssetRules() JROOT/libraries/src/Access/Access.php:183 13 Joomla\CMS\Access\Access::check() JROOT/libraries/src/User/User.php:398 12 Joomla\CMS\User\User->authorise() JROOT/components/com_content/models/article.php:58 11 ContentModelArticle->populateState() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:457 10 Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() JROOT/components/com_content/models/article.php:251 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.60 ms** **Nach letzter Abfrage: 1.89 ms** **Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 16.193 MB** **Zeilen zurückgegeben: 31**
SHOW FULL COLUMNS
FROM `eek01n_content`**„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `eek01n_content`**Status Duration starting 0.03 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.12 ms init 0.01 ms System lock 0.00 ms optimizing 0.00 ms statistics 0.01 ms preparing 0.01 ms executing 0.01 ms Opening tables 0.02 ms checking permissions 0.03 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms checking permissions 0.01 ms Sending data 0.08 ms end 0.00 ms query end 0.00 ms closing tables 0.00 ms removing tmp table 0.03 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 15 JDatabaseDriver->loadObjectList() JROOT/libraries/joomla/database/driver/mysqli.php:448 14 JDatabaseDriverMysqli->getTableColumns() JROOT/libraries/src/Table/Table.php:261 13 Joomla\CMS\Table\Table->getFields() JROOT/libraries/src/Table/Table.php:180 12 Joomla\CMS\Table\Table->__construct() JROOT/libraries/src/Table/Content.php:39 11 Joomla\CMS\Table\Content->__construct() JROOT/libraries/src/Table/Table.php:328 10 Joomla\CMS\Table\Table::getInstance() JROOT/components/com_content/models/article.php:253 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.30 ms** **Nach letzter Abfrage: 3.04 ms** **Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 16.495 MB**
UPDATE eek01n_content
SET `hits` = (`hits` + 1)
WHERE `id` = '276'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 UPDATE eek01n_content NULL range PRIMARY PRIMARY 4 const 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.01 ms System lock 0.03 ms updating 0.08 ms end 0.01 ms Waiting for query cache lock 0.00 ms end 0.01 ms query end 0.04 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 11 JDatabaseDriverMysqli->execute() JROOT/libraries/src/Table/Table.php:1264 10 Joomla\CMS\Table\Table->hit() JROOT/components/com_content/models/article.php:254 9 ContentModelArticle->hit() JROOT/components/com_content/controller.php:113 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.57 ms** **Nach letzter Abfrage: 1.66 ms** **Abfragespeichernutzung: 0.124 MB Speichernutzung vor Abfrage: 16.613 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 eek01n_content AS a
INNER JOIN eek01n_categories AS c
on c.id = a.catid
LEFT JOIN eek01n_users AS u
on u.id = a.created_by
LEFT JOIN eek01n_categories as parent
ON parent.id = c.parent_id
LEFT JOIN eek01n_content_rating AS v
ON a.id = v.content_id
WHERE a.id = 276
AND c.published > 0
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2024-10-14 07:36:34')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2024-10-14 07:36:34')
AND (a.state = 1 OR a.state =2)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL const PRIMARY,idx_state,idx_catid PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE u NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found 1 SIMPLE parent NULL const PRIMARY PRIMARY 4 const 1 100.00 NULL 1 SIMPLE v NULL const PRIMARY PRIMARY 4 const 0 0.00 unique row not found Status Duration starting 0.13 ms checking permissions 0.01 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.02 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.01 ms executing 0.00 ms Sending data 0.10 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 14 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 13 JDatabaseDriver->loadObject() JROOT/components/com_content/models/article.php:151 12 ContentModelArticle->getItem() JROOT/plugins/system/jsntplframework/includes/core/j3x/jsntplviewlegacy.php:398 11 JViewLegacy->get() JROOT/components/com_content/views/article/view.html.php:42 10 ContentViewArticle->display() JROOT/libraries/src/MVC/Controller/BaseController.php:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.27 ms** **Nach letzter Abfrage: 1.70 ms** **Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 16.847 MB** **Zeilen zurückgegeben: 0**
SELECT `m`.`tag_id`,`t`.*
FROM `eek01n_contentitem_tag_map` AS m
INNER JOIN `eek01n_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 276
AND `t`.`published` = 1
AND t.access IN (1,1,5)id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE m NULL ALL idx_tag_type **ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN** NULL NULL 1 100.00 Using where 1 SIMPLE t NULL eq_ref PRIMARY,tag_idx,idx_access PRIMARY 4 usr_web447_7.m.tag_id 1 100.00 Using where Status Duration starting 0.04 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.03 ms System lock 0.00 ms optimizing 0.01 ms statistics 0.05 ms preparing 0.02 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # **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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.53 ms** **Nach letzter Abfrage: 8.85 ms** **Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 17.569 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 `eek01n_categories` AS `s`
INNER JOIN `eek01n_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 = 89
ORDER BY c.lftid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE s NULL const PRIMARY,idx_left_right PRIMARY 4 const 1 100.00 NULL 1 SIMPLE c NULL range cat_idx,idx_access,idx_left_right idx_left_right 4 NULL 7 22.73 Using index condition; Using where Status Duration starting 0.11 ms checking permissions 0.01 ms checking permissions 0.00 ms Opening tables 0.01 ms init 0.04 ms System lock 0.01 ms optimizing 0.03 ms statistics 0.11 ms preparing 0.02 ms Sorting result 0.00 ms executing 0.00 ms Sending data 0.06 ms end 0.00 ms query end 0.01 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 21 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 20 JDatabaseDriver->loadObjectList() JROOT/libraries/src/Categories/Categories.php:324 19 Joomla\CMS\Categories\Categories->_load() JROOT/libraries/src/Categories/Categories.php:184 18 Joomla\CMS\Categories\Categories->get() JROOT/administrator/components/com_fields/models/fields.php:203 17 FieldsModelFields->getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:140 16 Joomla\CMS\MVC\Model\ListModel->_getListQuery() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.66 ms** **Nach letzter Abfrage: 0.47 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 17.623 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 eek01n_fields AS a
LEFT JOIN `eek01n_languages` AS l
ON l.lang_code = a.language
LEFT JOIN eek01n_users AS uc
ON uc.id=a.checked_out
LEFT JOIN eek01n_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN eek01n_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN eek01n_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `eek01n_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (89,0))
AND a.access IN (1,1,5)
AND (a.group_id = 0 OR g.access IN (1,1,5))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASCid select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE a NULL ref idx_state,idx_access,idx_context idx_state 1 const 1 100.00 Using index condition; Using where; Using temporary; **filesort wurde genutzt** 1 SIMPLE l NULL eq_ref idx_langcode idx_langcode 28 usr_web447_7.a.language 1 100.00 Using where 1 SIMPLE uc NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.a.checked_out 1 100.00 NULL 1 SIMPLE ag NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.a.access 1 100.00 Using where 1 SIMPLE ua NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.a.created_user_id 1 100.00 Using where 1 SIMPLE g NULL eq_ref PRIMARY PRIMARY 4 usr_web447_7.a.group_id 1 100.00 Using where 1 SIMPLE fc NULL ref PRIMARY PRIMARY 4 usr_web447_7.a.id 1 100.00 Using where; Using index; Distinct Status Duration starting 0.10 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms checking permissions 0.00 ms Opening tables 0.03 ms init 0.05 ms System lock 0.01 ms optimizing 0.02 ms statistics 0.10 ms preparing 0.03 ms Creating tmp table 0.04 ms Sorting result 0.01 ms executing 0.00 ms Sending data 0.14 ms Creating sort index 0.03 ms end 0.00 ms query end 0.01 ms removing tmp table 0.03 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.02 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 19 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 18 JDatabaseDriver->loadObjectList() JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:322 17 Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() JROOT/administrator/components/com_fields/models/fields.php:333 16 FieldsModelFields->_getList() JROOT/libraries/src/MVC/Model/ListModel.php:194 15 Joomla\CMS\MVC\Model\ListModel->getItems() JROOT/administrator/components/com_fields/helpers/fields.php:136 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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.20 ms** **Nach letzter Abfrage: 3.72 ms** **Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 18.042 MB** **Zeilen zurückgegeben: 3**
SELECT `name`, `value`
FROM `eek01n_jsn_imageshow_config`
WHERE `name` IN ('show_quick_icons', 'enable_update_checking', 'number_of_images_on_loading')id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_jsn_imageshow_config NULL range name name 767 NULL 3 100.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.02 ms preparing 0.01 ms executing 0.00 ms Sending data 0.03 ms end 0.00 ms query end 0.01 ms closing tables 0.00 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 18 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1701 17 JDatabaseDriver->loadObjectList() JROOT/administrator/components/com_imageshow/classes/jsn_is_parameter.php:81 16 JSNISParameter->getParameters() JROOT/administrator/components/com_imageshow/imageshow.defines.php:27 15 require_once JROOT/administrator/components/com_imageshow/imageshow.defines.php JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php:16 14 include_once JROOT/administrator/components/com_imageshow/classes/jsn_is_factory.php JROOT/plugins/content/imageshow/imageshow.php:28 13 plgContentImageShow->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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 0.31 ms** **Nach letzter Abfrage: 2.96 ms** **Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 18.379 MB** **Zeilen zurückgegeben: 1**
SELECT *
FROM eek01n_extensions
WHERE element='com_imageshow'
AND type='component'id select_type table partitions type possible_keys key key_len ref rows filtered Extra 1 SIMPLE eek01n_extensions NULL ref element_clientid,element_folder_clientid,extension element_clientid 402 const 1 10.00 Using where Status Duration starting 0.03 ms checking permissions 0.01 ms Opening tables 0.01 ms init 0.02 ms System lock 0.01 ms optimizing 0.01 ms statistics 0.06 ms preparing 0.01 ms executing 0.00 ms Sending data 0.04 ms end 0.00 ms query end 0.00 ms closing tables 0.01 ms freeing items 0.01 ms cleaning up 0.00 ms # **Aufrufer** **Datei und Zeilennummer** 16 JDatabaseDriverMysqli->execute() JROOT/libraries/joomla/database/driver.php:1662 15 JDatabaseDriver->loadObject() JROOT/administrator/components/com_imageshow/classes/jsn_is_utils.php:310 14 JSNISUtils->getComponentInfo() JROOT/plugins/content/imageshow/imageshow.php:45 13 plgContentImageShow->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:664 9 Joomla\CMS\MVC\Controller\BaseController->display() JROOT/components/com_content/controller.php:118 8 ContentController->display() JROOT/libraries/src/MVC/Controller/BaseController.php:702 7 Joomla\CMS\MVC\Controller\BaseController->execute() JROOT/components/com_content/content.php:43 6 require_once JROOT/components/com_content/content.php JROOT/libraries/src/Component/ComponentHelper.php:402 5 Joomla\CMS\Component\ComponentHelper::executeComponent() JROOT/libraries/src/Component/ComponentHelper.php:377 4 Joomla\CMS\Component\ComponentHelper::renderComponent() JROOT/libraries/src/Application/SiteApplication.php:194 3 Joomla\CMS\Application\SiteApplication->dispatch() JROOT/libraries/src/Application/SiteApplication.php:233 2 Joomla\CMS\Application\SiteApplication->doExecute() JROOT/libraries/src/Application/CMSApplication.php:225 1 Joomla\CMS\Application\CMSApplication->execute() JROOT/index.php:49 - **Abfragezeit: 2.32 ms** **Nach letzter Abfrage: 11.70 ms** **Abfragespeichernutzung: 0.125 MB Speichernutzung vor Abfrage: 19.486 MB** **Zeilen zurückgegeben: 51**