Abfragezeit: 0.07 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 0.751 MB Zeilen zurückgegeben: 1
SELECT `data`
FROM `adqlu_session`
WHERE `session_id` = '3okktssrv5t7tm16cknf0ak1bm'
| 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.00 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 | | 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.10 ms Nach letzter Abfrage: 1.64 ms Abfragespeichernutzung: 0.061 MB Speichernutzung vor Abfrage: 0.795 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.00 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/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.05 ms Nach letzter Abfrage: 1.31 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 0.869 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.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.00 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 | | 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.05 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.023 MB Speichernutzung vor Abfrage: 0.875 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.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 | | 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.07 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.043 MB Speichernutzung vor Abfrage: 0.883 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.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 | | 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.30 ms Nach letzter Abfrage: 9.10 ms Abfragespeichernutzung: 0.602 MB Speichernutzung vor Abfrage: 1.534 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.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.20 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.09 ms Nach letzter Abfrage: 8.18 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 4.985 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.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.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 | | 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.07 ms Nach letzter Abfrage: 7.30 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.249 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.00 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: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: 6.73 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.006 MB Speichernutzung vor Abfrage: 5.243 MB
UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"3b0d5d28c5fce6301d2d3712927107a6\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `adqlu_extensions`
SET `params` = '{\"mediaversion\":\"3b0d5d28c5fce6301d2d3712927107a6\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| Starting | 0.03 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.06 ms |
| Updating | 0.04 ms |
| End of update loop | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| End of update loop | 0.03 ms |
| Query end | 0.00 ms |
| Commit | 6.44 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.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.12 ms Nach letzter Abfrage: 0.78 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 5.290 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.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 | | 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.42 ms Nach letzter Abfrage: 2.89 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 5.501 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.00 ms |
| Opening tables | 0.15 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.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.03 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 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.04 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 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 | | 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.11 ms Nach letzter Abfrage: 0.46 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 5.532 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.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 | | 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.11 ms Nach letzter Abfrage: 0.06 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 5.539 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.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: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.15 ms Nach letzter Abfrage: 0.34 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 5.552 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.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 | | 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.14 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.129 MB Speichernutzung vor Abfrage: 5.795 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.00 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: 1.11 ms Nach letzter Abfrage: 0.93 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 6.170 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,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=26
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.10 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.06 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.07 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.30 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 |
| Removing tmp table | 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.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.34 ms Nach letzter Abfrage: 0.41 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 6.210 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.01 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.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.12 ms |
| End of update loop | 0.00 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.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.00 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.12 ms Nach letzter Abfrage: 0.07 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 6.227 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.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 | | 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: 2.47 ms Nach letzter Abfrage: 0.49 ms Abfragespeichernutzung: 0.052 MB Speichernutzung vor Abfrage: 6.474 MB Zeilen zurückgegeben: 3
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 = 26 OR a.catid IN (
SELECT sub.id
FROM adqlu_categories as sub
INNER JOIN adqlu_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 26))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:00')
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 200
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where; Using temporary; filesort wurde genutzt |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | Using index condition; Using where |
| 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 | staging_otterbein.c.parent_id | 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 | staging_otterbein.c.id | 10 | Using where |
| 3 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 3 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 16 | Using where; Using index |
| 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.13 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.06 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.05 ms |
| Executing | 0.00 ms |
| Sending data | 0.99 ms |
| Executing | 0.01 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.46 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.06 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 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.00 ms |
| Freeing items | 0.00 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 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.00 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: 1.63 ms Nach letzter Abfrage: 0.44 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 6.606 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 = 26 OR a.catid IN (
SELECT sub.id
FROM adqlu_categories as sub
INNER JOIN adqlu_categories as this
ON sub.lft > this.lft
AND sub.rgt < this.rgt
WHERE this.id = 26))
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:00')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | PRIMARY | c | ALL | PRIMARY,idx_access | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 38 | Using where |
| 1 | PRIMARY | a | ref | idx_access,idx_catid | idx_catid | 4 | staging_otterbein.c.id | 6 | Using index condition; Using where |
| 1 | PRIMARY | <derived2> | ref | key0 | key0 | 5 | staging_otterbein.c.id | 10 | Using where |
| 3 | MATERIALIZED | this | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 3 | MATERIALIZED | sub | range | PRIMARY,idx_left_right | idx_left_right | 4 | NULL | 16 | Using where; Using index |
| 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.07 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.04 ms |
| Optimizing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.04 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Preparing | 0.02 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 ms |
| Executing | 0.00 ms |
| Sending data | 0.75 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.20 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 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.00 ms |
| Freeing items | 0.00 ms |
| Removing tmp table | 0.00 ms |
| Freeing items | 0.01 ms |
| Removing tmp table | 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.00 ms |
| Reset for next command | 0.00 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.46 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 6.617 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` = 26
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.02 ms |
| Checking permissions | 0.00 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 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.00 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.00 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: 1.39 ms Nach letzter Abfrage: 3.35 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 6.811 MB Zeilen zurückgegeben: 5
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('Magnesiumhaltige Naturkalk-Düngung mit DOLOCAL\nIm Rahmen der jährlichen Erhaltungskalkung zum Ausgleich der Kalkverluste im Boden und zur Regulierung des pH-Wertes setzen zahlreiche landwirtschaftliche Betriebe auf unseren Naturkalkdünger DOLOCAL, den magnesiumhaltigen Düngekalk mit besonders leichter Umsetzbarkeit.\n \nUnser DOLOCAL Kalkdünger wird aus einem besonders weichen mittleren Muschelkalk gebrochen und anschließend fein vermahlen. Seine besonders weiche Gesteinstruktur verleiht DOLOCAL eine hohe Reaktivität und leichte Umsetzbarkeit im Boden. Zudem enthält dieser magnesiumhaltige Natur-Calciumdünger die wichtigen Nebenbestandteile Kieselsäure und Kalium, weshalb DOLOCAL besonders prädistiniert ist für die nachhaltige Bodenverbesserung im konventionellen und ökologischen Landbau. Im Hinblick auf die Reaktivität erfüllt DOLOCAL die hohen Anforderungen der DLG-Premiumstufe.\n \nVerwendete OTTERBEIN-Produkte:\n\n\n DOLOCAL Kalkdünger\n\n\n \nDie landwirtschaftlichte Praxis und zahlreiche wissenschaftliche Untersuchungen haben gezeigt, dass die Kalkdüngung die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel) ist. Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag. \n \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\n \nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Magnesiumhaltige Naturkalk-Düngung mit DOLOCAL\nIm Rahmen der jährlichen Erhaltungskalkung zum Ausgleich der Kalkverluste im Boden und zur Regulierung des pH-Wertes setzen zahlreiche landwirtschaftliche Betriebe auf unseren Naturkalkdünger DOLOCAL, den magnesiumhaltigen Düngekalk mit besonders leichter Umsetzbarkeit.\n \nUnser DOLOCAL Kalkdünger wird aus einem besonders weichen mittleren Muschelkalk gebrochen und anschließend fein vermahlen. Seine besonders weiche Gesteinstruktur verleiht DOLOCAL eine hohe Reaktivität und leichte Umsetzbarkeit im Boden. Zudem enthält dieser magnesiumhaltige Natur-Calciumdünger die wichtigen Nebenbestandteile Kieselsäure und Kalium, weshalb DOLOCAL besonders prädistiniert ist für die nachhaltige Bodenverbesserung im konventionellen und ökologischen Landbau. Im Hinblick auf die Reaktivität erfüllt DOLOCAL die hohen Anforderungen der DLG-Premiumstufe.\n \nVerwendete OTTERBEIN-Produkte:\n\n\n DOLOCAL Kalkdünger\n\n\n \nDie landwirtschaftlichte Praxis und zahlreiche wissenschaftliche Untersuchungen haben gezeigt, dass die Kalkdüngung die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel) ist. Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag. \n \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\n \nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\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.31 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.03 ms |
| Init | 0.08 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.02 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.53 ms |
| Creating sort index | 0.05 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.02 ms |
| Updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| Updating status | 0.03 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 | | 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.41 ms Nach letzter Abfrage: 0.37 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.831 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_seoglossary
WHERE id = '5';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_seoglossary | const | PRIMARY | PRIMARY | 4 | 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.03 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.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.05 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| End of update loop | 0.00 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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: 0.05 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.844 MB Zeilen zurückgegeben: 1
SELECT id
FROM adqlu_menu
WHERE published = 1
AND link = 'index.php?option=com_seoglossary&view=glossaries&catid=1'
LIMIT 0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 497 | 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:58 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.24 ms Nach letzter Abfrage: 0.36 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.876 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_seoglossary
WHERE id = '6';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_seoglossary | 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.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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.889 MB Zeilen zurückgegeben: 1
SELECT id
FROM adqlu_menu
WHERE published = 1
AND link = 'index.php?option=com_seoglossary&view=glossaries&catid=1'
LIMIT 0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 497 | 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:58 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.24 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.898 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_seoglossary
WHERE id = '7';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_seoglossary | 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.01 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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.911 MB Zeilen zurückgegeben: 1
SELECT id
FROM adqlu_menu
WHERE published = 1
AND link = 'index.php?option=com_seoglossary&view=glossaries&catid=1'
LIMIT 0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 497 | 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:58 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.23 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.919 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_seoglossary
WHERE id = '8';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_seoglossary | 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.01 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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 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.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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.933 MB Zeilen zurückgegeben: 1
SELECT id
FROM adqlu_menu
WHERE published = 1
AND link = 'index.php?option=com_seoglossary&view=glossaries&catid=1'
LIMIT 0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 497 | 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:58 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.25 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.032 MB Speichernutzung vor Abfrage: 6.941 MB Zeilen zurückgegeben: 1
SELECT *
FROM adqlu_seoglossary
WHERE id = '9';
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_seoglossary | 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.01 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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.01 ms |
| End of update loop | 0.00 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.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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1650 |
| 21 | JDatabaseDriver->loadObject() | JROOT/components/com_seoglossary/router.php:42 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.10 ms Nach letzter Abfrage: 0.04 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 6.954 MB Zeilen zurückgegeben: 1
SELECT id
FROM adqlu_menu
WHERE published = 1
AND link = 'index.php?option=com_seoglossary&view=glossaries&catid=1'
LIMIT 0,1;
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | adqlu_menu | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÜSSEL GENUTZT WERDEN | NULL | NULL | 497 | 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 | | 22 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1728 |
| 21 | JDatabaseDriver->loadResult() | JROOT/components/com_seoglossary/router.php:58 |
| 20 | SeoglossaryBuildRoute() | JROOT/libraries/cms/component/router/legacy.php:68 |
| 19 | JComponentRouterLegacy->build() | JROOT/libraries/cms/router/site.php:496 |
| 18 | JRouterSite->buildSefRoute() | JROOT/libraries/cms/router/site.php:465 |
| 17 | JRouterSite->_buildSefRoute() | JROOT/libraries/cms/router/router.php:281 |
| 16 | JRouter->build() | JROOT/libraries/cms/router/site.php:147 |
| 15 | JRouterSite->build() | JROOT/libraries/joomla/application/route.php:62 |
| 14 | JRoute::_() | JROOT/plugins/content/seoglossary/seoglossary.php:277 |
| 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.55 ms Nach letzter Abfrage: 6.86 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.055 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.00 ms |
| Closing tables | 0.00 ms |
| Opening tables | 0.16 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.01 ms |
| Executing | 0.00 ms |
| Filling schema table | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| Checking permissions | 0.08 ms |
| Closing tables | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.04 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.04 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 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 | | 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: 1.00 ms Nach letzter Abfrage: 1.78 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 7.160 MB Zeilen zurückgegeben: 5
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('Staubarme Naturkalk-Düngung mit MICROCAL®\nEine Vielzahl von landwirtschaftlichen Betrieben setzt im Laufe eines Jahres bei der Erhaltungs-, Gesundungs- und Aufkalkung sowie bei der Kopfkalkung von Getreide und Kartoffeln auf unseren MICROCAL® – Kohlensaurer Kalk 75 (angefeuchtet). \n \nAufgrund seiner hohen Reaktivität (> 90%) und feinen Kornstruktur zeichnet sich dieses Premiumprodukt durch eine schnelle Umsetzbarkeit aus und ermöglicht durch seinen Feuchtegehalt eine staubreduzierte Ausbringung. MICROCAL® ist mit dem DLG-Qualitätssiegel der Premiumstufe ausgezeichnet und ist in der Betriebsmittelliste des FiBL (Forschungsinstituts für biologischen Landbau) gelistet und für den ökologischen Landbau zugelassen.\n \nVerwendete OTTERBEIN-Produkte:\n\n\n MICROCAL® – Kohlensaurer Kalk 75 (angefeuchtet)\n\n\n \nDie landwirtschaftlichte Praxis und zahlreiche wissenschaftliche Untersuchungen haben gezeigt, dass die Kalkdüngung die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel) ist. Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag. \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\n \nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n \n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n \n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n \n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n \n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Staubarme Naturkalk-Düngung mit MICROCAL®\nEine Vielzahl von landwirtschaftlichen Betrieben setzt im Laufe eines Jahres bei der Erhaltungs-, Gesundungs- und Aufkalkung sowie bei der Kopfkalkung von Getreide und Kartoffeln auf unseren MICROCAL® – Kohlensaurer Kalk 75 (angefeuchtet). \n \nAufgrund seiner hohen Reaktivität (> 90%) und feinen Kornstruktur zeichnet sich dieses Premiumprodukt durch eine schnelle Umsetzbarkeit aus und ermöglicht durch seinen Feuchtegehalt eine staubreduzierte Ausbringung. MICROCAL® ist mit dem DLG-Qualitätssiegel der Premiumstufe ausgezeichnet und ist in der Betriebsmittelliste des FiBL (Forschungsinstituts für biologischen Landbau) gelistet und für den ökologischen Landbau zugelassen.\n \nVerwendete OTTERBEIN-Produkte:\n\n\n MICROCAL® – Kohlensaurer Kalk 75 (angefeuchtet)\n\n\n \nDie landwirtschaftlichte Praxis und zahlreiche wissenschaftliche Untersuchungen haben gezeigt, dass die Kalkdüngung die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel) ist. Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag. \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\n \nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n \n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n \n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n \n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n \n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\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.12 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.01 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.04 ms |
| Init | 0.05 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.45 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 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.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: 7.81 ms Nach letzter Abfrage: 5.43 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 7.201 MB Zeilen zurückgegeben: 25
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 04:48:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:48:00')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 613 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.09 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.04 ms |
| Optimizing | 0.04 ms |
| Statistics | 0.07 ms |
| Preparing | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.01 ms |
| Creating sort index | 4.58 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 2.30 ms |
| Waiting for query cache lock | 0.01 ms |
| Creating sort index | 0.38 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.00 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/cache/controller/callback.php:152 |
| 18 | JCacheControllerCallback->get() | JROOT/libraries/cms/module/helper.php:425 |
| 17 | JModuleHelper::getModuleList() | JROOT/libraries/cms/module/helper.php:361 |
| 16 | JModuleHelper::load() | JROOT/libraries/cms/module/helper.php:34 |
| 15 | JModuleHelper::getModule() | JROOT/plugins/content/loadmodule/loadmodule.php:168 |
| 14 | PlgContentLoadmodule->_loadmod() | JROOT/plugins/content/loadmodule/loadmodule.php:113 |
| 13 | PlgContentLoadmodule->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: 1.54 ms Nach letzter Abfrage: 0.28 ms Abfragespeichernutzung: 0.029 MB Speichernutzung vor Abfrage: 7.272 MB Zeilen zurückgegeben: 5
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('Ausbringung von 230 t Branntkalk gemahlen in 34 Stunden\nDie Kalkung von landwirtschaftlichen Flächen gilt seit jeher als die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel). Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag.\nIm Rahmen einer besonderen Aufkalkungsaktion wurden im Sommer 2016 ca. 230 Tonnen unseres Branntkalk 80 – gemahlen – innerhalb von 34 Stunden auf eine Ackerfläche im Raum Homberg-Ohm ausgebracht. Dank der logistisch einwandfreien Koordination konnte der Kunde den Branntkalk im gewünschten Zeitfenster auf die Ackerflächen bringen und pünktlich mit der Saat von Raps beginnen.\nOTTERBEIN Branntkalk 80 – gemahlen – ist mit dem DLG-Qualitätssiegel Premiumstufe ausgezeichnet. Mit dem DLG-Gütezeichen Premiumstufe werden nur Düngekalke aus natürlichen Lagerstätten (Kohlensaure Kalke, Branntkalke und Mischkalke) ausgezeichnet, die überdurchschnittliche Qualitäten nachgewiesen haben und ein höchstes Maß an Produktsicherheit gewährleisten.\n \nVerwendete OTTERBEIN-Produkte:\n\n\nBranntkalk 80 – gemahlen –\n\n\n \n\n \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR 'Ausbringung von 230 t Branntkalk gemahlen in 34 Stunden\nDie Kalkung von landwirtschaftlichen Flächen gilt seit jeher als die effektivste Maßnahme zur Regulierung des pH-Wertes und zur Verbesserung der Nährstoffverfügbarkeit im Boden (u. a. von Stickstoff, Phosphat und Schwefel). Auf diesem Weg liefert Kalk dem Boden die aktive Energie für Mehrertrag.\nIm Rahmen einer besonderen Aufkalkungsaktion wurden im Sommer 2016 ca. 230 Tonnen unseres Branntkalk 80 – gemahlen – innerhalb von 34 Stunden auf eine Ackerfläche im Raum Homberg-Ohm ausgebracht. Dank der logistisch einwandfreien Koordination konnte der Kunde den Branntkalk im gewünschten Zeitfenster auf die Ackerflächen bringen und pünktlich mit der Saat von Raps beginnen.\nOTTERBEIN Branntkalk 80 – gemahlen – ist mit dem DLG-Qualitätssiegel Premiumstufe ausgezeichnet. Mit dem DLG-Gütezeichen Premiumstufe werden nur Düngekalke aus natürlichen Lagerstätten (Kohlensaure Kalke, Branntkalke und Mischkalke) ausgezeichnet, die überdurchschnittliche Qualitäten nachgewiesen haben und ein höchstes Maß an Produktsicherheit gewährleisten.\n \nVerwendete OTTERBEIN-Produkte:\n\n\nBranntkalk 80 – gemahlen –\n\n\n \n\n \nJe nach Fruchtart empfiehlt die Düngekalk-Hauptgemeinschaft (DHG) im Lauf eines Düngejahres verschiedene Zeiträume für die Kalkung:\n\nDie Düngekalk-Hauptgemeinschaft (DHG) unterscheidet bei der Kalkdüngung folgende Kalkungsarten:1\n\n\nErhaltungskalkung\nErsetzen der jährlichen Kalkverluste. Erhalt der optimalen pH-Klasse und der optimalen Struktur des Bodens.\n\n\n\n\nGesundungskalkung\nAufkalkung in den empfohlenen pH-Bereich. Aufkalkung von versauerten Böden in den anzustrebenden pH-Bereich (pH-Klasse „C“), der vom Verband deutscher landwirtschaftlicher Untersuchungs- und Forschungsanstalten (VDLUFA) festgelegt ist.\n\n\n\n\nStoppelkalkung\nKalkung auf die Stoppel nach der Ernte im Sommer. Der Kalk wird direkt auf die Stoppel ausgebracht. Anschließend erfolgt in der Regel die Bodenbearbeitung, bei der der Kalk mit dem Boden vermischt wird.\n\n\n\n\nVorsaatkalkung\nKalkung vor der Saat. Einige Pflanzenarten (z. B. Zuckerrüben, Kartoffeln oder Mais, aber auch etliche Gemüsearten) keimen und wachsen besser, wenn der Boden eine gute, optimale Struktur aufweist und sich in der Phase des Auflaufens schneller erwärmt.\n\n\n\n\nKopfkalkung\nKalkung auf den \"Kopf\" der Pflanzen. Bei mehreren Pflanzenarten hat sich auch eine Kalkdüngung „auf den Kopf“ bewährt, wenn zuvor keine Vorsaatkalkung möglich war oder nach dem Auflaufen der Saat erkennbar wird, dass der pH-Wert des Bodens deutlich unter dem Zielbereich liegt.\n\n\n \nPraxistips für die Kalkung zur Bodenverbesserung\n{youtube}0eFE194K63A{/youtube}\n\n1Quelle: www.naturkalk.de\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.30 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.00 ms |
| Waiting for query cache lock | 0.03 ms |
| Init | 0.10 ms |
| Optimizing | 0.03 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.80 ms |
| Creating sort index | 0.03 ms |
| Removing tmp table | 0.04 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 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.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: 1.76 ms Nach letzter Abfrage: 9.51 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 7.345 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM 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=26
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.02 ms |
| Waiting for query cache lock | 0.00 ms |
| Init | 0.00 ms |
| Checking query cache for query | 0.18 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.13 ms |
| Optimizing | 0.05 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.06 ms |
| Statistics | 0.10 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.03 ms |
| Creating tmp table | 0.05 ms |
| Sorting result | 0.01 ms |
| Executing | 0.01 ms |
| Sending data | 0.04 ms |
| Executing | 0.01 ms |
| Sending data | 0.19 ms |
| Creating sort index | 0.02 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.45 ms |
| Creating sort index | 0.05 ms |
| Removing tmp table | 0.06 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 |
| 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 | | 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/portfoliosortable_item.php:37 |
| 16 | include JROOT/templates/kallyas/html/com_content/category/portfoliosortable_item.php | JROOT/libraries/legacy/view/legacy.php:677 |
| 15 | JViewLegacy->loadTemplate() | JROOT/templates/kallyas/html/com_content/category/portfoliosortable.php:138 |
| 14 | include JROOT/templates/kallyas/html/com_content/category/portfoliosortable.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.66 ms Nach letzter Abfrage: 12.80 ms Abfragespeichernutzung: 0.024 MB Speichernutzung vor Abfrage: 7.406 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 04:48:00')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2026-09-04 04:48:00')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 613 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.02 ms |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.01 ms |
| Checking query cache for query | 0.11 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.05 ms |
| Statistics | 0.10 ms |
| Preparing | 0.06 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.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.00 ms |
| Reset for next command | 0.00 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.06 ms Nach letzter Abfrage: 0.05 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 7.408 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.00 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: 0.95 ms Nach letzter Abfrage: 10.66 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 7.646 MB Zeilen zurückgegeben: 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
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 IN (35)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:00')
ORDER BY a.created DESC
LIMIT 3
| 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 | 1 | 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 | 0 | Using where |
| 2 | LATERAL DERIVED | cat | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 2 | LATERAL DERIVED | parent | ref | cat_idx,idx_left_right | cat_idx | 202 | const | 9 | Using index condition; 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.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.03 ms |
| Init | 0.10 ms |
| Optimizing | 0.04 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.02 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.05 ms |
| Executing | 0.00 ms |
| Sending data | 0.06 ms |
| End of update loop | 0.01 ms |
| Query end | 0.00 ms |
| Commit | 0.00 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.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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
| 14 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:183 |
| 13 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 12 | ContentModelArticles->getItems() | JROOT/modules/mod_hg_latestposts/helper.php:96 |
| 11 | modHGLatestPostsHelper::getList() | JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9 |
| 10 | include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.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: 1.27 ms Nach letzter Abfrage: 0.15 ms Abfragespeichernutzung: 0.037 MB Speichernutzung vor Abfrage: 7.690 MB Zeilen zurückgegeben: 3
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM 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=35
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.16 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.09 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.04 ms |
| Statistics | 0.08 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.03 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.03 ms |
| Executing | 0.00 ms |
| Sending data | 0.10 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.33 ms |
| Creating sort index | 0.04 ms |
| Removing tmp table | 0.04 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 |
| Removing tmp table | 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 | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 14 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 13 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 12 | ContentHelperRoute::getArticleRoute() | JROOT/modules/mod_hg_latestposts/helper.php:104 |
| 11 | modHGLatestPostsHelper::getList() | JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9 |
| 10 | include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.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.91 ms Nach letzter Abfrage: 0.84 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 7.680 MB Zeilen zurückgegeben: 3
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 IN (22)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2026-09-04 04:48:00')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2026-09-04 04:48:00')
ORDER BY a.created DESC
LIMIT 3
| 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 | 68 | 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.11 ms |
| Checking permissions | 0.01 ms |
| Opening tables | 0.02 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.00 ms |
| Waiting for query cache lock | 0.02 ms |
| Init | 0.05 ms |
| Optimizing | 0.03 ms |
| Optimizing | 0.01 ms |
| Statistics | 0.03 ms |
| Statistics | 0.05 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.01 ms |
| Sorting result | 0.01 ms |
| Preparing | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Preparing | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.02 ms |
| Creating sort index | 0.17 ms |
| Executing | 0.00 ms |
| Sending data | 0.09 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.01 ms |
| Creating sort index | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| Creating sort index | 0.02 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.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.00 ms |
| Reset for next command | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/model/legacy.php:310 |
| 14 | JModelLegacy->_getList() | JROOT/libraries/legacy/model/list.php:183 |
| 13 | JModelList->getItems() | JROOT/components/com_content/models/articles.php:565 |
| 12 | ContentModelArticles->getItems() | JROOT/modules/mod_hg_latestposts/helper.php:96 |
| 11 | modHGLatestPostsHelper::getList() | JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9 |
| 10 | include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.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.25 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 7.784 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=22
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 | | 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1689 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/libraries/legacy/categories/categories.php:309 |
| 14 | JCategories->_load() | JROOT/libraries/legacy/categories/categories.php:184 |
| 13 | JCategories->get() | JROOT/components/com_content/helpers/route.php:44 |
| 12 | ContentHelperRoute::getArticleRoute() | JROOT/modules/mod_hg_latestposts/helper.php:104 |
| 11 | modHGLatestPostsHelper::getList() | JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.php:9 |
| 10 | include JROOT/modules/mod_hg_latestposts/mod_hg_latestposts.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.60 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.710 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('\n \n\nPRAXIS-VIDEOS\nSehen Sie Videos mit hilf­reichen Tips für die Kalk­dün­gung in der Land­wirt­schaft.\n\n \n \n\nKALKRECHNER\nBerechnen Sie den Dünge­kalk­be­darf für Ihren Boden mit dem DHG-Rechner.\n\n \n \n\nDLG-INFOS\nLaden Sie hier das DLG-Merk­blatt 353 mit prak­tischen Hinweise zur Kalk­dün­gung herunter.\n\n \n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR '\n \n\nPRAXIS-VIDEOS\nSehen Sie Videos mit hilf­reichen Tips für die Kalk­dün­gung in der Land­wirt­schaft.\n\n \n \n\nKALKRECHNER\nBerechnen Sie den Dünge­kalk­be­darf für Ihren Boden mit dem DHG-Rechner.\n\n \n \n\nDLG-INFOS\nLaden Sie hier das DLG-Merk­blatt 353 mit prak­tischen Hinweise zur Kalk­dün­gung herunter.\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.05 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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.02 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.23 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 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.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.54 ms Nach letzter Abfrage: 1.50 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.734 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(' \n \n \n \nHÄNDLER\nHier finden Sie den passenden Händler für den Bezug unserer Produkte.\n\n \n \n\nDOLOCAL-FLYER\nLaden Sie den aktuellen Flyer zu unserem DOLOCAL Naturkalkdünger herunter.\n \n \n \n\nDOWNLOADS\nLaden Sie technische Infos zu unseren Produkten hier herunter.\n \n \n\n') LIKE CONCAT('%', LOWER(t.tterm), '%') OR ' \n \n \n \nHÄNDLER\nHier finden Sie den passenden Händler für den Bezug unserer Produkte.\n\n \n \n\nDOLOCAL-FLYER\nLaden Sie den aktuellen Flyer zu unserem DOLOCAL Naturkalkdünger herunter.\n \n \n \n\nDOWNLOADS\nLaden Sie technische Infos zu unseren Produkten hier herunter.\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.04 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 |
| Waiting for query cache lock | 0.01 ms |
| Init | 0.03 ms |
| Optimizing | 0.02 ms |
| Statistics | 0.01 ms |
| Preparing | 0.01 ms |
| Creating tmp table | 0.02 ms |
| Sorting result | 0.01 ms |
| Executing | 0.00 ms |
| Sending data | 0.19 ms |
| Creating sort index | 0.01 ms |
| Removing tmp table | 0.02 ms |
| Creating sort index | 0.01 ms |
| End of update loop | 0.00 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.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.13 ms Nach letzter Abfrage: 12.31 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.872 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: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.14 ms Nach letzter Abfrage: 12.90 ms Abfragespeichernutzung: 0.035 MB Speichernutzung vor Abfrage: 7.960 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.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.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 | | 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.31 ms Abfragespeichernutzung: 0.030 MB Speichernutzung vor Abfrage: 7.961 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.28 ms Nach letzter Abfrage: 1.18 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 7.987 MB Zeilen zurückgegeben: 0
SELECT *
FROM adqlu_jmap_metainfo
WHERE `linkurl` = 'https://staging.zkw-otterbein.de/sortiment/anwendungsgebiete/landwirtschaft'
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.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 |
| 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.02 ms |
| End of update loop | 0.00 ms |
| Query end | 0.00 ms |
| Commit | 0.00 ms |
| Closing tables | 0.00 ms |
| Unlocking tables | 0.00 ms |
| Closing tables | 0.00 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.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 |
7 × SELECT t.*
FROM adqlu_seoglossary t
LEFT JOIN adqlu_seoglossaries g
ON t.catid = g.id
5 × SELECT id
FROM adqlu_menu
5 × SELECT *
FROM adqlu_seoglossary
3 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug
FROM 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
3 × 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
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 *
FROM `adqlu_modules`
1 × SELECT id,placeholder
FROM `adqlu_gdpr_checkbox
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.name, a.rules
FROM adqlu_assets AS a
1 × SELECT element
FROM adqlu_extensions
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 a.id, a.name, a.rules
FROM adqlu_assets AS a
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
