Abfragezeit: 0.22 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 0.752 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `adqlu_session`
WHERE `session_id` = 'r8mb0ri5mntu4cfuav1offph7l'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Updating status | 0.01 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 13 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:44 |
| 12 | JSessionStorageDatabase->read() | Der selbe Aufruf in der Zeile darunter. |
| 11 | session_start() | JROOT/libraries/joomla/session/handler/native.php:259 |
| 10 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:49 |
| 9 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:81 |
| 8 | JSessionHandlerJoomla->start() | JROOT/libraries/joomla/session/session.php:636 |
| 7 | JSession->_start() | JROOT/libraries/joomla/session/session.php:596 |
| 6 | JSession->start() | JROOT/libraries/cms/application/cms.php:773 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.23 ms Nach letzter Abfrage: 1.06 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 0.772 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `adqlu_session`
WHERE `session_id` = 'r8mb0ri5mntu4cfuav1offph7l'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_session | const | PRIMARY | PRIMARY | 766 | const | 1 | Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 7 | JDatabaseDriver->loadResult() | JROOT/libraries/cms/application/cms.php:176 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 14.87 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.003 MB Speichernutzung vor Abfrage: 0.777 MB
INSERT INTO `adqlu_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`)
VALUES
('r8mb0ri5mntu4cfuav1offph7l', 0, 1, '1788503536', 0, '')
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `adqlu_session`
(`session_id`,`client_id`,`guest`,`time`,`userid`,`username`) VALUES
('r8mb0ri5mntu4cfuav1offph7l', 0, 1, '1788503536', 0, '')
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init for update | 0.01 ms |
| Update | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Update | 0.00 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 14.71 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/application/cms.php:212 |
| 6 | JApplicationCms->checkSession() | JROOT/libraries/cms/application/cms.php:799 |
| 5 | JApplicationCms->loadSession() | JROOT/libraries/cms/application/cms.php:131 |
| 4 | JApplicationCms->__construct() | JROOT/libraries/cms/application/site.php:63 |
| 3 | JApplicationSite->__construct() | JROOT/libraries/cms/application/cms.php:408 |
| 2 | JApplicationCms::getInstance() | JROOT/libraries/joomla/factory.php:125 |
| 1 | JFactory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.73 ms Abfragespeichernutzung: 0.062 MB Speichernutzung vor Abfrage: 0.805 MB Zeilen zurückgegeben: 47
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 47 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.02 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 7 | JCacheControllerCallback->get() | JROOT/libraries/cms/component/helper.php:448 |
| 6 | JComponentHelper::load() | JROOT/libraries/cms/component/helper.php:43 |
| 5 | JComponentHelper::getComponent() | JROOT/libraries/cms/component/helper.php:120 |
| 4 | JComponentHelper::getParams() | JROOT/libraries/cms/application/site.php:589 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.40 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.876 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM adqlu_usergroups AS a
LEFT JOIN adqlu_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
WHERE a.id = 1
| 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 | 1 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:835 |
| 9 | JAccess::getGroupsByUser() | JROOT/libraries/joomla/access/access.php:904 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.881 MB Zeilen zurückgegeben: 5
SELECT id, rules
FROM `adqlu_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 5 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:921 |
| 8 | JAccess::getAuthorisedViewLevels() | JROOT/libraries/joomla/user/user.php:454 |
| 7 | JUser->getAuthorisedViewLevels() | JROOT/libraries/cms/plugin/helper.php:296 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 0.889 MB Zeilen zurückgegeben: 76
SELECT folder AS type, element AS name, params
FROM adqlu_extensions
WHERE enabled = 1
AND type ='plugin'
AND state IN (0,1)
AND access IN (1,1)
ORDER BY ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 114 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.03 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 7 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/plugin/helper.php:310 |
| 6 | JPluginHelper::load() | JROOT/libraries/cms/plugin/helper.php:86 |
| 5 | JPluginHelper::getPlugin() | JROOT/libraries/cms/plugin/helper.php:128 |
| 4 | JPluginHelper::isEnabled() | JROOT/libraries/cms/application/site.php:599 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.42 ms Nach letzter Abfrage: 6.05 ms Abfragespeichernutzung: 0.602 MB Speichernutzung vor Abfrage: 1.539 MB Zeilen zurückgegeben: 345
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 adqlu_menu AS m
LEFT JOIN adqlu_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
| 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 | 480 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.34 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/menu/site.php:86 |
| 18 | JMenuSite->load() | JROOT/libraries/cms/menu/menu.php:74 |
| 17 | JMenu->__construct() | JROOT/libraries/cms/menu/site.php:57 |
| 16 | JMenuSite->__construct() | JROOT/libraries/cms/menu/menu.php:145 |
| 15 | JMenu::getInstance() | JROOT/libraries/cms/application/cms.php:439 |
| 14 | JApplicationCms->getMenu() | JROOT/libraries/cms/application/site.php:272 |
| 13 | JApplicationSite->getMenu() | JROOT/libraries/cms/application/site.php:438 |
| 12 | JApplicationSite->getTemplate() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847 |
| 11 | require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php | JROOT/libraries/zauan/shortcodes/shortcodes.php:290 |
| 10 | include_once JROOT/libraries/zauan/shortcodes/shortcodes.php | JROOT/libraries/loader.php:219 |
| 9 | JLoader::import() | JROOT/libraries/loader.php:682 |
| 8 | jimport() | JROOT/plugins/system/hg_assets/hg_assets.php:16 |
| 7 | require_once JROOT/plugins/system/hg_assets/hg_assets.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.22 ms Nach letzter Abfrage: 3.85 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.992 MB Zeilen zurückgegeben: 6
SELECT id, home, template, s.params
FROM adqlu_template_styles as s
LEFT JOIN adqlu_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
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | ALL | idx_template | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid,extension | element_clientid | 403 | staging_otterbein.s.template,const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/application/site.php:484 |
| 12 | JApplicationSite->getTemplate() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:847 |
| 11 | require_once JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php | JROOT/libraries/zauan/shortcodes/shortcodes.php:290 |
| 10 | include_once JROOT/libraries/zauan/shortcodes/shortcodes.php | JROOT/libraries/loader.php:219 |
| 9 | JLoader::import() | JROOT/libraries/loader.php:682 |
| 8 | jimport() | JROOT/plugins/system/hg_assets/hg_assets.php:16 |
| 7 | require_once JROOT/plugins/system/hg_assets/hg_assets.php | JROOT/libraries/cms/plugin/helper.php:230 |
| 6 | JPluginHelper::import() | JROOT/libraries/cms/plugin/helper.php:170 |
| 5 | JPluginHelper::importPlugin() | JROOT/libraries/cms/application/cms.php:669 |
| 4 | JApplicationCms->initialiseApp() | JROOT/libraries/cms/application/site.php:681 |
| 3 | JApplicationSite->initialiseApp() | JROOT/libraries/cms/application/site.php:209 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 4.84 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.256 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.03 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.02 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 16 | JDatabaseDriver->loadObject() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 15 | JCacheControllerCallback->get() | JROOT/libraries/cms/library/helper.php:156 |
| 14 | JLibraryHelper::_load() | JROOT/libraries/cms/library/helper.php:47 |
| 13 | JLibraryHelper::getLibrary() | JROOT/libraries/cms/library/helper.php:90 |
| 12 | JLibraryHelper::getParams() | JROOT/libraries/cms/version/version.php:274 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:1026 |
| 8 | plgSystemGdpr->onAfterRoute() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.248 MB
UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"b9373f8fc3bcd634b0527ce4cbec59a3\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"b9373f8fc3bcd634b0527ce4cbec59a3\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.03 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init for update | 0.05 ms |
| Updating | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.00 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/cms/library/helper.php:119 |
| 13 | JLibraryHelper::saveParams() | JROOT/libraries/cms/version/version.php:325 |
| 12 | JVersion->setMediaVersion() | JROOT/libraries/cms/version/version.php:284 |
| 11 | JVersion->getMediaVersion() | JROOT/libraries/joomla/factory.php:755 |
| 10 | JFactory::createDocument() | JROOT/libraries/joomla/factory.php:216 |
| 9 | JFactory::getDocument() | JROOT/plugins/system/gdpr/gdpr.php:1026 |
| 8 | plgSystemGdpr->onAfterRoute() | JROOT/libraries/joomla/event/event.php:69 |
| 7 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 6 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 5 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/cms.php:1125 |
| 4 | JApplicationCms->route() | JROOT/libraries/cms/application/site.php:791 |
| 3 | JApplicationSite->route() | JROOT/libraries/cms/application/site.php:215 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 1.01 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.295 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/language/helper.php:164 |
| 5 | JLanguageHelper::getLanguages() | JROOT/libraries/cms/application/site.php:329 |
| 4 | JApplicationSite->getParams() | JROOT/libraries/cms/application/site.php:135 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.57 ms Nach letzter Abfrage: 2.99 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 5.505 MB Zeilen zurückgegeben: 8
SHOW FULL COLUMNS
FROM `adqlu_assets`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `adqlu_assets`
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.00 ms |
| Closing tables | 0.01 ms |
| Opening tables | 0.22 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| Checking permissions | 0.06 ms |
| Closing tables | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.03 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.06 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 24 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 23 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 22 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 21 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 20 | JTable->__construct() | JROOT/libraries/joomla/table/asset.php:60 |
| 19 | JTableAsset->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 18 | JTable::getInstance() | JROOT/libraries/joomla/access/access.php:696 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.536 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_assets
WHERE `id` = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_assets | const | PRIMARY | PRIMARY | 4 | const | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1453 |
| 19 | JDatabaseDriver->loadAssoc() | JROOT/libraries/joomla/table/table.php:719 |
| 18 | JTable->load() | JROOT/libraries/joomla/access/access.php:697 |
| 17 | JAccess::getExtensionNameFromAsset() | JROOT/libraries/joomla/access/access.php:555 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.05 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.543 MB Zeilen zurückgegeben: 1
SELECT a.rules
FROM adqlu_assets AS a
WHERE (a.id = 1 OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | PRIMARY,idx_asset_name | PRIMARY,idx_asset_name | 4,202 | NULL | 2 | Using union(PRIMARY,idx_asset_name); Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 17 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:652 |
| 16 | JAccess::getAssetRules() | JROOT/libraries/joomla/user/user.php:385 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.33 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 5.556 MB Zeilen zurückgegeben: 458
SELECT a.id, a.parent_id
FROM adqlu_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1)
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1145 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.01 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/access/access.php:332 |
| 18 | JAccess::preloadPermissionsParentIdMapping() | JROOT/libraries/joomla/access/access.php:240 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.47 ms Abfragespeichernutzung: 0.129 MB Speichernutzung vor Abfrage: 5.801 MB Zeilen zurückgegeben: 458
SELECT a.id, a.name, a.rules
FROM adqlu_assets AS a
WHERE (a.name LIKE 'com_content.%' OR a.name = 'com_content' OR a.id = 1 )
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | PRIMARY,idx_asset_name | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1145 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.04 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1255 |
| 19 | JDatabaseDriver->getIterator() | JROOT/libraries/joomla/access/access.php:373 |
| 18 | JAccess::preloadPermissions() | JROOT/libraries/joomla/access/access.php:243 |
| 17 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 16 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 15 | JUser->authorise() | JROOT/components/com_content/models/category.php:142 |
| 14 | ContentModelCategory->populateState() | JROOT/libraries/legacy/model/legacy.php:435 |
| 13 | JModelLegacy->getState() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:114 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.08 ms Nach letzter Abfrage: 0.92 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 6.177 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,COUNT(i.`id`) AS numitems
FROM adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN adqlu_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
LEFT JOIN `adqlu_content` AS i
ON i.`catid` = c.id
AND i.state = 1
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=38
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where |
| 1 | PRIMARY | i | ref | idx_state,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 2 | DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; Using temporary; filesort wurde genutzt |
| 2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 38 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 15 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 14 | JCategories->get() | JROOT/components/com_content/models/category.php:354 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:115 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.42 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.207 MB Zeilen zurückgegeben: 46
SELECT element
FROM adqlu_extensions
WHERE type = 'component'
AND enabled = '1'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_extensions | ref | extension | extension | 82 | const | 47 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.18 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1538 |
| 22 | JDatabaseDriver->loadColumn() | JROOT/libraries/joomla/access/access.php:413 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 6.224 MB Zeilen zurückgegeben: 46
SELECT a.name, a.rules
FROM adqlu_assets AS a
WHERE (a.name IN ('com_admin','com_ajax','com_banners','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_contentmap','com_cpanel','com_customfilters','com_djimageslider','com_finder','com_flippingbook','com_gdpr','com_installer','com_jce','com_jmap','com_joomlaupdate','com_languages','com_listmanager','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_newsfeeds','com_phocagallery','com_plugins','com_postinstall','com_redirect','com_search','com_seoglossary','com_tags','com_tcpdf','com_templates','com_users','com_virtuemart','com_virtuemart_allinone','com_virtuemart_magicscroll','com_virtuemart_magiczoomplus','com_weblinks','com_wrapper') OR a.name = 'root.1')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | range | idx_asset_name | idx_asset_name | 202 | NULL | 47 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1494 |
| 22 | JDatabaseDriver->loadAssocList() | JROOT/libraries/joomla/access/access.php:441 |
| 21 | JAccess::preloadComponents() | JROOT/libraries/joomla/access/access.php:213 |
| 20 | JAccess::preload() | JROOT/libraries/joomla/access/access.php:168 |
| 19 | JAccess::check() | JROOT/libraries/joomla/user/user.php:394 |
| 18 | JUser->authorise() | JROOT/components/com_content/models/articles.php:466 |
| 17 | ContentModelArticles->getListQuery() | JROOT/libraries/legacy/model/list.php:129 |
| 16 | JModelList->_getListQuery() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 1.64 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 6.473 MB Zeilen zurückgegeben: 2
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 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,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 38
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 06:32:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 06:32:16')
ORDER BY c.lft,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END DESC , a.created
LIMIT 40, 9
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 44 | Using where; filesort wurde genutzt |
| 1 | PRIMARY | ua | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.created_by | 1 | Using where |
| 1 | PRIMARY | uam | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.modified_by | 1 | Using where |
| 1 | PRIMARY | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| 1 | PRIMARY | v | eq_ref | PRIMARY | PRIMARY | 4 | staging_otterbein.a.id | 1 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 10 | Using where |
| 2 | DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; Using temporary; filesort wurde genutzt |
| 2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 38 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.23 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.11 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Creating sort index | 0.23 ms |
| Executing | 0.01 ms |
| Sending data | 0.18 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.32 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
| 16 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:183 |
| 15 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.95 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.562 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id ) AS badcats
ON badcats.id = c.id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND
CASE WHEN badcats.id is null THEN a.state ELSE 0 END = 1
AND a.catid = 38
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 06:32:16')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 06:32:16')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | const | 44 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | const | 10 | Using where |
| 2 | DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; Using temporary; filesort wurde genutzt |
| 2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 38 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.10 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.05 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.01 ms |
| Unlocking tables | 0.01 ms |
| Preparing | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.17 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.14 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.01 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/legacy/model/legacy.php:337 |
| 16 | JModelLegacy->_getListCount() | JROOT/libraries/legacy/model/list.php:278 |
| 15 | JModelList->getTotal() | JROOT/libraries/legacy/model/list.php:228 |
| 14 | JModelList->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/legacy/view/legacy.php:408 |
| 12 | JViewLegacy->get() | JROOT/libraries/legacy/view/category.php:128 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.06 ms Nach letzter Abfrage: 0.35 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.573 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `adqlu_contentitem_tag_map` AS m
INNER JOIN `adqlu_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 38
AND `t`.`published` = 1
AND t.access IN (1,1)
| 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 | 59 | Using where |
| 1 | SIMPLE | m | ref | idx_tag_type | idx_tag_type | 4 | staging_otterbein.t.id | 4 | Using index condition; Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/cms/helper/tags.php:435 |
| 12 | JHelperTags->getItemTags() | JROOT/libraries/legacy/view/category.php:217 |
| 11 | JViewCategory->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 2.03 ms Nach letzter Abfrage: 3.79 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.762 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Mitteilung von Betriebsrat und Belegschaft\nWir, die Mitarbeiter der Firma Zement- und Kalkwerke Otterbein aus Müs, möchten uns gerne zu der geplanten Steinbruch-Erweiterung zu Wort melden.\nEs herrscht Unsicherheit, es gibt Bedenken und es gibt Ängste. Dies ist nur allzu gut nachvollziehbar, wenn man in Müs, und dann auch noch in unmittelbarem Bereich der angestrebten Erweiterung des Abbaugebiets, lebt. Kritische Fragen sind daher verständlich, schließlich will man genau wissen, was mit der geplanten Ausdehnung des Steinbruchs auf einen zukommt. Ängste müssen genommen, offene Fragen müssen beantwortet werden.\nWarum ist die Steinbruch-Erweiterung so wichtig?\nZum einen steht für uns Mitarbeiter sicherlich die Erhaltung des eigenen Arbeitsplatzes im Vordergrund. Viele haben Familie, ein Auto, manche ein kleines Häuschen. Daher sind Ängste auch in den eigenen Reihen spürbar und sicher nachvollziehbar. Uns ist an einer langfristigen Erhaltung des eigenen Arbeitsplatzes gelegen, um unsere und die Zukunft unserer Familien weiterhin sicherstellen zu können.\nDoch es geht hier nicht nur um unsere eigenen, sondern um viele weitere Arbeitsplätze, wie z. B. die der Zulieferbetriebe, der Speditionen und nicht zu vergessen der vielen heimischen Betriebe verschiedenster Gewerke. All diese Firmen und deren Mitarbeiter sind eng mit der Firma Otterbein verbunden.\nZum anderen stehen wir uneingeschränkt hinter der großen Produktpalette, die wir täglich produzieren. Die Zement- und Kalkwerke Otterbein sind ein erfolgreiches Familienunternehmen, wie es nur noch wenige in Deutschland gibt. Wir als Mitarbeiter sind stolz darauf, ein Teil der mittlerweile 130-jährigen Geschichte dieses Unternehmens zu sein und diese gemeinsam mit der Familie Müller weiterführen zu dürfen. Unsere Kunden, die regional und mittlerweile weltweit vertreten sind, wissen die Qualität unserer hochwertigen und zum Teil einzigartigen Produkte zu schätzen. Hierzu tragen wir jeden Tag mit unserer Arbeit einen großen Teil bei.\nEs ist also keineswegs an der Zeit „den Schlüssel umzudrehen“. Wir blicken optimistisch in die Zukunft und wünschen uns ein gutes Miteinander mit den Einwohnern von Müs. Wir sind sicher, dass die Geschäftsleitung der Firma Otterbein Sorge dafür tragen und alle notwendigen Maßnahmen ergreifen wird, um eine Beeinträchtigung der Anwohner so gering wie möglich zu halten und eine gute Lebensqualität auch weiterhin zu gewährleisten.\nEine Bürgerbefragung, wie sie Herr Bürgermeister Dietrich vorgeschlagen hat, halten wir Mitarbeiter nicht für zielführend, da diese zu einer Aufklärung nichts beitragen würde. Es wäre eine rein emotionale Abstimmung. Die Gemeindevertreter sind hier in der Verantwortung und dürfen diese nicht auf die Bürger abwälzen. Wir hoffen darauf, dass sich beide Parteien durch Gespräche und einen offenen Austausch zu einer für beide Seiten guten Lösung verständigen können.\nWir als Mitarbeiter befürworten die Erweiterung der Abbaufläche des Steinbruchs, denn wir möchten auch weiterhin sagen können „Wir bringen Steine zum Leben“, denn diese Tradition ist es Wert in unserer Region erhalten zu werden.\nGez. Markus Haake-Hermann Betriebsrat\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Mitteilung von Betriebsrat und Belegschaft\nWir, die Mitarbeiter der Firma Zement- und Kalkwerke Otterbein aus Müs, möchten uns gerne zu der geplanten Steinbruch-Erweiterung zu Wort melden.\nEs herrscht Unsicherheit, es gibt Bedenken und es gibt Ängste. Dies ist nur allzu gut nachvollziehbar, wenn man in Müs, und dann auch noch in unmittelbarem Bereich der angestrebten Erweiterung des Abbaugebiets, lebt. Kritische Fragen sind daher verständlich, schließlich will man genau wissen, was mit der geplanten Ausdehnung des Steinbruchs auf einen zukommt. Ängste müssen genommen, offene Fragen müssen beantwortet werden.\nWarum ist die Steinbruch-Erweiterung so wichtig?\nZum einen steht für uns Mitarbeiter sicherlich die Erhaltung des eigenen Arbeitsplatzes im Vordergrund. Viele haben Familie, ein Auto, manche ein kleines Häuschen. Daher sind Ängste auch in den eigenen Reihen spürbar und sicher nachvollziehbar. Uns ist an einer langfristigen Erhaltung des eigenen Arbeitsplatzes gelegen, um unsere und die Zukunft unserer Familien weiterhin sicherstellen zu können.\nDoch es geht hier nicht nur um unsere eigenen, sondern um viele weitere Arbeitsplätze, wie z. B. die der Zulieferbetriebe, der Speditionen und nicht zu vergessen der vielen heimischen Betriebe verschiedenster Gewerke. All diese Firmen und deren Mitarbeiter sind eng mit der Firma Otterbein verbunden.\nZum anderen stehen wir uneingeschränkt hinter der großen Produktpalette, die wir täglich produzieren. Die Zement- und Kalkwerke Otterbein sind ein erfolgreiches Familienunternehmen, wie es nur noch wenige in Deutschland gibt. Wir als Mitarbeiter sind stolz darauf, ein Teil der mittlerweile 130-jährigen Geschichte dieses Unternehmens zu sein und diese gemeinsam mit der Familie Müller weiterführen zu dürfen. Unsere Kunden, die regional und mittlerweile weltweit vertreten sind, wissen die Qualität unserer hochwertigen und zum Teil einzigartigen Produkte zu schätzen. Hierzu tragen wir jeden Tag mit unserer Arbeit einen großen Teil bei.\nEs ist also keineswegs an der Zeit „den Schlüssel umzudrehen“. Wir blicken optimistisch in die Zukunft und wünschen uns ein gutes Miteinander mit den Einwohnern von Müs. Wir sind sicher, dass die Geschäftsleitung der Firma Otterbein Sorge dafür tragen und alle notwendigen Maßnahmen ergreifen wird, um eine Beeinträchtigung der Anwohner so gering wie möglich zu halten und eine gute Lebensqualität auch weiterhin zu gewährleisten.\nEine Bürgerbefragung, wie sie Herr Bürgermeister Dietrich vorgeschlagen hat, halten wir Mitarbeiter nicht für zielführend, da diese zu einer Aufklärung nichts beitragen würde. Es wäre eine rein emotionale Abstimmung. Die Gemeindevertreter sind hier in der Verantwortung und dürfen diese nicht auf die Bürger abwälzen. Wir hoffen darauf, dass sich beide Parteien durch Gespräche und einen offenen Austausch zu einer für beide Seiten guten Lösung verständigen können.\nWir als Mitarbeiter befürworten die Erweiterung der Abbaufläche des Steinbruchs, denn wir möchten auch weiterhin sagen können „Wir bringen Steine zum Leben“, denn diese Tradition ist es Wert in unserer Region erhalten zu werden.\nGez. Markus Haake-Hermann Betriebsrat\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.19 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| Init | 0.09 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 1.36 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.05 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:106 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.65 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.786 MB Zeilen zurückgegeben: 30
SHOW FULL COLUMNS
FROM `adqlu_content`
„EXPLAIN“ unmöglich für Abfrage: SHOW FULL COLUMNS FROM `adqlu_content`
| Status | Duration |
|---|
| Starting | 0.02 ms |
| Checking permissions | 0.01 ms |
| Closing tables | 0.01 ms |
| Opening tables | 0.18 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| Checking permissions | 0.13 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.07 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Removing tmp table | 0.05 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 21 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/database/driver/mysqli.php:440 |
| 20 | JDatabaseDriverMysqli->getTableColumns() | JROOT/libraries/joomla/table/table.php:241 |
| 19 | JTable->getFields() | JROOT/libraries/joomla/table/table.php:162 |
| 18 | JTable->__construct() | JROOT/libraries/legacy/table/content.php:31 |
| 17 | JTableContent->__construct() | JROOT/libraries/joomla/table/table.php:308 |
| 16 | JTable::getInstance() | JROOT/plugins/content/myshariff/myshariff.php:128 |
| 15 | plgContentMyShariff->getShariffHTML() | JROOT/plugins/content/myshariff/myshariff.php:200 |
| 14 | plgContentMyShariff->getShariffTag() | JROOT/plugins/content/myshariff/myshariff.php:381 |
| 13 | plgContentMyShariff->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:106 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 1.74 ms Abfragespeichernutzung: 0.028 MB Speichernutzung vor Abfrage: 6.955 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('Gemeinsame Pressemitteilung Gemeinde Großenlüder / Zement- und Kalkwerke OTTERBEIN\nArbeitsplätze und Rohstoffabbau sichern – Erschließung eines neuen Abbauabschnitts für die Zement- und Kalkwerke Otterbein\nSeit 130 Jahren sind der Firmenname „Zement- und Kalkwerke Otterbein“ und die hochwertigen Firmenprodukte, d.h. Zemente, Kalke, Putze und Mörtel sowie mineralische Anstriche, bekannte Aushängeschilder für hohe Qualität aus dem Naturprodukt Kalkstein. Die derzeit in der benötigten Qualität nur noch begrenzt zur Verfügung stehende Abbaumenge hat das Unternehmen veranlasst, sich bereits heute verantwortungsvoll Gedanken über die Zukunft der Arbeitsplätze und der Rohstoffsicherung zu machen, ein weiteres Abbaugebiet zu prüfen und dabei in den Mittelpunkt der Überlegungen den Schutz\na) des Ortsteils Müs (Mensch, Gebäude, Umwelt und Natur)b) und des Grundwassers\nzu stellen. Eine Erweiterung ist notwendig, um die Produktion auf heutigem Niveau auch in Zukunft fortzusetzen, den Standort langfristig zu erhalten und damit die Rohstoffversorgung und -veredelung in der Region nachhaltig zu sichern. Die Firma Otterbein beschäftigt 120 Mitarbeiter und bietet jungen Menschen in neun Ausbildungsberufen eine Perspektive für den Berufseinstieg. Das Familienunternehmen ist am Standort fest verwurzelt und engagiert.\nEs geht um ein ca. 6,5 ha großes, nord-westlich gelegenes Abbaugebiet, das auf der bereits bestehenden Tiefe des heutigen Abbaugebietes weitergeführt werden soll. Die Erweiterung ist in Richtung Nordwesten geplant, weil sich nur dort nachweislich verwertbare Rohstoffe befinden.\nHoch qualifizierte Fachbüros sowie national und international anerkannte Professoren und Experten arbeiten derzeit mit Hochdruck daran, dieses Zukunftsprojekt im Sinne von Bürgern, Umwelt und Natur zu gestalten. Eine erste Information der Kommunalpolitik der Gemeinde Großenlüder zu dem Vorhaben fand bereits statt. Als wichtiger nächster Schritt ist vorgesehen, dass Unternehmensleitung und Gemeinde Großenlüder, vertreten durch den Bürgermeister Werner Dietrich, zeitnah alle Müser Bürger sowie interessierte Bürger aus angrenzenden Ortsteilen zu einer öffentlichen Bürgerinformation in das Bürgerhaus Müs einladen, um dort Rede und Antwort zu stehen. Das bereits heute durch den Regionalplan Nordhessen für die geplante Erweiterung vorgesehene Vorbehaltsgebiet für den weiteren Abbau von Kalkstein soll in einem förmlichen, öffentlichen Verfahren, an dem auch Behörden und Bürger beteiligt werden, in ein Vorranggebiet umgewandelt werden.\nDie Einladung zur öffentlichen Bürgerinformationsveranstaltung im Bürgerhaus Müs wird rechtzeitig im Lüdertal Bote sowie über die Medien bekannt gegeben. Unternehmen und Gemeinde Großenlüder legen großen Wert auf eine größt- und bestmögliche Bürgerbeteiligung sowie Transparenz.\nGez.\nWinfried Müller Dr. Christian W. Müller Werner DietrichGeschäftsführung ZKW OTTERBEIN Bürgermeister der Gemeinde Großenlüder\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Gemeinsame Pressemitteilung Gemeinde Großenlüder / Zement- und Kalkwerke OTTERBEIN\nArbeitsplätze und Rohstoffabbau sichern – Erschließung eines neuen Abbauabschnitts für die Zement- und Kalkwerke Otterbein\nSeit 130 Jahren sind der Firmenname „Zement- und Kalkwerke Otterbein“ und die hochwertigen Firmenprodukte, d.h. Zemente, Kalke, Putze und Mörtel sowie mineralische Anstriche, bekannte Aushängeschilder für hohe Qualität aus dem Naturprodukt Kalkstein. Die derzeit in der benötigten Qualität nur noch begrenzt zur Verfügung stehende Abbaumenge hat das Unternehmen veranlasst, sich bereits heute verantwortungsvoll Gedanken über die Zukunft der Arbeitsplätze und der Rohstoffsicherung zu machen, ein weiteres Abbaugebiet zu prüfen und dabei in den Mittelpunkt der Überlegungen den Schutz\na) des Ortsteils Müs (Mensch, Gebäude, Umwelt und Natur)b) und des Grundwassers\nzu stellen. Eine Erweiterung ist notwendig, um die Produktion auf heutigem Niveau auch in Zukunft fortzusetzen, den Standort langfristig zu erhalten und damit die Rohstoffversorgung und -veredelung in der Region nachhaltig zu sichern. Die Firma Otterbein beschäftigt 120 Mitarbeiter und bietet jungen Menschen in neun Ausbildungsberufen eine Perspektive für den Berufseinstieg. Das Familienunternehmen ist am Standort fest verwurzelt und engagiert.\nEs geht um ein ca. 6,5 ha großes, nord-westlich gelegenes Abbaugebiet, das auf der bereits bestehenden Tiefe des heutigen Abbaugebietes weitergeführt werden soll. Die Erweiterung ist in Richtung Nordwesten geplant, weil sich nur dort nachweislich verwertbare Rohstoffe befinden.\nHoch qualifizierte Fachbüros sowie national und international anerkannte Professoren und Experten arbeiten derzeit mit Hochdruck daran, dieses Zukunftsprojekt im Sinne von Bürgern, Umwelt und Natur zu gestalten. Eine erste Information der Kommunalpolitik der Gemeinde Großenlüder zu dem Vorhaben fand bereits statt. Als wichtiger nächster Schritt ist vorgesehen, dass Unternehmensleitung und Gemeinde Großenlüder, vertreten durch den Bürgermeister Werner Dietrich, zeitnah alle Müser Bürger sowie interessierte Bürger aus angrenzenden Ortsteilen zu einer öffentlichen Bürgerinformation in das Bürgerhaus Müs einladen, um dort Rede und Antwort zu stehen. Das bereits heute durch den Regionalplan Nordhessen für die geplante Erweiterung vorgesehene Vorbehaltsgebiet für den weiteren Abbau von Kalkstein soll in einem förmlichen, öffentlichen Verfahren, an dem auch Behörden und Bürger beteiligt werden, in ein Vorranggebiet umgewandelt werden.\nDie Einladung zur öffentlichen Bürgerinformationsveranstaltung im Bürgerhaus Müs wird rechtzeitig im Lüdertal Bote sowie über die Medien bekannt gegeben. Unternehmen und Gemeinde Großenlüder legen großen Wert auf eine größt- und bestmögliche Bürgerbeteiligung sowie Transparenz.\nGez.\nWinfried Müller Dr. Christian W. Müller Werner DietrichGeschäftsführung ZKW OTTERBEIN Bürgermeister der Gemeinde Großenlüder\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.02 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 14 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 13 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:106 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.006 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 adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
WHERE parent.extension = 'com_content'
AND parent.published != 1
GROUP BY cat.id) AS badcats
ON badcats.id = c.id
LEFT JOIN adqlu_categories AS s
ON (s.lft <= c.lft
AND s.rgt >= c.rgt) OR (s.lft > c.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND badcats.id is null
AND s.id=38
GROUP BY c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 2 | DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; Using temporary; filesort wurde genutzt |
| 2 | DERIVED | cat | index | PRIMARY,idx_left_right | idx_left_right | 8 | NULL | 38 | Using where; Using index; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 19 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 18 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 17 | ContentHelperRoute::getArticleRoute() | JROOT/templates/kallyas/html/com_content/category/blog_item.php:32 |
| 16 | include JROOT/templates/kallyas/html/com_content/category/blog_item.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 15 | JViewLegacy->loadTemplate() | JROOT/templates/kallyas/html/com_content/category/blog.php:172 |
| 14 | include JROOT/templates/kallyas/html/com_content/category/blog.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 13 | JViewLegacy->loadTemplate() | JROOT/libraries/legacy/view/legacy.php:216 |
| 12 | JViewLegacy->display() | JROOT/libraries/legacy/view/category.php:233 |
| 11 | JViewCategory->display() | JROOT/components/com_content/views/category/view.html.php:258 |
| 10 | ContentViewCategory->display() | JROOT/libraries/legacy/controller/legacy.php:664 |
| 9 | JControllerLegacy->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/legacy/controller/legacy.php:702 |
| 7 | JControllerLegacy->execute() | JROOT/components/com_content/content.php:38 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/cms/component/helper.php:405 |
| 5 | JComponentHelper::executeComponent() | JROOT/libraries/cms/component/helper.php:380 |
| 4 | JComponentHelper::renderComponent() | JROOT/libraries/cms/application/site.php:191 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.62 ms Nach letzter Abfrage: 2.04 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.038 MB Zeilen zurückgegeben: 0
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
WHERE m.published = 1
AND module = 'mod_maximenuck'
AND e.enabled = 1
AND (m.publish_up = '0000-00-00 00:00:00' OR m.publish_up <= '2026-09-04 06:32:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 06:32:16')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 687 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | newsfeeds | 204 | const,const | 1 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | staging_otterbein.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.id | 3 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.10 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.05 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.09 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 0.05 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 9 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:248 |
| 8 | plgSystemMaximenuckmobile->getMaximenuModules() | JROOT/plugins/system/maximenuckmobile/maximenuckmobile.php:105 |
| 7 | plgSystemMaximenuckmobile->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.039 MB Zeilen zurückgegeben: 0
SELECT id,placeholder
FROM `adqlu_gdpr_checkbox`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_gdpr_checkbox | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 1 | |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.01 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 8 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/gdpr/gdpr.php:1291 |
| 7 | plgSystemGdpr->onAfterDispatch() | JROOT/libraries/joomla/event/event.php:69 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 4 | JApplicationBase->triggerEvent() | JROOT/libraries/cms/application/site.php:196 |
| 3 | JApplicationSite->dispatch() | JROOT/libraries/cms/application/site.php:230 |
| 2 | JApplicationSite->doExecute() | JROOT/libraries/cms/application/cms.php:261 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 7.53 ms Nach letzter Abfrage: 1.86 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 7.091 MB Zeilen zurückgegeben: 9
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_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 <= '2026-09-04 06:32:16')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 06:32:16')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 687 OR mm.menuid <= 0)
ORDER BY m.position, m.ordering
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | m | ref | PRIMARY,published,newsfeeds | published | 1 | const | 403 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | staging_otterbein.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | staging_otterbein.m.id | 3 | Using where; Using index |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.07 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.04 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| Creating sort index | 7.12 ms |
| End of update loop | 0.01 ms |
| Query end | 0.01 ms |
| Commit | 0.01 ms |
| Closing tables | 0.01 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.01 ms |
| Starting cleanup | 0.00 ms |
| Freeing items | 0.01 ms |
| Updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.00 ms |
| Storing result in query cache | 0.01 ms |
| Reset for next command | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/joomla/cache/controller/callback.php:152 |
| 12 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
| 11 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
| 10 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:84 |
| 9 | JModuleHelper::getModules() | JROOT/libraries/joomla/document/html.php:514 |
| 8 | JDocumentHtml->countModules() | JROOT/templates/kallyas/index.php:18 |
| 7 | require JROOT/templates/kallyas/index.php | JROOT/libraries/joomla/document/html.php:578 |
| 6 | JDocumentHtml->_loadTemplate() | JROOT/libraries/joomla/document/html.php:640 |
| 5 | JDocumentHtml->_fetchTemplate() | JROOT/libraries/joomla/document/html.php:455 |
| 4 | JDocumentHtml->parse() | JROOT/libraries/cms/application/cms.php:1072 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 30.26 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.388 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER('{myshariff}\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '{myshariff}\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 16 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:139 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 3.07 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 7.452 MB Zeilen zurückgegeben: 0
SELECT *
FROM `adqlu_modules`
WHERE `id`='121'
AND `published`='1'
| 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 |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 30 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 29 | JDatabaseDriver->loadObjectList() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes.php:60 |
| 28 | hg_module() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 27 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 26 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 25 | do_shortcode() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:34 |
| 24 | hg_grid() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 23 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 22 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 21 | do_shortcode() | JROOT/plugins/system/hg_assets/shortcodes/shortcodes_grid.php:421 |
| 20 | hg_row() | JROOT/libraries/zauan/shortcodes/shortcodes.php:98 |
| 19 | do_shortcode_tag() | Der selbe Aufruf in der Zeile darunter. |
| 18 | preg_replace_callback() | JROOT/libraries/zauan/shortcodes/shortcodes.php:44 |
| 17 | do_shortcode() | JROOT/plugins/system/hg_assets/hg_assets.php:136 |
| 16 | plgSystemHG_Assets->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 0.43 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 7.459 MB Zeilen zurückgegeben: 0
SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
WHERE t.state = 1
AND g.state = 1
AND ( LOWER(' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR ' \nZEMENT- UND KALKWERKE OTTERBEIN GMBH & CO. KG\nHauptstraße 50\n36137 Großenlüder-Müs (Germany)\nTel.: +49 6648 68 - 0\nFax.: +49 6648 68 - 400\ninfo@zkw-otterbein.de\n\n\n\n\nyoutube\nfacebook\n\n\n\n' REGEXP REPLACE(REPLACE(tsynonyms, ', ', '|'), ',', '|') )
AND ( g.language LIKE 'de-DE' OR g.language = '*' )
ORDER BY ordering;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | g | ALL | PRIMARY | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 2 | Using where; Using temporary; filesort wurde genutzt |
| 1 | SIMPLE | t | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; Using join buffer (flat, BNL join) |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.01 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/plugins/content/seoglossary/seoglossary.php:263 |
| 16 | plgContentSeoglossary->onContentPrepare() | JROOT/libraries/joomla/event/event.php:69 |
| 15 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 14 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 13 | JHtmlContent::prepare() | JROOT/libraries/cms/html/html.php:237 |
| 12 | JHtml::call() | JROOT/libraries/cms/html/html.php:105 |
| 11 | JHtml::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/cms/module/helper.php:199 |
| 9 | JModuleHelper::renderModule() | JROOT/libraries/joomla/document/renderer/html/module.php:93 |
| 8 | JDocumentRendererHtmlModule->render() | JROOT/libraries/joomla/document/renderer/html/modules.php:42 |
| 7 | JDocumentRendererHtmlModules->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
Abfragezeit: 0.09 ms Nach letzter Abfrage: 1.67 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.484 MB Zeilen zurückgegeben: 0
SELECT *
FROM adqlu_jmap_metainfo
WHERE `linkurl` = 'https://staging.zkw-otterbein.de/aktuelles-zum-nachbarschaftsdialog'
AND `published` = 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_jmap_metainfo | ref | linkurl,published | linkurl | 767 | const | 1 | Using where |
| Status | Duration |
|---|
| Starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 ms |
| Checking privileges on cached | 0.00 ms |
| Checking permissions | 0.00 ms |
| Sending cached result to clien | 0.01 ms |
| Updating status | 0.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 13 | JDatabaseDriver->loadObject() | JROOT/plugins/system/jmap/jmap.php:276 |
| 12 | plgSystemJMap->onBeforeCompileHead() | JROOT/libraries/joomla/event/event.php:69 |
| 11 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:159 |
| 10 | JEventDispatcher->trigger() | JROOT/libraries/joomla/application/base.php:106 |
| 9 | JApplicationBase->triggerEvent() | JROOT/libraries/joomla/document/renderer/html/head.php:58 |
| 8 | JDocumentRendererHtmlHead->fetchHead() | JROOT/libraries/joomla/document/renderer/html/head.php:34 |
| 7 | JDocumentRendererHtmlHead->render() | JROOT/libraries/joomla/document/html.php:411 |
| 6 | JDocumentHtml->getBuffer() | JROOT/libraries/joomla/document/html.php:702 |
| 5 | JDocumentHtml->_renderTemplate() | JROOT/libraries/joomla/document/html.php:477 |
| 4 | JDocumentHtml->render() | JROOT/libraries/cms/application/cms.php:1086 |
| 3 | JApplicationCms->render() | JROOT/libraries/cms/application/site.php:773 |
| 2 | JApplicationSite->render() | JROOT/libraries/cms/application/cms.php:267 |
| 1 | JApplicationCms->execute() | JROOT/index.php:49 |
4 × SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `adqlu_extensions`
2 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM adqlu_modules AS m
LEFT JOIN adqlu_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN adqlu_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT `data`
FROM `adqlu_session`
1 × SELECT element
FROM adqlu_extensions
1 × SELECT *
FROM `adqlu_modules`
1 × SELECT id,placeholder
FROM `adqlu_gdpr_checkbox
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `m`.`tag_id`,`t`.*
FROM `adqlu_contentitem_tag_map` AS m
INNER JOIN `adqlu_tags` AS t
ON `m`.`tag_id` = `t`.`id`
1 × SELECT COUNT(*)
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
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 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,
CASE WHEN badcats.id is not null THEN 0 ELSE a.state END AS state,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,
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,ROUND(v.rating_sum / v.rating_count, 0) AS rating, v.rating_count as rating_count,c.published,
CASE WHEN badcats.id is null THEN c.published ELSE 0 END AS parents_published
FROM adqlu_content AS a
LEFT JOIN adqlu_categories AS c
ON c.id = a.catid
LEFT JOIN adqlu_users AS ua
ON ua.id = a.created_by
LEFT JOIN adqlu_users AS uam
ON uam.id = a.modified_by
LEFT JOIN adqlu_categories as parent
ON parent.id = c.parent_id
LEFT JOIN adqlu_content_rating AS v
ON a.id = v.content_id
LEFT
OUTER JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT a.name, a.rules
FROM adqlu_assets AS a
1 × SELECT a.id, a.name, a.rules
FROM adqlu_assets AS a
1 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,COUNT(i.`id`) AS numitems
FROM adqlu_categories as c
LEFT JOIN (SELECT cat.id as id
FROM adqlu_categories AS cat JOIN adqlu_categories AS parent
ON cat.lft BETWEEN parent.lft
AND parent.rgt
1 × SELECT `session_id`
FROM `adqlu_session`
1 × SELECT a.id, a.parent_id
FROM adqlu_assets AS a
1 × SELECT a.rules
FROM adqlu_assets AS a
1 × SELECT *
FROM adqlu_assets
1 × SELECT *
FROM adqlu_languages
1 × SELECT id, home, template, s.params
FROM adqlu_template_styles as s
LEFT JOIN adqlu_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
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 adqlu_menu AS m
LEFT JOIN adqlu_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT folder AS type, element AS name, params
FROM adqlu_extensions
1 × SELECT id, rules
FROM `adqlu_viewlevels
1 × SELECT b.id
FROM adqlu_usergroups AS a
LEFT JOIN adqlu_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT *
FROM adqlu_jmap_metainfo
