Abfragezeit: 0.45 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 1.146 MB Zeilen zurückgegeben: 0
SELECT `data`
FROM `kgeds_session`
WHERE `session_id` = '97d6e7c0d865082a165f9f06422e2a14'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_session | const | PRIMARY | PRIMARY | 766 | const | 1 | |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.05 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.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 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.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 15 | JDatabaseDriver->loadResult() | JROOT/libraries/joomla/session/storage/database.php:45 |
| 14 | JSessionStorageDatabase->read() | Der selbe Aufruf in der Zeile darunter. |
| 13 | session_start() | JROOT/libraries/joomla/session/handler/native.php:260 |
| 12 | JSessionHandlerNative->doSessionStart() | JROOT/libraries/joomla/session/handler/native.php:50 |
| 11 | JSessionHandlerNative->start() | JROOT/libraries/joomla/session/handler/joomla.php:88 |
| 10 | JSessionHandlerJoomla->start() | JROOT/libraries/src/Session/Session.php:660 |
| 9 | Joomla\CMS\Session\Session->_start() | JROOT/libraries/src/Session/Session.php:620 |
| 8 | Joomla\CMS\Session\Session->start() | JROOT/libraries/src/Session/Session.php:498 |
| 7 | Joomla\CMS\Session\Session->get() | JROOT/libraries/src/Session/Session.php:455 |
| 6 | Joomla\CMS\Session\Session->isNew() | JROOT/libraries/src/Application/CMSApplication.php:755 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.34 ms Nach letzter Abfrage: 0.57 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.161 MB Zeilen zurückgegeben: 0
SELECT `session_id`
FROM `kgeds_session`
WHERE `session_id` = '97d6e7c0d865082a165f9f06422e2a14'
LIMIT 1
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_session | const | PRIMARY | PRIMARY | 766 | const | 1 | 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.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.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.01 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.01 ms |
| executing | 0.01 ms |
| end | 0.00 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT/libraries/src/Session/MetadataManager.php:74 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.35 ms Nach letzter Abfrage: 0.11 ms Abfragespeichernutzung: 0.004 MB Speichernutzung vor Abfrage: 1.167 MB
INSERT INTO `kgeds_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`)
VALUES
('97d6e7c0d865082a165f9f06422e2a14', 1, '1524380246', 0, '', 0)
„EXPLAIN“ unmöglich für Abfrage: INSERT INTO `kgeds_session`
(`session_id`,`guest`,`time`,`userid`,`username`,`client_id`) VALUES
('97d6e7c0d865082a165f9f06422e2a14', 1, '1524380246', 0, '', 0)
| Status | Duration |
|---|
| starting | 0.04 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 |
| init | 0.01 ms |
| update | 0.09 ms |
| Waiting for query cache lock | 0.00 ms |
| update | 0.02 ms |
| end | 0.00 ms |
| query end | 0.06 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 8 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Session/MetadataManager.php:116 |
| 7 | Joomla\CMS\Session\MetadataManager->createRecordIfNonExisting() | JROOT/libraries/src/Application/CMSApplication.php:152 |
| 6 | Joomla\CMS\Application\CMSApplication->checkSession() | JROOT/libraries/src/Application/CMSApplication.php:757 |
| 5 | Joomla\CMS\Application\CMSApplication->loadSession() | JROOT/libraries/src/Application/CMSApplication.php:134 |
| 4 | Joomla\CMS\Application\CMSApplication->__construct() | JROOT/libraries/src/Application/SiteApplication.php:66 |
| 3 | Joomla\CMS\Application\SiteApplication->__construct() | JROOT/libraries/src/Application/CMSApplication.php:343 |
| 2 | Joomla\CMS\Application\CMSApplication::getInstance() | JROOT/libraries/src/Factory.php:140 |
| 1 | Joomla\CMS\Factory::getApplication() | JROOT/index.php:46 |
Abfragezeit: 0.61 ms Nach letzter Abfrage: 0.55 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 1.202 MB Zeilen zurückgegeben: 40
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kgeds_extensions`
WHERE `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_extensions | ref | extension | extension | 82 | const | 40 | Using index condition |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.03 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.02 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.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.23 ms |
| end | 0.01 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 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 |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 12 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 11 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Component/ComponentHelper.php:423 |
| 10 | Joomla\CMS\Component\ComponentHelper::Joomla\CMS\Component\{closure}() | Der selbe Aufruf in der Zeile darunter. |
| 9 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 8 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Component/ComponentHelper.php:431 |
| 7 | Joomla\CMS\Component\ComponentHelper::load() | JROOT/libraries/src/Component/ComponentHelper.php:497 |
| 6 | Joomla\CMS\Component\ComponentHelper::getComponents() | JROOT/libraries/src/Component/ComponentHelper.php:44 |
| 5 | Joomla\CMS\Component\ComponentHelper::getComponent() | JROOT/libraries/src/Component/ComponentHelper.php:103 |
| 4 | Joomla\CMS\Component\ComponentHelper::getParams() | JROOT/libraries/src/Application/SiteApplication.php:596 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.68 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.302 MB Zeilen zurückgegeben: 3
SELECT id, rules
FROM `kgeds_viewlevels`
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_viewlevels | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 3 | |
| 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.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1496 |
| 9 | JDatabaseDriver->loadAssocList() | JROOT/libraries/src/Access/Access.php:1063 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.10 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.313 MB Zeilen zurückgegeben: 1
SELECT b.id
FROM kgeds_usergroups AS a
LEFT JOIN kgeds_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 | index | idx_usergroup_nested_set_lookup | idx_usergroup_nested_set_lookup | 8 | NULL | 9 | 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.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1540 |
| 10 | JDatabaseDriver->loadColumn() | JROOT/libraries/src/Access/Access.php:980 |
| 9 | Joomla\CMS\Access\Access::getGroupsByUser() | JROOT/libraries/src/Access/Access.php:1095 |
| 8 | Joomla\CMS\Access\Access::getAuthorisedViewLevels() | JROOT/libraries/src/User/User.php:458 |
| 7 | Joomla\CMS\User\User->getAuthorisedViewLevels() | JROOT/libraries/src/Plugin/PluginHelper.php:310 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.99 ms Nach letzter Abfrage: 0.13 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 1.335 MB Zeilen zurückgegeben: 88
SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kgeds_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 | kgeds_extensions | ref | extension | extension | 82 | const | 125 | 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.05 ms |
| checking permissions | 0.00 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.03 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sorting result | 0.47 ms |
| Sending data | 0.14 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 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 |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 11 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 10 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Plugin/PluginHelper.php:343 |
| 9 | Joomla\CMS\Plugin\PluginHelper::Joomla\CMS\Plugin\{closure}() | Der selbe Aufruf in der Zeile darunter. |
| 8 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 7 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Plugin/PluginHelper.php:348 |
| 6 | Joomla\CMS\Plugin\PluginHelper::load() | JROOT/libraries/src/Plugin/PluginHelper.php:87 |
| 5 | Joomla\CMS\Plugin\PluginHelper::getPlugin() | JROOT/libraries/src/Plugin/PluginHelper.php:129 |
| 4 | Joomla\CMS\Plugin\PluginHelper::isEnabled() | JROOT/libraries/src/Application/SiteApplication.php:606 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.41 ms Nach letzter Abfrage: 6.61 ms Abfragespeichernutzung: 0.022 MB Speichernutzung vor Abfrage: 1.801 MB Zeilen zurückgegeben: 1
SELECT `enabled`
FROM `kgeds_extensions`
WHERE `element` = 'com_akeeba'
AND `type` = 'component'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_extensions | ref | element_clientid,element_folder_clientid,extension | element_clientid | 402 | const | 1 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.04 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.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 0.03 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 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 |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 9 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 8 | JDatabaseDriver->loadResult() | JROOT/plugins/system/backuponupdate/backuponupdate.php:74 |
| 7 | require_once JROOT/plugins/system/backuponupdate/backuponupdate.php | JROOT/libraries/src/Plugin/PluginHelper.php:253 |
| 6 | Joomla\CMS\Plugin\PluginHelper::import() | JROOT/libraries/src/Plugin/PluginHelper.php:182 |
| 5 | Joomla\CMS\Plugin\PluginHelper::importPlugin() | JROOT/libraries/src/Application/CMSApplication.php:622 |
| 4 | Joomla\CMS\Application\CMSApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:688 |
| 3 | Joomla\CMS\Application\SiteApplication->initialiseApp() | JROOT/libraries/src/Application/SiteApplication.php:212 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.54 ms Nach letzter Abfrage: 4.57 ms Abfragespeichernutzung: 0.158 MB Speichernutzung vor Abfrage: 1.879 MB Zeilen zurückgegeben: 110
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 kgeds_menu AS m
LEFT JOIN kgeds_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 | ALL | idx_client_id_parent_id_alias_language | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 230 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.m.component_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.06 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.03 ms |
| After opening tables | 0.00 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.25 ms |
| Sending data | 0.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.10 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.11 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.06 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Menu/SiteMenu.php:93 |
| 17 | Joomla\CMS\Menu\SiteMenu->Joomla\CMS\Menu\{closure}() | Der selbe Aufruf in der Zeile darunter. |
| 16 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 15 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Menu/SiteMenu.php:101 |
| 14 | Joomla\CMS\Menu\SiteMenu->load() | JROOT/libraries/src/Menu/AbstractMenu.php:76 |
| 13 | Joomla\CMS\Menu\AbstractMenu->__construct() | JROOT/libraries/src/Menu/SiteMenu.php:62 |
| 12 | Joomla\CMS\Menu\SiteMenu->__construct() | JROOT/libraries/src/Menu/AbstractMenu.php:131 |
| 11 | Joomla\CMS\Menu\AbstractMenu::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:374 |
| 10 | Joomla\CMS\Application\CMSApplication->getMenu() | JROOT/libraries/src/Application/SiteApplication.php:275 |
| 9 | Joomla\CMS\Application\SiteApplication->getMenu() | JROOT/libraries/src/Router/SiteRouter.php:64 |
| 8 | Joomla\CMS\Router\SiteRouter->__construct() | JROOT/libraries/src/Router/Router.php:189 |
| 7 | Joomla\CMS\Router\Router::getInstance() | JROOT/libraries/src/Application/CMSApplication.php:488 |
| 6 | Joomla\CMS\Application\CMSApplication::getRouter() | JROOT/libraries/src/Application/SiteApplication.php:405 |
| 5 | Joomla\CMS\Application\SiteApplication::getRouter() | JROOT/libraries/src/Application/CMSApplication.php:1070 |
| 4 | Joomla\CMS\Application\CMSApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:798 |
| 3 | Joomla\CMS\Application\SiteApplication->route() | JROOT/libraries/src/Application/SiteApplication.php:218 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.51 ms Nach letzter Abfrage: 6.01 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.616 MB Zeilen zurückgegeben: 1
SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kgeds_extensions`
WHERE `type` = 'library'
AND `element` = 'joomla'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_extensions | ref | element_clientid,element_folder_clientid,extension | extension | 484 | const,const | 1 | Using index condition |
| Status | Duration |
|---|
| starting | 0.02 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.01 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.12 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 15 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1652 |
| 14 | JDatabaseDriver->loadObject() | JROOT/libraries/src/Helper/LibraryHelper.php:167 |
| 13 | Joomla\CMS\Helper\LibraryHelper::Joomla\CMS\Helper\{closure}() | Der selbe Aufruf in der Zeile darunter. |
| 12 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 11 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/LibraryHelper.php:175 |
| 10 | Joomla\CMS\Helper\LibraryHelper::loadLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:43 |
| 9 | Joomla\CMS\Helper\LibraryHelper::getLibrary() | JROOT/libraries/src/Helper/LibraryHelper.php:90 |
| 8 | Joomla\CMS\Helper\LibraryHelper::getParams() | JROOT/libraries/src/Version.php:321 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.45 ms Nach letzter Abfrage: 0.17 ms Abfragespeichernutzung: 0.005 MB Speichernutzung vor Abfrage: 2.607 MB
UPDATE `kgeds_extensions`
SET `params` = '{\"mediaversion\":\"10648dbaddecb82bf4e25c2959d06439\"}'
WHERE `type` = 'library'
AND `element` = 'joomla'
„EXPLAIN“ unmöglich für Abfrage: UPDATE `kgeds_extensions`
SET `params` = '{\"mediaversion\":\"10648dbaddecb82bf4e25c2959d06439\"}'
WHERE `type` = 'library' AND `element` = 'joomla'
| Status | Duration |
|---|
| starting | 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 |
| init | 0.06 ms |
| updating | 0.06 ms |
| end | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| end | 0.09 ms |
| query end | 0.08 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| updating status | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 10 | JDatabaseDriverMysqli->execute() | JROOT/libraries/src/Helper/LibraryHelper.php:117 |
| 9 | Joomla\CMS\Helper\LibraryHelper::saveParams() | JROOT/libraries/src/Version.php:372 |
| 8 | Joomla\CMS\Version->setMediaVersion() | JROOT/libraries/src/Version.php:331 |
| 7 | Joomla\CMS\Version->getMediaVersion() | JROOT/libraries/src/Factory.php:778 |
| 6 | Joomla\CMS\Factory::createDocument() | JROOT/libraries/src/Factory.php:234 |
| 5 | Joomla\CMS\Factory::getDocument() | JROOT/libraries/src/Application/WebApplication.php:1113 |
| 4 | Joomla\CMS\Application\WebApplication->loadDocument() | JROOT/libraries/src/Application/SiteApplication.php:133 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.56 ms Abfragespeichernutzung: 0.025 MB Speichernutzung vor Abfrage: 2.644 MB Zeilen zurückgegeben: 1
SELECT *
FROM kgeds_languages
WHERE published=1
ORDER BY ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_languages | ALL | NULL | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 7 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 6 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Language/LanguageHelper.php:150 |
| 5 | Joomla\CMS\Language\LanguageHelper::getLanguages() | JROOT/libraries/src/Application/SiteApplication.php:330 |
| 4 | Joomla\CMS\Application\SiteApplication->getParams() | JROOT/libraries/src/Application/SiteApplication.php:138 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.48 ms Nach letzter Abfrage: 0.32 ms Abfragespeichernutzung: 0.021 MB Speichernutzung vor Abfrage: 2.663 MB Zeilen zurückgegeben: 4
SELECT id, home, template, s.params
FROM kgeds_template_styles as s
LEFT JOIN kgeds_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 | dbcth0rh.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.05 ms |
| checking permissions | 0.00 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.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.02 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sending data | 0.09 ms |
| end | 0.00 ms |
| query end | 0.00 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.01 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 |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 6 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 5 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Application/SiteApplication.php:488 |
| 4 | Joomla\CMS\Application\SiteApplication->getTemplate() | JROOT/libraries/src/Application/SiteApplication.php:168 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 2.73 ms Abfragespeichernutzung: 0.031 MB Speichernutzung vor Abfrage: 2.831 MB Zeilen zurückgegeben: 37
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeds_assets`
WHERE `name` IN ('root.1','com_aclmanager','com_admin','com_ajax','com_akeeba','com_associations','com_babioon_dataprovider','com_babioonemc','com_cache','com_categories','com_checkin','com_config','com_contact','com_content','com_contenthistory','com_cpanel','com_fields','com_finder','com_installer','com_jce','com_jcomments','com_joomlaupdate','com_languages','com_login','com_mailto','com_media','com_menus','com_messages','com_modules','com_plugins','com_postinstall','com_redirect','com_search','com_tags','com_templates','com_users','com_wrapper')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_assets | range | idx_asset_name | idx_asset_name | 202 | NULL | 37 | Using index condition |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:429 |
| 18 | Joomla\CMS\Access\Access::preloadComponents() | JROOT/libraries/src/Access/Access.php:213 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:531 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 21.92 ms Nach letzter Abfrage: 0.18 ms Abfragespeichernutzung: 3.715 MB Speichernutzung vor Abfrage: 2.881 MB Zeilen zurückgegeben: 17931
SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeds_assets`
WHERE `name` LIKE 'com_content.%' OR `name` = 'com_content' OR `parent_id` = 0
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_assets | ALL | idx_asset_name,idx_parent_id | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 18104 | Using where |
| Status | Duration |
|---|
| Sending data | 0.27 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.21 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.24 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.19 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.22 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.22 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.23 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.22 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.21 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.19 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.19 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.18 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.13 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.14 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 8.20 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| updating status | 0.02 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 20 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 19 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Access/Access.php:359 |
| 18 | Joomla\CMS\Access\Access::preloadPermissions() | JROOT/libraries/src/Access/Access.php:226 |
| 17 | Joomla\CMS\Access\Access::preload() | JROOT/libraries/src/Access/Access.php:540 |
| 16 | Joomla\CMS\Access\Access::getAssetRules() | JROOT/libraries/src/Access/Access.php:183 |
| 15 | Joomla\CMS\Access\Access::check() | JROOT/libraries/src/User/User.php:398 |
| 14 | Joomla\CMS\User\User->authorise() | JROOT/components/com_content/models/category.php:139 |
| 13 | ContentModelCategory->populateState() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:435 |
| 12 | Joomla\CMS\MVC\Model\BaseDatabaseModel->getState() | JROOT/libraries/src/MVC/View/CategoryView.php:116 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 10.43 ms Nach letzter Abfrage: 39.25 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 18.663 MB Zeilen zurückgegeben: 4
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.published = 1
AND s.id = 71
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 | filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | dbcth0rh.c.id | 107 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.21 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.08 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.10 ms |
| optimizing | 0.05 ms |
| statistics | 0.17 ms |
| preparing | 0.01 ms |
| Unlocking tables | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.05 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.24 ms |
| Sending data | 0.12 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 0.18 ms |
| executing | 0.01 ms |
| Sending data | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 8.05 ms |
| end | 0.02 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| removing tmp table | 0.35 ms |
| freeing items | 0.02 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 15 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 14 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/category.php:355 |
| 13 | ContentModelCategory->getCategory() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:122 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 8.02 ms Nach letzter Abfrage: 2.28 ms Abfragespeichernutzung: 0.057 MB Speichernutzung vor Abfrage: 18.776 MB Zeilen zurückgegeben: 8
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM kgeds_content AS a
LEFT JOIN kgeds_categories AS c
ON c.id = a.catid
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_by
LEFT JOIN kgeds_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kgeds_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeds_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 71
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:57:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:57:26')
ORDER BY c.lft, a.ordering, a.created
LIMIT 19
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | filesort wurde genutzt |
| 1 | SIMPLE | a | index_merge | idx_access,idx_state,idx_catid | idx_state,idx_catid,idx_access | 1,4,4 | NULL | 13 | Using intersect(idx_state,idx_catid,idx_access); Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | const | 1 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.19 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.09 ms |
| optimizing | 0.04 ms |
| statistics | 0.15 ms |
| preparing | 0.00 ms |
| Unlocking tables | 0.05 ms |
| executing | 0.00 ms |
| Sorting result | 6.70 ms |
| Sending data | 0.17 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.15 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.02 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.01 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.02 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 17 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:559 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.95 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 18.923 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20564
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 18.946 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20562
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.23 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 18.970 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20544
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.12 ms Nach letzter Abfrage: 0.22 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 18.993 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20525
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.00 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.13 ms Nach letzter Abfrage: 0.24 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 19.016 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20515
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_id | 1 | 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.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.21 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 19.040 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20493
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.10 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 19.063 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20455
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.11 ms Nach letzter Abfrage: 0.20 ms Abfragespeichernutzung: 0.036 MB Speichernutzung vor Abfrage: 19.086 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.article'
AND `m`.`content_item_id` = 20476
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_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.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.01 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 15 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/components/com_content/models/articles.php:689 |
| 14 | ContentModelArticles->getItems() | JROOT/components/com_content/models/category.php:253 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 8.07 ms Nach letzter Abfrage: 0.63 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.101 MB Zeilen zurückgegeben: 1
SELECT COUNT(*)
FROM kgeds_content AS a
LEFT JOIN kgeds_categories AS c
ON c.id = a.catid
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_by
LEFT JOIN kgeds_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kgeds_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeds_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid = 71
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:57:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:57:26')
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | c | const | PRIMARY,idx_access | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | a | index_merge | idx_access,idx_state,idx_catid | idx_state,idx_catid,idx_access | 1,4,4 | NULL | 13 | Using intersect(idx_state,idx_catid,idx_access); 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.08 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.06 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.04 ms |
| optimizing | 0.04 ms |
| statistics | 0.12 ms |
| preparing | 0.00 ms |
| Unlocking tables | 0.03 ms |
| executing | 0.01 ms |
| Sending data | 7.34 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.01 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.06 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 18 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1730 |
| 17 | JDatabaseDriver->loadResult() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:335 |
| 16 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getListCount() | JROOT/libraries/src/MVC/Model/ListModel.php:282 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getTotal() | JROOT/libraries/src/MVC/Model/ListModel.php:232 |
| 14 | Joomla\CMS\MVC\Model\ListModel->getPagination() | JROOT/components/com_content/models/category.php:265 |
| 13 | ContentModelCategory->getItems() | JROOT/libraries/src/MVC/View/HtmlView.php:423 |
| 12 | Joomla\CMS\MVC\View\HtmlView->get() | JROOT/libraries/src/MVC/View/CategoryView.php:144 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.20 ms Nach letzter Abfrage: 0.42 ms Abfragespeichernutzung: 0.034 MB Speichernutzung vor Abfrage: 19.109 MB Zeilen zurückgegeben: 0
SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
WHERE `m`.`type_alias` = 'com_content.category'
AND `m`.`content_item_id` = 71
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 | m | ALL | idx_tag_type | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 1 | Using where |
| 1 | SIMPLE | t | eq_ref | PRIMARY,tag_idx,idx_access | PRIMARY | 4 | dbcth0rh.m.tag_id | 1 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 14 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 13 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Helper/TagsHelper.php:454 |
| 12 | Joomla\CMS\Helper\TagsHelper->getItemTags() | JROOT/libraries/src/MVC/View/CategoryView.php:229 |
| 11 | Joomla\CMS\MVC\View\CategoryView->commonCategoryDisplay() | JROOT/components/com_content/views/category/view.html.php:72 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.37 ms Nach letzter Abfrage: 5.10 ms Abfragespeichernutzung: 0.039 MB Speichernutzung vor Abfrage: 19.185 MB Zeilen zurückgegeben: 4
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 `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 71
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | filesort wurde genutzt |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.02 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.07 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 21 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 20 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 19 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 18 | Joomla\CMS\Categories\Categories->get() | JROOT/administrator/components/com_fields/models/fields.php:197 |
| 17 | FieldsModelFields->getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:133 |
| 16 | Joomla\CMS\MVC\Model\ListModel->_getListQuery() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.14 ms Nach letzter Abfrage: 0.26 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 19.212 MB Zeilen zurückgegeben: 7
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM kgeds_fields AS a
LEFT JOIN `kgeds_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeds_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeds_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeds_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeds_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'com_content.article'
AND (fc.category_id IS NULL OR fc.category_id IN (71,0,378,386))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ALL | idx_state,idx_access,idx_context | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 9 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | dbcth0rh.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.id | 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.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 16 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 15 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 0.75 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.347 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20564'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.04 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.35 ms Nach letzter Abfrage: 11.41 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.482 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20562'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.06 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 2.10 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.514 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20544'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.06 ms |
| updating status | 0.01 ms |
| cleaning up | 0.02 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 2.52 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 19.551 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20525'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.09 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.29 ms Nach letzter Abfrage: 1.28 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.580 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20515'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.06 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.15 ms Nach letzter Abfrage: 1.30 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.608 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20493'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.01 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.03 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.31 ms Nach letzter Abfrage: 3.20 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.640 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20455'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.02 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.05 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.61 ms Nach letzter Abfrage: 20.46 ms Abfragespeichernutzung: 0.026 MB Speichernutzung vor Abfrage: 19.671 MB Zeilen zurückgegeben: 7
SELECT `field_id`,`value`
FROM `kgeds_fields_values`
WHERE `field_id` IN (1,4,3,5,2,6,9)
AND `item_id` = '20476'
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_fields_values | ref | idx_field_id,idx_item_id | idx_item_id | 766 | const | 7 | Using where |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.03 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| sending cached result to clien | 0.08 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 17 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 16 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_fields/models/field.php:702 |
| 15 | FieldsModelField->getFieldValues() | JROOT/administrator/components/com_fields/helpers/fields.php:158 |
| 14 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 13 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 12 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 11 | JEventDispatcher->trigger() | JROOT/components/com_content/views/category/view.html.php:108 |
| 10 | ContentViewCategory->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:672 |
| 9 | Joomla\CMS\MVC\Controller\BaseController->display() | JROOT/components/com_content/controller.php:113 |
| 8 | ContentController->display() | JROOT/libraries/src/MVC/Controller/BaseController.php:710 |
| 7 | Joomla\CMS\MVC\Controller\BaseController->execute() | JROOT/components/com_content/content.php:43 |
| 6 | require_once JROOT/components/com_content/content.php | JROOT/libraries/src/Component/ComponentHelper.php:382 |
| 5 | Joomla\CMS\Component\ComponentHelper::executeComponent() | JROOT/libraries/src/Component/ComponentHelper.php:357 |
| 4 | Joomla\CMS\Component\ComponentHelper::renderComponent() | JROOT/libraries/src/Application/SiteApplication.php:194 |
| 3 | Joomla\CMS\Application\SiteApplication->dispatch() | JROOT/libraries/src/Application/SiteApplication.php:233 |
| 2 | Joomla\CMS\Application\SiteApplication->doExecute() | JROOT/libraries/src/Application/CMSApplication.php:195 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 3.92 ms Nach letzter Abfrage: 28.39 ms Abfragespeichernutzung: 0.114 MB Speichernutzung vor Abfrage: 19.939 MB Zeilen zurückgegeben: 52
SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kgeds_modules AS m
LEFT JOIN kgeds_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kgeds_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 <= '2018-04-22 06:57:26')
AND (m.publish_down = '0000-00-00 00:00:00' OR m.publish_down >= '2018-04-22 06:57:26')
AND m.access IN (1,1)
AND m.client_id = 0
AND (mm.menuid = 53 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 | 85 | Using index condition; Using where; filesort wurde genutzt |
| 1 | SIMPLE | e | ref | element_clientid,element_folder_clientid | element_clientid | 403 | dbcth0rh.m.module,const | 1 | Using index condition; Using where |
| 1 | SIMPLE | mm | ref | PRIMARY | PRIMARY | 4 | dbcth0rh.m.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.19 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.02 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.08 ms |
| init | 0.09 ms |
| optimizing | 0.08 ms |
| statistics | 0.14 ms |
| preparing | 0.09 ms |
| executing | 0.01 ms |
| Sorting result | 0.79 ms |
| Sending data | 0.39 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.44 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.09 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.29 ms |
| Waiting for query cache lock | 0.00 ms |
| Sending data | 0.65 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.01 ms |
| Unlocking tables | 0.02 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 |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | Der selbe Aufruf in der Zeile darunter. |
| 14 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 13 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:433 |
| 12 | Joomla\CMS\Helper\ModuleHelper::getModuleList() | JROOT/libraries/src/Helper/ModuleHelper.php:363 |
| 11 | Joomla\CMS\Helper\ModuleHelper::load() | JROOT/libraries/src/Helper/ModuleHelper.php:87 |
| 10 | Joomla\CMS\Helper\ModuleHelper::getModules() | JROOT/libraries/src/Document/HtmlDocument.php:581 |
| 9 | Joomla\CMS\Document\HtmlDocument->countModules() | JROOT/templates/prj3/partials/top-banner.php:2 |
| 8 | include JROOT/templates/prj3/partials/top-banner.php | JROOT/templates/prj3/index.php:163 |
| 7 | require JROOT/templates/prj3/index.php | JROOT/libraries/src/Document/HtmlDocument.php:658 |
| 6 | Joomla\CMS\Document\HtmlDocument->_loadTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:720 |
| 5 | Joomla\CMS\Document\HtmlDocument->_fetchTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:535 |
| 4 | Joomla\CMS\Document\HtmlDocument->parse() | JROOT/libraries/src/Application/CMSApplication.php:1027 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.50 ms Nach letzter Abfrage: 8.79 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 20.165 MB Zeilen zurückgegeben: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM kgeds_fields AS a
LEFT JOIN `kgeds_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeds_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeds_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeds_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeds_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_custom.content'
AND (fc.category_id IS NULL OR fc.category_id IN (71,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_context | 766 | const | 1 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | dbcth0rh.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.id | 1 | Using where; Using index |
| Status | Duration |
|---|
| starting | 0.05 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.01 ms |
| checking query cache for query | 0.02 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.01 ms |
| sending cached result to clien | 0.08 ms |
| updating status | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 23 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 22 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 21 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 20 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 19 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 18 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 17 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 16 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 15 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 14 | JHtmlContent::prepare() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 12 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:146 |
| 11 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_custom/mod_custom.php:15 |
| 10 | include JROOT/modules/mod_custom/mod_custom.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 51.81 ms Nach letzter Abfrage: 5.37 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 20.386 MB Zeilen zurückgegeben: 15
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 374
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 | filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | dbcth0rh.c.id | 107 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.04 ms |
| Waiting for query cache lock | 0.01 ms |
| init | 0.00 ms |
| checking query cache for query | 0.22 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.01 ms |
| Opening tables | 0.07 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.12 ms |
| init | 0.12 ms |
| optimizing | 0.06 ms |
| statistics | 0.19 ms |
| preparing | 0.01 ms |
| Unlocking tables | 0.04 ms |
| optimizing | 0.02 ms |
| statistics | 0.06 ms |
| preparing | 0.04 ms |
| executing | 0.01 ms |
| Sorting result | 0.27 ms |
| Sending data | 0.13 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 0.20 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| executing | 0.01 ms |
| Sending data | 14.51 ms |
| executing | 0.02 ms |
| Sending data | 5.82 ms |
| executing | 0.02 ms |
| Sending data | 3.02 ms |
| executing | 0.01 ms |
| Sending data | 0.53 ms |
| executing | 0.00 ms |
| Sending data | 0.96 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.00 ms |
| Sending data | 10.18 ms |
| executing | 0.03 ms |
| Sending data | 7.55 ms |
| executing | 0.02 ms |
| Sending data | 5.05 ms |
| executing | 0.03 ms |
| Sending data | 1.34 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.19 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.03 ms |
| freeing items | 0.01 ms |
| removing tmp table | 0.22 ms |
| freeing items | 0.03 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.08 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/categories.php:115 |
| 15 | ContentModelCategories->getItems() | JROOT/modules/mod_articles_category/helper.php:143 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 12.14 ms Nach letzter Abfrage: 0.69 ms Abfragespeichernutzung: 0.049 MB Speichernutzung vor Abfrage: 20.470 MB Zeilen zurückgegeben: 18
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 379
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 | filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | dbcth0rh.c.id | 107 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.18 ms |
| checking permissions | 0.02 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.01 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.06 ms |
| init | 0.08 ms |
| optimizing | 0.04 ms |
| statistics | 0.15 ms |
| preparing | 0.01 ms |
| Unlocking tables | 0.03 ms |
| optimizing | 0.01 ms |
| statistics | 0.04 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sorting result | 0.18 ms |
| Sending data | 0.08 ms |
| executing | 0.01 ms |
| Sending data | 0.05 ms |
| executing | 0.00 ms |
| Sending data | 0.10 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 1.04 ms |
| executing | 0.01 ms |
| Sending data | 2.47 ms |
| executing | 0.01 ms |
| Sending data | 2.08 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 1.91 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| executing | 0.00 ms |
| Sending data | 1.13 ms |
| executing | 0.01 ms |
| Sending data | 0.06 ms |
| executing | 0.00 ms |
| Sending data | 0.14 ms |
| executing | 0.01 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.05 ms |
| executing | 0.00 ms |
| Sending data | 0.11 ms |
| executing | 0.00 ms |
| Sending data | 0.10 ms |
| executing | 0.00 ms |
| Sending data | 1.00 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| removing tmp table | 0.07 ms |
| freeing items | 0.03 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/categories.php:115 |
| 15 | ContentModelCategories->getItems() | JROOT/modules/mod_articles_category/helper.php:143 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 23.67 ms Nach letzter Abfrage: 0.64 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 20.559 MB Zeilen zurückgegeben: 16
SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time,
c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level,
c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id,
c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,(
SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 378
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 | filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | dbcth0rh.c.id | 107 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.01 ms |
| checking query cache for query | 0.16 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.07 ms |
| optimizing | 0.04 ms |
| statistics | 0.13 ms |
| preparing | 0.00 ms |
| Unlocking tables | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sorting result | 0.15 ms |
| Sending data | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| executing | 0.00 ms |
| Sending data | 0.02 ms |
| executing | 0.00 ms |
| Sending data | 2.54 ms |
| executing | 0.01 ms |
| Sending data | 3.03 ms |
| executing | 0.01 ms |
| Sending data | 0.49 ms |
| executing | 0.01 ms |
| Sending data | 0.40 ms |
| executing | 0.00 ms |
| Sending data | 5.26 ms |
| executing | 0.02 ms |
| Sending data | 1.56 ms |
| executing | 0.01 ms |
| Sending data | 2.74 ms |
| executing | 0.01 ms |
| Sending data | 0.14 ms |
| executing | 0.00 ms |
| Sending data | 5.10 ms |
| executing | 0.02 ms |
| Sending data | 0.09 ms |
| executing | 0.00 ms |
| Sending data | 0.66 ms |
| executing | 0.01 ms |
| Sending data | 0.07 ms |
| executing | 0.00 ms |
| Sending data | 0.04 ms |
| end | 0.01 ms |
| query end | 0.02 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.01 ms |
| removing tmp table | 0.07 ms |
| freeing items | 0.03 ms |
| updating status | 0.01 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.07 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/categories.php:115 |
| 15 | ContentModelCategories->getItems() | JROOT/modules/mod_articles_category/helper.php:143 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 1.47 ms Nach letzter Abfrage: 0.62 ms Abfragespeichernutzung: 0.038 MB Speichernutzung vor Abfrage: 20.637 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,(
SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
WHERE i.`catid` = c.id
AND i.state = 1) AS numitems
FROM `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 375
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 | filesort wurde genutzt |
| 1 | PRIMARY | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| 2 | DEPENDENT SUBQUERY | i | ref | idx_state,idx_catid | idx_catid | 4 | dbcth0rh.c.id | 107 | 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.16 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.04 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.03 ms |
| init | 0.06 ms |
| optimizing | 0.03 ms |
| statistics | 0.12 ms |
| preparing | 0.00 ms |
| Unlocking tables | 0.02 ms |
| optimizing | 0.01 ms |
| statistics | 0.03 ms |
| preparing | 0.02 ms |
| executing | 0.00 ms |
| Sorting result | 0.14 ms |
| Sending data | 0.07 ms |
| executing | 0.01 ms |
| Sending data | 0.04 ms |
| executing | 0.00 ms |
| Sending data | 0.08 ms |
| executing | 0.00 ms |
| Sending data | 0.17 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 ms |
| freeing items | 0.00 ms |
| removing tmp table | 0.05 ms |
| freeing items | 0.02 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.04 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.01 ms |
| storing result in query cache | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 17 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 16 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/models/categories.php:115 |
| 15 | ContentModelCategories->getItems() | JROOT/modules/mod_articles_category/helper.php:143 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 9.18 ms Nach letzter Abfrage: 0.45 ms Abfragespeichernutzung: 0.045 MB Speichernutzung vor Abfrage: 20.651 MB Zeilen zurückgegeben: 5
SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating,
COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM kgeds_content AS a
LEFT JOIN kgeds_categories AS c
ON c.id = a.catid
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_by
LEFT JOIN kgeds_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kgeds_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeds_content_rating AS v
ON a.id = v.content_id
WHERE a.access IN (1,1)
AND c.access IN (1,1)
AND c.published = 1
AND a.state = 1
AND a.catid IN (374,379,378,375,67,68,389,394,395,396,69,70,258,387,267,421,256,78,76,420,414,74,412,259,388,260,390,383,266,257,205,380,255,397,265,72,398,77,413,71,418,251,391,268,411)
AND (a.publish_up = '0000-00-00 00:00:00' OR a.publish_up <= '2018-04-22 06:57:26')
AND (a.publish_down = '0000-00-00 00:00:00' OR a.publish_down >= '2018-04-22 06:57:26')
ORDER BY publish_up DESC
LIMIT 5
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | index_merge | idx_access,idx_state,idx_catid | idx_state,idx_access | 1,4 | NULL | 186 | Using intersect(idx_state,idx_access); Using where; filesort wurde genutzt |
| 1 | SIMPLE | c | eq_ref | PRIMARY,idx_access | PRIMARY | 4 | dbcth0rh.a.catid | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.created_by | 1 | Using where |
| 1 | SIMPLE | uam | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.modified_by | 1 | Using where |
| 1 | SIMPLE | parent | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.c.parent_id | 1 | Using where |
| 1 | SIMPLE | v | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.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.18 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| Opening tables | 0.05 ms |
| After opening tables | 0.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.05 ms |
| init | 0.09 ms |
| optimizing | 0.04 ms |
| statistics | 0.34 ms |
| preparing | 0.26 ms |
| executing | 0.00 ms |
| Sorting result | 7.56 ms |
| Sending data | 0.20 ms |
| Waiting for query cache lock | 0.01 ms |
| Sending data | 0.12 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.02 ms |
| freeing items | 0.02 ms |
| updating status | 0.00 ms |
| Waiting for query cache lock | 0.00 ms |
| updating status | 0.03 ms |
| Waiting for query cache lock | 0.01 ms |
| updating status | 0.00 ms |
| storing result in query cache | 0.01 ms |
| cleaning up | 0.01 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 19 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 18 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 17 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 16 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/components/com_content/models/articles.php:559 |
| 15 | ContentModelArticles->getItems() | JROOT/modules/mod_articles_category/helper.php:225 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.94 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 20.810 MB Zeilen zurückgegeben: 4
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 `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 72
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | filesort wurde genutzt |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | 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 |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 25 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 24 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 23 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
| 22 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:670 |
| 18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_category/helper.php:261 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.16 ms Nach letzter Abfrage: 0.89 ms Abfragespeichernutzung: 0.040 MB Speichernutzung vor Abfrage: 20.826 MB Zeilen zurückgegeben: 0
SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM kgeds_fields AS a
LEFT JOIN `kgeds_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeds_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeds_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeds_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeds_fields_categories` AS fc
ON fc.field_id = a.id
WHERE a.context = 'mod_articles_category.content'
AND (fc.category_id IS NULL OR fc.category_id IN (71,0))
AND a.access IN (1,1)
AND (a.group_id = 0 OR g.access IN (1,1))
AND a.state = 1
AND (a.group_id = 0 OR g.state = 1)
ORDER BY a.ordering ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | a | ref | idx_state,idx_access,idx_context | idx_context | 766 | const | 1 | Using where; filesort wurde genutzt |
| 1 | SIMPLE | l | eq_ref | idx_langcode | idx_langcode | 28 | dbcth0rh.a.language | 1 | Using where |
| 1 | SIMPLE | uc | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.checked_out | 1 | |
| 1 | SIMPLE | ag | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.access | 1 | Using where |
| 1 | SIMPLE | ua | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.created_user_id | 1 | Using where |
| 1 | SIMPLE | g | eq_ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.group_id | 1 | Using where |
| 1 | SIMPLE | fc | ref | PRIMARY | PRIMARY | 4 | dbcth0rh.a.id | 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.01 ms |
| checking privileges on cached | 0.00 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/MVC/Model/BaseDatabaseModel.php:308 |
| 25 | Joomla\CMS\MVC\Model\BaseDatabaseModel->_getList() | JROOT/administrator/components/com_fields/models/fields.php:327 |
| 24 | FieldsModelFields->_getList() | JROOT/libraries/src/MVC/Model/ListModel.php:187 |
| 23 | Joomla\CMS\MVC\Model\ListModel->getItems() | JROOT/administrator/components/com_fields/helpers/fields.php:136 |
| 22 | FieldsHelper::getFields() | JROOT/plugins/system/fields/fields.php:479 |
| 21 | PlgSystemFields->onContentPrepare() | JROOT/libraries/joomla/event/event.php:70 |
| 20 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 19 | JEventDispatcher->trigger() | JROOT/libraries/cms/html/content.php:41 |
| 18 | JHtmlContent::prepare() | Der selbe Aufruf in der Zeile darunter. |
| 17 | call_user_func_array() | JROOT/libraries/src/HTML/HTMLHelper.php:239 |
| 16 | Joomla\CMS\HTML\HTMLHelper::call() | JROOT/libraries/src/HTML/HTMLHelper.php:111 |
| 15 | Joomla\CMS\HTML\HTMLHelper::_() | JROOT/modules/mod_articles_category/helper.php:305 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.19 ms Nach letzter Abfrage: 1.26 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 20.845 MB Zeilen zurückgegeben: 4
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 `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 78
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | filesort wurde genutzt |
| 1 | SIMPLE | c | ALL | cat_idx,idx_access,idx_left_right | ES KONNTE KEIN INDEX-SCHLÃœSSEL GENUTZT WERDEN | NULL | NULL | 94 | Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.00 ms |
| init | 0.00 ms |
| checking query cache for query | 0.01 ms |
| checking privileges on cached | 0.01 ms |
| checking permissions | 0.01 ms |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.03 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 25 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 24 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 23 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
| 22 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:670 |
| 18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_category/helper.php:261 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.18 ms Nach letzter Abfrage: 0.91 ms Abfragespeichernutzung: 0.041 MB Speichernutzung vor Abfrage: 20.870 MB Zeilen zurückgegeben: 4
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 `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
WHERE (c.extension='com_content' OR c.extension='system')
AND c.access IN (1,1)
AND c.published = 1
AND s.id = 68
ORDER BY c.lft
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | s | const | PRIMARY,idx_left_right | PRIMARY | 4 | const | 1 | |
| 1 | SIMPLE | c | range | cat_idx,idx_access,idx_left_right | idx_left_right | 4 | NULL | 6 | Using index condition; Using where |
| Status | Duration |
|---|
| starting | 0.02 ms |
| Waiting for query cache lock | 0.02 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 |
| checking permissions | 0.00 ms |
| sending cached result to clien | 0.02 ms |
| updating status | 0.00 ms |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 27 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 26 | JDatabaseDriver->loadObjectList() | JROOT/libraries/src/Categories/Categories.php:314 |
| 25 | Joomla\CMS\Categories\Categories->_load() | JROOT/libraries/src/Categories/Categories.php:186 |
| 24 | Joomla\CMS\Categories\Categories->get() | JROOT/components/com_content/router.php:72 |
| 23 | ContentRouter->getCategorySegment() | Der selbe Aufruf in der Zeile darunter. |
| 22 | call_user_func_array() | JROOT/libraries/src/Component/Router/RouterView.php:120 |
| 21 | Joomla\CMS\Component\Router\RouterView->getPath() | JROOT/libraries/src/Component/Router/Rules/MenuRules.php:111 |
| 20 | Joomla\CMS\Component\Router\Rules\MenuRules->preprocess() | JROOT/libraries/src/Component/Router/RouterView.php:222 |
| 19 | Joomla\CMS\Component\Router\RouterView->preprocess() | JROOT/libraries/src/Router/SiteRouter.php:670 |
| 18 | Joomla\CMS\Router\SiteRouter->processBuildRules() | JROOT/libraries/src/Router/Router.php:266 |
| 17 | Joomla\CMS\Router\Router->build() | JROOT/libraries/src/Router/SiteRouter.php:154 |
| 16 | Joomla\CMS\Router\SiteRouter->build() | JROOT/libraries/src/Router/Route.php:66 |
| 15 | Joomla\CMS\Router\Route::_() | JROOT/modules/mod_articles_category/helper.php:261 |
| 14 | ModArticlesCategoryHelper::getList() | Der selbe Aufruf in der Zeile darunter. |
| 13 | call_user_func_array() | JROOT/libraries/src/Cache/Controller/CallbackController.php:173 |
| 12 | Joomla\CMS\Cache\Controller\CallbackController->get() | JROOT/libraries/src/Helper/ModuleHelper.php:559 |
| 11 | Joomla\CMS\Helper\ModuleHelper::moduleCache() | JROOT/modules/mod_articles_category/mod_articles_category.php:61 |
| 10 | include JROOT/modules/mod_articles_category/mod_articles_category.php | JROOT/libraries/src/Helper/ModuleHelper.php:201 |
| 9 | Joomla\CMS\Helper\ModuleHelper::renderModule() | JROOT/libraries/src/Document/Renderer/Html/ModuleRenderer.php:98 |
| 8 | Joomla\CMS\Document\Renderer\Html\ModuleRenderer->render() | JROOT/libraries/src/Document/Renderer/Html/ModulesRenderer.php:47 |
| 7 | Joomla\CMS\Document\Renderer\Html\ModulesRenderer->render() | JROOT/libraries/src/Document/HtmlDocument.php:491 |
| 6 | Joomla\CMS\Document\HtmlDocument->getBuffer() | JROOT/libraries/src/Document/HtmlDocument.php:783 |
| 5 | Joomla\CMS\Document\HtmlDocument->_renderTemplate() | JROOT/libraries/src/Document/HtmlDocument.php:557 |
| 4 | Joomla\CMS\Document\HtmlDocument->render() | JROOT/libraries/src/Application/CMSApplication.php:1041 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
Abfragezeit: 0.87 ms Nach letzter Abfrage: 11.85 ms Abfragespeichernutzung: 0.027 MB Speichernutzung vor Abfrage: 21.233 MB Zeilen zurückgegeben: 36
SELECT name, element AS `option`
FROM kgeds_extensions
WHERE type = 'component'
AND enabled = 1
ORDER BY name ASC
| id | select_type | table | type | possible_keys | key | key_len | ref | rows | Extra |
|---|
| 1 | SIMPLE | kgeds_extensions | ref | extension | extension | 82 | const | 40 | Using index condition; Using where; filesort wurde genutzt |
| Status | Duration |
|---|
| starting | 0.03 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.01 ms |
| System lock | 0.00 ms |
| Table lock | 0.01 ms |
| Waiting for query cache lock | 0.04 ms |
| init | 0.03 ms |
| optimizing | 0.02 ms |
| statistics | 0.07 ms |
| preparing | 0.03 ms |
| executing | 0.00 ms |
| Sorting result | 0.26 ms |
| Sending data | 0.06 ms |
| end | 0.01 ms |
| query end | 0.01 ms |
| closing tables | 0.00 ms |
| Unlocking tables | 0.01 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 |
| cleaning up | 0.00 ms |
| # | Aufrufer | Datei und Zeilennummer |
|---|
| 16 | JDatabaseDriverMysqli->execute() | JROOT/libraries/joomla/database/driver.php:1691 |
| 15 | JDatabaseDriver->loadObjectList() | JROOT/administrator/components/com_menus/models/menutypes.php:90 |
| 14 | MenusModelMenutypes->getTypeOptions() | JROOT/plugins/system/betterpreview/src/Component/Link.php:35 |
| 13 | RegularLabs\Plugin\System\BetterPreview\Component\Link->__construct() | JROOT/plugins/system/betterpreview/src/Component.php:29 |
| 12 | RegularLabs\Plugin\System\BetterPreview\Component::getClass() | JROOT/plugins/system/betterpreview/src/Helper.php:135 |
| 11 | RegularLabs\Plugin\System\BetterPreview\Helper->getClass() | JROOT/plugins/system/betterpreview/src/Helper.php:109 |
| 10 | RegularLabs\Plugin\System\BetterPreview\Helper->onAfterRender() | Der selbe Aufruf in der Zeile darunter. |
| 9 | call_user_func_array() | JROOT/plugins/system/betterpreview/src/Plugin.php:97 |
| 8 | RegularLabs\Plugin\System\BetterPreview\Plugin->run() | JROOT/plugins/system/betterpreview/betterpreview.php:58 |
| 7 | PlgSystemBetterPreview->onAfterRender() | JROOT/libraries/joomla/event/event.php:70 |
| 6 | JEvent->update() | JROOT/libraries/joomla/event/dispatcher.php:160 |
| 5 | JEventDispatcher->trigger() | JROOT/libraries/src/Application/BaseApplication.php:108 |
| 4 | Joomla\CMS\Application\BaseApplication->triggerEvent() | JROOT/libraries/src/Application/CMSApplication.php:1047 |
| 3 | Joomla\CMS\Application\CMSApplication->render() | JROOT/libraries/src/Application/SiteApplication.php:780 |
| 2 | Joomla\CMS\Application\SiteApplication->render() | JROOT/libraries/src/Application/CMSApplication.php:201 |
| 1 | Joomla\CMS\Application\CMSApplication->execute() | JROOT/index.php:49 |
9 × SELECT `m`.`tag_id`,`t`.*
FROM `kgeds_contentitem_tag_map` AS m
INNER JOIN `kgeds_tags` AS t
ON `m`.`tag_id` = `t`.`id`
8 × SELECT `field_id`,`value`
FROM `kgeds_fields_values`
5 × SELECT c.id, c.asset_id, c.access, c.alias, c.checked_out, c.checked_out_time, c.created_time, c.created_user_id, c.description, c.extension, c.hits, c.language, c.level, c.lft, c.metadata, c.metadesc, c.metakey, c.modified_time, c.note, c.params, c.parent_id, c.path, c.published, c.rgt, c.title, c.modified_user_id, c.version,
CASE WHEN CHAR_LENGTH(c.alias) != 0 THEN CONCAT_WS(':', c.id, c.alias) ELSE c.id END as slug,( SELECT COUNT(i.`id`)
FROM `kgeds_content` AS `i`
4 × 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 `kgeds_categories` AS `s`
INNER JOIN `kgeds_categories` AS `c`
ON (s.lft <= c.lft
AND c.lft < s.rgt) OR (c.lft < s.lft
AND s.rgt < c.rgt)
3 × SELECT a.id, a.title, a.name, a.checked_out, a.checked_out_time, a.note, a.state, a.access, a.created_time, a.created_user_id, a.ordering, a.language, a.fieldparams, a.params, a.type, a.default_value, a.context, a.group_id, a.label, a.description, a.required,l.title AS language_title, l.image AS language_image,uc.name AS editor,ag.title AS access_level,ua.name AS author_name,g.title AS group_title, g.access as group_access, g.state AS group_state
FROM kgeds_fields AS a
LEFT JOIN `kgeds_languages` AS l
ON l.lang_code = a.language
LEFT JOIN kgeds_users AS uc
ON uc.id=a.checked_out
LEFT JOIN kgeds_viewlevels AS ag
ON ag.id = a.access
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_user_id
LEFT JOIN kgeds_fields_groups AS g
ON g.id = a.group_id
LEFT JOIN `kgeds_fields_categories` AS fc
ON fc.field_id = a.id
2 × SELECT `id`,`name`,`rules`,`parent_id`
FROM `kgeds_assets`
2 × SELECT `extension_id` AS `id`,`element` AS `option`,`params`,`enabled`
FROM `kgeds_extensions`
2 × SELECT a.id, a.title, a.alias, a.introtext, a.fulltext, a.checked_out, a.checked_out_time, a.catid, a.created, a.created_by, a.created_by_alias,
CASE WHEN c.published = 2
AND a.state > 0 THEN 2 WHEN c.published != 1 THEN 0 ELSE a.state END as state,
CASE WHEN a.modified = '0000-00-00 00:00:00' THEN a.created ELSE a.modified END as modified, a.modified_by, uam.name as modified_by_name,
CASE WHEN a.publish_up = '0000-00-00 00:00:00' THEN a.created ELSE a.publish_up END as publish_up,a.publish_down, a.images, a.urls, a.attribs, a.metadata, a.metakey, a.metadesc, a.access, a.hits, a.xreference, a.featured, a.language, LENGTH(a.fulltext) AS readmore, a.ordering,c.title AS category_title, c.path AS category_route, c.access AS category_access, c.alias AS category_alias,c.published, c.published AS parents_published, c.lft,
CASE WHEN a.created_by_alias > ' ' THEN a.created_by_alias ELSE ua.name END AS author,ua.email AS author_email,parent.title as parent_title, parent.id as parent_id, parent.path as parent_route, parent.alias as parent_alias,COALESCE(NULLIF(ROUND(v.rating_sum / v.rating_count, 0), 0), 0) AS rating, COALESCE(NULLIF(v.rating_count, 0), 0) as rating_count
FROM kgeds_content AS a
LEFT JOIN kgeds_categories AS c
ON c.id = a.catid
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_by
LEFT JOIN kgeds_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kgeds_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeds_content_rating AS v
ON a.id = v.content_id
1 × SELECT m.id, m.title, m.module, m.position, m.content, m.showtitle, m.params, mm.menuid
FROM kgeds_modules AS m
LEFT JOIN kgeds_modules_menu AS mm
ON mm.moduleid = m.id
LEFT JOIN kgeds_extensions AS e
ON e.element = m.module
AND e.client_id = m.client_id
1 × SELECT COUNT(*)
FROM kgeds_content AS a
LEFT JOIN kgeds_categories AS c
ON c.id = a.catid
LEFT JOIN kgeds_users AS ua
ON ua.id = a.created_by
LEFT JOIN kgeds_users AS uam
ON uam.id = a.modified_by
LEFT JOIN kgeds_categories as parent
ON parent.id = c.parent_id
LEFT JOIN kgeds_content_rating AS v
ON a.id = v.content_id
1 × SELECT `data`
FROM `kgeds_session`
1 × SELECT `session_id`
FROM `kgeds_session`
1 × SELECT id, home, template, s.params
FROM kgeds_template_styles as s
LEFT JOIN kgeds_extensions as e
ON e.element=s.template
AND e.type='template'
AND e.client_id=s.client_id
1 × SELECT *
FROM kgeds_languages
1 × SELECT m.id, m.menutype, m.title, m.alias, m.note, m.path AS route, m.link, m.type, m.level, m.language,`m`.`browserNav`, m.access, m.params, m.home, m.img, m.template_style_id, m.component_id, m.parent_id,e.element as component
FROM kgeds_menu AS m
LEFT JOIN kgeds_extensions AS e
ON m.component_id = e.extension_id
1 × SELECT `enabled`
FROM `kgeds_extensions`
1 × SELECT `folder` AS `type`,`element` AS `name`,`params` AS `params`,`extension_id` AS `id`
FROM kgeds_extensions
1 × SELECT b.id
FROM kgeds_usergroups AS a
LEFT JOIN kgeds_usergroups AS b
ON b.lft <= a.lft
AND b.rgt >= a.rgt
1 × SELECT id, rules
FROM `kgeds_viewlevels
1 × SELECT name, element AS `option`
FROM kgeds_extensions
Im Bemühen um attraktivere Online-Werbeauftritte verspricht die Medienproduktionsfirma Vital Plus Media aus Bonn Abhilfe. Sie bietet Online-Advertorials, bei denen redaktionell aufgemachte Inhalte mit Mehrwert im Vordergrund stehen sollen. Für ihr neues Format kündigt Vital Plus eine „Performance auf 200 Startseiten von Zeitungen und Magazinen“. Ein rotierender Teaser mit rund 350 Zeichen und Bild auf den Startseiten der Medien soll dann auf die Information mit bis zu 1.700 Zeichen führen.
Wussten Sie das? Das Silicon-Valley hat sein Image offensichtlich einer Deutschen zu verdanken. PR-Frau Margit Wennmachers prägte rund um die Jahrtausendwende das Bild des erfinderischen Nerds, der die Welt verbessern will. „Spiegel online“ erzählt ihre Geschichte und ruft in Erinnerung, wie Wennmachers mit ihrer 1997 gegründeten Agentur Outcast Communications in den Folgejahren zu einer der einflussreichsten Stimmen in der Tech-Branche wurde und was sie heute als PR-Managerin des Venture Capitalists Unternehmen Andreessen Horowitz treibt. Hier geht’s direkt zur „Spiegel“-Story.
